Post Job Free

Resume

Sign in

Sql Server Software Engineer

Location:
Sapulpa, OK
Posted:
May 31, 2014

Contact this candidate

Resume:

LALIT LAKUM

.NET Developer (C#, WCF, WPF), Portland, OR

Mobile: 315-***-****, Home: 503-***-****

Email: acedrs@r.postjobfree.com

CAREER SUMMARY

. Over 8 years of experience in software design and development

with proficiency in SOA based applications, web applications and

client-server applications ensuring robust design and high

standard of code.

. Experienced in the domain of Medical Software, marketing,

inventory and warehouse solutions. Experience in analyzing

business problems and developing simplified solutions and

processes for them.

. Extensive experience on Microsoft platform, using the technology

like C#.NET, VB.NET, WCF, WPF, MSTest ASP.NET, Web Services, MS

SQL Server, Visual Studio and Team Foundation Server.

. Broad aspects of WPF application development and test automation

including application architecture, user interface

conceptualization and implementation, performance analysis and

optimization, and test automation (functional, stress,

performance)

. Experience working on overall deployment and release aspects

which includes setting up the baseline schedules, source control

branching, Build Automation and installation development.

. Well versed with Agile and waterfall software development life

cycles.

. Have strong analytical and debugging skills with problem solving

attitude and self-learning desire.

. Proven troubleshooting ability while working in a large and

complex application under the stress of time constraints in

mission critical situations.

. Performed efficiently independently, as Team Member and as Team

Lead.

. Excellent technical background, written and oral communication

skills.

TECHNICAL SKILLS

Languages C#.NET, VB.NET, ASP.NET, AJAX, HTML, JavaScript, LINQ, JQuery

Framework .NET 4.5, .NET 4.0/3.5/3.0/2.0/1.1, MEF, Entity Framework, MS

Application blocks

DBMS SQL Server 2008, SQL Server 2005

Platform/OS Windows 7, Windows XP, Windows Server 2008/2003

Technologies WPF, WCF, Web services, MSTEST, NUNIT, MOQ, Silverlight

Tools Visual Studio 2012/2010, TFS 2012/2010, SVN, MS Project, MS Visio,

Corepoint Integration Engine, InstallShield, WIX (Windows Installer

XML)

Build Tools MS Build, TFS

Design MVVM, MEF, MVC, MVP

Patterns

Standards XML, HL7, UML

EDUCATION & CERTIFICATIONS

. Bachelor of Computer Engineering (B.E) from Nirma Institute of

Technology, Gujarat University (2001-2005)

. MCTS in WCF (70-513 WCF Development with Microsoft .NET

Framework 4), Certificate ID: 9370041

. Microsoft Specialist in HTML5 (70-480 Programming in HTML5 with

JavaScript and CSS3), Certificate ID: 9370041

WORK EXPERIENCE

Technical Lead at IGATE, Portland, OR

Mar 2012 - till date

Project: Connex Centralized Clinical Surveillance Systems,

Client: Welch Allyn Inc. USA

Environment & Tools: C#.NET (.NET 4.5 Framework), WPF (MVVM), WCF,

Welch Allyn Core Framework, MS Test, UI Automation Framework,

Coded UI, MOQ, Windows Services, Corepoint Integration Engine,

Visual Studio 2012, TFS 2012, SQL Server 2008, Wise Installer,

Windows Installer XML, WinPE, IMAGEX

Connex Clinical Surveillance is a patient monitoring system that

allows clinicians to proactively monitor health of several

patients' comprehensive respiratory (etCO2, SpO2, RRa, EarlySense

Motion) and vital signs status (NIBP, Temp) simultaneously,

helping clinicians to quickly recognize respiratory distress and

respond earlier to signs of patient deterioration. The patient

health data is measured from continuous monitoring devices or

episodic measurements taken from devices connected to the patient.

Connex Central Station is a WPF based windows application that

interfaces with Welch Allyn devices and tracks near-real-time

