SUMMARY

• Eight years of IT experience with emphasis on business requirements analysis, application design, data modeling, development, implementations, testing and project coordination of applications
• Extensively involved in ETL Data warehousing using Informatica PowerCenter 9.1/8.6.1/8.1/7.1.2/7.0/6.2/5.1 as ETL tool
• Strong experience in Informatica client tools - Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor
• Strong in Source to Target data Mapping and CDC (Change Data Capture) using Slowly Changing Dimension Mapping, incremental aggregation etc.
• Experienced in installing and maintaining PowerCenter on UNIX/Windows, for Oracle 10g/11g
• Highly skilled with the Integration of various data sources like Oracle 9i/10g/11g, DB2, SQL Server, Flat files, Excel sheets, XML and COBOL files
• Extensive experience in writing complex queries using SQL and PL/SQL programming units like Triggers, Stored Procedure, Functions and Packages in Unix and Windows environment
• Skilled in tuning of SQL using tools like Explain Plan, Tkprof etc.
• Experience in writing and deploying UNIX Shell Scripts for scheduling various data cleansing scripts and loading process
• Extensive noledge of network administrator tasks such as Active directory, DHCP, Web hosting
• Exceptional analytical and problem solving skills
• Team Player with the ability to communicate effectively at all levels of the development process
• Ambitious and hardworking with commitment to excellence

TECHNICAL SKILLS

Operating System: UNIX(Sun Solaris, Linux, HP-UX), MS DOS 6.22, Windows NT/XP/2000/98/95

ETL Tools: Informatica PowerCenter 9.1/8.x/7.1/6.1, Informatica PowerMart 4.7/5.0, Data Stage

BI Tools: Cognos 8/7.0/6.0/5.x, MR1/MR2/8.2 (Report Studio, Query Studio)

Data Modeling: Erwin 7x/8x

Reporting Tool: Cognos Reporting, Data Reports

Languages: PHP, C, C++, SQL, PL/SQL, HTML, XML, XSLT, shell scripts, COBOL, Java, Java Script, VB Script, Perl

Database: Oracle 11g/10g/9i/8i, MS SQL Server 2000/7.0/6.5 , Teradata, MS Access

Microsoft Suite: Excel, Word, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Sr. Informatica Developer/Designer

Environment: Informatica PowerCenter 9.1/8.6 (Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), Oracle 11g/10g, Toad Oracle Designer, Business Object 6.x, SQL Server, PL/SQL, UNIX Shell Scripting.

Responsibilities:

• Worked with business analysts and DBA for requirements gathering, business analysis and to design the data marts
• Worked with Data Modelers in the creation of the ETL source to target mapping document with the transformation logic
• Analyzed the current system for the core properties
• Analyzed the impact of changes on the existing systems
• Created mappings/sessions/workflows for moving the data from different sources into Oracle database
• Used INFORMATICA (Power Center 9.1) tool as ETL tool for constantly moving the data from different sources into staging area
• Worked with heterogeneous sources from various channels like Oracle, DB2, SQL Server and Flat Files
• Created Unix scripts to process several flat file feeds
• Developed scripts using PMCMD command to run the Workflows, Sessions from UNIX environment which are called in Autosys jobs
• Extensively worked on various Transformations like Joiner, Lookups (connected and unconnected), Update strategy, Sequence generators, Routers, Aggregators, Union in the development
• Worked on creating Mapplets and reusable transformations where necessary
• Developed the sessions and workflows in the workflow Manager
• Extensively worked on performance tuning of ETL mappings and sessions
• Used TOAD to run SQL queries and to validate the data.
• Troubleshoot and tune SQL using EXPLAIN PLAN
• Worked on the deployment of the jobs to Production
• Worked closely with the testing team and the user team to resolve bugs in the UAT
• Analyzed session log files if the session failed and fixed the Issues that come out of UAT
• Involved in reviewing the Test Cases written by the peers
• Provided production support of the processes

Confidential, Cleveland, OH

Sr. Informatica Developer/Designer

