Developed 7 Integration Services projects with 72 SSIS Packages and 283 SQL queries to perform data conversion and migration, within 15 hour period, of 130 Million data records into 244 tables from 300 tables in 5 legacy databases. [SQL Server, SSIS(DTS), SQL, Visual Studio]
Created a Report Services project with 5 data sources and 144 simple reports to monitor quality of data migration process. [SQL Server, Report Services, SQL, Visual Studio]
Created management system for ticket printing, distribution, sales and use with full reports for non-profit events. These reports can be viewed and printed via your web browser. [Visual Basic, SQL, DAO, Access, OLE Automation, XML, XSLT, XPath, VBUnit, InstallShield]
Extended report generation capability for the Opinion Survey application to web browsers. Multi-level XML data is generated from the SQL queries. The XSLT Stylesheet is used with XPath functions to transform the XML data into reports with subtotals. The XML data and XSLT Stylesheets have been successfully tested with several web browsers, including IE, Mozilla and Firefox. [Visual Basic 6.0, SQL, Access, XML, XSLT, XPath]
Created utility program to query database and generate reports for web browsers. [VB.NET, .NET Framework, SQL, XML, XSLT, XPath, NUnit]
Developed Opinion Survey management application for non-profit organizations. This tool provides the user interface to design the forms and enter data as well as report on the survey results. [Visual Basic, DAO, SQL, Access, ODBC, SQL Server, Excel, VBA, OLE Automation, VBUnit] This Opinion Survey application includes reports for:
Blank Survey Form.
Counting the results of Yes/No and Multiple-Choice responses.
Mean/Min/Max/Count Statistics of Numeric Value Responses.
Lists all of the text responses.
Search of all text responses.
Created a process to extract data from a legacy source for import into an Excel spreadsheet and transform it for loading into an Access database. [Excel, Excel VBA Macros, Access]
Extracted information from source code and transformed it for loading into database. This helped our team assess and track the elimination of unnecessary third party controls. [Visual Basic, C/C++, DOS Scripting, Access]
Developed Opinion Survey management, design and data entry application for non-profit organizations. This application can also generate reports in an Excel Spreadsheet. [Visual Basic, Access, Excel, Visual Basic for Applications (VBA), SQL, OLE Automation, ODBC, SQL Server]
Worked in small team to create transaction archive and reporting system, that in its first months of service identified 1000 billable transactions. [JAVA, JBuilder, XML, XSL, HTML]
Created management system for ticket distribution, sales and use with full reports for non-profit events. [SQL, Access]
Developed and maintained programs to read and write Electronic Data Interchange ASC-X12 transaction sets (TS150, TS286, TS813, ...). [Visual Basic, SQL, EDI]
Developed Windows and Web-based User Interfaces and Reports. These reports included Applications to register vehicles in multiple states nested within weight categories. [Oracle, Oracle Forms Builder, Oracle Reports Builder, PL/SQL, TOAD, SQL*Plus]
Worked with Team Leader to maintain and develop maps for communication between Oracle database and EDI data. [Mercator]
Developed filter program to auto generate INDEX.HTML for Web based photo browser [C++] View Source
Created a "push button" report generator, to publish
periodic client reports with tables and charts in a few hours instead
of several days. This flexible tool has saved time and money for at
least a dozen product areas. [Access, SQL, OLE/Graph]
Worked with users to create a computer program to interactively
retrieve, edit, analyze and plot large amounts of data. The utility
of this menu driven program was enhanced by it's programmability,
command recording features and data directed input format. [FORTRAN]