SUMMARY:

• Confidential has over Eighteen years of experience in all phases of design, development, and implementation of computer applications.
• He has worked for clients within the financial, manufacturing and healthcare industries. His areas of expertise include Confidential Applications Data Warehouse, Confidential Corporate Performance Management Products and DW/BI reporting.
• He is adept at facilitating sessions defining user requirements, developing and delivering end - user training, creating and maintaining project schedules.Expertise in DW Methodology and Confidential Packaged BI Applications.
• Successfully lead and implemented Confidential BI APPS/OBIA Financial, Supply Chain, Procurement Spend, HR and Project Analytics against Confidential E-Business (11.5.x and R12) and PSFT (9.0 and 9.1)
• Expertise in DW Methodology, BI Methodology and Confidential Packaged BI Applications.
• He has mentored junior resources at Confidential and at Confidential .
• I have also been involved in sharing new BI Application Adaptor for Project Commitments developed at client site with Confidential Development team for improvement around BI Applications 7.9.6.1 which was covered in release 7.9.6.3.

SKILLS:

• HR Analytics
• Confidential
• Procurement and Spend Analytics
• Confidential Time and Labor
• Fixed Asset Analytics
• Supply Chain Analytics
• Project Analytics
• Project Analytics with Grants Accounting
• Confidential Unified Method
• Confidential Project Management Method
• AIM
• Confidential EBS R11i/R12.1.3, JDE 9.1
• Informatica Power Center 9.x
• Confidential BI DAC 10g
• OWB
• ODI11g
• OBIEE 11g
• Confidential 11g/10g
• PL/SQL
• Windows NT/ 2000 / XP
• Linux
• IBM AIX
• Solaris

PROFESSIONAL EXPERIENCE:

Confidential

Senior Solution Architect

Responsibilities:

• To lead and deliver Confidential BI Solutions
• Configuration of OBIA11g using
• Fit/Gap analysis
• Custom development for real time reports
• Custom Data Modeling of Star and Snowflake schemas.
• ETL Architect
• Discover reports conversion to OBIEE reports using custom model/s.
• Offshore resource management.
• Manage client expectations during implementation of BI solution.

Confidential

Responsibilities:

• Implemented Supply Chain and Order Management Analytics
• Configured OBIA11g using Confidential .
• Customization and Extension of OBIA
• Create Dashboards and Reports as per requirements
• Customized Confidential ETL code to accommodate reporting requirements.
• Troubleshoot data issues during testing phase.

Confidential

Responsibilities:

• Implemented Confidential, Procurement Spend Analytics, Fixed Asset Analytics and Project Analytics with Grants Accounting
• Conducted demos for business and technical users.
• Fit/Gap analysis from initial requirement document to R12
• Providing solutions and level of effort towards customization and extension of BI Applications.
• Configured OBIA11g using Confidential .
• Build new Star Schema data models in OBIEE for Project with Grants Accounting, Purchase Order and General Ledger for real time reports in EBS.
• Build new Star Schema data models to convert Discoverer Reports to OBIEE reports.
• Managed three offshore resources for RPD and reports development.
• Support access and data issues during testing phase.
• Migration from dev to test instance
• Developed custom dashboards and reports for real time reports.

Confidential

Responsibilities:

• Implemented Financial, Procurement Spend Analytics, Fixed Asset Analytics and Project Analytics
• ETL Architect for customization and extension of OBIA
• Fit/Gap analysis for OBIA
• Providing solutions and level of effort towards customization and extension of BI Applications.
• Configured OBIA11g using Confidential .
• Developed Custom ETL using Confidential 11g for custom reporting needs.

Confidential

Responsibilities:

• Implemented Confidential
• Configured BI Applications against PSFT 9.1 as a source.
• Conducted demos for business and technical users.
• Providing solutions for customization and extension of BI Applications.
• Configured OBIA 7.9.6.3 using DAC.
• Developed Custom ETL using Informatica and included in DAC for custom reporting needs.

Confidential

Responsibilities:

• Implemented Confidential and Procurement Spend Analytics for Proof of Concept.
• Configured BI Applications against Confidential EBS R11.5.10.
• Provided fit gap analysis to client.
• Configured OBIA 11g using DAC.

Confidential

Manager

Responsibilities:

• Manage client expectations while implementing BI solutions.
• Involved in proposals, Cost Estimates and Orals.
• Assessment for implementing BI APPS.
• Fit/gap analysis and leading offshore team to implement Confidential BI solution mainly BI APPS.
• Involved in recruitment activities and also coaching junior staff for career development.
• Publishing Technical White Paper on custom solutions.
• Solution Architect for Business Intelligence Solution.

Confidential

Technical Manager

Responsibilities:

• BI Apps 7.9.6.2, OracleEBS R12.1.2 and PSFT 9.0
• Configured and Implemented Out of Box Financial, Procurement and Spend, HR and Project Analytics
• Leading team of eight people for DW Extensions and Report development
• Designed, Developed and Implemented custom Informatica adaptors for Projects Analytics using Grants Accounting.
• Extending Warehouse to other data elements to meet reporting requirements from EBS using Informatica.
• BI Apps 7.9.6.1 and Confidential EBS R12
• Configured and Implemented Out of Box Financial, Procurement and Spend Supply Chain, HR and Project Analytics.
• Lead team of four people for DW Extensions and Report development
• Extended all subject areas to meet reporting requirements, specifically extended Project Analytics to include Project commitments.
• Designed, Developed and Implemented new Star Schema for Project Commitments to be included as part of the Project Analytics and shared the code with Confidential product development team which was included in next release of BI APPS.
• Extended Warehouse to bring Flex Fields and other data elements from EBS using Informatica.
• Developed simple step-by-step process and conducted demos for non OBIEE users.
• Worked on resource requirements to support OBIEE for support
• BI Apps 7.9.6 and Confidential EBS R11i
• Configured and Implemented Out of Box Oracle
• Extended all subject area to bring additional DFF’s from EBS
• Configured and implemented SSO with EBS.
• BI Apps 7.9.6 and Confidential EBS R11i
• Configured and Implemented Out of Box Oracle
• Extended all subject area to bring additional DFF’s from EBS
• Extended DW to bring hierarchies from External Systems
• Daily Business Intelligence
• Configured and Implemented Out of Box DBI for Financials, Procurement and Supply Chain
• Conducted user sessions for acceptance
• Mentored Client resources for support
• Discoverer 10g on Confidential EBS R11i
• Helped to develop APPS mode EUL
• Developed, trained and mentored client Business Analyst to develop reports using Discoverer 10g
• Gather requirements from client and put it in technical terms for EUL developers
• Troubleshoot reporting issues
• Extensively used Analytical functions from Discoverer
• Enterprise Performance Framework
• Designed and developed custom application for major Consumer and Industrial consumer appliances manufacturing company to get store their allocations in Enterprise Performance framework (EPF)
• Used PL/SQL for customization and validation of data
• Wrote custom error reporting solution and implemented in Confidential Applications.

Confidential

Profitability Manager

Responsibilities:

• Wrote custom Sql*Loader and PL/SL scripts for converting Confidential data to be loaded using EPF framework