SUMMARY

• Over 7 Years of experience in Analysis, Design, Development and Maintenance of various software applications emphasizing on Data warehousing.
• 6+ Years of Data Warehousing ETL experience in Informatica Power Center 8.5/8.1.1/8.0/7.1.2/7.1.1/7.0/6.2 Power Mart 6.2/5.1.1/5.0/4.7.2.
• Experience in the Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snow flake Schemas.
• Relational and Dimensional Data Modeling experience.
• Extensive experience in Data warehousing tools including Informatica, Business Objects using different databases.
• Extensively Worked on Data warehousing with Data Marts, Data Modeling, Data Cleansing, ETL tool Informatica and data analyzing reporting Tool.
• Experience in working with data extraction, transformation and loading using Informatica Power Center.
• Experience in working with all Informatica modules like Server manager, Repository manager, Designer.
• Expertise in administering Informatica Repository, including creating and managing users.
• Extensive experience in design and implementation of star and snowflake schemas used in multidimensional modeling.
• Database experience using Oracle 9i/8.x, MS SQL Server 2000, DB2, MS Access.
• Experience in Installation/Upgrade of Power Center Server and Repository Server from PC 7.1.x to PC 8.1.x on Windows XP/2003
• Knowledge in UNIX Shell Scripting for scheduling Jobs.

TECHNICAL SKILLS:

Data Warehousing ETL Tools: Informatica Power Center 8.5/8.1.1/7.1.3/6.2/5.0, Informatica Power Mart 5.1, Power Analyzer 3.5x

Data Modelling Tools: Erwin 4.1/3.5.2,Visio2000

Databases: Oracle 10g/9i/8i/8.0/7.x, Teradata, SQL Server 7.0/2000, DB2 UDB 7.2/7.0.4.1.9, Teradata

Tools: TOAD, PL/SQL Developer, Oracle enterprise manager, Control - M 6.1.3,Remedy 6.1

Business Intelligence: (OLAP)

Languages: SQL, PL/SQL, SQL* Plus, C, C++, Unix Shell Scripting, HTML, JavaScript, VB Script.

Operating Systems: Linux, UNIX, Windows XP/2000/NT

Scripting languages: UNIX shell scripting, ActiveX, VB Script

Methodologies: Data Modeling - Logical, Physical, and Dimensional database design, Star and

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, Tennessee

Informatica Developer

Responsibilities:

• Used various Transformations like Dynamic Lookup, Connected and Unconnected lookups, Filter, Stored procedure, Update Strategy, Joiner, Aggregator, Expression, Router, Sequence generator, Normalizer in the mappings.
• Designed logic to transform the source, based on the requirement gathered from the users.
• Created Reusable Transformations and Mapplets in the designer using transformation developer and mapplet designer tools.
• Involved in Increasing ETL process performance by identifying performance bottlenecks, eliminating them, and tan identifying the next performance bottleneck until the mapping flow performance is the optimum.
• Configured single-pass reading to reduce the number of times the Integration Service reads sources.
• Optimized filters to maximize session performance, only process records dat belong in the pipeline.
• Interacted with the users and making changes to Informatica mappings according to the Business requirements.
• Created and monitored sessions using Informatica Server and Workflow monitor.
• Created UNIX shell scripts for Informatica jobs automation.
• Analyzed sales/spend data and provided quantitative analyses across markets, business units and functions.
• Managed all aspects of shared reporting services within Hyperion performance Suite.
• Set direction, validation, and testing schedules for upgrade from Hyperion 8.5 to 11g.

Environment: Informatica Power Center 8.6,Informatica Power Exchange, SQL Server2005,Oracle10g Windows NT,HP UNIX, IBM, AIX, Query Analyzer, Toad8.6, Hyperion, BMC Remedy User 7.1.

Confidential CHASE, TX

Informatica Developer

Responsibilities:

• Involved in the upgrading of Informatica from version 7.X to 8.X for data warehouse.
• Involved in the design of customer loan data warehouse.
• Developed DOS command scripts for running Informatica jobs and to implement pre-session and post-session tasks.
• Involved in developing Mainframe JCL jobs for running INFORMATICA jobs.
• Developed complex stored procedures to implement the routing logic.
• Handled various data sources Teradata, DB2, SQL server, XML, Oracle.
• Designed ETL process flow for entire DWH application and developed data mapping spread sheets to define transformation rules for each stage of ETL process.
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Worked extensively with Informatica to build complex relationship mappings, performing multi-table lookups, several other transformations.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.
• Used SQL SERVER Data transformation service (DTS) to load data.
• Worked with Terabyte data volumes, Optimized the sessions, mapping to achieve the best performance, and to load the data in a specified time window.
• Interacting with the users and making changes to the Business reports and Informatica mappings according to the Business requirements.
• Worked with data modeler’s team to create Data Flow Diagrams.
• Developed Informatica mappings and mapplets, between sources and operational staging targets, and fine-tuned some of them for better performance.
• Created views and altered some of the dimensional tables to satisfy the reporting needs.
• Employed Source Qualifier, Lookup, Expression, Aggregator, Rank, Sequence generator and Joiner transformations for populating the datamarts
• Used pre-session and post-session stored procedures in PL/SQL to improve the performance of the session.
• Implemented Type II Slowly Changing Dimensions using Version number.
• Performed migration from 6.2 TO 7.1, and performed backup and performance tuning.
• Extensively Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Instrumental in writing PL/SQL stored procedures and packages for transactional details (insert, update and delete operations)
• Created Migration Documentation and Process Flow for mappings and sessions.
• Created Event Wait, Event Raise, Timer and Control Events in workflow manager according to the business requirement.
• Responsible for unit testing the mappings using SQL scripts.

Environment: Informatica PowerCenter 6.2, 7.1, ORACLE 9i, HP-Unix, Windows 2000, Erwin 3.5, SQL*PLUS, SQL, PL/SQL.

Confidential, San Francisco, CA

Developer

Responsibilities:

• Analyzed and studied various Schemas for Implementation.
• Created source definitions from the operational sources and target definitions.
• Designed Sources to Targets mappings from primarily Excel/Flat files/XML to Oracle using Informatica.
• Worked Extensively on Informatica modules - Repository Manager, Designer, and Server Manager.
• Developed mappings, reusable Transformations for ETL using Informatica Power Center .
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, sequence generator and joiner.
• Configured sessions with Email and Command task.
• Command task and decision task based upon business requirements.
• Created workflows and reusable worklets for designed mappings.
• Analyzed the session, event and error logs for troubleshooting mappings, sessions and workflows.
• Worked with mapping variables, Mapping parameters and session parameters.
• Extensively used debugger to troubleshoot logical errors.
• Extensively used PL/SQL for creating views, stored procedures on the tables.
• Involved in partitioning of the sessions and performance tuning of database, Mappings, as well as Sessions.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Created Repository using Repository Manager.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Involved in production support which also includes trouble shooting of connectivity issues
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Tuned the mappings to increase its efficiency and performance.

Environment: Informatica PowerCenter 5.1/6.2, Oracle 8i, UNIX, TOAD, SQL * Loader,