TECHNICAL SKILLS:

• Oracle Forms
• Oracle Reports
• Oracle Tuning
• Oracle PL/SQL
• .Net
• Adobe LiveCycle
• PowerSuite
• Pentaho PDI
• Adobe LiveCycle
• JCL
• COBOL

WORK EXPERIENCE:

Confidential, Columbus, OH

Enterprise Data Architect

Responsibilities:

• Architect, design and build operational OLTP data store, data warehouse, Business Intelligence, data lake, modeling with analytics for one of less than fifty comprehensive cancer centers in the United States.
• Build multi - tenant application operational database with sub-tenant capabilities for adding additional institutions.
• Implement data governance and process flows for ensuring quality change control including migration and code repository.
• Enhance and build ETL and ELT processes to ensure data is accurately and efficiently loaded and processed for consumption.
• Recommend visualization and ETL tools.
• Data validation and profiling with master data management solution. Work with business groups to ensure needs are met.
• Architect processes to manage, monitor, process and implement the system as well as processes for developers and continuous implementations.
• Current technology includes ER Studio, SQL Server, SSIS, SSRS, T-SQL, Oracle 12c, PL/SQL, Toad, SQL Developer.

Confidential, Cleveland, OH

Business Intelligence Architect

Responsibilities:

• Sole provider of water treatment in the northeast Ohio region.
• Architect, design and build data warehouse, data lake, modeling and business intelligence with analytics for a reporting team with related water and sewer data for multiple cities, townships, and villages within the district.
• Architect data, process and system governance.
• Design and build ETL and ELT processes to ensure data is accurately and efficiently loaded and processed for consumption.
• Select and implement visualization tools.
• Data validation and profiling. Work with business groups to ensure needs are met.
• Architect processes to manage, monitor, process and implement the system as well as processes for developers and continuous implementations.
• Current technology includes Oracle 12c, PL/SQL, Toad, Linux with bash scripting.

Confidential, San Antonio, TX

Senior Software Developer and Integrator

Responsibilities:

• Leading US insurance and financial services member-owned company.
• Design and build database structures and processes in Confidential Netezza using Confidential DataStage and complex SQL queries.
• Streamlining processes to ensure data quality, ETL logging, error handling, data integrity alerting, and near real-time refresh rates.
• Tune long running queries, processes and architectures.
• Scheduling jobs through Control-M.

Confidential, Austin, TX

Database Engineer/DBA

Responsibilities:

• Leading water industry software company providing SaaS, bundled software products and managed services to municipalities, water districts, and utilities.
• Design and build database structures and processes in MS SQL Server using SSMS, SSRS, SSIS and complex SQL queries including implementing processes to pull data from SharePoint billing cycle calendar lists for complex reporting.
• Construct multi-tenant Data Warehouse and BI reporting databases for archiving and reporting.
• Using SSIS and T-SQL to ensure ETL processes are effectively integrating and scrubbing data.
• Ensure database functionality being designed and built interlocks/integrations with web UI, mobile, reports and desktop applications.
• Convert MS SQL Server databases (ver. 2005-2014) to PostgreSQL databases including data conversions and package, procedure, function rewrites.
• Perform installs, upgrades, backups, and restores.
• Architect and build multi-tenant OLTP and data warehouse as well as multi-tenant self-service BI from MS SQL Server, PostgreSQL to AWS (Amazon) Redshift (PostgreSQL) environment with JasperSoft (JasperReports), Tableau, Periscope, QuickSight (AWS) and Pentaho multi-tenant server reporting interface and database design.

Confidential, Austin, TX

Senior Developer

Responsibilities:

• ETL development in DB2 on zOS and AIX including complex SQL statements, SQL tuning, shell scripting, creating database objects, and custom tools to support corporate Business Intelligence for all Confidential products across all geographies.
• Providing data warehousing and analytics solutions for hardware and software warranty service products.
• Writing SQL PL procedures to improve process performance.

Confidential, Austin, TX

Senior SQL Developer

Responsibilities:

