Project Sql Server

Shraddha Jain

Email: *********@*****.***

Mobile: 469-***-****

Competent, diligent & result oriented professional with an experience in .NET technologies like ASP.NET, C#, VB.NET and MS SQL. Extensive experience in application development for healthcare, Financial and Educational domain.

EXPERIENCE SUMMARY:

9 years of progressive experience in Design and Development, Quality process and implementation for various .Net applications.

Expertise in enterprise application design and development in Visual Studio.NET using .Net 2.0, 3.5, 4.0, VB.Net, ASP.Net, C#, HTML, Angular JS, ADO.Net, LINQ, WCF, WPF, XML, CSS.

Expertise in working with application databases using SQL Server and MySQL including creation of complex SQL queries, stored procedures, triggers, restore/backup.

Extensive experience in creating user interface using HTML, Angular JS, Ajax control toolkit, user controls.

Experience in writing Data Access Layers using ADO.Net, Entity Frame Work and LINQ.

Experience in Web Service implementations. SOAP and REST services and WCF services.

Experienced using AJAX Controls to increase the responsiveness of the web application, used AJAX Toolkit for user Interface Development.

Experience working in Web service, WCF services and Windows services.

Good knowledge of Enterprise Library.

Experience working in UI design using WPF with Expression blend tool. Worked in XAML language for UI design and developed the code in .Net along with WPF implementation.

Experience in using VSS and TFS as Configuration management tools (Version Controllers) .

Well-honed skills of process flow as per organizational standards of CMMI Level5 Company.

Proven ability to prepare project technical, process and audit documents.

Worked as process coordinator and presented the project for various organizational audits.

Holds a profound knowledge in executing project in all Software development cycles from requirement till production support and sign off.

Performed Unit Testing for testing the Applications and Proficient in writing Unit Test Cases for Business logic and client functional requirements.

Proficient in developing applications using Object Oriented (OO) programming concepts.

Experienced in logging defects and provide root cause analysis on criticality of defects and perform defect review meetings with team.

Expertise in interacting with client for functional requirements, estimations, implementation, project status meetings, defect prevention, delivery and sign off.

As a Team Lead, extensive experience of handling and assigning tasks to team members, maintain the coding standards, schedule team activities and track the status for on time delivery and sign-off.

Excellent presentation, communication and organizational skills. A good team player with good analysis, problem-solving ability, verbal and written communication.

Quick, dynamic and constant learner with strong academic background.

Ability to learn and adapt to new technologies and features.

AREAS OF EXPERTISE:

Domain

Health care

Finance

Educational

Development platform

.NET 2.0, 3.5, 4.0

Programming Languages

ASP.NET, VB.Net, C#, ASP, Ajax, HTML, PL/SQL

Development tools

Microsoft Visual Studio 2010/2008/2013

RDBMS

MS SQL Server 2000/2005/2008, MS Access

QUALIFICATION:

B.E. in Information Technology, 2007,

Shri Vaishnav Institute of Technology and Science, Indore (M.P)

CERTIFICATION:

MCTS 070-528 (.net Web Based Client Development) - 2008

PROJECT EXPERIENCE:

Project Name: Load collection and queueing

Account: JP Morgan Chase

Role: Application Development Lead

Environment: Visual Studio 2013, .Net 3.5, 4.0, ASP.NET, C#, SQL.

Duration: June 2015 – July 2016

Location: Dallas, TX

Project Description:

Loan collection and queueing is the module for all the loans processing of a leading financial organization. In this project, all the pending payment loans of the bank is queued based on rule engine. There are different types of jobs runs in SQL and based on criteria sheet, all the pending loans are inserted in different queues. Agents from the bank will pick up the loans from queues to follow up on them and update the status. There is a web application developed for agents and business users where tracking of all the queues are done. Once any update is provided for the loan, the agent update the loan in web application and based on status that loan is again set up with the flag for processing on next day/month/year. In this way all the pending loans are processed daily/monthly/yearly basis.

