Summary
Overview
Work History
Education
Skills
Professional And Technical Tools
Professional Skills Summary
Timeline
Generic

Tania Akhtar

Manchester,CT

Summary

Business Intelligence Analyst with over 9 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.

Overview

9
9
years of professional experience

Work History

Business Intelligence Analyst

Kinsley Group Inc.
08.2020 - Current
  • Developed KPI dashboards and visualizations for data across multiple data sources using Power BI
  • Wrote advanced SQL queries and stored procedures using TSQL to retrieve data from SQL Server
  • Acted as a subject matter expert on data maintained across all data sources
  • Retrieved data from Microsoft Dynamics 365 (CRM) to provide reports
  • Worked within Great Plains (ERP System) to view and understand financial data for reporting
  • Automated manual reporting processes for the company
  • Created data loads and new tables to cover gaps in data availability
  • Maintained best reporting practices and data integrity for all reporting
  • Worked with the company President, CFO, COO to provide insight on improvement opportunities
  • Analyzed data and provided year over year reporting
  • Documented requirements and processes for reporting and the IT team
  • Gathered and organized data across multiple teams
  • Updated and maintained SSRS reports and scheduled reports for distribution
  • Owned and led projects from beginning to end.
  • Streamlined reporting processes for increased efficiency and accuracy with the development of custom dashboards.
  • Enhanced data quality by conducting thorough analyses, identifying discrepancies, and providing recommendations for improvement.
  • Optimized database performance through regular maintenance, query optimization, and index tuning.
  • Supported strategic decision-making processes by delivering timely and accurate insights from complex datasets.

Business Intelligence Data Analyst

Moran Towing Corporation
08.2019 - 08.2020
  • Created and maintained new and existing reports using SSRS, dashboards in PowerBI and creating datasets for business users
  • Worked closely with the business users to identify needs with the data and recorded requirements
  • Addressed and prioritized user requests through the ticketing system related to the Data Warehouse, Reports and access
  • Arranged and led meeting with the business users and technical team to plan and complete projects
  • Worked as the non-technical and technical person to complete projects from end to end
  • Worked heavily with TSQL to do data analysis and provide key information to the business
  • Worked with the Senior Management and VPs to understand business needs for Dashboards and reports
  • Created Fact and Dimension tables for datasets that would be used for adhoc reporting
  • Created simple SSIS packages for loading and transforming data
  • Created and updated documents to track project progress
  • Created production deployment documentation
  • Participated in weekly meetings with the team to address priorities and provide status on ongoing tasks.
  • Enhanced data-driven decision making by developing and implementing comprehensive business intelligence solutions.
  • Optimized data management processes by creating streamlined data pipelines for efficient analysis and reporting.

BI Developer/Data Analyst

Halfaker & Associates
11.2018 - 02.2019
  • Ownership of the Dashboard and Report development plan from requirements gathering and documenting, database design, report/dashboard development, testing and deployment plan
  • End to end planning and ownership of Report/Dashboard development
  • Enhancements to Cognos reports
  • Created Dashboards using Power BI
  • Used TSQL to write queries and do analysis on Data related to Veteran’s biometric information
  • Worked with the Senior Management and VP to understand business needs for Dashboards and reports
  • Provided input on business user requests during meetings and translated them into business and technical requirements
  • Created mapping document and mockups from meetings with business users
  • Created a timeline for Power BI Dashboard development with best practices for documentation, report/dashboard development, database design, test documentation, and deployment process
  • Work closely with DBA’s and Data Architects to develop a database design for Dashboards
  • Create tickets and tasks in GitHub to document steps necessary for creating a Dashboard
  • Attend and contribute to daily scrum meetings with the Reporting team
  • Create project plans with project managers
  • Created tickets in GitHub to manage tasks.

BI Developer

