Hwang Hunjin
+44-xxxxx | ABC@ gmail.com | Postal Code, City, UK | Full working rights | LinkedIn | GitHub
Professional Summary
Data Analyst with expertise in Python, predictive modeling, and data cleaning, driving a 21% increase in productivity. Proficient in SQL optimization, statistical methods (descriptive and inferential), and fostering cross-departmental collaboration to ensure data integrity. Skilled at identifying data issues, monitoring metrics, and delivering actionable insights, with strong report-writing capabilities.
Key Skills/Technical Skills
- Data Analysis & Reporting: SQL (OracleSQL, PostgreSQL, MSSQL, MySQL, BigQuery, Cassandra, MongoDB), Power BI (DAX), Tableau, Excel (Pivot Tables, VLOOKUP), Matplotlib, Seaborn, data visualization, competitor analysis, market research.
- Programming & Development: Python, R, Java, Spring Boot, JavaScript, jQuery, AJAX, Unix/Linux scripting, REST API, Apache Maven, Tomcat.
- Machine Learning & Data Processing: NumPy, Pandas, Google Analytics, GCP, predictive analysis, trend identification, model development.
- Testing & Automation: Selenium, Java (Maven), TestNG, Cucumber (BDD/TDD), REST Assured, JMeter, Postman, API testing, performance testing.
- Database Management & ETL: SQL, ODI (Oracle Data Integrator), OSB (Oracle Service Bus), Oracle SOA Suite, data extraction, transformation, and processing.
- Agile & Project Management: Agile (Scrum, Kanban), JIRA, Jenkins (CI/CD), Confluence, Git/GitHub/SVN, sprint planning, backlog management.
- Other Tools & Technologies: PyCharm, MS Office, cloud-based analytics, workflow automation, software deployment.
Training & Certifications
- Tableau Certified Data Analyst (May 2024)
- IIITB Certification of Executive PG Program in Data Science (October 2023)
- IBM Certification of Python for Data Science (Feb 2024)
- Master’s Program in Data Analytics (Mar 2024)
- Business Analytics with Excel (Jan 2024)
Professional Experience
Data Analyst (Intern – Hybrid)
Fortray Global Services LTD, London May 2024 – Present
- Assisted in data governance by tagging metadata, tracking data lineage, and identifying data ownership.
- Developed and maintained ETL pipelines to ensure data accuracy and consistency.
- Created interactive dashboards in Tableau & Power BI to visualize key business insights for stakeholders.
- Managed SQL databases, ensuring data integrity, implementing indexing strategies, and performing backups.
- Collected, cleaned, and transformed raw data using SQL, Python (Pandas), and Excel.
- Utilized Excel functions (Pivot Tables, VLOOKUP, conditional formatting) for data compilation and cleaning.
- Wrote and optimized SQL queries for efficient data extraction and manipulation.
- Designed and optimized database schemas to enhance performance and storage efficiency.
- Automated data transformation tasks using Python (Pandas) for improved efficiency and complex calculations.
- Collaborated with cross-functional teams to translate business requirements into data-driven insights.
- Contributed to process optimization, ensuring high standards of data accuracy and consistency.
- Continuously stayed updated with the latest data analytics tools and methodologies to improve workflows.
Data & Quality Assurance Analyst
Wipro Technologies, India Nov 2009 – Dec 2023
- Conducted in-depth data analysis using SQL (OracleSQL, PostgreSQL), Python (Pandas, NumPy), and Excel, ensuring accurate data-driven insights for business decision-making.
- Designed, optimized, and maintained relational databases, ensuring high data integrity, efficient query performance, and seamless data extraction for reporting.
- Developed interactive dashboards in Power BI, Tableau, and Excel, transforming complex datasets into actionable insights for stakeholders.
- Automated data validation, reporting workflows, and quality assurance processes using Python, Selenium, and SQL, improving efficiency and accuracy.
- Led end-to-end software and data quality assurance, implementing manual and automated testing strategies to ensure data integrity, system reliability, and optimal performance.
- Validated API integrations, conducted performance testing using Postman, REST Assured, and JMeter, and ensured seamless data exchange between systems.
- Assisted in building predictive models and statistical analysis to forecast trends, optimize business strategies, and enhance decision-making.
- Partnered with cross-functional teams to translate business requirements into data-driven solutions, ensuring smooth implementation and process enhancements.
- Operated in an Agile (Scrum, Kanban) environment, managing tasks using JIRA, Jenkins, and GitHub, while ensuring adherence to project timelines and quality standards.
Key Projects
Inventory Management Dashboard Using SQL and Tableau:
Objective:
Developed an interactive inventory management dashboard to optimize stock levels, reduce stock-outs, and prevent overstocking.
Technical Details:
- Extracted and transformed inventory data from SQL Server and integrated it into Tableau for visualization.
- Built KPIs to track stock turnover, reorder levels, and aging inventory trends.
- Designed interactive dashboards with forecasting and trend analysis to support inventory optimization.
Customer Sentiment Analysis Using Python and NLP:
Objective:
Analyzed customer reviews using Natural Language Processing (NLP) to identify sentiment trends and improve customer experience.
Technical Details:
- Collected and preprocessed customer review data from multiple sources using Python (Pandas, NLTK, TextBlob).
- Applied NLP sentiment classification to categorize reviews as positive, negative, or neutral and generated sentiment scores.
- Created interactive visualizations to track sentiment trends over time and highlight key insights.
Financial Forecasting Model Using SQL and Power BI:
Objective:
Developed a financial forecasting model to project future revenue and expense trends, aiding in strategic decision-making.
Technical Details:
- Extracted historical financial data from SQL databases for analysis.
- Designed forecasting models in Power BI using DAX calculations to predict revenue and expenses.
- Built an interactive Power BI dashboard to visualize forecasted vs. actual financial trends in real time.
Education
Bachelor of ABC
University of XYZ, Country Mon 20xx – Mon 20xx
Reference
Will be available upon request.
