Sr. Data Analyst Resume
3.00/5 (Submit Your Rating)
Washington, DC
SUMMARY:
- Sr. Data Analyst with experience across diverse environments. Skilled at working in fast - paced environments demanding strong organizational, leadership, and multitasking skills required to meet strict deliverable deadlines. Effective interpersonal skills and committed to providing superior customer service.
- Analyzed data for numerous United States Postal Service (USPS) PostalOne recurring and ad hoc reporting requests based on complex SQL queries in an Oracle 12c database environment. Supported the monthly production of over 10,000 reports for Aetna’s Disease Management program.
- Front end data Oracle 11g database analysis minimized production reruns and proved that Aetna’s Disease Management program financially saved plan sponsors money. Effective teamwork resulted in over $ 50,000 savings for ActiveHealth Management while volunteering to take on additional projects during staff shortages, “successful” performance evaluations, and the recipient of the Q4 2009 Sapphire Award for service excellence.
- The implementation of the more efficient Excel based Infoscheduler tool reduced the amount of time required to setup and schedule Crystal report instances for Aetna’s Disease Management program from about two hours to one hour per batch . Additionally, the development of complex Excel macros greatly improved production processes and eliminated extraneous QA work.
TECHNICAL SKILLS:
- Structured Query Language (SQL)
- Aqua Data Studio
- SQL Developer
- Informatica
- Crystal Reports
- Apache Subversion (SVN)
- Jira
- Confluence
- Remedy
- ServiceNow
- Oracle Business Intelligence Enterprise Edition (OBIEE)
- Adobe Acrobat Pro DC
- Microsoft Word/Excel/Access/Visio/PowerPoint/Outlook
PROFESSIONAL EXPERIENCE:
Confidential, Washington, DC
Sr. Data Analyst
Responsibilities:
- Combine large data sets into visually appealing reports, charts, and graphs.
- Create reports with Tableau, Access, Excel, and Oracle Business Intelligence Enterprise Edition (OBIEE) using complex equations.
- Evaluate existing metrics and develop new performance metrics in order to monitor performance across the enterprise.
- Construct complex database queries across multiple databases in order to develop effective analytical solutions.
Confidential, Alexandria, VA
Business Analyst
Responsibilities:
- Created standards forconfidential AWS cloud architecture.
- Tested data between confidential legacy source systems and AWS cloud architecture.
- Analyzed confidential data using Structured Query Language (SQL).
Confidential, Arlington, VA
Data Analyst
Responsibilities:
- Analyzed confidential data to support the data migration from IDENT to HART.
- Routinely implemented data quality rules as part of the data quality assessment (DQA) process.
- Documented and presented data quality assessment (DQA) findings and recommendations to internal and external data stakeholders.
Confidential, Fairfax, VA
Data Analyst
Responsibilities:
- Regularly analyzed confidential PostalOne data.
- Automated recurring confidential PostalOne reporting requests with the interactive shell Fluidshell.
- Solved critical ad hoc confidential PostalOne business questions with complex SQL queries.