Project Sql Server

ACADEMIC QUALIFICATION / CERTIFICATION:

Master in Computers & Information Technology (GPA 3.03).

•

Bachelors in Science major in Statistics and Mathematics.

•

Diploma in Computer Science.

•

OCP Certification (Introduction to Oracle :SQL & PL/SQL Paper).

•

CAREER SUMMARY:

• Over Seven years of proven and demonstrated experience in designing and implementing multi-tier

client server applications and system integration solutions as team member, analyst and developer using

specific tools and technologies (Visual Basic 6, OCX, DLL, COM, SQL Server, Oracle, Crystal Report).

• Including 3 years experience of developing web base business applications using ASP.NET, VB.NET,

ADO.NET, IIS, HTML, JavaScript, CSS, Web Services, XML etc.

• Strong background of Relational Database Design and a solid understanding of Normalization.

• Expertise in T-SQL, Database Triggers, Data Views and Stored procedures, query analyzer, DTS

(data migration) packages, SQL Server Reporting Service and SSIS, Vision, Erwin.

• Highly motivated team player with excellent problem solving skills with ability to work independently as

well.

TOOLS AND SKILLS:

•

Microsoft ASP.Net/ VB.Net SQL Server 2000/ 2005

• Oracle 9i

Microsoft Visual Basic 6.0

• Microsoft Access

Crystal Report 8.5/9/10/11

• Macromedia Flash

Macromedia Dreamweaver

• Java Script & HTML

Adobe PhotoShop

• Advanced Microsoft Excel (Pivot Table)

Fox Pro & Cobol

PROFESSIONAL EXPERIENCE:

Employer : Phipps Houses Services Inc. Manhattan, NY (Oct’ 08 – Current)

Designation : Analyst Programmer/ Report Developer

Project : New Employment Application System & Housing Application System

Environment : VB.Net, ASP.Net, SQL Server, Crystal Report XI, HTML, JavaScript, CSS.

Role and Responsibilities: (Team size 2)

• Design and implementation of database architecture.

• Designing and implementing of all application layers (UI, Business and data).

• Write/ Create stored procedure, database triggers to extract data for master detail form/ reports.

• Create DTS packages for data migration.

• Design complex reports in Crystal Report according to the requirement/ format given by management.

• Maintenance of company’s Asset Management software/ reports (using crystal report & SQL queries).

Employer : Aiki Systems, Stamford, CT (May’ 08 – Oct’ 08)

Designation : Computer Specialist

Project : Inventory & Accounts Management System

Environment : Visual Basic 6, MS-Access, Crystal Report 9

• Maintenance/ Development of Company Software.

1

• Resolve software and hardware problems.

• Installed custom built computer according to customers requirements.

• Retrieve data from unbootable hard drives and restore it to new machine.

Employer : Softnology Systems (Pvt) Ltd (Aug’ 05 – Apr ’08)

Designation : Software Developer/ Programmer

Project : Machine Maintenance Services and Inventory Management System.

Client : Engro Chemicals Ltd.

Environment : ASP.Net, VB.Net, SQL Server 2005, Crystal Report, HTML, JavaScript.

Role and Responsibilities: (Team size 3)

• Played an active role in the SDLC phases of the project.

• Apply advanced relational database concepts (e.g., table relationships, joins, etc.) in design and

implementation of database architecture.

• Follow object oriented based ASP.Net coding guidelines that will easily allow code maintenance or

enhancements.

• Write complex SQL Queries for SQL Server Relational database to extract data for master detail form/

reports.

• Design complex reports in Crystal Report according to the requirement/ format given by clients.

• Extract HTML coding from Dreamweaver and adjust/ amend it according to Form/ Screen requirement in

ASP.Net code behind environment.

• Write code in Java Script for form validation and Popup Windows opening.

• Effectively communicate with management involved to ensure project is being completed as per specification.

• Prepare test cases in MS-Excel to be used for execution of all testing according to requirements.

• Participated with deployment team in the deploy/ integration project and to fixes in release.

Project : Enterprise Resource Planning (ERP) System.

Client : Amreli Steels.

Environment : Visual Basic 6, Oracle 9i, Crystal Report 8.5

Role and Responsibilities: (Team size 5)

• This ERP system consists of Accounts, Payroll, Customer Relation Management, Store Inventory, Raw

Material Inventory, Finish Goods Inventory Modules.

• I played an active role in the SDLC phases of the project.

• Apply advanced relational database concepts (e.g., table relationships, joins, etc.) in design and

implementation of database architecture.

• Follow coding guidelines in VB6 environment that will easily allow code maintenance or enhancements.

• Write complex SQL Queries for Oracle Relational database to extract data for reports.

• Design complex reports in Crystal Report 8.5 according to the requirement/ format given by clients.

• Effectively communicate with management involved to ensure project is being completed as per specification.

• Prepare test cases in MS-Excel to be used for execution of all testing according to requirements.

• Participated with deployment team in the project deployment/ integration and to fixes in release.

Project : Inventory Management System.

Client : Engro Chemicals and Engro Foods Ltd.

Environment : Visual Basic 6, SQL Server 2000, Crystal Report 9

Role and Responsibilities: (Team size 4)

• Played an active role in the SDLC phases of the project.

• Apply advanced relational database concepts (e.g., table relationships, joins, etc.) in design and

implementation of database architecture.

2

• Follow coding guidelines in VB6 environment that will easily allow code maintenance or enhancements.

• Write complex SQL Queries for SQL Server Relational database to extract data for reports.

• Design complex reports according to the requirement/ format given by clients.

• Write code for data export in MS-Excel files so that data import in SAP system.

• Connect 3 different Warehouses located in different cities through Remote Desktop utility.

• Effectively communicate with management involved to ensure project is being completed as per specification.

• Prepare test cases in MS-Excel to be used for execution of all testing according to requirements.

• Participated with deployment team to deploy project and to fixes in release.

Employer : Civil Aviation Authority. (Jan’ 00 – Jul ’07)

Designation : Programmer / System Operator

Project : Human Resource Management System.

Client : Human Resource Branch Civil Aviation Authority.

Environment : Visual Basic 6, DB2, Crystal Report 8

Role and Responsibilities: (Team size 5)

• Assist Sr. System Analyst in the SDLC phases of the project.

• Follow coding guidelines in VB6 environment that will easily allow code maintenance or enhancements.

• Design complex reports according to the requirement/ format given by the management.

• Connect DB2 AS-400 database with Micro computers through Client Access tool.

• Participated with deployment team to deploy project and to fixes in release.

Project : Employment Management System.

Client : Employment Branch Civil Aviation Authority.

Environment : Fox Pro 2.0.

Role and Responsibilities: (Team size 2)

• Design tables, write codes.

• Design reports according to the requirement/ format given by the management.

.

Project : Overflying Billing System.

Client : Billing Branch Civil Aviation Authority.

Environment : Visual Basic 6, MS-Access 2000, Crystal Report.

Role and Responsibilities: (Team size 2)

• Assist Sr. System Analyst in the SDLC phases of the project.

• Write codes as per analysis and logics.

• Write complex SQL Queries for SQL Server Relational database to extract data for reports.

• Design reports according to the requirement/ format given by the management.

• Participated with deployment team to deploy project and to fixes in release.

Other assignments/ job responsibilities:

• Upkeep, development and maintenance of all computer softwares.

• Assign, manage and look after the data entry of existing Systems.

• Control on non-conformity & take corrective action.

• Take timely Backup & ensure deposit in security vault.

• Prepare reports, manuals and other documentation as per requirement of Higher Management.

• Any other job as assigned from time to time by the management.

Visa Status :

3

• I have a US Green Card and I am eligible to work for any employer.

4

Contact this candidate