saurabh_shekhar_cv

Résumé <Saurabh Shekhar>

Saurabh ShekharContact Number: 08130962572 / 09956964072.Email: [email protected]

Experience Summary Currently working in STPL Pvt Ltd. Lucknow, a US based MNC

(www.stpl.biz) as a Software Engineer from November 2013 onwards. Working on Microsoft Technology (MVC, SQL Server, .Net) with an

experience of 4 years. Followed the industry’s best practices and implementation processes,

which enhanced the quality of technical delivery. Excellent knowledge on MVC, ASP.Net, Java Script, JSON, JQuery, Crystal

Reports, LINQ and Entity Framework. Decent knowledge and experience in Database Designing, SQL Server DDL

and DDM Queries development. Also extensively used Tigers, Cursors and Functions.

Good experience in writing, deploying and calling Web Services. Also worked on WCF and XML based technology projects.

Extensively involved in debugging, reuse, source code management strategies and release management.

Nice understanding and practical exposure of Microsoft Power BI reporting. Development experience in various industries including financial services,

travel, education, material testing and jobseeker portals projects. Well understanding of OOPs concepts. Adaptability with domains with good exposures of Web Applications and

multi-tier architecture. Worked on creating normal and 3D charts, i.e., column/line/bar/pie-charts

to show data using Google charts, Highcharts.Technology

Programming Language

C#, MVC, VB.NET, ASP.NET

Microsoft Technology

Visual Studio 2012/2010/2008, SQL Server 2012:2008:2005, LINQ, Entity Framework.

Web Technology MVC 4, ASP.NET 4.5/4.0/3.5, HTML 5, XML, Java Script, jQuery,AJAX, JSON.

Services Web Services, WCF Services.Database SQL SERVER 2012:2008:2005.Reporting Tools Power BI, Crystal Reports.Configuration Tools

TFS 2010, SVN, Visual Source Safe.

Third Party Controls

Kendo UI Controls.

QualificationsDegree Institute Major and Specialization

B. Tech Information Technology.

Uttar Pradesh Technical University, Lucknow

Computers

H.S.C Saraswati Vidya Mandir, Lucknow.

General

of 6


S.S.C Saraswati Vidya Mandir, Lucknow.

General

AssignmentsThe details of the various assignments that I have worked upon are listed here, in chronological order:

SRM Techsol Private Limited, Lucknow: November 2013 onwards as a Software Engineer

Client Name ATA FleetView Services, USProject Title FleetView360Period From Oct 2014 onwards.Position Software Engineer.Responsibilities Leading the module for Asset Import in the Project.

Done Requirement analysis and task distribution related to project initiation and architectural design of application framework.

Architecture design of my module by considering the high level overall architecture of the complete project.

Designing the module to support responsive design and to support it on various platforms like Windows, Mobile and Tablet.

Database design of my module and other modules. Demo and presentation to customer for the overall

application developed so far on bi-weekly basis. Tracking the change request in the customer call and

getting it implemented. Deployment of application on Development, Test and

Production Servers. Preparing the weekly status report and required

documents that need to be send to client via my Project Manager.

Project Key features of Application:- An application supporting responsive design to support

web, mobile, and tablets. Involves maintenance, fixing the issues, analysis and

taking surveys of ATMs and Banks located at different places for the different customer/banks

It is based on project management system which involves management of multiple assets or service of different jobs related to different project and customers on role based model.

Progresses of the work are tracked on Dashboard with Different kind of statistics and analysis charts, graph etc. with clear understanding.

Applications also support the Help Desk mechanism for raising the tickets, change requests and track the flow for the same.

Platform / Technology/ Language

MVC 4, C#, .NET 4.5, Visual Studio 2012, Third Party APIs, LINQ.

Database Microsoft SQL Server 2012Methodology Agile.Software/ Scripts SVN, jQuery, JSON, High charts, jqGrid.Project Location Lucknow, India.

of 6


Client Name Inspired Change Solutions ICS, South AfricaProject Title PastorPro & LMS (Lead Management System).Period From Nov 2013 to Oct 2014.Position Software Engineer.Responsibilities Involved in completing Life Cycle including Analysis,

Design, Development and Coding. Designing the Power BI reporting solutions for the

Microsoft Executives. Data Modelling to handle the big up-stream data sources. Designing the Data Catalogue, Power BI Q&A, Automatic

Report Refresh solution for the Power BI reports deployed on the BI Sites.

Developed modules of the application in MVC 4 using Kendo Controls. Also used JQuery and JSON for passing and getting data to the controllers.

Written the separate classes for the common functions used.

Interacting the database by using Linq to SQL Queries. Export to Excel functionality on Grid and also import the

data using Excel Sheets into the database. Created the Technical design document and also

proposed a data model to design structure for the new development being done.

Project PastorPro PastorPro is an innovative web based church

management solution that allows you to manage members, new visitor follow ups, events and financial contributions.

It provides you with useful dashboards to easily track event attendance and financial contributions.

PastorPro event management module incorporates church services, Sunday school, training, conferences, etc.

Member can create own events. They can also create members and invite them to join the events.LMS (Lead Management System)

LMS — a complete end-to-end lead management web application that integrates all aspects of enterprise marketing into a single easy-to-use platform.

LMS gives you the ability to better manage the qualification, enrichment, maturation, distribution, and feedback loop on leads—leading to improved closure rates and increased marketing ROI. With LMS lead management solution, you can get higher-quality leads to the right people at the right time and get greater visibility into what happens afterward.


MVC 4, C#, .NET 4.5, Visual Studio 2012, Kendo UI Controls, LINQ, Power BI.

Database Microsoft SQL Server 2012Software/ Scripts JQuery, JSON.Methodology AGILE.Project Location Lucknow, India.

