We provide IT Staff Augmentation Services!

Senior Bi Analyst Resume

St Louise, MO


  • Around 8 years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2014/ 2012/2008 R2/2005/2000 in Insurance, Health Care and other Commercial business Domains.
  • Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
  • Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
  • Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
  • Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
  • Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
  • Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
  • Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
  • Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures.
  • Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports .
  • Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
  • In depth understanding of SQL Server Migrations and problem management
  • Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
  • Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
  • Responsible to maintain the efficiency of all the software and applications that run on UNIX system
  • Intensively working for graphic design Database backend programming in C# for dynamically generating components in front Database. Working knowledge with HTML.
  • Having excellent communication skills, analytical skills, understanding of business requirements in various domains.


MSSQL Server 2014/2012/2008 R2/2008/2005, SSRS, SSIS, SSAS, MS dynamics, Guidewire, Informatica, Tableau, DB2, MS-Access 2000, MS Excel, Team Foundation Server, Erwin 8.0/7.2/7.1, MS Visio 2010/2007/2005 , MS Dynamics, Oracle 11g/10g, Unix, T-SQL, Red Gate tools, HTML5, XML, Java script, VB Script, C#, Visual Studio 2014/2012, MS office, Windows NT/ 2000 Server/ XP


Confidential, St. Louise, MO

Senior BI Analyst

  • Requirement gathering for data to convert from CMS to GW database. Worked closely with GW implementation partner and identify client requirement for the new ClaimCenter and PolicyCenter.
  • Created and maintained two different stage databases for conversion and reporting needs.
  • Created ETL to load ClaimCenter and PolicyCeneter with data derived from a Java based legacy system.
  • Working with Guidewire Claim Center, Policy Center, Data hub implementation.
  • Data mapping, writing scripts and load data for conversion.
  • Work with GW integration team to validate and transform data across other systems.
  • Worked with reporting team on making changes, creating views and making new reports.
  • Design and planning for new SSRS reports in response to new Guidewire implementation.
  • Configured files to deploy the SSIS packages across all environments.
  • Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
  • SQL agent jobs creation, scheduling and error handling.
  • Off Shore Co-ordination and after hours’ deployment.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Project Environment: MS SQL Server 2014/2016, Red Gate tools, Guidewire, GIT, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio, Salesforce etc.

Confidential, Oklahoma City, Ok

Senior BI Analyst

  • Database development and maintenance including creation of jobs and troubleshoot.
  • SSIS package inventory, development and integration.
  • Auto FTP system troubleshooting and data transfer.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Involved in ETL architecture enhancements to increase the performance using query optimizer.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created SSIS packages for Data Conversion using data conversion transformation.
  • Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
  • Coordinated with front-end for implementing logic in stored procedures and functions.

Environment: SQL Server 2012/2008/2005 Enterprise Edition,SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Atlanta, GA

Sr. ETL MSBI developer


  • Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
  • Design and tune ETL process. Working closely with the Guidewire team on business aspects.
  • Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
  • Configured files to deploy the SSIS packages across all environments.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
  • Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
  • Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
  • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Project Environment: MS SQL Server 2008/2012, Red Gate tools, PowerPivot, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio, Guidewire etc.

Confidential, Montgomery, AL

Sr. SQL Server/BI developer


  • Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
  • Good understanding of healthcare domain, HIPAA regulations and continuous communication with different stakeholders, clients like Medicare, Medicaid, CHIP.
  • Production support, ad hoc queries meeting requirements from other development teams in a test driven agile development environment.
  • Design and implementation of SSIS/ETL process for the system.
  • Data conversion from mainframe system and Oracle databases to SQL server.
  • Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
  • Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles. Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
  • Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.
  • Modified stored procedures to meet current design and used them in SQL Server.
  • Moving data from SQL server to Dynamics CRM and initial entity creation.

Project Environment: MS SQL Server 2012/2014, MS dynamics 2013/2015, Red Gate tools, PowerPivotTFS 2013, Agile/SCRUM SharePoint 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

Confidential, Englewood Cliffs, NJ

Sr. MSBI developer


  • Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
  • Migrating Databases from SQL Server 2008 to SQL Server 2012.
  • Planned, defined and designed data based on the business requirement. Creating dashboard, scorecards using performance point server according to client requirements.
  • Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
  • Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Designed logical/physical data models using Erwin tool 8.0. Uses of power pivot.
  • Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.

Project Environment: MS SQL Server 2012/2008, Enterprise Edition, Bamboo, Performance point server, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007, Erwin 8.0

Confidential, Portland, OR

Sr. SQL Server/ETL/SSIS Developer /SSRS Developer


  • Developed physical data models and created DDL scripts to create database schema and database objects. Designed data models using Erwin.
  • Created indexes, constraints and rules on database objects for optimization.
  • Designed and developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
  • Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
  • Configured files to deploy the SSIS packages across all environments.
  • Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
  • Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.

Project Environment: MS SQL Server 2008R2, SQL server integration services (SSIS) 2008R2, SQL server reporting services (SSRS) 2008R2, SQL server analysis services (SSAS) 2008R2, VB.Net, C#, SQL profiler, EDI, Pro clarity, TSQL. Erwin tool 7.2, Windows 2007

Confidential, Philadelphia, PA

MS SQL Server BI Developer


  • Worked as a SSRS Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
  • Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
  • Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SSIS package for Market Value Process feed.
  • Used C# scripts in SSIS script task to run custom scripts in package flow.
  • Creating various periodic reports for customers using SSRS, performance point server.
  • Used event handlers to send custom e-mail notifications to business users as well as technical teams.
  • Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  • Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
  • Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Performed user acceptance testing on new and modified reports.
  • Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
  • Developed database triggers and stored procedures using SQL tables.
  • Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.

Environment: Microsoft SQL Server 2008, Visual Studio 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Confidential, Oakland, CA

SQL DBA / Developer


  • Actively participated in interaction with users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.
  • Performed Migration of data from SQL Server .
  • Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
  • Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
  • Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
  • Deployed reports in to Report Manager. Created Ad-Hoc reports using Report Builder.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a date.
  • Created report in SQL Server 2005 and deployed them on local-host for remote access.
  • Developed Multi-Dimensional Objects Cubes, Dimensions using SSAS.
  • Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
  • Ran DBCC and fixed data corruption in application databases.
  • Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Project Environment: MS SQL Server 2008/2005,, SSIS 2008, SSRS 2008, SSAS 2008, Power pivot, Visual Studio 2008, T- SQL, Visual Source Safe 2008 (VSS), XML, ADO.NET, ERWIN 7.1, PL/SQL, MS-Access, MS-Excel

Hire Now