Candidates About

 

Debra Sherna Hall

 

Key Skills & Qualities

• Strong SQL skills in Microsoft SQL Server or Oracle environments

·         Expert knowledge in entire Microsoft Office Suite 2007/2010/2013/2016

• Highly developed in use of Excel (Vlookup, Pivot Tables, Macros) and Access (data manipulation, queries)
• Expert in data management, extraction and process automation
• Proficient with data management policies, procedures and common technical tools
• Strong analytical, evaluation and interpretation skills
• Excellent planning and decision making abilities
• Ability to exercise and control the executed tasks with the planned activities
• Excellent communication with both technical and nontechnical audiences

 

 

Professional Experience

City National Bank, Los Angeles, CA: September 2017 – February 2018

Senior IT Business Systems Analyst

·         Implemented functionality changes on large client facing web portal. 

·         Facilitated and elicited requirements from senior business leaders.

·         Translated and documented technical requirements for the development team, and ensured the needs of the business were met. 

·         Created project documentation ie: (BRD’s, HLD’s, FRD’s, System Requirement Documentation, Process

Mapping, high/low level Design Documents). 

·         Knowledgeable of all phases of the SDLC process. 

·         Created test plans/cases for data migration of Treasury Net management system.

·         Performed QA testing of web portal enchancements.

Environment: Agile Methodology (Scrum), Microsoft Excel 2016, Microsoft Word 2016, Confluence, JIRA, Microsoft Visio.

 

 

Wells Fargo, Clive, IA: July 2016 – June 2017

Data Analyst

·         Perform data mapping and transformation of data from current systems of record to a future state solution.

·         Facilitate and lead engagement with business teams in order to understand current systems of record of patch tracking.

·         Develop and maintance departmental SharePoint site of documentation and tracking for processes identified of business teams patch tracking current systems of record.

·         Evaluate and interpret Process Flows, work practices, and application development documents.

·         Provide written and verbal communications to both technical and nontechnical audiences.

Environment: SharePoint, Microsoft Excel 2010, Microsoft Word 2010.

 

 

Bank of America, Plano, TX: July 2015 – November 2015

Business Analyst

·         Performed business and data analysis to identify source data and existing controls that impact the quality of data in a Financial Services environment.

·         Conducted business and data analysis to identify and profile source data for regulatory requirements.

·         Gathered requirements of data controls in systems of origin and identify repositories.

·         Identified business process key controls that impact data quality (i.e. data management / data governance / project management and or program management).

·         Facilitated and led engagement with business and technology SMEs in order to drive results in a matrixed environment.

·         Evaluated and interpreted Process Flows, Business Process Management (BPM), and application development documents.

·         Provided written and verbal communications to both technical and nontechnical audiences.

Environment: Visual Studio 2010/2012, SharePoint, Microsoft Excel 2007, Microsoft Word 2007, Microsoft Access 2007.

 

 

 

 

JWT, Irving, TX: November 2014 – June 2015

Data Analyst

·         Supported the Database Marketing Department.

·         Provided support of the campaign management system (MarketWide).

·         Developed SQL queries to extract data from relational databases as needed to support business needs.

·         Updated, modified, deleted records in relational databases, which include Store Procedures.

·         Worked closely with the architects and other developers facilitating the design and development phases within the software/systems development lifecycle.

·         Trouble-shot, identified issues, recommended solutions, and implemented remediation processes directing developers accordingly.

·         A subject matter expert as it related to client’s business.

·         Actively participated in the business requirements phase, design phase and development phase of SDLC lifecycle.

·         Contributed to Quality Assurance by assisting in the development of test scenarios and scripts on the basis of business and functional requirements and design.

·         Performed testing, identified and documented bugs, debug, and applied fixes to applications.

·         Provided support on application errors and related tasks, as appropriate.

·         Maintained ad hoc tables, tested and promoted dashboards and reports.

·         Assisted with the creation, updating and closing of project/maintenance items via the TFS ticketing system.

Environment: Agile Methodology (Scrum), Waterfall Methodology, SQL Server 2010/2012, SQL Server Integration Services (SSIS) 2012/2013,

Visual Studio 2010/2012, Team Foundation Server 2010/2012, SharePoint, MarketWide, Microsoft Excel 2013, Microsoft Word 2013, XML Version 1.0.

 

 

AT&T, Richardson, TX: July 2013 – October 2014

Business Analyst (Architecture & Common Services Integration – Solutions, Trending, Analysis & Tactics)

·         Identified and reported on issues which impact clients and backend of high availability/high performance system.

·         Analyzed various components of architectural system level design.

·         Interpreted and analyzed XML request and response performed during UAT.

·         Performed data mapping for error handling database.

·         Researched monthly analysis of partner performance; then prepared and presented PowerPoint presentations.

·         Updated, validated and deleted records in error handling database.

·         Conducted research to determine issues caused by backend adapters.

·         Wrote SQL query to extract data from multiple tables for analysis and research.

Environment: MySQL Workbench 6.0 CE, Oracle 10.0, TOAD, Microsoft Excel 2010, Microsoft PowerPoint 2010, XML Version 1.0.

 

 

 

 

 

 

YP.com, Glendale, CA: December 2007 – November 2012

Data Collection Specialist

Position Description: Using proprietary technology (Fetch Technologies) to build automated agents for the extraction of data from publicly available websites. Performed analyses to determine feasibility of extraction, analyzed extracted data to comply with business and design documents/requirements.

·         Analyzed the business requirement document and prepared the data specifications.

·         Used SQL to validate the new system staging data with existing production data.

·         Involved in creating process flow diagrams to fetch the data from different systems and display in a report form.

