E-Mail : adb8o9@r.postjobfree.com

Mahesh K Mob.no: +1-315-***-****

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 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. 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 knowledge & 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.

Have exposure to SAP HANA Modeling on SAP ERP modules like Finance, Supply Chain, Sales & Distribution, Material Management and Purchasing.

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.

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.

Academic Qualifications:

Master’s Degree in Business Administration from Andhra University (2000-2002).

Bachelor’s Degree in Science from Andhra University (1996-2000).

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 and Tableau.

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 Series,

Tools : Spufi, Platinum, Service Now, Clarify, Remedy, Jira and HPALM.

Configuration Management : ENDEVOR, Change Man

Tools

Job Scheduling and others : CA7, OPC

OLTP : CICS

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

Work Experience:

Working as a Lead Consultant in Wipro Technologies from May 2018.

Worked as Senior Consultant in Wipro Technologies through Focus IT, Bangalore effective from Aug 2017 to Apr 2018.

Worked as a Module lead in IBM India Pvt. Ltd., Bangalore effective from Aug 2011 to Apr 2017.

Worked as a Team leader in Wipro Technologies, Bangalore effective from Oct 2005 to Aug 2011.

Achievements:

Achieved 4 FIMC awards for reducing incident count and doing bulk data repairs.

Contributed to DG8 for achieving 99.79% against a target of 99.73%.

Successfully completed Pre-billing and Annual billing for the year 2009 & 2010. Received award for the same.

Was a key contributor for successfully implementing CIS - Sample manager interface project. Received ‘Thanks a Zillion’ award for the same.

Got an award ‘Outstanding Contribution’ for successfully completion of SAP HANA upgradation project.

Got an award for successful completion of SAP HANA Migration of SCM Phase 1 & 2.

Certifications:

IBM Certified Database Associate -- DB2 Universal Database V8.1 Family(730) and

DB2 9 DBA for zOS (732)

Project # 1 Jan 2018 – Till Date.

Client : National Grid (NG), USA

Project Name : Conversion BW SCM reports to HANA Reports.

Designation : SAP HANA Consultant

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

Description: National Grid is one of the world's largest international electricity and Gas Company and one of the largest investor-owned energy companies in the world. This company plays a vital role in providing energy to millions of customers across Great Britain and the Northeast US in an efficient, reliable and safe manner. Wipro has implemented SAP for the client in November 2012. Wipro is currently involved in enhancing the solution implemented and providing Application Maintenance & Support.

Roles and 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.

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.

Client : National Grid (NG), USA

Project Name : Data Scrub Allocation Code Extract

Designation : SAP HANA Consultant

Environment : SAP HANA, SAP WEBi and SLT.

Description: The Data Scrub application is used for rate case analysis on expenses data entered through Concur application. We built a HANA view/model with XSJS/OData API on Internal Order and Settlement rule tables to support the Data Scrub application on SAP Leonardo Cloud Platform. The solution will leverage the data from the existing HANA tables to build HANA Views, which is extracted to Data Scrub application through Cloud Platform Integration (CPI).

Roles and 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.

Project # 2 Aug 2017 – Dec 2017

Client : Johnson & Johnson (JNJ), USA

Project Name : BtB (Back to Basics)-HANA Up-gradation

Designation : SAP HANA Consultant

Environment : SAP HANA, SAP ECC, SLT, BODS

Description: Johnson & Johnson is an American multinational medical devices, pharmaceutical and consumer packaged goods manufacturing company founded in 1886. Its common stock is a component of the Dow Jones Industrial Average and the company is listed among the Fortune 500.

Johnson & Johnson is headquartered in New Brunswick, New Jersey, the consumer division being located in Skillman, New Jersey. The corporation includes some 250 subsidiary companies with operations in 60 countries and products sold in over 175 countries. Johnson & Johnson had worldwide sales of $70.1 billion during calendar year 2015.

Johnson & Johnson's brands include numerous household names of medications and first aid supplies. Among its well-known consumer products are the Band-Aid Brand line of bandages, Tylenol medications, Johnson's baby products, Neutrogena skin and beauty products, Clean & Clear facial wash and Acuvue contact lenses.

Roles and 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 SAPA 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.

Project # 3 May 2016 – Apr 2017

Client : Ericsson, Stockholm

Project Name : ONE system

