Caleb A. Cranke
Bowie
Summary
Data & Systems Analyst with significant experience at Strata Decision Technology, specializing in data integration and project management. Demonstrated success in improving data quality and security while managing cross-functional teams. Expertise in T-SQL and focused on delivering strategic solutions that enhance client success and operational efficiency.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Data & Systems Analyst
Syntellis/Strata Decisions
Chicago
01.2022 - Current
- Assists clients with specialized and complex data integration efforts related to the implementation of software products.
- Work as part of the Professional Services group working with multiple clients daily to facilitate their data planning as well as work as part of a project team to ensure that requirements and deadlines are met.
- Participate in client data discussions and lead client data meetings.
- Data Integration: Responsible for data planning, delivery of ETL utilities, and conducting training related to data integration from client source systems into Kaufman Hall software.
- Manage multiple projects, responsibilities and competing priorities as well as maintain comprehensive project documentation.
- Present data findings and working with other members of the Implementation team identifies and implements strategies that will address tactical and strategic client goals.
- Assist with internal and client reporting.
- Engages in quality control (data reconciliation) activities through the review of reports, data files, and client deliverables.
- Evaluate internal data sources and processes for integrity, working cross-functionally with other internal teams such as Implementation Consultants, Project Managers and Client Teams.
- HIPAA certified and compliant safeguarding client data such as implementing security measures or ensuring data is transferred through secured email, FTP sites, and kiteworks application. Also responsible for the management and security of users per clients request.
- Experience with implementation and integration of Multiple payroll platforms with clients such as Workda, UKG/Kronos, paychecks, ADP.
- Assist with implementation of clients with changing of source system conversion of Payroll/Hr systems.
Senior IT Operations Data Analyst
Consortium
Columbia
01.2015 - 01.2025
- Supported the profiling and development of new data sets HPN data, network compare, Consultant benchmark.
- Designed and modified T-SQL code as well as debugged stored procedures to process data.
- Interfaced with data/business analysts to deliver relevant data sets as well as notify stakeholders of process milestones on the various project’s updates.
- Participated in design, development of foundational products as well as new product initiatives.
- Designed, developed, and tested routines for data loads and uploads.
- Collaborated with business owners on data analysis and modeling projects.
- Interfaced with business community to gather requirement, research, and build ad-hoc reports.
- Enhanced and managed the receipt, QA, and processing of healthcare claims data through rules-based applications engaging the IT and Actuarial & Analytics teams as necessary.
- Coordinated with IT, vendors, and internal experts to develop and deploy a machine learning roadmap.
- Worked with business team to define data requirements and participate in ongoing planning, design, and evolution of data infrastructure.
- Complied with all information privacy and security policies as specified in the 'Consortium Health Plans Information Privacy & Security Policy Manual.'
- HIPAA certified and compliant with managing claims and membership data that from the Blue Cross Blue Shield Plans and ensuring that data is safeguarded.
IT Operations Specialist
Inovalon
Bowie
01.2014 - 01.2015
- Designed and/or developed specific databases for collection, tracking, and reporting of data.
- Designed, code, test and debug custom queries using Microsoft T-SQL and SQL Reporting Services.
- Designed, code, test and debug business logic for software applications using T-SQL per defined technical specifications.
- Developed quality code that meets project & departmental standards.
- Determined key performance indicator metrics.
- Produced forecasting models to support senior management in decision making.
- Collaborated with business owners on data analysis and modeling projects.
- Presented results of analysis, data models, and other projects to senior management, when requested, in a concise and professional manner.
- Responsible for generating Member Monthly Data Mapping (MMDM) profiles for clients monthly and customizing according to customers specifications.
- Analyzed Data to find root cause analysis when code in SQL breaks or errors in the reporting to clients.
- Supported mobile application Electronic Patient Assessment SOAP Note System (ePASS) for our partnered Providers and troubleshoot issues when application support, missing members, password reset, registering new providers as well linking existing providers to our clients.
- Responsible for creating and submitting Raps files for submission on behalf of our clients to center of Medicare & Medicaid services (CMS).
- Working on a special automation project to eliminate the manual task of generating financial reports for clients to make it a zero-touch process with QA validation checks to validate reports.
- Multitask between 4 different products such as MMDM, Prospective Advantage, SmartCare, ePASS as well as support each product.
- HIPAA certified and compliant with managing and handling datasets (Medicaid, medicare, HEDIS, HIX) from multiple carriers such as Aetna, BCBS, Cigna, United healthcare.
- Assisted with HR/Payroll integrations for clients.
Software Quality Assurance Analyst II
Inovalon
Bowie
01.2011 - 01.2014
- Attended design reviews, requirements sessions, core team meetings, and technical team meetings to update and speak about new changes to existing processes and new processes to come.
- Composed test scenarios, scripts, and related data using business and functional requirements.
- Conducted test scenarios and T-SQL script reviews with appropriate business lines.
- Executed detailed test cases; create, report and track defects, and communicate findings.
- Ensured the end-to-end operating model procedures are fully defined and tested.
- Performed other related duties when assigned task from multiple products.
- Worked independently and provided guidance to others.
- Ensured release defects are resolved and/or deferred prior to product implementation.
- Scoped project time and resource requirements and reviews with other developers.
- Trained and mentored other analysts in testing methodology and the software development life cycle.
- Executed and monitored testing results and communicates the results.
- Coordinate with UAT test group(s) to ensure all issues are communicated and resolved.
- Recommends development changes.
- Evaluated and recommended QA standards and continual improvement activities; Makes recommendations for long-term improvements of quality assurance process, workflow, and QA department.
- Performed user and workflow testing, exhibiting ability through analytic skill and experience to anticipate the larger ramifications and interactions of a defect.
- HIPAA certified and compliant.
QA Analyst
Inovalon
Bowie
01.2010 - 01.2011
- Worked closely with development team and management to ensure quality of internal and external applications through testing.
- Responsible for the successful planning, development, and execution of all QA activities for a given project.
- Developed, published, and implements test plans and test cases.
- Developed quality assurance standards.
- Used software development lifecycle tools and methodologies through QA process.
- Ensured quality assurance practices, procedures, and audits.
- Participated in load testing, acceptance, and regression testing.
- Assisted in reviewing financial reports for clients using PCIS control applications, occasionally requiring being available outside of normal business hours.
- Set schedule estimates, timelines and milestones with different products, services, and processes.
- HIPAA Certified and compliant.
Review Coordinator
MedAssurant
Columbia
01.2010 - 12.2010
- Schedule on-site reviews for the Site Review Consultants or other field review staff in an organized and efficient manner following Med Assurant's documented procedure for scheduling, documenting the contact, and sending the required documentation to the scheduled facility.
- Process, track and monitor client requests across all aspects of Employer's offered services for onsite credentialing reviews, corrective action solutions, HEDIS chart abstractions, Medicare risk adjustment reviews and custom chart abstractions.
- Serve as the daily communication coordinator for any assigned Site Review Consultants (SRCs) or other field review staff.
- Assist in the management of communication and correspondence with care provider offices, additional field review staff field reviewers, clients, and other individuals and organizations necessary for employees to fulfill the responsibilities.
- Provide administrative support to management including, but not limited to, scheduling, and staffing meetings, organizing, and producing documents, maintaining filing systems, mailings, and other daily tasks incidental to operations.
- Maintain compliance with Med Assurant policies, procedures, and mission statement by Adhering to all confidentiality and HIPAA requirements as always outlined within Med Assurant’s Operating Policies and Procedures in all ways and with respect to any aspect of the data handled or services rendered in the scope of work.
Education
B.S. - Business Management
Bowie State University
Bowie, MD01.2006
Skills
- Critical thinking and problem solving
- Professionalism
- Optimization strategies
- Leadership and collaboration
- Time management and organization
- Data analytics and visualization
- Customer service and communication
- Attention to detail and accuracy
- Project management and execution
- Office 365 proficiency
- Sales Pro3000 expertise
- VBA programming skills
- Microsoft SQL Server and T-SQL
- PostgreSQL database proficiency
- Relational database management
- QlikView and Dundas reporting
- Microsoft Visual Studio development
- Python programming capabilities
- Data management strategies
- Machine learning applications
- Database administration skills
- Statistical analysis methods expertise
- Salesforce CRM knowledge
- Meditech systems understanding
- Cerner healthcare solutions expertise
- Data warehousing solutions proficiency
- Snowflake SQL skills
- Data integration
- ETL development
- T-SQL programming
- Data mapping
- HIPAA compliance
- Data analysis
- Client relationship management
- Cross-functional collaboration
- Problem solving
- Data security
- Power BI proficiency
- Business intelligence
- Data quality assurance
- Advanced Excel
- Big data processing
- API integration
- Report generation
- Python coding
- Information security
- Software testing
- Systems deployment
- End user support
- User requirements
- User acceptance testing
- Version control
- Database design
- Requirements gathering
- Software development life cycle
- Application support
- Contract management
- Multitasking Abilities
Certification
- CompTIA Security Plus, 2025
- Microsoft Server Administration, 2009
References
References furnished upon request.
Timeline
Data & Systems Analyst
Syntellis/Strata Decisions
01.2022 - Current
Senior IT Operations Data Analyst
Consortium
01.2015 - 01.2025
IT Operations Specialist
Inovalon
01.2014 - 01.2015
Software Quality Assurance Analyst II
Inovalon
01.2011 - 01.2014
QA Analyst
Inovalon
01.2010 - 01.2011
Review Coordinator
MedAssurant
01.2010 - 12.2010
B.S. - Business Management
Bowie State University