SUMMARY

• 11 years of IT experience in Business System Analysis and Project management with an exceptional record of delivering cost effective, high performance technology solutions to meet challenges in business process consulting in Manufacturing, Pharmaceuticals, Media & Automotive
• Implementation and Rollout project experience along with profound experience in Support projects.
• Extensive experience in roles such as Project management & Senior Business Analyst with excellent knowledge to the full Product Development Life Cycle with various project management methods, frame works & processes.
• Experience in gathering user requirements, preparing and analyzing Business Requirement Documents (BRD), Functional Requirement Document (FRD), and propose changes as per various internal and external requirements gathered for process improvement.
• Experienced in creating interactive prototypes & UI specifications, including screen layouts, color palettes, typography & user - interface elements.
• Experience in Business process management (BPM), Business process Re-Engineering and process improvement to reduce the wastages in the transaction processes, improve quality, reduce processing cycle time, cut costs, and maximize revenue to the organization
• Experienced in Collecting and collating quantitative and qualitative data to provide analytical support for the development of strategies and projects.
• Worked extensively on performing ‘AS IS’ and ‘To BE’ analysis, GAP analysis Impact Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements and drafted Project Analysis documentations.
• Experience with defining and managing project Cost, Scope, Schedule, and Quality (CSSQ) including developing project budgets, scope statements, resource utilization, resource allocation to the projects, project schedules, agendas for meetings, monthly reports for PMO, and quality standards.
• Experience in working with the cross-functional teams in preparing qualifications, technical responses, and cost estimates in response to Requests for Proposal (RFPs) and evaluating the vendor with various analysis and awarding contract to the correct vendors.
• Extensive experience in developing Business process modeling (BPM), Business process Re-Engineering & process improvement using different methodologies Lean & Six sigma (DIMAC, FMEA).
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions
• Strong understanding of various business intelligent(BI) applications like Tableau, Qlikview, Business objects BI edge & Spot fire
• Leads the business requirement activities necessary to design, develop & maintain data loads, reports, & dashboards for data analysis.
• Extensive experience in managing the master data management (MDM) changes to support the standardization of downstreamprocesses and the migration of multiple enterprise resource planning (ERP) instances to a single global instance.
• Good domain knowledge & experience in Direct & indirect procurement, Material management, spend analysis, strategic sourcing, MDM, vendor management, Procure-to-pay, order management, Order-to-cash, Inventory management, Business Intelligence reporting in Supply Chain Management in Manufacturing, Pharmaceutical, and Automotive domains in B2B environment
• Conducted many Requirement Elicitation Techniques Interviews, workshops & JAD sessions with end-user/clients/stake holders and the development group/s.
• Excellent cross functional Knowledge and integration skills SAP MM-FICO, SD, PP, IM, WM, OTC.
• Effective in executing multiple tasks & assignments ahead of schedule. Strong Image for dedicated teamwork, high energy, work ethics & commitment with capability to handle new technologies & situations.
• Area of Expertise: Software development life cycle Methodologies / Project Management / Change & Release Management /generating RFP’s, RFQ’s / Data Analysis / Data & Business process Modeling / Business process improvement/Testing, six sigma trained and tested.

TECHNICAL SKILLS

Metholodogy: SDLC, RUP, UML, Agile/SCRUM, Waterfall, Lean, Six Sigma

Languages: SQL, C, C++, HTML

Databases: Oracle 9i, SQL Server 2012, MS-ACCESS

ETL: SQL SERVER INTEGRATION SERVICES (SSIS), Informatica

Fault Tracking Tools: HP Quality Center 10.0, HP ALM

Project Management Tools: HP Quality Center, Rational Requisite Pro, Rally, IBM RTC, JIRA

ERP: SAP R/3, SAP ECC 6.0,SAP HANA

Testing Strategies: Integration, Unit, System, Black Box, UAT

Reporting Tool: SAP Business intelligence/Business objects (SAP BOBJ), SSRS

Modeling Tool: MS Visio

