Sr. Sap Bw4hana/bobj Architect Resume
Dallas, TX
SUMMARY:
- Expert level SAP BW/4 HANA/BOBJ/BODS knowledge with 15 years’ experience.
- 18 years’ experience in the Information Technology sector.
- BI Architect leading End - to-End implementations in SAP Activate, Agile and ASAP methodology.
- Support Upgrades of BW7.0 to 7.3 and 7.3 to 7.4 in step-by-step approach of System preparation, SPDD, SPAU, and post upgrade activities.
- Expert level data modeling and performance tuning of SPOs, and COPs on BW on HANA.
- Highly effective in converting Business Requirements to Functional and Technical Specifications.
- Experience in Full Life cycle implementations in modules of SD, MM, PM, CS, PUR, FSCM - Dispute Management, Collections Management, FS - Consumer Mortgage Loans (CML), IS-Aerospace & Defense, Is-Utilities, FI-CA, Banking Services, Bank Analyzer.
- Extensive experience and knowledge in ETL (Extraction, Transformation, Loading) from IS-Utilities, LO Cockpit, FI-AP, FI-AR, custom extractors and as well using BODS tools.
- Expert level experience developing executive Dashboards and Webi reports using BOBJ, and Microsoft Excel for Analysis.
- Experience in Unit testing, Functional and Integration testing of end-to-end data flow using Mercury Quality Center and HPQC.
- ABAP and AMDP programming experience in Extractor enhancements in R/3, Start, Transfer, End and Expert Routines, conversion exits in BI.
- Expert analytical skills coupled with interpersonal, communication, presentation and self-organizing skills with strong problem-solving abilities and effectiveness in working independently and as a committed team player.
TECHNICAL SKILLS:
Industries: Consumer Mortgage Loans (CML), Oil & Gas, Chemical, Medical, Automotive, IS-Utilities, Banking, IS-Aerospace & Defense, Transportation
SAP Systems: ECC6.0, BW/BI 7.4, Solution Manager, Bank Analyzer, Banking Services, CRM, BODS
BI/BOBJ: BOBJ 4.1, Microsoft Excel for Analysis and Xcelsius
Programming Languages: ABAP/4, SQL, UNIX, Windows, MS DOS
RDBMS: MS SQL Server, ORACLE, MS Access.
Software: Microsoft Office Suite, Testing Tools like WinRunner, Test Director, and Rational Suite, HPQC, Share Point.
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Sr. SAP BW4HANA/BOBJ Architect
- Re-architecting BW7.3 solutions in BW4HANA in greenfield implementation
- Re-gathering requirements as business is matured in last 5 years
- Documenting Architecture diagrams and Functional documents after GAP Analysis
- ABAP routines and AMDP scripts were written in transformations where applicable
- Created aDSOs, Composite Providers and BW Queries
- Created BOBJ reports and Analysis reports
- Worked on NLS strategies and DTO (Dynamic Tiering Optimization) using SAP IQ.
- Lead offshore team on development activities, testing and documentation.
Environment: ECC, BW4HANA, BOBJ, Office Analysis, IS-U, FI-CA, NLS
Confidential, Issaquah, WA
Sr. SAP BW4HANA/BOBJ Developer
- Involved in gathering requirements and gap analysis
- Worked on Technical designs and testing strategy
- Developed BW Objects using Eclipse studio
Environment: ECC HANA, BW4HANA, BOBJ, IS-R, SD, MM, and IM Modules
Confidential, Greenville, SC
Sr. SAP BW on HANA/BOBJ Architect
- Lead activities between the Basis and BW teams to resolve HANA in-memory performance issues.
- Re-converted Hana Optimized DSOs to Standard DSOs to fix some of in-memory performance issues.
- Resolved Data loads performance issues between various DSOs by rewriting the ABAP logic.
- Analyzed Server config settings and recommended all missing Server config parameters on both BW and HANA
- Certified reports to comply with BI Certification project.
- Created Data Lineage flow from BOBJ to ECC.
- Fixed numerous production issues of BI reports.
- Involved in day-to-day activities and resolved production tickets.
Environment: SAP ECC6.0, BI7.3 on HANA, Bobj4.2, and SD, MM, and IM Modules.
Confidential
Sr. SAP BI/BW Architect
- Gathered business requirements and created business blue print
- Architected end-to-end solution based on blue print and documented using Visio
- Liaison between the clients and developers to ensure the solution met business needs
- Presented the solutions to the team and business units for final approvals
- Modeled and lead the Process Chain Optimization project to optimize nightly batch loads
- Assist in Support activities, Full Life Cycle Implementations, Enhancements
- Implemented projects and enhancements in PM, CS, PUR, IM, IS-U, and FI-CA modules in Agile Methodology.
- Supported ‘Support Pack Upgrades’ of BOBJ 4.0 to 4.1 and BW 7.0 to 7.3 and 7.4.
- Created reports in Webi and in Microsoft Excel for Analysis.
- Involved in end-to-end upgrade process that includes system preparation, SPDD, SPAU, and post upgrade activities.
- Worked closely with BOBJ Admin to implement Security profiles and connection issues.
- Expert in resolving transport issues, process chain failures, data load errors.
- Involved in Migration project from 3.x to 7.x as a quality coordinator, and resolved issues while promoting to Production.
- Efficient at ABAP coding to support transformations, extractor enhancements, reports, etc.
- Used BODS tool to extract data from Non-SAP systems.
Environment: SAP ECC6.0, BI7.4, Bobj4.1, BODS, Enterprise Portal, and IS-Utilities.
Confidential
Sr. SAP BI/BW Architect- Gathered requirements, conducted workshops, Architected the solution for highly critical exception reports where data exists in two different source systems
- Architect the end-to-end solution to create Internal Accounts balances by G/L report by joining Bank Analyzer and Banking Services data.
- Architect the end-to-end solution create an exception report that shows transactional postings posted to suspend G/Ls by joining Bank Analyzer and Banking Services data.
- Architect the entire solution to create Loan Statuses KPI Metrics report.
- Architect the end-to-end solution to create Finance Static Report, which displays Actuals, Budget, forecast (Bank Analyzer data) for YTD and MTD.
- Worked on enhancements of after go-live issues.
- Created Webi reports in BOBJ 4.0.
- Modified the existing Function Module(s) ABAP code as part of enhancements.
- Handled on-call support for daily batch loads.
- Worked on Archiving project (Data Volume Management)
Environment: SAP ECC6.0, Bank Analyzer, Banking Services, BI7.0, and BOBJ.
Confidential
SAP BI/BW Developer/Team Lead
- Lead the team in Support activities, Projects Full Life Cycle Implementations, Enhancements, Requirement gatherings.
- Developed end-to-end Solution Architecture for new projects and enhancements. End-to-end is from SAP ECC to BOBJ Webi and Xcelsius Dashboards.
- Implemented and supported CR&B (Customer Relationship & Billing) project in IS-Utilities module.
- Implemented and supported SBM (Service Business Metrics) project in PM and CS modules.
- Developed and supported FI-CA (Contract Accounts Payable and Receivable) Extractors, InfoCubes, BEx and Webi reports.
- Done a thorough testing to make sure Webi reports are reconciled back with GL Accounts in ECC system.
- Blueprint HR Modules - Personnel Administration, Time Management, Organizational Management.
- Wrote ABAP code in Transformations, extractor enhancements, Reports,etc.
- On-call support for all BW nightly batch loads
- Experience with CPS (Central Processing system) that controls all ECC and BW batch jobs.
- Developed Webi Reports using OLAP universes in BOBJ.
Environment: SAP ECC6.0, BI7.0, Bobj, Xcelsius, Enterprise Portal, and IS-Utilities.
Confidential
SAP BI Team Lead
- Modeled, implemented and lead the project end-to-end.
- Used SAP ASAP Methodology to deliver each phase of the project.
- Created Project Charter and L1/L2/L3 Plans as part of Project Preparation phase.
- Conducted Workshops as part of Blueprint phase and collected business requirements for further analysis.
- Converted business requirements into Functional and Technical specs.
- Created PowerPoint presentation on strategy for Reporting & Presentation approach.
- Monitored weekly status updates and project timelines.
Environment: SAP ECC6.0, BI7.0, Mercury Quality Center, Oracle9i, and Subversion
Confidential
BI Lead
- Worked on Mainframe programming code and analyzed the logic to replicate the same in BI environment as part of Mainframe system decommissioning.
- Created estimates for development, testing, and go-live efforts and resource tasks.
- Created functional design documentation for Government Regulatory reports by converting Legacy requirements.
- Created extractor with ~600 fields and loaded to Write Optimized DSO.
- Data extracted out from BI/BW into Flat files (Excel) using Open Hub Destination tool for business to play around with data for fine-tuning of requirements as part of enhancements.
- Unit testing and Integration testing for data flow was done.
- Created routines in transformations using ABAP OOP programming.
- Created highly customized complex Extractor Function Module in Source system (ECC6.0) with help of ABAPer.
Environment: ECC 6.0, BI 7.0, Mainframes.
Confidential
BI Lead
- Involved in requirement gathering and analysis.
- Created Gap document and Business Design Documentation.
- Created Functional Design Documentation for all identified reports and dashboards.
- Created detailed plan to estimate resources and efforts.
- Created BI data flow design solution architecture in Visio.
- Responsible to communicate technical design documentation and functional design documentation with Business team and obtain sign-off.
Environment: SAP ECC 6.0, BI 7.0.
Confidential
BI Team Lead
- Created Blue print for Reporting and involved in requirements analysis.
- Created detailed plan to estimate resources and efforts.
- Created BI baseline Configuration PowerPoint deck to configure the new BI system.
- Configured the new BI system through Solution Manager.
- Install the Business Content objects through Solution Manager for HR Modules - Personnel Administration, Organization Management, Time Management, PM, and FI modules.
- Documented module wise detailed configuration plan as part of realization phase.
Environment: SAP ECC 6.0, BI 7.0, and Solution Manager.
Confidential
Sr. BI Consultant/Team Lead
- Worked on resource planning, project timeline estimates as a team lead and coordinated with offshore team (India) for BI Extractors ABAP work.
- Involved in Blue printing, Gap analysis and BI backend configuration, design and modeling.
- Involved in full life cycle implementation on FI-AR (Cash flow), Dispute Management, and Collections Management.
- ABAP coding performed for BI standard Extractors like Customer Master, 0FI AR 4 and for some generic extractors in R/3.
- Lead thorough Functional and Integration testing in Quality phase and prior to go-live phase.
- Worked on postproduction system for all day-2-day issues like data loads, Query data issues, performance issues and issue enhancements.
- Worked with Basis in measuring system disk spaces, processes monitoring while data loads and query run time.
- Worked on formatted reports using several workbooks.
- Broadcasted workbooks directly to Users inbox using Information broadcast tool.
- Using Pre Calc-Server broadcasted the queued up pre-calculated workbooks.
- Created documentation each for Configuration, Design, Modeling, Loading, and Query development.
Environment: SAP R/3 4.7 and ECC 6.0, BI 7.0 and BW 3.5, EAI Web tool interface, Mainframes, Windows, SQL Server, and Pre Calc-Server.