DEEPTHI RAAVI

Long Island,NJ 361-***-****

ac13rf@r.postjobfree.com

PROFILE:

Over 2+ years of professional experience as a Business Analyst with a strong understanding of Business Analysis, System Analysis, Business Process Management and Business Process Modeling.

Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.

Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.

Effective communicator leading various information gathering meetings, user interviews, Joint Application Development (JAD) sessions and presentations.

Effective in establishing project plan and milestones, managing scope and in helping ensure that timelines are met.

Strong knowledge of business accounting rules maintained for General Ledger generation to support Cash and GAAP.

Proficient in developing Wireframes, Use Cases, Data Flow Diagrams, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams, Class Diagrams, Entity Relationship Diagrams and Business Process Diagrams. .

Experienced in developing Object Oriented Analysis and Design Models; Use Case Model and UML.

Well versed in project management tools like MS Project for project planning, Project scheduling.

Prepared documents to conduct user acceptance testing.

Good Knowledge of Unified Modeling Language (UML), Class Diagrams, Use Case Diagrams, Activity Diagrams, Sequence Diagrams.

Participated in preparation of Root cause analysis (RCA) documents

Agile Mangement and Software development with Extreme Programmming, Scrum, RAD and Agile RUP

Team player and self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills.

Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing.

Ability to identify and manage/support business implementation tasks and process changes

Assist PMO Management and other team members with project management support, including budgeting, planning, and organization.

Responsible for significant, enterprise-wide projects, typically with large budgets and sizeable staff, focused on meeting project objectives, including communications with sponsors, and stakeholders.

Conducted JAD sessions with supply chain management and development team to brain storm Point of Sale (POS).

Proficient in writing SQL queries for data analysis and validation.

Capable of developing business and clinical requirements documentation

Consults with functional unit management and personnel to identify, define and document current operational processes

Ability to provide data mapping and system mapping matrice

Expertise in developing QA Test Plan, Test Conditions, and Test Cases to ensure complete and adequate testing as well as coordinating and conducting User Acceptance Testing (UAT).

Diligent team player with enhanced analytical, communication, organization and leadership skills.

Tactful resource in managing user request changes and user conflicts.

TECHNICAL SKILLS:

Tools:

UML, Rational Rose, Requisite Pro, Clear Quest, Clear Case, Microsoft Visio, DOORS, MS Word, MS Excel and MS PowerPoint, Microsoft Office Sharepoint Server (MOSS), Business Objects, Content Management (CMS), Mercury Test Director, JIRA bug tracking tool, BugZilla, ERwin, MS Dreamweaver, MS Photoshop, UPerform, SnagIT,RALLY

Modeling Techniques:

Use Case Modeling, UML (Use case, Sequence diagram, Activity Diagram, Class Diagram, Entity Relationship Diagram), Object Oriented Analysis and Design

Methodologies:

RUP, RAD, Waterfall, Scrum and Agile

Operating System:

Windows, UNIX

Database:

SQL, MS Access, PLSQL, Oracle

Certification

Six Sigma and Scrum

PROFESSIONAL EXPERIENCE:

DealerTrack, LongIsland, NY JAN’17-Till date

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.

Resolution of complex requirements conflicts through effective stakeholder engagement

Ability to track work performed, work remaining, and quality testing

In conjunction with the PMO, supervise and nurture vendor relationships to ensure success of solution and process implementations.

Understanding of change control processes especially in relation to requirements documentation

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.

Strong customer service ethic with an understanding of how IT is ultimately delivered to the Customer

Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.

Worked with Finance users to customize NetSuite to suit business.

Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with Netsuite eCommerce suite.

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.

Worked within the operations team to come up with a report of analytics on a daily basis using Omniture.

Created wireframes and storyboards

Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.

Identified and addressed data issues affecting data integrity using MDM (Master Data Management) standards.

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 schedule 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.

.

Environment: Windows Advanced Server, UNIX / Oracle Platform, SQL, Omniture,MS Visio, CMS, RALLY,MDM, RUP, Rational Rose, Rational Clear Quest, Rational ClearCase, Rational requisite pro.

SourcePRo,Pittsburg,PA Jan’2016-Dec’2016

Business Analyst

Responsibilities:

Served as a liaison between various business units and information technology groups.

Conducted Architectural Discussions to prepare the Proposed Architecture and provided insight in the Business Case to the Architecture Review Board (ARB).

Involved in implementing homemade (POS) Point Of Sale system for US retail/Online stores.

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

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

Performed Business Process Mapping and performed AS IS and TO BE analysis

Worked together with other team members in interviewing various business groups and identifying and prioritizing business and functional requirements.

Performed extensive data analysis with other functional analysts on data received from various sources and in different formats.

COTS testing and Vendor integration experience.

Worked together with SME, architecture group and technical team leads to detail the interface, customized based on different user roles and functions.

Mapped the current and proposed process and conducted thorough GAP analysis

Generated Use Cases, Use Case Scenarios, Activity Diagrams and Data Flow Diagrams.

Co-authored Functional Requirements and Specification Document.

Work with marketing POS programs and allocate/calculate budget distribution among region for various programs

Performed defect tracking and maintaining trailing history of bugs.

Assisted the database development team in data modeling, data structure and data table layouts required for consolidation of incongruent databases,

Involved in writing test plan, test cases and test scripts for end-to-end testing.

Reviewed test results and reported bugs/issues using Mercury Test Director.

Assisted in UAT and end user training.

Involved in various other enhancement initiatives to include new functionalities and redesign.

Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, Rational Unified Process (RUP), CMS, Windows, UML, UNIX, MS-Project, MS-Office Suite, Casewise Corporate Modeller, WinRunner, Test Director

Sudo Saints,India JUNE’13 TO JUNE’14

JR.SQL Server Developer/Intern

Responsibilities:

• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, and Implementation.

• Writing complex SQL Queries, Triggers, Cursors and User Defined Functions to implement the business logic.

• Created Indexes on selective columns to speed up queries in SQL Server Management Studio.

• Used Team Foundation Server (TFS) for version control.

• Created new stored procedures and modified existing procedures depending upon the business requirement.

• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

• Involved in Designing, Developing and Testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source feeds using SSIS.

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loading the data into target data sources by performing different kinds of Transformations using SSIS.

• Worked on various Tasks and Transformations like Execute SQL Task, Execute package Task and conditional split, Script component, Merge and Lookup while loading the data into Destination.

• Scheduled SQL Server Agent jobs to run the packages on daily and hourly basis.

• Experienced in developing Custom Report and different types of Chart Reports, Tabular Reports, Matrix Reports, Drill down, Drill Through, Detailed, Summarized, List reports in multiple formats using SQL Server 2008 R2/2012 Reporting Services (SSRS)

• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

• Troubleshoot the performance of SSRS Reports and subscription issues in it.

• Responsible for designing data warehouse structures and ETL requirements.

• Created a new data mart for Data warehouse and loaded the Dimension and Fact Tables from the Source tables.

• Maintained enterprise Reporting based on specifications and business needs and modified existing reports as needed.

Environment: MS SQL Server 2008/2008 R2, AS400,SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Visual Studio 2010.

EDUCATION:

Master of Technology in Electrical Engineering,Texas A&M University Kingsville.

Bachelor of Technology in Electronics and Instrumentation Engineering, JNTU, India.

REFERENCES:

Available upon request

Contact this candidate