SUMMARY:

• An accomplished Business Analyst with 7 years of IT experience involving expertise on different domains.
• Proficient in process modeling/mapping, requirements gathering/management, systems analysis and design.
• Experience of working with MS Project to develop and monitor project plans.
• Strong command on SWIFT messaging.
• Comprehensive experience in Project Management, cost/benefit analysis, testing, development of business requirements specifications, and project planning working with project managers and business sponsors.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Strong knowledge of Agile PLM, scrum processes and experience in redesign of product development process as per the business requirement.
• Expertise in PLM(Product Life Cycle Management), MDM (Master Data Management)
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
• Worked with the following module suites: Oracle Financials (GL, AP, AR), Discrete Manufacturing(INV, BOM, WIP, Cost, PO), Supply Chain (Order to Cash, Procure to Pay, WMS),
• Extensive knowledge of standard SDLC methodologies, including RUP, MSF, Prototype and Spiral.
• Solid Experience in developing Scope/Vision Documentation and Project Plan.
• Strong Knowledge of SDLC, RUP methodology, and Project life cycles.
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
• Worked on PLM team center.
• Direct and manage the Change Management Control process for the projects by facilitating group meetings and/or one - on-one interviews/meetings with work stream owners to discuss change request impact on timelines and scope
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.
• Expertise in the management of User Request Change, and handle User Conflicts.
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing of software both before and after completion; conducting and documenting UAT.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.

TECHNICAL SKILLS:

Languages and Tools: UML, Rational Rose, RequisitePro

Rational SoDA: Rational Clear Case, Rational Clear QuestMercury Test Director:, MS Project, MS Visio, MS Office Suite, Product Lifecycle Management

PLM XML: Teradata, AGILE/SCRUM, Team Viewer, Bloomberg,VBA for Excel, Oracle Process

Manufacturing: (OPM) modules, distribution systems, SQL, PL/SQL, Java, J2EE, C#, VB.NET, C++/CLI, RDBMS, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX

Databases: Oracle 8i/9i, MS SQL Server, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. PLM Business Analyst

Responsibilities:

• Analyzed business needs and defined requirements with cross-functional teams
• Identified initiatives that improve product development and deployment processes
• Designed, developed and validated configuration and customization changes
• Propagated validated configuration and customization changes to production environment in alignment with defined release cycles
• Archived the documents using Team Center.
• Responsible for change management process.
• Managed release activities - created change request, obtained approvals, developed deployment plan, conducted knowledge transfer to support teams and coordinated go-live activities
• Provided Agile PLM Application Support - configuration, customization and on-demand reports
• Worked with Oracle Support in analyzing and identifying root cause for Agile PLM issues
• Successfully developed proof of concept to validate Agile PLM 9.3.2 to Agile 9.3.3 and Oracle 11g to 12c upgrade
• Communicate and interact directly and indirectly with clients and customers to gain their business' insights for improvement and enhancements of dispatching and electronic document managementsoftware applications.
• Designed custom utilization ad-hoc reports to support business decision making
• Automated interfaces (via action menu and workflow) to external systems using process extensions to eliminate manual user input and maintain data consistency
• Independently troubleshoot and resolve issues related to data, report design, product distribution and performance
• Performed on-demand data migration activities from Legacy applications

Environment: Oracle Agile Plm 9.3.2, Oracle Db 11.2.0.1.0, Weblogic 11g, Oracle Agile Plm Datamart 3.2.0.2.3, Aut, Averify, Acp, Linux

Confidential, Peoria, IL

Business Analyst

Responsibilities:

• The Project was involved in Data Warehousing which was developed to integrate operational systems into one central database structure. Informational queries can be obtained from the Data Warehouse that identifies customer behavior patterns.
• Responsibilities:
• Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Maintained & kept track of Stakeholders' requests for enhancements and changes using Unified Change Management tools (UCM
• Maintained the administration tool to control user access to Agile-PLM client services.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Played the role of a Business Process Analyst for a Team Center Enterprise to Unified Migration
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Used Test Director, PL/SQL for testing the application
• Develop Logical and Application virtualization, sequencing, packaging, and distribution
• Provided strategic direction and leadership to product area including engineering, quality, supply chain, and manufacturing support for sales / marketing
• Gathered and documented requirements for integration between TradeStone Product Lifecycle Management (PLM) solution and legacy system.
• Utilized corporation developed Agile SDLC methodologyPhysical data models that capture current state/future state data elements and data flows using Erwin.
• Application virtualization, sequencing, packaging, and distribution
• Provided strategic direction and leadership to product area including engineering, quality, supply chain, and manufacturing support for sales / marketing
• Gathered and documented requirements for integration between TradeStone Product Lifecycle Management (PLM) solution and legacy system.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Maintained the administration tool to control user access to Agile-PLM client services.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Deep understanding of Structured System Development Methodologies
• Created Process Flow diagrams and Business Rule Wireframe components to identify and visualize the redundancy. Manages small teams and work efforts for Agile PLM Projects.
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Developing Sourcing and Vendor management within PLM software to handle third party selection, first piece qualification, order fulfillment and financial settlements.
• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Created standard test case template according to the company requirements and standards.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Used MS Visio for Process modeling and Business Process flow diagrams
• Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.

Environment: Windows, MS Access, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), Team Center, ETL, .NET, Oracle, JCL, Crystal reports, RUP, UML, SQL, SWOT, Teradata, AGILE, ClearQuest, GAP Analysis, Win Runner

Confidential, Detroit, MI

Business Analyst

Responsibilities:

• Involved in writing Business Requirements Document, User Stories and Use Case Specifications, Functional Specifications, System Design Specification (SDS), System Requirements Specification (SRS), Business Continuity Plan (BCP), and Workflows.
• Followed agile software development methodology and developed UML (Unified Modeling Language) diagrams, such as Use Case Diagrams, Activity Diagrams and Flow Charts.
• Participated in meetings, walkthrough sessions with the Project Manager, SME, and the team.
• Conducted research on various payment means like mobile payment, cash remittance, fuel/fleet card payment, ecommerce and payment gateway.
• Provided mapping of XML from Auto Web to policy management system
• Prepared SIPOC (Suppliers, Inputs, Process, Outputs, Customers) for all the releases.
• Performed the task of a Scribe during meetings.
• Served as a liaison between business users, testers and the technical team to keep all in the same page and understand business needs.
• Created DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse
• Develop technical documentation for client distribution
• Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Maintained regular interaction with the development team, database designer and the higher management authorities to meet the project deadline.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Prepared FAQs (Frequently Asked Questions) and troubleshooting guide for the support team.
• Conducted UAT for the entire website and charging system via using the GE Watt Station Connect Application.

Environment: MS Word, MS Excel, Agile, MS Power Point, Java, .Net, Quality Center, MS Project, Windows, Oracle, My SQL Server, MS Visio, Sales Force Rally, SharePoint, HPQC, Documentum.

Confidential - Palo Alto, CA

Business Analyst

Responsibilities:

• Studied the existing business process and played a vital role in the GAP analysis and business blue print creation of the business process.
• Prepared product backlog working with Product manager and other SMEs'
• Prioritized user stories and assigned to different iterations.
• Facilitated daily stand ups and managed task board with user stories and tasks
• Prepared and tracked burn down charts and velocity charts for timely delivery of projects.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Worked on the business requirements of import and export process of Foreign Trade, maintain the data and configuring the respective settings.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Involved in creating BRD and FRD, use case and UML diagrams to communicate the intended system functionality and execution to developers.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Troubleshooting in the areas of purchasing, Security (SRM) and sales and handled day to day tickets.
• Worked on creating UAT documents and verifying the test data according to the new configurations for all SD business processes and getting sign-off after successful completion of testing.