SUMMARY

• Over 17 years of extensive experience in the Information Technology industry. Worked on technologies SAP HANA, SAP BI/BW, Oracle 10g, other BI tools and programming languages. Strong analytical skills, strong in SQL Scripting. Experienced in Big data concepts, proficient in Project management skills.
• SAP HANA Certified Consultant.
• Worked on data loads to SAP HANA with Data Extraction Transfer Loading (ETL) using SAP BOBJ Data services 4.0.
• Worked on SAP HANA data provisioning and using SAP LT replication server (SLT).
• Experience with SAP HANA data modeling using Attribute View, Analytical View and Calculation view.
• Experience with SAP HANA programming including SQL, SQL Script, and CE Script.
• Worked on SAP HANA administration including managing schemas, data model objects, import/export content.
• Worked on SAP HANA security including User Management, roles and Privileges.
• Created Decision tables in SAP HANA as per requirements.
• Extensively worked on SAP HANA Analytical privileges, granting access and restrictions to users on various views within the data modeling.
• Worked on full life cycle implementations in SAP BW/BI. Worked in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover and Training to Go Live.
• Well - versed and experienced in designing, creating, and maintaining custom InfoObjects, InfoCubes, DSO, Data sources, Transformations, DTPs, MultiProviders, remote cubes, applying filtering conditions, aggregates, InfoSet queries, initial, delta, full uploading methods, InfoPackage groups, and process chains.
• Installed SAP BI Content and created SAP BI and ECC integration by RFC.
• In-depth understanding of SAP NetWeaver components, architecture, configuration, and integration.
• Solid ability to work closely with clients and internal teams to assess needs and implement solutions.
• Having strong experience in Custom Development & enhancements in SAP BW/BI/BOBJ and ECC.
• Managed complex project involving multiple product implementations like SAP BW/BI/BOBJ, ECC, APO and CRM.
• Proven strengths in strategy, operations and Team Management.
• Successful Leader in Implementations and supports projects.
• Exemplary communication, analytical, and problem-resolution skills.
• Extensively worked on Administrative Workbench for Configuring, Scheduling, and Monitoring functions.
• Extensively involved in performance tuning of SAP BI/BW systems.
• Enhanced Master Data, Transaction Data extract structures.
• Experience in design, development and monitoring complex Process chains for all functional modules.
• Performed extensive LO Cockpit extractions.
• Worked on back end Data Extraction, Data Loading, Data Staging for FICO, SD, MM, PP, HCM, CRM & SRM modules.
• Created generic data sources for extraction and experience in data source enhancement.
• Created transformations, Start routines, End routines, created DTP’s for full load and delta loads.
• Developed reports using BEx Query Designer and BEx Analyzer. Created CKF’s, RKF’s, workbooks, and channels.
• Used ABAP conversion routines extensively in transformations, transfer rules and update rules.
• Improved Data Load and query performance using compression, aggregates and partitioning.
• Involved in Unit testing & Integration testing and Consolidation systems before moving into Production system for bug fixes and new developments and transportation issues.
• Prepared test cases, test scripts for Process testing, Unit testing and Integration testing for FICO, SD, MM, PP, HCM, CRM & SRM modules.
• Involved in Extended Star-Schema design, Data loading, Query creation, for SD, AR, General Ledger, Credit Management.
• Monitoring daily loads and sending load status reports to business users.
• Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, capable of working efficiently under pressure, managing multiple projects, and cross training subordinates in other functional areas.

TECHNICAL SKILLS

ERP: SAP ECC 6.0, 5.0, 4.7 & R/3

ESA: SAP NetWeaver, XI, Enterprise Portals 6.0, 5.0.

Data Warehouse: BI7.3, BI 7.0, 3.5, HANA 1.0

Languages: PL/SQL, SQL,T-SQL, JAVA, C, C++,.Net, ABAP/4

Operating Systems: Windows NT/XP/Vista/7/8, UNIX, Linux and OS/2 Warp

Software: Developer Suite, .Net, Power Builder 11.0, Visual Baisc6.0 Actuate 9.0/11.0

