Data Project

Susan Baker

Education: MBA (MIS) / Status: US Citizen / Current Location: Roanoke, VA or Brookfield, CT

Contact: 804-***-**** (Cell) / Email: **********@*****.***

LinkedIn: https://www.linkedin.com/in/susan-baker-212b8a67

POSITIONS HELD:

System Architect / Database Engineer / Oracle Consultant / Database Architect / Project and Technical Lead/Manager with approx. 15 years of experience in Database Design, Programming and Analysis of Database Information Systems.

PRIMARY SKILLS:

Oracle 12c, 11.2g, 10g to 7

Microsoft SQL Server 2012 to 2008,

PostGres 9.2.3, MySQL 5.0, Informatica 9.0, SQL Loader, SQLPlus, PL/SQL, T-SQL, Packages, Procedures, Functions, Triggers, Database Design, Administration and Management

Oracle Forms, Reports, Developer 2000, SSIS, SSRS, SSMA

Designer 2000, CA Erwin Data Modeler, Embarcadero ERStudio Data Architect, IBM’s Rational Data Architect, Visio

Oracle Enterprise Manager(OEM), TOAD, SQL Developer, SQL Navigator

Microsoft Office: Word, Excel, Access, PowerPoint, Publisher, Outlook, Project

DATABASE PLATFORMS:

Windows NT/2000/2003/XP, UNIX

OTHER SKILLS:

MKS Source Integrity, Visual Source Safe, Tortoise versioning, CVS versioning

C++, C#.NET, VB.NET, ASP.NET,

CorelDraw, Photoshop, PageMaker, AutoCAD

DATABASE WORK EXPERIENCE:

(Architect/Modeling/Designing, SQL/PLSQL/TSQL Programming, Consulting) (15+ years)

Database Management: Assessed and applied data governance, data quality, data integrity, master data

management, rules and validation on relational databases. Conducted various projects in data Migration and

executed ETL on data from various sources to targets.

Database Design: Designed, installed and configured multiple databases, as well as in the designed and

programmed the Database Access Layer

Data analysis: Obtained internal or external customer input, analyzed data and conceptualized and designed

databases based on input.

Database modeling: Generated conceptual, logical, physical and dimensional Database Models. Reverse

engineered source databases from varied platforms to a physical model to facilitate transportation between

compatible target platforms.

Database Security: Implemented views, Row level security (RLS/FGAC), DBMS obfuscation and data

encryption, PL/SQL wrapping, roles and privileges to enforce database security.

Data Migration: Loaded and extracted data and from various sources (text file, ASCII files, excel spreadsheets,

MS-Access, XML) using SQL Loader, data conversion tools and xml functions. Migrated data from other relational databases like MySQL, SQL Server using external vendor tools like Data Loader and PostGres using tools like PostGres Plus Advanced Server’s Enterprise Migration Toolkit.

Performance Tuning: Tuned queries using Explain Plan. Analyzed query performance before and after the use

of indexes. Generated statistics for database objects and made recommendations based on optimizer statistics and planner feedback.

Database size: Worked with large databases greater than 10 Terabytes.

Database Programming: Created, modified and deleted tables, views, indexes, clusters, synonyms, sequences, procedures, functions, packages, triggers and other database objects. Programmed using SQL, PL/SQL to select, create, update and delete data. Generated forms and reports.

Quality Analysis and Testing: Created use cases to test database integrity and work flow.

Project Management: Created project plans, timelines, baselines, and work assignments. Worked with team

members and across teams to enable timely execution of deliverables and work items.

Agile SDLC development: Used iterative and/or waterfall methods to plan database developmental work to fit project requirements and styles. Worked with client’s/business users to identify business requirements and technical requirements and prepared Functional and Technical documentation, Test case scenarios, User defined forms and reports and database documentation

EDUCATION: MBA/MIS (Aug 1998 – May 2000)

Virginia Commonwealth University, Richmond, VA, GPA: 3.75/4.00

CERTIFICATIONS & ACHIEVEMENTS:

•Oracle Certified Associate, Oracle University

•ASP.Net Server side programming, Virginia Western University, Roanoke, VA

PROFESSIONAL EXPERIENCE:

Battelle, Charlottesville, VA (Remote)

Database Architect/Tech Lead

July 2016 – Sep 2016

