Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vikram Tulla

Frederick,MD

Summary

Experienced MS BI Developer with over eight years of proven expertise in designing, developing, and implementing Business Intelligence solutions using the Microsoft SQL Server BI stack. Specializing in SSIS, SSAS, SSRS, and Power BI, adept at translating business requirements into efficient data models and delivering impactful insights. Proficient in T-SQL, query optimization, ETL workflows, and multidimensional OLAP database development. Skilled in creating complex SSRS reports, implementing CD/CI pipelines, and ensuring data quality. Strong background in source control using GIT and thorough understanding of QA testing within an Agile and DevOps framework. Excellent communication, analytical, and problem-solving skills with a consistent track record of meeting project deadlines and driving successful outcomes. Flexible, innovative, and collaborative professional ready to contribute expertise to dynamic projects and environments.

Overview

9
9
years of professional experience

Work History

SQL BI Developer

REEF Global Inc
09.2021 - Current
  • Conduct in-depth data analysis and provide comprehensive statistical insights to the Revenue Management Team for both parking and kitchen business segments
  • Develop and integrate SSRS reports seamlessly into web applications, delivering valuable insights to various stakeholders involved in the business
  • Rebuild legacy reports using SSRS specifically for the Revenue Management Team, enhancing the overall reporting structure and capabilities
  • Optimize the performance of complex SSRS reports, ensuring efficiency and speed in the retrieval and presentation of crucial data for informed decision-making
  • Collaborate closely with the Parking and Kitchens functional teams to gain a thorough understanding of the database design and business modules within the Revenue Management System
  • Work in tandem with the Revenue Management Team to develop reports for effective evaluation of the revenue generated from both parking and kitchen operations to perform profitability analysis
  • Create diverse daily transactional reports that serve to streamline day-to-day business operations, ensuring efficiency and accuracy
  • Engage with various cross-functional teams to define and design data pipelines, catering to their specific data needs and facilitating the creation of reports crucial for daily business operations
  • Design and implement a robust data repository tailored to support API services, ensuring seamless and efficient data access for all stakeholders
  • Play a pivotal role in the data conversion process from the Legacy revenue management system to the Current Revenue Management system
  • This involves conducting fit-gap analysis, data mapping, data cleansing, ETL processes, as well as thorough testing and validation
  • Utilize SSIS to develop ETL solutions for the seamless migration of data, ensuring a smooth transition between systems.

MS BI Developer

Chewy Inc
10.2017 - 05.2021
  • Facilitate the pet smart and chewy prescription services merger project by performing fit-gap analysis, data mapping, data cleansing and ETL processes
  • Develop and maintain reports and dashboards to track key performance indicators (KPIs) related to sales, customer behavior, inventory, and other relevant trends and metrics
  • Analyze large datasets to extract meaningful insights that can inform business strategies
  • Collaborate with business stakeholders to understand their information needs and translate them into data requirements
  • Work with data architects to optimize data storage and retrieval processes
  • Develop and implement ETL processes to extract data from different sources, transform it into a usable format, and load it into data warehouse
  • Ensure the quality and integrity of data during the ETL processes
  • Work closely with cross-functional teams including IT, marketing, finance, and operations to gather and analyze data relevant to their areas
  • Developing ETLs using SSIS for loading the legacy prescriptions data store and other systems data feeds
  • Collaborate with database administrators to ensure optimal reports performance and availability
  • Collaborate with data scientists and other analytics professionals on advanced analytics projects
  • Understanding the data components of Legacy prescriptions system
  • Use historical data to identify trends and patterns that can help in forecasting future business performance
  • Assist in the development of predictive models to support business decisions.

Jr. SQL Developer

Bizinsys Inc
02.2015 - 09.2017
  • Design and develop reports and dashboards based on business requirements using SSRS
  • Create visually appealing and interactive reports that provide meaningful insights using SSRS
  • Work with data models created in SSAS to ensure that the necessary data is available for reporting
  • Understand and leverage multidimensional and tabular data models for reporting purposes
  • Write and optimize complex SQL queries to retrieve data from various databases to create various SSRS Reports
  • Ensure efficient and optimal data retrieval to enhance report performance
  • Implement parameterized reports to allow users to customize and filter data based on their needs
  • Provide options for dynamic report parameters and user-driven customization
  • Collaborate with business analysts and other business users to understand reporting requirements
  • Work closely with database administrators and developers to align reporting solutions with overall system architecture
  • Understand existing ETL packages and make the necessary modifications to pull in the additional fields for the facts and Dimension tables
  • Design and modifications of the data warehouse schema to accommodate the new reporting functionalities such as Accounts Receivable, Accounts Payable and Project Accounting
  • Designed Account Receivable Invoice/payment and Account Payables Invoice/payment fact tables and developed ETL Process to enable management to review the status of Invoice and provide the General Ledger/Project related information
  • This provides the most accurate data which will be used by Finance management team to measure and take appropriate business decisions
  • Developed and modified multiple views that are used by the SSRS Report Users
  • Performance tuning of the Existing SSIS packages to support the Intraday Incremental data loads to the Data Warehouse
  • Defined the ETL workflow and package dependencies Performance tuning on various fact tables by designing the proper indexes and table partitioning Document report specifications, data models, and any custom code or queries
  • Maintain documentation to ensure transparency and ease of maintenance
  • Implement version control for reports and associated artifacts to manage changes effectively.

Education

Master of Science in Computer Science -

Hood College
Frederick, MD

Bachelor’s in computer science -

Jawaharlal Nehru Technological University
Hyderabad, India

Skills

  • Microsoft Business Intelligence Tools (SSRS , SSIS , SSAS)
  • Advanced SQL Queries
  • Database Development
  • Report Design
  • ETL Development
  • Data Visualization
  • Data Integration
  • Data Warehousing
  • SQL , T-SQL, C#
  • Git Technologies
  • Agile Methodologies
  • Data Modeling
  • SQL Analytics
  • Interpersonal Communication

Timeline

SQL BI Developer

REEF Global Inc
09.2021 - Current

MS BI Developer

Chewy Inc
10.2017 - 05.2021

Jr. SQL Developer

Bizinsys Inc
02.2015 - 09.2017

Master of Science in Computer Science -

Hood College

Bachelor’s in computer science -

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Vikram Tulla