SUMMARY:

Reporting Analyst / Business Intelligence Analyst / SQL Server Developer / Web Developer with a solid background in reporting and report automation, development and support, data retrieval, reconciliation, manipulation, cleansing, conversion and presentation with numerous transactional database types, dimensional data marts/warehouses and SSAS cubes.

SKILL:

SQL Server 2000/2005/2008 R2 (SSRS, SSIS, SSAS (MDX/OLAP), T - SQL, stored procedures, DTS packages, Dundas Dashboard components), Data Cleansing, Data Mapping, VB.Net, Mobile device application development, VBScript, ASP, HTML, Photoshop, MS-Office with VBA, MS-Office web components, Dashboard development, .Net Web development, Power Pivot.

PROFESSIONAL EXPERIENCE:

MSSQL ETL Developer

Confidential

Responsibilities:

• MS-SSIS package development for data extraction, transformation and loading to Kimball design data warehouse from multiple health care management systems.
• Data analysis, verification and cleansing
• Stored procedures, SQL Scripts, C#, Excel, SSRS, SSIS

Senior Reporting Analyst

Confidential

Responsibilities:

• Report creation automation and administration, complex dashboard design using SSRS, SSIS and Dundas presentation products, Excel, Power Pivot.
• Primary data sources - TS-Pivotal CRM system, Genesys CTI system.
• Stored procedure development.
• Research and development of MS Power Pivot templates for self-serve reporting

Business Intelligence Developer

Confidential

Responsibilities:

• Created ETL system using SSIS to move large quantities of data from SQL Server to DB2 Financials database (Artesia) after merger of new company into Chesapeake.
• Created data mart (based on Kimball data warehouse techniques), ETL (including slowly changing dimensions and error tracking), Cube and reports to bring together land lease and accounting data from Artesia (DB2), Oracle Data Warehouse, MS-SQL Server, Web Services, Excel Spreadsheets and flat files to create a cube (SSAS) for reporting (SSRS) purposes. Created reports from cube using SSRS. Ad-hoc report development.
• Created cube for financial reporting purposes and reports (SSRS) from DB2 system. Hyperion IR/Dashboard development

Business Intelligence Developer

Confidential

Responsibilities:

• Contractor working on development of Business Intelligence portal/dashboard to support accounting and inventory decision making for Geophysical Research Corporation, Tulsa OK, a manufacturer of Oil research gauges. Toolset includes SQL Server 2005, SSRS, BIDS, VB.net, against a large DB2 database using Pervasive SQL.
• Contractor working on development of Business Intelligence portal/dashboard to support rapid high level decision making for ORSNASCO, a large wholesaler based in Tulsa, OK. Toolset includes SQL Server 2005, BIDS, VB.net, C#, SSRS, SSAS (including MDX programming), and Dundas chart and map presentation products. System was built using primarily MDX query development within SSRS, plus creation of calculated members within the OLAP cubes.

Infrastructure Analyst/Web Developer

Confidential, Sacramento, CA

Responsibilities:

• Sole developer of .Net web application to allow duplication of removable media in a central location (communicate with CD/DVD duplication device over intranet), to store said data for retrieval, to track and report on media duplication requests (SQL Server/SQL Reporting Services).
• Automation of weekly/monthly reports using MS-SQL Reporting Services.
• Sole developer of .Net Pocket PC/Web/SQL Server integrated application to allow in the field health care data input for Oklahoma Health Care Authority, transmission of data to SQL Server, and website for data analysis, editing and reports (SQL Reporting Services).
• Design and automation of technical analysis/reports using (or developing) appropriate reporting tools and delivery systems, (Crystal Reports, SQL Server, SQL Reporting Services, VBA, ASP, Visual Basic, Office Web components and MS-Office components)
• Development of complex SQL statements and stored procedures to extract, transform and load data from diverse sources (SQL Server, Sybase, Flat Files, MS Access)
• Intranet data driven website development (complete design and implementation from requirements analysis to world wide rollout) using JavaScript, VBScript, ASP, Visual Studio, Photoshop, SQL Queries, Stored Procedures and DTS packages (SQL Server), Office Web components, ADO, SQL Reporting Services
• Development and implementation of data load procedures to import data from mainframe applications, Excel spreadsheets, MS-Access, Oracle and other sources to SQL Server
• Formulation of ad-hoc queries to provide on demand technical analysis and reports
• Ensure integrity and accuracy of data through development of validation systems
• Monitoring and supporting the execution of recurring reports and SQL server jobs
• Sole researcher and developer of systems to automate the production, delivery and presentation of hundreds of charts that provide essential information to monitor and improve Confidential ' performance using Office Web Components, Excel, SQL Server DTS packages.

Business Systems Analyst

Confidential, Sacramento, CA

Responsibilities:

• Report automation with Remedy, Crystal Reports, SQL, VBA, Visual Basic and MS-Office components, database development, technical writing, report analysis & development.
• Development of complex SQL statements and stored procedures to extract, transform and load data from diverse sources (SQL Server, Sybase, Flat Files, MS Access)
• Established reporting standards for Calgary, Alberta and Napa, California locations.
• Conversion of Perl scripts to various Microsoft technologies
• Crystal Reports Development (including creating user defined functions)
• Service Level contract analysis
• Administration of reporting servers
• Training of junior personnel in report development techniques and practices

Programmer /Analyst

Confidential

Responsibilities:

• Report automation with Remedy, Crystal Reports, SQL Server, VBA, Visual Basic and MS-Office components, database development (MS-Access), report analysis & development.
• Development of complex SQL statements for ETL from diverse sources (Sybase, Flat Files, MS Access)
• Administration of reporting servers
• Training of junior personnel in report development techniques and practices

Help Desk Analyst

Confidential

Responsibilities:

• Principal 1st level systems support person providing hardware and software support to users of microcomputers in the B.C. Ministry of Education for Mac and PC platforms.
• Maintain hardware and software inventory database and ensure return of borrowed items
• Inventory / Delete sensitive information from recycled computers for provinces "Computers for Schools" recycling campaign.