Project Manager Data

Dhwanil Kothari

Senior Data Analyst / Business Analyst

Summary:

> Over 7+ years of experience as a Data Analyst / BA, with

Progressive responsibilities in data analysis with focus on

financial reporting, and Data warehouse (DW), business intelligence

(BI).

> Accomplished Senior IT professional with a background in business

intelligence, reporting systems, data quality (including ETL), and

full life-cycle development.

> Hands on experience on complete Software Development Life Cycle

(SDLC) for the projects using methodologies like Agile, RUP,

Waterfall, and hybrid methods.

> Extensive experience on interaction with system users in gathering

business requirements and involved in developing projects.

> Designed and developed database models for the operational data store,

data warehouse, and federated databases to support client enterprise

Information Management Strategy.

> Chaired and conducted JAD sessions with business and technical

teams.

> Vast experience of working in the area of data management including

data analysis, gap analysis and data mapping.

> Worked extensively with Erwin, Visio and ER Studio for Dimensional

Modeling and Data Migration projects.

> Adept at writing Data Mapping Documents, Data Transformation Rules

and maintaining Data Dictionary.

> Created and executed Test Plan, Test Scripts, and Test Cases based

on Design document and User Requirement document for testing

purposes using HP Quality center.

> Extensive experience in User Acceptance Testing (UAT), functional

testing, system testing, and defect tracking using various tools.

> Coordinated and prioritized outstanding defects and system requests

based on business requirements.

> Acted as a liaison between the development team and the management

team to resolve any conflicts in terms of requirements.

> Experience with SQL, PL/SQL, and Performance Tuning.

> Interacted with all levels of the project development team, from

end users to Software Architects, Technical Lead, Database

Administrators, and System Administrators.

> Capable of managing project while leading cross-functional teams to

meet and exceed overall IT initiatives.

> Excellent technical, time management, communication, interpersonal

and presentation skills.

Skill Sets:

UML, IBM Rational Requisite Pro, SDLC, RUP, Waterfall, Agile, Scrum, MS SQL

Server 2000/2005/2008, MS Access. Oracle, SQL, HTML, XML, C, C++, TSQL,

PL/SQL, SSIS, SSAS, SSRS, BO, Microsoft Visio, Microsoft Project, MS

Office, Interpersonal and Managerial skills.

Projects Summary:

Western Union, Montvale, New Jersey

1/2011 - Present

Senior Data Analyst / Business Analyst

The Western Union Company (NYSE: WU) is a financial services and

communications company based in the United States. Up until 2006, Western

Union was the best-known US Company in the business of exchanging

telegrams. Western Union has several divisions, with products such as

person-to-person money transfer, money orders, business payments and

commercial services.

Responsibilities:

> Helped conduct meetings with the end users and performed interviews to

gather the requirements from them and to convert those requirements

into Requirements document for the development and testing teams.

> Analyzed the business requirements to get a thorough understanding of

the testing requirements and developed test plans and created test

cases in Rational Test Manager for extensive coverage of the

requirements during testing.

> Worked with the developers to understand the ERD (Entity Relationship

Diagram) and thus create comprehensive test plans, following the RUP

model, for the applications and also gather test data for the data

driven test cases.

> Worked extensively on BI (SSIS) Packages for extracting the data of

the customers from OLTP, transform that data and load it into the

OLAP.

> Extensively involved in using BI tools like Import and Export Wizard

for developing the packages.

> Provided the sequence and flow diagrams for various modules in the

project using Rational Rose.

> Investigated, documented and monitored the defects in Rational Clear

Quest.

> Participated in weekly review meetings to report the documented test

metrics and defects found in the System. Closed bug reports once they

are resolved and verified.

> Involved in Training and Documentation.

> Involved in Data mapping specifications to create and execute detailed

system test plans. The data mapping specifies what data will be

extracted from an internal data warehouse, transformed and sent to an

