praveenresume2015

Mob: +15853581783 Praveen Mehta Email :- [email protected]

Professional Summary Around 10 years of diversified experience in Web development, System Analysis, Technical

Design, Implementation, Performance Tuning, Testing and Release/Build management in all stages of Full Software Development Life Cycle (SDLC) in various Information Technology areas involving C#.NET, ASP.NET, WCF Services and SQL.

Highly Skilled in .NET Technologies with extensive experience in developing SOA based multi-tier applications.

Have successfully handled software development for diverse functions & work areas. Thorough understanding of Technical and Functional concepts in Telecom Domain, Social

Networking, GPS and business applications. Experience in web development, .NET Development (Ex- in ASP.Net and window services), APIs,

web services, and SSO (single sign-on). Good working experience on in developing WCF Services and Web services (Rest and Soap). Experience in using Web Services, Xml, CSS, HTML, Ajax and JavaScript and JQuery. Extensive experience in SQL Server Database design, developing T-SQL queries, stored

procedures, and triggers using SQL Server. Working experience with Source Control Management tools such as; Team Foundation Server

(TFS), VSS and SVN. Practical experience in developing application with Test Driven Development (NUnit Test) Additional skills include CSS, AngularJS (or similar client side framework), REST using Web Api,

SharePoint 2010. Strong experience in Agile development process for diverse requirements. Capable of taking initiative as the situation calls, eager and able to learn new technologies

quickly. Possess versatile leadership qualities and the ability to manage change. Accept responsibilities and job duties eagerly with minimal supervision and Works well under pressure.

Currently working as Senior System Engineer with IBM, India

Current accountabilities includes Provide input into the provision of estimates based on the agreed process, contribute to the

physical design of Internet solutions and produce design specifications based on agreed design principles

Develop components that are as widely reusable in accordance with the Company strategic objectives

To assist with the spread of knowledge within the team by effectively communicating ideas solutions and approaches to colleagues

To help identify potential development opportunities and areas of improvement within existing applications and processes

To undertake system development in the languages stated including unit and system testing of the components

Technical Expertise

Languages C#, OOPS, JSONRDBMS MS SQL Server 2005/2008R2IDE Visual Studio.Net 2005/2008/2010/2013Web Technologies ASP. Net, XML, DHTML, jQuery, WCFDistributed Technologies Web Services, WCFReporting Tools SQL Server Reporting Services 2008Project Related Tools VSTS, FXCOP, NUnit, log4NetMicrosoft Development Platforms .Net 2.0/3.5/4.0/4.5SDLC Process and Modelling Tools Agile(SCRUM variant), Visio 2010

Tools & Utilities VSS2005, TFS, Google Map, Amazon(S3, SQS, SDB), Facebook API, LinkedIn API, Twitter API, Netflix API

Academic Background

Bachelor of Engineering Rajasthan University, Jaipur, India

Employment HistoryIBM India Pvt. Ltd., Pune, India Senior System Engineer Aug 2010 – Present

Rishabh Software Pvt. Ltd., Vadodara, India Team Lead Jan 2010 – Aug 2010

Snl Corporate, Mohali, India Senior Software Engineer July 2008 – Jan 2010

Qbit Systems India Ltd., Jaipur, India Software Engineer May 2007 – July 2008Tayal Software Consultancy Services, Udaipur, India Software Engineer July 2006 – April 2007

Techon Dater Systems Pvt. Ltd., Udaipur, India

GET-Software Development Aug 2005 – July 2006

Recent Projects

Back To Front (RFID)Client Macy’s Systems and Technology

Technology Microsoft C# (4.5) 2013, LINQ, SQL Server 2008R2, Nunit, Moq, Json, Nuget Package, Spec flow

Project DescriptionIn Back to Front project where Macy’s want to scan stockroom inventory and create a Picklist of missing colors and sizes on the sales floor. In the back room a user uses the RFID technology scan each item in inventory and when scan completes he saved it and send a request to web service. Web service will take it from database and generate the Picklist and saved in enterprise database. After

saving user will able to see it on website and generate different-2 reports, print as a PDF or export to excel.Another feature of project is if user want to access the picklist on handheld device and modify it. User can access the generated picklist on device and he want to move item from missing list to Picked list he can search the product number and moved it to picked or not found or user can scan it and move it.

Responsibilities

Responsible for developing the web services.

Responsible for writing unit test cases for every service.

Responsible for writing all complex logic in the service.

Responsible for creating database object.

Created stored procedure, views and table in database.

Responsible for deploying service on development server.

Communicate with other team and deploy service on other environment.

Services are the rest based.

Two different type of service created one for retail server and other for web farm. Retail services runs on every stores and web farm runs on the enterprise server.

Responsible to create an architecture for service.

