Summary
Overview
Work History
Education
Skills
Accomplishments
Affiliations
Work Availability
Timeline
Hi, I’m

Richard Gaire

Mount Prospect,IL

Summary

6+ years of IT experience and Technical proficiency as Data Analyst in SAS, ETL ,SQL coding, Data Modelling and Data warehousing involved with in database design and development in Oracle databases and SAS Enterprise Guide .

-Data warehousing, process validation and business needs analysis.

-Expedited in developing code for the data bases applications to interact with databases in Oracle.

-Extensive experience in Sas such as trans pose , compare ,append, import ,export Summery ,freq etc.

Proven to understand customer requirements and translate them into actionable project plans.

Dedicated and hard-working with passion for Big Data. Perceptive and logical Data Analyst communicates well with both technical professionals and end-users to identify and translate business requirements.

Experienced driving data accuracy and integrity to exceed quality standards.

Builds and leads teams of talented professionals to develop valuable process solutions and meet business objectives.

Dedicated and motivated Data Analyst with proven skill driving process and data integrity improvements.

Leads teams in data warehousing solutions.

Exceptional skill in SQL-based environments.

Created reports in PDF, HTML, XML, RTF using SAS/ODS statement and data null.

-Extensive experience on SAS procedures like such as transpose, compare, append, import, export, SUMMARY, FREQ.

- In-depth knowledge in SAS BI tools, Such as SAS/DI,SAS/EG

- Expert in preparing code to interface with Teradata, SQL database with UNIX and Windows operating systems

- Efficient usage of SAS tools such as SAS/ Base, SAS/Connect, SAS/SQL, SAS/STAt, SAS/Graph, and SAS Macro

- Expertise in data step programming abilities for data manipulation, processing quantize, qualitative analysis, and report generating.

- Over seven years of proven expertise in statistical analysis and strong modeling in Fiance and Health care industries.

- Optimizing performance using various data validation and data cleaning methods on campaign data using statical procedures.

-Providing input in developing specifications of analysis datasets, validation plans, and other related documents and determining, research SAS software upgrades and related system maintenance results.

- Used advance SAS tools to automate the reporting systems to generate daily and monthly reports for advanced premium, policy risking-force count, monthly claim count, claim recover, claim outstanding reserve, paid claims reports, outstanding loss, agent commission etc

-Experienced with requeimnts analysis, development, testing, execution, maintaence, documentation and archival pf SAS reports.

-Provide more meaningful information vital to the overall stratrigeis.

- Revised and automated daily, weekly, monthly, and quarterly reports to run more efficiently and

-Excellent communication, analyzing and reports writing skill with ability for effectively communicate results of statistical analysis to diverse audience.

Hardworking and passionate job seeker with strong organizational skills.

Ready to help team achieve company goals. Organized and dependable candidate successful at managing multiple priorities with a positive attitude.

Willingness to take on added responsibilities to meet team goals.

Experienced Senior Data Analyst with over 7 years of experience in Banking. Excellent reputation for resolving problems and improving customer satisfaction. Detail-focused Data Analyst with knowledge in data warehousing, process validation, and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Seasoned collaborator

Experienced in meeting needs, improving processes and exceeding requirements in team environments.

Diligent worker with strong communication and task prioritization skills.

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Motivated and results-driven Data Analyst with a proven track record in data analytics and process mapping. Identifies business needs and develops valuable solutions to improve accuracy and process optimization.

Drives business success with recommendations based on data findings. Seasoned collaborator experienced in meeting needs, improving processes, and exceeding requirements in team environments.

Diligent worker with strong communication and task prioritization skills. Seasoned collaborator experienced in meeting needs, improving processes, and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.

Overview

9
years of professional experience

Work History

Capital One
Chicago, IL

Data Analyst
02.2018 - Current

