Software Engineer Sql Server
Resume:
MUHAMMAD YASIN
Apt ***,Coraopolis, Pennsylvania, 15108
***********@*****.***
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: *****.*****@**********.***
Cell: 412-***-****
Name: Steven Valetta
Organization: Giant Eagle
Designation: Senior Software Engineer
Email: ******.*******@**********.***
Cell: 412-***-****
Contact this candidate