external entity.

> Gather requirements and design of data warehouse and data mart

entities.

> Used SQL to perform data analysis and generating reports for

management discussion

> Managed Traceability matrix to trace Business Requirements, Functional

Requirements, and Use Cases.

> Identified opportunities for business process improvement and

initiated efforts to make improvements.

> Assisted in designing test plans, test scenarios and test cases for

integration, regression and user acceptance testing.

Environment: Rational Suite, ASP, VB, HTML, C++, SQL Server, and Windows

Standard and Poor, NY

5/2009 - 12/2010

Senior Data Analyst / Business Analyst

The project scope is to automate reporting of various manually generated

reports and provide a consistent view of them to the senior management in a

Reporting Dashboard. Need to understand the present report features and

identify enhancements required and incorporate the changes in the automated

report. To identify the fields, filters and calculations that need to be

used for generating the reports, performed data analysis on various source

files originating from various source systems.

Responsibilities:

> Designed the business requirement collection approach based on the

project scope and SDLC methodology.

> Conducted controlled brainstorming sessions with project focus groups.

> Documented business requirements with wireframes and mockups to

explain in detail the business implications and impacts.

> Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams,

Dataflow Diagrams in MS Visio.

> Prepared functional requirements to define the system rules by

creating Use Cases, Interface design and data dictionaries.

> Analyzed various resource files being used to generate the report and

documented data mapping and data source interface documents to assist

the development team.

> Worked with the Business Objects developers to provide input for

generating automated and adhoc Business reports.

> Used SQL for querying and analysis purposes on various source tables

and conditions applied and Wrote SQL joins, sub queries.

> Used SQL Server Reporting Services (SSRS) to schedule reports to be

generated on predetermined time.

> Built up and maintain a strong data warehousing system for the

organization

> Helped the testing team in creating the test plans and test scripts.

Assisted the users in UAT testing by providing test scenarios and test

data.

> Assigned problems to appropriate software development team for fixes.

> Authored progress and completion reports, which were then submitted to

project management on a weekly basis.

> Stored and modified requirements in MS - Word.

Environment: Oracle 11g, Oracle SQL Developer, Adobe Flex, MS Word, MS

Excel, MS PowerPoint, MS Access, MS Projects, MS Visio, Adobe Flash, MS

SharePoint.

BNP Paribas, Jersey City, NJ

4/2007-4/2009

Business Analyst

BNP Paribus is one of the largest global banking groups in the world. The

project is to develop and enhance the legacy system for trade and

allocation flow into CTAC (Fidessa's Client Trade, Allocation and

Confirmation System) for Equities, Options & Convertible Bonds. The project

also involves generating various financial reports used by Back Office for

clearing and settlement of trade's flow of Global Equities and Commodity

Derivatives (GECD).

Responsibilities:

> Interacted with SMEs, IT and Vendors for overall understanding and

need of the system. Was able to fine tune the business rules with

inputs.

> Perform the Initial Project Analysis and also gathered requirements

through JAD sessions conducted with IT, Vendor group and SMEs.

> Assisted Project Manager, in defining the time lines and preparing

work schedule for various phases of the project.

> Identified & designed Use cases from the Functional requirements and

wrote Use Case Specifications and created business process workflow

diagrams. Performed Gap Analysis to check the compatibility of the

existing system infrastructure with the new business requirements.

> Reviewed Requirements & deliverables for delivery timeline.

> Prepared Functional Design Specifications employing Use case

scenarios, sequence diagrams and class diagrams.

> Handle the various aspects of the end to end lifecycle related to

complex data warehousing and business intelligence projects

> Conduct tests and provide sound solutions to data warehousing problems

> Worked on broad range of technologies, including business process

tools such as Microsoft Project, MS Excel, MS Access, MS Visio, and MS

PowerPoint.

> Interaction with underwriters to understand multiple data points.

