Scroll To View More
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
Chris Remshaw, SQL Developer in Dallas, TX, United States
Chris Remshaw

SQL Developer in Dallas, TX, United States

Member since September 20, 2013
Chris is a hands-on architect + developer with many years of experience with companies large and small. Proven record of customer satisfaction, efficiency, and solution longevity. Experienced with a variety of languages and tools and comfortable solo, as a team member, or as a group lead/mentor.
Chris is now available for hire
Hire Chris

Portfolio

Experience

  • SQL, 14 years
  • Oracle, 12 years
  • Perl, 10 years
  • Java, 7 years
  • JUnit, 7 years
  • Cassandra, 3 years
  • Spring, 2 years
  • Apache Solr, 2 years
Dallas, TX, United States

Availability

Part-time

Preferred Environment

*nix, IntelliJ, VIM

The most amazing...

...work I've done is leading a team to create a cross-functional, distributed, and synchronized platform that processed and stored hundreds of millions of records.

Employment

  • IT Architect

    2014 - PRESENT
    AT&T
    • Design, develop, document and analyze overall architecture of systems, including hardware and software.
    • Determine integrated hardware and software architecture solutions that meet performance, usability, scalability, reliability, and security needs.
    • Coordinate design and integration of total system including subsystems.
    • Research and recommend technology to improve the current systems.
    • Hands on implementation of systems solutions.
    • Responsible for developing architectures and hands-on implementation of solution to complex business problems.
    • Responsible for discovering pain points from a customer perspective, driving evolution of framework and runtime components, implement and support solutions.
    Technologies: J2EE, Maven, Jenkins, TestNG, Apache Cassandra, Apache ZooKeeper, Apache Storm, JMS, RabbitMQ, JNDI, JIRA, Agile, Scrum

  • System Specialist

    2012 - 2014
    Bell Helicopter
    • Assisted with Factory Planner-to-SAP report migrations, primarily based in Perl/Oracle.
    • Created an Android application and services to track shop floor movements.
    • Expanded developer tool set by creating efficient core modules for batch access.
    • Developed software infrastructure for quicker error reporting and handling and problem resolution.
    • Integrated SharePoint document controls for automated report retrieval.
    Technologies: Perl, SQL, PL/SQL, Java, R

  • Technical Lead

    2010 - 2012
    Travelocity
    • Lead a team of co-located developers across three continents to create backbone services used by live site and external partners.
    • Lead development of hotel price feed storage and retrieval - a synchronized, distributed system that is responsible for hundreds of millions of records on a rolling basis. This single project had the highest conversion rate site-wide after launch.
    • Integrated third-party review system for hotels and cruises.
    • Lead installation and development of NoSQL (Apache Cassandra) integration
    • Created and maintained ETL batch services utilizing Spring for service content population and verification.
    Technologies: Java, Perl, SQL, PL/SQL

  • Developer

    2009 - 2010
    Bell Helicopter
    • Created and maintained Perl-based Factory Planner reporting scripts
    • Generated hierarchical logistics tracking to detect MRP volatility
    • Create Perl-based SharePoint API for report uploading and data retrieval
    • Create client-side Perl/Tk application for detailed report generation utilizing Win32::OLE
    • Enhanced .NET framework with smart batch uploading to Oracle
    Technologies: Perl, SQL, PL/SQL, SharePoint API

  • Developer

    2006 - 2009
    Dresser Wayne
    • Created Tcl scripts for consumption of Point of Sale (cash register) information and output in a standardized format.
    • Created TWAPI/WMI scripts for monitoring of hardware statistics.
    • Created scripts to interface with Gas station gas price display signs via parallel ports.
    • Assisted with debugging and maintenance on Java/Groovy reporting web interface
    • Enhanced core scripting framework by introducing additional efficiency.
    Technologies: TCL, TWAPI/WMI, SQL, Java, Perl

  • Developer

    2006 - 2006
    Verizon Wireless
    • Generated reports on wireless disaster recovery output to Excel
    • Assisted with JBoss/JSP intranet maintenance and page creation.
    • Created custom VBA code to comply with customer-specific requirements.
    • Created and maintained custom PL/SQL code that facilitated report creation.
    • Responsible for internal customer interaction, requirements gathering and analysis.
    Technologies: Java, JSP, Perl, SQL, PL/SQL, VBA

  • Developer

    2005 - 2006
    Performance Retail (Dresser Wayne)
    • Created, maintained, and improved TCL scripts for ETL processes from POS machines.
    • Responsible for data migration to MySQL back-end servers.
    • Created custom TWAPI/WMI scripts for hardware monitoring on-site at customer location.
    • Developed direct price modification program to interface with digital price signage.
    • Enhanced core functionality by expanding developer toolkit.
    Technologies: TCL, TWAPI/WMI, SQL, Java, Perl

  • Developer

    2004 - 2005
    Army Air Force Exchange Services
    • Created fully automated ETL process to handle all financial record migration to data warehouse on a nightly basis.
    • Modified existing PL/SQL procedures to enhance loading times dramatically.
    • Created developer tools for performance monitoring and reporting
    • Worked extensively with customers to document project needs and architect solution
    • Won AAFES Award for Outstanding Work for work completed on this project.
    Technologies: Perl, PL/SQL, SQL

  • Software Engineer

    2002 - 2004
    Travelocity
    • Led a team of developers to convert hotel booking path to Java/JSP.
    • Created and enhanced existing developer documentation and UML surrounding hotel core classes and capabilities.
    • Assisted in migration of shopping paths for Packages and Hotels from C++/TCL to Java/JSP.
    • Created and maintained C++/TCL pages in Packaging/Hotels.
    • Assisted with architecture of hotel path infrastructure.
    Technologies: Java, JSP, C++, TCL, SQL, Perl

  • Vignette Technical Lead

    2000 - 2002
    Nokia via One, Inc.
    • Created automated template generator utilizing Vignette StoryServer CMS.
    • Translated SAP ABAP reports to PL/SQL with Vignette front-end.
    • Assisted with security optimizations for existing Nokia site.
    • Worked with co-located team to enhance report and site capabilities.
    Technologies: TCL, SQL, PL/SQL, ABAP

  • Lead Developer

    2000 - 2000
    Service911.com
    • Led a team to create site-building infrastructure that reduced sub-site creation time from weeks to hours.
    • Utilized Vignette StoryServer CMS to customize portals for help content.
    • Optimized database and T-SQL procedures.
    Technologies: TCL, SQL, T-SQL

  • Technical Lead

    1999 - 2000
    AT&T via Scient
    • Led a team to develop infrastructure for AT&T's website.
    • Created content management templates utilizing Vignette StoryServer.
    • Architected database design for content storage and tool utilization.
    • Mentored team members and instituted best practices.
    Technologies: TCL, SQL

  • Technical Lead

    1999 - 1999
    iCelebrate.com
    • Held training sessions on use of mod_perl for start-up Holiday-based website before being hired on.
    • Lead front-end development team in creation of website elements.
    • Worked with DBA to architect and enhance Oracle back-end.
    • Optimized site infrastructure and mod_perl configurations.
    Technologies: mod_perl, SQL

  • Developer

    1998 - 1999
    Gemmy
    • Created ASP/VB scripts for customer use.
    • Interfaced with MS Access for custom report creation.
    • Worked with business customers to gather requirements and perform data analysis.
    Technologies: ASP, VB

  • Developer

    1998 - 1998
    Travelocity
    • Created pages for content portion of site utilizing ColdFusion.
    • Migrated ColdFusion applications to Vignette StoryServer (TCL) infrastructure.
    • Created internal tools for advertising placement, calendar and administration purposes.
    • Assisted with development of portal infrastructure for co-branding Travelocity site.
    Technologies: ColdFusion, TCL, SQL

Experience

  • Member - North American Mensa (Other amazing things)
    http://www.mensa.org/

    Mensa, the high IQ society, provides a forum for intellectual exchange among its members. There are members in more than 100 countries around the world.

Skills

  • Languages

    Java, SQL, Perl, JavaScript, Tcl, C++, C#, C, Lua

  • Frameworks

    JUnit, TestNG, Spring, Apache Struts

  • Libraries/APIs

    DBIx::Class, SharePoint API

  • Paradigms

    Agile Software Development

  • Platforms

    Unix, Windows, Oracle

  • Storage

    Cassandra, NoSQL, MySQL

  • Other

    Unix Shell Scripting, Apache Commons

  • Tools

    Subversion (SVN), IntelliJ IDEA, Maven, Apache ZooKeeper, RabbitMQ, Apache Storm, Apache JMeter, JProfiler, CVS, Apache Solr, Apache Ant
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
To view more profiles, join ToptalJoin Toptal
I really like this profile
Share it with others