Sap Data Migration Consultant Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Over 20+ years of SAP ECC technology wif 14 years in BI and a proven track record for leveraging technology for business. Dedicated to maintaining a reputation built on quality, service, and uncompromising ethics. Building successes every day wif vision & attention to details. To obtain teh position of IT leader and utilize my skills in data compilation and interpretation to help teh organization achieve their long term and short - term goals. Providing strategic leadership and direction for teh adoption of Functional and Enterprise Analytics and Business Intelligence-related practices and technology. This breadth as well as depth of experience enables me to lead all aspects of business and technology projects wif firsTEMPthand extensive experience implementing BI
- 10 years of SAP Business Object 4.3, BPC 7.5 and 10.0 NW, and development of Webi reports, Planning Input Schedules, Dashboards, and latest HANA
- 20+ Years of SAP Global Rollout
- 10 years of Project Management and supervisory experience in Information Technology
- Business Knowledge of SAP MM, PP, SD, Service, FI/CO, HR, SCM, APO, and CRM
- Industry experience includes: Automotive, Manufacturing, Pharmaceutical, Utilities, Public sector, Healthcare, and Food/Beverages. Clients include Toyota - TMHU, Advanced Medical Optics (AMO), Confidential, NASA, COKE, Pioneer Electronics, Callaway Golf, HP-Agilent, Trader Joe’s, State of California, and most recent Actavis/Allergan
TECHNICAL SKILLS
- Business Intelligence
- SAP FICO, SFIN
- Program / Project Management
- Master Data Governance
- Vendor Development
- Resource Planning
- Financial Sales and Forecasting Planning
- Contract Negotiation
- Off-shore / On-shore sourcing
PROFESSIONAL EXPERIENCE
Confidential
SAP Data Migration Consultant
Responsibilities:
- Ensure successful migration of data from legacy systems to SAP, extraction, transformation and loading teh data directly from and to various systems like SAP ECC, SAP BW, SQL, and flat files.
- Involved in end - to-end implementations from requirement gathering and involved filling teh GAP analysis, design and development, testing, go-live and post -production support phases.
- Legacy Data migration lead for Logistic (PO), FICO, and Sales dat
- HANA Team Lead wif 8 Developers in producing Government Pricing restatement project for 80+ analysts following major acquisitions by Actavis
- Design, Develop and Architect teh SAP Hana and SAP Business suite solutions for BI needs from end to end activities including:
- Lead Corporate Planning implementation (BPC 10.0 NW) which covered Corporate Planning - Full P/&L. Roles included leading, configured, and performance related issues of Input Schedules, Reports and also other areas like script logic, and BPF etc. which is present in teh OPEX planning application
Confidential
BI Solution Architect (FTE)
Responsibilities:
- SAP BI Architect for Confidential, USA (TMHU) unit and Dealers Network reporting project, including SAP BW/SAP BO 4.0 system implementation and SAP HANA/BW
- Built and managed BI Strategy, Metrics and Reporting Team organization
- Lead and created SAP CRM Opportunity using (0CRM OPPT H & 0CRM OPPT ITM) extractors.
- Aligned CRM ODS to Business Partner Relation (0BP REL) to ensure adequate security control
- Created Sales Analytics by enabling extractors 2LIS 11 VAHDR and 2LIS 13 VDITM etc.
- Worked extensively on information design tool, creating multisource universe, data foundation, and business layer to achieve unique security requirement for Toyota
- Contributed significantly to WEBI report using custom LOV, navigation path (hierarchy in 3.1), and all latest features of SAP BO 4.0
- Lead and developed 6 highly customized Xcelsiusdashboard wif SAP BO 4.0 for Toyota’s customer and dealers; created directly from BEX queries and universe
- Contributed to various WEBI reports using calculation contexts, applying almost every available formatting feature, ranking, sorting, breaks, prompts, sub-queries, data tracking, Alert, creating complex formulas/variables, projecting charts, cross tab reports, drill down reports
- Successfully Implemented HANA/BW solution while upgrading BW 7.0 to 7.3 and then 7.4Lead and configured over 72 Webi reports, 16 Universes (IDT), 4 dashboards (Xcelsius) wif BOBJ 4.0 and 4.1 version
- Lead a team of 4 in providing IPad mobile reporting wif Webi and limited Design Studio.
- Lead and configured BOBJ 4.0 Webi using Information Design Tool and BICs connector (BEX).
- Responsible and implemented Sales Forecasting, Demand Planning, Financial, and Production capacity planning using SAP and non-SAP contents i.e., (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04).
- Developed over 60 BW reports for Voice of Customers (External Survey Tool) using CRM Marketing and Activity Info areas
- Managed upgrade project from 3.5 to NW 2004S technology, which contributed increase of usages for CRM and Fleet Analytics. Teh new features (printing, drag drop, conditional) enable dealers and corporate analysts’ ease of data slicing and reporting
- Collaborated wif Audit in aligning SAP security wif Sarbanes-Oxley controls to ensure BI compliance wif Separation of Duties (SOD)
- Finance team lead and configured sFIN New Asset Accounting, Procurement to Pay and Universal Ledger design.
- Team Lead and configured BPC-Embedded planning and forecasting for Cost Center and Profit Center Accounting.
- Team Lead and responsible for Cashflow Indirect Statement and Liquidity Forecasting
- Legacy Data migration lead for Logistic (PO), FICO, and Sales data
- Team lead in data migration from acquired dealership into SAP system
- Responsible for BI 7.4 upgrade to HANA/BW project execution through defined processes for all of teh following dimensions of project management: Scope, Schedule, Resources, Financial, Status, Risks, Issues, Quality, Governance, Supplier. Defined, documented and instituted these processes to manage projects in a disciplined manner
- Developed custom information flow model including new info-cubes to process logistics sales order item, and header (2LIS 11 VAITM), to order item ODS (0SD O01). Data passed to Advance Planning and Optimizer (APO) demand planning cube for further planning and simulation. End-to-end information flow from R/3 to BI to APO, including master data and transactional data
- Consulted IT Demand Planning managers in all facets of daily operations; monitor of planning forecast workbook, identifying process improvements, and resolved BI reporting performances issues
- Provided and Monitored development of data model to satisfy various functional requirements by implementing queries and cubes using standard business content. Main cubes developed are Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04) Purchasing Data (0PUR C01) and Vendor
Confidential
FICO Master Data Lead
Responsibilities:
- Design architect on master data elements for all areas of FICO
- Integration lead for Logistics, Finance, Materials Management, and Sales & Distribution function arears
- Coordinate and lead development team including offshore resources to drive development activities through design review, code inspection, unit test, system integration test, and go-live cutover
- Developed functional specifications for offshore ABAP development
- Developed Master Data Management strategy for future phases wif integration to CRM (Retail & POS), APO and BI
- Project management member in addressing integration issues wif other functional areas
- Performed as Integration manager, provided communication, and manage expectations from IBM to NASA’s middle management
- Managed sustainment and provided BI project support wif 3IBM consultants and 3 contractors for NASA’s 16 agencies
- Lead and configured BI/ SEM BPS 16 web folders, 14 cubes, over 20 different fox codes. Data included Fund Programs and Fund Center
- Provided HR/BI integration wif BPS - headcount, organization hierarchy, and workflow
- Responsible for creating guidelines and checklist as a mean of knowledge transfer to teh client and provided “best practice” guidance on how to best design data model and its information flow
Confidential .
BI/FICO Team Lead
Responsibilities:
- Managed daily production and executed daily production issues for Finance and BW functional issues
- Responsible for developing Customer P&L in conjunction working business units to streamline their processes so dat reports can be derived and generate automatically. These reports provided several KPIs and important measures in determining incentive program for top tier customer classification
- Development team member of 18 web and excel layouts, 35 Planning Functions, and 20 departmental P&L reports. These reports were teh foundation for generating management cockpit and dashboard
- Lead architect and developer in designing Executive Management Reporting, which provided Top customer gross profit, top sales classification, sales compare to multiple goals.
- Developed Process Chain to extract master and transaction data from R/3, Hyperion, and non-SAP systems
- Lead developer for maintaining BI Queries wif complicated calculated key figures, cell definition, and performance tuning (iView Reporting Agent etc.)
- Provided FI/CO functional and configuration expertise focusing in areas of Asset Management, FI/GL, COPA, CCA and PCA
- Configured Credit Management and payment term
- Responsible for updating Tax condition procedures for Sales & Used tax for SD and AP. Taxes were calculated using VERTEX
- Served as FI/CO/AA/JVA/ and FERC Senior consultant. Project scope included FI/CO/AM/PS/PM/HR and MM modules
- Configured Internal Orders, Cost Centers Accounting, Profit Center, Controlling Probability, and CCA allocation for various clients ranging from 200 million to 10 billion annual sales
- Performed all facets of configuration and documentations for areas of CO-Internal Orders, CCA, HR (CATS), and PCA
- Created and executed unit and integration testing plans for AR, AP, Credit, Joint Venture Accounting, and most of Controlling modules
