SUMMARY

• DW, ETL, Analytics, Dashboards, Database & Metadata administration, Installation, configuration & upgrade of OBIEE platform (ETL and OBI tiers), Out of box and custom work, security implementation, client/project management, solution architect, pre and post sales support
• ETL: Informatica 8.x and 9.x, ODI 10g and 11g, OWB10g and 11g, Cognos
• OBIEE: 10g and 11g: dashboards, RPD and security
• Analytics: Financial, Procurement & Spend, Supply Chain, Order Management, Manufacturing, Project, HR (Recruitment/Workforce), Service, CRM Service
• Data sources: Oracle, EBS R11x, R12x, PeopleSoft, SAP, MySQL, MS SQL Server, CSV
• Hyperion ESSBASE, Planning Applications, SmartViews
• Fusion Transportation Intelligence (FTI) for Transportation Management (OTM)
• Oracle Retail: RMS, AIP, RPAS (Acumate, RDF, MSPL), RDW, RETL
• OPTUM’s Warehouse and Order Management System
• Erwin: Logical and physical data modeling for OLTP and OLAP data repositories
• Oracle 7 thru 11g, SQL Server, MySql, Teradata
• Oracle DBA 11g, EBS Apps DBA, ASM, RAC, Cloning, R12 upgrade, migration
• Teradata’s Multiload and Fastload over AMP VPROCs and VDISKs architecture

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Senior Consultant

Responsibilities:

• Install and configure ETL and OBI infrastructure using ODI 11g and OBIEE 11.1.1.7
• Implementing OBI Analytics 11.1.1.7.1 for Financial, Procurement & Spend, Supply Chain, Order Management, Manufacturing, Project and HR analytics
• Maintaining and administering Noetix views against EBS 12.1.3 instances
• Install and configure OBI 11g infrastructure in multi - hosts setup for complete ETL and OBI dashboards using Informatica 9.1 and OBIEE 11g for development, QA and production environments
• Upgrade OBIEE from 10g to 11g
• Upgrade OBIEE 11.1.1.6 to 11.1.1.7
• Upgrade DAC from10g to 11g
• Upgrade OBI Analytic from 7.9.6.2 to 7.9.6.4
• Upgrade Informatica from 8.6.1 to Informatica 9.1
• Custom changes to ETL and dashboards for further enhancements and performance improvement
• Develop custom dashboards and create users with different application roles
• Bug fixes and enhancements to ETL and OBI tiers
• Data modeling for new ad-hoc data source

Confidential, Atlanta, GA

Sr BI Architect / Manager

Responsibilities:

• Installed and configured OBI infrastructure using OBIEE 11g and OBIA for various analytics for EBS and PeopleSoft data sources
• Installed and configured Oracle Fusion Transportation Intelligence (FTI) 6.2 for Oracle’s Transportation Management and also integrated the environment with Oracle Data Integrator services
• Integration of OBIEE with OTM engine using ODI, OWB and FTI
• Analyze business requirements to develop interactive Dashboards and Ad Hoc Reports using OBIEE
• Implemented application roles based security using WebLogic’s LDAP based security
• Effectively translate business/functional reporting requirements into clear and concise assignments

Confidential, Tampa, FL

Consultant

Responsibilities:

• Worked as a member of Business Intelligence team to support OBIEE, OBIA, ESSBASE and Informatica Power Center products.
• Installed, configured and administered the repositories for Informatica, DAC and Business Intelligence on Sun Solaris Sparc host. Responsible for improvement of ETL process, metadata repositories as well as dashboards (front and back end both).

Confidential, Tampa, Fl

Senior BI Consultant

Responsibilities:

• Installed and configured ETL and OBI tiers for implementation of various analytics
• Implementing out of box as well as custom development of number of analytics: financial, procurement & spend, HR (Recruitment/Workforce), Supply Chain, Order Management, Project
• Integration of security with EBS, SSO and LDAP
• Performance improvement at ETL and OBI tiers
• Evaluated and provided bug fixes to the DISCOVERER and Publisher reports
• Migration of Publisher and DISCOVERER reports to OBIEE dashboards
• Develop migration, UAT, training and support strategies and carry them out to the customer’s satisfaction

Confidential, Tampa, FL

Consultant

Responsibilities:

