PROFESSIONAL SUMMARY

• Over 7 years of experience in Data Analysis/Business Analysis, System Analysis&Design, Development, testing and implementation of BI/Data Warehousing projects using Tableau, Micro Strategy, etc. in Insurance, Finance, Banking, Health Care, and Retail and Payroll Services industries.
• Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableauworkbooks and dashboards for executive decision making.
• Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public.
• Strong understanding of project life cycle and Software Development Life Cycle(SDLC) methodologies including RUP, RAD, Waterfall and Agile.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
• Experience in Developing, Designing and Support inter active Tableau dashboards.
• Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending. Intelligence tools and expertise in implementing various functionalities of Data Warehouse.
• Extensive experience in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Extensive experience in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option- Parameterized, and Linked reports using Tableau.
• Have working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
• Experience in publishing Dashboards and presenting dashboards on web and desktop platforms to Tableau Server.
• Having strong analytical, logical, Communication and problem-solving skills. Ability to adapt to new technologies by self-learning.
• Expertise in writing SQL Queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Good Understanding of Big Data and Hadoop technologies experience in loading, processing and extracting data in Hadoop environment.
• Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.
• Experience to work with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development to manage risk analysis and mitigation plans, status reports, and client presentations.
• Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality.
• Excellent skills in communication & collaboration, Strong analytical, logical, problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Operating Systems: Windows XP, Window 2000, MS-Dos, OS/400, UNIX

Languages & Software: C, C++, SQL, T-SQL, PL/SQL, Java2.0, J2EE, SAP ABAP, JavaScript, Python, PERL

BI and ETL Tools: Tableau 10.x/9.x/8.x/7.x, Informatica 9, 8.1, SSIS 2008, Cognos

Others: MS Project, Visio, MS Office, MS Excel

Testing Tools: HP Quality Center 9.2 / 10 / ALM, TFS, JIRA, Clear Quest, Rational Clear Case

Scheduling Tools: Autosys, Control M

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Databases: Oracle 9i/10g / 11g, DB2 8.0, MS SQL Server 2012/2005, Teradata 13

WORK EXPERIENCE

Confidential, Colombia, MD

Sr.Tableau Developer

Responsibilities:

• Analyzed the business requirements, identifying the requirements, reviewing and communicating with business and getting sign offs from business.
• Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Tableau.
• Upgraded Tableau server from 9.0 to 10.0 in DEV and QA along with Migration of reports.
• Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
• Played critical role in establishing Best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Worked on understanding of relational database structures, theories, principles and practices.
• Wrote Custom SQL scripts for creating aggregate tables and generating views.
• Effectively used data blending feature in Tableau to integrate different database tables.
• Designed and developed various analytic reports / dashboards using Tableau.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems. Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
• Built Excel, Qlik View and Domo reports in Tableau. Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Resolved various performance issues and analyzed the best process distribution for different projects. Assisted power users in Tableau dashboard development. Had conducted deep dive meetings with the business users to understand the current automation process and Ad hoc jobs for budget/forecast calculations.

Environment: Tableau(Desktop/Server)10.3, Teradata 13.0, Teradata SQL Assistant, Adobe Analytics, Microsoft SQL Server 2014, MS Visio, Microsoft Office Suite 2014 (Word, Excel, PowerPoint).

Confidential, Elkridge, MD

Tableau Developer

Responsibilities:

• Gathered requirements from Traders,PM’s and implemented them in a way to help them in the investment process.
• Served as a technical resource for Tableau on the project team to drive key projects to completion.
• Responsible for accessing disparate sources of production data and integrated these sources of information into common and interactive platform through Tableau.
• Designed dashboard visualization tailored to customer needs and ensuring flawless integration within the reporting framework.
• Performed analysis to build Tableau extract data sources leveraging existing data mart.
• Used live connection with Netezza and Oracle database schemas to provide near real-time data.
• Migrated Tableau Dashboard from version 9.3 to 10.3 and adding users to the AD group.
• Technical expertise in identification of solutions meeting complex business needs that facilitates automation and drives self-service.
• Created Interactive Dashboards with Context filters, Quick filters, Parameters and Actions to handle views more efficiently.
• Provided drill down mechanism with in a dashboard to clearly understand the performance of a portfolio and its KPIs.
• Provided navigation between different dashboards and making the selection criteria as the context.
• Used different table calculations and date calculations in the dashboard.
• Proof read all the documents and maintain accuracy of information and preparing SOP. Responsible for developing dashboards and preparing ad-Hoc reporting.
• Created a dashboard which helps the portfolio manager know which portfolios are under invested and which are over invested.
• Created Heat maps which show how the portfolios are on par with the models and their difference.
• Created Dual axis charts, Stacked bar, Histograms and Linecharts for time series.
• Used Box plot to show the distribution of outliers which aren’t performing well.
• Did data validation with backend database once the dashboard is created.