device readings and directs staff to respond to abnormal

situations. The continuous and sport patient records can be sent

to the hospital EMR, to provide easy access to timely, accurate

data. Alarms can be annunciated at the bedside on device, the

Central Station, and/or be sent to the clinician's phone or pager,

as hospital workflow dictates.

Responsibilities & Accomplishments:

. Continuously worked on the Connex Central Station product line

from the first release, currently working on CS 1.7, previously

worked on CS 1.6, 1.5, 1.2. Effectively planned the daily tasks

and assignments schedule to adhere to the timeline minimizing

the possibility of rework.

. Designing and developing various system components in "Welch

Allyn Software Solutions Platform" using C#, WCF and WPF (MVVM)

utilizing best programming techniques including design patterns,

re-usable and modular development.

. Developing comprehensive unit tests and UI automation tests

using framework and coded UI for the components/features

developed.

. Worked on interfacing the Welch Allyn's CVSM and Spot LXi

medical devices, through proprietary data format, handling the

measurements, events and alarm conditions data for the Central

Station application.

. Work on the new features/CRs planned for every release, always

owned the software module Connex Admin Tools throughout all

releases which is subsystem of Connex CS that allows all

administrative configurations for the system.

. Designed the intuitive UI interface in WPF for Admin Tools and

Patient Monitoring tiles.

. Involved in major features development like Custom Score, Device

Details, Flowsheet and Graphical Trends review modules.

. Worked on the integration of the components like Data Sync,

Licensing, File/Date Lifetime Manager, Process Monitor, ADT task

scheduler, Trend Data Exporter in standalone and client-server

solution.

. For each new release planned, involved in discussion with the

cross functional teams to define the requirements, proposing and

prototyping the engineering solutions for the marketing

requirements.

. Assisting in Agile software development management activities

such as backlog grooming, sprint planning and review.

. Participated in Change Control Board meetings; provided thorough

impact analysis (technical and use-case impact) and alternate

solutions with estimates for the work-items I work on.

. Continuously during the project, I have identified the best

practices, prepared check-lists, templates, review protocols to

help improving the overall process.

. Prepared UML diagrams, design documents, and technical

Specifications for the subsystems as per the standard operating

procedures defined at Welch Allyn meeting the USFDA's medical

device regulations.

. Maintained the OS Image development (customized for production

use) using WinPE and IMAGEX.

. Lead the installation development of Connex Server, Connex CS

and HL7 using WIX (Windows Installer XML). Always supported the

cross functional teams with the installation aspects and issues.

. Lead all the deployment aspects of the system, created the build

automation workflows in TFS 2010 (later migrated to TFS 2012),

and customized the build definitions that also include

versioning and obfuscating binaries.

. Worked as TFS Administrator for a developer team. Also helped

other project teams to define the nightly builds.

. Solely responsible for creating and releasing the weekly

engineering builds, created a custom build utility using TFS API

to trigger the builds by analyzing the components changed and

dependencies.

. Coordinated with test team to release the engineering and

baseline builds, created a smoke tests and automated execution

of these tests against each build with summary report ensuring

the good quality of the build delivered to test.

. Maintained the branching and builds for multiple releases.

. Proactively explored the various virtualization options from

VMware and discussed the proposals with management to automate

the deployment and UI automation test execution on daily basis.

. Initiated and performed code reviews, test protocol reviews, SDS

and document reviews throughout the development.

. Troubleshooting and providing support to Welch Allyn field

engineers and service engineers. Followed up with other teams to

convey the issues to get them fixed.

Senior Software Engineer at IGATE, Gandhinagar, India

Feb 2011 - Feb 2012

Project: Enterprise Gateway Subsystem (EGS) for Connex CS,

Client: Welch Allyn Inc. USA

Environment & Tools: C#.NET (.NET 4.0 Framework), WCF and Windows

Workflow (WF), Welch Allyn Core Framework, NUnit, MS Test, Windows

