Sql Server .Net
Resume:
Purushottam
**********@*****.***
Career Interests: Sr.Project lead with excellent record of delivering cost effective, high performance technology solutions to meet challenging business demands. Extensive qualifications in all aspects of information systems methodology from conceptual design through documentation, implementation, user training, quality review, and enhancement.
Professional Summary:
●8+ years of IT experience in web, windows and Microsoft BI using C#, ASP.NET, AJAX and ADO.NET with SQL server and SSIS.
●Experienced in WPF with MVVM architect using Telerik control.
●Proficiency in ETL integration Excel/Access/Text/SQL Server applications with external API’s, Databases, web pages, to import and export data.
●3+ years of experience in team and project management.
●Experienced in building prototype and presenting to client.
●Experienced in analysis, design and development of reports in client/server environment using Visual Studio 2010.
●Expertise in creating modules and writing complex SSIS packages in different business environments.
●Good knowledge in Microsoft Dynamic CRM.
●Experience in testing tools such as HP QC and SQUIDS (internal tool).
●Expert in handling errors, debugging, troubleshooting and validation of user data.
●Sound knowledge of reverse and forward engineering, conceptual, logical and physical model.
●Handled onsite-offshore operations by conducting knowledge transfer sessions and handshake Meetings on daily basis.
●Excellent knowledge and experience on Agile/Scrum methodology.
●Experience in working with executive management, technical architects and business end-users implementing change management and new technology deployments.
●Excellent communication, interpersonal, and project management skills to work within an aggressive and demanding project schedule and environment.
●Excellent knowledge on third party tool like Quest Analytics and Telerik control.
●Experience of working in different geographical locations (USA, India)
Technologies and Skills:
Programming languages: C#, ASP.NET, HTML, CSS, XML, AJAX, JavaScript
Web Technologies: Net Framework 2.0/3.5/4.0,ADO.Net,WCF,WebService, LINQ.
DBMS: MS SQL Server 2008/2012
Version Control Tools: VSS and Team Foundation Server (TFS)
Web Server: IIS 6.0/7.0
Operating System: Windows XP/2000/7
Hardware/Software: WPF, .Net 4.0, ASP.Net, VS 2010/2012, C# 4.0, SSIS 2008
Tools: Telerik, Dollar Universe, CRM and Quest Analytics 2014.4/2015.4.
Domain: HealthCare and Life Science.
Education:
C-DAC (Center for Development of Advanced Computing) – SIIT Pune. 08/2006 – 01/2007
● P.G. Diploma in Computer.
Bachelor of Engineering – Nagpur University, India 08/2001 – 04/2005
● Computer Technology.
Professional Experience:
Client: Humana Inc. KY, USA Jan 2014 – Till date
Role: Sr.NET TECH LEAD
Project : CMS - HSD ( Health Service Delivery)
Humana Inc. is an American managed health care company that markets and administers health insurance with headquartered in the Commonwealth of Kentucky, and has over 40,000 employees worldwide. Humana markets its health insurance services in all 50 U.S. states, D.C., and Puerto Rico, and has international business interests in Western Europe and Asia.
Health Service delivery is process to generate health care data for CMS approval. Humana generating data based on contract and non-contracted provider and submit it to CMS for Humana Provider Network Expansion.
Once Humana receive approval from CMS then able to sell product and expand their provider network throughout the county. Quest Analytics tool is used to feed provider data and generate adequacy as per CMS latest standard and guideline to meet Humana provider network adequacy standard and data compliance.
Responsibilities:
●Worked as SME for HSD and playing onsite Sr. Lead /co-ordinator role.
●Handling 13 team member in agile methodology and supporting onshore -offshore model.
●Playing major role in estimation, prioritization based on dependency, peer review, demo and deployment.
●Presentation layer (GUI) application has been created using WPF web forms, C#, ASP.NET 4.0, MS Visual studio 2010.
●Used ADO.NET objects to access data from SQL Server 2008 database by using stored procedures and queries in T-SQL.
●Played major role in creating user interface using WPF with MVVM architect.
●Involved in writing queries and performance optimization of the SSIS.
●Created SQL Server Job re-run utility and provided flexibility to business partner for on demand SQL SSIS Job execution from User Interface.
●Design various data flow diagrams for different modules by using Visio.
●Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
●Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
●Used $Universe tool to created dependency business flow for ETl/SSIS and API/Console jobs.
●Customize Quest Analytics API as per business need for network adequacy automation.
Environment: C# .NET, MS SQL Server 2008/2012, Visual Studio 2012,SSIS, WPF, ADO.net, IIS 5.0/6.0, Quest Analytics 2014.4/2015.4 and TFS.
Client: Humana Inc. KY, USA Oct 2012 – Dec 2013
Role: .NET TECH LEAD
Project : Retail Sales - CRM Integration
CRM tool used by Humana market point agent to collect customer information and their product of interest. Later it will create opportunity for Humana to provide detailed information to customer by setting appointment, telephone calls or campaign. This tool is integrated with market point telesales agent outlook, which will provide flexibility to agent to collect customer information on call.
Responsibilities:
●Worked on replacement of 20 year old system with CRM.
●Created SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services and created job for SSIS packages.
●Involved in writing queries and performance optimization of the SSIS.
●Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
●Extracted data from Oracle and migrated into SQL Server 2008 using console application.
●Integrated CRM service with difference source like agent application along with real time data processing.
●Consumed enterprise address validation service and created public and private service for CRM integration.
●Deployed SSIS packages, created job and scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of Sales department.
Environment: C# .NET, ASP.NET, MS SQL Server 2008, Visual Studio 2012,SSIS, XML, WCF, ADO.net, IIS 5.0/6.0 and TFS.
Client: Humana Inc. KY, USA Oct 2011 - Sep 2012
Role: Sr.NET TECH LEAD
Project : Medicare - Pinnacle
Humana - Pinnacle is web based application provide interface to business partner for dummy plan creation, updating current plan information and comparison of different plan.
This application used by Humana leader to review and set up goal Vs target to improve sales.
Responsibilities:
●Created presentation layer ( dummy plan ) using asp.net and C#.
●Used ADO.NET objects to access data from SQL Server 2008 database by using stored procedures and queries in T-SQL.
●Before doing any migration, always used to take database backup.
●Created SSIS job for processing of plan related data to Pinnacle system.
●Created ETL for dummy plan and actual plan comparison.
Environment: C# .NET, ASP.NET, MS SQL Server 2008, Visual Studio 2012,SSIS, ADO.net, Ajax, IIS 5.0/6.0 and TFS.
Client: Humana Inc. KY, USA Nov 2009 – Sep 2011
Role: Sr.NET DEveloper
Project : Humana-One
Humana-One is web based application used for handling Humana commercial plan and medicare policy.
This application used for customer enrollment for Humana plan.
Humana-One has 4 different part -
-Agent workBench
-Call center
-Online customer
-CM - Content Management
Humana - One data sent to Automated enrollment and then flow to downstream like police's, claims etc.
Humana one application help Humana to sales their commercial and individual medicare products.
CM application used to configure product, plan and their Benefits. Actuarial setup some guideline and configured those as rules in CM. Content management also called as rule engine to maintained all Humanaone application content.
Responsibilities:
●Worked on story / enhancement in current application.
●Presentation layer (GUI) application has been created using web forms, C#, ASP.NET 2.0, MS Visual studio 2008
●Used ADO.NET objects to access data from SQL Server 2000 database by using stored procedures and queries in T-SQL.
●Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
●Application migration from lower to higher environment.
●Production deployment support. Production incident review and fixes.
Environment: C# .NET, ASP.NET, MS SQL Server 2008, Visual Studio 2008,, ASP.net, ADO.net, Ajax, IIS 5.0/6.0,VSS.
Client: NaturaLawns of America (Wood Street, US) Apr 2008 – Oct 2009
Role: Sr. .NET DEVELOPER
Natural awn of America provides environment friendly service to create green lawn quickly, more naturally along with taking care of lawns. NaturaLawns provide facility to service provider to create their own franchise by creating their own web site on fly.
Responsibilities:
●Created user interface using C#, ASP.NET.
●Responsible for creation, maintenance and support of .Net Application.
●Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
●Prepared Data Flow Diagrams and Functional design document for database design.
●Created master templates.
●Gathered requirements from clients and business analysts for end user applications.
●Analyze business requirement.
●Unit testing and Integration testing for various modules.
●Followed SDLC procedure throughout the modules and reports development.
●Involved in documentation of the future enhancements.
●Performed unit testing and uploaded the enhancements into SharePoint server.
●Designed, defined and documented workflow diagrams and processes.
Environment: C# .NET, ASP.NET,MS SQL Server 2008,, ASP.net, Visual Studio 2008, ADO.net, Ajax, IIS 5.0/6.0,TFS.
Client: Avectra - net FORUM, India May 2007 – Mar 2008
Role: .NET DEVELOPER
Avectra net FORUM Pro is an efficient association management system that make it easy to manage your members and drive your association’s success; while freeing you from tedious, repetitive data input and manual reporting.
•Better identify, retain and serve members
•Capture, organize and manage all member interactions
•Simplify the planning and execution of your most complex events, meetings and conferences
•Build or extend your existing membership website
•Maximize your revenues with real-time eCommerce
•Engage members and give them access to all you have to offer
Avectra netFORUM Pro is designed for associations seeking powerful association technology without the ongoing expense of a customized solution – net FORUM Pro provides a complete set of membership management features, plus advanced querying, the ability to integrate with third-party applications, and features for managing certification and award programs.
Because Avectra netFORUM is cloud-based, you are always current with the latest technology through ongoing, automated software updates that won’t disrupt service or interfere with your daily activities. Avectra netFORUM Pro allows you to focus on your members, not your software.
Responsibilities:
●Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
●Created master templates, website, modules using toolkit.
●Unit testing and Integration testing for various modules.
●Followed SDLC procedure throughout the modules and reports development.
●Involved in documentation of the future enhancements.
Environment: C# .NET, MS SQL Server 2008, Visual Studio 2012, ADO.net, Ajax, IIS 5.0/6.0,VSS and avectra toolkit.
Contact this candidate