SUMMARY

• 12+ years of experience with emphasis on SAP as SAP Technical Consultant with core strength in all aspects of development expertise in BW/HANA/ABAP/BOBJ during implementation/ Upgrades and Support.
• Strong demonstrated and wide project development experience in BW on HANA with robust Data warehousing and BW modelling concepts and Analytics project experience.
• Working with Cloud Platform technologies like Impala and processing data from SAP as part of Enterprise Data Analytics project.
• Agile methodology: I am an Avid programmer meeting quick timelines in Agile project environments and very well capable of setting the business expectations in retrospective meetings.
• Built various complex HANA Attribute, Analytical and Calculation views which are being heavily used for reporting by business teams via Tableau and Google Analytics (GCP).
• Expert knowledge and hands on experience in building Graphical and SQL HANA views to suite the business needs.
• Well experienced with HANA modelling, schema functions, good understanding of HANA procedures and CE functions
• Developed solutions in HANA with various scenarios including multiple parameters, variables, binding parameters/variables from top to bottom and vice versa.
• Comprehensive development experience in designing and building Design Studio dashboards with noble CSS scripting to make it more user friendly and visually appealing dashboard developments.
• Highly proficient developing complete BW modelling front end and back end.
• Well experienced in building Business Objects Web Intelligence reports (WEBI)
• Extensively worked in designing and configuring back - end components including Advanced DSO, Hana Composite-Provider, Infoobejcts, Open ODS views, Data-sources (Generic Data-source by function module and table/views), Transformations, Data Transfer Process (DTP), Hierarchies, Info packages, Infocubes, DSO’s (Standard, Write Optimized, Direct update), Multi-providers and Process Chains.
• Highly skilled in creating process chains and scheduling them with various dependency consideration; I have created ample of them in production environment after every change implementation and helped offshore support team in data load monitoring and resolving load issues if any.
• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, variables, formula variables and text variables.
• Participated in enormous project change requirement deployment calls and implemented the changes successfully.
• Expert in Transformation routines (Start routine, End routine, field level routine)
• Proficient in ETL activities like Data Extraction (Standard SAP extractor/Generic extractor/SLT) and Loading (Full/Delta upload) and proficient in data extraction from SAP R/3 SD, MM, PP, PM, FI-CO and COPA.
• Experience in creating custom extractors and Generic Extractors and extensively involved in enhancing of the Data Sources, writing CMOD logics, setting up V3 jobs etc.
• Well versed with Data Modelling by LSA and LSA++.
• Improved data load and query performance by using Semantically Partitioned Objects (SPO), Hana optimized objects, Aggregates, Compression, Partitioning, Indexes and optimizing Data packet size.
• High skilled ABAP programming, created many ABAP program0020ms for scheduled maintenance, custom calendar-based table generation with exception handling, RFC function modules to transfer data from BW to F&R system etc, created many ABAP programs for other team members during the years in Confidential .
• Evaluated statistical performance using BW Statistics for optimization.
• Worked on FLP tile testing from Fiori Launchpad to view the reports via portal.
• Experience in Analysis, Design, Development and Implementation of Business Intelligence tools such as SAP BO 4.0/BI 4.1/BI 4.2, Universe Designer, Web Intelligence Reporting, information design tool, SAP Design studio, Xcelsius dashboard and basic Crystal Reports.
• Experience in interacting with business users to analyse the business process and requirements and transforming requirements into logical objects, mapping to technical objects and rolling out the deliverable.

TECHNICAL SKILLS

SAP Technology: SAP Business warehouse (BW/BI), BOBJ, HANA, ABAP Workbench, Data . Dictionary, Workflow, Reports, Interfaces, Conversions, Exits, BAPI, BAdIsEDI/ALE, RFC and Idocs, OSS notes, SAP NetWeaver, Workflow, FIORI

Programming Language: SAP ABAP

Business warehouse: BW/BI (7.5, 7.3,7.0, 3.5)

Interface: SAP Webservices, EDI/IDOCs, Enhancements.

Tools: Bex Suite, Visual Composer, Crystal Reports, Design studio, HANA Studio etc.

Database: HANA, Oracle 10g/9i/8i, DB2.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

SAP BW/HANA Software Developer

Responsibilities:

