We provide IT Staff Augmentation Services!

Sql Developer Resume

Suitland, MD

SUMMARY:

  • Confidential, has over 15 years of experience delivering analysis, design and software development to enterprise applications.
  • He provides full life cycle implementation to mission critical software components, application development lead (+5) applications and services.
  • He builds prototypes for solution validation and manages the transition from project inception to production.

TECHNICAL SKILLS:

Databases: MySQL, Oracle, MS SQL Server 2000, Couch DB

Languages and Frameworks: Tomcat, Liferay, Spring Tool Suite, C#/C/C++ (Objective - C), Java8, Servlet API, PL/SQL, XML, JSON, Bootstrap, JQuery, Python, LISP, JavaScript

Development tools: IntelliJ 13.1, Eclipse (enterprise), MS Visual Studio (for .NET), MS SQL Server Enterprise tools, JVisualVM, Crimson Editor, MySQLWorkbench 6.1, TOAD

Other tools: Apache Tomcat 8, Liferay Portlet Container, Autosys, SharePoint Server, MS Project, MS Office, Infragistics, ActiveX components, CSS, DOM, JDBC, ODBC, Active Directory, Crystal Reports, Visual SourceSave, ClearCase, ClearQuest, Gitlab

PROFESSIONAL EXPERIENCE:

Confidential, Suitland,MD

SQL Developer

Responsibilities:
  • Confidential implemented an application that detected changes of product delivery status and automated the generation and submission of email messages to convey the status changes. The goal of the application was to coordinate workflow tasks across the relevant teams.The messaging accounted for conditions and events related to XSD validation, metadata loads, data location and types. Given the recognition of detail changes in the records, the application would fetch the appropriate data set values and construct the email contents.
  • The application was designed as an “agent” that would be ‘awakened’ at regular intervals to read the (join) database tables for status changes. The database queries were trivial, so the implementation relies on a properties file to edit/audit jdbc connection and commands (which came in handy when the database backend changed) as well as the host names and SMTP properties for the email services. The result is a fairly easy application to deploy and maintain.
  • The implementation runs on a RHEL and currently executes SQL against MySQL servers. The Java libraries are well known technologies like SendMail and JDBC that provide the communication layers. The email is routed to web based email clients. The java code was deployed to an internal Gitlab repository for source control and work management across the development team.
  • Confidential implemented a Spring based web application that routed service requests from legacy (unsupported) URIs to updated URLS. The goal was to identify similarities between "old" and "new" application descriptions - to best match services to HTTP requests.
  • The fundamental result of this design was to parse/match URL requests based on key string patterns. This Servlet design, therefore, relied heavily on Regular Expression techniques. The application configured classes to configure modern URLs as potential values composed from the legacy URLs.
  • A set of methods translated legacy URL strings to a mapping of the modern application URI specification. Three public methods, available on this class as an API, took the full url (uri + query string), and standardized on the ‘&’ value. This meant that if the input value contained URL encodings (i.e. %26), then it would execute a decode. It also tested the input string for html escapings (i.e. &). In this case, it executed unescape. The idea is that the URL is standardized (homogenized) before the classes make an effort to parse it. The subsequent method inspected the URI to determine the application category. Given the category, it looked up the appropriate legacy configuration reference and returned it. The final method returns the modern URL specification required to build the redirect url to the appropriate application.

Confidential, Crystal City, VA

Responsibilities:
  • Development and debugging on Liferay Eclipse Java for Hibernate ORM integration to MySQL
  • Development to interface with existing code (Javascript/JQuery) with the enhancement
  • Developed JQuery functions to integrate User Events with the
  • Modeling Classes to reflect SQL to construct ORM queries

Confidential, Herndon VA

SQL Developer

Responsibilities:

  • Coding and debugging on Eclipse Java for Hibernate ORM integration to Oracle and Crystal Reports
  • Coding Java on Eclipse to interface with the TIBCO ESB tools and libraries (com.tibco.tibjms.TibjmsQueueConnectionFactory) to prototype a messaging platform for mortgage data
  • Developing TIBCO processes to move SOAP messages onto and off of a queue
  • Modeling SQL to construct queries that populate SOAP payloads

Confidential, MD

SQL Developer

