Data Sales

**+ years of strong techno functional experience as a senior BI developer & analyst at fortune 500 helping organizations excel in operations, analytics, metrics, forecasting by executing Business Intelligence, ETL, database solutions in diverse domains such as Bookings, Product Operations, Sales, HR, training, Finance, Telecom, Manufacturing.

Strong analytical, product management, SME & user engagement skills with a proven track record of understanding the requirements, business user needs translating them to BRDs, shaping them into self-service BI dashboards, making sure correctness and accuracy of reports promoting analytical & operational excellence.

Hands on skills in OBIEE RPD, Dashboard, Tableau Reporting & Server administration, integrating technologies to provide effective solutions and meet business needs making use of diverse cross-functional data sets including traditional databases, data marts, spreadsheets, ad hoc reports including applications logs.

Work Eligibility US Permanent Resident

Education BS Computer science

Experience Summary

10+ years of extensive experience solving business problems delivering measurable value to stakeholders. Leverage the power of data to provide insights using the BI tools like OBIEE 11g, 10g, Tableau 10.x, Hive, Hana Data Virtualization

Trained in Tableau 10.x advanced reports and server administration, with 2+ years of experience providing solutions utilizing Tableau and migrating OBIEE reports to Tableau.

5+ years of experience as BI analyst interacting with business users and stakeholders understanding and gathering requirements, writing BRDs, leading development execution and delivery.

Thorough Knowledge of Data warehousing and OLAP technology – designing star schema, snowflake schema, FACT and dimension tables, physical and logical Data modeling.

2+ years of ETL experience using Informatica and Pentaho tools, used plsql procedures for loading the Star Schemas

Expert in the SDLC (development, testing, debugging, implementation, documentation, UAT & qualification, user training and production support)

Trained in Sales force Administration and Apex Coding and Visual Force Pages

Very good communication skills, project interface for client projects. Quick learner highly motivated, result oriented and enthusiastic team player.

Extensive OLTP database experience using Oracle 10g/9i/8i/8.0/7.3, SQL, PL-SQL programming Skills, SQL Server DB, Oracle Forms 4.5/6i & Reports 2.5/6i, Oracle Discoverer Reporting, Toad and SQL Developer

Experience in writing shell scripts for repetitive and automated tasks using UNIX Shell scripting

Knowledge in Python Programming, R, Java

OBIEE

Functional specification/Technical Documentation, Strong Experience with RPD Modeling creating Hierarchies, Logical Columns, dynamic and static Session and Repository Variables

Involved in Multi User Development Environment for RPD Administration tasks for maintaining Migrating RPD and Web Catalog to UAT, Prod Environments

Developed Complex OBIEE reports using unions, utilizing Pivot tables, charts, stacked Bars, Analyze by Column selectors

Developed Dynamic and Interactive dashboards and pages using dashboard global Prompts and Constrained Filtering and dynamic presentation Variables

Implemented security using LDAP authentication supported by a Data level / Dashboard level security

Created the OBIEE Groups,Users and roles assigning the users to roles and set up the web-groups

Fine-tuned the SQL Queries creating the Aggregate tables in DWH with bitmap indexing on the frequently used columns drastically increased the Performance and also assigned the same aggregate tables at the BMM Layer in RPD

Worked on cache purging strategy using event-polling table. Worked on Ibots using Siebel Delivers for caching the reports.

Created different KPI using calculated key figures and parameters

Tableau

Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts, Bar Charts .

Worked extensively with Advance Analysis - Action Links, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's

Strong Dashboard design experience and passionate practitioner of effective data visualization.

Designed, developed and supported BI solutions, Involved in Debugging,monitoring, and troubleshooting Production issues/tickets support to Tableau users and Wrote Custom SQL Queries to support business requirements

Worked on combining Multiple Sources utilizing data Blending

Involved in administration tasks for Scheduling the Published workbooks and Data sources also Setting permissions, managing ownership of user roles and Groups

ETL

Created ERDs designing normalized data structures to store the data, and enforcing integrity constraints to maintain data consistency

Developed Informatica Mappings using transformations for ETL of Orders and vital work flow related measures.

Created many reusable transformations and mapplets, wrote control files to schedule ETL jobs

Implemented reconciliation process for data consistency between source systems and the warehouse.

Performed the Unit and Integration testing of mappings.

Created control files for SQL*Loader and Unix shell Scripting.

Created Oracle Stored procedures and packages for Complicated Business rules for Data Cleansing

