SUMMARY

• 10 years of IT experience in System Analysis, Design, Development, Implementation, QA and Production support of Data warehousing, Business Intelligence applications for various industries, using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Extensive experience in all phases of implementation - requirements gathering, solution design, gap-fit analysis, set up and configuration, functional design(Low level and High level), process definition, system integration, transition, effective documentation and end-to-end EDW solution.
• Experience in ETL- Informatica 9.1.1/8.x/7.x, OBIEE 12C,11G, OBIEE 10.1.x which includes Oracle BI/Siebel Intelligent Dashboards, Oracle BI/Siebel Answers, Oracle BI/Siebel Delivers and Oracle BI/Siebel iBots, Oracle BI Publisher, Reporting-OBIEE platform, Scheduling- DAC, interacting with multiple data sources like Oracle 9i, 10g, SQL Server and various other miscellaneous sources.
• Proficient in Informatica Designer Components Source Analyzer, Warehouse Designer Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor and also experienced in DWH Daily load monitoring and Production DWH issues in ETL and Reporting.
• Worked as developer, Designer and Analyst roles in various projects having Enterprise Data warehousing Technology and Oracle Business Intelligence platform (focusing Management Information Systems and Reporting requirements delivery).
• Experience in converting the Business Logic into Technical Specifications.
• Experience in creating the design documents - High Level & Low Level Design Documents
• Hands on experience in using Import and Export utilities as part of the backup strategies
• Experience in Developing Mappings and Mapplets, Worklets, Reusable transformations, Sessions/Tasks, Work Flows and Batch processes in Informatica Server
• Implemented performance-tuning techniques at application, database and system levels
• Hands - on experience in implementing DAC - Data Warehouse Application Console to schedule the Informatica Workflows and execution plans
• Experience with modern software engineering practices (Continuous Integration, Specification by Example, Behavior / Test Driven Development - BDD, TDD)
• Ability to Provide leadership, vision and design direction for the team and good experience in leading development teams
• Had capability in providing Estimation and Scheduling, Quality Planning, Risk Planning
• Exposure in Requirements Gathering, Design Data Mart Architecture, Development/Build, Testing, Implementation, providing Warranty and Transition support.
• Coordinate with other system owners to understand the data architecture and map it to the Data Warehouse
• Worked on SDLC model, agile model and gained working knowledge of industry standard architectural tools, processes and frameworks.
• 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.
• Had experience in resolving number of critical issues in support of daily production schedule job runs, and has ability to analyze and solve a wide range of technical problems.
• Involved in different stages of data warehouse/BI development for moving Heterogeneous sources to a Data Mart/Data warehouse, Data Migration, Data Conversions, Optimization using varied ETL tools.
• Extensive experience in ETL/BI Manual testing using Mercury Interactive tools like Quality Center
• Good leadership skills to guide and mentor the work of less experienced personnel, had experience in managing project and project Team with self motivation and commitment.
• Excellent communication skills, ability to learn new skills quickly, productive interpersonal skills with the ability to understand and cooperating with business teams and gather requirements efficiently by professional attitude
• Extensive knowledge and experience in writing RFP- Proposals and preparing Project Scoping and effort Estimations Technical Solutions.
• Providing Accountable support for continuous improvement related to requirements best practices, methodologies, and quality of business and functional requirements to implement
• Enthusiasm and passion to deliver results that bring optimal value to customers in EDW and BI Applications.
• Issue Management and Conflict Resolution via communication strategies.
• Ability to prepare, deliver and assess user trainings, presentations and/or facilitate collaborative discussions.
• Extended my responsibilities in People Management, Client Management, and Knowledge Management.
• Ability to draft proposals, minutes-of-the-meeting, status reports and comprehensive documentation.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5.1/9.1.1/8.6.1/8.1.1 , ODI 11G

Reporting Tools: OBIEE 12c/11g/10g/Siebel Analytics 7.8.5, OBIA, Tableau, BI Publisher 11g, Business Objects.

Operating Systems: UNIX(Sun Solaris, AIX), Window Server 2012,XP

Languages: C, Java, HTML, Unix Shell Scripting, Perl Scripting

