Post Job Free
Sign in

Manager Sql Server

Location:
West Chester, PA, 19380
Posted:
March 09, 2010

Contact this candidate

Resume:

Michael Bailey

*** ******** ****

West Chester, PA 19380

(215) 908 – 1547

*********************@*****.***

Work Experience:

SEI INVESTMENTS Oaks, PA 2009 – Present

Consultant

As a Consultant for CIBER, sited at a wealth management firm, create technical documentation for the

creation of Business Objects Universes to be used for Business Intelligence report development. Create

BOXI reports to be used for Global Wealth Platform Report validation. Convert existing Crystal reports into

Business Objects XI Web Intelligence reports.

IBM West Chester, PA 2006 – 2008

Senior Consultant

Initially contracting with Distributed Systems Services then with Regent Systems, analyze requirements and

negotiate with clients to produce prototypes and artifacts for report development. Create complex SQL

Server 2005 code to efficiently handle large reporting datasets. Create Business Intelligence reports using

Crystal Reports and Business Objects XI Enterprise suite tools including Designer, Desktop Intelligence,

Central Configuration Manager and Business View Manager. Oversee all Business Objects XI Enterprise

undertakings including user, folder and group administration. Deploy reporting platforms at remote sites,

implementing government and military security mandates. Collaborate with SQL DBA to warehouse live

data into repository for reporting purposes. Lead a group of six IBM employees in above-mentioned

activities.

DUPONT CHEMICAL Wilmington, DE 2005 - 2006

Computer Programming Consultant

As a contractor with Distributed Systems Services, design and perform maintenance on Business Objects XI

and Crystal 8.5 reports with Oracle, SQL Server and Lotus Notes back-ends for DuPont Chemical Legal.

Serve as the sole contact for the DuPont Legal’s reporting of financial, intellectual property and litigation

management. Administer Business Objects XI Enterprise application server including user, group and folder

assignments as well as installations and upgrades. Design and create data warehouse of Lotus Notes data into

SQL Server 2000 for reporting purposes.

TELE-RESPONSE CENTER Philadelphia, PA 2003 - 2005

Database Programmer

Emulate reporting using Crystal Reports with FoxPro, Sybase, or Oracle back-ends. Create & maintain the

direct mail line of business using Visual FoxPro. Convert & analyze data to maximize revenue generating

potential using FoxPro and Sybase. Administer the normalization of data prior to usage. Moderate the

integrity of the data. Generate & analyze daily statistics from direct mail and telephone programs to optimize

results for internal and external usage. Automate pledge acknowledgement and fulfillment system for

clients. Manage all software undertakings for entire administrative staff.

KEYSTONE MERCY HEALTH PLAN Philadelphia, PA 1999 - 2003

Senior Programmer

Construct financial statutory reports for the Departments of Public Welfare of PA, NJ, KY and SC as well as

for internal and external accounting purposes using Crystal with Sybase and Oracle back-ends. Forge RUBI

reports from Facets Insurance Software and periodically simulate those reports in Crystal to promote resource

optimization. Convert existing PICK/UNIVERSE legacy code into Crystal, Sybase, and Oracle in

compliance with software overhaul. Normalize existing PICK data into Sybase using Datastage. Oversee

project-oriented software development for general managed healthcare activities on PICK/UNIVERSE

system. Emulate programs to produce ad-hoc reporting of financial transactions regarding managed Medicaid

healthcare in accordance with several governmental guidelines (including HIPAA X12). Design and

implement utilities to streamline internal operations with Visual Basic and other Microsoft Applications.

Warehouse data into Oracle using Sybase. Document and deploy these undertakings in a regimented fashion.

Interview and analyze potential employees for project teams.

Page 1 of 2

Michael Bailey

990 Fernhill Road

West Chester, PA 19380

(215) 908 – 1547

*********************@*****.***

Technical Skills:

Software: JAVA, Crystal Reports 7 through Business Objects XI, Sybase ASE v12, Oracle v8 – 9i,

SQL Server, UNIX, MS Visual Basic, PICKBASIC, RUBI for Facets 296.1, FoxPro 2.6

- Visual FoxPro 8, C Programming, COBOL, IBM JCL, MS Windows 95, 98, NT, 2000,

MSDOS, MS Access, MS Excel, ADMVS, dBase IV, Cognos Powercube, Ardent

Datastage 3.5, PL\SQL, Transact SQL, CICS, BI-Query Data Warehouse

Hardware: IBM 4341 mainframe, IBM RISC System 6000, IBM compatible PC’s 286 through

Pentium Pro systems

Education:

Delaware County Community College Media, PA

Business Administration 1988 - 1992

Computer Learning Center Philadelphia, PA

Computer Programming Certification 1993

Temple University Philadelphia, PA

Computer Science 1999 – 2003

New Wave Resources Philadelphia, PA

Solaris Unix Administration Certification 2003

Solaris Java Certification

Oracle DBA Certification

Clearances:

IT II Security Clearance obtained from the Department of Defense 2009

Page 2 of 2



Contact this candidate