Services, Corepoint Integration Engine, Visual Studio 2012, TFS

2012, SQL Server 2008

The Enterprise Gateway is the server side subsystem of the Welch

Allyn Software Solutions Platform architecture that manages the

communication between the workstation and external systems (EMR

and Notification Systems) used by the customer. Standards that the

Enterprise Gateway commonly uses are HL7 and XML.

Enterprise gateway provides a high-level API to the workstation

services to translate high-level entity objects to and from the

protocols required for interaction with the external enterprise

systems and to send and receive data on the channels appropriate

for each enterprise system.

It integrates the functions like ADT, ORU and clinical Alarms with

the external systems.

Responsibilities & Accomplishments:

. Analyze requirements; prepare UML diagrams, design documents,

and technical Specifications as per the standard operating

procedures defined at Welch Allyn meeting the USFDA regulations.

. Lead the design and development of HL7 ADT/Vitals data

processing for inbound/outbound using C#.NET. Also designed the

interfaces which meet the vendor specifications for Alarm

interfacing.

. Developed HL7 processing business logic in action list of

Corepoint. Designed all the Corepoint components required for

interfacing providing continuous support to field engineers.

. Completed the Corepoint Action List Redesigning activities

starting from brainstorming, designing, developing, documenting

to training session with customer and V&V team.

. Always provided long-term solutions to the issues/requests

considering the future scope. Provided thorough impact analysis

on the issues to be fixed in future release.

. Proactively prepared documents for the purpose of help or

preventive measures.

. Regularly worked with client and onsite coordinators; worked

closely with QA team to ensure the Quality of the Delivery.

. Performed Code Reviews and Code Optimizations ensuring the use

of standard Coding Guidelines and Best Practices; provided

functional & technical guidance to junior team members to help

them in performing better.

. Developed extensive Unit/Integration tests targeting the maximum

code coverage; prepared unit verification strategy.

Analyst Programmer at Gateway Technolabs, Ahmedabad, India

Jan 2009 - Jan 2011

Project: Email Marketing System (EMS), Client: Thindata, CANADA

