Experience Summary:

• Ability to perform complex analysis of user requirements to produce specifications for the creation of new BAM enhancement viable to cross-systems support.
• Exceptional ability to create, comprehend process-level and system-level design including Functional Specifications, Project Scoping, Project Planning, Gap Analysis to augment the existing version of BAM.
• Experience in process and data modeling using Use Cases, Sequence Diagrams/Process Flow Diagram, Collaboration diagrams, Activity Diagrams and Class Diagrams to identify the as-is and to-be (what-if) processes.
• Defined the process using agile (scrum/DAD) methodologies more efficient, reduce rework and identified opportunities for customer satisfaction during POC and implementation of BAM.
• Experience in documenting test plans, test cases to perform Unit Testing, System Testing, Performance Testing and Load Testing; Seamlessly migration of code from Development to Testing, UAT and Production.
• Knowledge in Retailing, Transportation and Logistics, Planning and procurement, Supply Chain and Insurance domain experiences with certified INS 21 Certified Property and Liability Insurance Principles.
• Worked with Oracle PL/SQL Stored Procedures, Triggers, SQL queries, PL/SQL Packages and loading/comparing data within Data Warehouse.
• Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

Technical Expertise

Operating Systems : Microsoft Windows Server, UNIX, Linux
Database : Oracle 9.x, PL/SQL, SQL, DB2, TOAD, Tera-data
Software Tools : Visio, UML, Use Case Diagrams, Agile (Scrum), i2 JDA Planning and Procurement Suite – BAM (Buying and Assortment Manager), DM
(Demand Manager), SLIM (Store Level Inventory Manager), DataStage v7.5.1, Business Intelligence (BI).

Certifications & Training:

• INS 21 Certified Property and Liability Insurance Principles.
• Transportation and Logistics.
• Introduction to Retailing (101).
• Introduction to Consumer Packaging Goods (101).
• Introduction to Quality Assurance (201).
• Trained in RHCE and CCNA.

Professional Experience

Client : Confidential
Duration : March 2012 till date
Role : Sr. Business Consultant

Environments: JDA Assortment Planner 8.0, PL/SQL

Description: Supporting ‘Limited Brands International’ Business Group with JDA Assortment Planner 8.0. It involves training the technical and business team about the tool. Some of the other responsibilities include designing key Milestones, data conversion, system and business data validation for the Limited Brands ASSORTMENT8.0 Implementation.

Responsibilities:

• Serving as a Technical Lead/Architect for functional and technical installation, design and implementation of JDA ASSORTMENT8.0.
• Training both technical team and business partners on the planning strategy of ASSORTMENT8.0.
• Designed and lead workshops to access and express values, vision and dreams for LBI Wholesale and Seasonal Planning for Assortment 8.0.
• Designing Business scenarios and the Process flows from the conceptual to procedural level.
• Acted as the primary liaison to collect requirements and business process information, documented them in Business Requirement Document (BRD).

Client :Confidential
Duration : Sep 2009 till date
Role : Sr. Business Consultant

Environments: i2 Suite Tools (BAM, DM and SLIM), Windows Server, UNIX, shell scripting, PL/SQL, Oracle 10g, DB2, UML, Use Case Diagrams, BPM, Agile (Scrum), Visio.

Description: The current project is to support and enhance BAM applications for Stores Inventory Management, In-season and Pre-season Business Planning, product management, Sales and receipts Management and Distribution Center to store mapping.

Responsibilities:

• Work in conjunction with various project stakeholders discussing new opportunities, business strategy and planning timelines.
• Acted as the BAM SME for the Business Partners and the IT department interacting with internal as well as external clients, to collect requirements and business process information, document in Business Requirement Document (BRD).
• Designing detailed process model documentation containing business objective, vision and scope, preliminary estimates, infrastructure impact assessment and risk factors.
• Involved extensively in Project Planning in the areas of Scheduling, Team Building, Task Assignment, Generating Feasibility and progress report for new deployment of BAM.
• Used MS-Visio to document current work flows, manual processes and Best practices of system for training and guidance.
• Designed and developed Use Cases, Activity Diagrams, sequence Diagrams considering AS-IS and TO-BE in the existing architecture and performed Gap Analysis.
• Working with GAP Business Directors in documenting BAM Process and common issues resolutions on GAP Portal page called ‘Sketchbook’.
• Worked as Technical Writer with GAP Inc., Business Directors, Brand Implementation Leads for collecting, understating the business strategy to re-design the Business Planning Process for IT Business Planners.