Databases: Oracle 12c/11g/10g/9i,Teradata 12, Sybase 12.0/11.x/10, MS SQL Server 2000/2008, IBM DB2 UDB 9.0, Netezza, MS Access 97/2000, MS Excel

Case Tools: Visio

Other Tools & Utilities: PUTTY, WINSCP, MS Office Suite, Microsoft Visual Studio 2010 (TFS Version Control), Adobe tools, MS Visio, Quality Centre, Remedy

Database tools: SQL Server Management Studio, TOAD, PL/SQL Developer

Scheduling Tools: $U, Control N, DAC 7.9.6.3/7.8.4

Domain Knowledge: Telecom, Banking & Finance, Insurance, Health care

Data Modeling: Erwin 4.5/4.0,Logical Modeling, Physical Modeling, Dimensional Data Modeling(Star Schema Modeling, Snow Flake Schema Modeling, FACT and Dimensions Tables)

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Sr Informatica ETL Developer

Responsibilities:

• Responsible for full life cycle development of Data Warehousing and BI Solutions.
• Demonstrate leadership and subject master expertise with respect to BI KPI's
• Responsible for Requirement analysis, data profiling and prepare source system analysis document and obtain sign-off.
• Responsible for come up with ETL Architecture & Design Solution and prepare High Level Design Document and obtain sign-off.
• Prepared detailed scope/requirements documentation along with priority designations that development teams will use to plan, develop, test and implement application/system functionality
• Coordinating with other roles within all Business Operations and IT to ensure excellent business relationships are built and maintained.
• Analysis of the specifications provided according to the requirement.
• Creating and implementing scheduling strategy. Reviewing Business Specifications.
• Works with business partners to review prototypes and develop iterative revisions.
• Apply Business rule and create mappings for the warehouse.
• Support the business activities in production environment.
• Interacting with SME teams as well as Business JOB's for scheduling, execution, validation, support
• Unit testing & integration testing.
• Preparing data migration and Data Integration design process, data quality and data integration rules, source to target mapping design, error handling, and implementation planning using ETL Tools.
• Performing configuration, migration and deployment of ETL mappings
• Worked extensively on Informatica, Oracle and Teradata.
• Designed DFDs for ETL process to be implemented in ETL Tool
• Re-engineered lots of existing mappings to support new/changing business requirements.
• Working on OLTP/OLAP System Study, Analysis and E-R Modeling, Data Warehousing concepts, Kimball’s methodologies, designing of complex star schema and snowflake schema, and enterprise wide Data Warehouses and Data Marts with slowly changing dimensions
• Prepared Pseudo-Code Documents apart from DFDs and regular flow-charts to show the flow of jobs and to establish the relationships between various Procedures run in a sequence.
• Involved in bug fixing and enhancements of ETL and BI applications
• Coordinates with Project Managers and participates in project planning.
• Working in Informatica Administration Access and Code Deployment best practices

Environment: Informatica 8.6, Oracle Business Intelligence 11g, Oracle 10g, SVN, Microsoft Visual Studio 2008, Toad, and DAC.

Confidential, Chicago, IL

Senior Informatica Developer

Responsibilities:

• Involved in Participating in Requirements Gathering for system enhancements as part of solution lead.
• Involved ETL tool Informatica in designing the Workflows, Worklets, Mappings, Sessions and configuring the Informatica Server using Informatica Power Center 8.6 and scheduling the Workflows and sessions using scheduling tools, Control M.
• Worked in ETL design and development - understanding the tradeoffs of various design options on multiple platforms using multiple protocols.
• Involved in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Involved Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures, Function and packages to suit Confidential requirements.
• Maintain required deliverable artifacts during each project cycle - BRSD, Design documents, Test strategy documents etc
• Translating Compliance requirements into Functional Specifications (BRSD Documents) and Technical Specification Documents like HLD and LLD.
• Worked on Oracle Data Integration ETL Data mappings for source data extractions
• Integration between DB2, Oracle and SQL Server utilizing Web Services and MQ/JMS.
• Working with ETL tool suite to design and develop work flows, transformation mappings, and UNIX scripting.
• Collaboratively worked with development leads and architects during scope, requirements, and design processes to fully document scope, requirements, and design related to the business need, and estimate work effort to implement scope
• Apply Business rule and create mappings for the warehouse.
• Worked closely with business users to create report specifications and metadata information for report generations.
• Unit testing & integration testing.
• Create Data flow diagram for mappings.
• Involved in Project migration and deployments of Repositories.

