SUMMARY:

• Business/Systems Analyst with 6+ 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.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• 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.
• 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
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases,
• 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, Dallas, TX .

Business Analyst/Project manager

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contains the essential business elements and detailed definitions.
• Helped the client decide on the best vendor solution
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Worked with the clients banking partners to finalize the certification
• Gathered requirements for the integration of the payment terminals
• Extensively used MS Project for project management
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Worked with various vendor groups to gauge the effectiveness of their solution
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Created wireframes and storyboards
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, RUP, Rational Rose 2002, Rational Clear Quest, Rational Clear Case, Rational requisite pro, rational test manager, Rational Robot

Confidential, Bensalem, PA

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analysed 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
• 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, Hoffman Estates, IL

Business Analyst /Project manager

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contains the essential business elements and detailed definitions.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Worked with OSX Leopard and MS office Suite for MAC
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Created wireframes and storyboards
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Used FastTrack schedule9 for planning, tracking, and reporting project goals
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, FastTrack

Confidential, Warminster, PA

Sr. Business/Systems Analyst

Responsibilities:

• Assisted in creating File Maintenance use case inventory.
• Gathered requirements from business users and by going through COBOL programs, legacy use cases, and program specs.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerMart, PL/SQL.
• Acquisition Operations will be responsible for analyzing many areas of the business, including but not limited to: receipts routing, planning, receiving, buying, shipping, inventory management, grading, item number creation and purchase order management
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement document FRD, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Managed cutover of master data from existing information system into SAP system. Created and performed program specifications for scripting to extract and prepare data for import into SAP database.
• Identified and retail procedures for emerging retail chain
• Developed documentation for POS Systems including Corporate Policies
• Involved in testing the SOAP messages across the web site and made sure results returned in XML format
• Documented requirements for management reporting out of Clear Quest using Crystal Reports
• Worked on implementing software development projects using methodologies such as Waterfall, Rational Unified Process, and Agile/Scrum.
• Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new Dynamics CRM database
• Worked extensively with SME in understanding and documenting their requirements pertaining to monitoring changes and portraying a trend to maintain and analyze customer needs and many other business areas.
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
• Translated Business processes into Informatica Mappings for building Data marts.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Consolidated the analysis of multiple business lines after the COTS evaluation Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Gathered requirements for the integration of POS system with the supply chain system

Environment: MS Visio, MS Project, UML, DB2, Agile, MS Dynamics Ax 2009, ATG eCommerce, XML,Microsoft Office Suite, Documentum, Windows NT/XP