SUMMARY:

• Analytics | BI Solution Architect | Business Solution Architect | Business Intelligence | Data Warehouse | Data Analytics | Data Modeler | Business Analyst | Business Solutions ArchitectAmbitious & Analytical thinker, Business savvy & customer centered with accomplished track record in Business Intelligence, Data Warehouse, Analytics, ERP, Business Processes and Project Management.
• Strong expertise in Business Analysis, Data Profiling/Analysis, and Requirement Analysis. Solve business problems by applying critical problem solving techniques resulting in measured success and ROI balancing agility with effective collaboration across Business and IT aligned with Company’s Goal & Vision
• Extensive Data Warehousing and Business Intelligence experience in Business Analysis and solution design through comprehensive and detailed Business Requirements capturing, Source System analysis, Data Analysis and Profiling, end to end understanding of Business Processes, Solution Design in Star Schemas and optimized Data Modeling in both Scrum and Waterfall methodologies
• Management in software development life cycle, implementation, training, maintenance, customer support, IT day - to-day task / projects in Oracle ERP/CRM Business suite of Applications

CORE COMPETENCY / TECHNICAL SKILLS:

Techno-Functional: Marketing, Sales, Finance, Professional Services Verticals - Strong knowledge of business process flow and underlying ERP data structures of Leads to Opportunity, Quote to Cash, Install to Support, Procure to Pay, Forecasting and Fiscal close processes

DW-BI Solutions: Analyzing Detailed Business Process flow and System Analysis to build robust, scalable, optimum & efficient BI solutions (Data Modeling, Mapping/Business Rules)

Business Solutions: Working directly with Business/Power users at various levels in Business Requirements gathering and translate the BRD into Analytical Dashboards/Reports

Data Analytics: Proficiency in Data Integration, Data reconciliation, Data Anomaly patterns, Data lineage and profiling, trouble shooting

DW/BI: OBIEE, Tableau, Cognos, Neo4J, DataStage, Informatica, Pentaho, ERWIN, Splunk, ServiceNow, Oracle, SQL, PL/SQL, Data Modeling, Dimensional Modeling, Aggregation and Real Time Analytics

ERP/CRM suite of applications: SFDC, Oracle Financials/Sales/Services, SAP Install Base

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Solution Architect / Business Analyst / Data Analyst / Program Management

Responsibilities:

• Assessed, analyzed and completed BI capabilities for Sales/Finance/Professional Services with detailed documentation of charts, mockups, flow diagrams, formulas, Data lifecycle for star schema and Business Rules mapping, ETL flows with mitigation plans and program management
• Analytics helped Confidential Business to manage and drive pipelines into solid bookings, manage revenue, manage BU procurement/expenses, fulfill and track professional services, leverage X-sell/Up-selling using IB mastered data, projected bookings during fiscal close and forecasting in Finance/Sales/MFG-Ops
• Stability / Efficiency & Optimization / Cost Savings / Year over Year Growth
• Achieved stability/agility in Data Warehouse system, by analyzing and removing redundant flows, enhanced Data quality through Data lineage and reduced overall SLAs/OLAs by a margin of 25%
• Delivered 360-degree view capabilities to track Campaigns, Opportunity-Quotes-Sales Orders-Invoice-Payments linkage, MFG-Ops Forecasting, Professional Services execution/management, Revenue Recognition, General Ledger View, Procurement and Purchases, Payables, Finance Wall Street Reporting by blending and integrating data at an Enterprise level with ability to drill down/through Global/Local level
• Advanced/Predictive Analytics & Ad hoc capabilities
• Designed and modeled near Real Time Analytics in providing hourly refresh of projected Bookings to Management and Executives to help manage Forecast targets Vs Sales to meet Company Goals
• Worked along with SAP-HANA team to achieve model and analytics capabilities enabling Quoting team to intelligently provide Discount Margins based upon What-If and Predictive algorithms and modeling
• Conceptualized, Designed, Delivered and Supported Real Time Install Base - Best Known Configurations Mastered Data, empowering Sales growth leveraging X-Sell/Up-Sell
• Data mining data in AutoSupport to help business community especially the Sales team for X-Selling and up-Selling in Quoting and Configuration management
• Enabled end user self-service BI capabilities through Tableau by providing support, knowledge, and also delivering of prototypes of extensive Tableau visualization and reporting in Tier-2

BI Consultant: Business Analyst / SME / Data Analyst

Confidential, CA

Responsibilities:

• Identified and reconciled fixing massive revenue bleeding of $.5M for first 6 months of 2008 by analyzing/designing processes to collect back lost revenue as well as prevent future occurring
• Captured business requirements, analyzed and designed various business capabilities (i.e., credit card payments / Confidential transactions / Confidential transactions processed data imports, revenue modeling and account receivables bank reconciliations to sales
• Demonstrated various roles in lifecycle of BI development to establish patterns of fitness metrics with human traits and intervals of time
• Led efforts and implementation of BI solutions and analytics that linked human resource and real estate data to deliver lease management and property management reporting / analytics

Confidential, Redwood Shores, CA

Business Analyst / Tech Lead / Project Lead

Responsibilities:

• Engaged with Oracle sales team to build the BI-Sales Analytics, logical data model, KPIs, charts, BI canned reports for Executives and Sales Management
• Carried out requirement analysis, design & development of Student Enrollment module to manage registrations of units/courses/programs, pre enrollments, bulk enrollment/discontinuation, enrollment rules engine, importing legacy data, business events, notifications and workflows