SUMMARY:

• A hands - on database developer who consistently delivers on high visibility projects.
• AWS Certified Solution Architect - Associate
• Strong Oracle Architect skills. Specializes in advanced database design and tuning. Worked in all phases of project life cycle and functioned as Lead Application Designer and Database Architect.
• Agile Methodology developer. Comfortable working on multiple projects simultaneously.
• MS degree in Applied Mathematics and Cybernetics with over 20 years of professional experience in IT, specializing in the implementation of Oracle technologies within the communication, financial, government, and marketing/CRM services sectors.

SKILLS:

• Oracle Database (7 to 12), SQL, PL/SQL
• Thinking and dreaming in terms of code
• ElasticSearch, Logstash, Kibana, Filebeat
• Analytical mind
• Shell scripting, Ruby, Python, Perl
• Converting clients’ needs into code
• Oracle DB, PL/SQL, MySQL
• Thinking and dreaming in terms of code
• Docker, ElasticSearch, Logstash, Kibana
• Analytical mind
• Linux, Shell scripting, Ruby, Python
• Converting clients’ needs into code

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, MA

Principal Software Engineer

Responsibilities:

• Member of the Pure Engage Cloud Outbound Engineering database team.
• Implemented new database features, tuned SQL performance, diagnosed and solved Production issues with customer relations team.
• Implemented multiple highly complex reports for clients, including for a $100B revenue company who is sending 1+ million messages daily.
• Delivered financial data feed to the internal billing department.
• Improved and kept up to date the existing roll up process, which aggregates all billable data and delivers the output to the internal billing system.
• This critical data flow is the basis for all customers’ bills and company’s revenue.
• Resolved billing issues for the customer support team.
• Implemented data conversion and ETL code for acquired companies’ information.
• Worked with the data owners to make the exchange format. Staged, verified and imported new data.

Tools: Oracle SQL Loader, Oracle external tables, shell scripts, PL/SQL.

Confidential

Responsibilities:

• Envisioned, created and maintained several Confidential for customer support and developers.
• Created PROD Confidential to monitor the status of the vital Production processes for dozens of Confidential clients (account activity, message sending rate, agents’ availability, voice call quality, incidents).
• Deployed PROD Confidential to the wall mounted TV units around the office and made them available for the users on LAN.
• These Confidential allowed customer relations team to be much more proactive, which greatly increased clients’ satisfaction.
• Created DEV Confidential to help our development team to be on top of Agile development progress (Agile metrics, Sprint progress, number of Jira tickets per status, outstanding code reviews, code base builds’ statistics).

Tools: MySQL, Ruby on Rails, HTML, CSS, Javascript, JSON, REST API calls to Jira/Jenkins/Bamboo, shell scripts, dashing.io application.

Confidential

Responsibilities:

• Added data analysis and visualization of clients’ data using Confidential stack to the internal tool set.
• Aggregated log info (files and Oracle log tables) from all QA databases into one Confidential instance for easier access during testing.

Tools: Confidential (Logstash, ElasticSearch, Kibana), Filebeat, shell scripts, SQL, Docker, CentOS.

Confidential, Boston, MA

Principal ETL Developer

Responsibilities:

• Designed and developed a new database for Draeger data load, including data structures, transformation and load code.

Confidential, Merrimack, NH

Principal Software Engineer

Responsibilities:

• Delivered various code enhancements to PROD systems as a part of Tactical Developer responsibilities, including Oracle stored procedures, ETL code, and Perl and shell scripts.
• Designed and developed several metadata sub-systems: Quantitative Management Reports loader, and Data Quality Monitoring System with quality reports.
• Created universal Netezza Pivoting code to help quantitative analysts in their analysis.
• Led data analysis, modeling, and solution design and development of Lockup Engine: a complex rules engine for dynamic recalculation of clients’ requirement levels in Term Agreement context.
• Performed migration of Risk Workstation to Exadata hardware, including setting up of Control-M batch cycles, Oracle databases, and Reporting tools.
• Converted more than 30 legacy reports to Business Objects, created new reports to replace the old ones.

Confidential

Responsibilities:

• Designed and built the Confidential: a comprehensive IT reporting tool that provided summaries and detailed project budget information, including multiple custom reports and analytics tools.
• Led all project lifecycle phases from requirement gathering to production support.

Confidential

Responsibilities:

• Designed and developed Confidential Scheduler.
• Created Confidential daily performance reporting. Designed and implemented Confidential Purge System to delete millions of expired messages per hour from the OLTP database with hundreds of millions of rows.
• Improved billing practices by creating budget management tool to compare budget to billed hours.

Confidential, Weymouth, MA

Senior Oracle Developer/Architect

Responsibilities:

• Developed the marketing database for Confidential ’N’Gear from start to finish, including initial design, data load, ETL, weekly update process, aggregations, reporting, and documentation.

Confidential, Lincoln, MA

Senior Oracle Developer/Architect

Responsibilities:

• Created universal process management system which controls all parts of periodic database update cycle.
• Developed Response Engine - set PL/SQL packages for customers’ response calculation.
• Developed data extract, transformation and load (ETL) layer - tens of millions of records per process.
• Performed data cleansing and match/merge using FirstLogic PostalSoft tools and custom Perl scripts.
• Created and optimized shell scripts, batch files, and scheduling OS and Oracle jobs.