Environment: Tableau Desktop 9.3.3/10.3, Tableau Reader 10.3, Rapid SQL, PL/SQL, Redshift, Microsoft Excel 2010, Microsoft office 2010.

Confidential, St. Louis, MO

Tableau Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports in Tableau. Collaborate with business leadership to identify potential areas of analysis.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Created Web reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
• Created sheet selector to accommodate multiple chart types like Panelcharts, Bulletcharts and Stackbars etc. in a single dashboard by using parameters.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report.
• Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
• Defined best practices for Tableau report development. Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Worked on understanding of relational database structures, theories, principles and practices.
• Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Participated in the retrospective meetings and next sprint planning meetings.

Environment:Tableau(Desktop/Server)9.3.1, MS SQL Server 2008, UNIX, Microsoft Office Suite 2008 (Word, Excel, PowerPoint).

Confidential

ETL QA Analyst

Responsibilities:

• Worked alongside with Business Analyst and Technical Architect in Analysis of Business and Functional requirements.
• Attended Client meetings to gather the requirements and fill in the gaps in present requirements.
• Delegated QA meetings with the team and Project Management.
• Attended to team meetings, product walkthrough’s and review meetings.
• Worked with business team to test the reports developed in Cognos
• Involved in testing the Cognos reports by writing complex SQL queries
• Supported in QA activities in couple of enhancement projects apart from my designated responsibilities.
• Developed test plan and Responsible for creating Test Strategy for the Data Warehouse and the reporting modules.
• Reported the Bugs/Defects using TFS defect management tool.
• Used T-SQL for Querying the DB2 database in UNIX environment
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Used Quality Center to track and report system defects
• Written many test cases and test procedures using MS Excel.
• Initiated the QA process in the project along with team lead and acted as QA point of contact to the team.
• Worked on various data feeds like Text, Csv, XML, EDI, etc.
• Used SQL Server Integration Services 2008 to run various ETL jobs and read the logs for warnings/errors.
• Tested various Prompted reports, Summary & Detail reports, Drill down reports, Drill through reports, Ad-hoc reports.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested different Cognos OLAP Cubes using Analysis Studio and validated them against the Cube ETL loaded data in the Datamart.
• Acted as single point of contact for the Reports Development team in creating test data for the Unit testing of the Reports, Query subjects and Cubes.
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.
• Mentored new QA resources to understand the business process and our test methodologies.

Environment: Informatica Power Center 8.6.1, SQL, Teradata 12, Test Plan, Test Strategy, Test Cases, Microsoft SQL Server Integration Services 2008, TFS, IBM Cognos v8 Reports, Quality Center, T-SQL, Cognos Query Studio, Cognos Analysis Studio, IBM UDB DB2 v9, SQL Server 2005/2008, Toad for DB2, Quest Central for DB2, PUTTY, Microsoft Office 2008.

Confidential

ETL QA Analyst

Responsibilities:

• Participated in analysis of functional requirements
• Involved in designing and Preparing Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance
• Used Jira as Bug management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Creation of defects
• Preform validation of reports which Involves ISR, Roster, Student labels, as well the printed Reports and Reports which are included as part of hard drives
• Involved in developing scripts to validate all the reports used in Assessment which involved multiple data bases (Reporting, Scoring and Test path)
• Worked with Datamart which pulls all the data from the Testpath, Reporting and Scoring databases to produce the final Reports
• Worked on SSIS 2008 to validate all the tables of the Datamart for Nextera Reports. Included the database sources and the hash keys to identify the missing records from the source and the target Datamart tables
• Tested Nextera Reports to make sure the all the reports are according to the standard of state department of education which are specific to each state
• Interacted with Developers and Business Analyst for Defect analysis and performed Regression Testing in all the environments
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations within an ETL process testing cycle
• Performed different phases of testing like Smoke testing, Sanity testing, Functional testing, UI testing, Integration (End-to-End) testing, Regression testing
• Rigorously performed Regression testing for every modification/enhancement of the project
• Used SQL Server Management studio in creating & executing SQL queries for testing ETL process
• Worked on issues with migration of Data from development to QA-Test Environment
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications
• Involving in Performed Count Validation, Excel for Data Validation, beyond compare for comparing the state data files
• Maintained Traceability Matrix for each entity and marking down Test requirement, Test Head line, Actual result & Expected result to ensure complete test coverage
• Contribute in the development of knowledge transfer documentation

Environment: SSIS 2008, Microsoft SQL Server management Studio2008, Test Plan, Test Strategy, Jira, Agile, Test Cases, QTest, Confluence, Nextera (Reporting and Scoring) and MicrosoftOffice 2008.