·         Responsible for data mapping by writing complex SQL queries.

·         Generated and manipulated XML files to transform extracted data.

·         Acted as liaison between the business group and the technology team.

·         Communicated with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives thereby reporting to senior management about weekly status report & presentations.

Environment: SQL Server 2008, Oracle9i, TOAD, Microsoft Excel 2010, Microsoft XML.

 

Data Management Specialist

·         Acted as single point of contact for all data related issues/concerns (reviewed/assigned/processed all Certified Marketing Representative data requests upon receipt to department). 

·         Involved in writing SQL queries for ad-hoc SQL reports for technical analysis.

·         Full-filled ad-hoc requests according to user specifications by utilizing tools like TOAD and Excel.

·         Assigned and managed JIRA tickets for data related issues.

·         Liaison with customers for resolution of data issues to their satisfaction.

·         Built plans for new report roll out by interacting with business users and finalizing upon new requirements to facilitate better functionality.

·         Proficient in creating detailed design specifications for development teams and analysts.

·         Conduct meetings with the project managers and business users to gather and document the process flow using Visio.

·         Created and maintained house departmental guidelines and procedures for data processing and data management processes.

Environment:  SQL Server 2008, Oracle9i, TOAD, Microsoft Office 2003/2007 (Excel, Access, Word, Powerpoint), Microsoft Visio.

 

Data Quality Specialist

·         Involved in extensive data validation by writing several SQL queries and involved in back-end testing and worked with data quality issues.

·         Identified and provided recommendations for solving, and implemented solutions to provide data consistency and accuracy.

·         Worked with business users to define and analyze data related problems.

·         Conducted UAT sessions involving various types of users and define system refinements or acceptance.

·         Participated in various data analysis functions related to fetch data for processing reports.

·         Developed sample reports for data analysis on various levels of data required for Sales team.

·         Responsible to validate the data quality, integrity between legacy and new system.

·         Analyzed the data model of various legacy systems and perform gap analysis with new reports.

·         Collaborated with various departments during testing/loading/project planning to validate documented requirements and complete User Acceptance Testing (UAT).

Environment:  SQL Server 2007, Oracle9, TOAD, Microsoft Office 2003/2007 (Excel, Access, Word, Powerpoint).

 

 

 

 

 

 

Amgen Incorporation, Thousand Oaks, CA: January 2007 – October 2007

Project Coordinator (ISI – Client Services)

·         Acted as liaison between 3^rd party vendor and field sales force ((VIPs, District Mgrs, Corporate Account Mgrs, Field Sales Reps, and AC's) to coordinate and track set up of managed home connectivity (Analog lines, DSL, Cable Broadband, WYFI, Routers, and Modems).

·         Created, monitored and modified work order requests for field sales staff.

·         Imported Excel data reports analyzed and exported data to Microsoft Access database.

·         Worked with technical escalation teams’ in house and 3^rd party vendor.

·         Responsible for managing and escalating vendor issues.

·         Identified potential issues and develop mitigation plan and/or corrective actions.

·         Produced monthly reports showing connectivity status and monitor SLA reports for all field and home office connections.

·         Lead and coordinated weekly conference call meetings with vendor and company representatives.

·         Created meeting agendas, took minutes and distributed action items lists.

·         Produced ad-hoc reports.

 

 

Policy Studies Incorporation, Denver, CO:  November 2004 – July 2005

Quality Assurance Specialist (Government Health Services Division)

·         Performed UAT (User Acceptance Testing) on new system functionality developed to enhance operations and/or meet changing regulations.

·         Developed test plans and scripts designed to test changes or enhancements made to program-specific systems.

·         Knowledgeable of state and federal rules governing eligibility determination, member enrollment, and account maintenance processes for public health care programs.

·         Supervised the User Acceptance Testing (UAT) to test the usability of the application.

·         Drive UAT activity, plan for and ensure all pre-requisites are met prior to the UAT, support business users in UAT planning, formulating test cases.

·         Defined User Acceptance Test Plan and rollout schedule.

·         Performed both monthly and ad hoc QA on Government Health Services Division (GHS) programs by reviewing member account information maintained in program-specific systems and measuring actual outcomes against expected results set forth in approved QA/UAT Team policies and procedures.

·         Prepared written analysis of errors and corrective actions to be taken.

·         Provided customer support to client representatives for application changes and enhancements.

 

 

 

 

 

 

Washington Group International, Johnston Atoll - JACADS (Johnston Atoll Chemical Agent Disposal System): December 1994 – October 2003

Production Controls Analyst

·         Designed, developed, implemented and maintained Access databases and Excel spreadsheets for production controls.

·         Knowledgeable of facility processes and productions indicators.

·         Analyzed and prepared trend analysis for the following production controls.

·         Performed cost/scheduling controls in accordance with the contract statement of work and the Earned Value Management System.

·         Supported cost/schedule managers with requirements and variance analysis.

·         Evaluated manpower, man-hour, and labor cost requirements versus budget limitations.

·         Evaluated material, subcontract, and vendor costs to determine future requirements (compared actual cost to funding limitations).

 

Environmental Compliance Technical Support Analyst

·         Using Microsoft Access to identify and implement computer-based applications to facilitate and automate routine and repetitive activities.

·         Developed and maintained Access database for all necessary records related to shipping and disposal of solid and hazardous wastes.

·         Maintained critical departmental Access databases to allow easy access to and manipulation of data by department staff.

·         Provided software applications training to department staff.

·         Supported external clients with importing and exporting of data from Access databases to create Excel charts and graphs.

 

Education

 

Candidate for Bachelor of Science, Computer Science, California State University, Dominguez Hills