OBJECTIVE:

Oracle Consulting, Public Sector Expert, Federal, State and Local Government Implementation Expert, Commercial ERP, Consulting in Retail Selling/Direct Selling/Education, Data Warehouse Implementations, Business Intelligence projects, Multiple BI Apps implementations.

PROFESSIONAL SUMMARY:

• Confidential is a senior techno/functional ERP specialist/Business Intelligence - BI-ETL Architect/ DWH Managing consultant with over Twentyone (21) years of hands-on technical experience in USA implementing multiple ERP/Business Intelligence projects.
• Confidential has worked with Oracle ERP implementations (11i, R12) Financial Modules, Procurement, Accounting, Confidential, Manufacturing modules, Supply Chain, Human Resources (HR), Projects, Grants, Treasury, Transport module (OTM), ERP Custom Development, Oracle Fusion Middleware, SOA platform, JDeveloper web service development, Integration of multi Org/Multi Currencies within EBS, ERP release upgrades and Oracle ERP Expert witness consulting. Confidential is also an expert in Business Intelligence Implementations using OBIEE and Discoverer with Data Modeling experience (ERWIN, SQL Modeler).
• Confidential has been a BI Architect and ERP Techno Functional Lead Managing Consultant for over several years, working in several projects, implementing ERP/Custom Solutions, Business intelligence applications and Data Warehouse solutions.
• Being part of the assessment of business processes and improving business process software packages according to the client s requirement, Confidential had designed developed and successfully implemented Software Designs and Technical Design Documents using standard methodologies.
• Confidential has in depth experience in converting data from legacy to ERP systems, developing interfaces between financial subsystems and implementing performance benchmarks. Confidential 's expertise in ERP modules include General Ledger (GL), Accounts Payable (AP), Oracle Purchasing (PO), iProcurement, iExpense, Accounts Receivable (AR), Trading Community Architecture(TCA), Fixed Assets (FA), Cash Management, Project Accounting (PA), Oracle Service Contracts, Grants, Treasury, Workflow, E-Commerce Gateway (EDI), Inventory, Order Management (OM), Property Management (PR), Human Resources (HR), Advanced Benefits (OAB), Oracle Training Administration (OTA), Oracle SCM, Oracle Advanced Pricing, Demantra, Lease Management, iProcurement, Self Service, Business Intelligence and ERP System Administration.
• Designing and developing Enterprise BI Applications, BI Apps Implementation specialist, Health Check assessment on existing systems, Confidential Mapping Analyses, ETL Migration planning assistance, capacity sizing plans, SOA architecture solutions with OBIEE 11G, security layer definitions, SOA BPEL integration with Oracle ERP, PeopleSoft ERP, ODI, FCM, BIACM, DAC, Informatica(8.X, 9.X), OBIEE (10G,11G), Answers, Dashboards, BI Publisher/XML Publisher, SOA platform, Discoverer (Discoverer Plus, Administration, User Management), Discoverer migrations to OBIEE, OBIEE integration to heterogeneous platforms, Deploy best practices and administer migration strategies, Data Analysis, Business/Functional Requirement Gathering, Strategies for ETL (Sourcing, Mapping, Process Flow), converting user requirements to ETL process, working with Oracle Warehouse Builder(OWB) to manage the entire Oracle 11i/Oracle R12 modules (Financial + Manufacturing), ODI for OWB migration and new developments.
• Confidential Spatial Analytics with ESRI, Map Builder, MapViewer and Naviteq. Implementation expertise in BIApps modules such as Financial Analytics, Spend Analytics, HR Analytics, Project Analytics, Supply Chain Analytics and EAM Analytics. HCM Cloud implementation expertise with larger projects. Visual Analyzer expertise.
• Technical Lead, BI Architect, ERP Techno Functional expertise, ERP analysis and Design, Data Architect (OLTP and OLAP), Expert in DB design, Business Intelligence Expert, Data Warehouse Analysis, BI Reports conversion from one platform to other, ETL conversion from one tool to other, excellent trouble-shooting skills, commendable user interactions, quick problem-solving skills, team player, proactive approach to work and self-motivated.
• Strong experience with business system analysis in a complex data integration environment. Proven experience building data warehouse environments from conception to production (full project lifecycle), Strong experience with business system analysis in a complex data integration environment. Strong experience gathering business requirements from client groups and lines of business' and converting these into functional specification documents ("deep " documentation experience is required), Proficient using SQL statements to query data. Ability to read a data model & perform data mapping, Experience with data modeling and data movement modeling software (ERWIN, SQL Moduler). Experience working in a medium to large size Fortune 500 shop with a matrix reporting structure. Great business knowledge and significant segment of client s business/industry standards. Solid business knowledge in the verticals such as financial, Retail, Direct Selling, Education, Service sector, public Sector and Federal sector.

