SUMMARY:

An energetic, self - motivated and result oriented IT professional with 11+ years of experience as SAP HANA/BI/BW/ Confidential /XI/PI and in various database technologies as (Database Analyst/Developer/Administrator/Data warehouse/Data Mining Expert). Extensive experience in In-Memory Computing, Business Analytics, Data Migration, Expert in developing and designing Information Models, Expert in Enterprise Reporting, Dashboard Design, Data Modeling, EDW Design, development and support using Business Objects Portfolio. Possess demonstrated skills in end-to-end project implementation by various technology assets across multiple professional disciplines, and easy adaptability to constantly changing technology environments. Great Technical and Management experience.

TECHNOLOGY SKILLS:

SAP In-Memory (HANA): Data Provisioning (Flat Files, Confidential, SLT for SAP & Non-SAP ), Information Models(Attribute View, Analytic View & Calculation View ), SDI/SDA/SDQ

ERP: SAP R/3 4.6, 4.7 & ECC 6.0

SAP BI: BI Platform/BOBJ (IDT, WEBI, Crystal Reports, Xcelsius, Live Office, SAP Integration Kit, Advance analysis), BEx (BEx Query Designer, Web Application DesignerBEx Analyzer, BEx Web Analyzer)

SAP EIM: SAP Data Services, Information Steward, Data Quality, Rapid marts

SAP EDW: SAP NW BI 7.x, SAP BW 3.x.

Languages: C, C++, VC++, C#, JAVA, SQL, PL/SQL, T-SQL, ABAP (IDOC’s, LSMW, RFC, BAPI’s, BADI’sReports, Module Pool)

Databases: HANA 1.0/2.0, Oracle 6.x/7.x/8i/9i,10g, 11g, MS SQL Server 6.5/7.0/2000/2005/2008/2012/2014

Data Mapping: XML, EDI

Operating System: UNIX, LINUX (SLES) and Windows NT/ 2000/2003/2008/2012/2016

Database Tools: Quest Central, Toad, DBArtisan, SQL Navigator, PL/SQL Developer, ERWin, DTStudioHANA Studio

Applications: SAS, SPSS (Clementine), SAP Hybris

CAD/CAM Software: Pro/Engineer, CADDS5, AutoCAD, ADAMS, IDEAS and ANSYS

Hardware Platforms: Intel-based servers, SUN, Silicon Graphics Inc.

Additional Skills: ODP.NET, ACCUREV, TEAM, LUMIRA, Crystal Reports, Dynatrace, Jenkins, GitHubEclipse, AWS, Jenkins, Run Deck

PROFESSIONAL EXPERIENCE:

Confidential, Lake Mary, FL

Sr. SAP HANA Consultant (Data Provisioning/Modeler/Migration)

Responsibilities:

• Worked for SAP through Confidential to do the Implementation/Migration to SAP’s Hybris Clients
• Worked as a Sr. HANA Engineer (Multiple roles: HANA DBA, Data Provisioning and Data Modelling).
• Performed SAP Hybris Migration from Oracle to HANA predominantly using SAP HANA SDI.
• Installed SAP HANA, SAP HANA Data Provisioning (DP) Agent and configured it in Oracle Server in SLES servers in POC environments. Setup local environment by Installing SUSE Linux, SAP HANA on VM and provided access to team members
• Created Schema inside HANA using Hybris Dry Runs and modified the schema using scripts to match with SDI generated Schema. Wrote scripts and extracted data using SDI Oracle Adapters and loaded the data into HANA.
• Found a bug in SAP SDI tool and reported to SAP Product Team. Found workaround using SQL Scripts to handle that issue related to Default Values not being brought by SDI.
• Finished three full migration successfully from Oracle to HANA using SDI.
• Did performance Tuning, monitor performance improvements, create baselines using Dynatrace.
• Created Calculation Views and Stored Procedures to work with the reporting environment after the HANA Migration.
• Configured SLT and used it for Real time data Provisioning.
• Helped the Devops part of the project. Gave solutions to many roadblocks they faced to move the project without delays.
• Helped troubleshoot issues and performance problems on Hybris, DevOps etc.
• Handled Client Calls, SAP Calls, Internal Calls and Project Planning and execution whenever needed.
• Found issues in the SAP suggested process and brought it to their attention to be fixed for all projects.
• Trained new hires with SAP HANA migration related work and helped them documenting the full process.

Environment: SAP HANA 1.0 SP12, SAP Hybris, Oracle, SUSE Linux (SLES), Rundeck, AWS

Confidential,Chicago, IL

Sr. SAP Hana Consultant

Responsibilities:

• Created Technical specifications and standard modeling documents for HANA.
• Involved in business and blueprint gathering discussion.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed complex calculation view using SQL and CE-Function.
• Developed data models for the operations, PP, MM, Quality management tables in HANA.
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
• Developed the security model, Naming conventions and folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports, and dashboards from HANA data sources.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Created Users, Roles, privileges, Packages, schema as part of HANA security and development.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.
• Involved in developing test scripts and assisted UAT on SAP net weaver portal using Test ID's for super users, and end users.
• Integrated BOBJ 4.0 and Confidential 4.0 with SAP HANA1.0.

Environment: Confidential 4.0, BOBJ4.0, HANA 1.0 SP5/SP08, SAP BW 7.3, SAP ECC 6.0, Linux

Confidential, San Antonio, TX

Sr. SAP Hana Consultant

Responsibilities:

• Created universes using Oracle and SAP HANA models.
• Created HANA models using HANA studio.
• Extensively used Analytic, Attribute and calculation views.
• Used HANA Script and CE functions for the reporting needs.
• Participated in HANA installations and supported environment.
• Created WEBI reports using 4.0 versions for the Inventory, Purchase Order, Sales and Distribution business domains.
• Administered users and groups in the CMC.
• Migrated reports and converted universes from 3.1 versions to 4.0.
• Converted existing. unv files to. unx (3.1 universes to 4.0)
• Created complex reports using SAP Crystal reports for CSL trading application.
• Created Report Requirement documents and mapped data base fields with the report columns.
• Migrated reports and universes from 3.1 to 4.0.
• Created Voyage Trending dashboard using Xcelsius tool.
• Wrote stored procedures and free hand SQL using ORACLE CSLDBO2 schema.
• Interacted with business users and gathered report requirements.
• Analyzed and tested existing trades using Triple Point CSL commodity application.

Confidential, Lewisville, TX

Sr. SAP HANA Consultant

Responsibilities:

• Created Schemas (Universes), Imported Tables and Loaded data to tables and also copied standard content from SAP to local repository using SAP HANA
• Used Hana Studio to Create Attribute Views, Analytical views and calculated views
• Closely interacted with business team and completed the QA testing, conducted workshops (Trained Business Users how to use Reporting)
• Design & Development of universes with calculated measures and custom filters.
• Design, install, and configure system for new implementations, upgrades, and maintenance.
• Manage incidents, including complex troubleshooting across technologies.
• Coordinate configuration, change, release, capacity, and availability capabilities.
• Ensure transactional integrity and address authorization issues.
• Creating user groups for reporting and set email bursting with user specific data.
• Extensively involved in training users in Web intelligence, Crystal Reports, and Xcelsius Through training led scenarios.
• Interacted with Business Users to know their Business needs to effectively develop and modify Universes and Reports.
• Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Involved in migration 3.1 to 4.0.
• Designed/Modified the Universes as per the requirements adding new classes and objects as required.
• Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
• Created various LOVs for ease of Ad-hoc reporting in the process of building the Universes.
• Created reports in WEB Intelligence module and implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.

Confidential, Aurora, IL

Sr. SAP Consultant

Responsibilities:

• Complete roadmap for extraction from legacy and other heterogeneous environments in SAP BI using SAP Confidential
• Transformed data using built-in transforms and functions to meet various business requirements
• Loaded the data into SAP BI and HANA sandbox based data store objects Confidential based error-handing & tracing
• Used BODI for both real-time and batch jobs
• Harmonization of Master data across different heterogeneous systems
• Data Quality management using SAP Confidential - Cleansing, Enhancement, Matching and monitoring.
• SAP BO based reporting using WEBI, Crystal and Dashboard Designer etc. with SAP BI, SAP ECC and non-SAP legacy data sources.
• Techno-functional responsibilities - functional specifications, technical specifications to complete modeling and build of the objects

Confidential, Fairburn, GA

SAP Implementations Manager (Migration)

Responsibilities:

• Formed and managed a team of SAP consultants to do complete end to end SAP ECC Implementation from scratch till go live and played a hands on role along with the Team.
• Documented the functional specification document and developed an activation/deactivation BPM (Notify shipment) to activate or deactivate the equipment in the material master and correspondingly to update customer details in ie03 and a SWAP interface with JMS adapter to update equipment swap in customer location.
• Documented the functional specification document and developed an interface to populate the xml from the IDOC (DELVRY03) (added custom segments to IDOC) to send the shipment confirmation to the 3rd party CRM system when equipment’s are shipped from distribution center (DC) to garage.
• Developed an ANSI X12 to IDOC scenario using Seeburger AS2 adapter (splitter, BIC, classifier). Designed and configured Seeburger Business Integration Converter (BIC) adapter for EDI (OSN PO) related message exchange for converting an EDI-xml message to an EDI formatted message and vice-versa (BIC MD).
• Involved in Scoping, documenting and developing an ECC-XI- E-Sourcing scenario for the ERP purchase requisition transfer to E-Sourcing (done via the intermediary RFQ document) and for the transfer of master data.
• Involved in Scoping, documenting and developing an interface to pass the due date and customer details from the third-party system to perform ATP check in SAP APO and return the appropriate shipping method or the revised due date or the material availability date in the other case.
• Experience in eCATT testing tool, created test configurations (cases) set up system data containers for testing the business process, developed test scripts and loaded test data in test data containers.
• Configuration and development of interfaces utilizing various adapters which include FILE, JDBC, SOAP, RFC, IDOC, HTTP, JMS adapters.
• Involved in the development of various complex interfaces such as Material Master, Customer master, Orders to NUSA BW, Pricing conditions, Plant master, Vendor master.
• Developed an HCM interface with ADP from SAP HR (HCM) for payroll processing, benefits, 401K deductions, taxes, insurance, and other payroll functionalities.
• Involved in Scoping, documenting, designing developing and testing employee master data interface with third party system that handled PO approval authority per employee hierarchy.
• Involved in Scoping, documenting and designing and built interface between third party system and HR for cost center, company code and GL interface.
• Documented all the interfaces and BPM integration process that was developed and played a major part in creating proper documents in SAP solution manager for all existing active interfaces. Coding user defined functions using OOPS concept.
• Developed interface objects for in/out bound communication with the BW system and generated ABAP proxies using these definitions. Experience setting up file and JDBC adapters in XI/PI for various BI-XIscenarios. Used SOAMANAGER, WSADMIN, WSCONFIG, LPCONFIG and created web services (Converted RFC enabled function modules into web services) in BW especially query view data and invoked these web services using Xcelsius and generated dashboards out of the BW queries.
• Responsible for monitoring communication channels and restarting them when required and monitored the wave picking process to determine the list of customers to whom the equipment’s had to be kitted and shipped from DC.
• Created alert frameworks which automatically generates and sends out mails to specific support group mailboxes whenever an order fails at the ERP-EPIC interface in production. Developed an interface where Sales receipt data in XML format is converted and transmitted to SAP POS data management (POSDM) and vice versa.
• Active part of the testing team (eCATT) before each major tri-annual release and the periodic maintenance releases. Responsible for creating test plans using eCATT testing tool and generated sample payloads (per the accepted schema and the interface agreement between ERP-EPIC and 3rd party systems) to be tested for each interface and BPM. Fully involved in all the testing phases from unit, integration, and load to regression testing.
• Generated weekly and monthly reports in Solution Manager to determine the number and type of errors in production and analyzing methods and solutions to improve efficiency and also decrease the error rate.

Confidential, Maynard, MA

Technical Manager (Database)

Responsibilities:

• Manage the full Database team along with having a hands on role.
• Managing table spaces, data files, redo logs, tables and its segments.
• Maintaining data integrity also managing profiles, resources, and password security.
• Managing Users, Privileges, and Roles.
• Installation of Oracle software and patches.
• Upgrading the 9i databases to 10g including data guard.
• Upgrading the Database from lower version to higher version.
• Tune SQL statement against database and its objects.
• Write script to monitor the database with shell and PL/SQL code or SQL code such as procedure, function, and package.
• Successfully coordinated data migration efforts and implemented the system at various locations.
• Interfaced between the development team, the business analysts, and the clients for custom implementations of their web based solutions.
• Performed database tuning, backup/restore, monitoring, administration, and maintenance of the online databases. Did 24x7 production support on the online databases.
• Created procedure, packages, triggers, and database objects in oracle 8i/9i and 10g databases.
• Performed database design using database tools like ERWin.
• Created PL/SQL objects, UNIX Scripts, External Tables, Web services and maintained and modified on an ongoing basis.
• Analyze the data from the logs and data mine to get trend analysis.

Confidential, Burlington, MA

Sr. Database Analyst/Administrator (SSE)

Responsibilities:

• Worked with clients during and after the implementation phase and with in-house Bio-Informatics Scientists, data miners and marketing folks, to extract, organize, clean and normalize the data for analysis. Create analysis reports for marketing and scientific presentations.
• Wrote PL/SQL procedures, functions, packages, and database components in oracle 9i as part of Confidential ’s Data Analysis Pipeline Technologies), which won the Bio-IT World Award for 2003. Designed and implemented the entire database layer of Confidential .
• Wrote PL/SQL nodes, with c# .net, in Clementine to access data returned by Oracle Packages, using oracle’s ODP.NET technology.
• Implemented Oracle Partitioning, Local Table spaces, External Tables, collections and so on.
• Wrote PL/SQL procedures, functions, packages in Oracle 8i, as part of Discovery Suite, an n-tier web based bio-informatics data mining & visualization solution. Built on JSP, Servlets, Web Logic, EJB and Oracle backend.
• Responsible for creating, administering, and maintaining the in-house databases.
• Implemented ICD9, LO INC and complex Facts & Comparisons databases.
• Implemented Meta data database, that acts as a central database giving out summary statistics and marketing nuggets for all the databases.
• Did data migration from Oracle 8i to Oracle 9i. Did database migration from sqlserver 7.0 to Oracle 8i, which includes T-SQL to PL/SQL codes and database objects.
• Managed the database with HIPAA compliancy and implemented highest security standards.
• Did data mining and data analysis by using many custom and industry level tools.
• Used data extraction tools and worked with huge datasets from healthcare and genomics data to come up with models by mining the data.

Confidential, Dedham, MA

Database Developer /Administrator

Responsibilities:

• Worked as a team lead in implementing databases, through the entire software-development / implementation life-cycle, starting from requirements-gathering to ‘go-live’.
• Did custom development and implementations in Oracle based solutions.
• Did performance tuning to reduce the nightly process that runs from 8-10 hours to 2 hours, by tuning PL/SQL code and batch loads in oracle.
• Successfully coordinated data migration efforts and implemented the system at various locations.
• Interfaced between the development team, the business analysts, and the clients for custom implementations of eCredit’s web based solutions.
• Performed database tuning, backup/restore, monitoring, administration, and maintenance of the online databases. Did 24x7 production support on the online databases.
• Created procedure, packages, triggers, and database objects in oracle 7.x and 8i databases.
• Did Oracle database migration & upgrade from 7.x to 8i, on the production servers.
• Performed database design using database tools like ERWin.
• Worked on a multibillion $, International computer manufacturing company, on a web based equipment financing module for B2B and B2C. Worked extensively on a 24x7 environment on Oracle, UNIX, NT, Java, Java Servlets, and Web Servers. Worked on the database part of bureau integration, bank integration and routing algorithms. Worked onsite for weeks together.
• Worked as a developer and DBA on the global financial network solutions, on a HP-UX, Java, XML and Oracle environment.
• Worked on a multinational Biomedical company (multibillion $), on implementing and customizing the database for various products of eCredit. Worked on data migration from oracle 7.x to SqlServer 6.5. Worked extensively with the senior management and technical people from the client side.
• Worked on a multibillion $ company that specializes in construction materials, automotive components, industrial components. Worked extensively in development and implementation and supporting the product. Worked extensively with Oracle development. Worked on reporting, the data warehousing details, using Crystal Reports.
• Did R&D in reducing the turnaround time by fine-tuning the database queries, pl/sql packages and routing the requests to different Web Servers (IIS), which reduced the overall load on the server.
• Worked on design, development and administration of oracle databases.
• Worked on troubleshooting production problems and supporting the databases 24x7.

Confidential, TX

Database/Systems Analyst

Responsibilities:

• Maintained the entire staff/employee details in an Oracle database.
• Responsible for development, administration, and backups of the SQL Server databases.
• Part of a team who created and maintained a web portal that offers users an interactive way to obtain the information they need. Users can apply on-line for membership and information and also can search the information from our database. Worked as a database developer.
• Created and maintained email accounts, PPP account and access controls in Unix and domain accounts, web accounts, dial-up remote access controls in WinNT Server