Others: Nuv, Macro Objects, MS Project,share point, ServiceNow

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Project Manager

Responsibilities:

• Interact with the business users, project managers, commodity owners and top level management to gather requirements, prioritize work, and develop enhancements to the existing system.
• Responsible for programming project management, project tracking processes for use by advance engineering management.
• Responsible for Gap Analysis and prepared detailed AS-IS Business process and To-Be Business Processes Documentation.
• Understand SAP standard content to satisfy Business requirements, but also possess the capability to enhance/customize where necessary.
• Designed & developed Test Plans, Test cases based on the requirements given by the clients depending on the business model
• Conducted Functional Testing, Regression Testing, and Performance Testing during the various phases of development.
• Responsible for researching, gathering, and compiling data, as well as preparing detailed reports, databases, forecasts, summaries, reporting systems, and approval processes.
• Extensively analyzes internal or external quantitative data and reports, such as results versus budget, results versus plan, sales forecasts, profitability, productivity, project management, product, and industry.
• Responsible for integrating the Project management tool with the project accounting and purchasing.
• Finalizes business plan and mid-term plan by getting top management’s authorization to submit to executive management team.
• Reviews and improves the process to effectively reflect top managements’ policies as well as customer/market status and trends.
• Worked with Project Sponsor and team members to develop a detailed Statement of Work (SOW), Capital Budget, and Project Timeline showing critical path and internal/external customer milestones. Direct all phases of programs/projects from inception to completion. Coordinate problem solving efforts to resolve project issues.
• Continually assess status of critical path activities and project deliverables to proactively identify and mitigate potential risks related to scope, cost, schedule & performance.
• Develop, lead, coach and motivate 15-20 member global teams across functional groups such as engineering, manufacturing, operations, quality, marketing, sourcing, finance, research & development to accomplish key corporate business objectives.
• Deliver monthly presentations on Project Status to Executive Staff including Vice-Presidents, General Managers, Directors, and Senior Managers. Coordinate and execute Phase Exit Reviews (Project Gate Reviews).

Confidential

BI Project lead

Responsibilities:

• Responsible for conducting various requirement gathering sessions for documenting the business processes and efforts estimation for completion of project.
• Conducted JAD/JAR sessions and acted as a liaison between stake holders and technical team, analyzed AS-IS and TO-BE scenarios, prepared storyboards, use-case diagrams for the Procurement analytics.
• Designed and developed the Mock procurement analytical reporting structures and data visualization and presented across the board of executive council.
• Assisted ETL data warehouse and BI teams while generating the reports using business objects and crystal reports and assisted in writing SQL queries
• Developed the Procurement, Inventory management (IM), Production Planning (PP) standard delivered reports using reporting variants.
• Responsible for cleanses and classifies the information, and provides a rich reporting that offers both predefined content and ad hoc analysis capabilities for analyzing all spend data in the Qlik view
• Communicate with internal & external customers to address issues and provide support on data quality and integrity improvements.
• Helped in developing the BI Tableau analytical reports for the Current year, Last year and Plotted a Bar graph to help the users compare the performance of the Business Unit for the last fiscal year with that of the current fiscal year
• Defining the logic for various spend reports based on the historical purchase data, supplier information and supplier performance to identify the spend related insights, evaluate supplier risks, contract performance, saving potentials and the maverick spend on the products.
• Made use of the aggregated tables on the most frequently queried data for Monthly and yearly based BI reports.
• Worked extensively with @functions (@aggregate aware (Aggregate Navigation), @select, @prompt, @where) in the creation of dimensions, measures and conditions in the universe.
• Created hierarchies in the universe for drilling down the data from highest granularity to lowest granularity.
• Created Reports using combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports
• Designed and published visually rich and intuitively interactive Qlikview workbooks and dashboards for executive decision making
• Designed & developed Test Plans, Test cases based on the requirements given by the clients depending on the business model
• Conducted Functional Testing, Regression Testing, and Performance Testing during the various phases of development.
• Performed Unit Testing, Functional Testing, and User Acceptance Testing with various business units.
• Involved in all execution phases such as Pre-Mock, Mock1, Mock2, and Mock3 before implementing the conversion data into live event.
• Designed and developed the training manuals and training sessions for business users.

