Project Manager Sql Server

FEISAL ABEDEEN

**** * ******** **** **** D, Wheaton, IL 60187

***********@*******.*** 630-***-****

http: //www.linkedin.com/in/fabedeen

PROFESSIONAL SUMMARY

An exceptional Solution Developer with expertise in OOP / OOD architecture,

design and development of web based and database applications focused on

SharePoint web portal, ASP.NET/C# and SQL Server. In depth understanding

and domain expertise in Healthcare, Finance and Ad Agency systems.

OS: Windows Server 2008 R2, Windows 7

DATABASE: SQL Server 2008 / 2005, MySQL, Sybase, XML / XSLT / XSD, SSIS /

DTS, SQLCompare, SSRS / Crystal Reports, ERWin Data

Modeling

LANGUAGES: ASP.NET 2.0 / 3.5, C#, Silverlite, JQuery / JavaScript /

ECMAScript, PERL, PHP

GROUPWARE: SPS 2010/SPD 2010, WSS 3.0, MOSS 2007, Adobe PhotoShop CS 4,

XML Web Services, Windows Services, TFS 2010 / 2005, VSS

2005, UML, ERD

BUSINESS: Agile SCRUM, MS Project, Pert / Gantt Charts, Business

Requirements, Functional Specs, Unit Testing, Resource

Scheduling

DESCRIPTION OF EXPERIENCE

NEUDESIC LLC, Lombard, IL January 2010 - Current

SharePoint Server Senior Consultant II

Architecture, development and design of site collections for Healthcare

related publishing portal content management system. Replaced existing

Lotus Notes project and change management systems with MOSS 2007 site

collection, including content migration. Designed and developed web parts,

list definitions, site definitions, custom user controls, custom field

types and visual web parts for SharePoint Server 2010. .

. Enhanced the user experience with web parts client-side drag and

drop capability using JQuery AJAX with the ECMAScript Client Object

Model (COM)

. Worked on a large project with developers from Microsoft for

General Motors as a case study within Agile Scrum environment.

. Advanced learning of Beta technologies - Visual Studio 2010, SPD

2010, Office 2010, SPS 2010, TFS 2010 Server.

. Comparative analysis with MOSS 2007 as a content management web

application development platform. Built various proof-of-concepts

to demonstrate Client Object Model capability.

. Worked on development of MOSS 2007 site for SPX International that

merged business tier logic in WCF/custom .NET with SharePoint

technology as hosting environment to get benefits of publishing

portal.

. Developed virtual development environment on WS 2008 R2 VHD on

Hyper-V Server and boot-to-VHD with complete SharePoint Server 2010

deployment, security and audience configuration and set-up.

. Built complex sequential Workflows using SPD and Visual Studio for

approval, review and data collection within IS Department of Rush

Medical Center.

. Packaging of all site collection components such as site

definitions, List and Content Types, web parts, workflows and

themes including master pages and layouts.

TECH ALLIANCE INC. / MANPOWER PROF., Rosemont, IL June 2008 - December

2009

C# / SharePoint-MOSS 2007 Technical Consultant

Designed, developed and customized SharePoint CMS Publishing web portals

based on WSS 3.0 / MOSS 2007 application development platform by extending

C# / .NET capabilities to the SharePoint DOM. Complete project life cycle

migration of .NET website to MOSS publishing portal as user-managed CMS.

Created Object Oriented Architecture, developed, unit tested and deployed

secure and encrypted credit card payment-based ASP.NET / C# system for

Customer Event Registration - conversion from legacy VB6 / ASP system

within structured Agile OOP-based system.

https: // www.dairyevents.com/Login.aspx ;

https://www.dairyevents.com/admin/login.aspx

http://www.usdairy.com/sustainability; http://qa2.dairyfarmingtoday.org

. Developed custom field types, web parts, action events, user and

web controls, web services, AJAX controls, JQuery/JavaScript

client-side scripting built into web parts, work flows, features

and deployment to sites using Visual Studio 2008 WSS extensions

and SharePoint Designer 2007.

. Developed features to provision various aspects of Content

Management System such as content types, document libraries,

layouts and site columns using additional tools such as WSP

Builder, SharePoint Installer, CAML query builder, SharePoint

Manager 2007.

. Developed SharePoint site collection from PSD UI requirements,

custom .NET menu navigation control, masterpage/CSS from

wireframe specifications.

. Installed MOSS 2007 on WSS 3.0 in virtual environment,

configured and administered various site templates and site

collections.

. Developed OOP-based DMI namespace architecture including Classes

