Ramesh

100-100-1234
SQL/ MSBI/ Power BI Developer
Professional Summary:

 Over 5+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL &
Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI, Power BI
and Azure Data Factory, Data Lake.
 Extensively worked on system analysis, design, development, testing and implementation of projects and
capable of handling responsibilities independently as well as a proactive team member.
 Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML,
Waterfall and Project Management Methodologies.
 Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
 Experience in OLTP/OLAP environment and Data Warehouse.
 Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.
 Work experience on MS SQL Server 2012/2008R2/2005/2000, Oracle, crystal reports 6.
 Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS,
Power BI
 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.
 Expert in creating multiple type of reports using tools like Power BI and SSRS.
 Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters,
parameters.
 Designed and developed matrix and tabular reports with drill down, drill through using SSRS.
 Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.
 Worked as MS SQL Server Developer on enterprise and performance critical applications.
 Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS
SQL Server.
 Involved in migration of legacy data by creating various SSIS packages
 Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration
Services (SSIS), DTS, Bulk Insert and BCP
 Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube
using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
 Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL
Profiler and SQL Server Debugger.
 Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files
using SSIS.
 Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model (DAX),
Cubes (MDX) and SQL queries.
 Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in
Logical and physical Design of the Database using Erwin tool.
 Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel
pivot tables.
 Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages
 Excellent verbal and written communication skills with a strong focus on customer facing interaction,
customer service, and presentation.
 Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using
DMV's and creating the necessary environment for Deployment.
 Proficient with automated testing tools – Win Runner, Load Runner and QTP for testing Client / Server and
Web based applications
 Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
 Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
 Good Working experience in designing STAR, SNOW FLAKE Schemas, database modeling, logical and physical
database design using Erwin and Knowledge of how the Kimball approach has been implemented in the
Microsoft BI tool.
 Implement one-time data migration of multistate level data from SQL Server to Snowflake by using Python
and Snow SQL.
 Day to day responsibilities includes developing ETL pipelines in and out of data warehouses, develops major
regulatory and financial reports using advanced SQL queries in snowflake
 Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages.
 Involved in performance tuning and query optimization using tools like Azure Data Factory, Data Lake SQL
Server Profiler, Database Tuning Advisor and Index Tuning Wizard
 Ability to work independently and in a team, capable of handling time-sensitive issues in distributed
environments.
 Used Microsoft Azure date storage and. Worked on creating Azure Data Factory for moving and
transforming the data.
 Excellent Communication and interpersonal skills.

Technical Skills:
RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000, MySQL, Oracle
11g/10g/9i/8i, and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-
SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft
Visio, ER Studio

Reporting Tools: Power BI, SQL Server Reporting Services, Power Apps, Power Query, Crystal
Reports, Power Automate, Tableau, Excel.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages: T-SQL, PL/SQL, HTML, C#.Net, [Link], C++, Java, Java script, CSS, Windows
Scripts

Design Technologies/Tools: Erwin, MS Visio, Rational Rose

Data Warehouse / Business SQL Server Reporting Services (SSRS), SQL Server Integration Services
Intelligence Tools (SSIS), Power Automate (Flow), Visual Studio 2013/2010/2008, SSAS,
Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012
/ Visual Studio Shell

Education:

Bachelor of Engineering in Computer Science, SJB Institute of Technology, Visvesvaraya Technological

University, Bengaluru, India
Professional Experience:

Client: SNH University, Manchester, USA Mar 2021 – Till Date

Power BI Developer /SQL, MSBI Developer

Description:

Southern New Hampshire University (SNHU) is a private University between Manchester and Hooksett,
New Hampshire. The university is accredited by the New England Commission of Higher Education, along
with national accreditation for some hospitality, health, education and business degrees. SNHU is one of the
fastest-growing universities nationwide with 135,000 online students and 3,000 on campus.

Roles and Responsibilities:

 Gathered report requirements, connected with the business/client, conducted brainstorming

