SUMMARY:

• SAP Certified Consultant with over 12 years of experience consulting in Pharmaceutical/Medical, Automotive, Technology, Oil & Gas, Consumer Products, Manufacturing, Heavy Machinery, Aerospace & Defense, Retail and Telecom Industries
• 12 years of combined End to End experience as a Solutions Architect leading Large BI Implementation teams and coordinating onshore/offshore resources from reviewing functional requirements, model design to backend and frontend development, testing, deployment and documentation
• Hands on project experience configuration of SAP Confidential Data Models (Attribute View, Analytic View, and Calculation View) and row level data security
• Specialized in data warehouse solutions, data delivery, master data, SAP best practices, ASAP methodology, ABAP, SAP Reporting and ERP tools across multi - operational environments including Oracle, Teradata, MS SQL server, BODS, Informatica, SAP BW 7.3, SAP Confidential and a host of proprietary wireless industry applications
• Possess strong functional business process knowledge of FI/CO, Sales & Distribution, Material Management, Inventory, Purchasing and Supply Chain Management
• Possess strong functional business process knowledge of Order to Cash (OTC) and Procure to Pay (PTP)
• Demonstrated experience in translating business challenges into business requirements including designing, developing and implementing complex SAP BW, Business Objects and SAP Confidential solutions
• Hands-on experience in providing Solution Performance analysis, application tuning and facilitating Super User trainings to leverage new and existing BI solutions
• Experienced in providing project planning inputs, including tasks, durations, dependencies, and multi-tasking to manage multiple assignments with multiple priorities to meet concurrent deliverable deadlines
• Hands on experience in interacting with senior IT and Business Resources; working across business and technology teams to ensure alignment between business solution definition & systems architecture
• Demonstrated ability to effectively document, track, and deliver Business Requirements, Functional Specifications, Technical Specifications, design issues and resolutions
• Strong Production Support experience including Functional Analysis and Technical Troubleshooting at excellent Customer Satisfaction Level
• Excellent leadership, communication, and soft skills with the ability to deliver relevant, organized, intuitive, and knowledge-appropriate presentations, trainings and solution recommendations across diverse technical and business audiences

TECHNICAL SKILLS:

BI/BW: BI 7.3, 7.0, 3.5, 3.2, 3.1C, 3.0B, 3.0A

SAP R/3: ECC 6.0, ECC 5.0,ECC 5.0,4.7,4.6C, 4.5B, 4.0B

SAP Modules: Confidential, SD, MM

Confidential: Confidential XI 3.x, Confidential 4.0, Universe Design Tool, Information Design tool

Reporting Tools: Query Designer, BEx Analyzer, BEx Web, Web Intelligence, Dashboard design, Crystal report, Business Objects Explorer, Analysis for Office

Database: Oracle 10g, SQL server, MS Access, Teradata and DB2

Operating Systems: UNIX, Windows XP/2000/2003/NT 4.0/98/95

Languages: C, C++, VB, SQL, ABAP/4

Applications/Programs: MS Office, MS Visio, MS Power Point, MS SharePoint, HP Quality Center, BMC Remedy Action Request System version 7.1 SAP

AREAS OF EXPERTISE:

SAP BI (BW 7.3, BI 7.0, BW 3.X):

• 10 years of demonstrated hands-on experience as an SAP BW Lead Consultant and Developer/Analyst with focus on business process improvements in SD, MM, Purchasing, Inventory Management, CO-PA, FI/CO modules and post-production support
• 5 full life cycle implementations with BI upgrade experience from BW 3.5 to BI 7.0 and BW 7.01 to BW 7.3. Extensive knowledge of SAP Confidential 3.1, 4.0 Modeling, System Administration, Security, Configuration, Business Content delivery and Reporting
• Extensive experience in design, development, test and implementation of suitable system configurations, reports, program codes, and application of technical understanding to very complex technical IT solutions using SAP ECC 6.0 / SAP R3 4.6, Business Explorer Suite, Data Warehousing Workbench /AWB and other relevant software applications
• Expertise in front-end Business Warehouse tools for creating consolidated income statement and Balance Sheet, Profit in Inventory, Investment in Subs, Cash flow report and various automated validation and reconciliation reports

SAP:

• Over 4 years of experience implementing SAP Confidential (Webi, Xcelsius/Dashboard, Explorer, Crystal Reports, IDT) including a thorough Knowledge of Business Objects integration with SAP BW in Confidential 3.x and 4.0 environments
• Strong in Webi report development, Advanced Analysis for Office & OLAP, design and development of Universes
• Strong, hands on Confidential technical knowledge with Business Object Suite - Universe Design Tool, Webi and Xcelsius/Dashboard design
• Strong Confidential modeling experience, expert knowledge in resolving loop related issues on the Universes, and ability to resolve the Performance Issues related to Business Objects Reports

SAP:

• Over 4 years hands-on live project experience implementing SAP Confidential Solution and performance optimization
• Experienced in SAP Confidential Data Provisioning via SLT, SAP (Native) Confidential modeling, Data Modeling using Attribute View, Analytic View, and Calculation View, and programming including SQL and SQL Script
• Experienced in SAP Confidential Administration including managing schemas, data model objects, import/export content and SAP Confidential Security including User Management, Roles, and Privilege
• SAP Finance and Cost Accounting Confidential modeling. Delivered reporting over SAP Finance and Cost Accounting modules
• Experienced in SAP ECC table data model and analysis and integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration, etc.

SAP:

• 8 years of Functional/technical expertise in implementing SAP Confidential solution in BW. Configuring General Ledger (GL), Profit Center Accounting (PCA), Cost Center Accounting (CCA), Profitability Analysis (COPA), AR/AP and financial reconciliation reporting solutions

SAP:

• 10 years functional/technical implementation of SAP Confidential solution in BW. Configuring Sales & Distribution, Material Management, Inventory Management and purchasing reporting solutions. Experiences encompass both delivered and custom content from requirement gathering to reporting and stabilization post-go live

PROFESSIONAL EXPERIENCE:

Confidential

SAP Developer

Responsibilities:

• Environment: SAP Confidential 1.x; SAP BW 7.4 on Confidential ; SAP BODS 4.2; SAP ECC 6.0; SQL Server 2016; SSAS
• Solution: SAP Confidential Migration
• Solution Detail: Migrated SAP BW FI reports to Native Confidential leveraging SLT & in memory capabilities
• Implemented ML Accelerator to improve ML data load performance to SAP BW
• Migrated CO reporting data to SAP Confidential
• Built Calculation views over tables
• Created SQL Views over tables/Calculation views as a service layer
• Consumed Confidential Catalog SQL views via BODS to land data to SQL Server environment
• Migrated GL reporting data to SAP Confidential
• Built Calculation views over tables
• Created SQL Views over tables/Calculation views as a service layer
• Consumed Confidential Catalog SQL views via BODS to land data to SQL Server environment
• Migrated COPA reporting data to Confidential
• Built Calculation views over tables
• Created SQL Views over tables/Calculation views as a service layer
• Consumed Confidential Catalog SQL views via BODS to land data to SQL Server environment
• Used SAP Data Services (BODS) to batch load data into SQL Server environment
• Exported data to AWS S3 EC2 instance via SAP BODS to support external data consumption
• Modeled Fact and dimension tables in SQL Server to support BI reporting
• Built Stored Procedures to enhance and transform data in Confidential and SQL Server environments
• Designed and built Semantic layers in SQL Server as an abstraction over physical tables
• Built SSAS Tabular Cubes to support in-memory BI reporting
• Supported Pivot table reporting and Power BI Dashboarding
• Supported report roll out and user support

Confidential,Dallas, TX

SAP BW/EWM Consultant

Responsibilities:

• Environment: SAP BW 7.4; EWM 9.4; Confidential 7.14; SAP Confidential 4.3; SAP ECC 6.0
• Solution: Reporting solution for SAP EWM
• Solution Detail: This is a green field reporting effort for EWM. Client installed, configured SAP EWM and need visibility into the efficiency of their warehouse management processing.
• Configured EWM datasource application component for BW
• Determined the required delivered content for BI reporting
• Configured Update Mode for BW
• Activated pertinent business content
• Setup activation of BW update for Push enabled datasources
• Activated SID updates for BW in EWM
• Developed process chain to automate EWM data load.
• Delivered business content reports
• Worked with business to understand business content reports
• Worked with business to create requirement to enhance business content reports
• Worked with functional SME to write functional spec for custom EWM reports
• Developed custom EWM reports
• Testing
• Deployment
• Training
• Post Production Support

Confidential, Houston, TX

SAP BW/ Solution Architect

Responsibilities:

Environment: SAP BW 7.4; SAP Confidential 4.1; SAP ECC 6.0 (EAM/LAM; SRM; FICO)

