SUMMARY

• Over 8 years of experience in Analysis, Report design, Dashboard development, Testing and Implementation of Business Applications and Client/Server applications.
• Strong expertise in using Tableau software as applied to BI data analytics, reporting and dashboard projects. Worked on Tableau 9.0/8.3/8.2/8.1/8.0/7.0 versions.
• Strategic expertise in design of experiments, data collection, analysis and visualization.
• Expert in Data Visualization development using Tableau to create complex, intuitive and innovative dashboards.
• Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands - on development assisting users in creating and modifying worksheets and data visualization, dashboards.
• Good at Relational Database Management System (RDBMS) concepts.
• Working Knowledge on Kimball/Inmon Methodologies.
• Experience in Data Extraction, Transformation and Loading data using Informatica Power Center 9.x/8.x/7.x.
• Worked on tools like Repository Manager, Workflow Manager, Workflow Monitor, Designer consists of objects like Mapping Designer, Transformation Developer, Mapplet Designer, Source Analyzer and Target Designer, Admin console and Data Administration.
• Experience in managing Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3, Data Marts, OLAP, OLTP.
• Good at Pre-SQL and Post-SQL at session level in Informatica.
• Knowledge on Data Cleansing, Data Staging, Data profiling, Error Handling, Session log files, Workflow log files and Performance optimization like Push Down Optimization (PDO), session partitioning, which troubleshoots the bottleneck problems at different levels like source, target, mapping, session and system
• Experienced in all phases of SDLC using Agile and Waterfall methodologies for Data Integration, including requirement gathering from business users, analysis, design, creation of business requirement documents, mapping documents, impact/gap analysis document, ETL development, testing, and implementation
• Good in Onsite-Offshore work co-ordination.
• Designed, implemented and maintained project templates for business analysis, quality assurance scope management and change management
• Worked on creating Integration Service, Repository Service, repository backup, restore repositories
• Experienced in integration of data sources like Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2005/2000, Flat Files, XML files
• Extensively worked on developing and debugging Informatica mappings, Mapplets, sessions and workflows
• Worked in Agile work environment.
• Well versed in MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.
• Experience in Development, bug fixing and issue analysis.
• Extensively involved in Requirements gathering, requirements documentation, writing test plans, testing and Quality Reviews.
• Ability to perform under pressure in a deadline-driven environment.
• Good experience in preparing Unit Test Cases (UTCs), Unit Test Plan (UTPs) and Unit Test Results (UTRs).

TECHNICAL SKILLS

Operating System: Windows 98/00/XP/07, OS/390, Z/OS, VM, UNIX

BI Tools: Tableau 9.0/8.3/8.2/8.1/8.0/7.0

DWH ETL Tools: Informatica Power Center 9.5.1/9.1.0/8.6.0/8.1.1 , Informatica Data Quality 8.5

Database: IBM DB2, Oracle 11g/10g/9i/8i, Teradata 12

Database Tools: TOAD 11.5/8.6, SQL plus, SQL Developer 2.1.1

Languages: C, Unix Shell Scripting, PL/SQL

Files: Microsoft Visio, MS word, MS Excel, XML, Cobol and Flat Files, HDFS files.

Domain Knowledge: Finance, Healthcare, Telecommunications, Insurance and Retail

PROFESSIONAL EXPERIENCE

Confidential, MI

Sr Tableau Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Utilized Tableau server to publish and share the reports with the business users. Also involved in administration tasks such as providing access to the users and adding them to the specific group.
• Strong report/dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design..
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Designed mappings using different transformations like Lookup’s (connected, Unconnected, Dynamic), Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, and Aggregator using Informatica Power center designer.
• Analyzed different data sources like Oracle, DB2, Flat files including Delimited and Fixed width like text files, SQL Server, XML files from which the contract data and billing data is coming and understand the relationships by analyzing the OLTP Sources and loaded into Oracle data warehouse.
• Worked on Slowly Changing Dimension (SCD) Type 1 and Type 2 and 3 to maintain the full history of customers.
• Responsible for performance optimization by writing SQL overrides instead of using transformations, implementing active transformation like filter as early as possible in the mapping, selecting sorted input when using Aggregator or Joiner transformations .
• Implemented performance tuning at all levels like source level, target level, mapping level and session level.
• Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
• Used workflow level variables for the reusability of the code.
• Used Mapping Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.

Environment: Tableau 9.0/8.1/8.0, SQL, Oracle 11g, UNIX, Shell scripting, Toad.

Confidential, NJ

Tableau Report Developer/ Informatica Developer

Responsibilities:

• Involved in review and finalizing the technical specifications of source-target mapping documents
• Responsible for Data Extraction and Transformation from disparate sources like Oracle and XML files and loading in to XML files using Informatica Power Center 9.1.
• Use Tableau Desktop to analyze and obtain insights into large data sets.
• Create visually compelling and actionable interactive reports and dashboards.
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Manipulating data using Tableau versus using a programming language to find the right balance.
• Updating the Reports according to the client Requirements.
• Prepared Unit Test Cases for reports.
• Perform Gap Analysis and feasibility study for implementing Extract/reporting enhancements.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Work with subject Matter Experts to identify data relationships, report field mappings and translate them into technical requirements for development.
• Presented to the higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Coordinating and conducting business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, DBA's and project managers.
• Design mockups/wire frames for various reports by using MS Visio and Excel.
• Write and execute SQL scripts, Stored Procedures to develop reports and perform data/report validation.

Environment: Tableau 8.0/7.0, Informatica 9.1, Oracle 10g, PL/SQL, DB2, TOAD, XML and UNIX

Confidential

ETL/Data warehousing Developer

Responsibilities:

• Involved with business in gathering requirements and preparing technical design document.
• Analyzed source to target mapping sheet.
• Worked on ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation. Used Informatica Power Center/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Sybase,Flat filesin to staging area (Oracle) and load in to Oracle data warehouse.
• Developed complex mappings using various transformations like Source Qualifier, Update Strategy, Joiner, Filter, Router, Expression, Transaction control, Normalizer, Union transformations etc.
• Worked on simple/complex SQL queries and joins to have anoverride in source qualifier.
• Worked on PL/SQL procedures to load the data.
• Worked on data profiling which is used in the process of data investigation, discovery, and mapping to scan all records from any source to identify and quantify data quality.
• Involved in the design of incremental load strategy and error handling strategy.
• Developed standard and re-usable transformations and Mapplets using various transformations like Expression, Aggregator, Joiner, Source Qualifier, Router and Lookup.
• Developed reusable tasks at session level in the Informatica Workflow Manager.
• Worked on the huge workflows with worklets, event waits, assignments, Email and command tasks.

Environment: Informatica Power Center 8.1, Work Flow Manager, Oracle 10g, SQL Server 2005, Erwin, TOAD, UNIX Shell script.

Confidential

ETL Developer

Responsibilities:

• Extensively used Informatica Power center for Extracting, Transforming and Loading data from relational sources and non-relational sources.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Lookup (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Developed mapping parameters and variables to support SQL override.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Created sessions, database connections and batches using Informatica WorkflowManager.
• Developed mappings to load data in slowly changing dimension.
• Created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Designed and developed complex Aggregate, Join, Lookup transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.

Environment: Informatica Power Center 8.1, Oracle 8i/9i, MS SQL Server 2005/2000, XML.

Confidential

SQL/BO Developer

Responsibilities:

• Worked with data analyst to know the requirements of the project.
• Worked with various data sources like oracle, flat files, Sybase data coming as customers data and load into Oracle warehouse.
• Created Complex Crystal Reports using SQL Server Stored procedures as the data source
• Created WEBI Reports for various end user reporting
• Involved in designing of Informatica mappings by using transformations like source qualifier, expression, update strategy, router, joiner, connected lookup, unconnected lookup, dynamic lookup, transaction control, rank, sequence generator, Aggregator.
• Designed the Universe with almost 3000+ objects and complex derived tables
• Created Front end WEBI Reports using merged dimensions with the data coming from different queries.
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type2.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on shared folder.
• Worked on oracle utility, scheduling tool and versioning tool.
• Worked on Perl scripting.
• Created PL/SQL procedures for certain Business Requirements
• Designed SQL overrides in source Qualifier according to business requirements
• Created sessions and workflows for designed mappings and created Sequential Workflow using
• Monitoring the session logs to check the progress of data load.

Environment: BO XI R2, Crystal Reports, Data modeling, Oracle 8i, SQL, PL/SQL, MS SQL Server 2000, Flat Files, Windows 2000.