We provide IT Staff Augmentation Services!

Tech Lead/bi Architect Resume

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:

Confidential

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
Confidential

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.

Confidential

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
Confidential

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
Confidential

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
Confidential

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
Confidential

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.

Hire Now