Professional Summary:

 Around 8 years of experience in Business Intelligence (Power BI desktop, Power BI desktop

Pro, Power BI Service, Power BI report server), and other related IT development technologies
like MS BI Stack (MS SQL Server, SSIS, SSAS, SSRS), and MS Excel Power Pivot. In-depth
knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting, and Analytics.
 Working with Power BI Service for creating Dashboards and sharing them with business users.
 Creating complex Custom Views using Toad and SQL Developer to create data sets
for Power BI dashboards.
 Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc.,
and creating interactive visuals using geographic data.
 Working with Power BI Service for creating Dashboards and sharing them with business users.
 Extensive experience with different phases of the project life cycle (Analysis, Design,
Implementation, Testing, and debugging new and existing client-server-based applications).
 Strong experience in SQL Development, ETL development using Microsoft SQL Server
Integration
 Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services
(SSAS), and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
 Experience in Database Administration operations like Backup, Recovery, Replication, and
using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
 Experience in creating SQL Server Reports, handling sub-reports, and writing queries to perform
roll-up and drill-down operations in SSRS 2012/2008
 Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace,
statistics, index tuning wizard.
 Experience with working on ProClarity Analytics server to analyze results produced in the
Dashboard.
 Explore data in a variety of ways and across multiple visualizations using Power BI.
 Responsible for creating SQL datasets for Power BI and Ad-hoc reports.
 Extensive experience in designing, developing, and delivering business intelligence solutions
using Power BI, SSIS, Analysis (MDS), and Reporting Services (SSRS).
 Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and
analyzing cubes and dimensions.
 Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS), and SSIS.
 Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports,
Ad hoc reports, and distributed reports in multiple formats using SQL Server Reporting Services
(SSRS) in Business intelligence development studio (BIDS).
 Experience in creating indexed views, complex stored procedures, effective triggers, and useful
functions to facilitate efficient data manipulation and consistent data storage.
 Excellent verbal and written communication skills combined with interpersonal and conflict
resolution skills and possess strong analytical skills.
 Self-motivated and possess the ability for critical thinking, analysis, good interpersonal and
communication skills.
 Team-oriented, technically motivated, and creative. User-oriented with a desire to learn client’s
business requirements.

Technical Skills:
Languages MySQL, PL/SQL, PostgreSQL, DAX, MDX, SnowSQL, R

Databases MS SQL Server, MS Access, Oracle, PostgreSQL, Snowflake

 SQL Server Integration Services (SSIS), SQL Server Reporting Services
(SSRS), SQL Server Analysis Services (SSAS), Business Intelligence
DWH/BI Tools Development Studio (BIDS), SQL Server Data Tools (SSDT), Visual Studio
2017/2015/2012, Crystal Reports, Tableau 9.0/10.3, Snowflake, Power BI
Desktop, Power BI Service

Star Schema/Snowflake Schema Modeling, FACT and Dimensions tables,

Database Design Tools
Physical and logical data modeling and De-normalization techniques, RDBMS,
and Data Modeling
OLTP, OLAP

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server
Profiler, Import & Export Wizard, Visual Studio 2017, BIML Express, Microsoft
Tools and Utilities Management Console, Visual Source Safe 6.0, DTS, Business Intelligence
Development Studio (BIDS), PostgreSQL 9.0/9.1, SQL Server Data Tools
(SSDT), Crystal Reports, Power Pivot, Microsoft Office, ALM, AWS

Operating Systems Windows, Mac OS, Linux

Professional Experience:

Cigna Health, Nashville, TN July 2019 – Present

SQL/Power BI Developer (SSIS/SSRS)

Responsibilities:
 Developed Dashboards and Reports with Excel, SQL Server, SharePoint List, and Report
Server data sources using Power BI Service Desktop tool.
 Involved in database development using stored procedures, triggers, views, and cursors.
 Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
 Involved in designing and publishing visually rich and intuitive Tableau dashboards for
executive decision-making.
 Involved in creating MDX, DAX, Cubes, and Tabular models using SQL Analysis Services
(SSAS).
 Wrote efficient Stored Procedures for the Optimal Performance of the system.
 Implemented projects using Agile Methodology.
 Involved in designing and publishing visually rich and intuitive Power BI dashboards.
 Embedded Power BI reports on the SharePoint portal page and managed access of reports
and data for individual users using Roles.
 Created PL/SQL scripts to extract the data from the operational database into simple flat text
