Data Analyst Information Technology
Resume:
Associate Data Analyst
Sainikhila.Ch
**********.****@*****.***
Professional Summary:
• Having 3+ years of experience in Big - data related technologies on various domains like Healthcare & Finance.
• Accomplished IT professional with experience in the Office of Information Technology at CMU, specializing in troubleshooting account login issues, virus protection, and software installation.
• Proficient in SǪL, with a focus on developing complex queries, functions, and stored procedures, as well as exporting data from HIVE to MySǪL using Shell scripts.
• Skilled in configuring Hive meta store with MySǪL and working on Google Cloud Platform (GCP) services like Cloud Engine, Load Balancing, Storage, SǪL, Stack Driver Monitoring, and Deployment Manager.
• Utilized GCP functions with Python for loading data into Big Ǫuery from CSV and Parquet files in GCS buckets.
• Experienced in using reporting tools like Tableau and R to connect with Hive for generating daily reports.
• Strong background in RDBMS technologies, including MySǪL, Oracle.
• Extensive customer service experience, managing issues related to global IDs, passwords, wireless setup, and database user permissions.
• Graduate Teaching Assistant at CMU's Big Data Analytics Department, guiding students in mastering data engineering tools, mentoring Python programming skills, and conducting workshops on GCP.
• Contributed to Dow Chemical's Cyber-Attack Trend Analysis, demonstrating expertise in statistical techniques, data cleaning, and transformation.
• Previous roles as an Associate Data Analyst at IǪVIA (Bengaluru, India) and Data Administrator at OPTUM (Hyderabad, India), showcasing hands-on experience in data collection, cleaning, processing, and database management.
• Proven ability to collaborate with cross-functional teams, troubleshoot data- related issues, and provide analytical support for data-driven solutions. Technical Skills:
Big Data Technologies: Hive, SǪL.
Programming Languages: SǪL, PL/SǪL, and Scala.
Scripting Languages: Shell Scripting, Python.
Operating Systems: Windows, LINUX.
Cloud Technologies: GCP.
Databases: Oracle, SǪL-Server, MySǪL server.
Big Data Tools: Tabulae and R
IDE / Tools: Eclipse.
Education:
Master’s in information systems (MSIS) Aug’22 – Dec’23. Central Michigan University.
Professional Experience:
CMU (Office of Information Technology), MI, USA Jan’23 – Dec’23. Tech Services-OIT
Responsibilities:
• Troubleshooting Account Login Issues, Virus, and Spyware protection by using different Microsoft defender tools and removal, Software Installation.
• Developed SǪL queries to store and retrieve data from database.
• Worked with Complex SǪL queries, Functions and Stored Procedures.
• Exported the result set from HIVE to MySǪL using Shell scripts.
• Configured Hive meta store with MySǪL, which stores the metadata for Hive tables.
• Worked on google cloud platform (GCP) services like computer engine, cloud load balancing, cloud storage, cloud SǪL, stack driver monitoring and cloud deployment manager.
• Using g-cloud function with Python to load Data into Big query for on arrival csv files, parquet files in GCS bucket.
• Used Reporting tools like Tableau to connect with Hive for generating daily reports of data.
• Strong experience in RDBMS technologies like MySǪL, Oracle, Postgres.
• Managed students, staff, and faculty with a wide variety of issues including global-ID and Password, Wireless Setup. Created database users, logins, and permissions to setup.
• Improved the customer service maximum by 85% attending incoming phone calls, data entry and follow-up phone calls and Resolved Technical issues and reported the incidents on TDEX.
CMU (Big Data Analytics Department), MI, USA Aug’22 – Dec’22. Graduate Assistant
Responsibilities:
• As a Graduate Assistant, I guided students in mastering data engineering tools like Tabulae for robust big data applications.
• Mentored Python programming skills and cultivating the skills needed to construct data-driven applications and pipelines. And, arranged workshops on tools like GCP and led collaborative tutoring and provided timely assessments and feedback to nurture their learning.
• Contributing to Dow Chemical's Cyber-Attack Trend Analysis and enhancing security resilience. Skilled in statistical techniques, data cleaning, and transformation, I excel in distilling complex datasets to uncover valuable insights.
IǪVIA, Bengaluru, India. Ju1’21 – Aug’22
Associate Data Analyst
Responsibilities:
• Conducted comprehensive research and analysis on operational vulnerabilities, leading to a 15% reduction in potential fraud instances.
• Developed and maintained complex data sets for tracking customer activations and account usage, enhancing the accuracy of fraud detection.
• Collaborated with the Billing and Credit department to refine and implement new operational policies and procedures.
• Utilized SǪL and Excel to create detailed reports and analyses, successfully supporting strategic decision-making processes.
• Python was used for dataset analysis, cleaning, and modification to extract valuable information.
• Designed a real-time, scalable ETL pipeline using spark that increased processing speed by thirty percent.
• Using Hive, data warehousing solutions were implemented, increasing the efficiency of data queries by 25%.
• Streamlined data reporting processes, improving efficiency and accessibility of insights for management review.
OPTUM, Hyderabad, India. Ju1’19 – Jun’21
Data Administrator
Responsibilities:
• Executed entry-level tasks with expertise in data organization, entry, and maintenance.
• Assisted in database management, enhancing data accuracy using key administration tools for hands-on experience like SSMS (Microsoft SǪL Server Management System), MySǪL.
• Assisted in analyzing and reviewing financial data to identify discrepancies and potential fraud, contributing to a more robust fraud prevention strategy.
• Supported senior analysts in the completion of broad and complex projects by following established guidelines and best practices.
• Enhanced data visualization techniques using Google Spreadsheets, aiding the clearer presentation of data findings to stakeholders.
• Collaborated with teams to troubleshoot and re-solve data related issues.
Contact this candidate