Software Engineer Sql Server
Resume:
Lalit Kumar Arya
*****.****@*****.***
Professional Summary
• 11+ years of experience in software application design and development on Microsoft
Technology platform.
• Having domain knowledge of Telecom, Health care - payer and provider services, and Human
Resource and Payroll.
• Extensive experience in software development methodologies Agile SCRUM/ Waterfall/ with
good Technical, Analytical skill.
• Extensive experience in ASP.Net, MVC, Entity Framework, HTML5, JavaScript, JQuery,
Web services, WCF, VSS, TFS and Accurev.
• Experience in Application and Database Architecture . Good understanding of Enterprise
Application blocks, Design Patterns and SOA architecture.
• Participate development design, code review, test review, and operation procedure review
meetings.
• Demonstrated ability to work well with a wide variety of people at various levels. A self-starter
with positive attitude, willingness to learn new concepts and acceptance of challenges
• Good Experience in Debugging, Bug tracking, Application performance, System analysis and
design and good in problem solving techniques.
• Experienced in working directly with clients to define requirements and specifications, project
work planning and management, design, development and successful implementation of
applications and systems.
• Excellent analytical, communication, organizational, administrative, interpersonal and
leadership skills.
• Expert in databases SQL Server & database technologies including SQL, PL/SQL, ADO.Net,
ADO, ODBC, Stored Procedures and triggers Reporting Services (SSRS) and SSIS.
• Have expertise in Service contract, service implementation, and business logic, leading the
migration of applications to production, documentation.
• Fluent with operating in highly dynamic and evolving environments that require quick decision
making and negotiating a win-win outcome for clients.
Professional Skills
Programming Language C#, ASP.Net, HTML5, JQuery, Javascript
.Net Technologies WCF, WPF, Web Services, Silverlight
Application Design MVC2.0/3.0,
Others LINQ, Entity Framework, WebAPI, Angular JS, Knockout JS
Tools Visual Studio 2008/2010/2012, Visio, IIS 7.0, MS Project TFS, Accurev,
SAML2.0, Crystal Report 9.0, Accurev, Cruise Control,Visual Source Safe 6,
Va Spreadsheet2.5, IE 6.0
FxCop, TFS, JIRAS, Bugzilla, HP Quality control.
MS Testing Framework and nUnit unit testing tool.
RDBMS SQL Server 2000/2005/2008 R2, SSIS, SSRS, MySQL, Oracle, DB2, Sybase
Design & Architectural Design Patterns, Database design
OS Windows 98/NT/2000/2003/2008/XP and Windows 7
Experience:
• Senior Technical Lead, HCL Technologies - May 2010 – Present Client: T-Mobile USA
Currently, working at the client location as Development Lead managing 15 resources includes both
onshore and offshore. Successfully launched m.my.t-mobile.com a mobile website for T-mobile
customers to check their account activity built using HTML5/ JQuery.
• Project Lead at BIRLASOFT from Aug 2005 to May 2010.
• Software Engineer at Cressanda Solutions Ltd. Noida from Sep 2002 to Aug 2005.
Education:
Masters in Computer Applications, India.
Bachelors in Science with majoring in Mathematics.
Client Project Details
TMO & MYTMO [ https://my.t-mobile.com]
T-Mobile, USA @ T-Mobile, Seattle, WA Jan, 2013 to May, 2013
Team Size : 15
Position : Senior Technical Lead
Duration : Jan 2013 to Till now
Environment : MVC3.0, ASP.net, HTML5, Jquery, Jquery mobile, C#, Cruise Control, REST Service,
log4net, Accurev for configuration management & source control.
Description:
Upgrade the existing t-mobile and my.t-mobile site for the client T-Mobile. Provide the no service
contract option for their customer with good data plan. One aspect of the project is to re-use
existing backend services and business logic and centralize this functionality.
Responsibilities:
• Ensure application development, project plan adherence and scope changes.
• Create mobile site for T-Mobile m.my.t-mobile.com using technology like HTML5,Jquery
mobile, REST services.
• One aspect of the project is to re-use existing backend services and business logic and centralize
this functionality in a framework that is more ideal from a performance standpoint for the mobile
environment.
• Code Review, Coding, Unit testing, Build creation and deployment on dev environments.
• Reviewed and Documented Technical Specifications.
• Writing and consuming REST services.
• Writing custom controls for common use as standard.
• Used javascript libraries for front user interactions logics. Used JQuery for selecting DOM page
elements and ajax calls.
• Carry out status reporting to client, requirement review.
• Create a tool “QC report tool” to automatically generate the daily defects status report in
PowerPoint format. Tool is responsible to fetch the data from “HP quality center” and generate
the user friendly report via using the following technology like MVC3.0, ASP.net, C#, SQL
Server2008, bootstrap.js Open XML SDK, Oracle Client with Active directory authentication.
• Develop generic work flow and business logic in C# and REST Services.
• Work assignment to team members.
• Client Interaction and provide maintenance and support of the project after the pre and post
deployment of code.
Web Modernization Phase 1 & 2 [ https://m.my.t-mobile.com]
Client : T-Mobile, USA
Team Size : 10
Position : Senior Technical Lead
Duration : Jan 2012 to Dec 2012
Environment : HTML5, Jquery, Jquery mobile, C#, Cruise Control, REST Service, Accurev for
configuration management & source control.
Description:
The Web Modernization Initiative’s Mobile and Social Web Project has a principal objective to
build a mobile experience for their customers accessing My T-Mobile online and self-service capabilities.
One aspect of the project is to re-use existing backend services and business logic and centralize this
functionality in a framework that is more ideal from a performance standpoint for the mobile
environment.
Responsibilities:
• Ensure application development, project plan adherence and scope changes,
• Analysis of the project, communicate the same to fellow technical team at offshore, Project
coordination and identification of solution, as well as verification of the same
• Code Review, Coding, Unit testing, Build creation and deployment on dev environments.
• Reviewed and Documented Technical Specifications.
• Carry out status reporting to client, requirement review.
• Use HTML 5,CSS3 and Jquery for responsive design for mobile site.
• Use existing business logic of T-Mobile and consume REST service in C# to display and update
the data.
Allscripts Payerpath
Client : Allscripts Healthcare Corporation, USA
Team Size : 15
Position : Senior Technical Lead
Duration : Dec 2010 to Dec 2011
Environment : .NET 3.5, C#, WCF, XML, XSL, NEO, SQL Server 2005 and Subversion for
configuration management & source control
Description:
Payerpath is one of the leading revenue cycle management and clearinghouse services in the United
States with over 300 million claims processed annually and 600 million revenue cycle management
transactions overall. The project involves conversion of outbound claims from 4010 to 5010 format for a
network of payers and ensuring tighter edits, improving pass rates
Responsibilities:
• Analyzing business risks, identify and utilize appropriate modeling techniques,
• Analysis of the project, communicate the same to fellow technical team at offshore, Project
coordination and identification of solution, as well as verification of the same.
• Ensure application development, project plan adherence and scope changes,
• Carry out status reporting to client, requirement review, prepare review summaries, etc
• Conducting Daily Scrum, sprint planning, estimation & sprint retrospection.
• Reviewed and documented Technical specifications.
• Develop generic work flow and business logic in C#.
• Work assignment to team members.
• Client Interaction and provide maintenance and support of the project
MyWay (Electronic Health Record & Practice Management)
Client : Allscripts Healthcare Corporation, USA
Team Size : 20
Position : Senior Technical Lead
Duration : May 2010 to Dec 2010
Environment : .NET 3.5, C#, WCF, XML, XSL, TFS, SSRS, NEO, SQL Server 2005 and Subversion
for configuration management & source control
Description:
Misys Healthcare Solutions Inc is a leading EHR and EMR providers with leading hospitals, ambulatory
services and physician care settings as their clients. The HITECH Act of 2009 brought with it certain
mandatory compliance standards for providers to follow called the Meaningful Use objectives to qualify
for the ARRA stimulus funding. To meet this, the Allscripts flagship product Myway 8.6 needed to bring
in workflow and process changes and customizations in the EhR to enable the same MyWay is one
integrated solution covering Practice management, & Electronic Health Record.
Practice Management: Schedule patients, allocate resources, pull reports, handle the demographic details
that profile contact points, insurance coverage, pharmacies used, and link it all into the billing process.
Electronic Medical Records: Build a patient history, do clinical charting, capture lab results, handle e-
prescriptions, eliminate the paper chase.
Responsibilities:
• Conducting Daily Scrum, sprint planning, estimation & sprint retrospection.
• Preparing sprint burn down chart & Technical specification document.
• Involved in the project for requirement understanding and implementation.
• Involved with the offshore team for approach analysis and requirement understanding.
• Use secure FTP to upload and download the insurance information of the user and HL7 format.
• Create HIPPA compliance report using SSRS and C#.
• Create stored procedure and views to display data on UI and report
ITT E-HR [ https://myhr.itt.com ]
Client : ITT Industries, USA
Team Size : 10
Position : Project Lead
Duration : Aug 2009 to May 2010
Environment : ASP.NET 3.0, C#, SQL Server 2005, Window 2000 server
Description
The ITT E-HR is a bundled package which provides intuitive yet powerful employee management
functionality to your HR team. It offers a comprehensive set of solutions to help you manage your human
resources and capital.
The Global HR helps an employee in the following ways:
• An interface to perform various tasks related to HR.
• A centralized, easy-to-access and globally available Information System.
• A multilingual information system for employees across the globe in all management companies,
business units and value centers.
• More reliable, fast and accurate approach for interaction with HR.
• Most secure and robust architecture.
• Reporting system with multiple file format export options.
• Online help manual & training material for better learning.
Responsibilities:
• Develop the application with SCRUM methodology.
• Created Stored Procedures to extract data for generating reports by using SQL Server 2005/2008
Reporting Services (SSRS), Triggers, Indexes and Views for performance tuning.
• Work assignment to team members and daily SRUM meeting.
• Coding,Unit testing and bug fixing.
• Client Interaction and prototype creation.
NuView (HRMS) integration
Client : ITT Industries, USA
Team Size : 3
Position : Project Lead
Duration : Aug 2008 to July 2009
Environment: ASP.NET 2.0, SAML2.0, C#, SQL Server 2005, Window server
Description:
The NuView is a global HR Management System designed for mid and large scale enterprises to manage
their HR related activities. The NuView application is purchased by ITT for the same purpose.
Business Need: ITT has another HR and Payroll Management System named as MyHR Suite of
Applications developed and maintained by Birlasoft. This suite is a common interface for all ITT HR
applications. ITT needed a Single Sign-on mechanism to link NuView with MyHR Suite for real time
data integration.
Role: Providing Single Sign-on feature using SAML technology and integrating with .NET secured web
services. SAML provided a highly secured SSO implementation.
Compensation Planning (CP)
Client : ITT Industries, USA
Team Size : 7
Position : Project Lead
Duration : Oct 2007 to Aug 2008
Environment: ASP.NET 2.0, Framework 3.0, WWF, C#, SQL Server 2005
Description:
The Compensation Planning application provides highly flexible, Web enabled system for ITT Industries
that functions as a centralized repository for Compensation/ Bonus/ Incentives. It gives managers the
ability to evaluate and define a compensation structure or create a true pay-for-performance culture. The
tool handles the following plans Bonus Plan, LTI Plan (Long term incentives plan), Merit Plan. We have
these functionalities in this tool: Create Plan, Add Approver’s for the Plan, Create Roster, Roster
Approval process, Red Flag generation after any rules violations, after that Plan Approval process.
Responsibilities
• Development of Bonus Module in C#, ASP.net with SQL server as database.
• Work assignment to team members.
• Create normalized database and stored procedure views as required.
• Client Interaction and provide maintenance and support of the project.
• Creation of General Approval process using WWF.
• Integration of various plans with the approval process.
• Unit testing, Integration testing, Code review and Defect fixing.
Value Based Leadership Development (VBLD SYSTEM)
Client : ITT Industries, USA
Team Size :7
Position : Senior Software Engineer
Duration : April 2006 to Oct 2007
Environment : ASP.NET 2.0, C#, SQL Server 2000, Window 2000 server
Description
ITT Industries offers Value Based Leadership Development (VBLD) on an on-going basis. The purpose
of VBLD is to foster individual leadership development aligned to ITT’s Leadership Competencies and
organizational requirements and to the individual’s talents and preferences. The on-line VBLD application
is an electronic tool to facilitate the identification, selection and development of leadership talent within
ITT Industries.
The application intends to digitize hitherto manual processes. Hence it aims at tracking down/
maintaining a multitude of forms/ applications being submitted/ approved/ rejected/ draft saved by either
of the actors i.e. Nominee, Manager, VBLD Manager, HR Manager, VBLD Administrator.
Responsibilities:
• Development of Module.
• Work assignment to team members
• Client Interaction.
• Unit testing, Code review and Defect fixing.
Partnership for Performance (PFP/EC/HR Headcount/GAC Utility)
Client : ITT Industries, USA
Team Size :6
Position : Software Engineer
Duration : Dec 2005 to April 2006
Environment : ASP.NET 1.1, C#, SQL Server 2000, Window 2000 server
Description
The PFP (Partnership for Performance) Application is a HR based multilingual system envisioned to
provide ITT Industries with a centralized software application, which could be accessed by any employee
within the organization around the globe for the developmental processes – “Partnership for
Performance” (PFP). The PFP application helps performing the following:
i) Evaluation Process ii) PFP Administration iii) Reports
Responsibilities:
• Development of Module.
• Work assignment to team members
• Client Interaction.
• Unit testing, Code review and Defect fixing.
Password Management System
Client : ITT Industries, USA
Team Size :4
Position : Software Engineer
Duration : Aug 2005 to Dec 2005
Environment : ASP.NET 1.1, C#, SQL Server 2000, Window 2000 server
Description
Every time user has to enter the password credentials to visit a site. Client need an application that can
store all the credentials only one time and provide the users an interface consisting of the links, on
clicking on which he/she can access the site without supplying the credentials required.
Responsibilities:
• I am responsible for Development of Module.
• Unit testing and Code review
• Bug fixing
Sheriff’s CMS
Client : Sheriff’s Group UK
Team Size :6
Position : Software Engineer
Duration : April 2005 – Aug 2005
Environment : ASP.NET 1.1, C#, SQL Server 2000, Window 2000 server
Organization : Cressanda Solutions Ltd.
Description
Sheriff’s CMS allow user to provide new contents in form of Articles and information about Sheriffs
group of companies. Contents can be plain text or formatted text with pictures. It gives a consistent Look
& Feel. It allows content to be stored, retrieved, edited, updated, and controlled. It has two parts Admin &
User. Admin have rights to add update contents and upload files. And user can view and download files.
B& K Securities
Client : Batlivala & Karani
Team Size :5
Position : Software Engineer
Duration : Jan 2005 – April 2005
Environment : ASP.NET 1.1, C#, SQL Server 2000, Window 2000 server
Organization : Cressanda Solutions Ltd.
Description
Founded over a century ago, Batlivala & Karani was an early member of the Bombay Stock Exchange.
The firm has had its Head Office in Fort, the historic centre of Mumbai, throughout its existence. In
recent years the firm has also acquired National Stock Exchange membership and opened branch offices
in several major cities of India. Features we implemented are: Upload Reports on server, Security of
Information via user roles and user can see report on the basis of right, Search facility to find the
uploaded report
Responsibilities:
• I am responsible for Development of Module.
• Unit testing and Code review
• Bug fixing
ERP-Omni Net
Client : Golcha Group Jaipur
Team Size : 15
Position : Software Engineer
Duration : April 2004 to Jan 2005
Environment : ASP.NET 1.1, C#, SQL Server 2000, Window 2000 server
Description
The Enterprise Resource planning (ERP) implementation for the Golcha [Golcha Group Jaipur] aims at
providing an integrated solution for the business functionalities with focus on providing accurate
centralized information flow across the organization required to carry out the day to day business
activities and as on aid to the Decision Support System The Modules in E-Trans are: Human Resource
Management, Payroll, Financial Accounting, Plant maintenance, Marketing and Sale, Purchase
Management System, Inventory Management System, Quality and calibration, Fixed Asset, Budgeting &
Costing.
Responsibilities:
• I am responsible for analysis, Design and Development of Human and Resource Management,
Marketing & Sales Module and Payroll.
• Unit testing, Integration testing and Implementation of Module.
• Bug fixing.
Contact this candidate