ATUL KUMAR TIWARI
Summary
Senior data specialist with expertise in Azure data engineering and cloud migration. Skilled in developing optimized ETL pipelines and enhancing database performance. Proven leader with strong collaboration skills, driving successful project delivery and stakeholder engagement. Proficient in Azure Synapse and SQL, delivering impactful solutions that elevate enterprise reporting.
Overview
1
1
Certification
15
15
years of professional experience
Work History
Senior Data Specialist
LTIMindtree
09.2023 - Current
- Built scalable and optimized Azure solutions using Azure Synapse, Azure Data Factory, SSMS and ADLS Gen2.
- Implemented ADF pipelines and data flows for multi-source ingestion and transformation.
- Designed and architected automated GPR (Group Project Reporting) solutions for enterprise reporting.
- Migrated production services across Azure subscriptions and regions with minimal downtime.
- Enhanced database performance, resulting in more reliable data access and automated alert email notifications for proactive issue resolution.
- Redesigned storage workflows using ADLS Gen2 to improve performance and reduce operational cost.
- Migrated Tabular Editor objects into Power BI Semantic Models for cost optimization.
- Developed technical design and architecture documentation aligned with business requirements to facilitate clear communication and project alignment.
- Collaborated with stakeholders and cross-functional teams to deliver integrated solutions, ensuring alignment with business goals and user needs.
Technical Lead
Sopra Steria
03.2022 - 08.2023
- Developed complex SQL queries, procedures, and triggers for data integration and validation.
- Designed cloud-based data architecture and established implementation best practices.
- Supported Oracle to Azure Cloud migration using Databricks, Azure Data Factory, AWS Glue and Snowflake.
- Conducted code reviews and performance tuning activities.
- Collaborated with development and business teams to ensure successful project delivery.
- Analyzed business and technical requirements to inform enterprise data engineering initiatives.
- Participated in enterprise data modelling using ERWIN.
- Client: Land Transport Authority (Singapore)
- Technologies Used: SQL, PL/SQL, ERWIN, AWS Glue, Azure Data Factory, Databricks, Snowflake
Technology Specialist
Coforge Ltd.
11.2015 - 03.2022
- Designed and developed enterprise-grade data pipelines using Databricks and Snowflake for PoC implementation.
- Collected and analyzed project requirements to develop tailored technical solutions.
- Managed end-to-end SDLC activities, ensuring successful development, deployment, and ongoing support.
- Improved database performance through query optimization and tuning.
- Developed and optimized Oracle database objects, including procedures, functions, and triggers, to enhance system performance.
- Performed data mapping and transformation using PL/SQL.
- Client: SEI Investments (USA)
- Technologies Used: Databricks, Snowflake, Oracle, SQL, PL/SQL, ERWIN
Senior Software Engineer
Marlabs Software
12.2014 - 10.2015
- Gathered and analyzed business requirements to develop ETL and data processing solutions that meet stakeholder needs.
- Executed Netezza to Oracle database migration, ensuring data integrity and minimal downtime.
- Managed end-to-end ETL implementation and support, facilitating seamless data flow and integration across systems.
- Developed PL/SQL-based ETL and transformation solutions.
- Improved database performance through optimization techniques.
- Designed staging area data models and supported data integration activities.
- Collaborated with Airtel in Gurugram
- Technologies Used: Oracle, PL/SQL, Netezza, SQL
Senior Software Engineer
Cherrytec Intelisolve (Kuwait)
06.2014 - 12.2014
- Customized and developed retail management applications using Oracle technologies to enhance user experience.
- Designed and optimized PL/SQL procedures, forms, and reports.
- Optimized application and database performance through targeted optimization techniques.
- Conducted source system mapping and data modeling to ensure seamless data integration.
- Collaborated with Alshaya Group in Kuwait on retail management applications.
- Technologies Used: Oracle Forms & Reports, SQL, PL/SQL
Senior Software Engineer
Eastern Software Systems Ltd.
06.2011 - 06.2014
- Translated business requirements into Oracle-based ERP solutions to enhance system functionality and user experience.
- Customized ERP modules for sales, purchase, inventory, finance, and payroll to meet specific organizational needs.
- Provided production support and resolved issues for ERP applications to ensure operational continuity and user satisfaction.
- Managed database administration activities including export/import and role management.
- Technologies Used: Oracle SQL, PL/SQL, Oracle Forms & Reports
Education
Master of Computer Applications -
Skills
- Azure Data Engineering & Architecture
- Azure Synapse Analytics
- Azure Data Factory
- Azure Databricks
- Snowflake Data Platform
- Microsoft Fabric
- SQL / PL-SQL Development
- Cloud migration
- Data governance
- SQL
- PL/SQL
- Python
- Power BI Semantic Model
- Azure Data Lake Storage Gen2
- Snowflake
- SSMS
- Oracle Database
- Azure DevOps
- Git
- CI/CD Pipelines
- Pipeline development
- ARM Templates
- Azure Monitor
- Log Analytics
- RBAC
- Azure Key Vault
- Tabular Editor
- Analysis Services
- Team leadership
- JIRA
- JIRA
Certification
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
- Databricks Certified Data Engineer Professional
- Databricks Certified Data Engineer Associate
- Microsoft Certified: Azure Developer Associate (AZ-204)
- Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Oracle Certified Professional (OCP)
- Oracle Certified Associate (OCA)
- Databricks Accredited Lakehouse Fundamentals
- Data Analytics with Python from IIT Roorkee
Languages
- English
- Hindi
Personal Information
Nationality: Indian
Technical Skills
Microsoft Azure, AWS (Basic), Google Cloud Platform (Basic), Azure DataFactory(ADF), Azure Synapse Analytics, Azure Databricks, Azure Data Lake Storage Gen2, Microsoft Fabric, Snowflake, Power BI Semantic Model, SQL, PL/SQL, Python, SSMS, Oracle Database, Azure DevOps, Git, CI/CD Pipelines, ARM Templates, Azure Monitor, Log Analytics, Application Insights, RBAC, Azure Key Vault, ERWIN Data Modeler, Tabular Editor, Analysis Services, JIRA
Disclaimer
Hereby declare that all the information documented above is correct and true to the best of my knowledge and belief.
Timeline
Senior Data Specialist
LTIMindtree
09.2023 - Current
Technical Lead
Sopra Steria
03.2022 - 08.2023
Technology Specialist
Coforge Ltd.
11.2015 - 03.2022
Senior Software Engineer
Marlabs Software
12.2014 - 10.2015
Senior Software Engineer
Cherrytec Intelisolve (Kuwait)
06.2014 - 12.2014
Senior Software Engineer
Eastern Software Systems Ltd.
06.2011 - 06.2014