Deborah A. Roy

Sr. Database Engineer

Phone: 603-***-****

Email: adye86@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/deborah-roy-88a39662/

Summary

I have extensive experience as a Senior Database Engineer in the Marketing and Financial Services Sectors. I am skilled in all aspects of the Software Development Life Cycle including: requirements analysis, data analysis, data mining, software design, software development; ETL development (DataStage, Informatica, Talend, Visual Studio and SQL Server Management Studio), software test, integration, maintenance, performance tuning, trouble-shooting and technical documentation.

Work Experience

Harvard Medical School, Boston, MA

Position: ETL\Database Developer 11/20 to Present

Summary: ETL\Database Developer responsible for the design, development, test and support of ETL\Database applications using Microsoft Visual Studio and SQL Server Management Studio and Oracle SQL Developer.

Responsibilities: Requirement’s analysis, data analysis, data mining, code design, code development, code test using Microsoft Visual Studio, Microsoft SQL Server Management Studio and Oracle SQL Developer.

Skills: Software Development using SQL Developer, Microsoft Visual Studio and SQL Server Management Studio, Oracle SQL Developer, GitHub, code development (PL SQL), requirements analysis, data analysis, data mining, code migration, code reviews, production support, troubles-shooting, performance tuning, source control

Data-Axle formerly Infogroup, Burlington, MA

Position: Senior Database Engineer 04/18 to 11/20

Summary: Sr. Database Engineer on Agile Scrum Team responsible for the design, development, test, and support of software applications that interface with large Data Warehouses and Data Marts in the Marketing Sector.

Responsibilities: Requirement’s analysis, data analysis, data mining, code design, code development in Oracle PL/SQL, code test, ETL development using Talend, shell scripting, code migration, code maintenance, scheduling, technical documentation and support of production systems including performance tuning and trouble-shooting run-time issues, estimating costs for code development and duration. I am a Scrum team member using Agile Methodology.

Skills: Unix, Linux, Oracle (12c) PL/SQL Development using Toad and SQL Developer, ETL development (Talend 6.3), shell scripting, requirements analysis, data analysis, data mining, code migration, code reviews, production support, troubles-shooting, performance tuning, source control, dimensional modeling, file transfer protocols, batch scheduling, Crontab, Agile Methodology (Jira, Scrum, Kanban) and Technical Documentation. Self-starter with excellent organization and communication skills.

Epsilon Data Management, Wakefield, MA

Position: Senior Database Engineer 02/13 to 04/18

Summary: Responsible for the design, development, test, and support of software applications that interface with large Data Warehouses and Data Marts in the Marketing Sector. Applications supported campaign management and reporting for Pharma clients.

Responsibilities: Requirement’s analysis, data analysis, data mining, code design, code development in Oracle PL/SQL, Java, C, C++, code test, ETL development using DataStage, code migration, maintenance, scheduling, technical documentation and support of production systems including performance tuning and trouble-shooting complex run-time issues.

Skills: Unix, Linux, Oracle (11.2) PL/SQL Development using Toad and SQL Developer, Netezza, scripting languages, ETL development (DataStage (8.1,9.2,11.5 and Adobe), Java, C, C++, XML, HTML, MS Word, MS Excel, requirements analysis, data analysis, data mining, code migration, code reviews, production support, troubles-shooting, performance tuning, source control (CVS and Team Foundation Server), dimensional modeling, file transfer protocols, batch scheduling with JCS, Crontab, software upgrades and migrations, SharePoint, and Technical Documentation. Self-starter with excellent organization and communication skills.

Fidelity Investments, Merrimack, NH

Position: Principal Database and ETL Developer 05/94 to 2/13

Summary: Designed and developed Oracle software components and applications that interfaced with large Data Warehouses and Data Marts in the Financial Services Sector. Applications included Brokerage Workstation, Payroll Compensation System and Holdings Hub Warehouse.

Responsibilities: Requirement’s analysis, data analysis, data mining, code design, code development, code test, ETL development using Informatica, code integration, maintenance and support of production systems including performance tuning and trouble-shooting complex run-time issues, technical documentation.

Skills: Strong analytical skillset, Unix, Linux, Oracle PL/SQL using Rapid SQL and DBArtisan, Netezza, scripting languages, ETL Development (Informatica PowerCenter), C, C++, Java, SAS, Visual Basic, JDBC, MS Word, Excel, requirements analysis, data analysis, code migration, code reviews, production support, trouble-shooting, performance tuning, source control, dimensional modeling, waterfall modeling, Agile Methodology, ClearCase, Autosys, Crontab, ControlM, Technical Documentation. Excellent organization and communication skills.

Citizenship: United States of America

Education:

University of Rhode Island, Kingston, RI, School of Electrical Engineering, Earned a Bachelor of Science Degree in Electrical Engineering.

University of Rhode Island, Kingston, RI, School of Pharmacy, Attended school of Pharmacy for 3 years prior to transferring to the School of Engineering.

Contact this candidate