Sql Server Project

Irena Rafes

http://www.linkedin.com/pub/irena-rafes/89/154/883

Email: ***********@*****.***

**** **** ******/**** ***/NJ Phone: 917-***-****

SUMMARY:

. Senior IT Professional, system/data/business analyst with a proven

hands-on experience and a record of delivering smart, innovative,

defect free desired products in Agile and Waterfall.

. 17 + years experience with SQL Server and Sybase modeling and

development, VB.NET dev.

. Highly Experienced in Analyzing, Coding, Documenting, Managing and

24/7 support of full SDLC projects ranging from web based to legacy

systems.

. Detail Oriented Professional with Excellent Communication, Analytical,

Organizational and Multitasking skills.

Certifications:

Certified scrum master, Certified green lean six sigma belt, Business

Systems analysis-IIBA Endorsed Training

Technical skills:

. SQL Server, Sybase, Oracle, Visio, PowerPoint, Lucid Chart; Data

Stage, MS Project, MS Access/Word/Excel, import data using DSN, Visual

Basic 4, 5, 6, Visual Basic.NET, telnet, TCPIP, crystal reports,

crystal server, VDI, TFS, PVCS, Source Control, Embarcadero, MSI

packages, creating setups, Citrix, TWS, ODBC, flat files, creating

run books.

. Agile (Scrum, Kanban), burn down charts

. Platforms: Windows XP/Windows 7, UNIX

QUALIFICATIONS:

. Have extensive experience in gathering and documenting business and

function requirements through interviews, application development

sessions with users, existing processes, and through creating ad hoc

queries for data analysis and data modeling.

. Highly experienced with sql server development, modeling, back end

data analysis, back end data modifications, ad hoc queries, crystal

Reports, .net.

. Achieved high standards for team; made quick decisions, solved

problems and produced high quality results. Had high rating reviews

through the years.

EXPERIENCE:

2014. ASCAP IT Department NY

07/2007- 03/2014 Sr.System Business Analyst/Data Architect Ascap

Collaborated directly with business users and software development team to

bring legacy system enhancements from initiation to successful completion

during the conversion effort from Sybase to SQL Server. Received a personal

recognition from the upper management.

Collaborated directly with business users and software development team to

bring legacy system enhancements from initiation to successful completion

during the migration of the data center. Received a personal recognition

from the upper management.

Was responsible for production support, new functional enhancements and 24

hours support of the seven legacy systems and web applications with local

and international users.

Responsibilities:

. Analyzed, gathered and created business and function requirements

documents.

. Collected databases and systems specifications in areas affected by

the migrations from Sybase to sql server

. Gathered design specifications, created mockups.

. Created specifications for data ETL(extract, transform, load)

processes. Worked with metadata.

. Created documentation on the scope and change requests, including

tasks, deliverables, milestones, resources, inventory lists.

. Created use cases, data flow diagrams. Documented and implemented

various system setup packaging, deployments, and various performance

challenges. Have strong experience in handling and automating code

deployments from dev to QA to production.

. Managed a team of developers and provided code changes in .Net

environment.

. Performed system configuration, changes in ini files, registry, ip

addresses, DSN changes and ODBC changes.

. Created successful project plans, recaps of the meetings, test plans,

contingency plans, use cases, Data Flow diagrams, and project lessons

learned.

. Managed full SDLC.

. Researched and suggested new technologies, identified areas where

technology can lead to increased efficiency and productivity by

suggesting using IBM Datastage instead of vb.net. Provided detailed

research for improvement. Implemented speed and cost reducing methods

to the users by modifying various algorithms in their daily routines.

. Suggested, documented and implemented long term solutions and new

technologies.

. Arranged and documented different initiatives, such as creating MSI

packages, maintenance of code in TFS, UAT, regression testing and

deployment in QA and production, contingency plans, run books,

participated in off hours support.

. Managed scheduling and monitoring weekly SQL/Sybase jobs through TWS

(Tivoli scheduler) and UNIX.

. Acted as the central client point of contact throughout the life of

the projects between a user community/operations/DBA/IT developers and

management.

. Resolved conflicts, monitored and communicated project status to upper

management.

. Utilized agile and waterfall methodology to plan project deliverables

to meet release schedules.

. Resolved production issues, provided 24 hour production support,

answering questions on sql and sybase jobs.

. Suggested speed reducing mechanisms, for example, by adding indexes on

the tables, increased speed of processing of big volume data.

Researched and successfully implemented the approaches.

. Provided End users support and training on the various applications

and tracked open issues.

. Created and updated numerous Stored Procedures, using Sybase/SQL

Server, which were used to produce standard Reports for user specific

needs. Successfully updated Stored Procedures were required because of

changes in the application database schema, new end-user requirements

and performance issues, which have emerged over time as the database

has grown.

. Created and updated VB codes, SQL scripts and Crystal reports.

. Worked with MS Access to manage Data changes and extracts.

03/2005-07/2007 System Business Analyst /SQL Developer Ascap

Responsible for analysis and implementation of seven major legacy

applications upgrade to .NET and SQL Server 2008..

Responsibilities:

. Acted as the central client point of contact throughout the production

release and the applications support.

. Documented use cases, data flow charts, systems specifications and

areas affected by the upgrade, gathered design specifications, created

documentation on the scope and change requests, including tasks,

deliverables, milestones, resources, inventory lists.

. Maintained regular communication with both the user and internal

teams, and constantly managed user expectations.

. Achieved user satisfaction through successful delivery of defined

project scope.

. Compiled user requests and deployment issues, to provide the best

quality and reliable bug free systems.

. Managed SDLC

. Coded or/and delegated work to the consultants and testers.

. Suggested, documented and implemented automation of manual processes

in order to save money. Suggested and implanted successfully changes

in technologies that improved applications performance.

. Created Crystal Reports, ms access reports, unix jobs and SQL stored

procedures to analyze data and report to the users and management.

. Was responsible for production support.Translated technical specs into

user training materials and user demos/training. Translated user

requirements into system specifications. Estimated efforts and

documented prioritization.

8/1997- 03/2005 Technical Business Analyst/Sr Software Developer

Ascap

As a part of Legacy Team was responsible for analyzing and documenting SQL

processes and VB front end applications that were converted into

PREP(Performing Rights Enterprise Program).

Responsibilities:

. Created technical specs and requirements documentation.

. Coded, tested and managed UAT.

. Documented development and upgrade of Survey Legacy applications into

PREP.

. Developed and documented new requirements, back up plans, system

specifications, use cases, and data flows.

. Managed off shore and in house consultants.

. Managed SDLC.

. Managed approval of delivery policies, procedures and standards that

enhance the performance of Service and improve user satisfaction.

01/1997-08/1997 ProWorks Consulting Group Consultant

Responsibilities:

. Developed vb.4 and Sql server application for accounting and medical

billing firms and documented efforts.

08/1996-1/1997 Yamaichi bank of NY Consultant

Responsibilities:

. Ensured accounting

. Worked with UNIX/SQL Server, VB as part of Business Management group

EDUCATION: San Diego State University B.A in Business

Administration

Vilnius University B.S. in Mathematics and Computer Science

Honors program

Volunteering: Sports legacy institute -great cause- concussion prevention

program

Languages: English/Russian/Ukrainian

Contact this candidate