files using the UTL_FILE package.
 Creation of database objects like tables, views, materialized views, procedures, and packages
using oracle tools like Toad, PL/SQL Developer, and SQL* plus.
 Partitioned the fact tables and materialized views to enhance the performance.
 Schedule the packages to keep extracting the data from OLTP at specific time intervals.
 Responsible for rebuilding the indexes and tables as part of performance tuning.
 Monitored performance and optimize SQL queries for maximum efficiency.
 Used SQL Server Agent for scheduling jobs and alerts.
 Designed MDX queries in accessing cubes and hands-on experience in query structuring,
performance optimization.
 Responsible to monitor performance and optimize SQL queries for maximizing efficiency.
  Proficiently scheduled the Subscription Reports with the Subscription Report wizard
 Involved in the analysis, design, development, testing, deployment, and user training of
analytical and transactional reporting systems.
 Used stored procedures, created new stored procedures and triggers, modified existing ones,
and tuned them such that they perform well.
 Tuned SQL queries using execution plans for better performance.
 Optimized by assigning relative weights to the tables in the Catalog and Query Performance
 Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice
and dice and modern data visualization features.
 Designed and developed a new ETL/SSIS package that loads data from OLTP into our
existing Data Warehouse based on technical specifications and business requirements.
 Developed reports using Tableau and QlikView.
 Plan and scheduled the report to run at the desired frequency in Cognos Scheduler and
scheduled the cubes to run on ETL job completion dependency using the Auto sys tool.
 The designed dimensional data model of the OLAP database using Erwin.
 Automated Power Query refresh using power shell script and windows task scheduler.
 Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the
integrity of the data.
 Used Power BI Desktop to develop data analysis multiple data sources to visualize the
reports.
 Responsible for creating and changing the data visualizations in Power BI reports and
Dashboards on client requests.
 Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX
scripting to access data from the Tabular Model.

Environment: Advanced SQL, MS SQL Server 2014/2016, Notes, SSRS, SSIS, SSAS, Power BI, TFS,
T-SQL, DAX, Power BI Desktop, MDX, JIRA, Tableau, Microsoft Visual Studio 2015, Excel, Azure

Truven Health, Denver, CO Feb 2018 – June 2019

Power BI Developer

Responsibilities:
 Coordinated JAD session with the development team to understand functional requirements.
 Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Info Graphic Designer, Spline
Chart to make the visuals look and understand better.
 Created indexes and indexed views for enhanced query performance.
 Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX
scripting to access data from the Tabular Model.
 Designed Data Model in Power BI Designer according to the Structure and Hierarchy of Data.
 Created indexed views, and appropriate indexes to reduce the running time for complex
queries.
 Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
 Monitored performance and optimized SQL queries for maximum efficiency.
 Involved in all phases of SDLC and gathered business requirements from the business.
 Created reports using multiple data providers such as Universes and personal data files in
generating reports.
 Formatted the reports as per the business requirements.
 Involved in validating data between Qlik Sense and Cognos reports
 Participating in Daily stand-up Agile/Scrum meetings to discuss the enhancements to be made
for the existing requirements.
 Used QlikView to extract, transform and load (ETL) source data from transaction systems.
 Implemented Power BI Power Query to extract data from external sources and modify the
data to generate the reports.
 Extracted data from Oracle, SQL Server, Flat Files, Excel, and XML using SSIS and cleanse
the data.
 Designed dashboards utilizing Power BI with rich visuals such as charts, slicers, gauges,
funnel, word cloud.
 Performed data messaging operations using DAX expressions and M code in Power BI.
 Developed Power BI Apps to deliver key metrics to multiple groups within the organization.
 Shared Power BI reports and dashboards to various user groups using app workspace.
 Set up data alerts on Power BI dashboards to update stakeholders.
 Responsible for creating datasets using T-SQL Stored Procedures and involved in Data
visualization.
 Involved in creating stored procedures, triggers, T-SQL and mainly dealt with SSMS.
 Data Architecture, Analysis, and Technical Design solutions for OLTP and Datamart/Data
warehouse ● Used SQL Server Package Configuration technique to make Dynamic
configurations.
 Used Text Files/ SQL Server Logging for all SSIS packages.
 Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to
migrate data from SQL server database to Oracle database.
 Performed Database Administration of all database objects including tables, clusters, indexes,
views, sequences packages, and procedures.
 Generated periodic reports based on the statistical analysis of the data using SQL Server
