Overview of Qualifications

With over 12 years of experience strictly in the field of ERP/Data Warehousing and Business Intelligence. Have worked technically across all facets of the DW/BI Project Lifecycle: from Requirements Gathering, to Data Modeling, to ETL, to Business Intelligence Development and Implementation. Well versed in Data Warehouse and Business Intelligence architecture and implementation, have demonstrated tremendous technical and functional capabilities in his management and execution of Data Warehousing engagements.

SUMMARY:

• Experienced Data Architect/Data Modeler, PL/SQL Developer, and Data Warehouse Developer with 12 years of overall IT experience.
• Oracle Certified Associate.
• Experience with ETL processes, including detailed knowledge about star-schema designing using Kimball Bill Inmon data-warehousing methodology
• Extensive experience using SQL, PL/SQL, SQL Plus, SQL Loader, TOAD, Oracle Designer, Oracle GoldenGate and UNIX. Extensively utilized OWB 11G R1, 10G R1, R2, ODI 12c as ETL tools in data integration and data-warehousing with hands on knowledge with data modeling and developing data marts, multi-level dimensions.
• Excellent skills in analyzing, gathering user requirements, and served as a senior technical liaison for various projects.
• Over seven years experience in developing, supporting, and maintaining complex PL/SQL packages and using latest oracle analytical functions to simplify complex queries. Further experience in query plans, dynamic SQL queries, DBMS JOBS, Autosys, and working with large volumes of data.
• Received several recognitions for simplifying and redeveloping very complex modules.
• Experience in preparing requirements and design documents such as system requirement specifications, system analysis and design, and established project implementations and development guidelines and standards.
• Deep understanding of healthcare, medical, and Rx claims data along with advertising marketing and vehicle leasing domain.
• Proven ability to adapt to new tasks quickly and to work equally independently or as part of a team.
• Proficient with CMM-level 5 processes for ETL SDLC and OBIEE reporting strategies.
• Well versed with data quality and data governance standards and experienced in MDM methodologies for maintaining and handling unique identifier processes and client Master data.
• Experience configuring Interactive OBIEE Dashboards with drill-down capabilities using global and local Filters, prompts , repository and presentation Variables
• Worked on integrating and configuring BI Publisher with OBIEE.

TECHNICAL SKILLS

• Languages: SQL, TSQL, PL/SQL, COBOL, Unix Shell script, OMB plus scripting
• Database: Oracle 9i, 10g and 11g, SQL, PL/SQL, ORACLE, SQL Server 2005, SYBASE, MS Access
• Application Tools : Oracle Warehouse builder OWB 11G R1,10g R1, R2,Oracle Data Integrator ODI 10.x, ODI 12c ,OBIEE 11G,Oracle Golden Gate , Oracle Designer 2000, Oracle Work Flow, Oracle 10G,11G, Facets 4.31, Oracle Golden Gate, Microsoft project, FTP, Putty, UNIX, ERWIN, Oracle Data Modeler, VISIO, MS Visual Source Safe, PVCS,ARC/INFO, ERDAS 8.5,ArcView3.2a, ArcGIS, Oracle Application Express Reports APEX
• Business Experience: Dimensional Modeling, Data Entity-Relationship ER Modeling, Data Extraction, Transformation, and Loading ETL , Dashboard Designing, Data Marts/Data-Warehousing and Project Documentation/Presentation.

Selected Work Experience:

Confidential

• A team member of the core ETL team that worked closely with the Business to develop a consolidated data store for all financial instruments in order to get a single view of financial positions holdings. The data was then used by the client's reporting java team.
• Extensively worked with ODI Designer in Creating Projects, Creating Models, Reverse engineering data-stores metadata from Database, developed ODI Interfaces, ODI Procedures, defined Project specific Variables/Global variables Declare, Set, Refresh, Evaluate Types , Defined the flow of execution in ODI Packages and generated ODI Scenario's once the execution flow is defined in package
• Experience in creating complex ODI Maps and experience using most of 12c Components
• Performed the customizations to the ODI Knowledge Modules as part of tuning the Knowledge Module Code based on the requirements to log data load information.
• Experience working with Oracle Golden gate replicated table to move data into data store using ODI 12C .
• Experience in Querying Oracle data integrator work repository tables for capturing the information related to ODI Operator Logs.

