SUMMARY

• Specialized in ETL and BI tools like Informatica & OBIEE. Have 7 years of professional experience in the field of BI, Data & Analytics - with expert knowledge in Data warehousing Concepts. Possess Strong project management skills - wonderful client interaction - focus on accomplishing task in crunch time - highly productive for Onsite and Onsite - Offshore model.
• 7 years of hands-on experience using Informatica Power Center
• 2+ years of professional experience in OBIEE and BI Publisher
• Extensive experience with Informatica Power Center 9.1/8.6/8.5/8.1.1/8.0 (Source Analyzer, Target Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, workflow Monitor).
• Good knowledge in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table and Dimension Table.
• Vast Knowledge in Data Warehouse Development Life Cycle where all dimensions of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center
• Extensively worked on ETL Informatica transformations effectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from various sources such as Oracle, ASCII delimited Flat Files, XML, DB2, and SQL Server.
• Participated in Full life cycle development of Data Warehouse systems such as Analysis, Design, Development, Testing and Technical Documentation.
• Developed Mappings using Type 1, Type 2 and Type 3 SCD logic to load data into Dimension tables.
• Streamlined in testing data flow by using Debugger and tuning the Data Warehouse which includes Oracle SQL query tuning and Informatica Power center for finding out bottlenecks
• Worked on data warehousing and decision support systems with relational databases such as Oracle design and database development using SQL, PL/SQL, SQL PLUS, TOAD, and SQL-LOADER. Highly proficient in the integration of various data sources involving multiple relational databases like Oracle 11g/10g/9i,MS SQL Server,DB2,COBOL Files and Flat Files.
• Sound knowledge of DAC Client, DAC Server.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008.
• Experience on post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Good Understanding of RDBMS concepts like Indexes, Stored Procedures, Partitioning, Normalization (3NF) and De-normalizations.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Extensively worked with OBIA modules including Financial Analytics, HR Analytics, and Manufacturing Analytics.
• Expertise in using database applications such as ORACLE, SQL Server, DB2 and MS Access.
• Worked with several source systems, for example, JDE E1, EBS R12.
• Experienced in writing test queries/scripts for data analysis and QA report testing.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and from QA to Production server.
• Offshore Team Co-ordination - Onsite-offshore co-ordination experience and well versed with off-shore teams ensuring timely and quality results.
• Experienced in supporting end-user reporting needs using Informatica. Efficiently involved in interacting with Business Analysts, Department Managers and Business Users. Competence to Manage and deliver results on multiple tasks by effectively managing time and priority constraints. Ability to address any ongoing or changing Business needs.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Demonstrate excellent troubleshooting and analytical abilities. Demonstrated ability to work both in independent and team-oriented environments.

TECHNICAL SKILLS

• C
• C++
• JAVA
• SQL and PL/SQL
• Unix shell scripting
• Informatica Power Center 9x/8x/7x
• Dimensional Data Modeling
• Star Schema Modeling
• Snowflake Schema
• FACT and Dimensional Tables
• Oracle 11g/10g/9i
• OBIEE (10.1.3.x/11.1.1.x)
• BIAPPS 7.9.6.x
• ODI 11g
• DB2
• MS Access
• SQL Server 2005/2008
• Views
• Materialized views
• Cursors
• Stored Procedures
• Functions
• Database Triggers
• Packages
• TOAD
• SQL Developer
• SQL*Loader
• Informatica Work Flow Scheduler
• DAC
• SQL server agent. MS Visio
• Windows95 /98/2000/XP
• Windows NT 4.0
• UNIX
• MS DOS.

PROFESSIONAL EXPERIENCE

Senior Consultant

Confidential, Pittsburgh, PA

Responsibilities:

• Interacted closely with Functional Analysts and Business Users on the client side to understand the requirements and the impact of ETL on the business. (includes Analysts from multiple line of business)
• Understood the requirement and developed ETL design document to develop and customize mappings.
• Prepared strategy to load historical data and perform incremental loading of data.
• Analyzed source system (E1 - JDEdwards) and understood its importance to design the ETL rules.
• Analyzed Out of the box ETL code and customized them to pull new data for specific requirements by users.
• Designed complex ETL mappings for Type - 1 and Type - 2 Dimensions and fact tables.
• Extensively worked with Transformations like Router, Normalizer, Lookup, Aggregator, Expression and Update Strategy Transformations
• Scheduled data loads in DAC using Execution plans
• Helped support team in Monitoring and fixing failed loads in DAC by guiding the team to find the root problems.
• Prepared Test cases and completed unit testing of developed mappings.
• Co-ordinated with the team and the business analysts and users to ensure delivery of quality data.
• Performed Upgrade of Informatica from 8.6 To 9.1 on all 3 servers (Dev, Test, Prod)
• Performed Upgrade of DAC (configured and migrated) from 10.1.6 To 11.1.1.7 on all 3 servers (Dev, Test, Prod)
• Got Trained in OBIEE and worked extensively to understand the concepts and supported the team during resource crisis.
• Performed the gap analysis, Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Model (Physical, Business and Presentation layer).
• Configured Agents to send the Reports through Emails to the user group.
• Design the mappings, documentation and involved end to end implementation.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc reports according to the client needs.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE Answers to build the query.
• Used presentation variable in OBIEE Answers to save prompt values and use them for conditional formatting.
• Worked with properties such as changing the ownership of a folder or viewing the creation date of an object.
• Specified permissions that determine the folders and objects that users can view.
• Sorted data values, applied sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps.
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.

