Summary
Overview
Work History
Education
Skills
Certification
Disclaimer
Timeline
Generic
Shailja Singh

Shailja Singh

Business Intelligence Analyst
Greater Noida

Summary

Driven Database Expert with 7 years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments.

Overview

8
8
years of professional experience
5
5
years of post-secondary education
5
5
Certifications

Work History

Senior BI Analyst

Oracle
4 2023 - Current
  • Part of Financial Business intelligence in Oracle Advertising to improve Oracle Data Cloud revenue management which is critical for Revenue calculation and payment distribution
  • Collaborated with cross-functional teams to design and implement complex databases to automate them in VBA to ease process
  • Extracting, Integrating and analyzing complex datasets to drive business excellence
  • Creating and executing ETL package to load data into reporting database
  • Support production of Global revenue reporting and post sales operation
  • Creating reporting dashboard for internal stakeholders in Power BI and Oracle Analytics cloud for revenue advertising, Agencies and platform usage
  • Based on requirement do automation of reports through VBA, Python and Pandas
  • Maintaining monthly reports of Data Enablement and Agency reports in Backend
  • Responsible for post sale, provisioning process to create over 10 dashboard and track booking report for internal stakeholders
  • Resolve JIRA queries of user based on data mapping, reporting pipe issue by writing complex SQL queries, creating and altering stored procedure by SQL automation jobs.
  • Reduced report turnaround times by automating manual procedures through the implementation of efficient ETL workflows
  • Optimized data collection methods by identifying gaps in existing databases and recommending corrective actions, improving overall data quality

Business Analytics Specialist

Gartner Inc.
09.2021 - 04.2023
  • Worked closely with Sales and Marketing Stakeholders to support Data Enablement and Stewardship team
  • Performed Data analytics and prepared strategic reports on database of Enterprises
  • Worked on JIRA queries to provide quick solution to Stakeholders by utilizing analytical skills
  • Extracting database of Atacama and involved in cleaning and validating database over one lakh data by using SQL queries
  • Actively involve in creating over 50 thousand record of database and removing duplicates from reports.
  • Created Power BI Data Visualization reports for CRM database to track daily, Monthly and Quarterly deliverable Stakeholders
  • Created VBA program to automatically update Excel workbooks, encompassing class and program modules and external database queries
  • Lead team for new project and actively collaborated for timely delivery
  • Act center point of contact for all project activities liaising with Delivery Managers
  • Collaborated with cross-functional teams to achieve project goals on time and within budget
  • Training and mentoring new joiners and staff.

Senior Process Analyst

Accenture
07.2017 - 01.2020
  • Worked on Project for Google AdWords to actively improve and support backend team of AdWords marketing
  • Involvement in Data Gathering, Validation, Extraction and Manipulation for Google Ad and Cloud team for region EMEA, APAC and NA
  • Utilized VBA for automation of reports to ease project by maintaining error-free data
  • Utilized SQL and other tools to analyze data and generate reports for management and stakeholders
  • Created and executed ETL to load database for Stakeholders
  • Analyzing secondary research data and performing quantitative and qualitative analysis to provide insights into competitive and market intelligence from different sites like LinkedIn Navigator, Bloomberg, Factiva, D&B etc.
  • Maintaining all documentation, check list and SOP's for projects so team can be on same page.

Data Analyst

Heidrick and Struggle
05.2016 - 07.2017
  • Gathering raw information about people, companies, and trends from broad range of resources (Hoovers, Factiva, Business Week, Bloomberg, etc.)
  • Tracking executives from business newsletters (Global Risk news, daily CEO, CFO, and COO moves report)
  • Communicating with clients clarifying their queries on their search project and preparing automated reports on VBA Excel for future use
  • Established the global proprietary database record over 150 per day of Heidrick & Struggles.
  • Creating new records, and deleting/merging duplicate records
  • Proactively tracking industry/function, company, and executive news
  • Mapping industrial codes and Job level to companies as per their profile
  • Industries involved are IT, Healthcare, Manufacturing, marketing, and infrastructure.

Education

Bachelor of Science - Engineering

IIMT Engineering College
Meerut
08.2009 - 07.2014

Skills

  • Business Analysis
  • Business Intelligence
  • SQL
  • Project Management
  • Python (Pandas, Numpy)
  • Power BI
  • Extract Transform Load (ETL)

  • VBA

  • Data Visualization
  • Oracle DBA
  • JIRA

  • Advance Excel

Certification

Certificate for Data Analysis with Excel and Power BI by Digital Vidya

Disclaimer

This is to declare that all information provided above is true to my knowledge and acquaintances and any discrepancy found will be my responsibility.

Timeline

Business Analytics Specialist

Gartner Inc.
09.2021 - 04.2023

Senior Process Analyst

Accenture
07.2017 - 01.2020

Data Analyst

Heidrick and Struggle
05.2016 - 07.2017

Bachelor of Science - Engineering

IIMT Engineering College
08.2009 - 07.2014

Senior BI Analyst

Oracle
4 2023 - Current

Similar Profiles

CREATE PROFILE
Shailja SinghBusiness Intelligence Analyst