Mahesh Puppala

• Interaction with Product management & Engineering Teams: Work with Model N’s product management teams to understand current and future releases of the Model N applications (Revenue Management in Cloud, Contract Management and Accruals Solution). Communicate customer requirements effectively to product management and engineering teams and acts as project business and technical analyst subject matter expert. Document the product GAP after business requirement analysis and works with the Product team to include the important customer requirements in the future product releases.
• System configuration & Extension: Analyze the business requirement for Model N Applications (Revenue Management in Cloud, Contract Management, Accruals Solution) and guide the team to configure the system based on the requirements that include user, group, role, application switches, validations, approval routes, security and users authentication setups. Lead the development team to add the customs for the requirements that are not part of current product release that includes the project plan development to construct the customs by using the ACF, POF Frameworks as per the timeline allocated, design, code review and demo the custom features to the customer after construction. Drafter Desing objectives and system design documents
• Data Conversion & Integration: Conduct technical workshops to explain the requirements to convert the data from customers legacy system to Model N applications (Revenue Management in Cloud, Contract Management, Accruals Solution). Work with partner and customer IT counterparts to establish the data mapping sheets and integration design. This duty includes design interface to convert all the data objects into required format and develop a verification process to validate the migrated data. Work with customer ERP IT Team to develop an interface for payment processing, to load master data and pricing information into Model N applications.
• Testing Support and Defect Management: Work to fix the defects identified during various testing phases (System Integration Testing, User Acceptance Testing) throughout the project implementation. Review the test cases, review calculation model for rebate processing, update technical design document for the scope and configuration changes. Report the product defects to product development team to resolve the defects prior to next testing phase.
• Product Release & Configurations Deployment: Work with Model N Cloud operation team to deploy the Model N product release and patches in customer environments that includes deployment of Revenue Management in Cloud , Contract Management, Accruals Solution applications across various customer environments (DEV, QA, STG, PROD). Guide the technical team to create a patch for configuration changes, custom extensions, and performance fixes throughout the project implementation.
• Task & Resource Management: Lead Model N onsite & offshore technical team members, it includes creating a project plan, tracking the work progress, status calls and code review. Train new team members and provide guidance to the team when necessary.

• Analyze Model N and client software system and provide recommendations regarding optimal design and technical configurations per client business requirements.
• Conducting technical workshops with client IT technical team. Support functional team through requirements sessions and GAP analysis.
• Coordinate and work with technical counterparts from partner firms and client.
• Providing data mapping sheet to convert data from client ERP system to Model N. Suggest best solutions to overcome data mapping and data conversion related issues.
• Manage the technical team and responsible for all the technical deliverable.
• Review functional specifications; work with technical team on delivery of technical specification, unit test plans, and brain storming on case scenarios.
• Design and develop the custom features with the help of Model N ACF & POF Frameworks.
• Attending meetings, workshops with functional team to understand the issues and helping to provide suitable solutions
• Execute the technical task as per the development plan
• Performing all database related operations using tools like Toad for Oracle 10g and Oracle SQL Developer
• Working with Version control systems(perforce) to manage views, checking/ checkout and merge activities in local and main CC branches level of quality
• Guide and support for Build and deployment process.

• Revenue Cloud for Pharma: Model N's Pharma Revenue Cloud suite enables customer to maximize revenue and minimize compliance risk across their product portfolios, customer channels, and geographies.
• Roles and Responsibilities: Design new requirements as per the requirement and effectively implementing change management Building reusable components and front-end libraries for use, across the products Optimizing components for maximum performance Implementing components and application with support for test automation Mentor new team members in technical & functional areas Serve as a SME on Model N’s proprietary frameworks EOL Implementation – Converted all the Adobe Flex pages to React JS
• Environment: Java, J2EE, Web Services (REST/SOAP), ACF, POF(Proprietary), JavaScript, JBoss, React JS
• Revenue Cloud for Government Pricing: Revenue Cloud for Government Pricing (using Big Data solutions) reduces the risk of fines and brand equity damage to ensure regulatory compliance.
• Roles and Responsibilities: Transforming the Government pricing calculations from Oracle to Apache spark Big Data clusters to achieve 10x performance improvement Tunes jobs performance by using YARN Application Master and Spark History Server Written Hive Generic UDFs to implement customized functions in Spark SQL Written Spark applications for Government Pricing calculation and submits over EMR-YARN Transforms the data from oracle to csv using Informatic. Implemented Java Jar to generate automatic informatica workflows Transforms the data from CSV to Parquet using Spark SQL external tables in Amazon S3 Involved in setting up Hadoop cluster using Apache components for Dev and QA. Rewrite Oracle SQL to ANSI SQL compliant ANTLR v4 grammar utility
• Environment: Java, J2EE, Informatica, Spark ,Apache Drill, Hive SQL, Amazon S3 , JavaScript
• Rest services for Revenue Cloud: The Model N data services, namely, the Data Query Service and the Object Graph Editing Service provide application clients the ability to retrieve and update Model N data. The Data Query Service provides the ability to search and retrieve data for Model N objects (FGOs) using the Data Query Language (DQL). The Object Graph Editing Service provides the ability to create and update the Model N objects and perform application-specific life-cycle actions on the objects. These services are exposed as REST API services to the application clients.
• Roles and Responsibilities: Responsible for designing the project Design security model for the data objects. Implement web services security Develop REST APIs for the Data Services
• Environment: Java, J2EE, REST Web Services ,React JS, JavaScript, JBoss EAP
• Product Performance: Large customers like J&J, Merck and Abbott have huge data for processing. Application loading and calculations/Bucketing frame work improvements.
• Roles and Responsibilities: Designed and developed partitioning strategy for large tables Tuned long running queries by analyzing trace files, OEM query plans and AWR reports Rewrote some of the application logic from Java to PL/SQL procedures, to reduce the running time of specific tasks Enhanced importers framework evaluation Logic (core evaluation part for Master data module) in an optimized way i.e. reduction of loops in java later, resolving contentions, rewritten queries which are long running.
• Environment: Java, J2EE,REST Web Services , ACF,POF, JavaScript, Oracle 11g & 12c
• MN script engine: Model N has its own wrapper implementation on top of Rhino scripting service to be able to use for Acceptance tests (ACTs), for automation.
• Roles and Responsibilities: Develop an expression language that can provide the foundation for the configurability for logic running within the application server layer of Model N applications. Develop data libraries to handle the access and modification of persistent data Develop libraries for querying, loading, saving and removing FGO objects Develop extensibility support for feature scope libraries
• Environment: Java, J2EE, SOAP Web Services, JavaScript, ACT framework, Jenkins
• Strategy Conversion Engine: Scripting tool to convert all the legacy related data to latest implementation framework. Migrated data from old implementation to latest implementation. This is very useful to pharma customer business model change
• Roles and Responsibilities: Responsible for designing the project and implementation Moved all the data from old system to new implementations using oracle queries for pharma business model Refresh End to End pharma

GPA: 76.83%