SUMMARY:

• Accomplished Business / System analyst with 9+ years of experience offering expert analytical skills, extensive project management experience, and a history of delivering significant business process and bottom line improvements within the supply chain group.
• Excellent Business Process and Functional knowledge in Retail operations, Supply Chain, Manufacturing and Inventory Management
• Extensive knowledge and experience in Optimizing SCM, Reducing Inventory & Holding cost, Manufacturing Process Improvement, Supporting and enhancing POS (Point of Sale systems) in Retail Domain
• Strong experience in full System Development Life Cycle (SDLC) - requirements gathering, analysis, design, testing, configuration & change management, and project management.
• Worked on customization and enhancement of Retek Merchandizing System 9.0 (Oracle Retail Merchandising System), Oracle Retail Predictive Application Server and Oracle Retail Price Management 9.0.
• Adept in utilizing e-commerce tools such stag version 2007.1 and 10, to facilitate site improvement recommendations to augment sales and Omni-channel strategies and price optimization.
• Solid experience in developing VBA functions to automate Excel, Word, and Outlook. Writing and optimizing SQL and T-SQL queries.
• Experienced in different aspects of both Supply Chain analytics and operational expertise. Seamlessly direct deadline-driven, interrelated activities and related personnel. Hands-on experience planning and coordinating operations and Supply Chain functions; quickly master new tools, equipment, and technology.
• Understand and analyze automation opportunities and provide VBA automation solutions which are unambiguous, testable and verifiable using various frameworks of Excel and outlook Object model
• Experience on Retail / Supply Chain domain with strong knowledge of standard business processes like E-commerce, Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process, Accounting & financials. Good knowledge on POS and Assortment Planning.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
• Solid experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Expertise with supply chain strategies/vendor manufacturing 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.
• Good understanding of Store Warehouse Inventory Movement (SWIM),Store returns (RTI ),check in, check out, Adjust in, Adjust Out., Transfer IN, Transfer OUT
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases to ensure complete and adequate testing as well as coordinating and conducting User Acceptance Testing (UAT).
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, SharePoint,XML, XSD, Middleware, XSLT, Visual Paradigm, Doors Erwin Data Modeler 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis.

Methodologies: RUP, OOAD, Agile, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, CaliberRM, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux

Web Technologies: XML, HTML, Java Script, Vb script

Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, DB2

Languages: UML, C, C++, HTML, Java, SQL, PL/SQL, ASP.NET

WORK EXPERIENCE:

Confidential, Salt Lake City, UT

Lead Business / System Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
• Creating a tool to analyze the flow of materials, information and dollars between their suppliers and customers. This tool assists in building Road Maps of their Supply Chains
• Implemented planning, analysis, and reporting solutions that provide Overstock with greater visibility into operations, decreased supply chain variability and more accurate planning
• Designed Dashboard, a front end Excel/user form based application which connects to back end Access database using Excel/VBA.
• Defined the entire omni-channel strategy based on project goals with concerned stakeholders and fleshed out the details.
• Created user-interface for capturing manually entered data. Filtered/sorted data based on column entries using Excel/VBA.
• Created dynamic charts such as Needle chart, Pie chart & Bar chart displaying vital data such as Time allocation and Budget spending through VBA
• Defined the entire omni-channel strategy based on project goals with concerned stakeholders and fleshed out the details.
• Manage proof and correct price change worksheet and price change event in RMS (Retek).
• Maximize Supply Chain effectiveness by selecting proper mode of transportation
• Facilitated project kick-off and meeting sessions and cross-functional meetings to gather business requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SMEs’) from different functional groups. Also, defined the Scope of the project with the input provided by the stakeholders.
• Provided guidance to development team required to complete transition from Broad vision to Hybrids ecommerce platform
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Trained users on Oracle R12 Process Manufacturing Supply Chain modules -Advanced Supply Chain Planning, Scheduling, Purchasing, Process Execution & Reporting
• Prepared and owned System Requirements Specification (SRS) documents including web services (XSD) requirements.
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Designed and developed project document templates based on SDLC methodology.
• Coordinated and discussed as a Project Manager with Business Analysts, Developers and QA Testers regarding questions on Business Requirements and Defects
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked on data modelling and produced data mapping and data definition documentation
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Gathered requirements for the integration of POS system with the supply chain system
• Working with Agile/Scrum methodology, I organize daily scrum sessions with the off - shore team in India.
• Extensively used MS Visio to develop the solution concept, business timeline and wireframes.
• Followed AGILE methodology viz. Scrum throughout the project.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Conducted project kick off meetings with team members to explain roles/responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Involved with the technical team in understanding the XML file format required for Billing process.
• Designed the UI of the application, prototyping and wire framing in MS Visio for better illustration of the application.
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.

Sr. Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Collaborated constantly with client and internal team to gather business requirements and performed Requirement Planning sign offs
• Conducted JAD sessions with different functions including Business, Operations and IT to identify, analyze and validate business requirements in the form of user stories to produce, amend and/or review business and functional specifications for any new or existing technology applications.
• Contributed as a data team member of most advanced Excel and Elastic Search skills for the execution of data migration projects to make a strong impact on project performance and meeting of its deadlines
• Facilitate all scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.)
• Enact change and continuous improvement increasing the productivity of Scrum teams and the quality of deliverables
• Implemented writing test cases and doing system testing for ETL and also reports.
• Ensured consistent application of scrum methodologies across the scrum teams
• Analyzed and created reports, as well as gathered data from credible sources to support and enhance Omni-channel initiatives and performances. Prepared data information for projects, team meeting, Power-Point presentations and ad hoc requests.
• Keep tracked and ensured the clarity of historical team metrics and progress of the iteration and release.
• Collaborated with project leaders through weekly meetings to ensure the team is crafting and developing effective and efficient solutions that meet established standards, protocols and practices, issues, risks and mitigation plans.
• Constantly and consistently engaged in various e-commerce initiatives such as, custom application development and front to end features of the e-commerce platform. Assisted in upgrades to the legacy platform as well as developed new functions and features for existing retail clients.
• Utilized UML in behavioral, structural and architectural modeling - in creating Use Case, Activity, Class and Sequence diagrams.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Performed knowledge and data migration to technical/development and QA team by adopting use case analysis and user stories to explain business requirements to IT through identification, documentation and implementation of relevant test scenarios and cases with accurate test data.
• Tested GUI and functionality on various OS including, Windows, and Android and iOS platforms using VMWare to identify software defects.
• Authored design documents, Requirement Traceability Matrices (RTM), functional specs and complex process and work flow diagrams using MS Visio and QC.
• Involved in documentation creation such as functional and non-functional requirement specifications, questionnaires, product launch kits, quick-start and training, and user manual.
• Ensured that the website was compatible with online analytical tools as Google Analytics and Omniture.
• Maintained the product catalogs, search and navigation, search engine optimization (SEO), Business Intelligence (BI) and personalization, etc.
• Generated transactional reports by using SQL server then further used those reports for process gap analysis which lead to the re-engineering of the existing transactions involved between Order routing and Payment Hub.
• Created SQL queries in SQL Developer and managed the database and assisted in making Data warehouse and managing Data profiling.

Confidential, Hudson, OH

Business / System Analyst

Responsibilities:

• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Developing automated ETL processes using Excel VBA macros to convert General Ledger data (journal entries, ledger, Assets and Chatfield / indicative data) from PeopleSoft
• Writing simple to complex queries in MS Access and connecting Excel VBA application to MS Access database.
• Worked closely with operations and Supply Chain to create and validate a comprehensive materials master that help drive standardization of product purchases and created a comprehensive & accurate inventory across those multiple facilities.
• Reviewed the data model and reporting requirements for Congas Reports with the Data warehouse/ETL and Reporting team.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Procurement and Supply Chain analysis and feedback to Management regarding procurement patterns, inventory levels, rebate status, and excess and obsolete inventory;
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Develop SQL and SSIS ETL business intelligence solutions, data wrangling, migrate disparate source data into a centralized data mart structure for HEDIS and SSRS reporting, SSIS flat file processing, advanced SSIS features for data mapping, data conversion.
• Site migration to SharePoint 2013. Assigned with the Government Affairs group within the IT department. Developed Intranet sites for employees.
• Managed, maintained, and implemented all site wide content via Hybris Management systems (PCM, CMS, HMC)
• Used Hybris Administrative Console (HAC) for initialization and updating system
• Coordinated User Acceptance Testing (UAT), developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program. Used Microstrategy dashboards for data analysis and custom reports.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and Microstrategy layer.
• Documented, tabulated and reviewed methods of valuation in effect, using SQL (to continue working on prototype developed by self)
• XML order header and order detail data transfer; inventory/supply chain management modules
• Performed Website redesign, UI prototyping and screen mockups.
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Worked with the BRD for the POS implementation project
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Developed an interface between Oracle PA (Financials) & Clarity to bring the Non-Labor transactions into Clarity.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Models.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Review the Test Plan developed by the testing team for testing the application.
• Deep understanding of all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational Clear Quest.

Confidential, KS

Business Analyst

Responsibilities:

• Helped Project Manger in project design and project plan using the RUP Methodology.
• Determined a testing strategy in conjunction with the QA team. Assisted in writing detailed Test Plan, Test Cases and Test Case Scenarios for system testing, integration testing and functional testing.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Supervised all pertinent project management processes: Business processes, User Acceptance Test, Test scripts, Test results, End user training, oversaw documentation; Established regularly scheduled project team meetings milestones.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Design, architecture on ATG Content Management, Search, Commerce Service center.
• Tough challenges in this project: Need to reconfigured Content Administration and re-develop Commerce deal sku's as implemented by previous vendor?
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
• Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update the scripts.
• Prepared and executed test cases for Navigational test, Functionality testing and GUI testing using Test Director.
• Conducted Black Box Testing on the application and validated the dataflow in the application.
• Tested security test and audit test for this particular system. Performed Black Box, functional testing, end to end testing for world points system
• Manually tested the whole application before going for the automated testing.
• Involved in testing the conversion of the application into web application using XML web services.
• UAT testing performed along with call center managers to make sure that application meets their requirements.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for defect and change management
• Designed and developed project document templates based on SDLC methodology.
• Determined a testing strategy in conjunction with the QA team. Assisted in writing detailed Test Plan, Test Cases and Test Case Scenarios for system testing, integration testing and functional testing.