To move all the database and services configuration data a new UI is developed. This change is introduced because of EPV changes and will support ongoing activities for VLS to MSP. New module called “iCAT configuration” was added in Admin menu of the application and this will contain the configuration changes for database information, SSIS services and EPV values.

Responsibilities:

Maintaining web application modules and criteria sheet if any new criteria comes up for particular loan type.

Developed presentation layer using HTML, Angular JS and .Net controls for new configuration change request.

Developed a new UI for maintaining configurational data. This new design will maintain all the configurations for database and services after changing project to EPV mode. This requirement will be helping in VLS to MSP trans. This new design was later named as iCAT configuration pages which is moved in Admin module of application.

Responsible to coordinate all the development work and keep track of all the changes.

Key individual in the project responsible for interacting with agents and business users to gather the requirements for change requests and answer the loan related queries based on existing business criteria sheet.

As a Team Lead, responsible for handling and assigning tasks to team and track the status for on time delivery.

Key responsible for answering loan queries to the business users if there is any query for loan status or loan type or delay or flag. Need to look up the criteria sheet and analyze the loan to answer Business about loan falling in certain category or follow up queue.

Working with SQL database on tables and stored procedures and look for all matching loan criteria for queueing and queue cuts.

Handling all the process related work for all the database deployments. Need to raise ITSMs for all the database and UI changes.

As a team lead, need to coordinate all the ITSM work based in different team members change logs and oracle scripts.

Project Name: Energizer Separation

Account: Energizer Holdings

Role: Application Development Lead

Environment: Visual Studio 2013, .Net 3.5, 4.0, ASP.NET, C#, SQL Server 2008

Duration: Oct 2014 - May 2015

Location: St. Louis, MO

Project Description:

Energizer Holdings is an American manufacturer of batteries and personal care products, headquartered in Town and Country, Missouri. It is most well-known brands are Energizer and Eveready batteries for home products. Schick, Wilkinson Sword, Personna, Edge, Hawaiian Tropic and banana boat are personal care products. On April 30, 2014, Energizer announced it would separate its battery business and its personal care business.

With the separation, entire IT is separating into two parts - EHP (Energizer Home Products) and EPC (Energizer Personal Care). All the applications and data are now separating, thus many applications are modified to support the separation. Go2Market is the main application where all the data is linked and stored. This application is the main focus for separation as to go for the separation, all the EPC and EHP modules needs to be separated in two different applications which will independently work after separation.

Responsibilities:

Key individual in the project responsible for interacting with the client and IT Owners to gather functional/non-functional requirements and understand the business flow.

As a Team Lead, responsible for handling and assigning tasks to team and track the status for on time delivery.

Key responsible for gathering all the applications data and access information from IT Owners to identify and separate EHP and EPC data.

Enhance Go2Market application from presentation logic to database using .Net framework 4.0, ASP.net, HTML, ADO.NET, jQuery, Web Services and SQL server to separate all the modules for EHP and EPC.

Developing business layer using C# and reusable components for separation.

Enhancing presentation layer using HTML and .Net controls to separate EPC and EHP.

Responsible to coordinate all the development work and keep track of all the changes.

Working with SQL database on tables, relations, stored procedures, triggers and SQL scripts.

Working on services for various interfaces to split them for two companies and changing all the service providers and consumers settings based on domain for future use. Worked on WCF services and update all the data points and consumers based on new separation requirement.

There is huge amount of data present for company as a whole. Involved in performance tuning for the same and planning for distributed systems/servers for high performance after separation for EPC business.

There are various interfaces and web service updates require for separation.

Working extensively to verify all the existing data against requirements and support the separation activity.

Prioritizing all the application based on its usage and criticality and schedule the development activities so as to complete IT separation task on time.

Identifying all the changes required in each application working for both EHP and EPC.

Used Visual Source Safe and TFS for version controlling.

Project Name: BIGGER - Finance

Account: International SOS (ISOS)

Role: Application Development Lead

Environment: Microsoft Visual Studio 2010, .Net 3.5, ASP.NET, C#, VB.NET, SQL Server 2008

Duration: May 2012 - Sept14

