Profile Summary:

• Over 12 Years of IT application design and development experience with extensive skills in diverse software platforms. Working as a Technical lead, Lead Developer and On-Site coordinator at client location/s in US since May 2010.
• My roles includes, Design/Develop and support Web/Desktop applications using Microsoft applications development tools and technologies like Visual Studio up to 2010, .NET Framework 4.0, 3.5, 3.0, 2.0 1.1, TFS 2010, C NET, VB .NET, ASP.NET MVC 4.0/3.5, ASP.NET, ADO.NET, WCF Windows Services, Web services SOAP over HTTP , RESTful services, .Net Application blocks Enterprise library , Datasets, Data Views, Data tables, Caching, File System Objects, Microsoft Visual SourceSafe, ASP 3.0, Visual Basic 6.0 programming environments including essential skills.
• Expertise includes creating several DTS, SSIS packages including Task Factory and SharePoint List extensions, SSRS SQL Reporting , COM objects and Active X controls using Visual studio software. In-depth knowledge in SQL Server 2008/2005 objects and Data Access ADO objects, RDBMS Oracle 11/10g functions.
• Experience in reporting using SQL Reporting services SSRS , Crystal Reports 11/9.0/8.0, Data Reports and Excel macros.
• Extensively worked on server side languages like PL/SQL, Stored Procedures and Oracle OLE objects. Well versed with VBA Macro's experience with IIS 6.0 admin functions, Windows Schedule tasks, Windows Authentication modes, HTML, CSS, Java Script, VB Script, XML, TOAD v 8.5 , SQL Query analyzer, SQL Developer, T-SQL, Citrix and Service Oriented Architecture for Business Applications. Having good knowledge/understanding of Design Patterns, MVVM, Java Framework like Angular JS, Entity Framework EF and Object oriented programming.
• Experience in working with Erwin 7.2 data modeler to create automated pre-table, post-table scripts, database table design s .
• Experience in full SDLC includes requirements gathering, estimating, project analysis, functional/Technical design, development, Work Product Reviews, Participating execution of test cases during Unit Testing UAT, Implementation, Migration and system documentation phases of various business applications and large scale applications.
• Demonstrated excellent technical/leadership skills, Coordinated for work performed in remote locations in Onsite - Offshore model. Experienced working with other stake holders like ITO, Server, Security, DBA, Client users in all the phases of SDLC per the need
• Experience working in corporate projects like Disaster Recovery Testing, Database Upgrades, Server Consolidation, Windows 7 PC Refresh, Integration and Migration. Also, participated in CMMI audit interviews and appraisals. Underwent training in ITIL V3 Foundation, having good understanding of Agile and Waterfall project methodologies.
• Highly organized and self-motivated individual, Capable of Multi-task environment having Good communication, Technical, Leadership and inter personal skills.

Tools/Technical Skills:

• Operating System : Windows 2003/2000, Windows 7, Windows XP/NT, MS-Dos.
• Products/Tools :Visual Studio 2010, .Net Framework 4.0/3.5/2.0 1.1, BIDS 2008, TFS 2010, VSS, Web designing tools, Erwin 7.2 data modeler, CAML query builder, Quality Center
• Languages : C .Net, VB.Net, ASP.Net, ASP.NET MVC 4.0/3.5, and ADO.Net, WCF, WPF, WF, C, C , VB 6.0, ASP 3.0
• Reporting Tools : SSRS, Data Reports, Crystal Reports 8/9/11.
• RDBMS : Oracle 11g/10g, SQLServer2008/2005/2000.
• Business Domains : Energy Utilities, Pharmaceutical and Travel.

PROFESSIONAL EXPERIENCE

Current Project Highlights:

Confidential

Environment : Web/Windows, Microsoft Technologies.

Role : Technical Lead, Developer

Responsibilities:

• Working in Clinical Review Oversight tool project for Pfizer as in Technical Lead and Lead Developer since November 2013. Primary responsibilities include understanding the requirements and provide solutions, code the changes using Microsoft.NET.
• Designed and developed database table structure for Protocol Deviation Trends PD Trends and Scientific Integrity Oversight Plan SIOP review modules using Erwin Data Modeler 7.2 tool, updated/added pre-table and Post table script templates as per the current project requirements. Created views, stored procedures, functions, triggers and user types having SQL Server 2008 as database.
• Worked in data migration for existing PD Trends reviews from SharePoint to SQL Server database. Designed and developed SSIS package, used SharePoint List adaptor to pull the data from SharePoint site into SQL Server database. Used user group web service in SSIS script component to read/load the NT/AD user data from SharePoint site.
• Designed and developed web pages for performing Protocol Deviation Trends and SIOP Reviews using ASP.NET, C . NET, ADO.NET. The tool allows clinician reviewers and Operations reviewers to complete their review process for clinical studies. Changed existing webpage, added additional columns to the JQ Grid to accommodate the requirements.
• Developed web pages and style sheets using HTML and CSS.
• Worked in security module, changed the security object as per the new PXED LDAP groups introduced as part of new requirements. Involved in designing/developing the changes to existing Protocol Deviation data load project in VB.NET, ADO.NET.
• Assisted technical lead, managers at all stages of SDLC, provided unit test plans using standard project template s . Providing the status updates, daily scrum, and deliverables on time in Agile project management methodology.
• Worked with other stake holders like QA, Testing and UAT teams during system testing, user acceptance testing and pre-release defect fixes. Involved/tested the application in Windows 8 server, fixed the issues related to compatibility mode. Involved in production deployment, worked with ITO and DBA teams for moving the changes into production environment.
• Assisted Technical lead in preparation of Installation Instructions, Installation Verification, Environment Qualification. Involved in creating Test Plans and executing them in Test Lab using HP Quality Center.
• Coordinated, mentored offshore development team, provided assistance in technical/design understanding s . Worked with Informatica developers, assisted in design and development of informatica workflows/ETL jobs.

Skill/Tools:

C .NET, ASP.NET, VB.NET, ADO.NET,.NET Framework 4.0, Visual Studio 2010, SQL Server 2008/2005, Enterprise Library, Oracle 11g, VSS 6.0, Erwin Data Modeler 7.0, JQuery, CAML Query builder and SSIS,CSS.

Confidential

Environment : Web/Windows, Microsoft Technologies.

Role : Technical Lead, Developer

Responsibilities:

• Worked in Rental domain IT of DTAG as a Technical Lead, developer and Onsite coordinator from March 2012 till October 2013. Primarily responsible for working with BSA in understanding the requirements provide the solutions as per the current sequential Work Flow WWF /SOA based application.
• Worked in Credit Card forced charges project. My role is to work with BSA in understanding the requirements, provide technical designs/specifications for the application developed per Service Oriented architecture to the team. Prepare the High Level design and Low Level design, include class diagrams and use cases. Code the changes using C .NET, ASP.NET, SQL Developer, WCF Services, WWF, SSRS Reports, and SSIS apart from providing technical assistance to the team located in Off Shore. Also, perform reviews for the work completed by the team, prepare and participate in developing test cases for the changes.
• As a technical lead, responsible for maintaining source control using TFS, branching, merging per the release schedules, tracking the defects/work requests, tasks, test result, publishing the builds.
• Worked in Major Enhancements project which is a combination of several Change requests. Made changes to Windows Services, and client application added new JSON controls to achieve functionality as per the requirements. Designed and developed SSRS reports, used Drop down lists and tablix controls. As part of Major Enhancements, added additional features and validations to the client applications in VB.NET.
• Worked in User administration website, developed the website using ASP.NET MVC 4, RESTful service GET, POST and DELETE to identify the type of request, Linq to SQL, Lambda expressions and provided a mechanism for issuing user access to smart client Counter Agent application, created the database table classes using Entity Framework.
• Participated in requirements gathering for Flexible Fuel project, assisted in preparation of High Level and Low Level designs for the project. Made the code changes for allowing waiving off prepaid fuel charges in Hand Held and counter application if customer opts for Prepaid Fuel option while renting a car.
• Assisted onsite technical leads in design of Credit Card authorization over ride project, which allows configuring the authorization amount at the time of rental based to percentage or fixed price proposals for a particular location.
• Worked on Purge process which is an initiate as part of continual improvement of IT operations. Created/updated the purge scripts using UNIX shell commands and PL SQL as per the data retention policy of the organization. Identified source tables of the database, relations among the tables. Enforced the business rules in the existing scripts, also provided a means to business for defining the rules on their own through an interface for the consecutive purge cycles.
• Worked in RSA Rental Sales Agent Incentives Automation project. Provided technical solutions and resolved some of the critical issues identified as part of QA Testing. Performed functional and nonfunctional reviews, created test cases using standard templates.
• Provided solutions as part of Rental DB Archival project to resolve Database size issue in production database. Designed and developed SSIS ETL package to archive the production database. Made changes to the WCF services, introduced a new rental provider in the Work Flow to retrieve the rental agreements from new SQL Server database. Also, stream lined the existing Enterprise Data ware House process to have more accurate data for the reporting purpose/s.
• As a technical lead, Responsible for system integration/testing of WCF Services, Middle tier and UI applications, track/fix the defects, track work requests, tasks using Team Foundation Server 2010 as source control. Publish builds to QA and UAT environments, attend triage meetings and promote the defect free code to Production environment through implementation process.

