London Area, United Kingdom
SQL ETL Developer | Data Engineer | Google Certified Professional Analyst I am an experienced IT professional with 10 years of industry experience, specializing in SQL development, T-SQL, SSIS, SSRS, SSAS, ADF, and data modeling. I am also a Google Certified Data Analyst, having completed the Google Data Analyst Professional Certificate program. Throughout my career, I have developed strong expertise in developing complex SQL queries, stored procedures, and functions to extract, transform, and load data efficiently. I have successfully implemented ETL processes using SSIS, ensuring seamless data integration across various systems. Additionally, I have leveraged SSRS to create insightful reports, providing valuable insights to stakeholders. With the Google Data Analyst Professional Certificate, I have honed my skills in data analysis and visualization using tools such as Google Analytics, Google BigQuery, and Google Data Studio. This certification has provided me with a comprehensive understanding of data analysis techniques and the ability to derive actionable insights from complex datasets. In addition to technical skills, I have a strong understanding of CI/CD principles and have worked with TFS (Team Foundation Server) for version control and continuous integration. I am highly adaptable and thrive in fast-paced, collaborative environments, having successfully contributed to projects using Agile methodologies . With a passion for continuous learning, I am committed to staying up-to-date with the latest technologies and industry trends. I am a dedicated problem solver, always striving to deliver innovative solutions that meet the needs of the business. I have the right to work in the UK and am currently seeking new opportunities to leverage my skills and contribute to the success of a dynamic organization. If you are looking for a motivated and experienced SQL developer and data analyst with a strong background in web application support, please feel free to reach out to me. Let's connect and explore how we can collaborate to drive data-driven decision-making and achieve business objectives.
Design, develop, and maintain the ETL processes using industry-standard ETL tools such as Microsoft SSIS. This includes extracting data from multiple sources, transforming it as per business requirements, and loading it into the target data structures. Collaborate with business analysts, data architects, and other stakeholders to understand data requirements and design efficient data integration solutions. Ensure data quality and integrity by implementing data validation and cleansing processes. Analyze source data and create data mappings to transform and load it into the target data structures. Develop and maintain ETL workflows, mappings, and transformations to ensure accurate and efficient data movement. Identify and resolve performance bottlenecks in the ETL processes, optimizing data extraction, transformation, and loading. Monitor and tune ETL jobs to improve efficiency and meet SLAs. Monitor and analyze database performance, identifying and resolving issues that may impact the system's efficiency. Optimize database queries, indexes, and configurations to enhance performance and response times.
Comprehensive management of star schema data warehouse. Worked directly with clients in developing data models , enhancing existing models to streamline data storage processes and support Client requirements. Used SQL, SSIS, SSRS, AGILE Scrum, jira, TFS. Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, ,Normalisation techniques on database tables. Experienced in Query Optimisation and Performance Tuning.
A member in a team of 4- 5 people. Working on enhancements obtaining requirements from clients following SLDC. Working on c# .net , oracle, TFS, water flow model, SQL.
Member in a team of 20 people supporting various applications. Fixing bugs and developing small modules using c# .net , Oracle 9i, and MS sql 2010.