Ashutosh Kumar Thakur

Experience

• 

  InTarvo Technologies Pvt. Limited

  Mar 2010 - Aug 2010

  MIS Coordinator
• 

  CenturyLink

  Sept 2010 - Aug 2011

  Reporting Analyst
• 

  Accenture

  Sept 2011 - Jun 2019

  • Extracting,transforming and loading data from multiple sources into Tableau/Power BI/SSIS/SSRS.• Extensive experience in SQL Join,Store Procedure,Function,CTE,Index,View,Subquery,Cursor,Trigger.• Extensively used SSIS transformations such as Lookup,Merge,Multicast,Derived column,Data conversion,Row count and Send Mail.• Used ETL (SSIS) to develop jobs for extracting,cleaning,transforming and loading data into target tables.• Designing & deploying the end to end process of Data Visualization using POWER BI/Tableau.• Create dynamic Dashboard using parameters,filters,calculated fields and applying level of details functionality.• Schedule data refreshed and share dashboard and report using Power BI gateway and content packs.• Managing the Troubleshooting process,performance tuning of reports and resolving issues within Tableau/Power BI,• Create complex Report and dashboard using Join/Relationship/QueryFolding/Fuzzy matching/Data Profiling/Sync Slicer.• Experience in creating and building the dashboards in Power BI using Edit Interaction/Cross Filtering/Slicer/Manage and View Roles. • Experience in writing DAX queries/expressions like Related/LookupValue/Join/userRelationship in Power BI Desktop.• Creating Row level security with Power BI and integration with Power BI Service Portal• Create Dashboards, KPIs, Visualizations, Drilldown, Drill through and other types of reports in Tableau/Power BI/SSRS.• Design,Developed and maintain simple to complex tableau visulations.• Responsible to generate, maintain, consolidate and track Daily/Weekly/Monthly reports using Tableau.• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.• Extensive knowledge on LOD,Windows Formula and well versed with Tableau Calculations.• Developed Tableau workbooks from multiple data sources using Data Blending. Show less • Collect data from SAP/SQL Server and prepare and develop various type of supply chain reports.• Strong expertise in writing complex VBA coding for Excel and Access for different Business Environments.• Designed and developed the database tables,Query, forms and reports in MS Access.• Used recordset to add,update,delete data in MS Access/Excel.• Extensive experience in VBA designing templates,user forms,user defined functions,Graph and loop..• Proficiency in create Excel Based tools using ActiveX Controls/Form Controls.• Proficiency in extracting data from different file format like XML/Text/CSV/SQL Server/Access/FTP Folder using Excel VBA(Macro).• Proficiency in debugging and troubleshooting Excel VBA.• Developed procedures in MS Excel for export and importing data to and from MS Access.• Import data from Folders/Sub Folders and develop the various reports using DIR/FileDialog/Shell/FSO.• Used VBA extensively and provided options to query the data based on their selection.• Develop reporting templates,maintain them and publish error free reports as per defined schedules.• Improve and automate existing reporting structure for ease of use and reduced reporting time.• Created VBA programs to extract & consolidate data from database Folders/SQL/Access/CSV/Text/ Excel files.• Created macros to send automatic mails after preparing the reports.• Tremendous experience in tuning the MS Excel, Access queries and the data base.• Created multiple type of VBA programs for data extraction,automate report & for other daily manual work. Show less

  • Software Developer

    Mar 2016 - Jun 2019

  • Analyst

    Sept 2011 - Feb 2016
• 

  QSS Technosoft Pvt. Ltd.

  Jul 2019 - Jul 2020

  Senior Software Engineer

  Developed comprehensive Power BI dashboards to visualize sales, finance, and customer data, leading to a 20% improvement in decision-making efficiency.Optimized SQL queries, reducing execution time by 40%, improving the overall system performance.Automated data extraction and transformation processes using Power Query and SQL stored procedures.Designed and implemented complex SQL queries for data extraction and transformation from multiple databases.Integrated SQL databases with Power BI reports to provide real-time data insights.Analyzed data using SQL and Power BI to create dashboards showing performance metrics, resulting in improved operational efficiency.Maintained SQL scripts for data aggregation and provided data insights to business teams.Developed a Power BI dashboard to track key sales KPIs, leveraging SQL queries to extract data from multiple sources.Optimized Power BI performance by improving data modeling and query efficiency, reducing load time by 30%.Designed SQL views to pre-aggregate large datasets, improving report generation speed.Increased report development efficiency by 25% by automating data refresh processes in Power BI.Improved data query performance by optimizing SQL procedures, leading to a 15% reduction in reporting time. Show less

• 

  Noventiq India

  Aug 2020 - now

  Senior Data Engineer

  -Proficient in building end-to-end ETL pipelines, data transformation, and orchestration using Databricks/Synapse/Fabric/BigQuery/Snowflake/Data Factory/Airflow/DBT/SQL/Spark/Python/Pandas.-Generated Power BI reports from various sources like Synapse Analytics,Data Lake,Databricks,Azure SQL,Rest API,Big Query,Snowflake, scheduling regular refreshes and sharing reports through the Power BI Report Server/Power BI Service.--Migrated on-premises datasets to BigQuery using Dataform for transformation and automation.--Implemented partitioning and clustering strategies to optimize storage and query performance.--Built a Dataform project to automate data ingestion, transformation, and reporting using BigQuery tables.--Designed and built data pipelines using Dataform, integrating with BigQuery for efficient data modeling and transformations.--Developed reusable SQL models and automated workflows that reduced manual intervention and improved processing times.- Designed and developed scalable ETL pipelines using Python and SQL to process datasets of over 10 million rows daily.- Developed automated Python scripts to optimize and clean data for reporting purposes, reducing processing time by 30%.- Managed SQL databases (PostgreSQL, SQL Server), optimized complex queries, and wrote stored procedures for various analytics tasks.- Implemented Python-based ETL processes to automate data extraction, transformation, and loading from disparate data sources.- Built complex SQL queries for data extraction and transformation, improving performance by optimizing indexing and query execution plans.- Built an end-to-end data pipeline using Python, SQL, and Apache Airflow for processing sales data from an e-commerce platform. Show less