Anwesh Puram
Data Engineering Manager
Hyderabad
Summary
Technical manager & Enterprise Cloud Data Architect with 12 years of experience in leading teams and designing and delivering scalable data platform solutions on cloud to accelerate business transformations.
Overview
12
12
years of professional experience
5
5
Certifications
Work History
Manager
EY
01.2025 - Current
- Designed an end-to-end solution architecture for a global, multi-brand automotive client to unify the data process of various countries and brands in a single solution, resolving the delay in month-end closing activities.
- Led the implementation as a technical manager, handling a team of 12 members.
- Conducted an assessment for a global enterprise data mesh architecture solution to improve their cloud adoption and address the challenges of onboarding countries.
- Led go-to-market initiatives, and participated in RFP solutioning and effort estimations for data migration and transformation projects.
- Participated in client orals, technical demos, and solution defense presentations showcasing architecture capabilities and contributing to successful pursuit wins.
Associate Manager
Accenture
08.2019 - 01.2025
- Led a team of 15 as Technical Manager and Data Architect, managing enterprise cloud data integration projects with a focus on effectiveness.
- Designed cost optimization initiatives, achieving annual savings of $70,000 for a client by streamlining compute and storage resources.
- Spearheaded automation projects, resulting in a 45% reduction in manual operations, significantly improving efficiency.
- Managed end-to-end cloud data migration projects, successfully moving AWS S3 data into Snowflake using Matillion, and ensuring smooth transitions from Microsoft APS PDW to Azure Databricks with Airflow and Matillion.
- Engineered Azure Databricks integration, replacing NiFi data flows and optimizing data transfer from IBM Db2 to Dynamic 365 and Oracle DB.
- Served as Scrum Master, driving team productivity and ensuring project delivery within Agile frameworks.
- Participated in the Accenture Global Innovation Contest, where I integrated Alexa with a MySQL database in an AWS environment, creating a proof of concept.
- Worked with onshore teams across North America, Europe, and APAC to deliver effective cloud solutions, enhancing collaboration and project execution.
- Implemented architectures like Medallion, Delta Lake, Data Lake, and Data Warehousing to enhance data processing capabilities.
- Developed configuration-driven solutions, cutting time to market and code base by 80% for Enterprise Data Warehouses (EDWs) in Synapse Analytics.
- Achieved 45% soft savings through automation, greatly reducing manual efforts required from on-call engineers in operational projects.
- Directed metadata-driven data migrations between Salesforce, Oracle DB, Azure Data Lake, Azure SQL, and Synapse DB, ensuring data integrity.
- Worked with clients to refine estimates and staffing plans, achieving significant cost savings and optimizing resources.
IT Analyst
Tata Consultancy Services
05.2017 - 08.2019
- Developed and optimized ETL processes using SSIS, SQL and linked servers, enhancing data integration.
- Built SSAS Cubes (Tabular Models), including calculated columns and measures as per clients requirements.
- Improved SSAS Cubes processing time by implementing dynamic partitioning & optimizing DAX queries in measures and calculated columns, boosting the performance of cubes and Power BI dashboards.
- Implemented out-of-the-box solutions to reduce the load on tabular cube servers, effectively avoiding downtime of critical applications.
- Created and maintained automated cube documentation reports in Power BI, incorporating data quality checks and alert mechanisms for enhanced accuracy and reliability.
- Improved SQL Server performance through T-SQL query optimization and effective indexing, leading to faster data retrieval and processing.
- Designed and optimized Power BI reports, dashboards, and executive summaries.
Software Engineer
Tech Mahindra
05.2014 - 04.2017
- Analyzed and resolved critical tickets across Inventory, Order Management, HRMS, PO, and Manufacturing modules using MSBI Suite.
- Developed solutions using SQL, SSIS, SSRS, and SSAS technologies.
- Monitored and fixed SSIS job failures, and optimized data flows and SQL queries for improved performance.
- Managed Change Management processes and assisted in UAT testing.
- Achieved a 100% Customer Satisfaction Index (CSI) three times consecutively.
- Utilized Agile methodologies in a DevOps environment and actively collaborated with team members.
Education
Bachelor of Science - Electronics & Communication Engineering
Malla Reddy College of Engineering & Technology
Hyderabad01-2014
Skills
- Cloud & Data Platform: Snowflake Database , Azure Databricks , Azure Synapse Analytics , Microsoft Fabric Lakehouse ,Azure SQL DB
- Orchestration & ETL : Azure Data Factory , Apache Airflow
- Transformation & Modelling : dbt, PySpark, SQL , Python, DAX
- Reporting : Power BI & Tableau
- Automation : Azure Run Books , Azure Functions & Azure Logic Apps
Accomplishments
- Cloud Data Architecture
- Data Platform Modernization
- Data Engineering Leadership
- Solution Consulting
- Resource loading & Cost Estimation
- Stakeholder & Client Management
- Governance & Security Architecture
- Capacity Planning
Additional Information
- Team Leadership
- Sprint Planning & Delivery Management
- Pre sale support , Client Orals & Demos
- Cross Functional Collaboration
- Risk Management & Estimation
Certification
Azure AI Fundamentals
Timeline
Manager
EY
01.2025 - Current
Associate Manager
Accenture
08.2019 - 01.2025
IT Analyst
Tata Consultancy Services
05.2017 - 08.2019
Software Engineer
Tech Mahindra
05.2014 - 04.2017
Bachelor of Science - Electronics & Communication Engineering
Malla Reddy College of Engineering & Technology