SUMMARY:

• Over 8 years in Analysis, Design, user interaction, development and deployment of ETL/Data Warehouse, Business Intelligence and Web Applications.
• Experience in implementing SDLC process includes Analysis, creating specifications and flow diagrams of data integration and BI application, data marts and star schema.
• Experience in design and develop data integration projects to build data warehouse/data marts using Informatica, True Comp for Government, pharmaceutical and insurance projects.
• Experience in design, developing ETL process using Informatica and Oracle, User interface screens and reports using tools Tableau/Cognos/TRIRIGA and web development.
• Experience in Informatica Administration like Deployments, migrations, User and folder maintenance, ETL development standards doc, Migration procedures.
• Experience in writing stored procedures, functions and packages, SQL performance tuning.
• Developed UNIX scripts for Informatica Administration tasks, FTP, File Validation process.
• Created interface control documents for new interfaces, Service level agreements, exception handling and production support manuals.
• Experience in coordinating different departments and integrating data from various source system to TRIRIGA database using ETL process.
• Proficiency in developing reports using Tableau, Cognos BI(Report net, Impromptu, Power play).
• Experience in developing web applications using ASP, VB Script. JAVA Script, VB, HTML and DHTML.
• Experience in creating test process. Created unit and integration test plans and involved in testing of ETL process, reports and Web Applications.
• Provided production support in various projects. Experience working with cross - functional teams, team player and self-starter, capable of working independently.

TECHNICAL SKILLS:

Tools: Informatica PC 8.6/7.1.2, Tableau 9.2, Cognos 7.1, Report Net, True Comp 5.2Test Director 8, SQL Server, TRIRIGA 9, Microsoft Project, QualityCenter 9Programming VB Script, Java Script, ASP, SQL, PL/SQL, HTML, DHTML, C, PASCAL

Data Base/OS: Oracle 8/9/10g, Postgres 9.2/Redshift, SQL Server 7.0, MS-Access 2000, Solaris 2.7/5.8

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Tableau 9, Microsoft Project, Quality Center 9, Informatica 9.x, Oracle 11g, Solaris 2.7

Responsibilities:

• Worked with business Analysts, created Technical documents and data modeling based on requirements.
• Designed and developed Informatica mappings, sessions and workflows to perform ETL procedures to load data.
• Involved in analyzing existing process, gap analysis, ETL process development using Informatica, PL/SQL procedures.
• Developed data pipeline using PL/SQL to migrate the data from staging tables to data warehouse and data mart.
• Created action filters, parameters and calculated sets for preparing dashboards/ worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Worked with testing team to validate the reports.

Confidential, New York City

ETL Developer/Data Integration Specialist

Environment: Informatica 8.6/9.x, Oracle 11g, TRIRIGA 9, Microsoft Project, QualityCenter 9, Solaris 5.10

Responsibilities:

• Worked with business users to analyze data, requirement gathering, Technical documentation.
• Performing database modeling to build data integration application from various source systems and integrate with reporting database (TRIRIGA).
• Designed and developed Informatica mappings, sessions and workflows and Unix scripts to perform ETL procedures to load data to SEPTS database.
• Defined and document ETL development standards like naming standards and Migration procedures.
• Involved in analyzing the source data from various agencies and documented data issues and gaps.
• Developed PL/SQL, SQL scripts for data validation, data integrity verification. Developed UNIX scripts for file validation, ftp process.
• Coordinated Production releases with DBA and Release Management team.
• Involved in creating test plans and test cases. Helped users to prepare the test data to perform the UAT.
• Coordinating with TRIRIGA team to load data. Created metadata dictionaries for buildings information.
• Created user interface/training documents and run book for production support.

Confidential

Programmer Analyst

Environment: Informatica 7.1.1/8.1.3, Oracle 10g/9.2, True comp 4.x/5.2, Sun Solaris

Responsibilities:

• Part of Avaya technical team and worked with analyst to design and recommend changes in the area of external interfaces (Informatica and PL/SQL), created technical documentation.
• Worked with DBA, System Admins and Production support team to resolve the production issues.
• Support day today activities and full range of Development and Support activities tasks for existing Confidential Compensation Tool. Application is built around Callidus True Comp with multi-tiered layer on Web Logic, Oracle, Informatica, PL/SQL, UNIX Shell Scripts.
• Loaded sales compensation data to Callidus True Comp to calculate the compensations monthly using legacy application (PL/SQL & Unix scripts).
• Extracted data from True Comp and loaded data into Postgres database (Redshift) to generate the historical analytical reporting to identify the sales trends.
• Created test plans/cases and scripts to run the integration testing and documented the impact analysis of the existing system.
• Developed the Informatica mappings for loading the data. Migrated ETL process from PL/SQL procedures, scripts to Informatica ETL procedures.
• Provided the production support for 24/7.

Confidential

Informatica Administrator/ETL Developer

Environment: Informatica 6.2/7.1/7.1.5, Oracle 10.2/9.0/8, HP UNIX 11.11, HP Itanium

Responsibilities:

• Installed and configured Informatica Power Center 7.1 in HP itanium. Upgraded repositories from 6.2 to 7.
• Administering development, production and test environments, user, groups and folder maintenance.
• Defined and documented ETL development standards like naming standards and Migration procedures.
• Monitoring and scheduling in-house financial applications and ensure daily, weekly, and monthly processes successfully completed. Involved in debugging the mappings for fixing the problems.
• Developed data integration process to load sales forecast data from various heterogeneous systems.
• Design and develop the reports using SQL server reporting services for claims.