Responsibilities:

  • The Liferay 6.1 Performance whitepaper describes a software architecture common to multi-tiered application server deployments. To support the scalability expectations calculated by the whitepaper, Confidential
  • Install the web server, application server and database (the “stack”) software components as per the vendor's recommendation
  • Build an ideal system on DISA STIG-Compliant Redhat servers
  • Collect and compile the C source code for the mod jk proxy software
  • Enable web server to proxy requests to the Tomcat server. The Liferay 6.1 version of the portal was bundled with the Apache Tomcat 7
  • Having done multiple Tomcat installs, Confidential focused on getting the portal configured and set up, correctly. After some research, testing and minor JSP programming, he was able to orient the Liferay context to the MySQL 5.5 database - and listen for the apache proxy server. Having load balanced the application server with the mod jk component, the Confidential was involved with isolating and analyzing state and information to support the overall test statistics.

Confidential, VA

SQL Developer

Responsibilities:

  • Confidential 's role was to provide lead software development to a team comprised of senior management, junior software developers and business analysts. The project's goal was to develop enterprise and cloud-based solutions in response to issues raised by the military's ongoing deployment of healthcare, medical equipment maintenance, and regional logistics.
  • The specific tasks were
  • Asses how client demands could be translated into software requirements over the series of agile development sprints. As the requirements were gathered and derived, Confidential ’s goals were to provide architectural recommendations, logical (and UML) diagrams and working code (demonstrable capabilities) which accelerated software development for the client's technology vendors and partners.
  • Agile design and development of Java component solutions for privacy and encryption, data compression and Object Relational Mapping which are key solutions to the client's enterprise computing strategy.
  • Wrote the application integration framework to connect Tomcat 7 to the SQL Server instance using the MyBatis persistence layer. MyBatis is a framework that supports a fully configurable (using XML or annotations) approach to integrating Java (and .NET) access to a relational database resources.
  • Deploy the framework as a middleware accelerator reducing the time and learning curve to integrating with RDBMS resources.
  • In addition to the middleware integration to relational database resources, Confidential deployed an instance of Apache CouchDB (map reduce database) and developed a middleware layer (leveraging an open source library named Ektorp) to connect the RDBMS and Map Reduce databases. Confidential also wrote a file compression utility that encapsulated the Oracle/Java GZIP stream libraries as well as the Google Snappy library to do file compression on media (for greatest compression rate) and compression on text for speed. To support (general) privacy and security over the network, I implemented a component that integrated the (google) Keyczar encryption API

Confidential, Rosslyn VA

SQL Developer

Responsibilities:

  • Confidential was tasked to prototype a GIS Energy Sustainability solution on the Google Earth platform. The client provided a variety of data sources depicting US energy capacity, consumption and fuel statistics. The prototype's objective was to convey a simple data narrative about fuel usage, capacity trends (in new fuel types) and Coal age according to each state. The implementation took advantage of an existing polygon delineation (map) of the US states (which was provided to convey comparative energy profiles).
  • The prototype allows users to visualize analysis of the energy trends when they physically interact (touch) with the state of interest. Confidential conducted analysis on the energy statistics and recommended how the data could be visualized. Once the data were evaluated to convey an impactful visualization with Tableau, web based components (Amcharts) and mobile analytics (Roambi) were adopted to take advantage of the touch sensitive media throughout the Confidential .
  • Confidential was also tasked with the administration of over 130 tablet computers (including Apple, Motorola and HP devices). His role was to install Confidential apps, Third Party Apps, networking (wireless access to the DNET) and cloud based configuration for the Playbook, Slate, iPad, iPad2 and iPod Touch. Additionally Confidential wrote a web-based ASP.NET/C# utility to track loans and shipping for these devices across the firm and with Confidential trading partners.
  • Google Earth development relies on an XML dialect called Keyhole Markup Language (KML). The prototype required XML development (according to KML rules), HTML and client side scripting. Having designed the user experience, Confidential wrote a Java client that parsed the unstructured spreadsheets in order to produce JavaScript files for each of the 50 states. The javascript encapsulated widgets to spring out of the interactive map (when deployed to touch sensitive displays).
  • The prototype continues to be featured at conferences and meetings, and has evolved into an ongoing visualization application of US energy analytics.
  • Confidential has managed the Confidential Analytics Mobile Enablement program which features firm wide asset management and provisioning of cloud based mobile devices. The Mobile Enablement program facilitates the development of software prototypes, solutions and demonstrations on the iOS, android and Windows-based tablet platforms. Confidential has developed a means of provisioning devices to technology leaders across the firm. The DAI Mobile Enablement process exists to extend the innovation conversation beyond the CFI and into the marketplace for Confidential Analytics and across the firm. Confidential 's process tracks asset inventory on a database which relates borrowers to the assets. Confidential developed a web-based asset tracking tool (in C# on the ASPX "platform") in order to support transparent status of loans, users and devices. Confidential continues to research advances in geo location, messaging and augmented reality applications for mobile apps that explore the boundaries of post digital media.

Hire Now