Confidential

MM Business Analyst

Responsibilities:

• Involved in interacting with business users for requirements gathering and analyzing source data from various business groups.
• Identification of development objects (Reports, Configuration objects etc.,) as required with in-line to existing business process
• Analyze, create and maintain enterprise master data like material master, vendor master, Bill of materials (BOM), customer master supporting supply chain E commerce business process.
• Created user stories, use cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagramsand ER Diagrams.
• Worked on building various functionalities in the supply chain systems to optimize the business processes in Material Management, Purchasing and Inventory Management (IM) that includes Inter Company Stock Transfer Order (STO), Third Party Order, Transfer posting, GR/GI, Invoice Verification, Physical Inventory and Reservations, Warehouse management (WM).
• Responsible for providing the consolidated spending across multiple business dimensions and identify potential for strategic supplier relationships and improved performance.
• Communicate with internal & external customers to address issues and provide support on data quality and integrity improvements.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Model notations (BPMN) using MS Visio.
• Working with the laboratory team in the transformation projects of the lab records into the electronically stored document management system in electronic laboratory notebooks (ELN) comply with the FDA.
• Responsible for cleanses and classifies the information, and provides a rich reporting that offers both predefined content and ad hoc analysis capabilities for analyzing all spend data in the SAP Business objects (BI 4.1)
• Communicate with internal & external customers to address issues and provide support on data quality and integrity improvements.
• Helped in developing the Web intelligent data procurement reports for the Current year, Last year and Plotted a Bar graph to help the users compare the performance of the Business Unit for the last fiscal year with that of the current fiscal year
• Defining the logic for various spend reports based on the historical purchase data, supplier information and supplier performance to identify the spend related insights, evaluate supplier risks, contract performance, saving potentials and the maverick spend on the products
• Made use of the aggregated tables on the most frequently queried data for Monthly and Yearly based BI reports.
• Worked extensively with @functions (@aggregate aware (Aggregate Navigation), @select, @prompt, @where) in the creation of dimensions, measures and conditions in the universe.
• Created hierarchies in the universe for drilling down the data from highest granularity to lowest granularity.
• Created Reports using combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports
• Performed Unit Testing, Functional Testing, & User Acceptance Testing (UAT) with various business units.

Environment: SAP ECC 6.0, SAP BOBJ 4.0 HP ALM 11.0, and Microsoft office suite, SQL Server 2012, Rally, SharePoint 2007, MS Visio and Agile.

Confidential, NY

Lead Business Analyst - Ir

Responsibilities:

• Gathering Business Requirements interacted with the Users, Designers & Developers, Project Manager & SMEs to get a better understanding of the Business Processes, & Analyzed & optimized the process.
• Had an extensive interaction with the offshore teams and various verticals within the organization. Conducted individual and group (JAD) sessions with business and technical units.
• Responsible for translating the business requirements and developing the request for proposal (RFP) and then evaluating the vendor responses and assisting the business in awarding the contract for the right vendors.
• Acted as an interim project manager for a project release. Facilitated daily status call meeting, and lead JAD Sessions involving business, development, and QA teams.
• Worked closely with business units to develop a Business Requirement Document (BRD) and converting them into the functional requirement documents (FRD)
• Gathered requirements from user stories, BR and SR documents in a fast paced Agile Environment and in a test driven development.
• Managed master data management (MDM) changes to support the standardization of downstreamprocesses and the migration of Supply chain instances to a single global instance.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Model notations (BPMN).
• Supported prioritization of initiatives by coordinating with on-site and off-shore team members. Managed the Change request process and analyzed the impact of the change requests on the application in regards to Timelines.
• Extensive use of Soap UI for testing using multiple protocols such as SOAP, REST, HTTP and JMS
• Worked with the technical resources to produce the implementation/deployment plan.
• Provided day-to-day management & leadership to monitor activities between project team & client.
• Provided various demos to Global business teams for new developments
• Completed the training manuals & training sessions for customers

