We provide IT Staff Augmentation Services!

Bi Consultant Resume

3.00 Rating

Cary, NC

SUMMARY

  • Over 8 years of experience in Database Administration and Microsoft business intelligence Development under SQL Server environment, with thorough knowledge of SQL Server 2008/2008R2/2012 databases. Experienced in Insurance, Financial, Health Care and banking services.
  • Experienced in upgrading SQL Server 20 /2012 and data migration among versions.
  • Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS), SSAS (analysis services).
  • Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
  • Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Experienced in the complete life cycle of DTS/SQL Server Integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL jobs across different servers.
  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
  • Generating complex Transact SQL (T - SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
  • Experience in developing reports using Report Builder and used Metadata to define Fact & Dimension tables.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated drill down reports, drill through reports, parameterized reports, Cascaded reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
  • Working experience of designing Ad-hoc reports for higher managers using report model, providing them flexibility to create reports using drag and drop functionality.
  • Developed Cubes using SQL server Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
  • Expertise in.NET frameworkwith great proficiency in creating applications usingWin Forms, Web Forms, Entity Framework, ASP.NET, C#/VB.NET, ASP.NET MVC, ADO.NET, XML, AJAX toolkit, Cascading Style Sheets (CSS), JavaScript, WCF, WPF,IIS7.0, SQL Server 7.0/2000/, LINQ and Visual Studio.NET.
  • Created Dimensions with the cube wizard and generated named calculations and named queries.
  • Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Microsoft Certified Technology Specialist in SQL Server 2005 and SQL Server 2008.
  • Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.

TECHNICAL SKILLS

Operating System: Window 2000, Windows XP, Windows 2003, UNIX

Languages: C, C++, Java, VB6, VB.NET, C#, ASP.NET

Databases: MS-SQL Server 2000, MS SQL Server2005, MS SQL Server 2008, MS SQL Server 2012

Data Warehouse Tools: SSIS, SSRS, SSAS

SQL Server Tools: Enterprise Manager, Microsoft Systems Center Operations Manager, SQL Server Management Studio, Profiler, Query Analyzer, MS Visio

Web Technologies: HTML, DHTML, VB Script, Java Script, PERL and ASP

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

BI Consultant

Responsibilities:

  • Analyzed the existing reports in Report.Net, Actuate and their data sources
  • Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
  • Extracted data using SSIS packages (ETL) from different server locations and data sources.
  • Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
  • Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
  • Designed and implemented Parameterized and Cascading Parameterized reports using SSRS

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, ReportBuilder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler, Replication, Logshipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, Montpelier, Vermont

BI Consultant

Responsibilities:

  • Installation and Upgradation of SQL Server 2008 and SQL Server 2012 on Production Environments.
  • Involved in migrating data from SQL Server 2008/2008R2 to SQL Server 2012.
  • Develop and implement production database backup strategies for MS-SQL Server databases which enable maximum recoverability.
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services
  • Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
  • Involved in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group Working on Complex data conversions from Existing Legacy systems to Desktop application using C#.NET and SQL
  • Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL Server 2008
  • Created stored procedures, views, indexes and joins as needed.
  • Involved in Performance Tuning of databases to optimize existing applications and processes.
  • Creating jobs for scheduling the SSIS packages.
  • Worked with different Types of files like UPD, PCF, VMF, RCF..
  • Extensively utilized SSIS packages to create complete ETL process and load data into database which was to be used by Reporting Services.
  • Performed operations like sorting, merging on the source data in order to clean the data and remove duplicates.
  • Designed databases, tables, SQL functions, triggers in SQL Server 2008.
  • Responsible for database development in SQL Server 2008, worked on T-SQL functions and SQL syntax.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, ReportBuilder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler, Replication, Logshipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, Atlanta GA

BI Consultant

Responsibilities:

  • TSQL Programing - writing new stored procedures, updating & enhancing the existing code.
  • Optimizing the queries and taking care of performance issues.
  • Implementing Backup and recovery process and Replication process.
  • Deploying the code, SSIS packages and SSRS reports in production servers.
  • Installing and configuring the SQL Server 2008 and SQL Server 2012 on windows 7 servers.
  • Creating New SSIS packages and Migrating SSIS packages from SQL Server 2008 to SQL Server 2012.
  • Designing and modeling data warehouse and data marts, creating database objects and applying optimization techniques.
  • Exclusively worked on Script task (C#.NET, VB Scripting), File System Task to read the excel files and updating the excel files in ETL package.
  • Effectively using various synchronous and asynchronous transformations in ETL packages.
  • Integrated third party components ACG Grouper and Milliman Grouper in SSIS packages.
  • Created various Medicaid and Medicare Claims data extract and loading SSIS ETL packages.
  • Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL Server 2008
  • Created Stored Procedures/Functions/Triggers in SQL Server using T-SQL.
  • Automating various ETL jobs and sending notifications to the users.
  • Created SSRS reports and taking care of deployment issues.
  • Designing and deploying Adhoc reports for Business Process Management by using Operational Data Source.
  • Taken care of code and SSIS deployment and migration issues.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler, Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server

Confidential, NJ

BI Consultant

Responsibilities:

  • Extensively managed and administered SQL Server 2008/2005 and 2000 servers
  • Installation of SQL Server 2008/05 on DEV, Staging and Production Servers for teams
  • Monitored SSIS packages and job workflows for used database partitions to manage data
  • Transferred SQL Server Objects from QA to Production Using SSIS Packages.
  • Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns
  • Managed SQL Object Permissions, Roles and Authentication Modes for security policies
  • Rebuilding the indexes at regular intervals for better performance and updated statistics
  • Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
  • Support for international LEDES format
  • Analyzing and Understanding the business requirements.
  • Created SSIS packages to move the data from comma delimited flat files into SQL database.
  • Used many of the SSIS transformations such as Execute SQL Task, Execute Package Task, Flat File/OLE DB Source/Destination, Lookup, Derived Column etc
  • Imported data from various sources into a staging area, merges the data into the data model, and presents it to the business users.
  • Implemented ETL and business logic with various tasks and transformations.
  • Written many customized queries, implemented many performance improvements across packages.
  • Loading these data into data warehouse like SQL server.
  • By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
  • Identifying of performance bottlenecks, Performance tuning of packages

Environment: MSBI, C#, ASP.NET, Java Script, SQL Server Integration Services (SSIS), SQL Server 2005

Confidential, Redmond, Washington

BI Consultant

Responsibilities:

  • Query Optimization and tuning the query, creating Indexes to improve the query performance.
  • Bulk Insert and loading the data files which comes from various legacy systems (Mainframes and Oracle database).
  • Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
  • Expertise in Monitoring and Troubleshooting and resolving the SQL Server Performance issues.
  • Designing, developing and deploying various ETL packages for data loading (SSIS).
  • Creation and Execution of DTS and BCP utilities in SQL Server 2000.
  • Effectively using DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
  • Creation and implementation of Database backup Restore and Recovery plans.
  • Replicating the database (Snapshot, Transactional and Merge Replication) and providing greater autonomy to the users.
  • Working on Log shipping, Mirroring and SQL Server Clustering Databases.
  • Developing, implementing, maintaining and exercising Disaster Recovery processes.
  • Building Data warehouse database, Designing Star Schema, Creating Fact tables, Dimension tables and defining the relationship between them.
  • Expertise in processing the Cubes, Hierarchies, and Measures putting calculations and processing for Analysis Services (SSAS).
  • Expertise in populating processed Analysis Cubes historical data into excel file, ProClarity, various pie charts.
  • Trouble shooting and fixing the issues in front end code (VB.NET, ASP.NET, C#) when project needs.

Environment: Windows 2003, SQL Server 2008, Microsoft Visual Studio 2008, SSIS, SSRS, Windows XP, Windows 2003, Windows 2000

Confidential

SQL Developer

Responsibilities:

  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using T- SQL.
  • Involved in Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
  • Created and managed the Database Users, Login and Security.
  • Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Monitoring SQL Agent jobs.
  • Monitoring and Managing use of disk space and connections.
  • Created DTS packages to migrate data.
  • Involved in data transfers between various servers using BCP.

Environment: MS SQL Server 2000, T-SQL, DTS, BCP, Windows 2003 Server

We'd love your feedback!