Sivaramakrishnan SUBBIAH
Abu Dhabi
Summary
As a MicroStrategy Certified Professional, I have over 10 years of experience in Information Technology, covering areas such as database analysis, reporting, development, and administration. My diverse and challenging roles have expanded my data management knowledge and technical skills, allowing me to handle complex IT projects. I've developed the Power BI dashboard and used the report builder tool for ad hoc reports, showcasing my ability to deliver efficient data presentation and analysis solutions.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Data Analyst
Statistics Center Abu Dhabi
05.2023 - Current
- Managed interactive dashboards: Created Power BI dashboards for data-driven decisions.
- Handled data extraction and transformation: Extracted data from various sources and used Power Query for transformation.
- Performed data analysis: Utilized statistical methods in Power BI for strategic business planning.
- Optimized Power BI reports: Enhanced report performance for better user experience.
- Collaborated with teams: Worked with cross-functional teams to deliver actionable insights.
- Maintained data accuracy: Implemented data governance practices in Power BI reports.
- Provided tr
Developer
MOHRE – Labor Market Information Department
12.2016 - 05.2023
- Interacted with stakeholders to analyze requirements and develop prototypes.
- Designed and implemented dashboards to provide business insights.
- Developed MicroStrategy Schema objects including Attributes, Facts, Metrics, and Hierarchies.
- Created Intelligent Cubes and implemented incremental refresh strategies based on data volume.
- Generated standard and ad-hoc reports, incorporating advanced functions like Level Metrics and Conditional Metrics.
- Conducted rigorous testing and tuning to ensure reports met user specifications.
- Managed minor and major enhancements for reports and dashboards.
- Implemented System Manager Workflows for automated report distribution.
Developer
Emirates Airlines – SkyCargo(Strategic Planning Unit)
01.2016 - 12.2016
- As Developer interact with business on analyze the requirement and build the prototype
- Based on prototype approval start creating the dashboards for the business insights
- Responsibilities include: Understanding the user/Client requirement and develop the reports
- Initially build the prototype for the requirement
- Developed Microstrategy Schema objects and Public objects such as; Attributes Facts, Metrics, Consolidations, Custom Groups, Transformations and Hierarchies
- Created Intelligent Cubes, Incremental Refresh depends on volume of data and exertion of report
- Developed different kinds of Standard and Ad-hoc reports
- Involved in Testing and Tuning of Reports and Objects
- Validating the reports to the user requirements by testing developed Reports
- Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filter
- Developing the minor and major enhancement request for reports and Dashboards
- Creating the system Manager Workflows & Distribution service to deliver report to the multiple users.
Support team member
Meijer – Microstrategy – Shared Service Support
01.2015 - 11.2015
- As Support team member involved with Onsite coordinator on daily basis to analyze the ticket and technically assist regarding the problem Responsibilities include: Analyze the incident ticket and fix the issue
- Resolving the tickets raised by the users on timely basis without any impact to other reports
- Modify the public and schema objects based on the incident tickets
- After fix the issues, validating the report against Teradata
- Preparing search objects and list of objects changes document for Object Migration.
Developer
Meijer – Microstrategy – Market Basket Analysis 2.0
11.2012 - 06.2013
- As Developer involved interact with Onsite Coordinator on daily basis to know the business requirement and provide technical assistance regarding problems
- Responsibilities included: Development of Public objects like advanced filters, Conditional metrics and reports
- Creation of Intelligent cubes to improve the performance
- Query analysis, Performance tuning and report data validation against Teradata
- Creation, formatting and analysis of Dashboards
- Analysis of widgets and various grid/graph styles
- Extensive use of panels and panel stacks
- Development and enhancements to the Dashboards and Mobile Dashboard
- Coordination with team members
- Preparing search objects and list of objects changes document for Object Migration.
Developer
HTC Global Services India Pvt Ltd.
06.2012 - 10.2012
- As Developer involved in the BI-COE project
- Responsibilities include: Creating dashboards, reports, public objects, and schema objects and desktop, mobile, object manager, and enterprise managers in MicroStrategy Performing data modeling and analytics Leading the team
Developer
HTC Global Services India Pvt Ltd.
02.2012 - 05.2012
- As Developer involved in the conversion of Actuate reports to SQL Server Reporting Services (SSRS) reports
- Responsibilities included: Creating reports using SQL Server Reporting Services with DB2 as the database Modifying stored procedures for SSRS reports Performing issue maintenance of reports
Developer
Group M
10.2011 - 01.2012
- As Developer involved in the MediaCom Digital Data Reporting project, which involved developing packages on SQL Server Integration Services (SSIS)
- The project involved bringing multiple data sources under one roof to enable reporting through business intelligence tools
- Responsibilities included: FTP File Extraction- Creating application for extracting files from FTP to local systems Analyzing the data and creating tables Extracting data from flat files and transforming the data through business rules and loading into the database Creating stored procedures Performing unit and integration testing
Education
Bachelor of Engineering in Computer Science and Engineering -
Anna University
Tamil Nadu, IndiaSkills
- Microstartegy
- Power BI
- Microsoft Business Intelligence (MSBI)
- Oracle, SQl,Teradata
Certification
MicroStrategy Certified Developer
Training
MS Business Intelligence
Timeline
Data Analyst
Statistics Center Abu Dhabi
05.2023 - Current
Developer
MOHRE – Labor Market Information Department
12.2016 - 05.2023
Developer
Emirates Airlines – SkyCargo(Strategic Planning Unit)
01.2016 - 12.2016
Support team member
Meijer – Microstrategy – Shared Service Support
01.2015 - 11.2015
Developer
Meijer – Microstrategy – Market Basket Analysis 2.0
11.2012 - 06.2013
Developer
HTC Global Services India Pvt Ltd.
06.2012 - 10.2012
Developer
HTC Global Services India Pvt Ltd.
02.2012 - 05.2012
Developer
Group M
10.2011 - 01.2012
Bachelor of Engineering in Computer Science and Engineering -
Anna University
Similar Profiles
Aysha AlmarzooqiAysha Almarzooqi
Specialist, Statistical Quality Assurance at Statistics Center - Abu DhabiSpecialist, Statistical Quality Assurance at Statistics Center - Abu Dhabi
RUAA AL-ASBAHIRUAA AL-ASBAHI
RESEARCH AND INNOVATION TEAM- at STATISTICS CENTER ABU DHABIRESEARCH AND INNOVATION TEAM- at STATISTICS CENTER ABU DHABI
Ebtesam Al ShehhiEbtesam Al Shehhi
Senior Research Specialist at Abu Dhabi Department of Community DevelopmentSenior Research Specialist at Abu Dhabi Department of Community Development
Noof AlbaidhaniNoof Albaidhani
Hospitality Officer /Patient Experience Department at Corniche HospitalHospitality Officer /Patient Experience Department at Corniche Hospital
Saif AlkaabiSaif Alkaabi
Project Manager at Abu Dhabi Executive OfficeProject Manager at Abu Dhabi Executive Office