Post Job Free

Resume

Sign in

Sql Server Developer .Net Design Data Management

Location:
Houston, TX, 77005
Posted:
July 20, 2010

Contact this candidate

Resume:

Abhay Singh

Senior Dotnet Developer / Technical Lead - .Net, Microsoft Technologies

Oil & gas, Telecom, Shipping, Storage

Skilled Technical Lead & Senior Dot Net Developer with over seven years of

experience in Information Technology and more than five years in

Estimation, Analysis, Design, Process documentation of Commercial Client-

Server, Internet / Intranet Windows & Web Applications, along with hands on

skills on Development, Maintenance, Testing of the IT systems.

Technical Skills

Languages C#, C++, C,Java,VB.Net

Databases Oracle 10, Microsoft SQL Server 2000/2005/2008

GUI XAML,VB, HTML, DHTML,MFC

Operating Systems Windows NT & 95 98 and XP/Vista/7, Server

2000/2003/2008,

Web Technologies VBScript, Jscript, XML, XSD, XSLT, ASP, ASP.NET 1.0 /1.1/

2.0, JavaScript, CSS, AJAX, JQuery

Technologies Client/Server Architecture, .NET Framework

3.4/4.0,OOAD, UML, SOA, Cloud Computing, Design patterns

Data Access ADO, ADO.NET 3.5/4.0,Entity Framework, nHibernate

IDE/Visual Tools Visual Studio (All versions/2010), Microsoft Expression

Studio

ETL Tools Microsoft SQL Server DTS 2000, SQL Server Integration Services

2005

Design Tools Enterprise Architect, Rational Rose 2003, Rational

XDE, Microsoft Visio 2003, Erwin Data Modeler

Reporting Tools Microsoft SQL Server Reporting Services 2000/2005,

Business Objects

Web servers Microsoft IIS 7, Apache

Testing Tools FxCop, NUnit, NUnitASP, Mercury Load Runner,

TestDriven.Net

Version tools Microsoft Visual Source Safe 6.0, Clearcase, SVN,

Team Foundation Server 2008

Third party Tools Syncfusion Win Forms, Infragistics Net Advantage,

DevExpress

Office System Microsoft Visual Studio Tools for Office, Microsoft

InfoPath 2003

Other Tools MSBuild, NAnt, Microsoft Installer, NDoc, CruiseControl,

log4net

Miscellaneous Test Director, TOAD, IBM Lotus Notes, VBA Macros,

PowerBuilder, Microsoft Project

Experience Summary

. Worked in .Net Frameworks 3.5/4.0 using Visual Studio 2008/2010.Well

versed in Microsoft technologies like C#, WinForms, ASP.Net, VB.Net, VB,

ASP, XML/XSLT & JavaScript, XAML, LINQ, Serialization, Reflection,

Remoting, Multithreading, Transactions, Garbage Collection,Threading,WPF,WFC,WF, Entity Framework.

. Expertise in Database design and server side programming in SQL Server

2005/2008, Oracle 9i/10g, MS-Access 97/2000/2003 using Stored Procedures

and Triggers along with Data Transformation Services (DTS).

. Implemented and deployed Development, Testing (QA), Staging, and

Production systems for a number of clients and created or enhanced best

practices for maintaining and upgrading production systems.

. Extensive experience in Design, Development and Implementation of windows

& web applications using WinForms, ASP.NET, C#, VB.NET, ASP, XML and

JavaScript/JQuery/RESTful service.

. Experience in interacting with client/user to gather the business

requirements.

. Comprehensive grasp on Microsoft Server Products like Microsoft Commerce

Server, Microsoft Exchange Server, Microsoft Content Management Server &

related technologies like Windows SharePoint Services, Microsoft

Enterprise Services, SQL Server Notification Services and Microsoft SQL

Server Analysis & Reporting Services, .Net Design Patterns

. Experience in building AJAX-enabled Web applications using Infragistics

NetAdvantage for ASP.NET, ClickOnce deployment for Smart Clients.

. Applied Microsoft Enterprise Library and Application Blocks to reduce

development effort e.g., Data Access, Caching, Authorization and Profile,

Exception Management and Logging application blocks.

. Ability to create a detailed project plan with defined tasks and

