Sql Server Test Cases

Shweta Mahajan

Morrisville NC – *****

SUMMARY

Around 8 years of IT experience as a blend of Information technology, E-commerce, Finance and Healthcare gained through clear customer focus and by understanding business needs.

Worked for Fidelity, Credit Suisse., DPS, Microsoft, Morgan Stanley, Digital River, and Inbox

Performed varieties of important roles such as System Analyst, Developer, Quality Analyst, Programmer Analyst, knowledge management representative and demonstrated decision making qualities, dealt with unknowns.

More than 3 years of extensive experience as System Analyst and Business System Analyst.

Extensive analysis on existing systems and business models.

I have extensive experience in agile processes and methodologies.

Expertise in Requirement gathering, Functional specification preparation & Client interaction.

Possess strong tasks, time management skills and good communication skills.

Hands on experience in Project plan preparation, Monitoring & execution.

Experience in Application Solution design, flow chart & Use case preparation.

Experience on different Software Development Processes/models & agile process.

EDUCATION

Master of Science in Information Systems - Stratford University, VA USA – March 2012 - GPA: 3.89/4.0

TECHINICAL SKILLS

Languages: C#.NET 1.1, 2.0 and 4.0 VB.NET 1.1 and 4.0, ASP.NET 1.1, 2.0 and 4.0, Classic ASP, JavaScript, VBScript, HTML, DHTML, XML, AJAX.

Database Technologies: SQL Server 2005 and SQL Server 2008.

Tools /Products: Virtual Source Safe, CVS, MOSS 2007 (SharePoint). MS Visual Studio 2010 express, MS Visio 2010, System DeZign, RDA, and CTRL M.

Operating Systems: Windows 2010, Windows XP, Windows Vista.

Job Functions: System Analyst. Development, Maintenance, Enhancements, Support and Testing,

PROJECTS EXPERIENCE

Fidelity Oct 15 – Till date

Strategic Investment Product Data

Project: APP Services, Digitally Managed Accounts

Roles: System Analyst

Platforms: REST Services, SOAP UI, Agile, Scrum board, JIRA, quality central.

Digitally Managed Account (DMA) products offer younger, digitally-savvy accumulators a low-cost, simple web-based professionally managed account.

After answering a simple set of profiling questions, the customer is presented with a proposal suggesting an investment strategy that matches their needs. The customer may interact with the proposal and refine the investment strategy further or continue on the online account opening process via a web. Each DMA client will benefit from a fully digital experience including monitoring online and via periodic email updates and convenient access to account performance/future projections via the web.

Responsibilities:

Maintain product capabilities backlog.

Elicitation & analysis of business & systems requirements.

Use case development.

Diagramming and documentation of business processes and system workflows.

Develop System requirements in the form of User Stories.

Write clear, concise and well-structured functional specifications.

Maintain trace-ability between requirements, specifications and test cases.

Manage small enhancements initiatives.

Assist QA team in developing test plan and test cases, participate in reviews.

Assist in defect management by performing defect analysis.

Participate in product installation & post install support.

Credit Suisse Oct 13 – Oct 15

Credit Suisse

Project: MarginTrac

Roles: Business System Analyst and Developer

Platforms: Agile, Scrum board, JIRA, ASP.net 4.0, SQL Server 2008, SQL Server 2010, Windows XP,

Windows 7, Web services.

MarginTrac provides a total solution for managing margin trading for foreign exchange contracts. MarginTrac incorporates collateral tracking, position tracking, real-time data-feeds for collateral and position revaluation, and real-time calculation of margin requirements. MarginTrac enables users to conduct real-time on-line checks against the current value of a client's collateral. Upon trade execution, positions are instantly updated to provide real-time data to all traders across a network.

Responsibilities:

Work on new changes and enhancements to the current system as per business needs

Analyze and understand the current state process to ensure that the context and implications of changes are understood by the client and project team.

Closely work with Business to understand the correct requirement and business processes for reporting requirements.

Plays a key role in making sure that the overall project successfully meets the client’s requirement.

Work with clients to prioritize and rationalize the requirements.

Assist all customers and provide production support for all designs and perform installation for given requirements.

Develop an understanding of how present and future business needs will impact the solution

Support development and test strategies in order to do successful delivery.

Write SQL queries and store procedure in order to generate the regulatory reports.

Development of EOD & Intra-day Feeds that supply market data to Commodities systems;

Perform Data analysis to verify the changes after they are deployed.

Monitor all alerts and escalate issues for all procedures and systems

Coordinate among various teams and raise support ticket for all issues, analyze root cause and implement an efficient resolution for all production processes

Fidelity Investments Oct 12 – Aug 13

Project: TRS (Testing and Reporting Services)

Roles: System Analyst and Developer.

Platforms: ASP.net 4.0, ASP, SQL Server 2008, SQL Server 2010, Windows XP, Windows 7, Agile,

Scrum board, JIRA

The Testing and Reporting group works on the preparation, filing, and support of financial documents for institutional retirement plans (401(k), 403(b), and 401(a)). Primary purpose of this application is to prepare financial packages for the most complex of relationships, assist auditors in their efforts to complete the annual audit of each plan in addition to this it is responsible for producing yearend financial reporting to support employer required governmental filings for Defined Contribution Plans and external audit requirements.

Responsibilities:

Work on new changes and enhancement in current system given by business.

Assist all customers and provide production support for all designs and perform installation for given requirements.

Perform all tests on production applications and prepare recovery procedures for all applications and provide upgrade to same.

Analyze all business processes and ensure compliance to all controlled processes according to business requirement.

Monitor and provide support to workflows and provide expert knowledge on all workflow designs.

Monitor all alerts and escalate all issues for all procedures and systems.

Coordinate with various teams and raise support ticket for all issues, analyze root cause and implement an efficient resolution of all production processes.

Maintain logs of all issues and ensure resolutions according to quality assurance tests for all production processes.

Durham Public School May 12 – Aug 12

DPS IT Department

Project: VOLCON Employee Registration System.

Roles: Programmer Analyst

Platforms: ASP.net 4.0, SQL Server 2010, Windows Server 2003, Share Point, AJAX.

VOLCON is employee e-registration software that helps managers to quickly manage their employees, positions, task details and assignments. It is divided into different modules like employee registration, task and assignments creations, supervisor’s approvals, task deadlines, enrollment confirmations and deadlines etc.

Responsibilities:

Complete ownership of the assignment – End to End

Database design

Developed and maintained the applications by utilizing ASP.NET.

Provided ideas and Solutions to solve existing issues and prevent futures problems.

Analyze the business requirements

Creation of database store procedures triggers and views.

Project documents maintenance and creation of technical specifications and unit test cases.

Modified applications according to the client requirements.

Responsible for the testing, fixing the bugs and troubleshooting the technical problems.

SharePoint Document management.

Stratford University Aug 10 – April 12

Capstone Project

Industry: Health Care.

Project: Implementation of EHR.

Roles: Developer, Tester.

Platforms: ASP.net 4.0, C#.net 4.0, SQL Server 2008, AJAX, Windows 7, MS visual studio 2010 express,

Microsoft Visio 2010, System DeZign.

This application keeps the electronic health records of healthcare clients to improve care coordination, quality and satisfaction while functioning at their highest level of efficiency by providing a platform for patient and doctors to coordinate their activities efficiently and can be further extended to help Pharmacist and Researchers.

Responsibilities:

Website Planning (including the site map, phase breakdown, backend technologies)

Developed Project Plan - Develop site map, Build modules within project also implemented project flows by creating flow diagrams.

Creation of webpages from scratch which includes design, coding and testing

Created ER-Diagrams following with database and table creation also worked on SQL server store procedure and writing queries

Try to solve current health care problems by implementing (EHR).

Tata Consultancy Services Nov 07 – Feb 08

Morgan Stanley

Industry: Banking, Finance.

Project: Global Wealth Management Check 21.

Roles: Programmer Analyst

Platforms: ASP.net 2.0, SQL Server, Windows Server 2003, Share Point, VSS

This application included web services which indented to follow Check-21 legislation through which they can process scanned checks.

Responsibilities:

Modules modifications and enhancements as per new business requirements.

Project documents maintenance and creation of technical specifications and unit test cases.

Communicating with onsite team and clients for ongoing & forthcoming assignments regarding delivery, schedule, and identification of tasks risks.

Provided ideas and Solutions to solve existing issues and prevent futures problems.

Cybage Software Pvt Ltd. July 05 – Nov 07

Commerce 5

Industry: E-commerce

Project: Commerce 5

Roles: Developer and Tester

Platforms: ASP.Net 2.0, C#.net, ASP, SQL Server 2005, Windows Server 2003

Commerce5 is based on Ecommerce which offers channel management services to its clients to market, sell, and service their products.

Responsibilities:

Store Migration from ASP to Asp.Net.

Maintain the checkout process of the product purchase and localize the sites.

Modules modifications/enhancements as per the new requirements.

Communicating with onsite team, clients and managers for ongoing & forthcoming assignments regarding delivery, schedule, and identification of task risks, estimation of tasks.

Creation of technical design document & unit test cases.

Cybage Software Pvt Ltd. April 05 - July 05

Microsoft

Industry CMS

Project: TechNet Extractor

Roles: System Maintenance, Developer and Tester

Platforms: C#.Net 1.1, SQL Server, Windows Server 2003

The TechNet extractor tool is used for synchronizing Component management system (CMS) and TNPS databases.

Responsibilities:

Requirement analysis and understand and Analyze the TNPS API.

Developed a class in C# for interacting with the CMS and TNPS

Creating password encryption application

Modules modifications/enhancements as per the new requirements.

Communication with onsite team for ongoing & forthcoming assignments - Delivery, schedule, identification of task risks.

Cybage Software Pvt Ltd. Sept 04 – April 05

Microsoft

Industry: CRM

Project: MS COM CRM

Roles: Developer and Tester.

Platforms: C#.Net 1.1, Asp.net 1.1, Windows Server2003

Creating and maintaining Smart Components and CRM components.

Responsibilities:

Set properties for Smart Component and CRM component.

Generate preview for Smart Component.

Designed the deliverable document and creation of technical specifications & unit test cases

Develop Modify and Enhancement of programs.

Preparation, maintenance & updating the ultra-comprehensive checklist for the entire software development life cycle.

Contact this candidate