Worked as the Sr. Database Architect/Modeler/Developer/Technical Lead on the CBRNE (Chemical and Biological, Radiological, Nuclear, Explosive for Statistical and Meta-Analysis of Realistic Threats) Project-Phase I to stage data for migration between Oracle and Oracle, Oracle and SQL Server and MS-Access and SQL Server databases, using tools like SQL, PL-SQL, T-SQL, SSMA (Access and SQL Server 6.0), SSIS packages and stored procedures and functions. Directed and facilitated work across cross functional teams and assisted with ensuring timely completion of project tasks. Designed target databases and reports for the client and the complete migration process. Interacted with front end users to assist with planning for web applications and design. Responsible for creating specifications for the Functional and Technical design of the database programming layer as well as the Database documentation. Created the foundation procedures and functions required by the web programs that selected data for Phase I.

Virginia Department of Agriculture, Richmond, VA

Information Technology Specialist II / Data Architect

March 15 – July 16

Designed and developed a new Cardinal system to house data for VDAC’S new vendor related information. Extracted, Transformed and Loaded data from various sources into the new Cardinal system from VDACS data providers. Created processes and forms to validate and view vendor extracts. Created processes to reconcile data based on monthly vendor extract report submissions. Created summarized and executive information forms and reports based on requirements. Analyzed business requirements and transformed them into Functional and Technical specifications. Designed sub systems to handle transactional data and historical data.

Pharmaceutical Product Development, Richmond, VA

Sr. Systems Developer / Systems Analyst

July 14 – March 15

Principal system architect for the new system of reporting for the sample reporting functionality.

Modified/Reviewed/Created existing/new designs for PPD’s Sample Management System, ASSIST and other related systems using tools like Oracle Forms and Reports.

Migrated data from other systems within PPD and client sources, to ASSIST, using existing tools, as well as developed new tools and programs, wherever necessary.

Affinion Group (Connexions), Richmond, VA

Sr. Database Developer / Technical Architect / Data Architect

May 13 – June 14

Principal designer for major systems and subsystems, utilizing a thorough understanding of available technology, tools and existing designs.

•Analyzed, designed, developed, tested, and implemented efficient solutions involving diverse platforms, software, technologies and tools.

•Provided complete technical management and leadership on large IT initiatives

•Accountable for effectiveness, quality, and timeliness of project design decisions in line with Enterprise wide Technical Architecture (EWTA) governance.

•Consulted business at the highest technical level on all phases of SDLC.

•Worked with management to identify extremely complex business requirements and processes.

•Researched and evaluated solutions and delivered proposals that met business needs.

•Analyzed existing systems against IT and business strategies and made well-defined recommendations

•Acted as expert technical resource to others on new technologies and design techniques

•Defined and managed technical standards including coding, testing, and methodology for team in accordance with EWTA governance.

•Designed and architected new systems or major enhancements to existing systems.

•Reviewed physical and technical designs of systems

•Provided regular, constructive feedback, guidance, and support.

Advance Auto Parts/APC, Roanoke, VA

Sr. Database Architect

Feb 11 – May 13

Responsible for planning and direction of the Electronic Parts Catalog (EPC) project by providing expert level knowledge of database technologies, design alternatives and their implications.

•Established the database environment, classes, programming objects, database programming layer and naming standards for the project areas

•Managed issue identification and problem resolution process

•Addressed systems development and integration issues

•Created a prototype as part of design and estimation efforts

•Conducted code reviews on various sprints in the iteration

•Researched ETL tools and RDBMS to fit project requirements and finances

•Integrated test plans and conducted testing on assigned integration threads

•Production Staging, Launch, Piloting and Post Implementation assignments as required

•Populated various environments with appropriate AAIA test data

•Build bulk data load software for centralized EPC databases and push data for Store databases

•Responsible for database security in the development and test environments

•Submission of reports on disk capacity estimates and database physical design information

•Monitored resources including CPU usage and space utilization in all environments

•Executed and optimized queries on behalf of the development team and the business users, identifying potential barriers to project success and offering proactive solutions that align to the culture and operating model of the Company and the project team

Meridium Inc., Roanoke, VA

Database Developer / Engineer

Dec 07 – Mar 08 and Oct 09 – Feb 11

Worked on Meridium's Core framework databases (Oracle and SQL Server) that support its Asset Performance Management (APM) System. The APM system provides information to various manufacturing/industrial clients on how to increase production capacity, lower costs, limit risks and downtime.

•Conducted regular and baseline upgrades and testing on the core database both local and client, including changes to the design, documentation, data conversions, query optimization, data modeling and performance tuning during various upgrade cycles.

•Helped in migrating of the RDBMS to the recent database versions (Oracle 9i to 10g to 11i and SQL Server 2005 to 2008), as well as data migration.

