| Contact Information | |
| Name: | Sandra Jackson |
| Email: | sjaxon1 (at) lycos (dot) com [email concealed] |
| Location: | Albany, Georgia, United States |
| Resume | |
| Position/Title: | Database Security Architect |
| Resume: |
Sandra Jackson Sjaxon1 (at) lycos (dot) com [email concealed] 2516 Belmont Drive Albany, Ga. 31705 229 420 8842 _________________________________________________________________________ Career Objective: To obtain a professional position and enrich my skill set in exchange for use of my various skills and knowledge. _________________________________________________________________________ Summary • Strong Database Administration, data conversion & data analysis experience • Strong extraction transformation and loading (ETL) skills • Strong Data Application Design experience • 15 plus years experience performing database design and implementation of database systems • Strong experience simultaneously supporting data analysis and administering needs for 21 governmental agencies • Successful experience with (VLD) Very Large Databases & data warehouses • Successful Design & Implementation of large data warehouses • Successful experience creating and implementing analysis and reporting tools. • Successful management experience of over 350 employees • Excellent PL/SQL scripting skills • Successful OLAP and OLTP experience • Strong Meta Data maintenance experience • Experience working with logistics, supply chain management shipping and bill of lading tracking systems • Successful database dictionary experience • Excellent SQL team leadership skills • 8 years experience data warehouse design & maintenance with Successful implementation of data marts for various departments • Strong experience supporting 19,000 + database users • Successful Full Software Lifecycle Development (SDLC) Skills Relevant Skills: • Data Conversion & Analysis ETL Tools: SQL Server Data Transformation Services (DTS), Oracle Data Pump for extraction transformation and load (ETL), Brio, Cognos Impromptu, Cognos PowerPlay, Brio, Microstrategy DSS Agent, Monarch, Forest & Trees Fox Pro, Crystal Reports, MS Excel, MS Access, SAS, & SPSS • Data Architect Tools: Erwin 4.x, AllFusion Model Mart, Platinum Repository/OEE (PROEE); Rational Rose; Sybase Power Designer • Database Administration Tools: MS Access, ACT, Oracle 10, 9, 8, & 7, TOAD (Tool for Oracle Database Administration), SQL Server 6.5, 7, 2000; MS Query, SQL Plus, PL/SQL, Sybase SQL, Transact SQL, Embarcadero: DBArtisian, DB Change Manager, Red-Gate: DB Compare & SQL • Operating Systems: Itanium, HP-UX, AS400, Linux Red Hat, Sun Solaris Unix, Linux; Windows 2000 Server, Windows Advanced Server • Other Tools: Rational ClearCase, Rational ClearQuest, Visio, MS Office Professional: Outlook, MS Word, Power Point; FrontPage, MS Publisher; Word Perfect, SAMS, Reflections Data Conversion and Data Manipulation • Use of SQL scripts to perform ETL • Manipulation Multi-Dimensional Data (Cubing) • Successfully create & manipulate data for OLAP and OLTP environments. • Successfully create data models for OLAP and OLTP environments for various schema versions. • Successfully develop, and implement data format parsing from all file formats into SQL Database formats • Use ETL tools including DTS, Crystal Reports, Microstrategy DSS Agent and other tools to create, maintain, & analyzed daily, weekly, monthly, quarterly, & annual budgetary reports. Data Management and Information Systems • Designed, implemented and maintained databases & data reporting systems for over 100 gigabytes • Performed preliminary scope research database and data warehouse design. • Implemented computer access and administration of group and user privileges for data schemas and database systems • Designed and Managed data warehouse and data mart environments for the use of reporting financial, production, operations, and marketing data • Successful management of numerous projects involving multiple versions of database systems and database schemas. Data Architect • Use and design using Star and Snowflake schemas • Use of normalization techniques include Boyce-Codd • Develop database schemas for business, financial, and operations applications • Facilitate staff meetings, schedules, projects and deliverables regarding data warehouse design and implementation • Work with Project Managers, Applications Developers, SQL Programmers, Database Administrators, QA testers to migrate large scale applications into development, QA / test & production environments Experience: Jan 2007 – Present Database Engineer United States Marine Corps via Concurrent Technologies I act as lead data conversion specialist to extract and import 85+ data sources for conversion and import into a Master Database Repository System. I also provide database administration across multi-platform server environments including UNIX, Linux, & Windows. I provided database and systems administration including data import, database design, creation, user security, role creation and privilege assignment. I provided server systems administration monitoring of daily, weekly and monthly operational processes, and maintaining user permissions and access. I performed (ETL) extraction transformation and load of various types of data. I utilized Oracle 9 &10 in a UNIX / Linux server environment. I developed project plans to achieve established objectives and time schedules. I utilized PL/SQL scripting. I performed project management and systems analysis to aid in the acquisition of new data source feeds. I designed and implement new processes, procedures, forms, work measurements tools to effect process improvement, work simplification, improvement of manual processes. I independently designed 2 full life cycle application BI business intelligence systems (a data import parsing tool & a metadata operational view analysis tool), while supporting numerous Marine Corps application data support needs including but not limited to Marine Corps Equipment Readiness Information Tool (MERIT), System Operational Effectiveness (SOE), Marine Corps Enterprise Total Life Cycle Management Common Operating Picture (E-TLCM-COP), Global Combat Support System Marine Corps (GCSS MC), Master Scheduling Support Tool (MSST). I analyzed each data source from various DOD database application sources including but not limited to local base systems. Nov 2006 – Dec 2006 Database Administration United States Marine Corps via Smartronix I utilized Oracle in a UNIX server environment to support mission critical logistics and financial business systems for the United States Marine Corps Logistics Base. Installed Oracle 10g Database software and set up instances on Itanium servers. Performed database backups, database backup planning, and database disaster recovery. I performed data imports and data exports. Performed systems administration duties utilizing SAMS software and Windows host sessions to maintain system and directories. Contributed to scope of new database standardized operating procedures. I attended daily meetings regarding status of production and development servers. Oct 2005 – Jan 2006 Database Analyst IBM via Manpower I performed data analysis utilizing Excel, Access, Brio, DB2, and AS400 from database systems. I created daily reports. I collected statistics. I managed employee compensation data. I acted as team technical lead. I created reconciliation reports. May 2005 – Sep 2005 Database Administrator Prenova Energy Corporation I performed database administration on Microsoft SQL Server Database systems. I maintained production, development and testing environments. I performed data warehouse design, data modeling projects and worked to normalize database design. I designed DTS Packages and worked as system administrator to move nightly data feeds into bulk load formats for batch jobs. I performed troubleshooting to resolve performance issues and responded to user complaints and trouble tickets. Jan 2005 - Oct 2005 Database Support Volunteer New Birth Cathedral I provided data and data conversion support to the New Members Ministries and to the Employment Ministries using the Shelby System, Microsoft Excel, Microsoft Access and One Call. I extracted data, cleaned data and loaded data as needed. Feb 2005 – May 2005 Data Technician True Value Hardware via Atlanta Temp Sales Using legacy systems, I maintained daily logistics allocation logistics system data feed information. I performed operational reporting. I updated the supply chain management system order data as needed. Responded to help requests and tracked missing shipment information and assisted in reconciliation of logistics system order processing. I prepared mainframe logistics data processing batch jobs using JCL Job Control Language. Pulled order data processing feeds and prepared batch job data for delivery. Nov 2003 - Mar 2004 Database Administrator Ernst and Young via MSI Technical via Technical Systems of America I performed database administration, and systems administration and analysis duties while supporting a financial application. I provided database administration including database design, creation, user security, role creation and privilege assignment. I worked closely with project managers, financials software team leaders of development, quality assurance and production environments. I performed quality of assurance, tracking down data abnormalities, researching and resolving problems systematically. I performed (ETL) extraction transformation and load of financial and accounting data. Created and maintained (DTS) data transformation services and data loading procedures. I gathered financial data research. Performed data analysis, created, scheduled and generated corporate reports. May 2001 – Nov 2003 Database Administrator Centers for Disease Control I provided database administration. I participated in the planning and the implementation of the production, development and testing environments for multiple database servers. I acted as the authority for tuning and optimizing database queries, database stored procedures, Indexes and other database objects. Perform database normalization practices. I performed monitoring of indexes & creation of database design. Create and maintain Indexes, Database Triggers, Input & Output Stored Procedures, Views and other Database objects. I was responsible for the monitoring and implementation of database security. I designed relational databases, which support mainframes, client server and web applications throughout the CDC. I performed systems analysis. Work with team to integrate very large databases. I created stored procedures, triggers and other scripts. This position required knowledge of IDEF0 & IDEF1X methodology. Perform Database design and reverse engineering using Erwin 4.x, CA ModelMart, Platinum Repository/OEE (PROEE), Cast (Platinum Software). I performed database, and Database application troubleshooting. I performed Database recovery for Healthcare agencies. I built database maintenance documentation and procedures Feb 2001 Sept 2001 Database Administrator Eshare.com I performed normalization of an e-commerce Web Portal Database and creation of database design. Create and maintain Database Triggers, Input and Output Stored Procedures, Views & other Database objects. Write Transactional SQL. Perform Database design and reverse engineering using Erwin (Platinum Software I performed database recovery for Healthcare agencies. Build and restore server operations. Build database maintenance documentation & procedures. Jul 2000 - Feb 2001 Database Administrator Carecentric I created and maintained Database Triggers, Input and Output Stored Procedures, Views and other Database objects. I created transactional SQL scripts. Performed Database design and reverse engineering. I acted as final level of support for customer helpdesk for the Smart Clipboard healthcare Software. I performed Database recovery for Healthcare agencies. Built and restored server operations. I built database maintenance documentation and procedures. I provided 24/7 support. I used tools such as Sybase SQL Anywhere & ASA 7, SQL Server 7, Rational Rose, Power Designer, Power Dynamo, Info Maker, Visio, Erwin, Delphi, Microsoft Project, Excel & Excel VBA, Crystal Reports, HIPAA coding and PC Anywhere. Jan 2000 - Jul 2000 Database Administrator ATC HealthCare I acted as technical data lead. I performed data modeling using Erwin for creation of ERD models. I worked with Senior Administrators and other professionals as a liaison to facilitate Enterprise Resource Planning (ERP). Duties entailed data normalization and ability to employ various data schema models. Manipulated and prepare data for reporting. Act as Report Manager. I trained lead SQL Server 7 DBA. I performed data transformation services. I performed data warehousing. I built standardized and ad hoc reports. Automate reporting. Perform project tracking. Built multi-user-client server applications using Visual Studio products and MS Access, Built databases using SQL Server 7 and Access. I troubleshot SQL, TNS Names, and Ora Errors as related to SQL and Oracle databases. Created Error Handling Procedures and conflict triggers. Upsized databases to SQL Server 7. I administered user privileges. Set database security and passwords and granted permissions. Sep 1999 - Dec 1999 Database Administrator BellSouth Corporate I.T I acted as technical lead and project manager. I acted as a data architect. I performed full life cycle development and support. I performed business model analysis and design. Built complete end user applications and complete databases. I utilized MS Access, Visual Basics, and write SQL on a daily basis. I also utilized Access, Crystal Reports and MS Query to query against databases. Aug 1997 - Sep 1999 Finance Department Database Administrator MediaOne Telecommunications Position required analysis of cable, digital cable, telephone and Internet services and the operations of these telecommunications services for a large international telecommunications company. Created and maintain financial reports and documents. Managed, analyze, and create daily reports from the billing system. I performed accounting and bookkeeping daily. I updated company performance ledgers daily. I performed troubleshooting as necessary. Position requires expert knowledge of relational databases and relevant software and utilization of SQL database skills. I developed database design. Position requires building data warehouses. I used of normalization techniques. I created reports and produced analysis documents. Developed query statements to obtain customer and non-customer data in response to requests for information. Required analyzing results of queries; compiling data; creating, maintaining, and distributing weekly, monthly and annual reports. Provided input to upper and senior management. I managed special projects from start to finish. I performed data modeling. I established global links to external databases. Installed ODBC drivers and administered ODBC data sources. Participate with the strategic planning process. Utilize SQL Plus, TOAD, Forest and Trees, Crystal Reports, Monarch, Excel, Word, Access, PowerPoint, Windows, SAS, and Micro Strategy in an (OLAP) in a client/server environment to manage Oracle databases. Write formulas, macros, and queries to obtain information, analyze data and produce reports. Training: Title: -Facilitator Company --Course Description Database Administration-Microsoft SQL Server Administration- New Horizons Database Development-Microsoft SQL Server Development – New Horizons Oracle Database Administration-Oracle Corp. --Workshop I Oracle PL/SQL Training -Platinum --SQL Advanced Querying, Forest & Trees (SQL Builder) -Platinum --Report Creation w/SQL, Intermediate Erwin -Computer Associates --Data Modeling database, Advanced Erwin -Computer Associates --Advanced Data Modeling, Platinum ModelMart -Computer Associates --Advanced Data Modeling, Platinum Repository -Computer Associates --Meta Data Management Enterprise Computer Security - SANS Institute-Security Essentials Enterprise Computer Security - Microsoft Security Training-Developing Secure Applications Education: Masters of Computer Science Strayer University (anticipated) Masters of Public Administration University of Georgia 1993 Bachelors of Science Criminal Justice Albany State University 1991 |