Environment: Informatica 8.6, SAP Business Objects XI 3.1, ODI, Oracle 10g, ER Studio 8.5.3, SVN, Microsoft Visual Studio 2008, Toad, and Control M.

Confidential, Sanjose, CA

ETL Application lead

Responsibilities:

• Working as an onsite IT lead for the ongoing EDW Implementation activities.
• Responsible to prepare the detail plan for End to End Implementation and align various stakeholders & customers and lead the team for successful delivery.
• Responsible for Model the EDW and Data Mart layer enhancing with existing EDW Application, walk-through with Data Architects and obtain sign-off.
• Responsible for prepare ETL High Level and Low level Design Specification, walk-through with Customers & other stakeholders and obtain Sign-off.
• Responsible for prepare the SIT, UAT and Production Implementation plan, walk-through with customers & other stakeholders and End Delivery.
• Resolving the Data issues while the execution of the Production ETLs and ensuring the clean data to subscribers and reporting systems
• Developing subject area framework models in semantic layers with proper data groupings making business users to create self service Reports in the Business Analysis on their own reports
• Tuned the performance of Informatica, Database and Reporting performance. Some of the steps used to tune the performance include indexes, Informatica and database partitioning, Explain Plan, Effective rewriting the query and SQL Hints.
• Supporting the reporting related issues pertaining to finance raised by End User
• Provide support to Application Tuning Team
• Working closely with clients to ensure a detailed understanding of the needs
• Design, Development, Testing and Deployment of enhancements
• Reconciliation process across two databases (Oracle and Teradata)
• Participation of critical EDW Finance Month End and Quarter End closing activities
• Performed 24x7 production support
• Analyzed Business requirement and documented the ETL implementation.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides

Environment: Informatica Power Center 8.1, Oracle 10g, PL/SQL, MS SQL Server 2000, DB2, ERwin 4.1, Unix Shell Scripting, Windows NT, UNIX (Sun Solaris), Dollar U, OBIEE

Confidential, Sanjose, CA

Senior ETL Designer

Responsibilities:

• Data Extraction from Oracle source thru ETL mapping
• Data Cleansing
• Performance tuning of mappings.
• Transforming the Data to meet Business requirements
• Designing & testing of Mappings
• Scheduling the Jobs for Daily Load
• Setting up the Environment for Development and Testing
• Fixing Production issues.
• Created locations for all sources to deploy mappings
• Defining the transformation Rules and writing Triggers
• Created Process flows and Schedulers using $ Universe
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables.
• Used Informatica Scheduler for scheduling the workflows.
• Created various data marts from data warehouse and generated reports using Business Objects.
• Developed PL/SQL stored procedures to implement business logic

Environment: Informatica, Oracle Ware House Builder, Oracle 10g, SUN Solaris, Dollar U scheduling tool.

Confidential, Kentucky

OBIEE Developer

Responsibilities:

• Implementation of OBI Financial Analytics for GL, AP and AR modules, Procurement and HR Analytics.
• Involved in Installations, configurations of Informatica, OBIEE and DAC across multiple environments in Linux.
• Meetings with different business teams to get the business requirements for modules like HR, Finance and Procurement.
• Development of customization requests in RPD and development of mappings in Informatica and adding the tasks to DAC.
• Prepared the test Cases for executed the test cases for ETL full and Incremental loads and Dashboards and Reports for all modules.
• Creation of new Dashboards and reports based on business requirements.
• Deployments of Informatica, DAC, OBIEE across DEV, SIT and PRD environments.
• Testing of DAC full load and incremental loads.
• Worked on user access management for different business groups based on their levels.
• Knowledge on ERP (Oracle apps) OLTP application.

