Profile image of gkyniston
@gkyniston
Flag of United States Battle Ground, United States
Member since 16 de outubro de 2007
0 Recomendações

gkyniston

Conectado Desconectado
TECHNICAL EXPERIENCE: • Data Modeling and Relational Database Design in Microsoft Access, SQL Server, and MySQL • Microsoft Access 97/2000/2003 – VBA, ADO • Microsoft SQL Server 7.0/2000/2005 Database • Microsoft VB 5/6 Enterprise Development • Some C# .Net, Ruby on Rails • 1 ½ years academic experience in Object Oriented Development • Integration and troubleshooting of third party software applications. • Process automation • Window 95/98/NT4.0/2000/XP/Server 2003/Longhorn PROFESSIONAL EXPERIENCE: Consultant 8/2003 to present IMAK, LLC Real Estate Investments (Karlsen Development Affiliate) Vancouver, WA Provide website development as well as design and implementation of various Access and SQL Server databases. Software Engineer – Full Time Employee 9/5/2000 –8/15/2001 Vancouver, WA Application design, development and deployment using VB 6. COM/COM+ business and data access object development against SQL Server and Oracle. Employed SQL Server DTS in migrating data from SQL Sever to Oracle Data warehouse. Assisted other VB programmers in code/structure review according to architecture, and with debugging. Use of MTS and DCOM in deployment of enterprise applications. Preformed data modeling and design of various SQL Server and Oracle databases. Provided remote and on-site installation, administration, and maintenance of SQL Server databases and instances. 3rd party application installation and maintenance. Experience using Visual SourceSafe code repository. Major Projects LOCKBOX PROCESSSING APPLICATION; Using VB 6 and n-tier architecture principles, this application permitted business personnel to review and resolve unmatched invoice numbers and amounts resulting from website transactions. DCOM, MTS and COM+ based business objects were used against Stored Procedures in an Oracle Database. Business rules were encapsulated in VB business and data access objects and Oracle Stored Procedures. Business and data access objects were housed on a Windows 2000 machine under COM+ Services (MTS). A thin-client UI was also written in VB 6.0. Remote deployment and access to business and data access objects was provided through DCOM. Information marshalling and updating between tiers by simultaneous users was implemented through use of disconnected ADO recordset objects. DATA MIGRATION: Data migration of accumulated web stats from SQL Server 7 to flat files for import into Oracle Data Warehouse. DTS and VB Script were used to perform the Extract and Transformation of data. DTS was also used for the creation of fixed-width flat files. EMAIL SYNCHRONIZATION BETWEEN ORACLE AND SQL SERVER DATABASES: Scheduling of jobs using Transact-SQL to export bounced/unsubscribed email addresses from SQL Server 7.0 into fixed-width flat files for update into Oracle database. With very limited Oracle experience I was also able to save an abandoned Oracle project using SQL Navigator and PL/SQL. Rewrote update routines from the ground up using more efficient procedural techniques and stepwise refinement. Reduced code size by over 200 lines. PROJECT LEAD –NetAnalysis Web Analysis Software: Design/Installation/Setup/Administration of NetGenesis’s NetAnalysis website analysis software (version 4.5). Implementation of NetAnalysis site against SQL Server back-end in Windows NT 4.0 environment including installation/set up of SQL Server 7.0. Wrote custom VB 6 apps to preprocess log files into a custom format specific to our website. In addition, I repaired and maintained existing (but none functioning) netAnalysis site when originally hired by Egghead.com. Also did report generation and publishing. Assisted business analysts in report creation. Software Engineer 8/13/1999 - 8/30/2000 Milliman & Robertson Actuarials (Best Consulting contract) Portland, OR Website business and data access object development using VB 6.0, ADO, MTS, SQL Server 7.0 and Visual SourceSafe. Remote collaboration and testing of VB development with ASP programmers, network administrators, and database administrators in several different geographic areas including: Toronto-Canada, Seattle-WA, Tigard-OR. Preformed database design, development and administration against SQL Server 7. SQL Server 7 script creation. Data transfer using BCP. Analysis and computerization of business processes specific to the pension benefit industry using VB 6.0 and Access 97. Major Projects: PROVIDENCE HEALTH SYSTEM EMPLOYEE RETIREMENT WEBSITE Allowed 30,000+ employees to access real-time reports on their accumulated retirement benefits as well as dynamically forecast possible future benefits according to employee supplied parameters (quit or retirement dates). Also allowed real-time benefit distribution requests to be made by employees. Used Access 97 as the administrative interface for website information management. Used VB 6, ADO, SQL Server 7, MTS, and Visual SourceSafe in the course of building 20+ business and data access objects currently running on the Website. Built test harnesses using VB front-ends and ASP pages. Site uses IIS 4.0 and ASP pages for front-end logic. CUSTOM IMPORT APPLICATION Custom VB 6.0 importing app that allowed 500+ field, mainframe text file to be imported across multiple, Access 97 tables. Application handled all processing of text file. From calculating the number of fields needed in each table based on a header file, to the creation and linking of the tables as well as the import process. Written completely in VB 6 against an Access 97 Database. CONVERSION OF EXISTING FORTRAN SYSTEMS TO ACCESS 97 USING VBA. N-TIER DEVELOPMENT USING VB 6, MTS, ADO, SQL SERVER 7, AND ACCESS. MAINTENEACE AND MODIFICATION OF VARIOUS LARGE ACCESS 97 APPS. Consultant 1/95 – 8/99 Mahoney Hearing Aid Systems Vancouver, WA Analysis and computerization of business processes. Main development platform: Windows 95 based peer-to-peer networks. Extensive development and maintenance of normalized relational databases using Access 2.0, 7.0 and Versaform database products. Languages included VBA, VB 5 and Versaform's programming language. Use of ADO. Local and remote replication of databases using Microsoft Transporter under Access 7.0. Import/Export of data among various software packages. Major Projects: Labor and Industries client tracking and processing application under Access 7.0 ADT (Access Developers Toolkit). PAYROLL PROCESSING AND ACCOUNTING APPLICATION: Multi-user, hearing aid repair, accounting application under Access 2.0 – converted to Access 7.0. Conversion of manual payroll procedures to computer based. OTHER: Conversion of existing Versaform systems to Access. Maintenance of existing systems. Evaluation and installation of new technologies including Microsoft’s DCOM Technology. User training. NETWORK ADDMINISTRATION: Design, installation, maintenance and repair of Windows 95 based peer-to-peer networks, including all hardware and software. Certifications: Brain Bench Certified Professional Visual Basic 6.0 Programmer Brain Bench Certified Professional Access Programmer Education: 9/89-6/90 Clatsop College, Astoria, OR - 3.9 GPA 9/93-6/94 and 9/97-6/98-MT Hood Community College, Gresham, OR - Computer Science - 3.88 3.9 GPA in CS classes - GPA 3.88 Overall. 3 humanities credits short of Associates Degree (working towards Bachelors in Computer Science) Honor Roll Dean’s List President’s List
$40 USD/hr
0 comentários
0.0
  • N/ATrabalhos Concluídos
  • N/ANo orçamento
  • N/ANo Prazo
  • N/ATaxa de Recontratação

Portfólio

Comentários recentes

Não há revisões.

Verificações

  • Conectado com o Facebook
  • Freelancer Preferencial
  • Pagamento Verificado
  • Telefone Verificado
  • Identidade Verificada
  • E-mail Verificado

Pesquisar Freelancers similares