Swetha Mohan Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

Columbus, Indiana, Us

- Lead the sales analytics team to design and deliver key KPIs and measures by partnering with the sales business leaders to determine, analyze and document the business requirements and define the priorities for the solution implementation- Executing the detailed analysis and implementation of BI models and reports after assessing solution feasibility against requirements; This includes building data processing logic using SQL server, ETL transformation logic in Microsoft SSIS, modeling data in Microsoft SSAS and reporting measures and KPIs in Power BI, Excel etc.,- Lead the solution design and implementation by partnering with the Cummins Customer Care business team to develop a BI reporting tool in Microsoft SSDT and Power BI that helps business leaders to make strategic decisions

Columbus, Indiana, Us

- Led the analytics transformation project to implement BI reporting for Sales, Service and Supply chain functions from legacy ERP system data to SAP S4 Hana and Power BI- Designed and developed BI reporting projects by analyzing the requirements, that helped in significantly reducing the manual efforts for the business users

Columbus, Indiana, Us

- Designed and developed 15 operational reports for Cummins Distribution using Oracle Business Intelligence Enterprise Edition 11g (OBIEE)- Developed standard report template and managed the quality assurance team to validate 89 operational reports- Presented and gained user approval for 89 operational reports from Business Process Leaders resulting in launch of a new Business Intelligence platform

Rochester, New York, Us

- Part-time Student Employee at Interactive Games and Media (IGM) Labs - Designed and developed new features for the Administrative Data System (ADS) of the IGM program website using PHP, JavaScript and MySQL

Paris, France, Fr

- Designed and developed PLSQL procedures for the implementation of Anti-Money Laundering (AML) detection scenarios - Investigated the existing detection scenarios and constructed performance tuned queries using MySQL to analyze the impact- Effectively coordinated with different business analysts, to ensure AML best practices are not compromised

- Worked end to end on the development of an intelligent recruitment engine on the cloud using Groovy on Grails framework and MySQL database, which has an Applicant Tracking System (ATS) that relies on active collaboration between the recruiters and the candidates to find the right candidate for the right job- Played a major role in the design and development of “Prefer”, an effective Referral program tool which is built using Groovy on Grails framework inside the product- Implemented OAuth 2.0 and successfully integrated the product with social sites such as Facebook, LinkedIn and Google- Performed Regression testing for the entire website and have fixed all the broken links without any glitches

Mumbai, Maharashtra, In

- Developed an extensive J2EE web based application that enables hospitals and other healthcare providers to expedite claim and remittance processing in an efficient way to reduce costs- Built the application engine’s user interface in Spring MVC framework and core Java- Stabilized the application's performance by implementing optimized PLSQL stored procedures at the back end

Master’S Degree, Information Sciences & Technologies

Bachelor’S Degree, Information Technology