SUMMARY:

• Highly motivated individual with over 13+ years of experience in Information Technology. Adept at prioritizing and completing tasks to meet customers’ needs.
• Skilled problem solver and an efficient team player with good technical, process and domain skills.
• Able to work both independently and with large development and business team.
• Good team player with reputation of integrity and an ability to work on multiple technologies.
• Participated in all the phases of Software Development life cycle including requirement gathering, analysis, design, coding, testing, implementation and support
• Experience in implementing projects using Waterfall and Agile Methodology
• Successfully managed complex projects with global implementation and rapidly evolving requirements
• Worked in Healthcare, Insurance, Life science, Supply chain, Manufacturing and GIS Domain.
• Experience in delivering project with stringent timelines and high pressure
• Experience in designing application architecture using NTier architecture.
• Experience in Identifying and proposing value adds and tools for technology and business
• Expertise in migrating application from VB to .NET
• Effective Team Management and Coordination
• Extensive experience in application development in object oriented technologies
• Effectively worked in both independent and collaborative work environments.
• Knowledge in Cartography, GIS, Satellite image processing, GPS and Spatial data analysis.
• Experience in working on Trizetto FACETS extensions, custom solutions for different business purposes, migration

TECHNICAL SKILLS:

Programming Languages and Tools: C#.NET, VB.NET, ASP.NET, ADO.NET, Web Services, WCF, Web API, Entity Framework, MVC 4/5, LINQ, Javaf Script, jQuery, AngularJs, NodeJs, VB Script, Bootstrap, CSS, VB 6.0, VBA, ASP, AJAX

ETL Tools: SQL Server Integration services (SSIS), Data Transformation Services (DTS)

.NET Framework: 1.0, 2.0, 3.5, 4.0, 4.5

DBMS and Tools: Oracle 10 G, SQL Server 2012/2010/2008/2005/2000 , IBM DB2, MS Access, TOAD, Blue Zone,MySQL, WinSQL, PL SQL, Azure SQL

Application Servers: IIS 6.0/7.0

Reporting Tools: SSRS, Crystal Reports

Markup Languages: XML, HTML, DHTML, XSLT.

Version Control Systems: MS Visual Source Safe (VSS), TFS, GIT, Artifactory

Operating System: Windows 2000/2003/2008/2012 R2 Server/Windows7

Testing Tools: WinRunner, QTP, Quality Center

Other Tools: ArtinSoft, MS migration Wizard, ArcGIS, AutoCAD Map, IDRISI, SiteCore, Visual InterDev, ControlM, Google Maps API, Microsoft Earth API, Active Directory, MS Office(MS Word, MS Excel, Silver light, PowerPoint, Visio etc), NOSQL, MongoDBTrizetto FACETS 4.8/5.1/5.3, QNXT, Xamarin, Microsoft Azure, Azure SQL

PROFESSIONAL EXPERIENCE:

Confidential

Senior .NET/ETL Developer

Environment: .NET 2015, C#.NET, ASP.NET, MVC, TSQL, SQL Server 2015, SSIS, SSRS, AngualrJs, NodeJs, TFS, M.S. Access, VBA, MS Word, MS Excel, WebAPI, Azure SQL, Azure, ADO.NET, Entity Framework, HTML, Toolsnet, SQL Server Data Tool, Visual Studio Code

Responsibilities:

• Designed and developed various SSIS packages for migrating data from Legacy Access database system to SQL Server 2015
• Database analyzer tool created using C#.NET, SQL Server 2015, M.S. Access
• Designed and developed web based tool to integrate the Toolsnet SQL Server data base to Legacy system data base
• Created and updated MS Access Macros and VBA for Toolsnet SQL Server data base integration
• Designed and developed data monitoring tool created using Node JS, SQL Server 2015
• Designed and developed BOGIE web application using ASP.NET MVC, WebAPI, AngulasJS, Bootstrap, Entity Framework, AJAX, JavaScript
• Design and generated Tables, Stored procedures, function, views and Trigger in SQL Server 2015
• Involvement in performing unit, integration and system testing preparation with QA
• Coding and unit testing for .NET 2015, C#.NET, ASP.NET, MVC, TSQL, SQL Server 2015, SSIS, SSRS, AngualrJs, NodeJs, TFS, M.S. Access, VBA, Azure SQL, Azure, MS Word, MS Excel, ADO.NET, Entity Framework, HTML, Toolsnet, SQL Server Data Tool, Visual Studio Code

