Sap Bi

GAURAV MAKIN

*** ********* ***** **. | Hermitage, TN 37076 | Phone: 615-***-**** | Email: *****.******.**@*****.***

SUMMARY

• 5 Years of SAP Business Intelligence / Warehouse (BI / BW) experience as lead SAP Architect

• 2 Years of .Net Programming experience as Information Generalist

• 10+ Full Life Cycle implementations of SAP BI solutions from initial concept to go-live production deployment

• Successfully handled responsibility of lead SAP BI Architect for custom BI CRM data model which included design, development and end to end implementation of data model and security components, complex ABAP routines and report subscriptions using information broadcasting

• Engineered & implemented the automated error stack monitor which greatly reduced time spent on defect resolutions

• Successfully set up development standards and best practices, improving internal delivery processes cutting timelines by at least 20%; helping build stronger BI practice

• Proactive thinker, known for designing efficient SAP BI solutions suited for changing requirements, passion for taking initiatives that results significant cost savings and potential revenue growth opportunities & practice expansion

• Expanded responsibilities to lead multiple concurrent BW projects. Also, received multiple company recognition awards for my leadership and for exceeding objectives on multiple projects

PROFESSIONAL EXPERIENCE

Deloitte LLP - Nashville, TN June 2007 - Present

BI Specialist

• Managed end-to-end SAP BI deployments & project deliverables ensuring deadlines were met and solution delivered met client expectations (Typical Project Size ~ $300K/ Team Size 3-10). Performing various roles including:

+ Requirement gathering, Identify & help define KPIs, Project planning, Gap analysis & Review/Approval of requirements

+ Design of architectural layout & Engineering of solution including detailed design of data flows and creating technical specs, oversight of development

+ Development, Testing, Quality Assurance support & Deployment to production with post deployment Production Support, Design and application presentations.

• Designed and developed data model for custom work services management reporting using data services, SAP HANA & Visual Intelligence which helped firm leadership better plan for resource acquisitions based on work patterns and facility usage

• Managed the development projects between the US team and the Indian offshore development team to facilitate accurate and timely delivery of projects. This entailed managing the design reviews, development reviews, project plans and training sessions.

BI Developer

• Managed all of the SAP ERP, BI and BW Accelerator upgrades associated tasks which resulted in faster speed-to-delivery for the customer

• Performance optimized data model to reduce data load run times from 7.5 Hours to 15 minutes.

• Consult on projects interested in utilizing SAP as a possible solution – this includes holding meetings for feasibility analysis/studies, performing demos of the technology, demonstrating functionality to end clients

• Designed & developed data model for forecast and budgeting of financial & time data by consolidating data from SAP and non-SAP source systems at varying degrees of granularity which allowed firm leaders to forecast time & allocation of resources effectively.

• Designed and developed data model for custom project management reporting which provided firm leaders insight, via a consolidated view, of ongoing projects and their current status.

• Conducted workshops with team members & also performed cross-training of other developers on the technology

BI Information Analyst

• Partnered with SAP directly to assist in the researching issue resolutions & identified defects to ensure smooth functional of SAP Business Warehouse

• Oversaw technical aspects of a business warehouse ensuring SAP compliance is followed.

• Ensured data integrity and accuracy to reduce defects & downtime, monitored the integration with SAP ERP systems and .NET applications using SQL databases

Middle Tennessee State University – Murfreesboro, TN August 2004 – June 2007

IT Generalist (Graduate Assistant)

• Responsible for maintaining MTSU website using CGI Perl & leveraging Access and MySQL to develop in-house scripts, queries, and new business process change models in existing applications

• Developed library management system using Visual C# which included development of Entity Relationship diagrams (ERDs) and Class Diagrams, develop Use Cases and Test Cases, research the software reverse engineering process, writing the System Statement of Scope and preliminary User Manuals and documentation and presenting the use of the application

• Developed a customizable property management software and GUI in Visual C# for the hotel industry

TECHNICAL PROFICIENCIES

SAP BI Data Modeling & ETL Expertise in data model design & development. Info Objects, DSO, Cubes, MultiProviders, Info Sets, Virtual Providers, Simple & Complex transformations, ABAP Routines (Start / End / Expert), Rules (Update / Transfer), ABAP Debugging and optimizations, Data Sources, Extractors, Analysis Process Design (APD), Data Transfer Processes, Info packages, Aggregates, BW Accelerator index creation and monitoring. Data extraction from SAP & non – SAP source systems, manage load processes / schedules via process chains and scheduled jobs, open hub (info spokes), delta functionality

SAP BI Architecture Experience in SAP BI (3.5, 7.0 & 7.3). Experience in BW landscape overlay’s and upgrade projects (3.5 - 7.0 & 7.0 - 7.3)

Security & Performance Custom security models, ABAP user exit design, namespaces, roles, authorizations. Optimizations using cache, BW Accelerator indexes, query optimizations, Information broadcaster, Reporting agent methodologies, Master Data Management, Executing Stats and Compression on Info providers

Reporting & Visualization Tools Experience in BEx tools such as Query Designer, Web Application Designer and Visual Composer. Experience with visualization tools such as RoamBi, Tableu and Qlikview

Business Objects (BO) & SAP HANA Experience with different BO products (Data Services, Xcelsius, Explorer, Crystal Reports, Visual Intelligence, Universe Design), Integration points with SAP BI, building custom information spaces built on SAP and non-SAP info providers using SAP BO Explorer, Authorizations of business objects applications via Central Management Console (CMC).

Experience in creating tables and views to store data in SAP HANA loaded via data services, creating simple and complex attribute, analytical and calculated views in SAP HANA

Programming Familiar with programming concepts and languages such as C++, Visual C#, Perl

EDUCATION

M.S. Computer Science, Middle Tennessee State University (MTSU), Murfreesboro, TN Aug 2004 – Jun 2007

B.E. Electronics & Telecommunication Engineering, Vellore Institute of Technology, Vellore, India Aug 1998 – Aug 2003

WORKSHOPS / TRAININGS

• SAP BI Data Warehousing (BW310), SAP BI Modeling & Implementation (BW330), SAP BW Data Acquisition (BW350), SAP BI Reporting & Query (BW305), SAP BI Integrated Planning (BW370), ABAP Foundations (BC400)

• Core concepts of Business Analysis, Project Management, Workflows & Business Process, Leadership in IT organizations

• SDLC, Agile (SCRUM), Waterfall Methodologies, Unit Testing

• User adaptability and Usability of applications and Training & Customer Support

Contact this candidate