SUMMARY

• SDLC: 7+ years of IT experience in Analysis, Design, Development and Implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies
• Data Warehousing: 7 years of experience in Data Warehousing using Informatica ETL, Informatica Power Mart/Center, Informatica Power Connect, FACT Tables, Dimension Tables, Star Schema Modeling, OLTP, OLAP, MS SQL Server, MS Access, Erwin
• Databases: 6 years of solid database experience in Oracle, Teradata, MS SQL Server (database triggers, materialized views, In - line views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, SQL Developer and TOAD
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment
• Experience in Design document preparation and presentation to architect for signoff.
• Involved in requirement gathering, analysing, and documenting business requirements, functional requirements and data mapping sheets.
• Closely work with Autosys team for job scheduling and job dependencies.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De-normalization Concepts.
• Involved in writing shell scripts in UNIX for Informatica ETL tool to run the sessions.
• Experience in working with data warehouses and using Informatica PowerCenter 9.0.1 (Designer, Repository Manager, Workflow Manager and Workflow Monitor).
• Experience in working with XML, and Flat Files.
• Proficiency in data warehousing techniques forSlowly Changing Dimensionphenomenon, surrogate key assignment andChange Data
• Ability to work independently in tight schedules and efficient in meeting deadlines utilizing critical thinking and discretionary decision-making skill set.
• Excellent Analytical, Communication and Interpersonal skills. Good experience in developing applications using Agile Scrum methodology.
• Knowledge of SAP Business Warehouse BW 3.0/BI 7.0, Business Explorer (BEx), SAP R/3 and ETL process.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.x/8.x/7.x, Power Mart 6.2/5.1.1, Workflow Manager, Work flow Monitor, Datastage, Datamart, OLAP, OLTP, Mapplet, Transformations, SQL*Plus, SQL*Loader

Databases: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer, Visio and Sybase Power Designer.

Programming: Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C.

Tools: Rational Clear Case, Rational Clear Quest, Visio 2003, Visual Source Safe, HP Quality Center 10.00, Test Director, TOAD, PL/SQL Developer, CVS, Autosys, DB Visualizer and MS Access

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Actively involved in understanding the environment and the business requirement.
• Worked closely with the Users in order to understand the requirement and performed Gap Analysis.
• Informatica Designer tools are used to design the source definition, target definition and transformations to build mappings.
• Used Update strategy and Target load plans to load data into Type-2 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica Power Center
• Extensively used Informatica scheduler to schedule Informatica workflows
• Developed mappings and mapplets using Informatica Designer from various transactional source systems
• Used various transformations in the mappings and applied surrogate keys on target table
• Utilized Lookup, Aggregator, Joiner, Union, Expression, Filter, Update strategy, Normalizer, Router, Source Qualifier transformations to model various standardized business processes and implement business logic using Informatica.
• Used Shell Scripts to execute post-session and pre-session commands.
• Extensively used mapping variables, mapping parameters and parameter files in ETL mappings.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Involved in doing Unit Testing, Integration Testing and System Testing
• Increased Code Reusability using shortcuts, Mapplets, Reusable Transformations, Re-Used mappings, Reusable Sessions and Work lets to reduce redundancy in code
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse
• Monitoring the ETL jobs and fixing the Bugs.
• Provided reliable, timely support of integration, performance and user acceptance testing processes
• Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels.

Environment: Informatica Power Center 9.1/8.6, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Oracle 11g, Windows 2000, Toad for Oracle, Oracle SQL developer, Unix.

Confidential, Deer field, IL

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0
• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup
• Created events and tasks in the work flows using workflow manager
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Developed mappings for policy, claims dimension tables.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them using Autosys.

Environment: Informatica Power Center 9.1, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL,TOAD, SQL * Loader, Sun Solaris 2.6, UNIX Shell Scripting, Autosys

Confidential, Philadelphia, PA

ETL Developer

Responsibilities:

• Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members.
• Developed mapping parameters and variables to support SQL override.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Worked and Implemented Pushdown Optimization (PDO) to optimize performance issues of complex mappings involving numerous transformations and hence degrading the performance of the session.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Exhaustive testing of developed components.
• Worked on the various enhancements activities, involved in process improvement.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, Workflow Manager, Workflow Monitor.
• Worked on Change data Capture (CDC) using CHKSUM to handle any change in the data if there is no flag or date column present to represent the changed row.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Played a major role in coordinating Admin and DBA Team for data exports, imports and migration between different environments.
• Created various UNIX Scripts for Job automation of Data loads.
• Created Test cases for Unit testing, System Integration Test and UAT to check the data.

Environment: Informatica 9.1(Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica 8x, Oracle 10G, UNIX, PL/SQL Developer, Advanced Query Tool, UNIX AIX 5.1.

Confidential

Data Warehouse Developer

Responsibilities:

• Analyzed specifications and identified source data needs to be moved to Data Mart, participated in the design team and user requirement gathering meetings.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse. Designed star schema using Dimension modeling using the ER-win design tool.
• Extensively used ETL (Informatica) to load data from source (Flat files) to target Oracle database.
• Lookup, Aggregator, sequence, joiner and other transformations are used in populating data process.
• Created Informatica Mappings with PL/SQL procedures/functions to build business rules to load data.
• Involved in scheduling the Informatica Workflows.
• Conducted Performance tuning of application by modifying the SQL statements and using Explain Plan and TOAD Software.
• Used the Oracle stored functions/procedure/Packages.
• Involved in developing the requisite reports (list, grouped list, cross-tabs etc.) using Business Objects.

Environment: Informatica Power Center 5.1, Oracle 8i, PL/SQL, SQL Server 7, Toad, Business Objects 5.1, Windows NT, MS Access.

Confidential

SQL Developer

Responsibilities:

• Developed and modified complex SQL Queries and Stored Procedures as per business requirements.
• Normalized the tables to minimize redundancy and dependency.
• Translated business requirements into database applications.
• Perform and execute data extraction, transformation and loading.
• Divided large tables into smaller tables by defining relationship between them.
• Provided ad-hoc queries as per the business needs.
• Generated DDL Scripts for generating Tables, Views and Functions etc.
• Created Indexes to speed up the queries.
• Resolved and troubleshoot complex issues.
• Document all Technical Specifications

Environment: Oracle 7.X, SQL, PL/SQL, Windows NT.