SUMMARY

• Total 15+ years of experience in Software Management and Consulting in diverse technology area. Around 9 years of experience wif BI and analytics. Over 6 years’ experience on Oracle ERP functional & Technical.
• Having credential in successfully delivering 14 Oracle BI Analytics implementation, upgradation, support and customizations projects for Oracle Application’s Financial Analytics, HRMS Analytics, Order Management and SCM Analytics, Procurement and Spent Analytics, Project Analytics, EAM Analytics
• Beginner in Data Scientist, R, Data Visualization, Data Mining, Machine Learning and Advance analytics
• Expertise in end to end Business Intelligence solution such as OBIA, OBIEE, Informatica, DAC
• Thorough understanding of functional and technical of Oracle ERP 11.5.x and R12.
• Experience in requirements definition, design, analysis, development of technical specifications, custom reports, programming, implementations, integration, documentation, testing, post - prodn support in different environments
• Worked on BI Apps, DBI, OBIEE 11g, BI Publisher, Business Object, Dimensional Data Modeling, ETL, APCC, Endeca, Web logic, Oracle, SQL, PL/SQL, Security, Report and dashboards, EBS integration, ibot setup, Performance tuning, RPD Development, HLL and LLD Design
• Certified OBIEE10g Professional and Development program from Oracle on Daily Business Intelligence, Oracle SOA, Oracle Financial, Order Management and HRMS
• Well developed interpersonal and communication skills, having dealt wif diverse professionals, clients & team members at global locations
• Highly self-motivated and able to set TEMPeffective priorities to achieve immediate & long-term goals and meet project & operational deadlines
• Vibrant team player wif belief in taking positive approach towards issue resolution

TECHNICAL SKILLS

Databases: Oracle-7.x, 8.x, 9i, 10g, 11g

ERP: Oracle Application 11.5.x, R12, Seibel suite

Languages & Tools: OBIEE 10.x, OBIEE 11g, OBIA 7.9.5, 7.9.6, 7.9.6.17.9.6.2 , Informatica 8.1.5, 8.6.1, 9.X, DAC10.X, Business Object, Discoverer, Oracle Reports, Oracle SQL, OWB, AWM, Portal, Oracle SOA Suite BPEL, ESB, BAM, D2K, R, RstudioOperating Systems MS-DOS 6.22, Windows 3.x, Win 95, Window 7, Win NT 4.0, SCO UNIX, Red Hat Linux, Sun Solaris

Hardware: HP, Sun

Other Software: MS-Office, MS-Visio, HTML, Photoshop, Dream waver

PROFESSIONAL EXPERIENCE

Confidential

OBIA/OBIEE Architect and PM

Environment: Platform: Oracle 11g, Oracle e Business Suite 12.1.3, JDE, TOAD, OBIEE 11.1.1.6.4 , Oracle BI Apps 7.9.6.3., Informatica 9.1, Internal PM tools

Responsibilities:

• Hardware and Software Sizing, working wif OEM and hardware vendors.
• Proposal planning, Presales activities, RFP responses, Effort estimation, Project planning
• Project Management day to day activities and invoicing, project creation, resource management
• Communication wif clients and onsite team.
• Practice capability building and interviewing resources
• Building solution and POC for new technology as per client need base.
• Involved in revenue generation planning, hiring planning, preparing case study and other practice related activities

Confidential

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle e Business Suite 12.1.3, TOAD, And OBIEE 11.1.1.6.4 , Oracle BI Apps 7.9.6.4., Informatica 9.1, Internal PM tools

Responsibilities:

• Prepared BI environment for support and development from offshore.
• Involved in Knowledge transition activities wif client for development and support. Understanding existing governance model.
• Working wif client to setting up the processes for incident management, change management, Problem Management, Work order as per need.
• Building Operational and Process manuals
• Managing weekly meeting and Communication wif client and onsite team. Also Involved in monthly service delivery meeting
• Project and resource planning, workload estimation, effort estimation, resource availability and Risk Management.
• Day to day Project management activities and project creation, invoicing, resource management.
• Supporting and monitoring OBIEE, Informatica and DAC environment tickets.
• Analyzing, designing, developing, testing and deployment of new end to end BI solutions for new change request or incident driven changes.
• Preparing Technical Analysis, Technical Design and Installation documents.
• Involved in identifying improvement area in existing BI area
• Working wif Oracle for TAR

Confidential

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle e Business Suite 12.1.3, TOAD, OBIEE 11.1.1.6.4 , Oracle BI Apps 7.9.6.3., Informatica 9.1

Responsibilities:

