Liekar Strategic SolutionsDatabase Consultant
Oct. 1998 - Aug. 2002Greater Pittsburgh AreaExperienced in analyzing, developing, implementing, optimizing, managing and supporting database systems in an extensive array of subject fields. Assignments included: City of Pittsburgh - Developed data validation and manipulation procedures or crime management system. Performed business analysis, designed and developed modules for arrest record expungements and statistical reporting. Imported 13 years of data from mainframe system. Used Oracle 7.3, PL/SQL, including dynamic SQL, Designer 2000, ErWin and SQL Loader. Cellomics - Translated SQL Server application back-end to Oracle for bioinformatics product to create parallel systems. Used SQL Server 7, T-SQL, Oracle 8.0, PL/SQL, ErWin. PNC - Provided Oracle database administration and support to enable Informatica development for bank customer reporting using Oracle 7.3. Management Science Associates - Designed and developed data aggregation and manipulation procedures for SQL Server datamart for retail sales analysis using SQL Server 6.5, T-SQL, ErWin. Respironics - Analysis of converting manufacturing, product sales and registration data from disparate mainframe systems to SAP BW data warehouse. New Jersey State Police - Designed and developed data import, data aggregation and manipulation procedures for web-based internal affairs system using Oracle 8i, PL/SQL, including dynamic SQL, and ErWin. Highmark Life & Casualty Group - PL/SQL development for insurance claims processing application, including data exchange interfaces for imaging and letter writing systems, and data mart for reporting. Used Oracle 8i and 9i, PL/SQL, including dynamic SQL and PL/SQL API to Oracle Internet Directory (LDAP interface).