DAVID PARAJECKI

Milwaukee, Wisconsin 414-***-**** adlk43@r.postjobfree.com www.linkedin.com/in/davidparajecki

SUMMARY

A dedicated and perceptive data analyst, with a demonstrated track record of achievement in data analytics, implementations, data interchange and mapping, and project management. Utilizes strong interpersonal and communications skills to train and coach team members who collaborate to produce exceptional results. An analytical and creative top performer, who contributes to identifying opportunities to address client needs and successfully meets quotas either at or under budget for an organization.

● Statistical Modeling ● Workflow Processes ● Training and Development

CORE COMPETENCIES

Trained in use of SAP Crystal Reports XI to extract information from ERP database to post in any format from Excel spreadsheet to flat file for EDI transmission.

Strong knowledge of rules of Medicare and Medicaid (CMS)

Subject Matter Expert, Senior Member Enrollment Data Analyst.

Delivered results through data analytics and experience-driven insight.

Oracle SQL-proficient in using queries to develop solutions to business system with Navient proprietary information.

Worked within parameters of all major quality programs, such as Q1, QS 9000, ISO 2001, ISO 14001, Six Sigma, Lean, 5S, Kaizen, and Kanban.

Microsoft Windows OS: 3.1, 95, 98, ME, 2k, XP, 2k3, and server variants.

Adobe products, MS Office Suite and Outlook, Altiris Ticket, SQL 2016, and Salesforce.

Order entry on PeopleSoft and JD Edwards EnterpriseOne system.

GXS and Inovis TrustedLink for Windows, including working with Innovis and GXS to establish initial connection that set up new trading partners’ transaction sets.

Published HellermannTyton Distributor Price List (DPL) in Industry Data Exchange Association (IDEA) e-commerce data warehouse for electrical industry.

EXPERIENCE

NAVIENT CORPORATION, Milwaukee, Wisconsin

Business Systems Analyst, 2019-2021

Managed new eligibility (EE) implementations and changes to existing clients’ EE files through conference calls, e-mails, on-site visits, and ongoing customer communication, with EE implementations that included imports, exports, and any relative reports.

Oversaw high volume of projects and tasks with competing priorities.

Handled routine electronic data interchange and data-mapping tasks.

Performed business analysis of routine technical problems for escalation to appropriate technical teams and assisted other team members with system issues.

Developed workflow processes for users on system applications.

Supported department growth by aiding in training and coaching of new team members. Helped other departments understand enrollment rules, guidelines, and processes to proactively reduce problematic situations.

Created reports and edits for internal and external users.

Designed, developed, and executed simple and complex SQL queries to determine where problems existed within membership data, and performed ad hoc data analysis and reconciliation, using those SQL queries.

Maintained client requirements, using source to target maps and data dictionary, and processed documentation and team- defined standards by using tools such as Word and Excel.

Worked within ServiceNow and Azure DevOps to keep management and clients up-to-date on progress of specific projects and problems.

DENTAQUEST CORPORATION, Milwaukee, Wisconsin

Senior Member Enrollment Analyst, 2014-2019

Documented client-specific eligibility business rules and worked closely with developers on new EE implementations and changes to existing clients’ EE files.

Managed new eligibility EDI (EE) implementations and changes to existing clients’ EE files through conference calls, e-mails, on-site visits, and ongoing customer communication.

Worked on several large-scale clients with over 1 million members, as well as clients with 100,000 to 800,000 members, with focus on dental eligibility and enrollment via 834 EDI standards, with all implementations done on time and either at or under budget.

Maintained HIPAA 834 companion guides to aid customers’ submissions of EDI files.

Partnered with developers to diagnose, perform User-Acceptance Test (UAT), and approve code fixes into production. Created test files and test scenarios to ensure quality.

Oversaw high volume of projects and tasks with competing priorities.

Handled routine electronic data interchange and data-mapping tasks.

Performed business analysis of routine technical problems for escalation to appropriate technical teams and assisted other team members with system issues.

Developed workflow processes for users on system applications.

Supported department growth by aiding in training and coaching of new team members. Helped other departments understand enrollment rules, guidelines, and processes to proactively reduce problematic situations.

Created reports and edits for internal and external users.

Communicated to management ways to improve processes and productivity.

Designed, developed, and executed simple and complex SQL queries to determine where problems existed within membership data, and performed ad hoc data analysis and reconciliation, using those SQL queries.

Collaborated with developers and users to evaluate data, extract requests, and recommend viable short- and long-term solutions.

Sustained client requirements, using source to target maps and data dictionary, and processed documentation and team- defined standards by using tools such as Word and Excel.

Employed ServiceNow and Azure DevOps to keep management and clients up-to-date on progress of specific projects and problems.

DENTAQUEST CORPORATION, Milwaukee, Wisconsin

Member Enrollment Analyst, 2013-2014

Processed and analyzed client eligibility data.

Analyzed incoming EDI eligibility files to confirm file format requirements were met.

Conducted data analysis in system and worked with developers on data cleanup scripts.

Delivered membership data reports as required by company and by client.

Worked daily with various departments to ensure member data accuracy.

HELLERMANNTYTON CORPORATION, Milwaukee, Wisconsin

EDI Coordinator, 2005-2013

Processed daily Electronic Data Interchange (EDI) transactions, from receiving releases (830 and 862) to sending advance shipping notices (ASN 856) to processing purchase orders (850) and sending purchase order acknowledgements (855) and customer invoices (810).

Set up and maintained EDI database to pull data needed for completion and transmission of EDI transactions.

Created custom SAP Crystal Reports to extract information from ERP system needed for completion of EDI transactions.

Served as secondary contact for major automotive accounts, such as Chrysler, GM, and Mercedes.

Provided support, including entering orders and responding to emergencies as needed.

Milwaukee Wire Products, Milwaukee, Wisconsin

EDI Coordinator, 1983-2005

Processed daily Electronic Data Interchange (EDI) transactions, from receiving releases (830 and 862) to sending advance shipping notices (ASN 856) to processing purchase orders (850) and sending purchase order acknowledgements (855) and customer invoices (810).

Set up and maintained EDI database to pull data needed for completion and transmission of EDI transactions.

Created custom reports to extract information from ERP system needed for completion of EDI transactions.

Served as primary contact for major automotive accounts, such as Chrysler, GM, and Mercedes and Ford.

Provided support, including entering orders and responding to emergencies as needed.

CERTIFICATIONS

MS Certified in Writing Queries, Using Microsoft SQL Server 2008 Transact-SQL

MS Certified in Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

MS Certified in Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Contact this candidate