SUMMARY

• 8+ years of IT work experience at various levels and functions in data warehousing design, development, testing, production and maintenance.
• Demonstrated expertise building complex business rules by creating complex mappings/mapplets, shortcuts, reusable transformation.
• Experience in data analysis, working with data models, ETL designs for relational and dimensional models.
• Managed all phases of ETL development on assigned projects including reviewing technical documentation, allocating ETL development work, conducting design reviews, coordinating packaging and release deployments and testing of solutions in highly complex environments.
• Change Management Design & Development Process Improvement SDLC
• Project Management Deployments
• Strong knowledge of ETL development to support data warehouse design using dimensional models on an Oracle platform
• Proficient with Informatica Power Center
• Demonstrated proficiency in improving re - usability, automation of data loads, performance tuning in Informatica and de-bugging/rectification of data load errors
• Extensively worked with performance tuning at mapping levels like implementing Active Transformation filter and Update Strategy transformation for implementing inserts and updates.
• Vigorous experience in understanding data models and creating Dimensions and Facts
• Working experience with slowly changing dimensions
• Involved in creating folders and session migration and Repository Administration.
• Extensive experience on deploying Workflow, Session on Grid
• Vast experience in error handling and troubleshooting in Informatica
• Experience with data analysis and Dimensional Data Modeling (specific to a data warehouse), Star schema/Snowflake schema, fact and dimension tables
• Experience in database programming with Oracle SQL (DML/DDL), PL/SQL (Stored Procedures, Functions)
• Working experience with complex XML templates in Informatica Data Transformation
• Developed and executed UNIX shell scripts as pre/post-session commands to schedule loads, through SQL-loader utility.
• Proven ability to effectively manage time and resources and prioritize tasks in order to consistently complete projects on time

TECHNICAL SKILLS

Data Warehousi ng Tools: Informatica Power Center 7.x/8.x/9.X, Repository Server Administrator Console, SSIS

Databases: Oracle 11g/10g/9i, T-SQL, MS-SQL SERVER 7.0/2005/2008 , Teradata

Data Modeling: Star Schema Modeling, Snowflakes Modeling, FACT and Dimensions tables

Languages: C, C++, Java, XML

GUI Development: Data Transformation Services (DTS), Oracle designer

Database Utilities: TOAD 8.0/7.1, Winsql, SQL*Plus, SQL Developer, PL /SQL, MS- SQL SERVER

Environment: s UNIX (Solaris, AIX, HP-UX), LINUX, Windows Server 2003, 2008

Other Tools: MS Visio, MS Project, Autosys

PROFESSIONAL EXPERIENCE

Confidential, NC

Informatica Developer

Responsibilities:

• Responsible for requirements gathering for the data warehouse to develop the code.
• Designing and understanding mappings for extracting & loading data to/from heterogeneous sources including CRM/Oracle/SQL Server databases to optimize data workflows and ensure data quality.
• Designed mappings for consistency check to compare like data elements for change data capture (CDC) and UPSERT logic.
• Worked extensively across fixed width flat files, handled the null records, exceptional records, space records and gained hands on with data level accuracy.
• Created mappings with various transformations like source qualifier, expression, stored procedure, router, update strategy, lookup, aggregator, union to handle complex queries.
• Used Mapplets, Parameters, User defined functions (UDF) to implement object orientation techniques and facilitate the reusability of code.
• Tune in the SQL queries at Partitioning level for Performance Issues.
• Managed defects, enhancements and new functionality requests to meet changes in systems and business needs.
• Developed UAT testing as requested by the business support team after new patches were implemented to enhance the business usage.
• Documented Informatica mappings in Excel spread sheet.
• Developed batch scripts for running batch jobs in box and scheduling them
• Manage defects, enhancements and new functionality requests to meetchanges in systems and business needs to tune the performance of incremental load.
• Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Worked with team to perform unit testing of mappings, system testing and user acceptance testing (UAT).
• Worked on Slowly Changing Dimensions (SCD) Type 1, 2 and 3 to keep track of historical data.

Confidential, New York and Tampa FL

ETL Developer (Informatica)

Responsibilities:

• Source to target data mapping, job scheduling, development and testing of Informatica ETL programs.
• Involved in the preparation of High level design documents and Low level design documents.
• Over saw interactions with business users to resolve data questions and anomalies; mentoring of junior staff members; participation in data modeling design sessions, and metadata development.
• Worked extensively across fixed width flat files, handled the null records, exceptional records, space records and gained hands on with data level accuracy.
• Created mappings using various transformations like source qualifier, expression, filter, router, update strategy, lookup, aggregator and sequence generator.
• Generated and routed the data into various target definitions which consists of delimited flat files and table records.
• Used various functions like round, replace and different kinds of date functions to compare the data elements across the feeds for consistency.
• Managed defects, enhancements and new functionality requests to meet changes in systems and business needs.
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.

Confidential, Des Moines IA

ETL/ Informatica Developer

Responsibilities:

• Designing and understanding mappings for extracting & loading data to/from heterogeneous sources including Oracle/DB2/SQL Server databases to optimize data workflows and ensure data quality.
• Responsible for technical design, development, testing, code migration and take ownership of the body of work.
• Designed and created required mappings for consistency check to compare like data elements across the files to assure the consistency of data.
• Created tasks and workflows in the workflow manager and monitored the session properties in the work flow monitor
• Coordinated and managed delivery of interfaces on time with high quality and on budget.
• Transitioned in and retained the technical integration knowledge from external system integrators. Maintained project documentation for integration center of excellence and provide to developers.
• Extracted source data Cobol files using Informatica tools and created mapping using transformation mainly Normalizer, Lookup, Expression.
• Worked with business process experts to map integration requirements to ETL code.
• Managed defects, enhancements and new functionality requests to meet changes in systems and business needs.
• Identified and resolved problems with data processing infrastructure, processes, systems & tools and recommend solutions for improvement and standardization

Confidential

Sr. Executive /Data Analyst

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• Developed UAT testing as requested by the business support team after new patches were implemented to enhance the business usage.
• For Customer system, developed logical & physical data model by defining strategy for Star Schema with Fact & Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Used Informatica as the ETL for extracting data from the flat files on UNIX platform and transforming the data according to the target database and performed loading.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookups and stored procedures.
• Creating source, target, lookups, transformation, session, batches and define schedules for those batches and sessions
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Confidential

System Analyst

Responsibilities:

• Responsible for SQL coding using SQL/PLUS.
• Responsible for PL/SQL programming.
• Developed Stored Procedures, functions, triggers, and packages.
• Created primary Database storage structures (Table Spaces) and objects (Tables, Views, and Indexes).
• Managed the Table Spaces, rollback segments and indexes for applications.
• Coded the scripts for loading the data into Oracle Database from flat files using SQL Loader.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.