Arjun Singh Chauhan
London
Summary
Synopsis: Results-driven Senior Data Engineer with 12+ years of experience in designing, implementing, and optimizing data pipelines. Skilled in data warehousing, ETL processes, and big data technologies. Data-driven Data Engineer attentive to system needs and knowledgeable about best practices. Focused on continuous improvement and optimisation in face of changing demands on efficiency, functionality and performance. Iterates professionally and delivers on-specification systems.
Overview
12
12
years of professional experience
Work history
Technical Architect
UK Insurance
09.2019 - Current
- SSIS, SSRS, Power BI, SSAS Tabular, SQL Server, MDS, Developed scalable data pipelines, processing and transforming diverse data sources into a unified format
- Implemented data lineage and auditing mechanisms, ensuring compliance with data governance standards and regulations
- Data strategy and data lineage
- Programming languages used Python, SQL
- Involved in developing ETL (SSIS packages) loads to process business requirement
- Skilled in performance tuning of SQL objects and designing SQL Jobs
- In depth functional knowledge of Business departments and their processes in Insurance domain
- Actively involved in business requirement discussions with clients.
Technical Lead
CitiusTech
05.2018 - 09.2019
- Software : SSIS, SSRS, SQL Server 2008/2012, AWS Redshift, End to end logic maintenance and evaluation of providers on CMS approved guidelines
- End to end maintenance of Talend ETL and Redshift database
- Designed end to end hierarchal reporting structure for Clinicians/providers
- Maintenance of multiple AWS instances
- Migration from Cloud to on Prem
- Created and reviewed multiple SSIS packages
- Host daily Client calls and assisted client in UAT
- Reporting to the onsite team members on development activities in daily stand up call set up for Agile process
- Worked as SME for the application providing technical help to other team members
- Review of the packages/procedure and suggested modification to the same
- AXIS Capital, CAT 2.0
Application Development Team Lead
Accenture Services Pvt. Ltd
06.2011 - 05.2018
Senior Programmer
Accenture
01.2015 - 04.2018
- Environment : Windows 10
- Software : SSIS, SSRS, SSAS & SQL Server 2008/2012
- Duration, Framework design of SSIS packages
- Creating SSIS Templates and underlying SQL stored procedures
- Used SQL Server 2012 SSIS Project deployment model
- Development of SSIS packages and SSRS reports
- Database objects development
- Performed performance optimization activity in SQL Server 2012 and SSIS 2012
- Reviewed SSIS packages
- Assist client in UAT
- Worked as SME for the application
- Providing technical help to other team members
- Created Tableau reports for the application performance and reporting
- Involved in Technical decisions for Business requirement, Interaction with Business Analysts and Client
- Analyzed and fixing bugs of existing procedures and Reports using SSRS
- Unilever Skywalker
- Company : Accenture
Team Member
Industries Insurance HealthCare
06.2011 - 12.2014
- Products
- ETL Tools
- SSIS, Informatica
- Data Modelling Tool
- Embarcadero er studio tool
- Reporting Tools
- SSRS
- Power BI
- RDBMS
- MS SQL Server 2008R2/2012/2014, AWS
- Redshift
- Operating Systems Windows XP Windows 2007/2010
- Version Control Tools
- VSTS, TFS, Jira
- Incident Management Tools
- ServiceNow Areas of Experience
- Led a team in developing end-to-end data pipelines
- Having 5+ year experience working in Agile environment
- Extensive knowledge on TFS Devops and Azure Devops
- Proficient in Python programming language
- Knowledge of cloud architecture (Azure) and design patterns
- Extensive knowledge and experience in developing scripts using T-SQL for querying against databases with tuning SQL Server performance and job scheduling with SQL Server Agent
- Provided programming estimates, identified potential problems, and recommended alternative solutions
- Proficient in Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) and Master Data Services
- Knowledge on Cloud data warehousing tool like Snowflake
- Understanding of Identity access management platform
- Produced data strategy, data lineage, integration design pattern documentation for multiple clients
- Collaborated with cross-functional teams to identify data integration requirements and ensure seamless data flow across systems
- Optimized data storage and retrieval by implementing partitioning and indexing strategies
- Mentored junior team members, providing guidance on best practices, code reviews, and performance optimization techniques
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop., Understanding the Requirement
- Created SSIS packages and Stored procedure for application
- Fixing issues for existing SSIS packages
- Identified critical gaps and cause of delay in delivery process
- Resolved the issues raised by Business Users through Remedy tool
- Handling Loads daily and update status to Business Users and onsite Team
- Responsible for gathering functional knowledge of SSAS cubes and document it
- Resolved data reconciliation issues for the data in ProClarity and BW reports
- Automate Daily data reconciliation activity through Scripts
- Handled issues related to ProClarity (Front End Reporting Tool)
- Created technical knowledge base for ETL
- Page 2 of 3
Education
Year 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Microsoft -
DP-203: Data Engineering on Microsoft Azure Microsoft - undefined
2022
Working - undefined
Hexaware Technologies Ltd
2022
DA-100: Analyzing Data with Microsoft Power BI Microsoft - undefined
2017
Bachelor of Technology - undefined
Jaypee University of Engineering and Technology
2011
Skills
- DevOps strategies
- Project forecasting
- CI/CD tools
- Cloud architecture strategies
- Agile and Waterfall practices
- Delivery and service management
- Cost estimation and budgeting
- Data collection and analysis
- Strategic planning and review
- Gap analysis
- Capacity and scalability planning
- Optimizing and performance tuning
- Data mapping
- Project documentation
- Programming and design skills
- Process development
- Technical analysis
- Agile methodology
- SQL
- Agile
- Data analysis strategies
Timeline
Technical Architect
UK Insurance
09.2019 - Current
Technical Lead
CitiusTech
05.2018 - 09.2019
Senior Programmer
Accenture
01.2015 - 04.2018
Application Development Team Lead
Accenture Services Pvt. Ltd
06.2011 - 05.2018
Team Member
Industries Insurance HealthCare
06.2011 - 12.2014
Year 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Microsoft -
DP-203: Data Engineering on Microsoft Azure Microsoft - undefined
Working - undefined
Hexaware Technologies Ltd
DA-100: Analyzing Data with Microsoft Power BI Microsoft - undefined
Bachelor of Technology - undefined
Jaypee University of Engineering and Technology
Similar Profiles
SaifAli Fayyaz MullaSaifAli Fayyaz Mulla
Tata Consultancy Services at Senior Quality Analyst-UK Insurance(Life and Pensions)Tata Consultancy Services at Senior Quality Analyst-UK Insurance(Life and Pensions)
Rubie Lyn VillorenteRubie Lyn Villorente
Financial Advisor at Prudential Life UK InsuranceFinancial Advisor at Prudential Life UK Insurance
Pooja SethPooja Seth
Lead Assistant Manager - Process Excellence & Ops at US Insurance - P&C, Health Insurance, Legal supportLead Assistant Manager - Process Excellence & Ops at US Insurance - P&C, Health Insurance, Legal support
Henry CharlesHenry Charles
Audit Assistant Manager at DeloitteAudit Assistant Manager at Deloitte
Zoe ChibuezeZoe Chibueze
Restaurant Manager at SmokehouseRestaurant Manager at Smokehouse