communicate ownership to client and team leads.

. Logging & Instrumentation Application Block, Enterprise Library for .NET

Framework 1.1 & 2.0

. Experienced in Object Oriented Analysis and Design.

. Exposure to Test-driven development, SCRUM methods in Agile methodologies

. Developed systems for the Oil&Gas, telecom, shipping and software

development industries.

. Excellent analytical, problem solving, interpersonal and communication

skills, self-motivated, hard working, team player ability to handle

multiple tasks, and a fast learner.

. Strong ability to quickly adapt to new technologies

. Proven ability to provide technical leadership to large global teams.

Education & INDUSTRY Certifications

. Bachelors of Technology in Information Technology (IIIT-Allahabad,

India).

. Microsoft Certified Professional Developer (MCPD) in Enterprise

applications.

. Microsoft Certified Technology Specialist -.NET Framework 2.0 Windows

Applications

. Microsoft Certified Technology Specialist -.NET Framework 2.0 Web

Applications

. Microsoft Certified Technology Specialist -.NET Framework 2.0 Distributed

Applications

. Effective Public Speaking ( Susanne M. Glasscock School of Continuing

Studies at Rice University )

. Exposure to quality process / frameworks like CMM Level 5, CMMI

. Pursuing .Net 4 Certification(s).

Soft skills Summary

. Excellent English (oral and written) communication skills for both

technical and non-technical audiences.

. Strong Consulting Skills for Business interfacing roles.

. Capable of successfully managing and leading a team & Ability to track

the progress of a project through the multiple life cycles phases with an

emphasis on quality processes and guidelines in all stages of the

activities.

. Excellent interpersonal skills with the ability to influence team

members, management & external groups.

. Team player and self-motivated individual, capable of producing high

quality work.

. Organized, autonomous and detail oriented with the ability to work within

a constantly changing environment.

Selected Experiences

Chevron,

Houston, TX

Independent

Consultant

Location:

Houston, TX

(Dec 2009 -

Till date)

1) eXPLORE

(Dec 2009 - Till date)

Exploration is the integrated workflow linking existing exploration review

processes such as Prospect, RiskOG, ERT Review and regional BU databases.

Beside significantly reduce IT support needs, eXPLORE allows for

consistent, standardized technical assessments of exploration prospects and

most importantly a unified prospect definition and associated metadata

while maintaining a flexible security schema to prevent unauthorized access

to sensitive exploration information. This integrated view enables the

explorations to see a prospect from conception through its stages of

maturity across multiple review processes.

Role: Application Analyst & Lead Developer

My responsibilities included:

. Worked with Business users for requirements

. Played a key role in the detailed analysis & creating technical

specifications for undocumented features

. Led the effort to upgrade application(s) to .NET 3.5

. Designed and developed various windows forms to retrieve, update and

analyze prospect, risk, and other exploration data.

. Designed and developed various ORACLE 10g packages, stored procedure,

views to retrieve, update and analyze prospect, risk, and other

exploration data.

. Supported & maintained few Nuclear Applications which were developed

in Access 2007, Excel 2007, .Net 1.0 / 1.1 / 2.0

Technologies:

Visual Studio 2008/2010, Oracle 10g, Team foundation Server, Office web

component, DataGrids, Linq, ClickOnce

2) eRESERVES

(Nov2007 - Dec 2009)

eReserves delivers work process and software improvements to streamline

assembly, verification, control, and reporting of Chevron's corporate

reserves portfolio. The system provides following salient features:

. Improve reserves/resource accounting and reporting work processes,

enhancing the ability to support future business changes

. Improve the work practices and efficiencies of technical staff

. Balance governance, compliance, efficiency and data management

requirements

. Improve the software's architecture, maintainability and

sustainability

. Enhance the adaptability for Security, IP and SOX Compliance.

Role: Sr. Developer

My responsibilities included:

. Developed WCF Web services to retrieve, update and analyze reserves

data.

. Developed ADO.NET routines to create Data layers for the application.

. Developed and customized Ad Hoc Reporting modules.

. Designed and developed methods to navigate/search/filter large

organizational Hierarchy.

. Created various Stored procedures, Functions, Triggers and views for

SQL Server 2005.

. Helped with ClickOnce Deployment.

