Post Job Free

Resume

Sign in

Project Sql Server

Location:
Spring, TX
Salary:
95,000
Posted:
March 20, 2014

Contact this candidate

Resume:

***** ******* ***** **

Spring, TX *****

E-mail:

acc8pv@r.postjobfree.com

281-***-****

Yolanda E. Houston

OBJECTIVE

I would like to obtain a position as a Business Analyst within a reputable

company.

CAREER SUMMARY

. Ten plus years of experience in the IT industry as a Business

Analyst

. Other IT positions include systems analyst/development/design,

technical writer, configuration analyst, and IT instructor.

. Five years experience working in the Oil and Gas industry.

. Five years in the Human Resources industry.

. Have managed tasks and trained a group of 5 or more Business

Analysts globally.

. Have worked effectively with global teams

. Highly proficient in Microsoft Office Applications, Visio,

Project, and Excel, and Access

. Have worked effectively with PeopleSoft, JD Edwards, Oracle, and

SQL products.

EDUCATION

University of Houston

BBA in Computer Information Systems, Dec 2000

TECHNICAL SKILLS

Programming Languages: Visual Basic 6.0, SQL7.0, JCL, COBOL, C++, HTML,

Operating/DBM Systems: Mainframe, MS-SQL Server 7.0/2000, Oracle/SQL

database knowledge, Active Directory, Windows XP, 95/98, 2000, NT, ME, some

UNIX and LINUX, MS Exchange, Meridian Power User,

Software: WorldPort, PeopleSoft, JD Edwards, MS Visio, Excel, Access, Web

Ex, SameTime, Adobe Acrobat, Adobe Photoshop, TopTeam, Power Point,

FullShot, MS FrontPage, Project 98, Crystal Reports, Lotus Notes, MS

Outlook, Outlook Express, Netscape Navigator,

Hardware: Personal Computer, IBM, Macintosh, Scanner, Router

Relational databases and data models-DB2, Access, Oracle

WORK EXPERIENCE

Fiserv

Stafford, TX

Sr. Business Analyst

09/2013 - Present

Manage implementations to generate bank statements for clients all

over the United States.

Establish and document requirements both functional and technical.

Faciltate and manage data transactions and data files.

. Faciliatate all client meetings and maintain direct and consistant

contact with the client.

. Troubleshoot all client issues from beginning to end of project.

. Utilize Agile system development methodology

. Systems used: FOCUS, AccuRev, JETS, WC3, Project Management

Application, eRoom. OutputSolution Mgt.(OSM)

CEVA Logistics

Houston, TX

IT Business Analyst

06/2011 - Present

. Documented business and functional requirements for WorldPort and

CLASS Logistics systems

. Created process flows and flowcharts for logistic operations

using Visio 2010

. Facilitated requirements gathering meetings

. Developed project plans and time lines using MS Project 2010

. Acted as a liaison between development team and business users to

define system requirements for WorldPort and CLASS

. Wrote test plans and participated in UAT, Integration and Unit

Testing

. Created spreadsheets using MS Excel

AIG

Houston, TX

Business Analyst

04/2011 - 6/2011

. Documented business and functional requirements for developing

and enhancing HR systems and websites

. Creates process flows and flowcharts for SAIGE system

. Wrote Business Requirements documents for SAIGE system

. Researched and analyzed employee information in SAIGE

. Facilitated requirements gathering meetings

Mercer HR Consulting

Houston, TX

Business Analyst

08/2009 - 11/2010

. Documented business and functional requirements for developing

and enhancing HR systems and websites

. Wrote process guides using MS Word 2007

. Wrote SQL queries to produce Adhoc and customized reports and

exported reports into Excel

. Wrote SQL queries using Oracle 9.0 to produce reports and gather

data

. Documented business processes by creating dataflow diagrams and

process diagrams using MS Excel and Visio

. Created and updated process guides and issues logs using MS Excel

and MS word

. Met with clients directly to review and enhance business

processes and system requirements

. Participated in all phases of testing (i.e., Integration,

Regression, UAT, Unit Testing)