Environment: Informatica 8.6, OBIEE 10.1.3.4, Oracle 10g, DAC 7.9.5, Windows, UNIX.

Confidential

EDW/BI Solution Designer

Responsibilities:

• Analysis of the specifications provided according to the requirement.
• Multiple source system study for the requirements.
• Apply Business rule and create mappings for the warehouse.
• Worked on Data Acquisition part
• Worked closely with business users to create report specifications and metadata information for report generations.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet, and Transformation Developer.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
• Working with the Data Warehouse Architect to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas.
• Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Developed variousReports, Interactive Dashboardswith drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Implemented Dimensional modeling in MSTR Architect Layer and OBIEE reports
• Unit testing & integration testing.
• Worked on Test case preparation and execution
• Involved in designing the incremental load process
• Create Data flow diagram for mappings.
• Schedule the mappings in the onsite production server.
• Working on both onsite server and offshore server.
• User Acceptance Testing and getting Signoff of the reports from end users during the onsite.
• Preparation of ETL Detailed Design documents, ETL Manual Document.

Environment: Informatica PowerCenter 8.6, Designer, Workflow Manager & workflow monitor, OBIEE, MSTR, WINDOWS 2003, UNIX

Confidential

OBIEE Developer

Responsibilities:

• Involved in designing RPD according to Customer requirement.
• Configured Usage Tracking and created custom reports.
• Implementing OBIEE project which include Architecture, Design, and Implementations
• Installed OBIEE 11g in windows and unix environment.
• Developed different kinds of reports using pivots, charts and global and page level prompts using obiee Answers.
• Worked extensively on BI Administration tool to configure Physical, Logical and Presentation Layers.
• Defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed variousReports, Interactive Dashboardswith drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• UsedOBIEE Web Catalogto set up groups, access privileges and query privileges.
• Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.
• Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.
• Developed templates and reports inOracle BI Publisherin rtf format.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Environment: OBIEE 10g, BI Publisher, OWB, ORACLE 10g, WINDOWS 2003, UNIX

Confidential

ETL Solution Architect

Responsibilities:

• Ensuring traceability of all customer, business and functional requirements, represents business priority and supports project through all SDLC phases
• Responsible for Requirement analysis, data profiling and prepare source system analysis document and obtain sign-off.
• Responsible for come up with ETL Architecture & Design Solution and prepare High Level Design Document and obtain sign-off.
• Worked on reusable transformations and Mapplets to reduce the overall effort by 30%.
• Worked on Project to build a Data mart in Oracle DB and populate the data from Flat Files, XML’s into Oracle Database. Also Read from Oracle DB Tables and generate Downstream Flat files and XML Files as back feed for Business processing.
• Involved in the UAT phase and was taking up the issues raised by the users.
• Designing and implementing Business Intelligence technical and operational solutions.
• Data Architecture in Enterprise data modeling, database design, master data management.
• Multiple source system study for the requirements.
• Point of contact for all Compliance requirements related to EDW
• Apply Business rule and create mappings for the warehouse with ETL tool like Informatica.
• Worked closely with business users to create report specifications and metadata information for report generations.
• Developing and reviewing the Informatica mapping flows and data mapping between source and target.
• Providing estimations for ETL requirements, designing and architecting integration solutions for the given modules.
• Unit testing & integration testing and involving performance tuning of Informatica Mappings/Sessions.
• Understanding the change data capture, Data Reconciliation concepts.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Pearl scripting

Confidential

ETL Developer

Responsibilities:

• Data Extraction from Oracle source through ETL mapping
• Production support activities.
• Creating transformations and mappings using Informatica Power Center and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Integration of various data sources like Oracle, SQL server, DB2 and flat files into staging area.
• Performance tuning of mappings.
• Designing & testing of Mappings
• Scheduling the Jobs for Daily Load
• Setting up the Environment for Development and Testing
• Fixing Production issues.
• Configured the execution plans & execution tasks in the Scheduler.
• Preparation of technical design documents, reviewing the design documents internally and interacting with client for the same.
• Involved in User Acceptance Testing phase

Environment: Informatica PowerCenter 8.1, Oracle 9i, PL/SQL, Putty, UNIX shell scripting