Environment: SAP ECC 6.0, Smart OCI 1.0, HP ALM 11.0, Microsoft office suite, SQL Server 2012, Rally, SharePoint 2007, and Agile.

Confidential, NY

BI Project Lead

Responsibilities:

• Played the BI lead as well as the BI testing role for the complete full life cycle BI Implementation which includes conducting AS-IS & TO-BE sessions, gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, unit testing, trouble-shooting, integration & user acceptance testing, documentation & maintenance.
• Worked with several users to gather requirements & transformed them into a data model using extended star schema concept.
• Work directly with the business & other IT counterparts to prioritize, design, plan, manage, & deliver reporting & analytics solutions
• Designed & planned SDLC in Scrum/Agile methodology using Rally agile software development application.
• Developed various deliverables like BBP, Functional & Technical specs, Data mapping & Data flow documents, Gap & Impact analysis documents, Step by step solution & Transport sequence.
• Worked closely with business units to develop a Business Requirement Document (BRD) and converting them into the functional requirement documents (FRD)
• Responsible for the design & development of the data acquisition process, data mapping with estimate, schedule, design & execute the various reporting projects.
• Developed front-end Business Warehouse Components like Queries, Workbook, Calculated key figures, restricted key figures, variables, exceptions & conditions.
• Helped in creating the tabular models and multidimensional cubes using Analysis Services (SSAS).
• Managed master data management (MDM) changes to support the standardization of downstreamprocesses and the migration of multiple enterprise resource planning (ERP) instances to a single global instance.
• As Lead QA Analyst Designed & developed Test Plans, Test cases based on the requirements given by the clients depending on the business model & conducted Functional Testing, Regression Testing, & Performance Testing, User acceptance testing (UAT) during the variousphases of development.
• Involved in security analysis by checking profiles for end users & reporting users
• Develop & drive the implementation of SAP BI best practices & standards for the team.
• Provided hyper care support for Business & IT teams Post Go live activity

Environment: SAP ECC 6.0/ SRM 7.0, SAP BI 7.0/ BO XI 4.0, BEx analyzer, HP QC 10.0, Agile methodology, Visio, service center, Rally, MS Office 2010.

Confidential, NY

Lead Business Analyst -

Responsibilities:

• Gathering Business Requirements interacted with the Users, Designers & Developers, Project Manager & SMEs to get a better understanding of the Business Processes, & Analyzed & optimized the process.
• Responsible for translating the business requirements and developing the request for proposal (RFP) and then evaluating the vendor responses and assisting the business in awarding the contract for the right vendors.
• Designed & schedule the tasks/iterations, scope & deadline for each task as per Agile/Scrum methodology.
• Utilize RUP methodology to gather requirements, administer change control & create the Requirements documents & traceability matrix.
• Worked closely with business units to develop a Business Requirement Document (BRD) and converting them into the functional requirement documents (FRD).
• Created Requirements Traceability Matrix for requirements management purposes.
• Created requirements specifications document in compliance with organizational policies.
• Created wireframes & screen mock ups for user interface designs for the software application/s
• Developed templates to upload the Material Master data based on the fields available in the catalog manager.
• Managed master data management (MDM) changes to support the standardization of downstreamprocesses and the migration of multiple enterprise resource planning (ERP) instances to a single global instance.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Model notations(BPMN)
• Developed data mapping procedure between the catalog manager & procurement system based on the vendor data product categories.
• Worked on the integration of catalog manager to the BI Tableau to create rich visualization of catalog, shopping cart, vendor trends analysis dashboards to make the appropriate business decision.
• Participated in requirements review meetings & status meetings with business leads & other team members.
• Participated in QA efforts as Lead QA analyst in testing the new functionalities & enhancements, documented & executed test cases, documented the results & worked with the development team to fix the bugs found during testing efforts.
• Conducted the user acceptance testing with various commodity groups & business user.

