JEFFREY A. TIBBETTS

acvtde@r.postjobfree.com

401-***-****

SUMMARY:

Successful application developer with strong development experience in various capacities.

Extensive Oracle development experience including PL/SQL development, implementation and maintenance

ETL design and development

Lead small teams through the development life cycle in addition to being key member (developer) on numerous goal oriented teams.

Proven results achieved by being prepared, organized and expressed willingness to be accountable.

Strong relational database experience including; logical and dimensional data modeling, physical database design

Demonstrated effectiveness at developing, presenting and representing system architecture for business and vendor stakeholders for SOW initiatives

Strong advocate for programming standards and guidelines to promote better strategies and practices for developing and coding solutions

Exceptional leadership skills, teamwork skills and interpersonal skills

TECHNICAL SKILLS:

Primary Skills:

Oracle 11g/12c database design and development, complex query optimization, SQL, PL/SQL, scripting (Perl, csh, ksh, Bourne, SQLLoader, Windows CMD)

Secondary Skills:

AutoSys, Control-M

Operating System: UNIX, Linux, Windows

Other Tools:

Git, SQLPlus, PL/SQL Developer, SQL Developer, Rapid SQL, Toad, ERWin, ClearCase, IBConsole

Familiar with:

Agile Methodology, Database Design and Performance Tuning, ERWin, SQL Server, Ingres, InterBase, Informatica, Java, Weblogic, SSL

Broad Areas of Expertise: Vendor Management, Off-Shore Team Management

EXPERIENCE

Fidelity Investments/Veritude LLC 02/15 - 04/16

Smithfield, RI

Sr. Software Engineer, Corporate Technology Group

•Designed and developed framework to code-generate package specifications and bodies for each metadata APIs. Each API served as a wrapper to isolate users from the database structures and data validation rules.

Refactored report queries for the IBI to OBI data warehouse report migration. Developed SQL scripts to support data controls for this project. Scripts accepted input parameters that provided a simple yet flexible on demand execution.

Served as lead developer during the data warehouse architecture review meetings.

Fidelity Investments/Eliassen Group, Inc. 01/14 - 01/15

Smithfield, RI

Sr. Software Engineer, Corporate Technology Group

Developed process to code generated DDL and DML scripts to support the Python based Data Control Project.

Performed full SDLC for the mark-to-market alert model identifying post trade anomalies against predefined thresholds. The model was incorporated into the vendor product Actimize, to defined data channels and batch workflows. Design featured metadata configurations for user flexibility when declaring thresholds at various levels, i.e. account and product. Use of metadata provided a platform to build test cases dynamically and efficiently. Code was modularized and encapsulated in one (1) Oracle PL/SQL package.

Designed and developed database objects for the Aged Alert Notification process to report Actimize alerts that exceeded the predefined time required for each alert to reach CLOSED status. One (1) Oracle PL/SQL package housed all the back-end code for this process. This approach was taken not only for good code management and deployment but it provided a layer of security (public vs. private modules) and improved performance. The UTL_SMTP utility was used to send email notifications. The corporate who s who data was referenced to create a temporary hierarchy to determine email recipients. UTL_SMTP was the utility used to send email notifications . CONNECT BY PRIOR was used to build and BULK COLLECT INTO used to house the hierarchy temporarily for improved performance. Use of METADATA were implemented to drive the ever changing data requirements. This greatly facilitated the QA activities

.

SMART Management Inc., Providence, RI 10/13 - 01/14

Providence, RI

Database Engineer, Technology Group

Authored Database Standards reference for Smart Management IT development team. Reference encompassed five main areas, database design best practices, naming conventions, normalization, data integrity and stored procedures. Document complemented Smart's existing documentation library.

Presented an improved database user management methodology. Approach identified and classified major security vulnerabilities and outlined a plan of action to eliminate each threat. The design centralized user management to the database.

Fidelity Investments/Edge Solutions Inc. 07/13 -12/13

Smithfield, RI

