SUMMARY:

• Seasoned MS BI/ Data warehouse professional with over 9+ years of IT experience that includes over 6 years as an OLAP & ETL Developer with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation of client server applications in various industries.
• Very good knowledge of SQLSERVER 2017,2016,2014,2012,2008R2,2005,2000 and performing database development tasks within .Net(C#,VB.NET) Environments
• Extensive Experience in designing databases & DB Objects (Tables, Stored Procedures, Views, Triggers etc.) in both OLAP & OLTP environments
• Expertise in end to end development of Reporting Technologies Like Power BI,Tableau Server, Tableau Desktop versions 9.x/10.x, SSRS, Excel
• Highly proficient in writing Transact - sql & MDX queries, Performance Tuning and analyzing query execution plans and extensive knowledge of transactions, Error Handling in ETL & T-Sql.
• Extensive experience in creating ETL packages using SQL server 2017/2 /2010/2008 R2/2005 Integration Services (SSIS), Cubes using SQL Server Analysis Services (SSAS).
• Involved in all phases of Software Development Lifecycle (SDLC) and gathering business requirements for new applications using agile development methodologies.
• Working knowledge of different data sources as SQL Server, ERP Systems, Web forms, API Data, Teradata, Oracle, Flat files, Excel, MS Access & Mainframes, JSON.
• Experience in Developing SSIS Packages to move data from HDInsight ( Confidential Version of Hadoop) to Azure Sql server Data Marts.
• Experience in Configuring, Maintaining & deploying MS SQL database Servers.
• Experience in SCOPE language to communicate with COSMOS for data integrations.
• Experience with Creating, Automating and managing COSMOS/SCOPE jobs on the VC’s.
• Experience in building Tabular Model SSAS Cubes.
• Expertise in Power BI Reports & Dashboards end to end development.
• Experience in creating cubes from Dimension Modeling using Fact tables & Dimension tables using SQL Server 2005/2008R 2/2012/2014/2016 Analysis Services (SSAS). Defined Measures, Measure Groups, Hierarchies, and Dimensions by configuring Data Sources & Data Source Views.
• Experience in defining calculated members, named sets in SSAS & by using MDX queries.
• Experience in Power Pivot, Building pivot Tables, Power query.
• Experience in administering cubes by defining different security levels, roles.
• Extensive experience on complete Reporting Life Cycle on Authoring, Management & Delivery. Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005/2008R 2/2012/2014/2016 Reporting Services (SSRS).
• Experience in migrating EDW with Azure Sql Data Warehouse.

TECHNICAL SKILLS:

Databases: SQL Server 2017/2 / 2008 R2/2005/2000, Teradata, Oracle 9i/8i, DB2, MS Access.

MS SQL Server 2000/2005:, MS-Access, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

T: SQL, PL/SQL,SSIS/SSRS/SSAS,Sql Azure,ADF,Stream Analtyics, Pro-clarity,ADL

VB.net, VB Script, T: SQL, SSAS, OLAP, HTML, XML, ASP, Java Script, C, C++ and MDX.

ETL Tools: DTS, SSIS (SQL Server Integration Services), Custom Data Acquisition Framework, Informatica.

Power BI:, SQL Server Reporting Services, Tableau, WebFocus.

Tools: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, Front page.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Sr.SQL Server BI Developer / Azure DWH Developer

Responsibilities:

• Created DataMart’s for Machine Learning consumption and automated SSIS jobs for incremental data loads.
• Created Pipelines, Datasets and worked with datascientists&analysts as a part of POC of internal Confidential product key analytics which are implemented on Azure Data Factory.
• Developed data pulls from Cosmos using Scope Scripts.
• Worked with the Confidential COSMOS distributed systems technology. All the datasets related to PKRS & APS are moved to COSMOS.
• Created Source Target mappings for migrating on-Premise DataMart to Sql Azure.
• Designed, Developed, Tested, Published and maintained PowerBI Functional reports, Dashboards for the management teams to make healthy decisions in MBRs.
• Created maintained SQL Agent Jobs for automating and scheduling ETL process and Database maintenance tasks.
• Created Data frames using R script and sourced it to PowerBI Desktop for generating R Visuals for Confidential Product Key Life Cycle analysis Project and published to powerBIService.
• Develop and maintained partner onboarding web Application using C# and .net framework libraries.
• Created interactive Dashboards using Power BI for analytics Team.
• Created Dashboards using PowerBI for analyzing MS ProductKey Activations, MS ProductKey Blocks & MS ProductKey distribution shared across different partners.
• Created Reusable packages having modular structure which can be reused in other packages.
• Defined Dimension Models based on existing fact & dimension tables in Relational Data Warehouse.
• Created dimensions by defining Parent-Child relationships, using different dimension types.
• Created Perspectives & defined security, roles for different group of users.
• Created Tabular Model SSAS cube for the Machine learning Pilot project.
• Optimized performance of cubes by defining right key attributes, turning off optimization for rarely used attributes, defining hierarchy relationships between attributes.
• Formatted the reports using the Global variables and expressions.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created scheduled reports using Data-Driven subscriptions, Snapshot triggered & Schedule triggered subscriptions

Environment: SQL Server 2017/2016/2014 , T-SQL, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, PowerShell,TFS, Machine Learning, SQL Azure,ADW,ADF,R scripting, MS PowerBI, Power Apps,, HDInsight.

Confidential, Seattle, WA

Sr. SQL Server BI Developer/Analyst

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed Stored Procedures for combining Relational & Multi-Dimensional data into one query result set and created SSRS Reports on top of it.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
• Created SSIS packages with which data sources such as Flat files,Teradata,DB2, Excell files, and PDF files Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS2012)
• Created complex SSAS cubes with multiple fact measures groups, multiple dimension hierarchies and defined attribute relations based on the OLAP reporting needs
• Used Analysis Services for creating Dimensions using Attributes, defining Hierarchies, Levels & Measures, and Measure Groups.
• Built Cube Partitions using MOLAP, HOLAP,ROLAP methods for faster query performance and processing speed
• Built MDX queries for Analysis Services & Reporting Services.
• Defined Attribute, Dimension, Cube level properties using Analysis Services.
• Created KPIs, calculated members, Named Sets by using SSAS.
• Used MDX queries to Defined sets, member sets & creating calculated members, Named sets in Analysis Services.
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Formatted reports using Global Variables & Expressions.
• Created Data Models in Power Pivot for end user reporting purpose.
• Created Drill down & Drill Through reports using SSRS.
• Created Dashboards using Power BI for core business decisions.
• Designed Highly Parameter driven reports using SSRS.
• Migrated SSRS Reports & SSIS Packages from SQL2005 to SQL2012
• Used SQL Server Profiler to trace out stored procedure calls of slow running SSRS reports and do Performance tuning.
• Supported users to fix issues related to reports &cubes.
• Actively involved in daily scrum meeting for status updates.

