SUMMARY

• Over 10+ years of experience in Business Intelligence analytics that Lead, scope, structure and conduct analyses to generate insights that support business decision - making.
• Analyze complex business needs using data from internal and external sources and identify and interpret trends and patterns in datasets to isolate drivers and to create meaningful reports
• Utilize analytical capability to creatively visualize data in Modern BI/Data Analytics tools like Oracle BI,Qlik that will provide relevant insights to executive level decision-makers
• Apply business analytics expertise to summarize large sets of data into clear, concise, and intuitive reports.
• More than 10 years in Oracle business Intelligence life cycle projects in various domain.
• Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract, Transform and Loading(ETL) process of data.
• Understanding business stakeholders’ objectives, the metrics that are most important to them, and how they measure their performance. Proactively analyze data to answer key questions from stakeholders or out of self-initiated curiosity with an eye for what drives business performance, investigating and communicating areas for improvement in efficiency and productivity.
• Support Ad-hoc analysis/reporting needs from internal team members as well as external stakeholders.
• Skilled at developing and exercising cross-functional influence, translating between business owners and functional / technical teams
• Delivered all the projects and assignments within the specified time lines with accuracy.
• Strong ability to work within a demanding and aggressive project schedules and environments.
• Perform root cause analysis on failed components and implement corrective measures.
• Thrives in a dynamic environment, maintaining composure and a positive attitude
• Successful track record managing projects from feature definition to project deployment through the development lifecycle
• Proposing changes to and reviewing dimensional data models in support of BI needs
• Understanding business stakeholders’ objectives, the metrics that are most important to them, and how they measure their performance
• Analyze and define business needs and assist in developing appropriate solutions.
• Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.
• Designed, developed, implemented, and supports Oracle BI,QlikView dashboards. Integrated data sources and databases with Oracle BI,QlikView and developed data models and backend queries for presenting data.

TECHNICAL SKILLS

BI Applications: Oracle BI,OBI Apps,Oracle Data integrator,Qlik Sense,Qlik view,Spotfire,Tableau,Power BI,One stream

ERP: Oracle E-Business suite

Databases: Oracle Database, SQL Server,Teradata,SQL developer,TOAD

Reporting: Oracle Business Intelligience,Qlik Sense,Power BI, Hyperion Reporting,Qlikview,SAP BW,Spotfire visualizations

Conslidation: Hyperion Essbase,One stream

ETL Tool: ODI(Oracle Data Integrator), Informatica,Oracle DAC

PROFESSIONAL EXPERIENCE

Confidential

ERP Data Analyst

Responsibilities:

• Leading the Oracle Data Analytics and Reporting platform for both Confidential and Cool gear.Designing and Executing Reports Dashboard for all departments.
• Managing the Data warehouse implementation project which involved configuring Manufacturing,Order Management and Procurement module.Responsible for BI production reports to various department like Supply chain,Customer Service,Order management and Shipping & Distribution.Managing OBIEE and Hyperion Essbase security for all the departments in Confidential .
• Assist with the design and rollout of the enterprise-wide business intelligence (BI) application. Educate business units on the different BI applications available to meet the varying needs within the organization and suggest better ways to deliver BI applications where appropriate.
• Buid General Ledger from Oracle E-Business suite into Oracle BI reports.Using Data warehsoue techniques.
• Strong knowledge in implementing ETL mapping, workflows and data loading techiniques through Informatica.
• Very strong analytic and presentation skills and problem-solving techniques with emphasis on individual and team effort backed by excellent communication skills. Experience building and optimizing data pipelines, architectures and data sets.Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks.
• Worked with industry methodologies like Waterfall model,Agile development for OBIEE implementation.
• Sound Knowledge and Experience on E-Commerce, SCM (Supply Chain Management), Finance and Order Maangement. Successfully delivered Inventory management reports,Supply chain reports to CFO and Senior VP to make better business decisions.
• Extensive experience in Analytical Reporting for Sales,Order Management and Distribution.This include design ing of executive reports and also financial reports like EBITDA, Balance sheet and Cashflow.
• Worked on Hyperion Essbase integration from Oracle source and Flat file source which reports into Smartview.Proficiency in Essbase Administration such as defining ASO and BSO applications, Essbase Cache settings, Calculation optimization, Performance tuning, User Management, Shared Services setup, Database calculation and Creating batch File.
• Strong knowledge in designing and developing QlikView and QlikSense dashboards by extracting data from different source.Created incremental load process to load the data into QlikView applications and Oracle Data integrators from different source systems.
• Experience in Implementing QA, Generating test scripts and Writing Test Case.
• Owns and Drive overall BI and Analytics Strategy.

Confidential

Business Inteliigence Lead

Responsibilities:

• Analyzed business and data needs, defined metrics and managed project scope for the profitability data abstract for corporate banking using advanced SQL (included, finance, HR, and operational data elements and metrics).
• Develop a Fit- Gap analysis plan and help Client Evaluate the Results.Design feasibility and providing OBIEE reporting solution for various lines of business.
• Developing global Financial Reporting for the profitability group using OBIEE.Requirements gathering, data analysis and integration (Oracle and Essbase), report development and customization.
• Developing Essbase ASO cube to build OBIEE RPD and Complex OBIEE reports.
• Customization for OBIA RPD.Develop OBIA custom Reports and Dashboard.

Environment: OBIEE 11,Informatica 9.1 hotfix2,DAC 11g, Oracle 11g,hhyperion Essbase 11.1.2

Skills Used: Business analytics,System analysis, Data analytics

Confidential

BI Reporting Lead

Responsibilities:

• Work with business to design specific data requirements for producing analytical data for consumption in the BI frontend solution
• Specializing in BI Reporting tools OBIEE including full SDLC and technical leadership assisting in business strategy, critical business solutions, pre-sales (POC) and End to End delivery.
• Developing OBIEE RPD,OBIEE reports from Oracle data source and Essbase data source.
• Working with Hyperion Essbase Team to Develop financial reports(HFM reports) from OBIEE
• Performing Assembly testing with HFM,Essbase and OBIEE

Environment: OBIEE,Informatica 9.1 hotfix2, DAC 11g, Oracle 11g,Hyperion Essbase 11.1.1.2

Skills Used: BI roadmap,visualization development,Planning and Estimates for Varius BI Releases.