SUMMARY:

• Highly motivated SQL server/BI Lead with 9 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 - managed data centers.
• Experience in writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs).
• Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support and maintenance of business applications using SQL Server 2014/2012/2008/2005 , SSIS and SSRS 2005/2008/2012/2014/2016.
• Designed a website using an HTML editor and employing Java and ASP.NET code for various sites functionality.
• Expert database engineer, NoSQL and relational data modeling using Microsoft Sql Server.
• Having good knowledge on Teradata architecture, database features and Teradata tools.
• Used SQL Loader to load data from legacy system (CORE) and developed PL/SQL programs to dump the data from the staging tables to the interface tables and concurrent programs to get data into oracle base tables.
• Extensive knowledge of data warehouse methodologies.
• Proficiency in Database design, Coding, unit testing and Implementation.
• 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.
• 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/2008R 2/2008/2005.
• Worked in Implementation life cycles of both Agile and Waterfall Methodologies.
• 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.
• Performed data migration using tools like Data import/export, BULK INSERT and BCP between different heterogeneous systems and SQL Server.
• Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
• Designed and deployed various SSIS projects using SQL 2014/2016 SSDT to integration services catalogs and scheduled them.
• 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).
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SQL Server 2005 Analysis Services (SSAS) on EDW.
• Experienced in SSAS Tabular data modeling.
• Built a datawarehouse on SQL Server & Azure Database.
• Involved in importing data from large RDBMS systems to Hadoop using Sqoop.
• Hands on Experience working with Azure Data Lake Analytics to analyze the structured, non-structured data from various sources.
• Created different Power BI reports utilizing the desktop and the online service and schedule refresh.
• Assist end users with problems installing the Power BI desktop , installing and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users.
• Assisted customer in configuring and troubleshooting their row-level security for their company.
• Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data
• Experienced in developing Power BI reports 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 OLTP and OLAP environments.
• Hands on experience working with to analyze the structured, non-structured data from various sources.
• Support the business users and resolved issues pertaining to all the supply chain management and distribution modules after go-live
• Involved in performance tuning by checking the loads on Indexes by using sql profiler and Tuning advisor.
• 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.
• 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.

TECHNICAL SKILLS:

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

PL/SQL, T: SQL, .Net, C#, Java, Ruby, Python, Pig Latin.

Databases: NoSQL, DB2, MySQL, Oracle, SQL Server, Sybase

MS Outlook, MS Project, MS: Excel, Power Pivot 2010, MS-Access

Configuration Tools: Team Foundation Server (TFS), GitHub

Data Base Monitoring Tools: SQL Monitor from Redgate, SQL Profiler (SQL Server)

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Power BI Developer

Responsibilities:

• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.
• Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Build GSHS Reports in Power BI from scratch.
• Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Developed various dashboards to know the school climate, school safety, risk factors, and risk behaviors.
• Created dashboard for school system financial information which includes revenue and expenditure by district.
• Developed custom Georgia district map visual , the SVG is written inline within a Bootstrap 2 container.
• Written some Java script plugin that makes the polygons work like hyperlinks.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI .
• Used various sources to pull data into Power BI such as SQL Server, oracle.
• Involved in installation of Power BI Report Server .
• 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.
• Created groups, content packs.
• Created the KPI to show the difference between actual and forecast data.
• 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.
• By using Power BI desktop connected to various data sources, working with different visualizations.
• Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Created several user roles and groups to the end - user and provided row level security to them.
• Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Worked on importing custom visualizations.
• Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.
• Used various data visualizations with Power BI.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• 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 in SSAS.
• Involved in designing partitions in cubes to improve performance using SSAS.
• Created Tabular model reports to slice and dice huge volumes of data.
• Using Tabular model provided more security to data at Row level.
• MDX programming, DAX expressions, analysis and business forecasts.
• Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop .
• Creating reports from importing, direct query and live data from several data sources.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
• Experience in combining data from different sources by using of power query .
• Experience with, power pivot and dashboard designer.
• Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Environment : MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Oracle 11G, SQL Profiler, T-SQL, Power Bi Desktop, Power Bi pro, Visual Studio 2010, HTML5, Java Script.

Confidential, Warrensville, OH

