Sql Server Project

Professional Summary:

A Microsoft certified professional with 13+ years of experience in analysis, design and development of client/server, web based and n- tier application.

Extensive experience in developing applications using .NET Framework 2.0/3.0/3.5/4.0 developing experience in C#, ASP.NET,ADO.NET, MVC, IIS, Java Script, JQuery, WCF and SQL server.

Worked on Multi-tier Software System Architectures - Analyzing, Designing, Developing, Maintaining, Testing and Supporting (Production, Development and Testing environments) of Software Applications/Systems.

Customer (external) support, monitoring and administration of production software system/applications.

Trouble shooting and resolving issues of software system/applications in production/testing environment

Extensive experience in SQL Server Database design, Database maintenance, developing T-SQL queries, stored procedures, triggers using SQL Server 2008 and MSBI.

Maintain database backup and ongoing maintenance, Databases Designing, Writing Triggers, Stored Procedure, Views and Indexes.

Maintain Database Jobs, Alerts, and Maintenance Plans

Experience in BI Development and Deployment of SSIS packages

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experience in generating reports using SQL Server Reporting Services, Crystal Reports.

Functional domain experience involves Health care, Automotive and Logistics.

Effective in managing teams and working independently, collaboratively in teams.

Fantabulous team player and Eager to learn new thing. Highly self-motivated and a fast learner

Experience in Windows batch scripting

Experience in handling Intermec driver devices with SOTI Manager Tool.

Experience in Tibco business studio, contivo analyst and Jenkins tools.

Certified Scrum master in scrum alliance.

Experience in Tibco spotfire administration and reporting.

Experience in Python scripting and UIPath automation tools.

Experience Details

Technical Skills:

Programming Languages

C#.Net, VB.Net, VB 6.0, ASP

Web Technologies

ASP.NET MVC, HTML, AJAX, Web-Services/WCF

Scripting Language

XML, CSS, Java Script, AngularJS, JQuery

Technology

.Net Framework 1.1/2.0/3.0/3.5/4.0

Database

SQL Server-2005/2008, LINQ, MS-Access, MySQL, PostgreSQL

Primary Domain

Health care, Logistics, Automative, Manufacturing and Telecom

Development Tools

Microsoft Visual Studio .NET 2005/2008/2010/2013/2015

Tools

TIBCO, Contivo, Jenkins, Microsoft-Office, Microsoft Visio, Nunit

Versioning Tool

Visual Source Safe(VSS), Team Foundation Server, SVN

Trained skills

Predix, AWS

Certifications:

.Net Framework 2.0

ASP.NET 2.0

(70-315) Developing and Implementing Web Applications with Microsoft Visual C# .NET (MCP ID: SR2255078)

Brainbench Certified Professional : Transcript ID: 5793437

Certified Scrum Master in Scrum Alliance

Education:

Degree

Specialization

University

Year of passing

Post Graduation

MCA Computers

Bharathidasan University

2004

Graduation

B.SC Mathematics

Bharathidasan University

2001

Work Experience

Project Profile # 1:

Client: General Electronics Dec 2015 – Till Date

Location: Atlanta, GA

Project: Steam Remote Monitoring & Diagonistics and its analytics

Role: Tech Lead & Scrum Master

ProjectDescription:

Steam RM&D Performance Metrics is a web based application built on ASP.NET MVC 4 for Monitoring and Diagnostics of vast number of turbines all over the globe. The purpose of this program is to provide below features to the steam turbine unit GE Internal and External customers. Process operational data / fleet wide data to enable decisions for optimizing the value of machinery assets. Allow GE engineers to track the condition of the machinery and forecast maintenance requirements on a schedule consistent with operating requirements and business needs. Facilitate recommendations for optimization of machine availability and efficiency, and helps detect problems in an incipient stage Data received from the sensors placed at each turbine is loaded, validated and then corresponding plots are generated using TIBCO Spotfire. These plots/charts are very much useful for the engineers or the customers for tracking the health of the turbines; analyze the root cause for the turbine failures.

