We provide IT Staff Augmentation Services!

Erp Systems Analyst Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • 10 years of experience in Information Technology primarily focused in SAP technology and tools and specialist in BI/BW (data warehouse) implementations.
  • Experience working with traditional SAP BW, SAP BW on HANA and SAP (Native) HANA data modeling.
  • Currently working on enterprise data warehouse implementations involving SAP BW 7.4 on HANA, Native HANA, BOBJ and Data services.
  • Involved in several complete life cycle implementations of enterprise data warehouse, which includes requirements gathering & analysis, design & development, testing & deploying business applications primarily using SAP BI/BW/ECC and HANA technology and tools.
  • Experience working in multi system landscape architecture
  • Involved in the architecture design and developed functional and technical specification documents.
  • Conducted and participated in structured walkthroughs and technical reviews.
  • Co - ordinate team members during build and deployment of applications.
  • Ability to provide high level and detail estimates of various tasks related to BI solutions.
  • Experience working in an onsite-offshore model involving daily interactions with offshore teams to ensure on-time quality deliverables.
  • Performed installation, activation and enhancement of SAP Business Content based on customer needs for new applications.
  • Extensively worked in SAP BW (7.4, 7.0, 3.5), ECC 6.0 and R/3 4.6C.
  • Responsible for HANA modeling using HANA studio for enterprise data warehousing solutions.
  • Experience in using SAP BODS (Business Objects Data Services), SLT and SDA (Smart Data Access) to extract data from different source systems into HANA.
  • Developed Attribute, Analytical and Calculation (graphical and script based) HANA modeling views.
  • Involved in client’s requirements gathering discussions for the business warehouse implementation of SAP FI, CO, SD, MM, HR, CRM, xRPM and cProjects modules and also data residing in Non-SAP systems.
  • Experience in extraction, transformation and loading data between SAP, Non-SAP and HANA systems.
  • Worked extensively with BEx Query Designer, BEx Analyzer, Report Designer, Information broadcasting and Web Application designer for creating custom reports.
  • Experience in BI tools like Universe Designer, Web Intelligence, Analysis for Office, Lumira and Xcelsius.
  • Experience in analyzing performance bottlenecks on SAP BW and HANA systems and optimizing the applications.
  • Experience in developing ABAP dictionary objects, extract programs, function modules, web dynpro applications using adobe forms.
  • Excellent troubleshooting and resolution skills.
  • Experience in supporting various applications in production environment.

SKILLS & EXPERTISE:

  • SAP BI/BW
  • SAP BPC
  • Customer Interaction
  • SAP Bex Reporting
  • SAP ABAP
  • Gather/Analyze Requirements
  • SAP BOBJ Reporting
  • SAP ECC
  • Testing
  • SAP BW on HANA
  • SAP BWA
  • Manage Tasks & Deliverables
  • SAP HANA Studio
  • SAP Web Dynpro
  • Process Improvement

EMPLOYMENT HISTORY:

ERP Systems Analyst

Confidential

Responsibilities:

  • Interacted with customers to understand the requirements for business applications and documenting them.
  • Prepared functional and technical design documents based on customer requirements.
  • Responsible for HANA modeling for Complaint handling system, SQRR and for reporting applications in Booking, Billings, Backlogs, Inventory and Purchasing areas.
  • Extracted data from different source systems into HANA using SAP BODS (Business Objects Data Services), SLT and SDA (Smart Data Access).
  • Created several Attribute, Analytical and Calculation (graphical and script based) HANA modeling views.
  • Created ODP data sources based on HANA calculation views.
  • Responsible for building and enhancing BI/BW objects such as InfoObjects, Transformations, DTPs, InfoProviders (DSOs, Open ODS view, InfoCubes, and MultiProviders) and Process Chains. Monitor BI loads, communicate and troubleshoot issues with data integrity, data design, functional and technical. Perform routine program modifications, performance tuning, problem solving, debugging, and testing.
  • Maintained BW structures and support for ETL processes for data feeding in and out of BW.
  • Developed an automated interface to send employee information to third party vendor.
  • Developed a BW data model to assist employee separation audit.
  • Implemented BOBJ Webi reports to replace BEx web reports in HR analytics area.
  • Responsible for supporting HR Analytics housed on SAP BW system.
  • Developed reporting scorecards using BW and BOBJ tools.
  • Involved in Production support 24x7 based on support schedule.

