SQL Developer

Marcus Matthews

Columbus, Ohio

SUMMARY

A SQL Developer with technical proficiency, determination and proven management skills to complete projects as an individual or as a team member.

TECHNICAL SKILLS

Database Management Systems: Microsoft Access 2010, Microsoft SQL Server 2012, Oracle Database 11g, Teradata 13.10, and MySQL 5.1

Software:

Quest Software Toad® for Oracle Xpert 10.6.1, Oracle Report Builder, Teradata TTU Developer Client 13.10, Microsoft SQL Server 2008 Integration Services (SSIS), SQL Server 2008 Reporting Services (SSRS), MS Office2010, and Control-M 8.0x64 R1

Tools:

Toad for Oracle 10g, Oracle Reports Builder10g, Teradata SQL Assistant, SQLyog, Microsoft SQL Server Management Studio(SSMS), and Microsoft Visual Studio 2010

PROFESSIONAL EXPERIENCE

The Judge Group Columbus, Ohio 8/14 – Present

Reporting Analyst – Discover Financial

• Query Advanced List Management (ALM) web server, Unison and Aspect Unified Internet Protocol (UIP) dialers for Call table and Sign In Duration (SID) imports to create Key Performance Indicators (KPIs) for all company sites.

• Calculate adherence and export scoring for Fraud/loss prevention/Investigation (Security) and Agents of Card Member Assistance (CMA).

• Update forecasting metrics and publish the weekly staffing report in Online Scheduling Communication & Reporting (OSCAR).

• Provide ad hoc reports and data extracts with Teradata SQL Assistant.

• Investigate Workforce Management application upload errors using SQLyog Enterprise.

• Document current business process and prepare business/technical requirements for new or existing applications.

• Construct department monthly performance/shrinkage summary reports in MS Excel.

• Examine current manual processes to develop strategies to automate after the migration from MySQL to Oracle is complete.

• Analyze Avaya phone history from Agent Initiated Calls (AICs) to cell phones where Discover does not have consent to dial predictively.

• Support pre-delinquency Heat maps and Charge-Off intervals reporting.

• Generate PivotTable views using Microsoft Access for Talk, Hold and Wrap times per intervals.

JPMorgan Chase Columbus, Ohio 11/11 – 8/14

Information Analyst I – Performance Solutions

• Developed new and maintain existing schema objects using Data Definition Language (DDL) scripts in Oracle.

• Utilized Data Manipulation Language (DML) statements to create shared data sets for reporting and analysis from Oracle data sources.

• Managed connection strings for Proof of Concept/SSRS intranet website.

• Transitioned reports developed in Tableau to SSRS.

• Set up automated processes using Automation Designer to perform maintenance tasks, flat file imports and exports.

• Performed SQL tuning and optimization for ad hoc data requests.

• Mortgage Banking Incident Management and Remediation Scorecard development.

• Produced high-level snap shots and drill-down views for presentations to upper management.

• Analyzed customer contact rate using the operational data store (ODS) database.

• Participated in User Acceptance Testing (UAT) for mainframe applications.

• Intranet application disaster recovery testing.

• Provided data validation and reconciliation using Teradata in the Integrated Consumer Data Warehouse (ICDW).

• Data transformation and integration for MS Access databases from archived data sources.

• Composed Microsoft Visual Basic for Applications (VBA) code to manipulate Excel spreadsheet data.

• Designed data flow diagrams and write process documentation.

JPMorgan Chase Columbus, Ohio 8/10 – 8/11 Oracle Developer – Automation Services

• Developed data extracts, standard, or parameter driven reports in Tool for Oracle Application Developers (TOAD).

• Imported flat file data to Oracle using an ODBC connection to a linking table in MS Access.

• Uploaded data using SQL*Loader (sqlldr) and a control file (.ctl) from command-line interface (MS-DOS).

• Worked with Business Analysts (BA) to develop reports to support the application development.

• Scheduled meetings with the Line of Business (LOB) to understand the expectations of the request, collect requirements, and test data from requester to create Business Requirement Documents (BRD).

• Researched systems involved to satisfy a request and calculate the Service Level Agreement (SLA).

• Analyzed and optimized SQL for reports to improve poor performance or correct logic that does not adhere to the company coding guidelines.

• Used PL/SQL to program report form triggers and report blocks in Oracle Report Builder.

• Created tables, views, stored procedures, jobs, and packages.

• Tested and exported deliverables in Excel format (.xls).

• Performed report break fixes.

• Provided support break fix report runs to supply users with data in the event of a report is unavailable due to server issues.

• Elicited Subject Matter Experts (SME) to create documentation required by Home Lending Technology Risk Management Control for applications developed within the department.

• Enhanced existing production reports.

• Promoted reports that have passed UAT into production.

• Recovered decommissioned SQL Server reports to run in Oracle.

• Monitored performance, documented idle processes, diagnosed, repaired or removedjobs from DBMS schedule.

Kickstart LLC Columbus, Ohio 5/09 - 4/10 Manager

• Managed the service office database using Microsoft Access 2007 and Excel spreadsheets.

• Updated records, track inventory, place service product orders, and backup POS data.

• Troubleshot network connection and performance issues.

SOS Video Communications Columbus, Ohio 12/08 - 5/09 Internship

• Installed and maintained RAID0 AVID external Hard Drives, ATTO SCSI and PCI cards

• Managed operating systems, program software installation and configuration.

• Performed partitioning and formatting hard drives, flashing hardware, permission restoration, and error log analysis.

• Assisted in the development of the company Intranet using Microsoft Office SharePoint Server / Designer (MOSS) 2007, MySQL, and QuickBooks 2007 by creating custom connection strings and web pages using C# and ASP.net.

EDUCATION

New Horizons Columbus, Ohio 3/14

Implementing Data Models and Reports with Microsoft SQL Server 2012

New Horizons training is intended for database professionals with a working knowledge of relational databases, querying with Transact – SQL and a basic understanding of data warehouse schema topology, with an awareness of key business priorities such as revenue, profitability and financial accounting that must fulfill a Business Intelligence Developer role.

Primary responsibilities include:

• Reporting solutions development using SSRS

• Implementing multidimensional databases by using SQL Server Analysis Services (SSAS)

• Creating tabular semantic data models for analysis

• Develop data mining solutions

SetFocus, LLC. Columbus, Ohio 6/10

SQL Master’s Program

The SetFocus SQL Server Master’s Program is an intensive, hands–on, project oriented program where participants gain knowledge and valuable experience putting the SQL Server skill set to use in a simulated work environment.

• Created numerous simple to complex queries involving self joins, correlated sub queries, CTE’s and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.

• As part of a team, analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu- Ray) rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS.

• As part of a team, created various reports according to the business requirements for the movie rental company. Individually authored, installed, deployed and managed reports using SSRS for a library database.

• Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.

• Created an ETL solution that reads Product, Vendor, and Order data from .CSV files on a network share into a SQL Server database. The solution also validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008 reporting functionality (including the Tablix control). The reports were set up for automatic delivery based on standard report subscriptions.

Columbus State Community College Columbus, Ohio 5/09

Database Specialist Certificate

Columbus State Community College Columbus, Ohio 6/03 Associates Of Science, Chemistry

Contact this candidate