LOKESH JATTA
DATA ANALYST
Contact: 219-***-**** Email: ************@*****.*** LinkedIn
Data Analyst with over 3 years of experience in data analysis, visualization, and reporting. Expertise in developing automated data pipelines, optimizing ETL processes, and applying machine learning models to derive actionable insights. Proficient in using Python, SQL, and Tableau to transform raw data into meaningful reports that drive business decisions. Strong problem-solving and communication skills, with a proven ability to improve data accuracy, reduce processing times, and optimize decision-making processes. EDUCATION
Master of Science, Information Technology
Valparaiso University
GPA: 3.80/4.00
Bachelor of Technology, Electronics Communication & Engineering Kakatiya Institute of Technology and Science, India CERTIFICATIONS:
Microsoft Certified: Azure Fundamentals (AZ-900)
GPA: 3.60/4.00
EXPERIENCE
Rediant Infotech May 2024 – Current
Data Analyst
Designed and executed complex SQL queries to extract and analyze data from multiple databases, reducing data processing times by 25% through query optimization and efficient indexing strategies.
Enhanced Excel-based financial models, implementing data validation rules and automating calculations, which reduced manual errors by 20% and saved over 2 hours per week for reporting tasks.
Developed and optimized ETL workflows in Informatica, handling over 1 million records for real-time reporting and analysis, significantly improving data accuracy and availability for cross-functional teams.
Created and customized 8 dashboards in Power BI that highlighted vital performance trends, providing key insights used by senior management during weekly strategic planning and review sessions.
Collaborated with data engineers to ensure data pipeline reliability and troubleshoot issues, improving the overall data integration process and ensuring consistent data flow between systems.
Wipro Enterprises, India May 2020 – Dec 2022
Data Analyst
Created interactive data visualizations using Tableau, translating complex datasets into user-friendly dashboards that improved stakeholder data comprehension by 40%, facilitating data-driven decision-making.
Developed and optimized ETL pipelines using AWS Glue and Lambda to migrate 500TB of on-premise data to AWS Cloud, reducing data loading times by 50% and improving data accessibility for analytics teams.
Fine-tuned machine learning models in Python to enhance product recommendation algorithms, leveraging customer behavior data from 200+ interactions to optimize user engagement and boost recommendation accuracy.
Cleaned and transformed internal datasets using Python and Excel, generating weekly reports that tracked key performance indicators (KPIs) and identified opportunities for process improvements, leading to a 15% reduction in reporting errors.
Designed and maintained data workflows in Snowflake, ensuring the integrity and accuracy of large datasets while facilitating seamless data extraction and transformation processes.
Automated data pipelines to extract, clean, and aggregate customer data, cutting manual processing time in half and improving data reliability by 20%.
Collaborated with cross-functional teams to present data findings and refine analytical models, ensuring alignment between business needs and data solutions.
SKILLS
Methodologies: SDLC, Agile, Waterfall
Languages: Python, R, SQL
Data Science Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2, TensorFlow, Keras, Seaborn, PyTorch, BeautifulSoup, XGBoost
ETL & Visualization Tools: Tableau, Power BI, Microsoft Excel, Informatica, SSIS, Alteryx, Apache Spark, Apache Airflow
Cloud Technologies: AWS (EC2, S3, Lambda, Glue, CloudFormation, Athena), MS Azure, Google Cloud Platform (GCP)
Databases: MySQL, PostgreSQL, Oracle, SQL Server, MongoDB
Other Tools: Jupyter, Google Data Studio, KNIME, Power Query, Postman
Additional Skills: Data Cleaning, Data Wrangling, Data Warehousing, Data Mining, Data Migration, Critical Thinking, Problem-Solving, Statistical Analysis, Machine Learning, A/B Testing, CI/CD Pipelines