SUMMARY:

• Over 7+ years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Database and Data warehouse Software Applications
• Hands on experience in Full Life Cycle Development of Data warehouse design Process.
• Experience in all aspects of project development life cycle in Data Warehousing.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access, DB2 and flat files using Informatica.
• Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Extensively worked with Stored Procedures, Triggers, Cursors, Indexes, Functions and Packages.
• Expertise in PL/SQL development and SQL Query tuning for better performance.
• Expertise in development of stored procedures and functions to develop business rules.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases. Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model.
• Proficient in warehouse designs based on Ralph Kimball and William Inmon methodologies.
• Performance Tuning at various levels such as Source, Target, Mapping, Session, and System.
• Implemented complex business rules in Informatica by creating re - usable transformations, robust mappings/mapplets.
• Worked on UNIX-shell Scripting for Pre-Session, Post-Sessions tasks and also automated the scripts using a scheduling tool.
• Experience in using Workflows, Worklets and Mapplets.
• Used constraint based loading to load the targets
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.
• Excellent Technical and communication skills.
• Experience in coordinating with onsite offshore teams.
• Extensive Business Knowledge in Retail, Finance, CRM and HR Services.
• Strong in Analyzing Business spec and Developed Test Plans, Test Scripts and Test Cases and Execute them.
• Significant exposure to automation test tools like Test Director and QTP.

TECHNICAL SKILLS:

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin 7.3

Databases: Oracle 11g/10g/9i, SQL Server, Flat Files, DB2, EXPLAIN PLAN, Stored Procedure, Triggers, Materialized Views.

ETL: Informatica Power Center 9.1/8.6/7.1. PowerExchange, Data Profiling, Data Cleansing, OLAP, OLTP, Autosys

Programming: SQL, PL/SQL, Transact SQL, Shell, Java, XML

Environment: Unix-AIX 5.2/4.3,Solaris 10, Win XP, VMware

OS Tools: Putty

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

ETL Informatica Developer

Responsibilities:

• Work with Business User and Analyst to identify the source systems based on the business requirement.
• Co-ordinate with Data Architects / DBAs to create appropriate table structure in Dimensional Model.
• Develop Informatica Mappings to extract data from various sources such as MS Access, MS Excel, Oracle Database and Flat files then apply transformation rules and load into Oracle tables.
• Create Source Definitions, Shortcuts and Labels to properly migrate from Dev to UAT to PROD.
• Used key transformations such as Lookup, Joiner, Source Qualifier, Update Strategy, and Aggregator to effectively provide the correct data and improve overall performance.
• Worked with DBAs to improve table performance.

Environment: Informatica Power Center 8.6, Oracle 11g, Oracle SQL Developer, MS Excel, Flat Files, MS ACCESS, PRIMAVERA, M-II, SUCCESS, PACES, Windows XP

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update strategy and Sequence generator etc.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Extensively utilized the Debugger utility to test the mappings.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database.
• Defined Mapping parameters and variables and Session parameters according to the requirements and performance related issues.

Environment: Informatica Power Center 8.6, Oracle 10g/11g, Flat files, Oracle SQL Developer, Informatica Scheduler, Mercury, Java, Visio, PL/SQL, SQL, UNIX (AIX), Linux, Unix Sell Scripting, Windows XP

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data sources for data warehouse and to document business needs for decision support systems.
• Performed data manipulations using various Informatica transformations like Joiner,
• Rank, Router, Expression, Lookup, Aggregator, Filter, Update Strategy, Sequence generator, etc.
• Extensively used Data profiler to analyze the source data.
• Worked with the ETL architect to perform the load balance test and stress test.
• Worked with marketing people to understand the requirements in a closer way.
• Worked with fixed width and delimited flat files as major part of the data is coming from the flat files.
• Worked with the data architects to understand the conceptional, logical and physical models of the mart.
• Extensively utilized the Debugger utility to test the mappings.
• Written SQL overrides in source qualifier according to the business requirements.
• Extensively involved in Database tuning and Database performance.

Environment: Informatica Power Center 8.1, Oracle10g, TOAD, PL/SQL, SQL*Loader, DB2, MS Access, ERwin, UNIX, Windows XP

Confidential, Cincinnati OH

Informatica Developer

Responsibilities:

• Understand the business needs and implement the same into a functional database design using Erwin.
• Data Quality Analysis to determine cleansing requirements.
• Documented data conversion, integration, load and verification specifications.
• Developed complex mappings using corresponding Source, Targets and Transformations, which were optimized for maximum performance.
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, filter, sequence generator, joiner, aggregate, and expression transformation.
• Created reusable transformations and Mapplets in the designer using transformation developer and Mapplets designer tools.
• Created different parameter files and started sessions using these parameter files using pmcmd command. Session parameters, mapping parameters, and variables are changed at run time.
• Modified the PL/SQL stored procedures to meet the changing standards.
• Generated completion messages and status reports using Informatica Server Manager.
• Created and monitored Batches and sessions using Informatica Server Manager.
• Worked in the performance tuning of the programs, ETL procedures and processes.
• Developed shell scripts to automate the update processes.

Environment: Informatica Power Center 7.1, TOAD, Flat Files, Oracle 10g, SQL, PL/SQL, UNIX, Windows XP

Confidential, Denver, CO

Oracle Developer/Production Support

Responsibilities:

• Requirement gathering and analysis.
• Participate in Data Model design
• Create design specifications including source to target mappings for Mainframe/Operational Source to Stage, Stage to ODS and form ODS to Data warehouse tables.
• ETL development in Informatica, Code Migration from different Repositories and Data Conversion.
• Integration of source data from multiple systems and building data warehouse
• Daily monitoring & support of load to the ECS Data Warehouse

Environment: Informatica Power Center 7.1, Oracle 9.2.0, Toad, AIX UNIX, VISIO, Crystal Reports, DB2, Windows XP

Confidential

Oracle Programmer

Responsibilities:

• Designed and developed data tables to store employee payroll information.
• Interacted with end users to prepare system requirements.
• Identify the data and activities that need to be maintained.
• Designed and developed all the tables, views for the system in Oracle.
• Created indexes, sequences, constraints.
• Developed Application programs using Oracle PL/SQL Packages, Procedures, Functions and Database Triggers.
• Worked with analysts, users, and other IT technical professionals to understand requirements.
• Supported technical teams involved with ORACLE issues and operations.
• Involved in Implementation and production Support of the system.
• Responsible for unit testing and documenting the test results.

Environment: Oracle 9i, Visual Basic, SQL, PL/SQL, MS Access, MS Office Tools, Windows 2000.