| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
2 Years Experience | USA | 716-612-0826 | EMAIL AVAILABLE | https://LINKEDIN LINK AVAILABLEWork ExperienceFLEXTRONICS |Data Analyst |May 2021 - April 2023 Led the business objects end of life (BO-EOL) data migration project, successfully migrated 1000+ reports for global clients, improve processes to ensure data integrity and seamless operations in production environment. Automated business logic with VBA in excel for SQL base view name creation, enhancing process efficiency by 70%. Utilized Denodo to engineer scalable data models from SQL queries and extract data from relational databases, converting BO reports to Denodo views and generating production reports, aligning them with critical customer requirements. Developed and tested a script for automating Denodo VQL to snowflake VQL using python language and regular expressions, reducing manual effort by 60% and provided writing documentation of the script. Designed and managed 100+ report schedules in Denodo Scheduler using cron expressions, facilitating standardized reporting using SFTP protocol, providing production support and ensuring accuracy in ad hoc reports. Trained 1000+ site users on Denodo report conversion to influence efficient migration and produce reports by utilizing strong communication skills to ensure successful user adoption. Monitored data quality across migrated reports, performing rigorous validation to move reports to user acceptance testing (UAT) for report correctness, get approval to move reports to production environment. Created interactive dashboards using powerbi, improving process and strategic decision making through real-time performance monitoring of business objects reports migration. Assisted in the cloud migration from Teradata to Snowflake, by effectively communicating project goals and gathering feedback, ensuring seamless integration and adherence to database design and satisfying customer requirements. Developed shell scripts for data loading and transfer from Teradata to Amazon S3 and Amazon S3 to Snowflake, optimizing data pipelines and enhancing production process efficiency. Maintained data quality through comprehensive validation checks, ensuring accuracy and reliability in the migrated data using sample testing.Projects
Developed dashboards and a storyboard for a Book shop dataset using Tableau, effectively visualizing data for publisher stakeholder, document project plan to provide insights and collaboration of other stakeholders. Created a custom GPT and SharePoint website for a law firm using Microsoft Power Platform, meeting specific customer requirements and improving their digital capabilities. Designed a database in MYSQL to track impact of alcohol on student s success considering their family, school, grade, cocurricular activity and alcohol consumption rate. Developed a robust ETL data pipeline using Azure Data Factory to analyze the 2021 Olympics dataset using Azure Synapse Analytics. Set up Azure Storage, ingested data into Azure Data Lake storage Gen2, transformed data using Azure Databricks, stored transformed data to Azure Data Lake storage Gen2, analyse transformed data using Azure Synapse Analytics and Power BI.
Core Skills Data Engineering and Cloud Platforms ETL, Azure Data Factory, Azure Data Lake Gen 2, Azure Databricks, Azure Synapse Analytics, Azure Active Directory, Salesforce. Database Technologies SQL Programming, Microsoft SQL Server, MySQL, Postgres, Oracle, Microsoft Access. Analytics and Business Intelligence Power BI, Tableau, Denodo, SAP Analytics Cloud, Looker Studio, Alteryx, Advanced Excel. Data Analysis and Visualization Statistical Analysis, Data Cleaning, Data Manipulation, Exploratory Data Analysis, Data Validation, A/B testing, Predictive Analytics, Python, Pandas, NumPy, Matplotlib, Seaborn, Graphical representation, Dashboard Development, Storytelling with Data, Custom Visuals Creation, Interactive Visualizations, Data Reporting.Education University at Buffalo | MS | Management Information Systems (MIS) | STEM | GPA 3.8 |June 2024 Anna University | Bachelor of Engineering | Computer Science | GPA 3.7 |June 2021
CertificatesMicrosoft Certified : Azure Data Fundamentals DP 900 , Microsoft Certified : Power BI Data Analyst Associate PL 300 (Preparing) Statistics, Data Warehousing, Looker Studio, SAP Analytics, Alteryx, Google Data Analytics Professional Certificate, Data Science with python, Lean Six Sigma Green Belt, Complete Guide to SQL for Data Engineering: from Beginner to Advanced.PublicationsPublished Intelligent Systems to Predict and Diagnose Benign and Malignant Skin Lesions in IOS press, providing actionable insights in the healthcare domain. |
