Experienced IT professional with 8.5 years of diverse expertise in web development and data engineering. Adept at leveraging ETL processes, data analysis, and visualization tools, including Excel, Python, SQL, Tableau, Power BI, and Looker Studio. Proficient in database management (SQL Server, MySQL, MongoDB, PostgreSQL) and skilled in cloud platforms such as Google Cloud Platform (GCP) and Azure, including Azure Data Factory (ADF). Strong programming skills in Python and PHP, with a solid understanding of OOP concepts. Demonstrated ability to optimize data processes, identify patterns, and drive business growth. Holds certifications as a Microsoft Certified Azure Data Engineer Associate and Google Data Analytics Certificate holder. Committed to continuous professional development and staying current with emerging industry trends.
Excel
Python
SQL
Tableau
Power BI
Looker Studio
PySpark
Airflow
Google Cloud Platform
Compute Instance
BigQuery
Azure Data Factory (ADF)
ETL processes
Data Warehousing
Data Modeling
Data Cleansing
SQL Server
MySQL
MongoDB
PostgreSQL
Azure SQL Database
AWS Redshift
AWS Glue
Azure Blob Storage
Azure Data Lake Storage (ADLS) Gen2
Azure Event Hubs
Azure Stream Analytics
Azure Databricks
Amazon Web Services (AWS)
Google BigQuery
Snowflake
Python
Shell Scripting
PHP
LAMP technologies
JavaScript, JQuery, CSS, HTML
MVC Frameworks (Symfony, smarty, shopware)
OOPs Concept
MySQL Query Optimization
Integration
Testing and Quality Assurance
Version Control (Git, GitHub, SVN)
CI/CD Tools (GitLab)
UK Search Limited- Chesterfield October 2023 – Present
Developed and designed Power BI reports from various data sources, creating visually compelling visualizations to convey key business insights.
Implemented calculated groups and time intelligence for advanced analytics, enhancing the depth and accuracy of reporting.
Created interactive dashboards that facilitated dynamic data exploration for both internal stakeholders and clients.
Utilized Excel to generate detailed and comprehensive reports, meeting specific client requirements and addressing internal business needs.
Conducted regular reviews of existing Power BI reports, identifying and resolving issues promptly to maintain report reliability.
Ensured data accuracy and visualization effectiveness to meet the evolving needs of the business.
Developed and maintained a comprehensive data dictionary to ensure consistency in data definitions across the organization.
Implemented Python scripts for automating report generation, streamlining workflows, and enhancing overall efficiency.
Integrated automation processes to push data seamlessly to the data warehouse, optimizing data management procedures.
Collaborated with business stakeholders to understand strategic questions and translated them into actionable insights through data analysis.
Played a key role in addressing strategic business inquiries and providing data-driven recommendations for decision-making.
Analyzed e-commerce data to identify patterns and anomalies, leveraging business expertise to create new variables.
Conducted extensive analysis on e-commerce data using Python, SQL and Tableau; identified patterns and insights that decreased cart abandonment rate by 15%
Utilized Power BI to visualize findings and present insights to stakeholders.
Developed predictive models to forecast production based on cities and clients, resulting in a 20% increase in sales and revenue.
Proficient in Python, MySQL, R programming, and Microsoft Power BI (including DAX functions) for data engineering, analysis, and visualization tasks
Experience using IT management services like Slack for team collaboration, communication, and project management.
Proficiency in communication and collaboration using Microsoft Teams, including chat, video conferencing, document sharing, and integration with other Microsoft tools.
POORNAM INFO VISION - Kerala, India September 2017 – August 2021
Developed and maintained complex SQL queries for data extraction, manipulation, and analysis across multiple databases (SQL Server, MySQL, MongoDB, and PostgreSQL) to ensure accurate and consistent data.
Collaborated with cross-functional teams to design data solutions using SQL, Python, and other tools, supporting efficient data processes and reporting.
Optimized SQL performance, integrity, and security to ensure efficient and secure data operations, adhering to industry standards.
Leveraged Azure platforms, including Azure Data Factory (ADF), to manage and maintain data warehouse platforms, building and supporting efficient ETL processes.
Utilized dbt testing capabilities to validate data quality and integrity, resulting in a 20% reduction in data-related errors, while improving data processes and outputs.
Experience working with IT management services like Jira for tracking and managing projects and tasks.
Familiarity and experience working with TCP/IP connections, demonstrating an understanding of networking concepts.
Proficiency in working with cron jobs to schedule and automate pipelines or other recurring tasks.
Experience in scripting using Python, indicating proficiency in writing scripts for various purposes.
Lead design and development of enterprise applications using PHP, LAMP technologies, JavaScript, JQuery, CSS, HTML, MVC Frameworks like Symfony, smarty, shopware.
Experience with using of OOPs concept
Advance MySQL query handling
Integration with Content Management Systems and payment processing gateways
Identifying and troubleshooting client issues then documenting solutions and development and QA procedures
Ensure exceptional code quality and thorough testing (both at unit and system integration level) on every newly developed feature.
Provide technical problem resolution for highly complex problem
Excel to log the KPI and display the team performance using visualization.