Ernest R. Blackwell

acqf2f@r.postjobfree.com

*** **** *** *** *******, SC

864-***-****

Summary of Technical Skills

Technical Skills

•Oracle systems analyst, development, and database administration experience

•SQL Server Management Studio with database development, creation of Data Marts and Data Warehouses, and use of ETL Tools such as SQL Server Integration Services (SSIS)

•Highly Experienced with Oracle9i Discoverer, PL/SQL, T-SQL, Dynamic SQL, .NET Frameworks, JavaScript, MDX, VB.NET, VBScript, C++, HTML, XHTML, XML, C#.NET, Oracle Report Writer, SSRS, AS400, DB2

•Experience with Agile and Waterfall methodologies

•6 years of experience with Data Marts and Data Warehousing utilizing Kimball and Inmon methodologies

•Trained in Data Warehousing under Geoffrey Cole who was mentored by Bill Inmon (creator of the Inmon methodology)

•Excellent troubleshooting, support and networking knowledge of PC H/W, S/W, client/server and networking systems

•Windows ME, Windows XP, Windows Vista, Microsoft Office 2007; MS Office (2000-2007), MS Excel, ARMS, HTML, beginning Linux and Oracle 10G, Adobe Photoshop, Macromedia Dreamweaver and Fireworks, SQL Server, Reporting Services, Visual Basic, and .Net Framework

Equipment Data Associates Charlotte, NC Data Architect Consultant (11/2014 – 5/2015)

• Contributed to the audience development/master data management project, took data from different organizational data sources, cleaned and link the data, and move it into warehouse and cube environments where it could be used by bi/analytics tools.

•Implemented Data Warehousing practices utilizing Kimball methodology

• Participated in code reviews and meetings in an agile environment

• SSIS package development utilizing T-SQL, C#.NET and VB.NET, Script Tasking

• Worked with large data sources manipulating data, dimensional modeling, and performance tuning

• Worked with Mailchimp api utilizing JavaScript and C# script task sources

• Utilized XML code view in SSIS to evaluate and change package details

Sompo Japan Insurance Charlotte, NC Data Architect Consultant (5/2014 – 11/2014)

• Utilized Microsoft ETL/data integration tools (SSIS and T-SQL scripts)

• Explained BI data model and dimensional model best practices.

• Planned and implemented Data Warehouse Schemas and designs

• Planned data warehouse model (star schema with facts, dimensions, staging and raw tables)

• developed code using TSQL in a Microsoft SQL Server Manager environment

• Planned and implemented Data Warehouse Schemas and designs

• Responsible for all SSIS packages and ETL design company wide

• Implemented dimensional and fact tables in the modeling of data in the data warehouse

Lamplight Media Charlotte, NC Data Architect (3/2013-5/2014)

• develop requirements for reports

•created all databases and tables with a star schema data warehouse

• Responsible for developing SQL Server Reporting Services reports and components

• Tested and debugged software; assisted in testing projects for other developer\analysts

•worked in an Enterprise environment

• Data Warehousing utilizing Kimball methodologies

• Created and deployed SSIS packages to move data utilizing scheduled jobs to run the packages

• Planned and implemented Data Warehouse Schemas and designs

•Reviewed BI Tools and vendors

Department of Social Services Columbia, SC Data Architect Consultant (11/2012 – 3/2013)

• Worked with business users to develop requirements for reports;

• Analyzed user needs, as required, and leads in the design of specifications to meet those needs

• Responsible for developing SQL Server Reporting Services reports and components

• Tested and debugged software; assisted in testing projects for other developer\analysts

• Delivered reports within time estimates

• Developed and documented design

• Data Warehousing utilizing Kimball methodologies

• Identified risks and communicates risks to the project manager and project team

• Minimized rework by utilization of best software engineering practice

• Supported and adhered to change management process

• Utilized Microsoft ETL/data integration tools (SSIS and T-SQL scripts)

• Explained BI data model and dimensional model best practices

• Worked with SQL Server Reporting Services (SSRS/ SSIS)

• Deployed BI over the Internet

Regal Entertainment Group Knoxville, TN Data Warehouse Specialist (3/2012 – 11/2012)

• SSIS, SSRS, Data Cubes, SQL Development, ETL, Data Warehousing, Data Marts, TSQL, SQL

Server

• Enterprise Environment

• Dimensional modeling under Kimball methodology

• Created reports in SSRS, ProClarity, Dashboards, from OLAP Cubes, and in Excel

• developed code using TSQL in a Microsoft SQL Server Manager environment

• Planned and implemented Data Warehouse Schemas and designs

• Data Warehousing utilizing Kimball methodologies

