We provide IT Staff Augmentation Services!

Data Analyst Resume

4.00/5 (Submit Your Rating)

Phoenix, AZ

SUMMARY:

  • Expert in writing SQL with multiple joins and sub query to perform data analysis and adhoc reporting. Understand the relationship between database tables, keys and data types.
  • Strong knowledge of the Software Development Lifecycle (SDLC) as well as software development methodologies like Agile and waterfall.
  • Proven ability to quickly grasp new concepts related to functional and business processes and utilize as needed. Strong interpersonal, analytical, critical thinking and communication skills. Self - motivated and ability to master new technologies.
  • Creative thinker and proactive problem solver who can independently develop strategy and possess the ability to work effectively under a rapidly changing environment in order to meet deadlines.
  • Proactively anticipate, identify and resolve problems. Assertive visionary, multi-tasking and assimilating complex processes.
  • Expert in writing test cases both for manual and automated testing of Client/Server and Web applications. Experience in writing business requirement documents.
  • Possess diverse experience in requirements analysis and systems analysis. Extensive knowledge in writing and executing test scripts for user acceptance testing. Experience in functionality, Black Box, Integration and Regression Testing.
  • Strong analysis and review skills for analyzing bugs, and interacting with team members fixing the errors as per specifications and requirements.
  • Thorough knowledge of Medicare and Medicaid regulations and understanding of HIPPA transactions.
  • Thorough understanding of Accounting and finance including Financial Accounting, Managerial Accounting, Accounting Theory and Research, Federal Taxation, Multinational Taxation, International Accounting, Corporate Finance & Accounting, Finance for Managers. International Business, Resource Management, Ethical Leadership and Corporate Society, Strategic concepts in Marketing, Global Communications and Graduate Research Methods

TECHNICAL SKILLS

Data Analysis and Software Testing: Oracle SQL, QuickBooks, SoapUI, Excel (Formulas, Functions, Conditional Formatting, Pivot tables, H Look Ups, V Look Ups, Index-Match, Macros and What if analysis), Outlook, Microsoft Dynamics CRM application. Black Box, Integration and Regression Testing.

Accounting and Finance: Financial Accounting, Managerial Accounting, Accounting Theory and Research, Federal Taxation, Multinational Taxation, International Accounting, Corporate Finance & Accounting, Finance for Managers. International Business, Resource Management, Ethical Leadership and Corporate Society, Strategic concepts in Marketing, Global Communications and Graduate Research Methods

Tools, OS & Utilities: Toad, SQL Developer, SoapUI, Jira, MS Office, WinSCP, Putty, Windows, Linux/Unix

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Data Analyst

Responsibilities:

  • Worked on 1095A project to reconcile the data discrepancies which develop during the enrollment transactions in health insurance exchange.
  • Performed user acceptance testing (UAT) for Microsoft Dynamics CRM Application by validating the customer data through GUI.
  • Validated customer data after importing from flat files format to MS Excel. Performed data analysis in Excel utilizing Pivot Tables, Power Pivot, conditional formatting, V Lookups, Macros and other advanced Excel functions.
  • Imports, exports and transforms of data utilizing a variety of flat-file, XML or structured data formats. Correlate data from multiple sources to get a clear picture on the customer demographic information, dependents, insurance coverage, Total premium amount, Advance Premium Tax Credits and then change the invalid data according to the policies and procedures of Center of Medicine and Medicare (CMS).
  • Conduct daily, weekly, and monthly quality assurance audits of Casework Analysts as assigned by leadership. Prioritize workloads to ensure timeliness and quality standards are met. Monitor and report workloads on a daily, weekly, and monthly basis.
  • Conduct necessary research and coordination as necessary for all quality assurance audit activities. Analyze casework based in current policies, directives, and investigation through available resources and further research. Provide feedback and guidance to Analysts concerning quality assurance audit results.
  • Identify and analyze quality assurance trends and refer any realized issues to the Leadership team or Training Department for follow-through as needed.
  • Suggest process improvements based on quality assurance audit findings. Support and accept responsibility for special projects and assignments.
Confidential

Software Analyst

Responsibilities:

  • Analyzed the top-level requirements of software functions for each Business Process. Conducted walkthroughs and meetings with project team, business user/application owners to understand the application. Tested Web applications developed in .Net and D2K (Oracle Forms/reports) for data integrity and functionality.
  • Write SQL queries using SQL developer and TOAD for understanding of data used for application testing and validation. Write SQL with multiple table joins and sub queries to perform data analysis.
  • Performed software requirements traceability analysis to trace software requirements to (and from) system requirements and to risk analysis results.
  • Develops test strategies and test cases to satisfy test requirements and documenting the same to ensure application functionality meets original requirements to project.
  • Wrote test plans and test cases that identify the schedules, environments, resources (personnel, tools, etc.), methodologies, cases such as inputs, procedures, outputs and expected results.

We'd love your feedback!