Navya N

Programmer Analyst

Cognizant Technology Solutions•  January 2016 - August 2018

Eli Lilly is a global pharmaceutical company that engages in the discovery, development, manufacture, and sale of pharmaceutical products. Developed and supported 2 major applications: Commitment Attainment Tool (CAT) and Business Reporting Tool (BRT). CAT is used for tracking and reporting the sales representative’s targets and activities. BRT is used for data analytics on various business modules like Sales, Rx, Payer, Activity, and APLD data.

Programmer Analyst

Cognizant Technology Solutions•  January 2016 - August 2018

• Followed Agile methodology, interacted with the client, provide/take feedback on the features, suggest/ implement optimal solutions, and tailored application to customer needs. • Developed reusable and interoperable Web service modules based on Microservice architecture using REST with Spring Boot. • Used Spring framework, Spring-AOP, Spring-ORM, Spring-JDBC modules to implement the service components based on the given requirements in different modules. • Created connections to the database using Hibernate, APIs to retrieve and store data to the database with Hibernate transaction control. • Implement Dependency Injection (IOC) feature of spring framework to inject beans into User Interface and AOP for Logging. • Writing JUnit test cases for the developed functionality in Business, Helper & Utility classes developed and ensure that it is aligned with technical and functional objects. • Consumed Web Services to interact with other external interfaces to exchange the data in different forms by using RESTful service. • Achieved synchronization of multiple threads through Multithreading and Exception Handling. • Developed UI screens using HTML5, CSS3, JavaScript, JSX, and Bootstrap for responsive applications. • Implemented Angular 2 services to connect the web application to back-end APIs and built Angular applications with AOT (Ahead of Time) which helped in the performance of the webpage nearly 60% faster. • Created Typescript reusable components and services to consume REST API’s using Component-based architecture provided by Angular 2.0 and Built Single Page Applications (SPA) with loading multiple views using route services using Angular component interaction. • Worked extensively to achieve DOM Show, hide elements, and Event Handling using angular js. • Developed stored procedures using PL/SQL in Oracle database to report and manage metrics of client and competitor products which helped in performing data analysis for client portfolios for business development purposes. • Designed and developed reporting and attainment tools using dynamic SQL and SSRS. • Performed ETL processing such as Data Extraction, Data Transformation, and Data Loading process using SQL and SSIS. • Performed manual testing through HP Quality Centre based on business requirements and functional specifications. • Understanding business requirements drafted by the business analyst and product owner(client) & translating requirements to technical system specifications. • Extensively used Hibernate Query Language (HQL) and Criteria based queries to work with Oracle databases.