SUMMARY

• Confidential is a Certified Teradata Master with more than fourteen years of on - site experience with clients developing Internet strategies and delivering data management solutions.
• He has ten years of successful development, support, and project management experience in numerous spaces including government, retail, financial and manufacturing industries using Teradata, Oracle, SAP, and numerous Web development tools. Currently completing CISSP certification process.

TECHNICAL SKILLS

Languages: HTML, XML, JAVA, JAVA Scripts, VB, SQL, SQL +, C++, Visual C++, Visual J++.

Software: Confidential Teradata (14yrs ’12), Lotus, Oracle 8i - 7x (13yrs ’09), PL/SQL & PL/SQL+ (13yrs ’09), Viewpoint (3 years ’12), TASM (2 years ’11), Multi-Load (13 years ’11), Fast-Load (13 years ’11), T-Pump (9 Years ’11), TPT (2 Years ’11), Business Objects (13 yrs ’12), Tivoli (7 yrs ‘09), Cognos (4 yrs ’09), Informatica (9yrs ‘11), Erwin (9 yrs ’11) MS 2000 Professional, NT 4.0 Workstation, ’98, 95, MS Developer Suite, IIS, Linux, Witness (1 yr ’01), IBM DB2, SAP (3 yrs ’01), Enabler, Visual Enabler, Rational Rose, ASP, JSP (6 yrs’ 03), Crystal Reports, Flash, Illustrator, PhotoShop, Cold Fusion, Hot Metal, Front Page, Dream Weaver, OS/2, E-Quality

Hardware: Desktop PCs, Servers, High Speed Digital Data Transmission Networks (ISDN / ID 6), High Speed Wireless Digital Communications Systems, LAN, Web Phones, Aspect Phone Switches.

Languages: Fluent German, conversational Turkish and Italian, read Portuguese; self taught Russian, Ukrainian, Spanish, and Korean. Currently learning Hindi.

PROFESSIONAL EXPERIENCE

Confidential, Norfolk Virginia

Teradata Expert

Responsibilities:

• Coordinating the integration of new Teradata hardware and V13.10 software.
• Created the logical and physical data modeling of databases being transferred from Oracle / SAS to Teradata.
• Architected and created completely new Teradata data structure for new warehouse.
• Query performance tuning.
• Training and mentoring technical staff.

Confidential, Boca Raton Florida

Lead Consultant Developer. Lead / Senior Developer

Responsibilities:

• Built and deployed new ETL process to allow executive management to track attainment of sales force goals across multiple reporting levels.
• Built and deployed new database and ETL process to allow executive management to track customer loyalty rewards.
• Built and deployed new database and ETL process to allow executive management to effectiveness of various marketing initiatives and redirect efforts to improve business to business sales.
• Identification and replacement of obsolete data sources across the Data Warehouse.

Confidential, Columbus OH

Data Warehousing and ETL Consultant

Responsibilities:

• Conducted comprehensive review of Teradata instances evaluating available T-Perfs, indexing, partitioning, and priority scheduling and workload management (TASM).
• Evaluated several future Data Warehouse architecture options for capacity planning including use of data appliances and mixed hardware environments.
• Evaluation of Data Stage ETL process, scheduling, and hardware infrastructure.
• Review of Micro-strategies reporting process and review of generated SQL for tuning opportunities.

Confidential, Evendale OH

Senior DBA / Data Architecture Design Consultant

Responsibilities:

• Designed technical architectural and quality standards and guidelines and have enforced them through frequent design reviews conducted at the development, testing, and deployment lifecycle.
• Developed M-Load scripts for loading large volumes of data in to production server several times per day.
• Used T-Pump to maintain trickle feed of engine testing data into production database.
• Used TPT for moving data from Production to Dev Environments.
• Advised development teams regarding best practices in relating to various aspects of data warehousing including ETL, Indexing, and performance monitoring.
• Responsible for the review and tuning of Informatica ETL scripts loading multiple terabytes of data to improve performance and reduce data skew.
• Performed tuning of Cognos and MicroStrategies generated business intelligence queries to improve performance of 25 most commonly run reports, cutting runtime to less than 30% of pervious levels.
• Implemented TASM priority scheduling on Development, Testing, and Production environments.
• Developed ETL scripts for loading Wind Turbine Generator project on to the data warehouse, resulting in more than a 200 percent improvement in performance.
• Created of physical data model for Air Craft Engine Diagnostics project that provide near real time data of status of jet engines installed on civilian airliners.
• Provided technical guidance on solution architecture, design, development offshore development, integration, and quality assurance teams.
• Provided oversight for the pre-production / implementation phase Change Management process through frequent code and deployment readiness reviews.
• Configured TASM to manage system resources and provide e-mail paging alerts and used the new Teradata View-Point tool to pro-actively monitor data warehouse performance and ensure that SLA standards were met.
• Configured priority scheduler to apply various levels of resource allocation levels to individual user accounts based performance of SQL being submitted.

Confidential, Wright Patterson AFB, OH

Senior Consultant / DBA

Responsibilities:

• Used Fast-Load and Multi-Load for loading tables in Development, Test, and Production environments.
• Developed Teradata query that provided the first ever detailed description of corrosion of Aircraft components across the entire USAF fleet; leading to revision of maintenance procedures on assets deployed to South West Asia.
• Developed and executed numerous large scale Teradata queries that were used to provide data to the House and Senate Armed Services Committees regarding costs of operations in South West Asia, Air Force operations tempo, and viability of air transport and tanker fleets.
• Developed and executed a customized Teradata query for the CADPAD Joint Services Project that is used to identify key components of ejection seats for safety inspection and replacement.
• Developed numerous Teradata queries to address safety concerns on several USAF systems including wing root stress fractures in the T-38 trainer fleet and emergency tracking of defective ejection seat components.
• Provided specialized support to OSD, SAF, AFSOC, ACC, and ANG constructing customized Teradata queries to extract needed data.
• Conducted emergency data extracts From Teradata to support USAF investigations into downed aircraft.
• Developed and executed query that provided the basis for the Secretary of Defense’s semi-annual fleet status review.
• Conducted engineering reviews of new applications prior to deployment to ensure compliance with database standards.
• Primarily responsible for management of system resource allocation of Teradata Development system.
• Primarily responsible for enforcement of information security measures and policy on Teradata development and production systems.
• Responsible for creation and maintenance of Teradata user accounts on both Production and Test / Development environments including assigning of user privileges and roles as appropriate.
• Responsible for performing basic Teradata DBA tasks such as table maintenance, statistics collection, and monitoring of system performance.
• Provided technical phone support for worldwide user community, including real time support for deployed USAF units during Operation Iraqi Freedom.
• Conducted initial trouble shooting of Teradata issues including Teradata tables to provide optimum system functionality including identifying possible architectural design flaws and data quality issues.
• Conducted troubleshooting of Business Objects’ universes to identify design issues and implement fixes when possible.
• Insured functional integration of Oracle repository, Business Objects Software, Teradata servers, and NIPR Net.
• Acted as Lead on USAF AFKS helpdesk with tasking and supervising responsibilities over junior consultants.

Confidential, Greenville, SC

Business Consultant

Responsibilities:

• Participated in the development of BMW proprietary application for control and auditing of manufacturing plant operations.
• Developed GUI web applications that interfaced with Oracle 8i data ware house for BMW NA using SQL, JAVA, and HTML.
• Worked on automated production application using VB, UML, Java and JSP.
• Used MS Developer tools to develop ASP interface for Softlab's Visual Enabler Data Repository software with embedded VB applications.

Confidential, Columbus, OH

Programmer/Analyst

Responsibilities:

• Participated in the install of the witness system for Pearson’s Columbus Ohio facility.
• Created organizational schema that grouped client information into business unit user groups.
• Conducted statistical results reporting and business process modeling simulations and presented results to executive level management.
• Acted as primary system administrator, responsible for all maintenance, modifications, and technical support for the Witness software.
• Completed two separate on-site witness training courses, including system administrator training.
• Backed up data in witness system to Sybase database, and performed disaster recovery as needed using Veritas software.
• Served as Business Analyst that created technical solutions that improved the operating efficiency and profitability of several lines of business.
• Reduced $2 million in annual operating costs by automating SAP driven customer-invoicing process and using web-based customer self-service ASP software developed with MS Developer.
• Performed DBA functions including physical database design, creating and loading tables, backup and disaster recovery for Oracle 8i Data Warehouse
• Performed data modeling and star schema design for Data Warehouse and local data bases using Rational Rose.
• Created web based application to track order realization utilizing imbedded SQL\ PL\SQL queries of the Oracle Data Warehouse and SAP system to eliminate an 8 month backlog of unaccounted for orders.
• Designed, created, and administered Local Sybase Data Mart performing bench marking, modification, and disaster recovery as required.
• Performed general network administrative duties for facility of more than 250 employees.

Confidential

Independent Consultant

Responsibilities:

• Analyzed information systems infrastructure of Confidential Inc, and assisted in developing plan for overhaul and upgrade.
• Created Business Objects reports that interfaced with Oracle 7i for Confidential Inc. of Columbus Ohio.
• Wrote business strategies to expand e-commerce opportunities in Europe and Latin America.

Confidential, Columbus, OH

Team Support Specialist

Responsibilities:

• Promoted to Project Manager for future e-commerce application development.
• Proposed concept to develop Java based 3-D customer interactive JSP/ASP using Halcyon iASP.
• Oversaw and collaborated on various high profile IT projects including the preliminary development of retail applications in Java and Visual Basic.
• Loaded Oracle 8i tables on Customer back office PCs using PL/SQL UNIX line commands.
• Configured Oracle, Teradata, and PeopleSoft on all PC and POS systems delivered to Victoria’s Secret Stores and Bath and Body Works.
• Created new business tracking reports using customized Teradata queries utilizing proprietary Confidential ETL tools set on an ongoing basis.
• Assisted in data migration from DB2 system to Teradata data warehouse.

Confidential, Mason, OH

Data Systems Specialist

Responsibilities:

• Tuned performance on DB2 base to improve system performance for end users.
• Instituted new productivity tracking procedures that boosted productivity 25%
• Increased the companies operating efficiency by locating and eliminating database inaccuracies.

Confidential, Columbus, OH

Intern International Banking Department

Responsibilities:

• Extensive dealings with Brazilian, Italian, South Korean, and Chilean governments and businesses.
• Increased the size of the database by more than 300%.
• Improved accessibility and efficiency of data mining with the introduction of standardized reports utilizing SQL queries of Oracle and Teradata Data Warehouses.

Confidential, Columbus, Ohio

Conversational English Instructor

Responsibilities:

• Worked closely with people from a variety of cultures including, Brazil, Columbia, Korea, Japan, the PRC, Taiwan, Turkey, Russia, Poland, Thailand, and the UAE.