We provide IT Staff Augmentation Services!

Bi Developer/analyst Resume Profile

Madison, WI

Professional Summary:

  • Over 7 years of IT Experience in Data Warehousing BI Solution Design, Development and Administration with Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis services SSAS , Microsoft Reporting Services SSRS , Microsoft Integration Services SSIS , Performance tuning, Designing Logical/Physical databases and Troubleshooting.
  • Extensive Knowledge of all major international standards used in Healthcare like HIPAA 4010/5010, HL7, PCS, ICD 9/10, CPT Codes.
  • Expertise in Implementing and managing organization wide BI solutions in SQL Server 2005 / 2008 and Business Objects.
  • Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
  • Worked on SQL BI solution integration with Microsoft SharePoint Server MOSS .
  • Strong knowledge in Performance Point Server 2007 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports
  • Proficient with Microsoft Excel, especially pivot tables, reports, and charts.
  • Thorough understanding of Kimball's' theory, KPIs, SQL 2005/2008 Architecture, Data mining, working with slowly changing dimensions.
  • Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS 2007 SharePoint , Business Scorecard Manager, Dashboards, Performance Point Server for easy data access.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS.
  • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, OLAP and Sub reports, adhoc reports, parameterized reports, custom reports and formatting them.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.

SQL Server Administrator:

  • Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008.
  • Responsible for managing a database environment leading to documentation, database backup and recovery methods, manage automation of database administration, performance monitoring, tuning, and capacity planning.
  • Hands on experience of high availability SQL Server solutions using replication, Mirroring, Log shipping and SQL Server clustering and installation of physical server hardware and other peripheral devices.
  • Experience in space allocation, database migrations and database security along with solving code compatibility check issues during the migration from 2000 and 2005.
  • Responsible for standards and design of physical data storage, maintenance, access and security administration.
  • Responsible for design and correct functioning of backup and recovery on DBMSs.
  • Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
  • Evaluates and implements new initiatives on technology and process improvement.

Operating System

Windows NT/98/2000/XP/2003/2008 server


T-SQL, PL/SQL,Visual Studio 2003/2005/2008

Web Technologies

HTML,XML, SharePoint server MOSS


MS Access, MS SQL Server 2000/2005/2008


Enterprise Manager, SQL Server Management Studio SSMS , Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler


MS Office, Visio, Adobe Photoshop, Ms Excel

Reporting Tools

SQL Server Reporting Services 2005/2008, Business Objects

Analytical Tools

SQL Server Analysis service SSAS ,Performance Point Server 2007,

ProClarity Analytics Server

ETL Tools

Data Transformation Services DTS ,SQL Server Integration Services SSIS

Professional Experience


Role: BI Developer/Analyst

  • Developed new reports using SSRS 2008. Used table control, matrix control for cross tab reports.
  • Converted the reports from SSRS 2005 to 2008.
  • Performance tuning, query optimization of stored procs for better performance.


Role: Database Programmer Analyst -BI Developer/Analyst


  • Analyzing the SAS Programs and writing the Business Requirements for the Reports and Developing SQL Stored Procedures and Reports Using SSRS2005/2008.
  • Developed the Stored procs to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • DDL Scripts for generating Tables, Views, Functions for Reports.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
  • Performance tuning, query optimization and execution plan of queries for better performance.
  • Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
  • Designed and created Report templates, bar graphs and pie charts based on the Claims data.
  • Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
  • Writing Complex MDX for the Reports that Uses OLAP Cubes.
  • Developing OLAP, HOLAP and ROLAP Cubes to have a better Analysis for the Business Needs.
  • Experience in using Performance Point, Power Pivot and SharePoint Designer.
  • Training and Mentoring the Business Users to help them Understanding OLAP Cubes.
  • Managed SharePoint end user accounts, permissions, access rights, and storage allocations in accordance with best-practices regarding privacy, security, and regulatory compliance.

Environment: Visual Studio 2005/2008, SSMS , T-SQL Stored Procedures, SQL Server reporting services SSRS , SQL Server Analysis Services SSAS , ProClarity 6.3 ,Power Point, Office, Excel Power pivot 2010 ,Performance Point services, ER Studio


Role: SQL BI Developer/Administrator


  • Work with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Migrated databases from SQL Server 2000 to SQL Server 2005.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
  • Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Migrated DTS packages to SSIS packages.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Designed OLAP cubes with star schema and snow-flake schema using SSAS.
  • Created Cubes and performed Cube Partitioning in SSAS.
  • Understanding the OLAP processing for changing and maintaining multi dimensional data Warehousing, Optimizing Dimensions and Hierarchies and adding the Aggregations to the Cube.
  • Created various complex reports and manage them using SQL Server Reporting Services SSRS 2005/2008 .
  • Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
  • Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Wrote and integrated stored procedures to generate the special reports according to client's need.
  • Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
  • Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
  • Created highly complex SSIS packages using various Data transformations like conditional splitting, FuzzyLookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components
  • Developed and unit test SSIS load processes for performance check.

Environment: Windows 2003 Server, SQL Server 2008 Enterprise Edition, SSRS, SSAS, SSIS, Performance Point Sever 2007, MOSS 3.0, EXCEL2007, MOSS 2007


Role: SQL BI Developer


  • Developed data model based on the BA's and the reporting Team using SSAS, SSRS.
  • Designed cubes with star schema using SQL Server Analysis Services SSAS .
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measure groups and KPIs to analyze performance of strategic business units as well as corporate centers.
  • Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
  • Experience in SQL Server Analysis Services SSAS for data mining to identify rules and patterns in the data.
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Experience with SQL Server Reporting Services SSRS to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Created maintenance reports by using various components like Grouping, Sorting, Filters, and Navigation.
  • Developed Linked reports and Sub reports as per user and business specifications.
  • Highly involved in creating, structuring, formatting the reports using Report Designer and Report Builder.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Wrote store procedures to generate account statements for different types of accounts.
  • Involved in migration of SSRS from SQL 2000 to SQL 2005.
  • Worked on SQL Server Integration Services SSIS to integrate and analyze data from multiple heterogeneous information sources Oracle Sybase
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Building UAT and Test environments using Production backups.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, MOSS 2007


Role: SQL Developer/ Administrator


  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server 2005 EE, SSRS, SSAS, SSIS, Windows 2003


Role: SQL Developer/DBA Intern


  • Created new tables, written stored procedures for Application Developers and some user defined functions.
  • Created SQL scripts for tuning and scheduling.
  • Performed data conversions from flat files into a normalized database structure.
  • Created and managed users, roles and groups and handled database security.
  • Created Triggers to enforce data and referential integrity.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database Oracle and Text format data to SQL Server.
  • Data migration import export BCP from Text to SQL Server
  • Regularly monitored the system for bottlenecks CPU, RAM, Disk IO and Networking
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Performed development support, document reviews, test plan, integration of the system.
  • Creation/ Maintenance of Indexes for fast and efficient reporting process.
  • Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
  • Creation/Deletion of Linked Servers.
  • Managing historical data from various heterogeneous data sources i.e. Excel, Access .

Environment: SQL Server 2000, T-SQL, PL/SQL, TOAD.

Hire Now