profile Summary

• SQL developer experienced in design, administering, and maintaining relational databases, create complex SQL procedures, create SSRS reports and SSIS packages, VB/VBA programming. Work on site and remote with users to analyze and define data process needs, troubleshoot processes, implement appropriate business process solutions. Possess sound judgment and organizational skills, detail oriented, effective problem analysis, structured documentation skills, English clearly spoken, effective communication and customer service interaction, able to acquire all State and Federal security clearance levels. U.S. Citizen, English primary language clearly spoken.
• technologies
• Operating Systems: Windows all versions
• Languages: SQL, T-SQL, VBA/VBA Visual Basic 4.0/5.0/6.0, SQL
• Databases: MS Access all versions, SQL Server 2000 2008 R2, IBM Netezza, Oracle 11g
• Tools: Access Reports, SSRS, SSIS, Crystal Reports, Visual Studio, Connect Direct NDM, Control-M, Microsoft Office, SourceSafe, MS TFS, VISIO, MS Project

work experience

Confidential

SQL Data Analyst

Responsibilities:

• Develop multi-table SQL procedures to extract healthcare data from Trizetto QNXT back-end database for HEDIS reporting and development of healthcare outreach programs. IBM Netezza and Aginity for data warehouse analytics and reporting.
• Develop SQL based modeling methodology identifying member patterns for inclusion in proactive health intervention initiatives and improve health outcomes and member medical costs. Similar modeling methodology utilized to identify pharmaceutical and provider trends to indicate activities consistent with suspect prescribing and practice patterns.
• Develop SQL parameter based, custom code, SSRS reports for intervention and corporate level HEDIS performance level reporting, HEDIS measure reports for intervention outreach programs, SQL based reports for Provider, Member, Claims, and Encounter information, create Excel heat mapping custom reports. Create drill through, sub-report, nested data regions, drilldown action reports.
• Develop SQL and SSIS business intelligence solutions to migrate disparate source data into a centralized data mart structure, for HEDIS and SSRS reporting, SSIS flat file processing. T-SQL to create schemas, tables, views, stored procedures, alter tables and columns, table indexes, pivot/unpivot queries, CTE's, data de-duplication, data cleansing/conversion, ETL Automations.
• Drug Enforcement Agency DEA compliance investigation, specialized SQL based investigative data extraction and reporting.
• Access 2003 database migration to Access 2010, redesign forms, reports, replace macros with embedded VBA/SQL functionality for improved performance, create customized error handling. Split database into front-end/back-end configuration, create file import/export functionality, create auto populate functionality for member and provider information, create ordered tab auto form field population features to reduce data entry time and minimize human input errors. Create chronological timestamp driven comment entry fields. Develop VBA/SQL backup functionality for disaster recovery, create VBA based external file logging function for user traceability and data entry logging.

Confidential

SQL Developer

SQL Server 2005/2008 - Oracle 11g environment, SSIS ETL, SSRS development. Interact with project management resources to develop process methodologies, program new or modify existing database data manipulation procedures for web based client interfaces.

Responsibilities:

• Design, modify, and administer SSIS data transformation packages to process data flow between Oracle and SQL Server 2008 environment to client application interface database, work directly with project groups to create SSIS based process solutions from project requirements.
• Facilitate data element mapping between Oracle and SQL Server environments, migrate SSIS packages between development/test to production environments, use SSIS package configurations, variables, package checkpoints, multicast objects, data viewers and data transformation testing.
• Troubleshoot SSIS execution issues, determine cause of package failures, start/restart agent jobs.
• Oracle PL/SQL through TOAD and Linked SQL Server connection objects to query and manipulate Oracle data in production and dev/test environments.
• Develop SSIS ETL packages for Lotus Notes migration to SQL Server, data field mapping, data conversion, plan for and implement initial development of SSRS reporting from Lotus Notes migration.
• Use MS Access 2007 to facilitate ODBC connection between Lotus Notes for data modeling, incorporating Access as a data pass-through to SQL Server for SSIS extractions into SQL Server.
• Assist global DBA group with SQL Server database administration, create linked server connection objects, work directly with application development teams. T-SQL to create/copy/alter databases, create user logins, administer user roles, create and administer SQL Server Agent jobs, create-modify stored procedures and views, create table indexes and constraints, perform database backup and restore. Use SQL Server Profiler and query analyzer tools, create and execute database DDL and DML procedures.

Confidential

SQL Data Analyst

SQL Server transactional database and data warehouse environment, migration of Oracle to SQL Server transactional database and SSRS reporting for Ohio Department of Public Safety ODPS , Automated Title Processing System ATPS . Create forms and reports utilizing SSRS and VS 2008/2010 development environment. Created stored procedures, T-SQL, create development unit test plans, complete business and data analysis, create Visio database prototype forms/reports, create unit test plans, make presentations to client, Microsoft TFS source code environment.

Responsibilities:

• Create SQL parameter based reports within SSRS report developer environment. SQL and T-SQL to create stored procedures, create and alter tables and databases.
• Create custom SSRS code for embedded report control expressions and functions to retrieve, calculate, display, group, sort, filter, parameterize, manipulate strings, report control behavior, and format report content.
• Modify existing C modules associated with application interface menus and report input parameter forms to accept user input as report parameters.
• Used Oracle Forms and Report Builder to view legacy system Oracle forms and reports architecture, control logic and functionality, re-creating in a SSRS based environment.
• Used SQL Server Profiler and Query Analyzer for stored procedure diagnosis.
• Used Visio to reverse engineer client database elements and assist with creation of SSRS forms and report mockups.

Confidential

Database Application Support Analyst

SQL Server 2005/2008 and Access databases application support. Work directly with internal, external, and international customers to quickly and efficiently indentify software problem issues and resolve. Program new or modify existing database and stored procedure functionality.

Responsibilities:

• Assist DBA group with maintenance of SQL Server databases, SQL Ad-hoc reporting, T-SQL DDL and DML to maintain database tables, create stored procedures for application functions and maintenance, query analyzer tools for stored procedure diagnosis, review system logs to determine cause of job failures, start and stop server and database services.
• Troubleshoot Access and SQL Server data extraction utility applications, modify database query logic, used VBA programming to create and modify new database logic, used VBA to modify Access data scrape logic, VB scripting to modify registry parameters for Access database application startup configuration.
• Create Visio diagrams to document database and business application logic.
• Administer Connect Direct NDM file transfer, create, modify, and manage secure file transfer processes for internal and external business units.
• Administer Control-M job scheduler software, create, modify, and troubleshoot process management trees, resolved issues with automated job flow tasks.

Confidential

SQL Data Analyst

Provide Cardinal Health Strategic Pricing Group with methodology to extract, transform, and load ETL enterprise invoice data into local workgroup data mart and develop user interface to launch ETL process. Installed and configure local instances of SQL Server 2005, created SQL stored procedures for SQL Server Ad-hoc queries, SQL performance optimization, TOAD to query Oracle Data Warehouse.

Responsibilities:

• Create parameter based SSIS packages and stored procedures to automate ETL processes, perform data mapping, data conversion, from Oracle to SQL Server data mart.
• SQL and T-SQL to create/copy/alter tables and databases, DDL and DML procedures.
• Create VB based form ETL interface as a tool for date range input and filter data extraction from Oracle data warehouse into data mart.

Confidential

Database SQL Reporting Analyst

Database performance and production improvement for commissions reporting databases, support internal and national field management teams commissions reporting databases.

Responsibilities:

• Migrated Access commission reporting databases into workgroup environment, automate table linking through embedded VBA programming. Enhanced MS Access databases for agent commission reporting using embedded VBA and SQL programming.
• Centralized data file streams to improve overall data manageability, develop VBA import functions to read data streams .csv, flat file, .txt, .xls into Access reporting databases and process.
• Create exportable Excel reports and write SQL procedures for data retrieval and Ad-Hoc report processing.
• Developed broker dealer database for progress tracking and statistical analysis of new business cases, customized reports and database dashboard views.
• SQL and T-SQL for tuning and index assignments to optimize database query performance.

Confidential

SQL Server DBA

Provide technical support and management of database resources across Ohio Department of Health ODH SQL Server databases on Windows operating system and supporting database software. Ensure high data quality, developing, implementing, and overseeing database policies and procedures to ensure integrity and high availability of databases and accompanying software. Install, monitor, maintain, and performance tune production databases.

Responsibilities:

• As DBA group member, perform database backup/restore using SQL Server Enterprise Manager and T-SQL commands.
• Used Data Transformation Services DTS for data import/export, migrate database objects between SQL Server environments, SQL Ad-hoc reporting. .
• Assist other DBA group members with database security, setup and manage groups and roles, maintain high SQL Server availability.
• Install and configure SQL Server 2000/2005, apply service packs, assist with application migration from SQL Server 2000 to 2005.
• Setup and configure SQL Server Reporting Services SSRS , create SSRS reports for ODH Smoking Cessation program.
• Used SQL Server functionality, operating system and third party tools to monitor database performance, improve database performance through SQL Server tuning and optimization methods.
• Set up and maintain SQL Server replication services across Windows server environment and remote servers for statewide laboratory sample tracking system.
• Create custom tracking database to log incoming call information and create grant reporting statistics for ODH radon awareness program.
• Program functionality for calculation and reporting radiation dose assessment.

additional experience

Small Business Consulting

• SQL, VB/VBA, custom turn-key database solutions in SQL Server and MS Access versions 2.0 - 2013, redistributable SQL database solutions utilizing Access Runtime and SQL Server as appropriate for use.
• Custom Access workgroup and desktop databases from derived requirement specifications, create custom database reporting, dashboards, VBA/SQL based data processing procedures, create and modify database structures, design and implement database improvements, perform database object maintenance and clean-up, data cleansing.
• Assist remote clients with design thru development or modify existing SSRS reports and SSIS packages, create data migration processes, create and schedule SQL Agent jobs.

Commercial Nuclear Power

Subject matter expertise in radiological assessment and monitoring, environmental monitoring and remediation, Radiological CFR code implementation, contracts and personnel management.