Email ID : ad0roy@r.postjobfree.com

Cell# : 313-***-**** / 519-***-****

Visa Status : TN1– Canadian Citizen - Valid till January-19-2025

US Evaluation : BACHELOR'S DEGREE IN COMPUTER INFORMATION SYSTEMS

Sponsorship Required: No – As a Canadian Citizen I can work for any US employer

Available for on-site work = Yes

EXPERIENCE SUMMARY

Has over 15+ years of experience in software analysis, design and development.

Over 14 years of software design and development experience using C#, VB.NET, ASP.NET Web Forms, JavaScript, ASP.NET Web API using .NET Core, Entity Framework, LINQ, SQL Server, MongoDB, ROBO3T, MS Access, Azure DevOps, Postman, Swagger and many other tools.

Extensive design and programming experience with front end technologies that includes HTML5, CSS3, JavaScript, jQuery, Angular JS and Bootstrap.

Over 10 years of experience with Data Manipulation, ETL and Report Development using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

Over 15 years of experience in writing complex T-SQL Scripts, Stored Procedures, Triggers, User Functions, Cursors, Views, CTEs and Joins.

Over 10 Years of experience in creating SSIS Packages with extensively used C# Script Task.

Over 10 years of experience in creating reports using SSRS, Crystal Reports and DevExpress reporting tools.

Expertise in cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.

Expertise in Object Relational Mapping (ORM) using ADO.NET, Entity Framework, LINQ and Lambda Expressions.

Expertise in implementing the S.O.L.I.D principles and different design patterns like Repository, Singleton and Factory design pattern.

Excellent interpersonal and communication skills.

QUALIFICATION

CERTIFICATION

Pitney Bowes, Austin, Taxes, USA

Project Name

: Shipment Manager / Return Center Applications

Role

: Software Engineer

Environment

: C#, VS Core 2019-2022, .Net Core, EF CORE, LINQ, ASP.NET CORE, Web API and SQL Server, MongoDB, Robo3t, Entity Framework, N-tier architectural design, Code-First approach, SSIS, SSRS, Jira, Confluence, Agile, Scrum, FileZilla, GIT, S3 Bucket, Sumo Logics, Team City, Azure DevOps CI/CD, Postman.

Duration

: March 2021 – Current

Description: Pitney Bowes is a global shipping and mailing company that provides technology, logistics, and financial services to more than 90 percent of the Fortune 500. Small business, retail, enterprise, and government clients around the world rely on Pitney Bowes to remove the complexity of sending mail and parcels.

Roles and Responsibilities:

Primary contribution is working on back-end and front-end development using ASP.Net Web Forms, M.V.C, C#, JavaScript, jQuery and Bootstrap to develop and maintain the Shipments and Returns system interfaces.

Used Repository pattern to interact with the databases. Implemented service layer to keep UI and database layers loosely coupled.

Worked on PB Order File Parser for parsing the Merchant order files uploaded to Amazon S3-Bucket.

Worked on REST based Return Label APIs using the .Net Core Web APIs, used Postman and Swagger for API testing. Managed Sumo Logs using Sumo queries to identify the reported issues.

Secured Rest Services using OAuth2(Authorization, Authorization).

Created API action methods using REST HTTP verbs such as GET, POST, PUT and Delete for CRUD operations.

Improved the performance by using the Asynchronous Programming and replaced the tightly coupled code with loosely coupled architecture by implementing the Dependency Injection.

Used LINQ and Lambda Expressions along with the Entity Framework for optimizing the searches and avoiding the roundtrips.

Wrote Units Tests using xUnit and Fluent Assertions.

Used MongoDB with Robo3T for managing the returns label API data.

Created database objects using SQL Server including complex SQL Statements, Joins, Stored Procedures, Triggers, Data Views, Cursors, CTEs and User Defined Functions to manipulate data on server side for better system control and improved performance. Used extensively T-SQL.

Helped Data Team members for debugging the Azure Functions and fixing the issues.

Participating in daily Scrum and weekly grooming meetings with Project manager and team lead to meet expectations and deadlines.

Using Source Control Migration from on-prem to GIT and integrating it with Azure DevOps.

Deploying Solutions using Azure DevOps and performing code reviews for the changes made by other team members.

Terumo Cardiovascular Group, Ann Arbor, MI, USA

Project Name

: NXGen Cardiovascular Console Application

Role

