SUMMARY

• Industrious senior BI/Analytics practitioner with proven record in envisioning, designing and implementing scalable and efficient enterprise reporting/analytical solutions to enabling data driven decision - making. Creative problem solver who has consistently completed projects on time and within budget.
• Data Analytics, Reporting and Visualization
• SAP HANA and SAP Business Objects BI Suite
• Analytical and Problem-solving
• Leadership/Communication
• Project Management
• Mentor

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects BI 3.x/4.x Enterprise Suite (WebI, Design Studio, Lumira, Crystal Reports), Tableau

Databases: SAP HANA, Oracle, SQL Server, Teradata, MySQL, PostgreSQL, Greenplum

SAP ERP/BI: SAP ECC, S AP BI 7x, SAP CRM, SAP AFI

Data Modeling: SAP HANA Studio, Erwin, MS Visio

Languages: SQL, PL/SQL, HTML, XML, Java Scripts

ETL: Informatica, Data Services

PROFESSIONAL EXPERIENCE:

Tech Lead/BI Architect

Responsibilities:

• Lead a global team of developers (on-site/ off-shore) to enable reporting solution (100+ reports) as part of Confidential Financial Transformation (SAP Bank Analyzer Implementation) to deliver Operational, Accounting and Regulatory reports in a big data scenario (billions of records)
• Proposed BI and Security Strategy, data modelling/sizing/partitioning strategies, development guidelines and reporting templates for the BI landscape
• Worked effectively with the business stakeholders and analysts to identify and understand the reporting requirements and provide efficient solutions
• Proposed and implemented an efficient solution using HANA SDA (Smart Data Access) to combine data from two different systems, eliminating the need for data replication and reducing the development timelines
• Conducted multiple sessions/presentations to demonstrate the features and functionalities of SAP HANA and its integration with reporting tools like Web Intelligence, Advanced Analysis, Lumira and Tableau
• Built the Report Inventory solution to increase BI user adoption and experience with single point of entry for BI Content, direct navigation to the reports and searchable report metadata
• Implemented custom time dimension and currency convert functions to simplify the technical implementation and improve performance
• Design/Performance review and tuning of all reporting HANA models developed by the team.
• Reported project progress, risks, and updates to upper management on a weekly basis

Confidential

Lead BI Architect

Responsibilities:

• Actively participated in defining the reporting architecture and strategy for migrating from a NetSuite/SAP BW to SFDC/SAP HANA landscape to enable Sales Reporting and Dashboards
• Built efficient and scalable SAP HANA Information models to enable complex dashboard and reporting solutions using Tableau and SAP BusinessObjects Suite
• Developed multiple Tableau dashboards to provide high impact visualizations of key metrics with Confidential user interface and navigation
• Provided usage scenarios and best practice guidelines for enabling SAP BusinessObjects Enterprise Suite (Web Intelligence, Lumira, Design Studio, Advanced Analysis) reporting based on SAP HANA data sources
• Designed and built Aging Metrics Analytics Solution to provide automated and timely Aging Metrics notifications and escalations to respective approvers/originators to increase productivity across Manufacturing, Quality and Design Engineering teams
• Designed the performance, stress testing scenarios for the reporting solution

Lead BI

Responsibilities:

• Designed and implemented comprehensive Sales, Inventory Dashboards using SAP Dashboards/Xcelsius, and Web Intelligence drill-down reports providing valuable insights into business metrics and KPI’s
• Dashboard solution involved dynamic role based layouts and row-level security restrictions
• Prepared detailed documentation to assist users in dashboard navigation, analysis and understanding of the key metrics used in the dashboards
• Built complex Crystal Reports and Web Intelligence reports to enhance business user interactivity and productivity.

BI/Reporting Lead

Responsibilities:

• Successfully lead and managed a team of BI developers to roll out executive and operational dashboards (Xcelsius/Design Studio) and reports to Finance and Marketing business units spread across different global regions
• Regularly provide timely status updates to stakeholders and senior management by preparing monthly/weekly management scorecards and presentations
• Automated multiple standard close and forecast reports/dashboards thereby increasing the productivity of business analysts
• Built Tableau dashboards and reports based on SAP HANA views
• Established best practices and guidelines for designing BI dashboards and reports based on performance, data volume, user experience and consumption.
• Improved BI development delivery pace by effective prioritization of pipeline, optimized resource allocation and following Agile processes

Sr SAP Business Objects/Xcelsius Consultant

Responsibilities:

• Worked extensively with SAP BASIS and Security teams to install and configure the SAP Business Objects Integration Kit and define SAP authorizations/roles
• Interacted with SAP BI and CRM functional/technical developers to enhance the CRM extractor, design and develop the SAP BI virtual providers and multi providers utilized in building real-time CRM dashboards
• Built operational dashboards with (Service Desk Dashboard, SLA Metrics, Forecast and Pipeline dashboards) using Xcelsius with detail level drill-down Web Intelligence reports

Sr SAP Business Objects/BI Consultant

Responsibilities:

• Worked extensively with the SAP BASIS and SAP Security team as part of the SAP BI and Business Objects Integration to design and implement the security and NetWeaver/Business Objects InfoView portal integration
• Built over 100 reports (Income Statement Reports, Cost of Revenue/Gross Margin Reports, Balance Sheet, Staff Summary, and Revenue by Market Segment etc) as part of the Quarterly Financial Review (Actual & Forecasting) Reports
• Built Cost Center Headcount report with dynamic report layout requirement (different report layout based on user authorizations) and high user interactivity

Sr Business Objects/Xcelsius Consultant

Responsibilities:

• Actively involved in the migration from SAP Business Objects XI R2 to SAP Business Objects XI R3.1
• Involved in the design, development and deployment of IHSS and DEBS dashboards using Xcelsius 2008
• Developed Alert Notification Reports and Mail Merge Reports using Crystal Reports

Sr Business Objects Consultant

Responsibilities:

• Successfully lead and completed multiple Business Objects reporting initiatives - TA Adhoc, International Products, Institutional Products, Fixed Income Characteristics
• Developed Web Intelligence and Crystal Reports with varying level of complexities with respect to data retrieval and report formatting/layout
• Developed custom Audit Reports to effectively monitor and administer the User activity and Report/Universe usage in the BI Landscape
• Designed and Implemented a comprehensive Content Management Plan involving 200+ users distributed over 20 business units.