Confidential

Senior .NET/ETL Developer

Environment: .NET 2015, C#.NET, VB.NET, ASP.NET, MVC, TSQL, SQL Server 2015, SSIS, Control M, WCF, TFS, MS Word, MS Excel, FACETS 5.3, ADO.NET, Entity Framework, HTML, GIT, XML, Citrix Environment

Responsibilities:

• Analyzed and created a Detailed Design Document for various components in FACETS implementation
• Created a dashboard web application using ASP.NET MVC, Jquery, Bootstrap, Entity Framework, AJAX, JavaScript
• Created Members Management web application using ASP.NET MVC, Jquery, Bootstrap, Entity Framework, AJAX, JavaScript
• Designed and Developed custom batch components for EDI 834 enrollment process, BINB log validation, Maternity BES/835 claim processing, NDC Code scrubbing, Specialty Care Provider Termination, XG Care Reporting, NIA Missing Member Report using VB.NET, C#.NET, SSIS, and SQL Server 2015
• Design and generated Tables, Stored procedures, function, views and Trigger in SQL Server 2015
• Created flat file and Excel based reports
• Involvement in performing unit, integration and system testing preparation with QA
• Coding and unit testing for the NET 2015, C#.NET, VB.NET, SQL Server 2015, SSIS, Control M, WCF, TFS, MS Word, MS Excel, FACETS 5.3, ADO.NET, Entity Framework, HTML, GIT, XML

Confidential, Madison, Wisconsin

Senior .NET/ ETL Developer

Environment: .NET 2014, C#.NET, WIN SQL, TSQL, SQL Server 2012, SSIS, Control M, IIS 7.0, WCF, MVC 4/5, TFS, MS Word, MS Excel, FACETS, VB.NET, ASP.NET, ADO.NET, Entity Framework, AJAX, HTML, CSS, GIT, AngularJs, Artifactory, XML, Oracle 10 G

Responsibilities:

• Interact with business analyst and get the requirements for the applications development and support
• Analyzed and created a Detailed Design Document for entire development and maintenance projects.
• Coordinate with QA and Client users for the SIT and UAT and Signoff
• Created a dashboard web application using ASP.NET MVC, Bootstrap, Entity Framework, AJAX. AngularJs
• Designed and Developed custom batch components for EDI 834 enrollment process using C#.NET and SQL Server 2012
• Designed and Developed packages for ICD 9andICD 10 data migration using SSIS, C#.NET and SQL Server 2012
• Designed and Developed packages for Archiving FACETS custom data base using SSIS, C#.NET and SQL Server 2012, Oracle 10 G
• Updated and Tested various C#, SSIS custom components that impacted in FACETS 4.8 to FACETS 5.1 upgrade and FACETS 5.1 to FACETS 5.3 upgrade
• Designed and Developed custom components using SSIS, C#.NET to recycle claims that were pended for the pay hold
• Updated Aerial Authorization packages using SSIS, C#.NET, WCF, XML and SQL Server 2012
• Configure exe, dll, script files in Deployment Control System for SIT, UAT and Production move
• Design and generated Tables, Stored procedures, PL SQL, function, views and Trigger in SQL Server 2012
• Create SQL Server Report Services, flat file and Excel based reports based on the requirements
• Involvement in performing unit, integration and system testing preparation with QA leads and development tech leads.
• Coding and unit testing for the enhancement, development and support activities using .NET 2014, C#.NET, ADO.NET, Entity Framework, AJAX, HTML, CSS, TFS, MS Word, WIN SQL, SQL Server 2012, SSIS, MS Excel, Control M, IIS 7.0, Bootstrap, WCF, Quality Center, jQuery, MVC 4/5, FACETS 4.8/5.1/5.3

Confidential, Madison, Wisconsin

Senior .NET/ETL Developer / Technical Lead

Environment: .NET 2010/2012, C#.NET, VB.NET, ASP.NET, TSQL, ADO.NET, Entity Framework, AJAX, HTML, CSS, WIN SQL, DB2, SQL Server 2008, Oracle 10 G, SSIS, SSRS, Control M, SiteCore CMS, Active Directory, IIS 7.0, Bootstrap, People soft SQL DB, MySQL,WCF, MVC 4/5, Web API, Node JS, Jquery, TFS, MS Word, MS Excel, Microsoft Upgrade Wizard, Artinsoft Companion, Ubuntu Linux, Citrix Environment

