Reporting Analyst Resume
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