Software Developer (ASP.NET, MVC,Sitefinity CMS,SQL SERVER 2008/12 ,SSRS,Responsive Designing)

Experience
Tata Consultancy services ltd.                                                                                                June 2015 – Till Now
Developer/DBA
Project- Dow Chemical Manufacturing

• This project was related to migrate existing on-premise application to Microsoft Azure (IaaS and PaaS mode).
• Existing Applications were combination of asp and oracle, asp and MS access and SQL server 20005/08.
• I converted those DB to SQL server 2014 and for MS access/ oracle databases convert schema to SQL server 2014.
• For data migration I created SSIS jobs and deployed those jobs on cloud server.

Responsibilities-

• Understand business  requirement
• Developed SSIS packages for data migration
• Performed DBA activities for deploying SQL Jobs 
• Backup and restore the database on cloud environment

Skills Used- SQL Server 2014, Azure SQL, MS Access, Oracle, SSRS ,SSIS and Data Migration.
Project - Bank of America

• BICS is a database where data is coming from multiple sources like Oracle, SAP, Micro Strategy and many other data-sources.
• There are some jobs running weekly monthly to pull data in BICS.I worked in this application both part front end and back-end, initially this project is developed in ORM
• I and our team have migrated to EF6.This application is widely used for banking customers.
• Used SQL Server 2014, Oracle, SSRS, SSIS, Performance Optimization of SQL quires.

Responsibilities-

• Understand business  requirement
• Developed Sql quires and stored procedures

------------------------------------------------------------------------------------------------------------------------------------------
Lake water Software.                                                                                                                     Nov 2012 – May 2014
Developer
Project   -TCS BPO                                                                                             
cMatirx is a part of Ultimatix.net which is a TCS-eServe application. Conversion of Oracle Database to SQL Server2008 including views procedure, tables and SSRS reports.

• cMatrix and Trigger application used by BPO 1.0 and 1.1. It consists of two modules, Master module and Trigger Module which is a Transaction module. Matrix deals with capturing
• cMatrix and other Administrative information for different business units. Trigger deals with continuity of business.

------------------------------------------------------------------------------------------------------------------------------------------
A-Connexion Bpo Pvt.Ltd                                                                                                    APR 2012 – SEP 2012
BI-SQL Developer
Project-  Service Chanel USA

• Write sql quires / functions and stored procedures .
• Gave support of dashboard HVACs facility system
• Generate reports using Microstrtegiy  ETL tool
• Created index for optimizing queries

Past Projects:-
  1. Title:  Tullow Oil Corporate (CMS Website)
   Platform:   MVC 4 framework [Razor], Sitefinity CMS7.2, Fluent API, Linq
 Synopsis:  Tullow Oil website has been developed using Sitefinity modules using MVC4 razor and Sitefinity  API’s to access data, video, documents, share prices, images and related promo module. I have created modules like image gallery, result listing documents, press releases                              and External links module.                         
.
 
2. Title :  www.eyeglass.com
     Platform  :  ASP.Net 3.5, VB.Net, JavaScript, Jquery, CSS, SQL Server2008 R2 and Web Service
     Synopsis  : This is live shopping eyeglass site. In which I created web pages  And create queries  for   back  end like searching   and did full text index search for this site,  gave maintenance for  this live site.
3.Title :  www.msitechnologies.com (Designed in CMS) 
Platform  : Sitefinity CMS3.7, CSS, SQL Server2008 r2
Synopsis :  In this site I have created web pages using Sitefinity CMS3.7 and give maintenance for client  for three months. I have created twelve web pages  using Sitefinity CMS 3.7 .
Education                                                                                                                           
Master of Computer Applications                                                                                             JUL 2008 – JUN 2011
PIPS INDORE [RGTU- BHOPAL]
Aggregate Percentage – 78%