Environment: SAP SRM 7.0, Smart OCI 1.0, HP QC 10.0, UAT, UML, MS Excel, MS Access, MS Word, MS Power Point, Agile Methodology, SharePoint 2007, .NET

Confidential

Senior Business Analyst - Global Supply chain operations

Responsibilities:

• Gathering the business requirement from business users and SME’s for Procurement engagement and Preparation of procurement strategy, market analysis to find out potential suppliers for a specific category and services.
• Responsible for translating the business requirements and developing the request for proposal (RFP) and then evaluating the vendor responses and assisting the business in awarding the contract for the right vendors.
• Create and publish request for Quotation RFQ (email), collect quotes and negotiate with suppliers.
• Provide support in the following areas: requisition screening in line with category preferred suppliers, requisition approval, purchase order transmission, ensuring purchase orders and align to contracts where they exist, and user/vendor query resolution, sourcing and reporting.
• Lead Solution Design for Supply Chain Operations-P2P in areas such as REQ to PO, tactical Buying, procurement, Catalogue management, MDM,3 Way Match, Blocked Invoice Resolution, Strategic Sourcing, Tactical buying, Category Management, Commodity wise Spend for the Retail markets.
• Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML
• Implement Process Improvement initiatives, Value Stream Mapping, Swim Lanes and DMAIC methodology.
• Managed master data management (MDM) changes to support the standardization of downstreamprocesses and the migration of multiple enterprise resource planning (ERP) instances to a single global instance.
• Working closely with the procurement managers and stakeholders to establish and implement agreed procurement strategy, process improvement, SLA Measurement, negotiation and vendor management.
• Performed Unit Testing, Functional Testing, & User Acceptance Testing (UAT) with various business units.
• Communicating with stakeholders on getting required answers and convincing them for sourcing and savings initiative.
• Develop, enhance, re-engineer, maintain and support BI Tableau applications to create robust services around business requirements to inform business decision-making.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to destination data services.
• Wrote SQL queries to perform Data Validation and Data Integrity testing
• Responsibility for Management Information report design and production and Scope and prioritize work stream.
• Documentation & Knowledge Management: creating project plan, SLA metrics, SOP and SOW, RACI, process improvements, case studies and category research and strategy.
• Spend analysis commodity wise on monthly basis to show the maximum spent of the organization.

Confidential

Senior Business Analys

Responsibilities:

• Active member in gathering the requirements for documenting the business processes & efforts estimation for completion of project
• Identification of development objects (Reports, Configuration objects etc.,) as required with in-line to existing process.
• Responsible for translating the business requirements and developing the request for proposal (RFP) and then evaluating the vendor responses and assisting the business in awarding the contract for the right vendors.
• Worked closely with business units to develop a Business Requirement Document (BRD) and converting them into the functional requirement documents (FRD).
• Preparation of Project Plan, Implementation approach and road map for study and define phases forSupply chainE commerce processes.
• Managed master data management (MDM) changes to support the standardization of downstreamprocesses and the migration of multiple enterprise resource planning (ERP) instances to a single global instance.
• Preparation of Process Definition Documents andData MappingTemplate Documents for all P2P processes.
• Closely interact with the client during business study workshops and during all business decision meeting to guide them with best approach business methods on P2P processes.
• Prepared and defined process for all third party Master datainterfaces.
• Implement Process Improvement initiatives, Value Stream Mapping, Swim Lanes and DMAIC methodology.
• Created user stories, use cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams & ER Diagrams.
• Designed & developed Test Plans, Test cases based on the requirements given by the clients depending on the business model.
• Develop, enhance, re-engineer, maintain and support BI Tableau applications to create robust services around business requirements to inform business decision-making.
• Conducted Functional Testing, Regression Testing, & Performance Testing during the variousphases of development.
• Performed Unit Testing, Functional Testing, & User Acceptance Testing (UAT) with various business units.
• Created & provided SharePoint project site for document management purposes.
• Provided various demos to Global business teams for new developments
• Completed the training manuals & training sessions for customers
• Provided hyper care support for Business & IT teams after Go live activity.

