CAREER PROFILE:

• Having 14+ years of IT experience in Analytics, Business Requirement Analysis, Application Design, Development and Support, in the Telecommunications, Energy & Utilities, Health Insurance and Insurance domains.
• SAP HANA: Having 4+ Years of experience in SAP HANA 2.0 as a Native HANA Consultant. Expertise in Data modeling - Attribute View, Analytic View, and Calculation View. SQL based calculation views were also created in order to address complex business requirements. Experienced in SAP HANA programming including SQL, SQL Script, and Stored Procedure.
• Mainframes: Had 8+ Years of experience in IBM Mainframe using COBOL, JCL, DB2, VSAM, SAS, SQL, Easytrieve and IMS DB.
• Extensive experience in reporting and handling complex scenarios using Joins, Table Function, Table Types, Views in SQL. SAP HANA Data Administration including managing schemas, data model objects, import/export content.
• Created advanced modeling using hierarchies, derived views, restricted calculated column, variable, input parameter, currency conversions.
• Hands on experience in SAP HANA Data provisioning using SLT Replication server and
• SAP BO Data Services 4.0.
• Experience in SLT Environment configuration for real time replication of ECC data to SAP HANA 2.0. Worked in SLT DMIS upgrade testing like verifying Performance of Table replication, ABAP routines, Filters, and Load Statistics.
• Experience in working on SAP BW Content objects such as Info Objects, DSO’s, Info Cubes, Multi provider, Transformations and running Process Chains.
• Having good experience in ABAP programing and worked on Routines like Start Routines, Field Routines & End Routines.
• Having good knowledge on SAP HANA Architecture.
• Successfully implemented all BW SCM model reports into HANA reports. Involved in End to End implementation of the projects from Requirement gathering, Design document preparation, Build, UAT support, implementation and PGLS support.
• Had experience in SAP Native HANA Modeling on SAP ERP modules like Finance, Supply Chain, Sales & Distribution, Material Management and Purchasing.
• Experience in creating Dashboards and implemented Stories in SAP Analytics Cloud (SAC).
• Having good knowledge in S/4 Embedded Analytics in creating CDS view (Basic Views, Composite views, Consumption views) and good exposure to use them in FIORI list apps.
• Having good knowledge SAP HANA Web IDE, Multitenant applications, Database Containers, Synonyms, Flow Graphs and Data Archival process.
• Having good knowledge on building HANA views using SDI/SDA and ETL process using Data Services.
• Worked on Agile and Waterfall Models.
• Highly organized with ability to manage the Tasks/Projects and meet deadlines with a high degree of customer satisfaction. Good at communication, analytical, verbal, writing and presentation skills. Experience in working in Global onshore-offshore model. Excellent team player, self-motivated and quick learner.
• Ability to interact with End users, Managers and Technical personnel.
• Having sound analytical, problem solving and debugging skills.
• Ability to work well in a team and work independently.

TECHNICAL SKILLS:

SAP Software Products: SAP HANA Studio.

SAP HANA Data Provisioning: SLT, SAP Data Services (BODS), Flat file Uploader.

Reporting Tools: Analysis for Office, Tableau and SAP Analytical Cloud.

Information Design Tool: SAP BI, SAP Business Objective, and WEBi.

ETL Tool: BODS (Business Objective Data Services)

Languages: COBOL, JCL, Easytrieve, SQL, ABAP and SAS.

Database & File systems: SAP HANA Database, DB2, IMS DB, VSAM.

Testing and Debugging: XPEDITOR (online/Batch), SELCOPY, File Aid, MQ SeriesTools Spufi, Platinum, Service Now, Clarify, Remedy, Jira and HPALM.

Hadoop ecosystems: HDFS, MapReduce, Pig, Hive, Sqoop, Spark, Flume, Impala

Configuration Management: ENDEVOR, Change Man

Tools: Job Scheduling and others CA7, OPC

OLTP: CICS

Operating System: MS-Dos, MVS, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Camden, NJ

SAP Native HANA Consultant

Environment: SAP HANA 2.0, SAP ECC, CHARM, Apache Nifi

