Project Manager Sql Server
Resume:
To Whom It May Concern:
You will find my work experience and qualifications are well suited to the
position.
Currently I am a Technical and Data Analyst and for a healthcare company
while they are implementing new software.. I have over 20 years of
combined experience with building, maintaining and streamlining databases,
and data analysis. I have an extensive reporting and analytical employment
background. I am well versed in the methodologies associated with data
storage and, movement. My strong technical background in relational
databases, programming, business process documentation, and reporting
systems make me a valuable asset to any project or department.
I currently live in Ocala Fl, But will be moving to the area within the
month.
Thank you for your consideration,
Theresa Roman
843- 343-9188
THERESA ROMAN
*CELL 843-***-**** *EMAIL *************@*****.***
Computer Applications
Windows: 98, NT, XP, 2000, Windows 2000/2003
Server
Programming Languages: SQL, HTML, VB
Software: SQL Server 2000, Business
Objects, SQL PLUS, HL7 Protocol, Cognos, Crystal
Reports, Microsoft Query, Microsoft Project, SSR,
Visio, People Soft, Personify, SMS, Power
Builder,Active Directory, NT and Windows 2000
Server,TOAD for Oracle, Microsoft Visual Studio,
Server Management, and Reporting Services, Verdt
Experience
AVMED- GAINESVILLE, FL
Current as a Consultant,
. Technical Data Business Analyst
. Interface programming
. Databases
. Stored Procedures, sqlloader Functions and Triggers
. Reports, Crystal,SQL, Access and other data sources
CARECORE NATIONAL- BLUFTON SC
4/2009 - 9/2009
Data Analyst
. Interface programming
. Databases
. Stored Procedures, sqlloader Functions and Triggers
. Reports, Solutions using reporting services
. Extract data and build report
. Troubleshoot data issues
. Meet with internal clients
. Query multiple applications using SQL (Oracle, SQL Server, DB2).
. Utilize SQL Query Analyzer and SQL Server 2000 as reporting services
tools.
CFG for Essex County Correctional -NEWARK, NJ
5/2008 - 4/2009
Database Administrator/ Analyst
. Normalize data and establish procedures to ensure proper data
collection
. Requirements gathering, business process re-engineering solutions,
electronic medical records (EMR) setups, and documentation of
analysis.
. Administer data resources. Insure data availability, integrity and
security HL7
. Assure organization of data as well as "front end" application for
end user accessibility.
. Query multiple applications using SQL (Oracle, SQL Server, DB2).
. Work with administrative and medical staff to ensure data meets QA
requirements
. Utilize SQL Query Analyzer and SQL Server 2000 as reporting services
tools.
. Create and Maintain Reporting through Crystal Report, Access, Excel
and other data formats.
. Monitor performance and manage parameters on databases to provide
maximum efficiency.
Horizon New Jersey Health
12/2007 - 5/2008
Consultant for Data Analyst for Financial Services
. Analyze, design, develop, implement and support information
processing applications.
. Analyze data to determine trends in births, dental, "high cost" and
other medical procedures.
. Worked with claims department on monthly basis to ensure proper
payment to physicians.
. Build software, databases, spreadsheets, and custom reports using
Microsoft Access, Excel.
. Create and Maintain reports for auditing purposes.
TMA Resources
12/2006 - 12/2007
Business / Software Analyst
. Utilized SQL, MS Project, Access, HTML, Visio, Business Objects and
Crystal reports to implement member management and financial
softwares.
. Requirements gathering, business process re-engineering solutions,
product setups, prototyping and documentation of needs analysis.
. Conduct discovery sessions to define key business drivers, project
scope and define technical requirements.
. Work closely with IT project managers, database programmers and web
developers.
. Communicate regularly with technical, applications and operational
staff to ensure database integrity and security.
. Utilize SQL Query Analyzer and SQL Server 2000 as reporting services
tools.
. Help programmers develop web applications.
. Generate high-level design documents to provide programmers the
business logic and requirement.
. Creates and maintains effective relationships/communications between
IT project managers, database programmers and web developers.
. Conduct E-business analysis sessions. Included gathering business
rules, look and feel, validation, etc.
. Utilized MS Visio to show how data flowed between tables and
databases.
. Assisted and trained client staff users in software setups,
applications, and procedures as well as create training manuals for
end users
New Jersey School Boards Association 2/1996 - 12/2006
IT Specialist
. Analyze, design, develop, implement and support information
processing applications.
. DBA -Serve as primary support for critical database/management
systems.
. Design, analyze, document, test and validate business processes
. Build software, databases, spreadsheets, and custom reports using
Microsoft Access, Excel, SQL,
. Develop and conduct staff training courses.
. Manage the Association's database and communications protocols.
. Used VB to create outlook forms and functional front screens
. Managed helpdesk and provided top level support to end - users
. Project Manager/technical lead in acquisition of AMS/Great Plains
software.
. Created scripts using SQL for an unprecedented 99% accurate
conversion from old mainframe to newly acquired AMS system
Technical Background
. Analyst, analytical, management, data mining, data modeling, data
analysis, database design and relevant tools
. Data Migration strategies, HL7 protocol
. Technical documentation
. Advanced Microsoft Access/Office skills
. Advanced report writing, query skills (Crystal, Access, Report Smith,
RSS,BO )
. Proficient with VB and/or VBA, HTML and other programming languages
. SQL Views, Stored Procedures, SQL Conversion scripts
. MS Business Objects
. Troubleshooting software and database technical issues
Contact this candidate