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.