Senior Analyst Resume
3.00/5 (Submit Your Rating)
DenveR
TECHNICAL SKILLS:
Programming Languages and Tools: R, SQL, Tableau, Power BI, MicroStrategy, Python, IBM Cloud, MapReduce (Hive, HQL), A/B Testing, Teradata, Google Analytics (Certified).
Technical Knowledge: Statistics, Machine Learning (Regression, Decision Tree, Clustering and Scaling), ETL (SQL Server), Predictive Modelling, Data Mining, Data Cleaning, Data Analysis and Business Intelligence.
PROFESSIONAL EXPERIENCE:
Senior Analyst
Confidential, Denver
Responsibilities:
- Extracted and analyzed customer reviews data and built a sentimental analysis model to categorize customers experience on services using R.
- Developed predictive models predict customer loan payment trend and behavior using machine learning algorithm.
- Performed data integration, outlier analysis, missing value treatment, correlation analysis, PCA as part of data preparation.
- Extracted, Transformed and Loaded data from various sources into single file using SSIS and reduced data migration time by 30%. Rendered data using SQL for analysis to answer business questions.
- Worked closely with senior manager to Develop capacity analysis model comprising 18 teams (~130 employees) and 12 different data systems. This helped to upscale the operational efficiency and set the baseline.
- Part of the team that developed ETL pipelines by integrating various data system including people soft to measure individual productivity. This changed existing productivity management strategy and reduced manual work by ~90%.
- Performed in - depth analysis of customer call volume data to develop predictive model to predict the incoming call volume. This analysis lead to pipeline existing employees into multiple projects. This improved resource utilization by ~20%.
Associate - Business Data Analyst
Confidential
Responsibilities:
- Conducted data analysis using SQL, excel and created reports and dashboards using Tableau to represent the results.
- Analyzed sales and procurement data to perform GAP analysis by comparing target measures to actuals
- Managed data by proposing ideas and enhancements on BI reporting for business user and end user.
- Queried large data sets using SQL and cleaned it using R for modeling.
- Developed data visualizations to represent KPIs, dashboards and reports of operational efficiency
Program Analyst
Confidential
Responsibilities:
- Built complex SQL using advanced analytical functions to retrieve data from distributed data systems for analysis.
- Delivered test results of various features & regression analysis identifying bugs at an early stage saving 20% work.
Intern
Confidential, Denver
Responsibilities:
- Worked with cross-functional teams to gather requirements and created KPI’s and metrics to analyze the application performance and check existing system infrastructure compatibility with new business requirements.
- Built client recommendation dashboard using tableau to target new clients that increased new clients by 15%.