Reporting Services (SSRS).
 Design and Implement WCF services layer hosted on Windows Azure. This layer is the
middle tier between SQL Azure and SharePoint online external content.
 Create Cache Memory on Windows Azure to improve the performance of data transfer
between SQL Azure and WCF services.
 Developed Advanced PL/SQL packages, procedures, triggers, functions, Indexes, and
Collections to implement business logic using SQL Navigator. Generated server-side PL/SQL
scripts for data manipulation and validation and materialized views for remote instances.
 Build a presentation to present the design of hosting architecture on Windows Azure.
 Maintained a high degree of competency across the Microsoft Application Platform, focusing
on .NET Framework, WCF, Windows Azure, AppFabric, and SQL Azure
 Managed all aspects of the SDLC process - requirement analysis, time estimates, functional
specification, design, development, testing, packaging, and support/maintenance.
 Used Microsoft Power BI Power Query to extract data from external sources and modify data
to a certain format as required in Excel and created SSIS packages to load excel sheets from
PC to database.
 Expertise to follow the Agile process in application development.
 Created On-demand (Pull) and Event-Based delivery (Push) of reports according to the
requirement.
 Deployed and configured the reports in the Report Server.
 Designed and developed a Big Data analytics platform for processing customer viewing
preferences for mobile devices.
 Configured Power BI enterprise data gateway for scheduled data refresh
of Power BI datasets.
 Secured the reports using role-based security in Power BI.
 Designed the POC for migrating the On-premises OLAP database to Cloud for reporting.
  Utilized TFS (team foundation server) for coded check-in/check-out and the management of
differing code versions.

Environment: SSDT (Visual Studio data tools), SSMS (SQL Server Management Studio 2017), T-SQL,
DAX SQL Server Analysis Services 2014 (SSAS), SQL Profiler, MS-Excel, Power BI Desktop, Azure

BMO Harris Bank, Chicago, IL July 2017 – Jan 2018

SQL Server BI (SSRS /SSIS/SSAS) Developer

Responsibilities:
 Efficiently helped in the Software Development Life Cycle (SDLC) processes including
Analysis, Design, Programming, Testing, and Deployment.
 Worked with T-SQL to create Tables, Views, and triggers, and Stored Procedures.
 Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from
multiple heterogeneous information sources.
 Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like
Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task.
 Worked on SSIS transformations like Lookup, Fuzzy grouping, Merge, Union All, Data
conversion, Multicast, Pivot, Un Pivot.
 Created packages in SSIS with error handling and Worked with different methods of logging in
SSIS.
 Experience in creating complex SSIS packages using proper control and data flow elements.
 Designed cubes with star schema using SQL Server Analysis Services (SSAS).
 Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and
patterns in the data.
 Worked on PROCLARITY to create OLAP data sets and queries are created directly from the
unified Dimensional Model.
 Querying and manipulating multidimensional cube data through MDX Scripting.
 Experience with SQL Server Reporting Services (SSRS) to the author, manage and deliver
both paper-based and interactive Web-based reports.
 Developed stored procedures and triggers to facilitate consistent data entry into the database.
 Upgrade enhancements, maintenance, production support, and bug fixes for the project.

Environment: SQL Server 2012, SSAS, SSIS, T-SQL, SSRS, MDX, Report Builder, HP Quality center.

Alfa Mutual Insurance, Montgomery Mar 2016 – June 2017

SQL Server SSIS/SSRS Consultant

Responsibilities:
 Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data
during transferring, and archived data files for different DBMS.
 Generated database monitoring and data validation report in ProClarity and SQL Server
Reporting Service (SSRS).
 Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
 Deployed SSIS packages and Reports to Production Servers.
 Upgraded databases from SQL Server 2000 to SQL Server 2005.
 Responsible for the design and development of .Net web applications for firm Solutions.
 Migrated data using ETL Tool in SSIS.
 Maintained system monitoring jobs and provide high availability support.
  Created partition table for exceptionally large database for good performance.
 Worked on Migration of packages from DTS using SQL Server Reporting Service (SSIS).
 Participated in Databases Architecture and data Modeling design.
 Performing DBA functions, installing, configuring, and supporting database systems.
 Reported all events and requirements through established reporting mechanisms in SSRS.
 Reviewed and developed data models and database designs with development teams wrote
store procedures for some job automation.
 Generated test data and tested database to meet the functionalities deliverables in the project
documentation and specifications.
 Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL, and