: Software Engineer / ETL Developer

Environment

: C#, C++, WPF, MVVM, VS.Net 2013-2015, .Net Core, C#, EF CORE, LINQ, ASP.NET CORE, MVC, React JS, NODE JS, Web API and SQL Server, Entity Framework, SharePoint 2013, N-tier architectural design, SQLite, MongoDB, Robo3t, Code-First approach, SSIS, SSRS, Agile, Scrum, FileZilla, GIT, Surround, Azure DevOps CI/CD, Postman.

Duration

: April 2019 – February-2021

Description: At Terumo Cardiovascular Group, we develop, manufacture and distribute medical devices for cardiac and vascular surgery with an emphasis on cardiopulmonary bypass, intra-operative monitoring and vascular grafting. This includes a full-line of perfusion products, endoscopic vessel harvesting products and surgical stabilization products. In addition, Terumo CV Group is the exclusive distributor of Vascutek® Vascular Grafts in the U.S.

Roles and Responsibilities:

Designed and developed Schema Helper for enabling the current NXGen Cardiovascular Console Application to work with different versions of databases without switching to different environments using VB.NET and Reflection.

Designed and Created Auto Anomaly Detection Tool for finding and fixing the EDMX related changes using code first approach.

Created Entity Framework Model Reader for NXGen IN-Memory databases. Using VB.NET and Reflection.

Created Data Migration Tool by implemented One-to-One mapping algorithm using C#.

Created Hash Schema Validator for validating the old and newer system schemas.

Developed NXGen Application Compatibility Checker and NXGen Pullbacks UI using WPF and MVVM.

Developed Equipment Ordering System using VB.NET, JavaScript, LINQ, ASP.NET Web Forms and SQL Server.

Used LINQ and Lambda Expressions along with the Entity Framework for optimizing the searches and avoiding the roundtrips.

Improved the performance by using the Asynchronous Programming and replaced the tightly coupled code with loosely coupled architecture by implementing the Dependency Injection.

Created Data Parsers for importing PMR (Patient Medical Record) Data from Lotus Notes to SQL Database using SSIS Script Task and VB.NET Generic Collections.

Wrote Units Tests using xUnit and Fluent Assertions.

Created database objects using SQL Server including complex SQL Statements, Joins, Stored Procedures, Triggers, Data Views, Cursors, CTEs and User Defined Functions to manipulate data on server side for better system control and improved performance. Used extensively T-SQL.

Developed Tabular Reports, Ad-hoc, Parameterized Reports, Drill down and Drill through Reports using Crystal Reports.

Optimized Queries and Procedures using SQL Profiler for better performance.

Used Azure DevOps for CI/CD, Backlogs and User Stories.

Used Surround, Confluence and JIRA for defining all Epics, User Sorties, Tasks and Subtasks.

Deploying Solutions using Azure DevOps and performed code reviews for the changes made by other team members.

Worked in Agile Environment with bi-weekly Sprint planning. Participated in Story Refinement meetings, Kanban Task Scheduling and Daily Standups.

ThyssenKrupp Material, Detroit, MI, USA

Project Name

: Warehouse Management/Billing System (WMS)

Role

: Senior Analyst Programmer

Environment

: C#, VB.NET, ASP.NET, VS.Net 201*-****-****, MVC 5, Dev Express Controls, VBA, Bootstrap, HTML, JavaScript, jQuery, Ajax, Web Services, REST, JSON, React JS, Python, LINQ, Visual Source Safe, Dev express toolkit, SQL SERVER 2008-2018, T-SQL, Oracle 11i, PL/SQL, XML, Crystal Report, SSRS, SSIS, TFS, Entity Framework, SharePoint 2013, N-tier architectural design, Jira, Confluence, Agile, Scrum, Slack, FileZilla, SoapUI, GIT, MS Azure.

Duration

: November 2014 to Date

Description: ThyssenKrupp is one of the world's largest steel producers, the company also provides components and systems for the automotive industry, elevators, escalators, material trading and industrial services. As of a 2009 reorganization,http://en.wikipedia.org/wiki/ThyssenKrupp it is structured into eight business areas that fall under two major divisions, Materials and Technologies.

Roles and Responsibilities:

Maintained existing Inventory and Scheduling applications written in VB 6.0, Class ASP and MS Access.

Migrated existing Inventory System from VB 6.0 to .NET Framework with implementation of N-tier architectural design using VB.NET, SQL Server and Object Relational Mapping (ORM) Entity Framework.

Created User and Client-Server Validation Controls using ASP.NET, VB.NET and JavaScript, participated in full development life-cycle using Object Oriented Design (OOD) concepts.

Created TKIS Custom/ Reusable Controls using VB.NET and Dev Express tools set.

Created File Parser to read 830, 862 and 997 EDI files with ability of auto create Jobs, Parts, Orders and Inventory

Counts using VB.NET.

Created Online Delivery Requests Calendar for 18 different DCs with the ability to accept/suspend/reject delivery requests and Lock/unlock trucks, using ASP.Net Web Forms, JavaScript, Angular JS and Web APIs.

Converted old TKE Elevator’s portal from Classic ASP to ASP.Net Webforms application using VB.NET, CSS and JavaScript.

Used ASP.NET Validation Controls and Client-side Java Script like JSON, External Java Script Libraries to perform front end validation at the browser level.

Implemented Client-Side Validations and Session Management using JavaScript Objects and XMLS.

Used AJAX Script Manager and Script Manager Proxy controls to register JavaScript and Web Services.

Used LINQ and Lambda Expressions along with the Entity Framework for optimizing the searches and avoiding the roundtrips.

Created ASP.NET Web APIs for sharing the data between different platforms. Created API action methods using REST HTTP verbs such as GET, POST, PUT and Delete for CRUD operations. Used Postman for API testing.

Wrote Units Tests using xUnit and Fluent Assertions.

Secured Rest Services using OAuth2(Authorization, Authorization).

Created Data model for a centralized data warehouse using ERWIN and Microsoft VIZIO.

Created Dynamic Stored Procedure using MERGE Statements to incrementally load data from multiple database servers to the centralized data warehouse.

Created Database Objects like Tables, SSIS Packages, Stored Procedures, Scalar/Table value Functions, Cursors, CTEs and Views to generate Dynamic Ad-Hoc Reports related to Inventory, Receiving/Shipping Orders, Online Delivery Schedules, Storage and Transportation Billing Charges for 18 Different DCs and Billing Department.

Designed SSIS Packages with For Each Loop Containers, Script Tasks using VB.NET and Emails notification service for dynamic data load from Orders/Parts CSV and Excel files received from factory and distribution centers to a central Inventory database.

Developed automated validation processes that generates discrepancies reports on the TKE portal after examining the data between the source and target systems.

Created MS Access VBA based reporting tools for frequently used reports by DCs.

Created self-managed processes for accounts department to handle billing adjustments and errors.

Created XML based processes to handle bulk data insertions with improved system performance and data accuracy.

Worked in Agile Environment with bi-weekly Sprint planning. Participating in Story Refinement meetings, Kanban Task Scheduling and Daily Standups.

Used Confluence and JIRA for defining all Epics, User Sorties, Tasks and Subtasks.

Maintained the physical database by monitoring Performance, Integrity and Optimized SQL Queries and Procedures for maximum efficiency using SQL Profiler.

Helped team in Migrating databases from SQL Server 2012 to 2014 by checking the dependencies like SQL agent Jobs and Linked Servers. Used Synonyms for DB-to-DB connections and data sharing. Worked on Database daily backup’s automation and recovery processes.

Created Power Shell Scripts for publishing the code to Staging and Production environments.

Reviewed code written by other programmers and proposed best practices.

Trained team of 3 programmers in OOPS, TKE Framework, Web Development and T-SQL.

PREVIOUS WORK EXPERIENCE

GM Motors, Detroit, MI, USA

Project Name

: LSA (Litigation Support Application)

Role

: Senior Analyst Programmer / Team Lead

Environment

: VB.NET, VS.Net 2008, Cold Fusion 9.0, HTML, SQL SERVER 2008, T-SQL, Oracle 11g, Toad, PL/SQL,

XML, Crystal Report, SSRS, SSIS, LINQ, Visual Source Safe, TFS.

Duration

: October 2013 to October 2014.

Description: General Motors Company, commonly known as GM, is an American multinational corporation headquartered in Detroit, Michigan, that designs, manufactures, markets and distributes vehicles and vehicle parts and sells financial services. General Motors produces vehicles in 37 countries under ten brands. Litigation support software (LSA) is designed to aid lawyers in the process of litigation and document review, and generally includes databases for organizing, searching, and reviewing discovery evidence and materials including deposition transcripts, produced documents, and correspondence.

Roles and Responsibilities:

Identified the client requirements by studying the functional and change set documents.

Participated in preparation of test data.

Identified test requirement and checked if the test cases were complete to test the business functionality.

Created new User Interfaces Using VB.NET, ASP.NET Web Forms and Cold Fusion 9.0.

Created Database Objects like Tables, Stored Procedures, Scalar/Table value Functions, Cursors, CTEs and Views

Issues. Extensively used PL/SQL and T-SQL.

Created SSIS packages to Import data from different data sources.

Created and updating new and existing reports using SSRS and Crystal Reports.

Attended weekly status meetings and provide detailed status report to the client.

In addition, role required managing a team of 6 developers and providing mentoring, training support and code review for other

Programmers using VB.Net and Oracle 11i.

Kinder Morgan, Houston, TX, USA

Project Name

: KMS Revenue Management System

Role

: .Net Analyst Programmer / Team Member

Environment

: C#, VB.NET, Visual Studio 2008, SQL Server 2008, T-SQL, Crystal Reports, Windows 2003, Agile, Jira.

Duration

: February 2013 to September 2013 (8 months contract)

Description: Kinder Morgan is the largest midstream and the third largest energy company (based on combined enterprise value) in North America. The main Objective of this application is to provide a GUI based interface for an easy and user-friendly access to the revenue reports.

Role and responsibilities:

Developing new user interfaces in existing application using VB.NET and SQL Server.

Designed and maintained of new and existing revenue reports using Crystal Report 11.0.

Designed Tables, SSIS Packages, Stored Procedures, Functions and Views to deliver snapshots of Report data every once in a week to the respective Business user's team.

Wrote and debugged new and existing Stored Procedures, Data Views and Functions to process the large XML data files

Passed to SQL Server for bulk data insertions. Extensively used T-SQL.

Maintained the physical database by monitoring Performance, Integrity and Optimized SQL Queries for maximum efficiency using SQL Profiler.

Developing new user interfaces in existing application using VS.Net 2008.

Using Power BI Desktop Connected to various Data Sources, worked with different Visualizations’.

Implemented several DAX functions for various fact Calculations for different data Visualizations in Power BI.

Created Power BI Reports by using joins in multiple tables from multiple data sources using complex SQL queries.

Worked in Agile Environment with bi-weekly Sprint planning. Participated in Story Refinement meetings, Kanban Task Scheduling and Daily Standups.

Used Confluence and JIRA for defining all Epics, User Sorties, Tasks and Subtasks.

Toronto French School, Toronto, ON, Canada

Project Name

: SBTMS (Students Biographical and Transcripts Management System)

Role

: .Net Analyst Programmer / Team Member

Environment

: ASP.NET, VB.NET, Visual Basic 6.0, Html, XML, JavaScript, jQuery, MS Access, Visual Studio 2008, SQL Server 2005/2008, T-SQL, Crystal Reports, SSR, SSIS, ETL, WCF Web service.

Duration

: November 2007 to August 2012

Description: TFS – Canada’s International School is a bilingual, coeducational and non-denominational independent school for students from age 2 to university entrance. SBTMS is designed to handle the students Enrollment, Attendance, Biographical, Academic and Exams information.

Role and Responsibilities:

Involve in object-oriented analysis and design using UML Unified Modeling Language such as use case, activity, sequence, class and component diagrams using Visio.

Designed back end using SQL Server 2008/2012.

Fixed and maintained the existing GHAdmin application written in MS Access 2003

Designed and developed Student Biographical Management, Mark Book, Teachers Online Attendance, Brevet Fiche, CAS

Management, IB University Management, Students Activity Enrollment, Online Students Lunch Menu System and Online Books

Sale Systems using VB.net Web Forms, ASP.Net and JavaScript, jQuery, WCF Web Services

Designed and developed Course manager to handle the student’s course changing requests using VB.net Web Forms, ASP.Net

and JavaScript.

Used ASP.NET Validation controls and Client-side Java Script like JSON, External Java Script Libraries to perform front end validation at the browser level.

Used AJAX Script Manager and Script Manager Proxy controls to register JavaScript and Web Service files.

Involved in handling ASP.NET client-side state management (View State, Cookies and Query Strings) and server-side state management (Application State and Session State).

