|
|
|
|
Senior Data Warehouse/ETL Developer Resume
|
| Desired Industry: Information Technology |
SpiderID: 6468 |
| Desired Job Location: San Antonio, Texas |
Date Posted: 4/9/2006 |
| Type of Position: Full-Time Permanent |
Availability Date: 2 Weeks |
| Desired Wage: 75,000 |
|
|
U.S. Work Authorization: Yes |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: Yes, 25-50% |
| Highest Degree Attained: Bachelors |
Willing to Relocate: Yes |
Objective:
BERNIE T. BESSONETTE
7500 Callaghan Rd. #192 Phone: (210) 349-2308
San Antonio, TX. 78229 Email: bbessonette@satx.rr.com
PROFESSIONAL SUMMARY
w 12 years niche experience in multi platform data migration including Requirement Definition, ERP including SAP and Oracle, Data Warehousing with extreme emphasis on ETL, Data Marts and Data Mining
w All aspects of data warehousing projects including Requirements Gathering, Design, Implementation, Data Conversion, Data Cleansing & Verification, Custom Methodologies,
Custom Reporting and automation
w Experience with Fortune 100 Clients, DOD and State Government
w Experience with all IBM, Unisys, HP, Sun Solaris& PR1ME mainframes, Unix platforms and
all supporting system utilities, JCL/ECL and scripting, etc.
Technologies:
Platform Summary
Oracle 8i & 9i, Teradata, IBM 3090, AIX/SP2 IBM Unix, HP Unix, Sun Solaris Unix E10000,
Unisys 1100/2200 mainframes, Honeywell mainframes, PR1ME
Data migration initiatives
Teradata, SAP, Oracle, Data Warehouse, DBII, Sybase, RDMS (Unisys)
Software ETI EXTRACT, TSISoft Mercator, DataStage, FTP, COBOL
Data Warehouse Development
Oracle, DB2, Cobol, Teradata
Client Server Development
Oracle, C, Pro COBOL, MF COBOL, FTP
Mainframe Development
IBM COBOL, JCL, FTP, DB2, SQL, DMS 2200, RDMS 2200, Fortran, PLUS,
TIP Transactions, Mapper 2200, QLP, SQL
Experience:
Transtech LLC.
Client: Kraft Foods, 03/2005 – 11/2005
Senior ETL Consultant
·ETL consultant for large Trade System data warehouse on AIX Oracle to AIX UDB platforms
·Development of custom Oracle views and procedures, ETI*EXTRACT conversions and optimized UDB load routines for efficient data warehouse performance
·Daily Production Support with custom SQL coding and analysis
·Specialized site specific Data Verification SQL in Oracle and UDB to maintain data load verification and financial integrity
·Established and maintained strict project development and testing standards
·Win2K, UDB/DB2, AIX, SQ-C, SQL, Pro-C, Oracle 9i, ETI*Extract™, Perl, Unix Ksh scripts, CAS, WinSQL, Rational Suite
Tek Systems, Inc. 3/2003 - 12/2003
Client: Blue Cross Blue Shield of Texas
Business Analyst
·Initiated and lead core business unit requirement meetings.
·Lead Metadata creation, business user report analysis and reporting certification and data remediation.
·Proactively initiated, established and maintained open positive communications with all business units.
·Data certification testing of EDW (Enterprise Data Warehouse) conversion loads and ETL business rules. Entire environment and testing performed in Teradata SQL and Teradata Utilities on native Teradata platform.
·Data Warehouse requirements and warehouse enhancements based on core business unit production reporting and existing ad hoc sql queries.
Transdata Systems, Inc.
Data Migration Consulting 3/01 – 2002
Client: Cigna
Lead Conversion Specialist using ETI*EXTRACT
·Provided technical conversion design and solutions for staff of 15 conversion specialists in a team development environment
·Specifically responsible for conversion of all Release 2 claims processing data from legacy systems to DBII Data Warehouse. Data was transformed from inhouse legacy and third party vendor feeds to presorted flat files in DBII load format.
·ETI conversions were generated on NT platform and uploaded to IBM 3090 platform for compilation and execution
Frontline Systems Inc. 8/00 - 3/01
Client: U.S. Air Force
Senior Software Engineer
Provided data migration support using Ardent/Informix DataStage conversion tool in a MS SQL Server environment. Created all Business Object Universe(s) and Phase I Reports using Business Objects reporting tool.
·Transformations are from an MS-SQL transactional database to a MS-SQL data warehouse and several data marts. Client data warehouse built from legacy DOD and USAF data sources.
Daman Consulting, Inc.
Data Migration Consulting 5/00-7/00
Senior Consultant Staff Position
Client: Ford Motors, Dearborn, Michigan
Lead ETI*EXTRACT Master User
·Enhanced COBOL/FS DSL to allow custom error messaging and legacy data discovery on a large Marketing data warehouse project. Performed all DSL enhancements.
·Provided technical conversion design and solutions for staff of 11 conversion specialists in a team development environment on Legacy HP Unix and IBM390 platforms and Teradata target data warehouse platform.
Transdata Systems, Inc.
Data Migration Consulting 6/98 – 4/00
Client: State of California 9/99-4/00 Lead ETI*EXTRACT Mentor
·Designed, coded and implemented all local modifications of ETI*EXTRACT Tool Suite environment
·Designed, coded and implemented ETI EXTRACT conversions for converting data from IBM 3090 legacy systems to AIX Unix DBII Data Warehouse platform
·Designed and implemented conversion environment standards and all supporting documentation
·Provided onsite training of IBM and State of California employees to facilitate knowledge transfer in all aspects of conversion design, implementation, execution, testing, acceptance and enhancement of ETI EXTRACT Tool Suite.
Client: Pratt & Whitney 5/98 to 9/99 ETL Consultant Mentor and Master User
·Mentored IT staff employees in ETI*EXTRACT conversion design, documentation, implementation and execution for SAP Fixed Asset ,FI & Co Modules.
·Lead IT staff personnel in developing, tuning and implementing proprietary Conversion Methodology in a large scale SAP data conversion project worldwide.
·Member of data migration team tasked with mentoring and support of SAP and non Sap project teams on data migration roles & responsibilities, process and technology.
·Legacy systems were converted from IBM 3090 mainframe, unix systems worldwide, Access and Excel databases converted to a Sun Solaris E10000 SAP target.
·Identified, documented, prioritized, coded and implemented local enhancements to the ETI*EXTRACT Tool Suite, including development of a single-step (single program generation) IMS DSL for local use. Numerous template and grammar enhancements were required at this site.
·Established and maintained quality controls in all team contacts.
Logan/Britton, Inc.
Data Migration Consulting 3/96 - 6/98
Client: GTE, Irving, TX. 12/96 to 5/98 SAP Conversion Team Member
·Designed, coded, tested and implemented ETI*EXTRACT conversions and interfaces for SAP Fixed Asset Module handling over 5 million fixed assets.
·Designed, coded, tested and implemented all conversions and interfaces for fixed asset transfers, retirements and reverse retirements including custom analysis and balancing reports for a 28 billion dollar corporate entity .
·Provided data migration services for four IBM 3090 legacy installations with over 100 legacy systems and small legacy unix applications converting to a Sun Solaris SAP target system.
·Designed, coded, tested and implemented three ETI EXTRACT conversions for SAP Cost Module.
·Designed, coded, tested and implemented three ETI EXTRACT conversions for SAP FI Module.
Client: Fidelity Investments, Boston, MA. 8/96 to 12/96
ETI Master User and Conversion Team Member for DBII & Oracle Data Warehouse
·Designed, coded, tested and implemented conversions for DBII and Oracle data warehouses.
·Provided conversions from raw financial data tapes utilizing PRO C and PRO from raw financial data tapes utilizing PRO C and PRO COBOL to a Oracle HP Unix data warehouse. Duplicate load files were creating for loading into an IBM 3090 DBII data warehouse.
Client: American Express IDS/Financial, Minneapolis, MN. 6/96 to 8/96
Lead Master User
·Coded conversions, altered templates and provided support on the ETI*EXTRACT Toolset. Source was MVS, COBOL, DB/2, and flat files converted to a target Sybase data warehouse on an AIX unix platform.
Client:
Commercial Metals Corp., Seguin, TX.
4/96 to 6/96 Lead Master User
· Installed and maintained ETI*EXTRACT Tool Suite.
· Designed, coded and tested conversions from UNISYS 2200 flat files to a proprietary Oracle database on a Sun Solaris unix system.
·Designed, coded and altered templates and added special functionally to COBOL/FS DSL to make compliant in Unisys 2200 DMS 2200/COBOL and ECL environment
Education:
Education:
Southeastern Louisiana University B.S. – Computer Science 1984
·ETI EXTRACT Certified Master User
·RDMS Relational Programming
·Unisys Certified Mapper Coordinator & Internalist
Additional Information:
1993 to 1996
Staff Programmer CW Systems, Austin, TX.
· Responsible for all analysis and program coding for the conversion of TDHS Texas Department of Human Services) PRIME/DML (cash control system) and UNISYS 2200/DMS (SAVERR database) legacy systems to a UNIX/SYBASE target platform
· Programs were written using SPF/PC full screen editor in MicroFocus Cobol on each platform using its own native DML language. Produced work products using Word Perfect and Excel in a LAN Client/Server environment in accordance with Navigator methodology.
·Performed COBOL source conversions and wrote program specifications for programmers for the Texas Department of Human services Vendor Drug System converting data from sequentials file to a UNISYS 2200/900 RDMS relational database.
1991 to 1993
Staff Programmer MATCOM2, Inc., New Orleans, LA.
·Designed, coded, tested and implemented COBOL TIP DMS transactions for the enhancement of the Rework subsystem of the U.S. Navy’s Support Equipment Resource Management Information System (SERMIS)
·Provided general UNISYS product support for the SERMIS Rework subsystem used to allocate funds for equipment maintenance, establish maintenance capability, schedule depot maintenance resources, track the status of support equipment and record the completion of items overhauled or repaired.
1990 to 1991
DBA, SEMA, New Orleans, LA.
·Provided technical support for all UNISYS 1100 products.
·Maintained current operational database for the Naval Reserve Station. Including all TIP DMS 1100 transactions and all DMS areas and their integrity. Responsible for all DBA reorganization, schema support and physical database recovery.
1987 to 1990
Application Programmer
UNISYS Corp., San Antonio, TX.
·Designed, coded, tested and implemented new or existing software utilizing COBOL TIP transactions which interfaced with DMS and RDMS databases.
·Concurrently supported customers in QLP, IPF, IQU, MAPPER, SPERRYLINK, NITS, and general support of UNISYS 1100 products.
·Interfaced with end users and management to reach problem solutions.
1986 to 1987
Systems Programmer, UNISYS Corp., Unisys Benchmark Center, Eagan, MN.
·Benchmark responsibilities for the ACOE (Army Corp Of Engineers) Benchmark included 1100/2200 installation and support. Remote terminal emulation, UDS/Non-UDS environments and all aspects of booting and post-emulation analysis required for a country wide network.
1984 to 1986
Systems Programmer, System Development Corp.,
NASA, Slidell, LA.
·Mass Storage Analyst responsible for all system reboots and all file and database recovery including clean J13 boots.
·MAPPER Coordinator and system Administrator for Sperrylink System 4 Office Automation software package.
·Performed DOPS for Sperrylink System 2 to System 4 upgrade on Sperry 1100/62, 1100/72, 1100/82 and 1100/92 hardware.
·Provided support for NASA and Martin Marietta engineers in developing Fortran engineering applications.
Candidate Contact Information:
This candidate has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|