Payal Sanan
Address: Contact:
****, ****** **** *****, **** Phone: +1-224-***-****
Apt No. – 623, Email ID : *****.******@*****.***
Schaumburg (Illinois) – 60195
Visa Details:
L2 Visa-with valid EAD/work permit
Recently moved from India to US
Summary
Around 3.6 years of experience in analysis, design, development, management and
implementation of web based software applications using Microsoft technologies
including primary skills as ASP.NET using C#, .Net Framework 3.5, IIS, Database
queries, Stored Procedures, Views, Functions, SQL Server tuning, SSIS Package
using SQL Server 2008.
Good experience of working in US Public sector projects.
Strong knowledge of OOPS (C#) concepts
Experience in creating web applications using latest techniques like WCF.
Extensive experience in building SSIS packages for importing and exporting data using
MS SQL Server 2008 which involves complex data transformations.
Experience in Team Foundation server (TFS)
Strong knowledge in writing complex database queries, Stored Procedures, Views,
Functions using MS SQL Server 2005/2008
Strong knowledge in handling build and deployment related tasks on various
environments like staging, testing environments etc.
Experience in developing technical documentation in various stages of software
development life cycle.
Extensive knowledge of the software development life cycle (SDLC) from requirements
gathering to programming, testing and maintenance.
Strong knowledge in .Net Framework Unit testing, Integration testing for modules
coded.
Excellent communication skills with strong background working directly with the
coworkers to identify business objectives and establish requirements.
Technical Skills
Languages : C#
Technologies : ASP.NET, Framework 3.5, WCF
Databases : SQL Server 2005/2008
Software : Visual Studio .Net, SQL Server Management Studio, SQL Server Integration
Services
Platforms: Windows 7, Windows XP, Vista, Mainframe.
Professional Experience
June 2011 – Nov2014
Deloitte Consulting Pvt. Ltd
Location – Mumbai, India
Major Project: State of California, Disability Insurance (CA EDD)
Description: This project was developed with the aim of providing affordable, short-term
benefits to eligible workers who suffer a loss of wages when they are unable to work due to a
non-work related illness or injury, or due to pregnancy or child birth in the State of California,
US.
Role: .Net Developer and building SSIS packages
Responsibilities:
Involved in-depth analysis, development and testing of the project.
Design/develop system, application and program code according to business and
technical requirements. Designing web pages with ASP.NET and coding business logic
with C#.
Building complex SSIS packages for import and export of data which involves complex
data transformations.
Performing coding/programming tasks to specification and in accordance with the
development standards.
Handling all deployment related activities like deploying application and database on to
the different testing environments.
Writing complex stored procedures and queries.
Documenting technical artifacts
Developing unit test scripts and execute those scripts to ensure workability, completeness
and quality.
Involved in handling live production issues and triaging of the incidents.
Jan 2011 – May2011
Worked as an Intern in MICM Solutions Pvt. Ltd.
Project: Human Resource Management System
Description: The HR Management system consists of various modules which includes Training,
Staff Attendance, Employee Management and Payroll for the concerned institution.
Role: .Net Developer
Responsibilities:
Involved in requirement gathering, analysis, development and testing of the whole
system.
Involved in database design, writing stored procedures and functions.
Involved in the integration of all the modules.
Documenting all the technical and functional artifacts. Developed class diagrams, use
case diagrams and sequence diagrams using Star UML.
Academic Qualifications
Masters in Computers Application (MCA) – S.N.D.T Women’s University, Mumbai
Bachelors in Computers Science (B.Sc. Voc.) – MCM D.A.V College, Chandigarh
Personal Profile
: 8th November 1986
Date of birth
Marital Status : Married
Sex : Female
Nationality : Indian
I hereby declare that the above-mentioned information is true up to best of my knowledge.
Date: 02-17-2015 Payal Sanan