Omni Net Technology, Lucknow: May 2013 to October 2013 as a Software Engineer.

of 6


Client ITI (VPPUP)Project Title Vyashyaik Pariksha Parishad. (VPPUP)Period May 2013 to October 2013Position Software Developer.Responsibilities Requirement Analysis, Gathering Information’s and

setting up Architecture to build the applications. Developed applications in Net 3.5 framework and

followed three tier architectures using Enterprise Library. Development using Visual studio 2008 and writing and

creating procedures, functions, sub queries and join in SQL Server 2008 as database.

Developed interface through which exams can be conducted, admit card and verification card can be generated. This application also involves seat allotment, creation of mark sheets.

Developed Entrance Admission form also to fill the admission form by which admission of students for exams can be possible.

Allotment of seat to students in different colleges and in course depends on student category and their rank scored in the exams.

Project This application also involves seat allotment, creation of mark sheets, generation of reports, Admits card, Verification Cards, Challans.

Entrance Admission form /Examination Forms through which admission and examinations of students for exams can be possible and easily conducted.

Allotment of seat to students in different colleges and in course depends on student category and their rank scored in the exams.

Comprises of various logins with various rolesPlatform / Technology/ Language

.NET 3.5, ASP.Net, Visual Studio 2008, Crystal Reports

Database Microsoft SQL Server 2008Software/ Scripts SVN, jQuery, JSON.Project Location Lucknow, India.

Final Quadrant Solutions, Noida: March 2012 to May 2013 as a Software Engineer.

Client Name Sunway, Ireland.Project Title Final Quadrant Suitcase - Travel PortalPeriod March 2012 to May 2013Position Software Developer.Responsibilities Involved in completing Life Cycle including Analysis,

Design, Development and Coding. Developed modules of the application in ASP.NET 3.5, and

involved in writing class libraries using C# for other modules also.

Maintenance of the legacy COM Components developed in VB which is being referred in the current application developed in the .Net.

Involved in creating windows services for generation and sending emails from business to customer and customer to business.

of 6


Created web services to pass data from different channels present across the system.

Responsible for creation and maintenance of various database objects like stored procedures, functions, tables etc. used in the application (SQL Server 2008). Also responsible for the migration and backup process of the databases across the company network.

Created Email Window Service that sends mail manually and automatically to all the respective suppliers and clients.

Worked on creating and maintaining VAT Reports for Subagents which involves all the payments details for the respective subagents bookings are maintained in the form of Excels reports and in Pdfs files and are emailed to the subagents.

Worked on Direct Debit Reports which involves all payments transactions are done and maintained in the report and are emailed to the subagents.

Project It is a complete Travel Technology platform for Travel Agents & Tour Operators.

It provides Multiple Sales Channels (Website-B2C, Sub-agents-B2B, Call-Center-B2E), Ready 3rd Party Integrations with Major Content Providers, Booking Engine, Fares Management, Dynamic Packaging, Mid & Back Office, Mark-ups & Commission Management, Client Management, MIS Reporting & Other Modules.

Exposes interfaces which enable the application to be integrated with different entities or 3rd party aggregators for Flights, Hotels & Apartment, Low Cost Carriers, Car Rentals, and Payment Gateways etc.


.NET 3.5/3.0, SQL Server 2008, WCF Services, Web Services, XML, C#.NET, VB.NET.

Database Microsoft SQL Server 2008Software/ Scripts Visual Source Safe.Project Location New Delhi, India

Nexus Business Solutions, Noida: September 2011 to February 2012 as a Software Engineer

Project Title Job Seeker/Provider Portal.Period September 2011 to Feb 2012.Position Software DeveloperResponsibilities Requirement gathering from various marketing

associates. Web page design and development. Database Design and to write stored procedures.

Project Job Seeker/Provider Portals is getting developed in such a way that it can be configurable easily by any of the Job Provider companies and can assist in their business.

Applications is getting developed in layered architecture manner, so that if any of the company require some changes in the functionality or any additional functionality is required, it can be done easily without making much changes and code rewrite.

Application enables two kinds of login i.e. Job Seekers and

of 6


Employers. The Job Seekers can search job from the listed requirements along with applying for the same and employers can post any requirement using the same portal.

Advance Search will be there to search jobs on the basis of different criteria.


Net 3.5, C#, ASP.Net

Database Microsoft SQL Server 2005Software/ Scripts JavaScript

Tata Consultancy Services, Lucknow: May 2010 to August 2010 as a Summer Trainee

Project Title Team Management System.

Period May 2010 to Aug 2010Position Summer TraineeResponsibilities Attended the Summer Internship as a Software Trainee.

During a period of Internship:- Design and Architecture finalization of the project. Database Design for the project. Development of the project. Project documentation like User Manual, Software Design

Document for the project.Project Application Enables

Provides a common mechanism for managing the various teams and manages the data at centralized location.

Different Modules like Administrator, HR, and General Employee are linked to a common application and dynamic loading of the modules and screen takes place depending on the Role of the Logged in User.

The module General Employee is sub categorized on the basis of various roles like Group Leader, Project Leader, Team Member and the loading of screens and privileges provided on those screens depends on the various roles of the logged in user.

Allow to Create/Update Account, Project, Group Leader, Project Leader, Team Member, HR etc.

Allow the automation of management of large no of people to achieve organization goal.


C#, NET 3.5

Database Microsoft SQL Server 2005.Project Location TATA Consultancy Services, Lucknow

Achievements Got twice Employee of the Month award twice in SRM Techsol Pvt Limited

for my outstanding performance. Got many client appreciations on the modules which I was actively working

on.

of 6

saurabh_shekhar_cv

Documents