SUMMARY:

• Experienced DWBI Professional with 13+ years of experience in ETL, Oracle and Unix.
• Work Expertise in Data Loading, Data Analysis, Data Cleansing, Transformation and Data Integration using Informatica Power Center 9.x/8.x, IDQ, OWB and SSIS 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 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.
• Experience in Loading and Extracting Data using Teradata Utilities like Fast Load, Multi Load, TPUMP, Fast Export, Teradata Parallel Transporter(TPT), BTEQ as services in Informatica.
• 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

TECHNICAL SKILLS:

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

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

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

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

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

BI Tools: Business Object, Qlikview, Cognos and MSTR

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

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

PROFESSIONAL EXPERIENCE:

Confidential, LosAngeles, CA

AVP,ETL Analyst

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

Responsibilities:

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

Confidential, LosAngeles,CA

Senior ETL Data Integration Developer

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

Responsibilities:

• Lead 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:

• Lead 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, New York

Data Architect

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 anaylse 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, Busioness 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, Texas,Houston

ETL Lead

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

Responsibilities:

• Analysed 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, Hoboken, New Jersey

ETL Developer

Environment: OWB 10g, Oracle10g, UNIX, SQL, PLSQL

Responsibilities:

• Design, development and testing of mappings.
• Resolved the production issues.
• Tuned the jobs for better performance on request.

Confidential, Miami, Florida

ETL Developer

Responsibilities:

• Documented Application Support guidance and procedures
• Conducted High level analysis of defects
• Provided daily status High Level Report to the client

Confidential, Addison,Texas

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.