Summary:

• 7 years of professional experience as a Business Analyst with a strong understanding of Business Analysis, System Analysis, Business Process Management and Business Process Modeling.
• Excellent experience in the Stores/Airline and Retail Industries.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Understanding of Portfolio Management Asset Allocation, Performance Attribution and Portfolio Accounting.
• Knowledge of Financial products and services such as Fixed Income Instruments, Equities, Derivatives, and Hedge Funds.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Expertise in UML class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams as a business analysis methodology for application functionality designs using IBM's Rational Rose.
• Effective communicator leading various information gathering meetings, user interviews, Joint Application Development JAD sessions and presentations.
• Effective in establishing project plan and milestones, managing scope and in helping ensure that timelines are met.
• Experience with monitoring Servers by using BMC Patrol Monitoring system for all servers, databases, and network devices and Foglite.
• Experienced in SQL Server Reporting Service SSRS , Executing Queries and Running Store Procedures.
• Proficient in developing Wireframes, Use Cases, Data Flow Diagrams, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams, Class Diagrams, Entity Relationship Diagrams and Business Process Diagrams.
• Proficient in writing SQL queries for data analysis and validation.
• 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 .
• Diligent team player with enhanced analytical, communication, organization and leadership skills.
• Tactful resource in managing user request changes and user conflicts.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Business Analyst

With global expertise in freight and transport, DHL combines worldwide coverage with an in-depth understanding of local markets. The company now offers its new range of products and services on one stop basis. A complete range of express, parcel and logistics solutions from a single source is the hall mark of DHL. The company has more than 5000 Offices worldwide and more than 430 warehouse/ hub locations to provide better services to their clients. Also worked on Worked on Oracle Manufacturing and Supply Chain Management modules including OM, Shipping and Execution, Pricing, Inventory

Responsibilities:

• Involved in Inception Phase of the projects and prepared Business Context diagram, Systems Context diagram, Scope Document and other initial data models that contain the essential business elements and detailed definitions
• Facilitated JAD sessions with the Customers and other key business stakeholder SMEs Payroll, Audit, Travel, etc. to brain storm and determine the current and future states, and the required functionalities.
• Created As-Is and To-Be process flows, information flows, and activity diagrams to define the current and the future state.
• Attended 3rd party software demos, evaluated whether the functionalities provided by each software is in compliance with the IRS's and Walmart set of policies and guidelines.
• Analyzing the functionalities provided by each vendor product and develop a scorecard to help perform the RFP.
• Gathered core requirements of the system and developed functional specification, which includes:
• Assisted in helping the management in developing ecommerce Integrated Marketing Platform IMP portal to increase the marketing return on investment MROI and increase conversion rates.
• Facilitating working sessions with Wal-Mart
• Prioritized requirements to determine the candidate requirements and criticality, and be assured most important or high risk reqs are implemented first.
• Created the Scope Document by constantly getting feedback from teams of their subjective areas and highlighting business level functionalities requested.
• Reported daily status updates and generated reports in Clarity to send to the management.
• Loaded new requirements into HPQC, and correcting any requirement defects identified by the Wal-Mart QA Team
• Monitored Servers by using BMC Patrol Monitoring system for all servers,
• Rectified the defects identified by Wal-Mart QA team and maintained technical documentation and proper Change Control procedures.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Developed Change Request documents and got approvals from the customer.
• Performed re-work on requirements, and BRD based on the customer reviews and feedbacks.
• Assisted the testing team in developing the Test plans for quality assurance based on functional requirements.
• Assisted Project Managers in performing Risk Assessment, Management and Mitigation
• Worked on designing the screens and developing screen shows, and prototyping of the user interface and usability testing using Snag It
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft SET and Teradata
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.

Environment:

Clarity, HP Quality Center, Axure RP Pro, MS Visio, Project, Excel

Confidential

Business Analyst

The Confidential project scope includes the entire supply chain from Inventory management to shipping delivery and order management. Inventory management and supply chain groups are working together to address critical dependencies between processes like demand, supply, tooling and warehousing. It has been implemented for maintaining the Demand, Production, supply, Shipping Logistics and purchase order processes

Responsibilities:

• Helped Project Manger in project design and project plan using the RUP Methodology.
• Served as an intricate team member in preparing Scope and Vision document. Helped manage scope and identify risks throughout the project life cycle.
• Advised on capturing the additional data requests from the ODS Performed business process mapping for new requirements.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives such as futures, options on futures, equity options and index options , OTC derivatives such as interest rate swaps, swaptions, credit default swaps and total return swaps and portfolio allocation and management.
• Responsible for implementing supply chain and operations solutions in the exploration production lines
• Lead, develop and implement the planning system improvements to maintain optimal inventories throughout the global supply chain
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• 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.
• The Supply Chain scope includes the entire supply chain from production order to shipping delivery and order management.
• Documented current and proposed process flow and conducted detailed gap analysis.
• Worked in conjunction with other team members, technical architects and developers to understand system integration and interface requirements.
• Support for a major effort to improve the Warehouse Management System WMS capabilities of Supply Chain.
• Performed Requirement Analysis and developed UML Use Cases, Activity Diagrams using Rational Rose to understand the requirements.
• Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access
• Co-authored detailed Business Requirements Document and Functional Specification Document.
• Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams using Object Oriented Design OOD concepts and UML using Rational Requisite Pro.
• Worked with an information architect to create and develop wireframes and mock-up screens for the UI.
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Handled COTS project that was outsourced by a company for development and acquiring apt design process flow.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Conducted highly interactive JAD sessions with project stakeholders to identify and resolve issues. Ensured consensus between Line of Business and IT Teams.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• 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.
• Assisted in performing and coordinating unit, performance and functional testing.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services SSRS .
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Coordinated User Acceptance Testing UAT , developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new System.
• Assisted in deployment and implementation.

