SUMMARY:

• IT Professional with extensive 8 years of experience in Business analysis, modeling, mapping, design and development of Supply Chain Analysis for business applications.
• In - depth knowledge of Procurement to Pay (P2P) and Order to Cash (O2C) processes to efficiently gather customer's business requirements and translate business requirements into easy to use SAP system solutions.
• Good domain knowledge working with the technical staff to implement management and staff's business requirements into the software application in retail and e-commerce environments.
• Expertise with supply chain strategies/ quick service restaurant (QSR) process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
• Experienced in development methodologies like RUP, SDLC, agile/scrum and very comfortable using Agile Product management tool within Jira and Confluence.
• Extensive knowledge of technology system interfaces and data integration and well as networks and point of sale POS operating system
• Experienced with leading analysis and requirement-gathering/ elicitation efforts using various methodologies, techniques and (PMO) defined practices.
• Experienced in development methodologies like RUP, SDLC, agile/scrum and very comfortable using Agile Product management tool within Jira and Confluence.
• Innovative marketing professional with solid experience in e-Commerce, digital campaigns, brand awareness, direct and B2B channels, and the expansion of the brand using emerging technologies.
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Experienced in Data Migration, Data Conversions using DTS, Data Junction and SQL Loader
• Extensive experience with Business-to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios, such as e-procurement
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Experienced in designing star schema (identification of facts and dimensions), Snowflake schema for modelling a Data Warehouse Management (DWMS).
• Managed expense reporting process as SAP Concur system administrator, approved and validated expenses and submitted weekly reports.
• Expertise in Software Development Life Cycle (SDLC), Object Oriented Analysis and Design Methodology.
• Experience of Unit Testing (UT), System Integration Testing (SIT) and User Acceptance Testing (UAT) as well as Defect Tracking.
• Good command in modeling using case tools like ERwin, Oracle Designer, Power Designer & E-R/Studio.
• Experienced in developing T-SQL, Stored Procedures and Triggers for business logic implementations.
• Experienced in working with complex SQL queries, PL/SQL Stored Procedures, Functions and Packages using TOAD and SQL*Plus.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies and process mapping.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum
• Domain Knowledge of Mobile applications Internet/Intranet, client/server and industrial application development in the functional areas of Supply Chain Management
• Good understanding of Project Process and ability to analyze business problems and identify solutions.
• Worked extensively with the team to meet business requirement and analyzing workflow.
• Experienced in creating Data Flow Diagrams, Use Cases, Use Case Diagrams, Activity diagrams, Entity Relationship Diagrams
• Understood Inter-operability requirements for Cloud computing/SaaS.
• Skilled in determining system requirements and specifications for application development projects with emphasis on User Requirements and Functional Requirements through user interviews.
• Well versed in Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices.
• Experienced in developing Object Oriented Analysis and Design Models; Use Case Model and UML.
• Well versed in project management tools like MS Project for project planning, Project scheduling.
• Prepared documents to conduct User Acceptance Testing.
• Good Knowledge of Unified Modeling Language (UML), Class Diagrams, Use Case Diagrams, Activity Diagrams, Sequence Diagrams.
• Proven ability to work under pressure, prioritize and meet deadlines. Open to dynamic work environment and ability to work collaboratively with business analysts, testers, developers and other team members in the overall enhancement of software product quality.

TECHNICAL SKILLS:

• Operating System: Win, UNIX
• Languages: C, C++, SQL, HTML, SAS
• Software/Database: MS - Access, Oracle PL/SQL, ASP.NET, SQL Server, DB2
• Web technologies: HTML, XML, Macromedia Dream Weaver, MS-Front Page
• Application Servers: IBM WebSphere, ATG Dynamo, BEA WebLogic.
• MS Office Suite: MS Word, MS Excel, MS PowerPoint
• Web protocols: HTTP, TCP/IP, FTP
• ETL TOOLS: Data Stage
• Modeling tools: MS-Visio, Rational RoseProject Management Tools: MS-Project, DOORS (Dynamic Object Oriented Requirements System)
• Methodologies: SDLC, Object-Oriented Analysis and Design (OOAD), SAP, Rational Unified Process (RUP), Unified Modeling Language (UML), Rapid
• Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

BUSINESS SYSTEM ANALYST

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Analyzed Business Requirements and segregated them into high-level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Perform Source-to-Target Data Mapping; Data Lineage Analysis and documentation using the Enterprise Metadata Repository.
• Validated edge systems (TraceLink/ROC IT EdgeTrack) that integrates WMS/ ERP systems with serialization systems.
• Created the BRD for a project where 2 SAP and 1 Oracle ERP systems were consolidated into a single Oracle Cloud ERP system for Order Orchestration.
• Designed delivery of XML-based documents with inter-application linking, including system interface, user interface and testing
• Identified and queued End to End cycle for various products via Oracle SOA integration solutions for corporate functions, business units and enterprise-wide functions such as Order to Cash (O2C) involving Order Entry, Provisioning, Billing and Invoicing based on the subscribed plans
• Developed and maintained detailed project plan and implementation plan in MS Project. The implementation plan developed for Point of sale (POS) project became the benchmark for other projects
• Worked on requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional Data Warehouse Management (DWM) using ERwin.
• Created the product management and scrum teams to create User stories from the road maps. Conducted iteration planning, daily scrums and retrospective meetings and helped team get matured.
• Proven Product Management Skills with experience in Identifying trends, analysing markets, conducting product assessments and reviewing data pertaining to proposed projects
• Converted Point of sale POS data for approximately 20 retailers from legacy SAS system into newly built data warehouse on DB2 platform.
• Developed ETL data mappings using Informatica for extract, transform and loading data from OLAP system to OLTP system
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Worked on Matrix reporting, document and project updates through Portfolio management tool, Team Foundation Server (TFS), Share Point, WorkPro (work management tool) BizTalk, SAP and other enterprise level tools.
• Implemented and optimized ERP and peripheral application systems: ERP, MRP, Purchasing Procurement to Payment, Sales Order to Cash, Supply Chain Management, Manufacture, Manufacturing Execution Systems (MES), Finance Accounting and Reporting
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.
• Designed conceptual and logical data models of Data Warehouse Management (DWM) and tables. Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Created large amount of test data to support web services testing for Order Management, Inventory Management, and pricing data, and used SOAP UI to test XML data from central data repository.
• Managed the expectations of sponsors and key stakeholders through effective communications. Continually update impacted parties on progress or issues to ensure deadlines and expectations are met.
• Conducted JAD sessions with supply chain management and development team to brain storm Point of sale (POS)
• Worked with the SQA team which oversees the implementation and upgrades of Enterprise Service Platform in a SaaS (Software as a Service) setup.
• Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.

Confidential, Fitchburg, MA

BUSINESS SYSTEM ANALYST

RESPONSIBILITIES:

• Developed and implemented the planning system improvements to maintain optimal inventories throughout the global supply chain
• Created the Strategic Operations Technologies group with implementing Agile Requirements Methodology.
• Developed all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
• Tested different functions of the Point of sale POS system like scanning, payments and returns. Moreover, make sure that the system met the requirements and expectations
• Created documentation on program Management Office (PMO) methodology (BRD, Functional Decomposition, User Story requirements, Trace Matrices, Scope documents).
• Created user stories and requirements for web portals and mobile data applications, in an Agile environment, using JIRA
• Created SQL Scripts to install create and drop database object, including tables, views, primary key, indexes, constraints, packages, sequence, grants and created the changes in the database according new requirement
• Created the data mapping document from source to target and the data quality assessments for the source data
• Performed analysis and provided business reporting solutions to support the core business processes, such as Manufacturing, Supply Chain, Distribution, Finance, and Order to Cash.
• Performed data conversion by transforming XSD files to sample XML files for customer use
• Configured and Tested Oracle Procure to Pay, Order to Cash and Records to Report business process.
• Worked with the product management and scrum teams to create User stories from the road maps. Conducted iteration planning, daily scrums and retrospective meetings and helped team get matured.
• Performed data profiling identified data quality issues and recommended remediation strategies for EDW
• Used SQL Loaders to load bulk data from various Flat Files used SQL for DDL commands utilized SQL to create Risks signals and Extract large subsets of data.
• Performed SQL queries to conduct back-end testing and performed UI testing on application web interface.
• Created and execute test cases for the stories in version one and JIRA for both the desktop and mobile data applications.
• Worked with a major effort to improve the Data Warehouse Management (DWM) Management System (WMS) capabilities of Supply Chain
• Responsible for implementing supply chain and operations solutions in the exploration & production lines
• Coordinated various projects with the Program Management Office (PMO) to create user stories based on requirements from the user community.
• Supervised project progress by monitoring activity, solving problems, publishing progress and reports using JIRA and Sharepoint.
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Worked extensively on the Xml Product suite to test XML transactions. Validated input XML structures against data in the Annuity Net Database
• Ensured smooth transition from all manual end to end order to cash processes to automate EDI standardized processes. To name a few, I led the end to end supply chain integration of notable customers
• Worked closely with ETL developers and DBA to design and develop dimensional models; and prepared metadata models using Framework Manager for reporting purposes.
• Utilized excel and other computer programs frequently and became familiar with the workings of a Point of sale POS System

Confidential, San Diego CA

BUSINESS ANALYST/SYSTEM ANALYST

RESPONSIBILITIES:

• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Responsible for creating business work flows and processes and creating management reports based on the business rules and the business case analysis
• Support for an inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
• Prepared User Stories in JIRA for application design features like table and content, search criteria, page objects and functionality, ability to export and delivered Value by prioritization, sequencing and provided estimates
• Worked with the product management and scrum teams to create User stories from the road maps. Conducted iteration planning, daily scrums and retrospective meetings and helped team get matured.
• Interacted with Data Owner; provide framework, stewardship, governance and decision making for the management of the enterprise data quality for project development teams, business users and other stake-holders.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Performed Requirement Analysis and developed UML Use Cases, Activity Diagrams using Rational Rose to understand the requirements.
• Focused on Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Analyzed requirements documents, use cases and creating test strategies and test plans for various projects and also felicitated UAT testing
• Worked together with SMEs, architecture group and technical team leads to detail the interface, customized based on different user roles and functions.
• Configured and Tested Oracle Procure to Pay, Order to Cash and Records to Report business process.
• Defined, retrieved, analyzed large datasets using SQL, and Excel to drive and define operational solutions and approaches
• Involved in Business analysis and Technical Design session with business and Technical staff to develop requirement document and ETL specifications created dashboard by embedding reports and providing intuitive drilldown and exploit the benefits of analytics
• Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations
• Worked on Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.