OBJECTIVE: To utilize my skills and experience with Software Development to build a long-term career with a team oriented company.

SKILLSETS: SQL Server developer and administrator 15 years , with strong T-SQL, SSIS, SSAS, SSRS, stored procedures and performance tuning skills. Full Microsoft BI Stack Including Performance Point Server, VB.Net 5 years , Visual FoxPro developer 15 years , with OO, SQL, COM and large-scale data handling capabilities. Web development 8 years , with ASP.Net, ASP, DHTML, JavaScript, VBScript, PHP, MySQL, CSS, ODBC, ADO.Net, and ADO knowledge. Other related technologies, such as FTP, SMTP, MSMQ, CDO, VBA, XML, XSLT and Web Services. Exposure to all versions of Microsoft Windows Server platforms, IIS, Exchange Server, Terminal Services, Citrix and VPN technologies. Other significant application exposure includes Microsoft Office, Solomon IV Accounting, SBT Accounting, Telemagic CRM, ArcView-Gis, and Visual Studio.Net.

EXPERIENCE:

Confidenital

Data Architect / Senior BI Develop

I performed a comprehensive assessment of their current DW and BI environments. Identified and prioritized platform solution capability improvement opportunities. Focused on the following key areas Relational Data Warehouse logical and physical design and implementation. Reviewed OLAP security, partitioning and aggregation strategy as well as data acquisition and processing strategy, design and implementation SSIS tuning recommendations . Delivered a complete data visualization strategy and platform Cricket DW enhancement high-level roadmap including resourcing recommendations, gaps, solution delivery, and governance recommendations. Gathered information through review of solution code artifacts, available design documents, and discussions with key Technical Architects, Developers and IT Delivery leadership. Arranged input data using capability maturity assessment, combined with my expertise and industry knowledge, to document any gaps between the current state and recommended maturity level. Delivered a complete roadmap of recommended initiatives.

Confidenital

Data Architect / Senior BI Develop

Working for their Segmentation Analytics Director to create a self-serve analysis and list creation tool. The tool sources the Teradata EDW with summary table ETL that populates several SSAS cubes. The tools is used to create lists for the sales field and assist with new product launches. Users are connecting to the SSAS cubes with Tableau, SAS, and extremely customized Excel templates.

Confidenital

Data Architect / Senior BI Develop

Working with their internal IT department on the RPM project. This project will replace their existing TAMSII point-of-sale system with TOMAX for more than six thousand NAPA stores. Heavily involved with requirements and integration mapping between multiple source systems to TOMAX. The source systems included JD Edwards, AS400, DB2, SQL, Oracle, and multiple text files. I also assisted with complex SSIS ETL to convert their existing SQL EDW to Oracle.

Confidenital

Data Architect / Senior BI Develop

Worked for their Enterprise Business Intelligence Director to create a BI COE. Assisting internal IT department with Tableau deployment to business users that perform analysis and prototyping. Expanding Teradata EDW to include new data points and surfacing that data in Micro Strategy dashboards and reports. Working on dotcom unique SKU projects that will insure accurate gross margin reporting.

Confidenital

Data Architect / Senior BI Developer

Working to create a SSRS, PerformancePoint, and SharePoint BI reporting solution for CPC's safety group. Created SharePoint lists to maintain the safety data that was entered into Excel. The SharePoint list allowed for easy data entry, controls and data integrity. Created a SQL database for reporting and codded SSIS packages to populate the SQL database on a nightly load schedule. Created SSRS and PerformancePoint custom dashboards that were deployed to the Safety SharePoint site for management reporting.

Confidenital

Data Architect / Senior BI Developer

Worked with RPC's internal corporate IT department to create an enterprise and end to end data warehouse solution. Performed data modeling using SQL 2012 by creating conceptual and logical data models to aid in creation of final data scheama. Coded SQL 2012 SSIS jobs to populate staging and the final production database. Created a 2012 logging framework using the new deployment model and custom logging combined that is housed in the SSIS catalog and an operations database for easy management and reporting.

Confidenital

Data Architect / Senior BI Developer

• Worked with GCPS's internal information management team to create an operational data store. This was to get all data off the mainframe and into the ODS.
• Helped create security policies, master data, and rewrote CRUD applications to source from the ODS. Ported DB2 EDW code to SQL 2008 and ported Data Manager code to
• SSIS. The SSIS jobs utilized an operations database for logging, tracking, and management purposes. Created SSRS reports to replace Cognos, Crystal, and Access reports for multiple datasets.