Prepared data flow diagrams using MS Visio for better clarity and to

ensure documented process

> Scheduled meetings with data analysts, developers, System Analysts to

explain the business needs and fine tune the requirements.

> Authored progress and completion reports, which were then submitted to

project management on a weekly basis.

> Supported testing, Test Cases in HP Quality center that would test

various Test scenarios. Wrote Test plan and Test cases for the

Integration testing and system testing.

> Conducted Functional Walkthroughs, User Acceptance Testing (UAT) and

conducted training sessions to familiarize users with system.

Environment: SQL Server 2000 and 2005, Windows, UML, MS Office, MS Visio,

MS Project, MS Access, .Net framework 3.0, ASP.Net, XML, HTML

Fidelity Investment Covington, KY

2/2005 - 3/2007

Business/Systems Analyst

Fidelity Investments is a group of privately held companies in the

financial services industry. Job was to help design the entire Competitive

Intelligence Infrastructure for the SBS in Kentucky. The scope of the

project was to develop Competitive Intelligence Knowledge Base which was

designed in the internal Fidelity intranet known as Microsoft Share Point

and linked to an existing Knowledge Base

Responsibilities:

> Extracted the Business Requirements from the end users keeping in mind

their need for the application and prepared Business Requirement

Documents (BRD) using Rational RequisitePro.

> Reviewed Design Documents, Requirements Analysis Specifications with

Project Lead, Business Owners and the Technical Lead

> Participated in JAD sessions to resolve critical issues

> Created the business process model using MS Visio for better

understanding of the system and presented it to Project Manager and

other team members for validation.

> Created and managed Project Templates, Use Case Project Templates,

Requirement Types and Traceability Relationships in RequisitePro.

> Participated in requirements meetings, writing requirements in

CaliberRM, converting requirements from Caliber RM to HP Quality

Center

> Involved in creating automated Test Scripts representing various

Transactions, Documenting the Load Testing Process and Methodology.

Created meaningful reports for analysis and integrated the Performance

Testing in the SDLC.

> Wrote PL/SQL statement and stored procedures in Oracle for extracting

as well as writing data.

Various versions of the documents generated during the project were

maintained and managed using Rational ClearCase and performed defect

tracking using Rational ClearQuest.

> Tested the final application for Usability testing to verify whether

all the User Requirements were catered to by the application.

Environment: Rational Clear Case, Doors, IBM WebSphere, XML, HP Quality

Center, Java, RUP, MS Visio, SQL Server Reports, WinRunner, LoadRunner,

Quick TestPro

Abacus Infotech, Mumbai, India 1/2004

- 12/2004 Programmer Analyst

Abacus Infotech provides quality solutions, products and services including

Web Designing, Online applications, Web Hosting, Animations, Customized

application development, Software development for E-Commerce. The main aim

of the project was to make third party websites and web applications where

I had to gather the requirement and also created Reports which were to be

generated on predetermine time.

Responsibilities:

> Gathered user requirements.

> Identified high-level requirements for developing and documenting

detailed business requirements

> Involved in meetings with SME (subject matter experts) and users for

requirements gathering.

> Revised and updated the technical feasibility documents and created

sequence diagrams.

> Utilized RUP (Rational Unified Process) to create use cases, activity,

class diagrams and workflow process diagrams.

> Extensive development providing data integrated solutions using VB

5.0.

> Responsible for providing database solutions using MS Access/ SQL

Server/ Oracle database.

> Proficient use of T-SQL/ PL/SQL in creating tables, views, triggers,

stored procedures.

> Created reports using Crystal Reports and Oracle Forms/Report.

> Provided technical/Functional support to end user.

Environment: MS SQL Server 6.5/7.0/2000, Oracle 8.0/9.0, Visual Basic 5.0,

TSQL, PLSQL, Windows NT /2000

Education: Master's of Business Administration (M.B.A.) in Finance &

Marketing

Contact this candidate