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, ETL, complex query optimization, SQL, PL/SQL, PostgreSQL, 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, pgAdmin, ERWin, ClearCase, IBConsole

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Assistant Vice President

Responsibilities:

• Contributed to the technical review and design of one vertical data exchange in support of the Recovery and Resolution Planning (RRP) platform.
• RRP system consisted of three (3) major components, Enterprise Reference Platform (ERP), Enterprise Serving Platform (ESP) and Master Data Management Hub (MDM).
• These platforms worked together to provide a comprehensive set of features to support RRP
• Developed data controls using the Operational Control Framework within the corporate Enterprise Servicing Platform.
• Assignment established a methodology to develop, test and deploy the numerous checks.
• Naming standards were defined to quickly identify and inventory the controls for the various source providers.

Confidential, Smithfield, RI

Sr. Software Engineer

Responsibilities:

• Contributed to the technical design and programming model for the corporate campaign initiative within the Personal Investment data warehouse.
• Assignment calculated the lift measurements for defined metrics sourced from Oracle data marts to Oracle Confidential stores that sourced a Greenplum analytical database.
• Greenplum database functions developed in PostgreSQL.

Confidential, Smithfield, RI

Sr. Software Engineer

Responsibilities:

• Designed and developed framework to code-generate Oracle PL/SQL package specifications and bodies for each Confidential 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 of the PL/SQL anonymous blocks.
• Served as one of two lead developers during the data warehouse architecture review meetings.

Confidential, Smithfield, RI

Sr. Software Engineer

Responsibilities:

• 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 Confidential configurations for user flexibility when declaring thresholds at various levels, i.e. account and product. Use of Confidential 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 . Confidential was used to build and BULK COLLECT INTO used to house the hierarchy temporarily for improved performance. Use of Confidential were implemented to drive the ever changing data requirements. This greatly facilitated the QA activities

Confidential, Providence, RI

Database Engineer

Responsibilities:

• Authored Database Standards reference for Confidential 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.

Confidential, Smithfield, RI

Sr. Software Engineer

Responsibilities:

• 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 Confidential . Embedded SQL in korn scripts referenced Confidential in the model to facilitate ad-hoc metric shifts.
• Re-engineered standalone PL/SQL anonymous blocks to Oracle PL/SQL 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) */).

Confidential, Smithfield, RI

Sr. Software Engineer

Responsibilities:

• 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.

Confidential, Boston, MA

Assistant Vice President

Responsibilities:

• 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 Confidential 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 Confidential, 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.
• 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.