BI/Tableau Developer
Resume:
linkedin.com/in/mkb***
M K Baig *****.*****@*****.***
BI Developer Tableau Developer
Experience Overview
Over 8 years of experience in Designing, Developing, Administering, and Supporting Business Intelligence applications.
Extensive experience with BI and Data warehouse techniques using Tableau, OBIEE connecting multiple databases like Teradata, SQL Server, Oracle etc.
Participated in the Agile planning for Team Foundation Server to make sure that our team sprints satisfied backlogs.
Exposed to BI/DW assignments in various domains like Retail, Healthcare, Banking and Telecom
Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing
Strong knowledge of Dimensional Modeling like Star Schema and Snow Flake Schema to fit Query, Reporting, and Analysis requirements
Involved in integration of Tableau JavaScript API Filters in web application
Involved in Extract-Transform-Load processes using Informatica, Datastage and Amazon Redshift for Financial Reporting and Risk Analytics and Designing Risk Management plans.
Experience and Working knowledge in Hadoop HDFS Admin Shell commands.
Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
Explore data in a Variety of ways and across multiple visualizations using Power BI.
Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
Accountable for Service Level Agreements (SLA) for customers
Experience in Production and Technical Support activities and managing production rollouts
Worked on multiple projects from requirement gathering to training end-users
Hands on working experience Linux environment with Apache Tomcat, experience on Amazon AWS
Experience working with ANSI SQL, PL/SQL, SQL*Plus, SQL*Loader, and UNIX and Korn Shell scripting
Involved in writing detailed as well as high level documents for reports and repository design
Identifying and removing bottlenecks in order to improve the performance of dashboards and reports.
Experience troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements
Experience working with various operational sources like Informix, SQL Server, DB2 and Flat files
Performed data analysis for user enablement of forecasting and strategic planning
Effective communication skills and record for coordination between globally located teams
Influencing and rapport building with stakeholders to help them achieve their Analytical goals
Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
Education
Master of science in the field of Computer Science USA
Bachelor of computer applications Hyderabad, India.
Skills
BI Tools
Tableau 10.x/9.x/8.x, Datastage 8.x, Oracle Business Intelligence Enterprise Editions 10.1.3.x, Microsoft Power BI.
Languages
SQL, UNIX Shell Scripting, HTML.
Databases
Teradata v15/13/12, SQL Server 2000/2005, DB2, MS Access, Oracle 9i/11i
Operating Systems
Linux (Red Hat) AS4, Unix, WINDOWS 95/98/2000/NT/XP, 7, 8, 10
Dimensional Modeling
Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables
Application Software
MS Word, MS Excel, MS Access, MS Power Point.
Other Tools/utilities
Oracle TOAD; Teradata Utilities: SQL Assistant, BTEQ; DataStage Suite: Designer, Director, JSON
Professional Experience
Projects
Role
Location
[1] American Express
Sr. BI/Tableau Developer
New York City, NY
[2] Target
Sr. Data Analyst/Tableau Developer
Minneapolis, MN
[3] Capital One
Tableau Developer
Richmond, VA
[4] Pan-American Life Insurance Group
BI Tableau Dashboard Developer
New Orleans, LA
[5] IBM
SQL Developer/Tester
Hyderabad, India
[1] American Express Sr. BI/Tableau Developer
New York City, NY Jan’16 – Till Date
Roles and Responsibilities:
Gathered user requirements, analyzed and designed software solution based on the requirements.
Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
Created and analyzed reporting within Tableau based on the business requirement.
Designing and developing Supply Chain data models by integrating data from multiple sources
Interacting with business users to capture requirements and make enhancements as necessary
Developing Inventory Control dashboards using Tableau to analyze vendor defects
Writing SQL queries solved many critical requirements by digging the required data.
Developing Tableau interactive dashboards to monitor KPIs related to Overages, Shortages and Damages etc.
Extensively used advance chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems.
Created complex formulas and calculations within Tableau to meet the needs of complex business logic
Created and assisted users in Tableau dashboard development.
Defined best practices for Tableau report development and effectively used data blending feature in tableau.
Scheduling, debugging, and optimizing BI processes based on dependencies
Support ad-hoc requests, perform deep-dive analysis to identify areas of concern, and debugging of data inaccuracies.
Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
Strong SQL skills including use of nested expressions, unions, multi-table joins.
Transferring data from Teradata to Cerebro (HDFS) Using TD CLI utility and building Hive managed/external tables on top of it.
Working knowledge in Hadoop HDFS Admin Shell commands
Hands on working experience Linux environment with Apache Tomcat, experience on Amazon AWS
Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
Create reports, which display the competitive advantages over its competitors.
Technology Stack: Tableau 10.5/9.1, Teradata 15.1, SQL Server, Hadoop, Hive, Oracle, Tomcat, SAP HANA
[2] Target Sr. Data Analyst/Tableau Developer
Minneapolis, MN Sep’13 – Dec’15
Roles and Responsibilities:
Created and hands on experience in Level of Detail Expressions (LOD’s) such as Customer order frequency, Cohort analysis, Daily profit KPI, Percent of total, New customer acquisition, Comparative sales analysis, Average of top deals by sales rep, Actual vs. target, Value on the last day of a period, Return purchase by cohort etc.
Involved in full project lifecycle of SDLC and coordinated with all project teams.
Writing complex SQL queries on Teradata handling source data challenges and adapting to the dynamic nature of the project
Streamlined and improved existing data load processes by automating manual activities
Developed various reports using freehand SQL for Inventory Management and Innovations team in accordance with Business Strategies
Involved in troubleshooting, optimizing, fine-tuning SQL queries and debugging for efficiency
Involved in documentation, review, analysis and post production fixes while adhering to the defined SLAs
Worked with ETL team (DWH) to extract data into Tableau using custom SQL to filter data source
Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
Designed and deployed interactive reports with Drill Downs, Drop down menu option, Parameters and Linked reports using Tableau
Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, and parameters
Scheduled data refresh on Tableau Server for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
Develop parameter based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop
Migrated all dashboards from Tableau 8.1 to 9.1
Perform impact analysis for changes in database fields and modify jobs accordingly
Develop Contingency plan to manage database outages with no or minimal impact to business.
Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
Technology Stack: Tableau 9.1/8.1, DataStage 8.5, UNIX, Oracle, Mainframe, Windows 7, Teradata v14.01, Informix, SQL Server and Db2 databases
[3] Capital One Tableau Developer
Richmond, VA May’12 – Jul’13
Roles and Responsibilities:
Involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
Involved in full project lifecycle of SDLC and coordinated with all project teams. Interacted with Subject Matter Experts & End Users and gathered business requirements. Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
Worked extensively in creating dashboards using various versions of Tableau 7 and 8.1.
Worked closely with all team members in implementing Tableau BI tool in all IT projects.
Generated reports using SQL queries in Tableau 7.x/8.x and published to the Tableau server
Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.
Created adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau adhoc reports.
Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
Took backup of the Tableau server on regular basis by using Tabcmd, Tabadmin commands also developed restoration procedures to restore the server during system failures.
Created users, groups, security roles and SSL authentications.
Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production.
Cleared Roadblocks and delivered project under tight schedules.
Involved in integration of Tableau JavaScript API Filters in web application
Defined best practices for Tableau report development.
Created dashboards and reports for ad-Hoc Reporting.
Played an important role in coordination with the entire team and managing the time estimates for the entire project.
Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
Provided post implementation production support.
Technology Stack: Tableau 7.1, SQL Server Management Studio, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)
[4] Pan-American Life Insurance Group BI Tableau Dashboard Developer
New Orleans, LA Oct ’11 - Apr ’12
Roles and Responsibilities:
Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements, equity capital raising requirements and outline the proposed solution.
Interacted with Business users and Business Analysts in gathering requirements and to understand their business view in designing the Universe and modifying the reports accordingly
Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
Connected Tableau server to publish dashboard to a central location for portal integration.
Connected Tableau server with share-point portal and setup auto refresh feature
Created visualization for logistics calculation and department spend analysis
Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
Generate KPI for customer satisfaction survey results and disease management.
Maintained Test log and Wrote Test Evaluation, Summary Reports
Extensively involved in doing user acceptance testing (UAT).
Generated Test Cases for each specification in Requirement Specification Document corresponding to each module
Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
Technology Stack: Linux, Tableau 6.0 – 6.1, MS-Excel, SQL Server, Microsoft office, Visual Basic.
[5] IBM SQL Developer/Tester
Hyderabad, India Mar’10 – April’11
Roles and Responsibilities:
Developed SQL scripts to Insert/Update and Delete data in the database tables
Created Stored Procedures for implementing business logic
Consolidate multiple data silos that exist on campus to one location.
Scheduled data extracts on a daily basis.
Sophisticated stored procedures and triggers to provide complete technical solutions.
Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
Resolved end user reporting problems through collaboration with IT and Operations.
Shared the requirements through established reporting mechanisms within Excel using Macros and Bubble charts
Ad-hoc data analysis for validation and providing meaningful insights to the business using MS Excel 2010
Performed various operation on Pivot Tables and Charts in MS Excel using Databases, CSV files, Etc.,
Developed Test Strategy, Test Plan and Test Cases to cover all the functionality, Test Execution
Analyzed, Maintained Test Results and Test Reports
Performed product release testing and reported on the status of project
Responsible for end to end project testing effort, Requirement Analysis, Preparing Test Strategy, Test Plan, Test Cases to cover all Product functionality, Traceability Matrix, Test Execution, Defect Tracking, Metrics, Reporting and Escalation.
Experienced in gathering user requirements, analyzing and preparing project deliverables such as Business Requirement Document (BRD) and Functional Requirement Document (FSD)
Work closely with the development team to analyze, debug and resolve any issues
Established and executed test procedures, Analyzed test results and defect data
Maintained test records, Developed documentation and test procedures.
Test result analysis and defect reporting
Ensured that all high-priority bugs are fixed prior to deployment
Performing black box, functional, integration and regression testing
Technology Stack: MS Excel, SQL Server, Toad, HP Quality Center, HP Unified Functional Testing, HP Load Runner, Agile, SQL, XML, Windows, Linux, Unix, Test Director
Contact this candidate