that inherit from base Classes with core functionality - UML /

class / activity diagrams completed in Visio.

. Developed database design associated to class architecture -

Object Relationship / Entity (ORM) / ERD design completed in

Visio / SQL Server 2005 diagramming tools.

. Developed GUI for ASP.NET 2.0 websites using reusable web

controls, Master Pages, AJAX control Toolkit and DataGrid

controls from Infragistics.

. Developed Rijndael (AES) encryption / object serialization

Classes for secure credit card processing and payment capture /

sales.

. Developed PCI DSS-compliant payment processing Classes that

interfaced with AssureBuy's secure XML-based Internet Payment

Gateway.

. Developed Administration (DEAS) Classes for Registration,

Payment and Events. DEAS managed DERS by setting up User, themes

/ skins, reporting and printing functions.

. Developed payment reports for IDEAS using SQL Server 2005

Reporting Services (SSRS) including instance installation and

secure group administration.

. Developed various .NET functional Classes utilizing open source

C# / Java packages - such as PDF generation iTextSharp, charting

tool ZedGraph and HTML editor Winthusiasm - some of these

utilities required conversion from Java to C#.

TEK SYSTEMS - LIONS CLUB INTERNATIONAL, Oakbrook, IL May 2008-June 2008

Consultant - C# Software Engineer

Converted legacy mainframe application for Lions Membership Management into

ASP.NET / C# Life Membership web pages and completed debugging of

miscellaneous performance problems within multiple applications.

. Mentored junior C# / SQL developers for miscellaneous C# /

VB.NET and ASP.NET bug fixes, unit testing and DTS packages.

. Performed Regression Analysis, QA / Unit Testing on previously

written apps in C#, VB.NET and ASP to identify improper code

fragments causing performance issues on SQL Server database.

. Conducted performance tuning on inline-SQL queries, stored

procedures and functions to reduce large procedure cache

utilization on database.

TEK SYSTEMS - KINGSWAY FINANCIAL SERVICES, Schaumburg, IL October 2007-

April 2008

Consultant - C# Software Engineer

Implemented and developed OOP-based Transportation Insurance-related C#.NET

/ ASP.NET website called WebMerlin and VB.NET / C# winForms application

called Argante used for Bond Management and Invoicing systems running XML

queries into US Customs database. https://webmerlin.avalonrisk.com/

. Extended existing functionality on C#.NET Classes for WebMerlin

website and AJAX control toolkit including XML / Web Service

calls to external URL's.

. Developed reusable web controls and Classes including

proprietary server-side validation against Validation tables.

. Developed business user-driven enhancements for existing C#

WinForms Bond Management Argante application that used mix of C#

and VB.NET base Classes.

. Implemented third-party Infragistics / Data Dynamics .NET

controls where Microsoft controls had limited functionality such

as advanced GridView and ListBox.

. Developed Technical Design Requirements from business

specifications, Unit Testing and GUI development as required by

SOW.

. Developed enhancements to legacy BondMerlin VB 6-based system

per Help Desk Ticket system requirements - completed maintenance

bug fixes as required.

. Developed SQL Server 2005 stored procedures / tables / views,

miscellaneous Integration Services data packages (SSIS) for data

transformations / conversions between databases and business

reports using Reporting Services (SSRS) packages.

. Version Control / documentation and tracking of SDLC stages

accomplished via Team Foundation Server 2005 (TFS) within

structured Agile software environment.

TEK SYSTEMS - KISHWAUKEE COMMUNITY HOSPITAL, DeKalb, IL August 2007-Sept

2007

Consultant - C# Software Engineer

Architected and developed Object Oriented Role-based Menu Login

authentication and authorization portal in C# / ASP.NET / SQL Server 2005

for LDAP-based restricted logon access into Hospital Patient Management

system.

. Designed base architecture for Classes and database to

accommodate the secure Logon requirements by creating a cookie-

enabled Custom ASP.NET provider Model.

. Created UML schema and ERD in Microsoft Word by collecting

business requirements and technical specifications.

. Developed Directory Services (LDAP) - based authentication

Classes and authorization based on membership response from

Active Directory (ADS) query.

. Developed XML- based Classes for Cisco Call Manager for

hospital's Cisco VOIP phone system to return query from ADS in

order to integrate phone system with Meditech Patient

Registration System.

. Designed and implemented relational database using SQL Server

2005 to house Profiles, Roles and Authentication information for

multiple Membership Groups.

VALCOM - ITIL Division May 2007 -

July 2007

.Net Developer / Analyst

Developed and maintained Portal website based on ASP / ASP.NET / VB.NET-

based website called WebSPOC for users to make purchases, Inventory and

Order Management Tracking which accessed mainframe based CP7000 and SQL

Server 2000 data warehouse.

. Extended VB.NET base Classes created within Valcom namespace for

various GUI, Validation and Graphics Chart Controls and

enhancements to existing website.

. Migrated website from Legacy ASP to ASP.NET using data-migration

assistant, manual rewrite of pages and replaced ASP-include

files with OOP Classes and methods.

. Created Asynchronous XML-HTTP-JavaScript Classes-based AJAX

Charting and Reporting controls by extending existing JavaScript

library functionality.

. Created Unit Test Requirements to verify that enhancements met

technical specifications and to validate bug fixes for project.

. Developed stored procedures / functions / ADO.NET / DB classes

for data access within SQL Server and mainframe-based CP7000

data warehouse.

WAGEWORKS, INC. - COBRA DIVISION, Lombard, IL February 2002 - April

2007

Sr. Developer / Analyst

Designed, architected and developed several critical public-facing and

internal applications with Project Management of SDLC functions from

collecting business requirements to final implementation and deployment to

ensure timely and reliable data flow between business, Client and Vendors.

https://www.ee-commerce.com/cobra_inquiry/Premium/index.html;

https://www.ee-commerce.com/cobra_inquiry/Cobra/index.html

https://www.ee-commerce.com

. Architected and developed critical 3-Tier ASP.NET / VB.NET / SQL 2000

based File Tracking System (FTS) that allowed internal Staff to review

unresolved issues and track files on a timely basis, thereby avoiding

expensive legal penalties for late Notifications.

. Developed Classes and GUI to query and update SQL Server database for

internal Staff to manage status of File loading and issue resolution

processes. System automated calls to SQL Server DTS packages for

processing incoming ASCII comma-delimited data files.

. Implemented XML WebServices for integration of COBRA / Premium Billing

databases via Unique ID in various cities for seamless centralized

customer Login Portal hosted in Corporate HQ.

. Developed Windows Service for automated file sensing using VB.NET

Classes - invisible LAN service continuously queried directory for

files - whenever a text file object was detected, service called

various methods for validation, notification and calls to start DTS

loading packages.

. Developed PHP / MySQL-based websites called WebInquiry and

PremiumWebInquiry to display Payment and Insurance information - via

queries to SQL Server data warehouse that integrated with internal

File Tracking System.

. Database design, development and implementation for SQL server 2000 /

2005, Sybase, Visual FoxPro and MySQL Server including stored

procedures / TSQL / triggers, DTS packages - used ERWIN for data

modeling and design.

. Database DBA functions such as query tuning, daily tape backups, re-

indexing, hardware sizing, RAID5 implementation and User

Administration.

. Developed EDI transmission processes for Eligibility data feed to

major Insurance Carriers such as Aetna, BCBS, Caremark, Delta, Cigna,

Medco, and Empire in custom and standard XML-based HIPAA 834 formats.

. Developed PERL-based website called eeCommerce by which COBRA and

Retiree data was auto-processed and transmitted securely from FTP site

into database.

. Programmed File Notification System in proprietary RoboFTP scripting

language to automate connection, loading and notification of

electronic file submissions.

. Project Manager for 5 IT Staff members responsible for incoming and

outgoing data loading and contractors. Responsible for daily Database

operations and planned product development for the business.

Developed SOP's for ISO 2000 data flow and business qualification

procedures for the IT Department, the qualification was approved in

2004.

NEUMARK TECHNOLOGY GROUP, INC. Lisle, IL May 1998 - January

2002

Senior Consultant (consulting assignments listed below)

TECHNICAL ANALYST, ABBOTT LABS DIAGNOSTICS DIVISION Sep 2001-Jan 2002

. Assisted Client under Federal Drug Administration investigation with

software validation and database administration for proprietary

software ValPac 4.1 in VB 6.

. Administered database in Access 97 / SQL Server 7 for maintaining

software validation files.

. Completed requirements to be certified Abbott Software Validation

Technician.

ACCESS DEVELOPMENT, R.R. DONNELLEY'S LOGISTICS June 2001-August 2001

. Developed back-end Asset Management database in MS Access for taking

inventory using their existing scanning / bar-coding workstations.

. Developed MS Access databases for scanning / barcode Intellitrack

system. Worked on scanning / barcode Intellitrack software / PSC

Percon PT 2000 scan guns to devise strategy for nation-wide asset

management system.

