Uploaded File
add photo
Prabil
prabilbabu09@gmail.com
409-549-2012
Charlotte, NC 28205
BI Developer
10 years experience W2
0
Recommendations
Average rating
131
Profile views
Summary

  • 5 years of experience in state-of-the-art, mission critical and scalable end-to-end (Full life cycle) Data Analysis and Business Intelligence solutions with expertise in Tableau BI Products (Tableau Desktop, Tableau Server and Tableau Reader).
  • Experience with Tableau server/desktop install validation for upgrade to Tableau 9.2.
  • Involved in effective content (twb and twbx) sharing and distribution with end users and interaction with the same on Tableau Reader/Desktop and using Tableau server publish and Tableau Online features.
  • Used multiple Tableau data sources(.tds) from excel, CSV, text files and RDBMS (SQL Server) as source systems for workbook generation using Import/Live connection and methodologies.
  • Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Extensive experience in Data Analysis, Migration, Cleansing, Transformation, manipulation, chart creation, visual representation, Import and Export through various ETL tools.
  • Extensive use of SSIS for ETL, SSAS and SSRS with Tableau integration.
  • Experienced in drill down approach, Filtering, Parameters, Actions and Dashboard development using Tableau Desktop.
  • Map R Enterprise edition (M5) (Hadoop/Hive) for extraction for data for visualization and creating KPI’s.
  • Working knowledge of Tableau Admin tasks like scheduling extracts, subscription and user security.
  • Created different visualizations using Bars, Lines, pie chart, Maps, bubble chart, scatter plots.
  • Working knowledge on Tableau Server on deploying and scheduling Dashboards.
  • Created Tableau Dashboards- combining data from multiple data sources and large databases.
  • Designed Dashboards with best practices for optimum performance
  • Responsible for developing, analyzing and reporting key risk indicator and key indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
  • Experienced in utilizing newer Oracle tools and methods like the use of External Tables, merge statement, Pipelined functions and 10G features.
  • Performance Tuning & Query Optimization of SQL statements.
  • Comfortable in working with Composite Data Types.
  • Experienced in Debugging, Testing, and Deploying the Applications.
  • Experienced in working with Tableau advanced data activity features like Parameters, Action Filters, and Row level security.
  • Experienced in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing.
  • Successfully utilized performance enhancements features of Oracle to optimize the batch processes.
  • Excellent logical and analytical skills, enthusiastic, excellent interpersonal & communication skills.
  • Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
  • Good understanding and background in financial services, healthcare, and telecom industry.
  • Experienced working with Agile/Sprint Project methodology.
  • An excellent team player with fast learning curve, strong analytical, problem solving, communication and interpersonal skills to work under time constraints and has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

Experience
BI Developer
Information Technology
Sep 2016 - present
  • Worked and developed reports and analytic strategies for the Bank of America's AML (Anti Money Laundering) Operations to help identifying alerts related to governance, risk and compliance.
  • Implementing Tableau report development in Global AML reporting application to optimize the report usability and enhance the report functionality that Spotfire limits in its capabilities.
  • Using Spotfire and Tableau BI tools to build exclusive dashboards for the Business use and intractability.
  • Worked with Performance tuning reports using Tableau Recommendations.
  • Maintained strong collaboration and shared technical perceptions with business and technical partners.
  • Liaison between the client business departments and the project management and Technical development teams to share the business report expectations, knowledge and needs.
  • Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Created report schedules, data connections, projects, groups in Tableau server.
  • Involved in creating complex triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Created documentation, worked with users for new module enhancements and testing.
  • Created Data Definitions and help maintain Metadata repository.
  • Using and live and extract data connections for the reports, scheduling the reports and maintaining extract refresh for the reports on the Tableau server.
  • Implementing the use of URL's Hyperlinks Filters for developing Complex dashboards and worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ).
  • Created Advance connections, join new tables, create & manage Extract and Monitor Queries using Teradata SQL Assistant.
  • Extensively worked with the QA Team and the Business users during UAT in Sign-off process. Track issues or bugs to resolve.
  • Involved in Regression testing, Unit testing (UAT) and fixing issues in the Reports during validation and before approving the reports to Production Environment.
  • Environment: Tableau 9.2.9 desktop, Tableau server, UAT testing, Sales, Finance and Operational reports, Teradata SQL, TOAD, Spotfire, Multiple Data Source Extraction.
