Sql Server Maintenance

RESUME

Zainul Abideen Liaqat Husain ***–***-****(mobile)

*** ***** ***** ******, ******* Square, PA 19348 ********@*****.***

Profile:

• Experience of designing and developing Client/Server and Web based applications

• Experience of developing applications using ASP.NET, C#, VB.NET, SSRS, SSIS, Crystal Report, Report Builder 3.0,

PowerBuilder 6.5/7.0

• Experience of designing database, developing Stored Procedures, Views, Triggers, UDF and Queries using T-SQL.

• Experience in developing Web Services, MSMQ and XML based applications.

• Knowledge of building Mobile application using HTML 5 and jQuery Mobile.

• Hands on experience in gathering, analyzing and documenting business requirements

• Design and develop applications, based on 2-Tier and 3-Tier architecture.

• Design and develop Logical and Physical Database model for database development using Erwin 3.5.2.

• Develop Use Case/Use Case Description and create technical specification document.

• Experience in providing implementation and maintenance support.

• Experience of managing onsite and off-shore project.

• Experience of developing application in UNIX & C environment using Unify 3.2 and Unix Shell

• Experience of building application on IBM AS/400 (RPG/COBOL/CL/RDL)

Certification:

• Microsoft Exam 70-480: Programming in HTML5 with JavaScript and CSS3.

• MCAD (Microsoft Certified Application Developer, Web Applications using VB.NET)

• Brain Bench: Active Server Pages, PowerBuilder 7.0.

• Computer Society of India: National Test in Programming (COBOL)

• Computer Maintenance Corporation Limited: Competence in Programming (COBOL, BASIC)

Training:

• Development of Business Intelligence application at Microsoft Training Center, Malvern PA

• Certificates in Business Analysis and HTML5 & jQuery mobile.

Technical Skills:

Operating Systems Windows NT/2000/ XP/7, OS/400, UNIX System V

Programming Language/Utilities ASP.NET,C#, PowerBuilder 6.5/7.0 with PFC, VB.NET, VB 6, ASP, JavaScript, CSS,

XML, XSD, MSMQ, Crystal Report, SQL Reporting Services, Report Builder 3.0,

jQuery, HTML 5

Data Modeling Tools ER-Win 3.5, Visio 2000

Databases SQL Server 2005/2008, Oracle 7.0/8i/10g, Unify 4.0

Other Technologies UNIX System V, Shell Programming, RPG/400, COBOL/400, CL/400, SQL/400, C

Work Experience:

PSCI, Wilmington, DE Jul 14 – Current

Lead Developer for CSC, Wilmington DE

Corporate Service Corporation is a provider of legal and financial services to US and International Companies. There are several Web

based internal and client facing applications support the business. Back office applications also support the main application.

Role & Responsibilities:

• Attend tickets created for various applications to analyze and fix the defect.

• Attend daily stand-up and sprint review meeting to update status of the development.

• Create/support application for back office/ maintenance operations.

• Enhance or fix web page/web service/web API written in C#

• Enhance or maintain database objects like Stored Procedures and Functions.

Environment:

ASP.NET, Ajax, SQL Server 2008/2012, C#, HTML5, SSIS, CSS, SSRS 2008, jQuery, JavaScript, XML, JSON, Web API, Agile

Scrum, Oracle SQL Developer

ACE Group, Wilmington, DE Jan 08 – Jun 14

Sr. Systems Consultant

AGS Account Services is an intranet based dashboard type application for Global Services (AGS) unit of ACE. Application enables users

to perform different types of business functions. Home page connects user to a module related to his or her business group and assists in

Page 1 of 5

completing the related work or assigned task. The work flow module of the application assists underwriters in monitoring the progress of

policy issuance task by operation department of AGS.

Role & Responsibilities:

• Gather and document the different business functions of AGS.

• Design 3-Tier architecture for application and develop database for various modules of the application.

• Construct website, backend process, user interface, reports and system to system interfaces using ASP.NET, C#, jQuery,

HTML5, SQL Server 2005/2008, SSIS, SSRS, XML, Ajax

• Convert existing Access/Excel applications into web/windows based application using ASP.NET, C#,

• Develop SSIS packages for data export and import and schedule package as job in SQL Agent

• Provide post production support including fixing bug and enhancing various parts of the application.

• Manage onsite resource to support development and maintenance activities.

• Interact with off-shore team for the design and development activities.

• Development and maintenance of Management Reporting System in SSRS 2005/2005, Report Builder 3.0 and Power pivot in

Excel 2010

• Coordinate with business users of various levels.

Rewrite of Multinational Account Exchange (MAX) an intranet based application, used as a tool of communication, for managing the

customer insurance program in multiple countries.

Role & Responsibilities:

• Gather information from the existing MAX application. Identify enhancements needed in coordination with Business & IT.

• Document the requirements and design the processes for different business modules (web page/Backend process/Web

Service/Window Service/Database).

• Create Technical Specifications document for off-shore team.

• Coordinate with offshore team and explain the requirements/technical specification for construction.

• Design and develop database and database objects for MAX application.

• Code Review and unit test the process.

Environment:

ASP.NET, Ajax, SQL Server 2005/2008, C#, VB.Net, VBScript, HTML5, SSIS, CSS, SSRS 2005, SSRS 2008, Power Pivot Excel

2010, Report Builder 3.0, jQuery, JavaScript, XML, Excel PowerPivot 2010

Premier Tech, Overland Park, KS Nov 07 – Dec 07

Consultant for Mediware, Lenexa, KS

Maintenance of WORx® Suite, a medication management solutions for large, acute care and academic hospitals who serves a broad

range of facilities including state behavioral health networks, community hospitals and outpatient clinics.

Role & Responsibilities:

• Maintenance and enhancement of the client/server based application.

Environment:

PowerBuilder 10.0, Informix

Midwest Consulting Group, Overland Park, KS May 07 – Oct 07

Consultant for Sprint, Overland Park, KS

Enhancement and maintenance of Web and Windows based Cable Provision application, supporting more than 150 users. Cable/land

phone order received from the different providers for processing.

Role & Responsibilities:

• Convert web page scrapper written in VB.NET (.NET 1.1) to C# 2.0 (.NET 2.0)

• Maintain and enhance web/windows/services for Cable provisioning application.

• Development/modification of Stored Procedures, Views, SQL Native Web Services, and SQL queues.

• Test Code and Coordinate with QA.

Environment:

ASP.NET 2.0, Ajax, C# 2.0, VB.NET, SQL Server 2005, XSD, XML, JavaScript, CSS, Web Services, Window Service, WCF,

Team Foundation Server, MSMQ.

RiverPoint, Overland Park, KS Feb 07 - Apr 07

Consultant for Penton Media, Overland Park, KS

• http://www.acukwik.com/mobile allows access to phone numbers, websites, clearances, weather information and a distance

calculator. Display Fuel prices for participating United States FBOs (Fixed Base Operator) for pre-flight planning needs.

• http://www.acukwik.com under Proximity Search section plots airports within 50 miles on Goggle Map for a given location.

• http://www.Trucker.Com Rewrite of American Trucker website site in ASP.NET 2.0/SQL Server 2005, which assist in sale /

purchase of Truck, Trailer, services and parts by different agencies.

Role & Responsibilities:

• Coordinate with Team Lead in gathering business/technical requirements.

Page 2 of 5

• Develop and enhance new web pages of existing web applications.

• Test Code and Coordinate with QA.

Environment:

ASP.NET, Ajax, C#, VB.NET, SQL Server 2000/2005, XSD, XML, VSS, JavaScript, CSS, Web Services

Tata Consultancy Services, Philadelphia, PA Jul 06 – Feb 07

Sr. Consultant for ACE, Wilmington, DE

Enhancement and maintenance of web based Multinational Account exchange (MAX), application, which provide communication tool for

binding, implementing, servicing and maintaining multinational insurance programs in more than 100 countries.

Role & Responsibilities:

• Coordinate with Business Analyst and System Architect in gathering business/technical requirements.

• Develop web interface and reports for insurance brokers, clients, and ACE non-affiliate partners.

• Enhance existing Web application, which manages insurance programs in different countries.

• Perform Unit Testing and coordinate with QA.

Environment:

ASP.NET, Ajax, VB.NET, C#, SQL Server 2000/2005, Visio 2000, XSD, XML, VSS, JavaScript, CSS, SOAP, Web Service,

Remoting, DTS, SQL Reporting Services.

Covansys, Overland Park, KS Nov 04–Jul 06

Consultant

• NFIP (https://www.nfipservices.com) provides flood insurance protection to property through an insurance company. Covansys

maintains this website and for several other insurance companies, selling the flood insurance (https://www.travelersflood.com/)

• Indiana WIC (Women, Infant, Children) Program

Application processes bundle of food stamps collected from grocery stores to Covansys Atlanta office. Also online application

accepts requests from potential applicants and after food stamps approval.

• Missouri Department of Elementary and Secondary Education

Missouri First Steps (https://www.mofirststeps.com/), is a web-based application which support the online data collection,

reporting and audit requirements. Application manages the enrollment of children, registration of service providers, monitor

child progress, billing and fund recovery from insurance companies.

Role & Responsibilities:

• Coordinate with Business Analyst in understanding, modifying and enhancing the Use Cases.

• Develop User Controls, business classes and Web/Window Interface using ASP.NET/VB.NET.

• Enhance existing Client/Server application written in VB6, Crystal Report and Oracle. Enhance VB6 components for .NET

applications.

• Develop applications using Window Service and SOAP based Web service.

• Test Code and Coordinate with QA.

Environment:

ASP.NET, VB.NET, C#, SQL Server 2000, Visio 2000, XSD, XML, VSS, JavaScript, CSS, Oracle 9i, Crystal Report 8.0/.NET,

Toad, SOAP, Web Service, Window Services,VB6,COM,DTS,Reporting Services.

Levi, Ray & Shoup, Overland Park, KS Oct 04–Nov 04

Consultant for LRS Clients (On bench)

Technisource, Overland Park, KS Apr 04–Oct 04

Consultant for Sprint, Overland Park, KS

Support and enhance existing Provisioning Systems.

Role & Responsibilities:

• Develop Web Services and Message Queues for passing and receiving data to and from Sprint cable partners.

• Support and enhance existing systems written in VB.NET and ASP.NET.

• Convert Windows application written in VB6 to Client/Server and Web based application using VB.NET and ASP.NET.

• Scrape and Populate website pages programmatically.

• Develop XSD schemas for data in XML format.

• Maintain and enhance Windows and Web applications.

Environment:

VB.NET, ASP.Net, SQL Server 2000, Oracle 8i, Visio 2000, Crystal Report 8.5, XSD, XML,VSS, MSMQ

Paige Technologies, LLC, Kansas City, KS Jan 04–Apr 04

Technical Associate for DEMDACO, Kansas City, KS

Enhance sales order processing and distribution system.

Role & Responsibilities:

• Participate in information gathering and design phase.

• Develop Object Model using Visio 2000.

Page 3 of 5

• Develop physical database design using ER-Win.

• Enhance application using VB.NET /Oracle 8i.

• Develop reports in Crystal Report 8.5

• Provide implementation support.

Environment:

Oracle 8i, VB.NET, ADO.NET, Crystal Report 8.5, Visio 2000, Toad

Federal Home Loan Bank of Topeka, KS Mar 99–Dec 03

Programmer/Analyst

• Independently design and develop client/Server and web based applications for different business groups. Also coordinate with

IT team in design and development of project.

• On-Going Maintenance

Provide 24x7 support to critical Windows and Web based applications. Enhance according to the business need. Assisted in SQL

Server conversion and testing from version 6.5 to 7.0 to 2000 and PowerBuilder version from 6.5 to 7.0. Actively took part

during Y2K testing of different applications.

Role & Responsibilities:

• Participate in information gathering, analysis and design phase of system.

• Develop Use Cases, Use Case Description based on the business logic.

• Design & Develop Web Page User-interface and reusable User controls. (ASP/ASP.NET/VB.NET)

• Design & Develop Windows Forms for Client/Server application (PowerBuilder/VB).

• Extract, transform and migrate data using PowerBuilder/VB.NET routines and DTS.

• Develop T-SQL Stored Procedures, User-Defined function, Queries, Views and Trigger.

• Used Visual Source Safe (VSS) as a repository database for the application source code

• Develop Crystal Reports for Client/Server and Web based applications

• Coordinate with team members/QA in development and maintenance of applications.

Environment:

VB.NET, ADO.NET, ASP.NET, ADO.NET, Visual Source Safe, CSS, JavaScript, SQL Server 2000, ER-Win 3.5, Visio 2000,

Crystal Reports. NET, DTS, PowerBuilder 6.5.

Mastech Systems Corporation, Oakdale PA Mar 98–Feb 99

Software Engineer for Federal Home Loan Bank of Topeka, KS

Customer Accounts Management System (Client/Server)

Design & Develop integrated system to manage the customer (banks, Credit Unions and Thrifts in four state regions) Demand

Deposit and Overnight Deposit Accounts. Existing system was partially running on Unisys machine and by a third party system

CAMRA under Windows.

Roles & Responsibilities

• Coordinate with Business in understanding and documenting the application requirements.

• Design & Develop Business and Data Access components using Non-Visual Object (PowerBuilder)

• Develop T-SQL stored procedures, queries and views for data retrieval and update.

• Design and Develop Windows interfaces for data Entry, on-line queries, data conversion, End of Day Processing and reports

using PowerBuilder Foundation Class Libraries.

Environment

PowerBuilder 6.5 (with PFC), MS SQL Server 6.5, ER-Win 3.5, Windows 95/98

Eastern Software Systems, New Delhi, India Aug 96–Feb 98

Software Engineer for ARAMCO, Dhahran, KSA

• Rewrite - Environmental Waste Water Database Systems (Client/Server)

Different laboratories test wastewater samples from different refineries. Test results are stored in database for different

informational and analysis purpose.

• Rewrite - Bulk Plant Operation Systems (Client/Server)

Different type of oil products are stored in bulk plants and later distributed to different locations. Application keep track of product

inventory according to storage /Product type.

Roles & Responsibilities

• Participate in information gathering phase of the application development.

• Coordinate with Project Leader in documenting the requirement.

• Develop user interfaces, processing function and reports in PowerBuilder.

• Develop Stored Procedures, Views and Queries for data access and update.

• Convert mainframe data to Oracle.

Environment

PowerBuilder 5.0.3 (with PFC), Oracle 7, ER-Win, Windows 95/98

Page 4 of 5

Fujitsu-ICIM Limited, India Jan 96–Jun 96

Software Engineer for MIS Reporting System, Bank of America, Hong Kong

Assist application support team in development, enhancement and in maintenance of different reports for the bank, using

RPG/400, CL/400, SQL/400 and RLU

Lucknow Development Authority, India Oct 94–Dec 95

Assistant Programmer

Assist EDP team in developing and maintaining several applications under UNIX, C, and Unify 4.0. Extensively use UNIX Shell

script in converting data for C/S system. Migrated data from UNIX-Unify database to Oracle 6.0 and PowerBuilder 3.0.

Development and maintenance of applications written in COBOL and Clipper 5.0

Saudi Arabian Airlines, KSA Jul 93 -Sep 94

Junior Programmer

Assist project leader in developing and maintaining different applications on AS/400 using COBOL/400, RPG/400, CL/400 and

SQL/400.

Lucknow Development Authority, India Jan 88–Jun 93

Assistant Programmer

Assist EDP team in developing and maintaining several applications under UNIX, C, and Unify 4.0. Develop Shell routines for

support and maintenance purpose. Development and maintenance of applications written in COBOL and Clipper 5.0

Integrated Software Systems (P) Ltd, India Oct 86–Dec 87

Programmer/Trainer

Support the computer education division of the company (COBOL, PASCAL, GWBASIC and Dbase III+/Clipper)

Education:

M.S. (Systems and Information) Birla Institute of Technology and Science Pilani, India (1991)

Diploma (System Analysis & DP) Annamalai University, Tamil Nadu, India (1988)

M.Sc. (Mathematics) University of Lucknow, Lucknow, India (1985)

Status: Citizen of United States

Page 5 of 5

Contact this candidate