SUMMARY:

• Sybase IQ DB Certified professional with nearly 11 years of experience out of which recent nearly 7 years in SAP Implementation (BW/ BI) and 3 years in SAP HANA, Implementation, Performance tuning, Production Support and Team Management
• Holds the credit of gaining global experience by travelling to London as a Technical Lead in Interface Development Team at clients location
• Insightful experience in project management activities including project scoping, estimation, planning, finalization of technical / functional specifications, resource administration and quality management.
• Gained hands - on experience in delivery management functions viz. contract management, proposal development, program / delivery level planning, budgeting, revenue recognition, onshore / offshore ratio and margin management.
• Adept in handling report, data warehouse and model development; experience in migration of business objects using administration and maintenance of objects.
• An effective leader with proven abilities in leading teams during the project phase, & guiding team members and enabling knowledge sharing among the team.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs
• Expertise in Data Warehousing concept and having deep technical background
• Extensively worked in SAP HANA DB, SAP HANA Studio, SAP LT & SAP BODS
• Design and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed solution with DXC for SAP HANA reporting
• Very extensively worked in HANA Studio Modeling
• Extensively worked at SAP Net weaver 7.0 BI, 7.3 7.4
• Very extensively worked in Composite Provider
• Very extensively worked in Transient Provider
• Very extensively worked in Cube Partition and repartition with good knowledge about ABAP
• Extensively worked in modeling, extraction with initial and delta loads from R/3 systems.
• Using ASAP methodology conducted all tasks for Business Blueprint and Realization phases of project
• Experience in scheduling, monitoring data loads and data extraction from SAP R/3 (Generic data extraction).
• Hands on Experience on SQL Scripting for creating Tables, Views, procedures, and for several data modification/ Alterations
• Worked on Stored procedures to create Calculation views.

WORK EXPERIENCE:

Confidential

Team Lead

Responsibilities:

• Customer interactions to understanding the issue across various OpCos and regional HQ.
• Updating management about progress of month end activity every month
• Resolved complex/ critical incidents and simulated technical scenarios
• Worked on local reports and GMRs including dash boards
• High visibility of HEABS of database and BW architecture
• Perform the performance tuning of BW on HANA system
• Design and implemented BW ON HANA, in memory Cubes, Advance DSO and process Chain
• Design Composite Provider with HANA optimized cube and DSO
• Design and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views using CE Functions.
• Developed HANA DB procedures
• Called HANA DB procedure from BW Process Chain
• Created calculated and restricted column using calculation view.
• Code push down techniques by modeling in HANA studio.
• Responsible for the integrated planning, design, implementation and support of SAP HANA based solutions including SAP LT Replication Server.
• Reporting of Analytical and Calculation views from MS Excel.
• Created Universes on top of HANA calculation views and developed the WebI reports and dashboards using IDT (Information design tool).
• Design and Creation of Functional Specification and Technical specification for next phase.
• Identifying use-cases for HANA and building them in HANA as part of LSS (Lab for SAP Solutions).
• Onsite experience at Bangkok and Manila

Confidential

Consultant

Responsibilities:

• Actively participated in BW implementation lifecycle from requirements gathering, solution design, architecture, readiness assessment, customization, and rollout. Creating BEx reports and design the cubes
• Customer interactions to gathering Functional specs.
• Converting functional specs into technical designs.
• Development of DSO, Info Object, Info Cube, MultiProvider, transformation, DTP etc.
• Implementation and task allocation within team.
• Testing and Post Go Live support till Roll out
• Design and implemented BW ON HANA, in memory Cubes, Advance DSO and process Chain
• Design Composite Provider with HANA optimized cube and DSO
• Design and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views using CE Functions.

Confidential

Consultant Specialist

Responsibilities:

• Actively participated in BW implementation lifecycle from requirements gathering, solution design, architecture, readiness assessment, customization, and rollout. Creating BEx reports and design the cubes
• Handled the gamut of activities encompassing:
• Customer interactions to gathering Functional specs.
• Converting functional specs into technical designs.
• Development of DSO, InfoObject, InfoCube, MultiProvider, transformation, DTP etc.
• Implementation and task allocation within team.
• Testing and Post Go Live support till Roll out.
• Created Attribute, Analytical views
• Done modeling in SAP HANA studio
• Closely monitored the track of different BI activities to meet the SLA as well as in Trouble shooting of daily data loads.
• Done Partitioning and repartitions of the cube
• Handling resource allocations and setting up of communication channels across the various horizons of the organization structure as well as ensuring delivery of projects from conceptualization to delivery within pre-set budgets and deadlines
• Gathering the requirement from the client

Confidential

Consultant Specialist

Responsibilities:

• Led the team for BI support & development activities.
• Closely monitored the track of different BI activities to meet the SLA while engaged in daily data loads.
• Completed partitioning and repartitions of the cube and conducted trouble shooting of daily data loads.
• Developed Sales Register, Profit Center wise Asset Report, Purchase Journal for Materials etc.
• Created process chains & scheduled according to requirement.
• Performance Tuning: Maintaining Aggregates, Indexing etc.
• Converting business strategies into structured projects with deliverables identified
• Managing the entire aspects of process execution & designing and implementing project plans within preset budgets and deadlines
• Handling resource allocations and setting up of communication channels across the various horizons of the organization structure as well as ensuring delivery of projects from conceptualization to delivery within preset budgets and deadlines
• Holding review meetings to monitor progress of the project as per schedule / budgets
• Managing SAP implementation and functioning entailing:
• Mapping business requirements (As-Is & To-Be Analysis) and business process
• Preparing scope of implementation and GAP analysis
• Developing all relevant reports per user requirements including maintenance notifications, activity and malfunction reports

Confidential

Software Engineer

Responsibilities:

• Involved in designing complete customizable new interfaces for ElectraCard
• Instrumental in designing card module using FORMS9I. The purpose of this module was to provide web interface to client on the Internet.
• Accountable for designing forms for VISA module.
• Conferred with the Star for rendering outstanding contribution
• Undertook cost saving initiatives and saved approximately $ 1.5 Million by implementing HANA Holcim Project
• Dexterously conducted MOM and knowledge session for the team to enhance the skills of the team
• Distinctively implemented:
• Sybase IQ from Oracle Database and migrated the huge amount of data to Sybase IQ