Summary

• Career Since becoming a programmer in 1992 I have worked primarily with Microsoft
• Objective SQLServer, ASP.NET/C , with Oracle/Java/JQuery. My multi-industry experience has given me the ability to work on various sized projects and take on various roles. I would like to continue using my Programming, SQL, Management and Project Leadership skills. My varied background would be an asset to your organization.

Work Summary

Confidential

History Helped document and maintain existing Data Warehouse system. Data Warehouse system consisted of SSAS/SSIS and Oracle backend databases. The documentation was on Sharepoint 2012 Wiki List, expression Encoder, and ASP.net pages. The maintenance was adding data permanency to SSIS packages,adding in new fields to cubes, adding additional business logic.

Confidential

BI/Web Architect

I collected data from WuFoo, Ziprecruiter, AWS-AmazonSimpleDB, unsolicted email and other sources to a SqlServer 2012 database. I wrote all ETL with SSIS to move data into Staging and Relational then DataWarehousing tables. I also wrote a complete web front end to browse and data mine the data. Many data warehousing concepts used. The front end was built with ASP.net, C , Ajax, Java, Spring, JQuery, PHP and JavaScript. The purpose of the front end was to enable a time dashboard, a data mining query, and a details view of the data. Reports were done in Webpages, Excel, and SSRS. Submitted regular progress reports to Management.

Confidential

BI/Database Architect

Worked for companies as OfficeMax, Millenium Trust, Ulta. I primarily used SqlServer 2012 and the Microsoft BI stack with GreenSQL. I created databases, SSIS packages, SSAS, SSRS, SharePoint 2013, ASP.net pages, CSS, jQuery, Java and cubes with MDX to facilitate all aspects of data mining. These BI reports were for forecasting, accounting, and intelligent systems. Upgraded existing DTS packages to SSIS. I designed ETL for PROLAW legal database and AWS-SqlServer. PowerShell scripts and WCF were used to monitor server properties and Users in Active directory. I provided Web Services for various other applications. I led all project management using an Agile Scrum methodology. I created auditing methods for these new systems that I created. I added in additional SqlServer security with more sophisticated roles for logins. I architected the system from front end .Net to backend SqlServer. GreenSQL was used to mask various data. Data permanency was placed in the new SSIS packages. Job dependencies were mapped out using Visio. SSIS script code was in C .

Confidential

BI/Web Developer

• Created data warehouse reporting system with SqlServer 2008 backend and Web
• front end. I used jQuery, SSRS and C primary for the front end. Helped maintain existing front end system using ASP.net. Did business analyst using an Agile Scrum methodology to deploy business logic to an interactive Web front end.

Confidential

MSAccess Developer

Upgraded an Excel sheet retail spending sheet to a data mining system in MSAccess. The original system used SPSS and SAS downloads to Excel. I created a new database using MSAccess and MySql. I also created numerous queries to extract and manipulate the data. The Excel front end used VBScript ADO to import the new MSAccess data.

Confidential

Helped maintain existing data warehouse and wrote ASP.net with VB/C .net. Integrated web pages and BI tools to SharePoint 2010. Primarily took existing SQLServer 2000 DTS packages and converted them to SQLServer 2008 SSIS/SSRS/SSAS. The new SSIS packages had to be modified to incorporate things like data persistency, and job dependencies. New SSIS and maintained old SSIS/DTS packages had to be created to handle new Cubes/MDX reporting. Performed various DBA duties like Powershell scripting to automate Sql Agent jobs and permissions.

Confidential

Created a new Data Warehouse system. I was given 21 reporting assignments and told to create a new data warehouse system to complete them. The backend was SQLServer 2008. I created many new tables, indexes and stored procedures. The data flow was completed using SSIS. Data flowed from SQLServer, Oracle 10, Omniture, Dart for Publishers, SAS, SPSS and metadata. The reports were completed using Excel/PowerPivot, SSRS, OBIEE, Oracle Forms, and SSAS Cubes on SharePoint 2010. The front end webpage's and dashboard ran off of customized ASP.net, VB/C .net, Web Services, and JavaScript. I architected the system from front end .Net to backend SqlServer with any 3rd party tools. Personally setup Security with user logins and roles. I had to create status reports and give presentation to upper management. Regular DBA duties were adding users to security roles. I created a framework to manage roles and security of users. Database backup strategies and SSIS package backup strategies. Configuring Windows 2008 IIS virtual directories and providing various methods to monitor the system. Presentations included what was completed, how many hours per report were left and most importantly what possibilities were available. I used an Agile Scrum methodology.

Confidential

I worked for companies like CapGemini, CFA Institute, RedBox, DigitalLife. Put together real time product recommendation engine. The engine was written with SQLServer 2008, Analysis Services, OBIEE, SSRS, XML, Cach ,. This engine was integrated into a main ASP.net front end integrated into SharePoint with SSRS, Java and VB/C .net. I helped maintain the existing Data warehouse by providing experience in design, optimization, and query performance. I created data warehousing objects for reports and SSAS. Worked with a system that had over 1.4 million transactions a day. I architected the system from front end .Net to backend SqlServer with any 3rd party tools. Wrote code in Used SQLServer 2005 with due regard to a possible future upgrade in 2008. Built SSIS objects to move data.

Confidential

Worked for such companies as Oce, Amatore Associates, and Bank Financial.

Documented and modified existing systems written in SQLServer 2000 and Oracle. Documented over 167 DTS packages. Documentation consisted of Excel and Visio drawings highlighting job dependencies. Also did Database maintenance by adding fields, altering Stored Procedures, Indexes, and DTS Packages. Created a Case Management system. The system had a SQLServer 2005 backend and an ASP 2.0 front end reports were done with SSRS. The primary components of the system were data entry, reporting and database. I created the entire backend with tables, indexes, and stored procedures. Everything was new development. Analyzed existing systems written in SQLServer 2000. Took time and resource measurements on existing queries. Gave recommendations to improve existing query performance by using Stored Procedures, Indexes and improved query syntax. Analyzed SQL Server setup and made server performance recommendations.

Confidential

Wrote management reports, project plans, project documentation, project status reports and

performed database maintenance. Worked mainly with Microsoft SQLServer 2000/2005, Excel, VBScript, and DTS/SSIS. Wrote many SQLServer queries, Stored Procedures, Indexes, Fact Tables OLAP , ETL via VBScript, OLAP, OLTP and DTS. Used MSExcel and VBScript to audit data. Used SQL Reporting Services and Excel for reporting. Worked with Microsoft Project, Excel and Flow Connectors to help manage and then document projects. SQLServer Scheduler was used to automate the project. QRM's Transaction Data Mart was used to structure the entire project. Also used Oracle 9.2 PL/SQL TOAD, Sybase and MSAccess 2003 databases. Created and help maintain Data Warehouses. Designed Cubes using MSAS. Used MDX to create calculated members. Used ASP.net VB/C .net as the dashboard for the front end.

Confidential

Tried writing various strategy and mind games using DirectX and Visual C . Achieved some success but was hampered by game AI. Still working on some of the parts part-time. Did not expect much in monetary rewards.

Confidential

Created OLAP cubes for the Finance department. Using SQL 2000, MSAS, VB.NET, MDX and DTS as primary tools. Most of the data warehouse data was in SQLServer. The data warehouse meta data came from SQLServer, Excel, Lotus Notes, and MSAccess 2000. Most schemas for dimensions were star schema. Various tables, indexes, stored procedures had to be created. Various Data Warehouses were queried. Reports were done in Crystal Reports and SQLServer Report Services. Did Excel pivot tables and documentation.