Post Job Free

Resume

Sign in

Customer Service Sql Server

Location:
Hyderabad, AP, India
Posted:
August 19, 2014

Contact this candidate

Resume:

Rakesh Kumar Vangala

302-***-****

Application Development Lead

SOFTWARE/RDBMS DEVELOPMENT PROJECT MANAGEMENT ENTERPRISE WIDE

IMPLEMENTATIONS

. Experienced Technical Lead offering 13 years of success leading all

phases of Microsoft technology projects.

. Extensive experience in project management practices; Requirements

gathering and translating business needs into Functional and Technical

designs documents; Expertise in developing project plans, estimates,

ROI and resource planning.

. Business domain expertise in Sales, Manufacturing, Supply Chain,

Logistics, and Field Service software applications.

. Strong team experiencein working with cross functional teams, Onsite-

Offshore model and 3rd party software vendors.

. Quick learner and evaluator of the latest development tools and train

team; mentor development teams.

. Excellent communicator; leverage technical, business and financial

acumen to communicate effectively with executives and their respective

teams.

. Expert in agile and waterfall project management methodologies

Certifications:

> ACE - ACE Associate

> Microsoft Certified Professional- Designing and Dev. Applications

using SharePoint 2010.

> Microsoft Certified Professional-Building Web applications using

VB.Net

> Microsoft Certified Professional- Distributed Applications using

Visual Basic 6.0

> PMI - Presently undergoing training for PMP.

Education:

. Masters in Computer Science

. Training on ISO and CMMI @KEANE Inc.

Skills Summary:

Programming C#, VB .Net, ASP.Net, MVC,.Net Remoting, Web

Languages: services, RESTful services, VB 6.0, ActiveX

(COM/COM+/DCOM), Past experience in SAP ABAP

Databases: SQL Server 2008 & 2012,SSIS, SSRS, Oracle 10g

Operating Systems: Windows 2003, 2008, Windows Mobile 6.0

Web Technologies: HTML5, AJAX, XML, jQuery, Infragistics, Java Script

Servers: IIS, MTS, BizTalk server

Utilities: Visual Studio, Team Foundation Server, PVCS Version

Manager, Crystal Reports, Active Reports

Microsoft Tech SharePoint Server 2010, Designer, WCF

Professional Experience:

OTIS Elevator (Nov 2005 - Till Date): Successfully delivered cost effective

solutions on time within budget in compliance withACE Silver standards with

minimum/no supervision.

. Presently working in NSAAHQ fromApril '12asApplication DevelopmentLead

. Worked inBloomington, IN fromNov'05 to March '12 as a Sr. System

Analyst

Responsibilities:

. Project initiation, Requirements gathering and heavy customer

interaction.

. Prepare current and future state business process and propose various

technical solutions to address business needs; Participate in VSM

events

. Create Project plan, estimates, ROI, risk assessment & mitigation and

WBS.

. Set customer expectations and obtain sign off from customer at

required stages.

. Develop application architecture, design and interfaces with external

systems

. Execute application development thru SDLC including requirements,

architecture & design, coding, testing and implementation.

. Perform design & code reviews and created application documentation.

. Hands-on with C#, ASP.Net, MVC, Razor,Ajax, jQuery,RESTful

services,Winforms, Infragistics and Active reports etc.

. Hands-on with SQL Server and Oracle database design &development

including procedures, functions, triggers, SSIS and SSRS.

. Coordinate with multiple groups including operations and CSC during

life cycle.

. Presentproject updates to customers and senior management; escalate

risks in timely manner.

. Keep team motivated, and mentor and train development team

. Successfully transitioned applications to offshore teams.

. Conduct steering committee meetings and track projects using Project

management tools and techniques.

. Lead the application migrations during server upgrades and OS refresh.

Major Projects:

Mainframe CPU cost savings:

. Managed project from initiation to implementation with cross

functional teams.

. Prepared technical architecture and design and data mapping;

. Implemented ETL using SSIS.Data extract from various sourcesMainframe,

JDE& SQL Server.

. Coordinated with offshore and operational teams.

Contract Tracking Tool:

. Managedproject from initiation to implementation.

. Interviewed multiple department heads including sales, engineering,

supply mgmt., manufacturing and finance;Completedrequirement analysis.

. Developed technical architecture and database design.

. Created project plan, WBS and estimates

. Managed other developer - Train, assign tasks, review design and code.

. Integrated with various systems used by other departments.

. Implemented SSIS to integrate with flat files, SQL Server, Oracle dBs

and ftp folders.

. Implemented SSRS to develop Score card reports used across the

organization

. Developed UI using ASP.Net, C#, jQuery.

Contract Inspection Application:

. Evaluated various vendor Windows8 Tablets for Factory environment.

. Evaluated different technical solutions with Microsoft and Gartner

teams.

. Completed prototype and obtained sign off from business.

. Completed architecture and application design.

Deviations web application:

. Manage Project from initiation to implementation with no supervision.

. Successfully completed development, implementation and user training.

. Developed application using ASP.Net, C#, jQuery.

. Developed Reports using SSRS.

Material Receiving Application (Factory):

. Evaluated different vendor systems and Estimates

. Train Vendor on UTC IT security policies for DMZ environment.

. Reviewed and finalized technical solution and architecture with

selected vendor

. Prepared Functional Specifications

Manufacturing Tracking System(MTS):

. Developed Interface between.Net and JDE ERP system.

. Development, Testing, Deployment and Documentation.

. Facilitate requirements collection; coordinate simulation testing, UAT

testing with Business and Hardware Implementation with CSC.

. Developed application using ASP.Net, MVC, C#, jQuery, Sql Server

Supplier communication Portal (SCP):

. Implemented first internet web application(DMZ environment)in Otis

NAAby ensuring compliance with UTC IT Security policies, UTC's

external web architecture standards and processes and SOX

requirements.

. Developed application using ASP.Net, C#, jQuery, Oracle

Project: Warehouse Management System (Pocket WMS):

. Implemented first mobile solution Pocket WMS using Windows Mobile

technology.

. Developed interfaces with CHESS ERP System for SCP and Pocket WMS

projects.

. Developed application using Windows mobile, C#, SQL CE

Other Projects:

Provide enhancements and support for multiple projects simultaneously

including EAGLEapplication for Sales Reps, Customer Service for AMTs and

Online Tool Facility site for Field, PO Price, and ASNetc.

Technologies:ASP.Net,MVC, Web Services, .Net Remoting, C#, AJAX, XML,

jQuery, Infragistics, Oracle dB, SQL Server, SSIS, SSRS, LDAP

authentication, SSL certificates, Windows Mobile, SQL Mobile.

KEANE Inc. (Oct'03- Nov'05):As a Technical Lead - Managed a 5 person team

and coordinated their daily tasks/ Resource utilization with the offshore

team and work closely with Project manager.

. Lead the Mainframe, Progress 4GL and MS technologies teams for Claims

Supporting System's major enhancement.

. Enhanced major application "Point of Sale" web site that interfaces

with Mainframe using MQ-Series middleware. Technologies used ASP 3.0,

VB6.0, SQL Server, DB2 database.

. Developed Web services for Survey system for Insurance Claims using

C#, asp.net and SQL Server.

. Participated in requirements analysis with Business Analysts.

. Prepared and reviewed functional specs, Tech specs and detailed design

documents, High-level Test Plan and Test Cases.

. Prepared management reports on a daily and weekly basis.

. Coordinated the business for User Acceptance Testing.

. Provided help and motivated team to meet the target dates.

Opusasia Pvt.Ltd, (Apr01-Oct03): Sr.Software Engineer

Infoneeds India Ltd. (May99-Mar01):Software Developer



Contact this candidate