Experience Summary:

• Total 7.2 years of professional experience in IT industry, in the field of Data Warehousing/Business Intelligence using industry leading BI tools and technologies such as Oracle Data Integrator ODI , Informatica, IBM Data Stage,SAP BODS/BODI, OBIEE, Oracle SQL PL/SQL and IBM Information Analyzer. Have worked in multiple projects with various US and UK based clients
• Highly Motivated Business Intelligence professional with specialization in building Data Marts and Data Warehousing with Expertise in variety of ETL tools.
• Architect the ETL designs and provide best methodologies for Source system extraction, naming standards, design of staging area, Incremental loads, data quality, integration strategy, monitoring,alerting,lineage,cleansing,testing,metadata management,deployment,audit,archiving and documentation
• Experienced in Information Gathering, Requirement Analysis, Data Profiling, ETL architect, ETL Design, Development, Testing,re-engineering,deployments on time Delivery.
• Extensively worked on Design, Development and Administration of various ETL processes based on customer requirement like Error handling and error recovery, ETL Job control, Effective loading of data into Dimensions and Fact tables, incremental logic, capturing ETL audit statistics,restartabililty
• Engaged in various ETL processes from start to end and provide the CRAVE C Consistent
• Expert in automation of various processes and stabilizes the complex processes
• Mentoring and educating the team members and provide them training and motivation in various areas
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator
• Worked on both waterfall model as well as agile methodology projects.
• Specialized in all ETL tools available in market and cloud based ETL Snap Logic and Open source ETL tools like Penteho.
• Working experience in OBIEE and worked as a link between ETL and Reporting team for BI projects and developed the RPDs and reports in OBIEE.
• Familiar with usage of tools like CQ,JIRA and SalesForce.com for defect tracking
• Rich experience in Extraction of data from various data sources to the staging area and performing various transformations on the data and finally loading it to the target data warehouse
• Prepare estimation for given RFPs and provide the questionnaires and responses to BD team.
• Excellent technical, logical, code debugging and problem solving capabilities and easy grasping of new things.
• Worked with team and as well as individually motivated.
• Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills.
• Exposure to Various Domains like Sales Retail ,CRM and Inventory

Competencies

Assignments:

Confidential

Technical Environment: Informatica,Oracle 11g, UNIX with Putty, Liferay,Canvas,Toad with Oracle,SalesForce.com.

Role: Computer System Analyst

Responsibilities:

• Provides technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Created Informatica sessions and workflows and arrange all sessions by using perl script
• Proposing architecting of new ETL using database table and perl script.
• Implemented logic to archive the source files with date stamp affixed after the successful load.
• Advise and implement 'Best Practices' for ETL in complex system including processes for code migrations and configuration controls.
• Informatica Generic packaging creation to avoid the multiple workflows.
• Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list.
• Coordinates with offshore team and development schedules, maintenance activities and staff across all BI project teams.
• Identifies opportunities for new development initiatives makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• Involved in performance tuning of sources, targets, sessions, and workflows. Also involved in tuning of SQL queries.
• Identify, recommend and implement ETL process
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL development
• Identify bugs when developers are not able to do so.
• Allocate and re-direct resources
• Manage coordination between onsite/offshore teams
• Designing, developing and supporting jobs for to extract and load into the database from different sources.

Confidential

Technical Environment: Oracle Data Integrator ODI , Oracle 11g, UNIX with Putty, Toad with Oracle,SalesForce.com.

Role: Team Lead and Senior ETL developer

Responsibilities:

• Provides technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Understanding the Requirement Specifications, preparing the Functional and technical design documents.
• Advise and implement 'Best Practices' for ETL in complex and multi-developer system including processes for code migrations and configuration controls.
• Extensively researched on ODI packages and ODI 11g load plans and creating the product based generic ODI components and ensuring that all components are reusable and flexible enough to fit into every ETL situations.
• Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list.
• Coordinates development schedules, maintenance activities and staff across all BI project teams.
• Interacted with OBIEE team during design and development of facts and dimensions to accommodate all the reporting requirements.
• Identifies opportunities for new development initiatives makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• Involved in performance tuning of sources, targets, interfaces, and packages. Also involved in tuning of SQL queries.
• Identify, recommend and implement ETL process
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL development
• Ensure that all related projects cooperate and coordinate with the ETL DSR program team and BI team
• Manage coordination between onsite/offshore teams
• Designing, developing and supporting jobs for to extract and load into the database from different sources.

