PROFESSIONAL SUMMARY:

• More than 15 years of IT experience - 4 years of SAP, 11 years of Open Systems and Mainframes. Strong techno-functional experience in Implementation, Upgrade and Support in SAP BW and SAP HANA.
• Achieved 100% client satisfaction in 2SAP implementation projects with proven success in conducting CRPs, requirement gathering, design, project build, configuration, setup, system test and implementation, user support and training.
• Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges, Stored Procedures and CE Functions.
• Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.
• Completed 2 full-life cycle implementations of SAP BW which includes Data-Modeling (Star-Schema), Data Extraction, Data Loading (Full / Delta Up-Load), including Business Explorer Query Analytics and Reporting Design.
• Proficient in translating reporting key requirements as well as design and build the necessary data modeling, BW structures and reports, workbooks using Excel/macros.
• Extensively worked on SAP R/3 LO-Cockpit CO-PA, Generic Extraction and different modules like SD, MM and FI.
• Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information.
• Created the Process Chains to automate the data load and data target administration and monitored the processes.
• Comprehensive knowledge using SAP ASAP methodologies in Business Information Warehouse.
• Experience in Data-Provisioning techniques using SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality.
• Good HANA SQL scripting knowledge.
• Good Technical, Communication, Interpersonal and Client Interfacing Skills.
• Excellent analytical, self-learning abilities and able to prioritize and complete multiple tasks.

TECHNICAL SKILLS:

ERP: SAP R/3 version 4.7, ECC 6.0

Data Warehouse: SAP BW 7.3 & BW 7.4, SAP HANA 1.0(SP9), BO, CMC

Reporting Tools: SAP BExAnalyser, BEx Browser, Crystal Reports,Cognos Impromptu

Databases: Oracle 9i, SQL server 2000/2005, Ms Access

GUI Tools: Developer 2000, Visual Basic 8.0, Visual Source Safe, TOAD

Operating Systems: Windows 95/98/2000/XP, Windows NT, UNIX, IBM OS/390

EMPLOYMENT HISTORY:

Confidential

SAP BW/HANA Consultant

Responsibilities:

• Implementing a full life cycle Analytics solution which includes Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer.
• Report development on manufacturing modules like MM, PM, QM and integration experience with FICO.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Activation of the Business Content for Plant Maintenance (PM), Purchasing (MM), Quality maintenance(QM), CO-PA and customizing them as per the client requirement.
• Maintained Process Chains to automate and schedule the data loads.
• Hierarchies are implemented to support drill down reports.
• Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
• Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
• Loading data into table definitions, suspending data loads, resuming data loads.
• Designed and implemented SAP HANA 1.0 SP9 data modeling using Attribute view for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Expertise in migrating standard Infocubes, standard DSO’s to HANA optimized Infocubes, DSO’s and importing BW Models into HANA using HANA Studio.
• Monitoringand troubleshooting data loads.

Environment: SAP HANA1.0 SPS 09, BW NW 7.4, SAP BO 4.1, SAP ECC 6.0

Confidential

BW/HANA Consultant

Responsibilities:

• User Requirement analysis and development for COPA and FIGL reports and created LSA ++ dataflow.Responsible for analyzing the requirements and identifying the gaps.
• Responsible for reviewing Technical Design specifications.
• Involved in suggesting BW-HANA Blend scenario solutions for specific requirements where high volume of detailed data reporting is required in real time.
• Involved in ETL Based replication to provision the data from ECC to HANA system through BODS
• Involved in providing solutions to the complex requirements using BW 7.3 Infoproviders (Transient Infoprovider, Virtual Master Data InfoObjects, Composite Providers, Multiproviders) for HANA Models and resolved HANA Error’s like data type mismatch, numeric overflow, etc.
• Involved in identifying the area to improve the performance by utilization of HANA In-Memory Computing feature, Column Store, Calc Engine features.
• Involved in directing solutions to push the calculations to the HANA DB engine.
• Involved in Optimizing the Design of the data flows in BW, HANA for the requirements.
• Involved in Planning of data load activities, run book preparation.
• Hands on Experience in writing SQL, SQL Script, CE Functions
• Involved in coordinating with offshore for the daily deliverables throughout the ASAP phases.
• Involved in explaining the end user requirements to the Onshore/Offshore & filling the gaps.
• Meeting SLA for all the developments and continuously tracking for the updates to move the project in a smooth way to the target state.
• Involved in providing the solutions in HANA-BO reporting using Input Parameters, Variables & Hierarchies.
• Responsible for design, development and extraction of data from R/3 Source system and Flat files to the BW system.
• Created Process Chains which deletes the PSA Data based on the retention periods.
• Extensively worked with Data Flows.
• Extracted data from MM modules and uploaded the data into the Procurement Cubes.
• Created query Variants, Free Characteristics and exceptions using Query Designer.
• Extensively used Calculated and Restricted Key Figures, Restricted Characteristics, structures, Variables and conditions for the queries.
• Created Info-Packages and scheduling nightly jobs to run using the BW scheduler and handling Process Chains.
• Involved in defect management during SIT, UAT testing phases.
• Involved in Management of Transportation activities across the DEV, QA, PROD Environments.
• Involved in Coordinating with Upstream & Downstream teams for the data load activities.
• Involved in Tracking of Project documentation TDS, FDS, TUT, LLD.

Environment: SAP HANA 1.0, SAP BW 7.3, SAP BO 4.0, SAP ABAP, SAP BODS 4.0, SAP ECC 6.0

Confidential

BW Consultant

Responsibilities:

• Involved in the meetings with BP team to gather requirements for the enhancements.
• Helping the team in understanding the requirements and deploy the requirements within the timelines.
• Defined work packages and technical specifications for design, development and testing.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries using BEX reporting features like variables, exceptions and conditions in Sales and Finance areas.Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives.
• Perform unit testing and integration testing before moving the objects into quality system for UAT.
• Monitoring Data Loads and Trouble shooting. Worked on the fixes for the frequently occurring issues. Worked on back end development in order to meet the new reporting requirements.
• Worked on continuous improvements such as tuning the performances of the data sources, PSA and Change log cleanup activities.
• In depth knowledge of project management principles and full life cycle development with commitment to high quality work during the different stages of the project (Blueprint, Realization and Test).
• Complete knowledge of BW transports and hands-on diagnosis experience of transport issues/problems
• Diagnose and recommend query and data loading performance improvements using aggregate and indexes
• Communicate to SAP via OSS for problem solving and provide production support when necessary
• Implement and enhance standard BW business content. Design and develop data sources (generic, enhanced and custom) for extracting and staging data from SAP and non-SAP source systems to BW.
• Extensive Knowledge of BW Extractors from SAP R/3 4.6 and SAP ECC 6.0, as well as R/3 object dependencies, underlying tables and processes structures in functional modules. Ability to debug and fix extraction problems in BW.

Environment: SAP BI 7.0, SAP ECC 6.0.

Confidential

UNIX and Mainframe Application Programmer

Responsibilities:

• Prepare Design Documents based on the requirements gathered from the Business team.
• Develop source code/modify the existing code for budgeting and financial jobs in both production and non-production.
• Extensive Testing experience on production and non-production environments.
• Automating the batch cycle jobs in non-production environments by scheduling them and fixing for any errors that may arise.
• Code inbound and outbound Interface jobs for Bank of America, JP Morgan Chase, Deutsche Bank to FTP files from GIS to Mainframe and vice versa, from UNIX to Mainframe and vice versa.
• Support data fixes by executing mainframe jobs manually via TSO.
• Support data fixes by executing shell scripts from command line.
• Perform problem determination by researching GIS logs, GIS application server logs, Perimeter server logs, FMS/3 application server logs.
• Creation of BPML rules that will decrypt and encrypt the inbound and outbound files in GIS.
• Customized Infoview as per user requirement.
• Performed data validation by creating ad hoc reports
• Used import wizard to migrate reports, folders, users, groups, universes from different environments.
• Scheduled and published the business objects reports based on the user requirements.
• Added or modified users, groups, folders and rights using Central Management Console (CMC).
• Supported multiple customers with BMC Remedy ticketing system.
• Worked with SAP support to resolve any BO related tickets/issues.
• Involved in Business user meeting to fix and explain the reports for its errors and fixes.
• Involved in redesigning the Universe objects based on Business requirements.
• Interacted with end users and provided Production Support.

Environment: JCL, COBOL, DB2, FileAid, VSAM, TSO/ISPF, CA-Scheduler, CA-Agent, CA-Adapter, AIX/UNIX Shell script, Oracle 9i, SQL Server 2000, WinScp, GIS, Business Objects XI3.1/R2, Central Management Console(CMC), Import Wizard, Crystal Reports

Confidential

Senior Software Engineer

Responsibilities:

• Developed source code/modified the existing code using COBOL, C, JCL and DB2.
• Endevor actions performed in Batch, Online and Package options.
• Identify changes in the existing code using ‘Endevor’, analyze the impact of Changes using ‘CA-7 and File aid’ and identify the impacted modules.
• Performed Production Implementation upon successful user acceptance testing.
• Lead Major Project Implementations, Client new Release, Code review and verifications JCL/C/COBOL.
• Presented technical solutions for legacy out-standing Problem logs, coding in COBOL/JCL to provide fix.
• Conducted Disaster Recovery Plan exercises.
• Performed Contract/TimeLine Purge process, zOS Upgrade, PKZIP Upgrade and DB2V8 upgrades.

Environment: Batch C and Batch COBOL Programs. Platforms Client / Server (the server runs on Plano1B). JCL, DB2, PL/1, Eztrieve and Mainframe Maintenance Tools like Endevor, File-aid, TSO/ISPF, Info-X and SUPER-C, Syncsort, Platinum, QMF, CA-7, CA-11