• Involving in requirement gathering coordinating directly with business Consultant, analysing, and documenting business requirements, functional requirements and preparing the Technical Development Specifications for SAP BW database and reporting objects Requirement gathering.
• Successfully completed BW 3x to 7.5 migration
• Providing development effort estimation for the requirements.
• Developing HANA CDS Views as per the business requirements.
• Working on BW Upgrade project i.e. migrating SAP BW 7.3 to 7.5
• Coordinating with Cloud Platform team and help enabling file transfers from SAP BW system
• Validating Data in Platform with Impala query engine and comparing with SAP BW system.
• Coordinating with PO team and making sure file transfer happens successfully without any discrepancies.
• Updating HP ALM, PET stories and maintaining the status on daily basis in respective tasks. coordinating with multiple teams and getting the approvals in CAB meetings for monthly production implementations. prioritizing the tasks and working on the development objects. submitting the artefacts of the development and user acceptance testing (UAT documents, checklists etc). solving the ServiceNow Incident tickets received from business as per support process
• Resolving the batch issues and meeting the SLA’s and updating the business counterpart on status
• Developing SAP BW backend objects and reports for various project initiatives like SAP CRM Hybris, ACPP etc
• Building Business Objects dashboards as per the requirement
• Participating in planned upgrade initiatives for current SAP environment and analysing the impacted objects.

Confidential, Atlanta

SAP BI/BW/HANA Software Developer

Responsibilities:

• Participating in SAP workshops during project kick-off, Upgrade initiations etc in effectively strategizing the roadmap.
• Solely handling of validations during HANA replacement and HANA 2.0 upgrade (in progress) and providing weekly updates to project management team.
• Collaborating with SAP TQM in prioritizing and escalating OSS message as required.
• Involved in gathering, analysing, and documenting business requirements, functional requirements and preparing the Technical Development Specifications for SAP BW database and reporting objects Requirement gathering.
• Involved in requirement gathering coordinating directly with business Consultant.
• Providing development effort estimation for the requirement and effectively assigning points for each task in Agile meetings
• Updating Jira stories and maintaining the status on daily basis in confluence pages
• Worked on complete SDLC (Software Development Life Cycle).
• Have been working on creating design approach of various BW and HANA specific objects.
• Used to develop Technical specifications for objects from functional specifications
• Extensively developed new objects starting from data sources (LO and CRM), Infoobejcts, Infoproviders (Infocubes, DSO’s and MP’s) related to PO, SD (COM), MM, FI, CRM etc.
• Designed and developed complete data flows including LO and generic data sources, extraction process, V3 jobs, BW modelling objects (Infopackages, Data warehousing, Application layer and Reporting layer DSO’s, Infocubes and worked on PSA and changelog maintenance, Analysis Process Designer (APD), Process chains, ABAP programs, custom tables etc.
• Expert in in building reports using Web Application Designer (WAD), Web Templates and Information Broadcasting, and BOBJ-WEBI reports, Universe creation, BOBJ Publication configuration and setup, broadcast setup etc.
• Basic knowledge in BOBJ CMC tool and authorizations.
• Created Business objects WEBI reports using HANA calculation views as source.
• Basic knowledge in Lumira designer
• Various ABAP routine transformation logics written with considering the better performance approaches and proven results.
• Worked on various Design studio dashboards as part of migration of traditional BEx reporting via portal.
• Worked on HANA migration project and converted many BW objects into HANA models.
• As part of Analytics project, developed many HANA views using graphical and scripting.
• Experienced with SAP HANA data modelling, schema management, content import & export, data provisioning technology including SLT, Delivery units, SQL trace analysis and Calculation views performance with PlanViz.
• Design and development of HANA attribute, analytic and calculation view to meet reporting requirements of COM and POS consolidated sales by material and sales by customer
• Developed many Analytical and Calculated HANA views on top of CRM models to get Business partner, marketing attribute info and ProXtra, Pro Referral data etc.
• Transported various HANA views to higher landscapes via import/export and Delivery Units.
• Worked on NLS project where we archived numerous DSO/Cubes, contributing $ savings by 1TB (~25% overall memory) space reduction.
• Worked on SAP BI 7.4 upgrade project during which I had solely completed with end-to-end testing of all objects, CMOD logic testing, LISTCUBE comparisons, extractor logic synchronization etc.; resolved many errors in timely manner, completed the project roll out successfully.
• Worked on Cut-over activities and data validations part of post Go-live support.
• Worked on portal de-federation project and concluded the roll out successfully.
• Designed and developed SAP Business Objects WEBI reports, Xcelsius and Design Studio dashboards which will be reporting key metrics to the corporate IT team.
• In short span of time, developed more than 500+ BEx (business explorer) reports to meet the project requirements
• Worked on FLP tile testing from Fiori Launchpad to view the reports via portal.
• Worked with Mu-Sigma team to effectively generate the BI data into R system.
• Collaborated directly with SAP team in developing IDR (Inventory Diagnostic Reporting) project.
• Key member in attending the Agile retrospective and daily stand-up meetings from project team
• Actively trained the newly inducted members of the team and provided smooth transition
• Played crucial role in maintaining good relationships with client.
• Being SPOC between onsite and offshore to effectively communicate and engage the resource to meet the support requirements.
• First level of escalation point of contact from Onsite for support team to resolve any issues in the production system as part of daily data loads.
• Been an active member in TCS Technical interview process

Confidential

SAP Consultant

Responsibilities:

• Understanding the basic functionality of working with IS-Utilities
• Analysing and Reviewing the Functional specification and understand the requirement
• Design of Technical specification and Unit test document for the development.
• Responsible for peer review of Technical specification document prepared by other team members.
• Coordinating with onsite team daily to meet the deliverables.
• Scheduling the status call with other technical consultants located at various locations.
• Coordinating with team in setting up the initial project planning.
• Worked in a team well directed to achieve the common goals by delivering the objects within the specified time.
• Built various ABAP programs to transfer data to XI system.
• Developed many smart forms to support the billing related PDF generations.
• Written many ABAP reports to generate ALV List/Grid layout format-based outputs.
• Custom function modules are built to effectively handle data formatting and reduce the duplication of code.
• Implemented many SAP OSS notes based on the requirements.
• Created and configured SAP Workflows and configured SAP Inbox messaging system after the initial go-live of project

Confidential, Pennsylvania

SAP Consultant

Responsibilities:

• My responsibilities include requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• BI Design - Info Cubes design, Data Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Transformations, Info Packages using AWB. Proficient in Data modelling using MDM and BW extended star schema models.
• Delivering the Development objects as per the requirement.
• Involved mainly on Support process which involves ticket resolutions along with the developments
• OSS Note Implementation according to the requirement.
• Tax ware Implementation process (monthly and semi-monthly) across all the systems.
• Resolving the job-related Issues directly in production environment.
• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation.
• Documented functional and technical specifications for production support and project enhancements.
• Assisted in ongoing communication with BW end-users on business process and systems changes, and issues resolutions.

Confidential, Cedar Rapids

SAP Consultant

Responsibilities:

• Handling the Priority tickets, enhancements and Projects.
• Monitoring and scheduling of Jobs in BI Production systems.
• Resolving tickets raised part of production support.
• Developing the objects based on task given.
• Remedy ticket monitoring.
• Maintaining Transport Request sequence, production support and fixing issues.

Confidential

SAP Consultant

Responsibilities:

• Involved in all phases of Software Development Life Cycle. Gathering, analysing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• To discuss with the End User, Client, Functional Folks to get the requirement.
• Develop the code and technical specs matching the business requirements.
• Code review as the Functional & technical specification.
• Responsible for peer review of Technical specification document prepared by other team members.
• Test the deliverable as per project guidelines.
• Coordinating with client on status and object deliverable.

Confidential

SAP Consultant

Responsibilities:

• Involved in all phases of Software Development Life Cycle. Gathering, analysing, documenting business requirements, functional requirements, and data specifications.
• To discuss with the End User, Client, Functional Folks to get the requirement.
• Analysing and Reviewing the Functional specification and providing work estimation based on the Functional specification
• Develop the code and technical specs matching the business requirements.
• Code review of the technical specification prepared by the peers.
• Test the deliverable as per project guidelines.
• Coordinating with client on status and object deliverable.
• Design of Unit test document for the development completed
• Successful deployment and transport of objects