Sompo International (Formerly Endurance)
12.2014 - 11.2018
  • Reporting: Development experience with Cognos 10.2.2 & Cognos 11
  • Created SSRS reports using Visual Studio 2005, 2010, and 2015
  • Created reports with and Report Studio and used Query Studio for data analysis
  • Created models on Cognos Framework Manager
  • Involved in the migration of reports from Cognos 10 to Cognos 11
  • Streamlined data analysis by implementing efficient BI solutions and tools.
  • Involved in SQL Server and SSRS migration from 2005 to 2015
  • Created new SSRS reports based on business requirements
  • Created and managed report distribution schedules
  • Updated existing reports with new enhancements requested by users
  • Experienced in deploying SSRS reports from the Development to QA to UAT and then production server
  • Created nested queries and complex SQL queries for reports
  • Wrote TSQL queries to retrieve appropriate data for new report requests or enhancement requests to add new fields to existing production reports
  • Created Stored Procedures to retrieve data for reports
  • Optimized performance on slow performing reports with indexes
  • Rewrote report queries for best performance by using temp tables and best practices for writing code
  • Worked with Source System teams to retrieve mappings for fields from the Source System to the Data Warehouse to include in reports
  • Participated in error handling for upgraded reports by working with ETL team and DBA
  • Handled 500+ existing reports and triaged reports that would move the new production servers
  • Upgraded 250+ reports from 2005 to 2014 servers
  • SDLC: Followed the SDLC process to document requirements, implement design, develop the report, transition the report for QA testing, monitored UAT and followed change control process for deployment
  • Managed offshore QA resources and tasks assigned for QA testing
  • Coordinated with software testers and developers in the test phase of the product
  • Coordinated release of final products to the development environment for both SSRS and Cognos
  • Created new reports, unit tested report based on requirements before moving to QA for testing
  • Participated in meetings with business analysts, users, and developers to document requirements
  • Created FRD’s for new report requests
  • Translated business logic to technical requirements for reports that would be a tool to present industry related information
  • Work with the ETL team to create mapping documents for required fields from report specification documents.

SSRS Developer

K Hovnanian
10.2014 - 11.2014
  • Updated 200+ existing reports in the BIDS environment
  • Analyzed requirements to better understand need to update parameters and datasets for old reports
  • Created new report parameters to existing reports based on information hierarchy
  • Wrote TSQL queries to retrieve appropriate data from the new database
  • Worked with Business Analysts to understand the requirements for reports
  • Created tabular reports to display information regarding home services, products, sales, financial area
  • Involved in performance tuning of existing database objects such as stored procedures
  • Created and tested reports for the end user
  • Checked in and noted the changes made to reports and deployed reports to the Development environment
  • Involved in Performance Tuning of stored procedures used by reports
  • Used the Execution Plan to better understand slow performance areas and need for indexes
  • Created clustered and non clustered indexes to improve performance
  • Created reports using stored procedures and scheduled and subscriptions for the SSRS reports.

Education

Skills

  • Data Visualization
  • KPI Tracking
  • Advanced SQL programming
  • BI Reporting Tools
  • Database Management
  • MS SQL Server
  • Power BI
  • SSRS
  • Cognos
  • Business Intelligence Analysis
  • Report Writing Skills
  • Requirements Gathering

Professional And Technical Tools

SQL Server Reporting Services (SSRS) 2016, 2014, 2012, 2008 R2 / 2008, 2005, IBM Cognos 10.2.2, IBM Cognos 11, Power BI, SQL Server 2016, 2014, 2012, 2008 R2/ 2008 / 2005, Enterprise Manager, SQL Profiler, Query Analyzer, Management Studio, SSRS, SSIS, SQL Server T-SQL, Microsoft Office Suite, Project, Visio, Visual Studio Team System (VSTS), Team Foundation Server (TFS), Motio Client, Dynamics 365, Great Plains, Windows 10, Windows Server 2008 R2/2008, Windows 8.1, Windows 7, Windows XP

Professional Skills Summary

9+ years of extensive BI/DW experience using Microsoft SQL Server 2018,2016, 2014/2012/2008R2/2008/2005 and extensive knowledge of T-SQL, SSIS, SSRS and Business Intelligence Development Studio (BIDS). Experienced in writing reports using SQL Server Reporting Services (SSRS), Power BI and IBM Cognos. Experienced in creating models in Cognos Framework manager. Created reports and Dashboards with PowerBI. Experienced in writing complex SQL queries and stored procedures for data retrieval in SSMS. Coordinated release of final products to the development environment for both SSRS and Cognos. Well aware of SDLC procedures, change control rules, problem management and escalation procedures. Experienced in working with source control and version control with TFS, Motio CI, and GitHub. Experienced working with Cognos 11, Cognos 10.2.2, Report Studio, Query Studio and IBM Cognos Administration tool. Experienced in creating and updating clustered and con-clustered indexes to maintain and improve the SQL server performance and performance tuning for reports. Good knowledge of System Development Life Cycle (SDLC) and agile environments. Extensively worked on system analysis, design, development and capable of handling responsibilities independently as well as a proactive team member. Participated on on-call support on a rotation basis. Participated in project management, setting timelines and status reporting. Excellent skills in analytical problem solving. Excellent communicating and understanding of business requirements to fulfill client needs.

Timeline

Business Intelligence Analyst

Kinsley Group Inc.
08.2020 - Current

Business Intelligence Data Analyst

Moran Towing Corporation
08.2019 - 08.2020

BI Developer/Data Analyst

Halfaker & Associates
11.2018 - 02.2019

BI Developer

Sompo International (Formerly Endurance)
12.2014 - 11.2018

SSRS Developer

K Hovnanian
10.2014 - 11.2014

Similar Profiles

CREATE PROFILE
Tania Akhtar