. Fixing various defects on priority basis.

Technologies:

Visual Studio 2005, SQL Server 2005, Team foundation Server, DataGrids,

ADO.NET, ClickOnce, Design patterns, WFC, WinForm

Awards: Awarded "Execute with excellence" for significant and quality

contribution to eReserves

Verizo

n

wirele

ss,

Irving, TX

Independent

Consultant

Location:

Irving, TX

(Jan 2007 - Nov

2007)

Integrated communication Package

(Jan 2007 - Nov 2007)

Integrated Communications Package is a powerful multi-tier software

application that integrates telephony and data services to enable mobility,

improve response time and increase productivity.

The application supports web console and a desktop IM-like client to manage

VOIP based telephone remotely. The various features provided by application

include call management, instant email/sms alerts for calls/voice mails,

Address book, searching other user in enterprise and push to talk.

Role: Sr Developer

My responsibilities included:

. Participated in Joint Application Design (JAD)

. Mentored offshore members of team.

. Create Data Access layer for web/client APIs.

. Developed layers to interact with external system using Web services.

. Designed and developed XMLs/XSD to interact with other supporting

systems.

. Developed new routines in C# to extend workflow of application.

. Created low level design documents for new features.

. Created various stored procedures, Functions, Triggers and views for

SQL Server 2005.

. Fixing various bugs on priority basis and unit testing.

. Involved in refactoring existing code to .NET 2.0/3.0.

. Point of contact with other teams to integrate Data Access Layer

modules seamlessly.

. Involved in refactoring of application design and optimization.

Technologies:

Visual Studio 2005, SQL Server 2005, Team foundation Server,

DataGrids, ASP.NET,ADO.NET, ClickOnce,Design patterns, WFC, WinForm,

Remoting, Multithreading, WMI, XML Spy, ASP.NET web services.

Unisys

Globa

l

Servic

es,

Bangal

ore

India

Locati

on:

Bangal

ore,

India

(Oct 2005 - Jan 2007)

Configuration Monitor

(Oct 2005 - Jan 2007)

Configuration monitor is used to certify Unisys Enterprise servers to

ensure that server conform to a recommended configuration. The application

also provides functionality of creating a recommended configuration file in

XML format. It consists of a web based and a smart client front-end

deployed using ClickOnce technology.

Role: Team Lead

My responsibilities included:

. Gathered and evaluated requirements for the application and decided on

technology to use .

. Created the winform application conforming to Microsoft guidelines for

GUI design.

. Developed WMI /PInvoke layer to access system data.

. Developed a WebService in C# to certify partitions remotely.

. Developed ASP.NET pages to launch this ClickOnce Deployed application.

. Developed routines to create XML configuration file programmatically.

. Various methods using ADO.NET to save the data in Oracle.

. Used ClickOnce to Deploy the application.

. Used NUnit for unit testing.

. Used XPath and XQueries to extract data from XML files.

. Incorporated various .NET best practices/design patterns into this

framework implementation.

. Used Visual Source Safe for Source Control and version management.

.

Technologies:

.NET remoting, WMI,Microsoft Visual Studio .Net 2003, Microsoft Internet

Information Services 6.0, Microsoft Internet Information Services 5.5,

Microsoft SQL Server 2000, Microsoft SQL Server Reporting Services 2000,

Microsoft Visual Source Safe 6.0.

Awards: Awarded as "Team for speed" for contribution in the transition

DHL, Phoenix, AZ

Infosys Technologies Limited

(www.infosys.com)

Location: Phoenix, AZ

DHL Tracking System

(Nov 2004 - June 2005)

Scanner application supports mechanism to track a package shipped by DHL.

This application is Windows application developed in C# .It provides

functionality to read a list of packages shipped via DHL including the

order time/delivery time, origin and destination from the Motorola scanners

and upload it to Database server.

Role: Lead Technical Analyst

My responsibilities included:

. Involved in gathering the System Requirements and creating

specifications accordingly.

. Created various forms conforming to standard GUI guidelines to enter

and display data.

. Developed custom controls in C# - progress bar, buttons etc.

. Wrote the business logic in C# Assembly.

. Developed web front-end in ASP.NET

. Used SQL Server 2000 to retrieve data displayed in ASP.NET web pages.