• Research, design and develop data analytics and data quality solutions in support of providing data to all of the business unit applications in the corporate family of products for near real-time results in highly available environment.
• Implement changes in Oracle 11g source database using complex PL/SQL, global temp tables, ETL, external tables, windowing functions, and tuning techniques including hints, hash indexing, and complex queries.
• Team consists of database architect/analyst, data scientist, and application architect/analyst.

Confidential, Austin, TX

Programmer Analyst Senior

Responsibilities:

• Installing, configuring, and supporting Commercial Off the Shelf (COTS) systems
• Windows and UNIX servers. Using PL/SQL and T-SQL to write queries and ETL between systems. Support Public Safety and Enterprise systems.
• Working with end-users to determine business requirements and specifications.
• Work with vendors to ensure code meets needs of agency as well as resolving defect issues.
• Design input files for the system to consume.
• Analyze, define, and document requirements for data, work-flow, logical processes, hardware and operating system environment.
• Design model of business function and assists in redesign of business functions through automation.
• Maintain code and modifies existing programs to conform to system changes or to make improvements in the existing program.
• Design BI pattern matching for end-user analysis.

Confidential, Austin, TX

Senior Database Developer

Responsibilities:

• Converting third party PostgreSQL database and PL/pgSQL stored procedures to Oracle and PL/SQL for Global Planning Center component of data hub.
• Designing, developing and tuning Oracle SQL and database procedures, functions and tools to be used by middle tier to interface with UI for new Soft-Parts distribution and update automation system for maintaining automotive chip sets.
• Developing ETL processes with SQL Loader, PL/SQL, SQL Developer tools and DB Links to migrate data from existing apps.
• Creating SQL Developer adhoc reports for system maintenance teams.

Confidential, Round Rock, TX

Lead PL/SQL Support Developer

Responsibilities:

• L3 production support for Class 1 critical systems including defect and change request modifications on Oracle databases ranging in size from 4 TB to 20+ TB. PL/SQL development involving Oracle Streams, transformations and application data facing.
• Resolving issues with data migrations through Web Services, file processing, and Oracle Golden Gate ETL between parts supply systems for BI forecasting and planning.
• Performance tuning involving multiple nodes on RAC, partitioning and parallelism.

Confidential, Columbus, OH

Software Development Specialist

Responsibilities:

• Lead Oracle developer for mission critical state government financial processing OLTP system with batch processes on z/OS, UNIX/Linux and Windows operating systems running via UC4/AppWorx scheduler.
• Online and batch processing architect responsible for ensuring a stable environment for processing approximately $2.5 billion in revenue annually.
• Responsible for writing and maintaining ETL programs used to extract and replicate current production data loaded into the Data Warehouse.
• Work with customers to identify business intelligence reporting needs of the source system. SQL Tuning data access methods using indexes, hints, and programming methods to ensure best performance.
• Creating custom Oracle PL/SQL blocks, procedures, packages, functions and employing built-in Oracle components to ensure data is secure and quality data is transformed.
• Using UNIX/Linux shell scripting to maintain the scheduler, report, and perform automated support of the system.
• Monitoring database and query performance using Toad, OEM, and SQL Developer. Managing user interface with Oracle Forms/Reports and MS Access Application.
• Managing batch processing using Oracle Pro*C, Perl Scripting, UNIX/Linux Scripting, DOS Scripting, Hyperion SQR, COBOL, Visual Basic, DB2 connectivity for support systems and PVCS for version control.
• Running Java framework jobs through Spring Batch framework.
• Generating emails using VB.NET.
• Unique accomplishments include Oracle SQL tuning of Batch and OLTP processing using hints and programmatic strategies, consuming Web Services from within the Oracle RDBMS, accessing files external to the database through the use of external tables, wrapping secure PL/SQL, and creating agency-wide encryption utility for bank account information.
• Designated team lead ensuring OLTP application up-time and assignments are properly assigned to less senior level developers and deadlines met, while providing guidance towards accomplishment.
• Lead PL/SQL architect for agency designing and implementing solutions to meet legislative, administrative and financial requirements.
• Architecting solutions for reusability, scalability and performance.
• Examples of such solutions include the creation of user-defined database-level object types to be used within PL/SQL stored procedures for extracting blocks of data for web services with SLAs through refcursors and nested table data types, implementing PL/SQL stored procedures and functions with complex mathematical equations used to determine rates and financial discounts for rating programs in real-time, PL/SQL anonymous blocks used to move millions of records to new rating periods and for Business Intelligence reporting, designing and implementing PL/SQL stored functions to call Web services during batch processing for physical address validations and to return in real-time values from other core systems and external systems to the OLTP application. Work with business customers to develop customized solutions and troubleshoot errors.

