TECHNICAL SKILLS:

• SQL Server 2017 Database
• SQL Server 2012 Analysis Services
• SQL Server 2012 Integration Services
• Oracle 11g
• Access
• MySQL 4.1
• DB2
• SQL
• T - SQL
• PL\SQL
• MDX
• XMLA
• PHP
• Visual Basic
• COBOL
• SQL Server Management Studio
• SQL Server Business Intelligence Development Studio
• SQL Server Profiler
• Toad for Oracle
• Quest Optimizer for Oracle and SQL Server
• FileZilla
• Microsoft Office 2013(Word, Excel, Access, Outlook)
• Confidential Accounting
• Cognos 8 BI(ReportNet), Impromptu Reporting, PM Reports
• Microsoft Frontpage 2003, Dreamweaver
• Visual Studio 2015
• SQL Server Integration Services 2015
• SQL Server Reporting Services 2015
• SQL Server Analysis Services 2008
• Windows 10/7/XP/Vista
• Windows Server 2012 R2
• Linux
• SQL Server 2017 SQL Server Agent

WORK EXPERIENCE:

Confidential, Raleigh, NC

Sr. Database Developer

Responsibilities:

• Creating and maintaining ETL packages that loads data from outside sources, that contain patient and provider data for North Carolina healthcare, into SQL Server 2012 databases.
• Maintain Microsoft Master Data Services 2012 that maintains master records for patients and providers.
• Maintain Profisee Maestro that is used for the front end of SQL Server Master Data Service.
• Created\maintained entities and strategies.
• ITIL Foundation certified in IT Service Management

Confidential, Glen Allen, VA

Data Integration Specialist

Responsibilities:

• Created SSIS logging methodology, so that data can be accumulated on how packages are running with emphasis placed on error logging, row counts being recorded at certain points within package execution, package runtimes recorded, and any warnings that may occur during execution.
• Create database copy using SSIS packages to transfer needed schemas, tables and columns into a Research database.
• This replaced a full restore that was being used which included a lot of data that wasn’t needed.
• Database size went from 880G to 90G, which saves Confidential money in space rental fees.
• Create and maintain SSIS Regression testing process and checklist.
• Manage SISS Regression testing as needed when functionality is added\updated in the CORIS solution.
• Participate in visits to Adult Facilities and Parole and Probation offices, to meet with the employees to see what we, at Confidential, can do to make their job easier and more efficient and to create fellowship with the employees in the field, which makes for a better work environment for everyone.

Confidential, Columbia, SC

BI Analyst/Programmer

Responsibilities:

• Maintain Data Warehouse by creating\maintaining SQL Server tables, corresponding procedures and SSIS(SQL Server Integration Services) packages that migrate fact and dimension data from Oracle tables, Sharepoint list and Excel files to SQL Server data staging, fact and dimension tables that populate the various cubes. Work with SSAS(SQL Server Analysis Services) to create and maintain OLAP objects such as cubes, dimensions, roles, data source views and data security.
• Work with SSRS(SQL Server Reporting Services) to create canned reports using different data sources(SQL Server cubes, SQL Server data warehouse, Oracle relational tables) that are deployed on SQL Server report server and presented thru Sharepoint by using Dashboard Designer.
• Subscriptions are also created\maintained using these reports. I also work with users on how to use Excel 2010 to create Ad-Hoc reports.
• Member of Oracle Application Development team that maintains Oracle databases used in the Oracle Applications accounting software.
• Converted customer and sales data of companies purchased by ATD. Created/maintain PHP programs that read .csv flat files and used embedded SQL statements to do Inserts into the Oracle database.
• I also create ad-hoc SQL Insert/Update statements for more specific data maintenance.
• Created PHP programs that read MYSQL tables that were populated from outside customer feeds, compared that data with what was in the Oracle database, wrote out any discrepancies to a flat file and had that flat file FTPed to the corresponding customer.
• Work with SQL Server 2008 R2, Oracle 10g, and MYSQL 4.1 databases.

Confidential, Herndon, VA

Data Conversion Consultant

Responsibilities:

• Confidential Data Conversion consultant responsible for going to client sites and migrating data from Confidential, System1 and legacy systems to Confidential .
• Used ETL (Export, Transformation and Load) tools to handle migrations.
• Worked with restructuring of client data on existing Confidential systems such as merges, transformation, and data clean up such as merging of like vendor ids into single vendor id, changing items originally defined as goods to parts and remapping of general labor categories to more meaningful general labor category names.
• Worked with Oracle 10g, SQL Server 2000 and SQL Server 2005 databases.

Confidential, Moyock, NC

Confidential DB Administrator