Confidential

• Played an important Role in the effort to implement sales and profitability Analytics data warehouse and also helped designing the data loads using OWB R2. The technical environment consisted of OWB, OBIEE, PL/SQL, and process flows to load star-schema data marts.
• Helped design and develop OWB maps and process flows.
• Created/Edited documentation for the data loads.
• Designed the test cases in quality center to help testing teams complete the test plan in time.
• Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters as per the client requirements.

Confidential

• Helped redesign the data warehouse to make the system scalable the accommodate data coming from state school districts. The technical environment consisted of ODI, OBIEE, APEX, PL/SQL, and process flows to load CRM database and then load the data to a star-schema model.
• Helped with data modeling to change old objects and create new loads.
• Configured new Data Servers, Data Stores, developed ODI Interfaces, Load Plans to accommodate new requirements and developed Packages, Scenarios.
• Analyzed existing transactional database schemas and designing Star schema models to support the users reporting needs and requirements.

Confidential

APEX/ODI 11G Developer

• Helped design the Sales Forecast Applications Express Solution. The technical environment consisted of ODI, OBIEE, APEX, and PL/SQL.
• Developed Sales application using Oracle Application Express APEX
• Created Functional and Technical Design Specifications TDS for ETL processes. Data cleansing according to defined Business rules. Developed detailed Source Target Mapping STM design documents.
• Developed Interfaces, Configured Data Servers, Agents, Scenarios in ODI
• Experience in developing Multidimensional Data Model, designing logical and physical modeling, data warehouse architecture for EDW MDM, data quality, decision making and analyzing user requirements.

Confidential

OWB ETL Consultant

• Played an important Role in the effort to implement supply chain management SCM subject area and also helped designing the data loads using OWB R2. The technical environment consisted of OWB, OBIEE, PL/SQL, and process flows to load star-schema data marts.
• Developed complex OWB maps for Plans ,Forecast, Product, Variances data loads and process flows
• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Extensively worked on Answers, Dashboards and Generated Complex reports by using OBIEE report features like Unions, Pivot tables, Charts, Ticker, Narrative and View selector.
• Designed the test cases in HP quality center to help testing teams complete the test plan.
• Imported required physical tables Dimensions and Facts with integrity constraints into Physical Layer using connection pool and defined Physical Joins using new foreign key join.
• Designed and developed Reports and Dashboard metrics for Sales and Financial reports. Performed QA and data validation.

Confidential

ODI Developer Data modeler

• Silliker has implemented an end-to-end Business Intelligence solution to support the enterprise level reporting needs from a single platform. The BI solution was a custom application build using OBIEE as front end and ODI and PL/SQL used for ETL. This solution was needed for revenue forecasting and planning activities. Provided support and mentored BI developers while providing guidance and data analysis help
• Built the data model for the stage schema for all the data sources including SQL Server, Oracle, and flat files.
• Built the data model for the dimension and facts to build the star schema.
• Developed pl/sql procedures needed for ETL activities as well as for time dimensions.
• Managed one direct report, a junior ODI developer from the Silliker team who would receive knowledge transfer and take over the application in production.
• Developed PL/SQL scripts to ETL new data fields for end user requirements
• Created ODI procedures, interfaces, packages, scenarios, and tools utilizing KMs for reverse engineering, Loading and Integration ODI objects load staging tables, dimension tables, and fact tables.

OWB ETL Lead/OBIEE Developer

Environment: OWB 11G, Oracle 11g,OBIEE 10G

• Lead a team effort to implement a meter reconciliation subject area, also helped in creating hierarchy for the meter location dimension using Kimball Bridge Table. The technical environment consisted of OWB R2 and workflows to load star-schema data marts. Worked also on PLSQL and AUTOSYS.
• Developed OWB mapping for location, meter, customer in ENDW and Data mart.
• Developed the JIL files for Autosys to set up the schedule jobs/process flows to refresh the data warehouse.
• Coordinated with the end user and the off shore team to set develop the .net application developed for the end users to input the metadata to run the data warehouse.
• Developed complex data processing engine using advanced PL/SQL features to process high volume for reconciliation subject area.
• Created materialized views and aggregates to improve performance.
• Created multiple Dimensions Drill-Down Hierarchies Fact objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Managed OBIEE Dashboards for Meter Monitor Analytics, Revenue Forecasting and Capacity Planning areas of analysis
• Used Filters and provided Customized prompts using presentation variables and Materialized Views to increase the performance and avoid excessive data showing up Reports.

Confidential

ODI Developer

Environment: OBIEE 10gR3, ODI 10.1.3.5, Oracle Application Express 3.01, Oracle 11g

• Alabama Power Company implemented a Data Warehouse/BI Solution for the first time in some of their Business Units. It was important to prove the value, reliability and efficiency of the Business Intelligence solution for further iterations of the Project to gain support from Alabama Power Executives and Sponsors. An initial POC turned into 4 Phased Engagement with additional Phases lined up for coming months. This has been possible by the Expertise of the Rolta TUSC Management and Consulting Team which has provided the Technical expertise and Functional Management required installing, Develop and delivering a DW/BI Solution using OBIEE and Oracle Data Integrator.
• Create Reports for Metadata and user input screens in APEX for end user.
• Created ODI Procedures, Interfaces, Packages, Scenarios and Tools utilizing KMs for Reverse Engineering, Loading and Integration ODI Objects load Staging tables, Dimension tables, Fact tables
• Optimize data access and data loading techniques.
• Designed the ODI Agent setup to run and process ETL Jobs locally on designated servers.
• Created knowledge transfer and turnover documentation for the OBIEE and ODI implementations

Confidential

Data Warehouse Architect

Environment: OWB 10g R1 R2, Obiee 10G, PL/SQL

• Responsible for Designing and developing Star schema data model using Data Modeler for corporate Business Intelligence data warehouse.
• Developed and maintained Master Data repository, maintaining PHI Patient Health Information .
• Architected and developed the process of collapsing Claims Metrics and maintaining medical, Rx client data claims for Business Intelligence Dashboard and cleansing Data for ROI reports.
• Development of Data Warehouse ETL process, Dimension modeling and reporting strategies.
• Architected various Data Marts for different business units within the organization.
• Benchmarked the process of repository migration in Oracle Warehouse Builder.
• Performed the upgrade and migration of OWB 10G R1 into 11G R1.
• Developed the initial Corporate Data Governance policies and strategies with help of Corporate HIPPA compliance Officer.
• Developed various optimization and performance methodologies in conjunction with the DBA for optimal performance of the data warehouse including index handling, partitioning schemes and backup strategies for high availability.
• Scheduling, loading, cleansing and integrating source data into data warehouse from different sources such as Siebel CRM application, Web application SQL Server , and flat files
• Appointed as the Lead data architect for Data conversion and data migration projects from legacy CRM in multiple implementations of Siebel CRM.
• Lead the effort of Migrating data from MS ACCESS database to Oracle XE database Reporting Data Warehouse RDW for reporting .
• Metadata Integration Strategy for the Enterprise Data Standards Initiative including software evaluation and information integration and management method development.
• Changed all daily outbound customer feeds from PL/SQL to automated process using Oracle warehouse builder.
• Developed Logical and Physical models for repository handling Patient Unique Identifier logic. developing ETL processes for point in time reporting
• Developed maps and process flows to populate and maintain dimensions and facts for Siebel OBIEE.
• Architected CDC mechanism to capture new inserts and updates in the source table.
• Developed multiple custom processes to automate data feeds into SQL Server application from Oracle and extract data from SQL Server to feed into Siebel CRM in real time.
• Experience maintaining and updating reference codes related to Medical and Pharmacy claims such as ICD-9 Diagnostic and Procedure Codes, Revenue Codes, CPT Codes, HCPCS Codes, NDC Codes, NPI Codes etc.

