Project Sql Server
Resume:
Spring, TX *****
E-mail:
**********@*****.***
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