• Primary Skills

• OBIEE, OBIA

• Operating Systems

• Linux, Windows

• Languages

• PL/SQL, Pig Latin

• ETL Tools

• Informatica 9.0.1/8.6.1 and DAC 10.1.3.4.1/7.9.5

• OLAP/Reporting Tools

• OBIEE 11g/10g, Siebel Analytics 7.8.4

• Source Systems

• Familiarity with - Siebel CRM 7.7/8.0, Oracle EBS R12, JD Edwards Enterprise One 9.0

• Databases

• Oracle 11g and 10g

• Domain Knowledge

• Financials, Pharmaceuticals, Telecommunication and Supply Chain Management

Role: Developer / Business Analyst / BI Architect / Assistant PM Onsite

Sector: Telecom and Cloud Services

Environment: OBIEE 11.1.1.5, Informatica 9.0.1, Oracle R10, Siebel 8.0, Oracle EBS 11i, Revchain

Responsibilities

• Responsible for the entire maintenance, support enhancement, Quality Assurance and final implementation of the core BI application.
• Jointly led a team of 10 resources towards design, development and implementation of Change Requests and Enhancement.
• Performing Business Analysis and Requirements Gathering from various business functions.
• Worked as a Business Analyst and Data Integration Specialist for building Finance KPIs.
• Requirement Analysis, defining BI Road Map and architect BI solutions ETL OBIEE .
• Preparing Business Requirements Document and Reporting Solution Design.
• Managing incident tickets and task assignment.
• Coordinating with Onsite and Offshore for daily deliverables and status.
• Project planning and estimation.
• Highlights
• Built close to 90 reports using OBIEE ETL for Retention department in a span of 2 months.
• Retention queue dropped to 1800 tickets from 2900.
• Transformed the way Retention users had been analyzing the data that gave instant recognition.

Confidential

Role: Business Analyst / Module Lead Onsite

Sector: Communications

Environment: OBIEE 11.1.1.5, Informatica 9.0.1, Oracle Exadata

Responsibilities

• Understanding client's business model and their reporting needs.
• Gathering analyzing end-user business requirements.
• Preparing Business Requirements Document.
• Outlining Technical Design and architect Solutions.
• Leading offshore technical team and managing task assignment.
• OBIEE Reporting Performance Tuning.
• Presented OBIEE 11g new features with business use cases.
• Responsible for design and development, Quality Assurance and final implementation.
• Project planning and estimation.
• Highlights
• Built a prototype Executive Dashboard for SLTs that represented complex and high volume data in a true interactive BI form eventually replacing legacy excel reporting. The prototype was extremely well received by Senior Executives of the firm despite the fact that they were used to seeing their excel reports for years.

Confidential

Role: OBIA Architect / Tech Lead Onsite

Sector: Manufacturing

Environment: Oracle EBS R 12, OBIA 7.9.6.3, OBIEE 11.1.1.6, Informatica 9.0.1, DAC 10.1.3.4.1, Oracle 11.2.0.3

Responsibilities

• Conducting Oracle BI orientation sessions to familiarize client personnel with OBIEE/OBIA technology and product capabilities.
• Conducting workshops, Gathering analyzing end-user business requirements.
• Performing Report Rationalization, Prioritization, Gap Analysis and Solution outlining.
• Installation of OBIA components - OBIEE 11.1.1.6, Informatica 9.0.1, DAC 10.1.3.4.1 on Red Hat Linux servers.
• Setup and configuration of OBIA 7.9.6.3 Financial Analytics.
• Preparing Functional and Technical Design documents.
• Leading offshore technical team.
• Designing and modeling star/snowflake schemas in RPD.
• Creating custom reports as per the requirements and implementing object level security.
• Customization of ETL Informatica mappings and workflows to populate warehouse tables.
• DAC configuration and customization.
• Unit Testing and Final Implementation.

Confidential

Role: OBIA Architect

Sector: Manufacturing

Environment: JDEE 9.0, OBIEE 11.1.1.5, Informatica 9.0.1, DAC 10.1.3.4.1, Oracle 11.2.0.1, OBIA 7.9.6.3

Responsibilities

• Installed and setup OBIEE 11.1.1.5, Informatica 9.0.1 and DAC 10.1.3.4.1.
• OBIA setup and configuration for Financial and Supply Chain Management Analytics.
• Identifying and addressing gaps/challenges in the prebuilt out-of-the-box JDE adapters. Worked closely with Oracle to enhance their product.
• Implemented workarounds/resolutions for the issues/bugs encountered out of the box on the ETL Informatica DAC and Reporting OBIEE layers.
• Setup LDAP authentication mechanism in weblogic and Implemented object-level security.
• Setup OBI Delivers to send reports via email.
• OBIEE and ETL Infrastructure Sizing.
• Taking care of all the Administrative tasks, Deployment and Maintenance of Oracle Business Intelligence Applications.
• Highlights
• The project is a unique implementation of OBIA for JD Edwards ERP mounted on IBM iSeries DB2 platform. OBIA configuration has not been done for an ERP on IBM iSeries before which posed unique set of challenges and exposed gaps in the pre-built JDE adapters.
• As the sole member of BI module, I was responsible for the entire installation, setup, configuration, testing and deployment of OBIA 7.9.6.3 Financials and Supply Chain Management Analytics.

