Post Job Free

Resume

Sign in

Software Engineer Sql Server

Location:
Coraopolis, PA, 15108
Posted:
October 18, 2017

Contact this candidate

Resume:

MUHAMMAD YASIN

*** **** **

Apt ***,Coraopolis, Pennsylvania, 15108

609-***-****

ac2tbl@r.postjobfree.com

http://www.linkedin.com/in/muhyasin

PROFICIENCY

Microsoft Certified professional with 10+ years of proven hands on experience of leading, designing, developing and deploying Enterprise software applications.

Having good hands on experience on Microsoft BizTalk

Experienced as a Developer in BizTalk Server 2010/2013

Experience with B2B/EDI/WCF solutions using BizTalk Server

Strong experience in designing, documenting and implementing different BizTalk architectural components

Expertise includes Installation, Configuration and Customization of BizTalk Server 2010/2013

Implemented BizTalk custom adapters to access the ESB.

Experienced in developing custom pipelines and deploying Schemas, Orchestration and maps for BizTalk 2010/2013 solutions

Creating and Configuring BizTalk Schemas (XSD), Maps, Pipelines, Ports, Orchestrations and Custom BizTalk components.

Experienced in Configuration and Setup BizTalk 360

Experience in developing complex applications on Microsoft Dynamics CRM platform with customization of entities, sitemap writing client side JavaScript, Exposure in configuring and working with CRM plug-in

Strong Technical expertise in Web Technologies like Angular, MVC and APS.NET architecting multiple software frameworks using patterns like SPA, N-Tier and Domain Driven Design.

Diversified experience in the domains of Electronic Payment Solution Systems, Mortgage Systems, Tourism System and Telecommunication

Hands on experience in Windows Communication Foundation (WCF) and Web API for building service-oriented applications that communicate across the web and the enterprise.

Extensive experience in RDBMS Architecture, Model, Design & Development including SQL Server, T-SQL, Oracle, SQL, PL/SQL, MS SQL Server, SQL Navigator, Designer 2000 and Developer 2000.

Hands on experience with Crystal Reports, Integration Services (SSIS) and Reporting Services (SSRS).

Highly experienced in Object Oriented analysis and design (OOAD), Agile Development Methodology, Service Oriented Architecture (SOA),

Strong debugging skills in n-tiered ASP.Net/C# web application with Error Handling and troubleshoot production issues.

Proficient in writing stored procedures, Functions, Cursors, Packages, and Database Triggers using SQL Server2000/2005/2008/2012 and Oracle.

Toiled with diverse set of SDLC methodologies with hands-on extensive expertise with Waterfall and Agile/SCRUM models.

Strong Technical expertise in Web Technologies like Angular, MVC and APS.NET architecting multiple software frameworks using patterns like SPA, N-Tier and Domain Driven Design.

Diversified experience in the domains of Electronic Payment Solution Systems, Mortgage Systems, Tourism System and Telecommunication

Thorough understanding of the latest UI/UX tools and technologies, Angular, Bootstrap, HTML5/CSS3, jQuery/JavaScript to develop responsive web designs

TECHNICAL SKILLS

Enterprise Servers: BizTalk 2013/2010, Microsoft Dynamic CRM, ANTS Performance/Memory Profiler

Languages: C#, VB.Net, C, XML, UML, XAML, Sybase Power builder, VBScript.

Web Technologies: Single Page Application, AngularJS, .NET MVC, ASP.Net, JavaScript, jQuery, AJAX, ASP.Net Web API, WCF/Web Services, CSS/HTML

Tools & Frameworks: .NET Framework(4.5, 4.0, 3.5, 2.0), Entity Framework, N-hibernate, Microsoft Workflow Rule, TopLink, LINQ to SQL and LINQ to Entities, Microsoft Visio, ERWIN 4, TFS 2013/2010, SVN, VSS, TeamCity, MS Build

Database: SQL Server 2000/2005/2008/2012/2014, Oracle 10g

PROFESSIONAL EXPERIENCE

Lead/Senior Software Engineer, Creehan & Company, Pittsburgh, PA Dec’16 – Present

Creehan & company is the leading technology and services firm focused exclusively on the delivery of specialized Pharmacy models for over 25 years. The company provides technology management and hosting, commercial software, consulting and operational support services for specialty pharmacies, biotech pharmaceutical manufacturers and other healthcare organizations.

Project Title: ScriptMed PCI Compliance and Credit Card Tokenization

