Data Analyst Analysis

MEET KOTHIYA

Data Analyst

Location: Jersey City, NJ Mobile: 469-***-**** Email: *********@*****.*** SUMMARY

● Data Analyst with around 5 years of experience possesses a strong foundation in data analysis, statistical techniques, and data visualization.

● Designed and optimized BigQuery schemas, ERDs, and data pipelines enabling faster query performance.

● Built validation checks and tests ensuring accuracy of analytic output used for business decisions.

● Skilled in data manipulation, cleansing, and validation techniques to ensure data accuracy and reliability.

● Skilled in extracting, cleaning, and transforming large datasets from various sources using SQL, Excel, and Python to ensure data accuracy and integrity.

● Proficient in data visualization tools such as Tableau or Power BI to create compelling visualizations, dashboards, and reports.

● Proficient in analyzing complex datasets, identifying patterns, and extracting actionable insights to support business decision-making.

● Understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture, and Designing.

● Mentored junior analysts in applying statistical methods and mastering data tools. Improved team skills.

● Strong attention to detail, ability to manage multiple projects and meet deadlines, while maintaining data integrity and quality standards.

SKILLS

Languages: Python, SQL, R

Methodology: SDLC, Agile, Waterfall

Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2 Data Warehousing: AWS, Big Query, Snowflake

Visualization Tools: Tableau, Power BI, Microsoft Excel Database Management: My SQL, SQL Server

IDEs: Visual Studio Code, PyCharm

Cloud Platforms: AWS (Amazon Web Services), Azure, Google Cloud Platform Other Skills: Data Cleaning, Data Visualization and reporting, Statical Analysis, Data Governance, Data Wrangling, Data Modeling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving

Operating System: Windows, Linux

EXPERIENCE

United Health Care, NY Jun 2022 - Current Data Analyst

● Involved in complete Agile Requirement Analysis, Development, System, and Integration Testing.

● Perform data analysis and reporting tasks, utilizing SQL, Python, and Excel for data manipulation and analysis.

● Wrangled datasets from CSVs and Excel files into data models using Pandas and NumPy libraries in Python.

● Developed Python scripts to automate data collection from multiple APIs and systems, reducing manual effort by 40%.

● Migrating data to/from staging table in SQL from multiple data sources including Excel, CSV flat files, and other SQL servers.

● Designed and developed data pipelines and ETL processes to extract, transform, and load data into cloud- based data warehousing solutions such as Amazon Redshift and Google Big Query.

● Collaborate with stakeholders to gather requirements and define project objectives. Participate in meetings and discussions to understand business problems and provide data-driven insights.

● Built Tableau dashboards to track KPIs across sales, marketing, and operations. Dashboards drove a 10% increase in lead conversion rate.

● Developed Python scripts to automate data collection from multiple APIs and systems, reducing manual effort by 40%.

● Designed and maintained SQL Server databases and tables to store 7 years of historical data for analytics.

● Contribute to the development of data-driven strategies by providing insights and recommendations. Collaborate with team members to identify opportunities for leveraging data to drive business growth. Birla Soft, India Jan 2019 - Aug 2021 Data Analyst

● Used the Waterfall methodology to build the different phases of the Software Development Life Cycle.

● Analyzed and transformed data using various SQL functionalities using MySQL server to generate data extracts and reports.

● Conducted data analysis experiments, A/B testing, and statistical modeling to optimize business processes, improve customer experience, and increase operational efficiency.

● Stayed up to date with the latest cloud technologies, data analytics tools, and industry trends, and recommended innovative solutions to enhance data analytics capabilities.

● Documented data lineage, data dictionary, dependencies to streamline onboarding for new analysts.

● Performed statistical analysis using R and Python to uncover correlations and patterns in complex datasets.

● Developed sales reports using the on-premises data on Microsoft Excel and Tableau.

● Utilized Tableau to create various analytical dashboards that help business users to get a quick insight into the data.

● Provided support to end users for production issues and built custom SQL scripts for business needs.

● Worked on data cleaning and reshaping, generated segmented subsets using NumPy, Pandas, matplotlib, and SciPy in Python, resulting in a 25% reduction in data errors.

● Continuously improve data analysis processes and methodologies. Stay abreast of emerging technologies and industry best practices to enhance efficiency and effectiveness. EDUCATION

Master of Science in Computer Science - University of North Texas, Denton, Texas Bachelor of Engineering in Information Technology – Gujarat Technological University, India

Contact this candidate