SUMMARY

• To apply my diverse skills and experience to being an effective leader and team member in the area of Data Warehouse Data Architecture, Design and Development and Database Management
• Extensive experience in the IT industry with five years of experience as a Senior Confidential DBA.
• Contributor in the logical modeling sessions for many projects and converted the logical models to physical models.
• Design and implement backup and recovery strategies for Confidential databases
• Performed database tuning, making Confidential macros, triggers, BTEQs, and stored procedures more efficient, as well as end - user queries.
• Performance tuning on SQL for optimization of ETL processes and end-user queries.
• Coordinate Confidential Hardware and Software upgrades with the vendor engineers.
• Data Warehouse/Data Mart Design and Development using ERD, Star Schema, Snow Flake Schema
• Developed, tested and implemented ETL through SQL in BTEQ scripts as well as through ETL tools such as Informatica and Ab Initio.

TECHNICAL SKILLS

Databases: Confidential, Oracle, DB2, Sybase

OS: UNIX, Linux, MVS

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, Database Stored Procedures SAS, JCL, UNIX Shell Scripting, Perl, Database Stored Procedures, COBOL, CICS

Data Modeling: ERWin

ETL/BI: Ab Initio, INFORMATICA (development and administration)

Database: SQL Assistant, Viewpoint, Confidential Administrator, Confidential Manager, Netvault, Netbackup, Appliance Backup Utility, DBArtisan, TOAD, SQLPLUS

Confidential Utilities: BTEQ, FASTLOAD, MLOAD, TPUMP, TPT

PC: Word, Excel, MS Project, Visio, PowerPoint

Mainframe: TSO/ISPF, FILEAID, CA-7, Changeman

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Architect

Responsibilities:

• Principal Confidential DBA providing technical leadership in a brand new Confidential Installation
• Created entirely new Data Warehouse based on TD-HCLDM
• Data Mapping using Confidential Mapping Manager
• Logical Modeling using ERWIN
• Physical Modeling using ERWIN
• Data Standards
• Physical Implementation of all Database Objects including all User-ids, Roles, Databases, Tables, Views, Indexes
• Set up Archive and Backup Strategy
• Confidential Tools and Utilities, Viewpoint, Confidential Manager, SQL Assistant
• Worked closely with Management, BA’s and ETL Team Lead to ensure on time delivery of Release 1 of Data Warehouse. Currently doing the Data Modeling and Database design for Release 2.

Confidential

Solution Architect

Responsibilities:

• Support clients during upgrades and configurations.
• Solution Architect/Senior Pre-Sales consultant.
• Technical sales support.

Confidential

Senior Confidential DBA

Responsibilities:

• Senior Confidential DBA for the Data Warehouse Operations Team supporting the Data Warehouse.
• Very familiar with suite of Confidential Tools and Utilities.
• Design and implement backup and recovery strategies for Confidential databases
• Contributor in the logical modeling sessions for many projects and converted the logical models to physical models.
• Coordinate Confidential Hardware and Software upgrades with the vendor engineers.
• Ownership of resolving data issue bugs, by either delegating to junior team members or by coding and testing the solutions myself and following through by implementing into QA (CERT) and Production (PROD).
• Acted as liaison to Hotels group to give special attention to their bugs, issues and questions.
• Performed database tuning, making Confidential macros, triggers, BTEQs, and stored procedures more efficient, as well as end-user queries.
• Granted Permissions to users/groups. Create Databases, Accounts, Profiles, and Roles as part of the overall team strategy and standards.
• Designed and coded a process to reconcile System of Record bookings to Passport bookings for Air, Hotel, and Package.
• Performed and lead Design/Code Reviews and provided feedback where appropriate ensure best practices were followed.
• Performed CERT and PROD Implementations of Data Warehouse projects ensuring the quality of the processes being implemented.
• Informatica Administration which included driving the software upgrade projects as well as Informatica object deployments. Proficient in Repository Manager, Workflow Manager, Workflow Monitor, Administrator Console.
• Maintaining and developing ETL processes in a Confidential, UNIX and Mainframe environment which are part of the Demand Chain Management (DCM) application.
• Provided 24 hour on-call support of DCM application and ETL processes.
• Worked with DCM/ Confidential System Engineers to resolve and log issues with the DCM application.
• Developed, tested and implemented ETL SQL in BTEQ within UNIX Shell scripts.
• Performance tuning on SQL for optimization of ETL processes and data access from DCM.
• Designed, developed and implemented the disaster recovery process for the backup and recovery of the DCM database.
• Used SQL Assistant for data analysis and DBA tasks such as dropping/creating tables, indexes, granting access, data analysis, testing, and researching anything database related.
• Database Marketing List Programmer using Confidential SQL, SAS, and UNIX shell scripts.
• Created and modified BTEQ SQL scripts and SAS programs within UNIX shell scripts to create marketing list files for Confidential marketing campaigns.
• Verified and did QA on other programmers work before submitting files for distribution to vendor.
• Workload managed closely by reporting status of projects to Management and Marketing Liaisons on a daily basis.
• Used SQL Assistant for data analysis and DBA tasks such as dropping/creating tables, indexes, granting access, data analysis, testing, and researching anything database related.

Confidential

Systems Engineer

Responsibilities:

• Data Mart ETL Design, Development, Testing, and Implementation using Confidential, Ab Initio, Oracle, DB2 on UNIX platform.
• Coded data transformation and load processes with complex SQL within BTEQ as well as PL/SQL in Oracle. Also utilized FASTLOAD.
• Wrote UNIX Shell scripts to execute BTEQ, FASTLOAD utilities and Ab Initio DML. -Wrote Functional and Technical Design Documents while refining requirements from Business End-User Community.
• Kept thorough documentation of all work and projects. Supported Business End-User Community during UAT testing.
• Used SQL Assistant for data analysis and DBA tasks such as dropping/creating tables, indexes, granting access, data analysis, testing, and researching anything database related.

Confidential

Manager / Contributor

Responsibilities:

• Design and development of Campaign Management Data Marts (Oracle).
• Modeling, Design and Development of Cubes in Cognos.
• Design and development of Internet Originations Reports for eBusiness marketing.
• Group (SAS/DB2/SQL).
• Automate reporting processes for team (CA7)
• Teach new hires and junior team members mainframe skills.
• With Team, developed strategy to migrate business logic from front-end client to the back-end mainframe, a plan to make the front-end systems a thin client.
• Supported the Data Access Projects slated for the system release delivery that included back-end data retrieval and update programs invoked by the front-end systems through.
• MQ Series, Sybase Stored Procedures, and UNIX Scripts. Work projects through all phases of project life cycle. Wrote Functional, Technical Specs and Test Plans, code, test, and implement projects.
• Researched production incidents to develop the most architecturally-sound, long-term solutions.
• Worked closely with Sybase DBA's in making modifications to or creating Sybase Objects.
• Technical Team Lead in designing the Enterprise Data Warehouse (EDW) for Household Credit Card Services and Household Auto Finance.
• Consulted in Data Modeling (Logical & Physical) and Data Mapping Sessions.
• Developed Project Plan for Design, Development and Test Phases of project.
• DASD estimates for project.
• Evaluated ETL tools.
• Worked closely with End-Users to resolve design issues.
• Worked closely with DB2 DBA and Logical Modeler to resolve design issues.
• Worked closely with Global EDW team to ensure that the design was in accordance with standards and served the best interest of the End-Users.