Sql Server Data

Thomas Costigan

Email: *********@********.***

Address: **** ****** ****

City: Falls Church

State: VA

Zip: 22042

Country: USA

Phone: 703-***-****

Skill Level: Experienced

Salary Range: $102,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Thomas E. Costigan Jr., MISM

6935 Custis Parkway Falls Church, VA 22042-2049 USA

Home Phone: 703-***-****

E-Mail: *********@********.***

Mobile Phone: 703-***-**** (

Summary of Professional Qualifications

Over thirty years of information systems technology experience. Specialist in data conversion, data integration, extract/transform/load (ETL) projects on the MS SQL Server platform (2000, 2005 & 2008) using the SQL Server Integration Services (SSIS) and SQL Server Report Services (SSRS) components of the MS SQL Business Intelligence Development Studio (BIDS) and related technologies such as the Pervasive Data Integrator (PDI) data conversion tool using the RIFL scripting language. Functional experience in the fields of accounting & financial management, human resources (HR) / payroll / time & expense reporting, sales force automation (SFA) & contact relationship management (CRM), online banking & bill payment services, and international trade analysis. Experience with Visual Studio, XML data exchange, web portal technologies, Web Expressions, and Crystal Reports. Proficient in MS Office programs (Word, Outlook, Excel, Access, PowerPoint and Project). Business proficiently tri-lingual: English, Spanish and Brazilian Portuguese. Extensive travel experience both domestically and throughout Latin America and the Caribbean.

Formal Education

Master of Information Systems Management (MISM), The Keller Graduate School of Management (06/2003)

Master of Arts (MA), Latin American Studies, Georgetown University, Washington, DC (05/1981)

Bachelor of Arts (BA), Economics, Columbia College, Columbia University, New York, NY (05/1979)

Certificates And Continuing Education

Certified Developer, Pervasive Data Integrator, Pervasive Software, Austin, TX (02/2008)

Certified Information Systems Specialist, George Washington University, Washington, DC (05/1988)

Experience

Business Integration Analyst Engineer, TDB Communications, Lenexa, KS: 02/2012 to present (scheduled to conclude on 12/21/2012). Contract employee on assignment to the US Dept. of Homeland Security, Customs and Border Protection Agency, located in Washington, DC for the development of a data warehouse dealing with international trade compliance issues. The system is developed in MS SQL Server 2008 using SSIS, SSRS and SSAS. My immediate responsibilities deal with the loading of the warehouse from several disparate data sources using SSIS as the primary ETL tool. Phase one of the project was completed in late April. This phase loaded refined and summarized international trade data for the current and previous three fiscal years. Phase two of the project deals with the development of report tables that allow analysts to quickly identify strategic patterns of trade behavior that can then be used for tactical compliance actions. Background investigation completed and clearance granted to view and work will all confidential international trade data.

Data Consultant, Addison Search, Schaumberg, IL: 01/2012 to 02/2012. A temporary contract assignment to a for-profit adult education institution based in suburban Chicago, Illinois that is expanding its operations into Mexico and Chile. I was responsible for analyzing data coming from the current system in Mexico in preparation of integrating the data into the data warehouse system of the company in North America. My responsibilities included translating between English and Spanish as required to help run the daily progress telephone call meetings with the Latin American offices. Data conversion work done using the Talend Open Studio data conversion tool into an Oracle 11 database.

Senior Consultant, Deltek, Herndon, VA: 11/2010 to 12/2011. Responsible for data conversion, transformation and load projects related to Deltek`s Costpoint line of accounting systems (including GCS/System 1 and Time & Expense) primarily using the Pervasive Data Integrator program and MS SQL Server (including SSIS). On-site coordinator of a group of developers who was assigned to a complex Pervasive application that uses web portal technologies to tie together several ERP systems with Costpoint; briefed new members onto the project, launched them into productivity and got out of the way to let them be successful. Developed interfaces from Costpoint to the PayChex payroll and Vanguard benefits systems. Worked diplomatically but effectively to manage client project managers to engage their staff to provide timely and qualitative data submissions. Created formal estimates for new business opportunities that were accepted and successfully implemented. Helped to write the technical aspects of marketing materials for new products and services.

Configuration Systems Analyst, Online Resources Corporation (ORCC), Chantilly, VA: 04/2002 to 11/2010. Completed over 140 data conversion projects that converted customers, payees and payments using the Pervasive Data Integrator program and related SQL Server technologies that became part of ORCC`s online banking and bill payment system. Mentored and managed other staff members to enable them to perform data conversion projects using the same procedures and techniques that I developed. Engaged with ORCCs development team to design, test and manage the XML-based data load program to SQL Server. Served as the technical support coordinator for ORCC`s cash management system and directed other ORCC colleagues and client staff on how to avoid, identify and resolve invalid and fraudulent activities. Technical manager of ORCC`s internal sales force automation program deployed on the GoldMine CRM system; managed and mentored others to engage the day-to-day operations of the system. Served as the back-up administrator of the Remedy trouble-ticket tracking system and as a member of the application support group responsible for system performance monitoring, invalid / fraud activity detection and related problem / issue identification and resolution.

Systems Analyst for sales force automation / contact relationship management system projects (1996 to 2002) deployed using the GoldMine CRM product primarily for Vertical Marketing, Inc., Fairfax, VA. Managed remotely a team of ten developers who were located in Vishakhapatnam, India. Also worked as an independent contractor for the American Red Cross (National Capital Area Chapter), Washington, DC and as a consultant for Public-Sector Solutions, Falls Church, VA for accounting system projects that used the encumbrance-based USL Financials accounting system.

Pan American Health Organization (PAHO) / World Health Organization (WHO), Washington, DC (1989 to 1996). Programmer / Analyst and member of a small development team of a multi-user, multi-lingual, multi-currency fund-based accounting system that was installed in PAHO`s 35 field offices throughout the Americas. Over 20 trips to PAHO`s field office to perform system installation and support services. The software was developed in FoxPro and deployed on a Novell Netware network for multi-user installations. Responsible for managing the change from paper-oriented accounting systems to standardized, networked systems that engaged electronic data exchange back to Washington; overcame fear and resistance by local staff to make these necessary changes. Member of the PAHO disaster response team; sent on a mission with the International Red Cross to St. Maarten to provide emergency satellite telephone technology & training following hurricane Luis in 1995.

Microcomputer Consultant (1982 to 1989). Co-founder of Washington Programming Team, Washington, DC, the first company to be listed in the Washington Yellow Pages under -Microcomputer Consulting.- Managed up to 15 employees for the sales, installation and support of accounting systems from CYMA and NewViews. Sold and managed the installation of one of the first 3Com networks on the East Cost. Managed the development process of a software program for the Alliance To Save Energy that performed return on investment analysis of energy efficiency investment projects.

Newman & Hermanson Company, Washington, DC (1980 to 1982). Research analyst for US and international government studies in housing and urban development funded by the US Department of Housing and Urban Development (HUD) and the US Agency for International Development (US AID).

Other Relevant Activities and Interests

Soccer Referee, (1981 to present) certified and licensed by the Metro DC / Virginia State Referee Association of the United States Soccer Federation (USSF) and the Virginia High School Leagues (VHSL) association of the National Federation of State High School Associations (NFHS). I have over thirty years of experience refereeing the most popular game on planet earth on the youth recreational, youth competitive, high school, senior amateur (adult) and semi-professional levels. As a soccer referee, you have to manage two groups of eleven people who may not like each other very much (including their coaches, parents, fans and related supporters) to obtain a successful and fair outcome of the match. Since 2003, I have also been a certified Referee Instructor (by the USSF) with the responsibility of providing formal classroom and on-field training classes for new referees, recertification of current referees, and on-field mentoring of up-and-coming referees to encourage and improve their abilities to referee soccer.

On a volunteer basis since 2003, I have served as a member of the Columbia University Alumni Representative Committee (ARC) that performs undergraduate admissions interviews for students applying to Columbia College and the Columbia School of Engineering. I was appointed co-chairman of the Northern Virginia contingent in 2010, I represent Columbia and perform college / information forums at high schools and college fairs in Virginia, and I manage the assignments of applicants to the other fifty or so alumni in the region who actively perform admissions interviews. I have personally interviewed almost 200 applicants to Columbia over the years and have therefore helped these young men and women manage the process of applying to and being selected by a university like Columbia.

References Are Available Upon Request

Contact this candidate