Power BI/Azure Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using power pivot, power query, power view.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
• Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta and history loads.
• Utilized ( Power BI, Pivot/View ) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created data marts and multi-dimensional models like Star schema and Snowflake schema.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI .
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis.
• Extensive use of DAX (Data Analysis Expressions) functions for the reports and for the tabular models.
• Designed/Developed table driven ETL process with Perl and shell scripts, which in turn calls OWB mappings, Informatica oracle code to load EDW .
• Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
• Experience in custom visuals and groups creation in Power BI .
• Experience in scheduling refresh of Power BI reports , hourly and on-demand.
• Apply the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes to develop Power BI reports & effective dashboards.
• Load the processed data into final view point centralized DWH for further Power BI reporting.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Working experience with column store indexes, table partitioning in SQL SERVER 2012.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of event handlers, loggings, checkpoints, transactions and package configurations.
• Designed high level ETL architecture for overall data transfer from the source server to the enterprise services warehouse.
• Worked in creating complex stored procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated reports using global variables, expressions and functions.
• Configured reporting services in SQL Server 2008.
• Created different power pivot reports as per the client requirement.
• Gathered data and visual requirements from business users to deliver effective reports, dashboards and analytics.
• Experience in creating multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI .
• Experience in designing, building the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Performance tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte’s, redesigning schemas and many more.
• Also, went through query execution plans, sql profilers and did query optimization.
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets and Power Pivot.
• Involved in performance tuning using indexing (Clustered Index, Non-Clustered Index) tables.
• Created different Power Pivot reports as per the client requirement.
• Converted the existing Azure Data Factory V1 to Azure Data Factory V2 and also implemented SSIS package in Azure environment using Integration Runtime (IR).
• Done configure diagnostics, monitoring and analytics on Azure platform along with scale and resilience for Azure websites.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: MS SQL Server 2008R2, T-SQL, SQL Profiler, Visual Studio (2012), Power Bi Desktop, Team Foundation Server (2012), MS Analysis Services 2005, MS Reporting Services, MS Access, Import & Export Data, Oracle Warehouse Builder, Power Bi Desktop, Power Bi pro, Source Control Management System Windows XP, Index Tuning Wizard.

Confidential, Washington, DC

Sr. MSBI Developer/Azure Engineer

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.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• C reated 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.
• 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.
• B uilt connections to/pulling data from AS400, mainframe/db2 and Oracle.
• 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.
• Hands on experience in managing Azure Storage Accounts.
• 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 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.
• Extensive knowledge and hands on experience in azure data warehouse, data lake and data factory, U-SQL .
• Verified business requirements and functional specifications.

Environment : MS SQL 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), Pig, Azure, SQL Profiler, T-SQL, Power Bi Desktop, Data Warehousing, Data Transformation Services (DTS).

Confidential, Atlanta, GA

MSBI/Azure 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.
• Architected Cubes with PowerPivot, MDX, SSAS.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on maintaining, generating reports and data migration using SQL Server 2008, SSRS, SSIS.
• Worked on Azure Data Factory to orchestrate the ingestion of data from various sources like Azure tables, Azure SQL Database, Azure SQL DWH, Azure Storage Blobs, and on-premises databases to Azure Data Lake Store.
• 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.
• Monitor the data factories which pulls the files to blobs, Unzip the files, limits the data to 5 years and load into SQLDW through external tables which sits on top of storage account.
• 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.
• Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• 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 T-SQL queries using various join conditions.
• Involved in using Sqoop for importing and exporting data into HDFS.
• 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, 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 with power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created reports in Power BI 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.

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

Confidential

SQL/Business Intelligence Consultant

Responsibilities:

• Installed & Configured SQL Server 2000 for development purpose.
• Migrated certain packages from SQL server 7.0 to SQL server 2000.
• Created DTS packages to transfer the data from oracle to SQL Server 2000.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since stored procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Involved in performance tuning of the database and T-SQL queries using explain plan.
• Created indexes, constraints and rules on database objects.
• Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index Tuning Wizard.
• Designed and developed MS SQL Server stored procedures using T-SQL statements from scratch.
• Developed triggers on views to populate base tables.
• Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update or delete.
• Create stored procedures and user defines functions to supports efficient data storage and manipulation.
• Handling database objects with Enterprise Manager
• Provided technical documentation for future enhancements.

Environment: MS SQL Server 7.0/2000, T-SQL, Query Analyzer, SQL Profiler, Enterprise Manager, Windows Server 2000.