Responsible to help other team to consume the services on handheld and in website.

Resolved all the Nuget package issue in the service and streamline it.

Using Nunit and Moq for unit testing.

Working in Agile process. Using Jira to assign task and tracking. Take ownership and coordinate application development tasks with a third party software

vendor.

ICS Rewrite

Client XEROX

Technology Microsoft C# (4.5) 2012, LINQ, SQL Server 2008R2, SSRS, SSIS

Project DescriptionICS is web application, which is configurable, Interactive and administrable. The main objective of this application is to deliver to the commission payment to sales people in Xerox-US. The intent of this web application is to reduce the process overhead for any RFC (example: - If there is any request for change in report in system then it will take long time to complete the process (means taking approval for every business person for change). This system will test those changes in base case then publish it directly into production. It is reducing those processes overhead time.)

It’s an automated system from creation to distribution. This application given a customization option to user so user can customize the report or configure according to parameters and also maintain

versions for every configuration. User can create new and maintain the CompPlan group and configure a report according to CompPlan group.

Responsibilities

Responsible for coding and designing of application.

Responsible to create an architecture for application.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

Coordinate and communicate task with developers.

Ensure that development is performed as per requirement.

Use Visual studio 2012 and JQuery in this project.

Written C# code and maintain and create forms and reports. Make CSS and design for whole website.

Created stored procedure, views and table in database.

Responsible for deploying website on development server.

Communicate with other team and deploy website on other environments.

Take ownership and coordinate application development tasks with a third party software vendor.

Certificate Tracker

Client ONCOR

Technology C#, Asp.Net2010(4.0), LINQ, Sql server, Ajax, JQuery, SharePoint 2010

Project DescriptionIn Back to Front project where Macy’s want to scan stockroom inventory and create a Picklist of missing colors and sizes on the sales floor. In the back room a user uses the RFID technology scan each item in inventory and when scan completes he saved it and send a request to web service. Web service will take it from database and generate the Picklist and saved in enterprise database. After saving user will able to see it on website and generate different-2 reports, print as a PDF or export to excel.Another feature of project is if user want to access the picklist on handheld device and modify it. User can access the generated picklist on device and he want to move item from missing list to Picked list he can search the product number and moved it to picked or not found or user can scan it and move it.

Responsibilities

Responsible for delivering solution to our customer.


Responsible for managing scope, planning, tracking, aspects of the project.

Responsible for preparing Weekly Status Report for management.

Coordinate and communicate tasks with developers.

Ensure that development is performed as per requirements.

Communicate activities/progress to project managers, business development, business analysts and clients

Used SharePoint and visual studio 2010 in this project.

Written a C# code for certificate maintain and create forms to add a certificate. Make CSS and design for whole website.

It’s a SharePoint application so for authentication use SharePoint authentication and for email make a C# application and schedule it in windows server.

Successfully deployed application in production server and it’s perfectly working.

Achievements : Received accolade for successful deployment of application.

Operation Dashboard

Client ONCOR

Technology C#, Asp.Net2010(4.0), LINQ, Sql Server, Ajax, JQuery, SharePoint 2010

Project DescriptionThe purpose of this project is to build a dashboard which will be enriched in graphics indicating the current status of all the critical business applications, critical batches and critical processes with color coding.

Along with this, it will also show the trend of all the critical batches and processes from past week or month as required and keep track on all open tickets severity and application wise.

This is a single page dashboard application which have multiple web parts and display different-2 records. It also develop in SharePoint.

Responsibilities

Responsible for delivering solution to our customer.


Responsible to deploy application in different-2 environment (like SIT, UAT, Pre-Prod and Prod).

Responsible to maintain the application and any changes will come in future complete it and deploy the application.

Achievements : Received accolade for successful deployment of application.

CNO

Client ONCOR

Technology C#, Asp.Net2010(4.0), LINQ, Ajax, JQuery, SharePoint 2010

Project DescriptionCNO is portal used by business to see the all the open exceptions, completed exceptions logged through IVR.Also tickets pending, tickets created, Non Match Records are being displayed here CNO was developed in MOSS 2007 which later on got migrated to SharePoint 2010.The portal is just used as an interface to display the ticket information. CNO is not a standalone application. It fetches data from Oracle database. Also it interacts with other applications like ESB which further communicates with LCIS which stores the customer information.This is being used 24*7.ESB is the Integration Platform for exchanging data between Oncor Applications and In-service OMS Applications. It integrates all the data received from sources of reporting outage.

Field Workers get the data from OMS and provide the service to End Customer. SharePoint 2010 is the desired solution because of its alignment with Oncor’s overall IT strategy.

Responsibilities Responsible for deploying the application and maintaining it.

SDS (Software Deployment Systems)

Client ONCOR

