Resume
Randy Solomonson
Skills:
Applications: SQL Server, Microsoft Access, MySQL, Microsoft Office, Apache, Crystal Reports
Languages: T-SQL, C#, Java, Visual Basic (VB), PHP, C, HTML, WinBatch, LabVIEW
Operating Systems: Linux, Windows, Solaris, DOS, Cygwin
Other: Tier Performance Series, Oracle PeopleSoft, ATLAST, IBM BuildForge, SOAP
Experience:
Montana Department of Justice, Austin, Texas
Senior Consultant (October 2006 to present)
-Designed, developed, tested and deployed SOAP web services for motor vehicle registrations.
-Developed and optimized stored procedures for analytical reports involving millions of rows of data.
-Created C# applications for inserting and extracting data with database of several hundred tables.
-Reduced code up to 60% with as much as a 1400% increase in performance and fewer points of failure.
-Worked with a multi-tier architecture of a SmartClient, Web server, and Database server.
-Wrote an automated unit test suite in MBUnit.
-Composed Software Design Documents (SDD).
-Followed a standard software development life cycle (SDLC) paradigm of development.
-Assisted with setup and administration of Subversion repository.
Senate of Texas, Austin, Texas
Software Consultant (February 2006 to October 2006)
-Designed, developed, tested and deployed an automated fiscal budget report system using C# that automatically populates Excel spreadsheets with data from stored procedures in SQL Server. A PeopleSoft nVision clone.
-Created an automated batch process for updating payroll information from the Comptroller's FTP site to the agency's enterprise resource planning (ERP) system.
-Created Crystal Reports from SQL Server data using more than ten database joins.
-Ported existing enterprise applications from dynamic SQL in Oracle and DB2 to stored procedures across multiple SQL Server instances and databases.
-Created WinBatch scripts to copy budget information to client machines in a secure fashion.
-Provided quality control feedback of migration of data from PeopleSoft to Tier's ERP.
GE Energy, Cleveland, Ohio
Software Consultant (March 2005 to February 2006)
-Redesigned an enterprise software system to save $1 million per year according to GE standards.
-Developed and optimized stored procedures for aggregating raw data and creating reports.
-Worked directly with the users in streamlining the existing systems to current employee training.
-Created Crystal Reports based on stored procedures in SQL Server.
-Ported an enterprise system from Pervasive to SQL Server.
-Completely redesigned the database structure of a major system to include surrogate keys for all tables.
-Composed requirements, project plans, specifications, test plans and other life-cycle related documents.
United States Army, Huntsville, Alabama
Software Consultant (August 2004 to March 2005)
-Integrated several data sources throughout the Army into a single SQL Server database using replication and Data Transformation Services (DTS).
-Worked with several tables of over one million records.
-Developed SQL code to aggregate information from several sources into a simple data warehouse.
-Used SQL Server tools to analyze and optimize existing queries for up to a 1000% increase in speed.
-Created triggers to protected data from corruption in tables of over one million records.
-Enabled 128-bit encrypted communication between two database servers over the Internet.
-Developed a web interface to display information graphically from a database.
-Developed stored procedures to allow users to have a workflow for uploading data directly to tables.
-Worked closely with the Army and the development team to follow a MIL-STD-498 development cycle.
-Setup a defect-tracking and source code control (SCC) system for the team.
IBM Rational Build Forge, Austin, Texas
Systems Engineer (November 2003 to June 2004)
-Traveled to trade shows and symposiums to represent the company.
-Assisted in key areas of the development/release cycle for a timely and error-free delivery.
-Obtained and integrated several third-party software packages with BuildForge.
-Wrote the user's guide and database implementation guide for the flagship product.
National Instruments, Austin, Texas
Application/Test Engineer (October 2000 to August 2003)
-Collaborated with a committee to design a company-wide database for hardware and software tests.
-Developed a suite of software used to validate the accuracy of analog data acquisition hardware.
-Gathered requirements for user interface and report formats.
-Advised clients on the design and practicality of decisions within software design.
-Trained employees from United States, Russia, Israel, Sweden, France, and all over the world.
-Taught software development classes to clients in Boston, Orlando, Seattle and Portland, Oregon.
-Developed an employee training course.
Think & Do Software (merged to Entivity Software), Ann Arbor, Michigan
Software Testing and Support/Project Manager (January 1998 to April 2000)
-Developed an internationalization database engine for user interfaces.
-Organized travel, labor and materials required for a booth at National Manufacturing Week in Chicago.
-Implemented 12 unique, hands-on demo stations involving experimental hardware and software.
-Designed and conducted several performance tests on customized Windows NT workstations.
Frankenmuth Mutual Insurance Company, Frankenmuth, Michigan
IT Database Developer (April 1997 to January 1998)
-Designed, developed and implemented several database solutions.
-Created reports and user interfaces identified by user requirements.
-Wrote macros for Microsoft Word and Excel that automatically exported information to databases.
Sheldahl, Inc., Northfield, Minnesota
Technician (October 1995 to April 1997)
-Developed a Sales Quote database using Microsoft Access with a Microsoft SQL Server backend.
-Automated oven profile test using Excel macros to convert data from several tests into Excel graphs.
-Gathered and formatted data for Design of Experiments (DOE) and Statistical Process Control (SPC) charts.
Education:
Kettering University (formerly GMI Engineering & Management Institute), Flint, Michigan
Bachelor of Science in Computer Science (June 2000)
ABET accredited