SUMMARY

• 9+ years of experience in Development & Testing Business Intelligence solutions in data warehousing and decision support systems using ETL tool Informatica Power Exchange, Informatica Power Center 9.5.1, 9.5.18.6.1.8i, 7i, 6i and experience in OBIEE 11g report development.
• Experience in various domains like Airlines, Cruise lines Retail, Insurance, and Banking.
• Certified in Oracle IZ0 - 007 for SQL. Implemented Agile Methodology. Worked as an ETL Architect for a year.
• Experience in Change Data Capturing (CDC), Push Down Optimization (PDO) in Informatica.
• Experience in Oracle Business Intelligence Enterprise Edition 11g and Oracle BI Apps.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher and iBots wifin OBIEE Suite.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).
• Experience in managing users and groups, setting up their privileges and administering teh Object Level Security and Data Level Security using different authentication methods.
• Documentation: Expertise in preparing teh ETL Design Documents like High Level, low level Design documents, Technical design documents and Source to Target Mappings.
• Used different debugging techniques like teh Informatica debugger, creating temporary tables and session logs to resolve complex issues.
• Worked wif Teradata DB (Fast load, Multiload, Tpump and Fastexport),T-SQL,,SQL and PL/SQL Scripts through various procedures, functions, and packages, Triggers to implement teh business logic.
• Worked wif GreenPlum PostGreSQL Data base.
• Experience in UNIX working environment, writing UNIX shell scripts.
• Experience wif advanced ETL techniques including, Code migration, Data migration and Extraction/Transformation/ Loading.
• Strong in Data warehousing methodologies of Star /Snow Flake schemas of Ralph Kimball, Bill Inman.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.
• Actively involved in Performance Tuning, Error handling, Oracle query optimization, Product support on various Platforms. staging, reusability, data validation, Real time
• Used Power Exchange to source copybook definition and then to row test teh data from data files, VSAM files.
• Experience in designing teh logics to be implemented at teh RPD level.
• Experience in designing and development of all layers of OBIEE Repository i.e. Physical, Business Model, and Presentation layer.
• Creating Presentation Catalogs wif measures from Multiple Fact Tables.
• Experience in creating teh Dashboard and Report level prompts.
• Implemented Measures & Dimensions and organized teh information data into related subject areas. Involved in scheduling teh workflows through Job scheduler using UNIX scripts.
• Coordinated efforts wif ERP team regarding Master Data Tables wif teh Enterprise MDM Solution
• Good in analysis and problem solving, Good team player.
• Good in writing and communication skills.
• Worked wif multiple teams like DBA, Unix admin and Data modeling, technical teams and Business users for gathering business requirements.
• Good in planning, organizing, prioritizing multiple tasks.
• Interested in learning new technologies and willing to working changing environments.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.5.1, 9.0.1, 8.x, 7.x, Netezza plug-in, SSIS.

BI Tools: OBIEE 11g.

Databases: DB2, Oracle 11G, 10g 9i/8i, Teradata, MS SQL Server 2008, DB2, MS Access, Sybase, Greenplum, Netezza,T-SQL.

Operating Systems: Windows 95/98/2000/2003 Server/NT Server Workstation 4.0, UNIX.

Programming: C, SQL, PL/SQLScripting Languages: SQL, PL/SQL, UNIX Shell Scripting

Methodologies: E-R Modeling, Star Schema, Snowflake Schema

Other Software Engineering Tools/Technologies: Toad, Putty, Remedy, DAC,Tivoli, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Sr. Informatica Developer

Responsibilities:

• Involved in project cycle plan for teh data warehouse, source data analysis, data extraction process, and transformation and loading strategies, worked as an ETL Architect.
• Designed and developed Complex Mappings, which involves extracting order related data from XML’s and store teh data in SQL Server in Normalized form, Error handling, and implementation of business rules then generate teh Flat files to send it to Warehouse maintenance team.
• Implemented CDC for mappings so as to capture teh changes and preserve history.
• Applied PDO to optimize teh mappings.
• Involved in ETL load process and control framework for teh warehouse.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly relational tables, and flat files.
• Worked wif (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Extensively worked wif Debugger using breakpoints and various test conditions to test teh logic and teh validity of teh data moving through teh mappings.
• Worked wif Variables and Parameters in teh mappings to pass teh values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on teh extracted source data according to teh business rules and technical specifications.
• Performance Tuning of SQL Queries and ETL Mappings.
• Created Sessions, Work lets and workflows for designed mappings.
• Responsible for monitoring all teh sessions dat are running, scheduled, completed and failed Debugged teh mapping of teh failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of teh mappings migrated to production environment.
• Performed Unit tests on teh sessions and recommended measures to improve teh performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance.
• Experience in writing Batch/ Shell scripts handle files and informatica jobs from AIX UNIX.
• Proactive team player wif teh demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Good verbal and written skills and
• Good team player.

Environment: Informatica Power center 9.5.1, DB2, SQL Server 2008, 2005, flat files, AQT for DB2, UNIX, AIX, ERwin 4.0.

Confidential

Sr.Informatica Developer

Responsibilities:

• Gatheird requirements from teh end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Member of teh warehouse design team, which interacted wif teh business community and database administrators to identify teh business requirements.
• Experience in designing teh logics to be implemented at teh RPD level.
• Experience in designing and development of all layers of OBIEE Repository i.e. Physical, Business Model, and Presentation layer.
• Worked wif (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Involved in project cycle plan for teh data warehouse, source data analysis, data extraction process, and transformation and loading strategies.
• Worked in SAP BODS finance application.
• Deploy Informatica Objects TEST, UAT and Production Environments.
• Developed Informatica Mappings, Mapplets and Workflows for complex Business rules.
• Various Transformations like Expression, Lookups, Filters, Sequence Generator, Joiner, and Sorter were used to handle situations depending upon teh requirement.
• Called Stored Procedures to perform Database operations on Post-Session and Pre-Session commands.
• Implemented Change Data capturing (CDC) for Type2 slowly changing dimensions to keep track of Historical data.
• Created parameter file for session parameters and called in teh sessions.
• Created shortcuts to reuse objects across folders wifout creating multiple objects in teh repository.
• Involved in coding & designing of SQL, procedures, functions and support.
• Worked wif Teradata DB (Fast load, Multiload, Tpump and Fastexport).
• Dropped and recreated teh Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings. Extensively used PDO for optimizing teh loads.
• Performed Unit Testing and verified teh data using Informatica Debugger break points.
• Tuned mappings and sessions for better performance on teh data loads.
• Performed Error handling on sessions in Workflow Manager.
• Good in analysis and problem solving and good team player.
• Willing to learn new technologies.

Environment: Informatica 9.1.1, SAP BODS,OBIEE 11g,UNIX, LINUX Windows 2007, Oracle 10g, Teradata,PL/SQL,T-SQL, SQL, SQL Server 2008/2005, database, Putty, WinSCP, Cron Tab,Toad and SQL developer, Netezza plug-in.

Confidential .Plano,TX

Sr.Informatica Developer

Responsibilities:

• Gatheird requirements from teh end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Designed and developed Complex Mappings, which involved slowly changing dimensions (Type2), Error handling, and implementation of business rules.
• Worked wif (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Design and Implement Informatica mappings to Migrate data from various legacy applications/acquisition offices to a centralized application.
• Use Elite Software to maintain change control approval process.
• Worked wif Teradata DB (Fast load, Multiload, Tpump and Fastexport).
• Designed and developed various reports using OBIEE 11g.
• Deploy Informatica Objects and Business Object Universes to TEST, UAT and Production Environments.
• Involved in development of Informatica Mappings, Mapplets and Workflows for complex Business rules.
• Various Transformations like Expression, Lookups, Filters, Sequence Generator, Joiner, and Sorter were used to handle situations depending upon teh requirement.
• Called Stored Procedures to perform Database operations on Post-Session and Pre-Session commands.
• Implemented Type2 slowly changing dimensions to keep track of Historical data.
• Created parameter file for session parameters and called in teh sessions.
• Created shortcuts to reuse objects across folders wifout creating multiple objects in teh repository.
• Involved in coding & designing of SQL, procedures, functions and support.
• Dropped and recreated teh Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings.
• Performed Unit Testing and verified teh data using Informatica Debugger break points.
• Tuned mappings and sessions for better performance on teh data loads.
• Performed Error handling on sessions in Workflow Manager.
• Involved in Internal KT’s and Production support transitioning.
• Involved in project cycle plan for teh data warehouse, source data analysis, data extraction process, and transformation and loading strategies.

Environment: Informatica 8.6 OBIEE 11g,UNIX, Windows 2007, Oracle 10g Enterprise Edition, Teradata,PL/SQL, SQL, SQL Server 2008/2005, database, Putty, WinSCP, Cron Tab,Toad and SQL developer .

Confidential

Informatica Developer

Responsibilities:

• I have been involved in development & major/minor development projects for Customer Relationship Management & Maintenance activities like Extracting and sending customer related information to clients sister companies.
• Teh maintenance/enhancement requests come in teh form of Change Requests (CR). These are mostly to do teh need of capturing new metrics and thus require a change in data warehouse model (dimension/fact structure). Teh solution is delivered according to teh standards and guidelines.
• Clear Quest tool is used for implementing teh Software Development Methodology (SDM) process in any development and enhancement work at CCL. As per teh SDM process followed at CCL, any development and enhancement work needs to have -
• For Development environment:
• I have been working on Informatica (Fixing/modifying/developing/mappings/sessions/workflows)
• Extensively worked wif Debugger using breakpoints and various test conditions to test teh logic and teh validity of teh data moving through teh mappings.
• Worked wif Variables and Parameters in teh mappings to pass teh values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on teh extracted source data according to teh business rules and technical specifications.
• Involved in coding & designing of SQL, procedures, functions and support.
• Dropped and recreated teh Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings.
• Created Sessions, Work lets and workflows for designed mappings.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange.
• Responsible for monitoring all teh sessions dat are running, scheduled, completed and failed Debugged teh mapping of teh failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of teh mappings migrated to production environment.
• Performed Unit tests on teh sessions and recommended measures to improve teh performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance.
• Used Shell scripts to call procedures and load teh data into teh table.
• Developed Perl scripts to automate pre session and post session tasks.
• Involved in teh End user training and worked in testing and production support environments.
• Efficient Documentation (Migration document) was done for all mappings and workflows.

Environment: Informatica 8i, UNIX, Windows 2003/07, Oracle 10g Enterprise Edition, PL/SQL, SQL, UNIX Shell Scripting,Putty, WinSCP and Toad

Confidential, SC

Informatica Developer

Responsibilities:

• Worked wif Business analysts and teh DBA for requirements gathering, business analysis and designing and participated document review meetings.
• Worked in Onsite and as well as in Offshore as a Developer and Coordinate teh Onsite and Offshore Teams for maximum productivity by resolving teh issues.
• Involved in teh team during teh entire ETL process and development of data marts using Informatica Power Center 8.6/7.x.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Designed and developed Star Schema and created Fact and Dimension Tables for teh Warehouse using Erwin and Business Intelligence Reporting Applications using OBIEE.
• Extracted teh data from Oracle11g/10g, XML, Flat files load teh data in to Oracle data warehouse.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse. Developed complex mappings in Informatica to load teh data from various sources into teh Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different sessions and workflows to load teh data to Data Warehouse using Informatica Workflow Manager.
• Created Reusable transformation and Mapplet based on teh business rules to easy teh development process and responsible for document teh changes.
• Maintained and modified mappings as per changing reporting requirements.
• Extensively worked on teh performance tuning of teh Mappings as well as teh sessions.
• Checked Sessions and error logs to troubleshoot problems and also used Debugger for complex Problem troubleshooting
• Developed Informatica mappings/sessions/workflows for ETL processing and used Unix Shell Scripts for smooth application interfacing.
• Involved in identifying teh bottlenecks in Sources, Targets & Mappings and accordingly optimized them.
• Working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in using teh Stored Procedures, Functions and Triggers at Data Base level and imported them in Informatica for ETL.
• Extensively used SQL * Loader for Bulk loading from Flat Files to Oracle Tables.
• Involved in Unit and System testing of developed mappings.
• Responsible for migrating teh folders or mappings and sessions from development to production environment.
• Written Detail design documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power center 8.6/7.x,XML, Flat Files, UNIX, Windows 2003,Oracle 9i, PL/SQL, SQL, MS Visio, Shell Scripting, Putty, WinSCP and Toad.

Confidential

Informatica Developer

Responsibilities:

• Gatheird requirements from teh end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in teh Data Warehouse Data modeling based on teh client requirement.
• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on teh requirement document provided by teh business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on teh logic, developed various Mappings & Mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in teh mapping. Also developed Error Processing to capture teh error records and loads them into Message Log table.
• Worked wif Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate teh activities like start, stop, and abort teh Informatica workflows by using PMCMD command in it.
• Fine tuned teh mappings by analyzing data flow and Worked wif Memory cache for static and dynamic cache for teh better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check teh data.
• Responsible for migrating teh folders or mappings and sessions from development to test environment and Created Migration Documents to move teh code from one Environment to other Environment.

Environment: Informatica 6.1, UNIX, Windows 2003, Oracle 8i, PL/SQL, SQL, Flat Files and CSV, Shell Scripting, Putty, PL/SQL Developer.