•Also been an integral part of customer database upgrades including (error identification, rectification, importing and processing data from xml to improve performance, monitoring and reporting.

•Programmed in SQL, TSQL and PL/SQL to support applications on dual platforms.

•Identified problems, created tasks, work items, determined work assignments and recommended problem resolutions

•Monitored performance and grid locks to assist in smooth conduct of operations.

•Researched software and other products to solve current and future needs of the organization. Studied trends and emerging technologies that could affect growth and future direction of the organizational needs and goals. Conducted a study on cloud computing to determine changes that may need to be effected to promote the migration of existing technology in this direction.

Inforeliance, New Carrollton, Maryland

Oracle Consultant

May 07 – July 07

Worked on the IRS XML Relational Database (XRDB) (Oracle 10g) that provides information about corporate taxes and establishes organizational interfaces between Corporate Data & Systems Management Division, Product Assurance, Tax Exempt Government Entities (TE/GE) and Mission Assurance.

•Migrated XML type data from staging tables to the main database

•Performance tuning, SQL and PL/SQL programming

•Used tools like Designer, TOAD, SQL Developer, Developer suite and Beyond Compare.

Virginia Bioinformatics Institute, Blacksburg, Virginia

Database Engineer / Administrator / Project Lead

June 05 – Apr 07

Worked on the design and development of an integrated Proteomics RDBMS including genomics, transcriptomics, proteomics, metabolomics, pathways, computer modeling, and advanced analytical tools, funded by grants from the NIH (National Institute of Health) and the NIAID (National Institute of Allergy and Infectious Diseases). The database is the first of its kind in the area of Bioinformatics.

•Assisted Lead Scientist in Proteomics project management tasks in the capacity of a Project Manager by working with software designers and research scientists by being an integral part of the SDLC of the project. Created baselines/timelines, requirement documents, held meetings and follow ups to manage the project.

•Developed, maintained and monitored databases using tools like ERWIN and OEM

•Migrated data from flat files, tab-delimited, XML files to oracle.

•Scheduled regular exports, imports, data pumps, hot and cold backups

•Conducted regular study of data storage, usability, audit, performance statistics

•Created schema and schema objects like tables, views, packages, procedures, functions and triggers, and rules like roles and privileges

•Designed the data access layer using SQL and PL/SQL programming

•Used tools like TOAD and Microsoft Project.

•Other DBA and oracle programmer related activities

R&K Engineering Inc., Roanoke, Virginia

Programmer Analyst (Systems)

June 00 - June 05

Worked on a DOD Interactive System of co-coordinating Real Property Requirements between Army/NG sites and their respective Regions.

•Worked on Modernization of existing applications by moving them to a .NET platform using C#, ASP.NET, VB.NET.

•Analyzed various Systems and designed applications and programs for the Real Property Management system of the Department of Defense using Oracle 8i/9i, Macromedia-Authorware and MS-SQL server.

•Designed and developed The Interactive Timecard System (Payroll, Employee, Project records) using CASE Tools like Designer and Developer.

•Worked as the Lead programmer for the Real Property Inventory System – Phase I for the NAVY & Marine Coors with Oracle 9i and SQL Server as the backend RDBMS and .NET as the interface.

•Developed an Interactive Computer Based Training for the Real Property Planning of US Military Installations using Macromedia Authorware.

•Designed, Administered and Managed Oracle databases (Performance tuning, Optimization, Planning, Exports, Imports)

•Creation and development of reports using SQL and PL/SQL.

Virginia Commonwealth University, Richmond, Virginia:

Summer Intern (Database Administration / Programmer)

June 99 – August 99

•Analyzed, Designed and developed the EIS system for the Graduate Admissions Office Planned and executed project to effect Query optimization, security and concurrency control on Oracle databases.

•Designed web pages and brochures for the Graduate School of Business using FrontPage, PageMaker and Photoshop.

Graduate Assistant (Database Administration / Programmer)/ Administrative Assistant

Aug 98 – May 99 & Sept 99 – May 00

•Managed the Microsoft Access database (creation of tables, forms, and reports).

•Web integration of student databases, record processing and report management

•Processed student applicants for admissions and communicated with students and administrative departmental heads with reference all matters from application to admissions

•Performed secretarial duties and interacted with other departments at the university for dissemination and procuring of vital information, correspondence and reports on a timely and ad hoc basis.

•Conducted Lab assignments and presentations, Classroom trainings and examinations, Test assessment and reviews

•Assisted professors in tests and study materials for classes.

•Assisted students that needed additional assistance/guidance.

Contact this candidate