Skill/Tools:

C .NET, VB.NET, ADO.NET, WCF Services, RESTful Services, WPF, WF, JSON, .NET Framework 4.0, Visual Studio 2010, SQL Server 2008/2005, MVC 4, EF, Oracle 11g, TFS, SSRS and SSIS.

Confidential

Environment : Web/Windows, Microsoft Technologies.

Role : Technical Lead

Responsibilities:

• Worked in data archival and Integration project as per the client requirements. My role was to coordinate with business users for several applications, helping them in application data archival and data transformation, reporting the status to the project manager and performing bulk exports into filenet P8 tool.
• Worked as a Technical lead on a Major Windows 7 PC refresh project for the client. My role was to work with the project Manager on Functional and Technical requirements, and to ensure all HR, Corporate Financial applications comply with Windows 7 operating environment. Other responsibilities include, coordinating with Off Shore testing team in meeting the project mile stones, Identifying issues, providing remediation solutions, estimates and implementing the solutions in applications as per the requirements.
• Worked on ASP.NET web and VB.NET windows console applications having SQL server 2000/2005 and Oracle 11g as database. Designed and developed Web Methods in web services consumed the services in ASP.NET web applications.
• Worked in intranet application for Safety and Health department using ASP.NET. Used validation controls and regular expressions for custom validations.
• Worked as a functional lead for Several HR, Corporate Financial applications of Allegheny Energy having end to end responsibility interims of deliverables within the application area. Application areas include HR, Corporate and Finance departments. Extensive experience in successful implementation of minor/major application software's at Allegheny Energy. Creating/modifying components, applications as per the requirements. Unit testing of self-work and peer reviews.
• Primary role was to work with the Release Managers, General Manager Client IT in planning scheduling the outstanding work for HR, Corporate Finance divisions. Besides leading, coordinating, motivating and helping the off shore developer team on a day to day activities.
• Involved in developing and Implementing Sarbanes-Oxley, Active X controls, CMMI Level 3 audit requests. As a technical lead involved in several corporate projects that include ERP, Disaster Recovery, Server Consolidation, Windows 7 PC Refresh and Database Upgrades projects. Created Data Transformation Services DTS /SSIS package to map and load the data to the new databases as part of Database Upgrades.
• Worked in SharePoint administration console in creating the new sites, maintaining the sites and deleting the sites upon client request. Worked in VB Script for updating Active Directory AD attributes from Oracle Database.
• Worked in Windows applications, using MS Office libraries to send the emails from scheduler/s.
• Closely interacted with the clients, coordinated and resolved issues during the complete cycle of the changes and with extensive involvement very well managed client relationship at all levels. Worked with other stake holders ITO, Security, Server, Network and DBA in all stages of SDLC per need.
• As a 24/7 Primary support of HR, Corporate Financial applications, achieved 100 availability of systems and contributed to all applicable Service Level Agreements Green SLAs for 18 months in a row. Handled tier II/Level II support issues within areas of expertise and developed help desk support solutions and health checks. Identified root causes and solved frequent issues/problems. Analyzed the tickets received and solved them at the earliest.
• Prepared all the required documentation like analysis document, requirements documents, change documents, testing and Implementation documents using the standard templates. Also, conducted/participated in Work Production reviews at all stages of SDLC.