Environment: Informatica PowerCenter 8.6.1 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), Power Mart, Power Connect, Power Analyzer, Oracle 11g/10g/9i, PL/SQL, Toad, XML, SQL*Loader, Teradata, SQL Server, Erwin 7.2, Unix,Win XP.

Responsibilities:

• Worked with business analysts and DBA for requirements gathering, business analysis and to design the data marts
• Involved in customizing data models for Data Warehouse supporting data from multiple sources on real time
• Involved inLogical and Physical datamodels that capture current/future state data elements and data flows usingErwin
• Used advanced techniques of Informatica to load data fromMS SQL Server, XML files, Flat filesinto the targetOracledatabase
• Designed reusable transformations and mapplets
• Implemented changes in Slowly Changing Dimension tables
• Extensively worked with transformationsLookup, Update Strategy, Expression, Filter, Stored Procedures, Routerand others
• Designed and developed source to stage mappings/sessions/workflows
• Designed and developed stage to ODS mappings/sessions/workflows
• Designed and developed ODS to data mart mappings/sessions/workflows
• Evaluated, designed, applied and supported Business Intelligence technical solutions using Oracle Business Intelligence Enterprise Edition (OBIEE) /Siebel Analytics
• Imported external data (flat files)into Oracle tables using SQL*Loader
• Coordinated with IT department and external auditors during SOX IT testing
• Used debugger to test thedata flowbetweenSource and Targetand to fix the invalid Mappings
• Worked on different tasks in Workflows likesessions,events raise,event wait,decision-mail,command,worklets,Assignment,Timerandschedulingof the workflow
• Used Altova XML-Spy to create tables based on the XSD
• Worked on Custom views in creating the views in the XML wizard based on the Global elements
• Developed UNIX shell scripts and PL/SQL procedures
• Extensively worked on performance tuning of ETL mappings and sessions
• Used TOAD to run SQL queries and to validate the data
• Documented all mappings, created effective test cases by performing unit testing and Integration testing to ensure the successful execution of data loading process
• Analyzed session log files if the session failed and resolved the errors
• Provided technical assistance by responding to inquiries regarding errors or questions with programs/interface
• Tested the data and data integrity among sources and targets using Unit Testing
• Associated with Production support team in various performances related issues
• Created number of standard reports and queries based on the existing classes/objects

Confidential, Okemos, MI

Sr. Informatica Developer/Designer

Environment: Informatica PowerCenter 8.6, Oracle 10g, MS SQL Server 2008, SQL, PL/SQL, ERWIN, UNIX Shell Scripting, Teradata, Mainframes, JCL, VSAM, XML, Cognos 8.0, Perl, Informatica 8.x Web services.

Responsibilities:

• Interacted with business users in the analysis and development phase for requirement gathering
• Parsed high-level design specifications to simple ETL coding and mapping standards
• Defined various Facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process
• Maintained the batch processes using Unix Shell Scripts
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements
• Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations
• Worked with Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible
• Wrote, tested and implemented the PL/SQL Triggers, Stored procedures, Functions and Packages
• Migrated and upgraded Informatica PowerCenter version 8.0 to 8.5
• Performed performance tuning of the Informatica mappings using various components like, Parameter files, Variables and Dynamic Cache
• Maintained Development, Test and Production mapping migration using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting
• Created List Reports and Cross Tab Reports and Drill Through reports using Cognos Report Net.
• Performed unit testing entire process flow with other team members.
• Analyzed OLAP cubes data to compare actual results to budget results, to assess performance in Analysis studio.
• Wrote SQL Scripts and PL/SQL Scripts to extract data from Databases.
• Scheduled and Distributed reports through Schedule Management in Cognos Connection.

Confidential, Orlando, Florida

Informatica Developer/Designer

Environment: Informatica PowerCenter 8.6, WorkFlow Designer, PowerCenter Designer, Autosys, Repository Manager, PowerMart, Oracle10g, SQL Server, PL/SQL, SQL Loader, Perl, UNIX Shell Scripting, Windows NT/2000/XP, Business Objects 6.5

