SUMMARY:

• Oracle Certified SQL Expert (May 2012). Creates and modifies SQL stored procedures and SQL Agent jobs. Created and updated SSIS packages to support ETL activities involving clinical trial data and wrote C# unit test code in Visual Studio. Wrote PL/SQL stored procedures, functions, and triggers to support logistics and data warehouse activities.
• Created connectors, scheduled tasks, and business rules in Confidential Data Hub. Wrote JUnit code to test ETL connectors in Confidential .
• Previously an ETL professional using Oracle OWB and Informatica, and wrote Tcl programs to support ETL activities, saving the company over $100,000 a year through increased productivity by automating routine activities . Modified Oracle database when necessary for data warehouse functions.
• Formerly a Web Programmer (using HTML, CSS, PHP, JavaScript, and MySQL) for an Internet - based souvenir and gift company.

TECHNICAL SKILLS:

Oracle Certified SQL Expert (May 2012). Uses SQL and PL/SQL routinely as part of database programmer activities. Used MS SQL Server SSIS, Informatica and Oracle 11 g OWB for data warehousing and ETL. Currently using MS SQL Server T-SQL to support ETL and reporting activities for a real estate firm. Familiar with Confidential Data Hub’s proprietary programming language and JUnit code to support Confidential programming. Uses T-SQL, SSIS, and C# regularly. Supported an Internet-based company using MySQL, PHP, HTML, CSS, and JavaScript. Familiar with Java, Visual Basic, and C++ programming languages. Familiar with Apache and Tomcat web servers and both Windows and Linux operating systems .

EXPERIENCE:

Confidential, Berwyn, PA

Database and Report Developer

Responsibilities:

• Develops MS SQL Server T-SQL stored procedures and SSIS packages to populate a data warehouse with real estate listings and sales data . Creates Tableau reports based on MS SQL Server views and tables to display visualizations of the data. In addition, writes SQL code to verify information reported in the displays. Routinely uses Tableau Desktop 10.2, SQL Server Management Studio, and MS Visual Studio 2015.
• Routinely creates databases, tables, views, and indexes as needed for maintaining the staging tables and the data warehouse. Modifies tables (adding, altering, dropping columns, etc.) as needed. Imports/exports data into test environments for development purposes.
• Creates SQL to answer internal customer’s inquiries and to determine sources of discrepancies between client data and reported values. Meets with report users to determine their needs and get feedback on reports; helps internal clients solve problems and answers their questions concerning reports.
• Routinely MS Word, Visual Code, and Excel for documentation and reporting.

Confidential, Conshohocken, PA

Senior Application Engineer

Responsibilities:

• Develops MS SQL Server SSIS packages to populate a data warehouse with human clinical trial study data . The data is used by clients to compare their individual study metrics against industry-wide aggregations. In addition, writes unit tests in C# to verify code meets design requirements. Routinely uses SQL Server Management Studio and MS Visual Studio.
• Routinely creates databases, tables, views, and indexes as needed for maintaining the staging database and the data warehouse. Modifies tables (adding, altering, dropping columns, etc.) as needed.
• Creates SQL to answer data quality analyst’s inquiries and to determine sources of discrepancies between client data and reported values.
• Routinely uses GitHub for version control and collaboration. Has written MS PowerShell scripts; routinely uses Smartsheet for server performance tracking and MS Word and Excel for documentation and reporting. Occasionally leads Agile Scrums when required.

Confidential, Malvern, PA

Application Support

Responsibilities:

• Developed client-driven web pages based on Confidential ’s browser-based platform for organizing and aggregating data obtained from an Oracle database for a large financial firm .
• Technologies used included Oracle SQL, JavaScript, HTML, CSS, and HTML.
• Used SQL to join data for aggregation and display; custom HTML tags were used to display the results in browsers.
• Development occurred in an Agile environment.

Confidential, West Point, PA

Database Programmer

Responsibilities:

• Writes SQL reports and PL/SQL to support Government Pricing calculations.
• Uses i-Many, an Apache server web-based application that wraps SQL and PL/SQL in XML code for data collection, scrubbing, and manipulation, and for report generation.
• Routinely uses SQL Developer. Uses Oracle Analytics, set operations, and Regular Expressions as necessary for reports.
• Routinely creates tables, views, and indexes as needed for generating reports for Confidential . Modifies tables (adding/altering/dropping columns, etc.) as needed.
• Routinely creates SQL to select, cleanse, and transform data, then exports the data in MS Excel or XML files.
• Uses Excel 2010 for report formatting and data presentation, and Word 2010 for documentation.

Confidential, Malvern, PA

Data Management Developer

Responsibilities:

• Creates connectors in Confidential to pull data from text files, convert/transform the data, and load the data into Oracle 11g database tables. Creates scheduled tasks to FTP files, run the connectors, and archive files per business requirements. Writes business rules (procedures and functions) within Confidential using a proprietary programming language to enforce the business requirements.
• Routinely creates tables as needed to support the requirements of the connectors. Modifies tables (adding/altering/dropping columns, etc.) within Confidential as needed.
• Creates and modifies Confidential user interfaces for aggregating and reporting data for the business analysts.
• Routinely creates SQL in SQL Developer to test and review work performed in Confidential .
• Uses Oracle Analytics, set operations, and Regular Expressions as necessary.
• Uses Excel 2010 and Word 2010 for documentation.

Confidential, Malvern, PA

Database Programmer

Responsibilities:

• Writes SQL reports and PL/SQL functions and procedures to support data warehouse activities. Reviews other programmer’s PL/SQL code and suggests changes and corrections to the code. Routinely uses SQL Developer and SQL*Plus. Uses Oracle Analytics, set operations, and Regular Expressions as necessary for reports.
• Routinely creates tables, views, and indexes as needed for generating reports for clients. Modifies tables (adding/altering/dropping columns, etc.) as needed.
• Researched applicability of Oracle Partitions and Data Pump for projects concerning very large databases (VLDBs). Uses Explain Plans to help optimize SQL queries.
• Routinely created SQL to select, cleanse, and transform data, then exported the data in MS Excel or XML files for import into separate database tables.

Confidential, King of Prussia, PA

Database Programmer

Responsibilities:

• Writes PL/SQL procedures and functions to support the Confidential ’s Oracle 11g database .
• Reviews other programmer’s PL/SQL code and suggests changes and corrections to the code.
• Routinely uses SQL Developer and SQL*Plus.
• Supports webpage developers with design document review, development testing, and research of various technical issues (e.g., data archiving and the Oracle Data Pump API for PL/SQL) .

Confidential, Wayne, PA

Data Specialist /Lead Developer

Responsibilities:

• Develops and performs quality control of domains based on Confidential SDTM Confidential using SQL and PL/SQL for Oracle 10g databases . Creates Oracle Warehouse Builder (OWB) mappings to perform the ETL on the data from clinical trials to format the data to FDA’s requirements. Uses SQL Developer and OWB routinely.
• Creates OWB Experts and PL/SQL procedures and functions to automate data conversion and validation tasks. Writes programs in Tcl to automate tasks performed by OWB developers.

Confidential, Exton, PA

Database Programmer/ETL

Responsibilities:

• Assists the database team with the extraction, transformation, and load (ETL) of data in the transactional database to the data warehouse using Informatica tools. Writes mappings, creates the sessions, and schedules the workflows for new projects to enhance the data warehouse. Uses Toad for Oracle routinely.
• Modifies the Oracle 9g data warehouse as needed for projects. Writes Oracle stored procedures and functions to implement tasks in Informatica mappings.
• Provides implementation details in the project task outlines.

Confidential, West Grove, PA

Web Programmer

Responsibilities:

• Uses PHP and JavaScript to implement web programming for creating and ordering personalized gifts and souvenirs.
• Maintains and modifies MySQL database (with PHP for connectivity) to support company's Internet-based and administrative needs.
• Creates new pages using HTML for new products and services.
• Uses CSS to implement consistent page styles throughout the website.

Confidential, Valley Forge, PA

Senior Quality Assurance Chemist

Responsibilities:

• Administers a MS Access database of international laboratories.
• Writes performance evaluation programs to monitor laboratory quality using Visual Basic in MS Excel.
• Administers a database of analytical methods using MySQL with PHP front end.