. Facilitated requirements gathering meetings to obtain functional

and technical specs

. Wrote test plans, test scripts, and use cases

. Used Citrix applications to analyze client data, write queries,

and perform file comparisons

. Manipulated and updated client data in Business Workstation

application

. Managed client system requests in Seibel system

. Analyzed client issues and developed resolutions

. Ran batch jobs to produce Medical carrier files and payroll files

for ADP

. Performed quality assurance checks on all outbound HR files

(payroll files, healthcare files, etc.)

. Acted as a liaison between development team and business team to

define system requirements and build these into managed

implementation plans

El Paso

Energy

Houston, TX

Business Analyst

Contract: 2/2008 - 10/2008

. Responsible for providing BA functions for several Project

Managers and IT projects (big and small) implementing SDLC

methodology.

. Key player in major project to enhance accounting reports.

Reports were housed in Gas Master system running on an SQL

server. Reports were moved into PeopleSoft to complete general

ledger.

. Reviewed and gained knowledge of FERC requirements to ensure that

all accounting processes were in compliance

. Acted as a Liaison between IT group and the accounting group to

define system requirements to implement a new integrated

accounting application

. Wrote SQL queries to produce reports using Oracle

. Wrote and created test plans, test scripts, and developed test

cases

. Facilitated and planned training sessions for new integrated

accounting application

. Provided support during implementation (i.e. answer questions on

usage of system, address usage issues that arise through problem

tracking system / end-user emails).

. Provided status reports to all stakeholders (end-users and

management) to communicate progress on projects on a weekly

basis.

. Created and presented to stakeholders context and data flow

diagrams for energy applications

. Utilized MS Project 2003 to create project time lines and to

manage project tasks

. Led and facilitated meetings with end users, SMEs, and upper

management to determine business processes and requirements for

integrated accounting, and waste tracking systems

. Developed a broad understanding of Waste Tracking, Credit Risk,

and Accounting systems for upstream oil and gas activity. All

applications had a .Net platform.

. Create data flow diagrams and process diagrams for complex energy

applications

. Established and documented business processes

. Wrote and reviewed functional requirements documents as well as

technical design documents.

. Coordinated and participated in all phases of testing for

integrated accounting system (i.e., integration, unit,

regression, and user acceptance).

. Coordinated and participated in all phases of testing (i.e.,

integration, unit, regression, and user acceptance).

Fortis Energy Marketing &

Trading Houston, TX

Business

Analyst

Contract: 04/2007- 10/2007

. Key player on IT management team and responsible for gathering and

developing system requirements. Company plans to replace existing

system (Gas Master) with proposed ERP system (Commodities XL)

. Planned and coordinated enhancements and upgrades of accounting

system

. Wrote and created test plans, test scripts, and developed test

cases

. Key player in training accounting department associates on new

CXL system.

. Maintained a thorough understanding of all enterprise business

processes related to the Oracle Accounts Payable

. Observed and documented day-to-day activities of schedulers and

accountants

. Created process diagrams, data flow diagrams, and cross functional

diagrams for commodity accounting procedures

. Performed gap analysis between existing accounting system and

proposed accounting system

. Conveyed all technical design requirements to the IT development

team

. Facilitated meetings with end-users, SMEs, and upper management to

identify system needs, objectives, desired features, and input and

output requirements

. Analyzed business requirements/user needs and translated them into

functional and non-functional system requirement

specifications.

. Prepared and presented all stakeholders with well written business

requirements, system requirements, and technical design documents

. Utilized MS Visio to create process flow diagrams including cross

functional diagrams using swim-lanes, flow charts, and context

diagrams

. Used MS Project to develop detailed work plans to ensure timely

completion of

projects

. Interfaced with development/design teams to ensure development

efforts were in line with requirements

Hewitt Associates

The Woodlands, TX

Business Systems Analyst / Configuration Analyst

05/2004 - 03/2007

. Reviewed and analyzed business requirements, use cases, and

functional requirements for new applications or modifications to

existing applications.

. Wrote SQL queries to update/correct erroneous data elements in

DB2 tables and improve data quality