Responsibilities:

• Analyzed business processes, functions, existing transactional database schemas and star schema models to support the users reporting needs and requirements
• Converted the business rules into technical specifications for ETL process
• Created Conceptual data model by gathering the business requirements from various sources like discussions with functional teams, business analysts and from business documents
• Designed logical and physical database designs using Erwin Tool
• Used SQL * Loader to load the data from Flat files to Oracle for Comm Dashboard system
• Worked extensively in Performance Tuning with existing mappings by analyzing data flow
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions
• Involved in modifying the stored procedure with line of business
• Proficiently understood business processes / requirements and translating them into technical requirements
• Modified a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data mart
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator and Joiner on the extracted source data according to the business rules and technical specifications
• Created reusable transformations and Mapplet and used with various mappings
• Extensively used XML targets, XML sources, XML generator transformation and XML parser transformation
• Created Connected, Unconnected and Dynamic lookup transformation for better performance and increased the cache file size based on the size of the lookup data
• Done various optimization techniques in Aggregator, Lookup, Joiner transformations
• Developed and Implemented Informatica parameter files to filter the daily data from the source system
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Created Test cases for Unit Test, System Integration Test and UAT to check the data
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process
• Wrote shell scripts to perform pre-session and post-session operations
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor
• Troubleshot the loading failure cases, including database problems
• Used Autosys scheduling tool to schedule and monitoring the jobs

Confidential, Galveston, TX

ETL Informatcia Developer/Consultant

Environment: Informatica PowerCenter 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Cognos 8.0, DB2, Oracle 10g/9i, UNIX Shell Scripting, TOAD Oracle Designer.

Responsibilities:

• Analyzed user requirements for the system
• Responsible for verification of functional specifications and review of deliverables
• Designed and Created data cleansing, validation and loading scripts for Oracle Data Warehouse using Informatica PowerCenter 6.1
• Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, MappletDesigner, and Informatica Repository
• Created reusable transformations and mapplets to use in multiple mappings
• Used debugger to test the data flow and fix the mappings
• Created and monitored workflows and tasks using Informatica PowerCenter Workflow Manager
• Designed the Data Model using Erwin and integrating E-R models with the Oracle Database
• Analyzed newly converted data to establish a baseline measurement for data quality in Data Warehouse
• Imported Relational metadata extract and load relational data
• Created global repository, Groups, Users assigned privileges using repository manager
• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica
• Setting up batches and sessions to schedule the loads at required frequency using PowerCenter server manager
• Involved in Version control of the jobs to keep track of the changes in the Development Environment
• Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers using PowerPlay in Cognos
• Responsible for deploying and developing business intelligence applications with the use of Cognos
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary
• Developed Unit test cases for the jobs
• Provided assistance during user testing (interaction with the users)

Confidential, Auburn Hills, MI

ETL/ Informatica Developer

Environment: Informatica 6.x/7.x (PowerMart/ PowerCenter), PowerConnect, WorkFlow Designer, Powercenter Designer, Repository Manager, Cognos 8.0, XML, DB2, Oracle 9i, PL/SQL, Teradata, Mainframes, SQL*Plus, TOAD, SQL Server 2000, Windows NT 4.0, UNIX, Erwin

Responsibilities:

• Interacted with business user in the analysis and development phase and was involved in requirement gathering, prepared various documents like Technical design documents, Integration test plan, unit test plan and resolved business related issues
• Worked closely with System Analyst to identify various tables and the layout of data, understanding the complex business rules, identify appropriate sources for Data Warehouse, document business needs and implementing the data transformation methodology
• Extracted data from variety of sources like mainframe tables, flat files, SQLServer and loaded to the Data Warehouse
• Used Type2 mapping to update slowly changing dimension table to keep full history
• Developed reusable mappings, mapplets, sessions and worklets
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation
• Worked on databases implementing complex table joins, aliases, views, aggregate conditions to implement business logic
• Created test cases for Unit Test, System Integration Test, check the data quality issues, removing defects and to ensure the successful execution of data loading process
• Responsible for monitoring all the sessions that are scheduled, running completed and failed
• Involved in debugging the Mappings that failed and fixing
• Performed performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache

Confidential, Denver, CO

DW Informatica Developer/ Data Analyst

Environment: Informatica PowerCenter 6.x (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager),Oracle 9i, Teradata, PL/SQL,ODI, Erwin, Unix commands, Excel and shell scripting, MS Windows XP professional 2002,UNIX.

Responsibilities:

• Analyzed source data and gatheird requirements from the business users
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules
• Audited small business loan applicants to determine cash flow, debt levels and risk factors to assess credit worthiness
• Experience in Data modeling and design of Data Warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables
• Extensively used ETL to load data using PowerCenter from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle
• Design and Development of ETL routines, using Informatica PowerCenter within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done
• Analyzed and determined the most complex transformations
• Used Update strategy and Target load plans to load data into Type-2 Dimensions
• Designed the complete workflow for all the extracts (mappings) to serve the business requirements with dependency hierarchy
• Developed, monitored the workflows and responsible for performance tuning of the staging and 3NF workflows
• Responsible for monitoring all the sessions that are scheduled, running completed and failed
• Involved in debugging the Mappings that failed
• Created PL/SQL packages, Stored Procedures and Triggers for data transformation on the Data Warehouse
• Created the parameter file to run the workflow
• Created Users, user groups, database connections and managed user privileges using supervisor
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels
• Created Snapshots, Summary tables and materialized views in Database to reduce the system overhead
• Developed and maintained Reports using Business Objects
• Involved in designing BO reports & Universe & guiding designers and developers for each component
• Generated, published and scheduled reports in Web Intelligence

Confidential, Cincinnati, OH

Informatica Developer

Environment: Informatica (PowerCenter 5.1), PowerMart, Oracle 9i, PL/SQL, DB2, UNIX Scripting (Ksh), Business Objects 5.1, Teradata SQL, Teradata Utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD)

Responsibilities:

• Involved in the analysis, design, coding and testing of the data analysis and warehouse build phase (ETL)
• Responsible for the design of mapping and delivering the business data for the Data Warehouse from existing data sources
• Created Complex mappings with transformations involving expressions, lookup, rank, formalizer, update strategy and stored procedure
• Developed Mapplets, Mappings and configured sessions
• Developed reusable transformations to load data from flat files and other data sources to the Data Warehouse
• Used Informatica Data Migration to decrease the risk and minimize the errors
• Creating batches and sessions and optimizing the loading process with partitioning and caching
• Designed the ETL processes using Informatica tool to load data from Oracle, flat files into Teradata
• Trapping Data Errors
• Performance Tuning of Sessions and Mappings
• Assisted operation support team for transactional data loads in developing SQL Loader & Unix scripts
• Created reports using Business Objects

Confidential

Data Modeler/ETL Developer

Environment: Informatica PowerCenter 5.1, PowerMart, Workflow Manager, Workflow Monitor, Cognos 6.x, Oracle 8i, Erwin, UNIX Shell Scripts, TOAD, SQL * Loader, Windows NT, Teradata.

Responsibilities:

• Analyzed the systems, architecture, met with end users and business units in order to define the requirements
• Involved in the requirement definition and analysis in support of Data Warehousing efforts
• Developed ETL mappings, transformations using Informatica PowerCenter
• Extensively used Informatica tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer,
• Implemented various Informatica transformations like Expression, Filter, Aggregator, Router, Ranker, Update Strategy, Joiner, Lookup, Sequence generator, Stored Procedure and Source Qualifier to load the data from Staging area to DW
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Checked the accuracy of data loaded into Teradata and assured the linkage of keys on the tables for the various bank systems
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Teradata database
• Involved in the Performance Tuning
• Created and ran sessions and workflows using Workflow Manager
• Monitored the sessions and workflows using Workflow Monitor
• Trouble shooting of connectivity problems
• Looked up and read session, event and error logs for troubleshooting
• Helped in generating reports using Cognos Power play