SUMMARY

• Ten+ years of IT experience as an ETL Developer/Business Intelligence Developer which includes Six plus years of strong Data Warehouse Developer experience in Informatica PowerCenter 8x, 7x, 6.2/6.1, 5.1 environments.
• Strong experience in Siebel Analytics Server, Siebel Answers, creating Dashboards and Reports.
• Used DAC to create, configure, run, and monitor ETL for the Siebel Relational Management Warehouse(SRMW).
• Strong technical knowledge of Siebel Analytics, Admin tool, dashboards, configuring dashboard, user, report level security, metadata tools, and user interface designs.
• Strong experience with PL/SQL Coding, Normalized Database creation in relational databases like Oracle 8i/9i, MS - SQL Server 7.0, DB2 UDB, Sybase 11.5/11.2. Expert in writing optimized PL/SQL, SQL, triggers, and cursors in Oracle 9i/8i. Expertise in performance and tuning of triggers, stored procedures, queries.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional modeling.
• Strong experience in UNIX scripting.
• Excellent working knowledge of XML, DTD and XML Schema technologies.
• Expertise in performance and tuning of Informatica mappings and sessions for better performance.
• Experience in monitoring the various phases involved in SDLC as well as fine-tuning of the System after getting it live.
• Experienced in Software Engineering Modeling with the help of case tools and using Rational Rose for creating the Requirement Document and UML creation.
• Ability to understand, analyze and assess a wide variety of complex business and/or interpersonal issues. Is able to draw conclusion from complex situations and recommend and execute a course of action in a both timely and decisive manner.
• Contributes to the creation of a team-based, collaborative environment, promoting candor and receptivity, clarity of purpose, and high commitment to achieve business goals. Promotes team effectiveness by fostering a trusting and supportive partnership with others.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 8x, 7x/6.1, 5.1, DataStage

Data modeling: Erwin, Visio, System architecture.

Databases/Tools: Teradata, Oracle 8i/9i, MS SQL Server 2000, MySQLSybase

BI Tools: Business Objects, Cognos

Operating Systems: UNIX, Linux 7.0+, Macintosh 9+, Windows 95/98/2000/XP

Software Engineering Tool: Rational Rose, Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. ETL Developer

Responsibilities:

• Analyzed the system, check the processes and improve the performance.
• Maintain the daily schedules for the loads.
• Work on the mapping upgrades and standardize the migration process.
• Support the application for failures and outages.
• Work on the mappings for the changes and enhancements.
• Collect the performance statistics for the existing applications and loads.
• Work on the performace improvement for the database objects like triggers, functions etc.
• Daily maintance meetings to identify the issues.
• Extensively used SQL Developer and TOAD tools to execute SQL scripts and track performance through Explain Plans.

Environment: ETL: Informatica PowerCenter 8.6, Database: Oracle 10g/11g

Confidential, CA

Sr. Tech Lead/Architect

Responsibilities:

• Analyzed the system, met with end users and business units in order to define the requirements.
• Implemented the OBIA solution for the Fiancials and Procurement and Spend Analytics for Peoplesoft.
• Design and developed the Data Model for Peoplesoft RMS, PowerPlant and Drop.
• Responsible for creating all facts and dimensions for RMS, DROP and Powerplant streams.
• Responsible for Data Analysis, Data Mapping, Data Profiling and Source-To-Target Mapping.
• Assisted in Installation and configuration of Informatica Power center 8.6. (Domain, Grid, Nodes, Repository and Integration services).
• Setup development offshore team and managed/coordinate them throught the life cycle of project.
• Solely responsible for scheduling the Informatica mappings using DAC
• Architect the frame work for the BI load management and different environments at the Client Site.
• Setup the team for development and support for the project.
• Created Subject areas, tasks, Task Groups, Execution Plans for all the Full and Incremental
• Loads and supported them.
• Created Complex OBIEE reports based on Presentation Variables, Session Variables in the
• Dashboards according to business requirements.
• Created the Repositories (.rpd) metadata with complete Physical, Business and Presentation layers and also built the RPD metadata dictionary
• Developed various report output formats such as tables views, charts, pivot tables and Compound.
• Created Project Plans and Documentation for the project.
• Steamline the Project and created the test cases for the successful UAT and Production migration.

Environment: ETL: Informatica PowerCenter 8.6, Scheduling: DAC 7.9.6.2, Database: SQL server 2008, Sources: PeopleSoft, Flat files, Reporting tool: OBIEE 10.1.3.4.1.