. Provided production support by writing SQL queries to modify

applications

. Wrote SQL queries to extract data from relational database (DB2)

to create reports

. Applied SDLC principles to project management and organization

. Documented configuration processes

. Wrote requirements for new applications, modifications, and/or

reported defects

. Communicated and escalates application defects to Lead Analyst

. Troubleshoots and analyzes production defects

. Conducted training courses for clients and staff globally

. Developed training materials used to train clients and staff

. Configured the system to meet client requirements and

specifications

. Used Sametime for instant messaging and web conferencing

. Created and maintains application issues as defects are

identified

. Identified and implemented resolutions for application defects

. Participated in project team reviews to review test cases,

documentation, and other project related docs

. Maintained defects in a defect tracking database CSL Maestro

. Modified JCL code of batch jobs and run jobs to retrieve and test

client systems

. Wrote test plans, test scripts, and develop test

cases

. Updated automated test scripts as needed

. Wrote acceptance test criteria and test plans

Computalog Drilling Services

Houston, TX

Document Control Admin/Technical Writer

Contract: 01/2002 - 05/2004

. Maintained and operated MS SQL server databases, JD Edwards and

Meridian Power User, which were written in VB 6.0 using Access

2000.

. Provided installation and upgrading services for MS SQL Server

database.

. Provided help desk/desktop support for end users using SQL server

database s and Microsoft suite tools.

. Created, exported, and migrated data into SQL server databases

using Access programs written in VB.

. Wrote and updated user guides, training manuals, and help files

for software of 200+ pages that included step-by-step

instructions, screenshots, and functionality descriptions.

. Wrote and updated Users Guides for JD Edwards and Meridian Power

User DBMS.

. Wrote and maintained work instruction documents for manufacturing

oil-drilling tools; developed and modified digital photos using

Photoshop.

. Wrote and executed testing procedures for testing MS Windows

upgrades and SQL database performance monitoring.

. Assisted end users with password and user-id issues related to

accessing the database system.

. Ran reports from MS SQL Server database using SQL queries in

Access.

. Created and maintained payroll spreadsheets using Excel 2000.

Schlumberger Inc.

Houston, TX

Business Analyst/QA

Contract: 07/2001 - 01/2002

. Gathered and analyzed requirements for Smart Card

applications.

. Wrote and edited procedure manuals for Smart Card

applications.

. Created test plans and test scripts for Smart Card

applications.

. Reviewed Release Notes and User Guides to establish testing

strategies for testing

software.

. Logged, verified, and closed defect tickets utilizing the bug-

tracking tool: Test Track

Pro.

. Communicated with developers and management teams to validate

fixes and review project time lines.

. Installed and tested software on client PCs and MS CA servers for

Shell's Smart Card (personal identification card with microchip)

project.

. Modified and executed test scripts for testing Smart Card

applications developed for Shell Inc. Applications include Card

Management System and Smart Login.

. Performed regression and installation tests on all Smart Card

applications using Entrust and Microsoft CA servers.

. Tested Smart Card User Kit applications on Windows NT 4.0,

98/2000, ME, XP, Unix operating systems.

. Performed complete testing on Smart Card applications using the

following card readers: Reflex 20, Reflex 30, Reflex USB, and e-

gate Reader.

. Tested middleware using RedHat, SuSe, and Mandrake 8.1 LINUX

versions of UNIX for Department of Defense (DoD) security

project. Also tested DoD on Windows 98, 2000, ME, and NT 4.0.

. Utilized Active Directory to perform test scenarios using a

CA/Citrix server.

Texas Southern University

Houston, TX

Software Development Instructor

Contract: 08/2000 - 07/2001

. Wrote and presented lectures to teach the format and structure of

writing systems design documents

. Explained the processes of the systems development life cycle and

systems analysis

. Used Visio to instruct students on how to create flowcharts and

data flow diagrams

. Organized computer lab activities for teaching systems

development (programming), utilizing Visual Basic Applications

(VBA) and Visual Basic 6.0; Database development using SQL, MS

Access, Excel, Web Development using

HTML.



Contact this candidate