DTS/SSIS
 Designed and developed OLAP using MS SQL Server Analysis Services.
 Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2000
and SQL Server 2005.
 In charge of converting data using SQL Server 2005 using SSIS.

Environment: MS SQL Server 2005/ 2000, MS SQL Server Reporting, Services, MS SQL Server,
Integration Services, SSAS, ProClarity, MS SQL Server Analysis Services 2000, C#, ASP.NET, VB.NET,
OLAP, UML, Erwin, DTS/SSIS, BIDS.

DaVita Health, Philadelphia, PA Sep 2014 – Mar 2016

SQL Developer (SSAS SSIS SSRS)

Responsibilities:
 Analyzing and Establishing security features in SQL Server Reporting 2012 Environment.
 Worked on full life cycle development (SDLC) involving in all stages of development.
 Involved in system study, analyze the requirements by meeting the client and designing the
complete system.
 Involved in designing technical specifications for building Data Warehouse.
 Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the
exact data extraction, transformation, loading strategy & Dimensional modeling. Backup &
recovery.
 Developing reports using SQL Server Reporting Services in SSRS 2012. Creating various
value sections in Parameter’s list, designing cascading parameters, matrix dynamics, and
more features in Reporting Service.
 Used advanced features of T-SQL to design and tune T-SQL to interface with the Database
and other applications in the most efficient manner and created stored Procedures for the
business logic using T-SQL.
 Worked on SQL Profiler, Tuning Advisor in SQL 2012 to increase the performance of the
reports.
 Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the
same as jobs using SQL.
 Server Agent.
 Worked with report subscriptions and snapshots in SSRS 2012 to send the weekly run
automated reports to end-users.
 Develop complex MDX, Created Database Objects – Schemas, Tables, Indexes, Views, User-
defined functions, Cursors, Triggers, Stored Procedure, Constraints, and Roles.
 Designed and developed OLAP using MS SQL Server Analysis.
 Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures
in the Tabular Models.
  Scheduling daily, weekly, monthly Reports in crystal Enterprise to run at a particular time.
Creating users, groups and giving them required permission.
 Scheduling of some Reports based on event server. 
 Distributing Reports by e-mail, FTP, or via web access. 
 Designed Web-based Crystal Reports user interface, Security System Interface,
Parameterized Reporting. 
 Created dimension model for reporting system by identifying required dimensions and facts
using ERWIN.
 Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
 Created Grouping, sorting columns, and writing expressions per the business requirements.
 Extensively worked with SSIS tool suite, designed, and created mappings using various SSIS
transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast, and
Lookup.
 Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS
packages and SQL scripts.
 Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
 Developed tabular queries for efficient analysis of reports using Pivot/Unpivot in T-SQL.
 Involved in developing Data Access Components to access the SQL Server Database using
ADO.NET.
 Created Crosstab, Drill-down, Drill-through, and Sub drill-down reports -Report using RDL.
Promoted RDLs to Reporting Service Server.
 Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and
quarterly Reports including status.
 Used Reporting Services (SSRS) to schedule reports being generated at a predetermined
time.
 Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder,
SQL Server Reporting Services (SSRS) 2012
 Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and
involved in database partitioning.
 Created Data Warehouse Cubes in SQL Server Analysis Service (SSAS). 
 Implemented cell-level security in cubes using MDX expressions to restrict users of one region
from seeing data of another region using SSAS.
 Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP
databases.
 Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in
Dimensional Modeling.

Environment: SQL Server Integration Services 2012/2008 (SSIS), SQL Server Reporting Services
(SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio 2012, MS Visual Studio
2012, TFS, GIT, SVN, Rally, and Windows 2012 Server.

Serco, Hyderabad, India Nov 2013 – July 2014

SQL Server Developer

Responsibilities:
 Interacted with Team and Analysis, Design and Develop database using ER Diagram,
Normalization, and relational database concept.
 Involved in Design, Development, and testing of the system.
 Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and
Execution Plan).
  Developed User Defined Functions and created Views.
 Created Triggers to maintain the Referential Integrity.
 Implemented Exceptional Handling.
 Worked on client requirements and wrote Complex SQL Queries to generate Crystal
Reports.
 Tuned and Optimized SQL Queries using Execution Plan and Profiler.
 Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
 Involved in performing database Backup and Recovery.
 Worked on Documentation using MS word.

Environment: SQL Server, SQL, T-SQL, BCP, Visu5075894132al Basic 6.0/5.0, Crystal Reports.