John O.

## BIO **Proficiencies** **                                    Database Concepts:** Logical and Physical Data Modeling, Normalization, ERD, OLAP Cubes, Data Warehousing, ETL, Performance Tuning, Clustering, Federation, Partitioning, VLDB **                                    Databases: ** Microsoft SQL Server, Oracle, PostgreSQL, MySQL, Microsoft Access, MSDE**                       ** **                                   ** **                                    Languages:  **SQL, T-SQL, PL/SQL, C#, VB.NET, Java/J2EE, C/C++, ASP, JSP, Shell Programming, UML, Perl, HTML,COBOL, JavaScript, XML**     ** **                                   ** **Experience  ** <u>Software Developer/Database Architect – Datapros for Healthcare </u> Tampa, FL     August 2003 to September 2004 Consultant, October 2004 to Present on Staff ·        Design and develop relational database used for cleaning and analyzing purchasing data utilized in hospital materials systems ·        Design and write algorithms to cross-reference client data with known clean data ·        Author applications used by clinicians and analysts to verify and correct data ·        Develop extract-transform-load (ETL) routines to migrate data from hospitals into our systems (Lawson, etc.)  ·        Create applications to collect data from vendors and manufacturers ·        Train staff in the use of SQL ·        Performance tune system (profile queries, optimize query plans, etc.) **                                   ** <u>Data Architect/System Developer, Revenue Management Solutions</u> **                                   ** Tampa, FL     July 2002 to September 2004 ·        Design database schemas for applications requiring multi-terabyte databases ·        Design OLAP cubes to perform complicated statistical tasks ·        Performed extensive financial and statistical analysis using SQL and OLAP cubes ·        Develop data processing routines for Oracle and Microsoft SQL Server ·        Program reporting applications to produce sophisticated economic reports ·        Design and develop multi-tier web applications using ASP.NET,  Microsoft SQL, and Oracle ·        Design and develop Windows Forms applications using .NET and MSDE ·        Transition development staff to .NET and object oriented programming ·        Write UNIX shell programs to assist in data retrieval and data processing ·        Provide technical leadership for the development staff ·        Research and recommended new technologies to assist in business processes ·        Train analysts in the use of SQL                                     <u>Software Engineer Co-Op, Cisco Systems</u> San Jose, CA            June 2000 to January 2002 ·        Design and implement a web-based project tracking system using JavaServer Pages (JSP) and a relational database management system   ·        Design database to track project lifecycle and other department information.  ·        Author shell programs to facilitate engineering tasks ·        Produce web-based tools to securely distribute files ·        Create systems to make existing tools universally available throughout the organization **                                   ** <u>Systems Administrator, Production Test Services</u> Portland, OR  August 1999 to May 2000 ·        Design and construct networking systems to assist communication and provide an online presence  ·       ## Area of Expertise **                                    Database Concepts:** Logical and Physical Data Modeling, Normalization, ERD, OLAP Cubes, Data Warehousing, ETL, Performance Tuning, Clustering, Federation, Partitioning, VLDB **                                    Databases: ** Microsoft SQL Server, Oracle, PostgreSQL, MySQL, Microsoft Access, MSDE**                       ** **                                   ** **                                    Languages:  **SQL, T-SQL, PL/SQL, C#, VB.NET, Java/J2EE, C/C++, ASP, JSP, Shell Programming, UML, Perl, HTML,COBOL, JavaScript, XML