Responsibilities:

• Interact with business clients and get the requirements for the applications in F2F Sales System
• Developing a detailed approach document for entire development and maintenance processes for all modules.
• Implement the responsive design using BootStrap for Member Product Work space application
• Configure exe, dll, script files in Deployment Control System for the Demo and Production move
• Create Technical Design document for Home Banking ETL SSIS packages
• Create ASP.NET Web API Services, WCF Services for SiteCore HTML content catching
• Worked on Member Management WinForms A\application enhancements
• Migrate Member Management, CUCM WinForms application using Artinsoft and Microsoft Migration Wizard
• Create reusable component using C#
• Integrate application to Documentum
• Create security module to get it from Active Directory
• Create Windows components to retrieve the Organization data from CUIC MQ Services.
• Design, Create, Test and Implement the ETL packages using SSIS for Home Banking financial information data migration and retrieval process
• Create class modules using MVC Entity framework for Site Core Data Catching
• Design and generate Tables, Stored procedures, function, views and Trigger for HomeBanking in SQL Server 2008
• Configuring the ETL Packages and Components in Control M scheduler
• Create test cases for Unit testing, System testing and User acceptance testing
• Create Address Matching services for RTMI Application using WCF with Object Oriented Design
• Create work requests based on the user requirements and specification for B2B business
• Vendor applications migrated from MySQL to SQL Server 2008
• Create SQL Server Report Services, flat file and Excel based reports based on the requirements
• Migrate DB2 data base data and its objects to Oracle, SQL Server 2008 using SSIS for B2B system
• Create Packaging request and prepare the exes, dlls and configuration files for Production movements
• Involvement in performing unit, integration and system testing preparation with QA leads and development tech leads.
• Coordinate with client business users for the User Acceptance Testing and Signoff
• Coding and unit testing for the enhancement, development and support activities using .NET 2010/2012, C#.NET, VB.NET, ASP.NET, ADO.NET, Entity Framework, AJAX, HTML, CSS, TFS, MS Word, WIN SQL, DB2, MySQL, SQL Server 2008, SSIS, MS Excel, Control M, SiteCore CMS, Node.Js, UNIX Shell / Bat scripting, Gulp, IIS 7.0, Bootstrap, Peoplesoft SQL DB, WCF, Quality Center, MVC 4/5, Jquery, Web API

Confidential, Chicago, Illinois

Senior Software Developer

Environment: NET 2008, ASP.NET,C#.NET, Java Script, VBA for M.S Excel, Active Directory, Crystal Reports, Log, XML, Oracle 10G, TOAD, Oracle 10G, M.S.Access, M.S.Excel, TOAD, VBA, C#.NET

Responsibilities:

• Interact with Client on regular basis to get the better understanding of the requirement for the GS1 supply chain standards
• Coordinate with team to explain the requirements and get the allocated jobs done
• NTier Architecture of the application designed
• Designed and Developed application security module using C#
• Involved in the analysis and designing of business modules for development.
• Design and Developed web pages in GLN Module using ASP.NET, C#.NET, Java Script
• Design of Database tables, triggers, PL SQL and User Defined Functions in Oracle10G and TOAD
• Designed and developed unit test cases and have performed unit testing of several functionalities
• Documented multiple key items like SRS, SDD, Test Protocol, various traceability matrixes
• Created value added tool for GLN data pulling using VB.NET, VBA and Excel Macros
• Create value added to identify the duplicate records using Excel Macros
• Create SSRS reports for GLN module
• Involved in the presentation of modules to the client.
• Involved in the UAT
• Involved in the Implementation
• Analyzed and mapped the raw GLN data and uploaded the data periodically in Oracle DB using SSIS

Confidential

Senior Software Developer

Environment: .NET 2008, Silver light, WCF, DBML, ASP.NET, C#.NET, Java Script, SQL Server 2005, Citrix Environment

Responsibilities:

• Involved in Requirements gathering, Analysis and Detail Design.
• Involved in the design and development of Web pages using ASP.NET, Silver light, C#.NET, Java Script
• Involved in Designing of Database tables and written Stored Procedures and User Defined Functions using SQL Server 2005
• Involved in unit testing, which includes writing of unit test cases.
• Involved in designing and coding the middle layers of the application using C#.NET
• Involved in the presentation of modules to the client.
• Involved in the UAT, Implementation and support