Project Manager

Devi Medasetti

Email: **.***********@*****.***

Contact: 626-***-****

SUMMARY

Professional with 8+ years of diverse experience in IT as a Business Analyst in the fields of Finance, Banking, Healthcare and Insurance.

Experience working in all phases of Software Development Life Cycle (SDLC), involving User requirements study, Business requirement document, Application Design, Coding, Unit Testing & Integration Testing. Possess excellent technical Writing, analytical & Problem solving skills.

Proficient in understanding Business Requirements, Gathering Business Process Modeling, Business Process Flow, and Business Analysis.

Solid understanding of different business management strategies in Business Processes such as Business Process Automation, Business Process Improvement and Business Process Re-engineering.

Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).

Excellent documentation of requirements gathered using interviews, Brainstorming Sessions, Surveys and Questionnaires; Evaluating Data Sources, Translating Requirements into Specifications and Application Design.

Design, documentation and review of business documents like Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specifications (SRS)

Experienced in Business efforts in understanding sales pipelines, and contract details.

Competent in creating Unified Modeling Language (UML) diagrams for Business Process Modeling like Use Case Diagrams (UCD), Activity Diagrams (AD), Sequence Diagrams (SD), Data Flow Diagrams (DFD), and Flow Charts.

Supported Value chain management capability, Product Implementation and Reverse Engineering.

Expert in Tracking and managing the requirements using Requirement Traceability Matrix (RTM) that links and controls numerous artifacts produced by several teams across the deliverables of the project.

Assisted QA team in generating test plans, test scenarios, test cases, and managed complete defect tracking life cycle using various defect tracking tools

Expertise in Functional Testing to ensure a quality product and rich experience in conducting User Acceptance Testing (UAT) to guarantee all the business requirements have been fulfilled by the application

Knowledge in the ETL (Extract, Transform and Load) of data into a data-ware.

Exposure to Client/Server, Web Application Development tools and Software Development and Design.

Excellent analytical and problem solving skills; listening, oral, and written communication/presentation skills

TECHNICAL SKILLS

Business Modeling and BI Tools

OOAD (OOA/OOD), RUP, UML, SDLC,Microsoft Visio, Agile, Waterfall, Power Designer, Quality Analyst(QA),Business Objects, Web Intelligence, Live Office, Rational Rose, Rational Clear Quest, Tableau, UML,(RUP), UML

Project Management

MS Project, Requisite Pro, Dashboard Manager, Crystal Reports

Programming Languages

MySQL, PL\SQL, Visual Basic

Databases

MS Access, SQL Server, Oracle DBA

Operating Systems

Windows 95/98/NT/2000/XP/Vista/7/8, UNIX, MS Dos

Software

MS Office Suite (Word, Excel, Access,Visio, PowerPoint & Outlook)

PROFESSIONAL EXPERIENCE

Wells Fargo, Charlotte, NC Oct 2014 – Till Date

Sr. Business Analyst

Wells Fargo & Company is an American multinational banking and financial services holding company which is headquartered in San Francisco, California, with "hub quarters" throughout the country. The project involved moving from their legacy advisor compensation system to up to date version of vendor’s compensation system along with complete infrastructure upgrade capable to meet the growing business needs. The project also involved redesigning business process flows to streamline and automate current manual process

Responsibilities

Served as a liaison between project managers, stake holder team, and software development team to gather requirements and documented workflows and results into the Business Requirement Document (BRD).

Prepared Functional Specification Documents (FSDs) for various business functionalities by translating BRD’s.

Documented and delivered Functional Specification Document (FSD) to the project team.

Conducted Joint Application Development (JAD) sessions with business unit owners and technical team to capture business requirements and system behavior.

Captured and made executive presentations of the issues and risks inherent in as-is process for review by senior management.

Worked on Spread sheets to adjust Stored values and get effects on calculate values.

Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance

Created and applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagrams.

Ensured requirements specifications are formatted for ease of consumption by project stakeholder and technical teams.

Conducted walkthroughs with Development Team and facilitated UAT with Business Stakeholders/Users.

Developed activity diagrams (AD), sequence diagrams (SD) and object oriented design (OOD) for the software development team.

Traced and informed business requirement changes through the lifecycle of the project using Rational RequisitePro while maintaining customer needs and maintain a Requirements Traceability Matrix (RTM).

Managed the stakeholder expectations and facilitated clarifications between project stakeholder and technical teams throughout the duration of the project.

Performed gap analysis between current performance and desired performance (i.e. critical customer requirements).

Created Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.

Worked on OLAP to answer multi-dimensional Queries.

Environment: MS SharePoint, MS Office (Word, Excel, Power-point, Access), MySQL Server, OOD, UML, Agile, Waterfall, Rational Rose, Rational Clear Quest, Rational Requisite Pro, RUP.

United Health Group Rockwell, CT Nov 2012- Sep 2013

Business System Analyst

Responsibilities

Acted as a liaison between system users, client managers and software development team to gather requirements and document workflows and results of Financial Analysis into the Business Requirement Document (BRD).

Converted business requirements into functional requirements, created Functional Requirement Document (FRD), managed and maintained requirements traceability using Rational’s Requisite Pro.

Prepared Business Workflow models and used agile software development methodology to build new business processes.

Monitored actual financial performances against budgets and forecasted data to determine business needs.

Functioned as a forecasting and budgeting for client requirement.

Worked with other Business Analysts, Project Manager and software development team through the life cycle of the Project.

Re-engineered the business model using data modeling tools using Rational Rose and Visio.

Conducted and participated in JAD Sessions periodically with various Subject Matter Experts at various phases of the Development Life Cycle to discuss open issues and resolve them.