Environment: Informatica 9.1,DAC 11.1.7.1/10.1.6.4 , OBIEE 11g/10g, BI Publisher, Oracle 11g/10g, TOAD, SQL, PL/SQL, Windows Server 2008.

Senior Associate - Data & Analytics

Confidential, NY

Responsibilities:

• Business Analysis and Requirements Gathering
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time
• Developed and designed Datamarts extensively using Star Schema
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager. Also created various tasks such as command task, email task, timer tasks, Event wait and Event Raise tasks in the workflow manager
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations
• Involved in Performance testing the mappings and workflows in production staging before installing in the Production environment
• Developed UNIX scripts to compare the Production sequence generators with Production staging sequence generators and to update the sequence values in staging environment and automated the script
• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer and Workflow Manager
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others
• Developed sessions using Informatica Workflow Manager
• Solely responsible for the daily loads and handling the reject data
• Analysed data using OLAP tools
• Push down query optimization to optimize the queries
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart
• Designed and developed table structures, stored procedures, and functions to implement business rules
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues

Environment: Informatica PowerCenter 9,Metadata Manager, Power Exchange 8.6, Data Analyzer, UNIX, Flat Files, XML Files, SQL and PL/SQL, ERWIN 4.0, Toad for Oracle11g, Datamart, Microsoft Project, ESP.

Senior Informatica Developer

Confidential, LA

Responsibilities:

• Conversion of complex SSIS packages to new informatica mappings
• Performance Improvements of longer running packages by pushdown optimization
• Incrementalism for the existing full load packages
• Developed a single mapping for the entire extraction process of 3 stages and staging process of 2 stages using Python scripting, worklets, Flat files
• Developed worklets to handle the logging for incremental logic
• Production support for the jobs running every day and handled any failures in them
• Developed stored procedures to increase the performance of mappings and SSIS packages
• Workflow parameter file and session parameter file creation and usage
• Developed test case documents and specification documents with standards to be followed across all the mappings
• Implemented parallel loads for EDW & Datamart part with Max Concurrent Executables to 3.
• Performed unit testing and qcode reviews for the mappings developed across the team
• Attended training sessions in Informatica Cloud
• Worked on basic reporting in OBIEE

Environment: Informatica Power Center 9.1.0, PL/SQL, SQL Server 2008, Flat files, SQL loader, Python Scripts, Datamart, SSIS, OBIEE 10g.

Informatica Developer

Confidential, Houston, TX

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and load into Data warehouse using the Mapping Designer
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Used DTS package to import and export data to from the data base
• Written Queries, procedures, created Indexes, primary keys and data bases testing
• Datamart is used to segment the dataware house
• CDC pattern is used to track the data changes in data warehouse
• Defects were tracked, reviewed and analysed
• Aggregation of data using OLAP operations
• Use of pushdown optimization to balance data transformation
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, PL/SQL, SQL Server 2000, Flat files, SQL loader, UNIX Shell Scripts, Erwin, Datamart.

Informatica Developer

Confidential

Responsibilities:

• Involved in the complete life cycle of the data warehouse development and designed and maintained data marts.
• Designed star and minimal snowflake schemas
• Extraction, transformation and loading were performed using Informatica PowerCenter to build the data warehouse
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations
• Worked on various transformations such as Aggregator, Normalizer, Upgrade strategy, Router, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Joiner, etc
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Created Mapplets for reusable business rules
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures for performing different database tasks
• Designed a data model for the reporting needs of marketing team at Disney using ERWIN
• Generated reports using cognos
• Made extensive use of UNIX Shell scripting, setting UNIX cron jobs, maintaining user profiles, archiving log files etc
• Extracted data from different Relational sources like oracle, transformed the data based on user requirement and loaded around 1TB of data into target, by scheduling the sessions
• Sessions and batches were created using Server Manager to load the data into the target tables
• Performed Repository Administration tasks (Creating Repositories, Users, Assigning privileges, creating backups and recovery)
• Created partitions through the session wizard in the server manager to increase the performance
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance

Environment: Informatica Power Center 7.1.4, PowerMart 5.0, Oracle 9i, SQL * Loader, Teradata V2R5, PL/SQL, XML, UNIX 5.8.