We provide IT Staff Augmentation Services!

Reporting Analyst Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Poised to contribute unique blend of system analysis, project - management, and exemplary technical skills, along with commitment to excellence, to your firm’s value by ensuring that projects support strategic mission and objectives within scope, budget, and schedule.
  • Optimization of real-time and manual batch processing for database and query tuning.
  • Mapped top-down data source requirements for data migrations in multi-tiered environments.
  • Verified executables in SSIS packages for clients using T-SQL, Custom code, and Batches.
  • Extracted structured and unstructured raw data from data sources during the ETL process.
  • Created UI to extract updated information using SQL Style to output as graph formatting.
  • Proficient in database design and programming in Microsoft, Oracle, and IBM RDBMS.
  • Tracked and controlled precedence relationships between activities, time, and resources.
  • Leveraged T-SQL and DDL, DML, and DCL for indexes, views, joins, functions, and SPOCS.
  • Leveraged dynamic dashboards for reporting test execution rates and defect statuses.
  • Performed system assessments in clinical and ancillary systems for integration clinical data.
  • Monitored data warehouse projects using data, technical and application tracks.
  • Mapped ETL requirements to identify business entities for creation of business keys.
  • Exacted and transformed source data using snapshots, triggers and timestamps using CDC.
  • Designed code for Web Services using functionality, interfaces, and contracts in applications.

TECHNICAL SKILLS:

Business Intelligence: TPS,OLAP, EDW, Oper marts, Data Marts,BPM(Dashboards, Balanced Scorecards), Canopy, Bulk Loaders, Source Backup/, BiReady,Pentaho(ETL)MOLAP

Software Design and Programming: Software Design Principles - Architecture and Detail Design, Interface Design, MS Azure(IAAS,PAAS,SAAS)AWS,C++,C#,JAVA,VB6,Stack,VSCode,Eclipse,Netbeans,OOAD,OOP,SFML,Adobe Air,SWF

Software Testing: Test Planning and Organizing, Unit Testing,SIT, Functional,UAT.

Advanced Algorithms/Statistics: BFS,DFS,Sorting,Game Strategies, Optimality,Bayesian,Probability

Database Security: Access controls - Encryption, Error checking, System and Object privileges, Backup and Recovery, Transaction Support Concurrency Control Services and Recovery Services

Scripting and Messaging: Javascripts, JSON, VBScripts,Coldfusion,PHPLinux VI editor, bash, korn

Databases: Microsoft SQL Server, Oracle 9i-11g,MySQL, Sybase, DML,DCL,DDL

