SUMMARY:

• Around 7 plus years of Professional expertise in SAP including SAP PP and Manufacturing, SAP MDM, Data Migration and IT consulting. 
• Experience in implementing, configuring, integrating, testing, customizing, and providing user training and support in SAP Financial Accounting (FI) and Controlling (CO) modules. 
• Extensive BI Experience using Tableau 7.0/8.0 and SSRS. ETL experience using SSIS and DB experience on SQL Server, Oracle, MySQL, DB2. 
• Hands - on experience on writing functional specs and working with developers on the same.
• Experience in building SQL Queries, Creating sub queries, minus, union, inline queries and performance tuning of SQL (DB2 and Oracle).
• Experience in tools like Spreadsheet Modeling, SPSS, Tableau, Crystal Reports, Xcelsius, Web Intelligence, Business Objects, SAP HANA, SAS, and BEx Analyzer 
• Experience in designing, creating, and implementing Crystal Reports using Crystal Report software (Scorecard, SLAs, Historical, Trends, Daily).
• Involved in creating the Crystal Reports Repository Library (Central Depository for Coding Reference). 
• Proficient in Data Consolidation, Master Data Harmonization and Central Master Data Maintenance scenarios.
• Experienced in developing testing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL. 
• Experience in developing custom application to generate and distribute SAP Information Steward failed data report via email with excel attachments.
• Good understanding of the full lifecycle implementation - right from the conception stage to go live and support activity.
• Extensive experience in SAP MDM 5.5 and SAP MDM 7.1 - Data Manager, Import Manager and Syndicator. 
• Extensive experience in maintaining the Customer Master, Material Master and Vendor Master repositories in MDM.
• Performed data cleansing activities by identifying duplicates using Match and Merge strategy in Data Manager.
• Responsible for creation and linkage of product hierarchy in data manager.
• Experienced in writing test cases set up test data and execute test cases.
• Performed various kinds of testing activities on SAP ECC, SAP MDM tools and SAP Enterprise Portal.
• Researched and analyzed data for quality check to ensure that the global standards are met.
• Created ad-hoc reports for the upper level management using Stored Procedures and MS SQL Server Reporting Services (SSRS) following the business requirements. 
• Proficient ECC material master, LSMW and MDM extraction programs from ECC. 
• Worked as an MDM technical support team member to resolve issues and handle errors faced by the end users on a day-to-day basis.
• Performed various data comparison activities by extracting data from both ECC and MDM to fix any data synch issues that may exist between both the systems.
• Worked as an MDM global Business Process Analyst ensuring the smooth flow of business activities for Asia pacific region. 
• Involved in different phases of life cycle implementation using ASAP methodology AS-IS study, Fit-GAP analysis, TO-BE process, troubleshooting Production Support and End-user training.
• Experience with various Software Development Life Cycle (SDLC) Methodologies such as AGILE (Scrum), Iterative & Incremental Development, RUP Iterative, and Waterfall Model. 
• Proficient in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.  
• Experience in conducting successful brainstorming sessions, and preparing surveys and questionnaires. 
• Experience in conducting Joint Application Development (JAD) sessions with end users, Tech Leads, developments and testing teams for conflict resolution. 
• Skilled in business process analysis (use case, user experience design, storyboards, wireframes, user profiles and user stories) and mapping (gap analysis) techniques, conducting Joint Application Development Sessions, SWOT analysis, Cost Benefit analysis and ROI analysis. 
• Extensive experience in creating detailed Business Requirements Document (BRD), Functional Requirements Document (FRD), Web Services and APIs Documentation and User Interface Document (UID).

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Business System Analyst

Responsibilities:

