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