Sr. Software Engineer, Workplace Investment Technology Group

Contributed to the technical design and programming model for the corporate campaign initiative within the Personal and Workplace Investment data warehouse. Assignment calculated the lift measurements for defined metrics housed in Oracle EXADATA. METADATA were incorporated in the model to facilitate ad-hoc metric shifts.

Re-engineered standalone PL/SQL anonymous blocks to Oracle package procedures and functions. Code management was greatly improved allowing for code centralization and reuse. An added benefit from this refactoring was an increase in performance with the use of 11g analytic functions (MODEL functionality and OVER PARTITION BY), parallel processing (PARALLEL (degree 32)) and hints parallel(t,2)

Fidelity Investments/Veritude LLC 10/12 - 07/13

Smithfield, RI

Sr. Software Engineer, Corporate Technology Group

Designed, developed and implemented request components within the ECM Email application. PL/SQL using Oracle user-defined data types was the foundation of the programming model. Strict programming guidelines and naming conventions facilitated the ease of cross support teams and activities. Assignment provided real exposure to Agile Methodology.

Designed, developed and implemented auto generated test case scripts to emulate UI data input to facilitate QA efforts. Time consuming data entry was virtually eliminated and throughput of test results was dramatically improved.

Assignment introduced me to the Oracle s approach to object-oriented development.

STATE STREET CORPORATION 06/00 - 10/12

Boston, MA

Assistant Vice President, Corporate Systems & Operations

Support and integration system/analyst for enterprise risk vendor platform IBM OpenPages. IBM OpenPages is the leading provider of integrated risk management solutions for global companies. Major initiative commencing in 2010 Q3 involved closing vendor software security leaks, performing major software upgrades, procuring and deploying six (6) separate environments.

Successful collaboration with various teams within State Street provided a challenge yet rewarding experience. Parallel to these activities, coordination, planning and delivery culminated a successful disaster recovery (DR) exercise.

Development lead for the Basel II Technology. Basel II is an international business standard to ensure any large company that deals in money has enough cash at hand to cover all the risks it faces. Assignments involved design, development, deployment and support activities for Basel II Master Data Management application. Siperian MDM Hub software manages this MDM platform.

Designed, developed, tested and implemented (full SDLC) an internal support application using dynamic SQL. The application provided the control to dynamically activate/deactivate data validations without code modifications. Table metadata, view declarations and dynamic SQL were the cornerstones of the design. The design was such that business rules and validations could be activated (or deactivated) independently of another...There was no application downtime when a data validation or business rule was not performing correctly. Only that validation or rule was taken out of service. Release management efficiencies were gained with this design approach. All DDLs captured and recorded using ERWin for logical and physical presentations.

