Sign in

Project Sql Server

Somerset County, New Jersey, United States
August 12, 2018

Contact this candidate


Sara Srivastav

Sr. Business Analyst

Personal Info


Princeton, NJ




US Citizen


Business Analysis

Project Management

Resources/Budget/Time Management

Technical/Analytical Skills

Interpersonal Skills

Communication Skills


MS Project

MS Visio

MS PowerPoint

MS SharePoint

MS Excel

MS Team Foundation(TFS)

SAP Business Objects/BI

SQL Server


.NET Framework

Erwin Data Modeler



Rational Tools


MS • Computer Science

State University of NY

BE • Electrical Engineering



PMP - Project Management

Professional (PMI)

Experienced IT Professional having overall 15+ years’ experience in all phases of

SDLC – Project Management, Business Analysis, Design, Coding, Testing and Training.


2014-06 - Sr. Business Analyst

2018-06 New Jersey Department of Corrections, NJ

Define and plan solutions for NJ-Re-Entry initiatives Data Warehouse project after gathering and analyzing business and systems requirements.

Conducted Business Analytics using SAP BusinessObjects BI tools suite.

Elicited and documented Business/functional Requirements for Custody Scheduler by conducting regular meetings with stakeholders.

SDLC responsibilities included solution planning, defining and documenting business requirements and managing the project from development to completion followed by training and support.

Managed integration with Global Solutions Shop(GSS) ERP system for customer pricing, supply chain access and inventory management of DOC warehouse.

Translate requirements into functional specification, including process flow and data model documents. Integrated technical solutions with the business environment.

Used Workday Financial Management mainly for financial planning of the project and keeping track of expenses for temporary staffing of the project.

Ensure system deliverables meet business requirements by participating in identifying, designing and testing solutions.

Translating requirements into test conditions and expected results for product, performance, and user acceptance testing(UAT).

Utilized Waterfall as well as Agile Methodologies for software development.

Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.

Developed use case with UML for new product functionality.

Develop internal management policies (IMPs) for users of iTAG and conducted training and created User Manuals.

Manage project scope, quality, budget, risk and timeline in conjunction with project deliverables.

Excellent communication, analytical, interpersonal, and presentation skills.

Environment: PowerPoint, MS Visio, MS Project, MS office 2010, Erwin Data Modeler, Workday,

Oracle 10g, JIRA, SAP Business Objects/BI Tools, Global Solutions Shop (ERP) etc.

2013-11- Senior Business Analyst

2014-06 New Jersey Office of Information Technology, NJ

Conducted System and Business analysis of Cost Allocation Recovery (CAR) System.

Developed Technical Business requirements document.

Database Analysis, Design, Modeling, Normalization to support enhancement to CAR web application

Created Reports with SQL Server Reporting Services (SSRS).

Developed user documentation as well as scripts for functional usability testing and system training.

Environment: VS2010, NET4.0, C#, Oracle 11g, SQL Server 2008, SSRS, Erwin Data Modeler etc.

2013-07 – Senior Business Analyst

2013-11 MD Labs Pharmaceutical, NJ

Researched and documented existing business processes for functional redesign of existing Pathology Tracking system.

Business process and system analysis of the enhancements of existing system.

Created technical business requirement document.

Redesigned the existing database model.

Managed redesign of Pathology Tracking System using ASP.NET, C# and ADO.NET.

Synthesized and edited all process flow documentation and scripts for training modules.

Participated in several phases of development regression testing.

Environment: PowerPoint, MS Visio, MS Project, MS office 201, Erwin Data Modeler,

Oracle 10g, SQL server 2008 etc.

2012-12- BA/ Programmer Analyst

2013-06 MetLife, NJ

Developed, maintained, and supported applications for the enterprise intranet application.

Elicited business requirements by conducting interview sessions with stakeholders and created business Requirements and functional requirements and technical requirements.

Made enhancement to ‘Customer Reporting Tool’ an Internet application used by MetLife employees for Internal Analysis and Research.

Environment: MVVM, ASP.NET, C#, JavaScript, SQL Server, Crystal Reports etc.

2011-09- BA/Programmer Analyst