PROGRAMMER ANALYST, BOWNE BUSINESS SOLUTIONS February 2001-May 2001

. Performed analysis of proprietary Java / JDBC based object oriented

language against standard ASP based techniques for development speed,

functionality and performance.

. Developed several CGI-based modules with custom defined sets of

business rules, methods and properties for control of inventory

management and invoicing pilot system. This was a multi-tier web

application hosted on Mac OS 10 (UNIX processes) with Apache / Tomcat.

Techniques included HTML, style sheets, JavaScript / XML to display

data using JavaScript function library for client-side validation.

DATABASE / WEB PROGRAMMER ANALYST, PEOPLES ENERGY June 2000-January 2001

. Developed and administered contract billing, invoicing and customer

base information on SQL Servers.

. Developed web application to conduct electricity pricing analysis to

compare daily usage costs of client to major utility competitor, and

enabled client to precisely track and forecast unit margins.

. Designed parameterized SQL Server stored procedures with error

handling routines for implementing business rules in various tiers of

a web application.

. Crystal Reports development within ASP for ad hoc reporting.

. Developed electricity pricing database for business users using ERWIN

modeling and SQL Server 7 tables.

. Database administration included backup, rules / defaults on tables,

process scheduling, security, and BCP data transfer from HTML parser

output.

ASP DEVELOPER, CITICORP GROUP May 2000-June 2000

. Developed web pages for automated card reading. Client required POS-

linked dynamic data entry into website at provider sites for

monitoring student use of grants and class attendance.

. Designed ASP pages with SQL Server backend for student and provider

data and updates.

. Installed and administered Crystal Reports Web Server with Java-

enabled reports.

. Conducted software QA / QC and system testing for data reliability

reports for Project Manager.

DATABASE / REPORTS DEVELOPER, WHEELS, INC. November 1998-April 2000

. Developed SQL Server data tables to extract from Client data

warehousing for customer / vehicle purchase and maintenance

information system. Visual display developed using web Crystal

Reports.

. Linked transact SQL Stored Procedures across several SQL Servers for

complex business logic implementation.

. Designed and developed complex Crystal Reports using parameterized

Stored Procedures.

TECHNICIAN SUPPORT, CNA INSURANCE June 1998-October 1998

. Provided Application Support for software installation, hardware, and

LAN connectivity via secure remote access via dial-up to Windows NT

Servers to Field Reps using Windows 95 / NT laptops.

. Performed RAS Modem dial-up LAN configuration, installed and

administered MS Exchange Server Remote Mail Service, and provided

support for LAN, Windows and corporate / business software issues

. Installation / administration for MS Exchange Server Remote Mail

Service and local / server mailbox synchronization.

AMTECH ENGINEERING, INC., Indianapolis, IN February 1996 -

May 1998

Project Engineer

Managed Local Area Network for the business providing Technical Support

when needed. Used Federal guidelines to create Work Breakdown Structure for

large mostly Air Force and Army remediation projects, including Statement

of Work and Project Cost structure for Project Manager.

. Designed, installed and administered a 25-user Windows NT 4 local area

network. Converted Workgroup system to domain structure managed by PDC

and BDC. Designed network cabling requirements, administered LAN,

shared database and drives, tape back-up, UPS and network security and

anti-virus, print, mail and fax servers.

. Implemented Resource Tracking, Cost Estimation, Cost and Cost

Performance Analysis for multi-million Wurtsmith Air Force Base,

Rickenbacker Air Force Base, and U.S. Army Corps of Engineers.

Performed weekly status reporting and charting for project tracking.

. Developed Electronic Deliverables for Air Force by compilation of

database for chemical / physical data using ERPIMS / ERPTOOLS

software.

EDUCATION AND TRAINING

. M.S. Engineering Management, Colorado State University, Fort Collins,

CO, June 1996

. B.S. Chemical Engineering, Osmania University, India

. Microsoft Certification / Coursework: working towards MCPD on C#.NET

2.0

. MCP: Networking Essentials, Windows Workstation, Windows NT Server 4

ACHIEVEMENTS

. 1992 Recipient of the Elizabeth Dole Award for 500 hours of service to

the American Red Cross

. 2005 Acorn Award for exceptional leadership with Boy Scouts of America

as Committee Chair

. Journal Publication in Environmental Science & Technology, July, 1991,

Volume 25 (7) - Influence of Biofilm Accumulation on Porous media

Hydrodynamics - Alfred B. Cunningham, William G. Characklis, Feisal

Abedeen & David Crawford.

Contact this candidate