VIJAYA NARAPUSETTY

EMAIL: ac19zd@r.postjobfree.com CELL # 248-***-****

SUMMARY

3+ years of IT experience as Business Analyst/Data analyst/ expertizing in all stages of application SDLC encompassing requirements gathering, analysis, design, testing, implementation and support.

Facilitated requirements elicitation sessions with project stakeholders, SMEs, and a variety of teams to understand requirements and specifications for new applications along with the enhancements.

Skilled in creating test cases and performing Manual Testing like Regression, UAT, End to End, Integration and Unit Testing. Also tested using Testing Tools like Test Director, HPQC, HPALM.

Utilized Rational Rose and Visio for creating Use Cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models.

Prepared Business Requirement Documents (BRD) and converted into functional specifications utilizing Rational Requisite Pro management tool.

Conducted many JAD sessions for effective communication of views between stakeholders and performed ETL for data reporting within a data warehouse environment.

Utilized SQL queries for testing to ensure data integrity.

Gained knowledge of Automotive Bill of Material systems and Structures (CMMS) for my Master’s program at Ford.

An year of Financial Accounting Experience with my Recent Project and as well as part of Master’s Project.

TECHNICAL SKILLS

Activity diagrams

Agile, SDM Methodologies

CICS

COBOL

DB2

ETL

HTML

JCL

JDBC

MS Office Suite

MS Project

MS SharePoint

MVS

Process Mapping

Rational Requisite Pro

RUP

SDLC

Sequence diagrams

SQL Server

SQL

Tera Data

Test director

UML

UNIX

Visio

TRAINING AND CERTIFICATIONS

ITIL Certified - V3 Foundation for Service Management from CSME

PROFESSIONAL EXPERIENCE

Ford, Dearborn, MI

January 2014 – April 2014

RS&W - Business Analyst, (January 2014 – April 2014)

Worked on RS&W which is a global application based on Tool to track the Head count Contain ability for different cycle plans.

Involved in Many JAD sessions with SME’s to discuss the views based on the requirements for the Tool.

Responsible for the reviewing the Requirements based on the versions for testing the tool.

Worked on Several requirements for prioritizing the scope.

Worked on Financial part of the resources, staffing and workload globally.

Reviewed Business created EA Models and mapped the requirements to the Requirement Traceability matrix and found out the Assumptions & GAPS.

Created Test cases for different versions and validating the requirements based on the released Versions for all the Environments (Dev, QA).

Worked with the QC Team for validating the requirements for the Tool based on the released Versions.

Environment: MS-Visio, MS-Word, MS-Excel, PowerPoint, Planisware Tool, Share Point.

GCH _ Big Six Supplier Tooling - Business Analyst, (March 2013 – December 2013)

This Project is based on loading the Historical data from different source systems and taking them into the EDW as part of ETLIN’s and later mapped this to the output data as ETLOUT’s through a Pipeline to the Endeca for reporting.

Gathered requirements and followed the appropriate SDM methodologies to Document the requirements. E.g., 230 based business requirement documents (BRD), 62 Doc for Screens /Reporting, 72 Doc for Use cases.

Responsible for creating the Data Flow Diagrams, Business Process flow using MS-Visio.

Created the mapping for the data transformation between IN’s and OUT’s.

Responsible for translating BRD into functional specifications and test plans.

Created use cases and process mapping utilizing MS Visio and PowerPoint.

Responsible for translating BRD into functional specifications and test plans.

Worked with the QC Team for Validating the Data.

Environment: MS-Visio, MS-Word, MS-Excel, PowerPoint, BRD, Share Point, EDW, Data Warehouse, SQL, Tera Data, SQL Server

HP, Pontiac, MI

October 2012 – February 2013

Texas Medicaid, Business Analyst

Assessed user needs to determine functional and business requirements for software application development projects.

Gathered client business requirements from business leads, subject matter experts, and general users.

Facilitated requirements elicitation sessions among business, technical users and management.

Coordinated and executed quality assurance testing against requirements and specifications.

Ensured that all the artifacts are in compliance with corporate SDLC policies and guidelines.

Prepared Business Requirement Documents (BRD) and converted into functional specifications utilizing Rational Requisite Pro management tool.

Created use cases and process mapping utilizing MS Visio and PowerPoint.

Conducted JAD sessions for effective communication of views between stakeholders.

Performed ETL for data reporting within a data warehouse environment.

Utilized SQL queries for testing to ensure data integrity and validating business rules.

Environment: SDLC, BRD, MS Office, Visio, ETL, PowerPoint, Data Warehouse, SQL

Stay at Home Mother (May 2010 – September 2012)

HP, West Lafayette, Indiana

January 2010 – April 2010

Indiana Medicaid, Business/Data Analyst

Gathered requirements and prepared business requirement documents (BRD).

Responsible for translating BRD into functional specifications and test plans.

Conducted JAD sessions and closely coordinated with both business users and developers for arriving at a mutually acceptable solution.

Utilized Rational Rose / MS Office Suite for creating use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models.

Developed and maintained all operational and technical flows utilizing MS Visio and PowerPoint.

Executed SQL queries for testing and data reporting.

Responsible for validating data fields for valid, invalid and missing codes for different codes in aspects of the claims.

Environment: BRD, UML, Rational Rose, MS Office Suite, Data Process Models, MS Visio, PowerPoint

Ford Motor Company, Dearborn, MI - Master’s Project

Data Analyst - Bill of Materials Department

December 2005 – June 2006

Intern for Master’s Program

Analyzed the SDLC process improvement in terms of quality and reliability to control the cost of the software process and provided recommendations to mitigate them.

Conducted JAD sessions for effective communication of views between stakeholders and gathered business requirements.

Communicated and interacted on a regular basis with the project manager, SME’s and development team during different stages of the product life cycle.

Gathered business requirements and analyzed for ongoing applications of different software process improvement methods like software metrics LOC, FP metrics, COCOMO and inspection methods like SIP, PSP, CMMS and document standards.

Conducted testing of applications by writing SQL Queries.

Compared the Financial cost of the application with respect to the cost that was incurred based on the Industrial standards. Calculated ROI at every stage of SDLC.

Ensured that all the artifacts are in compliance with corporate SDLC Policies and guidelines.

Prepared BRD and converted into functional specifications using Rational Requisite Pro management tool.

Developed and maintained all operational and technical flows using Visio and PowerPoint.

Utilized prototypes to demonstrate and verify the behavior of the system.

Environment: SDLC, LOC, FP metrics, COCOMO, SIP, PSP, CMMS, SQL, BRD, Rational Requisite Pro, Visio, PowerPoint

Full Time Student (July 2004 – December 2005)

EDUCATION

Master’s in Software Engineering, Central Michigan University, Michigan

Reference: Cheryl Kitz

Bachelor’s in Electronics and Communication Engineering, S.K. University, India

Contact this candidate