We provide IT Staff Augmentation Services!

Business Intelligence Developer Resume Profile

objective

Leverage my technical, analytical, and interpersonal skills from a Business Intelligence standpoint in order to make a positive impact upon the organization.

technical skills

Languages

T-SQL including advanced stored procedure development, optimization, ad-hoc queries, and administration

PL-SQL including ad-hoc queries, optimization, linked server integration, and ETL processes

MDX querying for SSRS reports and SSAS calculations

VB.Net/C functions promoting advanced reporting functionality

Databases

  • SQL Server 2000/2005 x32 and x64
  • Oracle 9i
  • DB2
  • Software
  • SSRS
  • SSIS/DTS
  • SSAS
  • Management Studio, Profiler, and Tuning Advisor
  • Toad for Data Analysis
  • Proclarity
  • Crystal Reports 8/9/10, ColdFusion Reports
  • Team Foundation Server
  • Environments
  • Business Intelligence Development Studio 2005
  • Visual Studio 2005/2008
Experience

Business Intelligence Developer

Confidential

  • Business Intelligence BI support of Home Equity collections team.
  • Executed as lead developer on several large scale reporting projects, such as HAMP/HARP, actively implementing valuable metrics while working with business to define new processes.
  • Delivered primary support of Home Equity Support Workflow SWF , the system used to move accounts through charge off decisioning process, and reworked ETL greatly increasing efficiency at run time.
  • SDLC of new reporting including requirements determination, data analysis, T-SQL development, SSRS integration/design, testing, implementation, and support.
  • Administration of SQL servers including ETL processes SSIS/DTS/T-SQL and back-up coordination of releases.
  • Established mult-tier Report level down to ETL documentation of 200 existing SQL Server 2005/Oracle/DB2 based BI reporting systems.

Business Intelligence Developer

Confidential

  • Developed two complex dashboard/scorecard reporting systems for upper management using T-SQL queries, stored procedures, and MDX with SSRS 2005 as reporting medium.
  • Performed initial requirement determination and data analysis.
  • Built ETL SSIS/T-SQL of data from fragmented business processes and diverse database platforms SQL/Oracle/DB2 .
  • Architectural design and implementation of data structures as reporting groundwork.
  • Development of robust collections reporting using SSRS driven by advanced T-SQL stored procedures and queries, as well as vb.net.
  • Tangential tasks involved team development and mentoring of junior developers, as well as BI support of Personal Credit Management PCM Collections team.

Business Intelligence Developer

Confidential

  • Development of 250 SSRS reports of varying complexities against transactional and data warehouse environments.
  • Data warehouse development involving ETL, reporting, cube maintenance/design, and Proclarity support.
  • Key participant in stakeholder meetings to gather, help define, formalize, and develop reporting standards within the healthcare industry.
  • BI production support of report servers SSRS and legacy .
  • SSRS integration with Sharepoint.
  • Heavy utilization of profiler and tuning advisor for administrative and analysis tasks.
  • Advanced T-SQL programming for reporting and ad-hoc data analysis.

Hire Now