Designation : SAP HANA Consultant

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

Description: As a leading provider of ICT (Information and Communication Technology) equipment and services to network operators and adjacent industries all around the world, Ericsson is one of the few companies to offer end-to-end solutions for all major mobile communications standards. With more than 110,000 employees serving customers in more than 180 countries, Ericsson is using innovation to empower people, business and society as they work towards the Networked Society.

Roles and 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

Project # 4 Dec 2013– May 2016

Client : Lincoln Financial Group, USA

Project Name : APS (Annuity processing System) & HFR (HR, Finance and Reporting)

Designation : Senior System Developer

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

Description:

Lincoln Financial Group, a Fortune 250 company with over 10,000 employees, provides advice and solutions that help empower Americans to take charge of their financial lives with confidence. Their core business areas include — Life Insurance, Annuities, Retirement Plan Services and Group Protection. They focus on supporting, preserving and enhancing over 17 million customer’s lifestyles and retirement outcomes.

Roles and Responsibilities:

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.

Client : Lincoln Financial Group, USA

Project Name : APS (Annuity processing System) & HFR (HR, Finance and Reporting)

Designation : Senior System Developer

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

and CA7

Description:

Lincoln Financial Group is a Fortune 250 company offering a diverse range of financial services and solutions. With a strong focus on four core business areas - life insurance, annuities, retirement plan services, and group protection – their business is built around supporting, preserving, and enhancing our customer's lifestyles and providing better retirement outcomes. Led by over 8,000 employees, Lincoln Financial provides the tools and advice to help individuals take charge of their futures.

It is one of the premier insurance companies in USA. The scope of this project includes Application Management Services for the in scope applications. With team effort as our driver, and innovation as our focus, our team is committed to provide the excellence in delivery and value adds to the customer and graduate up the value chain.

Providing support to the customer for the applications developed in Mainframes. The purpose of the Project Application team is to enhance/maintain the business requirement of Lincoln Financial Group applications using IBM methodologies like AMS (application Management Services), On Demand Process Asset Library (OPAL) and SDF (Services Delivery Framework) and providing complete PRODUCTION SUPPORT for APS and HFR applications.

Roles and 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.

Project # 5 May 2012 – Nov 2013

Client : NASCO, US.

Project Name : Back-end Support and Maintenance

Designation : Senior System Engineer

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

SCAM

Description:

M/S National Account Service Company stands out as an organization that drives innovation in the health insurance industry to successfully process and compete with the commercial carriers for national and local accounts. It mainly processes health care claims and many Blue Cross Blue shield (BCBS) plans use NASCO to process more than 90 million claims annually.

The National Account Service Company (NASCO) is a company that provides single system access to a network of BCBS Plans for processing health care transactions for both single and multi-state employers. In other words, NASCO helps BCBS Plans manage health care benefits for their customer through one shared system to which the Plans are linked.

NASCO is a very vast system and has a robust architecture. To bring down the complexity the NPS system is broken into different applications. The sub systems constituting the NASCO processing System are Online, HIPPA (The Health Insurance Portability and Accountability Act), Membership, Front End, Payment Resolution, FEP (Federal Employee Program), Finance, Backend, ITS, BA, EBUS, DOCO, Midrange.

Backend team is mainly responsible for History maintenance and Control and reporting System. The Control and Reporting subsystem provides the customer with information used to manage their Claims inventory.

Roles and Responsibilities:

Analyzing the Code for changes.

Completely involved in enhancements and new program coding as per the NASCO 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.

Project # 6 Aug 2011 – May 2012

Client : ESI(Express Scripts ltd., USA).

Project Name : ESI Claims POS

Designation : Senior System Engineer

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

Description:

Express Scripts is one of the largest pharmacy benefit managers (PBM’s) in the US and started in 1986 at St. Louis. They Handles millions of prescriptions each year through Home Delivery and Retail Pharmacies in United States and Canada. It’s Membership base of 20 million plus. And largest client is United States DOD’s TRICARE Program and ranked 115 on Fortune 500 companies. The company processes pharmaceutical claims for members at network pharmacies and at their own mail order

pharmacies. They provide services to manage drug plans for government agencies (both as administrator of employee benefits and public assistance programs), corporations, and unions. ESI processes claims for about 500 million prescriptions per year, designs drug plans, and offers such services as disease management programs and consumer drug data analysis.