Confidential, Columbus, OH

Programmer/Analyst

Responsibilities:

• Senior developer for mission critical system with extensive use of Oracle 10g, Oracle PL/SQL, Pro*C, Perl Scripting, UNIX Scripting, DOS Scripting, Oracle Forms, SQL, SQR, MS Access Application, COBOL.
• Developing solutions such as COBOL called modules used in CICS to return employer representatives.
• Monitoring database and query performance using TKPROF, Explain Plans, Execution Plan Queries with SQL ID/SID, Autotrace, Toad, OEM, and SQL Developer.
• Added batch and online integration with AppWorx batch scheduler through the use of direct inserts using DB Links and AppWorx utilities.
• Developed functionality for Oracle Forms to retrieve data from DB2 through the use of VB macros in MS Excel running remotely DCOM components on the Application Server.
• Assist with debugging ASP.NET interfaces with Oracle database, including dynamic SQL and stored procedure/function calls returning refcursors returned for dataset processing and display.
• Accountable for architecting, modifying, tuning and testing highly visible PL/SQL stored packages used to determine billable rates employers pay for workers’ compensation insurance in monopolistic state.
• Developing coding standards and administering PL/SQL code reviews to ensure business logic is met, while performance standards and coding standards are met with proper exception handling.
• Developing application security screens to include automation of Oracle accounts, assign roles, reset passwords, drop accounts, and real-time reporting for auditing.
• Work with server logistics to troubleshoot Application Server IIS settings when making web service or DCOM calls.
• Work with business customers to develop customized solutions and troubleshoot errors.

Confidential, Columbus, OH

Programmer/Analyst

Responsibilities:

• Developer for mission critical system with extensive use of Oracle 10g, Oracle PL/SQL, Pro*C, Perl Scripting, UNIX Scripting, DOS Scripting, Oracle Forms, SQL, SQR, MS Access Application, COBOL.
• Extensive performance and error testing of batch processes during conversion between UNIX AIX to UNIX Solaris.
• Automation of batch processes through AppWorx batch scheduler. Re-writing Safety Grants Incentive application using VB and VBA to include correspondence and budgeting functionality while incorporating macros and application managed security, and moving data store from MS Access to SQL Server with the addition of adding DTS stored package to batch process employer compliance entries from the Web.
• Safety Grants Incentive is an application used by the agency’s Safety and Hygiene division to reduce the frequency and severity of workplace injuries, managing more than $30 million in grants for workplace improvements.
• Implement customizations to packaged Oracle HRIS/Humanic application to include assignment of Oracle Role-Based security through the application screens and employee to management assignment automation.
• Use SQL Loader to load semi-annual data from the business customers used for the semi-annual rate making process.
• Writing Oracle SQL scripts to compare database objects and versions between two Oracle instances.
• Writing Oracle SQL scripts to analyze expected table statistics and general conditions of database, including table fragmentation and cardinality.
• Writing Visual Basic utility used to insert as text and extract as text to rebuild images and files stored in an Oracle database to include EBCDIC to ASCII conversion.
• Work with business customers to develop customized solutions and troubleshoot errors.

Confidential, Columbus, OH

IT Consultant

Responsibilities:

• Developed VB and MS Access DB using VBA projects for small companies primarily in the health care field.
• Application specific for employee assigning, staffing and budgeting employee resources.

Confidential, Worthington, OH

IT Consultant

Responsibilities:

• Mainframe and AS400 Operations. PeopleSoft developer designing, creating, testing Oracle GUI and SQR batch jobs, and writing and testing Oracle SQL and PL/SQL for large university administrative system and check processing corporation.