Technology C#, Asp.Net2010(4.0), LINQ, JQuery, SharePoint 2010

Project DescriptionThe centralized portal for deployment change requests will eliminate the hassle of tracking requests in BMC remedy and it will be useful to monitor and administer lower environment application setup and migration. It also will have features for notifying the stakeholders as a request flows through the work flow.

Responsibilities

Responsible for developing it from scratch.

Develop in SharePoint using visual studio 2010.

Responsible for development and design of the application.

Command Center

Client ONCOR

Technology C#, Asp.Net2010(4.0), Oracle 11g

Project DescriptionCommand Center Application is used to collect RF Meter reading from collector and pass it to MDMS System. Command center (CC) is the application responsible for interacting with Meter inbound or outbound.

Command center is a part of AMS (Advance Metering System). CC is the gateway application, which interacts with Collectors for the meter information.

CC collects meter reading, creates LP files and MR files, and sends it to MDMS and AMS R3. Below flow describes the file interaction between CC and different AMS systems.

Responsibilities

Responsible for supporting the application.

Responsible for sending daily ODR report.

Responsible for get the Connect Disconnect status report from oracle and send it to client.

Responsible to write a query for connect disconnect report.

Responsible for get the LLUpdate and update it in database and send report to client.

Digital Enrollment

Client Direct Energy

Technology C#.Net4.5, Asp.Net4.5, MVC, WCF, Sql server2008, JQuery, Knockout

Project DescriptionAs a Team Lead responsible for Analysis, effort estimation, design, development of .Net applications or new developments

Responsibilities

Responsible for leading team in delivering solution to our customer.

Deliver new and complex high quality solutions to clients in response to varying business requirements

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Responsible for preparing functionality and project Setup document.

Maintained quality communication with client.

Key projects handled so far include Digital, OTS, VB Project.

Achievements : Received appreciations from project manager.

Comcenter Website

Client Sprint

Technology Microsoft C# ASP.NET (3.5), LINQ, SqlServer2008, Ajax, JQuery

Project DescriptionComcenter is an internal application used by Sprint employees in the support of Toll Free Portability. The application serves as a database for portability support and is utilized for data entry, number administration/reports and inquiries as well as a management tool for the daily workload.Responsibilities



Responsible for managing scope, planning, tracking, aspects of the project.





Used jQuery in this project and use of Ajax on various reports to display faster result.

Written a C# code for port management and user related forms and test them. Make CSS and design all port management and user related forms

Written flexible programming so application can be host on any server

Used objects and cache them so we have faster results when we sort, filter or search data.

Continuously working on code optimization.

Key projects handled so far Comcenter Website.

Achievements : Received lot of accolades mail from Client. Received appreciation from project manager.

OrderAid Management SystemsClient SprintTechnology Microsoft C#.NET (4.0), LINQ, SqlServer2008, WPF, BlueZone

Project DescriptionOrderAid is One-Sprint macro based batch processing tool that automates high volume order management activity for CIS (Customer Information Systems), FMS, and KSLW.In this application User can create a excel template and fill those template manually and again upload

those one in the application and all records save in database and those records process in mainframe using BlueZone.Responsibilities



Basic thing of this project is its architecture which is based on object and its interface with bluezone and batch processing, I developed this architecture, Bluezone connection, Batch Processing and only responsible to manage this.

Worked on application critical parts like Template creation, Bluezone connection, download file from server, Write data into excel, Data importing from excel, progress bar and slider for macros and project installer.

Using new .net technology LINQ and WPF and all database related code and query written in LINQ.





Continuously working on code optimization.

Responsible for managing project plan and track project steps in tracker sheet. Key projects handled so far Order Aid Management Systems.

Comcenter ApplicationsClient SprintTechnology Microsoft C#.NET (4.0), SqlServer2008, BlueZone

Project Description Comcenter have basically 3 small applications.

1.) Port Monitor2.) CISAgent3.) SMSAgent

1.) Port MonitorPort Monitor application searches new Toll Free number in mainframe and compare it with last saved toll free number in Sql server database. If numbers do not match then it saves the current toll free number in database. The same process runs for each available number.

2.) CISAgentFirst we login into CIS and then pick TFN from database. According to them we will get some message from mainframe and as per message it will update TFN status and some other field in database. Through some process we get TFN status from mainframe and update it in database.In third module, we will apply a query in database to get some TFN number. This TFN number would get pass in mainframe. This will fetch some screen code and as per the condition we update “END User Account Name” in database.

3.) SMSAgentFirst we login into SMS and then pick TFN from database. According to them we will get some message from mainframe and as per message it will update Port status and some other field in database. Through some process we get Error Code from mainframe and update Port Detail Status