Worked extensively on creating WCF Services for gateways, by creating Service Contracts, Data Contracts, Message Contracts and hosting them on IIS.

Wrote complex SQL Statements, Stored procedures, Triggers, Data Views and Functions to manipulate data on server side for better system control and improved performance. Used extensively T-SQL.

Used DTS (Data Transformation Services) and SSIS (SQL Server Integration Services) to create ETL packages to validate, Extract, Transform and Load data.

Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.

Designed new ETL Processes with complex Stored Procedures and Scalar/Tables value Functions to generate Dynamic Ad-Hoc Reports related to Students Courses, OUAC and Marking.

Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS (SQL Reporting services) and Crystal Report.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Involved in GUI Testing, Functional Testing and Regression Testing.

Wrote user manuals and trained system users

Provided support on all in house existing and newly developed applications

Anatolia Tile Inc., ON, Canada

Project Name

: ACOMS (Anatolia Custom Order Management System)

Role

: .Net Analyst Programmer / Team Member

Environment

: ASP.NET, VB.NET, Visual Basic 6.0, Html, XML, Java Script, MS Access, Visual Studio 2008, SQL Server, T-SQL, Crystal Reports, SSR, SSIS, ETL

Duration

: Aug 2006 to October 2007

Description: Anatolia Tile Ltd is one of Canada's largest importers and distributors of tiles across United States and Canada. ACOMS is a Warehouse management system which provides Graphical User interface for Inventory, PO, Customers, Orders, Shipments, and Accounts receivable management.

Role and Responsibilities:

Designed back ends using SQL Server 2005

Developed System Generation, Data Generation, General task management, Pattern management, Custom Ordering, PO

Receiving back ordering, Products, Vendors, Contacts list and Stock status forms using VB 6.0.

Designed and developed Secured login methodology at Module/System level. Created all required forms to enforce the

Secured logins within the system.

Wrote services to create the Outbound PO files in Microsoft Word (.doc) and Acrobat (.pdf) format with automatic email

Notification features using VB.NET Win Forms and Microsoft Outlook.

Wrote complex Stored Procedures, Triggers, Functions and DTS (Data Transformation Services) using SQL Server 2005.

Provided support on all in house existing applications and newly developed applications.

Wrote user manuals and trained system users

Other Projects:

Department of Energy, Alberta, Canada: Sep 2012 to January 2013

Anatolia Tile Inc., ON, Canada: Aug 2006 to October 2007

Punjab Irrigation and Drainage Authority – Government of Punjab – Pakistan: Mar 2001 to Jun 2005

Areas of Experience

Industries

Health Insurance

Automotive

Oil & Gas / Government

Education

Warehousing / Manufacturing

Applications

Litigation Support Application

EDI / ETL / IPAAS Systems

Healthcare Rules Engine

Alberta Minerals information System

SBTMS

Online Scheduling System for Logistics

POS/Inventory/PO

RDBMS

MS SQL Server 2000/2005/2008

Microsoft Access

DBASE III+/FoxPro 2.6

Pervasive 8.0

Oracle 6.0/11i / Toad/PL SQL

Operating Systems

Windows 98/NT/XP Windows Server

Development Tools

SQL Server 2008 R2/2012, MS SSIS, SSRS, SSAS.

VB.NET, C#, ASP.NET, MVC 4.0, Cold Fusion 9.0, COBOL

Visual Basic 5.0/6.0, Silverlight, C/C++, Dev-Express Controls, Bootstrap

HTML, CSS, AJAX, JavaScript, jQuery, Ajax, T-SQL, LINQ, Entity Framework, LINQ, WCF, REST, JSON.

Windows Services, Web Services

Reporting Tools

SSRS, SSIS, ETL

Crystal reports

Microsoft Access

Source Safe Tools

VSS

TFS

GIT

Web Hosting

Internet Information Services (IIS)

MS Azure

Degree

Institute

Year

Master of Computer Sciences

University of South Asia (NCCS)-Lahore-Pakistan

1999

Diploma In Computer Applications

Allama Iqbal Open University-Islamabad-Pakistan

1995

Bachelors of Science

The University of Punjab-Lahore-Pakistan

1994

Certification

Institute

Year

Visual Basic 6.0

Brain Bench

2000

SQL / HTML 3.2

Brain Bench

2000

Windows NT Workstation

Brain Bench

2000

Contact this candidate