PROFESSIONAL SUMMARY:

• Over 2+ years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2012/2008 with various business domains like Financial, Banking sector
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Excellent T-SQL Development Skills to write Complex Queries involving Multiple Tables, great ability to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views
• Experience in writing complex SQL queries involving Inner and Outer joins, Temp Tables, Global Temp Tables, Derived Columns
• Proven ability in Performance Tuning, Query Optimization
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal Skills
• Well versed with Tuning SQL Queries & Stored Procedures to improve performance
• Extensive experience in T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data Warehousing
• Extensive experience in SQL Server Integration Services (SSIS) and Reporting Services (SSRS) and experience creating Drill-down and Drill-through Reports, writing Expressions in SSRS and Fine-tuning Reports
• Expert in creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs, and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools
• Experience in Creation, Configuration, Development, and Deployment on various servers of Reports using SSRS
• Expertise in Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data using OLEDB connection from varied sources by using multiple transformations including Data Conversion, Conditional Split, Bulk Insert, Merge and Union All
• Experience in Dimensional Data Modeling and Cube Development, Designing of STAR, SNOW FLAKE Schemas, Partition, Aggregation and Optimization using SSAS
• Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 ) and Excel Pivot
• Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014 , calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.

TECHNICAL SKILLS:

Databases Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio

ETL Tools: DTS Data Transformation Services Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report, Tableau PowerBI

Database: SQL Server 2011, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, My SQL

Programming: SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, My SQL, T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Unix.

Other Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point, OLAP & OLTP

PROFESSIONAL EXPERIENCE:

Confidential, ATLANTA, GA

SQL/Power BI Developer

Responsibilities:

• Designed and developed stored procedures, queries and views as necessary. Extensively use joins and sub-queries for complex queries which were involving multiple tables from different databases.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop
• Developed and implemented several types of Financial Reports by using Power Bi. Validated reports and resolve issues in a timely manner.
• Worked on different DAX calculations.
• Implemented Row level security.
• Scheduled Automatic refresh and scheduling refresh in Power BI service
• Created Credit Risk Financial Models
• Migrated existing self-service reports and ad-hoc reports to Power BI.
• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using Power BI.
• Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization.
• Identified various parameters to improve the existing data models for approving credit cards and line increases to individuals.

Environment: SQL Server 2012, Power BI, MS SQL, Server Management Studio, T-SQL, Visual Studio, Excel.

Confidential

SQL/Power BI Developer

Responsibilities:

• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Developed different types of tabular reports, matrix reports, charts and graphs reports that aggregate data using SQL Server Reporting Services.
• Responsible for setting up subscriptions of the reports via SQL Reports Distribution (SQL-RD)
• Embedded the reports on to application using MS Report Viewer in Visual Studio 2010.
• SQL query optimization in SSRS by designing required indexes partitions after analysis using SQL profiler and examining execution plans in SQL server Management studio.
• Created reports from Web Services and using MDX on cubes in SSAS to create reports in SSRS.
• Planned the complete backup (with suitable recovery model) of various Databases.
• Involved in development of OLAP cubes, designed Star Schema, Snowflake Schema & Fact Tables, Created Partitions, Aggregations and Calculated Members in SSAS.
• Created Clustered and Non- Clustered Indexes on tables for performance optimization of complex stored procedures.
• Ultimate Software Implementation and Conversion from ADP processing completed for 5 Hospitals, this included time clock configuration and mapping, import to Multiport of all employee data, setup of all employees and data exports for direct deposit and positive pay files, and a variety of employee related deductions.
• Implementation of any new business, Complete Company setup of multiport software including applications for all applicable Federal, State and Local Taxes. Meeting required deadlines for Company startup.
• Performance tuning of the stored procedures, user defined functions and long running queries.
• Providing information and assistance to the Database Architects on physical models, setup and maintenance of metadata.
• Connect to the data sources in Azure SQL Server and deploying the reports to share point by plugging the reports to the Azure SQL data sources.
• Wrote database triggers for automatic updating, auditing of the tables.
• Deployed SSIS packages across development, test and production environments using project deployment model
• Improved the performance of the slow running queries by using performance tuning.
• Worked in creating stored procedures, views, materialized Views.
• Experience in managing and automating Control flow, Data flow and Events using Microsoft .NET framework for SSIS packages.
• Developed report specifications, created and modified reports using Tableau
• Worked in creating Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
• Experienced in agile environments
• Trained teammates in using JIRA/Confluence.

Environment: Power BI 2.X, SQL Server 2016, Tableau, T SQL Services Integration Services 2016, Visual Studio 2015, SQL Server Reporting Services 2016, SQL Server Management Studio, Excel, C# 4.0