BellaBeat Smart Marketing through User Behavior Analysis: - Conducted end to end data analysis through Requirement gathering, Data modeling, ETL process, Analysis, Visualization and provided actionable recommendations to Marketing Strategy and Executive teams to increase their customer base. - Used Spreadsheets, Tableau, SQL and R programming to address different challenges with data volume and analysis requirements across multiple levels of granularity and presented the insights to the stakeholders. - Documented the various processes in R Notebook and standard document deliverables.

Expertise: Enterprise Planning and Budgeting, OLAP DML, Enterprise Performance Management System, Hyperion Planning, Essbase, Calculation Scripts, MaxLProjects: - OFA to EPB migration toolkit: Worked as project manager for automating the migration of structures, metadata and data from Oracle Financial Analyzer’s (OFA) Express database into Oracle’s Enterprise Planning and Budgeting (EPB) product’s Relational and OLAP database. - Technical lead in migration of OFA databases to Hyperion Planning’s Relational and OLAP databases as Oracle acquired Essbase and integrated into its Enterprise Planning and Budgeting product. Fixed product bugs, worked on performance issues and handled customer support for OFA and EPB applications. - Public Sector Planning and Budgeting Solution: Designed and developed a niche planning and budgeting solution for clients in public sector space. Involved in designing and developing the dimension structures, measures, forms for user input and reporting, product intelligence through business rules and Essbase calc scripts for implementing various complex processing and functionalities.

- Resource Planning Workbench: - Designed a custom data warehouse for measuring, tracking, analyzing and decision making on the utilization of resources across the consulting division of Oracle. - Gathered requirements, designed the ETL process, implemented, validated, deployed and tested the solution using Oracle Warehouse Builder(9i), setup Key Performance Indicators and built Discoverer reports to be published periodically on Oracle Portal dashboards for consumption by strategic decision makers. - Trained power users to slice and dice data, designed and developed Balanced ScoreCards on top of custom data warehouse solution for strategic analysis and tracking organization wide performance over short and long term. The success of this project contributed to the Consultant of the Year award. - Automation tool extension to OWB: - Self-initiated and designed a tool using MS Excel macros and TCL-OMB scripting to automatically import and map flat file sources to relational staging tables in Oracle Warehouse Builder, cutting down the time and effort involved to a tiny fraction of the manual process that was required otherwise. - Designed, developed and tested Oracle BI products such as Forms, Reports, Discoverer workbooks on top of functional modules of Oracle Applications including CRM, Sales Compensation, HRMS, Financials, Purchasing and Supply Chain. - Implemented and tested pre-built Business Intelligence Solution and Enterprise Data Warehouse (BIS-EDW) and Daily Business Intelligence (DBI) , set up security profiles to manage privileges for various user groups and trained power users to address their dynamic reporting needs. - Designed and developed standardized templates through Data Warehousing Methodology FastTrack (DWMft) to reduce documentation efforts and preserve high standards of deliverables.