SQL Metadata TOAD Teradata Data Visualization Triggers Tableau BI Developer Tableau Server Project Management Unit Testing
Remove Skill
Tableau Reports Developer
Information Technology
Oct 2015 - Aug 2016
  • Gathered and analyzing the business requirements with BRD, and convert to technical requirements with FSD and data mapping document, design diagram, solution design diagram and mock ups.
  • Responsible and accountable for the business, functional, technical, documentation, design (mock up, wireframe and, proto type), pipelining, base lining, Gap analysis, reverse engineering, development, testing and UAT of the whole project in 3 environments RT (Run Time) Dev\Staging and PROD of all requirements of the 3 layers of the project as a Tableau Analyst (Project level and Systems) 11 Sources, Composite middle and Tableau Reporting level).
  • Worked with Performance tuning reports using Tableau Recommendations.
  • Liaison between the client business departments and the project management and Technical development teams to share the business report expectations knowledge and needs.
  • Prepared the Report Inventory, Report Mapping doc, report business requirement document (BRD) and the report Functional Specifications Document (FSD) for all the 3 tiers source, data and Analyzed the business and functional requirements of the various source systems, middle data composite fields and destination reporting Tableau fields.
  • Developed prototype reports and then freezing report requirements.
  • Involved actively in Inception, elaboration Phases and prepared vision statement and initial data models and flows that contained Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
  • Extraction from big data databases such as Hadoop/HIVE and also Teradata for sales and marketing departments.
  • Data blending by connecting to HIVE and SQL databases as back-end.
  • Loading of data flows using SSIS applying Visual Basics.
  • Acted as a Tableau BI end to end life cycle implementer involving in Data Analysis (Tableau Analyst), Dashboards development (Tableau Developer) and Dashboards Administration (Tableau Admin).
  • As a Tableau Analyst, used Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving into the data for predictive findings and for various data analysis.
  • Map R Enterprise edition (M5) (Hadoop/Hive) for extraction for data for visualization and creating KPI's.
  • Sliced and diced the data, for analysis of patterns, trends and fashions of various KPIs, measured using various graphs, charts, indicators, and gauges.
  • Majorly focused on Tableau BI tool and to bring end tableau dashboards and closely worked with the clarity development team and Composite team acted like an end -to -end Tableau Implementer (Tableau Analyst, Tableau Developer and Tableau Admin) throughout the project.
  • Created dashboards for Sales, Financial and Marketing departments.
  • Used data analysis and data gathering with ad-hoc SQL quires for the Marketing department and created and updated reports from various databases for advertising purposes.
  • Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
  • Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using tableau desktop.
  • Involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, T
  • Implemented Tableau Row Level Security with User Filter.
  • Published Tableau Reports/ Extracts to Tableau server and migration.
  • Environment: Tableau 8.0,9.0 Desktop, Tableau Server, Hadoop/HIVE, Tableau Analyst, BRD, FSD, Data mapping documents, Prototype reports, Freezing report documents, Tableau Row level Security, Data Analysis, Dashboards development and Dashboards Administration. Santana Textiles, Edinburg, TX
SQL Data Analysis Teradata SSIS Agile Methodology Data Visualization Big Data Tableau Tableau Server Data Mapping Project Management Tableau Desktop System Analysis Waterfall Gap Analysis
Remove Skill
Data Analyst
Information Technology
Aug 2011 - Nov 2013
  • Used data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data.
  • Designed reports as per client Requirement and created the reports using Excel file and Oracle database.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI's.
  • Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Created demos in Tableau Desktop and published onto Tableau Server.
  • Produced Logical Data Models/Physical Data Models.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • Deployed Tableau Dashboards and worksheets in clustered environment using Google Analytics.
  • Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
  • Provided support for Tableau training for various end users.
  • Interacted on a day to day basis with several different groups in order to achieve a common deliverable.
  • Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
  • Hands-on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.
  • Involved in resolving reporting issues and design issues throughout the reporting life cycle.
  • Managed a development team responsible for product delivery, support, development and maintenance.
  • Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Monitored the project processes, making periodic changes, authoring progress and completion managed project plans and budget, guaranteeing on-time delivery.
  • Ensured all project requirements and objectives are properly documented and pursued.
  • Environment: Tableau 7/8.0x, Tableau server, Google Analysis, HANA, Oracle databases, Visual Basics, Erwin.
SQL Data Analysis Oracle Erwin Data Modler Data Visualization Tableau Tableau Desktop Tableau Server SQL Server Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Lamar University
Skills
Unit Testing
2021
5
Data Visualization
2021
4
Project Management
2021
4
SQL
2021
4
Tableau
2021
4
Tableau Server
2021
4
Data Analysis
2016
3
Erwin Data Modler
2013
2
Microsoft Excel
2013
2
Oracle
2013
2
SQL Server
2013
2
Tableau Desktop
2016
2
Gap Analysis
2016
1
System Analysis
2016
1
Teradata
2021
1
Waterfall
2016
1
Agile Methodology
2016
1
BI Developer
2021
1
Big Data
2016
1
Business Intelligence
0
1
Data Mapping
2016
1
Data Mining
0
1
ETL
0
1
Metadata
2021
1
PL/SQL
0
1
SSAS
0
1
SSIS
2016
1
SSRS
0
1
Stored Procedure
0
1
TOAD
2021
1
Triggers
2021
1