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