Confidential

Technical Environment: ODI,SAP Business Objects Data Services XI 3.2, Snap Logic, Oracle 11g, UNIX with Putty, Toad with Oracle.

Role: Team Lead and Senior ETL developer

Responsibilities:

• Manage the team such critical project and provide response in time
• Designing, developing and supporting jobs for to extract and load into the database from different sources.
• Automation of data load using ODI and SAP BODS.
• Extensively researched on ODI packages and ODI 11g load plans and creating the product based generic ODI components and ensuring that all components are reusable and flexible enough to fit into every ETL situations.
• Supporting and monitoring daily loads and performance issues effectively.
• Making business users to know about the statistics, behavior, events, and trends of gamers for these games to enable marketing campaigns and measure the effectiveness.
• Tracking everyday huge gaming data effectively.
• Overcoming a lot of performance issues while supporting and delivery in time.
• CRM application provides business users to know about the statistics, behavior, events, and trends of gamers for these games to enable marketing campaigns and measure the effectiveness.
• Ability to view data at a high level.
• Monitor ETL
• Modify ETL routines
• Make minor changes to ETL mappings
• Developing enhancements when ever required.

Confidential

Technical Environment: Oracle Data Integrator 10g/11g ODI , SAP Business Objects Data Services XI 3.2, SAP, Aspentech, Honeywell PHD,Oracle 11g, Toad with Oracle.

Role: Senior ETL developer and architect

Responsibilities:

• Development of ETL Interfaces, packages, procedures using Oracle Data Integrator.
• Extensively researched on ODI packages and ODI 11g load plans and creating the product based generic ODI components and ensuring that all components are reusable and flexible enough to fit into every ETL situations.
• Development of SAP BODS jobflows,work flows, data flows.
• Creating the ETL loading strategy for SAP BODS jobs and make those jobs enable to run and control by database table and ensuring its serial and parallel execution.
• Extensively involved in the requirement gathering for various KPIs and implement the data structure of tables according to the business needs and populate the data according
• Extraction of data from various data sources to the staging area and performing various transformations on the data and finally loading it to the target data warehouse Involved in the Unit testing for the jobs.
• Researching on the Open source ETL tool to implement for current product.
• Working on to create seamless and smooth installation procedure of the ODI components like master and work repository, agent, physical and logical schemas, scenarios etc. to any platform like windows or Linux.
• Developing the real time ETL for the real time reporting and for the sources like Aspentech,SAP,PHD,MS Access,excel,flat files,maximo etc.

Confidential

Technical Environment: IBM DataStage, Oracle PL/SQL, Toad

Role: Lead ETL Developer

Responsibilities:

• Involved in the requirements definition and analysis and creation of high level and detailed design and mapping documents
• Worked with high volumes of datasets from various sources like Oracle, text files, and relational tables
• Created the Repository, maintained source definitions, transformation rules, and target definitions using Informatica Repository Manager
• Extensively used the following transformations, among others: stored procedure for index drop/rebuild , router for creating multiple data pipelines , lookup connected unconnected , update strategy to define insert/update/delete/reject , aggregator, and sequence generator for generating surrogate keys
• Invoked stored procedures to perform database operations as a part of post-session and pre-session commands
• Responsible for tuning ETL mappings and sessions via source qualifier/lookup overrides to optimize load and query performance
• Analyze jobs and implement jobs according to the business needs.

Confidential

Technical Environment: IBM DataStage, Oracle 10g, Information Analyzer, Toad

Role: Lead ETL Developer and Lead data analyst

Responsibilities:

• As a data analyst analyze the data according to business and correct the data coming from different source systems and provide the issue logs to extract developers to correct data
• Development of ETL server jobs using DataStage Extraction of data from various data sources to the staging area and performing various transformations on the data and finally loading it to the target data warehouse Involved in the Unit testing for the jobs.
• Involved in the ETL design and its documentation
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.
• Used Informatica Designer to create mappings using different transformations to move data to a DWH
• Loaded the flat files data using Informatica to the staging area.