Project Sql Server
Resume:
Sharon B. Rogers
East Brunswick, New Jersey 08816
(732) 238 - 7265
Email:***********@*****.***
Summary:
• Business Systems Analyst with over 10 years experience writing documentation for business
users, programmers, and testers. Planned, designed and created scope documents, release
notes, business requirements, functional requirements/systems specifications, use case, quick
reference card, instructional manuals, and installation guides. Modified use cases and a user
guide.
• Research expert, who determines content by conducting in-depth interviews with subject matter
experts, reviewing existing documentation and examining existing systems.
• Liaison between the business and technology department translating business language into
technology requirements and vice versa
• Proficient in SQL, MS Access, Oracle, Excel, Toad. Have a Microsoft Certification in SQL Server.
Worked with Source to Target Mappings.
• Leader and organizer of document reviews.
• Strong interpersonal and communication skills. Self-motivated, creative, resourceful, organized
and detailed oriented professional.
Education:
Masters of Business Administration May 1991
Rutgers University, Newark, New Jersey
Major: International Business. GPA - 3.6/4.0
Minor: Finance
Bachelor of Arts Degree May 1981
La Salle University, Philadelphia, Pennsylvania
Major: Computer Science and Math
Computer Credentials:
Software Skills:
Office Tools: MS Word, MS Excel, MS PowerPoint, Visio
TeleConference Tools: Web Meeting, Sametime Meeting
Process: Clear Quest, SharePoint, Calligo
Project Management: MS Project
Databases And Tools: Oracle, SQL Server, MS Access, Toad, SQL
Languages: XML, HTML, JavaScript, Java, Fortran, COBOL
Certifications:
MCP in SQL Server 6.5,
Rutgers University Web Developer Certificate (Java),
HTML, Javascript, ColdFusion, XML, Flash, Dreamweaver
Sharon B. Rogers
25 Cosgrove Court
East Brunswick, New Jersey 08816
(732) 238 - 7265
Email:***********@*****.***
Project Experience:
Business Systems Analyst
Metlife September 2007 - December 2008
• Reviewed and analyzed the business requirements that described enhancements to an
eBusiness Human Resources application. Investigated and determined solutions to address
requirements. Articulated solutions in writing in a functional specification document. In addition,
created a traceability matrix. As a result the developers had detailed information to commence
the design and the business had confidence all their requirements were addressed.
• Led a JAD session with developers and project leader to define the detailed requirements for an
eBusiness project. Incorporated the requirements into use cases. Therefore, testers had detail
information to write test cases and scripts.
• Oversaw testing which included unit, systems, regression, and UAT testing for an eBusiness
project. Presented to the testers the enhancements. Reviewed test scenarios for completeness
and accuracy. Led bi-weekly meetings with testing and developers. Managed the defects. As a
result the test cycle completed on schedule.
Short-Term Assignments August 2006 - December 2006
• Merrill Lynch - Created a quick reference card for an internally developed Unix function. Wrote a
Systems Requirements Specification that described enhancements to a Financial Advisor tool.
Therefore, business users had a resource to refer to for information on the function and the
systems changes.
• Avaya - Revised and standardized an 80 page Marketing and Sales User Guide with
contributions from multiple writers. As a result the document had one voice.
American Reinsurance December 2002 - June 2006
• Acted as the business single point of contact to the underwriters for their questions regarding data
of an in-house application. Investigated questions by creating and running ad hoc SQL queries
and working with developers. The result was reports with quality answers presented to the
underwriters.
• Wrote release notes for programmers and testers in projects that adhered to the Software
Development Life Cycle (SDLC). These notes outlined the software changes for an in-house
underwriters’ application, which was developed in Visual Basic and PL/SQL. As a result
programmers reduced time to produce code.
• Created and executed test cases for unit, systems, regression and UAT testing. New
enhancements of application went into production with no major problems to the users.
Sharon B. Rogers
25 Cosgrove Court
East Brunswick, New Jersey 08816
(732) 238 - 7265
Email:***********@*****.***
Prudential Insurance Company October 2001 - January 2002
• Wrote a Scope Document, which was a high level description of the Passport project. The main
goal of this ETL (Extract Transform and Load) project was to convert data stored in VSAM files
into a relational database. As a result everyone on the team had the same basic knowledge of
the project.
Avaya August 2000 - May 2001
• Performed data analysis and developed business rules for the data model. Communicate the
results of the analysis and the rules to the Database Administrator.
• Converted business requirements into systems specifications for the customization of a third party
vendor eBusiness ordering application that interfaced with an Oracle database and SAP. The
testers reduced the time to write test cases.
• Prototyped requirements by designing and developing web pages utilizing Microsoft FrontPage.
This visual representation enabled business user to solidify requirements earlier in the project.
AT&T September 1999 - December 1999
• Updated existing business requirements documents with recently implemented changes to a local
ordering system. As a result the documentation reflected the system.
Prudential Insurance Company May 1997 - November 1998
• Wrote requirements for an in-house legal system for testers. This made it possible for the testers
to write test cases.
AT&T January 1995 - May 1997
Merrill Lynch November 1994 - January 1995
Givaudan-Roure, A Hoffman La Roche Company September 1994 - November
1994
Systems Engineer/Marketing Representative
IBM Corporation July 1985 - June 1993
Associate Programmer
IBM Corporation March 1983 - July 1985
Data Quality Analyst
Insurance Services Office December 1981 - March 1983
Contact this candidate