• Responsible for all SSIS packages and ETL design company wide

• Implemented dimensional and fact tables in the modeling of data in the data warehouse

Bank of America Charlotte, NC (remote/contract) Data Consultant (12/2011 – 3/2012)

• SSIS, SSRS, Data Cubes, SQL Development, ETL, Data Warehousing, Data Marts, TSQL, SQL

Server, DB2, AS400, Oracle 10g

• Created SSIS packages that truncated stage tables, loaded tables from a specific source (Oracle tables, SQL Server Tables, CSV, Excel, Sharepoint) using connection strings passed by variables utilized in package configuration tables and calling an Archive package

• Integrated date between Sharepoint and Load Tables in a SQL Server Database and updated projects regularly in Sharepoint

• Worked extensively with all aspects of BI in a Microsoft environment

• deployed SSIS packages and manifests to SQL Server DB for automation

• Implemented dimensional and fact tables in the data warehouse

• Worked with Business objects

• adhauc reports on Financial Data through queries created in SQL Server Management Services, SSRS, and a Data Cube

• Implemented dimensional and fact tables in the modeling of data in the data warehouse

• Worked with Business objects

• used VB.NET to change variable values and create other stored procedures within SSIS and SSRS

Environment -> SQL Server 2000-2008/SQL Server Management Studio/ SSIS/DTS/ VB.NET

TD Bank. Greenville, SC (contract) SQL Developer (07/2011 – 12/2011)

• Completed training (6235 SSIS) on SSIS from a Microsoft Certified Representative

• Used SSIS to Import and Export Data, integrate heterogeneous data, clean and standardize data, and support BI solutions

• Physical design and implementation SQL Server databases.

• Implemented dimensional and fact tables in the modeling of data in the data warehouse

• ETL (collected and cleaned data from various sources)

• Created queries for comparison of tables from SQL Server 2008 DB to SQL Server 2000 DB

• Created tables, databases, views, queries, and stored procedures

• Used visual basic script and VB.NET to optimize SSIS packages daily

• participated as a key member in the creation of a Data Warehouse and Data Marts

• Reviewed applications such as TOAD for query optimization and development

• Wrote comparison queries analyzing data brought in to new data base from old/production database to compare for accuracy of data between databases

• Worked extensively with all aspects of BI in a Microsoft environment

• Analyzed stored procedures for optimization and trouble shooting

The Palmetto Bank. Greenville, SC Data Analyst/ Developer (08/2010 – 06/2011)

Tested FiServ's Expedite platform software for deposits

Planed, designed, and implemented application database code objects, such as stored procedures and views.

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.

Provided database coding to support business applications using SQL Server T-SQL.

Performed quality assurance and testing of SQL server environment.

Developed new processes to facilitate import and normalization, including data file for counterparties.

Worked extensively with all aspects of BI in a Microsoft environment

Created VB.NET Forms

Implemented dimensional and fact tables in the modeling of data in the data warehouse

Worked with Business objects

Physical design and implementation SQL Server databases.

Created utility to upload data from SQL Server to AS/400.

Created utility to upload data from Excel files to AS400 and iSeries and create billing statements.

Retrieved data from SQL Server and AS400 to create different financial reports

Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.

Daily ad hoc reporting as needed around the bank using SQL within AS400 (DB2/DB200) in a high paced, growing environment allowing for split second financial decisions by Exec Mgt

Created and maintained monthly, quarterly, and regulatory driven reports

Implemented Database wide changes

Conducted a bank-wide audit of all custom reports already developed

Implemented Business Intelligence software allowing 23 power users to run their own reports

Drove all Data Management Initiatives (Data Warehouse, BI, Data Security, and Data Definition)

Built relationships by facilitating a quarterly Data Management Steering Committee

Formed and directed break out groups to help drive Data Management initiatives

Help restore corrupt data across 29 branches due to a server crash on first day of employment which prevented a bank-wide shut down at the last minute

FISERV audits, training, and interviews

Researched, developed, and created data management initiatives

Designed and pitched a Data Management Group Charter to the Technology Steering Committee

Presented, pitched, and championed a Data Management Roadmap before the Technology Steering Committee

Environment -> AS400/SQL Server (2008)/SQL Server Management Studio/ SSRS/ VB.NET/ MicroStrategy, IQ Query, Smart Query, QLink

Global Contact Services. Salisbury, NC SQL Developer (02/2010 – 04/2010)

Created, tested, performance tuned and implemented stored procedures, views, indexes and queries in Microsoft SQL Server 2000, 2005, 2008

Modified SQL queries using Microsoft Visual Studio.

Programmed in VB.NET

Physical design and implementation SQL Server databases. Supported all production operation activities, with focus on integration and development of new and existing products and services.

Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.

Implemented dimensional and fact tables

Worked with Business objects

Assisted new and existing clients with integration and data conversion activities.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Aided in development, execution, and maintenance of disaster recovery plans for all data services.

Planed, designed, and implemented application database code objects, such as stored procedures and views.

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.

Provided database coding to support business applications using SQL Server T-SQL.

Performed quality assurance and testing of SQL server environment.

Follett Corporation. Greenville, SC Report Writer (10/2008 – 07/2009)

TSQL Development in SQL Server creating views, queries, and indexes to optimize reporting

Create triggers to keep track of changes to the fields of tables when changes are made.

Maintain MS SQL Server 2005 and 2008, including security, configuration and install service packs upgrades.

Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.

Developed testing scripts using T-SQL to test new products developed in other languages.

Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.

Developed highly complex interactive reports (SSIS/SSRS) with TSQL used bySchool Districts across the US

oSome report requirements exceeded tool capacity, forcing use of intricate external calls to develop efficient interactive capabilities.

Completed successful training on custom SQL variant in only 20% of allocated time

Streamlined over 100 reports within three months, improving runtime of each report by up to fifteen minutes per run

Performed Quality Assurance on all reports developed by other SQL Server Report Developers

Excelled in customer facing and regular end user support, making contact with clients and obtaining requirements sessions/ documentation.

Analyzed advance functions in Visual Basic for report optimization and for QA

Developed Advanced expressions within layout using complex variables manipulation to develop the report to make design more attractive for the customer and optimize data on K-12 Testing

Environment -> SQL Server (2000, 2005, 2008)/SQL Server Management Studio/ SSIS/ VB.NET

United States Air Force. Tinker Air Force Base, Oklahoma Flight Manager (2004 –2007)

Developed advanced database (Oracle 9i) using PL/SQL for monitor aircrew qualifications and other aircrew-related programs saving the Air Force $183,000 yearly which showed the incorrect logging of flight hours/training by aircrew allowing hundreds of aircrew to gain flight pay they shouldn’t have been getting.

Constructed the triggers, tables, collections, functions, user defined datatype, procedures

Optimized tables for faster reporting

Entrusted to schedule weekly flights and incentive rides on the E3, including: filming for the movie “Transformers”, flights for the Canadian Ambassador, Government Officials, News Crews, etc.

Custom built Oracle reports that verified flight restrictions due to health problems, complete flying training, up-to-date physiological training, current aeronautical orders, and aircrew qualification

Built an Evaluations Tracker report in PL/SQL that verified up-to-date and overdue evaluations currently run monthly for the commander

Built a Mission Package Audit report (PL/SQL) that audited aircrew mission packages, making audits more time efficient by 75%, comparing various forms of data across fields and databases, showing inefficiency in the logging of flight hours and training in over 1,000 cases. Allowing management to take corrective action

Developed a Flying Hours Audit application that showed aircrew hours for comparison of up to 3,000 files annually

Programmed advanced reports (using PL/SQL) essential to the management of operations for 300+ assigned aircrew personnel.

Created and altered Oracle Reports to check 1,200 annual aircrew training events in Aviation Resource Management Systems (ARMS) which helped to maintain a 100% accurate database

Prepared flight plans and produced custom reports from Oracle 9i (SQL) to monitor individual flight requirements and unit flying hours

Became the “go-to” person for the Manager of the Flight Management team Tinker Air Force Base for the creation of all Oracle 9i reports

Advised upper management on matters pertaining to aircrew resource management systems (ARMS) providing clear understanding between departments

Technical trainer for all incoming personnel on basic and advanced functions of Oracle9i, ARMS, and PL/SQL

Utilized Oracle 9i and PL/SQL skills to create a report that identified and helped to resolve over 15,000 due date errors after failed Aviation Resource Management System (ARMS) 5.1 world-wide release

Environment -> Oracle 9i/10g

Military Security Clearances and Certifications

Oracle Report Writer, CPR, Safety, Security training, Suicide Prevention, Computer Security

Secret Clearance (inactive as of Honorable Discharge 08/2007)

EDUCATION

Community College of the Air Force 2004-2007

Flight Management

Greenville Technical College 2008-2010

Business

PROFESSIONAL ACCOMPLISHMENTS

Named the Distinguished Graduate of the Honor Guard Training Program

Nominated as Star Performer at an international military exercise in Canada for highest level of dedication to the exercise and fastest resolutions to technical road blocks

Graduated second in an intensive Oracle 9i report writing class of 30 Airmen at Fort Dix, NJ.

Contact this candidate