Perform ETL operations on acquired company data to clean and conform data for ingestion into company standard data structures. • Cleaning, formatting, and standardizing the data for loading into the database. • Create/modify the procedures and functions necessary for loading.• Create data validation reports.

Manage operations of a distributed database environment supporting primarily OLTP, NoSQL, and data warehouse environments by implementing and maintaining database infrastructure and architecture focused on enabling the business to move fast and scale while maintaining customer trust.• Using SSIS and Stored Procedures, imported data from multiple legacy databases into current data structure. Cleaned and conformed the data, documented and reported any discrepancies. • Automated and streamlined the process for Credit Bureau reporting. A semi-manual process cut down from 20 hours per month to 2. Refactored code for performance and operational ease of use.• Development and creation of multiple data sets from our loan and application systems to facilitate more agile reporting capabilities for the ability to standardize the business logic across multiple stand-alone reports. Reduced processing/ETL time by 80%.• Advised in the architecture and development of the new Data Warehouse. Defined the initial structure for dimension and fact tables • Created documentation and standards for the data team. These included development standards, best practices, naming and design standards, and stored procedure templates.• Performed preventative maintenance checks on SQL servers.Worked with server team and vendors to prioritize and remediate errors.

SQL Developer for the Cessation Services Quitline at RPCI. The Quitline services multiple state agencies as well as private companies and insurance providers.• Imported, cleaned, and loaded data from our Cisco phone system into a data warehouse for reporting. Subsequently created and implemented standard benchmarks and trend reports to support our state quitline programs and to ensure that we are meeting contractual goals. Reporting is at the Program, Agent, and Call Center level. Reports were delivered through SSRS.• Utilizing SSIS and stored procedures, designed and developed a Data Access Layer residing on our current legacy database to facilitate more agile reporting capabilities and the ability to standardize the business logic across multiple stand-alone reports • Advised in the creation and development of the new back end data model and database to support our future operations. • Implemented basic project management best practices to assist management in coordinating activities.• Worked with researchers to understand their data needs and create either data sets or end reports to meet their objectives.• Worked in a DBA capacity to support security and access, monitor database health, and to verify that the SQL server agent jobs and other ETL processes were running smoothly.

Perform the ETL functions for Pentalpha Oracle Data Warehouse. Duties include:• Cleaning, formatting, and standardizing the data for loading into the database. • Modify and create the procedures and functions om Oracle PL/SQL necessary for loading.• Perform gap analysis on new files and file changes. Document and communicate any data changes to appropriate end users.• Create and modify tables, including associated triggers and constraints in Oracle PL/SQL• Run reports and queries to QC data loads.• Research, documents and solve any data quality issues.• Communicate with vendors regarding data updates and changes.• Assist in the development of the proprietary OATS interface. In PL/SQL create and test the retrieve and update queries.• Initiated the creation of Change Management policies and procedures for the data warehouse and documented same.

My primary functional responsibility is to support the data operations related to the development and production of the weekly and monthly DataMart databases, the SQL databases and file transfers. As a data support analyst, I support the database build operations, 8-10 business analysts, 2 campaign programmers, 2 third party database developers and various analysts and data consumers within the lines of business.• Management of AnalytiX DataMart systems platform. • DataMart related project and change management facilitation for bank wide and division wide requests. • Design and development of changes to customer insights databases and marketing automation technology programs. • Relationship management duties with analysts, marketing managers, and others. • Elicitation and documentation of change requests. • Development of technical and functional design specifications and documents. • Development and execution of validation and testing plans. • Coordination of development and change implementation. • Coordination of trials, training and adoption of existing and new data tools in data management, analysis and reporting. • Integration point person for AnalytiX data into other emerging platforms such as Microsoft SQL Server. • Provision data appropriately and efficiently to consumers of Customer Insights data. • Partner with Customer Insights managers to meet their data needs for deliverables. • Manage and coordinate automated data files and transfers to vendors

• Used Analytix/Datamart to create marketing e-mails, direct mail, and calling lists. In addition merged the Analytix/Datamart data with other external and internal sources to create custom reports and lists.• Using business intelligence tools, created a custom report/interface to view the ezLeads records.• Managed the project to bring the TBC dialer information into Datamart.• Worked with outside vendor to rework the email list creation process to stress efficiency and accuracy.

• Responsibility for corporate level, TBC level, and Customer Solutions level projects. Role as project manager is to coordinate and oversee the associated tasks accompanying various projects. Major projects include:• Aspect autodialer installation for TBC• Over the phone account opening • Autodialer enhancements• In role of Campaign Integrator, coordinated activities between Marketing, Call Center Technology, and the Telephone Banking Center to ensure efficient execution of calling campaigns. Campaigns included regular Fall/Winter/Spring marketing campaigns as well as 40 other calling campaigns in 2009• Developed extensive front-end reporting for outbound calling campaigns. In addition created scheduling and profitability models for outbound dialing campaigns.• Implemented and maintained Telephone Banking Center SharePoint site.

• Focused on advanced problem solving • Coordinated communications with the Help Desk, ATM Help Desk, vendors, and customers.• Ensured consistent, reliable, and available network services, which additionally includes rolling out new infrastructure related projects.• Received escalations of incidents from Triage Analyst and Shift lead.• Infrastructure Evaluation – Looked proactively at resource utilization (device, circuit) to see if a potential failure of impact is coming.• Performed extensive problem assistance, working with engineering, looking at sniffer traces.• Mentoring and skill development – worked with Triage Analysts to increase their knowledge and perform cross training on unique skills.• Knowledge Management – identified and captured key issues and resolutions for population in the Knowledge Management System

Adjunct Professor in the Information Technology Department.Courses taught Include: - Tech 100 Intro to Business Computing - Tech 140 Networking Fundamentals - Tech 130 Hardware Fundamentals - Secr 210 Intro to Security

• Designed, implemented, and administered a Windows NT4 network for a 15 user LAN. Network included MS Exchange, IIS, a Novell file and print server, as well as an IBM AS/400• Established the initial Internet, mail, and web connectivity for the company, for both the corporate LAN and 22 remote locations• Designed and created customer contact databases for the company sales force.

• Managed 8 supervisors and indirectly responsible for 100 call center agents.• Shifted business unit from negative to positive profitability by focusing agents on quality and meeting call metrics.• Interacted with client, senior management, and phone agents to ensure that the metrics for quality and client SLA’s were being met.