SUMMARY

• Specialize in Analysis, Design, ETL Lead/Architect, Data modeling, Data architecture.
• Define ETL strategies/roadmap, capacity planning, process, procedures, standards.
• Expertise in implementation of Informatica based ETL solution fulfilling stringent performance requirements.
• Head complex ETL requirements and design.Developed solution in highly demanding environment and provide hands on guidance to other team members.
• Worked as data modeler, Created Conceptual, Logical and physical data models, data modeling guidelines, ER diagrams. Created Dimensional (Star and Snowflake) models, known different CDC, Slowly changing dimension techniques. Also worked Integrated Data Model (IDM) to create model as platform independent.
• Worked with multiple ETL tools such as Informatica, Datastage.
• Worked in creating SQL and PL/SQL, UNIX shell scripts.
• Worked in integrating with cloud application Salesforce, and other third party server/application like Webserver, BO, Tivoli, AutoSys etc. through Informatica server.
• Good team player, motivate team members, visionary, good planner, mitigate risk, strong analytical and presentation skills.
• Proficient in business analysis, development lifecycle, ETL, QA and testing, production support, performance tuning.
• Pro - active and enthusiast to learn and adapt new technologies.

TECHNICAL SKILLS

Data Modeling Tools: TOAD Data Modeler, Erwin V8, V9

ETL Tools: DataStage, Informatica

Databases/DB Tools: Oracle 8i/9i/10g/11g, DB2, MS Access, TOAD, SQL Developer

Version Control Tools: Subversion

Operating Systems: Windows, Linux, UNIX (AIX, Sun Solaris).

Other Skills: Unix Shell scripting, bash scripting, PL-SQL/Oracle SQL*Plus.

PROFESSIONAL EXPERIENCE

ETL Architect/Senior Data Modeler

Confidential, Portland, OR

Responsibilities:

• Develops partnerships and works closely with business team members to understand and document day in the life and usability requirements through storyboards, wireframes, user interface specifications and other documentation.
• Create integration context diagrams and associated systems process models to aid in clarity
• Work closely with Business functional analyst and business customer to ensure information and integration requirements are clearly understood and resolve any conflicts
• Create and maintain Paper prototypes, UI storyboards and UI Specifications by working closely with Functional Analysts and Business team members.
• Defines test scenarios based on business processes and may participate in Integration Testing when needed.
• Conduct usability User Acceptance Tests with business teams.
• Designed Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Create /Review Test Plans for Unit / Integration testing.
• Identify/resolve bugs when developers are not able to do so.
• For small duration, worked with Nike business using Informatica Metadata manager and Business glossary in creating the enterprise wide data linkage between Business terms and end database object.
• Troubleshoot and diagnose ETL performance issues, Performance tuning and query optimization.
• Managed the overall Data model/ETL/Reports deliverables.

Confidential, Las Vegas, NV

Architecture | Design | Development | Testing

Responsibilities:

• Created, maintained the Logical/Physical data models.
• Designed Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Design Informatica mapping and session template for various phase of projects.
• Work and supported the ETL developer during project’s build and System test and UAT phase.
• Design Test Plans for Unit and Integration testing.
• Reviewed and randomly tested Informatica coding.
• Troubleshoot and diagnose ETL performance issues, Performance tuning and query optimization.
• Managed the overall Data model/ETL/Reports deliverables.

Confidential, Nashville, TN

ETL Architecture, Design & Development

Responsibilities:

• Involved in Requirement gathering, Logical and Physical Data model design.
• Extensively worked to analyze and identify source systems, design data structures, data selection, data integration, Data profiling and resolve data quality issues.
• Head complex ETL requirements and design.Developed solution in highly demanding environment and provide hands on guidance to other team members.
• Clearly defined the Scope and Assumption of Interfaces, Communicated the Risk and Mitigation plans proactively to Business Stakeholders.
• Design Test Plans for Unit and Integration test.
• Optimized/Tuned the existing Informatica mapping in various levels by avoiding bottleneck to get better performance without disturbing the existing system functionalities.
• Involve streamlining in loading huge volume of data from source to target.
• Worked in integrating with Salesforce, and other third party server/application like Webserver, BO, Tivoli etc. through Informatica server.
• Loading and extraction data from Salesforce.com (cloud technology) using Informatica 9.1.

Confidential

ETL Lead, Design & Development

Responsibilities:

• Worked as Datastage Administration and ETL development Lead
• Datastage server health check, patch/ fix pack installation, resolving unknown/new issue.
• Involve in creating Source to Target mapping by studying the specifications and analyzing the required transforms.
• Work as Lead and complete owner to Migrated 7.5 jobs to Datastage 8.1.
• Optimized/Tuned the existing Datastage jobs in various levels by avoiding bottleneck to get better performance without disturbing the existing system functionalities.
• Audit Log database of unsuccessful records that failed to be created or updated with appropriate reasons.
• Coaching and mentoring staff developers.

ETL Consultant

Confidential, Lexington, KY

Responsibilities:

• As Onsite Technical Lead, interacted with Business Users / Analysts to understand the requirements and translate the requirements to technical specifications ETL Mappings in Informatica.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
• Managing/Coordinating the Enhancement releases from requirement gathering, Design, Development, System testing, QA and Production deployment between teams.
• Involved in performance tuning in various level of ETL mappings.
• Drafted Test Plans, Back out plans and Contingency measures during the Production Patches/Fixes for the existing applications.
• Developed UNIX Shell scripts for scheduling the jobs.
• Developed project related documentation, participated in testing, performance tuning, business meetings and other activities as required by project

Informatica ETL Consultant

Confidential

Responsibilities:

• Analysis and designing of ETL processes.
• Involved in preparing Logical and Physical data model, Source Data Analysis, ETL Process flow and the schema objects with necessary Indexes, Partitions.
• Designed the jobs based on the understanding the Data model table relationship.
• Optimized/Tuned the existing Informatica mapping in various level (Source Qualifier, Transformations and Target) by avoiding bottleneck to get better performance without disturbing the existing system functionalities.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces

Confidential

Development

Responsibilities:

• Analyze the external third party vendor sources (SSB/Fact set etc) to establish feeds into Data Warehouse.
• Analyze the existing systems used by different users and establish the feeds to these systems from Data Warehouse.
• Create session tasks for each mappings and workflows to run the sessions using Informatica Workflow Manager. Monitor scheduled and running workflows using Workflow Monitor.
• Performed simple and complex transformations (Aggregator, Expression, Lookup, Joiner, Sequence Generator, Sorter, Stored Procedure, Update Strategy, etc.,) as part of Mapping between source and target.
• According to the business logic created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, Union, Update Strategy and Sorter.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Performed Incremental loading by means of loading recently modified/added record into DW
• Map existing sources/feeds to the Data Warehouse fields.
• Build the ETL layer to load data from ODS to Data mart. Data validation checking, and adding new columns.