SUMMARY:

• Creative and deadline driven technical professional with 6 years of experience in dedicated IT roles. Six years as a SQL Server developer and BI Analyst with solid experience installing, supporting, and enhancing SQL Server databases and reporting.
• Experience in SQL Server 2005/2008/2012, SSRS, SSIS, SSAS and SQL Server development including stored procedures, functions, triggers, and T - SQL. Extensive knowledge in data mining and designing data warehouse databases for both Star and Snow Flake schema. Strong skills in SQL Server Analysis Services including OLAP databases, ETL tools, building cubes, dimensions, and hierarchies. Excellent communicator with strong interpersonal, analytical, and organizational skills.
• Background in full life cycle database development (conceptual, logical and physical data model) with deep background in T-SQL statements for creating tables, indexes, triggers, constraints, locking issues and other Objects in the database.
• Proficient with SQL Server Reporting services, Integration Services, Analysis Services, Excel, Access, and Visio. Designed and distributed reports in multiple formats such as Excel, Access, PDF, XML, HTML using SQL Server 2005/2008 Reporting Services.
• Created and configured cubes, dimensions, measures, data source and data source views using SQL Server 2005 Analysis Services.

TECHNICAL SKILLS:

Relational Database Analyst: Business Intelligence AnalystSSRS, SSAS, SSISComputer Skills

Business Intelligence tools: SSRS, SSAS, SSIS, VS 2005/2008, ProClarity Analytics Server, Crystal Reports, Data Mining tools and techniques

Database Management Systems: SQL Server 2005, 2008/R2, MS Access

Programming Languages: T-SQL, VB, CSS, XHTML / Web Authoring, C#

PROFESSIONAL EXPERIENCE:

Confidential

SSRS Developer

Responsibilities:

• Create views and stored procs for reporting datasets
• Design complex tabular reports, charts, gauges, and Maps using SQL Server Data Tools and Report Builder 3.0
• Deploy and manage reports in Report Server
• Write sql scripts to analyze data

Environment: SQL Azure, VS 2010, Excel

Confidential

SQL - BI Developer

Responsibilities:

• Create SSIS packages to import data from excel files to SQL Server
• Create stored procedures to load fact data and for incremental loading
• Build cubes, dimensions, and hierarchies including cube security
• Create reports using SSRS 2008/R2 and Report Builder 3.0

Environment: SQL Server 2012, VS 2010, Excel

Confidential

Data Analyst / SSRS Developer

Responsibilities:

• Perform data analysis on Gulf Oil Spill Claims and Indian Trust Settlement using SQL Server 2008R2 and Excel
• Create daily and ad-hoc reports using Report Builder 3.0 and BIDS
• Create and manage SSRS subscriptions using Report Manager
• Distribute and deploy reports to GCCF website
• Data migration and manipulation from multiple sources to SQL server using SSIS
• Convert Crystal reports to SSRS

Environment: SQL Server 2008 R2, VS 2008, Excel 2007, SharePoint 2010, Visio 2007

Confidential

SQL Developer / BI Analyst

Responsibilities:

• worked on a Disney project tracking and analyzing Omniture web traffic, Ads data, and TV audience
• Creating weekly and monthly Executive Dashboards using Excel as a client tool
• Gather business requirements and write SQL codes for staging and final databases
• Create ad-hoc reports using SSRS
• Work in a team performing ETL on existing Excel data and import to SQL server using SSIS

Environment: SQL Server 2008/R2, VS 2008 Team System, Excel 2010, SSRS, SSIS

Confidential

SQL Server Developer/BI Analyst

Responsibilities:

• Creating al materials for SSRS,SSAS 2008
• Created reports in multiple formats such as Excel, PDF, HTML utilizing SQL Server 2005/2008 Reporting Services.
• Designed reports, grouping/sorting and parameters (including multi-value parameters) using SQL Server 2005/2008 Reporting Services.
• Conduct multidimensional analysis using ProClarity Analytics.

Environment: SQL Server 2005/2008, Microsoft Visual Studio 2005/2008, SSRS, SSIS, SSAS, Excel

Confidential

SQL Server Developer/BI Analyst

Responsibilities:

• Optimized capabilities by utilizing SQL Server Management Studio to prepare both logical and physical aspects of new database.
• Enhanced data security and recovery through development of a targeted disaster management plan and backups.
• Enhanced reports’ links and information access through creation of drill-through targets - expertly employed SQL Server 2005 Analysis Services to define data source and views, dimensions, measures, hierarchies, attributes, KPIs, and perspectives.
• Ensured security and control of SQL Server administration by creating unique user logins and schema, monitoring user accounts, and granting privileges.
• Optimized query functionality by using performance monitor and the Activity monitor to locate and eliminate deadlocked processes.
• Expedited distribution of reports to specified recipient group by customizing actions based on a predefined set of criteria and elevating permissions onto a report server.
• Calculated bills of quantities for engineering jobs in Excel. Installed, configured, and authenticated SQL Server 2005. Conducted data migration from flat files to SQL.

Environment: SQL Server 2005/2008, VS 2005, SSRS, SSAS, HTML, Excel, Access