Worked with User Interface (UI) team to create report mock up’s from wire frames to ensure that functionalities are captured and presented on the front end as per the BRD’s.

Worked closely with the business team and stake holders to gather accurate business requirements for the project.

Worked with different IT & Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects

Created and maintained end-to-end data mapping and data conversion spreadsheet.

Extensively worked on MS Excel, MS PowerPoint, MS Project, MS Visio and MS Word.

Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data.

Involved in Gap Analysis and assisted the development team to understand the process.

Mediated discussions, influenced, negotiated as needed to make progress towards achieving solutions.

Environment: MySQL Server, MS Project, MS Visio, MS Office (Word, Excel, Power-point, Access), Agile, Rational Rose, Lotus Notes.

AMERIPRISE Financials, New York, NY June 2010 – Oct 2011

Business System Analyst

Ameriprise Financials is one of the large Investment banks in the mid-west region and has the highest number of in-house and outside distributor’s financial advisors. The project involved understanding the current functionalities of Charles River Trading system and decommissioning the legacy system and merging both the entities of Long view trading system ensuring all the existing functionalities are met by new system

Responsibilities:

Conducted JAD sessions with management, Subject Matter Experts, vendors, users and other stakeholders to document current as-is front to back bank operations.

Was involved in vendor discussion to identify functionalities that was mandatory verses good to have. Based on the discussion documented business requirement for Trade Notification Manager for LVTS system. Also performed GAP analysis and identified the functionalities that were missing in the new system.

Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Created UML based Use Case Diagrams and Data Flow Diagrams. Developed Class Diagram, Sequence Diagram and ER Diagram using MS Visio

Created test plans and test cases using Mercury Quality Center

Simplified reporting solutions by using MS OLAP and MS Excel.

Worked on Data Warehouse to create Analytical reports for knowledge.

Helped the testing team in tracing the requirements from Requirement Traceability Matrix and involved in the User Acceptance Testing

Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place

Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.

Played a key role in the planning, User Accepted Testing, and implementation of system enhancements and conversions

Environment: RUP, Windows 2000, Java, SQL, PL/SQL, Oracle 9i, SQL server 2000, HTML, XML, MS Visio, MS Excel and MS Word. MS Project, Mercury Quality Center, Requisite Pro

Liberty Mutual, New York, NY Oct 2008 – May 2010

Business Analyst

Liberty Mutual is one of the largest insurance companies dealing in commercial as well as personal lines of insurance. The project was to automate the claims processing systems and enhance the CRM (Customer Relationship Management) by providing real time monitoring for its auto insurance division.

Responsibilities

Defined, prioritized, and tracked requirements throughout the project lifecycle, software development teams are able to respond rapidly to ever-changing requirements without risking the project success.

Provided support to loan officer and underwriter teams by ensuring the timely, judicious and accurate processing of mortgages.

Worked on Data mining, Visualization, Data Management and online updating.

Performed analysis on project scope parameters (gap analysis, usability, cost /benefit.)

Assisted in Reuters Market Data System (RMDS) for Open Market Data programs, using Multicast and Broadcast Technology.

Analyzed Business Requirements, reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.

Worked with production staff to identify and map detailed current processes, identified gaps and failure points with the legacy data management system, performed root cause analysis and developed functional requirements that supported overall strategy, goals and objectives for the new IT Architecture.

Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.

Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram in Rational Rose.

Conducted JAD sessions to get SME’s input on how to implement the application for core credit card production and billing.

Examined and analyzed Test plans, Test Scripts, & Test procedures based on RUP methodology.

Tracked reviewed analyzed and compared defects using test director.

Presented management reports to the project manager in handling whole project.

Environment: Rational Rose, MySQL Server, MS Project, MS Visio, MS Office Suite (Word, Excel, Power-Point, Access), RUP, UML, MS Project

Client ICICI Prudential, India May2006–August 2008

Business Analyst (Sales & Marketing)

Description: ICICI Prudential is an Indian national provider of life insurance and annuity products. ICICI group is composed of two business segments a) protection products by ICICI Prudential Life Insurance Group, and b) accumulated products by ICICI Annuity Group (ICICI AG). ICICI Prudential does not have a policy owner’s website, while its competitors have. This lead to a limited opportunity to communicate and serve policy owners, like information about new products their features, cross selling of other products from ICICI Prudential product portfolio. This project is conceived to actively engage policy owners and to address above mentioned problems.

Responsibilities

Developed business relationships between external and internal clients, sales, managers and the development teams to establish project timelines and coordinated priorities to meet implementation deadlines.

Collaborated with developers and subject matter experts to create proper data models and mapping the data connections between models, analyzing tradeoffs between usability and performance needs.

Created Project Plan, Risk Mitigation Plan, Project Scope Document, Software requirement Specification, Project Glossary.

Elicited requirements by sessions including use of interview, document analysis, workshops, adapting in determining appropriate requirements capture and management methods including but not limited to use cases, diagrams and process flows.

Translated business requirements into high-level and detailed functional specifications

Using MS Office suite components for documenting, traceability, project tracking, documentation, and presentation to senior management.

Interfaced between Business new product builders and System platform builders.

Worked with systems area to translate business needs into system requirements.

Made sure the test cases and test process guarantee accountability to business and systems requirements.

Involved in the testing phase right from the Unit testing to the User Acceptance testing.

Environment: UML, MS Visio, MS Project, MySQL Server, MS Project, MS Visio, MS Office Suite (Word, Excel, Power-Point, Access), Rational Rose, Oracle DBA

Contact this candidate