Jonathan Madison Email & Phone Number

Hartford, Connecticut, Us

• Implement automation and optimized existing SQL logic decreasing runtime of various reports by 37%• Built, maintained, scaled, and supported 15+ existing data pipelines using SSIS and Python and 10+ existing dashboards using industry standard tools (Tableau/PowerBI)• Mitigate risks associated with insufficient and inaccurate data with the development of data integrity reporting suite for error detection and correction• Collaborated with multiple Medicaid CFOs and Finance leaders to gather requirements for building reporting to monitoring high acuity risk members in cost saving initiatives

Hartford, Connecticut, Us

Chicago, Il, Us

• Data extraction/manipulation from internal and external systems handling HCSC Operations within the Government line of business that include Claims, Encounters, Membership, Provider Networks, Customer Service, and other metrics upon ad hoc request• Create specifications for reports and analysis based on business needs within the Government line of business• Present detailed data extractions and reports for government operations data to executive leadership and CMS• Provide quality assurance on data/reports delivered to CMS and executive leadership for Appeals/Grievances within the Medicare space• Develop reconciliation tools/reports utilized for quality assurance of Payment Integrity within the Government line of business • Create visualizations for executive leadership using visualization software that includes Tableau, Clarabridge CX Studios, Excel• Utilize statistical concepts to apply to informatics reporting.• Direct multiple small and large-scale projects for reporting data to both internal and external customers from internal systems• Produce datasets and reports for analysis using system reporting tools such as Microsoft Access, SQL Server Management Studios, and SQL Server Data Tools for data retrieval and manipulation• VBA utilization for the purposes of automating reporting solutions within Microsoft Office Suites including MS Access, MS Excel and Outlook.• Collaborate with the business solution leaders to understand business strategy and translate into product requirements.• Collaborate with divisional data teams to generate tools to be leveraged in building unified data modeling and data mapping

• Designed and implemented a $12,000 5 year IT portfolio consisting of local server hardware, cloud server, website and data warehouse• Design and develop organizational website with interactive front-end UI development tools that include Java Script and HTML editing• Develop and maintain a cloud based virtual server for data storage and relational database organization using tools such as Microsoft Azure• Developed automated reports with data collected from various data sources using data extraction tools that include SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)• Built the infrastructure and maintained scalable data architectures from complex data sets across multiple platforms to enable business agility

Basking Ridge, Nj, Us

Develop course of action to promote B2B relationsBusiness account activationsSoft hand off to Business ChannelCold calling95 percentile in district for GrowthWinner’s Circle Candidate for 2014Retain2Gain Recognizing You Award

• Designed and implemented wireless network system resulting in $2.5K in annual savings in wireless telecommunications• Analyzed collected health data to design a communication portfolio in compliance with HIPAA laws• Built the infrastructure and maintained scalable data architectures from complex data sets across multiple platforms to enable business agility

• Developed and delivered an integral database and other data-driven solutions to support business needs and drive self-service analytics• Built the infrastructure scalable data architecture from simple data sets for future use across multiple platforms• Develop and maintain small network server• Design and implement a robust interactive website for external information collection

Develop a course of action for efficient sales behaviorsCoach behaviors Triage managementDevelop and maintain productivity reportsShift Coordinator

Richfield, Minnesota, Us

Promote admirable customer serviceNon-Commission sales Develop retail-to-business relations with local small businesses.Leading consultant within location

Master’S Degree, Management Information Systems, General

Bachelor’S Degree, Information Technology Project Management

Associate’S Degree, Computer And Information Systems Security/Information Assurance