Express Scripts is the #1 Pharmacy Benefit Management organizations (After Merger with Medco) conducting business across USA, which deals with use of prescription drugs safer and more affordable to consumers through employers, government, union and health plans.

Roles and 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.

Project # 7 Apr 2010 – Aug 2011

Client : Thames Water Utilities Ltd, UK.

Project Name : CIS Support and Maintenance

Designation : Module lead

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

Description:

Thames water utilities Ltd is UK’S large water and waste-water Service Company with over 4,000 employees providing service round the clock to 13 Million customers across London and south east of England. TWUL provides Water & Waste-Water services to some 70 million customers in 46 countries across the world.Thames Water’s Customer Information System is a large and complex system that was merged with the existing Contact Logging System and Debt Recovery Package (UCS). The main purpose of TW CIS is to bill customers and provides related information to the system’s Swindon-based users.

The Customer Information System (CIS), at Thames Water has been in place since July 1993. CIS consists of over 2000 modules covering online transactions, overnight batch runs, ad-hoc queries and enquiry only services. CIS is running on IBM mainframe under CICS. CIS has an online side and a batch side. The online services cover customer contacts, pending work and any other items that require immediate update of the data tables. The batch services that cover billing, bill print runs, debt recovery, data refreshes, ad-hoc queries, management summaries etc.

Roles and Responsibilities: Managed team and their work load. Co-operated with the team to complete the deliverables within specified deadlines. Provide technical guidance to the team. Was responsible for the deliverables. Ensured SLAs are met. Monitored Batch jobs and resolved abends.

Co-ordinate with users on reported problems and any other user tickets. Prepared design and detailed specs for enhancements and involved in SVC Estimations. Managed issues, escalations with the client.

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.

Project # 8 Aug 2008 – Sept 2009

Client : Thames Water Utilities Ltd, UK.

Project Name : CIS – TERMIS interface Project

Designation : Senior Software Engineer

Environment : COBOL, JCL, DB2 and MQ Series.

Description: Thames Water supplies drinking water to close to 8.3 million customers with the supply network of over 31,000 km of mains, which stretch from Cotswold to South East London. In the Thames Water region, wastewater is collected from homes and businesses and delivered to sewage treatment works. The wastewater is treated to the required consent conditions before being released into rivers. The sewage sludge is recycled to agricultural land or incinerated for energy recovery.

Thames Water issues Trade Effluent Consents to the industries and traders across its network for them to discharge Trade Effluent into the sewer network. Initially CIS is getting data and sending report to AEGIS application. AEGIS application replace with new application SAP. The primary objective of the project is the test data which is coming from new application, modifying existing interface report and sends to new application system as required format. We need to do end to end testing in stages (System, UAT, and Production)

Roles and 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.

Project # 9 Sept 2006 – Mar 2010

Client : Thames Water Utilities Ltd, UK

Project Name : CIS Support and Maintenance

Designation : Software engineer

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

Roles and 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.

Project # 10 Oct 2005 – Aug 2006

Client : NATIONWIDE INSURANCE, USA.

Project Name : PRI and CRI

Designation : Project Engineer

Environment : COBOL, JCL, Change man, CA7, IMS

Description: Nationwide is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments.

Over the last 80 years Nationwide has gone from a small auto insurer for Ohio farmers, to one of the largest insurance and financial services companies in the world with more than $157 billion in statutory assets, Nationwide is one of the largest insurance and financial services companies in the world.

The main purpose of the project is to provide Production Support, Maintenance and Enhancement activities for PRI, CRI, & FIMS. Extract application will comprise of the following tasks;

1.Backlog Defects Cleaning: Production defect fixes, including hotline fixes and related correction activity.

2.Regulatory changes and Enhancements to the system based on business requirements.

3.Application documentation: Continuous updation of the SMTD and EPD.

4.System/Design enhancements: Providing value addition by making improvements to the existing system design/function and performance optimization with prior approval from Nationwide manager.

Roles and Responsibilities:

Have been trained on IMS DB and SmallTalk.

Involved on PRI and CRI Preparing System Maintenance Technical Documentation (SMTDs).

Worked on Various Production defect fixes LC, MC, and HC.

Worked in code changes and enhancements to the existing System.

Involved in Unit testing and Test Plan Preparation.

Contact this candidate