SUMMARY:

• I am a SAP HANA developer who has over 10 years of extensive experience creating, analyzing, executing, and designing visual reports .
• I am considered an expert in SQL 2005/2008 Business Intelligence BI, and I have a lot of experience with SAP BW and SAP HANA. I am also proficient in data warehousing concepts, and have worked extensively with relational databases like Oracle 11g/10g and SAP HANA.
• My clients include JNJ, Mosaic, GMC, Hospira, Marathon Oil, US Navy, Shell, Monsanto and Mckesson.

TECHNICAL SKILLS:

Database Types: SQL, Access, Oracle11g/10g, IBM DB2, SAP HANA 1.0 and Teradata .

Reporting Tools: Tibco Spotfire Professional 5.0, 6.5, 7.0, Tableau 8.0, SSRS and BO Explorer .

Methodologies: Agile Scrum and Waterfall .

Other technologies: Oracle, MS Access, MS SQL Server, SAP CRM, SAP BW, FI/CO, ABAP, HTML, XML, PL/SQL, BODS, Business Objects, C++, IronPython, .NET, TERR, HTML Spotfire Professional, S4/HANA, Tableau, Qlikview and Java.

PROFESSIONAL EXPERIENCE:

Confidential

SNR. SAP HANA Developer / Consultant

Environment: - SAP HANA 1.0, BODS 4.0, ECC 6.0, Spotfire, Tableau, S4/HANA

Responsibilities:

• SAP HANA data provisioning and using SAP LT Replication Server (SLT).
• Designed innovative approaches to view and interact with data for analysis .
• Generated SAP HANA views from BW system for Spotfire reporting .
• Replication using Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0.
• Converted multiple reports from Excel, Tableau, and BO to Spotfire.
• Developed SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Ability to collect business requirements and define functional & technical specifications.
• Created functional requirements as input to application design while identifying the type of visualization that best suits the client’s needs.
• Attended project reviews with business analysts to ensure functional requirements are met .
• Reviewed and tested functional designs for BI, data discovery and analytic solutions .
• Depicted the SAP BW process by replicating the entire ECC tables into HANA through SLT and built HANA views and BO reports, thus eliminating BW from landscape.
• Expertise with SAP HANA Studio with Modeling and Administration Perspectives

SAP HANA Developer

Environment: - SAP HANA, ECC 6.0, BODS, SharePoint and Tableau.

Responsibilities:

• Used BODS to Provision data from 12 varied data sources like Fleet Information, driver details, vehicle maintenance, vehicle parts, engine, chassis details, trip/route details etc.
• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, and Reporting and Testing process.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Responsible for migrating reports from Development to Acceptance/ Production server .
• Expertise with HANA Administration areas like Authentications, security management, backup and recovery, Persistency layer management..
• Replicated data using SLT and BODS and created models as per requirement..
• Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA.
• Developed Jobs in SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.
• Attended project reviews with business analysts SME’s to ensure functional requirements were met .
• Involved in moving Information models to BW as transient provider and created Reports.
• Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
• Participated in project management activities including scheduling the testing and release phases of reports.
• Produced time sensitive reports for HR, MM and Financial personnel.
• Excellent skill set in building queries using Reusable structures, filters, Restricted Key Figures, Calculated Key Figures, formulas, conditions, and exceptions.

BI Consultant

Environment: - SSIS, SSAS,SSRS, Tibco Spotfire, SQL 2005/2008 and Oracle

Responsibilities:

• Ensured that source to target transformations maintained data integrity .
• Developed SSIS packages and TSQL stored procedures for data loading, integration, data access and external data feeds .
• Dimensional data modeling star schemas, key performance indicators and other OLAP considerations .
• Performed performance tuning and optimization of SQL databases .
• Extensive experience scheduling SSIS packages .
• Strong analytical and troubleshooting skills .
• Performed backend testing by SQL statements with Oracle to ensure correct data was returned by application.
• Created SQL server stored procedures, functions, views and tables to build ETL feeds .
• Configured slow and fast changing dimensions .
• Worked on report design, query design, testing and query performance tuning using aggregates and indexes.
• Involved in requirement gathering and conceptual design for developing the data warehouse.
• Developed complex dashboards and reports using Tibco Spotfire Professional.
• Performed user training on reports created in SSRS and Tibco Spotfire Professional.

SAP BW Consultant

Environment: - SAP CRM, SAP BW, Oracle, Teradata

Responsibilities:

• Gathered requirements for SAP BW implementation with major oil company as the client .
• Designed and maintained Infocubes, ODS Objects, Infosources Infopackages and transfer rules for the datawarehouse solution .
• Implemented data warehousing solution for FI/CO, SD, HR and MM modules .
• Involved in preparing the AS-IS and TO-BE business process documents.
• Designed logical data models based on functional requirements and load strategy specifications to capture source data, data consolidation mechanisms and integration scenarios for reporting purposes.
• Worked on Report Design, Query Design, Testing and Query Performance Tuning using Aggregates and indexes.
• Defining ODS objects, Aggregates, Multicubes and Data loads from various source systems like R/3 systems, Non R/3 systems and Legacy systems and flat files.
• Created Datasource enhancements, Generic extractors, Logistics Cockpit configuration and customization, Business Content, User exits, and customized delta built up for the datasources.
• Well versed with EDI, ALE, IDOC interfacing technologies, and experience in Troubleshooting Dataloads and Update routines using SAP's OSS notes.
• Business Analyzer, Infoset Query, Web Application Designer, Business Explorer for Reporting

Database Admin

Environment: - SQL Server, Access

Responsibilities:

• Maintained multiple, interacting MS SQL Databases on multiple servers.
• Performed DBMS installation and patching.
• Was responsible for backup of servers and recovery.
• Created stored procedures from user requirements.
• Performed server installation and software distribution.
• Performed ad-hoc requests for data manipulations, imports, exports, and updates.
• Enforced best practices in database administration and security protocols;
• Tracked and resolved data user issues and concerns, such as helping to extract data and develop reports.
• Interacted with internal clients to develop database solutions that met business requirements.