Mike Litwin Email & Phone Number

Algonquin, Il, Us

Algonquin, Il, Us

Minneapolis, Mn, Us

Founded on the principles of trust, experience, and innovation, Trexin Consulting specializes in strategy execution – the implementation of business strategy to achieve targeted business goals. Applied strategy situations that Trexin frequently leads include: digital transformations for business, scaling capabilities for growth, optimizing operations for cost reduction, driving synergies for M&A, and recovering projects in distress. Trexin’s services are right-sized for our Clients’ needs, ranging from our “Diamond Team” service when our Clients want Trexin to own an outcome and share delivery risk, to Expert/Advisory services for senior-level guidance, to Strategic Staffing services for execution-oriented tasks and roles.

Newark, Nj, Us

Management:Managing team of 2 direct reportsData Scientist & Machine Learning Engineer:ProjectsSpark Cluster Optimization (Databricks) Identified, Tested and Modeled optimal cluster configurations. Determined Clusters size – Servers, Workers, Nodes Needed based on data size. Created cluster instance profiles for use.Data Pipelines Ingestion, Cleanse, Curate, Consolidated, Transfer of Data Data for Consumers Epsilon / Experian data feeds / up to 230 million records / CRM apps Data for Claims – Healthcare (PHI / HIPPA) 5 Vendor data feeds covering entire US /23 billion records / PRM applications Stack Development – Coordinated with engineers to set up pipeline environment Environment setup, S3, APIs, Direct HTTP Client, Multiple Server Access/Data Movement Database management: mining, architecture, mapping, ETL, QA/Dev, Git Data Quality Assurance Cleanse, Test, Automate data points from multiple disparate systems, and file types: .json, .csv, .parquetPHI Compliance – Mirador (3rd Party verifier) De-identify data considered to be personal to the consumer or could potentially identify the consumer. (HIPPA Compliant) Initial cleanse step for claims data. Modeling Healthcare Service Line Propensity for consumers Converted legacy modeling techniques for use in current data environments, such as Databricks. Removed the need for CLI commands. Developing pipeline to create models as product offering. Identify, create modeling services using API, multiple models where customers can provide data and received a modeled data set. Modeling Projects Consumer Response Index Determine the likelihood a consumer will need a specific healthcare service in the future. Consumer response tendencies Determine the likelihood a consumer will respond to a communication. Deterministic and Probabilistic algorithms. Lead/Record pairing/matching.

Newark, Nj, Us

Manager Campaign Analytics/Quality AssuranceAnalytics - Campaign Analysiso A/B Creative comparisons; Target/Holdout comparisonso Annual CRM mailings, following AMA monthly healthcare focus.o WEB-MD Physician Referral/Usageo Analysis: St. Dev. Profit of CRM Mailings for consumers Consumer Healthcare Propensity Co-Morbidity/Chronic ConditionsQuality Assuranceo Database audits – Facts, Dimensions, Lookup/Decode o Monthly Automated Quality Assurance Procedures, Tables, Variables, Transforms, Standarizationso Daily maintenance monitoring post client update.Marketing Research AnalystCRM Healthcare Data extraction using SQL 2003/2005/2008o Daily SQL coding used to extract mailing list data based on specified demographic criteriao Standard demographics, age, gender, income, hospital encounters, propensities, and any unique criteria needs.o Managed 20-25 clientso 15-20 CRM mailing projects completed daily.o Monthly/Quarterly/Annual CRM mailings o Single point of contact, responsible for 95-98% of all offline CRM mailings.o Standardization of data; first/last/prefix/addresses, etc..o Ad hoc research regarding CRM mailing lists issues/questions.o Matching, comparison, import, export of non-standardized mailing list data, for use in CRM mailings.

El Segundo, Ca, Us

Senior Business Analyst (Business Analytics) Service Call Reduction analysis.o Weekly reports measuring service calls metrics o SAS coding used to collect, assemble data, report data through exports to Excel, or PDF. Time in Motion studyo Analyzed timeframes for DirecTV installation.o Collaborated with scheduling department to identify deficiencies of scheduling times and areas of possible improvement. Resulted in more efficient scheduling of technicians daily work and reduced schedules.

Data Analyst (Utilization Management) Medicaid and Medicare State of CO Reports o Quarterly, automated reporting, reduced report time by 90%. Supervised implementation of SQL servero Created SQL database to track Medicare/Medicaid payments.o Organized meetings with IT personnel to ensure implementation of server completed in a timely manner. Created Provider directory using MS Access platform.o Used to identify therapists, increased ability to locate best match therapist for each client’s needs.

Data Analyst Organizational Culture, Effectiveness, Leadership Impact/Strategy survey project coordination.o Identified reporting requirements o Maintained schedule of survey completion. Survey results reporting.o Survey collection and reporting, using SPSS, Excel and Word.o Coded special supplemental survey questions into reporting. Tracking Databaseso Created automated tracking databases in Excel.o Streamlined setup process of survey collection websites.

Us

Financial Analyst 9/97 – 9/02 Weekly and Monthly Financial Database.o Created, developed, and maintained financial reporting o Comparison reporting of current project revenue to forecasted revenue. Quality assurance expense audits.o Individual sales personnel expenses.o Identified unacceptable expense practices. Developed database linking Revenue, Payroll, and Expenses for projects. o Aided in reconciling expenses and payroll compared to Revenue.Project Coordinator 4/97 – 9/97 Managed Technology Deployment projects o Nationwide basiso Consisting of 30-50 regions across local U.S. Coordination of regions and client schedule to maintain project schedule. Compiled Invoicing details for Project billing in Excel.

Developed and analyzed sets of test data for on site projectsDesigned robotic tester for phone keyboardResearched information for Analog to Digital ConvertersParticipated in team project for the design of amplifiers

Bachelor Of Arts, Mathematics

Ba, Mathematics, Physics