Scroll To View More
Jonathan Eropkin, SQL Developer in Fresno, CA, United States
Jonathan Eropkin

SQL Developer in Fresno, CA, United States

Member since January 2, 2018
For over 15 years, Jonathan has worked with Microsoft platform technology as a senior web applications developer, CTO, and lead architect. He has strong SQL Server development skills and is more than competent with .NET and C#. His background includes business analysis, requirements documentation, and product management. He communicates well, takes pride in project and task ownership, and works well with teams or as an individual contributor.
Jonathan is now available for hire

Portfolio

Experience

  • Relational Databases, 18 years
  • SQL, 17 years
  • Microsoft SQL Server, 17 years
  • T-SQL, 14 years
Fresno, CA, United States

Availability

Part-time

Preferred Environment

Visual Studio 2013/2015/2017, SSMS, MS SQL Server

The most amazing...

...initiative I've worked on was designing, building, and managing a full-featured eCommerce and direct-mail marketing platform for the periodical industry.

Employment

  • Owner | Consultant

    2009 - PRESENT
    Category One Consulting
    • Acted as the sole owner and operator of a consultancy specializing in full-spectrum data and technology management for small businesses.
    • Developed full-stack projects for clients—utilizing PHP/MySQL and the .NET/SQL Server and designing and creating databases, web applications, and web services.
    • Prepared scope and specification documents for new web applications, then executed the project plan within time and budget constraints.
    • Managed network and server hardware in an active directory environment, and advised clients on best practices for network and application security, disaster recovery, and infrastructure improvements.
    • Created data queries and reports for quasi-government water management agency to comply with requirements of California Proposition 218. The data queries were fed into annual assessment billing statements that were sent to thousands of property taxpayers.
    Technologies: Microsoft Platform Technology
  • Lead Architect

    2016 - 2017
    SubDirect
    • Designed and implemented a variety of creative and innovative marketing solutions to acquire and process subscriber data for enterprise magazine publishers: Hearst, Time Inc., Meredith, Condé Nast, and others.
    • Led a team of full-stack developers.
    • Mentored and coached the operations and marketing staff.
    • Owned the complete systems development lifecycle (SDLC) using scrum/agile and waterfall methodologies.
    • Created functional specification documents (FSD), business requirements documentation (BRD), and proofs-of-concept (POC), including use cases, UAT test plans, performance and reporting metrics, and process documentation.
    • Analyzed program performance metrics, reviewed programs for industry-specific regulatory compliance.
    • Maintained Level 3 PCI certification.
    Technologies: Microsoft Platform Technology, AWS
  • Chief Technology Officer

    2011 - 2016
    SubDirect
    • Established the technology foundation for a marketing startup that provides new audiences for enterprise magazine publishers.
    • Collaborated with marketing, sales, and business development teams to create functional specification documents (FSD) and business requirements documentation (BRD).
    • Led a team of full-stack developers to design, build, and implement innovative consumer marketing programs.
    • Designed and product managed CircLink, an industry-specific full-spectrum marketing platform.
    • Provided technical guidance to customers/partners.
    • Mentored the operations and marketing staff.
    • Managed the offshore development team.
    Technologies: Microsoft Platform Technology, AWS
  • Senior Programmer

    2004 - 2009
    EFG Software
    • Actes as the senior programmer for a consulting firm that provided web and Win32 application development services, network management, and legacy application support.
    • Worked directly with the client stakeholders to create a new functionality, custom database queries, and application support.
    • Created new features for in-house custom software application (MostWanted Software) targeting law enforcement agency HR, inventory and training/certification departments.
    • Installed and configured Windows desktops and servers in an Active Directory environment.
    • Wrote project specification documents as directed by the client requirements for new applications.
    Technologies: ASP.NET, WinForms, MS SQL Server, C#, VB.NET
  • Staff Programmer

    1999 - 2004
    Intesolv Business Systems
    • Worked as a staff programmer for a full-spectrum consulting firm specializing in agriculture and heavy manufacturing industries.
    • Created and maintained dynamic websites using ColdFusion and ASP.
    • Integrated intranet applications with Sage Acuity (MAS 500) to import and export data.
    • Developed custom database queries for MS SQL 6.5, SQL 7.0, MS Access, and FoxPro.
    • Adopted early on AJAX technology via XMLHTTP in Internet Explorer 4—creating key intranet reports that update in near real-time during data processing.
    Technologies: Classic ASP, MS SQL Server, MS Access, FoxPro

Experience

  • CircLink (Development)
    http://circlink.com/

    I created this platform in 2008 to process direct mail magazine offers, and over the years greatly expanded its capabilities and features to handle new types of campaigns, products, and enhanced fulfillment methods.

  • RewardBee (Development)
    https://rewardbee.com

    I created the business and functional requirements and designed and built several key components for RewardBee, a public-facing website and web application that gives consumers rewards for completing surveys.

Skills

  • Languages

    SQL, T-SQL, Visual Basic .NET (VB.NET), C#
  • Storage

    Microsoft SQL Server, Relational Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ANSI SQL
  • Other

    Business Requirements, Data Modeling, Functional Specifications, Ajax
  • Frameworks

    ASP.NET, .NET
  • Libraries/APIs

    WinForms

Education

  • Bachelor's degree in Applied Mathematics
    1995 - 1999
    California State University, Fresno - Fresno, CA, USA
I really like this profile
Share it with others