Responsibilities:

• Analyzing user stories and converting them into the design and implementation plans through rigorous working sessions with the functional team.
• Implemented advanced native HANA models to build simple to complex reports based on business requirement, delivered them on time.
• Involved in solution design for OTC module in areas of P2P module for third party, subcontracting process, Stock transfer and shipment PO
• Creating native HANA models with advanced functionality such as calculated measures, table functions, input parameters, filters, variables, rank.
• Resolved high priority defects to make sure accurate data is available for users and performing root cause analysis to avoid them in future.
• Managed modelling content in SAP HANA such as Import and Export of packages, Mass Copy, Schema Mapping and Delivery Units, etc.
• Transported HANA models from one environment to another by using CHARM.
• Performed unit testing to verify whether the resulting data matches with stipulated performance benchmarks.
• Worked for solution designs for various outputs involved in OTC via email, EDI or Forms
• Ensured security by creating Analytic Privileges and setting up data level authorization.
• Worked on Hybrid Agile Mythology which is mixture of Agile and Waterfall.

Confidential, Boise

SAP Native HANA Consultant

Environment: SAP HANA 2.0, SAP ECC, SLT, CHARM and Tableau.

Responsibilities:

• Business know-how, especially in the areas Item Cash Flow, Cost Saving, Budget, Portfolio and Project Management, Procurement.
• Prepared Technical Specification for Functional Specifications.
• Performed data modeling and developed HANA Information views as per the Business Standards.
• Migrated HANA content from development, QA environment to Production environment using Import /export and delivery units.
• Responsible for supporting and independently completing project tasks on time.
• Supported and enhancement of Tableau application with emphasis on data modelling.

Confidential

SAP Native HANA Consultant

Environment: SAP HANA 2.0, SAP BW, SAP ECC, SLT, SAP BO, WEBi and Analysis for Office.

Responsibilities:

• Involved in requirement gathering to convert existing Account Payable, Invoice verifications, Travel & Expenses, Check Register, Real checks, Purchase Requisition, Service Order Operations and Material Warehouse Management (Material Issues Receipts, Material Plant, Material Quantity) SAP BW models to HANA Information models.
• Created GAP analysis model for Business requirements and Prepared SAP HANA Technical specifications, Technical Design Documents and standard modeling documents for HANA.
• Replicate the necessary tables by using SAP LT Replication Server from ECC to SAP HANA.
• Performed data modeling and developed HANA Information views. Developed complex scripted calculation view using SQL and Table Functions.
• Worked on the Business process in the areas of Pricing, Availability check, Credit Management, OTC, Delivery, Rebates and Billing
• Created advanced modeling using Hierarchies, restricted calculated column, variable, input parameter.
• Migrated HANA content from development, QA environment to Production environment using Import /export and delivery units.
• Understanding the critical BW ABAP logic and implement the same logic in Calculation views.
• Completely took ownership to complete the build, end to end testing and implementation.
• Performed BW loads using process chains, tested the Data load performance, Validated the data between calculation views and ECC/Production reports.
• Developed Webi reports and dashboards for above HANA models.
• Created Universes on top of HANA calculation views & developed the Webi reports and dashboards using IDT Information design tool.

Confidential

SAP Native HANA Consultant

Environment: SAP HANA 2.0, SAP WEBi and SLT.

Responsibilities:

• Prepared Technical Designs by using Functional specifications provided by Functional Team.
• Replicated the necessary tables thru SLT and built HANA information views (Graphical and Scripted Calculation Views).
• Built XSJS/OData API with selection parameter and these API’s are connected to CPI using cloud connector. It will help to PULL from the source application to Data Scrub.
• Created WEBi reports on top of HANA Views which will help the user to load full data into the Data Scrub system for their system testing.
• Completely involved in all the testing phases like Unit Testing, Integration, Regression and UAT testing.

Confidential

SAP Native HANA Consultant

Environment: SAP HANA 2.0, SAP Analytical Cloud.

Responsibilities:

• Created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom.
• Created Dashboards and SAC stories on SAP HANA information Views.
• Implemented stories using different features of SAC.
• Implemented complex calculations in SAC stories like Year to Date Calculations, Currency conversion and Currency Variance Calculations.