Environment & Tools: ASP.NET 2.0 (C#.NET, JavaScript, JQuery), MS

SQL Server 2008, Web Services, Window Services

Email Marketing System (EMS) allows users to plan, execute,

analyze and hone their email marketing campaigns. It is a

sophisticated, robust and highly secure permission-based email

deployment and reporting system capable of managing large volume

campaigns. EMS clients have the ability to:

o Conduct advanced audience segmentation

o Easily leverage dynamic content

o Drill down into exportable and real-time reports

o Integrate with web analytics programs

o Access a robust Application Program Interface (API)

o Deploy emails to recipients around the world

Responsibilities & Accomplishments:

. Studied the existing system developed in ASP and involved in the

design of the Architecture to leverage the benefits of the OOP,

design patterns and .NET 2.0 framework.

. Designed and developed UI, Business and Data Access Logic using

ASP.NET, ADO.NET, and JavaScript and C # in the .NET 2.0

framework.

. Designed RDBMS and develop T-SQL, Functions, Stored Procedures

and Triggers using SQL Server.

. Worked with clients for understanding and framing the

requirements and prepare Technical Specifications.

. Worked closely with QA team to ensure the Quality of the

Delivery.

. Performed code reviews and code optimizations for performance

ensuring the use of standard coding guidelines and best

practices.

. Lead a team of trainee developers to deliver a software product

demonstrating the use of latest technologies (LINQ, WPF, WCF,

Silverlight and JQuery).

. Involved in development of various Bulk Processes which are

scheduled applications to perform a specific task like

UploadRecords, DownloadRecords, ExportReport, SendMail,

DeliveryAgent etc.

. Involved in development of following major functionalities.

o Online Database System allows users to manage personalised

information for Braodcasting. It allows customised

database design hence allows Add/Search Records in a

dynamic way. It also provides wide range of other database

activities including Upload Records.

o Onlne Forms allows users to create forms that users can

use in a website or an email that users can submit and

information will be added to ODS.

o Broadcasting is where users can manage their email

braodcasts and campaigns. Users can assemble the content,

select recipients and choose from a variety of braodcast

options including broadcast splits and broadcast testing.

. Configuration and subsequent deployment of the system (web

applications, resources, API and offline processes) to different

environments (DEV, QA, UAT, Stable and Production).

Senior Software Engineer at Gateway Technolabs, Ahmedabad, India

Mar 2008 - Dec 2008

Project: Fantasy Gaming Room

Environment & Tools: ASP.NET 2.0 (C#.NET and JavaScript), MS SQL

Server 2005, Web Services, Window Services

Fantasy Gaming Room is a website which allows the users to bet

their real money on any sport event from NBA, MLB, NFL, and NHL.

Participants act as owners to build a team that competes against

other fantasy owners based on the statistics generated by the real

individual players or teams of a professional sport. Statistical

performance is converted into points that is compiled and totaled

according to a roster selected by a manager that makes up a

fantasy team.

Responsibilities & Accomplishments:

. Designed and developed UI, Business and Data Access Logic using

ASP.NET, ADO.NET, JavaScript and C # in the .NET 2.0 framework.

. Involved in Requirement Study, Analysis, and Database &

Architecture Design.

. Involved in development of following major functionalities.

o League Management allows user to either creates a League

and invites the players or user can join any other league.

o Drafting is a process where all the joinees of any league

can choose their players to form a team. This manages the

turn of the paricipants and provides them with realtime

information about available players, choosen players,

drafted teams and a wishlist for each individual

participant.

o Import Tool is a window service which downloads the Real

Statistics which are available as XML data and import it

to SQL database of our system.

o Score Calculater is a service which calculates the score

based on the imported data against the points defined for

a league and decides a rank for each participant.

. Solely responsible for configuration and subsequent deployment

of the system to UAT.

. Participated in Code Review, Code Optimization, Bug fixing &

Documentation.

Senior Programmer at iCubix Infotech Ltd., Ahmedabad, India

Aug 2007 - Mar 2008

Project: Claris Intranet Applications

Environment & Tools: ASP.NET 2.0 (VB.NET and JavaScript), MS SQL

Server 2005, Web Services

Responsibilities & Accomplishments:

. Designed and developed Informational Web Portals and Intranet

Applications using ASP.NET and VB.NET individually.

. Involved in maintenance (customer support / bug fixing /

enhancements) for existing ERP modules in use.

Software Engineer at Ahem Management Solutions, Ahmedabad, India

Aug 2005 - Aug 2007

Project: PharmaSuite Matrix

Environment & Tools: VB.NET, Win Forms, MS SQL Server 2005,

Crystal Reports

This is an ERP System developed specifically for pharmaceutical

manufacturing companies where all the major processes and modules

are organized in an integrated fashion. The system automates the

processes ranging from Material Receipt to Finished Goods

Dispatches including intermediate processes like Inventory and

Accounting.

Overall, the systems consolidate all business operations into a

uniform and enterprise wide system environment.

Responsibilities & Accomplishments:

. Involved in design and development of complete ERP Solution for

a small scale Pharmaceutical Companies.

. Individually designed, developed and successfully implemented a

Time Tracking System.

. Recruited the team of Trainees and trained them to work in

Client Projects with layered architecture approach.

. Involved in Requirement Study, Analysis, Database & Architecture

Design.

. Involved in development of following major modules.

o Inventory Management and Quality Assurance

o Report Generation Module providing comprehensive

information about each process using Crystal Reports and

DOS Reports.

o Configuration and Implementation of the system at the

various Pharmaceutical Manufacturing Units.

o Prepared comprehensive HELP document to provide the users

in depth understaing so that they can use of the system

effectively.

. Worked with clients for the purpose of requirement change and

support.



Contact this candidate