Tracey Templin
Blackstock SC 29014
(803) 899 - 2179
Preferred contact method: *******.****@*****.***
Specific Qualifications
I have over 20 years of industry experience which includes C/C++, Javascript, HTML, Microsoft SQL server, ,Sybase, SSIS and Unix scripting, Stored Procedures, T-SQL, DML, DCL, DDL. I am experienced with Cobol and JCL. I can easily fill gaps in any development team.
Experience
01/2011-02/2011 Wells Fargo– TA/QA wholesale, Charlotte, NC
Title: Short term QA/TA assignment for INTL RFX trading
SQLServer, extract, transform and load tables for testing. Testing with QualityCenter(10),Some SQL coding
07/2010-11/2010 Wells Fargo– Retirement, Charlotte, NC
Title: Sybase architect
Optimizing and updating back end Sybase queries and stored procedures.
Converted a predefined test DB environment to a workable DB environment. This new environment was for testing possible optimization changes
Used SQL server utilities to extract data from “old” table to “new” test tables and used heavy Stored Procedure/SQL coding
Optimizing long running queries and stored procedures. Testing and verifying optimization changes
12/2009–05/2010 Bank of America - GRiTT, Charlotte, NC
Title: Level 2 Lead Production Support Analyst
(For the Corporate Investment Technology)
Provide 24/7 level 2 support for all systems that interacted with Middle and Back Office systems.
Anticipate issues before they happen.
Analyze problems and develop solutions in a fast paced trading world
Contact appropriate internal and external partners to speed resolutions
Set up and maintained Autosys and a few Informatica jobs
Created and used access, excel spread sheets, and some SSIS to create reports on the SQLServer
09/2007–08/2009 Wells/Wachovia – CIBT Charlotte, NC
Title: Level 2 Lead Production Support Analyst
(For the Fixed Income Trading System)
Provide 24/7 level 2 support for all systems that interacted with Middle and Back Office systems.
Anticipate issues before they happen; Monitor trading platform in high pressure environment;
Analyze problems and develop solutions in a fast paced trading worlduse Some C# coding to obtain this.
Contact appropriate internal and external partners to speed resolutions.
Set up and maintained Autosys jobs
Created and used access, excel spread sheets, and some SSIS to create reports on the SQLServer
Shared Success Award: Teamwork for Shared Success – June 2008, August 2008
06/2007–09/2007 BCBS-SC, Columbia, SC
Title: Senior Level 1 Production Support Engineer for Claims applications
Analyzed problems and deriving solutions in a fast paced Claims world
Contacted appropriate internal and external partners to speed resolutions
09/1996-04/2006 DaimlerChrysler - Chrysler Group, Auburn Hills, MI
Title: Project Lead (Leading and mentoring up to 5 team members)
Developed and Maintained the Chrysler Parts Quality and Supply System, which is a mission critical system used to track supplier quality throughout the manufacturing process. (errors and down time could cause plants to close, costing the company millions)
Performed 24/7/365 production support for the system
Carried out peer reviews of technical design documents. Reviewed new designs and code developed by the team
COBOL/DB2 programs were used with complex SQL’s to retrieve the m/f data needed to support client server system.
Used EDI with Sybase and DB2 to extract, transform and load data.
WCM processing. Web Screens were used for outside supplier input. HTTP was used to create the screens. Embedded SQL (TSQL) did the updates.
Tracked trouble tickets to make sure that the problems was fixed and the tickets closed
Provided many enhancements for the car platform teams in terms of suggesting and implementing new processes to improve their work flow
Recognition of Excellence: Director and VP Award - May 2005
Bravo Award for improving the integrity and reliability of the PPAPing data - June 1999
See technical skills for an idea of the technology I have used.
01/1995–09/1996 Ford Motor Company, Dearborn, MI
Title: Senior Programmer Analyst (WWERS).
Maintaining online part releasing system. Coding and debugging programs needed to support this system to make sure the parts were released on time using
See technical skills for an idea of the technology I have used.
01/1986-01/1995 AAA – Michigan, Dearborn, MI
Title: Programmer Analyst
Maintained both the salary payroll system and the commission payroll system
Education
University of Michigan – Dearborn, MI 1985
Bachelor of Science, Computer Information Sciences
Technical Skills
Very experienced in relational tables such as SQL Server(2000 thru 2008), Sybase (10.3 – 15.0), MySQL, Oracle(9/10g), T-SQL, DML, DCL, DDL,SSIS, ETL, XML
Multiple version control software. (Used for project version control and release control management)
VI, Shell/Korn Unix scripting, Stored Procedures, JavaScript, QC(10), C, C++, Access/Excel
Experienced programmer/analyst, QA tester, and Technical analyst
Wrote and monitored Unix scripts that controlled: TSQL and complex relational tables
Developed production batch run cycle. Used a home grown UNIX batch scheduler to run and monitor daily, weekly and monthly production batch runs.
Measured, identified, analyzed and tested the application using home grown testing system
Developed JavaScript jar files during application Integration and deployment of the bi-directional interface with the outside companies using MQSeries and XML files.
Moved the application to newer UNIX boxes three times with only technical support help. Set up the performance-testing environment.
Performed load monitoring and balancing testing, with the DBA group.
Trained by the top DBA at Chrysler to create effective and efficient SQL’s, to create the best possible unique cluster index on tables, based on how the data was to be used, and to create as many secondary indexes as needed to meet system and user needs.
Utilized advanced SQL to produce files that were sent to the Unix environment to become either input that was manipulated in Sybase stored procedures or databases used in the data warehouse.
Application DBA for 8 years (all new tables or changes to existing tables had to be approved by me before they could go to the DBA group for processing.)
Designed, developed and tuned Sybase tables. Developed applications that communicate with Sybase tables. Monitored Sybase job from SQL Also used raw SQL to create SQL code.
Designed, developed and tuned Sybase tables. Developed applications that communicate with Sybase tables. Monitored Sybase job from SQL Also used raw SQL to create SQL code.
Performed inquiry, updates and deletions from Sybase databases in an effective manner.
Developed and Maintained over 200 Sybase Stored Procedures and SQL’s used as the nightly batch processing of the mainframe data used to update and synchronized the Client server applications Sybase tables
Senior technical resource for the C/C++programs used to create an application that debugged and created the fixes for the production C/C++programs. Made major enhancements involving C, Entera and PowerBuilder
Moved business logic out of the PowerBuilder (GUI) application into the C/C++ code.
Developed batch JavaScript programs during application integration and deployment of the bi-directional interface with an outside company using MQSeries and XML messages, to receive XML messages that could be receipts or transactions that needed to be used to update our system.
Developed the Software Configuration Management (SCM) planning and control usage, using PVCS for the JavaScript that interfaced to the outside company.
Senior technical resource for the C/C++ programs used to create an application that debugged and created the fixes for the production C /C++ programs.
Used C/C++ compilers for all PowerBuilder logic based work. Set up change controls to deploy the PowerBuilder application to 150 servers, manually all over the world, every six weeks using a windows batch script.