sessions, and determined the best solution to provide the results in either a Reporting Services
report or Power BI.
 Setting up the Power BI Environment, creating app workspaces, publishing apps, and setting up
Power BI Gateway.
 Designed and developed various complex reports such as Drill down, Drill Through, Cross
Tabbed using MS Reporting Services and Power BI.
 Published Power BI Reports in the required originations and made Power BI Dashboards available in
web clients.
 Involved in creating data visualizations like Clustered Column Chart, Line Chart, Slicer, Gauge
Visualization etc. with Power BI.
 Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.
 Developing visual reports, dashboards and KPI scorecards using Power BI desktop
 Integrate Power App with Power BI to enable the write back feature from Power BI.
 Worked on DAX query to create calculated columns and calculated measures based on
Requirements.
 Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined
Functions to implement the business logic.
 Created SSIS packages to integrate the data coming from flat files
 Migrated SSIS Packages from old to new versions during data migration.
 Optimized queries by looking at Execution Plan for better tuning of the database.
 Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, and
Flat files.
 Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources
for different reports.
 Designed and developed Tabular Model Cubes. Developed calculated columns and measures using
complex DAX.
 Created Power BI Visualizations and Dashboards as per the requirements.
 Created SSIS packages for loading data from SAP BW/BI to SQL Server.
 Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
 Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures
groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
 Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
 Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc
Reports using MS SQL Reporting Services (SSRS)
  Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc
Reports using MS SQL Reporting Services (SSRS)
 Wrote extensive T SQL / P SQL query for Join conditions, Unions, Aggregations and Expressions for
SSRS Report
 Extracted data from internal data warehouse system to SSRS
 Designed and developed stored procedures, queries and views necessary to support SSRS reports
 Extensively involved in Unit and UAT during the deployment of SSRS report.
 Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using
SSRS.
 Performed database backup and deployment to the production server. Developed custom visuals
using Python and R languages. Configured Integration Runtime (IR) to move the data from on
premise to cloud.
 Worked on PowerShell scripts to automate the creation of resources and resource group.
 Involved in Normalization and De-Normalization of existing tables for faster query retrieval
 Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the
project.
 Designed SNOWFLAKE Schemas.
 Building the pipelines to copy the data from source to destination in Azure data factory (ADF V1)
 Creating stored procedure and scheduled them in Azure Data factory and Creating Data factory in
Azure Data factory.
 Creating multiple data sets in Azure worked in migration of SQL Server 2008/2012/2014 to SQL
Server 2016.
 Worked on Azure Data factory to load the data from on premise to Azure Data Lake.
 Worked on POC to migrate existing on-premises BI platform to Azure Cloud.
 Worked on Azure cloud in spinning of new resources under resource group.

Environment: MS SQL Server 2016/2014, MS SQL Server Integration Services (SSIS), MS SQL Server
Analysis Services (SSAS), Sales force, Intact, Power BI Desktop, Power BI Service, Data Gateway, DAX, T
SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.

Client: HDFC Bank, Hyderabad, India Duration: Dec 2019 – Nov 2020
Role: Power BI Developer /SQL, MSBI Developer

Description: HDFC Bank Limited is an Indian banking and financial services company headquartered
in Mumbai. It is India's largest private sector bank by assets and world's 10th largest bank by market
capitalization as of April [Link] is the third largest company by market capitalization of $122.50 billion on
the Indian stock exchanges. It is also the fifteenth largest employer in India with nearly 150,000 employees.

Roles and Responsibilities:

 Designed and developed Tabular Model Cubes and Dimensions using SQL Server Analysis Services
(SSAS).
 Worked on writing DAX queries and manipulating the multidimensional data in Tabular Model
cubes.
 Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating
Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing
production support for the application as required.
 Developed calculated columns and measures using DAX in Power BI.
 Used the tabular model cubes as the source in Power BI to visualize the data.
 Created Power BI dashboard and generated reports.
  Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from
multiple sources.
 Created multiple transformations and loaded data from multiple sources into the Power BI
Dashboard.
 Published Power BI Desktop to the cloud.
 Created interactive reports customized for the business using Power BI Desktop.
 Installed and configured and maintained Power BI Report Server.
 Experience in combining data from different sources by using of Power Query
 Created some SSIS packages to import and export data from various data sources using SSDT.
 Scheduled the jobs for SSIS packages under SQL Server Agent.
 Deployed SSIS packages using Integrations Service Catalog and through XML configurations
 Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
 Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures
groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
 Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
 Created database objects like tables, users, roles, stored procedures, triggers.
 Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
 Created a few new reports for internal usage using SSRS.
 Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc
Reports using MS SQL Reporting Services (SSRS)
 Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc
Reports using MS SQL Reporting Services (SSRS)
 Wrote extensive T SQL / P SQL query for Join conditions, Unions, Aggregations and Expressions for
SSRS Report
 Extracted data from internal data warehouse system to SSRS
 Designed and developed stored procedures, queries and views necessary to support SSRS reports
 Extensively involved in Unit and UAT during the deployment of SSRS report.
 Responsible for deploying the reports, cubes, and packages on all environments.

Environment: SQL Server 2012/2014/2016, SQL Server Integration Service, Power BI, Azure, SSMS, Jira
(Scrum), T-SQL, PL/SQL, MDX. SQL Server Management studio, Enterprise Manager, Profiler, MS Visio, Erwin,
Query Analyzer, SSIS, SSRS, SSAS, SQL Server DTS, Sybase Visual Studio

Client: Bharti Airtel Limited, Hyderabad, India Duration: Jan 2017 –Nov
2019
Role: SQL /MSBI Developer

Description: Bharti Airtel Limited is a leading telecommunication company globally. Headquartered in New
India, we are the most trusted provider of ICT services with a global network across the USA, Europe, Africa,
Middle East, Asia-Pacific, India, and SAARC regions.

Roles and Responsibilities:

 Responsible for transformation and loading into the target SQL Server databases using ETL tools,
DTS and SSIS.
 Created SSIS packages with which data resources such as Flat files, Excel files, were loaded daily to
create and maintain a centralized data warehouse.
 Made the package dynamic so it fits the environment.
 Scaled SSIS to make it work more reliable.
 Expertise experience with administering and debugging DTS and SSIS.
  Created scheduled jobs to execute DTS and SSIS packages.
 Transferred/Rewrote DTS packages to SSIS Packages. Hands on working experience with configuring
every aspect of SSIS.
 Created alerts, notifications, and emails for scheduled SSIS packages execution.
 Involved in all the implementations, Data modelling techniques, Performance tuning and Query
Optimization with SQL Server database.
 Coordinated other Reporting Analysts in analyzing data and creating management reports.
 Assisted internal and external report needs and designed solutions based on specific requirements
using SQL Server Reporting Service (SSRS).
 Developed reports without formal specifications often.
 Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the
data with MDX script.
 Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various data
sources and thus, developed Cubes.
 Create prototype SQL Server Analysis Services (SSAS) cubes using the Unified Dimensional Model
(UDM).
 Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
 Created a few new reports for internal usage using SSRS.
 Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc
Reports using MS SQL Reporting Services (SSRS)
 Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc
Reports using MS SQL Reporting Services (SSRS)
 Wrote extensive T SQL / P SQL query for Join conditions, Unions, Aggregations and Expressions for
SSRS Report
 Extracted data from internal data warehouse system to SSRS
 Designed and developed stored procedures, queries and views necessary to support SSRS reports
 Extensively involved in Unit and UAT during the deployment of SSRS report.
 Created and developed the stored procedures, triggers, views, and user-defined functions to
support application development.
 Worked closely with IT project managers, programmers, and testers.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), Business Intelligence
Development Studio (BIDS), T-SQL, SQL Server Agent, Java, C#, DB2, Visual Studio 2016, XML, XSLT, MS
Office, and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio.