SUMMARY:

• Experienced DWBI Professional with extensive experience in ETL and data analysis, Oracle and Unix. Work Expertise in Data Loading, Data Analysis, Data Cleansing, Transformation and Data Integration using Informatica Power Center 9.x/8.x, Informatica cloud, BODS and OWB from various sources and targets including Oracle, DB2, Cobol and Flat files .
• Possess wide domain experience in Healthcare, Banking, Insurance, Logistics, Life Science, Card Payment, Insurance, Retail & Sales. Managed end to end project implementation under different roles - Project Manager, Data Analysts, BI Lead and Developer, QA/Validation support
• Worked extensively on Informatica’s Power Center Designer (Source Analyzer, Confidential Designer, Transformation Developer, Mapplet and Mapping Designer), Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensive experience in RDBMS technologies using Oracle 11g/10g/9i, SQL Server, Toad 9.7, SQL*Plus and Database Querying using SQL, PL/SQL programming constructs.
• Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), Data-Vault, ODS, EDW.
• Experience in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3.x.
• Experience working with Informatica Data Quality tool IDQ, Informatica cloud, Informatica Analyst and Informatica Developer tools, Data Validation Option (DVO),RTAM.
• Experience in data profiling using Informatica including column level profiling, Join analysis and Profile models.
• Experience in scheduling of ETL jobs using Informatica Scheduler, Control-M, ESP and Tidal
• Knowledge on developing BI solutions using leading BI tools like Business Objects, QlikView, Cognos and MSTR.
• Work experience on UNIX platform with respect to Informatica ETL environment. Wrote UNIX Shell Scripts to enhance functionality in Fetching, Loading and Scheduling Source files from the Source System, External and Internal Audit by generating Email Notification.
• Identified and Populated Fact and Dimension tables according to Business Rules implementing Type 1 and Type 2 Slowly Changing Dimensions.
• Worked across different project methodologies - Agile, waterfall and iterative models
• Actively involved in performance tuning techniques related to Informatica and Oracle.
• Extensive experience in error handling and problem fixing in Informatica
• Clear understanding of Big data analytics and Cloud based solutions

TECHNOLOGY SKILLS:

Technical Skills/Toolsets Proficiency:

ETL Tools: Informatica Power Center 9.x/8.x, IDQ, BODS, OWB,SSIS High

ETL Sources: SAP BW, Oracle, Flat Files, Excel High

Development: SQL, PL/SQL, SQL Loader, UNIX, Shell Scripting High

Languages:

Data Bases: Oracle 11g/10g, My SQL, DB2, SQL Server, Teradata High

Operating Systems: Windows XP/7, UNIX, Sun OS High

BI Tools: Business Object, Qlikview, Cognos and MSTR Low

Scheduling Tools: Informatica Scheduler, Autosys, Tivoli, Control M, Tidal, ESP High

Others: Toad, PL/SQL Developer, WinSCP, SVN, AquaData Studio, AQT High

PROJECT EXPERIENCE:

Confidential, Agourahill, CA

Senior ETL Developer

Environment: Informatica Cloud, Informatica PC,SQL server, MSTR

Responsibilities:

• Analyzed and documented user requirements, business processes and best practice
• Provide analysis for any business users reported data issues
• Create ETL designs and developments process
• Provides ETL standards guidelines to team as per need.
• Tuned Jobs for better performance.

Confidential, Los Angeles, CA

AVP, Analyst

Environment: BODS, Informatica 10.2, Oracle 10g, Informatica cloud, ESP

Responsibilities:

• Design/develop new change request provided by Business users
• Support/maintain all the day-to-day loads and provide fixes to issue
• Perform complex data analysis for user request
• Create Operational ETL document for new process moved to Prod
• Tuned the jobs for better performance

Confidential, Los Angeles, CA

Senior ETL Data Integration Developer

Environment: Informatica 9.6, Oracle 10g, PL/SQL, UNIX, OBIEE Reporting, Tidal

Responsibilities:

• Led ETL/BI design/development process.
• Interacted with the Business User to understand the problem area and provide solution recommendation
• Design, development and testing of mappings to load Data Vault table-Hub,Link & Satellite
• Worked on Solution POC with extended implementation team
• Tuned the jobs for better performance on request.

Confidential, Erie, PA

Project Lead

Environment: Informatica 9.5, IDQ, Oracle 10g,PL/SQL, UNIX, Teradata, Qlikview Reporting, Autosys

Responsibilities:

• Led ETL Team for all the Development/Design .
• Interacted with the Business User to understand the problem area and provide solution recommendation
• Design, development and testing of mappings.
• Created mapping, workflow, session to load to data from source to data warehouse
• Managed team including work allocation to the team members with periodic reviews
• Mentored and motivated the team to empower for qualitative deliverables
• Tuned the jobs for better performance on request.

Confidential, New York, NY

Data Architect/PM

Environment: Informatica 9.10, SSIS, IDQ, SQL Developer, PL/SQL, Oracle 10g, UNIX, Cognos Reporting

Responsibilities:

• ETL design and development for the project
• Design and development for converting PLSQL to ETL
• Analyzed and documented user requirements, business processes and best practices
• Worked on IDQ to analyze and test source data
• Project Planning and Estimation activities for Enhancements and Change Requests
• Created RTM, Technical design documents and Data Mappings
• Implemented Informatica error handling and exception handling

Confidential

Senior Consultant

Environment: Informatica 9\8.6, Business Objects, SQL Developer, PL/SQL, Oracle 10g, UNIX

Responsibilities:

• Business Understanding of the source systems providing the Data.
• Handled daily AM related issues for purchase, payment and money transfer systems
• Interacted with the Business User to understand the Issue and provide resolutions
• Provided knowledge transfer to other team members on customer process & application landscape

Confidential, Houston, TX

ETL Lead

Environment: Informatica 9\8.6, SQL Developer, Oracle 10g, PL/SQL,UNIX

Responsibilities:

• Analyzed Business requirement and documented ETL requirement.
• Developed and tested Data mapping.
• Responsible for ETL delivery compliant to customer’s quality standards.
• Provided knowledge transfer to other team members on customer process & ETL requirements

Confidential, Miami, FL

ETL Developer

Responsibilities:

• Application Maintenance, Enhancements and Performance Tuning of BKC Global data warehouse
• Documented Application Support guidance and procedures
• Conducted High level analysis of defects
• Provided daily status High Level Report to the client

Confidential, Addison, TX

ETL/Report Tester

Environment: Microstrategy, Datastage, Oracle9i, UNIX.

Responsibilities:

• Generated business status reports on Microstrategy
• Analyzed, Developed, Tested and Managed the Reports
• Test case preparation and execution for SIT
• Defect validation & regression testing of the reports.