Sap Sr Bw/bi Analyst/architect Resume
Roswell, GA
SUMMARY:
- Experience includes rapidly learning and applying new technologies, and supervising and training personnel.
- Strengths include oral and written communication, attention to detail, and gaining results.
- Extensive functional and technical expertise with strengths in project management, SAP HANA, BPC on S/4HANA, SAP BI/BW 7.5/Business Objects Web Intelligence (BOBJ 4.2) reporting solutions, and SAP ERP/ECC.
- Experience includes successfully architecting, configuring, and implementing SAP BI/BW 7.5/BOBJ 4.2, SAP HANA, BPC on S/4HANA, and SAP ERP/ECC FICO solutions for global organizations in several industries including automotive, chemicals, consumer products, and healthcare/pharmaceutical.
- Over 15 years of SAP functional and technical experience including BI/BW 7.5/BOBJ 4.2, BPC on S/4HANA, FICO, FSCM, MM, SD, SAP HCM Travel & Expense(T&E), HP ALM, and Solution Manager.
- Core strengths include business systems analysis, data transformation, designing and developing reporting solutions, solid understanding of financial accounting and accounting principles, SAP/BOBJ/BW/HANA security, process transformation, and training.
EXPERIENCE:
Confidential, Roswell, GA
SAP Sr BW/BI Analyst/Architect
Responsibilities:
- Currently implementing BPC on S/4HANA, developed calculation views, over 50 queries, and working closely with the functional team to deploy a country of sale solution for processing 80 million monthly line items.
- Currently using Tableau to develop views and dashboards with both SAP data and data from other sources.
- Recently implemented BW 7.5 on HANA and BOBJ 4.2 by performing system sizing and validation, resolving post DMO issues including ETL and Webi reporting, and working closely with the business users
- Recently developed and implemented a custom SAP HCM T&E Expense reporting global solution that combines T&E data, Credit Card receipts, and SAP workflow data into custom BOBJ Webi reports.
- Successfully deployed two major projects to design and implement new FIGL and FICO InfoCubes that contain over one billion records and improves reporting performance by over 97% and increases end - user satisfaction.
- Recently completed S4F80(SAP BPC optimized for SAP S/4HANA), HA350, HA250, HA150, HA400, and BW362 BW on HANA instructor-led training courses along with openSAP SAP BW powered by SAP HANA, BI 4 Platform Innovation and Implementation, S/4HANA - Deep Dive courses.
- Participating in strategic planning for business intelligence solutions including HANA by providing recommendations, analysis, and direction for SAP BW/BOBJ Solutions.
- Responsibilities includes designing, developing, and supporting the SAP BW/BOBJ solution including InfoObjects, InfoCubes, DSO Objects, DataSources, InfoSources, DTPs, and Transformations.
- Creating OLAP connections using the BOBJ Central Management Console (CMC) to deploy SAP Business Objects Webi reports that meet Sarbanes-Oxley (SOX) compliance.
- Project leader and hands-on to successfully implement a project leveraging BI content to create and implement a global reporting solution with 29 BOBJ Webi reports using data from ECC 6.0 SAP Collections and Dispute Management (FSCM) to improve cash flow and customer relations.
- Design, developed, and deployed BOBJ Web Intelligence (Webi) reports for global requisition to pay (RTR) users.
- Using SAP Solution Manager to monitor and alert users when there are BW ETL/process chain issues.
- Establishing and maintaining effective communication with Functional Team Managers by keeping them informed of project status, accomplishments, issues, and defect resolution.
- Utilizing HP Application Lifecycle Management (ALM) to effectively manage BW/BOBJ defects and projects.
Confidential, Atlanta, GA
Sr. Financial Systems Analyst
Responsibilities:
- Designed and developed BW BEx A/R queries that led to significant month-end closing improvements through time savings and enhanced data analysis.
- Designed and implemented daily foreign exchange rate upload process into SAP ECC 6.0 that was 100% automated and totally eliminated costly errors caused by manual updates. Created custom query in SAP that calculated the average exchange rate used for various financial processes and reporting requirements.
- Hands-on project leader implementing a robust BW reporting solution for SAP Collections Management (FIN-FSCM-COL) that increased cash flow and improved visibility to accounts receivable data from ECC 6.0.
- Developed detailed BW BEx A/R queries used by the treasury department to forecast anticipated cash flow from customers.
- Developed and presented BW training to end-users to increase usage and understanding of new and existing BEx queries included Web reporting.
- Responsibilities also included troubleshooting FI/CO issues, loading and maintaining A/P, A/R, and GL Workflow master data using LSMW, recommending solutions for improving month-end closing, and resolving issues.
Confidential, Smyrna, GA
Sr. Financial Systems Analyst and BW Team Lead
Responsibilities:
- Won approval and was the project manager responsible for completing successful and on-time implementation of BI 7.02. Received special recognition award from CIO for my hands-on role and the tasks I completed for this project.
- Developed and modified BW InfoSpokes and BI Open Hubs to extract customer invoices and sales orders, inventory data, master data, product costing, and purchasing history to Cognos BI 10.
- Created and maintained data objects for BI/BW 7.02 reporting structures including, but not limited to DSO objects, InfoObjects, InfoCubes, InfoProviders, Extractors, Transformations, Process Chains, Open Hub, and BEx queries.
- Coordinated with global team members resolve issues, processed change requests, and implemented enhancements for SAP BW 3.5/BI 7.02 and SAP modules including FI, CO, MM, and SD.
- Managed IT projects to completion on-time and within budget while ensuring compliance with IT Change Control Procedures. Proactive in avoiding potential problems and reducing risks.
- Change control experience in a FDA regulated environment.
- Created detailed requirements and developed BEx queries or ABAP programs to extract data from SAP R/3 to support global shared services implementation and working capital initiatives. Received special recognition for my role in these projects.
- Received special recognition for my role in a SAP data center project that saved over $1million in annual operating costs.
- Developed functional and technical specifications from user requirements and then configure the BW or SAP R/3 system or create the reports/queries, document the changes, test the solution, and obtain end user acceptance.
- Performed first and second level support and problem solving for all SAP BI/BW 7.02, FI, CO, MM, and SD customer issues in the Development, QA, and Production SAP R/3 clients.
- Complete understanding of SAP R/3 Security demonstrated by creating and changing User IDs as requested by business owners and assigning users to existing and new security profiles and roles in both SAP R/3 and BW 3.5. Generate transports for security to move profiles and activity groups to the proper clients in compliance with regulatory requirements - including Sarbanes-Oxley (SOX).
Confidential, Atlanta, GA
SAP Database Administrator
Responsibilities:
- Developed and maintained the overall long range project plan for the entire reporting team that includes four analysts and three developers.
- Project manager and web site designer responsible for leading a project team of web developers that transformed SAP data into a dynamic web site used extensively by executives and field service engineers throughout North America to measure continuing quality.
- Worked with a variety of call center systems by providing reports and support to the various call center locations in the U.S.
Confidential, Atlanta, GA
Independent Consultant
Responsibilities:
- Worked closely with configuration teams and subject matter experts to develop instructor led training, web-based help, and job-aids for the CO module and SAP BW.
- Developed training materials using the Business Process Procedures (BPP), AuthorIT, Documentum, InfoPak, and OnDemand to create reusable training objects.
- Provided technical assistance to other team members and resolved technical issues with new, highly integrated training content development tools.
Confidential, Indianapolis, IN
Independent Consultant
Responsibilities:
- Trained the core team instructors (train-the-trainer) that resulted in a successful implementation.
- Coordinated and performed the "pre" and "post" implementation activities for the SAP Knowledge Warehouse 5.2 installation. This is a separate SAP R/3 system that manages a content server with over 300,000 reusable training objects.
Confidential, Atlanta, GA
SAP System Coordinator
Responsibilities:
- Coordinated with the SAP Production Support and Basis Teams to resolve issues, process change requests, and implement enhancements for SAP modules including FI, CO, MM, PP, PS, and SD in release 4.6x.
- Created and maintained IMG projects to configure and test new enhancements in SAP 4.6x for the FI, CO, MM, PP, PS, and SD modules and New Dimension Systems including BW.
- Led a SAP security project to define, test, and implement new security profiles for hundreds of users that clearly defined transport (TMS) activity and sharply decreased configuration issues.
- Developed detailed project plans and coordinated activities associated with support packages, system upgrades, and new functionality implementations that sharply reduced problem tickets and decreased support costs.
- Monitored over 30 SAP 4.6x systems activities including security and system performance, identified problems, and coordinated resolution, which resulted in faster system response time and increased end-user satisfaction.
- Coordinated all globalization activities including successfully converting over 30 SAP R/3 4.6B systems from local time to GMT that resulted in increased efficiency of support team members and reduced maintenance costs.
- Developed, implemented, and maintained the SAP Release Management web site utilizing Macromedia Dreamweaver, Flash, and JavaScript for SAP technical users deployed on the company’s worldwide intranet.
Integration Specialist
Confidential
Responsibilities:
- System administrator of both the Development and Production SAP R/3 Systems that comprise the Knowledge Warehouse 5.x landscape. Planned and coordinated all Basis and system activities including application of support packages, system upgrades, and new Knowledge Warehouse releases.
- Created and maintained all user access security profiles and roles for the Knowledge Warehouse 5.x landscape.
- Developed, implemented, and trained over 100 content developers to utilize the SAP R/3 Knowledge Warehouse.
- Developed and deployed reusable SAP training client strategy to support training activities at all locations globally and reduced system requirements by 33%.
Confidential, Atlanta, GA
Information Technology Manager
Responsibilities:
- Integration Specialist for the team developing SAP R/3 training to support the worldwide implementation of SAP R/3 for the world’s largest soft drink producer.
- Configured the SAP R/3 4.0 CO-CCA Cost Center Hierarchy and CO-PCA Profit Center Hierarchy used for validation sessions in the blueprint phase of the worldwide ERP implementation for the world’s largest soft drink company.
- Designed, developed, and implemented a financial reporting solution for a $5 billion healthcare company (PPM) using the SAP R/3 4.x Report Writer/Report Painter for the Audit and Controller’s Groups. Led to a 50% reduction in the number of days required to complete the month-end closing.
- Led a project with 4 FTE’s to design, develop and implement a client/server reporting solution for the nation’s second largest unemployment insurance firm.
- Developed and presented a SAP R/3 presentation to the selection committee of a $1.5 billion Department of Energy contractor that resulted in a $5-7 million engagement.
Confidential, Baton Rouge, LA
Supervisor
Responsibilities:
- Designed and developed data conversion specifications and programs used to convert legacy systems to SAP R/3 FI environment for all general ledger account transactions and balances that resulted in being able to meet the “go-live” date and achieved significant savings in contractor costs.
- Led a project with 3 FTE’s to develop and implement a PC-based financial reporting solution utilizing legacy system data at a 75% cost savings to the company.
- Designed and developed a SAP R/3 reporting solution for FI A/P and G/L using ABAP/4 Query and Report Writer that eliminated manual reconciliation.
- Developed business process procedures and configured the FI/CO and PS modules for a global SAP implementation.
- Led a project with 3 FTE’s that designed, developed and implemented a SAP R/3 MM Inventory interface.