SUMMARY:

• Having 14 years of IT experience, including 9 years in analysis, design, development and support of DWH & BI applications in an effective way to deliver leading edge of software solutions.
• Experience in different phases of DWBI projects such as Requirements gathering, Analysis, Design, Development, Testing, Implementation/Deployment, Production Support and Documentation, along with cross team communication and Knowledge Transfer activities.
• Exposure in OLTP/OLAP System study, analysis, E - R modeling, data architecture and designing logical & physical of database schemas like star schema and snowflake schema used in relational, dimensional modeling.
• Extensively worked on writing complex Oracle SQL queries, PL/SQL blocks, packages, stored procedures, functions, DB Triggers and performance tuning etc.
• Experience in design, develop ETL workflows, mappings using tools such as IBM Infosphere Data Stage , Power center Informatica, SAP BODS and SSIS.
• Experience in developing OBIEE Repository (. rpd) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer) includes Time Series Objects, configuring metadata, Answers, Delivers and Web Catalog Objects.
• Extensive experience in building Interactive Dashboards with drill-down& drill-across capabilities using global & local Filters in OBIEE11g . Understanding and defining business key metrics, dimensions, hierarchies and attributes.
• Experience in supporting & execution of prebuilt DWH package NOETIX with Informatica ETL jobs. Monitoring loads, fixing the issues and working on enhancements etc.
• Experience in working with OBIA - Manufacturing application. Mapping pre-built available RPD objects from Physical, BMM and Presentation layers with required other entities.
• Experience in scheduling ETL Informatica jobs using Oracle DAC client tool and debugging the load process. Configure, monitor and Schedule ETL routines of DAC.
• Exposure in implementing the Data quality using SAP Information steward 4.0 & 4.1 Ver. Analysis enterprise data quality issues and develop the scorecards and dashboard by using the SAP information steward different modules.
• Experience in leading the team by taking ownership of the project execution. Analyze, estimate and schedule the tasks and break down into structure and assign to appropriate Perform code and design review and co-ordinate with off shore team.

SOFTWARE SKILLS:

ETL: DataStage 8.5/7.5 & Informatica 7.1.1/8.1/9.5 ,SAP BODS and SSIS

Reporting/Analytical Tools: MS Power BI, Oracle BI EE 11.1.1.7.0/ 10.1.3.x, SSRS

Big Data: Confidential - Cosmos

RDBMS: Oracle 8 / 9i / 10g/11g & SQL server 2005, 2008.

Languages: C, SQL, PL/SQL

GUI: Developer 2000 (Forms / Reports 6i)

Database Tool: Toad 9.0 Ver. Oracle Sql Developer ver 1.5.4

Scheduling Tool: Control-M 7.0, DAC 11.1.1.6

PC Software Tools: MS-Office Suite, Adobe Photoshop 7.0

Operating System: Unix, Linux, Windows 7/Vista/XP/2003/2000

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Environment: SQL Server, SSIS, Bigdata (Cosmos), Windows, Scope, MSBI

Technical Lead

Responsibilities:

• Requirement gathering, User Stories analysis and Design the pipeline process with High and low level architect design.
• User interaction and brain storm meetings in collecting business requirements and preparing functional/technical specification and data modeling.
• Design and develop ETL jobs using SSIS and Scope script to extract source data from different sources system such as client internal Big data (Cosmos), Flat files and Databases and processed into Data Warehouse.
• Understand business KPI metrics and Design, develop Data Marts and Cube to suit the Analytical reports presentations.
• Create and manage dashboards, reports using MS Power BI tool.
• Run daily SCRUM and prepare biweekly SPRINT and assign the tasks to the Team.
• Co-coordinating with Onsite and Offshore team and assign tasks.

Confidential, Chicago, IL

Environment: Teradata 14.1, SAP - HANA, DB2, SAP BODS 4.2 and LINUX

ETL Lead

Responsibilities:

• Perform ETL design and development, starting from requirement gathering, source data analysis, conceptual/technical document creation, OLAP Data model architecture design & engineering,
• Design and develop ETL jobs using SAP BODS 4.2 to facilitate the easy data flow into SAP HANA system.
• Involve in Admin tasks such as Create Local, Central repositories in DB2 and configured into CMC. Create users and assign the roles.
• Create BODS ETL Jobs, Work flows and data flows to load data from multiple OLTP retail systems such as Teradata Sql server and Flat files.
• Create various scripts transformation to control the data flow in BODS jobs and workflows.
• Implement error handling using BODS try-catch transformations and extensively used conditional transformation.
• Used various BODS transformations and implemented SCD type 2 to load the data in Dimension and Facts by using Join, query, Map Operation, Table Comparisons, Row-Generation, History prevention transformations.
• Extensively used Pivot, Reverse Pivot and functions like lookup, index search for transforming data.
• Follow the SAP code standards include naming conventions and code promote process using Central Repository version control by Checkout and Check-in methods.
• Debug execution errors using Data Services logs (trace, statistics and error) and by validate result data in target HANA system.
• Implement various performance optimization techniques such as caching, Push-down memory-intensive operations to the database server, etc.

Confidential, Calrsbad, CA

Environment: Oracle 11g, Sql Server 2005, Oracle EBS, Noetix DWH, Datastage 8.1, Informatica 9.5

BI & ETL Lead

Responsibilities:

• Interact with Business users, gather business requirements, analyze and convert them into technical landscape
• Provide technical direction for development, design, and enhancement for ETL & analytical solutions
• Used ETL tools such as DataStage Designer and Informatica Power center to design and develop the ETL jobs/interfaces
• Extensively used ETL jobs to load data from ORACLE EBS, SQL Server databases, XML & Flat files and processed into ORACLE EBS, Flat files to FTP/SFTP locations.
• Develop complex jobs using various DataStage stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator etc.
• Create Data stage using FTP stage and batch script for SFTP file transfers for Japan region processed data.
• Used DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Create Health check scripts to validate the mismatch data and automate the process
• Monitoring DWH loads and generating daily, weekly and monthly reconciliation and trend analysis reports.
• Support & Develop Informatica Jobs on packaged DWH - Noetix tool using modules such as Designer, Workflow Manager, Workflow monitor and Admin console
• Writing complex sql queries, Pl/sql procedures to extract the data from DWH for BI reports and tuning the queries
• Co-ordination with Offshore team.
• Perform code and design reviews. Enforces the coding standards

Confidential, Hartsville, SC

Environment: Oracle 10g, EBS, OBIEE 11g & OBIA (Manufacturing Analytics), Sql Server 2005, Informatica Power Center 8.6.1, and SAP information Steward 4.0 & 4.1

OBIEE Consultant & Data Steward

Responsibilities:

• Extensively used ETL to extract data from fixed width as well as Delimited Flat files, applied business logic to load them to Oracle databases.
• Created complex mappings using Expression, Filter, Connected/Unconnected lookup, Sorter, Aggregator, Router, Update Strategy, Union, Joiner and Sequence Generator transformations for populating target tables in efficient manner.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
• Created Unix Shell Scripts to schedule and automate the Informatica Workflows.
• Monitoring the scheduled ETL loads through DAC and fixing the issues.
• Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
• Working with the Business users for identifying potential reporting needs that will help them analysis the business trends.
• Preparing mock up designs for OBIEE dashboards and report requirements.
• Create connection pools, physical tables and customized views on Manufacturing Analytics predefined tables with existing DWH required tables.
• Create Dimensional Hierarchy; Level based Measures and Aggregate navigation in BMM layer. 
• Involved in implementing the Row level security for dashboards according to user requirements. 
• Developed custom reports queries using Oracle Answers and assigned them to application specific dashboards. 
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.  
• Developed complex out of box functionalities like Static HTMLs, navigations using Go URL methodologies etc.
• Monitoring the scheduled ETL loads through DAC and fixing the issues.
• Developed Pl/sql procedures to load the COMBINED (Manufacturing Analytics and existing DWH) data into OBIEE - Data Mart.
• Offshore development coordination, code reviews and ensuring project delivery.
• Updating the mapping documents and helping to the users in solving their technical issues and understanding about the Reports and Dashboards.
• Gathering information requirements for the Data Quality issues and analyze with business users / subject experts in implementing data quality process using through Information Steward 4.0 tool.
• Understanding the business rules and data process of different plant ERP systems and establishing the DB connection with the IS tool to evaluate the bad data.
• Developing the data quality metrics and dashboard by creating the data sets (Views/Tables), Rules, binding rules with data sets (views/tables) and creating the score cards using through IS Data Insight and Metadata Management Modules.
• Scheduling the jobs to run automatically in generating the updated SCORE Cards and make availability to the user access.
• Responsible for the maintaining, monitoring and governance of plant and enterprise level master data.
• Coordinated all changes through active participation in the running change and change implementation processes via mapping document (Excel spreadsheet) and make available to the data architecture and team members. 
• Following applicable escalation and helping to the users in solving the technical issues and providing the inputs and understanding the tool.

