We provide IT Staff Augmentation Services!

Senior Data Analyst / Business Analyst Resume

3.00/5 (Submit Your Rating)

Mclean, VirginiA

Hire Now

SUMMARY

  • Adaptable risk analytics professional with around 16 years of diversified experience.
  • Good understanding of Data Warehousing concepts like Fact Tables, Dimension Tables, Star and Snowflake Schema, Metadata and Data Marts
  • Robust MS Access and Excel skills with Pivot tables and VLookUps.
  • Proficient in creating SQL queries.
  • Strong written & verbal skills in order to communicate with all levels of the organization.
  • Capable of managing multiple priorities with a high - level of efficiency, organization and self-direction.
  • Flexible problem solver and analytical thinker with excellent communication and customer service skills.
  • Proven ability to effectively work independently or as part of a team to efficiently solve problems and produce positive results.

TECHNICAL SKILLS

Concepts: AWS Services

Tools: Rapid SQL, MYSQL Workbench, MicroStrategy, Tableau, JIRA

Operating Systems: Windows, UNIX

Database: Oracle, Sybase, CDW, MS Access, AWS RDS, Hadoop File System (HDFS)

Programming Languages: SAS, SQL, Visual Basic, Python

Applications: Microsoft Office (Word, Excel, PowerPoint, Visio, Outlook); Microsoft Teams, SharePoint, OneNote, OneDrive, PESystem, Note Tracking System, Pac-Trac system, MidaNet system, Lotus Notes

Cloud Technologies: AWS, Redshift RDS, S3 storage, CloudWatch, SNS

SDLC Methodologies: Agile and Waterfall

PROFESSIONAL EXPERIENCE

Confidential - McLean, Virginia

Senior Data Analyst / Business Analyst

Responsibilities:

  • Developed and executed SQL queries to create and maintain both ad-hoc and standardized weekly/monthly/quarterly reports to support department inventory, status, repurchases and other requested indicators. Reduced number of requests for historical data by posting data into self-service SharePoint site.
  • Accessed Sybase and CDW data via MS Access to generate the required reports.
  • Updated monthly reports using MicroStrategy platform and provided data for ad-hoc reporting needs.
  • Executed VBA procedures to auto-populate data into multiple quality report tools. Adjusted and coordinated the addition of new datasets. Refreshed and maintained VBA-generated end-user tools. Identified and expediently escalated issues.
  • Maintained, enhanced and created MS Access reporting databases.
  • Interacted with internal and external customers to create, enhance and accurately provide more than 40 scheduled operational and ad-hoc reports, meeting time delivery and other SLA commitments.
  • Created data visualizations by creating pivot table summaries to brief both management and customers.
  • Performed data verification, data validation and comparison of data.
  • Generated flat files by updating the SAS program to generate ad-hoc reports.
  • Identified Autosys program failures, analyzed log files using VI Editor in UNIX and escalated results and recommendations to management.
  • Trained coworkers on file formats, pivot tables, database queries and importing data in Excel and Access.
  • Prepared step-by-step procedural documentation for processing reports

Confidential - McLean, Virginia

Risk Analyst Professional / Associate

Responsibilities:

  • Generated several operational and ad-hoc reports by writing and executing SQL queries.
  • Formatted Excel reports and created pivot table summaries to brief management and customers.
  • Managed Autosys process, monitoring job status and restarting SAS program as needed, then used FTP to transfer generated flat-files into shared drives.
  • Served as back-up for several team members, executing their processes in addition to my workload.
  • Administered reporting mailbox. Tracked requests and prioritized, assigned and escalated issues.
  • Promoted from Associate to Professional.

Confidential - McLean, Virginia

Loan Processor

Responsibilities:

  • Reassigned appeal files to underwriters using Quantum application.
  • Monitored mailbox to process requests for review appraisals and CRS, flood and credit reports and updated the Quantum database.
  • Published servicer letters as needed for quality control purposes.
  • Provided as needed clerical assistance for Central Processing group.
  • Scanned documents and uploaded them to the shared drive for underwriter accessibility.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship