Manuj Sharma

Oracle BI Business Analyst

Summary:

Over 9 years of experience in the software industry in Application Design, Development

and Implementation. Experience in complete Software Development Life Cycle (SDLC) including requirements gathering, analysis, estimation, design, development, implementation, testing and maintenance (technical and production support).

• 6 years of IT experience in Data warehousing, Siebel Analytics (Oracle BI).

• 4 years of Experience in Supply Chain Management, Manufacturing and Quality Management at Cisco Systems.

• Experience with Sales and Marketing BI including Sales Territory Assignment and Sales Commissions with NetApp.

• Experience in Insurance Domain.

• Led a team of 5-6 IT professionals. Collaborated project team efforts.

• Experienced using data warehouse or analytical tools for business purposes

• Strong Conceptual, technical, interpersonal and communication skills

• Ability to independently “drive” activities on the initiatives (autonomy, do not wait to be told)

• Ability to translate business requirements into technical requirements

• Strong knowledge of key data warehousing processes

• Excellent communication skills, Fast learner and a team player.

Professional Experience:

Mar’10 till date Network Applications (NetApp), CA

Business Intelligence Analyst

• Drive interviews and end user interactions with NetApp Sales Operation Managers to determine requirements for data, Oracle Business Intelligence Reports\Dashboards, Service levels, data quality and performance

• Work with Business Users to define Key Performance Indicators to monitor Health of specific Business processes. Assess and Identify potential data sources.

• Document the changes\new requests determined after discussion with Business Users into a Business Requirements Document.

• Translate Business questions and requirements into conceptual and UI application models to enable Technical Dashboard development.

• Work with the Application Architecture team to create the required Structures needed to enable the Reporting of data as per requirements gathered from the Sales Operation Managers.

• Ensure Architectural Alignment as per standards defined by the NetApp Application Architecture Leads with model management standards and naming conventions and the elimination of redundancies.

• Identify potential risk areas during the Analysis phase. Define clear audit requirements to ensure accuracy of data that gets reported to NetApp Sales Representatives in the Field and the High Level Sales and Marketing Executives at NetApp.

• Create Reporting\dashboard prototype to be shared with the Business Users to get their approval before starting work on the larger development efforts.

• Document Test Cases and prepare Test Plan based on the requirements stated in the Business Requirements document.

• Execute Test Cases on raw data to ensure data accuracy and logic meet the criteria defined in the Test Cases.

• Create Oracle Business Intelligence Reports\dashboards to be used by the NetApp Sales Team.

• Work with the Project\Program Manager on Program Management activities

• Guide the User acceptance testing effort by training Business users and working with them at final implementation phase.

Environment: OBIEE 10.1.3, Oracle 10g, Windows XP

Dec’05 till Mar’10 Cisco Systems, Inc., CA

Oracle BI Business Analyst

• Drove interviews and end user interactions to determine requirements for data, reports, analyses, metadata training, service levels, data quality and performance

• Worked closely with QDS Architects, QA teams, Technical Dashboard Development teams and IT to translate requirements into technical specifications (includes BRD and Kimball)

• Ensured architectural alignment with model management standards and naming conventions, and elimination of redundancies

• Translated business questions and requirements into conceptual and UI application models for the Technical Dashboard developers

• Worked to define KPIs to monitor Health of specific Business processes.

• Helped identify and assess potential data sources

• Helped assess potential points of failure and articulates audit requirements starting at the analysis phase

• Recommended appropriate scope for the project

• Coordinated prototype reviews

• Worked closely with PM team for inputs and risk management on related facets of Program Management activities

• Helped Customize Repository, Configure Meta data Objects (Subject Area, Table, Column), Configured Web Catalog Objects (Dashboard, Pages, Folders, Reports).

• Proposed new Star schemas. Modified existing schemas to incorporate new requirements/Process changes.

• Took ownership in building prototype for pilot project.

• Worked with Business Users to develop Subject Area, Metadata Reporting requirements such as schemas required hierarchies and data sources.

• Guided the User acceptance testing effort by training Business users and working with them at final implementation phase.

• Helped Configure Physical Layer, Logical Layer and Presentation Layer as per requirements.

• Worked with the ETL team in loading of tables using ETL tools from legacy data.

Environment: OBIEE 10.1.3, Oracle 10g, Windows XP