Responsibilities:

Perform requirement analysis or review requirements, gap / impact analysis, high-level / low level design, development and test support based on customer requirements.

Served as Scrum Master for a Software Development team, guiding the team to high performance

Facilitated Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meetings

Removed team impediments on a daily basis to allow the team to deliver the sprint goals and deliverables.

Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks that increased customer satisfaction.

Worked on Python analytics development and Integrated Python & C# together.

Knowledge sharing to the team and providing technical solution for peers based on the experience.

Worked on TIBCO spotfire administration and report creation.

Environment: Visual Studio 2010/2013, MVC, WCF, C#.NET, SQL server 2008, MSBI, Tibco Spotfire, PyCharm for Python, Rally, Jenkins, SVN and Quality center

Application Servers: Internet Information Server 6.0,7.0

Project Profile # 2:

Client: AT & T Jan 2015 – Dec 2015

Location: Plano, TX

Project: CSI

Role: Tech Lead

ProjectDescription:

CSI is AT&T’s enterprise middleware platform supporting AT&T U- verse, Mobility, Wireline, and other products and services, and is for use by internal and external AT&T clients including company- owned retail stores, Business-to-Business (B2B) partners, and other internal ordering, provisioning, billing, and care applications.

Responsibilities:

Perform requirement analysis or review requirements, gap / impact analysis, high-level / low level design, development and test support based on customer requirements.

Service creation and deployment.

Maintained enterprise applications leverage database schemes to created flexible architecture.

Development is done iterations based on Agile SCRUM process.

Team handling and co-ordination.

Knowledge sharing to the team and providing technical solution for peers based on the experience.

QC and UAT support.

Worked on TIBCO, Contivo 5.6, Jenkins, Junit

Environment: Java, XML, XSD, Eclipse, XMLSpy, Datastax Devcenter, TIBCO, Contivo 5.6, Jenkins, Junit, Maven central, SVN and Quality center

Project Profile # 3

Client: Visy Industries Jan 2014 - Dec 2014

Location: Melbourne, Australia

Role: Tech Lead

ProjectDescription:

Involving Development, enhancements and Production / support for the below Visy Microsoft Applications, Navigator, Logistics, eVisy and other applications

Developed a project called Fleetmax Tool as an individual and its details are below,

The main purpose of this Fleetmax tool is to track the Melbourne fleet of vehicles from each site. For that installed the Nomad software on all Intermec driver’s devices using SOTI Manager Tool.

Responsibilities:

Onsite co-ordination, customer handling and handled third party vendors support

Handled and helped to all priority tasks

Knowledge sharing to the team and providing technical solution for peers based on the experience.

Perform requirement analysis or review requirements, gap / impact analysis, high-level / low level design, development and test support based on customer requirements.

Team handling and technical guidance to team

Assist offshore in obtaining the clarifications / inputs required for clear understanding of the requirements or for resolving issues

Code deployment

UAT support

Environment: Java Script, VB Script, JQuery, ASP.NET4.0, MVC, C#.NET, Sybase and SQL server 2008, VSS

Application Servers: Internet Information Server 6.0, FileZilla, .NET Reflector, SOTI Manager

Project Profile # 4

Client: Visy Industries Aug 2013 - Dec 2013

Location: India

Project: TIM Portal

Role: Tech Lead

ProjectDescription:

TIM portal has been developed to enable and ensure that Visy NEWWORK users have an effective way of not only creating tooling orders but also track the outstanding jobs with vendors while being able to effectively manage their jobs which may mean re-prioritizing due dates to meet customer deadlines, cancelling orders and viewing order status etc.

Having the Tooling ordering and tracking process centralized will make the overall visibility of the orders for NEWWORK more manageable while enabling New work user to choose the vendor and create different work lists unlike the current process where vendor is determined by the selected cost center of the VIPA..