in database.In third module, we will apply a query in database to get some TFN number. This TFN number would get pass in mainframe. This will fetch some screen code and as per the condition we update Port Status “CIC Status” in database.

Responsibilities

I was responsible for the initial development of this project right from scratch and also responsible for completing this project as per requirements. I get the requirements from The Tech Lead who is a Sprint (Client) Employee & I had the freedom to suggest improvements & implement them.

Project Included - Technology (4.0), Window Forms, DSN, Bluezone (CIS)

Handled all aspects of project including - designing, architecture, development, client interfacing & delivery of the project.

I have built the common classes for this project. These classes are used in all applications of this project.

Along with that I have built DSN based structure.

(DSN Structure is very much helpful for independent connection.)

Worked on two applications, gathered all requirements from client, managed & prepared requirement documents, tracking documents, estimation, code review and application design documents.

Solved issues mentioned in issue tracker.

Uploaded code in VSS timely.

Provided regular project updates to all stack holder timely.

Maintained quality communication with client.

Maintained MOM for all meetings.

Key projects handled so far Comcenter Applications.

Achievements : Received lots of verbal appreciations from Client and got accolade mails.

JobSiteClient Jobsite

Technology Microsoft C# ASP.NET (3.5), LINQ, SqlServer2008, Ajax, JQuery, Google Map, SSRS, W.C.F

Project DescriptionI was working for one of the major application called Jobsite. I was majorly involved in development of application. I have handled a team of 4 people & worked on most important and critical part of the jobsite. My role was as follows

Responsibilities

Gather the Functional Requirements Document and prepare Detailed Design Documents.

Prepare the effort estimates.

Develop the application.

Written Rest based WCF service.

Written script to display job location on google map.

Perform Unit Testing, Integration testing, Defect tracking and Defect closure.


Communicate activities/progress to project leads and managers.

Develop implementation plans and provide UAT support.

Social 27Client SnlCorporate

TechnologyMicrosoft C# ASP.NET(3.5), LINQ, SqlServer2008, Ajax, JQuery, Rest Based W.C.F., Facebook API, Amazon S3, Microsoft Application Blocks, Microsoft Report Viewer, SSRS, Twitter API, LinkedIn API

Project DescriptionSNL Corporate product is Virtual Conference. Social27 Virtual Show attendees can post their message on wall and twitter and also share photos and videos with others. Attendees can register himself by Social27 Virtual App, facebook and live id (hotmail). They can communicate with exhibitors, contact representatives, speakers and others by mailing or exchange vCard. They can learn from documents and video presentation and rate them and set self-mood by mood meter tool.

I was mainly involved in development of application and integrate the Social API with application (FaceBook API, Twitter API etc…).

Responsibilities

Handled team of 5 members for the development of this application

Estimation, Requirement gathering.

Architectural design of module.

Coding.

Code Review.

Unit Testing.

Used cloud based technology by using Amazon cloud.

Responsibility of application delivery on time.

Global Positioning SystemClient Fleet ManagementTechnology Microsoft C# Asp.Net (2.0), Sql server 2005, Google Map, GPS Device

Project DescriptionQbit Systems is a small scale company. We have developed Global Positioning system software. GPS in Motion provides custom development for tracking. We use GSM, SMS, GPRS, UDP and TCP/IP

technology for communicating to devices in the field and GPS, Cell ID, GSM triangulation for locating devices. This is a web based application, which is continuously, monitoring the vehicles on the road, using GPS device. GPS device and base station both uses SIM cards for the communication through the SMS. The GPS device gets the current latitude and longitude values after the specified time interval and send the message which capture by window service and save it in the database. According to those values our website plots the points on the google and virtual earth map. Written a code which sends a message to GPS device.

Responsibilities

Developed window service

Written program for GPS device.

Designed and Developed website in Asp.Net.

Written script for google map and virtual map to plot the Vehicle location.

Created design & development documents.

Designed database for system.

Rajasthan State Beverages Corporation Ltd. (RSBCL)Client Rajasthan Excise Department & Rajasthan State Beverages Corporation Ltd. (RSBCL)Technology Asp, VB Script, JavaScript, Oracle 9i

Project DescriptionE Connect developed Online Transaction Software. This software developed for Rajasthan Excise Department & Rajasthan State Beverages Corporation Ltd. (RSBCL). Software installed in every district of Rajasthan. Rajasthan Government departments handle their transaction by this software.My role was developer and responsibilities as below.

Responsibilities

Interface designing.

Create project documents.

Coding.

Unit Testing.

Report designing.

Person-In-Person-OutClient Techon Dater Pvt. Ltd.Technology VB6.0, MS-Access 2000

Project DescriptionTechon Dater was developing a fully automated software for maintain the company employee Timing named as “Person In Person Out”.

Responsibilities

Interface designing.

Coding.

Manual Testing.