Location: Philadelphia, PA

Project Description:

International SOS is the world's leading provider of medical assistance, international healthcare, security services and outsourced customer care.

BiGGeR is the finance application of International SOS and handles all the claims, invoicing and billing procedures of ISOS Business through Providers and its clients. After completion of each health service, service provider generates the claim and after claim processing, invoicing process start for the consumer.

All the transactional data created in BiGGeR is also integrated with other applications of ISOS. Web and Windows services formed the base for integration.

Responsibilities:

Key individual in the project responsible for interacting with the client to gather functional/non-functional requirements and coordinate development at offshore.

As a Team Lead, responsible for handling and assigning tasks to team and track the status for on time delivery and sign-off.

Prepared Functional Specifications based on Business Requirements from client.

Successfully completed several enhancements from presentation logic to database using ASP.net, HTML, ADO.NET and SQL server.

There are various dependent applications accessing data from BiGGeR. Maintained those applications in VB.Net and SQL changes in line with the mail application changes.

Used AJAX Controls to increase the responsiveness of the web application, used AJAX Toolkit for user Interface Development.

Used security features like authentication, authorization and encryption.

Worked extensively on tables, relations, stored procedures, triggers and SQL scripts.

Implemented the audit requirement in database using triggers and columns.

Preparing Unit Test Cases following modularity of project.

Creating, maintaining databases & database objects in SQL server.

Used TFS for version controlling and tracking the progress of project.

Responsible for keeping track of all the changes in change log and verifying it against Functional requirements and visual source safe report.

Follow Project Process Flow cycle starting from Requirement Phase for each enhancement request/major release.

Prepare and maintain various reports representing project data. Includes traceability matrix, defect report, defect prevention report, Audit report.

Key responsible for gathering all the project data and preparing reports.

Project Name: Service Provider Information Network - SPIN

Account: International SOS (ISOS)

Role: Senior Developer

Environment: Microsoft Visual Studio 2010, .Net 3.5, ASP.NET, VB.NET, C#, SQL Server 2005,WPF

Duration: Jul 2009 - Apr 2012

Location: Singapore and India

Project Description:

International SOS is the world's leading provider of medical assistance, international healthcare, security services and outsourced customer care.

Service Provider Information Network (SPIN) is the application that maintains all the service providers for ISOS. The primary objective of SPIN system is to allow ISOS to manage relationships with its Services Providers around the world, and to ensure that each and every time a request for services is handled by International SOS staff, the most appropriate services from a reputable provider are offered to the customer. The SPIN system is a strategic initiative for International SOS, and requires a large financial and manpower investment. This system manages provider's data, maintains reviews of providers and passes this data to all other applications of ISOS.

Previously SPIN is developed in other technology; this project is to rewrite the SPIN from scratch using .Net technology as all the other applications of ISOS are in .Net.

Responsibilities:

Understanding of existing application followed by preparation of Functional Specification.

Experienced entire SDLC life cycle for this project including SRS, Design & Analysis, Development, Testing, Version Controlling, and Testing and provided support for deployment, UAT issues and Production Support.

Code the project from scratch in .Net technology in accordance with functional specifications.

Developed the entire presentation layer using web forms, HTML controls, validation controls, data bound controls and Ajax controls toolkit.

For enhanced UI design and features, WPF is used along with expression blend tool. Thus worked with XAML language and parallel worked on code behind for functionality.

Developed business layer using c# and reusable components.

Developed database layer using ADO.NET and LINQ.

Used Entity framework from binding database to the application.

Created database using SQL server. Includes tables, relations, stored procedures, triggers and complex queries.

Worked on Reporting services to create various health reports for patients and help in billing reports and invoicing into Bigger from SPIN.

Used ADO.NET objects such as Data Adapter, Data Reader and Dataset for reading/updating records in the database.

Implemented the audit requirement in database using triggers and columns.

Developed master pages and user controls.

Used crystal reports for end user's medical history, check-ups, reports and follow-ups.

Maintained all the other small applications dependent on SPIN. Done changes in VB.Net, SQL server and interfaces between all the applications.

