SUMMARY

• Around 6 years of experience in ETL Tool Informatica, designing and developing Tableau application and in Quality Assurance involving analysis, both Manual and Automation testing. Expertise in working Banking and HealthCare domain.
• Extensive experience of data warehousing using Informatica PowerCenter 9.5/9.1/8.6/8.5/8.1 Client.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Extensive experience in designing developing Informatica Mappings & Mapplet using various transformations for Extraction, Transformation and Loading from Multiple Sources (SQL Server, Oracle, Flat files, DB2 Mainframes) to Data Warehouse and creating Sessions and Workflows/Worklets and executing the Workflows.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Triggers and Cursors.
• Experience in Data Visualization Tool Tableau Desktop and generated the reports using Tableau version 9.2
• Having Good knowledgeof Software Development Life Cycle (SDLC)methodology and project management principles
• Expertise in Tableau BI reporting tools & Tableau Dashboard developments & Site administration.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Bubbles, using trend - lines, KPIs, Running and moving aggregate measures and Highlight Tables.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.

TECHNICAL SKILLS

Database Technologies: Oracle 8i/9i/10g/11g, MS Access, MS Excel

Languages: PL/SQL, SQL,VBS Scripting Language

ETL,DW: Informatica Power Center 9.x, 8.x, Power Exchange 9.1 CDC, Talend Open Studio 6.3

BI Tools: Tableau 8.0, 8.1, 8.2 & 9.0.2

Tools: Toad for Oracle, SQL developer

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Testing Tools: ALM, QTP, Mainframe

Operating Systems: Windows XP/7

PROFESSIONAL EXPERIENCE

Confidential, NEWARK, NJ

SR. DW INFORMATICA DEVELOPER

Responsibilities:

• Responsible for requirement gathering analysis and Participation in requirement gathering sessions.
• Responsible for converting the business requirements into ETL Technical Specifications
• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse.
• Extensively worked with Informatica Designer for design of ETL mappings.
• Worked with Filter transformation and made sure we use it as early as possible in the mapping design for better performance of the mapping.
• Used Router transformation whenever multiple filters are there in the mapping design.
• Extensively worked with Look Up transformation both Connected and Unconnected.
• Extensively worked with all the transformations like Source Qualifier, Rank transformation, Update Strategy, and Look Up transformations.
• Worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, and Sequence Generator.
• Worked with Flat Files sources and Targets.
• Worked with SCDs slowly changing dimensions Type 1, Type 2, and Type 3.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Worked with Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Extensively worked with Connected and Un Connected Look up Transformations in the Designer of Informatica PowerCenter
• Worked with the Business Intelligence tools like Tableau.

Environment: Informatica Power Center 8.6/8.1, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Tableau, Oracle 9i, SQL Server 2000

Confidential, NYC

BI / Tableau Developer

Responsibilities:

• Enhancement and data fixes dashboards for Executive Membership/Membership.
• Worked in the agile methodology, which has its primary focus on the management part of the software development in small iterations of two-week Sprint.
• Enrollment/Disenrollment 3 years with different categories/Voluntary Disenrollment PACE.
• Work closely with users on gathering the requirements in terms of data presentation in dashboards.
• Developed the PCW Hours reporting dashboard to help users in understanding and managing the extra spend across various sites for the PACE, SL, Direct plans.
• Developed Daily Claims Dashboard to report the submission of claims in terms of the different status like Paid/Denied/Pend etc. Created Bar charts/Trend Graphs/Pie Charts, KPI to help users determine the trend for business needs like Average age of the claim, Running balance across QNXT and ILS source system.
• Developed Authorizations for hospitals /Nursing Homes Dashboards to determine the authorizations metrics like % denial, denied & submitted authorizations for last 12 months across affiliated centers for the plans
• Worked on modification of SQL queries and modifying various reporting views in dashboard as per user changing requirements.
• Used the RANK(), DENSE RANK() and ROW NUMBER() functions to de-duplicate data, pick the most preferred record from large, redundant datasets to prepare reporting data.
• Worked on unit testing and data validation to the source tables and fixed all the issues reported in Dashboards as per UAT.

Environment: SQL Server 2014, Tableau 9.2

Confidential

BI / Tableau Developer

Responsibilities:

• Worked on the requirement gathering of the reports.
• Worked in the agile methodology-using Scrum, which has its primary focus on the management part of the software development in small iterations of four-week Sprint.
• Integrated different reports in to dashboards and set access permissions accordingly based on user/Business needs.
• Analyzed the database tables and created database views based on the columns needed.
• Created parameters for dynamic calculations and used quick filters to create monthly analysis of sum of amounts transferred and daily reports included bar, line, graph.
• Created maps, area maps in order to analyze the total number of transactions made based on demographics.
• Created Bar charts/Trend Graphs/Pie Charts to analyze types of sender (individual or Organization) and recipients (individual or organization) and KPIs to help users to determine the turnaround time.
• Created continuous graph in order to determine the successful and failed transactions.
• Published dashboards to Tableau server.
• Created Schedule jobs for data incremental refresh manually in tableau server.
• Worked on increasing performance on Dashboard using performance recorder.
• Some Knowledge of TABCMD & TABADMIN, Database Maintenance and Troubleshooting.
• Implemented six sigma projects and standards for better efficiency with increased margins.
• Proactively communicate and collaborate with clients to analyze information needs and functional requirements

Environment: Tableau 8.x, Tableau 9, Oracle (SQL, PL/SQL).

Confidential

Automation/Manual Tester

Responsibilities:

• Developing the Manual Test Cases using Parameterization
• Coordination with Team and Monitoring the Manual Team
• Initially started with Progressive automation and prepared scripts using dummy objects.
• Development of Automation test scripts using QTP with the scripts prepared during progressive automation replacing the objects.
• Running the QTP script
• Prepare queries to fetch data into MS-Excel for validation
• Test result analysis and Reporting

Environment: ALM,QTP, Toad, MS-Excel