Post Job Free

Resume

Sign in

Sql Server Software Engineer

Location:
Pittsburgh, PA
Posted:
April 27, 2016

Contact this candidate

Resume:

Mahinder

For Corp to Crop acui9c@r.postjobfree.com

Microsoft Certified/ Oracle Certified/ Sitecore CEP 7.0 Certified

Professional Summary:

9+ years of experience in design, development, testing and documentation of Enterprise applications using Microsoft technologies.

Microsoft Certified Professional with experience in developing solutions using .NET & MSBI platform

Functional domain experience in Finance, having 4 years of experience in HealthCare and HL7.

Developed Web Applications and Windows Applications using .NET Framework, C#/VB/ASP.NET, ADO.NET, XML Web Services, REST, SOAP, WCF, WPF, Kentico CMS, Silverlight, AJAX with SQL Server 2005/2000 & IIS 6.0, MVC 4, Entity Framework, Crystal Report, SAP Business Object, SunGard, Rules Engine, NextGen HER, SSRS, SSIS and SSAS, Sitecore.

Developed Web Applications and Windows Applications using .NET Framework, C#/VB/ASP.NET, ADO.NET, XML Web Services, REST, SOAP, WCF, WPF, Kentico CMS, Silverlight, AJAX with SQL Server 2005/2000/2012 & IIS 6.0, MVC 4, Entity Framework, Crystal Report, SAP Business Object, SunGard, Rules Engine, NextGen EHR, SSRS, SSIS and SSAS, Sitecore

Developing .NET Applications on Microsoft SQL Server 2000 /2005 and Oracle 10g, on Windows 2000/2003

Developed BI cubes and dashboards using SSRS and SSAS

Experience in Project Monitoring, Planning and Managing Deliverables

Technical Competencies

●Languages: C#.net, VB.net

●Frameworks: Visual studio, .NET 1.0, 1.1, 2.0, 3.5,4.0

●Client Programming: HTML, DHTML, ASP.Net, And AJAX,CSHTML, Kentico CMS,Sitecore, Java Script, VB Script

●Database: MS SQL SERVER 7.0/2000/2005, PL/SQL, XML, LINQ, Oracle

●Build Tools: TDS,GlassMapper

●Web Services: SOAP and RESTful Services

●Application Servers: SVN or Subversion, VSS

●Operating system: Windows and Linux

●Reporting Tool: (SSRS, SSAS,SSIS), Crystal Reports,Business Object

●Web Analytics: Google Analytics API

Professional Certification:

MCP Certified

Oracle PL /SQL Certification

Sitecore CEP 7.0

Professional Experience

Mylan Pharmaceutical Aug 2014 – Present

Sr. .Net developer/ Sitecore Developer Pittsburgh, PA

Mylan one of the world’s leading generics and specialty pharmaceutical companies, with sales in approximately 140 countries and territories. And our dedication to providing access to medicine continues to grow after more than 50 years.

Recently delivered 20 websites e.g. http://mylan.com/, http://epipen.com/

Tasks accomplished on the Project:

●Development of .net products and requirement gathering.

●Development of New components MVC4.0 and HTML 5

●Developing WCF for Global Registration.

●Project Environment Setup Visual Studio and TFS.

●Migration of framework.

●Develop modules and handling web API

●Updated and delivered more than 20 Websites based on .net/ Sitecore

●Extensive worked on MVC 3.0/4.0 and Sitecore 7.0 to upgrade and develop new components as per need.

Environment: C#,MVC 4, Sitecore 7.1, TDS, TFS, Glass Mapper, MVC 4, Google Analytics API, Sql Server 2012

Lajolla – BI Reporting April 2014- Aug 2014

Sr. Software Engineer San Ramon, CA

La Jolla Group, Inc. (“LJG”) is the world’s premier multi-brand apparel licensing company, with a portfolio of prominent brands including O’Neill Clothing USA, Metal Mulisha Clothing and FMF Clothing.

Tasks accomplished on the Project:

Developed .NET based utility to fetch data from three databases (i.e. ProvideX, Oracle and MSSQL) and upload the integrated data to Hubsoft System automatically.

Developed complex click through dashboards using SSRS. The dashboards contained sales data which is extracted from multiple databases and then emailed to defined set of users on daily basis.

Developed gross profit dashboard for all product sales based on data fetched from multiple data sources

Environment: ASP. NET 4.0, MVC 4, REST, SOAP, SQL server 2008 R2, Hub soft API, SSRS,SSIS, SSAS, Oracle and ProvideX

CAN Capital Feb 2014 to April -2014

Sr. Software Engineer/Tech lead

CAN Capital, Inc.is the pioneer and market share leader in alternative small business finance, having provided access to $4 billion in capital for tens of thousands of small businesses in a wide range of locations and different business types.

Tasks accomplished on the Project:

Enhanced New PQ Reports performance by creating & fetching report data from Cubes

Developed report based on data from Cubes and database to allow risk team to perform analysis on Non Performing Merchants

Reviewed & analyzed the PQ reports as developed by the team

Learned the E2E merchant funding flow using CAPTAP

Environment: SQL Server 2008 R2,SSIS, SSAS, SAS, MS- Excel, MS-Access, .NET Framework, Kentico, Sitecore.

MdBackline June 2013- to Feb 2014

Sr Software Engineer/Tech Lead Princeton, NJ

MDbackline is a web application that is triggers a survey as a follow up to the treatment provided by the doctor to his/her patients. MDbackline contacts the patient by email at an appropriate time and asks the patient to take to a survey. While collecting information about a patient’s health status, MDbackline also shares pertinent health information with the patient, based on the patient’s answers to survey questions.

Tasks accomplished on the Project:

Designed and developed the application Database.

Designed the data templates in NextGen EHR (Electronic Health Record) system

Integrated MDBackline with client’s NextGen EHR system

Environment: ASP. NET 4.0, Sitecore, MVC 3, Entity Framework, SQL server 2008 R2, NextGen EHR

Bank of The West (Trantor Inc.) Sep 2012 to May,2013

Sr. Software Engineer San Ramon, CA

Vendor Risk Assessment:

Vendor risk management (VRM) is a comprehensive plan for identifying and decreasing potential business uncertainties and legal liabilities regarding the hiring of 3rd party vendors for information technology (IT) products and services. In Phase 2 Vendor Risk Assessment Survey Internal Review tool for Vendor Survey Generate Report with vendor risk rating and send email notification and request BU to review,Vendor Management team receives notification of survey submission by vendor, BUCO’s team receives Email notification requesting review,Review and closure of survey where all sections are indicated Satisfactory. Its an UI application build in vb6 and remediated to .net 4.5 framework and Sql server 2012 as database to store different trade messages. This asset triggers connectivity between SunGard Servers to exchange Trade messages, whenever a Trade hits Messaging Queue Installed on App server. Apart from MQ it also has MFT and TWS jobs.

Module: BIA, Vendor Assessment, Risk Assessment, Disaster Recovery

Tasks accomplished on the Project:

Design the E2E architecture of the application

Developed and maintained the project plan during the course of development of the project.

Integration with Sungard APS

Developed batch parser to trigger connectivity between SunGard Servers to exchange Trade messages

Risk Investment utility using Sungard tool

Developed COP documents related to the project

Coordinated UAT of the project with business users

Environment: ASP. NET 3.5, SQL server 2008 R2, Crystal Report 13, SAP Business Object, SunGard

Safaltek Software Pvt. Ltd. May 2006 – July 2012

Project: Ocean Manager Feb 2012 to Sep 2012

Tech Lead/Team Lead Noida

Ocean Manager is an online ship management software or marine product designed to meet all Quality, Health, Safety and Environment element of a ship management or a ship ownership company to enhance safety and reduce risk in shore to ship or ship to shore operations. Worked on various modules like Audit System, Vessel Tracker (Google maps), Risk management system etc.

Tasks accomplished on the Project:

Design the DB and framework of the assigned modules

Developed and maintained the project plan during the course of development of the project.

Managed the team of 8 resources

Performed code reviews of the development completed by the team members

Managed the client & stakeholders expectations

Medicity Jan 2008 to Jan 2012

Sr. Software Engineer Saltlake City, Utah

Interface is an integration framework comprised of a collection of technologies which form a middleware to enable integration of systems and applications across enterprise.

The framework accepts HL7 data from different TCP/ICP client and goes through the process of validation, transformation to be feed into database to maintain patient’s health record.

Tasks accomplished on the Project:

Requirement analysis and prioritization

Interacted with onsite stakeholders and helped the business users in defining the system requirements

Prepared effort estimation, Release plan, Review documents.

Designed the application backend

Contributed in managing project documentation as per defined ISO process

Coordinated the UAT with business users

Environment: ASP. NET 2.0, ADO. Net, C#.Net 2.0, REST,SOAP, MS-SQL server 2005, Web Services

ProAccess Aug 2008 to Jan 2009

Team Lead Chandigarh

ProAccess Care Collaboration Platform enables physicians, hospitals and HIE’s to:

Access clinical information stored in disparate systems across care locations

Distribute and exchange relevant information to constituents involved in delivering patient care

Collaborate and share information among all members of a patient’s care team

Tasks accomplished on the Project:

Performed requirement analysis and involved in GUI designing of the application

Responsible in implementing the system using .NET, ADO.NET and writing Stored Procedures in SQL Server

Responsible for analysis of other products and implementation of enhancements in the application

Coordinating with the team on various different tasks and delivered weekly progress reports for effective monitoring of the project

Environment: ASP.NET 2.0, ADO. Net, C#.Net 2.0, MS-SQL server 2005, Web Services

NEQCA - New England Quality Care Alliance

Software Engineer Jan 2006 to July 2008

Chandigarh

New England Quality Care Alliance is an independent network of over 160 primary care physicians and over 650 specialists throughout Eastern Massachusetts. A provider can create own site according to selected web templates.

Tasks accomplished on the Project:

Requirement gathering and analysis

Implementing the system using C#.NET, XML, ADO.NET and writing Stored Procedures in SQL

Collecting requirements on daily basis from client and coordinating with onsite team

Performed unit testing of the code developed

Environment: Asp.net (VB),SQL Server 2000, Kentico and SSRS

Educational Qualification:

Masters of Science from Kurukshetra University, Haryana, India



Contact this candidate