Summary
Overview
Work History
Education
Skills
References
Certification
Languages
Websites
References
Timeline
Generic

Ankit Jain

Quakers hill,Australia

Summary

Adept at leading data analysis and integration projects at Service NSW, I excel in crafting custom data solutions that streamline business processes. My expertise in SQL, Tableau/Power BI, and stakeholder collaboration has driven significant improvements in software development compliance and efficiency. Renowned for problem-solving and technical documentation, I consistently deliver projects that exceed business objectives.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Fraud Intelligence & Data Analyst-Team Lead

Service NSW
08.2021 - Current
  • Lead the design, analysis, and development of custom data solutions, ensuring the successful integration of complex technical requirements into business processes.
  • Collaborate with development teams to provide comprehensive support for software and technical solution development, ensuring compliance with endorsed software development methodologies.
  • Conduct in-depth cost analysis and feasibility assessments for new and ongoing projects, ensuring alignment with budgetary and timeline constraints.
  • Develop and maintain technical documentation, including detailed solution designs, reports, and progress updates for review by senior management and stakeholders.
  • Identify and resolve issues during the development process, proposing innovative alternatives to meet user and enterprise requirements.
  • Oversee go-live support and maintenance activities, ensuring the successful transition and implementation of solutions into the production environment.
  • Collaborate with cross-functional teams to monitor workloads, ensuring the efficient allocation of resources and achievement of business goals.
  • Perform technical evaluations and provide recommendations for continuous improvement of software development processes.

Business Analyst Tableau

Infosys Itd
01.2021 - 07.2021
  • Conducted thorough data analysis and modeling, presenting evidence-based insights that supported decision-making processes
  • Created and managed data plans to ensure alignment with business objectives and scalability
  • Analyzed and mapped business performance metrics, contributing to improved operational strategies
  • Engaged with stakeholders to influence data-driven decisions and negotiate project scopes
  • Managed and conducted ad-hoc research and trend analysis to support business development initiatives
  • Offered recommendations to enhance digital functionalities, resolve usability issues, and prioritize development tasks
  • (Client- Optus Telecom)

SQL Developer

Credit Corp Ltd
11.2020 - 01.2021
  • Involved in writing complex SQL queries on DEV and production environment for Daily Data load to Provide updated Credit user data to Customer care team
  • Involved in stored procedure/ T-SQL queries to get desired output which create daily data load into Data warehouse/Data flow for visualization

Junior Data Analyst

TATA Communication
07.2019 - 09.2020
  • Responsible for building a data warehouse, data visualization for all telecom network stations to manage the KPIs.
  • Expertise in writing T-SQL queries, dynamic queries, sub-queries, and complex joins for generating complex stored procedures.
  • Assisted with the analysis and evaluation of project requirements, helping to define technical approaches, and identify potential risks or challenges.
  • Provided analytical support for the development of custom data solutions, ensuring that business goals were met and that solutions were aligned with project objectives.
  • Performed data cleaning, analysis, and reporting tasks, providing insights that contributed to improved project outcomes.

Business Intelligence Analyst for Origin Energy Client

MVP Studio
05.2019 - 06.2019
  • Created a visualization for Origin Energy Queensland to illustrate their daily gas exportation, including gas pressure, gas emissions, and each power station, natural gas, coal energy, and wind farm energy.
  • Analysis on each Plant for Gas reading on each valve on geodata map to highlight wells status Offline or Online
  • Analysis of power generation during peak and non-peak hours in summer and winter to check energy distribution and utilization at each plant.

Business Intelligence Developer

Airtel india ltd
Mumbai, Maharashtra, India
11.2013 - 03.2019
  • Worked as A Business intelligence developer for India's biggest Telecom operator to provide Telecom insights via Daily reporting, Ad-hoc reporting for Monthly Network sales, Network expenses and Budgeting Analysis

Education

B. Tech - Information and Communication Technology

North Maharashtra University
India

Skills

  • Data Analysis & Reporting: Advanced SQL, Power BI, Tableau, Excel, Data Modeling
  • Programming Languages: SQL,Python,PySpark and Teradata EDW Solution
  • Technical Documentation: Creating and maintaining detailed reports, technical specifications, and progress updates
  • Solution Design & Development: Technical solution design, prototyping, and testing for Data Extraction from various data sources
  • Project Evaluation & Cost Analysis: Assessing project requirements, cost-benefit analysis, and solution feasibility
  • Stakeholder Collaboration: Effective communication with stakeholders, development teams, and senior management
  • Problem Solving & Troubleshooting: Identifying issues and proposing alternative solutions
  • Compliance & Quality Assurance: Ensuring adherence to development methodologies, high-quality standards, and best practices
  • Go-Live Support: Providing post-deployment support and issue resolution
  • Methodologies: Agile, Scrum, Waterfall
  • Data Extractions:- Extracting data using Azure Data Factory, Databricks /Data Lake and Building Data Pipeline for daily data Extraction from Source to Destination EDW solution

References

Available on request

Certification

  • Tableau Desktop Analyst
  • Microsoft Power BI Analyst-Associate

Languages

English
Professional
Hindi
Professional

Websites

References

References available upon request.

Timeline

Senior Fraud Intelligence & Data Analyst-Team Lead

Service NSW
08.2021 - Current

Business Analyst Tableau

Infosys Itd
01.2021 - 07.2021

SQL Developer

Credit Corp Ltd
11.2020 - 01.2021

Junior Data Analyst

TATA Communication
07.2019 - 09.2020

Business Intelligence Analyst for Origin Energy Client

MVP Studio
05.2019 - 06.2019

Business Intelligence Developer

Airtel india ltd
11.2013 - 03.2019

B. Tech - Information and Communication Technology

North Maharashtra University

Similar Profiles

CREATE PROFILE
Ankit Jain