Project Sql Server
Resume:
Sara Srivastav
Sr. Business Analyst
Personal Info
Address:
Princeton, NJ
Email:
********@*****.***
Phone:
US Citizen
Skills
Business Analysis
Project Management
Resources/Budget/Time Management
Technical/Analytical Skills
Interpersonal Skills
Communication Skills
Software
MS Project
MS Visio
MS PowerPoint
MS SharePoint
MS Excel
MS Team Foundation(TFS)
SAP Business Objects/BI
SQL Server
Oracle
.NET Framework
Erwin Data Modeler
LoadRunner
JIRA
Rational Tools
Education
MS • Computer Science
State University of NY
BE • Electrical Engineering
COEP
Certification
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.
Experience
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 ASP.net 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 ASP.net 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 ASP.net 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