SUMMARY:

• Highly motivated SQL server/Power BI developer with around 8+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, MSBI Stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying and managing applications and services through a global network of Microsoft - manageddata centers.
• Experienced in client requirement Analysis, Physical, Logical design, development Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2014/2012/2008/2005, SSIS and SSRS 2005/2012/2014/2016.
• Strong ability to analyze user requirements, Business Requirement Specifications.
• Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation
• Experience in configuration and maintain Report Manager and Report Server for SSRS, deployed and scheduled the reports in Report Manager.
• Expert in creating and developing Power BI Dashboards in to rich look and tested Power BI reports of Database and verified it with the source data.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014/2008/2005.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER functions.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Extensive knowledge in Tuning T-SQL queries to improve the database performance.
• Designed and developed new ETL/SSIS package that load data from OLTPinto our existing Data Warehouse based on technical specifications and business requirements.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled DTS/SSIS Packages.
• Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL in SSRS.
• Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
• Expertise in Power BI, Power BI Pro, Power BI Mobile
• Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SQL Server Analysis Services (SSAS) on EDW.
• Worked on Power BI which acts like a cloud service that works with Excel to provide a Self-Service BI.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Experienced in Developing Power BIReports and Dashboards from multiple data sources using Data Blending.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTPand OLAP environments.
• Support the business users and resolved issues pertaining to all the Supply chain management and distribution modules after go-live.
• Excellent knowledge of all the phases of Software Development Life Cycle (SDLC).
• Involved in keeping the team focused and on track and also established meeting times, places and agendas.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week using POWER BI
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
• Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
• Also have knowledge on various industries like insurance, finance, health care, retail.

TECHNICAL SKILLS:

BI Tools: POWER BI, SSIS, SSRS, SSAS

RDBMS Servers: MS SQL Server 2016/2014/2012/2005

Operating Systems: Windows, Linux

Programming Languages: PL/SQL, T-SQL, Java, Python

Databases: Oracle, SQL Server, NoSQL, DB2, MySQL, Azure, RedHat

Office Applications: MS Outlook, MS Project, MS-Excel, MS Visio

Configuration Tools: Team Foundation Server (TFS), GitHub

Data Base Monitoring Tools: SQL Monitor from Redgate, SQL Profiler

PROFESSIONAL EXPERIENCES:

Confidential, New Jersey

Sr. Power BI developer

Responsibilities:

• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Used Power BI Desktop to connect various data sources and worked with different visualizations and created dashboards.
• Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages usingVBScript.
• Created automation script to Scale up/down the Data Warehouse.
• Used various Data Visualizations with Power BI and published reports to Power BI Services.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.
• Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Designed SSIS packages to transfer data from various sources like Oracle, text files, XML Files, SQL Server, Excel andAccessto SQL Server.
• Created SSIS packages to extract data from OLTP to OLAP systemsand scheduled jobs to call the packages and Stored Procedures.
• Developed Tabular Model infrastructure in SSAS for various Lines of Business and created over different interactive Dashboards using various visualizations in Power BI Desktop
• BuiltMDXqueries and Data Mining Expression (DMX) queries for Analysis Services & Reporting services.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabularSSAS database.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of theSSAScubes and MDX queries.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Using Power BI connect live to Analysis Services models both tabular and Multidimensional cubes.
• Developed Reports to visually explore data and create an interactive report Excel and Power BI.
• Using a Query Editor in Power BI performed certain operations like Fetching data from different file.
• Working with import and direct query, creating custom table in the Power BI.
• Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Dashboards using cloud service.
• Working with table and matrix visuals, Worked with different level of filters.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region usingSSAS.
• Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations inSSAS.
• Applied various data transformations like slowly changing dimension, aggregate, lookup, multicasting, conditional split and derived column in SSIS.
• MDX Programming, DAX Expressions, Analysis and Business Forecasts.
• Created dimensions by defining Parent-Child relationships, using different dimension types.
• Involved in planning, defining and designing star/snowflake diagramsusing Erwin on business requirement and provided documentation.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets.
• Worked on Adding tiles to the dash boards, images to the dashboards using Power BI services.

Environment:MSSQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Azure, SQL Profiler, T-SQL, Power Bi Desktop, Power Bi pro, Visual Studio 2010.

Confidential, Bentonville

SQL Power BI Developer

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed SSAS cube to hold summary data for dashboards and OLAP Analysis.
• Used various Data Visualizations with Power BI and published reports to Power BI Services.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Successfully migrated content from MS Access to SQL Server 2000, SQL server 2000 to SQL server 2005, SQL Server 2005 to Oracle 10.g.
• Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Created Databases on PLSQL
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2000, MS SQL 2008/2012/2014, SSIS, SSRS, Power BI, Power Pivot, PLSQL, XML, T-SQL, MS Excel, SharePoint Portal Server 2003/2007, ETL, Visual Studio MS Access, Oracle 11g/12c

Confidential, New Jersey

MSBI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Worked on Azure WebJobs which run every hour and pulls the Files from a Data Drop File Share and unzip them to move to various Blobs and Registers those File names in Catalog.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Created Pig scripts to the files landing in Blobs to position the fields According to the Third party requirement.
• Verified business requirements and functional specifications.

Environment: MSSQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Azure, SQL Profiler, T-SQL, Power Bi Desktop, Data Warehousing, Data Transformation Services (DTS)

Confidential

MSBI Developer

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and Sql Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard and VB scripts, Sql Server Migration Assistant (SSMA) and SSIS packages.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various Hospital Database systems using SQL Server 2008, SSRS and SSIS.
• Worked on Azure Data Factory to orchestrate the ingestion of data from various sources like Azure tables, Azure SQL Database, Azure SQL Datawarehouse, Azure Storage Blobs, and on-premises databases to Azure Data Lake Store.
• Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans.
• Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development. T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints & Database triggers.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions.
• Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.
• Unit tested and tuned SQLs and ETL Code for better performance.
• Created and maintained Technical documentation for launching HADOOP Clusters and for executing Hive queries and Pig Scripts.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Deployment of SSIS packages and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Designed rich dashboards withpowerBIand prepared user stories to create compelling dashboards to deliver actionable insights.
• Created reports inPowerBIpreview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
• Conduct Code Walkthroughs, and perform SSIS/SSRS peer reviews.
• Used Team Foundation Server 2010 to check in code artifacts and Techno solutions, Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.
• Created database-staging tables for running the QAS batch for Postal Address Validation.
• Worked with Managers to prepare requirements gathering documents and quality documents.

Environment: SSIS 2008/2012, SQL Server 2008R2, T-SQL, Hive, Microsoft Access, SSRS, Azure, Microsoft Excel, VBScript, SQL Server Migration Assistant (SSMA).