Skill/Tools:

ASP.NET, VB.NET, C .NET, ADO.NET, .NET Framework 1.0/2.0/3.0 and 3.5, ASP 3.0, VB 6, MS Access, VSS, SQL Server 2000/2005, Oracle 8i/10g

Confidential

Role : Lead Developer

This is a web application for tracking the project and it's Progress. Engineering Construction and Projects division of a Teleservices Company having its major functionality in Supply, Foundation, Erection and Painting of the towers. This web application is useful in tracking progress related to the sites, phases, stages and tasks carried out in various places of ECP Division. Meetings, discussions and Notes depict in respective Logins. Calendar user control shows the logged in user's tasks, meetings and sites as per the date wise. A Windows Service escalates the mails to the superior/employer when there is a delay in work status.

Responsibilities:

• Designed and developed Project Management for ECP using ASP.Net.
• Used ADO.NET for SQL Server database interaction using Data Adopter, Data Reader, and Dataset.
• Used Web services, Windows services
• Designed Developed Calendar User Control, Used Grid controls.
• Involved in testing, debugging and Implementation
• Worked in VB Script schedulers to load tables in database.

Skills/Tools used:

VB.NET, C , SQL, ADO.NET, SQLServer 2000, MS Visual Studio .NET, Visual Source Safe, Microsoft Windows XP.

Confidential

Environment : Windows/Web

Role : Programmer/developer

Worked in Windows and Web based projects for the clients of Confidential Technologies from September 2002 till March 2005.

Responsibilities:

• Worked in Member Progress Tracking tool for Gymnasiums using VB.Net. Used ADO.NET for SQL Server database interaction using Data Adaptor, Data Reader, and Dataset. Designed Developed User Controls. Used Grid controls to show the list of records.
• Developed EZAzenda tool in ASP. Net. Used ADO.NET for SQL Server database interaction using Data Adaptor, Data Reader, and Dataset. Used ASP.NET Web Forms controls. Created stored procedures and triggers. Developed Reports using Crystal Reports 9.0. Used Server controls, Data Grids Data list. Used ASP.Net Validation controls for validating user inputs.
• Developed Stock Sales Management System for stock handling department for an automobile industry using VB.NET. Actively participated in analysis and design of the system. Used ADO.NET for SQL Server database interaction using Data Adaptor, Data Reader, and Dataset. Developed Reports using Crystal Reports 9.0. Designed and created reports in the application using XML data. Used Server controls, Data grids Data list.
• Worked in Real Estate Management tool in VB6.0. Used ADOs for MS Access database interaction using Connection, Command objects and Record sets. Developed Reports using Data Reports.
• Worked in web solution Www.Pettycashsoftware.com in ASP 3.0. Used ADOs for MS Access 2000, interaction using Connection, Command and Result sets.
• Involved in testing, debugging and implementation phases. Prepared the documentation using standard templates suggested by client.

Skills/Tools used:

.NET Framework 3.0/3.5, VB.NET, ASP.NET, ADO.NET, SQL Server 2000/2005, XML, Crystal Reports 9.0, VB6.0, HTML,ASP3.0, PLSQL, MS Access 2000,JavaScript, IIS 5/6, Windows NT 4.0/2000/XP, Visual Source Safe 6.0,