SUMMARY:

Senior data and integration architect, MBA graduate, with Fortune 500 experience in enterprise database architecture, database development and analysis, web application architecture and management, Business Intelligence, ERP implementation, technical and functional project management, systems integration, and reports development. Over ten years’ experience developing and implementing enterprise databases, integrations, and web applications throughout the software development lifecycle, including management of offshoring programming and testing resources.

• Database design, development and data analysis using the Microsoft SQL platform
• Business Intelligence including SQL reporting services, integrated services and analysis services
• Enterprise systems integration using Microsoft SQL Server tools and Oracle Data Integrator
• Mentoring systems integrators and database developers
• Technical architecture design and documentation
• Technical and functional project management
• Web application/portal architecture and management
• Quality Assurance (QA) Testing

TECHNICAL SKILLS:

• SQL Server 2000 - 201 4
• SSIS
• SSRS
• Oracle Data Integrator
• Oracle PL/SQL
• Oracle GoldenGate
• Beginner
• Tableau
• Microsoft PowerBI
• AS/400 & DB2
• XML/XSLT
• SOAP/REST

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, North Carolina

IT Senior Data Architect

Responsibilities:

• Develop and maintain systems integrations and interfaces using Microsoft SQL SSIS and Oracle Data Integrator.
• Develop and maintain data architecture, including master data and data quality, using Toad Data Modeler and Microsoft Master Data Manager (MDS), as well as Oracle Data Integrator.
• Implementing an enterprise Oracle Data Integrator and GoldenGate environment.
• Design and develop Business Intelligence architecture using Microsoft, Oracle, and Tableau products.
• Research and evaluate new technologies and software.
• Mentor and develop two systems integrators.
• JD Edwards EnterpriseOne, CGC eCMS, Vanguard, Intelex, Prophix, Saba LMS, Autodesk / FlexNet, Adobe Sign, Financial Applications including Sales Forecasting, WIP application, Custom Dashboards.

Technologies include: SQL Server 2005 - 201 4, SSIS, SSRS, MDS, DQS, Oracle Data Integrator (ODI), Oracle GoldenGate (OGG), Toad Data Modeler, DB2, Oracle 12c, Web services (beginner), Tableau (beginner), Microsoft Power BI Stack (Power Pivot, Power Query, Power View), Cognos (beginner).

Confidential, Charlotte, North Carolina

IT Systems Architect

Responsibilities:

• Managed the tracking of application portfolio, systems integrations.
• Developed and maintained systems integrations and interfaces
• Developed and maintained data architecture, including master data and data quality.
• Researched and evaluated new technologies and software.
• Designed and developed Business Intelligence architecture.

Confidential, Mooresville, North Carolina

Manager

Responsibilities:

• Responsible for the daily management of the company's ERP system and data warehouse, implementation and integration of all technical solutions, performing all business analysis work, and all quality assurance for a large transportation company.
• Managed one internal ERP specialist, who maintains and modifies the ERP system and provides specialist technical support.
• Partially implemented a new ERP system (TMW Suite), acting as project manager and lead database developer, leading a team of four to implement and integrate the ERP within the existing environment.
• Created a custom two-way ETL process to integrate the new ERP system with our custom Transportation Management System (TMS). Process was built using tables, stored procedures, views, triggers and functions, as well SSIS.
• Acted as lead database admistrator and database programmer, training one full-time database administrator from scratch.
• Created ETL processes, databases, stored procedures, views, triggers, synonyms, indexes, and reports for projects.
• Created SSIS jobs for data warehouse population, system and application integration, and third party application population.
• Implemented and maintained two SSRS data warehouse instances. Included in the warehouses are custom data models and reports.
• Created reports for historical analysis, asset optimization, forecasting, and compliance.
• Implemented SSAS instance for financial and historical shipment analysis and mining.
• Worked with developers to upgrade and maintain entity data model for custom TMS application.
• The application was developed in ASP.NET 4.0 using C#, Entity Framework, SQL Server 2008 R2, AJAX, Jquery and Telerik ASP.NET and Silverlight controls.
• Acted as project manager, business analyst and liasion, database programmer and lead, quality assurance lead and graphics lead.

Confidential, Mooresville, North Carolina

I.T. Project Manager

