Julie Knapp Email and Phone Number

Re-engineered and re-coded SQL Server database structures and stored procedures of legacy financial reporting system to streamline the process, increase speed, and improve maintainability.

Translated metrics of a federal grant studying high school graduation and dropout rates into SQL Server stored procedures and documented methodology used in calculations. Created a suite of Reporting Services (SSRS) Reports displaying various enrollment, attendance, and grade point average metrics after interviewing stake holders for business requirements. Analyzed schema changes when transactional database system switched to new vendor. Documented and coded necessary modifications to existing SQL Server Integration Services (SSIS) packages that populate the data warehouse.

Designed plan for splitting data sources (necessitated by partial company purchase) at the data import level; thus, all down-stream reports remained unaffected.Interviewed users to create Business Requirement Documents; created necessary queries for implementation of solutions and oversaw transition to production, including testing Essbase Hyperion cubes.

Designed and coded client data reporting database system with SQL Server that included stored procedures and Distributed Transaction Service (DTS) packages to transform the data and calculate portfolio performance measurements, such as monthly, quarterly, annualized returns and dispersion statistics, reducing client-facing numerical errors from several per reporting period to zero.Conceptualized and created Visual Basic application for corporate officers that generates Excel reports with revenue data aggregated by multiple categories and views.Produced SQL Server Integration Service (SSIS) packages to transform data between database schemas and create a data mart.Developed Analysis Services cube that calculated total invested amount and average monthly, quarterly, and annual returns across several categories.Trouble-shot system problems with proprietary portfolio management and trading software within tight time constraints.Analyzed database problems and developed solutions under the guidelines of Agile Development and Scrum methodologies.Spearheaded impromptu teams as needed to address system problems and create process solutions that crossed departmental boundaries while ensuring buy-in from all stake holders.Mined data for portfolio performance statistics with ad-hoc queries as requested by management.

Interfaced with marketing, business development, and web design units to create specifications for two database systems; the first a transactional database that accepts patient test results and medical white paper data via a web user interface, the other optimized to determine and display the best medical treatment for the patient's specific health issue.Led team of SQL database developers responsible for the design of above database schemas and the coding of stored procedures, views, and other objects with SQL Server 2000.Designed and coded automated Distributed Transaction Services (DTS) packages that transform data between database systems; maintained documentation of data flow changes.Directed the implementation of new HIPAA (Health Insurance Portability and Accountability Act) standards of data integrity in the database schema.

Created system of DTS packages to import state-specific public loan data into a single SQL Server database schema. Re-wrote stored procedures, decreasing data retrieval times by at least 75%. Initiated and coded self-explanatory Visual Basic application that empowered clerical personnel to perform DTS uploads, trouble-shoot data problems, and create data reports without technical support.Microsoft

Created software and data reporting applications using ASP, HTML, Access and/or Visual Basic for a wide variety of industries (financial companies, light manufacturing facilities, web design houses) after interviewing the stake holders to determine business needs. Wrote support documentation for applications.

Developed batch processes using SQL Server scripts and stored procedures to capture and transform data acquired from customer support database systems. Trouble-shot and engineered solutions for data and performance problems experienced by world-wide Microsoft product support specialists. Produced ad-hoc SQL queries to provide management with support request statistics.

Coded Macintosh applications that interface with hearing test measurement instrumentation. Performed various mathematical transformations on the data, like Fourier Transforms, and displayed the data in graphical form such as audiograms and tympanograms.

Designed, documented and coded the client-side I/O system for an Intel multi-processor distributed real-time operating system, using a C-like proprietary programming language. Invented buffering scheme that increased data retrieval speed by more than 50% compared to the previous I/O system.Participated in all phases of development cycle; design, coding, test, and customer support. Led test team for embedded system software products that ran on a new generation of Intel processors.