Job overview

  • Researched and resolved issues regarding integrity of data flow into databases.
  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Tested data prediction algorithms based on historical data.
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs.
  • Participated in requirements meetings to understand business needs.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Documented project constraints business impacts and risks, noting potential impact to organization.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Developed tables, views and materialized views using SQL.
  • Used statistical methods to analyze data and generate useful business reports.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Designed and implemented tools to support strategic value chain optimization initiatives.
  • Compiled, cleaned and manipulated data for proper handling.
  • Developed polished visualizations to share results of data analyses.
  • Modeled predictions with feature selection algorithms.
  • Leveraged mathematical techniques to develop engineering and scientific solutions.
  • Tested and validated models for accuracy of predictions in outcomes of interest.
  • Built relationships and influenced and motivated employees to drive operational improvements.
  • Developed and improved integrated reporting and analysis capabilities.
  • Articulated risks and issues to communicate concerns to various levels of management.
  • Executed analysis of risks and identified risk mitigation strategies.
  • Evaluated trends to understand competitive environments and assess current strategies.
  • Promoted enterprise-level risk management practices and helped instill strong culture focused on protective policies and procedures.
  • Instituted contingency plans, promoting business continuity through cross-training, documentation and data backups.
  • Collaborated on implementation of collection strategies with collections, risk and fraud teams.
  • Investigated allegations to check validity and recommend actions to minimize risk.
  • Instituted regular safety inspections and hazards management strategies to keep operations compliant.
  • Analyzed data on price, stability and other factors affecting investment programs to incorporate into investment decisions.

State Farm
Buffalo Grove, IL

ETL Tester
02.2015 - 03.2018

Job overview

  • Gathered data on integration issues and vulnerabilities, reported findings and recommended improvements.
  • Developed and maintained defect databases for known issues
  • Evaluated function, performance and design compliance of every product against design standards and customer needs.
  • Kept scripts and test cases updated with current requirements.
  • Monitored resolution of bugs, tested fixes and helped developers tackle ongoing problems by providing QA perspective.
  • Developed and maintained defect databases for known issues.
  • Built automated test scripts to handle repetitive software testing work.
  • Completed pre-implementation testing for new system modifications to assess potential impacts.
  • Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
  • Conducted research, gathered information from multiple sources, and presented results.
  • Monitored resolution of bugs, tested fixes and helped developers tackle ongoing problems by providing perspective
  • Evaluated function, performance, and design compliance of every product against design standards and customer needs

American Century Investments
St Louis, MO

Business Analyst
04.2013 - 12.2014

Job overview

  • Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
  • Identified process inefficiencies through gap analysis and outlined sensible solutions.
  • Led cross-functional teams to analyze and understand enterprise-wide operational impacts and opportunities of technology changes.
  • Supported leadership team with reporting, analysis and business presentations to inform divisional strategies.
  • Met with stakeholders to establish favorable business relationships and support mutually beneficial interests.
  • Delivered analysis of market, sales and consumer trend impact on long and short-term strategies.
  • Assessed impact of current business processes on users and stakeholders and evaluated potential areas for improvement.
  • Improved business direction by prioritizing customers and implementing changes based on collected feedback.
  • Collaborated with teams in product line transition to streamline manufacturing footprint.
  • Drafted reports on company financial metrics to assess successes and account for deficiencies.
  • Interacted with internal customers to understand business needs and translate them into requirements and project scope.
  • Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance, and functionality.
  • Evaluated trends to understand competitive environments and assess current strategies
  • Analyzed key aspects of thebusiness to evaluate factors driving results and summarized into presentations

Education

Southern New Hampshire University
Hooksett, NH

Bachelor of Science from Computer And Information Sciences
04.2025

Tribhuwan University ,Nepal
Butwal

Bachelor of Science from Mathematics Education
03.1995

Skills

  • Database Programming SQL, Python , R
  • Statistics and SAS
  • Unix, Linux
  • Jupiter notebook
  • Teradata
  • Industry Report Reading
  • Industry Trend Analysis
  • Reporting Tools
  • Query Tools
  • Information Processing
  • Data Warehousing
  • Information Flow Management
  • Advanced Excel Spreadsheet Functions
  • Word Processing
  • Extraction Transformation and Loading (ETL)
  • User Acceptance Testing (UAT)
  • Teradata Database
  • Spatial Visualization
  • Teradata BTEQ
  • Microsoft Power BI
  • Metadata Enhancements
  • Enterprise Application Integration

Accomplishments

  • Modified and improved existing databases to reduce processing time by 75% and improve accuracy by 100%.
  • Made recommendations on business intelligence tools to cut processing time by 98%.
  • Supervised team of 5 staff members.

Resolved product issue through consumer testing.

Affiliations

  • Project Management Institute
  • Rotary International
  • Lions Club
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analyst

Capital One
02.2018 - Current

ETL Tester

State Farm
02.2015 - 03.2018

Business Analyst

American Century Investments
04.2013 - 12.2014

Southern New Hampshire University

Bachelor of Science from Computer And Information Sciences

Tribhuwan University ,Nepal

Bachelor of Science from Mathematics Education
Richard Gaire