Programmer Analyst Resume
TampA
PROFILE SUMMARY:
- Demonstrated exemplary expertise as evinced through over 14 years of extensive Global Project Management & SAP Implementation experience encompassing Technical & Functional Consultation, Global Rollouts, Project Delivery, Team Management skills across various domain
- Hands - on experience in implementing SAP HANA at Confidential Inc to create Fiori Applications in ECC using CDS (Core Data Services) and push data to downstream systems via OData services and ODBC/JDBC connections
- Techno-functional professional, proficient in SAP HANA SQL Script database objects development and SAP FIORI UI Development using WebIDE.
- Well-versed in working on SAP Modules including SAP R3(FI, SD, MM, PU), SAP PLM, SAP SRM, SAP SNC, SAP APO.
- Handled major clients like Confidential, eBay, PayPal, Adidas, Reebok, and Hughes network systems.
- Profound Knowledge of SAP HANA upgrades from HANA 1.0 to HANA 2.0 and SLT upgrade to latest DMIS 3.0, SAP ECC, SAP SLT, Fiori using WebIDE, Object Oriented Programming, BRF, BADIs, ABAP Web Dynpro, Process Controlled Workflow, PI, ALE/IDOC,, HANA User Management, and Used Smart Data Access to fetch data from SAP B/W
TECHNICAL SKILLS:
HANA Development Skills: Data modeling Created Attribute views, Analytical views, Calculation views (Graphical and SQL Script), Tables, views and Decision Tables Created Stored procedures and Table functions using SQL script S/4 HANA developments include created CDS Views with association and different types of AnnotationsAMPL, OData service development via Gateway, created consumption views ECC Code push down to HANA via proxy and External views. HANA data provisioning technology including SLT, BODS, SDA HANA Security includes creating Analytical privilege, Roles and User management HANA administration includes monitoring memory unloads, performance monitoringTrace analysis (SQL Trace, performance trace, expensive statement trace, user specific trace, database trace) SAP SLT (Data loading/Replication with Filters, created rule to Transform data and filter data at source and SLT level, Data replication monitoring using LTRC Code, SLT Administration using LTR, Parallelization of data load/replication via LTRS) HANA XS and OData service, exposed data to downstream systems via OData or JDBC/ODBC connections SAP HANA performance tuning via Visual plan and Explain plan HANA CTS (Change and Transport system) via Solution Manager Worked on SAP HANA and SLT upgrade
UI Development Skills: Expertise in SAP Fiori, Personas and Web Dynpro
ABAP development Skills: ABAP Workbench Tools reports, classes, functions groups, modules pools, ABAP Dictionary tables, views, lock objects, search helps, global types, Data transfer/upload technologies BAPI, Batch Input, direct update, Excel upload, ALV Grid, ALV Tree, ALV text-edit, Lists Enhancement Customer exits, user exits, BAdI, BTE, Dynamic Programming, Object-Oriented Programming, Program Optimization Print forms PDF forms, Smart Forms, SAP Script Integration with external systems (IDOC, RFC, ALE), BRF Workflow
SAP Modules: SAP R3(FI, SD, MM, PU), SAP SRM, SAP SNC, SAP APO, SAP PLM
CORE COMPETENCIES:
- Performance Management
- SAP Development Consultation
- Escalation Management
- Service Delivery Management
- SAP HANA Implementation
- Project Management
WORK EXPERIENCE:
Programmer Analyst
Confidential, Tampa
Responsibilities:
- Spearhead a team of 15 members in managing multiple onsite/offshore vendor resource
- Coordinate with the cross functional team to accomplish objectives and meet critical deadlines in a fast paced, high growth dynamic environment in both Waterfall and Agile iteration methodologies
- Involved in Technical and Functional Design review, Development, Unit testing and Go-live support
- Provide Technical analysis, data migration, interface support, and technical support whenever necessary. Prepare the Development Plans for Assigned Development Objects based on Complexity level
- Supervise staff members in the development, implementation, and delivery of systems to business and technical requirements
Confidential
SAP HANA Implementation
Responsibilities:
- Complex and performance intensive ABAP programs are code pushed down to HANA to improve performance, the reports which took more than 24 hours ran in less than 60 seconds.
- Complex calculations views are created in HANA and exposed to external reporting services like MicroStrategy, Tableau, IBM Cognos, Information steward, Power BI, Watson and many other reporting tools.
- Created Stored procedures and called them from SAP ECC via Proxy to improve performance.
- Created Calculation/Attribute/Analytical views which are exposed to SAP ECC as External views and consumed in ECC programs.
- Created Analytical privilege and assigned them to role to restrict data access to users.
- Involved in HANA User Management - like creating users, assigned corresponding roles which had Analytical privilege.
- Involved in SAP SLT - Loaded and replicated ECC data with/without filter to HANA, created rules to transform ECC data to HANA, Parallelized the data load and replication to improve data latency, worked on multi source to single target SLT model, also worked on monitoring and administration of the SLT system.
- Created CDS/AMDP and consumed them in SAP reports to improve performance.
- Created XS OData service on CDS Views/Calculation views and exposed them to SAP Fiori and downstream systems for reporting.
- Involved in HANA Administration like Memory management, Performance management,
- Trace Analysis which includes (SQL Trace, performance trace, expensive statement trace, user specific trace, database trace).
- Worked on HANA Change and Transport Management System (CTS) combined with Solution manager to transport changes across systems.
- Worked on SAP HANA upgrades from HANA 1.0 to HANA 2.0 and SLT upgrades to latest DMIS 3.0.
- Used Smart Data Access to fetch data from SAP B/W.
Confidential
SAP SRM 7.0 Implementation
Responsibilities:
- SAP SRM 7.0 is implemented at Confidential to replace the existing Ariba procurement software.
- SRM is implemented from end-to-end.
- Developed numerous enhancements to Standard SAP Webdynpro screens.
- Customized the shopping cart (Classic and Professional) and purchase order screen extensively as per the requirement.
- Customized Standard SAP Floor Plan manager screens.
- Enhanced Standard Approval workflow process via BRF.
- Worked on BRF, BADIs, Enhancement Points, ABAP Webdynpro, Process Controlled Workflow, ABAP Objects, PI, ALE/IDOC, and ABAP Objects
- After analysis users were creating return purchase order manually.
- This manual intervention was time consuming and might lead to some data entry errors. In this project, we automated the entire Return process at Confidential .
- SAP Web Dynpro tool has replaced the existing Java tool in retail with.
- We have provided a tool in web dynpro where users can analyze the return materials and decide which materials needs to be returned. After analysis, return request will be created.
- Exception business rules were defined which will be validated in the web dynpro tool during analysis.
- If any of the exception rule matches, then the return request will be sent to the Confidential team for approval. Confidential team has been provided with module pool screens similar to web dynpro screens for retail store.
- Confidential team may approve the return request or they might send it back to the retail store for clarification.
- If no exception rule matches, return purchase order / material document will be created in the retail store automatically. Confidential team is also given an option to approve the return request, in which case return PO /Material document will be created in module pool screens.
Confidential
Programmer AnalystResponsibilities:
- Implement performance efficient SAP RMCA (version ECC 6.0) industry solution on a separate instance of SAP.
- The sub ledger transactions posted in SAP RMCA will be transferred to SAP core environment, at a consolidated General ledger on daily basis as part of this project.
- This is a global implementation spread across 5 Company codes and 70+ countries.
- Worked as a developer in RMCA implementation from end to end.
- Customized the whole RMCA module as per Confidential requirements.
- Worked extensively on inbound interface, IDOC, User Exits, ALV Reports, Outbound Interface, BAPIBADI and BTE etc.
- I have created Forecasting and Demand Planning utilities.
- Customized the entire Demand planning module to meet Confidential business needs.
- I have worked on Dialogue program to create custom utilities similar to Standard transactions.
- I have worked on User Exits, Complex ALV Interactive Reports, BAPI and BADI.