Oct’05 to Dec’05 Janssen Pharmaceuticals, NJ

Oracle BI Application Developer\Analyst

• Worked with Business Owners/End-user to create Subject Areas, Folder/Sub-folders, Presentation/Business columns; Understand Chart & Tables in pane; Query, Filter, Drill-downs, User / User group level Security requirements.

• Led Enterprise DW developers to design - Facts & Dimensions Repository.

• Resolved special processing requirements & Architecture/Design issues, Designed Star Schemas, Processed Non-measure columns in Fact. Resolved Complex join issues.

• Designed & Documented Detail Design. Proposed new star schemas.

• Configured Physical Layer Imported tables, Created Tables, Added/Changed physical joins/keys.

• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns etc

• Configured Presentation Layer Create Folders/sub-folders, Standard Queries for different User Groups.

• Created Access & Query privileges depending on User Groups, Managed day-to-day .rpd & iBots

Environment: Siebel Analytics 7.7, Siebel Tools 7.5, Informatica 6.0, MS-SQL Server 2000, Windows 2000, MS-Office

Mar’05 to Sep’05 GH to Compass Conversion

Test Lead Assurant Employee Benefits, KS

Systems Analyst

• Involved in Integration Testing of the data converted to Compass system.

• Understood the requirements of the new system and that of the existing system to facilitate the writing of the Integration Test Cases.

• Involved in extensive discussions with business users and developers to understand the business/requirements/functionality.

Environment: MVS, JCL, DB2, VSAM, IMS

Oct’04 to Mar’05 Direct Bill System

System Analyst AMIG Insurance, OH

Computer Programmer\Analyst

• Project management including Requirement Analysis, Design, Development, Testing and Technical Documentation.

• Facilitated the conference calls with Client on business/requirements functionalities.

• Evaluated, redesigned and modified existing program logic to improve overall system performance.

Environment: Unisys, ClearPath MCP 8.0, COBOL-85, DMSII, WFL, TADS, Programmers Workbench

May’ 04 to Oct’ 04 Enhancement to Commercial Policy System

System Analyst GuideOne Insurance, IA

Systems Analyst

• Involved in training on both functional and technical knowledge to others.

• Completed coding on new, complex and involved systems; conducted code reviews

• Monitored & Reviewed Deliverables and Collected the Metrics for the project.

• Involved in the complete Testing life cycle of the system.

• Batch Production Support and Fixed the Production abends.

• Coordinated with QA team to proceed with end-to-end testing.

Environment: MVS, JCL, VS/COBOL II, CICS, VSAM, DB2- IBM Mainframe

July’03 to May’04 CAPSIL MAINTENANCE

System Analyst/Team Lead UAFC Insurance, FL

IT Programmer\Analyst

As a Team leader his Responsibilities included:

• Involved in SDLC (System Development Life Cycle)

• Project management including Requirement Analysis, Design, Development, Testing, Technical Documentation.

• Coded the new modules, which would implement the functionality.

• Led the System testing of the various functionalities.

• Facilitated the conference calls with Client on business/requirements/ functionalities.

• Awarded the K-star award (Knowledge Star) for preparing a Knowledge repository to projects in the future working on the same platform.

Environment: DOS/VSE Operating System, JCL, CICS

Oct ’02 to Jun’03 LIFE AREA TEST CENTER

Test Coordinator/Test Lead Statefarm Insurance, IL

Test Coordinator

• Set up test environment for next day. Reviewing work products of Team members.

• Ensured that Onsite and Offshore communication was carried out smoothly so that the daily Batch cycle gets completed successfully.

Environment: IBM – Mainframe (MVS), JCL, DB2.

Technical Skills:

Languages: VB 6.0, VB Script, Java Script, SQL, HTML, COBOL, ASP, MVS, JCL, VSAM, Easytrieve.

Databases: DB2, IMS, DMS II, MS-ACCESS, Oracle

Data Warehouse / ETL Tool: Informatica Power Center (5.1, 5.2, 6.0)

Version Control: Microsoft VSS

Insurance Admin Systems: CAPSIL, CAPS, CLEARPATH

OBlEE : OBIEE 10.1.3,

Education:

Bachelor of Electronics and Communication Engineering, HP University. Regional Engg. College, Hamirpur (Now named NIIT Hamirpur), one of the premier Engineering Colleges in India.

Contact this candidate