2012-12 New Jersey Department of Labor, NJ

Design, Developed, and Implemented web-based Internet application for automation of Temporary Disability System of State of NJ. Jersey.

Involved in Business Analysis, Technical requirements, Database design and testing the system.

Environment: ASP.NET, NET 4.0, C#, Oracle 10g, AJAX, SOA Architecture, Scrum Agile,User Stories etc.

2003-04 – BA/Programmer Analyst

2011-08 NYS Office of Child and Family Services (OCFS) –Albany, NY

Responsibility included design, installation, administration, support and enhancement to CHRU legacy system Fingerprint Information Processing System (FIPS).

Identify, gather and document requirements specification by working directly with customers to identify their business processes, rules and application functionality for FIP.NET.

Analysis and research of existing FIPS SQL server database for re-design and migration to Oracle database.

Created User Manual and trained the NYS staff to use the new system.

Design, develop, and implement and SQL Server 2008 web-based intranet N-Tier application which provides various, complex customized reports to the client.

Business analysis, requirement specification, design and conversion of old BenchMark access Application to new enhanced web interactive intranet Enterprise BenchMark System.

Interact with users on a daily basis to collect the business requirements, analyze the requirements, re-engineer business process and develop user interaction models, flow diagrams and Site navigation maps. Post it on SharePoint BenchMark.

Wrote SQL Server stored procedures having complicated business logic to provide and support the functionality required for processing the transaction between our web services and applications.

Environment: ASP.NET, MVC, Web Services, WCF,VB.NET, VB6, .NET 4.0, ASP, XML,

HTML, CSS, XSL, Visual Studio. NET, AJAX, DHTML, Windows XP/2000, Oracle 10g, SQL

Server 2008, Visual Studio Tool Set, VBScript, JavaScript, AJAX, LINQ, SharePoint 2007,

Site minder, LDAP etc.

2001-09 – Programmer Analyst

2002-12 NYS Office of Temporary and Disability Assistance (OTDA) –Albany, NY

Worked with Business Analyst on requirements and design

Developed COM/COM+ objects using Visual Basic

Developed user interface using Visual Basic, VB Script, ASP, COM/COM+, HTML

Used MTS for deploying COM objects

Developed database logic using Oracle stored procedures

Used JavaScript for front-end validation

Responsible for QA of developed modules

Environment: Visual Basic, Visual Interdev, ASP, MTS, COM, COM+, HTML, Windows NT, Windows 2000, Oracle 8i, PL/SQL, Visual Studio Tool Set, VBScript, JavaScript, LDAP etc.

1996-11 – Programmer Analyst

2001-08 GE - Schenectady, NY

Webmaster for a six sigma project which went online on GE-intranet as the main ‘cockpit’ for all the GE- CIS leaders. It was a cockpit for all the application owners as it showed their application performance on a daily basis. It incorporated a very complex logic and was implemented using Vbscript, JavaScript, ASP, and Interdev, oracle ODBC etc.

Developed a project in VB, which would monitor the different machines (Robot) in different parts of world and send alerts in the form of email/pager whenever a robot machine would go down.

Database driven Web application, which would load the schedules of a particular application and allow the user to edit, update or delete it as per his requirements. This schedules application was developed using Visual Interdev-6.0 to create the ASP/HTML page, Java, JavaScript, COM, DCOM, MTS, and SQL SERVER.

Environment: Visual Basic, Visual Interdev, ASP, MTS, COM, HTML, Oracle 8, Developer 2000, Windows NT, SQL SERVER, PL/SQL, Visual Studio Tool Set, VBScript, JavaScript, LDAP etc.

1996-06 – Programmer Analyst

1996-10 Solomon Smith Barney Inc. NYC, NY

Project - Capital Market

Developed apps using Sybase, VB, C, C++ and Rogue-wave tools.

Responsible for designing and maintaining the enormous data bank of stocks and shares.

Key Programmer for retrieving critical data from the data bank using Sybase SP (stored procedures.)

Environment: Visual Basic, C, C++, HTML, Windows 95, PL/SQL, Sybase etc.

Contact this candidate