RDMS: Oracle 10g, 9i, 8i, DB2, MS SQL Server 6.0, Sybase System11

Reporting Tools: Actuate 9.0/11

BOBJ: Webi, Xcelsius, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr SAP HANA/BOBJ Consultant

Responsibilities:

• dis is a proof of concept project implementing HANA over BOBJ for business unit to get the advantage of faster Analysis on Big Data for the client Confidential .
• Worked on loading data to SAP HANA with Data Extraction Transfer Loading (ETL) using SAP BOBJ Data services 4.0.
• Created Various Attribute View, Analytical View and Calculation view as per analysis in SAP HANA Modeling.
• Programmed SQL, SQLscript and procedures to implement business logic in a database. Worked on both Graphical and SQLScript of Calculation view.
• Created SQL script procedure for CE (Calculation Engine) Functions.
• Created Analytical privileges on different views for different users as per business requirements.
• Involved in gathering requirements for Big data analysis of client data.

Environment: SAP HANA 1.0 SP5, BOBJ 4.0

Confidential, TX

Sr System Analyst SAP BI/BW

Responsibilities:

• Worked on complex reporting issues related to Collateral Management.
• Scheduled, monitored both Master Data & Transactional data flows through Process Chains on a daily basis throughout the life cycle of the project in each environment.
• Was successful in troubleshooting and performance tuning which reduced execution time of several jobs.
• Production support for the nightly batch jobs to meet the SLA’s.
• Hands on development with the new Enterprise Data Warehousing (EDW) including new Real-Time Data Store, BI Data Source, RDA, Visual Composer and the new Transformation and Loading tools using the DTP. Implemented Information Broadcasting through the BI Portal.

Environment: SAP ECC6.0, SAP BI7.3, BOBJ 4.0, FS-CMS, FS-BP, FS-CML

Confidential, FL

Sr System Analyst SAP BI/BW

Responsibilities:

• dis is a full life cycle SAP BI implementation project and was involved in Business Blue Print preparation, Business requirements gatherings, functional design documents & technical design documents preparation.
• Enhanced the extract structures and populating them with the User-Exit and Function Modules
• Developed a generic data source to pull credit card transaction data from ECC to BW.
• Identified data modeling techniques, and designed InfoCubes and ODS objects, as well as different aspects of time-dependant and non-time-dependant master data attributes.
• Worked on BW business content data source enhancements, generic extractors, and user exits, and customizing delta built up for the data sources.
• Worked on material classification configuration.
• Used Delta update mechanisms for uploading data to BW from ECC in specific intervals. Extensively used Process chains to load data to the data targets.
• Resolved BEx Analyzer issues, as well as GUI errors such as ActiveX error.
• Created manuals for references and involved in training end users.

Environment: SAP ECC6.0, SAP BI7.3, SAP FICO/GL, FI-FM

Confidential, TX

Lead /System Analyst SAP BW

Responsibilities:

• dis project is a migration project from Oracle 9, Actuate Reports to SAP BI/BW
• dis is a full life cycle SAP BI implementation project and was involved in Business Blue Print preparation, Business requirements gatherings, functional design documents & technical design documents preparation.
• Involved in enhancing the existing BW object like DSO, Infocubes, Multiproviders for spend and purchasing reports.
• Identified data modeling techniques, and designed InfoCubes and ODS objects, as well as different aspects of time-dependant and non-time-dependant master data attributes.
• Production support for the nightly batch jobs to meet the SLA’s.
• Worked on change requests in the existing design of SAP BW in the areas of Purchasing, Shopping carts and Account payables. dis includes enhancing the existing BW objects, creating new BW.
• Created /Modified update rules, update routines, start routines, transfer rules, transfer routines wherever required.
• Worked on performance to improve the query execution time, created Aggregates, Number Range Buffering, Indexes, rearrange the dimension characteristics and partitioning the cubes.

Environment: SAP ECC6. 0, SAP BI7.0, SAP Banking (DM, AM,BPP) SAP FICO/GL