TECHNICAL SKILLS

Databases: SQL Server 2000 - 2016, Oracle7.25, 8i,10G, Teradata, Db2, Netezza

Reporting Tools: SSRS 2008-2012, Crystal Enterprise 10

Data Analytics: SQL Analysis Services 2008

ETL Tools: SQL 2000 DTS, SSIS 2008-2012

Data Modeling Tools: SQL Enterprise Manager, ER-win, MS-Visio, Toad

PROFESSIONAL EXPERIENCE

Managing Contractor

Confidential

Responsibilities:

• Implementation of Oracle Master Data Management (MDM)
• Managing offshore team of Oracle MDM Developers
• Client Liaison for all security, access, and personnel needs
• Assessment of client needs and development of detailed technical documentation from client interviews and discovery

Confidential, Dublin, OH

Business Intelligence

Responsibilities:

• Lead development role on BI Team supporting call center management
• Database development and reporting using SQL 2012, SSRS, and SSIS
• Developed database coding standards and management methods while training junior staff
• Created ETL processes to query/consume data from Netezza, SQL, and various file formats
• Introduced TFS for source code management, project, and time tracking
• Initiated and leading project to rebuild a convoluted database structure into a usable data warehouse

Contract Developer

Confidential, US

Responsibilities:

• Created and maintained database stored procedures, functions, triggers, in a high availability, multi-database environment
• Developed complex ETL solutions to transform existing SQL for conversion into Salesforce
• Created SQL Stored Procedures for SSIS-driven interaction
• Maintained internal documentation projects critical for business continuity

Confidential, OH

Architect/ Business Intelligence Developer

Responsibilities:

• Architected, developed, and deployed, Business Intelligence solutions
• Developed and maintained SSIS to ensure flow of data feeds between systems
• Created reporting solutions for business customers in SSRS, SSAS, and Excel Pivot Tables
• Managed SQL databases and DR procedures in a growing and changing environment
• Maintained system and process documentation
• Implemented development environment, source control, and change management

Contract Developer

Confidential, Louisville, KY

Responsibilities:

• Developed and monitored SQL back end systems for Banking Clients
• Architected database design, SSIS, SSAS and SQL code for deployment across multiple SQL platforms

Confidential, Powell, OH

Responsibilities:

• Created and maintained SQL Reports (SQL2008/SSRS 2008)
• Gathered and refined customer specifications
• Defined and presented data models from Oracle and SQL databases
• Created training materials and taught end users report development using SSRS

Confidential, Columbus, OH

Responsibilities:

• Development and maintenance of fund services data fees for various banking areas. Spearheaded project to deploy MS Team for software change control

Confidential

Applications Analyst II/Business Intelligence Developer

Responsibilities:

• Performed Migration numerous legacy databases and applications to common SQL 2008 platform.
• Upgraded DTS, SSIS and manual processes to formalized SSIS 2008 environment wif strict operational control and procedure.
• Documented existing system deficiencies, path to migrate and modifications.
• Developed architectural best practices and departmental standards.

Data Warehouse Architect

Confidential, Dublin, OH

Responsibilities:

• Led BI team in developing the architected solution by participating in or leading enterprise data warehouse design and development projects.
• Understand business requirements, analysis, design, programming, testing, implementation, and support of new processes for the enterprise data warehouse.
• Managed full project development life cycle.
• Oversaw conceptual, logical and physical data modeling activities in both a relational and multidimensional environment.
• OLTP, OLAP, Analysis Services, SQL Server 2005, SQL Tuning, Database Design, Data Warehousing, Data Modeling using Erwin and C#.NET wif SSIS code.

Confidential, Westerville, OH

Business Intelligence Developer

Responsibilities:

• Developed framework to control existing SSIS processes and jobs.
• Implemented job-step logging and process reporting.
• Wrote procedures for change control processes.
• Defined and implemented code promotion routines and SAS70 compliance standards.
• Managed team code releases.
• Worked wif DBAs and System Administrators to spec., configure, and deploy servers.
• Migrated existing code and packages from SQL2005 to SQL2008.
• Mentored junior team members in coding techniques and standards.
• Redesigned and developed existing ETL routines for data integrity and performance enhancements.

Confidential, Charlotte, NC

Sales Reporting

Responsibilities:

• Managed Merchant Portfolio data production.
• Standardized, documented and replaced existing manual processing routines.
• Employed ETL approach to improve processing times and reliability.
• Developed functions, stored procedures, and DTS packages as needed.
• Worked directly wif business users and modified code to accommodate changing business needs. Initiated and managed projects for data cleansing and server organization.
• Defined procedures and managed user access request for access to Merchant Information Services data and applications.
• Architected and participated in large-scale project to bring three existing systems into a single integrated tool and data repository.
• Managed project to migrate servers to SQL2005 from SQL2000
• Processed incentive plan data for Small Business Merchant Sales.
• Part of a team which implemented enhanced interfaces wifin the Merchant Suite Reporting application providing an individualized drill-down view of sales figures.

Confidential, Charlotte, NC

Applications Support, AVP - Operations Finance

Responsibilities:

• Assessed current operations and automated tasks using SQL2005 SSIS as an ETL Tool.
• Coordinated and personally implemented team's SQL2005 installation as a bank pilot.
• Developed and maintained necessary tables, procedures, functions and views.
• Documented our installation as a part of "Best Practices" materials.
• Replaced existing operations involving manual file changes, file transfer via Email, multiple Excel spreadsheets, Access databases, FoxPro and Flat Files.
• Identified SQLServer2005 SSIS as the tool to replace existing manual file operations effectively replacing one and 1/2 FTE and also saving $90k which had been budgeted for a similar tool.
• Developed Executive Dashboard application wif drill-down Hoshin Metric Scorecards using Cost Allocation system, management goals and metrics to improve and incent upon proactive management of Service Center expenses and productivity.
• Maintained and developed enhancements to a VB6/Oracle 10g Cost Allocation tool used to manage expenses of all bank service center operations and personnel effectiveness. dis tool was written several years before when it was contracting for the same group.
• Modeled database modifications as needed using Erwin.

Contract Developer

Confidential, Charlotte, NC

Responsibilities:

• Oversaw developing asp interfaces for partner financial institutions.
• Developed changes to the user interfaces for loan application entry.
• Created system whereby multiple user application forms would be presented at specified frequencies given specific customer attributes.
• Primary focus on COM/XML/XSL communication streams between multiple applications.

Confidential, Charlotte, NC

Responsibilities:

• Developed Security Deployment for Crystal Enterprise deployment.
• Created supporting documentation around report creation, promotion to production.
• Trained and mentored team members on new guidelines and report creation issues.
• Researched and created migration path from Fleet ATM hardware systems and various other data sources into Confidential hardware management systems.
• Developed multiple scenarios for system integration to provide the optimal solution.
• Performed the migration of multiple legacy systems into a single ASP.NET application wif SQL Server 2k database.
• Gathered requirements and ultimately guiding developers through database modeling activities and implementation. Built views and stored procedures for data retrieval and modification.
• Analyzed database performance to identify and exploit tuning opportunities.
• Built multiple reports using queries and stored procedures developed in T-SQL.
• Created temporary flexible process to provide internal and external Bank locator services wif ATM data from both Fleet and existing Confidential ATM Hardware data.
• Monitored and adjusted dis process to meet changing requirements and needs during the various phases of system integration.
• Worked wif external vendors of information and services to provide web ATM and Bank Locator information.

Confidential, Charlotte, NC

Responsibilities:

• Developed and Supported Trade Support applications wifin Corporate Investment Banking.
• Managed a team initiative to move code to common modules and reusable objects.
• Created and deployed business objects for encryption, global email utilities, common error handling routines, and user action logging.
• Developed and implemented specific procedures for development team around software change control.
• Documented Software Change Management processes, plans, procedures and artifacts as they pertain to the development team.
• Served as team liaison to Change Management Group wifin the bank.
• Managed changes to current development lifecycle process to become compliant wif bank standards.

Confidential, Charlotte, NC

Responsibilities:

• Gathered project requirements and wrote sizing and technical documentation for various project scenarios. The resulting analysis led to the in-house development approach being discarded in favor of a third-party solution.
• Developed mockups utilizing SQL Server, MS Access, and Visual Basic wif third-party components.
• Built stored procedures and user functions wif T-SQL for database updates and queries by the application.

Confidential, Charlotte, NC

Responsibilities:

• Implemented a conversion project for internal web application moving from Oracle 9i to DB2 environment.
• Ascertained and documented business requirements, technical specifications and the project plan for the project.
• Altered SQL statements appropriate for DB2 environment.
• Developed COM+ objects to supply the application wif a data access layer in order to halp alleviate connection lag times.
• Upgraded web presentation layer while standardizing page layouts.
• Moved many of the visual components of the front-end to style sheets to facilitate future application changes.
• Developed Crystal Reports as needed for ad-hoc reporting.
• Created a process using Excel VBA to export to Excel Pivot-Reports from Crystal Enterprise.