Responsibilities:

• Keeping Confidential up to date through patches and updates(copying newer executables and running SQL scripts)
• Troubleshooting when database problems arise(slow running, data integrity, etc.)
• Provide analysis on setups and technically applying setup decisions
• Prepare input files and execute preprocessors to get large amounts of data into Confidential
• Providing support for users whenever they had questions on how modules in Confidential work
• Create users and apply user permissions as requested by supervisors in Confidential and SQL Server, General knowledge on where Confidential data exist in SQL Server database( Confidential ) and which tables hold needed data.
• Converted Confidential database from a 10 company setup back to a single company setup using SQLTalk and Query Analyzer to modify tables.
• Also remapped proj ids, org ids, acct ids and vend ids during this database conversion to handle duplicates that existed in more than 1 company(except accounts, which are above company ids), use org ids to define the different companies and to align proj ids more logically for accounting.
• Used Cognos Impromptu Administrator to create catalogs of data from the SQL Server production database and used those catalogs to create reports.
• We then upgraded to Cognos 8 BI, that I loaded on a local server and I used Framework Manager to create and publish data packages of data using relational and dimensional modeling and these packages were used to create reports using Query Studio and Report Studio.
• I also coded SQL statements to create reports.
• Load Confidential on users computers as needed(including software, ODBC database connections).
• Download required data from Confidential in support for Sage Timberline, Concur Expense, PowerTime Electronic Confidential software.

Confidential, Portsmouth, VA

Sr. Computer Consultant

Responsibilities:

• Member of the Material Access team that creates and maintains the software that handles inventory control
• Worked with 10g Oracle database creating tables, procedures, triggers, functions, views.
• Create and maintain forms using Oracle Forms as our tool to create interfaces with the database by creating the layout of forms using text boxes, labels, drop down list text boxes, radio buttons, checkboxes and action buttons by putting these objects on a form canvas and then by writing and maintaining PL/SQL script and stand alone SQL statements to handle branching, exceptions and data manipulation.
• Created static reports and dynamic reports (where the user can enter criteria that will retrieve more specific information) using Oracle Reports with underlying PL/SQL code and Business Objects 6.5 to retrieve data from the database into formatted reports based on users request.
• Responsible for MAT team's website on the Shipyards local intranet.
• I create and maintain our Web Pages using a combination of Microsoft Frontpage 2003, HTML and Javascript and use ASP and PHP to give the pages the needed functionality in communicating with the database

Confidential, Virginia Beach, VA

Systems Analyst

Responsibilities:

• Worked on Oracle 9i database creating and maintaining schemas, tables, procedures, triggers, users, user rights, views.
• Created and maintained PL/SQL by entering or updating SQL code blocks (that performed inserts, updates, delete and queries to the Oracle 9i database) as user needs arose and as their request for information changed and also creating and changing code in the procedural part of the PL/SQL block to handle branching and exceptions that may occur with data that is retrieved or manipulated.
• Created and maintained Web forms using HTML and Javascript, and the associated programs (PHP, ASP, Perl Confidential ) interfacing with the Oracle 9i database, so employees may enter project budgets, update budgets, purchase requests and retrieve information on purchases and pending purchase requests from the Internet to the Oracle 9i database using SQL code and the results would be reflected in the Confidential Accounting software which interfaced with the Oracle 9i database.
• Created static reports and dynamic reports (where the user can enter criteria that will retrieve more specific information) using Cognos Impromptu Reporting and PM Reports that retrieved data from the Oracle 9i database and also created and maintained user defined reports using SQL, PL/SQL, Confidential script, PHP, and ASP code to retrieve data and format the data at the users request. Link the reports to our Confidential web site using HTML links and Netscape Navigator.
• Met with users to talk about their needs, then research and provide a solution (creating web pages, creating reports and/or forms, creating database objects, etc) to where they get the data and information that they need to carry out their daily tasks.
• Implementation of the Confidential Electronic Confidential software for Internet use and create various web reports that retrieve data from the Confidential database and overall knowledge of how Confidential Electronic Confidential software interacts with the Confidential database (i.e. tables, procedures, triggers, user rights and views).
• Created a schema (Training) and needed tables with primary and foreign keys, using Oracle Enterprise Manager, for conversion of web training tools, queries, and tests from an Access 2000 database to our Oracle 9i platform and changed the code in the associated programs to interface with the new tables in the Training schema.
• Implement Confidential Accounting software and overall knowledge of how Confidential Accounting software interacts with Confidential database(i.e. tables, procedures, triggers, user rights and views).
• Create and maintain UNIX jobs that download data from from Confidential System1 to Confidential Electronic Timesheets.