Confidential, NJ

Environment: 10.1.3.x, Oracle 10g / ETL (Datastage 7.5) / UNIX / Control-M and SQL server 2005

ETL Lead

Responsibilities:

• Developing ETL jobs using ETL -DataStage 7.5 designer by creating Mappings and Transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy between source and target using Datastage 7.5 designer.
• Monitoring ETL Datastage 7.5 load and fixing the issues. Provide root cause solutions.
• Scheduling and monitoring ETL job loads through Control-M and fixing the issues
• Attending the GES - Enhancement Tickets
• Assigning ticket to team members and discussing the status in Daily meeting
• Co-coordinating with onsite resource and tracking the all GES related activities and maintaining.
• Generating weekly/monthly reports on team ongoing and pending tasks and attending the calls with the clients
• Involved in Review and Quality checking of other team members Code

Confidential

Environment: Oracle 10g (Sql, Pl/sql) / ETL (Data stage 7.5) / UNIX

Senior ETL developer

Responsibilities:

• Interacted with end users to gather business requirements and transformed them into technical work plan.
• Involved in Data Modeling and creating ERD and DATA DICTIONARY using with ERWIN tool
• Created and maintained database objects required for the process in development and QA environments
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers
• Developed jobs using ETL - Datastage in Designer to extract data from different operational Sources like Flat Files, CSV Files, XML Files, Oracle and SQL server database and performed business operations on data like Cleansing, Transforming and Load (Initial/Incremental) into Target DWH.
• Created Design Documents and Unit Test cases with test Results Documents.
• Used Job Sequencers to orchestrate the parallel job execution and reporting the Status of the Job through Email
• Exported and imported the Datastage jobs between the production and the development servers
• Loading the data into the Staging and moving the data from Staging to ODS.
• Involved in Unit, Integration, system, and performance testing.
• Supported Data Reconciliation team during the data recon process
• Extensively used SQL coding for overriding the generated SQL in Datastage and also tested the data loaded into the data base.
• Supported the application after moving into Production and Troubleshooting the issues faced in Production support.
• Attending daily call with Onsite resources and resolving the issues.
• Deploying the DB objects and Code to PRE-PROD and PRODUCTION environments.
• Performed Data base Import / Export activities.
• Validation of Data Loaded by ETL Process.
• Participated in daily stand up with Team, Manager & Client

Confidential

Environment: Oracle 9i & .Net

Senior Oracle Developer

• Write complex Oracle SQL queries and PL/SQL stored procedures, functions and packages to implement the business logics in-order to process the data.
• Involved in Database Import / Export activities for DEV and UAT environments.
• Used the PL/SQL procedures/packages to kick off the SQL Loader control files/procedures to load the data.
• Involved in query optimization, performance tuning and DBA activities like import and export tables, granting privileges, Monitoring load process through Oracle OEM tool and advised to DB team to take necessary actions.
• Developed Pl/sql Package to create Health check scripts to validate the mismatch data and automate the process
• Preparation of Checklists, identification of Test Cases, preparing Test Plans.