Lead internal application/database developer for Treasury International Capital (TIC) system. System collects, scrubs and produces mandated filings for the US Treasury Department, (see http://www.treas.gov/tic/). The application components being IBM WebSphere, Oracle DBMS, and Oracle PL/SQL packages/procedures/functions. All delivery milestones were met causing a significant improvement in State Streets’ Federal Government’s rating.

Senior application/database developer for Corporate Marketing intranet website. Website manages all internal product information. The web components being Oracle DBMS, Oracle WebDB and Oracle PL/SQL packages/procedures/triggers.

Addressed data integrity concerns with the implementation database constraints, (primary key/foreign keys), versus existing programming methodology.

Maintained pre-existing Oracle PL/SQL package that housed application software. Additional packages were designed and implemented to modularize the software.

Partnered with third-party vendor, Interwoven, to interface their content management product, TeamSite with website. Designed and implemented Perl scripts to process content in and out of the Oracle database. Oracle triggers were used to insulate vendor software from production tables.

Designed and implemented a full cycle refresh process using Oracle PL/SQL package. Process provided the mechanism to push/pull data to/from the TeamSite data repository. XML was the data exchange format used.

Designed and implemented process using Oracle PL/SQL package to extract data into XML format used to prototype Lotus Notes Workflow capabilities.

Converted Oracle WebDB intranet website to MacroMedia ColdFusion. Conversion was intermediary step in the migration path to IBM WebSphere.

2006 Q2 Corporate Systems & Operations Extra Mile Award winner

PUTNAM INVESTMENTS 11/96 - 05/00

Braintree, MA

Sr. Systems Consultant - Management Information Systems

Designed and implemented the packages, procedures and functions of the intra-day accounting data refresh process for the highly visible Appraisal Management System (AMS).

Process controls and data integrity were vital. AMS submits to external EDP audits.

Re-engineered nightly security trade and position feed system that supports Client Service Workstation, (CSW) for institutional base client portfolios using Oracle PL/SQL programming language and stored procedures. Packages are being developed to standardize and modularize the software.

Actively participated and contributed to internal PL/SQL Programming Standards and Procedures to emphasize quality and assurance of all developed software. Promoted discussions surrounding programming techniques to stimulate new ideas and to reinforce the benefits of well-structured software.

Designed and implemented UNIX scripts (Bourne shell) to facilitate the development and testing of software.

1998Q2 Outstanding Employee Award (OEA) nominee

Batterymarch Financial Management/Eliassen Group, Inc. 01/96 - 09/96

Boston, MA

Application Database Consultant - Information Technology Group

Lead Consultant at Batterymarch Financial Management in Boston, MA.

Upgraded their existing character based Global Portfolio System (GPS1.0) to the current client/server GPS3.x version. GPS is a trademark of the DST Belvedere company.

Converted CA-INGRES data to a Sybase SQL Server database. UNIX shell scripts, (Bourne and C), using embedded SQL and database stored procedures were developed to facilitate the migration process.

Implemented several front-end menu applications and developed a series of system routines to support the conversion process.

Maintained vendor supplied application programming interface (API) Tcl scripts.

State Street Research & Management 01/93 - 01/96

Boston, MA

Senior Developer/Analyst - IT Development

Participated in the conversion of their in-house HP/COBOL financial application to the DST Belvedere Sun/SQL Global Portfolio System. The GPS software is a client/server architecture.

Responsibilities involved design, development and implementation of the reporting component of the CA-OPENROAD based front-end user application. UNIX shell scripts using embedded SQL, CA-INGRES/Windows4GL, CA-INGRES/ReportWriter and database stored procedures were used to implement the reporting process. All new reports have been developed on MS-Access.

Robin Systems Corporation 11/91 - 01/93

Waltham, MA

CA-INGRES Software Consultant

Involved with software consulting group to develop mission-critical character-based business application for a CA-INGRES Home Infusion Therapy client.

Directly responsible for programming the Pharmacy formulation and dispensal software in a distributed Ultrix environment.

Contributed in the development and implementation of the application programming model.

ALDRICH, EASTMAN & WALTCH, L.P. 02/86 - 11/91

Boston, MA

Information Specialist - Information Systems

Responsible for the technical integrity of the development and maintenance of all DEC/VMS character-based application software.

Presented, developed and maintained AEW's programming guidelines. Major accomplishments include:

Appointed to panel to research and select a relational database model and 4GL to meet the company's dynamic business needs.

Instrumental in the early design of the CA-INGRES prototype application - Corporate database.

Acted as lead technical advisor to outside consultant firm, Coopers & Lybrand (C&L).

Communicated and reviewed AEW development standards with C&L to emphasize the importance of data and screen presentation. Created, populated and maintained all data points requested by C&L.

Upgraded firm's investment performance application software with record and file locking features. Greater batch processing throughout was achieved.

Restructured and documented existing/new logic to conform to the AEW programming standards.

Screen inconsistencies were addressed and corrected. The Performance System was released into production before the scheduled target data. Modular program construct was recognized as the standard to which new application design would adhere.

EDUCATION:

Merrimack College, North Andover, MA

BSBA Major: Accounting

Contact this candidate