Wrote PL/SQL Stored Procedures, Functions, UTL Files, Inline views, & Triggers for the application

NetApp Inc, Senior BI developer & Analyst, Project lead Feb ’14 – Present

Point of contact for bookings & quotes analytics covering NetApp’s product spectrum – existing, new and acquired products.

Improved organizational productivity and resource costs eliminating the Manual processing of data & redundant requests to generate Reports by automating the same in various Visualization tools Like OBIEE and Tableau .

Managed new product support & acquisition integration – FlexPod analytics, StorageGrid ASUP, AWS, ONTAP Select bookings & quotes, SolidFire, Auto Support Reports Tableau adoption across projects.

Reduced redundant requests and manual efforts in generating “FlexPod/HSG Forecast Bookings” reports for business users by providing self-service portals using Tableau Visualizations to serve 200+ business users.

Implemented Net new customers and repeat customer KPI & Metrics to help management Decisions.

Integrated FlexPod Auto Support data from Hive using complicated Custom Query in Tableau and generated Visualizations to support Market and Sales Intelligence Functions to take Decisions on Attach rate on various Workloads

Integrated Multi Source data from DWH - StorageGrid Bookings with Auto Support logs from HIVE and Hadoop, Automated the whole process and Provided Weekly updates on used and unused Storage by Top N Customers, S/w Versions Being Run, Grid Usage trends, No of Storage Nodes by Customer etc. using Tableau Visualizations to Support the Object Storage management Function

Revisited and Corrected the System quantity KPI Definition and Logic Fix at the DRM and ETLs Logic for FAS and E-series helping management to report the numbers Accurately. Executed the project acting as a liaison between the Business and IT team, Understanding and Architecting the Solution, documenting Proposed Logic for Technical and Functional BRD’s and executed the UAT.

Helped the E-series Management to report the numbers correctly by Platforms by introducing the new mapping for the new parts and implemented the same Working with Cross Functional Teams. Worked Closely with the SMEs to identify and solve existing production bugs, run through the proposed solutions with IT & Business teams.

Analyzed and Enhanced the Existing reports in OBIEE for the Various KPI on Customer Life cycles and product Life Cycle Flags

Lead role in Identifying and Enhanced the Impacted Opportunity reports for the various Dashboards up on change of process from SFDC to SAP C4C Implementation

Drive Accountability for the product Operation Function, leading the implementation of the definition of various Products and specific KPI

Tracking the challenges/roadblocks identified in prior UAT Phase, Analyzed, discussed and provided the Business solution to IT, Worked Closely with ETL/BI team for Production issues/incident fixes, bugs with in SLA Goal

Technical and Functional Design Implementation Lead for OBIEE Dashboard to Tableau Migration project using HANA Data Virtualization identifying the Gaps fields from DWH and HANA DE layer

Integration of multi-data source environments from Oracle and Hive for Auto Support Metrics for various Business Functions to support the KPI needed for Business Reviews

Apple Inc, Data analyst Sep’13 – Jan ‘14

Worked as Data Analyst for Analyzing and tuning complex SQL queries generated in Java web services and Java core for launching the ilog application that supports advisors at all locations. Module generated cases for Product, Agreement, Dispatch, and Shipping

Analyzed the queries generated by OBIEE reports and tuned the query for faster retrieval Of Data.

NetApp Inc, BI Developer Sep ’12- Jun’13

Worked in Customer Support Reporting Team. Analyzing the data from SAP CRM Application for Installed Base, Support Cases, Part Request, Part Return, Field Support Information Domains and delivered the finished product of dashboards to meet the Milestones of GS BI engagement Model.

Automated Part request Outstanding, Top Part Return Offenders, part stuck report etc., reports in flexplore Environment.

Trained Customer support operations team in onsite and offshore with development process of the OBIEE Dashboards and reports for Installed Base Module and worked as an Interface between the IT and Business to generate various reports

Cisco Systems Inc, OBIEE lead developer Nov’ 11- Aug’12

Analyzed the queries generated by OBIEE reports and tuned the query for faster retrieval Of Data.

IronPort Operations - Iron Port is an Email Security Appliance that protects against messaging threats. Worked as a Data Architect and solution provider replaced the Legacy Neotrix and Mumba Reporting tool with OBIEE 11g. Set up a datamart and BI reporting environment. Identified Facts and Dimensions from the existing Oracle ERP systems for Finance Module, Order Management and Key Sales System. Built the RPD and developed the various reports to help analyze trends.

Analyzed and generated Operations Fact (fin_rev_rec_fact) and Dimensions - Theater, order, customer, time in physical, BMM and presentation layer, generated the timeline reports.