Environment:

Rational Suite Rose, Requisite Pro , SQL, Oracle, Dreamweaver, Rational Unified Process RUP , Windows NT/XP/2000, UML, UNIX, MS-Project, MS-Office Suite, Case wise Corporate Modeller , Win Runner, Test Director

Confidential

Business Analyst

Confidential. is an Confidential Public Corporation that runs a chain of large discount department stores and a membership required warehouse stores. Wal-Mart serves customers and members more than 200 million times per week at more than 8,446 retail units under 55 different banners in 15 countries. With fiscal year 2010 sales of 405 billion, Wal-Mart employs more than 2.1 million associates worldwide. The purpose was to develop a web based application in GAIN for Walmart's Logistics division that will enable the HR Logistics' users to handle the 'Position Movement' process, for transferring/moving an associate from one position to another position, within or outside departments and/or in the hierarchy.This project is aimed at implementing and integrating with existing Walmart applications, a single 3rd party relocations software that will meet all corporate domestic relocation needs required to ensure policy and tax compliance.

Responsibilities:

• Served as a liaison between various business units and information technology groups.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• 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.
• XML order header and order detail data transfer inventory/supply chain management modules
• Used ERP business user information to create prototype business models and related business objects for Human Resources, Sales, Supply Chain and Finance which strongly supported ERP configuration using Business Process Modeling tool with UML and OOD
• KBS Knowledge Base System is also a one of the best feature of this system which will intimate the responsible person about an event which is necessary for company either through mail or through SMS whichever they set. This System is used to control all the various activities taking place in a mill in effective manner.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Worked together with other team members in interviewing various business groups and identifying and prioritizing business and functional requirements.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Worked together with SMEs, architecture group and technical team leads to detail the interface, customized based on different user roles and functions.
• Mapped the current and proposed process and conducted thorough GAP analysis
• Generated Use Cases, Use Case Scenarios, Activity Diagrams and Data Flow Diagrams.
• Co-authored Functional Requirements and Specification Document.
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Assisted the database development team in data modeling, data structure and data table layouts required for consolidation of incongruent databases,
• Involved in writing test plan, test cases and test scripts for end-to-end testing.
• Reviewed test results and reported bugs/issues using Mercury Test Director.
• Assisted in UAT and end user training.
• Involved in various other enhancement initiatives to include new functionalities and redesign.

Environment:

Windows, Oracle, SQL, MS Visio, MS Access, MS Project, MS SharePoint, UML, Requisite pro, Rational ClearQuest.

Confidential

Business Analyst

Confidential is one of the world's largest package delivery companies. UPS delivers more than 15 million packages a day to 6.1 million customers in more than 200 countries and territories around the world. Since 2005, its operations include logistics and other transportation-related areas. It has been headquartered in Sandy Springs, Georgia. Worked to ensure that the company's benefits were optimal to both the employee and the company as a member of Flexible Benefits Implementation Team. This was achieved through the analyzing of existing insurance plans and assisting in the implementation of new plans with cost-benefits analysis, reporting and plan comparisons. This has been significant in that UPS revenue growth has slowed but continued even though they are one of the last companies to provide 100 employer paid benefits.

Responsibilities:

• Interacted extensively with SMEs to understand and document their requirements pertaining to Fixed Income Instruments such as Corporate Bonds, Treasury Securities, Municipal Bonds, Agency/GSE securities, CDs, MBS and New Issue Offerings , Corporate Actions, Risk Analysis, Portfolio Performance Attribution and Optimization.
• Worked with Financial Analysts to evaluate benchmarks that included a vast array of global indices as well as customized benchmarks.
• Coordination SME and Business/End User Relation Data Modeling Test Cases Scripts UAT Communication Plan Risk Mitigation Plan User Training SOX COTS
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Collaborated with other team members to write detailed Business Requirements Document. Developed Functional Requirements Specifications and System Requirement Specification from the business requirements.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Designed Use Cases, Use Case Diagrams, Use Case Scenarios, Workflow and Data Flow Diagrams. Business Process Flow Diagrams, Activity and Sequence Diagrams using Microsoft Visio.
• Involved in various brainstorming sessions to investigate, identify, analyze and solidify business rules.
• Reviewed with architect and technical team various technical design documents as well as input and output parameters for various web services.
• Preparing BRD, Business Cases, and presentation to the clients, Business Re-engineering proposals.
• Created and maintained a Traceability Matrix using Rational Requisite Pro.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Involved in analysis for wide range of Six Sigma and Web-based initiatives, including user requirements.
• Generated wireframes and prototype for the GUI.
• Substantial report development experience utilizing SQL Server Reporting Services SSRS , Cognos Impromptu, and Microsoft Excel
• Worked with the QA team to develop test plan, test cases and test conditions for integration and functional testing. Traceability Matrix was used to ensure complete end-to-end testing.
• Wrote and executed test scripts for GUI testing using WinRunner.
• Coordinated UAT. Reported all bugs and defects to the development team.
• Performed data analysis and ran various SQL queries to critically evaluated test results.
• Participated in end-user training and generating descriptive user manual.
• Assisted production support team in identifying failure points and performing root cause analysis.

Environment:

RUP, Rational Requisite Pro, Rational Soda, Rational Rose, Rational Clear Case, Rational Clear quest, Java, VISIO, Oracle 9 , Sybase , SQL, Oracle, UNIX, XML SPY, GOXML, LINUX, HTML, WINDOWS