Sql Server Project

Paula Cocklin

**** ** *** ****** 360-***-****

th

Ridgefield, WA 98642 *********@*****.***

SUMMARY OF QUALIFICATIONS

Accomplished IT Senior Systems Analyst with 15 years of experience in

telecommunications, government, and Hi-tech industries.

4 Experienced in business process engineering and software development life cycle, including

analysis, design, development, testing and implementation of software applications.

5 Experienced in Project Management methodologies and related artifact documentation.

6 In-depth knowledge of Conceptual, Logical and Physical database modeling, mapping and

design using Embarcadero/ERStudio, SQL Server Management Studio 2005, TOAD,

PowerBuilder and Visio.

7 Skillful in utilizing SQL, PL/SQL and Transact-SQL to access data from application databases

for analysis and reporting purposes.

8 Excellent interpersonal, communication, writing and presentation skills; adept at managing

multiple projects simultaneously.

9 Strong skills in analysis, problem solving, communication, team leadership and

administration.

10 Adept in finding creative, real-time solutions to a wide variety of business challenges.

11 Industrious, self-motivated worker who can function independently but also works well with

others to achieve goals and meet deadlines.

TECHNICAL SKILLS

Languages/Systems: Oracle Advanced SQL, SQL Tuning & PL/SQL; Transact-SQL, SQL Server 2005;

MS Access; Unix Administration/Scripting (HP UX, Solaris 6 & 7); Perl, HTML, XML, Vendor-specific API

Programming, Windows 2000 & 2007 Applications.

APPLICATIONS: ERP – Lawson Financial/HR/Asset Management/Procurement-Requisition, Mitas Loan

Servicing, Oracle/MetaSolv Order & Provisioning, ACT! CRM; Database Support – SQL Server Mgt Studio

2005, Visual Studio 2005, Embarcadero/ERStudio, Qwest TOAD, PowerBuilder, MS Visual SourceSafe, Citrix;

Reporting – SQL Server Reporting Services, Crystal Reports, MS Access; User Collaboration – MS

Sharepoint Server, Groove Virtual Office; Network Monitoring – Netcool Product Suite, NetExpert; Service

Management – Numara Track-It!, HEAT, Magic, BMC Remedy; MS Office Apps (2007) – Visio, Access,

Excel, MS Project, PowerPoint, Word; Documentation – Adobe Photoshop & Acrobat, PageMaker, InDesign,

FrameMaker.

PROFESSIONAL EXPERIENCE

IT Systems Analyst II Integra Telecom 04/2008 – 12/2009

IT Systems Analyst providing system support for vendor and internally developed

applications and analysis support for managing business processes, information

flows, and the translation of business process outcomes and operational

requirements into designs and specifications for workable IT solutions.

12 Captured, clarified and presented business and service level requirements, expectations,

ideas and concepts to internal project teams and management. Generated supporting

SDLC documents including: requirements, business cases, process diagrams, systems

design, project plans, and production support guides.

13 Applied communication, analytical and problem-solving skills in negotiating priorities and

resolving requirement conflicts among various stakeholders.

14 Analyzed, sized and prioritized business user requests for application changes or

development of new systems.

15 Participated in project scope and quality control activities through peer reviews,

inspections, unit testing, functional testing, and walk throughs.

16 Contributed to multiple analytical efforts with collaboration through project documentation

and providing analysis support with data extraction from various data repositories and

subsequent data summarization and presentation preparation.

17 Supported enterprise applications with research, analysis and remediation of data and

application issues along with user guidance in defining application business rules for all

enterprise-wide users.

18 Provided recommendations and guidance to departments on process issues and

changes and potential implications of new products or system enhancements.

Business Systems Analyst II Portland Development Commission 10/2006 – 04/2008

IT Business Systems Analyst providing system support for vendor and internally

developed applications and analysis support for managing business processes,

information flows, and the translation of business process outcomes and operational

requirements into designs and specifications for workable IT solutions.

19 Captured business and service level requirements and designed new process flows to

optimise operational efficiency. Presented and clarified business users’ requirements,

expectations, ideas and concepts to internal project teams and facilitated consensus-

building on existing client business processes and systems.

20 Implemented change control management to communicate the feasibility of scope

changes. Provided impact assessments and comfortably managed a number of

concurrent projects, involving multiple teams, third party vendors and customers.

21 Participated in project scope and quality control activities through peer reviews,

inspections, unit testing, functional testing, and walkthroughs.

22 Provided recommendations and guidance to departments on process issues.

Represented the IT infrastructure team to other functional groups and communicated

process implications of new products or system enhancements.

23 Defined and created a wide range of documentation: business requirements, system

requirements, functional specifications, testcases and test scripts, wireframes (Visio),

GUI designs, Visio process and data flows, database design and modeling

(Embarcadero/ERStudio & SQL Server Management Studio 2005), training manuals, and

userguides.

SENIOR SYSTEMS ANALYST Electric Lightwave, LLC / Citizens

Communications 10/1999 - 8/2006

IT Senior Systems Analyst for Network Monitoring group and for an expanding

telecommunications company.

24 Captured business and service level requirements and presented requirements,

expectations, ideas and concepts to internal project teams. Facilitated consensus-

building on existing client business processes and systems.

25 Facilitated the integration of new applications, hardware and process modifications and

interfaced with SMEs to prepare BPR documents for ongoing projects. Performed GAP

and Risk analysis of existing systems and benefit evaluations for new systems.

26 Determined user/business/functional requirements. Created vision, scope, and use case

documents; business process models, use case diagrams, activity diagrams, and state

chart diagrams.

27 Prioritized business and systems problems; analyzed and conducted impact analysis.

Conducted Joint Application Development (JAD) sessions with stakeholders throughout

SDLC to resolve open issues.

28 Validated technical designs created by IT developers against functional specifications.

29 Created training and user guide documentation support for training and Help Desk teams.

EDUCATION AND TRAINING

Bachelor of Science – Business Administration University of Kansas, Kansas

Masters of Art – Art History University of Kansas, Kansas

ADDITIONAL TRAINING (Instructor/classroom)

Project Cadence Project Management Training // MS Project

Management:

SQL Server Mgt Intro to SQL Server Management Studio // Reporting Services // Analysis Services

Studio:

Embarcadero/ERStud ERStudio Data Base Modeling & User Training

io

Oracle: Oracle 10g: Advanced SQL & SQL Tuning Workshop // PL/SQL: Programming

Triggers

Oracle DB 10g: Programming with PL/SQL, Parts I & II

Netcool Omnibus Netcool User Training // System Administrator Training

Netcool/Impact 2.1: User Training // System Administrator Training // Advanced Developer Training

UNIX Administration: Intro to UNIX // UNIX–SysAdmin I // UNIX–SysAdmin II

Contact this candidate