Sap Bi - Bpc Architect / Admin Resume
Cleveland, OH
SUMMARY:
Provide expertise in operating and continuously improving enterprise systems, also keep learning and expand knowledge in operating/improving systems.
EXPERIENCE SUMMARY:
- 25+ years of total IT experience.
- Expertise in SAP BW - HANA-SLT with hands on development and admin skills. BW-HANA upgrade, support pack installation, Transport management, Performance Management with Hands on / SME/ Analyst for Center of Excellence. Worked on BOBJ reporting using BICS connection, universes. BO 4.2 & 4.3 Upgrade
- Experience in setting up Hana backups, Hana replication, Hana cleanup, setting up alerts and HANA cockpit.
- SLT Admin-SLT Confugration with ECC & Non SAP source via RFC Connection & DB connection with HANA, Transformation & Filter capablity, Performed Monitoring-Admin task from SLT & HANA Studio.
- HANA Modeling - Design of CDS views & Calculation views (Attribute & Analytic View conversion with Calculation View). Import of BW data models as HANA views and build additional modelling on them. Transport of HANA views, Performance analysis of HANA views, Consume HANA views in BOBJ and tableau.
- BPC 10.1 reporting and Admin, also performed BPC installation and have done Security setup
- Implementation & Support experience, hands on configuration experience includes working in with Vistex, BW FI-CO, MM, PM, PP, QM, SD. BPC 10.1 Configuration-Installation-Security-Development.
- Worked on global ERP Implement and roll outs (US, Mexico, Australia, India), Hands on Implementation, Rollout, upgrade, Development activities.
- SAP R/3, ECC from 3.x to ECC 6.0 version experience, BI 3.x to 7.4 Version worked including 6 full life-cycle implementation, upgrade and production support.
- SME in Business Requirement analysis, mapping client’s business process to SAP processes, Configuration, Prototyping, Testing, Training, Documentation and Post Go-Live Support. Familiar with agile methodology.
- SAP Release Management - Projects, Weekly & Monthly Release Management task managed with SDLC Process. (Define SDLC process & Implemented)
- Responsible for overall onsite / off shore SAP Managed Service and delivery team.
- Responsible for setting the direction, and managing 15-45+ individual contributors.
- Responsible for SLA’s - Development - Jobs - Release management etc.
- In depth knowledge of Project Management, Agile Methodology, Risk Management, Implementation Methodologies, Business Process reengineering as well as sound understanding of Overall Business intelligence, ECC Functional Area SD, PM, PP, Vistex, MM, FI, Archival, BPC, Business Objects.
- Hands on work experience in Upgrade, SP Implementation, SAP Note implementation, working with SAP raising OSS messages, Technical work, enhancements, ECC archiving, mergers, new implementations.
- Experience in preparation of documentation that includes area of course design, evaluation, training materials and providing End user Training.
- Have strong interpersonal skills with the ability to interact with end-users, managers, technical personnel, etc. Excellent work ethics and team oriented with strong analytical and leadership qualities.
CORE COMPETENCIES:
- SAP BW HANA - SLT, Business Intelligence and Data Analytics
- SAP BPC / EPM reporting Admin & security, SAP Basis for BI platform.
- Service Oriented Enterprise Architect Management
- Solution Implementation and Delivery
- IT Systems Migrations/Integration
- Project Management including resources and time.
- Database Archival
- Hand on SAP Environment.
- SAP Performance Management.
TECHNICAL SKILLS:
SAP: SAP BW 3.x To 7.4, BPC 10.1, BO 4.2, ETL Process, SAP R/3 & ECC EHP 6.0 with all Modules, HANA, CRM, EWM, Solmon, GRC
SAP Reporting: WEBI, BO Universe base reporting for BPC, BEX, Dash Board
Project Management: Microsoft Project, Microsoft Office, Visio
SAP Language: ABAP
SKILLS:
- SAP BI/BW 7.4-7.5 On HANA, 3.x to 7.30
- SAP HANA DB Migration
- SAP ECC 6.0 (S/4 has overview knowledge)
- SAP BO 4.2, 4.3 & Data Service
- SAP EWM & CRM
- SAP ECC Archival
- SAP BPC 10.1 / EPM / BPC Security
- Redwood / UC4 Job Scheduling System
- Service Now / JIRA
- SAP Solmon CHARM Process
EXPERIENCE:
Confidential, Cleveland, OH
SAP BI - BPC Architect / Admin
Responsibilities:
- Development of SAP HANA Calculation views on top of ADSO’s and stacked calculation views
- Use of star joins for master data, Left, right and Temporal joins, unions and rank node to meet business requirements.
- Use of Calculated, restricted columns, Counter, Currency conversion in HANA views.
- Performance tuning of Hana view using plan visualizer and use of SQL scripted HANA views for complex scenarios.
- Consume HANA views in BOBJ webi tool and Analysis for office.
- SLT set up with ECC & Non SAP source system for get data Applied.com website.
- New Implementation of SAP BW 7.3 and also worked on 7.4 Upgrade SP13 & HANA DB Migration and 7.5 BW upgrade in course of 2.5 years down the line.
- Conversion of traditional BW models to HANA optimize models.
- Build ECC Custom Extractor, ABAP enhancement with complex logic, Installed Standard extractor with enhancement Extractor set up for Purchasing, Inventory, SD, Billing, Vistex & Delivery area. Enhancement with in BW transformations, lookup routine enhancement & use of complex ABAP logic for enhancement. AIT has complex report called MC295 which combines data from most SAP modules (AR, GL, Inventory, Purchasing, Sales, Billing, Delivery). This data has to be aggregated and displayed in Report it has executed monthly after books closure and report output drivers various business functions including corporate decision making.
- Designed complex models to supply data to corporate website (Applied.com) by combining data from various sources such as non-SAP SQL Server and SAP HANA Database. Models are built in HANA to pick this data in real time from Non-SAP and combine with SAP HANA data.
- Predictive analysis is used on this data to predict sales and inventory trends.
- Implementation of Daily sales Dash Board in Business objects using data from traditional BW models. Also converted this to source from SAP HANA after HANA go-live. This benefited business to track real time sales at a glance.
- Designed BO Universes based and HANA based reports, without compromising on performance.
- Part of BO 4.0 new Implementation, BOBJ 4.2 SP03 Upgrade. Currently working on 4.3 upgrade.
- Recently implemented BPC 10.1 Phase 1 Reporting (Eliminated Non-SAP HOST system) & Consolidation. Responsible for initial Configuration task & BPC system setup, BPC security, Defining BPC Rules with transformation & Non-SAP AIT subsidiary location Consolidation data automated updated in BPC via PI interface. (Manual Work eliminated).
- Worked on BPC Performance management, FI super users training on books close and security setup. BPC Back up export /Import restore in Non-Production environment after each month book close. Always sync QA with Production BPC environment.
- Built a custom ABAP program to easily administer BPC system. BPC Z ABAP Program help too quick reach UJ* Transaction Codes and makes it easy for BPC administration.
- AIT Oil & Gas non-SAP company migration into ECC/BW.
- AIT MSS Company SAP 4.7 Version Migration in AIT ECC EHP 6.0 & SAP BW 7.4 /BODS/BO 4.2 used for reporting with complex requirement.
- AIT ECC Archival blue Print kept ready with Business Process area wise.
- Solution Manager upgraded after set up BW area in Solmon for monitor System growth and disk management. using Salmon form Admin work.
- Worked with Basis team set up and testing of GRC to implement Fire fighter process in BW Production system.
- EWM-HANA implementation with BW HANA Reporting. Rolling out EWM- HANA Location by Location.
- AIT Release management successfully managed without any Defects in Production. Always made sure to check all SDLC process & validate impact, transport & performance. Worked with Basis team during Production releases.
- Monitor Nightly batch jobs to complete as per SLA and without Violating SOX team. We have 0% Failure Target & 100% SLA time line achieve.
- Manage SAP Service Delivery Team. Drive/Support large multi-million-dollar implementation pursuits within cross disciplinary teams
- Responsible for the technical execution of an SAP support rollout. Responsibilities include planning, launching the technical team during the planning phase and managing the day to day operations during the execution phase of the project.
- Responsible and in charge for SAP support roll-out with a globally distributed team of 30 resources including offshore team. Work with project teams of 20 resources (company, client and third-party resources) across all phases of the project & Support life cycle (Management) to support over 5,000+ users.
- Lead multiple SAP client service delivery teams in the active execution of engagements in compliance with firm and practice unit service delivery standards. Advocate and enforce applicable SAP standards, policies, procedures, and best practices.
- Being an architect/Admin responsible to DRIVE deliverables - not just report and track them.
- Expert and responsible for transforming business needs in to requirements, which ultimately to translates in to SAP functional and technical requirements.
- Work with the Architect and establish sustainable and measurable internal standardization programs that drive increased on time/budget delivery results.
- Develop and document project design requirements for scalability, reliability, reusability, security and adherence to architectural standards. Help PM on master project plans and risk mitigation plans (Management).
- Deliver the SAP core application design on time with high quality and on budget. Ensure effective communication and interaction with key associates involved in the delivery of the SAP solution
- Follow IT development standards where applicable by developing and communicating middleware based EAI architecture, strategies, guidelines, standards and best practices
- Provide technical SAP product expertise, advises on potential risk and risk management.
Confidential, San Diego, CA
SAP BI Architect
Responsibilities:
- HD Supply - Facility & Maintenance Implemented new ECC / BW/CRM/BPC. I worked as consultant through L&T Infotech for this project responsible for implementation, testing and Production Support. I was Project manager managed Confidential team & BI Architect responsible all Development & Hands on Task day to day from onsite.
- All most 5+ Years worked in HDS- FM San Diego managed Project work with Hands on highly satisfied Customer.
- 24x7 Support provided without any violation SLA.
- BI Complex Requirement satisfied to Sales Team & Finance Team. Examples - Project to cut down costs of mailing Product catalog Every Year to each customer. This project combines Customer master data and customer sales data to determine eligible customer for full catalog which will save company huge costs in sending catalog to every customer.
- SAP Solmon CHARM Process define with SDLC HDS Process. This project Confidential onsite Consultant implemented with help SAP ECC/BI/CRM/Sales Force team. We did configuration / Testing etc. CHARM process helped cutdown Release management time & Manual Task.
- SAP BW 7.0, 7.3 Implemented & Upgraded.
- Implemented BPC 5.5 for 1st time and upgraded to BPC 10.0 over cause of time.
- BO 4.0 Implemented with BWA.
- Before I left from HDS FM project implemented SAP HANA 1.0. HANA was released in 2012. (We did Comparison & POC work BWA Vs HANA 1.0)
- I have Hands on SAP BW all Functionality with ABAP part & interface. (EX- Sales Force System interface with ECC & BW for Project System Modules)
- Hands on expert Development, Requirement Gathering from Business, Report development, System Performance, Upgrade with SPAU fix & Testing, Support pack implementation with SAP OSS task.
- SAP BW 7.3 upgrade & Linux migration successfully completed with Parallel N+1 landscape. (Managed LO Delta in Both system parallel)
- SAP CRM-BW complex functionality Customer Segmentation & Territory Management successfully implemented with custom design & standard design combination as per business expectation.
- Corrective steps taken for improve data load time / Report performance/data modeling architect.
- BEX broadcast reports & WebI report set up with Users security roles.
- Performed and created test scenario’s and test scripts. SAP testing HP QC.
- Provided SAP Services at least 5 years’ experience working in AMS projects.
- Trained employees and users on onsite/offshore model, managing complex SAP Support projects.
- Collaboratively working with SAP ECC 6.0 with SD/LE/FI/CO/MM/BI/BPC Security and Basis.
Confidential, Phoenix-Chandler
SAP BI Architect
Responsibilities:
- Provided 6+ years of all Level SAP Support, Implement in SAP BI / Teradata area.
- Extensive business application troubleshooting experience.
- Confidential & Confidential business spin off time build new System BI for both business in short time line. This task is so critical because of Global company & large business in Semiconductor.
- Performed multiple SAP ECC/BI Upgrade / Rollout/New functionality Implemented in Freescale environment.
- Good overall understanding of SAP functionality/technology in any or all of the following areas:
- I was key resource in SAP BI team due to worked in Freescale longest 6+ years managed successfully BI intelligence.
- Hand on BI Development /upgrade/Rollout during this 6 Years project.
- Never missed SLA Violation. (as per contract 50K charge per violation)
Confidential
SAP Functional Lead
Responsibilities:
- SAP new released R/3 Product in 1995-96. I was part of SAP R/3 implementation team in largest Textile industries with complex requirement. (My starting Career in SAP-1995-1996 Years)
- SAP & PWC SAP partner for implementation project but unable to map complex Business textile process in SAP. I was part of team from Arvind Mills brief business process & successfully implemented SAP PP/PM/MM/FI-CO.
- I learn SAP during this project after implemented SAP PM modules.
- After some time, day to day disk growth I was involved in SAP Archival task. R/3 3.x version SAP archival not proper given functionality. I have built Z module for Archival. I have archived 800 GB data in System from PP, CO, FI, MM, SD.
- Given hands on training to shop floor workers & super power Users related SAP activity.
- Involved Rollout task in other Company location.
- This is 1st Textile Project for SAP after launch R/3 product. We have worked so hard make success this implementation.
- Create strategic best practices for use among the team
- Analyzed the user requirements, design and writing detailed functional specs & Technical specs.
- Responsible for Production support task & Roll out.
- Configured the PP/PM/MM module by setting up the overall organization structure design, document types, item categories, master data, usage of condition step, copy control of sales document types to billing and delivery documents.
- Responsible for creating Blue Print document. Worked together with Programmers and the Project Coordination Team to ensure the clients' business needs have been met
- Gathered requirements and created functional specifications for, interfaces and enhancements. Configured prototype for PP/PM/MM module based on business requirements.
- Managed LSMW-legacy data conversion from the old database and facilitated User Acceptance testing of the new system.