Project Data

Ritesh Lalwani

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

Contact no: 312-***-****

Professional Summary:

Skilled Business Analyst with over more than 3 years of Experience for gathering requirements (BRD, FRD, RTM and Data Mapping Documents), modeling and creating UML diagrams.

Excellent knowledge of industry standard methodologies like Iterative Software Development Life Cycle process as per Agile, Waterfall and Rational Unified Modeling (RUP).

Skilled in articulating Business Requirements from SME’s interview and workshops & translating requirements into Business Requirement Specifications (BRS), Functional Requirement Document (FRD).

Acted as a liaison between the business units, QA and the technology teams. Lead JAD sessions and acted as the lead facilitator for multiple projects from start to finish through the SDLC.

Expertise in using JIRA to open bugs, create tasks and user stories, initiate change requests.

Adequate knowledge of Data warehousing (Netezza, Teradata, Hadoop), Data Analysis (SSIS, Advanced MS Excel Sheet), BI tools (Cognos, SQL, and Tableau) and Project Management Methodologies.

Highly skilled in extracting the data from the database & analyzing data by writing the complex SQL queries in SQL server

& Oracle.

Skilled in designing, developing and using Relational Database Management Systems (RDBMS) and Data Warehousing process.

Skilled in creating the user story, Use cases, Class diagram, Activity diagrams, Sequence diagrams.

Worked closely creating Requirements Traceability Matrix to keep the stakeholders informed of the progress of the project.

Worked closely with the system architecture to facilitate design and development of Business Rule Engines to support SOA architecture and defining web services and web methods.

Involved in test planning, test preparation, test execution and creating reports to assure that all aspects of the project are in compliance with the business requirements.

Detail-Oriented Energetic Team Player, Motivated With Multi-Tasking Capabilities, Problem Solver, And Hands-On Leader With Exceptional Presentation And Client/Customer Relation Skills.

Strong Analytical, Administration And Problem Solving Skills Dedicated To Maintain The High Quality Standards. Good Communication Skills, Ability to Work Independently. Technical Skills:

Operating Systems Microsoft Windows 8/7/2008/XP/ Unix SDLC Methodologies Agile, Waterfall, RUP Process and Prototyping Internet Languages/ Web

Applications

UML, HTML, SQL

Business Intelligence SQL Server Integration Services (SSIS), Reporting Services ( SSRS), Tableau Databases and Tools SQL Server 2005, 2008 & 2012, My SQL, Oracle 8i/9i/10g, MS Access, My SQL, PL/SQL, Visual Studio 2008/2012

Project Management Microsoft Project Professional, Rational Rose, JIRA Languages C/C++, Java, JavaScript, CSS, SQL, XML, ASP.NET, C#.NET Version Control Team Foundation Services, SharePoint Others MS Office Suite (Word, Excel, PowerPoint)

Professional Experience:

Cognizant Technology Solutions, Pune April 2012- July -2015 Jr. Business/ Functional Analyst

Project 1: The project involved development of web services. This application gave ability to make better use of notification and keep track of all important alerts for the onsite clients that was send to all higher authorities of organization. The application had high level of confidential data. The confidentiality of data was appropriately maintained. Project 2: AVM- Banking & Finance is the independent internal financial dealer of Cognizant Technology Solutions. Worked on web based wealth management tool, which provides the client to monitor their investments, stay informed on the financial markets by providing research on the investments and plans, and explore potential investment planning strategies. It also provides the comprehensive account information, easy account statements, convenient cash management. Project 3: Programming Portal- This Project was major initiative of online course training for newly hired trainees in Cognizant. I was involved in Requirement analysis, functional analysis and design of new features and enhancements to Development. This application is used all over the location in Cognizant for taking online courses at the time of training for period of 6 months. Responsibilities:

Implemented Iterative based agile (Scrum methodology) in order to meet the tight timelines involving multiple Vendors and interfaces.

Performed Requirement Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.

Worked extensively on Business Requirements, Functional Specification, Data-Integration, Data Mapping, and Data Warehouse access using SQL, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards.

Performed a high-level Gap Analysis between the existing platforms against the business requirements.

Worked on UML Diagrams to create Activity Diagram, Sequence Diagram, and State Chart Diagram for better understanding.

Used TFS to report bugs and to maintain product backlog items.

Tracked sprint progress and burn out rate and other critical project reports in Team Foundation server (TFS Studio).

In depth knowledge of managing product lifecycle, SharePoint integration, creating team project, Shelving and Unshelving, Managing Document and using MS projects in TFS.

Ensuring Standard Branching/Merging for each Release Cycle using TFS Inbuilt Feature.

Highly skilled in tracking down the updates in TFS through the latest check-in’s and check-out of the codes and the documents.

Wrote Customized Deployment Process templates for deploying source bits to Dev/QA/UAT/PROD Environments using PowerShell and TFS.

Formalized and documented enterprise standards for performance testing in both Rational and TFS.

Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document

Created and maintained the Requirements Traceability Matrix (RTM).

Analyzed requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)

Exceptional documentation skills with expertise in creating wire frames, process workflows, use Case, Activity, and State diagrams based on UML Methodology using MS Visio, Enterprise Architect etc.

Worked with the team in Sprint Planning, Daily Stand Up, and Sprint Backlog.

Proficiently helped development teams to break down large User Stories for execution.

Participated in Scrum, Planning Poker and Retrospective Meetings.

Extensively used SQL queries to filter data, perform analysis and manage provider tables used for evaluation.

Developed complex SSRS reports like Drill through, Drill down, Parameterized, sub reports to represent their data in meaningful information.

Designed plans for User Acceptance Testing (UAT) and facilitated Post Production Validation (PPV) to ensure all functionalities are meeting the standard.

Analyzing User and Functional requirements to point out gaps between used SQL queries to extract the data from the database.

Environment: Agile, Waterfall (Hybrid), C#.Net, SQL, Microsoft BI Suite (SSIS, SSRS, SQL Server) 2008, HTML, Visio, XML, MS SQL Server 2008/2012, Visual Studio 2008/2010/2012, JIRA, Rational Rose, JavaScript. Education: Bachelor’s in CS, Pune, India

Pursuing Master in Information Technology and Management, IIT, Chicago

Contact this candidate