PROFESSIONAL SUMMARY:

Highly skilled, hands - on technology engineer possessing over a decade of professional experience in enterprises-class environment specializing in database architecture, development, implementation, optimization, and administration. Deep expertise with large and sophisticated Oracle OLTP & OLAP environments, complex PL/SQL programming, and troubleshooting/tuning of mission-critical systems. Strong software development background with fluency in numerous programming languages. Motivated team player with a leadership background and ability to provide tangible results on high visibility projects under demanding conditions

TECHNICAL EXPERTISE:

Oracle 10g, 11g, PL/SQL, MySQL 5+, Pentaho, Data Integrator, Factset, PGP Symantec, VBA, Toad, Tora, PL/SQL Developer, VBA, Recent Exposure to Crystal and Bobj, Java, JavaFx, Perl 5.8+, Python (2 & 3), Linux (Most distros), Shell, Bash

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Oracle Developer

Responsibilities:

• Design data archival strategies and calculate their impact on the operation of the database.
• Develop SQL coding standards, best practices, performance tuning guides, and standard database processes.
• Develop Crystal Reports and deploy to report server.
• Drive the selection of technology components for the database (e.g., backup software, storage management, etc.).
• Educate internal and external clients on proper documentation of all the database architecture.
• Mentor others in various database, application, and infrastructure areas that can affect performance.
• Develop and distributes best practices and standard documentation to other teams.

Confidential, Medford, MA

Oracle Developer

Responsibilities:

• Develop new proprietary business application to support strategic business processes using various technologies including Oracle PL/SQL, Oracle Stored Procedures, Java, JavaFx, VBA. Converts designs and specifications into computer code.
• Compile code into programs or components, tests and analyzes for errors and revises program as needed.
• Collaborates with Project Team to prototype, refine, test, and debug programs to meet needs.
• Write and maintain basic documentation to describe program development, logic, coding, testing, changes, and corrections.
• Receive and transmit data from 3rd party providers.
• Encrypt and decrypt as required. Analyze code to find causes of errors and revises programs.
• Tune queries for optimal performance.
• Migrate and automate frequently run forms, form letters, and reports into Crystal Reports.
• Train end users or technical support staff to use programs.
• Provide Tier 3 software issue analysis and resolution
• Maintain effective communication and relationships within project team members.
• Twice recognized person of the week
• Automated file transfer process, saving days of man hours
• Pioneered use of Linux tools to manipulate files with shell scripts

Confidential, Boston, MA

Oracle Developer & Technical Lead

Responsibilities:

• Created and manage ETL feeds between third party, data providers (Factset, BarraOne, etc.) and hosted Oracle environments.
• Leverage Perl, C#, SSIS, SSRS, T-SQL, Windows scheduler and other tools where applicable to accomplish tasks.
• Coordinate with hardware acquisition team for storage needs.
• Tune queries for optimal load, run times.
• Act as business analyst, working directly with product owner, in an Agile work-flow process, to gather requirements, give estimates, and accomplish tasks in a professional and timely manner.
• Created load to process risk analysis for 335k stock holdings (daily - $450 Billion)
• Automated jobs that were formerly performed by global staff
• Over communicated status of projects to keep stakeholders appraised
• Modeled dimension and fact tables to allow on-line data analysis

Confidential, Westborough, MA

Application Developer & Technical Lead / Oracle Developer

Responsibilities:

• Coordinate and synchronize account and usage data between power companies and energy resource database.
• Create ETL scripts, work and process flows.
• Database Development in Oracle using PL/SQL.
• Maintain legacy Perl loaders/ extracts
• Effectively translate business requirements, including rules and constraints into technical specifications and documentation.
• Apply experience with the Pentaho Data Integration ETL tool and provide technical support to other members of the team.
• Received SHAPE award for outstanding contribution.
• Database configuration via T-SQL and PL/SQL.
• Translate design requirements and implementation of stable end-to end solutions.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Produce and maintain proprietary marketing decision support system - a secure warehouse for marketing data, plus reporting tools.
• Develop Oracle procedures in PL/SQL on Oracle 10g
• Create technical documentation for procedures.
• Create reports using Business Objects, XCelcius, Flex, Crystal Reports
• Utilized object oriented design principles to increase report efficiency and create code library for shorter development times

Confidential, Renton, WA

Oracle Developer

Responsibilities:

• Maintain an integrated inventory / user interface database
• Produce clear, concise and well-documented designs and code for client-server and web-based systems.
• Database development in Oracle, using PL/SQL, JavaScript, HTML, Perl, Oracle Forms and other technologies.
• Strong Experience writing interfaces, triggers, stored procedures and PL/SQL.
• Communicate technical concepts to non-technical audiences, and gather functional system enhancement and upgrade requirements to be used in the technical design and development phases.
• Perform weekly audits of secondary database server to ensure data integrity in the event of fail-over.
• Manage tablespace to account for data growth.
• Analyze legacy systems to document and migrate to modern, stable platforms
• Build data warehouse to process client/website interaction

Confidential, Lexington, MA

Oracle Developer

Responsibilities:

• Build email lists for marketing campaigns
• Import client data files into Oracle databases.
• Database Development in Oracle using PL/SQL.
• Process large data files in a UNIX environment.
• Write scripts and procedures using SQL. Perform quality assurance checks.
• Update databases to ensure data integrity. Provide support to both clients and internal teams.
• Documentation of relevant information. Provide technical support and respond to error reports, problems or questions.
• Focus on database efficiencies, and end-user satisfaction.
• Recognized for completing projects on time or ahead of schedule

Confidential, Newton, MA

Technical Analyst

Responsibilities:

• Create and support software to place hospital patients in follow-on care facilities.
• Provide expert guidance and technical analysis in support of outstanding customer support ticket issues escalated.
• Manage the successful completion of projects owned by Customer Technical Support and communicate status to interested parties on a regular basis.
• Internal and External Customers' Technical and Senior Staff members.
• Automated data entry process with Perl
• Automated creation of monthly reports