Qualifications Summary: Over twenty years Information Technology experience: applying systems solutions in the financial, manufacturing , and medical industries. A result oriented individual with proven ability to develop and enhance effective software and reporting programs and provide documentation for those programs. Experience includes Client Server and Mainframe environments. Skills Summary: SQL 2008 stored procedures, views, DTS, ETL, SSIS, and SSRS. Aqua Data, Crystal XI, Business Objects, Visual Basic 6.0, Visual FoxPro 8.0, Access including database, procedures, data entry screens, and reports. Business Objects Universes and Xcelsius dashboards. Qlikview data extracts, transforms, data models and dashboards. I also have experience using Visual Source Safe, TFS, and SVN source control applications. Experience: Confidential Sr. Data Research Analyst In my role at Nemours as a Research and Reporting Analyst I consult with internal customers. I write data queries from our Oracle and SQL Server databases for reporting in either Crystal Reports, SSRS, or Qlikview. I create SSIS packages, stored procedures, and views in our SQL Server databases. My role with Qlikview is to create data extracts, data transformations, data models, and front end dashboards. Our main data sources are Epic Clarity and Lawon.

Confidential Business Intelligence Developer I wrote complex stored procedures in SQL for Crystal XI and 2008, Microsoft Reporting Services and Access reports. I created views, functions, and DTS in SQL Server 2005. Business Objects: Universes, Xcelsius, Web Intelligence, Crystal XI, Crystal 2008. I published Crystal reports to Business Objects Central Management Console. I worked with the Business Unit to define requirements for all enterprise reporting. I am now working with Crystal 2008 and Business Objects 3.1 new features that include universes as a data source and Xcelsius dashboard features connected to Crystal 2008 with SQL stored procedures as the data source. I was also the Enterprise Reporting Release Manager. Confidential Systems Analyst Define requirements, modify and enhance Sage Pro based on Company and user requirements. Sage Pro is a Sage Software ERP written in Visual Fox-Pro. Perform analysis, design, and project management. Confidential Information Analyst Generation of Mortgage industry reports utilizing SQL Server 2000 and Microsoft SQL Reporting Services. Perform data analysis, ETL, DTS, report design and deployment. Confidential Senior Developer, Analyst, Project Manager Registration and Housing Application: Coordinate and manage software development efforts for client meetings. Work with internal staff and external clients to gather requirements for programming and reporting needs. Maintain, enhance, and create new features of our custom application utilizing Visual Basic, Visual FoxPro, C/C , SQL, and Crystal. SQL 2000: DTS client data from text and, or excel to SQL databases. Define database structures, indexes, performance tuning, backup and restore, create and test stored procedures, triggers, user functions, and user data types. Write registration, housing, and financial reports for meetings accessed internally and from the web. Generate DTS packages to provide scheduled data to clients. Mentor development staff, project management, web design data interface and stored procedures. Provide initial and updated documentation for requirements, systems, and training. Saleslogix and Great Plains: Work with the Sales and Marketing and Financial departments to define requirements for custom reporting needs. Write and test stored procedures to generate Crystal reports for the Sales and Marketing and Financial departments. Event Guide: Write and test stored procedures to generate reports via SQL Reporting Services for our custom Event Guide application. Confidential Software Engineer Advanced Allocations: Design and development team leader for Advanced Allocations software. Wrote code to interface our software to Great Plains Dynamics, Solomon, Epicore, and an open integration for other ERP software. Participate in requirements gathering with upper level Management and Marketing to define version enhancements. Database table design, stored procedures, and triggers in SQL. I wrote VB6 code following defined standards, worked with core development team to implement application requirements using core components, and worked closely with QA staff for testing and modifications. Provide initial and updated documentation for requirements, systems, and training. Confidential Senior Programmer Analyst Solomon Certified Application Developer: As a certified Solomon Application Developer I met with new and existing clients to define their software requirements. I developed prototypes, wrote and test software enhancements and added modules to Solomon in Visual Basic 3.0, VBA script, and Solomon proprietary controls to look, feel, and function like Solomon Software. I wrote code in Access and RPG for clients to enable their custom software to be interfaced to Solomon. Database table design, procedures, and functions in Pervasive Btrieve SQL. I wrote all reports for our custom modules and custom Solomon reports in R R report writer, FRX Reports, and Crystal reports depending on the version of Solomon and the Client Requirements. I performed extensive testing, documentation, implementation, training, and support. Confidential Programmer Analyst Utilizing Visual Basic version 3.0, Sybase T-SQL, and SQR I was a part of multiple development teams to replace all Agency legacy applications COBOL, C/C , and Paradox with one new and robust application called written in VB3 and T-SQL. I attended and led RAD/JAD sessions, worked within module teams to design, write, test, implement, train, and support the application. I wrote data conversion programs utilizing SQR and wrote reports for all application modules in SQR. Provide initial and updated documentation for requirements, systems, and training. Develop test plans and kiosk training materials. Confidential Contract Part Time Access Developer: Design Access database tables, procedures, and reports for their Medical equipment inspection, repair, and preventative maintenance software. Mainframe Programmer Analyst I was a Programmer Analyst in the tire COBOL and steel industries XBMS . Confidential BOU310 SAP Business Objects Universe Designer XI 3.0/3.1 Solomon Certified Applications Developer SCAD Various Microsoft courses at Microsoft Certified Education Centers including Visual Basic and SQL Server