• Fit Gap analysis of Oracle SCM, Inventory, other reporting was based on Cognos
• Approach for building solution related to Supply Chain, Financial
• Customization and extension of DAC, Informatica, OBIEE and BI apps 7.9.6.2.
• Design and review new development of data modeling, DAC, Informatica and OBIEE solution
• Fixing the bugs’ earlier development.
• Defining the testing approach and strategy for development
• Production release of the all components
• Study business applications to understand the Customization implemented based on the inputs given by the client and also through self analysis
• Documenting Customization in the form of User Manual
• Scope of the project includes JD Edwards Financials, Sales & Distribution & Manufacturing

Confidential

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle eBusiness Suite 12.1.3, TOAD, OBIEE 11.1.1.6.4 , Oracle Apps, OBIEE for Noetix View, XML Publisher. Oracle Grant Accounting (OGA), Oracle General Ledger

Responsibilities:

• Fit Gap Analysis of OGA modules.
• Approach for building the solution for the OGA to GL reconciliation.
• Design and development of PL/SQL code, XML Publisher RTF template, data template.
• Registered all components in Oracle Application.
• Testing and issues resolution of the all the components.
• Documented Technical Design.
• Production release of the all component

Confidential, San Jose

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle eBusiness Suite 12.1.3, TOAD, OBIEE 11.1.1.6.4 , DAC, Oracle BI Application 7.9.6.3, Informatica 9.0.X, RHEL

Responsibilities:

• Installation OBIEE 11.1.1.6, OBIA 7.9.6.3, Informatica 9.0.1 and DAC 10.1.3.4 for financial Analytics
• Configuration of all the components
• Setting of the DAC Properties and Source system parameter
• Upgradation of Informatica from 8.6.2 to 9.0.1
• Moving custom Informatica component into Prebuilt repository
• Merging Custom RPD and web catalog into prebuilt RPD webcatalog
• Testing and Issue resolutions
• Documentation of the Installation and Configuration.

Confidential, San Jose

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle eBusiness Suite 12.1.3, TOAD, OBIEE 11.1.1.6.4 , DAC, Oracle BI Application 7.9.6.3, Informatica 9.0.X, RHEL

Responsibilities:

• Involved in RFP, Effort estimation, building project plan and hardware sizing for upgrade
• Built Solution Approach for BI Platform upgrade for OBIEE 11g and OBIA 7962 to OBIA 7963 for E Business Suite 12.1.3
• Installation and platform upgrade for OBIEE 11g
• Production Setup and config and migrating of OBIEE RPD And web catalog
• Setting up the Usage Tracking
• Zero Single Sign on (ZSO) Setup for OBIEE11g and other security setup.
• Documentation of the Installation and Configuration
• Configuration of all the components

Confidential

OBIA/OBIEE Architect

Environment: Platform: Endeca Server, Studio, Integration Suite

Responsibilities:

• Installation of Oracle Endeca server, Studio and Integration Suite.
• Enabling the standard sample apps for OEID
• Exploration and analysis of structure, Semi structure and unstructured data

Confidential, Durham

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle eBusiness Suite 12.1.3, TOAD, OBIEE 11.1.5.3, DAC, Oracle BI Application 7.9.6.3, Informatica 9.1

Responsibilities:

• Involved in RFP, Effort estimation, building project plan and hardware sizing for upgrade and new Custom SCM Modules
• Analyzed source system and existing BI application for new Custom SCM
• Built High Level Design for the overall data flow and Informatica mapping for Oracle Apps 12.1.3 Supply Chain Module and Finance module
• Involved in data modeling activities for SCM and Finance.
• Guided ETL team for Extracting from source, Transformation logic and loading strategy for facts and dimensions. Given inputs on low level designs, testing and performance activities for Informatica ETL mapping to the team
• Developed complex time dimensions for custom modules
• Built custom container into DAC for the new Custom SCM and finance modules
• Built Solution Approach for Confidential BI upgrade for OBIEE 11g and OBIA 7962 to OBIA 7963 for E Business Suite 12.1.3
• Fit Gap Analysis of infrastructure upgrade and Built strategy and upgrade path for Informatica, DAC, OBIEE and Database
• Installed Informatica, DAC and OBIEE and other non BI components on Linux and OOTB Configured and built environment for Upgrade
• Upgraded Informatica, DAC, OBIEE, Database and OBIA DEV, UAT and PROD environment
• Worked on post migration steps and Testing of the data wif baseline database.
• Setting up Incremental Data loading strategy, issue resolving and closely work wif Oracle Product engineering team

Confidential

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle eBusiness Suite R 12.1.3, TOAD, OBIEE 11g, DAC, Oracle BI Application 7.9.6.3, Informatica 9.0

Responsibilities:

• Understand Fixed Asset Business Process and Identify KPI and Metrics.
• Source system analysis and find potential dimensions and facts. Associate columns, slowly changing dimension policy, multiple data source and ETL process run tracking and other auditing related column taken care.
• Ensure solution designs address performance requirements and availability, integrity and security challenges, and business functional requirements.
• Building the logical and physical data model.
• Installing and configuring Informatica.
• Creating the Informatica ETL mapping for loading these Facts and Dimensions into warehouse.
• Built best practice for the ETL and Data modeling

Confidential, Chicago

OBIA/OBIEE Architect

Environment: Platform: Oracle 11g, Oracle eBusiness Suite R 12.1.3, TOAD, OBIEE 11g, DAC, Oracle BI Application 7.9.6.3, Informatica 9.0

Responsibilities:

• Review Architecture, data warehouse, installation and configuration of OBIA.
• Identifying the GAP wif OOT and preparing for customization.
• Customization of the seeded mapping for identified GAP.
• Development and suggestion for customization Best practice
• Configuration of the OBIEE 11g’s RPD and Web logic server.
• Testing of dashboards, KPI, reports and prompts.
• Prepared the documents

Confidential, Durham

OBIA/OBIEE Architect

Environment: Platform: Oracle 10g, Oracle eBusiness Suite 11.5.10.2, TOAD, OBIEE 10.1.3.3.2 , DAC, Oracle BI Application 7.9.5, Informatica 8.1.1

Responsibilities:

• Involved in RFP, Effort estimation, building project plan and hardware sizing.
• Built Solution Approach for Confidential major BI upgrade from OBIA 795 to OBIA 7962 for ERP upgrade 11.5.10.2 to R12.
• Fit Gap Analysis of Upgrade and Built strategy and upgrade path for Informatica, DAC, OBIEE and Database. Overall designed upgrade architecture.
• Installed Informatica, DAC and OBIEE and other non BI components on Linux and OOTB Configured and built environment for Upgrade
• Upgraded Informatica, DAC, OBIEE, Database and OBIA for Supplied Chain Analytics and Financial Analytic.
• Migrated and Upgraded business analytics warehouse for prebuilt and customs application,
• Worked on post migration steps and Testing of the data wif existing systems.
• Setting up Incremental Data loading strategy, issue resolving and closely work wif Oracle Product engineering team.
• Enhanced and supported existing BI Solution
• Integrated Hyperion data wif OBIEE for CAPEX reports and Created Informatica mapping for the Hyperion source and Oracle Application source.
• Built the data model, RPD and OBIEE reports for custom requirement.

Confidential

OBIA/OBIEE Architect

Environment: Platform: Oracle 10g, Oracle eBusiness Suite R12, TOAD, OBIEE 10.1.3.3.2 , DAC, Oracle BI Application 7.9.6.1, Informatica 8.6.1

Responsibilities:

• Requirement gathering and GAP analysis.
• Built solution for Oracle BI application.
• Installed Database, OBIEE, Oracle BI Application, DAC and Informatica client and Server.
• Configured Oracle Database and data warehouse performance tuning.
• Setup for the Informatica repository and integration service by using the Informatica power center administration console.
• Identified and Configured the prebuilt domain values for Financial, procurement and spent analytics, HRMS and project
• Functional Mapping for the Oracle GL Account as per client need,
• Restored the p rebuilt Informatica objects through repository service.
• Importing DAC p rebuilt repository, configured for the data warehouse tables, setting up DAC system properties, defined source system parameters for Oracle application R12.
• Configured source independent parameters such as extraction date, rate, calendar and currency.
• Built custom execution plan for financial analytics, Spend and procurement analytics, Project analytics and HRMS analytics.
• Loaded data into warehouse.
• Customization of the DFF, Profit center and other client need
• Dashboard and reports Gap analysis and implemented same by configuring RPD and Web catalogs.
• Built security on bases of the Oracle ERP R12 and OBIEE authentication done in Oracle R12 and authorization as per user responsibility in Oracle R12.
• Merged OBIA catalog and RPD wif custom RPD and catalog.
• OBIA Data reconciliation wif Oracle R12.
• Suggested functional solutions for eBusiness Suite R12.Documented the all process and design.

Confidential

OBIA/OBIEE Architect

Environment: Platform: Oracle 10g, Oracle eBusiness Suite R12, TOAD, Discoverer 10g Administrator, Discoverer 10g Desktop, Discoverer Plus and Viewer, BI Publisher, OBIEE 10.1.3.3.2 , DAC, Oracle BI Application 7.9.6.1, Informatica

Responsibilities:

