Natarajan Mohan Email and Phone Number

• LEAD TECHNICAL IMPLEMENTATIONS FOR INTEGRATING FORECASTING SOLUTIONS DATA WITH CLIENT SYSTEMS. • EVALUATE EXTERNAL VENDORS OFFERING BUSINESS INTELLIGENCE SOLUTIONS THAT CAN BE INTEGRATED INTO TRINITY’S FORECASTING PRODUCT TO ENHANCE USER EXPERIENCE WITH VISUALIZATIONS. • VALIDATE THE CHOSEN VENDOR FOR TRINITY’S FORECASTING PRODUCT BUSINESS INTELLIGENCE SOLUTION INTEGRATION BY WORKING ON A JOINT EXECUTION PROGRAM WITH THE VENDOR TO BUILD A WORKING PROOF OF CONCEPT OF THE INTEGRATED SOLUTION.• LEAD THE IMPLEMENTATION OF INTEGRATING THIRD PARTY FULL STACK BUSINESS INTELLIGENCE SOLUTION TO TRINITY’S FORECASTING PRODUCT TO FACILITATE WEB BASED INAPP CUSTOMIZED DASHBOARDING AND VISUALIZATIONS. • EVALUATE THIRD PARTY SOFTWARE SOLUTIONS FOR USE ACROSS TRINITY’S TECHNOLOGY INITIATIVES AND/OR SUPPORT ADOPTION OF NEW THIRD PARTY SOFTWARE SOLUTIONS.• MENTOR AND PROVIDE KNOWLEDGE TRANSFER OF CURRENT PROJECT NEEDS AND BEST PRACTICES IN THE INDUSTRY TO DEVELOPERS. • PROVIDE TECHNICAL ASSISTANCE AND ADVICE TO OTHER TECHNICAL TEAMS ACROSS THE ORGANIZATION WHEREVER NECESSARY AND WHEN SKILL GAPS EXISTS THEREBY DRIVING TRINITY’S TECHNICAL TEAMS TOWARDS BEST PRACTICES AND CONSISTENCY.

• OWN THE CSHARP.NET CODE BASE AND PYTHON FLASK API FOR EXISTING FORECASTING TECHNOLOGY SOLUTIONS STACK. PERFORM CODE REVIEW AND MIGRATIONS AS NEEDED.• OWN THE SQL CODE BASE OF APPLICATION DATABASES HOSTED IN MICROSOFT AZURE DATA ENVIRONMENT WHILE BEING RESPONSIBLE FOR SOURCE CONTROLLING THE CODE BASE USING SOURCE CONTROL SYSTEMS LIKE GITHUB. • DEVELOP AND MAINTAIN COST CONTROL MECHANISMS USING TOOLS LIKE POWERSHELL AND AZURE RUNBOOK FOR APPLICATION COMPONENTS LIKE DATABASES, APP SERVICE PLANS, AZURE FUNCTIONS.• BUILD DATA VISUALIZATIONS AND DASHBOARDS USING TOOLS LIKE TABLEAU, POWER BI. AUTOMATE THE DEPLOYMENT OF THE DASHBOARDS TO SERVER USING TOOLS LIKE POWERSHELL AND WINDOWS BATCH SCRIPTS.• WORK CLOSELY WITH CLIENTS/STAKEHOLDERS TO BRAINSTORM AND GATHER DETAILED BUSINESS REQUIREMENTS, TRANSLATE THE REQUIREMENTS COLLECTED TO MEANINGFUL TECHNICAL SOLUTIONS TO HELP DRIVE THE BUSINESS.

- Develop ETL packages to migrate data from file location to Azure Database/ Datawarehouse. - Develop Automated tasks using sales force data loader in order to replicate sales force data on a nightly basis. - Develop Azure data processes to process raw pharma data, cleanse and build integrated layer, apply business rules and create reporting ready datamart layer. - Develop Tableau dasboards on the datamart layer to provide critical insights about drug market, sales and sales force sizing. - Develop automated tasks to release Tableau dashboards to the server that are accessed by the end users on weekly basis. - Develop custom web parts and components in sharepoint to develop and maintain interactive team page.- Perform Data Analysis and develop Ad hoc reports as and when required by business users/stakeholders. - Work closely with clients/stakeholders to brainstorm ideas and gather business requirements.

• Developing custom web parts and components for SharePoint 2013.• Integrating Access 2013 with SharePoint 2013.• Built Complex Stored Procedures to be used in SSIS Packages while migrating data from SharePoint to MS-SQL Server.• Develop, modify & maintain server inventory in SharePoint.• Implementation of SharePoint-based workflows as well as development of Business Intelligence dashboards.• Interact directly with biostatisticians, epidemiologists, applications and systems programmers, research coordinators and administrative staff, acting in a supporting role for all work undertaken by the Systems and Technology team.• PC and printer hardware and software troubleshooting and support.• Create, update and maintaining team documentation using Microsoft SharePoint technologies.

• Built Complex T-SQL queries using joins to retrieve data from SQL server for forecasting and created Excel Report based on client's requirement. • Built Indexes to implement query optimization and performance tuning in T-SQL while developing a webpage using C#.Net for the client.• Worked in a team that developed a website for a leading insurance company using Asp.net and C#.net; solely designed the backend. Used Query optimization techniques while using SQL server.• Prepared various documentations like the Functional Requirement Specification (FRS), Technical Requirement Specification (TRS), Code Promotion (CP).• Retrieved data using SQL for forecasting and created Excel Report based on client's requirement.• Worked with Business Analysts to translate business requirements and functional designs into test plans for enhancements.• Worked with Business Analysts to gather business requirements and translate it into functional designs that is to be implemented.• Developed B.I dashboards and reports using SSRS that helped the client to access and analyze data resulting in higher revenues and margins and a better customer experience.• Maintained constant communications with the client throughout the project through video conferences to help identify and clarify business requirements.• Provided both domain and technical knowledge transfer to freshers in the team.