Sql Server Management

Address : **** ******** ********, *******, **, N*G 0A5, Canada

Email ID : acy3ic@r.postjobfree.com

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

Citizenship : Canadian

Visa Status : TN1 Sponsorship Required For Jobs in U.S.A

Synopsis: 15+ years of experience in analysis, design and development of client/server, web based and n-tier application. Expert in developing windows applications, web applications, windows services and web services in Microsoft Visual Studio .Net IDE.

EXPERIENCE SUMMARY

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

Over 12 years of software design and development experience using .NET technologies.

Extensive expertise in developing Client-Server as well as Web based applications.

Over 15 years of experience in writing complex T-SQL Scripts, Stored Procedures, Triggers, Inline / Table value functions and Views.

Over 10 years of experience in creating and scheduling SQL Jobs along with automated processes.

Over 7 Years of experience in creating SSIS Packages with extensively used Script task component and C#.

Over 7 Years of experience in creating reports using SSRS and Crystal Reports.

Expertise in database, web servers and application servers.

Excellent interpersonal and communication skills.

Self-motivated and an able team player.

Flexible enough to adapt new environments.

Sound knowledge in analysis of functional issues.

QUALIFICATION

CERTIFICATION

Thyssenkrupp Materials, Detroit, MI, USA

Project Name

: Warehouse Management System

Role

: Senior .Net Analyst Developer

Environment

: VB.NET, C#, VS.Net 201*-****-****, DevExpress Controls, VBA, Bootstrap, HTML, JavaScript, JQuery, Ajax, Web Services, REST, JSON, LINQ, Visual Source Safe, Dev express toolkit, SQL SERVER 2008-2014, T-SQL, XML, Crystal Report, SSRS, SSIS, TFS, Entity Framework, N-tier architectural design, Agile Development Practices.

Duration

: November 2014 to Date

Description: ThyssenKrupp is one of the world's largest steel producer, 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 and Class ASP.

Re-wrote existing Inventory System from VB 6.0 to .net Framework with implementation of n-tier architecture using VB.net and SQL Server.

Worked on TKIS Custom/ Reusable Controls building layer using VB.Net and Dev Express tools set.

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

Counts for Storage Billing and notification services to DC.

Created Online Delivery Requests Calendar for 18 different DCs with ability to accept/suspend/reject delivery requests,

Lock/unlock trucks and Units tracking using ASP.Net, Web Forms, JavaScript, JQuery, Ajax, Web Services, REST and JSON.

Created Storage and Transportation billing processes to automatically calculate the charges based on storage and

Transportation services provided by DCs.

Converted old TKE Elevator’s portal from classic ASP to .Net framework using ASP.net, C#, CSS, JavaScript, Ajax, and JQuery.

Created self-managed PC Miler Object with ability to map the truck routes and calculate the mileage charges for single stop or multi-stop deliveries using C#.

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

Generated T-SQL Scripts to Create Schemas, Tables and Views for the Centralized Data Warehouse.

Used Import/Export Wizard to generate SSIS packages that migrates data from various sources to a Staging Database.

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

Rationalized the existing SSIS Packages and other ETL Processes to improve performance and maintain data quality.

Cleaned and normalized data within the other relational database systems and generated new Report Models to improve user interactivity and selectivity.

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

Created and scheduled nightly, weekly and monthly SQL Jobs to run different SSIS Package and Stored Procedures to extract data from the source systems and load it into the new Data warehouse management system.

Developed new SSRS Reports for Back Office Users and integrated those with the company's Portal.

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.

Designed new ETL Processes with Complex Stored Procedures and Scalar/Tables valued Functions 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 C# 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 testing process that validates data between the source and target systems and generates Discrepancies reports on the portal.

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

Created self-managed processes for accounts department to handle billing adjustments without calling I.T.

Created and deployed Data Cubes for higher management to view and analyze parts data.

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

Investigated Issues and proposed permanent solutions for the found problems to other team members.

Identified problems and formulated alternative solutions. Provided assistance for integration of Front end and Back end application.

Selected and implemented Agile Development Practices according to the application requirements for every project.

Maintained project schedules and tasks. Tested and troubleshooted all applications, websites and procedures.

Maintained the physical database by monitoring Performance, Integrity and Optimized SQL Queries 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. Analyzed targeted Servers disk size, Compatibility, Data and Log files location. Worked on Database daily backup’s automation and recovery processes.

Reviewed code written by other programmers and proposed best practices

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

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

Programmers using .Net and SQL Server. Supported all in house applications.

Attending weekly status meetings.

PREVIOUS WORK EXPERIENCE

GM Motors, Detroit, MI, USA

Project Name

: LSA (Litigation Support Application)

Role

: Senior .NET Developer / 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 C#, VB.net, ASP.net and Cold Fusion 9.0.

Wrote new and debugged existing Stored Procedures, Data Views and Functions for notified functional and performance

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 .Net and Oracle 11i.

Kinder Morgan, Houston, TX, USA

Project Name

:KMS Revenue Management System

Role

:.NET Developer / Team Member

Environment

:VB.NET, C#, Visual Studio 2008, SQL Server 2008, T-SQL, Crystal Reports, Windows 2003, 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:

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

Supporting existing in-house applications

Attended daily and weekly status meetings.

Department of Energy, Alberta, Canada

Project Name

: MIDAS, ABMARS, AMI (Alberta Minerals Information System)

Role

: C# Systems Analyst / Team Member

Environment

: C#, VB.NET, Visual Studio 2008, SQL Server 2008, T-SQL,SSR, SSIS, ETL, LINQ, Entity, Framework, DOE Framework,TFS

Duration

: SEP 2012 to January 2013

Description: Alberta is a global energy leader, recognized as a responsible world-class energy supplier, an energy technology champion, a sophisticated energy consumer and a solid global environmental citizen. AMI (Alberta Minerals Information system) typically handles Land Permits, Contracts, Lease terms and Land exploration information.

Role and Responsibilities:

Added new features to AMI (Alberta Minerals Information System) system using C#.

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

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

Created complete system study document and DFD’s for future conversion of AMBARS and MIDAS applications to .NET framework.

Created Flow-charts for existing Procedures with the aim of providing easy fix methodology to other team members.

Provided full support on MIDAS and ABMARS Assessments/Permits management systems.

Provided full support on AMI (DOE’s largest system). Day to day tasks included the Integration and unit testing of DI’s along with the fixing of the DI's.

Used SharePoint 2012 to collect, communicate and collaborate data between different team members and organizational units.

Toronto French School, Toronto, ON, Canada

Role

: NET Developer / Team Member

Project Name

: SBTMS (Students Biographical and Transcripts Management System )

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:

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.

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 (.dtsx files) 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 valued 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 Developer / Team Member

Environment

: ASP.NET, VB.NET, Visual Basic 6.0, Html, XML, Java Script, MS Access, Visual Studio 2008, SQL Server 2005/2008, 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

Korson Furniture Imports Ltd. Woodbridge, ON

Project Name

: KCOMS (Korson Custom Order Management System)

Role

: .IT Support Specialist / Programmer

Environment

: Visual Basic 6.0, VB.NET, Pervasive SQL, SQL Server 2005, Crystal Reports 9, Windows XP

Duration

: Nov 2005 to Aug 2006

Description: Korson Furniture is a Canadian Manufacturer and importer of select European period reproduction. KCOMS 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, and 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.

Wrote user manuals and trained system users

Project Name

: EDI Management System

Role

: Application Developer (Part Time - Contract)

Environment

: C#, Visual Basic 6.0, Microsoft Access 2000, Crystal Reports 9, Microsoft Visio, Windows XP

Duration

: Sep 2005 to Aug 2006

EDI Commerce Inc., Mississauga, On, Canada

Role and Responsibilities:

Fixed and maintained the existing EDI Software.

Maintained existing EDI Commerce application written in Visual Basic 6.0.

Designed and developed EDI Loader, XML Builder, PO Exporter, ASCII File reader using C# Win forms.

Designed and developed FTP Client application to upload and download EDI data files from different ftp sites using C# Win forms.

Punjab Irrigation and Drainage Authority – Government of Punjab – Pakistan

Project Name

: MIS (Management Information System)

Role

: Senior Programmer / Systems Analyst (BPS-18)

Environment

: C#, ASP.NET, ADO.NET, Visual Basic 6.0, XML, XSLT, SQL Server 2000, Case, SQL ANSI, T-SQL,

Java, J#, Oracle, ER-Win, Visio, Rational Rose, Crystal Report 8.0, Oracle 9i, PL/SQL

Duration

: Mar 2001 to Jun 2005

Description: Punjab Irrigation & Drainage Authority (PIDA) has been set up through an enactment in 1997 at provincial level with representation of farmers. Likewise, Area Water Boards (AWB) at each canal command and Farmer Organizations (FOs) at distributary level have been constituted

Role and Responsibilities:

Designed and Implemented the GUI Using Visual Basic 6.0 and C#.

Designed databases using SQL Server 2000.

Designed and Developed Chart of Accounts, Organizational Chart, Accounts Association, Voucher book, Accounts Check Digit

System to avoid the possible user mistake and all other forms using Visual Basic 6.0.

Created automatic Vouchers opening, Closing and Canceling Techniques based on different criteria’s like daily, weekly and

Monthly using C# win forms.

Developed and integrated Departmental Vehicle's management module using C# Win Forms.

Designed and developed Employee's Biographical, Employee's payroll systems using C# Win Forms.

Designed and Developed Employee Registration, Allowances, Personal Details, Loan handling, Departmental/Sectional Information, Leave analysis modules using C# Win Forms.

Developed Employees Salary slips, Disbursement vouchers, Salaries detail analysis, Leave history, Employee's monthly,

Annually, and seasonally salary analysis, Loan and all other reports using Crystal Report 8.0.

Designed and developed complex reports like Chart for Accounts, Organizational Chart, Ledger, Trial Balance, Balance sheets,

Income Statement, Cash Flow Statement, Bank reconciliation statement, Transaction edit list, Budget Utilization and many other

Types of reports using Crystal Report 8.0.

Wrote Stored Procedures, Triggers and database Functions using T-SQL.

Developed Software installation Package and user manuals.

Provided Software support and user training.

Wrote complex SQL Queries using Joins and sub-queries.

Developed Software installation Package and User manuals.

Provided full Software support and user training

Contact this candidate