Confidential, Irving, TX

Sr. ETL Developer

Responsibilities:

• Understanding and identify the requirement passed on by Data Analyst.
• Create a business logic for steps involved in loan modification.
• Used Informatica as an ETL tool to write codes for Data movement
• Gathering the requirements from the users and customers for DTS conversion.
• Converting the DTS jobs into informatica mappings and workflows.
• Automating the informatica jobs using UNIX shell scripting.
• Upgrading Informatica Hotfix to 10.
• Creating informatica logic using various transformations and store procedures.
• Testing and validating data and Informatica process.
• Create a ETL architechture for the loading of data in the warehouse.
• Creating documentation and testing plan for the conversion.
• Loading data into Teradata using its utilities like Tpump, FastLoad and MLoad.
• Using informatica workflow tasks and UNIX scripts for sending notifications and e-mails.
• Creating Reports for the improvement and enhancement of the projects.
• Creating UAT for the users and the customers.
• Simplified the process.

Environment: Informatica PowerCenter 8x, Oracle, SQL Server, Sybase,Teradata, Unix, Erwin.

Confidential, Birmingham, AL

Sr. Data Engineer

Responsibilities:

• Understanding the role and functioning of SQL DTS jobs.
• Gathering the requirements from the users and customers for DTS conversion.
• Converting the DTS jobs into informatica mappings and workflows.
• Automating the informatica jobs using UNIX shell scripting.
• Upgrading Informatica Hotfix to 10.
• Creating informatica logic using various transformations and store procedures.
• Testing and validating data and Informatica process.
• Create a ETL architechture for the loading of data in the warehouse.
• Creating documentation and testing plan for the conversion.
• Loading data into Teradata using its utilities like Tpump, FastLoad and MLoad.
• Using informatica workflow tasks and UNIX scripts for sending notifications and e-mails.
• Creating Reports for the improvement and enhancement of the projects.
• Creating UAT for the users and the customers.
• Simplified the process.

Environment: Informatica PowerCenter 8x, Oracle, SQL Server, Sybase,Teradata, Unix, Erwin.

Confidential, Los Angeles, CA

ETL Architect

Responsibilities:

• Upgradation of Siebel analytics 7.8.5 BI application to OBIEE BI application speciific to Sales, Service & Marketing modules for Fox Home Entertainment Department.
• Create a ETL architechture for the loading of data in the EDW on Teradata.
• Build Siebel SDE and SIL mappings using Informatica Designer tools.
• Work with the Cataman team to clean the data and organize the data for creating a analytic environment for the new territory.
• Extensive experience defining and rationalizing complex data models within a Teradata data warehousing environment.
• Provide a support for Data maintaince in the warehouse and monitor all the Informatica mappings.
• Created the detailed ETL design documentation for the project.
• Tune the Informatica mapping and performance tunning of Teradata database.

Environment: Informatica PowerCenter/PowerMart 8x, PowerExchange, Teradata, Unix, Erwin

Confidential

Tech Lead

Responsibilities:

• Designing the warehouse for the analytical reporting purpose using Erwin and System Architecture.
• Creating Design Doc for the Data Model and impelenting it.
• Create a ETL architechture for the loading of data in the data model.
• Builds and maintains the EDW logical and physical models in the context of the Teradata.
• Extensive experience defining and rationalizing complex data models within a Teradata data warehousing environment.
• Used Informatica PowerCenter 8.1.1 and its components for ETL mappings.
• Work with the LCMT team to clean the data and organize the data for creating a analytic environment.
• Provide a support for Data maintaince in the warehouse and monitor all the Informatica mappings.
• Created the documentation for designing.
• Created a documentation for ETL Architecture and mappings.
• Worked as with the team to provide reports for Finance department using Sieble analytics.

Environment: Informatica PowerCenter/PowerMart 8.1.1 (Work Flow Manager, Work Flow Monitor, Designer), Oracle, Unix, Erwin, System Architecture, Sieble Analytics.

Confidential, Oakbrook, IL

Sr. Informatica Developer

Responsibilities:

• Developing the logic and ETL mappings according to the business requirements.
• Worked with Business Analysts and DBA’s to understand the business requirements. Creating and improving the technical design documents for better implementation of the project.
• Used Informatica PowerCenter 7.1 and its components for ETL mappings into databases.
• Worked on all components of Informatica tools as Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer and Server Manager.
• Enhanced the performance of mapping with the use of lookup override and SQL override feature in Informatica.
• Converted the PL/SQL logic into informatica mappings.
• Worked with Informix and trillium.
• Completed documentation in relation to detailed work plans and mapping documents.