Identified key requests, sales facts and licensing dimension from licensing sales App. Created Total days Approved, TOP N reports on customers, licenses and requestors.

Built shipments dashboard based on shipping fact from the oracle-shipping module.

Created finance, operations, key requests, adjustor roles in weblogic, implemented security at dashboard, report and data level using LDAP authentication.

Created the Groups, Users and roles assigning the users to roles and set up the web-groups in UI, setup permissions mapping them to objects (Dashboard, folder, report level, tabs)

Implemented the Proxy Setup and OBIEE ‘Act as’ functionality.

HRMS-Cisco - worked on the Integration & Migration of CMMC and HRMC 11.1.3 to 11.1.5.

Worked on OBIEE dashboards covering Absence Management, Acquisition, Employee relations, staffing, Talent Planning and Workforce Planning, transfers, Recruitment.

Involved in 10g to 11g Migration; Analyzed and provided estimates for Migrating and modifying the existing reports in 10g. Identified the product bugs in 11g like saved filters, performance issues with more than 2 column selectors and worked with oracle support to fix the same.

Debugging dashboard data issues and fixed mismatches with source HR database.

Created workarounds for Advanced SQL filters and TOPN reports in finance Dashboards of CMMC. Tuned complex SQL Queries involved in Dashboard reports

VMware, OBIEE consultant Aug ‘07 – May ‘09

As a member of the team that implemented the DWH using ODI from SIEBEL sales. The Worked on BI Sales dashboard to help analyze the Sales, Bookings, and Opportunities.

Developed complex reports using Analytic views pivot tables, narrative views, column selector, charts, unions, gonav, Case etc. Created Time series measures with Ago and Todate Functions.

Improved Dashboard Performance using Aggregate tables, Level based measures, Cache Management, Event polling. Worked on setting up of caching the reports using nqcmd command and logical SQL.

Created mappings using active/passive Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy. Developed Mapping and Workflows for Full / Incremental Load based on design specifications.

Configured Full load for AR, AP modules, Scheduled, Maintained and Monitored ETL using Siebel Data Warehouse Application Console (DAC).

Enhanced RPD to add Time Series Metrics, user level authentication Enhanced dashboard reports, security and IBOTs through different releases of the system. Debugged and fixed data mismatch issues.

CashEdge(FISERV), OBIEE consultant May’ 07 – Jul’ 07

CashEdge is a financial services provider offering solutions to banks and financial institutes. Created OBIEE Dashboard for financial transactions using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.

Presented repository security aspects to client, Gathered high-level security requirements to map them into content level security suitable for application service provider model.

Implemented Data level security identifying the groups and their permissions and privileges as per business needs. Set up of LDAP Authentication, security roles and assigning them to user/role/group tables

Cisco Systems, CA, Siebel Analytics consultant Oct’ 06 – Apr’ 07

Cisco has worldwide network academies offering curriculum covering various networking courses. Built the RPD and BI dashboard from ground up to visualize the vital stats of these networks academies.

Developed the Facts, Dimensions, necessary hierarchies and the joins between the logical tables, adding aggregates in the BMM layer developed subject areas needed, Created OLAP requests in Siebel Answers and multi-level requests (drill-downs and guided navigation)

Fine-tuned the performance of the RPD built with Materialized Views using Aggregate tables.

Wells Fargo, Minneapolis June ’06 – Oct ‘06

Worked as an ETL developer on the Electronic Loan Filing (ELF) initiative at Wells Fargo Home and Consumer Finance Group (HCFG). The homegrown ETL solution utilizes multiple databases including Image capturing and processing results involved in handling home mortgages and personal loans.

Created PL-SQL procedures, SQL-Loader control files, shell scripts. Fixed data integrity issues.

Wrote packages for capturing DML changes made by users for auditing purposes, for capturing Incremental Data Changes and to Populate Data into target tables

Tata Consultancy services, lead software engineer Dec ’03- Feb ’06

Client was Belgacom Telecom Provider in Belgium. As a Technical lead and project interface from TCS worked on the Order Management (OM), Carrier Pre-Selection (CPS) modules. A data mart is created to help analyze trends in order flows, customer retention and generate business reports.

Worked in the IT department of ITC. Worked on Oracle SQL and PL-SQL based applications writing PL/SQL packages (Procedures). Generating forms and oracle reports for the Insurance System, Salaries and Benefits and Discoverer reports for Optivision (SCM module).

Contact this candidate