Project Sql Server

Name: Atta ul Hyee

Email: **********@*****.***

Cell#: 647-***-****

Summary

Professional experience of software development and support within small and large companies that includes small, medium and enterprise applications.

Experience of working individually, within the teams as a team player and leading the projects. Always delivers the quality work/product. Take pride and ownership in work.

Continuous learner of software designs, processes and new technologies.

Specialties: Technical project lead, technical project tasks planning, application design and development, database designing, deployments and production support.

Professional Expertise

Technical Project Lead.

Requirements gathering and proposals

Correspondence/communication with business and clients

Project tasks planning and assignment

Software design & architecture

Software development

Database designing

Documentation

Deployments

Data migrations

Production support (problems solving, bug fixing, customization & enhancements in the applications)

Planning & Improvements.

Applications & Domains Experience

Purchase Orders

Inventory Control

Order Management System.

Client Billing/Invoicing (Receivable & Payable)

Payrolls

Applications for Sales and Marketing Departments

Applications for Customer Services Department

Rental Business

Courier & Cargo Services

Insurance & Underwriting Services

Appointment Booking

Database Management Utilities

Applications to transfer documents/files (XML, Text, ZIP & Recording) using FTP & SFTP

Technical Skills

Experience

.NET (C#)

Over 5 years

Visual Studio (2008, 2010, 2012, 2013, 2015)

Over 5 years

Asp .NET (MVC)

Over 5 years

Entity Framework

Over 5 years

Microsoft SQL Server 2008, 2012 & 2014 (Databases, SSRS, T-SQL)

Over 5 years

MySQL

Over 10 years

Visual FoxPro (programming & database) version 2.6, 3.0, 6,7,8 & 9

Over 10 years

ACCPAC Pro Framework

3 years

HTML 5

2 years

JavaScript

3 years

jQuery & AJAX

1 year

XML

Over 5 years

Bootstrap

6 months

WinScp & BizTalk (FTP & SFTP)

3 years

Microsoft Word, Excel, Access Database

Over 10 years

Automations with Excel & Outlook

Over 5 years

Integration (applications, 3rd party tools)

3 years

Professional Experience

Senior Programmer/Analyst January 2015-To date

BW Underwriting Services Inc. (leading Life Underwriting Services firm, provides services within Canada and USA)

http://bwunderwriting.com

Providing continues support that includes leading and helping junior developers, providing application architecture type of solutions, supporting existing applications and developing new modules/applications to support business needs using new technologies. Always provides smooth and high quality work from beginning to the end of the application development life-cycle.

Projects Detail:

Project 1(web application for managing documents)

Development tools used – Visual Studio 2015, C#, APS.NET MVC 5.0, Entity Framework 6, SQL Server 2014 & TFS.

Developed an application to provide interface for handling several types of documents (opening, copying, moving files based on business rules & validating several parts of the file name and its conventions).

Designed reports for the application.

Project 2 (Reports designing and development)

Development tools used – Visual Studio 2015 & SQL Server 2014

Team lead on this project.

Identified all the existing reports, letters & insurance forms from the legacy application and processes involved with those reports.

Created the project plan to redo all those in the newer technologies, prepared the tasks (such as designing reports to support multiple languages, queries, code etc.) to assign to the development team.

Put together the project structure and worked with the development team to create views & complex queries.

Worked with business analyst and the development team on daily basis using agile methodologies.

Maintained the project and its deliverable regularly.

Project 3 (Application Enhancements to have it run under the most recent operating system)

Development tools used – Visual FoxPro 9.0 & SQL Server 2012

Lead this project and the resources involved in the project.

This project was to modify very critical components of legacy application to work in the Windows 7 & Windows 10 environments.

Converted Visual FoxPro 7.0 application into Visual FoxPro 9.0 version.

This successful project helped and assured the company that they can upgrade IT infrastructure with the most recent hardware and operating systems (clients & servers sides – Win7 & Win10 on the clients)

Put together a complete project plan (identifying system components to be modified, development, testing, deployment/roll out).

Did research to get new tools and implemented those within legacy applications. Like PDF generation, email automation, faxes & reports output etc.

Many critical components of the system were modified and enhanced. These modifications were done in such a way that application can work under old and new environment/operating system so migration of client work stations to the new operating system can be done smoothly.

Deployed the application, its related tools and verified client machines. All the production deployment was highly accurate. No issue was found in the application and while it was running on the new hardware for all the users in the entire company.

Project 4 (XML data feed to client)

Development tools used - C#, Entity Framework 5.0, SQL Server 2012, SSRS, Visual Studio 2013 & TFS.

Worked and lead this project independently from beginning to its completion.

Collected all the requirements from the client and communicated with management, BAs & IT.

Provided the possible solution and detail design/architecture of the complex problem to the management.

Modified existing applications and databases.

Developed new application to implement the solution and sending data feed to the client in XML format. Validated the output XML with XSD type schema.

Used NLog for multiple (application log & database log) types of logging.

Programmer/Analyst February 2007-Dec 2014

Watermark Insurance Services Inc. (Watermark is the quality provider of insurance services across Canada)

http://www.watermarkinsurance.com

Projects Detail:

Project 1 (Web & Windows Services – back office)

Development tools used - C#, Asp.NET MVC 3, Entity Framework & SQL Server 2008.

One of the three members of a team to design and develop the application.

Involved in designing & modeling the solution to sync two databases that were different in design.

Wrote a window service to keep syncing the databases all the time.

Wrote a window service to work with internal system and for web service.

Developed a RESTFUL web service to accept the data in XML format to process it and then to generate the data into main system and send response back to the requester with confirmation. Also this service sends data back to the client on various events.

Project 2 (Redoing of Internal applications & website from legacy tools to new technologies)

Development tools used - C#, Asp.NET MVC 3, HTML 5, JavaScript, jQuery, CSS, Entity Framework, SQL Server 2012, SSRS, Visual Studio 2012 & TFS.

One of the three members of team to redesign and develop internal applications and website.

Gathered the complete requirements from the business.

Redesigned the database to give more flexibility in the system and to fulfill the new business requirements.

Developed website for clients to login, place their orders, check order statuses, upload and download various kinds of files based on their permissions.

Made the testing and rollout plan co-coordinating with business users.

Implemented data migration.

Design and developed more than a dozen reports.

Developed several parts of the application to package the documents into the zip files and deliver using SFTP to clients.

Project 3 (Ordering System)

Development tools used - Visual FoxPro 7.0, SQL Server 2008, SSRS, Visual Studio 2010 & TFS.

Desktop application that manages daily orders, services, invoicing, reports & client profile maintenance. Also consumes few services.

Created a very dynamic and efficient data access layer that made maintenance of the legacy system very easy down the road. Changed the entire back-end of this main application with SQL Server 2008.

Implemented data migration from old database to new database using scripts and coding. Consolidated couple of databases into one SQL Server database.

This application includes billing module (receivable & payable). Customization and enhancements were done in this billing module as well.

Designed & developed over 100 reports/questionnaires/Letters/Forms that various departments use on daily, weekly & monthly basis.

Developed & designed various user interface screens.

Developed a feature that generates documents and sends to the clients.

A feature was developed that integrates with the company’s phone system to auto dial from within the application.

Project 4 (Data Migration)

Databases involved in migration were Visual FoxPro 7.0 & 9.0, MySQL, MS ACCESS, SQL Server 2008 & 2012.

Identified the various data sources and categorized data for migration.

Performed data analysis and all the data sources to extract data.

Categorized data to make plan for migration.

Planed, architect and developed the application to migrate data from various sources (multiple databases) to the new database.

Wrote code and scripts to migrate data.

Provided data cleanup solutions to business users for migration process.

Project 5 (Electronic Funds Transfer – Integration with QuickBooks)

Development tools used - C#, Entity Framework, ADO.NET, SQL Server 2012, Visual FoxPro 7.0, QuickBooks, QODBC 3rd party driver for data connectivity, Visual Studio 2012 & TFS.

Lead the analysis and design phase of the project. Prepared detailed designed documentation.

Designed and developed a process and the application to integrate with QuickBooks database.

Prepared the documentation for business users to use the application with the implementation plan.

Enhanced the design of the existing database to generate and keep the history of payments.

The integration with 3rd party software and driver was implemented.

Developed various payment reports.

A feature was also developed to send payment statement to payees automatically.

Project 6(Various applications/services)

Development tools used - C#, Visual FoxPro7.0, Visual FoxPro 9.0, SQL Server 2008 & MySQL

Developed an application that downloads data & documents from web to the Ordering System. This application also generates documents after reading from database and sends reports electronically to various departments.

Developed an application to send data and files back & forth electronically from ordering system to the clients.

Developed an application to provide facility to the clients to send updates to their existing orders. And then sends statuses back to the clients electronically using ACORD Transactions which are the standard used by insurance companies across Canada.

Developed an application to keep syncing two different databases continuously. In result of this the other applications were able to access most recent data from the main system all the time.

Developed an application to provide updates related access of data to external clients.

Developed an application to update Ordering system automatically from other applications.

Wrote several stored procedures.

Designed and developed a process and the application to keep syncing data & documents among two office locations.

Developed an application that sends data/files to clients in various formats like XML, ZIP, DOC, XLS, PDF & TIF etc.

Developed an application that sends files after embedding in the final response.

Various reports were developed for clients by using Reporting tool.

Changed the backend database of several applications.

Project 7 (Web Portal)

Development tools used - Ruby & Rails, SQL Server 2008, MySQL & Visual FoxPro 9.0.

Implement business logic layer into web portal.

Implemented ACORD data standards in the application.

Wrote many unit tests.

Developed an application to update the main system from the portal.

IT Consultant September 2005 to December 2006

AbacuseConsulting (arguably the largest consulting company of its kind in Pakistan)

http://www.abacus-global.com

Project 1(ACCPAC Pro framework based application for rental business):

The development was done in an ERP system (ACCPAC Pro - Visual FoxPro code base) for an USA based client.

Several new screens were designed for managing and placing new orders.

Calendar ActiveX control was used on one of the major user interface screens to book appointments.

Enhancements were done in the user preferences interface in the application.

A feature was developed to read data from barcode scanner.

Worked extensively on SM (system management) module of this application. That includes enhancements & customization in user interface and DDL (data definitions language) routines. Also worked on the routines that had the functionality of database recovery and index fixes.

Several reports were designed for AR (accounts receivable) & AP (accounts payable) modules.

Software Developer January 2005 to September 2005

Blessings (a software company in Lahore, Pakistan)

Project 1(ACCPAC Pro 7.1):

The development was done in an ERP system (ACCPAC Pro 7.1 - Visual FoxPro 8.0 code base) for an industrial client.

The development, enhancements & customization was done in the following modules of ACCPAC.

Sale Order

Purchase Order

Inventory Control

General Ledger

Accounts Receivable

Accounts Payable

System Manager

Designed & developed several new reports in General Ledger, Accounts Receivable & Accounts Payable modules.

Enhancements and customization were done in user interface screens of Sale Order, Purchase Order & Inventory Control modules.

Project 2:

This project was developed to transfer data electronically from one office to another.

By using this project the head office was able to manage all inventory and accounting related data of the sub offices.

During data transferring the real inventory figures got updated in head office.

Programmer / IT In-charge February 2001 to December 2004

OCS (overseas courier service) Pakistan (Pvt.) Ltd

http://ocs.com.pk/

Development tools used in the following projects – FoxPro 2.0, Visual FoxPro 3.1, Visual FoxPro 6 and MySQL.

Project 1(Mail Tracking System):

Designed & developed the tracking system for the customer service department so they can promptly response to customer inquiries to locate shipments and statuses.

The users were able to update statuses and add comments for the shipments in the main system.

Project 2(mail/shipments pick up & delivery system):

Supported an application that handled outgoing, incoming mail & POD (proof of delivery).

Enhancements & customizations were done in several parts of the existing application. One of the important parts was to sync data between various locations across the country to make data entry of thousands of mail packets easily every day in main locations.

Several new user interface screens were designed & developed within the application for data entry.

Designed several reports that got used on daily, weekly & monthly basis.

Designed & developed many reports for outgoing & incoming mail for sub offices (branches).

Project 3(Cargo Shipments):

Developed the application to maintain all the cargo shipments.

Designed user interface to store shipment statuses & client’s information.

Designed and developed the cargo shipment invoicing reports.

Project 4(Couriers Incentive Sheet):

Developed this module to calculate couriers monthly incentive based on the amount of mail they have delivered.

This project provided the facility to store incentive rates per branch.

This project produced the summary & detail incentive sheet per courier.

And then at the end it produced files to send to the head office.

Project 5(Sale & Recovery System):

Designed and developed sale reports for branches & sales persons that were used on daily, weekly & monthly basis.

Designed and developed Aging & ledger reports.

Designed and developed monthly incentive report for sale persons.

Designed and developed monthly incentive report for employees of recovery department.

Project 6(Invoicing System):

Designed screens for data correction.

Implemented business rules within the existing application from time to time as required.

Developed invoicing reports for clients.

Automate the invoicing steps before applying monthly, quarterly or yearly rates into production.

Customized several reports.

Education

B.C.S (Bachelor’s of Computer Sciences)

University of South Asia

http://www.usa.edu.pk

Front end web development course (HTML 5, Java Script, jQuery, Ajax & CSS)

4 months course study within the group of developers and IT professionals.

ACORD Transactions & ACORD XML for Life Data Modeling Training

2 days training arranged by

CLIEDIS (Canadian life insurance standards association)

https://cliedis.ca

Agile Tour 2009

Attended 1 day conference that was arranged by

Toronto Agile Community

http://www.torontoagilecommunity.org

Continuously learning about new technologies and software processes mostly from http://www.pluralsight.com/ and Microsoft Virtual Academy.

Contact this candidate