SOFT SKILLS:

• Strong experience meeting with clients and business users, Proven experience building and maintaining client relationships, Good interviewing and facilitation skills and matching skills to the respective technology.
• Expert in working with onsite/offshore team members in getting to finish developing the applications.
• Advisor/BI Architect/ERP expert in several BI Apps projects, best practices implementation specialist, experience in sizing/slicing strategies.
• Communicates easily with stakeholders in varying situations (One-on-one interviews, formal requirement gathering sessions, technology liaisons and inter departments etc.).
• Strong experience gathering business requirements from client groups and lines of business' and converting these into functional specification document
• Delivery Managerial Skills
• Identifies and documents the business partner s functional and data requirements based on a business process description to ensure that the final deliverable coincides with the context of the business operations.
• Manages and documents the translation of business needs into requirements to communicate to the project team activities, resources, and deliverables necessary to meet business objectives.
• Participates in investigations, interviews, and formal or informal requirements gathering sessions to understand stakeholder needs.
• Recognizes discrepancies between business needs and deliverables, when reviewing and validating requirements, and communicates these discrepancies to stakeholders to ensure that they understand and either accept these discrepancies or identify a need to change project direction
• Analyzes technical problems for senior management, development teams, and business partners in order to identify the technical approach and solution options for the given problem; this includes collaborating with project teams to resolve technical road-blocks, performing solution proof-of-concept (POC), and examining third party product offerings.
• Provides application design and development costing estimates to senior management that are used in determining business initiative feasibility and priorities, and/or used by the IT Project Managers for project planning Provides technical and application expertise to senior management and project teams, including the areas of governance methodologies and processes, for purposes of ensuring the architecture and applications are consistent with the design framework, Enterprise/industry standards, and strategic direction.
• Provides technical coaching to team members on design patterns, development processes, and application functions in order to improve their technical skills.

SPECIALTIES:

Public Sector, Federal, State & Local Project implementations, Large Commercial Implementations, Big 5 Consulting Experience, Excellent trouble shooting skills and working experience with Oracle Support.

TECHNICAL SKILLS:

Oracle Financial/Manufacturing/ HR Specialty Skills: Oracle Application R12/11i/ 11.5.10/11.0.3/10.7/ NCA/10.6 - Oracle Application functional expertise, Oracle Application Technical/Workflow/Alert Developments, Flexfield Management, Apps Conversion/Interface, Custom Development, Business Requirements Gathering, Business Process Re-engineering, Integrated Testing, Database Design, Data Conversion, Production Support and Expert QA Analysis methods in Oracle Financials/HR/Manufacturing.

Data WareHouse: Informatica (8.6.*,9.X), DAC, Oracle Warehouse Builder(OWB), Oracle Data Integrator(ODI), PL/SQL

BI Tools: OBIEE (10G, 11G, 12C),, OBIA (BIA Apps), BI Publisher, Discoverer, Noetix, Brio, Crystal Reports

Analytics (BI Apps 11G,7.X ): BI Apps Modules: Financial Analytics, Spend Analytics, HR Analytics, Project Analytics, Supply Chain Analytics, EAM Analytics, HCM Cloud.

Software/ Testing Tools: SQL Navigator, PL/SQL Developer, Toad, Vertex, TaxGen, WinRunner, Load Runner, PVCS, Front Page 2000, Visio, FormScape, HPQC

Web Tools: Oracle Portal, APEX, Web DB, Oracle Workflow, Flow Builder, HTML, Oracle Web Application Server Installation, Configuration and Administration, Cartridge implementation of Forms Server, Report Server, Java, JDeveloper, XML, XMLDB, XQuery

Methodologies: Application Implementation Methodology (AIM) on RICE and CEMLI (Configurations /Customization, Extension, Modification, Localization, and Integration), Custom Development Methodology (CDM), Agile (Jira, Trello), QA methodologies (HPQC), IBM Process.

SDLC: Statement of work, Project Scope, Business Requirements, High Level Requirements Document HLRD, High Level System Design Documents HLSD, Functional Modeling, Logical/Physical Database Design, Unit and integration Testing, End User Training and Development, Easy Path Migration Method (EMM), End User Training/Mentor.

