SUMMARY

• Business Analyst with 8 years of experience in Retail and E - commerce Industry.
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP).
• Have strong experience in Retail Applications, Purchase Order Management and Supply Chain
• 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.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile /Scrum.
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
• Experience in developing Forms & Reports using Oracle Forms & Reports
• Business Process Analysis: Proficient in analyzing Business Requirements, System Requirements, Functional Requirement specification (FRS), Design Documents, Use Case Specifications (Use Cases), UML diagrams, Requirements Traceability Matrix (RTM) and performing Gap Analysis, Impact Analysis, Process Analysis and designing prototypes to design the test flows.
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Good command over Logical and Physical entity relationship data modeling using Oracle Designer and Power Designer.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Actively involved in developing, executing and managing User Acceptance Testing ( UAT )
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence
• Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Assisted in preparing and executing Test Cases, and reviewed Test Execution Procedure Document (EPD) document prepared based on the Business Requirement Specifications (URS), Functional Requirement Specifications (FRS) to cover overall quality assurance.
• Experience on Retail / Supply chain domain with strong knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process. Little knowledge on POS and Assortment Planning.
• Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 database.

TECHNICAL SKILLS

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, DoorsErwin 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, Test Director, Quick Test Pro, PR Tracker

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

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

Content Management Tools: Documentum, Sharepoint, Interwoven, Filenet

Languages: UML (Use case, activity diagram, sequence diagram, data flow diagram, component diagram), C, C++, HTML, Java, XML,SQL, PL/SQL, ASP.NET

Modeling Tools: MS Visio, MS Studio, TrueComp

PROFESSIONAL EXPERIENCE

Confidential, Hoffman Estates, IL

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Coordinates oversight of proper cash handling and financial transactions, including contract and purchase order management, accounts payable, accounts receivable, payroll, grants, revenue recording/uploading;
• Responsible for providing analytical support to Sales Support/marketing and internal sales group clients of WMS.
• Followed Agile (XP) Methodology for the release.
• Performed extensive Requirement Analysis including data analysis and gap analysis
• Business data modeling and analysis and a thorough understanding of relational data structures, database star and snowflake schemas and OLAP concepts.
• Coded the ETL and Business Intelligence Batch and On line PL/SQL Packages.
• Conversion of existing website to ATG software client moved from custom built application to ATGs eCommerce suite
• Work as Business Analyst for the project to build a MS SQL data warehouse for complex wide profitability reporting.
• Work under direct supervision to perform Supply Chain activities for assigned product portfolio to optimize inventory, minimize cost, and set and achieve customer service goals.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
• Analyzed user stories to develop acceptance test criteria in collaboration with product owners.
• Query the database using SQL Advantage for testing and verification purposes.
• Documented Business Process Requirements with Use Cases and facilitated JAD sessions to define AS IS and TO BE IT processes for the TIERS project a conversion from Unisys COBOL to client/server.
• 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.

Environment: Microsoft Office Suite, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Biztalk, Sybase, VBScript, C#. DOORS, C++, NET, Agile/Scrum, Business Objects, TestDirector, LoadRunner

Confidential, Bensalem, PA

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Coordinates oversight of proper cash handling and financial transactions, including contract and purchase order management, accounts payable, accounts receivable, payroll, grants, revenue recording/uploading;
• Responsible for providing analytical support to Sales Support/marketing and internal sales group clients of WMS.
• Followed Agile (XP) Methodology for the release.
• Used master data management (MDM) to define reference dataPerformed extensive Requirement Analysis including data analysis and gap analysis
• Prepared UAT Materials UAT Test Cases to include various steps involved for UAT and to have proper coverage of requirements
• Conversion of existing website to ATG software client moved from custom built application to ATGs eCommerce suite
• Work as Business Analyst for the project to build a MS SQL data warehouse for complex wide profitability reporting.
• Provide business intelligence analysis to decision-makers using an interactive OLAP tool
• Responsible for scheduling meetings with users, SME’s and stakeholders to identify problems resolve issues and improve the process to ensure a stable and accurate solution.
• Assisted with the BRD for the POS implementation project.
• Performed gap analysis from existing Open Systems software system to SAP.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Involved in testing the POS system
• Work under direct supervision to perform Supply Chain activities for assigned product portfolio to optimize inventory, minimize cost, and set and achieve customer service goals.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Conducted JAD sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions, trade and custodial data.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Analyzed user stories to develop acceptance test criteria in collaboration with product owners.
• Query the database using SQL Advantage for testing and verification purposes.
• UAT testing performed along with call center managers to make sure that application meets their requirements.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process

Environment: Microsoft Office Suite, DB2, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Biztalk, Sybase, XML, Crystal Reports, VBScript, C#. DOORS, C++, NET, Agile/Scrum, Business Objects, TestDirector, LoadRunner

Confidential, Chicago, IL

Business Analyst/Data Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Conducted extensive requirement analysis using Rational requisite pro
• Performed business using casewise modeller
• Thoroughly studied the requirements for the process re-engineering
• Captured requirements for Biztalk messaging server
• Developed a change management and tracking process using MS-TFS (Microsoft Team Foundation Server)
• 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.
• Analyze B2C and B2B web properties and create new business plan, business requirements, and staffing requirements
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Environment: Microsoft Office Suite, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Biztalk, Sybase, VBScript, C#. DOORS, C++, NET, ASP.NET, TFS, Business Objects, TestDirector, LoadRunner

Confidential, Indianapolis, IN

Business Analyst

Responsibilities:

• Prior supply chain/ERP/WMS solutions. Food Service preferred.
• Performed Functional, GUI, Regression, System Integration, User Acceptance, Configuration and content testing for web-based ECommerce application and Content Management System.
• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Worked with business owners, Credit Derivatives and Fixed Income Derivatives Business Intelligence, IT and other stakeholders in creating a content management solution for managing the information in the Trinity Tool (Excel)
• Tested application security features, including session expiry, book marking, passwords and compatibility across multiple browser types and encryption levels.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Imported Sources and Targets, Created Mappings and developed Transformations using Informatica PowerMart designer.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Worked with Product Owners to identify current processes and created Business Process Flow diagrams.
• Designed and implemented basic SQL queries for testing and report/data validation
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.

Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, MS Word, MS Excel, MS Access, Agile/Scrum, MS Project, Java, MS Power Point,, ASP.NET, SQL Server, Windows 2000.