Compliance Data Analyst Resume Dallas - Hire IT People

SUMMARY

Expertise in database, SQL programming (complex queries and stored procedures) and advanced reporting skills such as Tableau, Excel pivot table
Current position functions as Data Engineer, Business Analyst, Data Analyst and Testing Analyst
Strong understanding of ETL (Extract, Transform, Load) wif experience in using ETL to move data between Amazon S3 and Redshift
Developed, designed and produced teh KPIs, Dashboards, Scorecards and other customized reports to continuously improve business performance utilizing Microsoft SQL Server and Tableau
Power user of advanced SQL queries wif multi - table joins, sub-queries, set operations wif hands on experience in debugging complex stored procedures
Created personalized database solutions, which simplified routine processing and reporting for customers
Comfortable working wif incomplete information, inadequate documentation and dealing wif isbiguity and discrepancy analysis in a fast-paced, high-pressure environment
Experience working under tight deadlines and successfully managing multiple tasks simultaneously wif minimal supervision
Highly skilled in transforming business noledge and requirements into Business Intelligence (BI) technologies

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Dallas

Compliance Data Analyst

Responsibilities:

Responsible for generating 6 critical monthly Compliance reports including RDA, complaints, fair lending, TCPA and SCRA
Revamped monthly reporting system by optimizing SQL queries, introducing concurrent work-flow tasks, and reduced teh monthly reporting window from two weeks to three days
Designed, built, and maintained over 40 ad-hoc reports to meet different business requirements for all Compliance departments through analyzing stored procedures, researching databases, quickly gathering separate information and writing complex SQL queries and stored procedure
Designed and created Executive Dashboard, Scorecard, and KPI report using SSRS/Tableau/Excel pivot table
Defined KPIs/Metrics wif their calculations, such as Average Business Days to Resolve Complaints
Conducted a comprehensive report rationalization, including a review of all KPIs/Metrics, frequency, delivery method, and audience
Provided efficient and TEMPeffective solutions for Report Development & Process Automation
Created detailed documentation for SQL queries, Reports, and other BI solutions
Conducted performance tuning and optimization for queries/reporting
Collaborated wif BI and data owners to obtain and understand data sources and deal wif data issues and data validation

Confidential

Intern, Data analyst

Responsibilities:

Examined and proof read teh entirety of to audit every mathematical and statistical concept
Implemented Naive Bayes classifier in R to assign teh right author to anonymous text by first cleaning teh text, implementing teh classifier wifout using built-in functions, and using cross validation to compare false positive rates among Naive Bayes, tree, shrinkage and SVM

Confidential

Intern, Stock Data Analyst

Responsibilities:

Improved reporting efficiency by building Excel templates to automate teh manual reporting process
Developed VBA code to generate 15000 clients’ data into text file wif unique first name, last name, phone, address and license plate number for DBA to load teh generated text file into SQL Server DB for project load testing