Client :Confidential
Duration : July 2008 to Aug 2009
Role : Business Consultant

Environments: i2 Suite Tools (BAM, DM and SLIM), Windows Server, UNIX, shell scripting, PL/SQL, Oracle 10g, DB2, UML, Use Case Diagrams, BPM, Agile (Scrum), Visio. Business Intelligence.

Description: For various brands at GAP Inc worked with diverse stakeholders supporting different phases of implementing i2 BAM (Buying and Assortment Manager). It involves designing key Milestones, environment delivery, system delivery, database setup, Operations readiness testing, code conversion, system and business data validation and Post Implementation and sign off activities.

Responsibilities:

• Worked alongside with cross functional teams in order to establish comprehensive business and functional requirements and then translating those requirements into software design specifications using various notations of UML for successful implementation of BAM v6.2.5.x.
• Developed and managed project plans, system requirements, change management policy standard and procedures required for the implementation.
• Documented application features and operations in detail, including screen layouts, business rules, process diagrams, pseudo code and other documentation for BAM training and education.
• Assisted the IS and Technical team in understanding and developing the functionality.
• Was responsible for developing and managing project plans: system requirements, change management policy standard and procedures.
• Designed and documented and prioritized key reports for day to day servicing needs for products monitoring processing and Inspection.
• Documented, reviewed, and verified testing procedures for compliance to Interface Quality Assurance and Development standards and policies and other required standards.
• Identified and documented issues, risks, gaps and their impact to the project life cycle by recommendations and alternatives.
• Assisted the Integrating Strategy and Technical team in understanding and developing the functionality by conducted JAD sessions with business unit owners and portfolio team to capture business requirements and system behavior.

Client : Confidential
Duration : Dec 2005 to June 2008
Role : Business Consultant

Environment: Redhat Ent 4.0, UNIX, MS Windows Server AS400, ORACLE 8, , PL/SQL, J2EE, Java, Struts, Visio, XML, RAD, N2 Chart

Description: This is an initiative to transfer the business rules from the legacy system to the SQL database with the help of a light weight struts wed-based application. This tool enables Allstate Policy Makers to read and analyze the business rules written in AS400 (legacy system).

Responsibilities:

• Analyzed the transactional data model, data elements by working in conjunction with SME (subject matter experts) on day-to-day basis to create technical specification for data conversion programs.
• Designed PL/SQL procedures, Shell Scripts for extracting, cleansing, transforming, integrating and loading data into data warehouse database from legacy system.
• Extracting and analyzing various rules from the legacy system, decode the various rules using a business rules sheet designed by underwriters.
• Responsible for unit, System and Integration testing; developed Test scripts, Test plan and Test Data and participated in UAT (User Acceptance Testing).
• Involved in working on an interactive web based application involving frame work with HTML, DHTML and XML, OOPS concepts (classes, objects), Java concepts, java scripts and struts.

Client : Confidential
Duration : Dec 2003 to Dec 2005
Role : Business Consultant

Environment: MS Windows Server, SQL server, ORACLE 8, PL/SQL

Description: This project was about designing a Java based application. This application will help the client to add, update and delete rules in database for an insurance based service provider. This project involves designing, reporting and defect fixes.

Responsibilities:

• Designing the UI for the client’s agents using a light weight Java/JSP based application enabling the business users to add, delete and update the rules using the database (SQL server).
• Compiling comprehensive data and discoveries into a summary document that clearly communicate results of number of issues coming in/fixed/outstanding.
• Interacted with technical consultants and business analysts to understand the business and reporting requirements and source systems.

Education: Bachelor (degree) of Engineering in Information Technology.