Experience

• 

  Curantis Solutions

  • Addison, Texas

  • Application DBA

    • Feb 2019 - Present
    • Addison, Texas

• 

  Epsilon

  • Advertising Services
  • 700 & Above Employee

  • Senior Business Systems Analyst

    • Apr 2017 - Feb 2019

    Acts as the key liaison between the client and the technical delivery teams. Provides first level support for project related production issues.- Analyzes complex business problems to be solved with automated systems- Provides technical expertise in identifying, evaluating and developing systems and procedures that are cost effective and meet user requirements- Actively researches and identifies database related issues and provides SQL solutions- Plans and executes unit, integration and acceptance testing; and creates specifications for systems to meet business requirements- Provides details to developers regarding what should be included in the product to ensure it is included for client roll-out/implementation- Interfaces with the client and EPSILON technology delivery teams, supporting the design and delivery of marketing database solutions - Works with cross-functional linked teams to address business or systems issues- Leads requirements gathering sessions via client interviews - Takes ownership of all written documentation (own and others) including requirements, functional specifications, test plans and go-live manuals - Works with and supports technical staff in the design, development and testing of the solution - Supports production staff & client end users in the use of designed solution

  • Senior Database Developer

    • Aug 2015 - Mar 2017

    - Designed and implemented an ETL and database solution using Amazon Web Services - Completed several high-profile projects accurately always meeting the deadlines- Worked to keep runtime of ETL and Redshift pipelines to a minimum through redesign; used compression to minimize the use of disk space thereby reducing the size of a cluster resulting in cost savings of over $1,000 per month- Established database management systems, standards, guidelines, and quality assurance for database deliverables, such as external data interface specification, data loading plan, data maintenance plan and security policy- Documented, evaluated and communicated database design- Coded complex programs and derived logical processes on technical platforms- Determined appropriateness of data for storage and optimum storage organization- Determined how tables relate to each other and how fields interact within the tables for a relational model- Developed and executed unit test cases- Analyzed and gathered requirements through interaction with external and internal resources

  • Database Analyst/Database Developer 2

    • Apr 2013 - Jul 2015

    - Performed data exploration, profiling, and modeling as a means to plan and QC report development- Created, maintained and executed robust marketing analysis reports utilizing SQL, Excel, proprietary and third party reporting tools; deployed these reports via a web-based managed reporting interface- Executed extensive data auditing and data troubleshooting- Supported production systems- Provided documentation of report criteria and metrics- Performed other activities to support the Oracle database environment including data loads, refreshes, and data extraction

• 

  Automated & Management Solutions, LLC

  • Database Developer

    • Apr 2008 - Apr 2013

    Utilized System Development Life Cycle (SDLC) processes in development of premium insurance related projects. Worked on complex programming projects for several large clients with minimal supervision while providing guidance and assistance to fellow developers. - Developed T-SQL Server procedures and views to support complex automated and batch processing, modified triggers using T-SQL according to the project requirements- Responsible for developing, testing and implementing upgrades to existing procedures to meet changing organizational and customer needs, to improve quality, scalability, performance- Performed SQL Server administrative tasks to ensure data integrity as well as daily system verification and monitoring to validate database status and availability- Involved in the technical, system and user level documentation- Responsible for reporting, tracking and fixing defects- Packaged and deployed upgrades to clients’ test and production environments - Scheduled batch jobs in Production, Development, Testing and QA Environments and provided day-to-day support. Responsible for modifying existing Power Builder code

• 

  Albany High School

  • Albany, NY

  • High School Mathematics Teacher

    • 2006 - 2008
    • Albany, NY

• 

  Clifton High School

  • Clifton, NJ

  • High School Mathematics Teacher/ESL Mathematics Teacher

    • 2005 - 2006
    • Clifton, NJ

• 

  St. Joseph's Regional High School

  • Montvale, NJ

  • High School Mathematics Teacher

    • 2001 - 2004
    • Montvale, NJ