• I worked in a team to load the organizational, contractual and sales data from ERP/legacy systems to Oracle 10g using Hyperion’s Informatica toolset (DIM). Source systems were PeopleSoft, SAP (IDOCS) and legacy systems and data provided was in flat files as well as XML. Targets were data warehouse, data marts and XML files.
• Created logical and physical data models for EDW and data mart using Erwin
• Created ETL Mappings/Workflows using Informatica PowerCenter
• Implemented exceptions for data cleansing and data quality

Environment: Infrastructure management for government Business Intelligence, DW, OLAP BI Oracle 10g, Informatica 7.1/8.0, Erwin, PLSQL Developer

Retek Business Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Worked in a team to implement standalone RPAS to support major retail outlet. This data was related to the inventory and sales for planning and demand forecasting. Sources were SQL server, flat files and excel sheets. Targets were Oracle 10g/Acumate.
• Create and load new base and alternate hierarchies to support product and stores hierarchies
• Load planning data (product, stores and time) for calculations of various measures using loadmeas
• Manage Workbooks for end user viewings

Environment: Supply Chain and Retail Inventory Analysis and forecasting, BI Oracle 9i Retail, RPAS, RDF

DW Analyst

Confidential, Columbia, MD

Responsibilities:

• Worked on a project to build ODS and Staging area for EDW by pulling the data from AS/400 systems into Oracle 10g database. Data pertains to the health insurance members and their validation for claims. Sources were AS/400 systems and incoming data was in flat and XML files formats. Targets were data warehouse and XML files.
• Participated in upgrade of Oracle OWB from 9i to 10g
• Evaluate the logical and physical data models for the EDW with Erwin
• Develop ETL process flows under OWB for data cleansing and loads
• Develop shell and PL/SQL code to launch OWB to execute the process flows
• Enhancement to Oracle streams code for data mirroring

Environment: Healthcare industry Rx membership / claims processing, DW, BI, Oracle 10g, Streams, OWB 9i / 10g, Erwin 4.1.4, Toad, PL/SQL, shell, RAD (issue resolution)

Retek Analyst

Confidential, Dallas, TX

Responsibilities:

• Participated in the implementation of Oracle Retail AIP and RPAS. This project involved development of PL/SQL code and shell scripts for data transfers from legacy to RMS and AIP systems. RMS/AIP (Oracle 10g) would hold data related to inventory planning (allocation, replenishment, supply chain, etc.) and supply chain management and RPAS (Acumate) would hold date related to various hierarchies.
• Design and develop ETL scripts using shell, RETL and RetekFTP
• Planning for data transfer (purchase and transfer orders) between RMS, AIP and legacy systems
• Building dimensions in AIP for Pack/Eaches and Physical/Virtual warehouse transformations
• Evaluating hierarchies in RPAS Acumate with MSPL and RPAS client
• Work with RPAS configuration tool and Forecast Administration Wizard to define parameters for RDF

Environment: Government Retail SCM, Inventory planning, AIX, Oracle 10g, AIP (SRP, WRP, WIP, OM, DM), RMS, RETL, RPAS, RDF, Toad, SQL Developer, shell, perl, PL/SQL, PRO*C

DW Architect

Confidential, Tampa, FL

Responsibilities:

• Participated in the implementation of data warehouses for new product offerings, customers and claims transactions. Data sources were AS/400 and XML/CSV files, target was Oracle.
• Created the data model using Erwin for new health insurance offerings, the membership and claims
• Implemented ETL using PL/SQL and optimized the performance using indexes and analytical functions
• Created ODS, data marts and EDW for members, drugs and claims
• Generated metadata, logical and physical layouts for development, administration and reports

Environment: Healthcare industry Rx claims processing, DW, BI, Oracle 10g, OWB, Streams, Erwin 4.1.4, SQL Navigator, Hp/ux, NT, Shell, Perl and PL/SQL scripting, JAD/RAD sessions

DW Architect

Confidential , Tampa, FL

Responsibilities:

• Worked on a project to build data warehouses for pharmacy claims transactions. Data sources were legacy hosts, AS/400, XML files, Oracle and SQL servers and target was Oracle. Data was initially pulled into staging area (ODS) and then data was pushed into EDW so that individual data marts and reporting team can extract the data for their individual needs. I coordinated efforts of a team of 6 engineers.
• Used COGNOS FrameWork Manager to generate the business model of data mart
• Used COGNOS DecisionStream (Data Stage) and Oracle streams to design ETL processes
• Used COGNOS ReportNet to develop basic reports for validation
• Created logical and physical data models using Erwin to hold pharmaceutical claims and reject history
• Created ODS and REPOSITORY of data related to claims and rejected claims
• Developed PL/SQL stored procedures for data cleansing and transformation
• Performed DBA duties to optimize the performance and thru-put for data loads and reports
• Implemented audit functionality in the database to streamline the data transfer processes