• Gatheird information AS is environment.
• Installing and configuring OBIEE, Oracle BI Application, DAC and Informatica client and Server.
• Restored Informatica repository and integration service by using the Informatica power center administration console.
• Restoring the p rebuilt Informatica objects through repository service.
• Importing DAC p rebuilt repository, configured for the data warehouse tables, setting up DAC system properties, defined source system parameters for Oracle application R12.
• Configuring source independent parameters such as extraction date, rate, calendar and currency.
• Loaded data into warehouse.

Confidential, Bensalem

OBIA/OBIEE Architect

Environment: Platform: Oracle 10g, Oracle eBusiness Suite R12, TOAD, Discoverer 10g Administrator, Discoverer 10g Desktop, Discoverer Plus and Viewer, BI Publisher, OBIEE 10.1.3.3.2 , DAC, Oracle BI Application 7.9.4, Informatica

Responsibilities:

• Gathering user requirements, Analyzing % developing approach for implementation.
• Installing and configuring OBIEE, Oracle BI Application, DAC and Informatica client and Server.
• Creating Informatica repository and integration service by using the Informatica power center administration console.
• Restoring the prebuilt Informatica objects through repository service.
• Importing DAC prebuilt repository, configured for the data warehouse tables, setting up DAC system properties, defined source system parameters for Oracle application R12.
• Configuring source independent parameters such as extraction date, rate, calendar and currency.
• Mapped the GL natural account picking up subject areas and setting the parameter for Financial and Spent Analytics and run Initial load for Financial and Spent Analytics.
• Configuring and testing prebuilt the dashboards and reports.
• Setup up Oracle Discoverer End user Layers for building the metadata repository.
• Recording / consolidating activity and project tracking into Project Quality and Project Management documents

Confidential

OBIA/OBIEE Architect

Environment: Platform: Oracle 10g, Oracle Application server 10.2, Discoverer for OLAP, Oracle Portal, Oracle AWM, OWB 10.2, OFSA 4.5.2, Flex Cube, LAPS, TOAD 8.6

Responsibilities:

• Installing & configuring the Oracle Database, Application server 10.2, Oracle Warehouse Builders, Analytical Workspace Manager, Oracle Portal and Oracle Discoverer for OLAP and Oracle Discoverer
• Loading the data by using the Oracle data export and import data pump utility,
• Defining workspace for the creation of the project.
• Designing and developing dimensions, levels, hierarchies and attributes, facts and cubes.
• Mapping physical data wif logical design data model in AWM
• Handling to load the data into dimensions and cubes.
• Building formulas by using function utility in Oracle OLAP Discoverer and developed the Discoverer OLAP reports.
• Setting up and configured Portal and OID user in Oracle middleware.
• Registering Oracle Portlet provider for the Discoverer
• Designing and building the portlets on basis of the oracle OLAP reports and graphs also built gazes portlets and published into portal and also configured for detail report analysis visualized into Oracle Discoverer Viewer

Confidential, Santa Clara

Oracle Application Lead Consultant

Environment: Platform: Oracle 10g, Oracle Application 11.5.10.2, TOAD, Discoverer 10g Administrator, Discoverer 10g Desktop, Discoverer Plus and Viewer, XML Publisher 5.6.3

Responsibilities:

• Understanding clients’ customization requirements.
• Mentoring team member and built several custom objects for Oracle E business 11.5.10.2. Suite.
• Setting up Oracle Discoverer End user Layers for building the metadata repository.
• Building and mentoring team member for XML Publisher and Discoverer reports.
• Undertaking unit testing of all the deliverables related to Order to Cash cycle.
• Estimating the new requirements / change requests.
• Documenting and consolidated activity and project tracking into PQ and PM documents.

Confidential

BI Senior Consultant

Environment: Platform: Oracle Daily Business Intelligence - 7.2, Toad, Oracle Application R12

Responsibilities:

• Preparing the project proposal, SOW and plan.
• Performing requirement gathering for Dashboards and Reports.
• Mapping DBI dashboards and reports wif existing standard.
• Designing and implementing DBI functional setup for Financial, HRMS, Project and procurement.
• Developing and deploying Fast Formula for the HRMS module as per Standard DBI needs.
• Testing and evaluating the DBI impact analysis on existing system functionality.
• Providing solution for the technical and functional issue during project implementations.
• Building BI publisher reports, discoverer reports, Oracle reports.
• Communicating wif Oracle Service for TAR and provided technical and functional information as per TAR need.
• Leading and managing team members and Super users.
• Recommending and building the BPEL, ESB & RFID solutions for the plant integration wif the Oracle Applications

Confidential

Software Engineer

Environment: Platform: Windows 95 using ASP, Oracle 8i, HTML, DHTML, etc

Responsibilities:

• Undertaking research, analysis and suggesting the market requirement.
• Involving in Analysis, Database Design, coding. Reviewing documents and coding.
• Developing and designing Web site.