James Barnett

Proficient in developing and managing ETL workflows using SQL Server Integration Services (SSIS).

Hands-on experience designing, deploying, and maintaining SSIS packages for data integration and transformation

Hands-on experience with deploying, managing and implementing workflows using Azure Pipelines to automate build, test, and deployment processes.

Developed interactive dashboards and analytical reports using Power BI.

Designed and implemented data visualizations and reporting solutions in Power BI.

Built dynamic Power BI reports to support data-driven decision-making.

Developed interactive dashboards and analytical reports using Power BI.

Designed and implemented data visualizations and reporting solutions in Power BI.

Built dynamic Power BI reports to support data-driven decision-making.

Hands-on experience designing, deploying, and maintaining SSIS packages for data integration and transformation.

Hands-on experience creating and managing SSRS reports to support business intelligence initiatives

Utilized SSRS to deliver timely and accurate reporting solutions that enhanced operational visibility

• Managed company’s State Pharmaceutical Assistance Program (SPAP). Responsible for downloading, processing, archiving and tracking state payment files. Also in charge of process documentation and workflow.
• Served as point of contact for 11 states and monitored the enrollment of 24,000 SPAP members.
• Monitored and maintained various databases and reports for SPAP.
• Served as lead role for all CI Group Fix SPAP submissions (Winbatch).
• -17,000+ members processed through winbatch in 2015.
• -15,000+ members processed through winbatch in 2014.
• Led transition of SPAP to Billing department.
• Served as lead role for CI Group Fix Mass Move 2015 project.
• -50,000+ members mass moved through this process.
• Served as lead role for CI Group Fix Mass Move MRCM 2015 project.
• -500,000+ members mass moved through this process.
• Scheduled and facilitated meetings to discuss process issues and improvements.
• Trained associates on current processes and procedures. Responsible for research, testing, and inventory.
• Assigned work and developed quality assurance system.

• Managed bi-weekly Case Submission file for transmission to CMS. Responsible for monitoring the eRPT system, downloading response files, uploading received response files into the internal workflow database, archiving receipts for tracking and trending, identifying and creating a report of members with rejected cases, validating results, identifying associate errors and process changes, partnering with internal customers for resolution and providing management with a monthly report.
• Managed and maintained numerous reports for Medicare CPU department. Responsible for research, testing, inventory, and product quality assurance.
• Scheduled and facilitated meetings with leaders to discuss process issues and improvements.
• Research and review escalated issues for management.
• Assigned work and assisted other reps with case issues.
• Trained and led fellow work content specialist on current processes and procedures.
• Monitored and maintained various Excel spreadsheets for Medicare CPU department.

• Mastered all Medicare CPU work types such as Submit Acceptance, Submit Rejections, Category 2&3 cases, AMPERS cases, Exception cases, etc.…
• Worked on numerous special reports such as LIS Audit work, Streamline projects, Eligibility/Termination project, Submit Rejection 505 project, Disposition reports, AMPERS/Cat. 3 project,4RX reports, PRXM projects, etc.…
• Served as an expert resource (SME) to team members and other departments when bailing out for any Medicare CPU work type such as Submit Rejections, Submit Acceptance, AMPERS/Exception case build, Cat. 2 &3 case build, MET tab, etc…
• Always assisting Work Content Specialist with various case build projects such as AMPERS/Exception case build, Cat. 2 &3 case build, etc…
• QAed cases with a 98% acceptance rating. Also assist with QAing Submit Acceptance letters.
• Always met or exceeded production and quality goals.

• Wrote Process Updates and Process Reminders
• Presented Process Updates and Reminders to Team Lead huddles/Process meetings
• Alerted Process Updates via the EMS mailbox to Leaders and Associates
• Added Process Updates and Reminders to SharePoint
• Created Zoomerang questions related to Process Updates and Reminders
• Added and closed issues in EMS database
• Contacted CMS Help Desk to report and resolve issues
• Created and logged a Med Ops referral in the System Ticket log site
• Scheduled and attended Weekly and Bi Weekly Process meetings

• Able to efficiently and accurately load Humana Medicare plans from scratch. Also experienced with Partial and Model Loads.
• Able to navigate comfortably through the Planload Loading/Reference Guides, Planload Atypical Doc, Planload NPD, Planload Supplement Doc etc.…
• I had moderate to full contribution with 10 loads from scratch plans completed.
• I had exceptional contribution with QA audits for Planload at 98%
• I had full contribution with Claims Testing audits for Planload at 98%.

• Work CPU Bail-Out 8 to 9 months out of the year.
• Experienced in Streamline process, 127/169 and 15 Replies, Prepping folders, Cases, Correspondence, etc……
• Worked on special projects such as PDE, Reply 933, and Med Recon.
• Always willing to work overtime and go the extra mile for our members.
• Always met or exceeded production and quality goals.

• Always met or exceeded production and quality goals.
• Able to navigate efficiently through systems.
• Always willing to help others when asked.
• Utilized A-Train or Chapter 2 during downtime.