Mr. Christopher Hernandez 4826 Monteray Dr Midland MI 48642-6073 Cell: 317-260-0857 Email: chrisbackup@yahoo.com Summary Highly skilled IT Professional with a decade of experience working for major corporate clients. Extensive and wide range of programming knowledge, skills, abilities, and experience working as System Analyst, Programmer, Web Developer, Database Applications Developer; handled other roles like DBA, database engineer, ETL and data warehouse experience. Outstanding experience in diagnosing technical challenges through code review and supporting technical documentation. His work in past positions has increased sales by 40 percent and reduced overhead by 35 to 50 percent in some cases. Is a quick study, able to diagnose technical challenges through reading code and supporting technical documentation and able to quickly determine the similarities and differences between technologies, outline and train others effectively. Has done the work of two people on several occasions after someone left and wasn't replaced. Can work independently without handholding or in a team. Can hit the ground running on any IT project. Extensive experience with the following technologies ASP.Net, WCF, Winforms, C#, ADO. Net, ASP, COM, ACTIVEX, Visual Basic (5.0,6.0), Oracle (8i,9i,&10g), SQL SERVER (7.0,2000,2005), DB2, JavaScript, VBScript, Dreamweaver, HTML, DHTML, XML, XSL, XSLT, MSXML, XSD, XDR, XAML, UML, CSS, FTP, SFTP, SFPT2, SSH, SSH2, SOAP, WCF, WPF, PKI certificates, Some (Fireworks and Flash) experience. MS-DOS, WINDOWS 95/98/NT 4.0/2000/XP, Some (Citrix, Novell, and AS 400) experience. TECHNICAL SKILLS Operating Systems MS-DOS, WINDOWS 95/98/NT 4.0/2000/XP, UNIX, AIX, AS 400, Citrix, Novell Internet/Web Tools: ASP.Net 3.5/2.0/1.1 /ASP 3.0/ 2.0, WCF,COM/DCOM, JSP, JAVASCRIPT, Jquery ,Xquery, Microsoft InfoPath, XML, XSL/XSLT, MSXML, XSD, XDR, XUL, HTML, DHTML, CSS, VBSCRIPT, SOAP UDDI, WSDL, FTP, SFTP, SFPT2, SSH, SSH2, WCF, WPF , MTOM, PKI certificates, Dreamweaver Application Development Tools: Visual Studio.Net 2005/ 2003, VB.Net / Visual Basic 6.0 / 5.0, Visual Interdev 6.0, Macromedia Dreamweaver, IBM Rational ClearCase, QuarkXpress(Mac) Programming Languages: C#, Visual Basic, Qbasic, VBA, VB.Net, ASP, ASP.NET, JSP, JAVA, PL/SQL, MS/SQL, T-SQL, C++, some (COBOL, Pearl, PHP, and Coldfusion) Scripting Languages: JavaScript, VBScript, HTML, DHTML, CSS, XML, XSL/XSLT, XUL JCL and cmd line Interpreters: Unix Shell and MS-DOS command.com Servers: IIS 5.0/4.0, MS Site Server, Web logic, IBM Web Sphere, Website Web Server, MTS, JRUN Databases/ RDBMS: SQL SERVER 2005/2000/7.0, ORACLE 10g/9i/8i/, SYBASE SQL ANYWHERE, DB2 UDB, Microsoft Access, My SQL Methodologies: UML Tools: Visio Other Packages: Erwin, Front page98, TOAD. Source Control Tools: Visual Source Safe Reporting Tools: Crystal Reports, Oracle XML Publisher, SQL Server Reporting Services
Database Development and Expertise: 11 yrs on a daily basis and as needed, performed along with application development and web development, all projects, as needed. Oracle PL/ SQL platform: Creation/Modification/Troubleshooting: Databases/Schemas/Tables/Stored Procedures/Views/Triggers/Database Functions, Packages/Complex Query creation/ETL functions for application development DBA Admin tasks on DB objects tables, views, query optimization, etc, Utilization of built in functions etc, Creation of Oracle packages Data transfers to other databases, including Oracle to Oracle databases and Oracle to SQL database and SQL to Oracle databases, as needed
MS SQL platform: Creation/Modification/Troubleshooting: Databases/Schemas/Tables/ T-SQL, DTS Packages/Stored Procedures/Views/Triggers/Database Functions, Packages/Complex Query creation/ETL functions DBA Admin tasks on DB objects tables, views, query optimization, etc, Utilization of built in functions etc Creation of DTS packages Data transfers to other databases, including SQL to SQL databases and Oracle to SQL database and SQL to Oracle databases, as needed
Professional Experience
US Air Force Washington DC 11/24/2008-- 12/31/2008 Client needed Web Services and Security Expertise. This was a 2 weeks Short-term project extended to 5 weeks
IT CONSULTANT/Systems Analyst /Programmer · Portal system architecture design documentation and development. · R&D on secure transactions, cryptology, and security infrastructure. Securing Web Services Security with SOAP, PingFederate, x.509 certificates, WS-Security, WSE, Trace logging in WS 2.0/3.0, WS-Policy, WS-Trust, MTOM, Indigo, Cryptography, SAML, XML signature, XML Encryption. STS token service. · Web services design, documentation, and development all done in C# · Wrote SQL queries in SQL Server and developed Oracle Tables and PL/ SQL/ Stored Procedures/ Views/ Triggers/ Database Functions, Packages/Complex Query creation · Developed documented .Net reference architecture code. Developed documented J2EE reference architecture code. Developed documented .Net reference services to demonstrate functionality of the reference architecture code. · Developed documented J2EE reference services to demonstrate functionality of the reference architecture code. · Developed additional code to aid with testing of the reference architecture code.
Environment: ASP.Net 2.0/3.0/3.5, C#, Visual Studio 2005, Visual Studio 2008, .Net 2.0/3.0/3.5 Framework, SSRS, IIS 5.0/5.1/6.0, Win XP, SQL Server 2005, Oracle9i and Oracle10g, PingFederate IDP Services
4Ten Technologies Baltimore MD 09/2008-- 11/2008 Project involved web programming and browser customization and browser tool creation. Start-up Company. Project stalled for lack of funds.
IT CONSULTANT/Systems Analyst /Programmer · Used (Mainly C#), C++, VB.Net, Silverlight, JavaScript, VbScript, Html, HTML, DHTML, CSS, XML, XSL/XSLT, XUL, XAML, WCF, WPF, FTP, and Batch scripting programming, for various projects. · Extensive research of various Web infrastructure technologies pertaining to toolbar development on MS IE platforms and Firefox platform and other existing browser platforms. · R &D on browser FTP protocol and FTP file operations and client side file operations through browser internal functions (JavaScript and some DHTML) on MS IE (all versions) and Firefox, Safari, Opera platforms (current versions and one version prior). · Oracle Database ETL functions for Web applications data storage, retrieval, and updates. Some Proc and views creation and modification as needed. Query creation and modifications as needed. HTML and CSS. Wrote Oracle Pl/ SQL/ Stored Procedures/ Triggers and functions · Web programming and development. Defined strategies and approach for multiple projects. · Analyzed complex requirements, existing infrastructure, and defined more robust and effective solutions.
Environment: ASP.Net 2.0/3.0/3.5, C#, Visual Studio 2005, Visual Studio 2008, .Net 2.0/3.0/3.5 Framework, SSRS, IIS 5.0/5.1/6.0, Win XP, SQL Server 2005, Oracle9i and Oracle10g, JavaScript, VBScript, HTML, DHTML, CSS, XML, XSL/XSLT, XUL, WCF, WPF, FTP, Unix Shell and MS-DOS command.com
NAVFAC MCON (US NAVY HQ), Washington DC 12/10/2007-- 4/01/2008
IT Consultant/Systems Analyst/System Admin/ DBA /Programmer · Administer existing Delphi application. Reverse engineer, analysis development, bug fixes, and application upgrade. Control requirement analysis and development. Version rollout planning and release. · MILCON (custom in-house) Delphi Application Administrator · System analyst support and IT Consultation for in house applications that are utilized on a daily basis by MILCON program analysts, stationed at the Navy HQ, Washington Navy Yard. i.e. (“ieFacman”,”Discoverer”,”eProjects”,”FIS”) · Support and IT Consultation as needed for MS products, i.e. MS Access, MS Excel · Support for user queries and reports, data transfers, imports, and exports as needed · Administration and support for batch processes of data transfer from Navy proprietary systems for utilization by MILCON application · Maintenance of FTP, SFTP, SFPT2, SSH, SSH2 secure data transfer processes · Administration, Analysis, Support, and maintenance of the program analysts' ability to interact and function on a daily basis with secure hosting facility at AHF location · Support and analysis of Citrix client server architecture · Work with management in order to determine and define problem issues and change requests · Work with NMCI network liaisons and technical staff on a daily basis for investigation of problems, problem resolution, and/or change requests and necessary modifications · Record and track all issues on a daily basis. All service attempts and developments regarding any particular issue are recorded and updates are posted to a report billboard for immediate access to real time reports on all outstanding issues · Determine logical solutions and approach for problem fixes and change requests · Developed in-house intranet problem tracking system in order to track problem issues and change requests, using MS Access, MS InfoPath, WCF and WPF. · Development/test environment, server upgrades and change testing and qualification. · Planning, testing, documentation and support of system upgrades for Microsoft Windows 2000/2003 SQL 2000/2005 environment with other IT departments and secure hosting facility staff. · Support documentation and admin for n-tier client/server architecture applications. · Administration and support for batch processes and data transfer systems for US Navy HQ. · Support and analysis of Citrix client server architecture. · SQL and Oracle Database Administration on DB objects tables, views, query optimization, created built in functions etc, · Creation of Oracle packages. Databases/Schemas/Tables/Stored Procedures/Views/Triggers/Database Functions, Packages/Complex Query creation/ETL functions for application development · User logins and access privileges setup and administration. · Public Key Infrastructure and certificates, setup, testing, and management · DB processes, performance metrics, network and storage resources reporting.
Environment: ASP.Net 2.0/3.0/3.5, C#, Visual Studio 2005, Visual Studio 2008, .Net 2.0/3.0/3.5 Framework, SSRS, IIS 5.0/5.1/6.0, Win XP, SQL Server 2005, Oracle9i and Oracle10g, JavaScript, VBScript, MSXML, XSD, XDR, WCF and WPF, FTP, SFTP, SFPT2, SSH, SSH2, MS InfoPath, Unix Shell and MS-DOS command.com
ITT TECHNICAL INSTITUTE, Carmel, IN 02/28/2006--06/30/2007
IT CONSULTANT/System Analyst/Applications & Web Developer, App Admin/I3 Interactive Intelligence Admin & Developer/DBA
· "Increased sales by 40 percent, and instituted cost efficiencies that reduced overhead by 35 percent”.
· “Did the work of two people after someone left and wasn't replaced”.
· Designed and implemented custom back-office ETL systems for complex large scale student data applications. · Daily development of MS SQL Procs, Views, Functions, Triggers, DTS packages creation and modification as needed. Oracle Procs, Views, Functions, Triggers as needed. Oracle PL/SQL stored procedures and anonymous blocks for data conversion purposes. · Experience with Perl and Korn shell scripting. · Experience with enterprise-scale relational Data Models and Data Warehouse, including both relational and dimensional models at student HQ data center. · Experience with diagramming and documentation requirements, including ERD, Data Dictionary, and Data Flow Diagrams. · Configuration management practices and procedures, modeling and managing metadata. · Knowledge and understanding of approaches for business intelligence, data marts. · Outstanding professional and efficient and accurate technical leadership in developing solutions for complex problems. · Outstanding, professional, efficient, and accurate technical leadership and direction to less experienced members of a team. · Extensively used INNER JOIN, OUTER JOIN, IS-NULL function and wrote and optimized queries for developing stored procedures · Used query plans to analyze the queries for optimization and performance tuning. · Developer SQL CLR functions using C# and prepared deployment scripts for this functions. · Experience with XML data modeling. · Experience with XLST, XPath and XQuery, DOM parsers. · Various tools and products used: Rational ClearQuest/ClearCase, Quest Software, TOAD, PL/SQL Developer, Erwin, Putty, Oracle client 10g, PL/SQL, Perl, Korn shell, XML, XSLT. · Provided technical and specialized guidance, and solutions to complex software engineering problems. Performed software engineering analysis and design. Estimate software development costs. · System design, development, and integration activity lead utilizing best common practice software engineering, and design techniques. · Support documentation and admin for n-tier client/server architecture applications. · Web application development and electronic publishing. XML, Xquery, XSL/XSLT. Data Parsing. Unix/Linux and windows platforms. Java/J2EE development. VB.Net programming. Dfc with java implementation. · SQL and Oracle Database Administration. · Database design, creation, and maintenance. · Database object creation, administration, and maintenance · User logins and access privileges setup and administration. · Development/test environment, server upgrades and change testing and qualification. · Setup and administer scheduled database backups and maintenance plans. Server activity, metrics, and transaction, system, and security log monitoring. · DB processes, performance metrics, network and storage resources reporting, apply patches and updates. · DB performance tuning, data indices and statistics, maintenance. DB administration task T-SQL Scripting. · Planning, testing, documentation and support of system upgrades for Microsoft Windows 2000/2003 SQL 2000/2005 environment with other IT operational departments and development staff. · Assisted with configuration and administration of mission-critical systems, database servers and tape backup systems. · Application development, programming, and administration. · Interactive Intelligence telephony system software administration, maintenance, and proprietary development and customization. Some I3 Interactive handler creation, modification and maintenance · In-house Applications upgrade, maintenance, C# & VB.Net programming, and Java/J2EE Web development. DTS packages, Oracle packages and ftp data transfers programming and Admin. · Provided Consultation to management to Develop Business Models then Designed, and Developed multiple SOA Oriented processes. · Modified, upgraded, and integrated other existing SOA processes. · Developed and implemented into production Wonderlic test score system that retrieved data from third party website, processed it and then implemented it into legacy database system. · Created multiple DTS packages for data transformation between HQ legacy systems and 211 Online systems. · Setup, admin, and maintenance of a job scheduler machine in the department to handle all 211 Online scheduled jobs. Transferred existing processes and batch jobs to the new machine from an old machine stationed at HQ. · Interactive Intelligence call center system software administration, maintenance, development. Created and administered multiple call campaigns for ITT TECH 211 Online Call Center. · Developed Web pages with I3 system proprietary functions for telephony call handling and database data call disposition. · Developed custom functionality alongside proprietary functionality to allow agents to perform needed actions whilst they were on an outbound call. · Tested and verified system objectives and functionality with management and users. · Implemented the application into production within I3 proprietary environment -“Scripter”. · Some basic I3 proprietary handler investigation and creation, modification, and maintenance · Created several Complex Queries for data retrieval queries for management to use for reporting purposes. This phase and rollout was done as a preview call campaign. · Upgraded this application to handle Agent owned callbacks and developed additional features and requested functionality as well as database functionality and application functionality on the back end to be able to provide agent owned callback service. Implemented this phase into production after testing and verification was done. · Consulted and trained management and users on the system. · Consulted with management and designed and developed several SOA processes and data management tasks related to the project, whilst developing all phases of the application. After a flawless rollout, at some time later after this, my application was copied and used by the I3 vendor for another project with HQ in order for them to provide dialer functionality to another school in California. Both applications currently run in production today. · Completed modifications to the second phase of the developed dialer application and worked with management and software vendor in order to upgrade the system and implement the campaigns in power dialing mode. · Made script modifications and implemented the application into production in power dialing mode. · Created DTS packages for data transfer services between HQ database system and the dialer database for data imports and exports and updates. · Continued to consult with management, and design, develop, test, and implement several needed custom data management and manipulation SQL processes. Created various DTS packages, database modifications, triggers, stored procedures, scheduled, maintained, monitored, upgraded, and implemented solutions into production. · Made additions to the dialer application in production as requested. · Developed basic inbound call detection script. · Developed ASP.NET Website as a CRM for the dialer database and developed and implemented security infrastructure for windows authentication and application authentication. Implemented and setup the Web application infrastructure to function with role base and access control functionality. Developed modules within the Website application to perform data manipulation tasks based on needed business requests. · Continual SQL process creation, stored procedures, database triggers, data modification, testing and implementation into production, alongside Website development and performing daily data retrieval, management, monitoring, and manipulation tasks as requested by management. · Crystal Reports, Oracle XML Publisher, SQL Server Reporting Services · Developed and implemented into production FTP process to retrieve data from legacy database and export to document imaging vendor website on a daily basis for another project not related to the call center. · Consulting, informing, and training management on a daily basis, whilst monitoring data processes administering the dialer database and the I3 call center system and performing daily requested tasks in production, alongside dialer application maintenance and Website application development.
International Object Tech Cedar Grove, NJ 10/1998--12/2005
Clients: Dynsis, and Pfizer and Delphi Automotive.
IT CONSULTANT /System Analyst / Database Designer & Engineer /SQL, Oracle, Ms Access DBA/Applications Programmer / Web Developer
· "Helped to Increase customer sales by 35 percent in some instances, and instituted cost efficiencies that reduced overhead by over 50 percent in some cases”. · Designed and implemented custom back-office ETL systems for complex large-scale auto manufacturing data applications. · Application support, Diagnose and troubleshoot escalated customer issues related to web browser, firewall, proxy server as well as other internet related technical issues. · WEB Applications Development. Duties included transforming Access databases that I created for use as Web-based applications using classic, ASP, SQL, PL/SQL, VbScript, JavaScript, JSP, HTML, CSS, XML, COM, T/SQL and later, C#, VB.Net, and ASP.Net for developing company World-Wide Database Systems. Used Macromedia Dreamweaver to assist in rapid web page development. · Some (Fireworks and Flash) experience, and some Cold Fusion experience. · Worked with management to Develop Business Models then Designed, and Developed/Programmed multiple Databases (Ms Access). · Created relational database structures. Tables, views, primary keys, foreign keys, and indexes, (Ms Access). · Tier 2 and tier 3 level infrastructure setup and support. · Ms Access Database Administration. · Legacy system support and maintenance (Ms Access). · Programming Visual Basic, VBA. · Designed SQL database schemas, created SQL databases needed for new applications and implemented those databases into production. · SQL Database Administration, maintenance and support, user account creation and access administration · Created relational database structures. Tables, views, primary keys, foreign keys, and indexes. · Stored procedures, Complex Queries, and database triggers. · Vb 6 and earlier Vb 5 applications support, investigation, code changes, form and module modification as well as new forms, reports, and module development and programming. · Involvement and assistance as part of a team in compiling entire various VB custom built application systems for different version releases for delivery to clients. · End user (customer) daily support of different versions applications that were installed at various customer locations that included problem investigation and real time customer training on the phone. · Remote connection support which included the use of dial-up pc anywhere · VPN Remote desktop connections, FTP, and telnet to perform problem investigation and resolution. Dial up connections were used for customers who had only this infrastructure in place. Some locations required a piggy- back dialup connection to one location in order to get to another. · Used MS VPN and third party VPN software to establish different connections to locations for customers who insisted on their own third party VPN software. · Application upgrades, as well as new installation, (database setup and implementation for new customers), DTS package changes, upgrades, monitoring, scheduling and execution were done remotely by either VPN Remote Desktop connections or dial-up pc anywhere connections, whilst developing new modules for future application releases. · Batch file creation and modification to download data from UNIX server · VBA programming to process data from Access databases to be displayed and used by the data consumer in Excel spreadsheets. · FTP process SOA modules (written in VB 6) to transfer result files to data consumer's location. · Access switchboard creation and modifications to run test modules unmanned that imported data into access databases from text files, processed the data, and exported and formatted the display in excel spreadsheets for delivery to the data consumer. · Assisted in other existing .Net applications support and development as part of a team and individually. · PC Hardware / Software trouble-shooting. · Database population. · Generation of Ad-Hoc reports as needed. Data retrieval and investigation (involving the creation of complex queries, reports). · Tier 2 and tier 3 level infrastructure setup and support for those applications that included COM Object setup for classic ASP applications and existing proxy server investigation and configuration for hosting the applications databases and where the applications would reside. · Complex Query creation, SQL Server, Enterprise Manager, Visual Source Safe, some Networking functions, on a daily basis. Hardware/Software Installation, troubleshooting and support along with application development, maintenance. · Outstanding professional and efficient and accurate technical leadership in developing solutions for complex problems. · Outstanding, professional, efficient, and accurate technical leadership and direction to less experienced members of a team. · System design, development, and integration activity lead, utilizing best common practice software engineering, and design techniques. · Provided technical and specialized guidance, and solutions to complex software engineering problems. · Web application development and electronic publishing. XML, Xquery, XSL/XSLT. Data Parsing. Java/J2EE development. .Net programming. Unix/Linux/AIX and windows platforms. Dfc with java implementation. · SQL, Oracle, and Ms Access database administration. · Database design, creation, and maintenance. · Assisted with setup and administration of scheduled database backups and maintenance plans. Server activity, metrics, and transaction, system, and security log monitoring. · DB processes, performance metrics, network and storage resources reporting, apply patches and updates. · User logins and access privileges setup and administration. · Development/test environment, server upgrades and change testing and qualification. · Assisted with DB performance tuning, data indices and statistics, maintenance. · DB administration task T-SQL Scripting. · Planning, testing, documentation and support of system upgrades for Microsoft Windows 2000/2003 SQL 2000/2005 environment with other IT operational departments and development staff. · Configuration and administration of mission-critical systems, database servers and tape backup systems. · Programming Visual Basic, VBA. Complex query creation. Application and Report development, Admin, maintenance and upgrades. · WEB Applications Development. Duties included transforming previously developed in-house applications into Web-based applications using ASP, SQL, VbScript, JavaScript, C++, HTML, CSS, XML, DHTML and C#, J# and VB.Net for developing company worldwide plant WAN data systems. · Environment : C#, VB.Net, ASP.Net 1.0/1.1/2.0, Visual Studio 97/6.0, Visual Studio.Net 2002/2003, Visual Studio 2005, Enterprise manager, Query Analyzer, Toad, Visual Source Safe, .Net 1.0/1.1/2.0 Framework, UML, ADO. Net, XML/XSL/XSLT, WCF, Winforms, SSRS, IIS 1.0/2.0/3.0/4.0/5.0/5.1/6.0, HTML, DHTML, CSS, Java script, VBScript, VBA, Visual Basic, Win 95/98/2000, Win NT 3.0/3.5/4.0, SQL Server 7.0/2000/2005, My SQL, Oracle8i /9i and Oracle10g
Education Bachelor's Degree equiv. Received an Award from Delta College for "Outstanding Graduate" on achievement of first Associate Degree. GPA of 3.9
1998 to 2005 Delta College US-Michigan-Saginaw Associate Degree Business Studies in Computer Science and Technology Application Specialist covering following areas. · Unix. · Local Area Networks. IBM Dos. Windows 9x. AS 400 intro & AS 400 Storage and Retrieval. Cobol Programming I & II. MS Access. Ms Excel. Ms PowerPoint. MS Word. · Micro Hardware Install & A+ certification prep. · Basic & Adv Web Page Design. · Intro to CIS. · Intro to the Internet. · QBasic. C++, C++ Object Oriented, C++ Data Structures. · Visual Basic I & II. COMMAND LINE (D0S). · BUSINESS COMMUNICATION I & II. · APPLIED PSYCHOLOGY. · LOCAL AREA NETWORKS. · PRIN OF ADVERTISING. · ACCOUNTING I & II. · DESKTOP PUBLISHING. · FUND OF ORAL COMMUNICATION. · MS OFFICE/BUS SYS. HUM RESOURCE MNG I. · CO-OP BUSINESS. Visual Basic for Applications. Programming I & II. · Systems Analysis & Design. · Java Programming, Oracle Database, Cisco Networking. · .Net Web Server Programming. JavaScript Programming. · Web Site Development & Management · DreamWeaver. · E-Commerce. · Network Essentials. · TCP/IP Theory. · Adv Pc Trouble-Shooting. · Help Desk Fundamentals. · INTRO NOVELL ADMIN. CISCO NETWORKS INTRO & ADV CISCO NETWORK. WIN NETWORK ADM Completed courses for 2nd Associate's Degree / Programming & 3rd Associate's Degree / Networking (Phi Theta Kappa member.)