We provide IT Staff Augmentation Services!

Sap Bods Consultant Resume

0/5 (Submit Your Rating)

Dallas, TX

SUMMARY

  • IT professional with more than 8 plus years of experience in building data models using SAP HANA, SAP Data Services (BODS), Relational(RDBMS) sources, and reporting solutions using SAP Business Objects tools
  • Experienced in all phases of the Software Development Lifecycle (SDLC) including requirements gathering, analysis, design, system implementation, performance tuning, testing and support
  • Involved in SCD Type 2 implementation, integration with SAP systems, SAP BW and Non SAP Systems as a source to BODS, by implementing Data Ware House with Star Schema, Snow flake Schema
  • Worked in Different Business Segments Oil Gas, Banking, HealthCare, Hospital Devices, and Pharmaceuticals
  • Proficient in Data Migration from legacy to SAP ECC environment by using SAP BODS tool. By using LSMW, I Doc and SAP HANA loadings.
  • Experienced in Getting the data from Non SAP and SAP ECC/BW in to SAP BODS Environment and loading in to the Non SAP And SAP HANA Environment
  • 1 plus years of development experience with primary focus on SAP HANA development, planning, architecture, and implementing large scale data warehousing on SAP HANA platform
  • Expertise in Native HANA development: creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytic, and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics)
  • Experienced in creating functions, Analytical Privileges, building SAP HANA security models, migration & optimization, sizing, and performance tuning
  • Experienced in architecting SAP Business Object Platform 4.2/4.1 to integrate with SAP BW, SAP HANA, SAP ECC (HANA Live views), Oracle (MDM) and to support Data migration/profiling using SAP Data Services and Information Steward
  • Expertise in developing complex Web Intelligence documents with multiple reports, tabs, queries, cross - tabs, charts, hyperlinks, with drill-down/though capabilities from using BICS and Universes
  • Developed fully interactive Dashboards with multiple KPI’s, inputs, what-if analysis with drill-down/through capabilities using SAP Dashboard (Xcelsius), Design Studio and integrated these with SAP Business Objects Mobile App to consume in Ipads/Iphones
  • Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written
  • Excellent inter-personal skills with eager to learn new concepts, methods, and technologies

TECHNICAL SKILLS

Reporting Tools: SAP Business Objects (Information Design Tool, Universe Designer, WebI, DeskI, Central Management Console, InfoView, BI Launch pad, Mobile, SAP Business Objects Dashboards (Xcelsius), Design Studio 1.6, Lumira, Analysis for Office

Data Bases: SAP HANA, Oracle, SQL Server, Teradata, Sybase

ETL Tool: SAP Data Services 4.2 /Data Integrator, SAP BW, Information steward.

Languages: SQL, PL/SQL, UNIX Shell Scripts, HTML, C, C++, VB 5.0/6.0

Operating Systems: Microsoft Windows, Unix, Windows Enterprise Server, AIX, Red Hat Enterprise Linux 4.0.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SAP BODS Consultant

Environment: SAP HANA, SAP Business Objects 4.2, IDT, SAP HANA live, Webi, Lumira, Analysis for Office, Design Studio, SAP Data Services 4.2

Responsibilities:

  • Lead data analysis, modeling, and extraction of data from multiple sources. Design and develop dashboard reports
  • Provide guidance on inter-operability of different platforms and tools
  • Develop, implement, maintain, and document standards and guidelines for SAP HANA models and Interfaces
  • Involved in SCD Types using (Table Comparison, History Preserving, Key Generation)
  • Developed a standard BODS ETL Job to load the Time Dimension table using Data Integrator Transform DATE GENERATION.
  • Excellent Work experience in Extracting and loading the Data related SAP ECC by using the BAPI calls
  • Worked with BODS and HANA code migration from Dev to QA and Production between taking the Backups and processing the data as per the Business and Testing team requests
  • Extracting the data from different systems like sap ECC, sap BW, Force.com,
  • And loading in to SQLserver, and HANA as Target.
  • Created packages in Information Steward to maintain the quality Data Ware House.
  • Configured SAP HANA, SAP BO with SAP BODS, Created Repository for the Reporting (SAP BO, WEB’I)

Confidential, Tampa, FL

SAP Data Services/HANA BI BOBJ Consultant

Environment: SAP Business Objects 4.1, IDT, SAP HANA, Design Studio 1.6 SP 2

Responsibilities:

  • Architecting and managing the technical, non-technical and visualization aspects of the project
  • Leading the delivery of Visualizations with a focus on end-to-end integration and bringing standardization within the project
  • Work on the technical details for transforming existing data onto SAP using tools such as BODS & Oracle DB
  • Design/develop/Unit Test all ETL routines in BODS.
  • Data cleansing process (Cross reference value changes, Data standardization, Obsolescence, Deduplication, USPS based Enrichment); Execute Transformations.
  • Identify data quality issues, provides recommendations for improvement / resolution. Prepare input/output reports and assist business analyst in preparing reconciliation reports.
  • Developing standardized dashboard templates using SAP Design Studio which can be used as the base for new dashboards for different business use cases
  • Develop attribute views, analytic views, calculation views, exposing SAP BW models as HANA views, and enhance the SAP HANA Live views to address the business user requirements
  • Developing and enhancing the other technical artifacts such as UNX and SAP HANA views
  • Provided ideas around dashboard development to enhance the user experiences at run time
  • Used indexes in the Design Studio to capture the data points at the run time to minimize the development efforts on universe and HANA views
  • Created Global script and optimized the code to control the component interaction and to manage data sources, data elements and data calculations during run time
  • Created customized Web Intelligence documents which are utilized as detailed reporting purpose

Confidential, Chicago, IL

Sr. SAP Data Services/HANA BI Developer

Environment: SAP Business Objects 4.1 (Mobile), SAP HANA/Live, SAP BW 7.3 on HANA, ECC, Data Services 4.2, Design Studio 1.5

Responsibilities:

  • Involved in business requirement gathering to translate them into design developments
  • Created Web Intelligence reports with Parameters, Sub-reports (Master/Detail) using open Doc functionality on top of BEX Queries (BICS)
  • Designed, created, implemented, and tested dataflows, workflows, scripts, and jobs for multiple projects for SAP Data Services.
  • Troubleshooting and performance tuning which reduced several ETL jobs from several hours to less than one.
  • Created attribute, analytical, calculation views and enhanced SAP HANA pre-delivered content
  • Worked with security team in building security models within BOBJ and configured single-sign-on between SAP BOBJ and BW(STS), HANA (SAML) and WinAD
  • Coordinated with technical teams to configure SAP HANA/Live pre-delivered content and involved in promoting packages using HANA Lifecycle Manager (HLM)
  • Worked extensively on Analysis for Office Reports to support their operational reporting needs
  • Used Promotion manager to promote objects in CMC from Dev to Test to Production env’s
  • Worked with Basis, IT teams for configuration, troubleshooting issues for performance tuning
  • Involved in user training and prepared technical specification document on Business Objects artifacts

Confidential, MO

Business Objects Data Services Developer

Environment: SAP Business Objects BI Platform 4.1, Data Services, Oracle

Responsibilities:

  • Participate in Data Mapping workshops and follow-up meetings with the client business and IT teams. Assists in data mapping and GAP analysis between source and target data in BODS as per the blueprint.
  • Prepare technical specification document.
  • Worked on the technical details for transforming existing data onto SAP using tools such as BODS & Oracle DB.
  • Design/develop/Unit Test all ETL routines in BODS.
  • Coordinate with technical teams regarding client transports, testing strategies etc.
  • Identify data quality issues, provides recommendations for improvement / resolution. Prepare input/output reports and assist business analyst in preparing reconciliation reports.

Confidential

Java Developer

Environment: Java, Android Studio, MySQL

Responsibilities:

  • Responsible in complete Software Development Life Cycle (SDLC) for proper analysis, development, testing, deployment and enhancement of the code as an Android/Java Developer.
  • Experience on multi-threading, data structures, algorithms, object oriented design, and design patterns.
  • Played a key role in writing application logic in Java using Eclipse IDE and Android SDK.
  • Experience with SQL query generation and data modelling experience.
  • Followed up by testing (user interface, errors with all possible inputs, debugging, publishing) apps after project completion
  • Tested applications on multiple devices to insure compatibility standards.

We'd love your feedback!