Confidential

Role: Senior Developer

Sector: Electronics

Environment: Oracle Apps, Siebel, OBIEE, Informatica, DAC, Oracle

Responsibilities

• Actively involved in the maintenance of the application and resolving day to day issues raised by the markets.
• Analyzed, designed and developed new requirements.
• Fixed issues/bugs pertaining to RPD, webcatalog, Informatica and DAC.
• Mentored junior team members and assisted them in their assigned tasks.
• Interacted with the end clients to discuss the status of issues.
• Prepared Change Request and code migration documents.
• Involved in Unit and System testing.

Confidential

Role: Senior Developer

Sector: Power Generation Transportation

Environment: Siebel, OBIEE, Informatica, DAC, Oracle

Responsibilities

• Understanding and analyzing business requirements to provide end to end ETL, RPD and Webcat technical solutions to accomplish them.
• Designed and modelled star/snowflake schemas in RPD.
• Built Physical, BMM and Presentation layer in RPD
• Created Pre-configured reports as per the requirements and implemented object-level security.
• Customized/Created ETL Informatica mappings and workflows to populate OLAP tables
• Created tasks in DAC pertaining to ETL mappings, embedded them into relevant subject areas and then assembled them into execution plans.
• Prepared Technical specification.
• Prepared Unit Test Plan UTP .

Confidential

Role: Senior Developer

Sector: Telecom

Environment: Siebel 8.0, OBIEE 10g, Informatica 8.6.1, DAC 7.9.5, Oracle 10g

Responsibilities

• Understood client's business model and transferred them into technical architecture.
• Worked as an OBIEE designer and analyzed business requirements to provide end to end ETL, RPD and Webcat solutions to accomplish them.
• Designed and modelled star/snowflake schemas in RPD.
• Created Pre-configured reports as per the requirements in Presentation Services OBIEE and implemented object-level security.
• Created Auxiliary, SDE, SIL and Update mappings and workflows to populate OLAP tables.
• Created tasks in DAC pertaining to ETL mappings, embedded them into relevant subject areas and then assembled them into execution plans.
• Involved in end to end design of Adhoc Reporting subject areas which includes the design and development of ETL mappings workflows, RPD configuration and DAC configuration.
• ETL Performance Tuning.
• Mentored junior team members and assisted them in their assigned tasks.
• Monitored the daily ETL load DAC run and resolved the load issues.
• Wrote UAT test scripts and conducted UAT from client's site.
• OBIEE ETL Administration and Environment Management

Confidential

Role: OBIEE Team Lead

Sector: Pharmaceuticals

Environment: Siebel, Siebel Analytics OBIEE , Informatica, DAC, Oracle

Responsibilities

• Worked as a module lead and Analytics co-coordinator between PMO, offshore and end customers across Europe .
• Interacted with different markets for Requirement Gathering and Analysis
• Designed and developed new requirements and enhancements.
• Conducted UAT and deployment of point releases.
• Involved in maintenance of the application and resolving day to day issues raised by the markets.
• Fixing bugs/issues in RPD and webcatalog layers.
• Enhancing object-level and data-level security.
• Monitoring weekly loads.
• Conducted weekly calls with different markets to discuss the status of present issues.
• Mentored junior team members and assisted them in their assigned tasks
• Unit and System testing
• Siebel Analytics Administration and Environment Management

Confidential

Role: OBIEE Developer

Sector: Pharmaceuticals

Environment: Siebel, Siebel Analytics OBIEE , Informatica, DAC, Oracle

Responsibilities

• Understood client's business model and transferred client's business rules into technical architecture system
• Created pre-configured reports as per the requirements.
• Implemented Object and Data level Security across the application.
• Implemented multilingual functionality in Siebel Analytics.
• Involved in implementation of Disconnected Analytics.
• Involved in the design and development of Marketing Analytics dashboards and reports.
• Involved in the implementation of Marketing Segmentation.
• Built Physical, BMM and Presentation layers in RPD including developing star/snowflake schemas, creating dimensional hierarchies, defining measures/metrics, creating variables and implementing data-level security.
• Worked on Siebel Delivers and setup scheduler configuration.
• Implemented Single Sign On with Siebel CRM application.
• Unit System testing, Quality Assurance and final implementation.
• Siebel Analytics Administration and Environment Management