Sql Server Project
Resume:
Mob: +1-806-***-**** Email: ********@*****.***
Jayant Kumar
EXPERIENCE SUMMARY
• Jayant has around 5 years of experience in IT industry extensively on Microsoft Technology, C++ and C based
applications in Domains like Crop Insurance, Accounts/Payments,
• Specialized in:
Object Oriented Programming and Design Patterns.
Test Driven Development (TDD) (Used NUNIT Framework).
Cutting edge technology: WCF, MVC3, ASP.NET,Entity Framework etc.
Data Base Programming i.e. Stored Procedures,Cursors, Triggers
NET framework fundamentals, language (C#) and different versions of .NET.
Optimizing performance and maintaining scalability in Asp.net applications.
Database design, TSQL and optimization in SQL Server.
Experience in working with Agile Methodologies along with Leading & Managing team
Data Analyzing and massaging techniques
Designing,Developing, maintaining and Optimizing Data Migration services using SSIS
Designing and Developing Data warehouse
Designing and Developing Reports Using SSRS and integrating it with SharePoint
• Have managed the planning, organization, and implementation of project activities.
• Diverse experience utilizing in N-tier architecture applications including Asp.Net, MVC, WCF
• Fluid understanding of multiple programming languages, including C#, HTML, XML JavaScript, Ajax.
• Hands on experience on cutting edge technologies like Design Patterns, MVC Architecture.
• Have work experience in Web based application development, Database programming, Server side programming and
Client Server computing in multi-threaded software systems using C#.Net.
• A very good knack for streamlining and optimizing processes and Data Base SQL Queries.
• Proactively identified and solved project issues through negotiation and/or escalation processes.
• He has been involved in each phase of software development life cycle during his projects where he was involved in
Requirement gathering, Requirement Analysis, Impact analysis, Effort estimation, Functional Studies, Designing, software
development, unit testing, Quality Review, Production release and support.
• He holds experience on software development methodologies such as waterfall and AGILE-SCRUM .He has Good
Understanding of process improvement approaches like CMMi, and ISO and also participated in assessment and
identification of areas that need process improvement
• He has worked with esteemed client ProAG (CUNA Mutual Group) in developing and maintaining their IT applications
and business flows.
• He has received many client appreciations for his hold on functional areas.
• He wish to continue managing and working on technically challenging projects which includes creating algorithms based
on requirements, database design, application and process flow designing.
ACADEMICS
Education (Yr. of Passing) Major Institute
1. Bachelor of Engineering (2005 To 2009) Computer Science Anna University,Chennai,India
and Engineering.
2. 12th (2004) Science (CBSE Board), India
3. 10th (2002) Science (CBSE Board),India
WORK HISTORY
1
Mob: +1-806-***-**** Email: ********@*****.***
Duration Organization Designation WORK LOCATION
49 Months MajescoMastek Inc. Sr. Software Engineer Amarillo, TX, USA and Pune,MH,India
(Mastek Ltd.)
TECHNICAL SUMMARY
SKILLS TOOLS EXPERIENCE LEVEL (Years)
ASP.NET Visual Studio 2005/08/10/12 4
Web Services/WCF Visual Studio 2005/08/10/12 4
ADO.NET Visual Studio 2005/08/10/12 4
HTML/HTML5 Visual Studio 2005/08/10/12 1
JavaScript 1
T-SQL MS Sqlserver 2005/2008/2008R2 4
Reporting Services (SSRS and Crystal report) SQL Server 2008 R2 4
SSIS SQL Server 2008 R2 2
XML 2
C 2
Winforms Visual Studio 2005/08/10 4
C++ 4
Emrys 3
Database programming MS SQL server 2005/2008 R2/Pervasive 4
Roles Developer 4
Lead Developer 2
Analyst 2
Source code control VSS 2
TFS 4
WORKSHOPS/TRAINING PROGRAMS
Conducted In House Training programs on VS-2008/.net framework and MS SQl Server 2005 at Mastek Ltd..
•
Has been actively involved in Technical recruitment panel in Majescomastek Inc..
•
ACHIEVEMENTS
• He has got Stellar award in ProAG for his contribution in Data redesign of Rewrite System of Legacy .
• He has got Recognition award from client ProAG., for re-designing and Automating the Reporting System..
• He has got On-Spot recognition award in Mastek for implementing new functionalities under strict timeline.
Project Description:
Project 1: MajescoMastek Inc.(Mastek Ltd.)
Project Name: ProAG Oasis
Client Name: ProAg (Cuna Mutual Group), US
Duration: August 2010 – Till date
Role: ONSITE co-ordinator, programmer Analyst and Data Analyst Project Type: Analysis, Development, Maintenance
and Support
Technologies: C#, ASP.NET,WCF, JQUERY, Microsoft Visual Studio .Net 2010, SQL Server 2008, VSS, Beyond Compare,Kdiff, AJAX,
javascript, jquery,CSS,C++, Win forms, XML, Emrys Framework, Pervasive Database, HP ALM(application life cycle management), On
time, EPMO,SSRS,SSIS, Nunit
Description:
It is a software solution for Operations of a crop Insurance provider ProAG (A subsidiary of Cuna Mutual Group USA), which deals
with online writing policy, claim for the loss and Collecting and massaging data from RMA USA, which is used for writing a valid
policy. It is an application which deals with entire crop insurance life cycle.
Currently it is in Maintenance Stage and rewrite is in Development cum Maintenace phase.
Team Size: 50
2
Mob: +1-806-***-**** Email: ********@*****.***
Roles and Responsibilities:
Requirement gathering and Onshore – off shore co-ordination
1.
Algorithm defining, Application designing, application development, deployment, Quality Management and
2.
support activities.
Creating Unit Test Plans using TDD (NUnit) frame work.
3.
Responsible for developing the business logic using Object Oriented Programming Languages like C#.
4.
Developed the different Web and Windows application using ASP.NET, C# 1.1/2.0/3.5.
5.
Developed the web application using MVC pattern and created the LINQ queries.
6.
Developed and integrated the Web Services (WCF) with web application using C# 1.1/2.0/3.5.
7.
Database programming like - Writing Stored Procedures,Cursors,Triggers using SQL Server 2008/12
8.
Writng/Developing/Optimizing SSIS package for Data load from RMA FTP into ProAG System
9.
10. Developing SSRS reports
11. Used almost all the components of SSIS .like DFT,Script Task,Script Component, Execute process task etc.
12. Developed various SQL Batch Job and SQL Scripts for Forward Migration.
13. Responsible for Data Migration and Deployment of the application on the server.
14. Involved in the different QA Release, Model Office Release and production release cycles.
15. Provided the support to QA and Production support team.
16. Also involved in the white box testing of this project.
17. Analyzing the new Business rules released by RMA, Designing Algorithm and Test Plan
18. Working on design of new rewrite of old existing legacy system on .net Platform.
19. Maintaining the various Environments, database and Application Servers
20. Doing reverse engineering and creating the workflow/functional flow diagrams
21. working on production tickets and issues.
22. Working on the development of ASP.NET based rewrite application.
23. Developing Models, Views and Controllers
24. Analyzing the Data and sending reports to Accounting Manager
25.
Project 2: in MajescoMastek Inc.(Mastek Ltd.).
Project Name: LossAdjusterExpense
Client Name: ProAg (Cuna Mutual Group), US
Duration: Aug 13 – Till date
Role: Developer and Data Analyst Project Type: Analysis and Application development
Technologies: ASP.Net,MVC 3 javascript,Jquery,CSS, SQL SERVER 2008, WCF, SSRS, SSIS, SharePoint
Description:
It is web based application for all the Employee/Contractor/Agents/Adjusters/Underwriters to Enter their Expenses and get it
Reimbursed.
It is specially designed on the base of ProAg Business.
It also gather Data from 3 other External Systems using SSIS .
Technologies used were: C# ASP.NET MVC 3, SQL server 2008 R2,SSRS, SSIS.
Team Size: 6
Roles and Responsibilities:
26. Algorithm defining, Application designing, application development, deployment, Quality Management and
support activities.
27. Developing web Application using ASP.NET,MVC(MVC3) pattern (Views, Models and Controller ).
28. Developing SSRS reports
29. Writing/Developing/Optimizing SSIS package SSIS packages to bring data from various External Systems like
Oasis, Agworks, ExponentHR. And Export the Summary file at ProAg SharePoint .
30. Writing/Developing/Optimizing SSIS package to Export the Summary file and upload at ProAg SharePoint .
31. Programming Database cursors,functions, Stored procedures and triggers
32. Scheduling/Subscribing the Report at Sharepoint portal
33. Designing Database and tables
34. Analyzing the Data and sending reports to Accounting Manager
Project 3: in MajescoMastek Inc.(Mastek Ltd.).
Project Name: ProAg Reports Automation
Client Name: ProAg (Cuna Mutual Group), US
Duration: JAN 13 – Till date
Role: Lead Developer and Data Analyst Project Type: Analysis and Application development
Technologies: ASP.Net, javascript,Jquery,CSS, SQL SERVER 2008, WCF, SSRS, SSIS, SharePoint
Description:
It was to Automate the Entire Reports system in ProAg which include Business reports,Accounting reports as well as statistical
report .It include design/development of a Data warehouse and Share point.
This project deals with optimizing the timelines, reducing the effort, automating certain processes and overall reducing the time
span of 20 days to 2 days.It uses third party services also for gathering data.
Some of the reports are used in different web application.
Technologies used were: C# ASP.NET, SQL server,SSRS, SSIS.
Team Size: 8
Roles and Responsibilities:
35. Requirement gathering and Onshore – off shore co-ordination
36. Algorithm defining, Application designing, application development, deployment, Quality Management and
support activities.
37. Developing SSRS reports
38. Writing SSIS packages to bring data from various sources and putting them into Datawarehouse database.
39. Building a Dashboard for Accounting Team
3
Mob: +1-806-***-**** Email: ********@*****.***
Writing/Developing/Optimizing SSIS package
40.
Programming Database cursors,functions, Stored procedures and triggers
41.
Scheduling/Subscribing the Report at Sharepoint portal
42.
Designing Database and tables
43.
Analyzing the Data and sending reports to Accounting Manager
44.
Project 4: in MajescoMastek Inc.(Mastek Ltd
Project Name: Masteknet –L&D
Client Name: Mastek – L&D,India
Duration: April 10 – July 2010
Role: Designer/Developer/Analyst Project Type: Application development and Maintenance
Technologies: ASP.Net 3.5, SQL SERVER 2008, WCF
Description:
It was a software solution for internal Operations of Mastek which deals with online Leave application, loan application, IT
declaration; Incentive Calculation and Pay slip generation.
Technologies used were: C# ASP.NET, SQL server., SSIS, SSRS
Team Size: 4
Roles and Responsibilities:
Discussed, gathered and analyzed requirements with customer
45.
Produced Use Case diagrams and Unit Test cases based on gathered requirements
46.
Worked on Leave module of Masteknet –L&D and Integration of all modules.
47.
Used .net framework 3.5 for development.
48.
Developed Presentation Layer for Apply_Leave and Approve_Leave using ASP.NET.
49.
Did backend programming on Sql server 2005(wrote stored procedures, functions, triggers and cursors) .
50.
Developing and Maintaining SSIS Packages
51.
Used Sql server 2005 for Authentication and authorization.
52.
Gave support to entire application.
53.
Project 5:
Project Name: Octopus (Online Advertising)
Client Name: HANDSTANDS,USA
Duration: Jun 09 – Mar 10
Role: Application developer Project Type: Application development
Technologies: ASP.Net, SQL SERVER 2005, Web Services, SSRS
Description:
It is specifically meant for global advertisers to reach the vast area of online consumers & to let them gain insight into their ultimate
consumer profile which was responsible to Connect and optimize online users or audiences and inventory with access to over 386 million
unique worldwide. This project was specifically meant for tracking & monitoring the behavior of target audiences that uses web for their
general surfing based on their reading articles, searching, website visits & hits etc.
Online Advertising enables marketers to, Engage with customers based on their behaviors and interests, Reach target audiences
wherever they go across the Web, Send prospects relevant messages based on where they are in the buy cycle and protect advertiser’s
brand and control their behavioral media buys on a single platform
Team Size: 4
Roles and Responsibilities:
Discussed, gathered and analyzed requirements with customer
54.
Produced Use Case diagrams and Unit Test cases based on gathered requirements
55.
Creating Procedures, Functions, triggers, Unix Shell Scripts on timely basis.
56.
Used Visual studio 6 for development.
57.
Developing new reports and screens as per requirements
58.
Used Sql server 2005 for Authentication and authorization.
59.
Gave support to entire application.
60.
Initiated the crisis call to resolve raised issues, which impact multiple users
61.
Involved in creation & generation of status reports of raised & issued tickets to customers
62.
Creating Business Reports using SSRS
63.
Project 7: in MIT,Anna University,India
Project Name: Automated Modeling of worms Client Name
Duration: Sept 08 – April 09
Role: Application developer Project Type: Application development
Technologies: Java, Sql server 2005
Description:
It was developed to detect a system is been attacked by worm in a LAN or WAN and was based on an IEEE research paper.
It was the college project.
Team Size: 2
Roles and Responsibilities:
Discussed, gathered and analyzed requirements with customer
64.
4
Mob: +1-806-***-**** Email: ********@*****.***
Coding in java to implement the business logic
65.
Database Programming
66.
Manual Testing.
67.
Project 8: in MIT,Anna University,India
Project Name: Quiz Contest - Symposium
Duration: Aug 07 – Oct 07
Role: Application developer Project Type: Application development
Technologies: C++
Description:
It was software developed to conduct Quiz contest in College campus on systems present on College LAN.
Team Size: 2
Roles and Responsibilities:
Discussed, gathered and analyzed requirements with customer
68.
preparing Use Case diagrams and Unit Test cases based on gathered requirements
69.
Algorithm Designing
70.
Manual Testing
71.
Contact Details:
Mob: +1-806-***-****
Email: ********@*****.***
Mail: 7101 Wolfin Ave., Apt# 602, Amarillo, TX, 79106
5
Contact this candidate