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.