Customer Service Sql Server
Resume:
Rakesh Kumar Vangala
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