Databases: Oracle RDBMS 10G, 11G, 12C

Products: ERWIN, HTML, Java, C++, C, Pascal, COBOL, Unix Scripts

OS: UNIX, LINUX, LAN, MS-DOS, Windows, MVS (IBM)

Hardware: DEC Alpha Server 8400(Turbo Laser), Dec 2100, Sun Solaris, IBM Mainframe, PC

PROJECT EXPERIENCE::

Confidential

OBIA BI Architect-ERP Techno Functional Analyst

Tools: Informatica, ODI, OBIEE 12C, SQL, PL/SQL.

Responsibilities:

• I worked as an ERP Analyst/BI Architect with the client to convert the legacy system data (MFG* Pro and CLS) to BI Apps 11G (ODI, OBIEE 12C) for historical reporting purposes.
• I’ve participated in roadmap discussions with product owners and provided technical leadership with all the phases of the project.
• I have led a team of 5 people with the defined effort and converted the transactional data such as Sales Invoices, Sales Orders, Inventory Daily/Monthly Balances into OBIA Data Warehouse as custom plugged data.
• I’d also integrated third party sub systems (MFG*Pro and CLS) into OBIA Data Warehouse.
• I’ve created the conceptual, logical and physical design of the converted system and converted all the dimensional data such as Orgs, Items, Parties, Customers, Locations etc. into BI Apps. The efforts involved extending the ODI/Informatica mappings and developing new mappings in ODI to get the extended OOB modules working in BI Apps.
• Worked with the PCMCS Hyperion Cloud systems to receive the inbound data and designed the star schema in OBIA using Informatica.
• Coordinated the entire Requirement sessions with client and performed the design, development and testing life cycles in an onsite/offshore model.

Confidential

ERP HRMS Techno Functional Analyst-HRMS/Payroll Conversion Specialist

Tools: SQL, PL/SQL, Concurrent Manager, FNDAPI

Responsibilities:

• Confidential has Oracle ERP R12 and in one of their recent projects, the task was to re-design the HRMS conversions, which were developed in 2007.
• The conversion programs needed to be upgraded and Confidential wants to use them in the new R12 system with any universal third-party files.
• Designed and developed the strategy for accepting the universal file for Employee, Assignment, Address, Paycheck and redesigned the HRMS programs and re-wrote some of the PL/SQL packages, procedures and APIs to manage the conversion efforts.
• Worked with the migration team to process all the components and concurrent programs to Production.

Confidential

OBIA BI Architect-ERP Techno Functional Analyst-OBIEE Expert

Tools: OBIEE, Discoverer, BI Publisher, SQL, PL/SQL, ODI

Responsibilities:

• installed OBIA 11G and client had custom Project Grant system along with Oracle ERP R12 system.
• I have performed the gap analysis and performed custom DWH and OBIEE development to extend the OBIA reporting solutions.
• The implementation included the currency conversions and several dashboards with currency prompts customizations.
• Provided the training materials for users training events.
• Used ODI to do the ETL tasks and implemented few mappings and customized existing mappings.

Confidential

BI Architect-ERP Techno Functional Analyst-OBIEE Expert

Tools: OBIEE, Discoverer, BI Publisher, SQL, PL/SQL, ODI

Responsibilities:

• I worked as an ERP Analyst/BI Architect with the Confidential to lead the OLTP reporting implementation efforts.
• The implementation initiative was to run their OBIEE reporting out of the OLTP environment and set directions to agencies’ development team with the best practices, methodology and other implementation methodologies.
• I’d provided guidance in RPD Merges, migrations, catalog backups, security assignments and role creations.
• I was part of the efforts involving DB objects (MVs, Views) creations, OLTP reports and dashboards with all levels of sub ledger details for the General Ledger Status of Fund reporting and Procure to Pay reporting.
• Used ODI for ETL development efforts.

Confidential

BI Tech advisor/BI Architect, ERP Expert, OBIA BI Apps implementation specialist

Tools: OBIEE, SQL, PL/SQL

Responsibilities:

• Oracle R12 and BI Apps modules (Financial Analytics, Project Analytics, Spend Analytics) and HCM Cloud.
• I’d worked as a Technology advisor/strategy specialist working with team members to deliver projects on time.
• The ETL components and BI reporting were done by a team of members offshore.
• I had performed as a liaison between the client and development team to ensure the success of the project implementation.
• I’d devised the best practices and performed code walkthroughs with the technical leads and made sure the designs are accurate and adequate to sustain the future upgrades.

Confidential

BI Architect- OBIEE-BI Publisher Expert

Responsibilities:

• Setups and configurations with Map Builder, Map Server. ESRI OBIEE, Map Viewer, Map Builder, PL/SQL, ODI
• My role was there to assist the project as a Spatial analyst/advisor and set the roadmap for the project.
• I have set the direction to bring the spatial data from ESRI, worked with Shape files and established the Oracle DB procedure way to bring the geometry objects into custom data warehouse.
• I have also completed the setups in Map Builder, Map viewer and setup the OBIEE components in OBIEE 12C.
• Developed Dashboards and analyses to plot the spatial data on maps as custom layers, charts and other OBIEE formats. Used ODI to manage the ETL tasks.

Confidential, Washington, DC

BI Architect-ERP Functional Analyst- OBIEE-BI Publisher Expert

Tools: OBIEE, Discoverer, BI Publisher, SQL, PL/SQL

Responsibilities:

• I am working as a ERP Analyst/BI Architect with the management in the Confidential to lead the reporting implementation efforts.
• I’d worked as an ERP subject matter expert and worked with the ETL team to develop the ETL components.
• Client has their data warehouse and Discoverer reporting environment currently.
• We have implemented the Federal Financial Analytics, Spend Analytics and Project Analytics and performed a 360-degree gap analysis with the Oracle ERP system. Installed and managed the OBIEE environment.
• Administered the RPD Merges, migrations, catalog backups, security assignments, role creations.
• I have developed several reports and dashboards.
• I've created and executed the BI Training strategy and conducted the techno functional trainings in Bi Apps for more than hundred functional/technical users.
• Identified the data lineage between ERP and Data Warehouse and prepared the MD50 documentation on all modules.
• Design the enhanced data model for the custom P2P model within the BI Apps Data Warehouse.
• I’d helped the client to integrate their existing HR/Payroll solution to BI Apps OBIA Data model with ETL/OBIEE efforts.

Confidential, Chicago

BI Implementation Adviser, ERP Architect, OBIEE/BI Publisher

Tools: OBIEE, Discoverer, BI Publisher, PL/SQL

Responsibilities:

• I am working as a ERP Architect/BI Architect/Advisor with the management in an agile environment to lead the reporting conversion and implementation efforts.
• Advised the client on setting the right reporting environment.
• Installed the OBIEE server and administered the environment.
• Client has 400+ Discoverer Reports and they are trying to leverage the existing system and the HCM Cloud/Financial/Spend Analytics.
• I’d performed as a hands-on data scientist/analyst with what if analysis and other developments within OBIEE.
• I’d also performed the advisory role by providing migration/conversion strategies for Discoverer to OBIEE, Capacity planning, Sizing strategies, and server setup configurations.
• I have defined the best practices and standards for OBIEE team and I am mentoring the user team on OBIEE as a need basis.

Confidential, Chicago

BI Advisor, BI Architect

Tools: OBIEE, Disocverer, Cognos, ReportNet, Qualtrics, Userwise, Prewess, Hybris, APEX, Informatica, PL/SQL

Responsibilities:

• I am working with the management in an agile environment to lead the OBIEE/BI Publisher Conversion and implementation efforts in the correct path.
• This Agile project has multiple environments like BI Apps, Cognos, Discoverer, ReportNet, Qualtrics, Userwise, Prowess, Hybris and client is building a highly scalable data warehouse system using OBIEE as the front-end tool.
• One of the top objectives involving conversion of the 800 reports within Cognos, Report Net and Discoverer into OBIEE.
• I am performing as a hands-on data architect with daily developments with multiple tools such as SQL Modeler, OBIEE (RPD+Analytics), PL/SQL and Apex.
• I am also performing as an ERP functional analyst to perform the gap analysis.
• The data warehouse project is using OBIA/Informatica for extracting the Oracle R11 source system data.
• My primary tasks are to analyze the ERP R11 source data, Prowess data, Hybris data and other sub systems and perform the gap analysis, enhance the existing data mart, re-design the existing architecture.
• Conducted the meta data inventory analysis on all the existing PL/SQL ETL code and completed the ETL migration assessment from PL/SQL code to ODI. I’ve participated heavily in extracting and transforming the data into custom DWH to address the ERP (11i) source level customizations.
• With several subsystems, I’ve performed the role as a BI Advisor and impact analyst. I have defined the best practices and standards for OBIEE implementation and I am mentoring the user team on OBIEE as a need basis. I’ve developed complex Dashboards and reports within OBIEE with data level securities.
• I have developed several Apex applications and maintained around 25 applications (3.2X, 4.2X) and worked with QA team to adhere to all standards.