Confidenital

Data Architect / Senior BI Developer

Worked with the Worldwide group to create Partner Management Framework PMF web facing dashboard to provide management with Partner statistics and tools for worldwide to manage Partners. Performed database architecture and modeling of database for Microsoft's integrated reporting initiative. Analyzed multiple data sources to define a single data model. Authored code to handle the transformations necessary to derive correct dimensional taxonomy and business rules for accurate reporting. Created SSIS Jos to pull data from multiple sources into PMF's data warehouse.

Confidenital

Data Architect / Senior BI Developer

Working with a Microsoft gold partner to architect and implement a Performance Point Planning Server application. This custom application ,handles billing, revenue and adjustment schedules for several revenue types ,with many lines of business via customized Performance Point models. I created custom InfoPath forms to enter parameters, PPS Excel reports to review the results, and custom web parts to run SSIS ETL packages to load the ,PPS models for dynamic results. I architected a relational database, wrote several custom SSIS ETL packages and scripts to consolidate MSCRM and Solomon data. I published all forms and the custom web parts to a branded ,SharePoint Site for internet delivery. The ABS system is utilized to manage ,contracts for all lines of business and key forecasting worldwide.

Confidenital

Data Architect / Senior BI Developer

Working with Microsoft Worldwide to build a Performance Point Server hosted on the Windows 2003 Server platform. Installed all software and built the backend data models utilizing SSAS. I configured KPI's, Reports, and Scorecards for use in the custom SCMDM dashboard with the PPS Dashboard Designer. I published all dashboards to a customized SharePoint Site for internet delivery. I branded the site with SharePoint Designer. The MDM Targeting Tool is used by the Microsoft sales staff to locate low hanging fruit in the mobile device markets worldwide.

Confidenital

Data Architect / Senior BI Developer

Worked with a Microsoft Gold Partner to build a proof of concept Performance Point Server hosted on the Windows 2003 Server platform. Installed all software and built the backend data models utilizing the PPS Data Modeler. Setup custom security and created Excel templates for writing data back to the models. I configured KPI's, Reports, and Scorecards for use in custom dashboards with the PPS Dashboard Designer. I published all Dashboards and Excel templates to a customized SharePoint Site for internet delivery and document management.

Confidenital

Data Architect / Senior BI Developer

Worked with Magellan's internal corporate IT to create and modify their existing internal claims snowflake schema to accommodate external claims. Coded SSIS ETL packages to load the schema, track errors and audit each process. Created cubes and dimensions in SSAS based on the logical data model. Designed SQL Reporting Services dashboards and reports to provide management with company metrics

Confidenital

Data Architect / Senior BI Developer

Worked with Post's internal corporate IT to create SQL Reporting Services dashboards and reports to provide management with company metrics. Authored MDX queries to pull data from Analysis Services cubes into temp tables for efficient reporting architecture. Created Data Warehouse model with the cubes and dimensions in SSAS based on the logical data model. Trained Post IT staff on Reporting Services, SSAS, and SSIS for maintaining the ETL and supporting future reporting development.

Confidenital

Senior Software Developer

Worked with the Worldwide group to create a SQL Reporting Services dashboard to provide management with C C Sweet Spot statistics for worldwide software licenses. Performed database architecture and modeling of software license from sales database for Microsoft's integrated reporting initiative. Analyzed multiple data sources to define a single data model. Authored code to handle the transformations necessary to derive correct dimensional taxonomy and business rules for accurate reporting.

Confidenital

Senior Software Developer

Worked with the US-EPG group to create SQL Reporting Services dashboard to provide management with the real-time results of quota to revenue for sales regions and industries. Performed database architecture and modeling sales and marketing reporting database for Microsoft's integrated reporting initiative. Analyzed multiple data sources to define a single data model and the transformations necessary to derive correct dimensional taxonomy. Created and maintained complex data feeds from multiple backend data sources utilizing SQL Server Integration Services. Automated and secluded the SSIS packages to effectively manage the Development, QA, and Production servers. Produced SDLC documentation and assisted Microsoft IT with the on-boarding of the dashboard to a Silver Certified Application.

