Senior PostgeSQL Developer & Architect Resume

SUMMARY:

Skilled technical lead able to mentor team members with strong agile development practices
Experienced in design and development of enterprise applications with a focus in Big Data, analytics, and data warehousing (DW)
Experienced using SQL for government and corporate applications and databases
Experienced in architecting highly complex databases using Erwin data modeler

TECHNICAL SKILLS:

Languages: C#, VB.NET, Python, Silverlight, C++, COM+, XML, XSL, JavaScript, Java J2EE, PL/SQL

Databases: GreenPlum, PostgreSQL, SQL Server, Oracle, MS Access

Tools: Hadoop, MapReduce, Hue, Sqoop, Hive, Altova XML Spy, pgAdmin, MS Visual Studio, SSIS, SSRS, SAS EBI, TOra, TOAD, Eclipse, TestDriven.Net, Crystal Report, InstallShield, Wise, Erwin

OS: Windows, Mac OS, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Senior PostgeSQL Developer & Architect

Responsibilities:

Designed and developed Data Warehouse (DW) on Greenplum PostgreSQL database for IRS Return Review Program (RRP) for analytical functions to predict and identify income fraud and withholding discrepancies
Migrated legacy application on Oracle database to a new Greenplum PostgreSQL database
Improved application performance by merging OLTP and DW operations while optimizing Greenplum PostgreSQL database queries and improving the table - partitioning strategy
Mentored developers on proper SQL scripting for PostgreSQL development and troubleshooting

Confidential

Senior Software Engineer & Architect

Responsibilities:

Created an application using Greenplum MPP that analyzes real-time trading data from multiple complex sources
Optimized application performance by translating SAS code into SQL queries using PostgreSQL
Implemented fraud detection models for the Wash Trade and Front Running schemes, utilizing SAS Enterprise Guide and Greenplum PostgreSQL
Expedited the processing of the CTFC financial Data Exchange Program via a unique mapping solution that reduced render times from months to days, later adopted by other agency groups
Improved system reporting services by creating a custom Graphical Query Builder for file metadata used for business analysis
Helped CFTC surveillance to improve data standards and algorithms for future CFTC exchanges

Confidential

Senior Software Development Analyst

Responsibilities:

Created an automation triage module within the Accessible Interoperable Military's Electronic Health Record System (AHLTA) using C#, SQL Server, and Oracle Database
Improved application and patient security by designing a new asymmetric encryption based on the RCA crypto library
Designed and developed multiple high complex database objects for OLTP using Oracle, Erwin Data Modeler, and SQL
Successfully resolved complex issues related to the Common Access Card module used by military service members to get medical treatment

Confidential

Software Engineer

Responsibilities:

Developed an access management tool using a proprietary encryption protocol that was incorporated into a custom instant messaging app
Built a responsive web-reporting tool utilizing JavaScript, XML, XSL, COM+, C++ and VB 6

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship