1

KOUSHIK VELDANDA +91 901 444 3043

[email protected]
BI Analyst & Developer
Profile Summary
• Above 5.5 years of experience in Business Intelligence, Data Visualization, Database/ Data
warehouse Design, Development and Data Extraction using Microsoft tools
• Experience in the Latest BI Tools Tableau, PowerBI, SSRS, SSIS SSAS, Mem-SQL, SQL Server
Management Studio
• Got good recognition for sharing knowledge on Tableau by presenting sessions to entire BI team
members of company
• Outstanding team player with excellent problem-solving skills, with good interpersonal and excellent
business communication skills
• Excellent experience in migration of data from Excel, Flat file to Microsoft SQL Server using SSIS and
DTS utility
• Good knowledge in configuration of SSRS server and Tableau Server
• Implemented navigations using Buttons & Bookmarks and enhanced UI with multiple viz. in PowerBI
• Developed multiple workarounds for new visualizations in Tableau and for new methods in SSRS as
Auto hide, Pie Charts and other
• Awarded as Innovative Mind for the three times in GGK Tech for implementing the innovative ideas
which reduces Client’s risk and increases company branding
• Awarded Star Performance for a couple of times for the continuous productivity towards project
• Learned Mem-SQL and compared with standard SQL RDBMS
• Handling BI operations/training's as apart of BI – Tech COE team member
• Have experience on Agile Methodology and good knowledge on VS online, Team Foundation Server,
Branching & Merging, Code Analyzer
• Led a team that delivered applications in time
• Worked on POCs and documented the rendering times for each reporting tools
• Extracted data from various data sources into the BI tools, Visualization tools using scripts
• Had experience on handling Deployments in UAT and Prod environments

Certifications
• Completed 70-461/462/463 certifications on Microsoft SQL Server and certified as MCSA
• Certified by Tableau as Tableau Desktop Qualified Associate
• Certified by Microsoft as PowerBI developer after completing “Analyzing and Visualizing Data with
Microsoft Power BI” certification
• Completed 70-767 certification on Implementing Data Warehouse from Microsoft
• Certified by Google as Google Analytics Individual Qualification (IQ) on analytics

Work Experience
• Working in GGK Tech as Senior Software Engineer from June 2014

Technologies/ Tools known:

• MSBI Stack: SQL Server (>2008), Mem-SQL, SSIS, SSAS, SSRS, PowerBI
• Others: Tableau (>9.0), Crystal Reports, Bash, Python (basics), C#, MS Office, VSTS (App & Web)
• Big Data Stack: Have knowledge on HDFS, PIG, Spark, Oozie, Hue, Flume, Zeppelin
• Cloud: Google Cloud
• Operating Systems: Windows 10/8/7/XP, Linux, Mac OS

Koushik Veldanda
2

Projects:
Data Analyst/ Database Developer/Power Bi Developer
CMFG – Credit Union, USA - April 2019 to Present
CMGF is a Credit Union based industry, which performs the analysis on Credit Union data and
showcase the gaps to respective.
• Familiar with Symitar and DNA data models of Credit Union
• Analysed client data and applied quality rules to it
• Developed Power BI reports and dashboards with multiple data sources
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
• Implemented row-level security for multiple credit unions.
• Used Power BI Gateways to keep the dashboards and reports up to date
Environment: SQL Server 2016, SSIS, PowerBI

Data Analyst/ Database Developer/ SSRS Report & Power Bi Developer

GFOB - Travel Agency, Australia - April 2017 to March 2019
GFOB is the Travel Company which has multiple agencies. It provides water and road way transports
at New Zealand, GSA and Australia. All agencies are the mediators who collects info from passengers
and book their trips.
• Analysed Client data on Oracle and collected different KPIs
• Added branding of company by adding some additional tasks, which improves their business
• Developed multiple PowerBI reports with multiple Navigations, Bookmarks and market visuals
• Improved client interface with their agencies by suggesting a new portal interface between them
and designed the mock-ups
• Responsible for Designing the Reports as per the KPIs and converted Crystal reports to SSRS
• Worked on Data-Driven Subscriptions and created a specific schema defined database for it.
• Added a CDC instance between Oracle and SQL to maintain live data
• Created SSRS Reporting server and linked with portal to display developed reports.
• Developed SSIS packages to load data between CDC to stage and data warehouse databases
• Developed multiple work around techniques in SSRS reports and made them beautiful
Environment: SQL Server 2016, SSIS, SSRS, Oracle 11g, SSRS Reporting Server, PowerBI

Database Developer/ Tableau Developer

iBSM, Inovalon, Solution Provider, USA, Aug 2016 to Mar 2017
Inovalon is a Solution Provider for insurance companies. IBSM is an internal application which deals
with organization growth and employee details
• Quickly learned Actuate tool and Worked on migrating IBSM reports developed on Actuate tool to
Tableau.
• Modified iBSM ETL process to accommodate the changes related to Tableau migration.
• Worked as Business Analyst and analysed specifications. Identified different requirements and
converted them to technical tasks
• Provided Training to different business users to develop dashboards in workspace.
• Created interactive dashboards by combining views in Tableau Desktop, that were presented to
Program Managers and Business/ End Users.
• Generated tableau dashboards for sales with forecast and reference lines.
• Created URL Actions to navigate from one Dashboard to another.
• Developed Tableau reports with complex functionalities like cascading, data blending, auto-hide and
rich visualizations
• Scheduled data refresh on Tableau Server for weekly and monthly
Environment: SQL Server 2016, Tableau 9.2, Tableau Server, Actuate

Koushik Veldanda
3

Database Developer/ SSRS Report Developer/ Tableau Developer

INDICES, Inovalon, Solution Provider, USA, Jun 2015 to Aug 2016
It deals with the generating of reports to the end clients of Inovalon. It collects the data from all
applications and stores in respective databases. Cubes were built on top of RDBMS. Based on the
databases and Cubes reports were generated by using Tableau, SSRS, SharePoint
• Created partitions and improved the performance of cubes
• Creation of Meta-data for the input data and applied the business standards
• Moved the solution from package deployment to project deployment model, to improve the
security, maintainability, and speed of delivery of changes or updates
• Fixed multiple issues with existing SSRS reports
• Performed the research and analysis for Inovalon to evaluate Tableau versus Power BI and SSRS,
through bench-marking with various relevant datasets
• With the help of cubes and database, developed SSRS, Tableau reports and published on SharePoint
• Implemented various changes in the cube design and in flat SQL tables to improve ETL data load as
well as reporting performance
• Understood the domain well to ask the relevant questions and solve the issues
faster Environment: SQL Server, SSIS, SSAS, SSRS, Tableau, Tableau Server

Database Developer/ ETL Developer

iPort, Inovalon, Solution Provider, USA, Jan 2015 to Jun 2015
This module entirely deals with raw data, which came from different clients. We need to convert the
raw data to traditional RDBMS model and push to different modules. This entire conversion and ETL is
automated by using custom SSIS packages.
• Understood the functionality and developed the data load processes
• Created custom SSIS packages which handles Fault Tolerance
• Prepared estimates, strategy & plan for the development tasks
• Created metadata for all required tables to make the process smooth
• Worked on UAT, Prod deployment process and resolved multiple issues
• Conducted knowledge sharing sessions for Team members
• Validated existing test scenarios, and updated them based on the identified gaps
• Performed peer reviews and followed Agile methodology
Environment: SQL Server, SSIS, C#

POC: Clickstream Analytics (Internal)

Problem statement: Generate real time analytical reports based on huge live data.
• Identified and understood the KPIs for analysing clickstream data
• Wrote Spark SQL, and Hive QL to prepare the metrics/required data for metrics from Hadoop HDFS
• Created reports (dashboards and storyboards) on Tableau and PowerBI.
• Worked on designing the data model for fast query performance
• Applied the best practices of Hadoop and compared with all traditional BI tools
Environment: Tableau, SQL, Spark SQL, Hive QL, Power BI

Education:
• B-Tech in Electronics and Communication of Engineering, 2014
71.6%, CVR College of Engineering, Hyderabad
• Intermediate in MPC, 2010
87.6%, Sapthapadi Junior College, Nalgonda
• SSC, 2008
84.3%, Krishnaveni Talent School, Nalgonda

Koushik Veldanda