Environment: HANA Studio, SAP BW 7.3 to 7.4 on HANA, SAP ECC 6.0, BEx Query Designer, Webi, Universe Designer, IDT, Data services, Information Steward.

SAP BI/BW Developer/Analyst

Confidential

Responsibilities:

  • Involved in client’s requirements gathering discussions for the business warehouse implementation of SAP FI, CO, SD, MM, CRM, xRPM and cProjects modules and non SAP source systems.
  • Involved in the architecture design and developed functional and technical specification documents.
  • Involved in setting up master data for BW 7.3 on HANA and implemented a finance reporting application sourced from Teradata.
  • Responsible for data modeling in SAP BW 7.3 on HANA.
  • Activated Business content for several business warehouse implementations.
  • Customized the standard business content as per the business requirement.
  • Developed generic data sources based on tables/views, function modules, queries.
  • Developed extract programs using ABAP for generic data sources.
  • Developed custom info objects, info cubes and multiproviders.
  • Written ABAP routines in transformations.
  • Built process chains for data load automation.
  • Developed reports using Bex Query Designer, Business Explorer and Web Application Designer.
  • Developed reporting dashboards using Xcelsius and created custom reports using Universe Designer and Web Intelligence.
  • Created iviews, pages and worksets and configured enterprise portal to publish BI web reports.
  • Developed business applications using web dynpro and adobe forms technologies.
  • Experience working with BPS/BPC cubes.
  • Liaise with SAP Basis team regarding BW Transport requests.
  • Worked with SAP security to set up the user security for the application.
  • Involved in Unit, Integration and User Acceptance testing.
  • Involved in Production support 24x7.
  • Reports were run and distributed to the users when requested.
  • Interacted with users to resolve the business application issues.
  • Conducted BI reporting tool -WAD training session to the IS team members.

Environment: SAP R/3 4.6C, ECC 6.0, SAP BW 3.5 & 7.0, BW 7.3 on HANA, BPC 7.5, BEx Query Designer, BEx Analyzer, Report Designer, WAD, Xcelsius, Webi, Universe Designer, HTML, JavaScript, MS Office tools, Mercury Quality Center.

Confidential, IN

SAP BI/BW Developer

Responsibilities:

  • Participated in the development of technical specifications.
  • Extended transaction Data Sources by appending new data elements using enhancement component RSAP0001 and used the function exit EXIT SAPLRSAP 001.
  • Also worked with data sources 0FI AP 4, 0FI AR 4, 0FI GL 4 and written user exit codes like 0FI AP 4 EXIT to populate Purchase order item with Material group code and 0FI AR 4 EXIT to retrieve partner functions like Bill-to-Party & Ship-to-Party.
  • Customized info cubes for FI-GL, FI-AR, FI-AP and MM.
  • Implemented FI cubes 0FIAR C03 and 0FIAP C03 and ODS 0FIAR O03, 0FIAP O03.
  • Created 12 queries based on calendar day week, month and year to obtain a variety of reports for AR-Overdue Analysis, AR-DSO (Days Sales Outstanding), AR-Due Date for Net Payment, Details of AR Line Items, Overview of Accounts Payable, etc.

Environment: SAP R/3 4.6C, SAP BW 3.5, BEx Query Designer, BEx Analyzer, WAD.

Graduate assistant

Confidential

Responsibilities:

  • Hardware and software support to the various computer labs on the campus.
  • Installed and configured software and also handled system performance issues.
  • Troubleshooting user problems with respect to various services provided by the university.
  • Configured hardware for PCs and provided user support.
  • Responding to calls and attending user problems regarding issues with hardware and software available in the labs.
  • Handling data uploaded to the Remedy Service database. This was done using MS-ACCESS.
  • Instructed and conducted labs to under graduate students in C programming language and Electronic circuits.
  • Supervised academic projects and involved in the implementation of projects.

We'd love your feedback!