• Solution: Reporting solution for SAP EAM/LAM & SRM
• Solution Detail: This was a Greenfield SAP BW/ Confidential implementation. I led the effort in enterprise-wide BI implementation for EAM and SRM reporting.
• Led BI Blueprinting sessions
• Lead requirement workshops
• Delivered Design documentation
• Developed over 30 reports
• Testing
• Deployment
• Training
• Production support

Confidential, Chicago, IL

SAP BW Solution Architect

Responsibilities:

• Environment: SAP BW 7.0, SAP ECC 6.0
• Solution: SAP Project Systems
• Solution Detail: Review and enhancement of clients Project Systems reports
• Enhanced critical Project systems masters such as 0WBS ELEMT, 0PROJECT.
• Redesigned Project systems datasources and dataflow to improve load performance
• Reviewed and enhanced project system datasources to meet reporting requirements
• Impact analysis and redesign of existing dataflow and process chains to improve load performance
• Delivered SAP BW cutover plan

Confidential, Houston, TX

SAP BW Solution Architect

Responsibilities:

• Environment: SAP BW 7.3, SAP ECC 6.0
• Solution: SAP FI/AR implementation; SAP RAR ( Revenue accounting & reporting)
• Solution Detail: Implemented AR reporting to support Credit and Cash management
• Implemented SAP FI/AR solution to support customer payment analysis and cash management
• Implemented Open A/R reporting to improve client’s receivable analysis/collection process
• Improved client’s visibility into FI A/R Lockbox processing
• Improved visibility into statutes (“On Account”, “Applied”, “Unprocessed”) of received payments for more detailed analysis of Cash application
• Provided detail payment report tracing Original invoice to received payments taking into account partial payment and residual payment scenarios
• Implemented detailed customer invoice payments report to show customer payments history and pattern for better analysis of customer account value. Customer line item/open item management

Confidential, Chicago, IL

SAP BW Solution Architect

Responsibilities:

• Environment: SAP BW 7.3, SAP ECC 6.0
• Solution: SAP BPC implementation support
• Solution Detail: Support BPC implementation, Production support and process improvement
• Supported SAP BPC implementation
• Implemented Account Based COPA to support BPC implementation
• Led migration of BPC components across landscapes
• Enhanced Costing based COPA
• Implemented Technical Content to support SAP BW administration
• Improved load performance by implementing pseudo deltas
• Implemented trigger based Process chains to improve load performance
• Redesigned process chain to improve load sequence and time

Confidential, San Francisco

SAP BW/SPM Solution Architect

Responsibilities:

• Environment: SAP BW 7.3, SAP ECC 6.0, SPM 3.0, BODS
• Solution: System analysis and improvement
• Solution Detail: System enhancement and process improvement
• Help client optimize SAP SPM implementation
• Improve system performance and data reliability
• Increase user adoption to realize return on investment
• Drive SAP SPM implementation to maturity
• Engaged with stakeholders to understand and document SPM pain points
• Documented issues, risk/impacts and provided recommendation options to management
• Worked with PMO team to work up list of requirements for immediate implementation to improve overall system performance and usability
• Rationalization and prioritization of requirement list for phased delivery
• Hands-on implementation of approved phased enhancements
• Device methodology to measure and improve quality of data accuracy to achieve data maturity
• Identify root cause through SPM analytics to drive procurement process improvement
• Designed a process to define and measure data accuracy across multiple business units
• Designed a closed feedback loop process to enhance improve data accuracy
• Designed data quality reporting process to gain visibility within the organization
• Proffer best practice solution options to management to enable corrective action decision making
• Identified gaps in existing sets of SPM analytic reports required to improve efficiency of spend
• Worked with procurement financial analysts to identify means to report spend saving opportunity
• Designed and built reports to measure approved spend compliance
• Designed and built reports to measure data quality improvement
• Documentation and training of users on new enhancements

Confidential, Houston, Tx

Sr. BW Solution Architect

Responsibilities:

• Environment: SAP BW 7.3, SAP ECC 6.0, Confidential 4.0, BODS
• Solution: Subsea Division Joint Venture reporting
• Solution Detail: Supply chain and financial reporting for new subsea division
• Led the delivery of Supply Chain Management solution comprising of Inventory management, Procurement and Logistics reporting
• Engaged with business users and functional SMEs to elicit and clarify requirements and work up functional documentation feasible for reporting
• End to end SAP BW design, development and deployment on BW 7.3 platform
• Delivered high visibility Vendor performance reporting on multiple reporting platforms helping client rate and improve vendor performance
• Implemented Accounts payable financial reporting to help analyze and improve account payable processing using Vendor Invoice Management data
• Actualized SRM (SUS) reporting on external supplier self-service tool utilization to monitor and improve positioning of clients’ supplier self-service tool
• Implemented Purchase Price Variance (PPV) reporting to help client reduce cost and maximize spend with most optimized vendor
• Accomplished delivery of Open Purchase Order Rescheduling analytical reporting to improve MRP scheduling thereby improving manufacturing SLA
• Realized the implementation of Valuated Stock Current vs. Previous Month trend reporting to improve material utilization at various plants/storage locations
• Mentorship and knowledge transfer to mid-level developers
• Post-production support

Confidentia, Marlton, NJ

Lead SAP Solution Architect

Responsibilities:

• Environment: SAP BW 7.3, SAP ECC 6.0, Confidential 4.0, SAP Confidential
• Solution: SAP Confidential ; SAP FICO Reporting
• Solution Detail: Created better-performing versions of existing ECC reports (Financial Special Ledger and Project System reports) and creation of MRP Exception Analytics
• Led review of existing ECC reports for conversion to Confidential
• Identified related ECC tables required for modeling and reporting
• Configured SLT via LTR and replicated required purchasing tables to Confidential
• Created and Managed SLT data provisioning in Confidential
• Created BODS ODP Datastore (connection) to ERP 6 system
• Created BODS dataflow and loaded 0FI GL 10 data to Confidential via template table
• Setup BODS batch job to extract 0FI GL 10 data in Change Data Capture (CDC) mode
• Reviewed and deconstructed ECC ABAP code to understand existing ECC reporting functionality
• Identified redundancy in existing ECC solution and worked with functional team to clarify requirement and streamline schema relationships to optimize SAP Confidential modeling
• Redesigned financial reporting against FMUSFGA table (actual line item table)
• Designed and developed information models to support financial close reporting/analytics
• Implemented Confidential modeling comprising 54 high volume ECC tables
• Developed Confidential models (Attribute, Analytic, Calculation) views
• Creation of analytic privileges to manage row level data security
• Developed Calculation views via SQL script to model multiple fact tables COPA plan/actual scenario
• Developed SQL scripts and stored procedures
• Administered SAP Confidential database functions (User creations, Analytic privileges)
• Knowledge transfer to client’s Confidential modelers
• Worked with report developer to deliver financial reporting on Crystal reports
• Coordination of user acceptance testing
• Maintained Schema Mapping to facilitate migration of objects across landscape
• Creation and transport of packages across landscapes

Confidential - San Francisco

Sr. BW Solution Architect

Responsibilities:

• Environment: SAP BW 7.3, SAP ECC 6.0, Confidential 4.0, BODS
• Solution: Subsea Division (Cameron/Schlumberger) Joint Venture impact analysis
• Solution: SAP BW/BEx, Web intelligence and Dashboard design enhancement
• Led joint venture impact analysis of Cameron Subsea division
• Assisted client in the Identification, documentation and modification of impacted enterprise structure objects to facilitate undisrupted go forward operation post JV completion
• Provided Enhancement to existing Data Warehouse structure and reporting objects (BEx Queries, IDT universes, Webi reports, Dashboards and authorization objects)
• Led effort in Identification and remediation of impacted codes within SAP BW warehouse and SAP ECC source system extractor codes
• Analysis authorization impact analysis and change recommendations based on employee carve-out
• Led end to end testing scenario documentation and process

Confidential

Sr. BW/ Solution Architect

Responsibilities:

• Environment: Netweaver ABAP & JAVA stack, SAP BW 7.3, SAP ECC 6.0, SAP Confidential, Oracle, Informatica, Confidential 4.0, BODS, MS SQL Server and Teradata
• Solution: Subscriber and Subscriber SKF reporting
• Solution: Marketing Analytics (SAP Confidential ) pilot, Confidential 4.0., Web intelligence, Dashboard design
• Solution: Migration of SAP BW 7.3 Database to SAP Confidential IMDB for Financial Reporting POC
• Engineered BI Enterprise Data Warehouse solutions within a mixed platform environment
• Led architecture and design decisions for SAP Confidential and BI implementations
• Led pilot implementation of SAP Confidential agile datamart pilot for marketing analytics
• Led phase2 SAP Confidential enhancement implementation on marketing analytics agile datamart
• Hands-on configuration of SAP Confidential Data Models (Attribute View, Analytic View, and Calculation View) and row level data security
• Served as Lead Architect leveraging extensive knowledge of Business Objects 4.0
• Designed, developed and implemented solution strategies for SAP Confidential technologies
• Handled integration between multiple systems for enterprise-wide BI reporting
• Leveraged data from multiple sources to provide near real-time marketing analytics on Confidential platform
• Designed and developed IDT UNX Universe leveraging Confidential data models
• Designed and developed dashboard and Webi reports based on SAP Confidential data
• Configured Business Objects Explorer to leverage SAP Confidential for data exploration
• Managed multi-discipline resource teams within high visibility projects
• Designed SAP BW Architectural solutions and managed the development process
• Managed SAP BW development, testing and post-production support
• Performed Performance tuning based on design best practices
• Coordinated SAP BW 7.3 technical upgrade with SAP Basis
• Involved in planning of SAP BW 7.3 on Confidential POC
• Migrated SAP BW 7.3 Database to SAP Confidential IMDB
• Migrated standard DSOs and Cubes to In-Memory DSOs and Cubes
• Led SAP BW 7.3 on Confidential reporting POC to Accounting business group
• Facilitated design sessions to develop detail technical BI solutions
• Provided and managed project schedules to meet project deliverable timelines
• Tracked project deliverables and reviewed requirements with project stakeholders
• Managed a team of developers and interacted with multiple functional groups to understand and document business requirements, architect technical solutions, and delivered BI solutions
• Enforced workflow standards in Architecture and development by developing technical strategy, tactical plan, and documentation templates for implementing data and information delivery solutions
• Provided team and technical leadership for data and system architecture, and delivered custom software applications in a high pressure environment
• Delivered Architectural Solution Documents (ASD) and Contextual Architectural Documents (CAD) for non-SAP solutions and Data flow diagram, InfoProvider schema design and report designs for SAP BW
• Designed and Developed Business Objects Universe and provided maintenance and support tasks
• Addressed business intelligence initiatives from a data delivery/presentation perspective
• Provided consultation on SAP Confidential reporting, Dashboard design and development
• Designed and developed in Business Objects Information Design Tool (Universes)
• Designed, developed and maintained IDT OLAP and Relational universes
• Developed BICS connection in Confidential 4.0 Information Design Tool (Universes)
• Developed complex dashboards using flash Variables, Open Doc, and Query Browser
• Developed Crystal reports leveraging Query Browser

Confidential

Lead BW/SPM/ Solution Architect

Responsibilities:

• Environment: Netweaver ABAP & JAVA stack, SAP BW 7.01, SAP ECC 6.0, SAP SPM 2.1 SP7, SPM 3.0, B1 4.0
• Solution: Spend Performance Management - Procurement reporting
• Solution: Web Intelligence design/development and Dashboard Design for mobile device
• Led reporting requirements gathering sessions with client
• Designed, Developed, tested, and deployed Business Objects dashboards and Webi
• Developed SAP Confidential 4.0 dashboard using SAP BW as a data source
• Configured Business Objects Explorer to consume SAP BW data models
• Developed BICS connection in Confidential 4.0 Information Design Tool (Universes)
• Worked collaboratively with users during system testing and deployment
• Delivered Spend performance Management solution to business users, giving insight into the organizations global spend
• Delivered SAP SPM solution based on Contracting, Order Purchasing and Invoicing business processes
• Trained users to utilize new SPM reporting functionalities
• Managed daily calls and issues tracking/resolution with SAP
• Enhanced delivered SPM datasources using ABAP to meet customer requirements
• Enhanced delivered functionality of SPM reporting
• Created Master Data generic datasources to enhance reporting functionality
• Designed and built custom reports which were not delivered by SAP
• Enhanced delivered reports to meet customer's unique reporting requirement
• Modified existing SPM BEx queries to achieve customer’s specific reporting requirements
• Helped client rebuild SPM solution in a newly upgraded BW system after enhancement pack upgrade
• Worked on a Distributed Dual-Stack (ABAP +JAVA) System
• Enhancement pack upgrade - dual maintenance mode support
• Performed Unit testing, integration testing and coordinated UAT with business stakeholders
• Performed data validation and data lineage mapping
• Led Post production stabilization/support