Preparing Unit Test Cases following the modularity of project.

Performed Unit testing against unit test cases and tracked all the defects till closure.

Project Name: Newcase

Account: International SOS (ISOS)

Role: Senior Developer

Environment: Microsoft Visual Studio 2005, .Net 2.0, ASP.NET, VB.NET, C# SQL Server 2005

Duration: Dec 2008 - Jul 2009

Location: India

Project Description:

International SOS is the world's leading provider of medical assistance, international healthcare, security services and outsourced customer care. The primary objective of Newcase system is to create a case for each and every service provided by ISOS to any individual/group of people. Whenever there is any medical service call comes to ISOS, the process start with creating a new case for the service. In this application, all the stages of service are tracked for ex - case created assigned to provider, transfer case to GoCare, validate and finance in Bigger and after all the process is completed the case is back to Newcase for closure.

Responsibilities:

Following Project Process Flow cycle starting from Requirement Phase for each release.

Done impact analysis as per client requirements.

Successfully completed several enhancements using VB.Net for Gocare integration application and ASP.net, HTML for web part of application. Used ADO.NET and SQL server for connectivity and database for both the applications.

Involved in development of database using SQL server. Includes tables, relations, stored procedures and triggers.

Actively participated in UI and design change release and suggested many quality changes which will be approved and implemented.

Involved in development of UI and design release which is successfully signed off and received various appreciations for the same.

Used ADO.NET objects such as Data Adapter, Data Reader and Dataset for reading/updating records in the database.

Developed master pages and user controls.

Preparing Unit Test Cases following the modularity of project.

Creating, maintaining databases & database objects in SQL server. Worked extensively on tables, relations, stored procedures and triggers.

Project Name: Copy Course

Account: CEC - Career Education Corporation

Role: Developer

Environment: Microsoft Visual Studio 2003, Winforms, .Net 3.5, VB.NET, SQL Server 2005

Duration: Jun 2008 - Nov 2008

Location: India

Project Description:

CEC is one of the largest education service providers. CEC creates/maintains applications for various educational institutes/universities. Copy course is module where user can create a new customized term/class from existing previous term's class data. This helps in customizing the class but saves time to get the base data from previous available term. Once the basic structure for the class is created each and every course can be customized as per new term requirement.

Responsibilities:

Responsible for developing client requirement as per use cases provided for new functionality.

Successfully completed several enhancements from presentation logic to database using VB.net, HTML, ADO.NET and SQL server.

Developed new GUI based on wire frames provided by client.

Developed various logical units of business layer which involved in get the data and copy it for new term.

Extensively created and modified various complex stored procedures for copying the data.

Unit test the functionality against requirements and use cases.

Creating, maintaining databases & database objects in SQL server. Worked extensively on tables, relations, stored procedures and triggers.

Project Name: Global Occupational Care

Account: International SOS (ISOS)

Role: Developer

Environment: Winforms, VB.Net 2.0, VB, SQL Server 2005

Duration: Sep 2007 - May 2008

Location: India

Project Description:

GOCare is a health-monitoring program managed by International SOS. Assist organizations manage the health and safety of their global workforces and customers. GOCare includes - Standardized medical assessments, Logistical arrangements managed, Medical data storage, Consistent and objective medical review and interpretation of results, Issuance of Medical Passports, Reporting i.e. presentation of Medical Data in Crystal Reports. GOCare Online web application is driven by data feeds from GoCare offline. Offline Data is presented Online in a customized way depends on different Clients. Members can access their medical statistics from GOCare Online in the form of various reports prepared from offline data.

Responsibilities:

Maintaining and enhancing of existing application according to requirements.

Creating, maintaining databases & database objects.

Production support to the existing application, resolving application issues and database issues.

Responsible for solving critical production defects efficiently.

Part of development team handling enhancements and project releases.

Used VB.NET, ADO.NET and SQL server for development.

Used crystal report tool for report generation of project.

Normalize various versions of database following the Database standardization process.

Used Visual Source Safe for version controlling.

Contact this candidate