Responsibilities:

Perform requirement analysis or review requirements, gap / impact analysis, high-level / low level design, development and test support based on customer requirements.

Developed Presentation layer using MVC 4.0 & JQUERY and Business layer using C#. Net.

Responsible for creating complex Stored Procedures, Triggers, TSQL, views and packages in SQL Server 2008.

BI development activities - Extracted data from various sources like SQL Server, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Intensively used Cascading Style Sheets (CSS) and XHTML to design look and feel of the web pages.

Windows batch script handling

Created a Data Layer object in C# language which gives the common classes of methods to execute stored procedures into a Data Set, Data Table and Data Reader.

Team handling and technical guidance to team

Code deployment and UAT support.

Performed Unit testing according to the test cases for the modules, and Involved in developing test cases using NUNIT

Windows batch script handling

Environment: Java Script, VB Script, JQuery, .NET Framework 4.0, Visual Studio 2010 C#.NET, MVC, Sybase, VSS, Windows services, WCF and SQL server 2008,

Application Servers: Internet Information Server 6.0, FileZilla, .NET Reflector.

Project Profile #5

Client: Nissan North America Sep 2008 - July 2013

Location: India

Project: Nissan North America Support

Role: Sr. System Analyst

ProjectDescription:

Involved Development, enhancements and Production / support for the below Nissan Microsoft Applications, Certified Pre-owned System(CPO), Parts Re-Ordering, Warranty Reconciliation, NCF Workflow and Imaging System (FYI), Enrolment Management System, XM Radio

Developed on the below projects as an individual, 1.eNVIS report 2.Dealer Master Request stand alone web application 3. Vehicle Invoice report 4.Parts Invoice report

Responsibilities:

Provided the highest level of engineering support, quickly resolving “down system” issues and minimizing costly downtime.

Created new bug entry, identified bugs, and created effective fixes. Provide suggestions or solutions by interfacing with development teams. Proactively troubleshot systems.

Provided design consultation and migration planning services.

Prepare estimates for new Enhancements in Microsoft technology.

Mentoring new team member with existing applications. Managed multiple and concurrent projects to make sure about the completion of work within the defined scope, budget and time.

Analyzed all the documents that are required for the progress of releases such as Functional Requirement Specifications, System Requirement Specifications, and change request.

Make sure that all the project deliverables are in line with production.

BI development activities - Extracted data from various sources like SQL Server, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Windows batch script handling

Provided Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Generated reports using SQL Server Reporting Services.

Environment: Java Script, VB Script, XML, XSLT, ASP.NET2.0, C#.NET and BI, SQL Server 2005, HostBridge, Fedration ServerApplication Servers:Internet Information Server 5.0,6.0.

Project Profile # 5

Client: Nissan Canada Inc. Nov 2007 - Sep 2008

Location: India

Project: C&I Sales Planning Tool

Role: Team Member.

ProjectDescription:

The C&I Sales Planning Tool, is a Web based application, which transfers the management and analysis of sales forecasting functionality from Microsoft Excel models to the system. User can create analysis and forecast the Market data for fleet, carflow or roll-up based on various combinations of variables. Version control is maintained for each analysis. Comparison of one version with another one based on parameters. The Application also implements the maintenance and reports interface.

Responsibilities:

Page Design and Coding

Implemented Infragistics Netadvantage Web controls

Preparation of Unit Test cases, Operational document, user manuals.

BI development activities - Extracted data from various sources like SQL Server, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Windows batch script handling

Testing - unit testing, integration testing and system Testing

Environment: C#, ASP.NET 2.0, XML, XSLT, web services, Visual Studio .NET 2005, SQL Server 2005, Infragistics NetAdvantage for .Net 2007, VSS and Quality center

Project Profile # 6

Client: Cardinal Inc. Dec 2006 - June 2007

Location: India

Project: Greystoke 2.0