Responsibilities:

• Managed application development teams up to nine persons, including in-house and offshore programmers, database administrators, quality assurance testers, interns and vendor contractors.
• Lead daily scrum meetings as ScrumMaster, coordinating the management of all IT projects. Other project techniques used include agile and waterfall development, and LEAN methodologies.
• Temporarily acted as the database adminstrator ( 2009-201 0) - implemented and maintained databases, data models, stored procedures and reports using multiple instances of SQL Server 2005 and 2008 .
• Project successfully came in on budget and time, with only one programming resource and no QA or business analyst. Acted as project manager, QA tester, business analyst, training developer and trainer. Application was developed using C# and ASP.NET 3.5 using AJAX, and SQL Server 2005.
• Application increased average shipment postings per week by over 7,500%.
• Reduced the number of inbound help desk requests by 40%, by introducing self-serve account management.
• Designed, wrote functional specifications for, and managed the implementation of Confidential 's customized, corporate website using the open source MojoPortal content management system.
• Project was completed on time in three months, with no budget, with only one programming resource and no QA or business analyst. Acted as project manager, QA tester, business analyst, training developer and trainer.

Confidential, Miami, Florida

Marketing Analyst

Responsibilities:

• Administrated a custom-built, integrated CRM-Sales Force Automation application on the .NET Platform (using C#) with over 800 users in three countries for a domestic sales organization that generated annual revenues of over $1.6 Billion in 2006.
• Developed, organized and implemented two software development life cycles of CRM-SFA hybrid as business project manager. Acted, beyond initial job scope, as liaison between business and technical owners and overseas programming vendor, based in India.
• Designed and wrote requirements for interactive dashboards.
• Wrote SQL queries and created reports with graphs and histograms.
• Wrote and executed over 400 Transact SQL queries, reports and packages against multiple servers and databases for data analysis and business process improvement purposes. Converted queries into overnight jobs and Data Transformation Services (DTS) Packages.
• Executed and modified SQL scripts that generated the official figures for the sales organization for Ryder's quarterly SEC filings and board of director meetings.
• Performed data analysis, data manipulation, reporting and forecasting for the sales organization using SQL server and Excel pivot tables.
• Created manual ETL processes in SQL and Excel to create the necessary reports/extracts/tools for the sales personnel to do their jobs more efficiently.
• Managed application technical support team and application technical support contractor, effectively acting as manager.
• Developed, organized and implemented two application deployments to over 800 users in three countries; responsibilities included RFP, vendor management, deployment planning, user attendance scheduling, and user training.
• Saved the sales and marketing department over $275,000 by implementing webinar-based training and traveling to end users at field locations throughout the United States and Canada.

Confidential, Miami, Florida

E-Learning System Analyst

Responsibilities:

• Designed a custom, integrated e-learning system using ASP .NET 2.0 and VB.NET to deliver training modules and certification exams to outsourced Help Desk technicians overseas, which immensely decreased Help Desk contract costs. This application delivered training materials to over twenty-five help desk technicians via Intranet, while using a custom security module.
• Developed training materials for the Help Desk outsourcing project. Materials included PowerPoint presentations, documents, video presentations, hands-on activities, exams and practical exercises.

Confidential, Miami, Florida

Help Desk Technician I & II

Responsibilities:

• Installed and performed repairs to hardware, software and peripheral equipment, following design or installation specifications over the phone to many of Ryder’s 10,000+ employees and executives.
• Reduced Help Desk overhead costs by $56,000 by independently proposing and developing an Intranet portal.
• Developed and managed three Intranet portal iterations for the Help Desk using PHP and ASP .NET 2.0, which housed knowledge articles, links and message boards. This application was vital in the outsourcing/off shoring success.
• Developed a self-sufficient portal for the Help Desk (using an ASP .NET 2.0 implementation of DotNetNuke) that removed the need for a programmer and enabled Ryder to outsource its Help Desk overseas. The application is still in use today. The portal features include a knowledge management system, content management system, document management system, and high severity alert message board.
• Developed an employee-facing self-help Help Desk portal (using ASP .NET 2.0) for Ryder’s 10,000+ US and Canadian employees. This application included a knowledge management system for self-help technical support articles, video presentations and system outage information.