Responsibilities:

Design and development of WCF Services

Design and development of REST APIs

Integrated internal WCF service with UniPay (3rd party Service) and Application Interface

Application user interface development for Credit Card Tokenization

Peer Code Review

Environment: Visual Studio 2015, .Net 4.6, WCF, REST API, C#, Oracle, Soap UI, REST API

Project Title: ScriptMed Walgreens Performance

Responsibilities:

Analysis performance improvement areas.

Study the use cases provided by client (Walgreens)

Analysis and documented for the given use cases to fix application related performance issue.

Documented and presented the approach to team leads to fix the performance related issue.

Development according to the approach document

Analysis the performance pre and post change.

Environment: Visual Studio 2015, .Net 4.6, WinForms, Oracle, ANTS Performance Profiler 9, TFS 2015

BizTalk Architect, Giant Eagle. Pittsburgh, PA Aug’16 – Nov’16

Giant eagle have several vendors that required process the Order purchase and processing EDI 850 and 855 is being used to process the order and BizTalk 360 was used to configure and monitor the BizTalk services.

Project Title: Processing and Integration of EDI 850 and 855.

Responsibilities:

Designed and architect the BizTalk Orchestration.

Integrated the EDI 850 and 855 Schemas, Maps and Ports configurations.

Stabilized and provide production supports which reduced daily production issues count radically and allowed business user to perform day-to-day operations without any roadblock

Created WCF Web Services consuming BizTalk Orchestration to perform easy outbound and inbound operations. Implemented reusable BizTalk framework utilizing services and features such as Schema, Orchestrations, Maps, Functoids, etc.

Designed custom pipelines for the message transformation.

Designed orchestrations including Correlation and Retry Mechanism.

Configuration of BizTalk 360

Environment: visual Studio 2013, .Net 4.0, C#, BizTalk 2013 R2, BizTalk 360, Oracle

Lead/Senior BizTalk Developer, Heartland ECSI. Pittsburgh, PA Apr‘14 – July 16

Heartland ECSI is a leading provider of electronic payment solutions in the Higher Education market while its parent company, Heartland Payment Systems, processes more than 11 million transactions daily and supports more than 300,000 merchants worldwide.

Project Title: Heartland ECSI Payment Select System

Responsibilities:

Working as Client Consultant/Technical Lead to comprehend client’s requirements and to develop technical specifications document. Providing technical leadership to the offshore team to successfully develop the required business components and modules.

Designed and architect the BizTalk Application to Integrate system and provide

Integration of Payment Select Service to Banner (higher education ERP) system.

Develop a Single end point (SEP) WCF Service for payment Transaction that can easily by integrated to any third party application for payment process and can do the Data Post in HTML OR XML.

Develop a WCF Service that was used to perform the following highlighted functions: Process the Daily Scheduling payments of Students for both Credit Card and ACH, Creating a NACHA file and Send this file to Bank for Process, Send the Payment reminder emails to Students,

Stabilized and provide production supports which reduced daily production issues count radically and allowed business user to perform day-to-day operations without any roadblock

Applied Agile (SCRUM) practices to daily development including: Daily Scrums, Sprint Retrospectives, Sprint Planning, Sprint Demonstrations, Product Backlog/Story Estimation, Test-Driven Development, Iterative Development and Pair Programming.

Participating in designing of database using MS SQL Server. The database was designed as such so as to facilitate easy inclusion of new modules into the system.

Implemented AJAX and Bootstrap for better user experience and good performance.

Used Team Foundation Server (TFS) to manage changes to the source code.

Written JQuery for client side code to implement different functionalities in events, validations and listeners.

Environment: BizTalk Server 2010, .Net MVC, Microsoft SQL 2012, MSMQ, LDAP, N-hibernet, WCF Service, Java Script,, Team Foundation Server

Lead/Senior BizTalk Developer, Systems Limited. Karachi, Pakistan Sep 2012 – Mar 2014

Project Title: Bank Windhoek Phoenix BizTalk Server Integration

Responsibilities:

Worked as team lead and lead team of 4 developers.

Designed and developed Service Oriented Architecture (SOA) using BizTalk Server and WCF services which enabled easy communication with PhoenixXM

Created WCF Web Services consuming BizTalk Orchestration to perform easy outbound and inbound operations. Implemented reusable BizTalk framework utilizing services and features such as Schema, Orchestrations, Maps, Functoids, etc.

Designed custom pipelines for the message transformation.

Designed orchestrations including Correlation and Retry Mechanism.

Created Master XML Schemas.

Creating complex maps for vendor integration with Team members.

Used Health and Tracking Tool for the suspended messages and pulling the incoming XML based on the needs.

Involved in Web services testing using SoapUI tool.

Used BizTalk Administration Console for monitoring the message flows.

Analyzed, performed technical review and documented WCF services specifications for compressive migration from Web services to WCF.

Involved in requirement understanding and its transformation into technical implementation

Presentation and Trainings to give technical knowledge of frame work to team.

Held meetings and discussed business processes, user requirements and their implementation with client

Worked as liaison between quality assurance, business analysis and development teams.

Sprint Planning, Sprint Demonstrations, Product Backlog/Story Estimation, Test-Driven Development, and Iterative Development.

Environment: Microsoft BizTalk 2010, SQL 2008, .Net 4.0, Visual Studio 2010

Lead/Senior Software Engineer, Systems Limited. Karachi, Pakistan Aug 2011 – Aug 2012

Project Title: Dynamic CRM System Implementation for Dubai Telecom Regular Authority

Responsibilities:

Responsible for overseeing the company's requirements, development, testing and deployment of Microsoft CRM projects.

Customized Sale module and entities of leads, account, contact and opportunities according to the business process.

Created workflows based on requirements.

Used MS Dynamics CRM 2011 Customization tools to customize system components such as forms, views, attributes, relationships, and entity mappings.

Designed plug-ins to populate contact and account number on create of new record.

Customized sitemap for entity navigation for custom menus.

Responsible for solution management in enterprise environment.

Responsible for converting business requirements into technical requirements for development team.

Customizing and configuring CRM system at a user level.

Managed and responsible of the project delivery from start to end.

Designed and developed a multi lingual web portal using ASP.Net, jQuery, CSS/HTML which provided comprehensive integration with MS Dynamic CRM

Lead, mentored and trained resources on Dynamic CRM and provided technical supervision

Involved in requirement understanding and its transformation.

Work break down and assignment within the team. Managed quality and timeliness of the development.

Created technical specs with detailed flow diagrams

Environment: Microsoft Dynamics CRM 2013, Microsoft CRM SDK 2013, IIS 7.0, Aps.Net, jQuery, Java Script, CSS/HTML, SQL 2012

Project Title: Dynamic CRM Implementation for Event Management System (QTA)

Responsibilities:

Implementation of state of the art solution of Microsoft Dynamics CRM 2011 that enables QTA and its partners to use a single technology enabled platform.

Leading and/or participating in discovery analysis meetings with the client to understand current business processes that need to be incorporated into Dynamics CRM 2011.

Conduct detailed analysis sessions with end users.

Creating documentation to define workflow and requirements and implementing custom workflows into business process.

Designed and integrated ASP.NET front-end using WCF Web Services and LINQ, and implemented client side validations for Web-server controls. Extensively used .NET validation controls for Client side validations.

Wrote, debugged and deployed plug-ins in .Net

Integrated SQL Server 2008 with CRM using SQL Stored Procedures, Functions, Triggers, and Importing/Exporting data from legacy data sources using SSIS.

Developed Main view and Single view Dashboards as an extension of Dynamics CRM.

Same information used by multiple stake holders shared amongst them. This does remove redundant information entry.

System have complete security and access permissions control where information can be saved with desired access permissions and can be restricted to limited audience.

System delivered with a self-service Customer portal for Event registration.

Comprehensive reports and dashboards that help QTA to take informed decisions.

Analysis tools to analyze Event responses and their success.

Environment: Microsoft Dynamics CRM 2011, Microsoft CRM SDK 2011, ASP.NET, JQuery, Java Script, SQL Server 2008

Senior Software Engineer, Systems Limited. Karachi, Pakistan May ‘09 – Jul ‘11

Project Title: Certus Recording Calculator

Responsibilities:

Worked as a technical lead to supervise and manage team of 5 resources

Designed and development of a web application that provide intuitive UI

Developed web services using WCF to calculate the recording Fee and Tax and provide recording office locations.

Configured WCF service deployment on IIS on Amazon Cloud Instances for production service setup.

Used ASP.NET Validation Controls and developed JavaScript to perform various Client side validations. Implemented UI validation using JavaScript.

Used AJAX Toolkit to develop the controls.

ADO.Net Entity Framework - LINQ WCF Data Services – OData WCF RIA Services.

Developed Data Model Classes with LINQ to SQL and business rules that are implemented within model layer using C#.

Used XML extensively for data handling and rendering, XML serialization and parsing

Transformed data from one server to another using SSIS

Developed a Desktop Application that used Microsoft Window Workflow (WWF) Rule Engine that implements the formulas for Recording fee, Transfers and Mortgage tax and saved these formulas into Database.

Developed a framework that implements a web service that returned the calculation results to client.

Held meetings and discussed business processes, user requirements and their implementation with on-shore team.

Integrated Data Access and Exception Handling application blocks for database management and error handling.

Involved in integration testing of different modules.

Involved in documentation of sprint stories after getting requirement from client. Involved in the maintenance and enhancements of the system.

Provided full documentation of the enhancements. Involved in the maintenance and enhancements of the system.

Environment: Asp.Net, JQuery, Java Script, Amazon Cloud, AJAX, CSS, WWF Rule Engine

Project Title: Servicelink Vision Account System.

Responsibilities:

Involved in the process of requirement gatherings.

Involved in the Design and Implementation Process.

Developed New Screens and functionality using Sybase PowerBuilder 11.0

Developed web pages using JSP and flex framework

Involved in designing complete database objects like Tables, Views, Stored Procedures, and triggers using Oracle 10g.

Used Visual Source Safe to manage the source code

Involved in writing Java script functions for all validations.

Developed lots of reports for both Ad-Hoc and scheduled runs.

Deployed application on UAT and production servers.

Developed custom reports using Crystal Reports.

Train Junior Team members

Presentation and Trainings to give business domain knowledge to team

Technical specification and documentation

Software development/maintenance with SDLC, OOAD using UML

Environment: Adobe Flex 3.0, Java(J2EE 1.4),WebSphare, Toplink, Oracle 10g, Sybase PowerBuilder 11.0

Software Engineer, Systems Limited. Karachi, Pakistan Oct ‘06 – Apr ‘09

Project Title: BITB- Back in the Black (LandAmerica)

Responsibilities:

Involved in the process of requirement gatherings.

Involved in the Design and Implementation Process.

Developed ASP.Net web pages using C#

Involved in designing complete database objects like Tables, Views, Stored Procedures, and triggers using SQL server Worked on Reusable software components Design and Development

Developed .Net Components using C#.

Used Visual Source Safe to manage the source code

Involved in writing Java script functions for all validations.

Created DTS packages for data transformation process

Environment: Asp.Net 2.0, SQL 2005

Project Title: IndyMac Repurchase System

Responsibilities:

Involved in initial requirement gathering

It was 3-Tier Architecture web Application developed using ASP.NET

Worked in User Interface layer, Business Logic layer and also in the Data Access layer with the SQL Server.

Played an active role in analyzing, documenting and designing the application

Creating ASP.Net web pages using C#

Worked with Master Pages and Cascade style sheets (CSS) for the web pages.

Used VSS to manage the source code

Worked on Java Script for Client side Validation

Worked on Creating Web Services.

Wrote Stored Procedures, Functions and Triggers using SQL Server.

Worked on deploying the application on to development, staging and production servers.

Developed custom reports using SSRS.

Environment: Asp.Net 2.0, SQL 2000,MS reporting Services

EDUCATION

Bachelors of Science (BS), Computer Science July, 2006

CERTIFICATIONS

Microsoft® Certified Technology Specialist (MCTS): Microsoft BizTalk Windows® Server 2010

Microsoft Certified Professional: Developing Microsoft Azure and Web Services

Microsoft Specialist (Microsoft Dynamic CRM 2013 Applications)

KEY ACHIEVEMENTS

Proficient Excellency Award 2013 by Systems Limited

Outstanding Performance Award in 2009 by Systems Limited

Secured Third (3rd) position in the batch of BS (CS) University of Karachi

Secured First (1st) prize in Proquest ’03 Quiz competition, organized by ACM-CSKU chapter

Represented University of Karachi in different programming competitions

REFERENCES

Name: Roger Wolfe

Organization: Giant Eagle

Designation: Program Manager

Email: ac2tbl@r.postjobfree.com

Cell: 412-***-****

Name: Steven Valetta

Organization: Giant Eagle

Designation: Senior Software Engineer

Email: ac2tbl@r.postjobfree.com

Cell: 412-***-****



Contact this candidate