We provide IT Staff Augmentation Services!

Senior Microsoft Bi Developer Resume

GA

PROFESSIONAL SUMMARY

  • Over 10 years of experience in Business Intelligence and Data Warehousing with Microsoft
  • BI tools such as SQL Server Integration, Reporting and Analysis Services. Experience in analyzing, designing, tuning, and developing Databases applications and various segments ofSoftware Development LifeCycle using MSSQL Server 2014/2012/2008/2005.Good knowledge Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
  • Proficient in SQLServer Integration Services (SSIS) to build Data Integration and Workflow Solutions,Extract, Transform and Load (ETL)solutions for Data warehousing applications.
  • Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
  • Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
  • Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
  • Hands on experience with performing various SSIS data transformation tasks like Look - ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers and Catalog loging etc.
  • Deployed and ScheduleSSIS packages on to different servers
  • Modified SSIS packages to automate theData Load on Daily basis using SSIS toolsIn SQL Server 2012.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX, and Tabular Model with DAX
  • Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections
  • Expertise in Proactive Caching, Degenerated Dimensions and Tabular Data Modelling for Moderate to Large Data Systems.
  • Developed Excel Reports Regular, PowerPivot for Excel 2013
  • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View.
  • Well acquainted inrendering reports, managing subscriptions,creating reports in SSRS and Tableau.
  • Experience in creating Tabular reports, Matrix reports, Charts reports, List reports, Parameterized reports, Sub reports, Adhoc reports through Report Builder Using SSRS 2012
  • Experience in Data Visualization and complex report building using Tableau v8
  • Excellent experience in scheduling and deployment of reports in Tableau and SSRS.
  • Very Strong on tools such as Erwin Data Modeler and Visio have full understanding of the Software Development Life Cycle.
  • Strong proficiency inRDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagramsusing tools such asMS Visio and DBDesigner.
  • Worked in Huge Data Migaration Activites from Different Data Sources. Invoved in migration of data from AS/400, DB2, Sysbase to SQL Server
  • Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2012.
  • Strong proficiency in usingT-SQL (DML, DDL)in SQL Server2005/2008/2012 platform.
  • Highly skilled in creatingTables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Defined Functions, Relational Database ModelsandData Integrity observing Business Rules.
  • Expertise in writing DDL, DML and DCL commands using T-SQL, Oracle SQL, PL-SQL .
  • Worked extensively in creatingJobs, SQL Mail, Alertsandschedule SSIS PackagesusingSQL Server Agent.
  • Superior knowlwdge in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
  • Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014 with T-SQL.
  • ExcellentVerbal & Written Communicationskills and strong inDocumentation.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
  • Proven background improving process quality and providing system automation recommendations and strategies to manage solutions and data efficiently.

TECHNICAL SKILLS

OS: Windows NT/2008/2003/XP.

Database: MS SQL Server 2014/2012/2008/2005, Oracle 10g/9i,My SQLMS Access, DB2, Sybase

Languages: SQL, T-SQL,PL/SQL, MDXTool & Utilities SQL Enterprise and SQL Query Analyzer

Reports Tools: Crystal Reports,Tableau

Business Intelligence: Tableau V7, Tableau V8, SSIS, SSRS, SSAS, BIDS,SSDT

Data Modeling Tools: Erwin, MS Visio

Web Server: IIS

Vesrion Control: VSS, SVN, TFS

PROFESSIONAL EXPERIENCE

Senior Microsoft BI Developer

Confidential, GA

Responsibilities:

  • Invloved in data migration from different data sources like AS/400, oracle, Sysbase and Falt files
  • Creating analysis services cube from the data warehouse with a single fact table and a star schema is used with the dimension tables.
  • worked with MDX / Data Mining Queries in SSAS
  • Responsible for extracting data from multiple operational and Medical sources and assemble them into meaningful business intelligence
  • Developing SSIS Packages and deploying them to test and production servers.
  • Scheduling the SSIS package using SQL Server Agent Jobs.
  • Creating and Customizing SSRS Reports, Dashboards Reports as per the Project’s and Client’s Requirement.
  • Developed Different Types of Complex Reports like Drill Down, Chart, Cross Tab, Parameterized reports, Dashboard Reports etc.
  • Developing complex reports and visualizations using Tableau 8 / Tableau 7 as per requirement
  • Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server stored procedures within MS SQL Server environment.
  • Develop and maintain complex reports, multidimensional cubes and flexible dashboards.
  • Create and maintain data flow diagrams for existing and future ETL processes.
  • Create and maintain detailed source-to-target ETL mapping specifications.
  • Assist in the definition of the database requirements; analyze existing models and reports.
  • Invloved in DB Designing for new enhancements of Products
  • Scheduling the daily maintances activies in SQL Agents Jobs
  • Generating the reports with the help of SQL queries for Dashboards
  • Preapring and deploying of SSRS reports

Environment MS SQL Server 2012, MS SQL Server Integration/Reporting Services/ Analysis Services 2012(SSIS/SSRS/SSAS), Tableau, Visual Studio 2012, C#.net.

Confidential

Microsoft BI Developer

Responsibilities:

  • Created OLAP cubes using SQL Server analysis services (SSAS).
  • Invovled in creation of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, OLTP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables.
  • Invloved in data migration from different data sources like AS/400, oracle, Sysbase and Falt files
  • Preparation of document pertaining plan for migrating data into newly created tables.
  • Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
  • Involved in creating SSIS packages to migrate large amounts of data.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Created packages included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
  • Involved in Creating and Testing the SSIS packages developed for security.
  • Scheduled the packages in SQL Agents Jobs to keep extracting the data from OLTP Confidential specific time intervals.
  • Developing complex reports and visualizations using Tableau 8 / Tableau 7 as per requirement
  • Converting existing excel reports and formulas in them to automated reports in Tableau
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts
  • Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
  • Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS

Environment MS SQL Server 2012, MS SQL Server Integration/Reporting Services/ Analysis Services 2012(SSIS/SSRS/SSAS), Tableau, Visual Studio 2012.

Confidential, Mt Clemens, MI

Senior Microsoft BI Developer

Responsibilities:

  • Involved in requirement analysis, design and coding of the project.
  • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, Sub reports, and formatting them using SQL Server Reporting Services SSRS 2012 .
  • Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports.
  • Experience in writing expressions in SSRS and Expert in fine-tuning the reports
  • Created and designed Enterprise reports and Parameterized Reports
  • Generated region wise reports using global variables, expressions and functions using SSRS
  • Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint
  • Worked on deploying Reports to Report Server. Creating user interface on Report Server for the users to access reports on Report Manager.
  • Created Report Snapshots to improve the performance of SSRS
  • Manage security in report manager by assigning the proper roles.
  • Worked on Performance Tuning on existing stored procedures and existing reports for the faster processing of reports
  • Worked with report manager for deploying the reports across all the environments.

Environment MS SQL Server 2008/12, MS SQL Server Integration/Reporting Services/ Analysis Services 2008/12(SSIS/SSRS/SSAS), Visual Studio 2012

Microsoft BI Developer / SQL DBA

Confidential

Responsibilities:

  • Responsible for data definitions, source system identification and connectivity, working with end users to define business requirements and needs and performing data validation.
  • Consult with end-users to analyze and understand user needs, objectives, desired features, and input and output requirements.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
  • Configured Package logging, Error logging and Event Handling to Redirect Error Rows and fix the errors in SSIS.
  • Creating and Customizing SSRS Reports, Dashboards Reports as per the Project’s and Client’s Requirement.
  • Developed Different Types of Complex Reports like Drill Down, Chart, Cross Tab, Parameterized reports, Dashboard Reports etc.

Environment: MS SQL Server 2008, MS SQL Server Integration/Reporting Services 2008 (SSIS/SSRS), Visual Studio 2008, C#.net.

Confidential

Microsoft BI Developer / SQL Server DBA

Responsibilities:

  • Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
  • Worked onDBA activities like creating users, roles and granting and revoking privileges.
  • Prepared proper backup and recovery plans.
  • Optimized query performance by creating indexes.
  • Worked on Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
  • Created custom and Ad hoc, Several drill down and drill through reports reports using SSRS
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Environment: MS SQL Server 2008, MS SQL Server Integration/Reporting Services 2008 (SSIS/SSRS), Visual Studio 2008, C#.net.

Confidential

Microsoft BI Developer

Responsibilities:

  • Involved in Gathering and analysing the requirements and Interacting with in-house team of domain experts.
  • Responsible for design and development of Database and ensure optimum level of normalization and standardization of tables, implementation of functionality.
  • Analyzed and designed the database schema for SQL Server 2005 using data tool ERWin data modeler as per client requirement for Development team.
  • Involved in designing data base and writing complex business logic using Stored Procedures, Views, Triggers, functions Rules, Defaults and Database Mails.
  • Writing Database Documentation, including data Standards, Procedures and Definitions for the Data Dictionary (metadata).Worked on development projects in complete SDLC life cycle.
  • Working with Report Server Manager in Configuring and scheduling the reports.
  • Configuration Management using Microsoft Visual SourceSafe.
  • Managed co-ordination with testing team, and Version management, patch management and Source code management with VSS.
  • Build and Release - Created deployment packages for ASP.Net application using Visual Studio 2005 and release.
  • Involved in creating Dynamic Stored Procedures and views.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Involved in performance tuning of queries for query efficiency.
  • Took part in the normalization and de-normalization of database.
  • Responsible for creating datasets using T-SQL and Stored Procedures and also involved in Data visualization.
  • Responsible for rebuilding the indexes and tables as part of performance tuning
  • Used SQL Server Agent for scheduling jobs and alerts
  • Performed Query optimization & Performance Tuning
  • Optimized queries using SQL Profiler and Database engine tuning advisor

Environment: ASP. Net, VB.NET, SQL Server-2005