SUMMARY:

• About 8 years of IT experience in development, design and implementation with major focus on database and data warehousing applications
• Strong in Data warehousing Concepts, Star Schema and Snowflakes Schema methodologies, understanding business process/requirements.
• Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies.
• Experience with dimensional and relational database design.
• Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle.
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Involved in the configuration of Siebel Analytics/OBIEE Delivers, iBots, Jobs Manager, Cache Manager, Variable Manager and Security Manager (Object level security and Data level security).
• Extensively worked on Extraction Transformation and Loading (ETL) using Informatica 9.5/9.1/8.6.1/8.1/7.1/6.1.2/5.1 (Power Center).
• Experience in tuning Informatica Mappings and Sessions for optimum performance.
• Involved in massive data cleansing prior to data staging.
• Involved in Production support and troubleshooting of Informatica/DAC failures and OBIEE/Siebel Analytics issues.
• Develop processes for cleansing, transforming, extracting, integrating and loading data with use of Datastage.
• Worked in Siebel Analytics and OBIEE Clustered model.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expert in implementing business rules by creating Re - Usable Transformations like Mapplets and Mappings.
• Proficient in using Informatica Server Manager to create & schedule sessions and batches.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Experience using Teradata utilities BTEQ, FastLoad, MultiLoad, FastExport, Tpump, SQL Assistant, and SQL Administrator.
• Experience working with Oracle, PL/SQL and writing stored procedures.
• Worked with testing team to create test cases for unit and system testing.
• Expert in Functional testing, System testing, Regression Testing, and Database testing using SQL Navigator, AQT, Toad and data migration testing.
• Experience in Repository administration (Creating back-up and User Groups).
• Good knowledge in Scheduling ETL Jobs tools like Autosys, Appworx.
• Experience in UNIX shell scripting, CRON, FTP, WFTP and file management in various UNIX environments.
• Experience in development methodologies like RUP, SDLC and Waterfall.
• Post production support, handling new enhancements and customer support.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Highly organized and detail-oriented professional with strong business and technical skills

Technical Skills

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.2/ 3.5.2/3. x, Oracle Designer

Business Intelligence: Siebel Analytics 7.x, OBIEE 10.x, crystal reports, Oracle DBI and BI Publisher

Databases: Teradata V2R12/V2R6/V2R5, Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2000/2000, DB2 UDB, MS Access 2000, Sybase Server 12.x/11.x.

Others: Java, Toad, SQL Navigator, Harvest, Maestro, Autosys, HTML 4.0, DHTML, XML 1.0, SQL, PL/SQL, Rational Clear Quest, Clear Case, Unix Shell Scripting

Confidential, Saint Cloud, MN

Sr. Informatica Developer

Responsibilities:

• Involved in requirement gathering with business users and converted them into mapping documentation.
• Extensively word on Informatica Power Centers tools like Designer, Workflow Manager and Repository Manager.
• Worked with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Union, Rank and more.
• Developed complex mappings and involved in tuning for better performance.
• Designed and executed error handling process using Informatica Debugger.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Identified the Bottlenecks, removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Developed number of Complex Informatica Mappings and Reusable Transformations based on the business rule.
• Involved in creating SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
• Created complex transformations using connected/unconnected Lookups.
• Created Reusable Transformations and Mapplets based on the business rules.
• Involved in Performing Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts to implement ETL process on daily/monthly jobs.
• Involved in creating best practice documents for ETL Process.
• Involved in coordinating with DBA to increase performance of ETL process by creating indexed on target tables as required.
• Collaborated with development and testing team to support end to end testing.

Environment: Informatica 9.1, Teradata V2R12, Oracle 11g, Solaris 10, UNIX Shell Scripting, Toad for Oracle, SQL Assistant for Teradata, DB2

Confidential, Atlanta, GA

Sr. ETL Developer

Responsibilities

• Analyzing the source data coming from different sources and working with business users and developers to develop the Model.
• Involved in Dimensional modeling to Design and develop STAR Schema, Using ER-win to design Fact and Dimension Tables.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mappings and complex transformations (Aggregator, Joiner, Lookup (Connected & Unconnected), Source Qualifier, Filter, Update Strategy, Stored Procedure, Router, and Expression).
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of tests in Customer information, Monthly and Yearly Loading of Data.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extracted data from various sources like Mainframe, Flat Files and Oracle.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Used SQL * Loader for Bulk loading.
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts.
• Created Stored Procedures for data transformation purpose.
• Monitored the sessions using Workflow Monitor.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets.
• Removed bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Created Mappings, Mapplets and Transformations, which remove any duplicate records in source.
• Implemented efficient and effective performance tuning procedures, Performed benchmarking, and these sessions were used to set a baseline to measure improvements against.
• Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.
• Used Calculations, Variables, Break points, Drill down, Slice and Dice and Alerts for creating Business Objects reports.

Environment: Informatica 9.1, Teradata V2R12, Oracle 10g, Solaris 10, UNIX Shell Scripting, Toad for Oracle, SQL Assistant for Teradata, DB2

Confidential, Warren, NJ

Sr. Informatica Developer

Responsibilities

• Participated in all phases including Requirement Analysis; Client Interaction; Design, Coding, Testing and Documentation.
• Understanding High Level ETL Requirement specifications to develop LLD for type-I, SCD Type-II and Type III mappings and done rigorous testing for various test cases.
• Extracted data from SAP r/3 and populated data into Oracle Data warehouse.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression, Normalizer and Update Strategy
• Developed detailed ELT Plan for loading the staging area from the Oracle database and then from Staging area to the Data Warehouse
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area.
• Developed and tested stored procedures, functions and packages in PL/SQL
• Extracted data from various sources like SQL Server, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Created and Executed workflows and Work lets using Workflow Manager to load the data into the Target Database
• Worked on power exchange to create data maps, pull the data from flat files mainframe, and transfer into data warehouse
• Implemented Slowly Changing Dimensions as per the requirements.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.  
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, mappings and sessions.
• Wrote UNIX Shell Scripts for Informatica jobs and Autosys scripts for scheduling the jobs (work flows)
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Scheduling the jobs using Power Center Job Scheduler, and using pmcmd command.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment:

Informatica Power Center 8.6, Power Exchange 8.1, OLAP, OLTP, Oracle 10g, PL/SQL, SQL,T- SQL, SSIS, DB2, UNIX, Business Objects 5.1, Shell script

Confidential, Seattle, WA

Sr. Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model.
• Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank and router transformations.
• Worked with OBIEE Reporting team to understand and analyze the out of box reports for Workforce Profile Dashboards/Reports.
• Worked on the SDE and SIL Mappings for loading the data into Stage and then into the target tables.
• Worked informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Developed informatica mappings and also tuned for better performance.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Good experience on the Out of the Box (OOTB) OBIEE repository and functionalities.
• Application views are built through Harvest Change Manager Tool in desired schema in Teradata Warehouse and used as one of the sources for informatica.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involved in Unit testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
• Worked with many existing Informatica mappings to produce correct output.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Detail system defects are created to inform the project team about the status throughout the process.
• Development is done by following SDLC and later now following RUP (Rational Unified Processing).

Environment: Informatica Power Center 8.6.1/8.1.3 , Oracle 10g, XML, LINUX, UNIX Shell Scripting, Harvest Change Manager, Rational Clear Quest, Windows

Confidential, Auburn Hills, MI

Sr. Informatica Developer

Responsibilities:

• Meet business users to collect and analyze business requirements and provide system enhancement recommendations.
• Worked closely with the end users and decision-makers to develop the transformation logic to be used in Informatica.
• Developed mappings in Informatica to load the data from various sources into Target System
• Extensively worked on Informatica Designer and work flow Manager. Designed and developed various mappings and mapplet’s in Mapping designer and sessions and workflows in Workflow manager to extract data from various sources and load to Oracle database
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup (connected & unconnected lookups), stored procedure, sequence generator and joiner).
• Used other features of Power Center namely pmcmd, pmrep, target override, target load order, Connected and Unconnected look up, Data , index , Persistence Dynamic & Static lookup cache.
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Managed Informatica Domain, Grids and Services.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Optimizing / tuning mappings for better performance and efficiency.
• Used source based , Target based and full Pushdown optimization techniques and Key range , hash function , Round Robin pipeline partioning for better performance
• Migration of Informatica maps extensively involved in migration from Dev to Test and Test Prod.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Backing up Informatica, UNIX on weekly bases.
• SSIS training was given by Microsoft Corporation and comparison with Informatica.
• Used UNIX Shell Scripting to invoke Sessions in the workflow manager
• Created and executed queries directly on Informatica power center repository database. For querying the mapping, mapplet, logs, tasks status on tables.
• Use SQL Trace, TKPROF and EXPLAIN PLAN for performance tuning of oracle DB.

Environment: Informatica 8.1, Shell Scripting, Oracle 9i, DB2, Teradata, MS SQL 2005, TOAD