Environment: SAP ECC 6.0/ SRM 7.0, HPQC, UAT, UML, MS Excel, MS Access, MS Word, MS Power Point, ASAP Methodology.

Confidential

MM Business Analyst

Responsibilities:

• Interacted with Users, Developers, Project Manager & SMEs to understand the business process, identify enhancements & gather Business Requirements.
• Participated & facilitated in the sprint sessions to add/modify/change any requirements based on the customer request in Scrum Agile methodology.
• Conducted GAP Analysis of AS-IS & TO-BE business process.
• Prepared Business Requirements Document converted it to Functional Requirements Specifications.
• Used MS Visio to create Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, and Data Flow Diagrams & ER Diagrams.
• Analyzed & documented the System specifications, Business requirements & detail design of the software for full understanding of the business & used MS Visio for the requirement tracking & analyzing.
• Worked closely with business users to comprehend business need, translate business need to requirements, understand user’s roles & responsibilities & grant them access to the appropriate parts of the Demand & supply planning application.
• Performed feasibility analysis for patches & releases related to the Demand & supply planning application.
• Managed master data management (MDM) changes to support the standardization of downstreamprocesses and the migration of enterprise resource planning (ERP) instances to a single global instance.
• Involved in configuration of vendor master, material master, defining number ranges for vendors, Release Strategies, Inventory Management, Contracts, Vendor Management, Pricing Procedure within PO, MRP.
• Involved in configuration settings requirement for various Business scenarios such as STO, release procedure, pricing procedure, message determination, MRP, Split valuation.
• Sales Order Processing/Customer order management component incorporating organizational structures in sales, controlling sales process, Sales document types, Item categories, Schedule line categories, Document flow and copying control.
• Sales document types- Order, Inquiry, Quotation and Billing for end users and inter-company cross billing.
• Involved in configuration of various functionalities in Inventory Management (IM) like, Goods receipt, Good issues & transfer postings in Inventory Management.
• Complete requirement analysis, during decommissioning of servers, to migrate user instance from one server to another for the Demand Planning application.
• Resolved issues related to MRP - Single level & multi-level planning for materials in plants & Consumption based planning - Reorder point planning.
• Complete analysis for the Business issue & Responsible for raising Change request & Process change request.
• Lead QA activities in creating & executing the test cases, enter defects in the Quality Center & follow up with the development team to make sure that all defects have been fixed.
• Performed Unit Testing, Functional Testing, & User Acceptance Testing (UAT) with various business units.
• Lead the defect tracking session & report the defects.
• Prepare Weekly Test Execution status report & Monthly Status Report.
• Analyzed & documented content management system processes.
• Created, provided & managed SharePoint project site for document management purposes.

Environment: SAP R/3 4.0, Click commerce demand planning application, SQL server 2007, Informatica

Confidential

Business Support Analyst

Responsibilities:

• Participated in requirements review meetings & status meetings with business leads & other team members.
• Entered & managed the change requests to requirements.
• Created Requirements Traceability Matrix for requirements management purposes.
• Created requirements specifications document in compliance with organizational policies.
• Created wireframes & screen mock ups for user interface designs for the software application/s.
• Participated in the data mining & data analysis activities with the technical resources.
• Participated in QA efforts, testing the new functionalities & enhancements, documented & executed test cases, documented the results & worked with the development team to fix the bugs found during testing efforts.
• Suggested measures & recommendations to improve the current application performance.
• Ad hoc running of the batch loads as requested by the business users.
• Providing workarounds for important incidents.
• Responsible for uptime SLA. Responsible for file receipt from upstream, processing the files & recovery.
• Testing of the fixes & Implementation of support.
• Support & monitoring for ADD batch loads.

Environment: Click Commerce parts, SAP MM, SAP BW, SQL SERVER 2005, MS Access, JAVA, & UML.