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

Languages

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

Web Technologies

HTML,XML, SharePoint server MOSS

Databases

MS Access, MS SQL Server 2000/2005/2008

Tools/Utility

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

Software

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

Confidential

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.

Confidential

Role: Database Programmer Analyst -BI Developer/Analyst

Responsibilities:

  • 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

Confidential

Role: SQL BI Developer/Administrator

Responsibilities:

  • 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

Confidential

Role: SQL BI Developer

Responsibilities:

  • 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

Confidential

Role: SQL Developer/ Administrator

Responsibilities:

  • 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

Confidential

Role: SQL Developer/DBA Intern

Responsibilities:

  • 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