Service Sql Server
Resume:
CAREER SUMMARY
Around ** years of Microsoft .NET experience in Design, Development, Implementation, Testing and Deployment phases of Software Life Cycle.
Significant and progressive experience in Microsoft NET, web-based applications
Expertise in .NET Framework, ASP.NET, ADO.NET, C#.Net, Web services, WCF, WCF Rest, Restful Web API – Implementation, Customization, Application Integration, Utilities development, NUnit testing.
Proficiency in Object Oriented Design/Programming principles.
Excellent in Problem Solving and well Adaptable. Good at working both independently and as a team player.
Extensive experience in software development life cycle.
Experience working with continuous integration builds process.
Experience working with Test Driven Development process.
Proven expertise in software design and development on Microsoft .NET framework.
Analyze application performance using various tools.
Expertise knowledge in project co-ordination and requirement analysis.
Created web models or prototypes that include physical, interface, logical, or data models.
Develop web site mockup or page templates that meet project objective.
Experience working with SSIS, SSAS and SSRS packages.
Experience working in PaaS environment like Apprenda.
Experience in documenting functional and technical specifications.
CERTIFICATION
Microsoft Certified Professional – Web Based Client Development
Microsoft Certified Professional – Application Development Foundation
M102: MongoDB for DBAs, December 2014
M101JS: MongoDB for Node.js Developers (Link), December 2014
shaping-up-with-angular-Js, Code School
TECHNICAL SKILLS
Front-end
XML, JSON, AJAX, CSS, DHTML, HTML, JavaScript, JQuery, JQuery Mobile, Angular JS
Data base
MS SQL SERVER 2000/2005/2008/2012, Couchbase, MongoDB
Development Language
C#
Microsoft
Win Forms, Microsoft ASP.NET, MVC 3.0 (Razor View), Restful Web API,
Services
. NET Web Service, WCF, WCF Rest, Windows Services
Cloud Services
Apprenda
CMS
Sitecore
Testing Tools
HP Quality Center, HP ALM, SOAPUI, JIRA
Web Servers
IIS 6.0, IIS 7.0, IIS 7.5
Operating System
Windows 7, Windows 2008 Server
Version Management
Tortoise SVN, Win CVS, TFS, Bit Bucket
Business Intelligence
SSIS, SSAS and SSRS
Tools
Fx-Cop, Crystal Reports, Team City, Resharper 7, Dundas Web Charts, Telerik, DevExpress, Powershell, Microsoft Visual Studio performance analysis wizard
PROFESSIONAL EXPERIENCE
McKesson Health Solutions – King of Prussia, PA Jun 2015 – Mar 2016
iHub – Software Developer
McKesson Health Solutions delivers industry-leading clinical evidence and expert technology to help payers and providers collaborate for better healthcare outcomes at lower costs. Our solutions reduce unnecessary healthcare utilization while improving outcomes; operationalize complex volume- and value-based payment models; and optimize billing communication between providers, patients and payers. Our solutions are in more than four out of five payers in the country; more than 3,900 hospitals and facilities use our InterQual evidence-based decision support criteria; and our Relay Health financial solutions are used to automate 1.9 billion financial transactions each year.
Responsibilities:
Preparing design document and estimation for different components required for the system.
Developed several .Net projects and deployed into the Apprenda Cloud Services (Paas) for the Multitenancy, Authentication and Authorization applications.
Created Platform Microservice for the tenant on-boarding and subscription system.
Created an Off-platform CDB and PDB in oracle using DBaas and connected to the on-platform application in the Apprenda Cloud service.
Implemented a multitenant application in the Apprenda Cloud service with the Isolated/Commingled Database.
Installed Apprenda Cloud service (Private) in different environment.
To automate the process of deployment, designed by using Restful Web API and Powershell.
Created an automation deployment for .Net & java application using Apprenda Cloud services API
Implemented the Nugget package.
Configured and triggered continuous integration for the .Net projects in the TeamCity.
Integrated TeamCity with the Artifactory for the distribution system.
Created the design document in the Confluence (Atlassian) and commit the coding changes in the bitbucket.
Troubleshooting the Apprenda environment if there is any issue exists in the deployment of the application.
Environment: .NET framework 4.0 (ASP.NET, C#), MS SQL Server 2012, WCF, Rest WCF, Bit Bucket, Apprenda, Powershell, Restful Web API
Corcentric, Cherry Hill - NJ Jun 2014 – Jun 2015
CBP – Sr .NET Developer
Corcentric is one of the leading billing system providers for the truck leasing organization. This application is highly configurable and customizable for the different client. The system provides complete billing system for the end client dealers and fleets. Corcentric reporting engine was re-engineered using SQL Server Reporting Services and data warehousing concepts. This provides additional flexibility in the types of reports that can be run, in addition of charts and graphs.
Responsibilities:
Coding, Testing and Bug Fixing.
Develop enterprise-coding standards and drive process improvements.
Created Restful Web API to consume and update the fleet parts and prices information.
Responsible to write re-usable stored procedure, MDX Query.
Responsible for analysis and designing data warehouse and Analysis service
Designing Dashboard to show Charts data return from SSAS Server.
Designing SSRS Reports.
Creating SSIS project using design patterns to transfer data from production to Datawarehousedatabase
Environment: .NET framework 4.0 (ASP.NET, C#), MS SQL Server 2012, WCF, SOAP UI, Dev express controls, JQuery, Restful Web API, TFS, JavaScript, SSAS, SSIS AND SSRS.
Comcast, West Chester - PA Jul 2012 – Jun 2014
Comcast BCP – .NET Developer
Comcast is one of the world’s leading media, entertainment and communications company. Comcast is principally involved in the operation of cable systems through Comcast Cable and in the development, production and distribution of entertainment, news, sports and other content for global audiences through NBC Universal.
Comcast BCP, is an online web application used to support Comcast customers, to view/pay/customize their bill details based on the logged in user privileges. Customer will receive their updates thru mail and SMS based on the action they performed such as pay and automate their account bill. Customers can set up, manage and purchase domains under their account.
Responsibilities:
Understanding the Business requirements.
Creating Layout, Sub Layout and template creation in Sitecore.
Consuming WCF Service and map the corresponding items in the Sitecore fields.
Developed Sitecore Comparison tool for validating development and production packages.
Creating and publishing packages to the Sitecore.
Involved in creating Mock Service and testing WCF Service using SOAP UI.
Involved in developing Unit Test Project.
Involved in creating Widget for the Einstein and GrandSlam using MVC Framework.
Working in the part of integrating Couchbase changes in the Einstein project.
Environment: .NET framework 3.5, 4.0 (ASP.NET, C#), MS SQL Server 2008, WCF, Web API, SOAP UI, Telerik controls, JQuery, Site Core, MVC 4.0, TFS, JavaScript, JQuery, Couchbase.
Knowledgepoint360, Lyndhurst - NJ Oct 2011 – Jun 2012
Touch Point (TP) – Sr. NET Developer
Touch Point (TP) is a product provided by Physicians World (PW) to manage all honorarium and expense payments to speakers for promotional and non-promotional events. All suppliers with whom the client contracts to conduct their events use the application to track their activities and faculty payments. Touch point mobile are a new website developed for Touch Point Mobile Users. The purpose of this project will be a tailored version of core Touch point application for iPhone/iPad mobile devices & the site will be HTML5 compliant site.
Responsibilities:
Designing the Views specific to the mobile and tablet versions using JQuery Mobile.
Implementing Models, Views and Controllers in ASP.Net MVC 3.0.
Implemented ASP.NET MVC 3.0 pattern mechanism to display content.
Involved in Creating and Consuming WCF Services.
Involved in database design and SQL development.
Involved in coding and unit testing for the application development.
Involved during bug fixing and release management.
Prepared system unit and UAT test case.
Environment: .NET framework 4.0, 3.5 (ASP.NET, C#), MVC 3.0(Razor view), MS SQL Server 2008 R2, AJAX, SSRS, JQuery Mobile, Win CVS, NUNIT, Windows Service, Cruise Control, Windows 2008 Server.
Knowledgepoint360, Lyndhurst - NJ Apr 2011 – Sep 2011
Operational Efficiencies – Sr. NET Developer
Touch Point (TP) is a product provided by Physicians World (PW) to manage all honorarium and expense payments to speakers for promotional and non-promotional events. All suppliers with whom the client contracts to conduct their events use the application to track their activities and faculty payments.
Operational efficiencies are a new enhancement developed for Touch Point. The purpose of this project to update financial details for the event based on the honoraria rules specified by the FDA.
Knowledgepoint360, Lyndhurst - NJ Jan 2011 – Mar 2011
Touch point Account Data – Sr. NET Developer
Touch Point (TP) is a product provided by Physicians World (PW) to manage all honorarium and expense payments to speakers for promotional and non-promotional events. All suppliers with whom the client contracts to conduct their events use the application to track their activities and faculty payments.
Account Data file is a new enhancement developed for Touch Point. The purpose of this project to form modified speaker and participant details thru web application as xml based on the Schema, which will be send thru ftp server to the local system to process. Local system put the modified and added speaker/participant information in ftp server in xml format, the local SSIS package will be used to loop and store the data in the application database.
Knowledgepoint360, Lyndhurst – NJ Sep 2010 – Dec 2010
Touch point Inactive Entities & Migration – Sr. NET Developer
Touch Point (TP) is a product provided by Physicians World (PW) to manage all honorarium and expense payments to speakers for promotional and non-promotional events. All suppliers with whom the client contracts to conduct their events use the application to track their activities and faculty payments.
Inactivate entities & Migration is a new enhancement developed for Touch Point. The purpose of this project is to capture the reason for inactivating the entities also to indicate the inactivated entities with double asterisks to the logged in user. Along with this enhancement, the existing Touch Point application is upgraded to .NET 3.5 and SQL server 2008(Reporting Services & SSIS Packages)
Knowledgepoint360, Lyndhurst - NJ Apr 2010 – Aug 2010
Touch point Workflow Efficiency – .NET Developer
KnowledgePoint360 has conceptualized and developed the Touch Point application as web based application to manage events for the Pharmaceutical companies. The Touch Point application is highly configurable and customizable for a given client and stores all the configuration data, business rules, workflows, validations in the client specific database.
The purpose of this enhancement project is to develop chart based reports from the existing report format. It aims to help the user to understand the report better in GUI format. Dundas chart is used to develop the charts. Telerik controls are used to accept inputs from users, to generate the chart overlay and to develop the drilldown report overlay.
Knowledgepoint360, Lyndhurst - NJ Apr 2009 – Mar 2010
Centralized payment service (CPS) – .NET Developer
Centralized Payment Services (CPS) is a service provided by Physicians World (PW) to manage all honorarium and expense payments to US-based HCPs (Healthcare Professionals) for promotional and advisory activities. All suppliers with whom Lilly contracts to conduct these activities use the system to track their activities and faculty payments. The system also enforces various compliance and business rule logic, including:
Enforcing annual compensation limits for HCPs
Auto-calculating honorarium amounts based on faculty tier structures and the type/duration of the activity
Budget and honorarium exception approval processes
Faculty contracting requirements
Knowledgepoint360, Lyndhurst - NJ Jan 2008 – Mar 2009
Customer Program portal (CPP) – .NET Developer
Customer Program Portal (CPP) is a centralized service offered by Thomson Physicians World (PW) to issue payments to Lilly’s faculty in accordance with Lilly’s annual compensation limits. This system is used to manage and track marketing interventions where an honorarium is paid to US healthcare professionals.
We are enhancing the product and following the Waterfall methodology, my responsibility to get the requirement, do estimation, design and developing the product.
Responsibilities:
Involve in requirement study and project analysis.
Responsible for high level design and detail design document preparation
Provide estimation for the Change Request.
Designing and developing the Web page.
Involved in database design and SQL development.
Involved in coding and unit testing for the application development.
Involved during bug fixing and release management.
Prepared system unit and UAT test case.
Prepared knowledge transfer document for the team to understand application process.
Knowledge transfer to team members.
Environment: Dot NET framework 3.5 (ASP.NET, C#), MS SQL Server 2008 R2, AJAX, Dundas Web charts (7.0), Telerik, WinCVS, NUNIT, Windows Service, Cruise Control, Windows 2008 Server, WCF, Web Service, SSIS, SSRS.
Knowledgepoint360, Lyndhurst - NJ Mar 2007 – Dec 2007
Centralized Payment Service Maintenance – .NET Developer
Centralized Payment Services (CPS) is used when payments will be issued to US Healthcare professionals for providing a service that is neither a continuing medical education activity, nor one that is supported by a grant. A dashboard concept was implemented in CPS which will give users a single point to review a variety of information and system tasks personalized for them which includes a user’s alerts, announcements, event calendar and graphs. The CPS reporting engine was re-engineered using SQL Server Reporting Services and data warehousing concepts. This provides additional flexibility in the types of reports that can be run, the addition of charts and graphs, and the ability to export and view data in additional file formats.
Customer Program Portal (CPP) is a web based application where the Lilly, Cialis and VMS representatives can add and search activities directly to the Centralized Payment Services (CPS) of Thomson Physicians World (PW) instead of calling/ sending a request to a coordinator of CPS. The Speaker Database in the Customer Program Portal (CPP) web application which is a part of Centralized Payment Services (CPS) was upgraded with new features such as Searching all CVs and profiles of speakers by key words or name, Viewing Speaker Profiles: Contact info, Photo, CV, Preferences, Training & Contracting Status, Compensation Availability, Activity Status, and Utilization: Real time available field cap, displayed in terms of programs. Illustrates utilization and program status (confirmed, cancelled, pending) Current Programming Calendar: Speaker’s commitments per day, Aggregated Attendee and Representative Evaluations and Geographic Distribution of Program Activity: by state.
Faculty Resources (FR) is a web based application where the Health Care Professionals (HCP) can login to the system and they can view their invitation alerts; confirm their activities; also, they can sign their own contracts through the system. Faculty Resources (FR) system allows the HCP to upload their presentation document to the system, so that they can access the document from anywhere.
Responsibilities:
Tracking the issues for the CPP, CPS and FR legacy Application.
Debugging and Analysis the Root cause for the ticket.
Providing proper estimation and root cause analysis document.
Providing fix by changing the database and business level coding.
Deploying the application in the production environment.
Environment: ASP.NET 1.1, (C#.net), SQL Server 2000, Infragistics, JavaScript, XSL, XML, WinCVS, FXCOP, Windows Service, Windows Server.
EDUCATIONAL QUALIFICATIONS
Examination
Board/University
Month /Year
Master of Computer Applications
Anna University
Apr / 2006
B.Sc.(Computer Science)
Manonmanium Sundaranar University
Apr / 2003
REFERENCES
Company
Reference
Location
McKesson Health Solutions
Timothy Bock
Development Manager
acuq4m@r.postjobfree.com
https://www.linkedin.com/in/timothybock
King of Prussia
PA
McKesson Health Solutions
Nandagopal Sivabakthan
Senior Software Developer
acuq4m@r.postjobfree.com
King of Prussia
PA
Corcentric
Leena Jain
Director of Software Development
acuq4m@r.postjobfree.com
Cherry Hill
NJ
Corcentric
Muthukannan Rajagopal
Senior Software Architect
acuq4m@r.postjobfree.com
https://www.linkedin.com/in/muthukannanrajagopal
Cherry Hill
NJ
Comcast
Dhanabal Samiappan
Manager
acuq4m@r.postjobfree.com
https://www.linkedin.com/in/dhanabal-samiappan-351a757
One Comcast Center
PA
Comcast
Tsatsu Maxwell
acuq4m@r.postjobfree.com
Boot Road,
West Chester PA
Contact this candidate