Sql Server Design

KARAN SHAH

**** ****** *******, ******* ** ****8

Email: ********@*****.*** Cell: 857-***-****

CAREER HIGHLIGHTS:

* ***** ** **** ********** as Business Analyst/Consultant

H-1B Work Permit; Open for Relocation

Experience in working in Financial, Insurance and Healthcare Sector.

Tech savvy and Quick Learner with Excellent Problem Solving and Analytical

skills

Master of Science in Information Systems from Northeastern University,

Boston, MA (Sep 2010 - Aug 2012)

TECHNICAL SKILLS:

Data-Warehouse/ETL Tools : OBIEE BI Publisher 11g, Talend,

Microsoft SQL Server Integration Services

(SSIS), Microsoft SQL Server Analysis Services (SSAS),

Tableau, Documentum

D2, xCP 2.0

Database : MS SQL Server 2008R2, Oracle 10g/11i, PL/SQL, MySQL, MS

Access,

MongoDB

Methodology : SDLC, Object Oriented Analysis and Design, Unified

Modeling Language

(UML), Zachman Framework, Agile, SCRUM, Waterfall Model

Operating Systems : Windows 2000/XP/Vista, Windows 7, Windows 8,

Microsoft Windows

Server 2008, MAC OS

Application Tools/IDE : Microsoft Visual Studio 2008, VMware vSphere

Client, SQL Server Management

Studio, Rational Rose, TOAD, MS Project, Pencil,

Minitab, WebEx, IBM ClearCase,

IBM ClearQuest, JIRA, HP Quality Center (HPQC)

WORK EXPERIENCE:

> Associate Consultant, EMC Corporation, Pleasanton, CA

Sep 2012 - Present

Gather Business Requirements for the Client's System and design the System

Requirements Specification document depending on the requirements

Design reports based on the requirements and specifications provided by the

client

Explaining technical problems and solutions to technically literate

team/client members.

Design, maintain and comprehend technical documentation e.g. system design

specifications, statement of work (SOW), test documentation, product

manuals, etc.

Perform research and design on technical requirements and

programming/configuration depending on nature of the project.

Worked on the requirements gathered from the customer to build

specifications for the database tables (DDL) and views needed for the

respective project development

Perform Data Migration using Enterprise Migration Appliance to migrate data

from source to the destination repository.

Worked on implementing various IIG Products like Documentum xCP 2.0,

Documentum D2 etc.

PROJECTS UNDERTAKEN AT EMC:

Business Analyst/Consultant, Fannie Mae, Herndon VA

May 2014 to Present

. Gather the business and functional requirements from the client by

interacting with all members from cross functional teams and documented

them to design the specifications.

. Define and document customer business requirements, functions and

processes.

. Design Business Use cases for system testing based on various user

groups that will access the new system.

. Design UAT Test scripts for Testers so that they can carry out testing

based on the use-cases.

. Act as a liaison between departmental end-users, technical analysts,

information technology analysts, consultants and other governmental

organizations in the analysis, design, configuration, testing and

maintenance of case management systems to ensure optimal operational

performance.

. Analyze existing data and perform Data Migration by using EMC's

Enterprise Migration Appliance (EMA) by migrating data from source to

the destination repository in a systematic manner.

Business Analyst/Consultant, New York City Dept. Of Finance, New York, NY

Jan 2014 to Apr 2014

. Define and document customer business requirements, functions and

processes.

. Gather requirements from the client by interacting with the cross

functional teams.

. Consult with functional unit management and personnel to identify, define

and document business needs and

objectives, current operational procedures, problems, input and output

requirements, and levels of systems access.

. Act as a liaison between departmental end-users, analysts, IT analysts,

consultants

and other governmental organizations in the analysis, design,

configuration, testing and maintenance of case

management systems to ensure optimal operational performance.

. Analyze the feasibility of, and develop requirements for new system and

provide enhancements which lacked in

the existing system thus ensuring system design fits the needs of the

users.

. Analyze existing data and perform migration to load data in to the

destination repository.

Data Analyst/Report Developer, Gilead Pharmaceuticals, Foster City, CA

June 2013 to Nov 2013

. Identified the functional requirements specification for the clients by

interacting with the various groups

. Design the reports specifications based on the functional requirements

. Developed queries in order to produce the desired output in the reports

using OBIEE BI Publisher (11g)

. Provide solutions and suggestions to the client related to reporting

. Designed the new database to store large amounts of data by migrating it

from old to the new database and

ensuring that the operating processes are functioning properly

. Ensure accuracy and integrity of data & applications through analysis,

coding, writing clear documentation &

problem resolution.

Software Quality Analyst, Bristol Myers & Squibb, Ewing, NJ

Feb 2013 to May 2013

. Analyzed and performed out the System Testing on BMS Document Imaging

Management System

. Analyzed, Developed and Implemented comprehensive automation tests using

HPQC

. Writing test cases for the system and converting it into a viable test

plans

. Designed and implemented the test plans for carrying out UAT on the

system

. Approved the tests based on the results received after testing making

sure the system is performing as per the

requirements

Business Analyst, Boston Scientific Corporation, St. Paul, MN

Oct 2012 to Jan 2013

. Gathered business and functional requirements for the system and

documented them to design the specifications.

. Developed traceability matrix to record requirements through each stage

of requirements gathering process.

. Provided detail application design for Boston Scientific Clinical device

tracking system in xCP 2.0.

. Designed a proof of concept solution for Boston Scientific Clinical

device tracking system.

. Designed architecture template design for xCP 2.0 applications.

> Software Engineer Co-op, EMC Corporation, Hopkinton, MA

Jan 2012 - June 2012

Performed QE test cases for functional and regression test activities in

cross-functional team meetings

Actively participated in scrum meetings(Agile), project planning and

assured that projects reflect as per the planned activities

Reported test metrics, defects and project status to the manager and cross-

functional stakeholders

Performed testing for assigned projects and carried out test evaluation and

reporting, including defect tracking using IBM ClearQuest

Analyzed, Developed and Implemented comprehensive automation tests using

RIA-Test for Flex based application and transformed various test cases into

viable test plans as per the user requirements specifications

Developed and debugged UI automation scripts using RIA-Test and triaged the

test failures.

Contact this candidate