| 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.
|