Photo of Ayush Singh

Ayush Singh

Business Intelligence & Data Analytics Professional

Mumbai, Maharashtra, India
0
Followers
0
Following
I am a skilled Data Engineer with a proven track record of optimizing ETL processes, implementing robust data security measures, and developing impactful BI solutions. 
My expertise includes SQL Server, Microsoft Power BI, and various data analytics tools. With a focus on efficiency, I have reduced data loading times significantly, automated incremental loads, and played pivotal roles in Agile projects. 
My comprehensive experience spans remote positions at Synoptek India Private Limited and Saama Technologies, showcasing proficiency in SSIS, SSAS, SSRS, and more. 
I commitment to excellence is evident in his achievements, including awards for project delivery and technological excellence

Careers

Data Engineer

Synoptek

Full time08/2022 -
  1. Developed and maintained ETL processes, reducing data loading times by 88%.
  2. Implemented ETL strategies for incremental loading, considering both Type 1 and Type 2 update scenarios.
  3. Implemented data security measures, achieving compliance with industry regulations and company standards.
  4. Designed and developed SSRS reports based on business requirements and data sources.
  5. Designed and developed SSAS data models, considering business rules and requirements.
  6. Implement multidimensional cubes or tabular models to support analytical queries.
  7. Created visually compelling reports and dashboards in Power BI based on business requirements.
  8. Developed and maintained scalable BI solutions, enabling seamless data visualization for key stakeholders.
  9. Optimized existing BI dashboards, improving user experience and decision-making capabilities.
Senior Data Analytics Engineer

Saama Technologies

Full time12/2021 - 07/2022
  1. Developed and implemented data analytics pipelines, automating incremental loads, and saving 48 hours per month.
  2. Utilized SQL and Power BI to create data visualization models for real-time reporting ns.
  3. Implemented data modeling techniques to facilitate complex business reporting and analysis.
Data Analyst

M&G Global Services Private Limited

Full time01/2020 - 12/2021
  1. Developed and maintained scalable BI solutions, enabling seamless data visualization for key stakeholders.
  2. Utilized SQL and Power BI to create data visualization models for real-time reporting needs.
  3. Designed and developed various business intelligence and data solutions in Power BI and SQL.
  4. Implemented source control and release management using DevOps for Power BI dashboards, SQL scripts, and ETL tools, ensuring versioning and streamlined deployment processes.
  5. Played a pivotal role in Agile projects utilizing JIRA Confluence, contributing to collaborative and iterative development methodologies.
  6. Effectively utilized Power BI data visualization tools to communicate business analytics and insights to multiple teams and stakeholders, fostering data-driven decision-making.
  7. Spearheaded initiatives resulting in a 90% reduction in manual reports through the implementation of data pipelines and automation workflows using Power BI, Microsoft Excel, SQL, and ETL tools.
LogStar ERP India Private Limited

Associate - Software Developer

Full time04/2017 - 03/2019
  1. Developed sophisticated T-SQL queries, views, and stored procedures in diverse multi-database environments, optimizing data retrieval and analysis processes.
  2. Investigated and resolved data-level system issues promptly, enhancing overall usability and functionality to ensure a seamless business intelligence experience.
  3. Collaborated with business analyst groups and stakeholders to gain insights into evolving database reporting needs.
  4. Transformed diverse database reporting needs into powerful SQL queries, extracting and compiling data to create impactful KPIs and visuals that facilitate informed decision-making.

Education

University Of Mumbai

Computer Science

04/2014 - 04/2017Master's DegreeClass of 2017
Skills
SSRSOLAP, SSASSSISPower BIMicrosoft SQL ServerSQL ServerData analysis and explorationdata migration, data modelingData EngineeringBusiness Intelligence
Experience5-8 years
Hourly rate$15/hr
Open to
remote

astro circleWelcome to Outdefine

A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!

Join for free
astro-hello

Join a community, when you join Outdefine!Connect with 72,000 tech professionals globally.

A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!