SUMMARY

• Over 5 - year experience in data analysis and data visualization; Applied noledge to identify, determine, and solve business problems
• Full lifecycle experience in teh Business analysis of teh Agile Scrum, object-oriented development systems analysis, data wrangling, Core documentation, and Process analysis design, development and testing phases of Software Development Life Cycle
• Strong understanding of business process flows, Business Process Reengineering (BPR)
• Experience in working in a fast-paced team to identify business problems, and determine teh data source required to fulfill requirements from clients’ and different function teams
• Executed projects to drive insights that lead to self-employed business clients, enterprise clients, and overall market analysis
• Expertise in multiple programming languages, and data analytics & visualization tools including R, Python, SQL
• Created, developed, and ensure high-quality easy-access appearance and accuracy of monthly, quarterly reports templates for decision-making teams
• Created interactive dashboards to deliver easily interpreted insights for business performance evaluation helped to improve teh business performance
• Strong analytical and creative problem-solving skills as well as teh ability to make effective decisions
• Strong organizational skills along with teh ability to handle multiple tasks simultaneously
• Ability to communicate and maintain good working relations with technical team members, and technical and non-technical stakeholders
• Experience in Python used NumPy and pandas for statistical analysis and machine learning methods (Classic & penalized Regression)
• Working experience in R, managed and analyzed both structured and unstructured data with scientific computing and analysis packages
• Experience in database schemas designed, data transformation from raw data to designed database schemas, and data cleansing procedures to extract data
• Generated dashboards of weekly and monthly reports; Also, Generated story-telling quarterly business performance interactive dashboards for quarterly summary meeting
• Executed advanced excel skills (VLOOKUP & pivot table) to visualized and categorized customized reports to make in key performance indicators and insights for cross-functional business evaluations

TECHNICAL SKILLS

Language: R programming, Python (NumPy, pandas, seaborn, matplotlib, NLTK, TextBlob)

Project methodology: Agile, Scrum, Waterfall

Business Visualization Tools: Tableau, Power BI, MS Visio

Database management tools: MySQL, SQL Server, NoSQL, Hadoop

Operating System: Windows 10, macOS, Linux

UML Diagram: Use Case Diagrams, Activity Diagrams, Process flow Diagrams, Data Flow Diagrams

Machine Learning: Classic Penalized Regression Method (Lasso, Ridge), Decision Tree, Clustering, SVM

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Data Analyst

Responsibilities:

• Designed information management tool to handle 5G network data, helping Confidential solution teams to track, log and fix clients’ network glitches quickly by reducing service turnaround time by 70%
• Developed and implemented network key performance indicators, helping Confidential in performance testing and contract negotiations with clients by highlighting teh hidden problems in their networks
• Automated Daily network reports (Radio and Network Switching) to measure network health, improving teh operational efficiency
• Prepared weekly, monthly and quarterly network performance testing reports for higher management evaluating 5G network expansion and optimization
• Gatheird business and functional requirements for teh Retail Marketing department
• Identified distinct groups of customers which informed content and marketing strategy
• Analyzed business trends and performance regionally, including point of sales analysis of product categories, revenue, and customers segmentation to identify teh new business opportunities
• Worked with supervisor to discern significant value drivers and challenges, and determine teh key metrics and insights for improving business performance
• Reviewed and analyzed key metrics to develop an understanding of customers’ behavior and communicated findings to sales team; Collaborated with cross-functional teams (sales, strategy, IT) to enhance channel program offering
• Developed predictive models based on logistic regression and data mining technique by Python to optimize email send-time for teh marketing department, and day-of-week, resulting in a 13% uplift in open rates with an email subscriber list
• Identified opportunities, and helped program management stakeholders to make decisions for improving business performance by implementing changes in teh existing data model, and provide ad-hoc reporting dashboard using Tableau
• Combined information from multiple sources (CRM, POS Database) and translated data into actionable insights
• Developed customer affinity analysis based on prior network activities and geographical locations; Retargeted campaigns led a 20% increase in new/recurring revenue

Environment: MS Office, Python (JSON, YAML, Numpy, Pandas, Sklearn), Tableau, SQL

Confidential, McLean, VA

Business System Analyst

Responsibilities:

• Gatheird information from various stakeholders by conducting root cause analysis, generating mockups, and observing; initiated high-level business requirements document (BRD)
• Successfully conducted JAD sessions, which helped synchronize different stakeholders on their objectives and helped teh developers to has a clear-cut picture of on perspectives of improvements to be implemented
• Performed risk analysis for teh project; identified related importance, possibility, and severity
• Followed Agile Scrum framework for teh project to reduce teh chances of failing and to keep doors open for any upcoming big change in teh requirements
• Updated workflow, process flow diagram, and GAP analysis by identifying existing billing, documenting teh enhancements to meet teh end state requirements
• Presented teh results of non-functional/technical improvements on sprint review meeting by leveraging Tableau
• Analyze business requirements and document them into vision document and segregated them into high-level and low-level Use Cases, UML diagrams (activity diagrams / State Chart Diagrams)
• Wrote, manage, and prioritize epics and user stories to specify requirements and importance using JIRA
• Supervised regular sprint planning, daily stand-up, sprint review, sprint retrospective meetings and supplied appropriate management reporting
• Clarified QA(Quality assurance) team issues and reviewed test plans and test scripts developed by teh QA team to make sure that all requirements will be covered in scripts and tested properly, and assisted teh QA personnel in teh creation of Test Cases
• Assist teh QA personnel in teh creation of Test Cases

Environment: MS Office, Python (Numpy, Pandas, Sklearn), Tableau, SQL, Scrum framework

Data Analyst

Responsibilities:

• Gatheird information from various stakeholders and documented high-level business requirements
• Assist users in account management by providing visualized summaries on weekly spending
• Designed, created, and defined key metrics applying to data to analyze teh past business performance, and worked on generating scripts for churn rate prediction by considering factors such as monetary size, monthly payment, rating, and terms
• Utilized tree model, random forest model, logistic model, and linear regression model to predict teh business performance
• After tuning teh parameters of mode, Improved teh model performance by around 10%
• Conducted workflow, process diagram, and GAP analysis by identifying existing technologies, documenting teh enhancements to meet teh end state requirements
• Used advanced Microsoft excel to categorize customers; Improved teh counseling effectiveness by 20%
• Ran sample tests on different categories and visualized teh business performance increasing rates and trend in each category
• Built Tableau visualizations for ad-hoc reporting against various Data Sources for stakeholders’ meetings
• Analyzed provided dashboards and requirements to improve teh performance for faster access of dashboards to teh partners

Environment: MS office, Python (Numpy, Pandas, Sklearn), Tableau, SQL

Confidential

Financial Analyst Intern

Responsibilities:

• Performed full cycle of accounting duties and assisted with budgeting and forecasting on a monthly basis
• Major accomplishment included reducing teh company's marketing cost and made routine management tasks into automation procedure to improve office efficiency
• Ran teh statistical data trends analysis and created financial visualization models using Excel and R, and monitored teh risk appetite and exposure threshold rebalance teh portfolio asset allocation
• Built automatic customized analysis and data visualization dashboard to automate teh portfolio reporting on daily PnL to teh portfolio manager