Last update 2009.09.02
Professional Summary:
- 10 years in the IT domain focused on delivering Business Intelligence analysis tools.
- Proven talent in Database Analysis, Reporting, Development and common Administration tasks
- Skilled in SQL 2005/2008 Business Intelligence tools, Data Warehousing and ETL processes.
- Implemented Microsoft Dynamics CRM 4.0 for multiple clients (Installation, Configuration, Customization, Deployment, Training)
Technical Summary:
Business Intelligence:
- Ability to deliver comprehensive BI through MS solutions including MS Excel, Microsoft Office Sharepoint Server (MOSS), and PerformancePoint Server 2007
- Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
- Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
- Advanced extensible reporting skills using SQL Server Reporting Services (SSRS)
Microsoft Dynamics CRM 4.0
- Certified Business Management Solutions Specialist: Applications, Installation and Deployment, Customization and Configuration
Professional Experience:
SharePoint360.com (March 2009 » Present)
Solutions Architect
- Identify client needs and propose solutions using Microsoft Business Productivity Platform
- Participating in Microsoft’s Technology Adoption Program on the next versions of SQL Server, Office 2010, and Sharepoint 2010
- Implemented Microsoft Dynamics CRM 4.0 internally and for parent company
- Provide architecture and consulting services for Business Intelligence and Microsoft Dynamics CRM 4.0 projects
ProfitLine Inc. (June 2008 » March 2009)
Senior SQL Server Business Intelligence Developer
- Responsible for all ETL operations within the Engineering group including client feeds, warehouse loads, and data extraction.
- Manage a team of database developers to support the Business Intelligence and data services needs of the enterprise.
- Work directly with clients on new implimentations of our software platform.
- Actively engage in design discussions for all Business Intelligence and database initiatives.
LPL Financial (July 2007 » June 2008)
SQL Server Business Intelligence Developer
- Lead team on Business Intelligence efforts by providing real world training exercises and demonstrations
- Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
- Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
- Architect faux data mart solutions to improve performance of SQL Server 2005 Reporting Services (SSRS)
Stratagene (Feb 2007 » July 2007)
SQL Server Business Intelligence Developer
- Provide SQL Server 2000 Data Warehousing (OLAP) support and upgrade plan
- Design and execute SQL Server 2000 – SQL Server 2005 upgrade plan
- Integrate custom .Net assemblies into Reporting Services Reports for outside the box solutions
- Use SSIS to perform ETL operations for Master Data Management (MDM) needs as well as auditing reasons
Thomson Learning (NETg) (Nov 2005 » Dec 2006)
SQL Server Database / Busines Intelligence Developer
- Interface with business to gather Business Intelligence requirements
- Administer OLTP and OLAP SQL Servers
- Develop Oracle PL/SQL stored procedures for Decision Support System to assign sales territories to new leads
- Architect and execute Business Intelligence solutions including ETL, OLAP, and Reporting requirements
- Manage migration from Crystal Reports to SQL Server 2005 Reporting Services (SSRS)
ICE Enterprises (May 2004 » Nov 2005)
SQL Server Busines Intelligence Developer
- Install, configure, and develop SQL Server 2000 Reporting Services (SSRS)
- Advanced reporting techniques included time series trend analysis, de-normalization of data and linear regression
- OLTP T-SQL development support for cruise booking software
- Custom ETL solutions using T-SQL stored procedures schedules as jobs.
- Perform migration from Crystal Reports to SQL Server 2000 Reporting Services (SSRS)
SQL Server Business Intelligence Analyst
- Create Busines Intelligence solutions including Executive Dashboards and Business Scorecards with MS Excel
- Perform ETL operations for Business Intelligence reporting solutions using custom VBA and Excel web queries
- Create ad-hoc queries from SQL Server databases for custom reporting needs
MCI Communications (Apr 2000 » May 2004)
SQL Server Developer
- Developed custom online reporting solution using classic ASP and SQL Server 2000
- Administer local SQL Server 2000 for custom reporting app.
- Develop custom T-SQL stored procedures to perform ETL operations
Third Party Verification Specialist
- Research sales issues by doing ad-hoc queries in Oracle 8i and SQL Server 2000 databases
- Developed website for all communication to local inbound sales reps using classic ASP and SQL Server 2000
- Act as a liason between national support organizations and local call center management
Helpdesk Administrator
- First level support for all system issues including PC, Telephony, and LAN issues
- Troubleshoot desktop PC issues and resolve by replacing hardware or re-imaging the PC
- Nightly maintenance of local servers (backups to tape, batch jobs, etc.)
- Perform basic SQL Server 2000 administration tasks including security access, backups and restores.
Education:
University of Phoenix (current)
- Completing Bachelor of Science in IT with a focus on Software Engineering.
- Planning on continuing to MBA program.
Maricopa County Community Colleges
- General educational requirements plus some basic programming language courses (VB6, Classic ASP)
- Focused on math and programming classes for CIS Associates Degree (Database Fundamentals, Oracle PLSQL)