Ayush Singh
Business Intelligence & Data Analytics Professional
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
- Developed and maintained ETL processes, reducing data loading times by 88%.
- Implemented ETL strategies for incremental loading, considering both Type 1 and Type 2 update scenarios.
- Implemented data security measures, achieving compliance with industry regulations and company standards.
- Designed and developed SSRS reports based on business requirements and data sources.
- Designed and developed SSAS data models, considering business rules and requirements.
- Implement multidimensional cubes or tabular models to support analytical queries.
- Created visually compelling reports and dashboards in Power BI based on business requirements.
- Developed and maintained scalable BI solutions, enabling seamless data visualization for key stakeholders.
- Optimized existing BI dashboards, improving user experience and decision-making capabilities.
Senior Data Analytics Engineer
Saama Technologies
- Developed and implemented data analytics pipelines, automating incremental loads, and saving 48 hours per month.
- Utilized SQL and Power BI to create data visualization models for real-time reporting ns.
- Implemented data modeling techniques to facilitate complex business reporting and analysis.
Data Analyst
M&G Global Services Private Limited
- Developed and maintained scalable BI solutions, enabling seamless data visualization for key stakeholders.
- Utilized SQL and Power BI to create data visualization models for real-time reporting needs.
- Designed and developed various business intelligence and data solutions in Power BI and SQL.
- Implemented source control and release management using DevOps for Power BI dashboards, SQL scripts, and ETL tools, ensuring versioning and streamlined deployment processes.
- Played a pivotal role in Agile projects utilizing JIRA Confluence, contributing to collaborative and iterative development methodologies.
- Effectively utilized Power BI data visualization tools to communicate business analytics and insights to multiple teams and stakeholders, fostering data-driven decision-making.
- 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
- Developed sophisticated T-SQL queries, views, and stored procedures in diverse multi-database environments, optimizing data retrieval and analysis processes.
- Investigated and resolved data-level system issues promptly, enhancing overall usability and functionality to ensure a seamless business intelligence experience.
- Collaborated with business analyst groups and stakeholders to gain insights into evolving database reporting needs.
- 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
Welcome 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