Confidential

OWB ETL Developer

Environment: OWB 10g R1 , PL/SQL

• Installed and configured Oracle Warehouse Builder repository Designer and Deployment .
• Created mapping using OWB operators Un-pivot, Lookup, De-duplicator Transformation and Join, Split Operator and Sequence, and User-Defined Transformation, pre/post mapping .
• Resolved many production problems in various situations.
• Created ETL Processes for new Customer Subject areas, developed Data Extraction, Transformation and Loading Program using integration services.
• Expertise in ETL documentation, design, and development by applying business methodology.
• Created client implementation roadmap for new client by gathering requirements from various stakeholders Subject Matter Experts, PMO, client DW team, and executive management .

Confidential

ETL Developer/Technical Lead

Responsibilities:

• Carried assessment at MVP Health to identify the remediation activities to ensure compatibility of the existing custom processes with the latest version of Facets 4.31 for successful upgrade.
• Work for remediation of existing maps into target due to data model change in higher version of facets.
• Developed an advanced user notification system by developing a scheduler, email notifications and data profiler in OWB 11G.
• Authored development and maintenance best practices handbook which included detailed database standards policies for the whole development team.
• Responsible for 24/7 system data loads and scheduled jobs, along with addressing issues to ensure smooth functionality for critical business processes.
• Utilized OWB, Toad, PL/SQL and Crontab for scheduling, loading, cleansing and integration of corporate customers' files on employee, medical and pharmacy information.
• Worked with account managers and customers to develop requirements for data feeds. Maintained relationships with customers and data providers to resolve issues on feed scheduling, delivery methods, data errors, eligibility rules and updates to requirements and file formats.
• Used pre-mapping and post-mapping for capturing audit information and calling stored procedure to disable and enable constraints indexes on the source tables.
• Created mappings to get the I-Card information into flat files to be sent to third party for I-Card printing.
• Used collections to move mappings and other objects from development schema to testing schema.
• Created mapping to import and export data into flat files third party claims and also import new provider agreements information on monthly basis.

Confidential

Database Developer

Responsibilities:

• Installation Configuration of Oracle Warehouse Builder.
• Low level of details captured in a bus matrix for vehicle insurance data mart.
• The granularity of the fact table was brought to one row for a unique claim life cycle.
• Used external tables to perform complex transformations on the monthly sales flat file data before loading data.
• Implemented slowly changing dimension type two to track customer history based on address change.
• Documented the ETL specifications and created test cases for testing in different environments.
• Developed Forms and implemented Data model changes using Designer 6i Case Tool .

Confidential

Database Developer

Responsibilities:

• Created shell scripts to automate day-to-day operations.
• Developed numerous Stored Procedures, Functions and Packages to implement application logic in Oracle.
• Digital Image Processing of high-resolution satellite images IRS-1D PAN and IRS-1D LISS III.
• Application of Geospatial technology for creation of GIS layers and information extraction from space images. Customized VB application using VB Map Objects to make it user-friendly.
• Integrated base map generation using image processing and geospatial tools.
• Spatial Database generation for Ranthambore National Park using advanced GIS techniques.
• Use of Navigation system for locating geographic coordinates by advanced 12 channels Global Positioning System and its integration with geospatial database.

Confidential

IT Developer

Responsibilities:

• Migrated legacy system to Visual FoxPro.
• Implemented enhancements in payroll module, ESI/PF calculations, excise reporting and developed new reporting tool.
• Tools to synchronize data received from different C F agents. Data received from each C F was disparate, so had to develop 13 different modules to accomplish data transfer.