We provide IT Staff Augmentation Services!

Senior Data Analyst / Business Analyst Resume

Mclean, VirginiA

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