Resume of DATABASE ANALYST, ADMINISTRATOR

Title
DATABASE ANALYST, ADMINISTRATOR

Primary Skills
VBA, SQL Server, MS Access, Oracle 9i, PL/SQL Developer, TOAD VI, Visual Basic 6.0, VAccess, Excel.

Location
US-NY-NEW YORK

Posted
Jan-02-07

PROFESSIONAL EXPERIENCE:

Sony
Database Manager
January 2006 - Present
Manhattan, New York

Created DTS packages, Jobs, Stored procedures, Triggers, backup, restore, ad-hoc reports, automated daily, weekly, monthly reports in SQL Server 2000.
In charge of creation and administration of Sony Publishing databases.
Developed front end interface for upper management to enter multiple criteria that returns reports with Access Project.
Created a matching routine that generated millions of dollars from suspense files from all around the world.
Creating data warehouse in SQL Server 2000 and IBM AS/400.

MX Energy
Database Analyst
July 2005 - December 2005
Edison, New Jersey

Developed automated system to check for errors, and send email with details to analyst using DTS Packages, Jobs, Stored procedures and triggers using SQL Server 2000 and Microsoft Access.
Developed automated system to check for customers who didn?t receive letters and resend them using DTS Packages, Jobs, Stored procedures and triggers using SQL Server 2000 and Microsoft Access.
Developed database for help desk activities DTS Packages, Jobs, Stored procedures and triggers using SQL Server 2000 and Microsoft Access.
Analyze 300 table database for data and system errors.
Created error, performance, and financial reports for entire company DTS Packages, Jobs, Stored procedures and triggers using SQL Server 2000 and Microsoft Access.
Team Lead on legacy data cleansing project.

Paradigm Consulting Services
Database Administrator/Developer
October 2004 - July 2005
Clifton, New Jersey

Created new automated reporting using DTS and Visual basic scripts.
Increased performance by using Traces, Index tuning and Execution plans.
Perform daily, weekly, monthly, quarterly, yearly and ad hoc reports using various reporting platforms.
Educate other associates on proper operation of created procedures.
Create technical documents on operations, procedures and general instruction.
* Parse heterogeneous data into company databases.
Administer SQL Server and Access databases.

T-Mobile
Database Analyst
April 2004 - October 2004
Parsippany, New Jersey

* Work with Oracle 9i and SQL Server 2000 creating complex schemas, views, stored procedures and triggers for companywide data migration.
* Improve data processing for Oracle and SQL database by streamlining current processes.
* Analyze current databases for invalid data.
* Team lead on billing reconciliation project.
* Team lead on data migration.
* Created automated reporting for the entire T-Mobile network.



INGRAMS MAGAZINE -Kansas City, MO
Database Administrator/Developer
October 2003 to March 2004

* Work with SQL Server 2000, MS Access and Goldmine to produce specialized marketing lists.
* Develop automated processes using Visual Basic.
* Improve data processing for Goldmine database by streamlining current processes.

ALAMOSA PCS - Leawood, KS
Database Administrator/Developer
July 2002 to September 2003

* Database Administrator for SQL Server 2000 and Access Databases.
* Created databases, tables, queries, access pages, macros, reports, security, views, DTS packages, jobs and all other aspects of SQL Server 2000 and Access database design.
* Created reports on dropped calls, block calls, attempts, successes, MOU?s, and outages that automatically sent text messages to field technicians and emailed managers reports of switches.
* Analyzed user requirements to create daily, weekly and monthly management reports including key process indicators and metric reports.
* Provided special reports on an ad-hoc basis in response to demands from management, using MS Access queries and SQL Server data.
* Developed automated process to increase productivity and reliability for daily processing/reporting needs using SQL Server 2000 and MS Access.
* Used multiple technologies, including SQL Server, MS Access, VBA and Visual Basic to develop automated services and automated reporting processes.

J.M. NEIL - Overland Park, KS
Database Administrator
July 2001 to July 2002

* Assigned to Sprint, implemented new MS Access databases to fulfill the requirements of the business units. Integrated those same databases to eliminate duplicate procedures.
* Created MS Access database for Sprint Network Real Estate department for Contract Labor Reporting.
* Created MS Access database for Sprint Network Real Estate Lease Admin. Audit process.

SPRINT PCS - Kansas City, KS
Project Analyst
March 1998 to July 2001

* Helped manage projects by estimating costs, deadlines, staff, and logistics.
* Created reports with Access and Excel for a department of over 200 employees.
* Directly managed a team of 10 subordinates.
* Utilized technical capabilities to create several departmental MS Access databases.


AlliedSignal - Lenexa, KS
Executive Administrative Assistant
March 1990 - January 1997

Lyndhurst, NJ

Managed the V.P.?s meeting and trip schedule.
Organized department staff and logistics.
Created reports using Excel and Access

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NY-NEW YORK »
View all resumes in US-NY »

View other DATABASE ANALYST, ADMINISTRATOR resumes, Programmer / Developer resumes