Rabbani Burhanuddin, Senior Data Analyst

Rabbani Burhanuddin

Senior Data Analyst

United Way

Location
India - Hyderabad
Education
Master's degree, Computer Science
Experience
11 years, 0 months

Share My Profile

Block User


Work Experience

Total years of experience :11 years, 0 months

Senior Data Analyst at United Way
  • Canada - Alberta
  • May 2016 to April 2020

• Built reports and dashboards with SSRS (SQL Server Reporting Services) and Power BI. These reports were automated.
• Created dashboards in Andar and Power BI using complex SQL scripts.
• Built SSIS Packages for data transfer.
• Stakeholders were Executive Leadership Teams.
• Increased overall efficiency of the team.
• Developed efficient SQL queries for data extraction and loading.
• Created self-serve reports for slicing and dicing.

Environment: - MS SQL Server 2016, Microsoft Office Suite 2016, Andar, CSS3, Power BI Service, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), Report Builder 3.0

Data Analyst at Strathcona County
  • Canada - Alberta
  • June 2018 to September 2018

• Transformed and loaded Unstructured Data (Microsoft Word File) to Structured Data (SQL Server Database) using C#.net Interop.
• Created data models for importing the data into SQL Server database from unstructured data source.
• Created complex scripts for ETL into SQL Server.
• Created KPI reports using SSRS from the transformed structured data.
• Built reports from three different sources (Microsoft Word File, Microsoft Excel File & Questica Data (SQL Server))
• Published the SSRS reports onto the Power BI Report Server (PBRS).

Environment: - MS SQL Server 2016, Microsoft Excel 2016, Microsoft Word 2016, Report Builder 3.0, SSRS (SQL Server Reporting Services), Visual Studio 2017

Data Analyst at Center for Advanced Public Safety
  • United States - Alabama
  • March 2012 to March 2016

• Involved in Data migration between different law enforcement agencies in Madison County (Alabama).
• Participated in creation of Case Management System for Madison County Alternative Sentencing Office (MCASR).
• Created data models for data extraction into SQL server databases.
• Created KPI reports, Business Intelligence reports and Data Analysis using Tableau, SSRS and CARE (Critical Analysis Reporting Environment).
• Created ETL templates and designs for CARE Dashboards.
• Created XML schemas in compliance with NIEM (National Information Exchange Model)
• Statistical Analysis of large Datasets for federal agencies using R platform and MINE tool
• Created Data modeling diagrams (Dimensional Model).

Environment: - MS SQL Server, Oracle, Excel, TOAD, SQL Developer, C#.net, MS Visual Studio 2012, MS Office, Liquid XML, NIEM (National Information Exchange Model), SSRS, R, CARE ETL Reporting Tool, MINE statistical tool, Power BI

Data analyst at Standard and Poor's
  • United States - New York
  • August 2011 to February 2012

• Part of Sovereign countries rating team involved in creation of Decision Support System for Financial Analysts across the globe who would rate financial institutions for auditing.
• Worked in coordination with development team for new Case Management System.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Closely worked with ETL team in identifying the design pattern.
• Involved in AGILE methodology with updates on daily scrum meetings. The Scrum meetings were handled by VersionOne.
• Performed data analysis and data profiling using complex SQL on various source systems including Oracle.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Environment: - SQL, Excel, Oracle, TOAD, SQL Developer, Arrow Global (S&P Proprietary), VBA Macros, VersionOne

Business Intelligence Analyst at Bausch n Lomb
  • United States - New York
  • March 2011 to July 2011

• Created standalone reports using SAP Business Object Desktop and SAP Business Objects Web Intelligence Reports application.
• Creation of SAP Business Objects Universe.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2.
• Worked in importing and cleansing of data from various sources like Oracle, flat files onto Oracle
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, SAP Business Objects XIR3, Oracle 10G, TOAD, Sapphire R5.

Data Tester at Verizon Wireless
  • United States - Ohio
  • August 2010 to December 2010

• The project was the deployment of Verizon Wireless 4G Network in Columbus, OH.
• Performed IRAT tests which include 4G to 3G CS cell reselection in idle mode, 3G to 4G CS cell
Re-selection in idle mode.
• Used Delorme for route planning and directions.
• Responsible for solving all the issues with LLDM & WINDS software and post processing of the data.
• Writing scripts to test the data from different cells.
• Operate database management system for RF data from different cells.

Environment: Microsoft Excel, WINDS, LLDM, Windows XP

Graduate Assistant at Northwest Missouri State University
  • United States - Missouri
  • January 2009 to May 2010

• Maintained database for entire chemical inventory.
• Created reports depending on dept requirements using TOAD.
• Guided undergraduate students in different lab activities including Organic chemistry and Bio- Chemistry Lab.
• Graded exercises, assignments, worksheets, as well as record grades and attendance.

Environment: CISPro, Oracle, TOAD, Windows XP

Web Content Editor at Northwest Missouri State University
  • United States - Missouri
  • August 2009 to December 2009

• Published The Northwest Missourian newspaper on the website www.nwmissourinews.com.
• Won third prize for best college newspaper website by Associated Collegiate Press in the year 2009.
• Extensively used HTML and XML for publishing.
• Designed advertisements for student publications using Adobe InDesign and Photoshop.
• Published data onto the newspaper from student journalists.

Environment: College Publisher 5.0, HTML, Adobe InDesign, Photoshop, Dreamweaver, Flash, Macintosh

Education

Master's degree, Computer Science
  • at Northwest Missouri State University
  • May 2010

Masters in Computer Science Aug' 2008 - May 2010 Northwest Missouri State University Maryville, MO

Specialties & Skills

Business Intelligence
Data Warehousing
Data Analysis
ACCEPTANCE TESTING
ADOBE INDESIGN
ASP.NET
BUSINESS REQUIREMENTS
CHANGE CONTROL
Data analysis
Power BI
SQL Server
R Scripting
TIBCO Spotfire
Tableau

Social Profiles

Personal Website
Personal Website

URL removed due to policy violation. Please contact support for further information.

Languages

English
Native Speaker
Arabic
Beginner
Hindi
Native Speaker
Telugu
Native Speaker
Urdu
Native Speaker

Training and Certifications

SAP Business Objects (Training)
Training Institute:
RITNOA
Date Attended:
December 2010
Duration:
200 hours

Hobbies

  • Cricket
    Played tournaments for University of Alabama