Confidential

SAP Native HANA Consultant

Environment: SAP HANA, SAP ECC, SLT, BODS

Responsibilities:

• Worked on all Information Views (Attribute Views, Analytical views and Calculated views) and Tables in each Schema level.
• Worked on all functionalities like Formulas and Functions, SQL Procedures, Input Parameters, Filters and Variables, Measures, Semantic Modeling, Flow Graph, Currency Conversion.
• Worked in all system statistics and performance by using PlanViz.
• Tested all replication scenarios (Load, Replicate, Stop, Suspend and Resume) for verifying performance of table replications by loading data from ECC to SAP HANA systems.
• Worked in SLT DMIS upgrade testing like verifying Performance of Table replication, ABAP routines, Filters, and Load Statistics.
• Supported BODS team to verifying performance improvement in information views.
• Good Experience in Integrating SAP HANA with BOBJ reporting tool.
• Worked in Pre-upgrade & Post-upgrade Testing and Statistics collections and ensure all critical interfaces and reports are working as expected for Development, Quality and Production systems.

Confidential

SAP Native HANA Consultant

Environment: SAP HANA, SAP ECC, SLT, SAP BO, WEBi and Analysis for Office.

Responsibilities:

• Created Attribute View, Analytical view and Calculated view.
• Worked on creation of SQL, SQL Scripts, Stored Procedures and SQL Script debugging.
• Good Experience in developing restricted and calculated measures, creating hierarchies, variables and filters.
• Imported data through flat files into SAP HANA and created schema and required tables
• Build Data load/Data provisioning using SLT and SAP Data services (BODS) Methods.
• Good Knowledge in Integrating SAP HANA with Analysis for Office and BOBJ reporting tools.
• Involved in Pre-migration and Post-migration house-keeping activities for Development, Quality and Production systems

Confidential

Senior System Developer

Environment: SQL, SAP Business Objects, WEBi and IDT.

Responsibilities:

• Performed Data Modeling and Developed Attribute View, Analytical view, Calculated view and worked on complex logics by using SQL scripted views.
• Worked on creating SQL Stored Procedures, Functions and SQL Scripts.
• Good experience in building and debugging the SQL procedure.
• Designed and developed BO reports/universes accessing DB2 UDB databases.
• Analyzed existing Universe and Database to enhance the existing Universe and created new Universe as per business requirement.
• Designed and developed standard reports and summary reports.
• Created WEBI reports using SAP Business Objects functionality's like queries, slice and dice, drill down, cross tab, master detail and formulae's etc, according to the requirements.
• Tested the SAP BO reports and its functionalities based on the business requirement.

Confidential

Senior System Developer

Environment: COBOL, JCL, VSAM, SAS, Easytrieve, Endevor, Expeditor, File-Aid, Platinumand CA7

Responsibilities:

• Attended requirement gathering sessions with the customers and assisted them in preparing the requirement documents for APS application.
• Prepared High-level design documents, Estimates and System flow diagrams.
• Given walkthrough to the customers on the High-level design documents.
• Guided the team in preparing the Low level design documents, Coding and Testing.
• Reviewed System test plans and System test results with the customers.
• Provided support during System testing and UAT. Assisted team in fixing UAT defects.
• Interacted with the customers related to various production support issues, which include Sev 1, Sev 2 and Sev 3 tickets.
• Provided Production Support for the production batch abends.
• Lead offshore team by providing guidance and support.
• Assisted the team in technical issue resolution and provided clarifications.
• Gave transition to the new offshore team members.
• Tracked the progress of offshore team deliverables, including projects, fast tracks, trackers, tickets, etc. by interacting with the offshore Group Lead and team on a periodic basis.
• Taken the ownership of offshore quality and timely deliverables.
• Participated in the discussions with the customers on Implementation activities.
• Reviewed offshore team deliverables to have zero defect deliverables.
• Worked on coding, testing and implementation.
• Kept the Application Information Document (AID) and other application related training materials up-to-date.

Confidential

Senior System Engineer

Environment: COBOL, ASSEMBLER, JCL, VSAM, DB2, Expeditor, File Manager, PDM and SCAM

Responsibilities:

• Analyzing the Code for changes.
• Completely involved in enhancements and new program coding as per the Confidential standards.
• Involved in coding and testing of online and batch jobs and providing support to testing team.
• Involved in Unit and Integration Testing, Test Plan preparation and execution.
• Provided support during acceptance testing & deployment.
• Involved in 1-timer requests to fix the Claim information with in turnaround time.
• Ensured that the delivery meets Time-lines and Quality Standards.
• Involved in other system areas like ITS, Mid-tier and testing team.
• Involved in generating weekly reports to notify the team on their work requests.
• Provided technical support and participate in review of deliverables.
• Ensured that the work products are of high quality and delivered in time.

Confidential

Senior System Engineer

Environment: COBOL, JCL, DB2, OPC, Expeditor, Fail-Aid and Remedy

Responsibilities:

• Analysis of the business requirement as per the functional specifications.
• Preparing the High-level design of the requirements.
• Modifying the CICS-COBOL-DB2 Applications as per the design.
• Preparing the unit test plan matrix, and execution of test cases
• Handling staging of application to ST/UAT regions and providing the ST/UAT support for Users to test the modules modified as part the project.
• Training the Testing team and end user team on the new enhancement.

Confidential

Module lead

Environment: COBOL, JCL, DB2, PLATINUM, OPC, Expeditor, Fail-Aid and Remedyr

Responsibilities:

• Monitored all the Daily checks and updated the status to the PM & higher levels on time.
• Incident/SR/CR/PR management. Scheduling, Monitoring and Managing team and their work load.
• Monitor, track and analyze the chase calls related to low CSAT/DSATcases for further Improvement.
• Provided quick resolution for escalated issues by coordinating between onsite and offshore teams.
• Involved in Reviews and Ticket Audits. Conducted weekly meetings with the team for improving the performance of the team members by discussing about the issues and Adhoc activities.
• Involved in regular calendar activities.
• Involved in Minor enhancement and developments.
• Contribution to estimates & work packs preparation by demonstrating quality in work packs and well-articulated / justified estimates.
• Preparation of FMEAs and Project documentation.
• TOP3 analysis for incidents and requests on monthly basis.
• Ensured Proactive fixes/Incident reduction. Suggestion and implementation to the defects/Incidents - 2 per month.
• Supported PM on providing feedback on the resources during performance appraisals.
• Ability to engage the team during crisis situations, taking charge of technical issues and guiding the team towards resolutions..
• Groomed team members in all aspects relevant to the project (Technical, Communication etiquette, Process, etc.,).
• Mentored team members by conducting technical and functional sessions.
• Maintained co-ordination between onsite and offshore teams.

Confidential

Senior Software Engineer

Environment: COBOL, JCL, DB2 and MQ Series.

Responsibilities:

• Provided the data to uploading to SAP system.
• Involved in code changes and Migration process.
• Unit, integration and regression testing done and provided support for UAT and Warrantee Support.
• Provided post-implementation warranty support.
• Resolving customer issues related to Consents and samples strictly within the SLA time.

Confidential

Software engineer

Environment: COBOL, JCL, DB2, PLATINUM, OPC, Expeditor, Fail Aid, Clarify and Remedy.

Responsibilities:

• Worked in production support and maintenance, handling batch failures and User cases.
• Involved in Health checks, take the ownership clarify monitoring and assigning cases to team members and helping team members resolving cases to meet SLA norms and objectives.
• Proactively took the owner ship and gained in-depth knowledge on the Modules related to Billing, Metering, Service Order and supporting it to till date.
• Involved in giving enhancements and permanent fixes for the frequently occurring problems to improve the performance of the system.
• Involved in DC Migration testing with all interfaces testing.
• Involved in Coding and Testing including UAT, test case preparation and maintain the quality of deliverables as per laid down process.
• Involved Adhoc activities and all month end activities.
• Involved in knowledge transfer and groom up new joiners.
• Understood the complete architecture of the system.