Project Management: BPM for Program/Functional Units. CMMI-ACQ, Project Predecessors/ Dependencies Gantt Chart (Schedule/Activities/Milestones Pert(O,P,ML), CPM(Critical Eliciting, GAP Analysis, Forward/Backward Tracing

INDUSTRY EXPERIENCE:

Reporting Analyst

Confidential

Responsibilities:

  • Used UML tools for requirements development and management and design and analysis phases.
  • Performed multiple work-session to elicit requirements at Facets Application and User level for over 100 business units during a SMT build.
  • Created dynamic using tables/attributes/data using Facets 5.1 data schema for 70 applications.
  • Created jobs for backing out Facets Confidential claims for loaded processes during Unit testing in 2013.
  • Able to identify Batch Action codes during electronic adjudication of 837I,837P, and 837D claims
  • Worked closely with end-users for design and development of Confidential 5.1 ICES provider reports.
  • Set-up excluded services such as member responsibility, category, subcategory, and group using defined code-sets in Confidential Benefits Plan.
  • Experienced in configuring Bill Types with frequency, POS by FAC or PRO, and Finance codes
  • Set-up Medicare Advantage benefits using Confidential scoring logic for selection of Coinsurance/Copays, Prior Authorization and non-participating providers.
  • Used EOC’s, Benefit Grids, Benefits Matrices, Modals, and EncoderPro for Confidential benefit builds.

Technical Analyst

Confidential, Denver, CO

Responsibilities:

  • Confidential Certified in TAP110/112(Dec 2014) for configuring Carriers, Benefit Groups, Employer Groups, Networks, and Providers using Confidential Tapestry Core.
  • Created and configured provider contracts and pricing mechanisms in Confidential to match service related or claim level events.
  • Set up Access Control and permissions for application and component levels for EPIC. Users.
  • Gathered high-level requirements for configuring provider’s information in Confidential Tap110 and Tap112.

Data Analyst

Confidential

Responsibilities:

  • Conducted work-sessions with Stakeholders to elicit requirement high level Test Scenarios.
  • Validated HL7 ADT Workflow along with Meditech applications, interfaces, and Reporting.
  • Validated (Scheduling, Admit/Discharge, Orders, PHA, and LAB) messages during ICD10 testing of Meditech 5.66 and 6.0.
  • Mapped integration components on the technology, application, and data tracks for a Meditech 6.0 build with Confidential and Confidential .

Reporting Analyst

Confidential

Responsibilities:

  • Used MS Access and Rapid SQL to validate SEPY, groups, and products updates in Facets.
  • Unit tested changes to products along with service ids/rules before code is migrated to Facets.
  • Generated multi parameterized reports in MS SSRS 2008 to allow end users to generate dynamic Confidential 4.81 claims aging reports.
  • Rendered dynamic Reports in SSRS 2008 using raw SQL, BIDS, Report Builder, and Report Manager to create final .RDL file and C#
  • Facilitated Test planning phase with the creation of the System Test Plan and 400 test scripts.
  • Conducted multiple work-sessions to elicited requirements from over 25 business units.
  • Performed product build and functional testing of Carrier/Providers, Benefit Plans, and Providers/Claims modules in Confidential 4.8.1 - 5.01.

Project Test Coordinator

Confidential, Hartford, CT

Responsibilities:

  • Tracked defects and created queries to extract daily test case execution results in HP ALM.
  • Validated Baseline Test Strategy for testing inbound/outbound messages to Facets 4.7, Macess, and ClaimCheck.
  • Organized and conducted data summits and Business requirements for validating 25 applications for ICD10 and 5010 conversion
  • Sourcing using synthesis and analysis for negotiating SLA’s with Confidential cross-functional teams.
  • Facilitated Test planning phase with the creation of the System Test Plan and 400 test scripts.

Test Lead/BizTalk Support

Confidential, Fort Worth, TX

Responsibilities:

  • Validated scorecard from decision engine along with transported messages for business rules, mapping and formatting in Biztalk Server 2008.
  • Manually calculated Confidential and Lease approvals scores from downstream applications using BizTalk Server 2008,C#, and Presta Billing module.
  • Coordinated with offshore teams for defect tracking and time estimation for completion tasks.
  • Created C# interfaces along with Maintenance on minor .NET bug fixes for Presta BTS support.

Project Lead

Confidential, Detroit, MI

Responsibilities:

  • Acquired and trained resources for test planning during Pre-live ICD10 Remediation SIT testing.
  • Augmented testing approach along with managing Test schedule and executing test cases for Facets 4.7 ClaimChek.
  • Sourcing using synthesis and analysis for negotiating SLA’s with Confidential cross-functional teams.
  • Managed Confidential ’s and test efforts for over 550 test cases in interfacing with Facets 4.5 for testing
  • Validated Confidential source file pushed from an Confidential translator to flat-file dumped to Excel CSV file.

Confidential Analyst

Confidential, Dallas, TX

Responsibilities:

  • Identified each failed Segment Id/elements against HIPAA rules using text editors and HIPAA Compliance tools
  • Created Test plans to capture Open Enrollment and Ongoing Scenarios for 834 and non 834 (ansi flat-file)
  • Created SQL statements to extract data for end-to-end test scenarios in the QA and Prod DBMS environments.

Automation Test Lead

Confidential, Irving, TX

Responsibilities:

  • Lead procurement activities for evaluation and selection of Confidential automation testing tools.
  • Automated Web-based, Mainframe, and Window application using Keyword, Object Spy, Data table parameters, Expert View,
  • Created Splitting Actions in test scripts while running single test scripts or suite only in QTP 10.
  • Created VBscript functions in QTP 10 to capture Flex 3 objects in QTP 10 during regression testing for a Tmobile portal.
  • Used descriptive programming to mirror objects in web-based applications with QTP/VB Scripts.

Senior QA Analyst

Confidential, Mason, OH

Responsibilities:

  • Created Test plans Test cases for testing transporting of inbound and outbound HL7 messaging to Care360.
  • Performed Test Case Review and performed demonstrations to stakeholders before build releases.
  • Created SQL statements to extract data for end-to-end test scenarios in the QA and Prod DBMS environments.
  • Validated source file pushed from an Confidential translator to flat-file dumped to Excel CSV file.

ETL QA Analyst/Automation Developer

Confidential, Coppell, TX

Responsibilities:

  • Performed product testing ( Confidential Submission) and Client reporting on findings and resolving any discrepancies.
  • Validated flat-file row count against the expected records in trailer from file push from Axway during ETL testing at Confidential in 2008.
  • Validated data sources data migrated format and mapping to staging during ETL process.
  • Performed ETL testing and analysis of transformation, merging of Java code, and source data to staging during a Pharmacy BI project in 2008.
  • Used T-SQL for creating indexes and views, renormalization and aggregation, and backing up and archiving data during ETL processes
  • Lead procurement activities for evaluation and selection of company-wide Confidential testing tools.

Project Manager

Confidential, Dallas, TX

Responsibilities:

  • Functional and Regression testing of functional areas and HL7 messages in Confidential and EMR/Laboratory Portal.
  • Lead functional unit work-sessions as a solid communicator with exceptional team-building skills.
  • Used Gantt, Pert, and CPM charts for monitoring predecessors, dependencies, and critical areas.
  • Executed Project Evaluations to validate Inputs match outputs using multiple feasibility analysis

We'd love your feedback!