We provide IT Staff Augmentation Services!

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

Hire Now