Data Analyst

PROFILE

Exceeding client expectations through focused research, quantitative, statistical, technical, analytical and problem-solving skills, and an urge to learn and implement processes to improve data-driven decision making. Designed, built and deployed efficient, scalable, robust solutions for intricate business problems using data warehousing technologies and reporting tools. Dec 2015 – Dec 2018 Sr. Data Insights Analyst, Upwork Build data pipeline for internal monitoring on key matrices of the Intelligent Reporting for client’s eCommerce website: data extraction and processing using Hive & Spark from data bases, query automation, data visualization in Tableau.

Compiled SQL queries, design & implement ETL solutions using Talend ETL solution software. Designed logical data model to confirm source data, business logic, reference tables, and destination databases.

Conducted data blending, data preparation using Alteryx and SQL for Tableau consumption and publishing data sources to server boosting efficiency. Determine KPIs and develop and maintain scorecards that align with the user experience vision and strategy.

Collaborated closely with cross-functional teams including engineers, developers, QA leads, customer support, and product team to build new features. Designed Machine Learning models using R shiny app to use structured, and unstructured variables to intelligently route the tickets to proper queues. Collated and presented the recommendations and insights that would enable continuous measurable improvement in the client’s business decisions. Responsible for leading delivery teams, supporting the planning, development and implementation of project efforts.

Managing offshore team of 16 analysts and maintaining customer relationships with clients ranging from first level management to vice presidents, across business and technology functions. Provided technical and analytical guidance to business stakeholders to meet diverse business needs.

Environment: Tableau, Alteryx, MS SQL Server 14, Python, R, MS PowerBI, Spark, Hadoop, Hive, XML Oct 2013 – Nov 2015 Data Analyst Consultant, Clients: Earnest Inc, International Law Group, P.A.

Focal point for making sound underwriting decisions related to applicant profiles, loan rate decisions, data collection, data analysis, and overall portfolio profile. Developed and implemented new policies to enhance the tools used to underwrite loan applications, while providing training across department for overall efficiency. Mined large data sets and created customized underwriting reports to improve insights into Portfolio Reporting Operations and Treasury Operations teams databases. Synthesized large chunks of data and understand trends, and communicate insights/recommendations to senior leadership.

Expertise experience working on the IRR, LIBOR, CCAR, Dodd Frank and other financial regulations and experience in customizing financial services applications. Contributed to the successful implementation of Data Quality checks using PIT and TTC estimates for internal reporting and Building the SL Database. Conducted both technical and functional interviews with various stakeholders of the application to exceed remittance processing and reporting SLAs. Cleaned data using stop-words, Regex etc.; created feature vectors using bag-of-words model, generated predictive model for text classification (SVM) performed 10-fold cross-validation, and evaluated model performance using confusion matrix. Reduced the average classification error rate to 68%.

Gathered and analyzed loan-level static and dynamic/transactional data to ensure data quality and data integrity via R scripts.

Created Dashboards for risk analysis using Salesforce with interactive views, trends and drill downs along with user level security.

Audited transition from Postgres to Redshift for SL databases and recommended migration solutions to various stakeholders.

Ludson Leon

415-***-****, **********@*****.***

EMPLOYMENT HISTORY

Triaged and maintain exceptions management workflows to ensure timely and accurate reporting using Zendesk via python scripts.

Environment: Python, R, Postgres, AWS Redshift, Tableau, Zendesk, Looker, Salesforce, SQL Server 2014, GoogleSheets, MS Word, MS PowerPoint

Feb 2012 – Oct 2013 Business Banking Specialist, Wells Fargo Bank NA Recognized as one of District’s Top Bankers [July–Sept. 2013] Actively involved in the compilation, management, reconciliation and reporting of Wells Fargo’s investment referrals for daily, monthly and quarterly deadlines. Regularly formulated, tested and implemented efficient reporting systems to capture and report key variances to necessary business partners.

Pro-actively involved in the gathering and analyzing capacity related data from production to measure against metric driven benchmarks to ensure full systems availability. Acquired and retained relationships with Wells Fargo partners to maximize opportunities which lead to exceeding both Branch and District goals by 162%. Environment: Ms Access, Basel II, T-SQL, MS Excel, MS Word, MS PowerPoint Jan 2010 – Feb 2012 Strategic Project Analyst, Moison.me Manage cross functional teams within the project and development processes to assess existing technologies and validating requirements & project specification documents. Consistently used ETL & BI solutions to collect and present data to management. Responsible for liaison between technical and business teams for meeting customer requirements such as documenting errors and incorporating software enhancements on a scheduled basis. Created and maintained central metadata repository using MS Excel pivot tables, MS Access and VBA from Business Objects and Oracle Data Integrator databases. Refactored various VBA based Applications that shared data between MS Excel, MS Access and MS PowerPoint.

Developed business plan and led the team in introduction of new service yielding revenue of $2M for FY2012

Environment: MS SharePoint, MS Excel, MS Word, MS Visio, MS PowerPoint, SQL Server 2008, Oracle 11g, ALM/HP Quality Center 11

Jul 2012 Howard University, BBA Finance Minor Statistics SKILLS Data Mining Expert

Sales Analytics Experienced

Project Management Skillful

Cost Accounting Experienced

Data Engineering Experienced

Dashboard Visualizations Expert

Forecasting Experienced

Jul 2017 Data Science and Data Engineering NYC

EDUCATION

CERTIFICATES

Contact this candidate