Confidential, Hickory, NC

Responsibilities:

• Managed large-scale project to create an n-tier Quality Assurance application.
• Client produces medical grade hosiery; production standards are monitored and recorded through the application for newly required FDA compliance reporting. A complex set of procedures is employed to monitor and correct machine tolerances.
• Performed BRD, LLD, hardware specification, database design and formulated front end design documentation from information gathered from multiple sources.
• Created screen interfaces for operator/user interaction and automated mechanical device interfaces.
• Created communications port interfaces for data transmitted from manufacturing equipment.
• Architected SQL 2000 database using Toad and ERwin, security maintenance interfaces, T-SQL, stored procedures, triggers and views.
• Employed SQL group permissions and security managed through a custom written front end.
• Engineered DNA architecture for security login, data interfaces and program logic modules written in COM.

Confidential, Charlotte, NC

Responsibilities:

• Managed project to create web interface to third-party software used to track and monitor Associate training and available learning materials.
• Mentored and coached team members on technical issues.
• Technologies included low-level development using SQL Server 2000, Sybase, and COM+ in a distributed network environment, VB6, and Visual Interdev 6.

Confidential, Charlotte, NC

Responsibilities:

• Upgraded an application written for expense management and financial accounting costing processes for the entire bank's servicing center operations.
• Wrote post development testing scripts and managed testing phases performed by bank operations employees.
• Migrated data access to a single component from inline RDO record sets using Oracle Drivers to ADO command objects wif Microsoft Drivers for performance improvement wif Oracle 8.03 database access.
• Developed and deployed application reporting to a Crystal Web-based solution.

Confidential, Charlotte, NC

Manager of Change Control

Responsibilities:

• SCM (Software Change Manager) for multiple application development teams.
• Supervised change process employees.
• Designed and implemented procedures for software management and code promotion.
• Led projects for code, technical documentation and process improvement.
• Developed and maintained financial reporting using Microsoft DNA architecture wif COM+ and SQL Server 7.0.

Confidential, Charlotte, NC

Responsibilities:

• Development for a complex N-Tier web based financial management system using HTML, ASP (VBScript, JScript), and COM based XML-XSLT transformation, and SQL Server 7.0.
• Created solutions for changes associated wif MSIE 5.5.
• Employed Visual Basic to build COM components, Microsoft Transaction Server, Visual Interdev, and XML Spy.

Confidential, Charlotte, NC

Responsibilities:

• Developed and supported N-Tier web based training and reference materials using Visual Interdev and VB 6 and SQL Server 7.
• Created COM components for data access and server side processing.

Confidential, Charlotte, N.C

Responsibilities:

• Developed VB6 Network Batch Scheduling and Documentation Management System as an NT based N-Tier system utilizing COM, DCOM, Remote Automation, ActiveX Server, and the NT Scheduler API.

Confidential, Charlotte, NC

Responsibilities:

• Supported Intranet system while developing a VB/Intranet content management system.
• Designed SQL Database. Technologies implemented include VB 6.0 wif ADO and COM, Visual Interdev, ASP and SQL Server 6.5.
• Performed Database interaction was handled via inline T-SQL statements and compiled to executable code.

Confidential, Charlotte, NC

Responsibilities:

• Created cost allocation and tracked package front end for existing VB 3.0/Access 2.0 tools for Service Center management.
• Utilized VB 5.0 accessing Oracle 7.3 via RDO.

Confidential, Charlotte, NC

Responsibilities:

• Designed and implemented VB5 / Oracle 7.2 loss tracking system for 350+ end users.
• Employed DAO, RDO data access methods and IBM Messaging Queue middleware to access mainframe background processes.

Continental, Charlotte, NC

Manufacturing Facility

Responsibilities:

• Performed development using COBOL, JCL, Visual Basic 4.0 / MS Access, and HP COBOL applications for Manufacturing and Payroll requirements.
• Analyzed and corrected existing software problems as needed.
• Developed and implement test scenarios for all software changes.

Confidential, Charlotte, NC

Associate Programmer Analyst

Responsibilities:

• Performed Maintenance programming supported Patient Accounting software.
• Languages included COBOL and Powerhouse in both HP and DEC VAX/ALPHA environments.
• Maintained software/data, daily batch processes and performed software upgrades in four test/client-training environments.
• Headed several Y2K projects to update data element dictionary and end user documentation for the upcoming millennium.
• Served as technical resource on the Year 2000 code modification team.
• Designed and reviewed administrative processes and user procedures for internal tools written in Visual Basic/MS-Access.