Project Sql Server
Resume:
Chirag Gupta ******.**.**@*****.***
Microsoft Full Stack Consultant with Angular. +1-469-***-****
Summary
B.Tech from NIT Jaipur with 9 + years of experience across various domains in Analysis, Design and Development of software projects in .Net, ASP.Net, Sql Server, Oracle, Angular(1.x, 2.x, 4.x) .
Worked with different clients in various areas to provide customizable design and solutions for business needs.
Expertise in application development using Microsoft .Net technologies including C#, ASP.NET, ADO.Net, .NET Framework 2.0/3.5/4.0/4.5, ORM, Visual Studio 2015.
Programming expertise in C#, LINQ, T-SQL, JavaScript, jQuery, Angularjs.
Working knowledge in WCF, WPF, EF, WebApi, REST Services, ASP.NET and ASP.NET MVC 3.0/4.0/5.0.
Good understanding in Agile Scrum, OOAD, UML, SOLID Principles and Design Patterns.
Expertise in design and development of Single Page Application (SPA) using Angular 1.x, ASP.NET MVC, WebApi.
Experience in using IOC containers like Unity and Structural Map.
Working knowledge on web development using HTML/HTML5, CSS3, Bootstrap, XML and XSLT.
Expertise in understanding any existing application architecture/framework and work over it.
Expertise in design and development of System Tests cases using MS Test and Moq framework.
Experience in Data Modeling, TSQL Queries, Stored Procedure, Triggers, Functions and Database Management for Sql Server, MYSQL, Oracle, NoSQL.
Experience in report development using SSRS Reports and Crystal Reports.
Experience in Research and POC development.
Experience in writing PowerShell script for prerequisite Installation, and application Deployment.
Technical Skills
Operating System : WINDOWS 7/10/2013 server.
Programming : .NET 1.1/2.0/3.5/4.0/4.5/4.6, VB.NET, C#.NET.
Database : SQL Server 2008/2012, Oracle 10G, MYSQL 5.6.
Web Development : HTML5, CSS3, Bootstrap, ASP.NET, ASP.NET MVC 3.0/4.0/5.0, JQuery, JQuery UI Knockout, AngularJS, Angular2, AJAX.NET, JavaScript, Type script.
Middleware : WCF, WCF REST, ASP.NET Web Api, Web services.
Tools : Visual Studio 2010/2013/2015, Visio, TOAD, PL/SQL Developer, SSIS.
Source Control : SVN, TFS, VSTS.
Methodologies: OOAD, UML.
Agile Tools : Rally, Jira.
Build Tools: TFS, Jenkins.
Concept : SOA, Design patterns.
ORM : Entity Framework 6.0, NHibernate 4.0.
Cloud Development : Azure.
Project Experience
Project: SysPro: EventOmni Mar 2018 to Current
Environment: C#, SQL Server 2012, Web Api, MVC, HTML5, CSS3, Bootstrap, JSON, Visual Studio 2015, Angular 4.
Project Description:
This project scope is to create a system to organize events for various organizations giving them the potential to create and manage events online.
Responsibilities:
UI development in MVC and writing code to access DB via DAL in ADO.NET.
Understanding requirement from Business Analyst and developing them.
Managing a team of 4 people onshore and offshore.
Project: Lloyds: SSP+ Mar 2017 to Mar 2018
Client: Wipro
Environment: C#, SQL Server 2012, Web API, Angular 4, VSTS, K2, Express.js, HTML5, CSS3, Bootstrap, JSON, Visual Studio 2015, Angular 4, Visual Studio Code.
Project Description:
This project scope is to create a dashboard and a workflow tool, to help Lloyds staff with their day to day work and to reduce scope of manual work. The target was to remove 150 odd people manual day to day task and replicate it with automated workflow.
Responsibilities:
Developed various workflows using K2 and invoking them via Angular.
Mock UI development using Angular 2, Visual Studio Code, Angular CLI, Asp.net, Web Api that generate XML mock data.
Project: VISA: Phoenix Aug 2016 to Mar 2017
Client: Wipro
Environment: C#, SQL Server 2012, Soap UI, Web API, jQuery, ASP.NET MVC 4, REST, TFS.
Project Description:
This project scope was to create and verify rules for various Visa Card third party promos running worldwide. The services created in this project were used to apply discounts on Visa card worldwide.
Responsibilities:
Development of Web API and using Soap UI to test them.
Creation of HTML templates and UI in Angular to interact with backend.
Writing Test cases using Moq and MS Testing framework.
Project: VISA: Card Production Sep 2015 to Jul 2016
Client: Wipro
Environment: C#, SQL Server 2012, WCF, jQuery, ASP.NET MVC 4, REST, TFS, SSIS.
Project Description:
This project scope was to invoke Card Wizard printer services with different Card Formats to print cards. This project printed emergency card for people across the globe and has amongst its customers various banks across various continents.
Responsibilities:
Development of UI, DB and middle tier to print Emergency Card Request.
Writing SP, Triggers and complex queries to manage inventory of cards on a real-time basis.
Writing Test cases using Moq and MS Testing framework.
Project: Visa: ICE-DR Monitoring Tool Mar 2015 to Sep 2015
Client: Wipro
Environment: C#, WCF, PowerShell Script, SQL Server, Windows Forms.
Project Description:
The project scope was to check table content between two data centers and highlight if there was a difference over a configurable time and to deploy the application across multiple servers.
Responsibilities:
Wrote a PowerShell script for checking the connectivity status between App and Web Servers and automated the creation of Application, hosting and deployment using the PowerShell script across App Servers. Created a windows form application and pinged multiple servers to get the row count of various tables to see if there is a difference in row count across multiple servers where data replication is ongoing.
Created a Windows Form with auto scrolling and auto populating features.
Project: Government of Ireland: MTLR Oct 2014 to Mar 2015
Client: Tarams Technologies
Environment: C#, WCF, ASP.NET, MVC, Angular 1.x .
Project Description:
The project was to develop custom page for MTLR used by Government of Ireland Transport division. This project was used in defining the scope of the work and monitoring the projects daily using Google Maps.
Responsibilities:
Worked on development of various custom page for MTLR used by Government of Ireland Transport division.
Created various pages using MVC and integration of Google Maps.
Created various Tables, SP and Triggers for DB to manage various functionalities.
Project: BT End User Portal Nov 2012 to Oct 2014
Client: British Telecom
Environment: C#, WCF, WWF, JQuery, Rest Services, ASP.NET, Angular JS, Web Api2.
Project Description:
Worked on the development of application which the customers will use to place and customize order. The application will go live within a couple of months for the end user using .NET 3.5 Framework.
Responsibilities:
Developed the various API’s which will consume various REST services.
API’s were written in C# cutting across various projects and n-tier structure was followed and there were numerous services which were consumed.
Wrote Customized Workflows in WWF to be consumed by the web site.
Worked on the front end which included jQuery.
Worked on logic to bring down the redundancy level from 95% to 10%.
This was an application written right from scratch and delivered till testing.
Project: CHUCKY Mar 2011 to Nov 2012
Client: Wells Fargo
Environment: C#, Web Services, jQuery, SQL Server 2008, ASP.NET.
Project Description:
Involved in development of the Check Processing System used by users in Home Mortgaging Department of Wells Fargo in US for processing of checks.
Responsibilities:
Interacted with the users for gathering business requirements and prepared understanding documents for the same.
Upgraded the project from .Net Framework 3.5 to 4.0 and resolved various issues.
Wrote Stored Procedure and optimized various existing stored procedures to improve the performance and rewrote many existing logic.
Implemented various service calls and worked with various vendors for the same.
Project: OPIS Mar 2010 to Mar 2011
Client: Johnson & Johnson
Environment: C#, Oracle 9i, ASP.NET.
Project Description:
Involved in development of OPIS used by J&J to mark various drugs under various price labels for different region and different customer groups.
Responsibilities:
Interacted with the users for gathering business requirements, analyzed them, prepared estimates and various enhancement proposals.
The entire code was written in .Net Framework 1.1 and wrote many stored procedures, triggers to implement those functionalities.
Worked on stories from proposals to making them go live and creating new proposals for the project for TCS.
Project: Trail Dec 2009 to May 2010
Client: Johnson & Johnson
Environment: VB.Net, Oracle 9i, ASP.NET.
Project Description:
Involved in migration of the project from VS 2003 to VS 2008 in .Net Framework 3.5 and also adding new functionalities. This was a project of Johnson & Johnson.
Responsibilities:
Handling several enhancements from requirements gathering, design, prototype development and demonstration to development and delivery of the project.
Automation of various mappings and various report generation through Windows Services.
System Engineer Mar 2009 to Nov 2009
Project: SDS
Client: Sauer Dan Foss
Environment: C#, SQL Server 2005, SSRS, ASP.NET.
Project Description:
Involved in creating new reports in SSRS and sending them to the client on a regular basis and also Windows Forms software. It was for Sauer Dan Foss.
Responsibilities:
Worked as a sole developer for Report Generation and worked with the team for win forms based applications.
SQL Server Services was created and consumed to push data into tables for faster report creation.
Provided a UI with win forms to display SSRS reports which would be dynamically generated based on the filters selected by the user.
Project: Project-Tracker Jan 2009 to Mar 2009
Client: Tata Consultancy Services
Environment: C#, SQL Server 2005, ASP.NET.
Project Description:
Project Tracker is an internal system which helps in maintaining the project related activities (billing, WON, SOW), Resources, Resource Utilization. It replaces various complex excels used by the management team.
Responsibilities:
I was the sole person taking the KT from the management team understanding the various functionalities which they implement in their excel sheet and implemented the same in the site.
Developed the DB design, the UI design and implemented the same.
Played the role of Team Leader and also a Team Member and helping various people to understand the functionality.
Project: Alex Oct 2008 to Jan 2009
Client: KPMG
Environment: C#, SQL Server 2005, ASP.NET.
Project Description:
ALEX is an online application for accounting professionals It provides quick access to a full range of authoritative accounting, auditing, and financial reporting guidance and literature with an emphasis on International Financial Reporting Standards (IFRS) and U.S. GAAP.
Responsibilities:
We implemented a few search enhancements and also a few customizations.
This project involved the knowledge transition which includes the activities like going through the documents of Alex, source codes. Also were responsible to demonstrate our understanding through reverse KT through various deliverables.
Project: Issue Tracking System Aug 2008 to Oct 2008
Client: Tata Consultancy Services
Environment: C#, SQL Server 2005, ASP.NET.
Project Description:
Issue Tracking System enables the managers/testers/developers to track the defects. This involves the complete workflow of the defects starting from opening, assigning, fixing and closing the defect. In this project I did the development and designing part.
Responsibilities:
We implemented a complete Issue Tracking System as part of TCS ILP Program.
Project: Solving NP-hard Timetabling Problem using Genetic Algorithm
Jan 2008 to May 2008
Environment: C++.
Project Description:
The project involved understanding the problem statement and coming up with a practical solution in line with Genetic Algorithm. The solution was especially helpful to persons who design timetable on a college basis and have to look into many concerns of the faculty and accommodating all of them.
Education and Certifications
Bachelors of Technology in Information Technology (B.Tech), National Institute of Technology (NIT), Jaipur, India.
Rated Outstanding in the whole account in Visa.
Ranked 2nd during ILP phase II of TCS and was selected out of 60 people to work in a project.
I have been rewarded with TCS “On the Spot” Award, TCS Gems and I have been nominated for the “Star of the Quarter” Award.
I have been rewarded with Achieving Excellence Award and Shared Success Award in Wells Fargo.
Contact this candidate