| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data AnalystLocation: Jersey City, NJ Mobile: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLE 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.SKILLSLanguages: Python, SQL, RMethodology: SDLC, Agile, WaterfallPackages: NumPy, Pandas, Matplotlib, SciPy, ggplot2 Data Warehousing: AWS, Big Query, SnowflakeVisualization Tools: Tableau, Power BI, Microsoft Excel Database Management: My SQL, SQL ServerIDEs: Visual Studio Code, PyCharmCloud 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-SolvingOperating System: Windows, LinuxEXPERIENCEUnited 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. EDUCATIONMaster of Science in Computer Science - University of North Texas, Denton, Texas Bachelor of Engineering in Information Technology Gujarat Technological University, India |