Environment: Informatica PowerCenter/PowerMart 7.1 (Work Flow Manager, Work Flow Monitor, Designer), Oracle, Unix, Trillium 7.7

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Developed various Informatica mappings, tasks, workflows
• Completed documentation in relation to detailed work plans and mapping document.

Environment: Informatica PowerCenter/PowerMart 7.1 (Work Flow Manager, Work Flow Monitor, Designer), Oracle, Windows NT

Confidential, Rolling Meadows, IL

Sr. Informatica Developer

Responsibilities:

• Implementing Project life cycle - by analyzing the production implementation, and identifying the sources and source data validation. Developing the logic and ETL mappings according to the business requirements.
• Worked with Business Analysts and DBA’s to understand the business requirements. Creating and improving the technical design documents for better implementation of the project.
• Used Informatica PowerCenter 7.1 and its components for ETL mappings into databases.
• Worked on all components of Informatica tools as Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer and Server Manager.
• Enhanced the performance of mapping with the use of lookup override and SQL override feature in Informatica.
• Completed documentation in relation to detailed work plans and mapping documents.

Environment: Informatica PowerCenter/PowerMart 7.1 (Work Flow Manager, Work Flow Monitor, Designer), Oracle, SQL Server, Windows NT

Confidential, Bannockburn, IL

Sr. Informatica Developer

Responsibilities:

• Used Informatica PowerCenter 7.1.3 and its components for ETL mappings into different databases targets.
• Implementing Project life cycle - by analyzing the production implementation, and identifying the sources and source data validation. Developing the logic and ETL mappings according to the business requirements.
• Worked with Business Analysts and DBA’s to understand the business requirements. Creating and improving the technical design documents for better implementation of the project.
• Worked on all components of Informatica tools as Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer and Server Manager.
• Enhanced the performance of mapping with the use of lookup override and SQL override feature in Informatica.
• Wrote PL/SQL stored procedures & triggers for implementing business rules and transformations.
• Identified the Bottle Necks, removed the Bottle Necks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Worked with Informatica Professional Services to resolve issues
• Worked with different Operational Data Sources such as DB2, SQL Server, XML, Excel, Flat files.
• Prepared cobol copy book files, changed those cobol copybook files to level 1 file
• Server Manager Used for creating and maintaining the Sessions. Server Manger also used to Monitor, edit, schedule, copy, aborts and deletes the session.
• Solely responsible for the daily loads and handling the reject data.
• Completed documentation in relation to detailed work plans and mapping documents.
• Finished the tasks within the allocated time for every release.

Environment: Informatica PowerCenter/PowerMart 7.1.3, Cobol, Sun Solarisad, SQL Server, DB2, Oracle 9i, XML Files, SQL Navigator, Toad, Windows NT

Confidential, New York, NY

Sr. ETL Analyst/Designer/Developer

Responsibilities:

• Analyzing designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Analyzing the logical model of the Databases and normalizing it when necessary.
• Initial design phase included in identification of our Fact and Dimension tables.
• Responsible for installation, configuration and management of all the components of Informatica.
• Extensively used Informatica PowerCenter 7.1.1 for extracting, transforming and loading into different databases.
• Designing, developing and testing the Different Mappings according to Requirements.
• Wrote extensive PL/SQL stored procedures & triggers for implementing business rules and transformations.
• Wrote the shell scripts in UNIX for automating the job.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Identifying the Bottle Necks, Removing the Bottle Necks and Tuning the Mappings and Sessions for improving performance.
• Session Log files analyzed incase the session fails in order to resolve errors in mapping or session configurations.

Environment: Informatica PowerMart, Oracle9i, DB2 UDB, UNIX/AIX

Confidential

ETL Developer/Analyst

Responsibilities:

• Installed and Configured Informatica 7.1.1 over Windows, creating repository in SQL Server 2000. Creating shared, global folders along with user privileges based on role of each player in the project.
• Worked on Informatica - Source Analyzer, warehouse designer, Mapping Designer, Mapplet and Transformations.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Decision making Units in tables.
• Done the prototyping of the model.
• Created UNIX Environment variables in various .ksh files.
• Analyzed the Technical, organizational, and economical feasibility of the project.
• Created Informatica mappings with PL/SQL procedures/functions to build decision rules to load data.
• Extensively used most of the transformations such as the Source qualifier, Aggregators, Lookups, Filters and Sequence.
• Extensively Used ETL to load data from different databases and flat files to Oracle.
• Extensively worked on Database Triggers, Stored Procedures, Functions and Database Constraints.

Environment: Informatica PowerMart, SQL Server 2000, Oracle 8i, DB2 UDB, UNIX

Confidential

Informatica Developer

Responsibilities:

• Installed and Configured Informatica 6.1.1 over Windows, creating repository in SQL Server 2000
• Gathered software requirement specifications by doing JAD and JAR sessions.
• Made the use cases for the business process.
• Identifying a comprehensive set of information needs and user requirements for a database driven information system for related business process.
• Construct a context diagram and a level 0 data flow diagram depicting a process oriented view of business processes.
• Developed an extended entity relationship diagram depicting a data oriented view of business processes.
• Identified the proper facts and dimension table keeping the performance in consideration.
• Developed shell scripts to FTP daily and monthly delta files and archive the old files.
• Used various data sources like Flat Files, Relational Tables and COBOL Copybooks.
• Wrote PL/SQL stored procedures and triggers for implementing business rules and transformations.
• Performed complex mapping for the required business logics.
• Extensively used Source Analyzer to define the metadata, Warehouse designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Provided training to end users to use various functionalities of Business Objects.
• Extensive Performance Tunings on the sessions, tweaking them to run faster, drastically reducing the cycle time.
• Created various UNIX simple scripts to automate database connection checks, and take data backups.

Environment: Informatica PowerMart (Designer 6.2, Repository Manager 6.2, Server Manager 6.2), SQL Server 2000, Oracle 8i, DB2, UNIX

Confidential

Informatica Developer

Responsibilities:

• Identifying information needs within and across functional areas.
• Developed and extended entity relationship diagram for enterprise wide business processes.
• Identifying the integration points between functional areas in enterprise wide model.
• Created, modified, deployed, optimized, and maintained Business Objects Universes.
• Development and Deployment of Complex Reports.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Involved in redesigning the universes.
• Defined the optimized target definition with the help of warehouse designer.
• Worked on Informatica tool source analyzer, data warehousing, mapping designer, workflow monitor, workflow manager and repository manager.
• Used the mapping designer to map source and target.

Environment: Informatica 6.2, Business Objects, Cognos, Documentum, Windows Server 2003, and Oracle 8i

Confidential

Informatica Developer

Responsibilities:

• Extensively involved in Gathering requirements by holding meetings with users.
• Identify entities and relationships in a business environment using an event-oriented focus.
• Modeled the business process in the enterprise wide scenario.
• Constructed context diagrams and data-flow diagrams based on a description of a business process. Analyzing the data model and identification of heterogeneous data sources.
• Constructed an extended entity relationship diagram based on a narrative description of a business scenario.
• Performed testing and QA role: developed Test Plan, Test Scenarios and wrote SQL Plus Test Scripts for execution on converted data to ensure consistency.
• Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies.
• Worked on Tuning database server, application logic, database objects.
• Worked on tuning SQL statements using Sybase query plan analyzer
• Managed the database objects Indexes, Triggers, procedures, functions, packages, cursors.
• Involved in Maintenance of database, monitoring logs.

Environment: Informatica PowerMart (Designer 5x, Repository Manager 5x, Server Manager 5x), SQL Server 2000, Oracle 8i, UNIX/AIX

Confidential

Finance Business Intelligence Developer

Responsibilities:

• Identifying the information needs within and across functional areas of an organization.
• Modeling the process in the enterprise wide scenario.
• Identify the integration points between functional areas in an enterprise wide model.
• Identifying benefits of cross-functional integration in an enterprise-wide system.
• Tuned the performance of queries by working intensively over indexes.
• Used the dynamic SQL to perform some pre and post session task required while performing Extraction, transformation and loading.
• Created different source definitions to extract data from flat files and relational tables for Data mart.
• Created, modified, deployed, optimized, and maintained Business Objects Universes using Designer.
• Designing the ETL process using Informatica in order to populate the Data Mart using the flat files to Oracle database.
• Created complex mappings in order to populate the data in the target with the required information.
• Created work flows and sessions in order to perform the required transformation.

Environment: Windows Server 2000, Oracle 8i, Informatica 5.1, Business Objects