Sql Server Management
Resume:
PAMELA A. MELNICK
North Aurora, IL
***********@*******.***
CAREER PROFILE
Experienced business analyst with a strong technology background looking
for an opportunity to be a contributing member of a dynamic and successful
organization.
. Experience leading and coordinating efforts to analyze, design,
code, test and implement new software solutions.
. Proven ability to interact with people at all levels of an
organization.
. Excellent written and verbal communication skills, project
management skills, analytical experience with root cause analysis.
. Experience working independently as well as within a team.
. Strong knowledge of commonly used concepts, practices, and
procedures used in systems analysis and software development.
. Detail oriented problem solver with ability to identify problems,
their causes, and implement solutions.
. Highly organized and able to exercise good judgment.
PROFESSIONAL EXPERIENCE
10/05-Present DIAMOND INSURANCE COMPANY, Schaumburg, Illinois
Systems Analyst II/Database Programmer
Special Project: Project managed development of new policy
management system. Reverse engineered and documented Access
based policy management system in preparation for buy/build
decision; vetted off-the-shelf products, vendors and developers
to replace existing policy management system; engaged developers
for a custom solution; liaison between internal SMEs and
developer consultants; gathered requirements; wrote
specifications; monitored project timelines; tested solutions.
Responsible for the creation of policy system data warehouse
(SQL Server) and created SQL DTS package to repopulate data on a
daily basis; creation of Crystal Reports and ad hoc queries to
support management in making critical business decisions;
administration of Business Objects XI; wrote data integrity
scripts to verify successful data feeds between disparate
systems; played key role in data cleansing and data validation
in the data migration phase of the development of Diamond's
workers compensation policy administration system; involved in
daily care and feed monitoring of all system processes; assisted
network admin in providing end user support and various other
network related activities.
6/96 - 10/05 NEUMANN HOMES, INC., Warrenville, Illinois
Programmer II - Functioned as business analyst and member of the
Acquisition Transition Team (1/05 - 10/05)
Interfaced with newly acquired business staff to gather key data
for integration into the Neumann Information System. Performed
data transformation activities (SQL) to insure all data ported
was useful and accurate. Wrote training documents for use in
training acquired business staff.
Programmer II - Functioned as data analyst and junior database
administrator (2/03 - 1/05)
Analyzed opportunities for system improvement based on results
of researching, auditing and reconciling system-wide data and
root-cause analysis (SQL). Built positive, cooperative
relationships between business units, national support teams and
the IT Department. Assisted database administrator in managing
SQL Server. Created scheduled jobs and DTS packages.
Web Developer (6/00 - 2/03)
Developed and maintained proprietary CRM business applications
and benchmarking reports in a web-based intranet environment. MS
SQL Stored procedures, triggers, views.
IT Operations Specialist (6/96 - 6/00)
Facilitated the identification and documentation of business
system needs. Acted as liaison between management, end-users and
developer consultants. Project managed development process.
Tested new programs for compliance to business requirements.
Produced ad hoc reports using MS Access and MS SQL and MS Excel.
Prepared end-user documentation, provided end-user training and
desktop support.
EDUCATION
* National-Louis University - Bachelor of Science in Management - 2000
TECHNOLOGY
* MS SQL Server 2000/2005--stored procedures, DTS, SSIS, user defined
functions, views, triggers, query analyzer, profiler, data cleansing,
matching and merging routines, backup/restore, maintenance plans
* Business Objects XI; Crystal Reports; MS Word; MS Excel; MS PowerPoint;
MS Viso
* Experience with Visual Basic; ASP; HTML; VBScript; JavaScript; Visual
Studio, .Net
ADDITIONAL TRAINING
* Software Testing and Inspection Methods - The Learning Tree (9/05)
* Developing High-Performance SQL Server Databases - The Learning Tree
(8/04)
MEMBERSHIPS / AWARDS
* Member of the Information Technology Team responsible for Neumann Homes
receiving the 2004 Top Technology Award from Big Builder Magazine
* Neumann Homes "Information Technology Team Member of the
Year" (2002)
References: Available Upon Request
Contact this candidate