Environment: Pharmaceutical industry Rx orders/claims processing, DW, BI Oracle 9i, Streams, Erwin 4.1, COGNOS tools set, Enterprise Manager, SQL Server 2005, Query Analyzer, PL/SQL, RAD sessions

Confidential, St. Petersburg, FL

Systems Analyst

Responsibilities:

• I participated in the implementation of OPTUM’s Warehouse and Order management projects. I worked with technical users and internal customers to resolve performance and bugs related to inventory and order management. I worked with Java Servlets, Pro*C and Forms/Reports to implement new functionality and provide bug fixes. Also used shall and PL/SQL extensively for batch processing of order management, inventory reconciliation, allocation, replenishment, etc. I performed data analysis for ETL and data cleansing to establish the data integrity and consistency across applications.

Environment:: SCM Retail WMS, Support, ETL, Solaris, NT, Optum’s WMS, Oracle 9i, Forms 5, SQL*LDR Toad, Visio, Erwin, PL/SQL, PRO*C, JSP

Confidential, California

Consultant

Responsibilities:

• Participated in the implementation of Oracle Retail for Supply Chain Management. It would support the retailers’ orders for stock replenishment and sale management for regular promotions.
• Gather business and systems requirements to design an architecture for SCM
• Evaluate the data flow among disconnected systems for data conversions into a centralized system
• System Analysis and connectivity planning for conversion from legacy to Oracle Retail
• ETL architecture to load legacy and disconnected data into Oracle Retail (RMS)
• Planning for batch processing, data mining, EDI

Environment:: Retail: SCM Retail Inventory Solaris, Oracle9i, RMS 9, RETL, Visio, Erwin, Toad

Confidential, California

DW Data Analyst

Responsibilities:

• I developed star schemas, logical/physical data models, OLAP cubes, web-based reports, metadata, automated batch processes for ETL as well as applications management and code in shell, perl, PL/SQL, PRO*C, C, C++ and Java languages for Oracle and MS Server. I worked with business analysts, end-users, customers (internal as well as external) for problem analysis/resolution, tasks managements and resource co-ordination.
• Developed data warehouse of company’s sales, cost and revenue data to perform the cost analysis, market review and demand projection. Used Erwin to create star schema and MS Cube Builder to generate cubes for OLAP reports using Brio Reports. Developed reports with Oracle Portal (WebDB). Used Project Plan for project management activities of a team of five engineers.
• Developed ETL strategy using Informatica for data loads and cleansing among dissimilar sources and targets. Used Erwin to develop and maintain ERD of data warehouse for technical publications and product/customer sales warranty information.
• Developed logical and physical data models for Oracle 8i and SQL server. Developed PL/SQL packages for data aggregation and summarization. Performed database performance improvement by doing reverse engineering, schemas improvement and query optimization processes.
• Developed multi-threaded Video File System in C for Video Broadcast Server computer running Hp/ux (RTOS). Code was written using Unix IPC. Developed shell/perl scripts for integration and testing.
• Participated in migration of legacy to SAP conversion project. Participated in FICO functional design of various menus and process flows. Developing ABAP code using ASAP methodology for rapid delivery, Menus and Reports for finance and inventory

Environment:: Business Intelligence, ETL, Finance, sales, support, Hp/ux, Oracle, Portal, SQL Server, Informatica, Brio, Erwin, Toad, Visio, Developer/2000, Designer/2000, PRO*C, Perl, Shell, PL/SQL

Confidential, California

Systems Integration Engineer

Responsibilities:

• I led the team of 4 engineers to design and develop an OLTP/CRM application for customer order management using UNIX IPC, TCP/IP sockets and ORACLE PRO*C interface. Also implemented a data warehouse for planning
• Requirement gathering, problem analysis & resolution
• Developed logical and physical data models for a decision support system
• ETL processes with fall-back/recovery mechanisms to synchronize the data among 300+ hosts
• Implemented aggregation and summarization steps in data warehouse for better reporting

Environment:: OLTP, Finance, system integration, sales, support, Solaris, Oracle, Form, Reports, Loaders, PL/SQL, PRO*C, shell, sockets, IPC, multi-threading, batch processing