Confidenital

Senior Software Developer

Developed a system to modernize the delivery and storage of internal documents. Convert existing Incident Report forms from MS Word to Web forms. The new forms leveraged a combination of InfoPath, Windows Workflow, SharePoint 2007, and SQL Server 2005 to create, route, approve, and catalog the new Incident Reports.

Confidenital

Senior Software Developer

• Assigned to Siemens AMD Division, Atlanta Georgia to expanding their POS data capture and reporting systems. I was the primary consultant assigned to the project by Blackstone Cullen.
• Phase 1, Responsible for migrating POS data from Microsoft Access to SQL Server with SQL Reporting Services. I scoped and designed the new SQL database. Wrote DTS packages and extended stored procedures to cleanse, tune, maintain integrity and migrated all data during the conversion process. I setup and maintained SQL Reporting Services including training employees on report creation and publishing. Built and maintained user interface in VB.Net to maintain user tables, query data for analysis, and handed business rules.
• Phase 2, Responsible for assisting Siemens corporate IT on project business case, requirements, coding, and documentation needed to migrate POS data from SQL Server to Siemens Oracle data warehouse. I created and managed the UAT testing. We transitioned 65 Distributors from emailing data submissions to FTP their data submissions. Trained report writers in Business Objects as well as creating the needed universes and reports to aid in making critical business decisions. Reengineered the VB.Net user interface to utilize ODBC connections to Siemens backend Oracle data warehouse.

Confidenital

Developer Project coordinator

• Primary in-house developer in the deployment of new web-based business system written in ASP/ASP.net, VB Script/VB.Net, and Java Script utilizing SQL Server as our database. I was the team lead for technical support, enhancement, and maintenance of this system named Indeavor. Designed and implemented a richer user experience through advanced DHTML, CSS and JavaScript techniques. Act as primary SQL database administrator. Responsible for database design and maintenance including performance and optimization tuning. I create SQL extended stored procedures and user defined functions. Used T-SQL and ADO to access SQL database tables for presentation in ASP/ASP.Net WebPages. Created and modified a robust reporting layer utilizing Crystal Reports.
• Perform duties of Webmaster supporting and modifying the company's Website. Implement marketing campaigns utilizing web forms to collect and manipulate data in SQL tables. Created robust emails utilizing HTML, XHTML, DHTML, CSS, VB.Net, JavaScript and ASP.Net to drive customers to our website. Established and maintain an Intranet and Extranet containing technical documentation, schemas, reports, and charts using XML/XSLT and HTML. Act as project coordinator between the marketing and Technical departments to streamline requested enhancements and deployment of those enhancements for Indeavor, CRM and the company's Website.
• We are currently rewriting our ASP web-based business system in ASP.Net and VB.Net. I was responsible for managing the end of life cycle of our current ASP application and a smooth transition into the ASP.Net and VB.Net version.
• Responsible for development, technical support, enhancement, and maintenance of the legacy custom Visual FoxPro applications, SBT, and TeleMagic. I acted as the lead developer in the upgrade of all legacy Visual FoxPro applications to VFP 8 9. This migration path also included program enhancements to leverage the new features available in VFP 8 9.

Confidenital

On-site Consultant Technical Services Representative

Provided on-site software consulting for the installations, upgrades, and troubleshooting for all versions of TeleMagic Software, SQL Server and other customer FoxPro applications. Served as trainer both on-site and in house on all products. Other duties were to provide technical support for these windows and database applications. Acted as the primary Windows NT 4 administrator for the company.

Confidenital

Marketer Level 2 System Administrator

Personal sales results and team leadership skills lead to being promoted to Marketer Level 2. Acted as the primary Novell 3.12 and 4.0 system administrator responsible for setting up Novell networks in five separate installations. Performed database backups, restores, and reporting system wide. Balanced sales responsibilities with computer tasks, as they were assigned. Established security methods to protect company information and prohibit non-productive uses of equipment. Trained facility managers and users on various network applications and security procedures. Configured and personally wired all connecting cables and hubs for systems, allowing for growth and flexibility as needed.

Confidenital

Quality Control

Promoted from marketing position to quality control position in 7 million dollar marketing center. Responsibilities included auditing sales, data entry, coaching and training of new hires. Other duties were to motivate and perform reports for each of the regional teams.