SUMMARY:

• Around 8 years of experience in Retails, Finance and Supply Chain domain. Extensive expertise in Business Systems Analysis, Financial Analysis Oriented Software Analysis documenting, developing process flow diagrams.
• Knowledge and understanding of Futures, Options, CDO, CDS, CMO, MBS, Interest Rate Swaps, Credit Derivatives, Swaps, Bonds, Equity Swaps, Capital Markets, Fixed Income, Structured Products..
• Expertise in configuring Oracle Supply Chain and Manufacturing modules, with excellent functional experience in Implementation, Upgrade, Enhancement, Testing, Production Support, Customization of Business Applications, Conversion, User Training, Analyzing Business requirements and writing functional design specifications.
• Defined and developed specifications for financial products; initiated associated project development.
• Information Systems, Manufacturing (CPG) and Health and Fitness industries exposure to all phases of the Software Development Life Cycle (SDLC).
• Proficient in the implementation of production change management techniques and service delivery disciplines
• Proficient in industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), CMM (Capability Maturity Models) and Agile.
• Facilitated JAD and JRP session with executives and project managers, prepared workshop materials and organize workshop activities.
• Experience in writing Business Requirements Specifications, Functional Requirement Specifications and maintaining the Requirements Traceability Matrix (RTM’s).
• Sound proficiency in analyzing and creating Use Case Diagrams, Class Diagrams, Activity Diagrams, Data Flow Diagrams and Sequence Diagrams based on UML methodology using Rational Rose.
• Experience of Unit Testing (UT), System Integration Testing (SIT) and User Acceptance Testing (UAT) as well as Defect Tracking.
• Hands on experience of SQL - Data Manipulation Language (DML), Data Definition Language (DDL) and Data Control Language (DCL).
• Assisted data analysts to develop logical data models, source data cleansing and data profiling. Essentially applied business rules in the transform phase.
• Thorough understanding of As-Is Process, designed To-Be Process, gathered business requirement, performed gap analysis, throughout all phases i.e. CRP’s, Testing, Go Live and Production Support
• Demonstrated leadership ability to resolve issues, drive projects, and meet deadlines. Excellent interpersonal and communication skills with the ability to understand both business and technical needs from the clients and customers.

TECHNICAL SKILLS:

Methodologies: UML 2.0, Rational Unified Process (RUP), Rapid Application Development (RAD), Agile Development

Business Tools: Word, Excel, MS Project, Visio, Rational Rose, Requisite Pro, Rational SODA, Clear case, Clear quest.

Documentation Tools: Rational Requisite Pro, MS-Word, Excel, Project, PowerPoint.

Testing Tools: HP Quality Center, Quick Test Pro (QTP),JIRA Business Intelligence OBIEE, Business Objects XI

Languages: C, C++, Java, SQL, SAS and Visual Basic 6.0. RDBMS

ERP Tools: MS-SQL, MS Access, Oracle

Netsuites, Supply Chain & Manufacturing: Oracle Warehouse Management System, Oracle Inventory, Oracle Order Management and Shipping, Oracle Bill of Material, Oracle Work in Process, Oracle Purchasing, Advanced Pricing, and Mobile Applications

PROFESSIONAL EXPERIENCE:

Confidential, MI

Sr. Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain 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.
• 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).
• 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.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• 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, SQL, MS Visio, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, FastTrack .

Confidential, KS

Sr. Business Analyst/Data Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Helped in defining Change Management Process for Release Management Team.
• Employed Rational Clear Quest for effective Change Management (Requirements Creep) and bug tracking during the testing lifecycle.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor. 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.
• Conducted extensive requirement analysis using Rational requisite pro
• Thoroughly studied the requirements for the process re-engineering
• 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.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• 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.
• Working 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.
• Written smoke test cases in Quality Center and modified them when they are automated.
• Involved in environment requirement gathering meetings and giving inputs to the environment teams.
• Developed QA Test Plan from technical specifications and requirements for this project which deals mainly with three areas i.e. presentation tool, integrated genesis selling tool and catalog API.
• Manually tested the whole application before going for the automated testing.

Environment: MS Visio, MS Project, UML, Agile, ATG eCommerce, Microsoft Office Suite, Documentum, Windows NT/XP

Confidential, Seattle, WA

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.
• 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. Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables. 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
• Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Created source table definitions in the Data Stage Repository by studying the data sources by importing the data from Mainframe.
• Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Generated XML documents using the XML Output Stage.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, DataStage BASIC language Expressions, SAP SD, SQL Server, Windows NT 4.0, Visio, Sybase, UNIX, Oracle 8i, PL/SQL, IBM DB2, Dbase3, Erwin, MS Access, XML Files, MVS, IMS.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Involved in all phases of software development life cycle (SDLC) in RUP framework.
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
• Held responsibility for creating business flow diagrams and charts for E-commerce using MS Visio
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Extensively interacted with both user group and development team.
• Managed and tracked change control process of requirements and design changes. Documented the changes, issues and their impact on the system design and delivery.
• Provided documentation such as requirements management plans, functional requirements, test plans and test cases.
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology using Rational Rose
• Performed requirement analysis by gathering both functional and non functional requirements based on interactions with the process owners & stake holders and document analysis. Performed user interviews.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Exclusively worked on writing test plan, test cases, test scripts, test reporting,
• Data Driven Tests using LoadRunner to verify database values to ensure group login transaction accuracy and database integrity.
• Manually tested and GTS modules using Quality Center
• Checking the system behavior with multiple values of data for regression testing using LoadRunner and enhancing the scripts for Reusability and Modularity.
• Performed backend testing by using SQL.
• Logging defects and writing test cases in Test Director.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Created test cases and test scripts
• Worked with Mercury test director
• Conducted User Acceptance Testing (UAT), Unit testing and System testing

Environment: Oracle 8x/9i, Asp. Net, MS Project, MS Office Suite, RUP, UML, Microstrategy, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS office suite 2003, MS Visio 2003, Mercury test director.

Confidential

ORACLE BUSINESS ANALYST

Responsibilities:

• Working on the onsite and offshore model and handling a team of 5 offshore members in terms of defining requirements, allocating tasks, reviewing and of work.
• Responsible for gathering and analyzing Business and system functional requirements and for understanding and translating these needs into Business Requirement Specification (BRS), System Requirement Specification (SRS) documents, Client requirements document (CRD), and Functional specification document (FSD).
• Responsible for creating functional specification documents for the design, development and implementation of project.
• Responsible for creating functional specification documents for the design, development and implementation of project.
• Validating EDI’s files in different format and preparing layout for the data transports for claim, payment, and provider processes.
• Supporting, Assisting and advising Project Director and Program Manager from time to time for Project Management and taking decisions on various aspects of the project like performance metrics and non-functional requirements.
• Responsible for conducting Gap analysis for the assigned projects. Prepared Data Flow Models for Claim, Payment and Post Payment Process Workflows.
• Working on daily product support CRM tickets and closing them in timely manner.
• Involved in creating test cases based on requirements and use cases.
• Performing User Acceptance Testing (UAT) as the project advances.