PROFESSIONAL SUMMARY:

• Over 7 years of experience in Microsoft BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2012/2014/2016 .
• Experience in developing and debugging Stored Procedures and Triggers.
• Expertise in Visualizing and Analyzing Data using Power BI with cloud-based applications.
• Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function ( UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER2005/2008 R2/ 2012/2014/2016
• Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot) , Performance Point Server (PPS), Power BI and Power view .
• Experience in T-SQL Developer skills include stored procedures, Indexes views, User Defined Functions (UDF), Triggers, and Distributed Queries, Scheduled Tasks
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Developing SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, DB2, MS accessing SQL Server SSIS.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in Power BI , creating interactive visualizations, dashboards, reports based on business requirements.
• Excellent hands on experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS .
• Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages .
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union
• Experience in working with Data Cleansing technique in ETL procedures.
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, and Access) and power pivot.
• Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
• Experience developing BI/dashboard components using tools like BIDS, PerformancePoint and Power Pivot.
• Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experience in implementing surrogate key generation strategy in the Data warehouse.
• Experience in generating On-demand and Scheduled reports for management decision and business analysis by using SSRS.
• Experience in databases like MySQL and NoSQL like MongoDB
• Experience in querying Azure SQL Server and working on Microsoft Dynamic CRM
• Well versed with HIPAA, Facets, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Proficient experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in performance tuning, processing and deploying the cubes
• Experience in cube partitioning for better database performance.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 , ORACLE, MS Access.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), SQL* Plus.

ETLTools: DTS, SQL Server Integration Services (SSIS).

Reporting Tools: SQL Server Reporting services (SSRS), PowerBI

RDBMS: SQL Server 2012/2014/2016 , Oracle 11g/10/9i.

T: SQL, PL/SQL, Dynamic SQL, DAX, C# .NET, XML, Java, Hive.

Operating Systems: Windows 7/Vista/XP/2008/2003, Windows 10, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Tracy, CA

Sr.SQL BI Developer/Power BI Developer

Responsibilities:

• Worked as a developer in creating and testing complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked on the backend Databases of health Care applications such as QNXT
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Worked on performance tuning of Views, CTE’s, stored procedures.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Used star schema in designing data marts for creating SSIS ETL packages.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2012.
• Involved in part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Designed SSIS packages to transfer the data from, flat files and Excel documents to the Staging area in SQL Server 2012.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used DAX operations that were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular (SSAS) data warehousing.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations on the Power BI reports and Dashboards on client requests.
• Connecting Power BI to different data sources - SQL databases, Cubes, Web services, Web trends, Excel, Azure.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Involved in UI Design for Power BI Reports and designed effective layouts.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Created Roles and implemented Row level security for user Authentication in Power BI.
• Created effective Dashboards in Power BI Service and made the reports user friendly and interactive.
• Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively. Installed On premise data gateway and scheduled daily data refresh in Power BI.
• Developed Complex calculated measures using Data Analysis Expressions (DAX)
• Deployed the generated reports directly on the client’s workstation.
• Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make the visuals look and understand better.
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Responsible for creating and changing the data visualizations in PowerBI reports and Dashboards on client requests.
• Provided Continuous Maintenance and Development of bug fixes on power BI Reports
• Deployed Dashboards, Reports and Data sources in the Power BI Service .
• Strong experience with source control such as TFS and VSTS.

Environment: MS SQL Server 2016/2012 Enterprise Editions Server Integration Services 2015/2012, MS SQL Server Reporting Services 2015/2012, SQL Server Analysis Services 2015/2012, Power BI, Windows 10.

Confidential, Maryland Heights, MO

Sr. SQL BI Developer

Responsibilities:

• Responsible for gathering/refining requirements from the business for developing dashboards.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Created T-SQL scripts, which generated tables, relationships, based on the finalized ER-diagram
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors (SSIS).
• Created PowerBI Dashboards and integrated them to SharePoint.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Datawarehouse and DAX operations for SSAS 2012.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Create PBI and scorecards for business stakeholders.
• Created, Implemented, Modified the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Given Power BI to Business users which help them to create their own Reports/Dashboards in the Front End.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Worked on Microsoft Azure data technologies experience in Azure SQL Data Warehouse
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2016.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Integrated custom visuals based on the business requirements using Power Bi desktop
• Developed Custom Calculated measures using DAX to satisfy business needs
• Deployed the generated reports directly on the client’s workstation.
• Created Backend validations using Insert/ Update and Delete triggers.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning.

Environment: MS SQL Server 2012, MS SQL Server Reporting Services, SQL Server Analysis Services, Power BI, Windows Server 2007, ASP.NET.

Confidential, Columbia, MD

SQL/MSBI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Sybase, DB2 and SQL 2014).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Used Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all in transformation of SSIS Packages.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema and snow flake schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Datawarehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Define reporting requirements and gather data, using MS Access, and MS PowerPoint to create and maintain management reports, also export data from MS access to MS Excel to create Pivot table for management do more analysis.
• Developed yearly and quarterly company expense reports.
• Experience in T-SQL development activities such as writing stored procedures, triggers, functions and views
• Developed ETL Packages in SSIS to import data on a weekly basis from the OLTP system to the landing zone in the staging area and migrate it to Date Warehouse and data marts
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.
• Used EDI tools to verify mapping to X12 format.
• Involved in implementation of HIPAA EDI Transactions (835,837).
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services tabular data warehousing.
• Created bottom count, top count, cross join, no ascendants and MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2012/2014, SSRS, SSIS, SSAS, Spotlight, MS Access 2000 & Windows 2003/2000 platform, ASP.NET.

Confidential, Roseland, NJ

SQL Developer

Responsibilities:

• Gathered user requirements from users and managers to better understand the business logic of the company and create SQL database that fits their needs
• Designed new SSIS packages as per requirements, resolved the problems.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
• Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.
• Successfully migrated data to new location using Snapshot Replication and implemented Merge Replication to support up to date record of Inventory Information.
• Created Views to replace old tables and created new tables with triggers to support new business needs.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Migrated Crystal Reports to SSRS reports manually
• Created AD-Hoc Report models and drill down and drill through and complex reports using SSRS
• Created custom stored procedures and function to support various new operations.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Alerts and scheduled SQL Agent jobs to generate Reports.

Environment: SQL Server 2008, SSRS, SSIS, T-SQL, Script, JavaScript, ASP.NET, Microsoft Office