• Worked as a Master Data Management implementation project and playing key role in Design, Build and Deployment phases. 
• Understanding business processes and establishing processes for creation/update of Master Data for various domains (Material, Customer and Vendor) and regular maintenance/harmonization of master data to support business. 
• Understanding Business entities and validating out of the box data model. Configuring data model to meet business needs. 
• Interacted with Clients and stakeholders in gathering requirements for the Oracle MDM data feeds and designing the data model.
• Analyzed, designed and Implemented the placement of data quality checks in the Channel Management Pipeline using SAP Information Steward comparing data quality and correctness between of data in SAP and Teradata based warehouse.
• Involved in creating dashboards and reports in Tableau BI and Maintaining server activities, user activity, and customized views on Server Analysis and perform load testing.
• Involved in configuration of SLT Server, monitoring the data loads form ECC to SAP HANA DB.
• Developed Crystal Reports for Customer service/ Claims, Finance, enrollment departments. 
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment. 
• Setting up out of the box system and configuring it to meet business needs. Setting up data quality rules processes and validations/assignments for clean master data. 
• Expertise of SAP MDM components like MDM server, Console, Data Manager, Import Manager and Syndicator. 
• Experience on SAP modules such as Product, Material, Vendor, Customer master.
• Good real time knowledge of configuring Remote system/Ports, Import and Syndication Maps, Workflows, Validations & Assignments. 
• Experience on MDM Inbound/Outbound data flow and configuration and Integration with PI and ECC.
• Designed and created system Test plans, Test script preparation.
• Involved Unit Testing, Defect management, System integration testing and User acceptance testing.
• Coordinated with users during UAT.
• Prepared user training documents and training users on various master data creation/maintenance processes. 
• Coordinated with Data/ETL team and building strategies to Extract, Transform and Load data. Good exposure to ETL processes and tools like Informatica Power center, SAPBODS.   

Confidential, NY

Business System Analyst

Responsibilities:

• Developed several SQL queries to understand the data and data-relationships. 
• Experience in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and translating them into functional specifications.
• Skilled in Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, Sequence Diagrams, Unified Modeling Language (UML) using MS Visio and Enterprise Architecture.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files. 
• Worked Extensively with SSRS reports and Crystal Report to create various reports for SQL Server. 
• Quality Assurance experience in creating test plans and test scripts, reviewing test cases, and validating and monitoring defects using various defect tracking tools.
• Wrote SQL queries to simulate complex business scenarios during analysis and design of Information Steward and BODS programs.
• Strong testing experience in performing Functional Testing, Smoke Testing, Regression Testing, Progression Testing and User Acceptance Testing (UAT). 
• Expert in creating, managing and tracking Requirements Traceability Matrix (RTM). 
• Involved in implementation, customization, testing and configuration of SAP ERP 6.0. Worked on integration of FI with SD (Sales & Distribution) and MM (Materials Management) in Procure to Pay (PTP) & Order to Cash (OTC) cycle.
• Worked on merging data from SAP BW to SAP HANA (mixed scenarios), by consuming HANA.
• Strong knowledge and hands-on experience in SQL and Relational Databases. 
• Knowledge and hands-on experience in Java, HTML, CSS, XML.
• Good understanding of the Object Oriented Analysis (OOA) concepts.
• Experience working on SQL tables, creating and executing queries.
• Involved in Purging the SOI server if message were not moving through PI/PO (Putty and SQL server)
• Responsible for the preparation of Project Charter, Business Requirements, the Detail Informatica ETL mapping specifications document, project planning, testing, implementation and post-implementation activities. 
• Involved in execution of R8 and R9 reports through Oracle SQL developer. 
• Worked in environments adhering to Generally Accepted Accounting Principles (GAAP) and Sarbanes Oxley (SOX) compliance. 
• Functional specification for Customized Reports, LSMW for conversion and transfer of master and transactional data from legacy to SAP system. 
• Experience in developing interfaces using EDI and ALE.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Accomplished business analysis skills and an understanding of the software development life cycle (SDLC) specializing in Traceability across all levels of projects.
• Involved in documenting the Test Plans, and Test Cases for the User Acceptance Testing (UAT).
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, Test Plans and Test Cases.
• Coordinated with business users to prepare, update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
• Expert in creating UML Diagrams including Use Cases, Activity Diagrams, Flow charts, Sequence Diagrams, Collaboration Diagrams and Data Flow Diagrams using MS Visio.
• Worked with data reporting tools, Business Intelligence tools, Cognos 10, Crystal Report. 
• Wrote and executed SQL queries to verify data in the reporting system and used Tableau to generate reports. 
• Involved in reviewing test procedures, defining test cases, reviewing and maintaining test scripts, analyzing bugs and User Acceptance Testing (UAT).
• Expertise in assisting Testing teams with Test Plans, Test Cases and Test Scenarios, and manage defects using various Defect Tracking Systems.
• Experience in building SQL Queries, Creating sub queries, minus, union, inline queries and performance tuning of SQL (DB2 and Oracle).
• Involved in developing the data quality rules to find out data anomalies and missing data using IDQ tool.
• Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP). 
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. 
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment. 
• Wrote and executed system test plans, test cases and test data on MS Excel for the web-based application.
• Proficient in SQL queries with a good understanding of data analysis and management using different tools.
• Initiated departmental procedures to increase awareness and use of SAP among cash application and collection team.   
• Proficient in writing SQL queries for testing and data validation.