. Involved in Interoperability with legacy COM components.

. Performed Unit, Integration and Regression testing to determine and

eliminate program bugs.

. Migrated few old MFC utilities to winforms.

Technologies used:

Microsoft .Net Framework 1.1, /C++/C#/MFC/COM/ASP.NET/SQL Server2000/Custom

Controls, VS.Net,Win2000,Motorola Scanners, Mercury Quality center,IBM

clear case

Wavecom(now

Sierra), France

Infosys Technologies

Limited(www.infosys.com)

Location: Bangalore,

India

Wavecom Debug Tools

(June 2004 - Nov 2004)

Wavecom develops, markets and sells a line of digital wireless standard

modules and sells mobile telephones and wireless modems.

The project involved development of various tools to help developers create

and debug applications targeted for wavecom chips. The tools included a COM

component that abstracted the serial port communication for MFC based

application, windows applications to read debug traces from the handset and

developing fronted and APIs for C interpreter (CINT) to run automated

tests.

Role: Lead Program Analyst

My responsibilities included:

. Wrote wrapper for routines to communicate with serial port as a COM

executable supporting connection points. Connection point in this

executable made communication with serial port very easy compared to

otherwise clumsy method of polling serial port in regular intervals.

. Developed Target Monitoring tool- a winform utility to read traces

from mobile. The application also supported reading RAM and objects

(contacts, diary etc) from Target.

. Used ActiveX controls to display data in graphical format.

. Reverse engineered and created design documents for few old MFC

applications to maintain them and ease future enhancements.

. Demonstrated the usage of these tools to wavecom Clients worldwide.

. Lead a team of 5 members to transfer the project to a new team of

entry level programmers.

Technologies used:

C++/MFC/COM/OOAD/ActiveX, Visual Studio 6.0, WinXP,Wavecom wireless

modules.

Motorola

Corporation Ltd,

Chicago

Infosys

Technologies Limited

(www.infosys.com)

Location:

Bangalore, India

Terayon CMTS

(March 2004 to June 2004)

Terayon's BW 350 is a CMTS device used to provide high speed data services,

such as cable internet or Voice over IP, to cable subscribers. The CMTS

runs Linux with customized TCP/IP stack.

Role: Business & Technical Analyst

My responsibilities included:

. Fixed bugs related to DHCP protocol.

. Developed additional commands for an intuitive command line interface.

Implementation involves directed a-cyclic graph of nodes which defines

CLI language. Any valid sentence in CLI language starts at the root

node and ends on a leaf with a valid ordered list of sub-phrases so

that each one is dealt by a function from one node to the next.

. Modified embedded database implementation to support concurrent update

by multiple processes. This database contains subscriber information

debugging information etc for Terayon CMTS.

. Modified Linux Kernel ARP stack to add extra information needed by ARP

manager in Terayon CMTS.

. Improved application performance by rewriting various routines.

. Developed efficient logging mechanism.

. Involved in knowledge transfer to new resources in the project.

. Created documents explaining design of complex modules.

Technologies used:

C/C++/Embedded Database/TCP-IP, Linux, Terayon CMTS hardware.

EMC Hopkinton, MA

Infosys Technologies

Limited

(www.infosys.com)

Location: Bangalore,

India

Avalon

(July 2003 - March 2004)

EMC is worldwide leader in policy based storage management solution. The

project Avalon aimed at creating a high performance DLL to support AVID (a

digital media company) products to store files of huge sizes in EMC

solutions from a windows desktop. The DLL had to use minimal APIs from

third party so that impact of changes in third party should not break the

data transfer mechanism the DLL provided.

Role: Program Analyst - Testing & Development

My responsibilities included:

. Developed a small footprint XML parser in C.

. Added data transfer functionality to a WIN32 multi-threaded DLL

ensuring proper synchronization routines using Mutex and events from

win32 SDK

. Created MFC front-end to test this DLL.

. Coordinated with testing teams for them to be able to better

understand the product and features thus ensuring quality.

. Involved in Writing Unit / Integration / System Test Cases.

Technologies used:

C/C++/XML/Win32 SDK/Multithreading, Visual studio 6.0/ Windows 2000

Reference(s)

Available upon request

[pic]

[pic]



Contact this candidate