PROFESSIONAL SUMMARY:

• Expert Senior BI / DW professional with nearly 15+ years of IT Industry experience. Held multiple roles over my career including Project Lead, Solution Architect, BI Architect / Developer, ETL Architect / Developer, Data Modeler, Business Analyst & Tester.
• Experience delivering BI / DW solutions using Agile, Scrum and Waterfall delivery methodologies. Participated in full - solution lifecycle stages from Planning, Analysis, Design, Coding, Testing, Migration, Production Support and implementation of software applications.
• Experience delivering solutions for domains including Finance, Insurance (P&C), Retail, Discrete Manufacturing, Transportation & Telecom.
• Hands-on technical expertise with Oracle Data Integrator 12c/11g, Informatica 9.0, OBIEE 11g/12c Tools.
• Excellent team player, enthusiastic initiator, and ability to work in large and small teams as well as independently. Good communication and excellent problem solving, analytical skills.
• Excellent all-round knowledge and expertise in delivering Data Warehousing Solutions using ODI 12c/11g, Informatica, OBIEE Tools:
• Experience developing realistic time estimates and identifying dependencies
• Designed and developed ODS, Data Mart (Kimball), Enterprise Data Warehouse (Inmon)
• Hands on experience with modeling Star Schema & Snowflake Schema models.
• Data validation and standardization experience using SQL Scripts to reconcile and validate data after loading data through ETL.
• Experience with using RDBMS technologies like Oracle, Teradata and SQL Server 2005/2000 databases.
• Multiple complex ETL mappings that include performance/debugging/monitoring for Insurance, Finance, Telecommunication domain using Informatica/ODI12c/11g.
• Proficient in conducting end user across multiple BI / ETL technologies
• Experience delivering solutions across multiple business areas including Finance, Sales, Marketing, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Quality, Inventory Warehouse Management, and Supply Chain.
• As ODI Architect/Developer, Hands-on exposure with ODI 11g/12c (Topology Manager, Security, Designer and Operator)
• Used ODI 12c/11g to create packages, interfaces, procedures, scenarios and load plans that assisted in publishing data for part catalogs. Migration of Code from different stages(DEV/TEST/Production)
• Understand real-time data extraction using functionality provided within Oracle Golden gate technology (v11g) and hands-on experience integrating with ODI 12c and loading into Oracle ODS.
• Developed complex mapping(s) / reusable mapping(s) using Expression, Aggregation, Filter, Set, Lookup, Split operators.
• Complete setup of ODI (Master & Work Repositories) from scratch that includes Topology (Physical /Logical Architecture, Agents, Contexts) & Security setup.
• Converted manual SQL Scripts/ complex stored procedures to ELT mappings using ODI12c and scheduling as per user requirement using Load Plans.
• Created Customized knowledge modules (LKM, IKM) based on business needs and executed Scenario/Load Plan/Package deployment into Target Data mart(s).
• Performance tuning for various phases from Database to ELT based mappings.
• Experience with SCD Type 1 & 2 (CDC) implementation based on user requirement.
• Conducted KT sessions on how to run the mappings & scheduling the load plans.
• Experience extracting data from Oracle Analytics 11g (Financial Analytics, Human Resources Analytics, Procurement and Spend Analytics, Supply Chain Management & Order Management Analytics, Profitability Analytics, Manufacturing Analytics) and loading Oracle 11g ODS.

TECHNICAL SKILLS:

ETL Tools: Oracle Data Integrator (11g/12c), Informatica 8.6.1 Hotfix

BI/OLAP Tools: OBIEE 11g/12c, Tableau 9.0

Modeling Tools: ADONIS Modeling Tool, Erwin, Microsoft Visio

Languages: HTML, Java Script, TCL (for OWB), Unix Shell Programming

Operating Systems: Windows 2000/7

Databases: Oracle 11g/10g, MS-SQL Server 2005, Teradata

Others: PL/SQL Developer, Toad, Oracle Data Pump, Service Now

PROFESSIONAL EXPERIENCE:

Confidential: Sacramento, CA

Azure Data Factory BI Architect & Developer

Responsibilities:

• Building the pipelines to copythe data from source to destination inAzure Data Factory(ADF V2)
• Migration of on premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake Store(ADLS) using Azure Data Factory(ADF V2).
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
• Developed Validation subsystem to provide ability to data owner to view data quality issues (exception reports using OBIEE tool) and take actions to resolve them in self-service manner at any time with less stint.
• Provided ability to data owner to update lookup tables, Create/manage adjustments, initiate Data Validations (Package of ~26 validations), data refresh jobs via file based interface (CSV file method) and Mixed protocol share that are developed jobs using ODI 12c tool.
• Used Kimball/Inmon DW guidelines to follow Star Schema Design, Table structures, Exception Processing .Used ODI Tool (odiFileWait, odiFileMove, odiFileCopy etc.) for CSV processing method to run on demand rather than schedule the jobs. This method prove that so benefit to user that they can do operation by own by seeing data and any time to get their desired output quickly to save time.
• Successfully developed Open Enrolment Data Mart (Access & Event metrics derived from MSS Application) for HAMD Business team and deployed to Production. Currently Jobs are scheduled to run every day morning at 2 AM. Working on Weekly metrics for OE period.
• Worked on Functional Allocation Phase 2, to break the High level Summary data to detail staff level for easy reporting. This process is completely automated via ETL tool. Functional area’s like (AUM, External Management fee, Personnel (Base & Incentive Comp), Operating, Admin expense etc.) processed sequentially using SDLC methodology ( Design, Analysis, Validation, Data cleansing, correcting source data using peoplesoft HCM data.
• Developed complex automated business rules for above functional groups with less stint. By implementing these rules saves ample time for INVO with accurate data.
• Automated Exception handling and conducted user awareness sessions for INVO about BI automation proposal of most complex problems for functional allocation. Received positive feedback from customer for the proposals and given go ahead to implement the BI proposals.

Technologies: Azure Data Factory V2, ODI 12c, Oracle, SQL Server, Service Now, Flat Files (csv,tsv,xls etc..)

Confidential

ODI Developer & Architect

Responsibilities:

• Participated in Data Modeling for CCSI Account Arrangement for Each Client & Financial Advisor to understand High Level requirements.
• Created Logical Data Models using Microsoft Visio by understanding Functional Requirements.
• Experience in developing the load plans, packages and job scheduling. Installation of ODI11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
• Complete End-to-End installation of ODI on remote systems that include setup of Master & Work
• Analyzed Data sources and target data models and proactively identified problem areas & plan/ implement steps for process improvement.
• Created Unit Test Plan, VSD Diagrams, DIT Review sessions that reviewed with final stake holders

Technologies: ODI 12c (12.1.3), Oracle, Flat files, Service Now, SharePoint.

Confidential

Oracle Data Integrator Architect & OBIEE Reporting Analyst

Responsibilities:

• Prepared data model(s) ~Blue print for each above Subject Area (EBU Data lab, Revenue Data lab, IBRO Data lab, Semantic Data lab) before actual development.
• Performed Exporting and Importing CDC objects using Oracle Data Pump.
• Design of Reports and Dashboards, rpd (Repository) file and pivot tables, graphs, scheduling, alerting mechanism etc.
• Participated in the User Acceptance Testing (UAT).
• Set-up user level security for dashboards and reports, per client specification
• Automated Export/Import of scenarios across environments (Development, Test and Production)
• Experience extracting data from Oracle Analytics 11G (Financial Analytics, Human Resources Analytics, Procurement and Spend Analytics, Supply Chain Management & Order Management Analytics, Profitability Analytics, Manufacturing Analytics) and loaded into Oracle 11g ODS
• Met with Business Stakeholders and Functional team to gather project technical requirements.
• Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces. Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Developed the migration process required to migrate ODI configuration through test, production and contingency environments.

Technologies: OBIEE 11g, BI Publisher, ODI 11g, Oracle 10g (SQL Queries, PL/SQL), UNIX Shell Programing, Flat Files.

Confidential

Responsibilities:

• Used the OBIEE Admin Tool to develop the three layers in the Repository. The Physical, Business Model and Mapping layer and Presentation layer (RPD) analytics. Migrating reports /dashboards between different environments.
• Added required dashboard pages per senior management requirements.Added relevant projects in the Company RPD for new subject areas, and developed the star schemas using the OBIEE Administration Tool. Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Used the OBIEE Admin Tool to develop the three layers in the Repository.(RPD)

Technologies: OBIEE 11g, Oracle 10g (SQL Queries, PL/SQL), PL/SQL Developer, Flat Files.

Confidential

Informatica Technical Architect & Developer

Responsibilities:

• Responsible for handling & maintaining servers part of development, Test, Stage, DR, Production environments
• Created mapping documents to outline data flow from source to targets.
• Developed mapping parameters and variables to support SQL Override.
• Created sessions, configured workflows to extract data from various sources, transformed data, loading into data warehouse.
• Used Type1, Type2 SCD Mappings to update slowly changing dimension tables.
• Worked on complex Source Qualifier queries, pre and post SQL queries in the Target.
• Documented & tracking the changes and upgrading in the application.
• Working on the Change Management to effectively manage changes related to the application
• Delivering new system enhancements which includes version upgrade and system upgrades Migration

Technologies: Windows XP, Oracle 10g (SQL, PL/SQL), Cognos 8, Informatica 8.6.1 Hotfix, Pl/SQL Developer

Confidential

Senior ETL Developer

Responsibilities:

• Conduct due diligence, knowledge acquisition and design review phase.
• Preparation of high level and low level design documents for extraction, transformation & loading (ETL) and user interface (UI) phase.
• Create mockup, their review and prototyping phase for ETL & UI at offshore.
• Capturing of change requests (CR) owing to changing business requirements, its review and prioritization with business teams.
• Creation of performance management, quality assurance, system integration & load testing strategies and their implementation.

Technologies: HP-Unix, Oracle 10g, SQL, PL/SQL, Oracle Warehouse Builder 10G R2, Cognos 8 (Report Studio)

Confidential

ETL Developer

Responsibilities:

• Business Benefits Include: Allows Users to create or update projects in Informatica or Oracle Projects and synchronize Project structures, activities, resource details and assignments, budgets, actual cost, progress and cost to complete in both systems
• Involved in writing scripts, procedures to load data from different legacy systems to staging area as well as to load data from staging area to Star Schema.
• Debugged the mappingsby creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Developed Reusable Transformations, Aggregations and created Target Mappings that contain business rules.

Technologies: IBMAIX64 8.1.0, WINDOWS NT, SQL, PL/SQL, Informatica 7.1, VSS, Toad 7.6