Confidential, Chicago

OBIA BI Architect- ERP Analyst

Tools: OBIEE, OWB, Informatica, PL/SQL

Responsibilities:

• My responsibilities included the design and prototype developments of several of the key BI reports. Based on the business' reporting requirements,
• I have developed several key meta-layer RPD components and I was solely responsible for the MD50 deliverables.
• I was also responsible for leading the QA efforts and conducting the UAT.
• Developed all levels of test scripts and managed the QA process in HPQC.
• Worked with Confidential team to manage the OBIEE development components and help with migration strategies.
• ESRI/Naviteq, Mapviewer integration with OBIEE to locate the retail centers of Confidential thru the application.
• Participated in the estimation efforts and ETL migration efforts from OWB to Informatica.

Confidential, Philadelphia

Lead Architect

Tools: Oracle Application R12, People Soft, APEX

Responsibilities:

• Working with an R12 project implementing Confidential (Financial Accounting Hub) and transferring data to PeopleSoft GL and Oracle AR.
• I was responsible for the Confidential technical configurations, conversion of legacy data into Confidential thru mapping set and transaction objects.
• Components including complex accounting entries for Sales Orders, Payments and Adjustments.
• I have designed and developed the key components of the incoming/outgoing interfaces. Used APEX to create custom bolt application with Confidential .
• I have also installed the managed the initial OBIEE reporting environment.
• I have worked on reporting and interface processing in PA module.
• I have used Discoverer as the reporting tool and worked with PL/SQL to develop the PA interface to process the PA transactions.
• Developed several AP/PO reports and created extract sql scripts for employee related queries from Oracle HRMS.
• Maintained the PO Workflow for Req Approval.
• Maintained the Apex applications, created application administrative components and extended the existing application components.

Confidential

ETL Architect

Tools: Oracle Application R12, OBIEE 11.1.16.4, OWB, BI Publisher

Responsibilities:

• Working with a Data Warehouse project using OWB with Oracle R12 as the primary source system.
• OBIEE is used as the business/presentation layer objects defining the RPD and for reports developments.
• Responsible for several ETL components including complex HR Organization Hierarchy, Employee related mappings, Human Resource data from Oracle ERP to custom Data Warehouse using PL/Sql and OWB. Integrated the HR warehouse components and maintaining the HR Analytics along with Sales and Forecast Analytics.
• Tasks included building the star schema against OLAP data and building the RPD components for reporting and rebuilding the reports.
• Developed the security layer in OBIEE with HR Org security.
• Developed unit test scripts and managed the QA processing in HPQC.
• Extensive usage of BI Publisher for reporting purposes.

Confidential, Chicago

Lead Architect

Tools: Oracle Application R12, OBIEE 11.1.16.4, PL/Sql, JavaScript, ODI, HPQC

Responsibilities:

• Designing the Portal UI and working on the OBIEE repository business/presentation layer objects defining the RPD, working with Oracle R12 ad other subsystems such as Clarify, ADSP as the source systems, installed and configured the OBIEE demo environments.
• Responsible for the team of 5 people with Data Warehouse (ODI/OWB), designed and developed several ETL components using ODI.
• Responsible for OBIEE designs, ODI migration from OWB, OBIEE RPD development, implemented map analytics POCs with Oracle Map Viewer, Google Maps, implemented OBIEE custom Table Of Contents with dynamic report delivery, Write-back capabilities, Usage tracking, Developed several Dashboards complex reports.
• Designed the test cases and test scenarios for OBIEE User Acceptance Testing and managed the UAT testing in HPQC with multiple user groups.
• Developed the DB table aggregates to optimize 100+Million recordqueries to perform within seconds
• Upgraded OBIEE 11.1.1.6.4 to 11.1.1.7 in Dev for POC purposes.
• Performed the configuration and integration efforts to connect ESRI - Naviteq Mapviewer with OBIEE for Confidential vendors relate to spatial analytics.
• Configured the OBIEE scheduler, Conducted knowledge transfer sessions and Mentored the novice users.
• Developed several BI Publisher Reports.