PROFESSIONAL SUMMARY:

• 9+ years’ IT experience and 4+ years’ experience designing and implementing BW solutions for the following SAP modules: BW, Manufacturing, Procurement, Logistics & Distribution, Production Planning, APO
• Experienced in hands - on designing, building and supporting data modeling, data flow diagram, and multi-dimensional data models, data sources, info providers, Info packages and transformation.
• Experienced with SAP ABAP, SAP Standard Extractors, SAP BW Accelerators, SAP BODS, BEx, BW objects, SAP BW development within BW platform.
• Develop functional specifications, test proposed solutions and document the resolution Strong hands on configuration experience on SAP BW&BI/BO/ABAP and SAP - HANA.
• Good Exposure on all areas of BI which includes ETL, creating Info packages, Scheduling, Monitoring, Process Chains, BEx- Analyzer, BEx Query and Web Application Designer.
• Created Generic datasources, table views, and replicating them to BW system
• Strong Knowledge of SAP BW/BI with extensive experience with Requirements Gathering, Scenario testing, Writing Functional Specifications, creating training material and knowledge transfer to client, experience on SDLC & ITIL methodologies, extraction, modeling, reporting, and Performance Tuning.
• Strong Knowledge of SAP FI with extensive experience with Requirements Gathering, Scenario testing, Writing Functional Specifications, creating training material and knowledge transfer to client.
• Extensive knowledge of business process design, applications systems analysis, requirements gathering, drive change management, and project management.
• Configured and wrote functional specifications in areas of Accounts Payable outgoing payments and Accounts Receivable incoming payments.
• Acted as liaison between implementation teams and business partners while driving process change and enabling technology solutions, worked with the business to test and document the workflow solution for future upgrades.
• Experienced on (SAP-BOBJ) creating the univers, Xcelsius reports, Crystal Reports and Webi with the help of SAP BW Query and SAP ERP using BW and publish the reports in business objects.
• Strong understanding of OLAP database (especially dimensional and 3NF) structures, theories, principles, and practices.
• Experience in driving best practices, design patterns and reference implementations for SAP BW and demonstrate creative ideas in solving business opportunities.
• Experienced in complex projects on BW data architecture, multidimensional modeling, BI trends and best practices in the marketplace.
• Involved in developing Infobjects, Transformations, DTP’s, DSO’s, and Info cubes.
• Involved in maintenance and creation of SAP BW/BI and BW 7.4, objects as per Business requirements.
• Hands on Experience and Technical Proficiency in Data Extraction, Data Loading, Delta Management, Data Modeling, Info objects, DSO Object (Standard and Write-optimized), Info Cube, Multi-Providers and infosets and BEx Analyzer.
• Expert in working with Lo-Cockpit extraction and Generic extraction using with Tables and Views, also worked on Lo and Non-Lo Data Source Enhancements.
• Involved in solving performance-related issues for query performance and data loading performance by using indexes, compression, aggregates, partitioning the Info Cube, using ABAP Routine and Functional module, and Data Source Enhancement Variables.
• Able to implement FICO solutions including design, testing and support to meet business needs and/or corporate strategy.
• Guiding and applying architectural and SAP best practices to design, development and ensure it meets operational requirements, such as scalable, maintainable and manageable, secured, reliable and available.
• Assume accountability and ownership of SAP FI platform, deliverables, development, development plan, and application maintenance, configuration/ Implementation of SAP FI and Control.
• Develop functional specifications, test proposed solutions and document the resolution Strong hands on configuration experience on SAP FI.
• Configured, customized and test SAP modules as well as implement new developments and production support for AP, AR, GL, SL, FA, CM, Tax, and MM modules along with Treasury transaction manager
• Configure and maintain SAP Cash applications include setting up house bank, handling various payment formats such as wire, ACH, positive payee, check, electronic bank statement, lockbox.  Configure and support FSCM Treasury transaction management in order to handle various treasury instruments, product types, transaction types, flow types, and release procedures for creation and working of treasury Instruments.
• FI Analyst responsible for setting up the Organizational Structure updates.
• Engages in daily production support in FI and assisting with the resolution of various SAP FI issues after go live.
• Provides FI functional and configuration support focusing in areas of Accounts Payable (Automatic Payment Program, Check Management) and Accounts Receivable.
• Configures banking solutions for client's bank accounts such as payment methods, bank determination, house banks, check configuration, outgoing payments, down payments, positive pay file, cashed check file, ACH, bank reconciliation, cash journals.
• Validates and documents existing AR/AP business process procedures and recommended process improvements where applicable.
• Able to implement and lead SAP BW solutions including design, coding, testing and support to meet business needs and/or corporate strategy.
• Guiding and applying architectural and SAP best practices to design, development and ensure it meets operational requirements, such as scalable, maintainable and manageable, secured, reliable and available.
• Knowledge of safety related legislative requirements of the Oil & Gas industry
• Assume accountability and ownership of SAP BW platform, deliverables, development, development plan, and application maintenance.
• Define, own and implement SAP BW, data modeling and BOBJ standards.
• Worked on Money Market instruments and FX instruments, AR and AP - Configuration of Master data, business transactions, dunning /payment processes in AR/AP.
• Configures solutions for Accounts Receivable such as payment terms, reason codes, accounts for payment differences, dunning procedures, FI integration, provided post go-live support and issue resolution.
• Communicates with business users on a bi-weekly basis to gather requirements, mapped the requirements to business scenarios and developed the design documents during the initial stages of the implementation.
• Responsible for tracking changes to the Chart of Accounts and maintain the different clients in sync
• Ability to balance between strategic design vs tactical needs and ability to prioritize and execute quick proof of concepts.

SOFTWARE SKILLS:

Languages: HTML, PL/SQL, SQL, XML

Reporting tools: SQL server 2005/2008 R2 SSAS/SSRS/SSIS, Crystal Reports, Dashboards, Tableau, SAP BO, SAP HANA, SAP BW

SAP /BI Packages: SAP BW 3.5, BI 7.0, BI 7.3, 7.4, SAP- BI 4.1, SAP- R/3 & SAP ECC 6.0. BEx Explorer, WAD, BOXI 3.1, R2 (Xcelsius, Crystal, Webi), SAP Financial Accounting with ERP 6.0 EhP6, SAP- R/3 & SAP ECC 6.0, BW on HANA SP6, HANA Studio SAP Financial Accounting with ERP 6.0 EhP6, SAP Business Objects, Design Studio

Databases: MS Access, SQL Server 2008, ORACLE 10g

RDBMS: MS Access, SAP HANA, OLAP, Multidimensional, Star-Schema

Office Application: MS-Word, Advanced Excel, PowerPoint, and Access, Outlook, and Suse Linux Open source application, Office 365

Operating Software: Windows, Linux/Unix, Mac OS, IOS

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, TX

SAP BI/BW Consultant

Responsibilities:

• Extensively involved in extraction of data by customizing predefined extract structures (LO Cockpit) and Generic Data Sources.
• In Logistic Extraction Cockpit: Maintained extract structures for CRM and Sales & Distribution.
• Involved in extracting data from SAP R/3 by generating Generic Data Sources (Tables/Views).
• Worked with functional consultant for mapping the source data (R3/non R3) to target Data Sources in BI.
• Created Info Objects, Info Sources, ODS objects, Info Cubes, Multi Providers, Info Sets, Update rules, and Transfer rules.
• Proficient in filling the setup tables and maintaining the delta update methods.
• Good Knowledge on queued delta, un-serialized and direct delta methods, loaded the data from R/3 to BW
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing.
• Monitoring of the process chains and analyzing the reasons for the frequent failures of the processes.
• Created custom info objects, characteristics and key figures. Involved in creation of custom Info areas, Info Cubes.
• Used generic extraction (RSO2) to extract data from SAP R/3 to BW.
• Activated Business content according to Functional requirements.
• Worked on various Sources related to SD, MM and FI.
• Designed, developing and implementing data warehouse using SAP BI with ECC.
• Designed custom Info Cubes & Managed DSO object & Info-Cubes.
• Used LO Cockpit to activate and load transaction data from the Sales header and item detail & Data extraction from flat files for Mater data and Transactional data.
• Mapped R/3 fields to BI Info objects in transformations.
• Created Custom Info object catalogues for Characteristics and Key Figures for the Sales Info area.
• Worked on business content extractors.
• Extracted and loaded data from SAP R/3 into Custom Sales Info Cube using Data Sources 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 13 VDHDR and 2LIS 13 VDITM.
• Enhanced the data sources by adding the required additional fields in ECC and mapped the same with corresponding newly created Info objects on BI side.
• Created many basic Info Cubes, created Info Sources, created Data Sources, replicated Data Sources, and loaded Master Data from flat files and from OLTP, Multi providers and DSO objects.
• Extractions - Extracted data from Logistics SD and Flat File.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using LO Cockpit by using enhancement.
• Created Generic Data Sources with Delta based and Involved in solving performance-related issues by applying Partitioning and Compression etc.

