Anand Mohan Email & Phone Number

Maryland Heights, Mo, Us

Saint Louis, Mo, Us

Lead a team of Site and Data Reliability Engineers to automate and maintain Enterprise Data and Analytics (EDA) cloud infrastructure and data pipelines.Capabilities developed by team include ● Data anomaly detection processes using statistics and ML, enhancing data completeness and reliability. ● Enterprise-wide self-service DDL deployment capability using CI/CD automation, saving DBA time spent on DDL deployments and reducing failed deployments. ● ServiceNow to Jira integration plugin, improving communication and collaboration between development teams (20) and business analytics users. ● Code Comparison tool between Informatica Power Center (on-prem) to Informatica On Cloud (IDMC), reducing code discrepancy by nearly 90% ● Automation for resolving vulnerability detection in cloud and on-premise EDA assets, enhancing security and compliance

Saint Louis, Mo, Us

Maintain 2 portfolios for the organization - ● Lead a team responsible for delivery of ~ 300 Compliance Reports to 30 Medicaid Centene Health Plans. Automation of the reports lead to savings of $1MM per month in penalties that may incur if delivered late or inaccurate ● Lead a team responsible for automation of various claim audits from various vendors and send the refined results for Claims Adjustments. This automation increased the recoupment of claims $18MM annually. The entire development of this tool was completed on a Cloud based Palantir PlatformResponsible for the following ● Work with stakeholders to report progress, negotiate deadlines as necessary ● Provide technical guidance and insight to upper management and procure buy-in ● Introduce agile technical aspects - Peer reviews, code reusability, version control for report delivery, test validation ● Conduct interviews, hire, and train new team members ● Contribute to product design and establishment of requirementsCreated Several Python Modules ● Provide Column level data lineage from free form SQL reports ● Data Quality and Auditing tool ● Zero Code - Config based custom ETL tool that can perform Data Extracts and Data Loads with features that can auto detect field names for loading into EDW ● Config based tool to Copy Data into Excel Templates (With pre-existing formulas and locked cells) - This increases throughput of end users 15 minutes per tab to copy paste data ● Servicenow to JIRA integration - Create and Update Tickets that originate in Servicenow to be automatically created in JIRA when a ticket requires development or a bug-fix Conduct Python Sessions - Introduce best practices ● Hierarchical Configuration files ● API calls to post and get data ● Config Based ETL Tool

Saint Louis, Mo, Us

Responsible for Data integration between systems, Process improvement in ETL design and development● Provide Subject Matter Expertise on Technology and Process and have a proven track record of good leadership and mentoring of team members● Taken lead roles in recognizing and fixing processes that caused or causing data quality issues● Helped with the rollout of Member migration from Healthnet to Amisys and put processes in place to mitigate the possibility of double counting membership ● Work on EDW 2.0 to implement Best Practices in sourcing and landing data in Hadoop

Fenton, Mo, Us

Responsible for Data integration between systems, Process improvement for Application DBAs, ETL design, development and Performance Tuning Queries in DB2 LUW/zOS and PostgresMajor contributor to Cost Reduction: ● Lead and Implement the Migration of the Quoting Application data on the mainframe to Postgres and Operation Reporting data mart to DB2 LUW● Introduced and Lead improvements to Informatica ETL Development, Release Management and Data Management by creating templates, automation and streamlining processes● Lead the DBA Team in creating the data model design for a Transportation Management System ● Develop and create automation in the ETL process to load data from a new in-house built logistics system (WMS, OMS, CRM), automation for on-call support from Cognos (BI System)● Built a Metadata Repository for BI Reports to track data definition and lineage● Performance tune report response times by identifying bottlenecks in the database

Chesterfield, Mo, Us

Played multiple roles in the IT organization as an Application developer, Report developer using Siebel Analytics/SSRS and ETL developer using Informatica, SSIS and eventually a Database Administrator● Created data models, automation of file management and ETL processes for data received from vendors leading to reduced load times (over 90%) and accelerating the data for Dashboard Consumption ● Identified Opportunities to house data in DW and build Reports and Dashboards helping in integrating data for different units of the organization and resulted in ★ An Executive Dashboard showing Account Receivables/Account Payables and Expense reports★ Reports/Dashboards for District Managers and Sales Reps to track their Goal Achievements, Performance by measuring Call activities of the sales reps, samples dropped vs. growth in Market Share. Identify hotspots using prescription trends and Top Prescribers.★ A Planning and Tracking Dashboard showing Days of Supply of Bulk and Finished Goods Inventory, Monthly Calendar View of Products scheduled at Work Centers, Raw Material Availability.

San Diego, California, Us

Worked with the COE team and was responsible for providing support during pre-sales and implementation phases of a project (List of Clients included, 3M, TIAA CREF, Lexis Nexis)● Managed the technical aspects of customer relationship, specifically with systems integration, and architecture design● Translate high-level business requirements into logical business dimensional model

St. Louis, Mo, Us

Worked as a Siebel Analytics and Informatica Server Administrator, Siebel CRM Application Developer, Siebel Analytics Report Developer and Data Modeler● Received Letter of Merit, from Client’s VP – IT, for work rendered in upgrading Siebel, Siebel Analytics to 7.7, Oracle from 9i to 10g, Informatica to 6.2 and migrate CRM Data mart from DB2 to Teradata ● Designed and Developed 5 Dashboards and over 45 reports (Call Analytics/Opportunities) using Siebel Analytics ● Achieved 50% improvement in Client’s Data load process by fine tuning Informatica Sessions and Mappings ● Conducted various training sessions to help Business Users create Ad-hoc reports using Siebel Answers

Princeton, New Jersey, Us

B E, Electronics And Communication Engg

Ms, Electrical Engg

Hsc