Helpdesk Support Resume Profile
SUMMARY
I'm a hands-on Data Architect and Senior SQL DBA with over 30 engagements in the Banking, Insurance, Accounting, Manufacturing and Distribution, Technology, Retail, and Government sectors. Top clients have included Microsoft, Wachovia/Wells Fargo, Bank of America twice , American Express, Ernst Young, Coca-Cola twice , Tyson Foods, the TJX Companies, UPS, Home Depot and the U.S. government. I have a Department of Defense security clearance, level S Secret , and Big Data experience.
SKILLS
BI / Data Warehouse design, admin tuning | Transactional Database design, admin tuning |
T-SQL PL-SQL development, code review tuning | VLDB Very Large Database design, admin tuning |
Database upgrades migrations | DTS, SSIS, ETL development, migration tuning |
Application Integration projects | Disaster-recovery planning tuning |
Data Services manager | Production Development DBA |
SSAS .net development support | Reporting Services SharePoint development support |
New server specs, builds integration management | Disk sub-system optimization |
Data Modeling, Process Flow Diagramming | Detail Design documentation |
EXPERIENCE: SNAPSHOT
EXPERIENCE: DETAIL
Confidential
Data Warehouse Architect
Confidential is a 1B private company and underwriter of wholesale specialty insurance including: property, casualty, professional liability and directors and officer's liability coverage. Confidential operates as a subsidiary of Alleghany Insurance Holdings, LLC. I am the Architectural lead for a new, enterprise BI Analytics reporting environment proof-of-concept. Performing requirements gathering, legacy systems analysis, OLAP data warehouse design, integration and ETL planning. Tableau 8.2 and Qlik Sense.
Confidential
Principal Data Architect, Client Management, Reference Data and Trading Systems
Confidential, a large financial services Broker/Dealer, Prime Brokerage, Pension Fund Management, Private Wealth Management / Banking company in Mexico. It is headquartered in Mexico City, and has offices in the USA, South America and the EEU. Because of the USA's Foreign Account Tax Compliance Act FATCA , GBM needed a new enterprise-wide system to track US taxpayer financial data, and also to strengthen client data requirements to comply with Know Your Customer KYC guidelines. I am the data architect for Client and Product Reference Data, providing database design, optimization, T-SQL stored procedure coding and ETL services for a multi-year, start-from-scratch, Front- and Back-Office systems redesign project. The project has required constant travel between the US and Mexico City and fluent Spanish.
Confidential
Data Architect, BI Risk Analytics Developer
Munich Re DAX:MUV is 130 years old and employs 47,000 persons worldwide. The company has evolved into more than 50 business units. I was with the one that generated 62B in 2010 providing risk coverage to 5,000 primary insurance companies in 150 countries. My project was to design a HOLAP data mart scalable to greater than 100M records, develop data migration and ETL processes to homogenize and connect over 1000 data-sources in both 64-bit Oracle 11g Enterprise and 64-bit SQL Server 2008 Enterprise, and to write and tune DML queries to produce meaningful extracts for consumption by actuarial risk-modeling software.
Confidential
Data Architect, Systems Architect
- Current DoD security clearance S . Subcontractor to SAIC and QinetiQ on two Federal Government projects:
- US Army Software Engineering Directorate for the Pentagon project MFOQA Military Flight Operations Quality Assurance . This was a build-from-scratch applications development project to provide a maintenance, operations, safety and training suite for military aviation. Each branch of the military has their own project and I was on the US Army's. I designed new database objects, and provided best practices training and T-SQL support to multiple teams of .net developers at Ft. Rucker and Redstone Arsenal. We were honored to receive the 2010 Army Modeling Simulation Award for Army-wide Team Operations Plans. Our prototype set the conditions for future Army Aviation operations and training by significantly increasing productivity, quality, safety and communications.
- USDA / Risk Management Agency project CIMS Comprehensive Information Management System . This was an ETL and performance-tuning assignment designed to port existing batch processes originally written for SQL 2000 to more efficient SQL 2008 R2 procedures and cut processing time 50 . Special challenges involved multi-terabyte data-sets, remote data-center operations, and limited hardware resources. Also provided Best Practices for SQL Server configuration, administration and T-SQL coding.
Confidential
Data Architect, Supply Chain Business Intelligence
Home Depot NYSE:HD recently began changing to a Regional Distribution Center model for its supply chain. I provided MSSQL BI database design, optimization and SSIS ETL services to bridge their legacy Purchase Order systems with their Manhattan Associates Warehouse Management System WMS enterprise supply chain software. I also specified new SQL 2005 BI servers, managed their deployment, designed the new SQL Server ROLAP databases, designed and administered the SSIS ETL processes which pull and transform legacy system data from two IBM ZOS mainframes running DB2 and up to 30 remote IBM AIX systems running DB2-UDB into SQL 2005 for end-user reporting.
Confidential
Senior SQL DBA / Data Architect / Best Practices trainer
- As a subcontractor to Microsoft Consulting Services for their national database projects, I completed 5 projects:
- American Express NYSE:AXP , Investment Services Phoenix, AZ . This was a pure consulting engagement where I was part of a 3-person Microsoft team that was asked to perform a code review on one of their confidential business intelligence financial applications and present their upper-management with optimization recommendations.
- Wachovia NYSE:WB , Investment Banking Charlotte, NC - Risk-Management Division. The MARS Risk Management application and its associated 1.6 terabyte database tracks and performs real-time updates to every investment that the bank owns international and domestic stocks, derivatives, ADR's, ETF's, Bonds, Currency contracts, Mortgage-Backed Securities, etc. Individual investments prices must be kept current 24x7 and it's a clustered, high-concurrency, high-availability, high-profile application and database. My duties were broad: daily database administration, performance tuning both the physical environment and T-SQL code, stored procedures writing, ETL processes, SSIS, 300M transactions/day continuous Transactional Replication tuning and administration, specifying and building 2 new SQL 2005 Production servers, data migrations to new SQL 2005 environment, VLDB administration, Best-Practices and Disaster Recovery planning.
- Bank of America NYSE:BAC , Global Wealth and Investment Management division St. Louis, MO . Where Wachovia's MARS system is a Risk Management application, Bank of America's Linedata Lineview Trading System is the transactional application that gathers and executes the Bank's trades in global equities markets. I was brought in as a Data Architect to provide the plan and to support the migration of this system to clustered and mirrored 64-bit SQL 2005.
- Moduslink International NASDAQ: MLNK , is the company contracted to Microsoft to provide Vista operating system order-fulfillment. My project was a borderless work-from-home requirement to provide them with custom SQL reporting via VPN and conference calling for a confidential project involving teams in Singapore, Amsterdam, and the NW US.
- TJX Companies, Inc NYSE:TJX - Merchandising Systems Division Westborough, MA . This is the parent company of several retail chains: Marshalls, TJ-Maxx, Bob's, AJ Wright's, Homesense Canada , Winners Canada , TK-Maxx Great Britain . They currently do most of their Sales, Inventory and Purchasing on the mainframe. I led their internal database architecture team in Phase One database designs to begin moving these functions into a SQL 2005 on Itanium-64 environment. I also taught 10 90-minute classroom sessions on SQL Best Practices.
Confidential
Database Services Manager / Senior SQL DBA / Data Architect
This financial services company NASDAQ:PRGX mainly provides contingency auditing services to large retailers Wal-Mart, Walgreens, Pharr-Mor, Rite-Aid, Piggly-Wiggly, etc . I had a very much hands-on technical management role as their Database Services Manager and a working production DBA. This was 'Big Data', with over 220 terabytes of SQL databases, Gartner Group reported us as being in the top 10 worldwide in terms of sheer volume of data under MSSQL Server management. I was responsible for all of it providing strategic direction to the company for data management handle the performance optimization of the physical environment, daily administration of approximately 1500 SQL databases on 60 servers, oversight on numerous internal T-SQL programming projects, and the selection and management of database-related vendors and service providers. Lead and mentor of the Database Administration Services department 4-6 direct reports . Oversaw contractor work product, Database and dataflow design, T-SQL programming, Best Practices authoring and training, Disaster Recovery planning, and Database administration of VLDB Very Large Database environment.
Confidential
Data Architect / T-SQL Developer
I provided SQL database design and Stored Procedure programming services to UPS NYSE:UPS BIA Business Intelligence / Analytics department, specifically for a new application development project. I was the sole SQL resource working with a team of Coldfusion developers to produce UPS' new browser-based Key Performance Indicator application for internal use by UPS decision-makers. I did Dataflow and Database Design, Implementation and Automation, Stored Procedure development.
Confidential
Data Architect/Senior SQL DBA
Tyson Foods NYSE:TSN is the world's largest producer of chicken, beef and pork products with over 80 processing plants and their associated systems and administration databases. I was brought in to design, implement and maintain some of their federally required data-repositories. These de-normalized SQL data marts held Human Resources info from diverse data-sources across the Tyson enterprise. I additionally served as both Development and Production DBA of the HACCP the international quality-assurance standard compliance production-controls software. Developed in-house, it schedules and tracks the results of regular quality control tests for the company's food production lines at 80 locations nationwide. I provided high-level relational database consulting and mentoring to junior staff and database interface programmers on other projects/apps.
Confidential
Data Architect
Georgia-Pacific NYSE:GP is an international building and paper products manufacturer and distributor with 300 factories in the US, Latin America and the EU. I designed, implemented and trained them to maintain an MS SQL Server business intelligence data-warehouse for their UNISOURCE Mexico Division. This involved OLAP database design, custom replication programming via stored procedures, DTS package design, ETL programming for data extraction, summary and export to an Oracle data-warehouse while dealing with the special problems involved with working across an international WAN. I also had to speak technical Spanish to direct the Mexico I.T. staff.
Confidential
Managing Consultant
Managing Consultant of all Microsoft SQL related initiatives at Coca-Cola Enterprises NYSE:CCE corporate headquarters. CCE is the bottling arm of the Coca-Cola empire. My job was the hands-on management of 175 data-marts on 10 Production, 5 Staging and 5 Development SQL 7 servers across their international WAN. I developed and enforced corporate programming standards for intranet, internet and data-mining / business intelligence client-server applications which used SQL databases. I was somewhat responsible for the daily management and training of Jr. SQL staff. I did design and implementation of their SQL Server disaster recovery processes, automated maintenance and query optimization of the data-warehouse databases.
Confidential
Senior consultant
Design and implementation of automated performance optimization, maintenance and disaster recovery processes on supply-line business intelligence data-warehouses. Clients included Burnham Services, an international logistics company transporting the majority of new IBM computer systems and bank ATMs worldwide and Colonial Pipeline which moves 80 million gallons of product per day through 5349 miles of their own, world's largest-volume refined petroleum products pipeline. These MSSQL Business Intelligence databases ran on Compaq 7000 NT servers and utilize both one- and two-way DataMirror and InfoPump replication across multi-state WANs between DB2 databases running on AS-400s, Oracle databases running on RS6000s and SQL Server databases running on NT. I was the onsite Project Manager, SQL 6.5 - 7.0 migration, regression testing, QA, disaster recovery planning, Change Control and User Acceptance Testing.
Confidential
Project Manager
SQL 6.5 to 7.0 e-commerce website migration Project Manager for Tech Data, a 17 billion international software and hardware wholesaler/distributor at the time ranked 102 in the Fortune 500 NASDAQ:TECD . Coordinated the efforts of multiple departments and supervised up to 35 individuals at any one time. This website generated 42,000,000 per month in sales revenue and its associated production database serves eight additional legacy applications. Consequently, the implementation was required to be live no parallelism and accomplished within a four hour scheduled outage. The project included regression testing of the existing Web and internal applications, mainframe connectivity via MDI gateways, SNA Server, NT4 SP5, SQL 7 SP1, Internet Information Server 3 and 4 in addition to the expected troubleshooting of the existing 6.5 database schema for the upgrade. The hardware
Confidential
Senior Consultant
Senior Consultant in the Mortgage Loan Management System MLMS product division of Securities Software and Consulting NASDAQ:SSNC , a financial software publishing firm with offices worldwide. I was a billable specialist and responsible for the installation and networked configuration of proprietary 3-tier client-server commercial loan systems as well as SQL Server 6.5, NT 4.0 and Crystal Reports on the client's server s . Clients included some of the best-known names in the Finance and Insurance industries, both in the U.S. and abroad. When not traveling, I did product customization such as automated batch processing, wrote technical specifications for system modifications including data-mapping and performed MS SQL DBA functions. I also completed a leadership role in our own 126 node network conversion from 16 mbps token-ring to 100 mbps Ethernet. My clients were:
|
|
|
|
|
|
|
|
|
|
Confidential
Network Administrator, Network Conversion Consultant, Implementation Team Leader
I worked with their Commercial Factoring Division and was responsible for a key, 500 node network server upgrade to Windows NT 4.0 in addition to the client-side upgrade to Windows '95. Planned, deployed and administered their network anti-virus solution. Additionally, was responsible for the creation and full time administration of the Collections Domain, with an end-user base of 80 personnel. Responsibilities in that role included the physical upgrade of end user workstations to Year 2000 compliance and the redesign of the UNIX network segment for optimization with a DAVOX predictive dialer system. This system controls the daily activities and documentation for all of their Collections operations.
Confidential
Helpdesk support, desktop support, project asset manager. Hardware installation support, software installation support, trainer.
While at Ernst Young, I was third-level support in their Atlanta WAN site end-user troubleshooting organization. Part of a 1200 site global WAN, the Atlanta segment had over 800 workstations, over half of which were connected remotely through secure internet connectivity or direct RAS dialup. When Ernst Young signed a seven-year, 1 billion contract for SAP design and implementation with the Coca-Cola Company NYSE:KO , I was transferred to work as the permanent on-site workstation support for the project Project Infinity . On a typical day I would participate in hardware and software specification processes with Coke staff counterparts, coordinate and participate in the rollout of the upgrades, maintain accurate inventories, manage network security clearances, and directly support 125 on-site users.
Confidential
Finance / Sales Distribution as a Commercial Loan Officer, Real Estate Market Analyst, Small Business Owner, E-Commerce Server Builder / Developer
I was involved in e-Commerce before it was on the Web. I built and maintained direct-dialup commerce servers designed to provide absolutely secure electronic transactions for retail and mail-order businesses. I worked to perfect an offline downloadable product for such businesses. This innovation allowed customers to keep a current, multimedia catalog of products, prices and shipping constraints on their local machines and provided them the means of point-and-click ordering and customer service inquiries which would run as batch processes after business hours or in real-time mode, depending on the customer's preference.