Environment: SAP BW 7.4, Business Objects 4.0 Web Intelligence, Xcelsius, Crystal Reports, Data Integrator, and Windows NT.

Confidential, Garland, TX

SAP FICO Consultant

Responsibilities:

• Actively worked with finance business resources to determine the technical solution that best meets the business requirements, including but not limited to: Fixed assets, Accounts Payable, Accounts Receivable, General Ledger, Product Costing, Project Systems, executive controls, treasury and Cash Forecasting, investment management, Profitability Analysis and interfaces to MES and third party subsystems.
• Proactively addressed continuous improvement requests and drives them to completion.
• Demonstrated the ability to independently gather business requirements, design technical solution and implement solution, either alone or by coordinating with other IT and business resources.
• Consistently demonstrated initiative to acquire and utilize new technical skills within job function.
• Consistently achieved target dates for assigned tasks aiding in on budget delivery of the project.
• Delivered technical solutions that meet Business Requirements, IT technical standards and is sustainable in the planned productive environment.
• Addressed production support tickets within FI/CO domain according to service level agreements with business.
• Extensively worked on creation and monitoring of the process chains.
• Extensively worked on Ticket handling and solving the errors.
• Managed data loading with both full update and delta management, also scheduling and monitoring.
• Configures new company codes and maintained cost centers/profit centers in SAP.
• Provides daily production support for customizing/process change and break-fix issues.
• Lead research and make recommendations on data warehouse products, services, and standards in support of procurement and development efforts.
• Coordinate user support efforts and crafts solutions to complex and re-occurring problem.
• Maintained and enhanced cost center hierarchy to meet business requirements
• Used project management practices and tools to provide tracking information
• Performed PHA studies such as HAZOP/HAZID/LOPA/What-IF analysis
• Knowledge of safety related legislative requirements of the Oil & Gas industry

Environment: BW 7.0/7.4, SAP HANA 1.0, Business Objects 4.1, FI, Bex Analyzer, Universe, Web Intelligence Reports.

Confidential, TX

SAP BW/HANA Consultant

Responsibilities:

• Facilitated requirements gathering and reconciliation of data definitions with business and IT experts. 
• Played a Lead role for onshore and offshore. 
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View. 
• Worked as Senior SAP BW Consultant and was responsible for Implementation, Upgrade, support, and maintenance of two BW systems. 
• Migration of Cubes & DSO as Hana optimized. 
• Involved in Planning, Migration, Pre and Post Migration activities, Testing and issue resolution. 
• Developed HANA dataflow objects (Composite Provider, Advance Data Store Objects etc.) .
• Development of Info cubes, Multi Providers, Data Store Objects (DSO), Transformations, DTP’s, and Info packages as per the technical specifications. 
• Involved in daily Monitoring and support of BW system.
• Create Start Routines, Field level Routines, End routines and Formulas in Transformations. 
• Create the process chains to load Daily deltas from SAP for Master and Transaction Data and automated the same. 
• Requirements Analysis for new enhancements in BW. 
• Maintaining Reconciliations to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Transport the objects across the landscape and resolving of issues faced during the transports. 
• Cutover activities like Object Testing, Business functionality test, Regression testing in the QA. 
• Support of bug fixes and issues reported. 
• Extensive experience working with Tableau Software as a dashboard developer, Architect and SME .
• Created and developed Tableau data visualization reports for KPI’s. 
• Defined best practices for Tableau report development. 
• Data Visualization and Analytical professional using Tableau.
• Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards. 
• Define specification, design and build of Tableau Desktop reports and dashboards.
• Installation, set up and administration of Tableau Server
• Training designers, analysts and end users in Tableau Desktop and Tableau Server.

Environment: SAP BW 7.3, Design Studio 1.1&1.2, Business Objects 4.0 Web Intelligence, Xcelsius, Crystal Reports, Data Integrator, and Windows NT.

Confidential, Houston, TX

SAP BW /HANA Consultant

Responsibilities:

• Facilitate requirements gathering and reconciliation of data definitions with business and IT experts.
• Playing a Lead role for onshore and offshore. 
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View. 
• Data provisioning using SAP Landscape Transformation and SAP Data services.
• Evaluate the information gathered from multiple sources, reconcile conflicts, and decompose high level information.
• Understanding, distinguish presented user requests from underlying true needs and distinguish solution ideas from requirements. 
• Prepare requirements documents to be used as the basis for project development.
• Leading Onshore and Offshore teams.
• Test final output based on requirements and business needs.
• Coordinate with global IT and Business teams to deliver the requirements.
• Worked as Tableau architect in standardizing Tableau for enterprise wide deployment. 
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server in Dev, QA, UAT and Prod environments. 
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine. 
• Administered user, user groups, and scheduled instances for reports in Tableau. 
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules on Tableau server. 
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development. 

Confidential, Prairie View, TX

Graduate Research Assistant

Responsibilities:

• Performed bi-weekly system application upgrades in the College of Business computer labs.
• Tutored undergraduate students in finance and MIS; assist students in comprehending SAP course material to increase student performance.
• Assisted professors with research related to teaching SAP courses as a school curriculum and work papers.
• Provided efficient backup service; followed up queries to resolve problems effectively.
• Tracked issues raised and all leads and produced reports on all variables and operations.
• Built and maintained client relationships and internal communication flows between faculty members and ITS on PVAMU SAP projects from development all through implementation and support.
• Assisted in developing improved processes within this function and the rest of the Faculty members.
• Escalated all issues that can't be solved at Faculty level to appropriate department and also follow up on such cases.
• Worked very well on high, medium and low priority tickets.
• Involved in monitoring and production support.
• Monitored Daily Chains, Weekly Chains, Monthly Chains.
• Raised tickets to other resolution groups regarding performance of the system and data loads.
• Reloaded the data requests from PSA in case of data load failure.
• Involved in rolling up data to aggregates and compression of the cubes.
• Monitored of Info packages and analyzing the reasons for frequent failures of Info packages.
• Found the root cause for the Errors of the chains if they have not started in time.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction loads.
• Maintained Reconciliation’s to verify the data in SAP R/3 and SAP BI are same or not after the data loads.
• Maintained history for the tickets until they are closed.
• Schedule data loads into BI from R/3 involving full, initial delta loads & delta loads.

Environment: BW 7.0, Business Objects, CRM, Bex Analyzer, Universe, Web Intelligence Reports, Crystal Reports.

Confidential

Business Analyst/ Business Process Unit

Responsibilities:

• Performed data and file processing for ongoing activities and assisted with resolution of participant issues including the timely and complete close out of participant cases.
• Created and maintained complete and accurate Processing Guides for all assigned deliverables 
• Researched and analyzed issues and cases (using SQL, Excel, Crystal Reports, etc.) putting in place solutions to address root cause with the intent to reduce ongoing case volume and effectively prevent reoccurring system issues for the whole Bank.
• Responded to day to day client and/or Business Unit inquiries and communications.
• Worked closely with the Business Process teams (Consumer, Business, Corporate, and IT Service Center) to deliver quality results of ancillary services.
• Leveraged technology to automate ongoing processes and create the most efficient and stable delivery of services to clients/Business units. 
• Analyzed and understood system requirements for the execution of implementation and ongoing work (i.e., is expert in aligned client requirements)
• Created, executed, and maintained accurate and detailed test plans (unit, function, integration, and regression) for all new system application functionality testing
• Assisted clients in reducing risks to personnel and to the facility by giving them engineering driven solutions
• Involved in identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Regularly interacted with onshore and offshore teams to communicate requirements and review test cases and test plans.
• Used Mercury Quality Center to look up defects and issues raised by testing activities.
• Documented all the Detailed Design and Business Rules in Detailed Design Document.
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using MS Visio
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS)
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Created use case scenarios and documented work flow and business process using MS Visio
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Gathered and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Produced and managed documentation on release activities to support problem resolution.
• Responsible for Knowledge Transfer (KT) sessions of the project to the Production Support Team.
• Created Scope document, Project Request Form, Project Closure Form and secure signoff from project sponsor and other key stakeholders
• Created and reviewed Scope document, Project Request Form (Scope Document), Design documents, Requirements Analysis Specifications and Project Closure Form with project lead, Business owners and the Technical lead.
• Performed Data mapping, logical data modeling, created class diagrams, Activity diagrams, and ER diagrams and used SQL queries to filter data

Environment: MS Project, MS Visio, MS Office Suite (Word, Excel, Power Point, Outlook), Java, Agile, Kanban, SharePoint, UML