Environment: SQL Server 2014/20112/2008 R2, T-SQL, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, PowerShell.

Confidential, Jacksonville, FL

Sr. SQL Server BI Developer/Data Analyst

Responsibilities:

• Involved in logical and physical data modeling, database design, star schema, data analysis.
• Analyzed the specifications provided by the client and gathered the requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• Developed logic for Incremental Loads ( new rows and modified rows )
• Migrated old data from legacy system into SQL Server 2008 using SSIS Packages
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions
• Wrote lot of Stored Procedures and developed lot of SSIS Packages in DW environment. Responsible for ETL jobs scheduled to run and daily DW load
• Created and configured various SSIS packages for optimal performance by studying the parallelism, buffer sizing and design approaches.
• Created partitions and aggregated cube for better performance.
• Processed cube to perform incremental updates.
• Created Data Models in Power Pivot for end user reporting purpose.
• Built MDX queries for Analysis Services (SSAS) & Reporting Services (SSRS).
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint
• Constructed Cubes based on data volumes mostly adhering to Star Schema
• Created complex SSAS cubes with multiple fact measures groups, multiple dimension hierarchies and defined attribute relations based on the OLAP reporting needs
• Built cube partitions using MOLAP, HOLAP,ROLAP methods for faster query performance and processing speed
• Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports

Environment: MS SQL Server 2008R2, Erwin, SSIS, SSRS, SSAS, Oracle 10g, SharePoint 2007, T-SQL, PL/SQL, MDX, Toad, Teradata, Informatica

Confidential, Bellevue, WA

SQL Server BI Developer/Analyst

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Analyzed client specifications and gathered requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Involved in performing database code and design reviews and worked with application code teams in developing, delivering and modifying database objects as per project requirements
• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
• Designed and maintained complex stored Procedures using Joins and Sub queries and to retrieve data from multiple tables
• Designed and configured SSIS packages to migrate the Customer Information, Contracts Information and other important data from the Excel, Oracle, legacy System using various transformations.
• Created customized SSIS Packages using C# and VB Scripting.
• Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures
• Coding, troubleshooting and performance tuning SQL and complicated SSIS packages.
• Generated reports using SQL Server Reporting Services 2005/2008R2 from OLTP and OLAP data sources.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploy and schedule Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created reports by extracting data from cube.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created report snapshots and cache for better performance.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers...
• Backup and Restore databases.
• Undergo unit testing and integration testing.
• Report bugs, fix assigned bugs and propose possible fixes through Visual Studio.
• Deploy databases to local and to other servers using Visual Studio 2010.
• Use 2010Team Foundation Server for project update and for status update.
• Used Codelook for code review and code update.
• Use ErWin to design schema, forward engineer to create and update scripts and make required changes
• Active participation in agile environment especially SCRUMS.

Environment: SQL Server 2005/2008/2008 R2, T-SQL, Windows server 2008, Octopus, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, PowerShell,Octopus.

Confidential, Redmond, WA

SQL Server BI Developer/Data Analyst

Responsibilities:

• Worked with business users to define and analyze problems, create logical data model, implement physical data model, and considers the implications of business solutions to the current and future environment.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services
• Created SSIS packages with which data sources such as Flat files,Teradata,DB2, Excell files, and PDF files Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS2008)
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Developed adhoc reports without formal specifications often.
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development, handle complex business rules, history data and audit analysis.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Created SQL Agent jobs to automate and schedule ETL Scripts & SSIS Packages.
• Cube designing using SSAS and creating ad-hoc reports.
• Worked closely with IT project managers, programmers, and testers in agile environment.
• Developed Custom ad-hoc, Tabular, Drill Down, and Parameterized, cascaded and sub-reports using SSRS 2008.

Environment: SQL Server 2005/2008/2008 R2, T-SQL, Windows 2003, Oracle, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, Cosmos.

Confidential, Los Angeles, CA

Confidential BI Developer

Responsibilities:

• Develop, maintain, monitor, and performance tuning of the data mart databases and SSAS OLAP cube(s)
• Created Star and Snow Flake Schemas of Data Marts.
• Developed a multi-dimensional database and OLAP cube using SQL server 2008.
• Designed fact and dimension tables, Created multi-dimensional OLAP Cubes.
• Build SSIS Master and child packages for initial load of data and incremental (monthly) loads of data for EDW.
• Manage the ETL function and use of staging tables.
• Proactively diagnose, research, monitor for and resolves SQL and database-related faults and performance problems
• Develop and maintain appropriate repositories of data model and dataflow diagrams relating to the data warehouse.
• Ensures that data projects follow prescribed agile development life cycle and meet quality standards
• Function as a technical expert in the design, development, modification and debugging of data OLAP cubes and databases, etc.
• Develop ETL specifications, source to target mapping and other documentation required for ETL development.
• Ensure appropriate documentation is completed and stored in the repository database.
• Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Built MDX queries for Analysis Services & Reporting Services.
• Developed MDX queries to communicate OLAP and for KPI’s.
• Intensively used SQL Server Integration Services to create the extraction and loading process.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Designed and Developed KPIs, Scorecards.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, SQL Profiler, Erwin, SQL Server Reporting services, TFS (Team Foundation Server), SQL Server Analysis Services, SAP BW, Visio, Share-Point.