Role: Team Member.

ProjectDescription:

The project will be responsible for maintaining a subset of Journals and Journal lines from the superset located in the General Ledger. The reason for maintaining a subset is to allow Lease Accounting the ability to reverse any journal entries in the general ledger and provide a workflow mechanism for approving reversal, BNL, and cost journal entries before pushing them to the General Ledger. The user community consists of both the Lease Accounting and Cost Accounting departments. Lease Accounting is responsible for creating, manipulating new and existing journals.

Responsibilities:

Design the application using AJAX

Enhancement and maintenance work on .NET technologies with sql server 2000 as the back end.

Analysis, coding and unit testing

Extensive use of Java Script for validations.

Involved in preparation of documents like unit test case, enhancement report, release readiness review etc.

Environment: ASP.NET with C#, web services, .NET 2.x, SQL Server 2000 and VSS.

Project Profile # 7

Client: Cardinal Inc. June 2006 - Nov 2006

Location: India

Project: Demo scheduler 2.0

Role: Team Member.

ProjectDescription:

This web-based application aims to implementing demo ordering process for Cardinal Product. This System divides the user into two groups such as Requestors and Administrators. Each requestor will be assigned to a particular pool and each pool will have some limited range of product which will be available for the Demo for that particular pool. Requestor will be only allowed to create new requests and view their previous requests. Administrative User can be divided into two groups again, they are, Super Admin and Pool Admin.

Responsibilities:

Enhancement and maintenance work on .NET technologies with sql server 2000 as the back end.

Created generic secure and reusable data access components using the ADO objects such as Dataset, Data Adapter, and Data Reader.

Analysis, coding and unit testing

Involved in preparation of documents like unit test case, enhancement report, release readiness review etc.

Involved in preparation of System and Integrated test cases.

Environment: ASP.NET with C#, .NET 2.x, SQL Server 2000 and VSS.

Project Profile # 8

Client: Sulekha.com April 2005 - Feb 2006

Location: India

Project: SulekhaB2B1.0

Role: Team Member.

ProjectDescription:

The potential strength of this project is to make an environment to communicate business peoples according to their business needs and to create a path between the customers to business and business to business. It s a classic environment one can able to place his products offer (buy/Sell/Business) and create categories and catalogs. It will be always available on the site until their offer period. Once the offer period expires it will be renewed at anytime based on the needs of the company.

Responsibilities:

Design the application using AJAX

Used XML and XSL Transformations to display content on the website.

Development work on .NET technologies with sql server 2000 as the back end

Provided extensive documentation for all the modules/products worked on

Used VSS for the purpose of version Control and source code sharing

Analysis, coding and unit testing

Involved in preparation of System and Integrated test cases.

Environment: ASP.NET with C#, .NET 1.x, SQL Server 2000.

Project Profile # 9

Client: I Millennium Pvt Ltd. Feb 2004 - Mar 2005

Location: India

Project: Textile Village 1.0

Role: Team Member.

ProjectDescription:

Textile Village is buyer-oriented package for the textile industries. Basically it is a commercial site in which the Buyer and Suppliers are able to meet at anytime and anywhere. It involves whole transaction between buyer and suppliers from Tendering to receiving the goods. Order Process and Mail System are the major focus of this system. Buyers can able to know his order status at ease. Service Provider providing assistance to buyer and suppliers. In order to survive the Triangular communication is handled in the Mail system for securable correspondence between them.

Responsibilities:

Development work on .NET technologies with sql server 2000 as the back end

Created generic secure and reusable data access components using the ADO objects such as Dataset, Data Adapter, and Data Reader.

Analysis, coding and unit testing

Involved in preparation of System and Integrated test cases.

Used VSS for the purpose of version Control and source code sharing

Used XML and XSL Transformations to display content on the website.

Environment: ASP.NET with C#, .NET 2.x, SQL Server 2000.

Contact this candidate