ANISHYA PAUL

Description: Shell is a global group of energy and petrochemicals companies. With around 94,000 employees in more than 70 countries and territories, Shell helps to meet the world's growing demand for energy in economically,environmentally and socially responsible ways.

This project covers reports of daily, monthly, yearly transactional reports and fuel reports.

It involves generating jasper reports for Shell Petrol Pump for more than 20 countries which includes card and transaction details at each SHELL Outlet.

Technologies Used: Jasper, Oracle PLSQL, Unix, JSON, SQL Server Integration services

Tools: SQL Developer, Tibco Jaspersoft, Putty, Winscp, GitHub, Microsoft Visual Studio

Role: Internal Report Developer

Responsibilities:

• Design and Develop jasper reports on jasper soft reporting tool

• Interacted with Business Analysts and stakeholders/customer in requirement gathering.

• Created Technical Design for the Back End PL/SQL based on Business Requirement Documents and the Functional System Design and implementation of business application using the Oracle RDBMS

• Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using oracle tools like PL/SQL Developer.

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

• Experience in Oracle RDBMS database installation, configuration, and maintenance and knowledge on design and implement normalized relational database schemas.

• Constant monitoring and performance tuning of oracle database, checking the most queries.

• Involved in updating procedures, functions, triggers, and packages based on the change request.

• Built Complex queries using SQL and wrote stored procedures using PL/SQL.

• Writing Procedures and complex queries to fetch data from database

• Resolving Performance issues to ensure reports do not take long time to generate

· Configured Jasper report server.

· Effectively made use of Analytical & Aggregate functions, Create Tables, Indexes, Views, Set Operators, Joins, Complex Queries, Materialized Views,and Constraints for fetching the data from database.

· Have done Performance tuning of complex SQL queries using Index, Parallel Hints, AWR Reports and Optimization using Oracle Hints, Explain plans, DBMS_PROFILER,Tk-Prof and Table Partitioning.

· Deployment and version control of reports using SVN, GIT.

· Designed and developed Unix Shell script to perform data loading.

· Created Unix shell script for interface tool to run sessions.

· Experienced in using SSIS tools (MS Visual studio) like import and export wizard, package installation and SSIS package designer.

· Experience in importing/exporting data between different sources like Oracle/Access/Excel etc using SSIS utility .

· Involved in project support.

· Designed statistical reports.

· Optimizing the performance from the query and tool side.

· SQL queries to retrieve data from ORACLE database.

· Creating temp table for performance improvement.

· Creating view, materialized view, procedures

· Involved in Query tuning.

· Analyzing AWR and ADDM reports.

· Worked on projects in Agile/Scrum methodology contributing to Sprint Planning and Daily Stand-up meetings.

· In Agile Supported release planning and solution architecture design as needed. Directed daily scrums with different scrum teams. Actively participated in sprint planning sessions, offering insights into technical feasibility and effort estimation.

· Worked closely with users in gathering and analyzing requirements and providing solutions that meet their requirements.

· Participate in daily scrum to discuss on the current status and burn down of the hours for the tasks assigned.

Description: Healthways is the largest and most experienced global disease management and wellbeing provider. Healthways offers comprehensive solutions that helps to improve well-being, decrease healthcare costs, enhance performance and generate economic value for their customers.

We have a set of informatica mappings and PLSQL and .NET codes which will take the data from BizTalk server and sends into the downstream system database SQL SERVER.

Data Intake – TA is coming in the phase of Healthways Data Fix. If any Data Fix is required for any of the schemas for Healthways, TA is looking in to that.

Technologies Used: Oracle PLSQL,SQL, .NET, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Eclipse, SSMS, Visual Studio

Role: Data Intake-Technology Analyst

Responsibilities:

· Communicated with business customers to discuss the issues and requirements.

· Involved in production support activities to resolve the ongoing issues and troubleshoot the problems.

· Responsible for developing/supporting application using VB.net and PLSQL

· Finding and fixing the data issues/customer facing using VB.NET , SQL,PL/SQL.

· Creating and solving the incidents and change requests for the required data/interface fixes.

· Involved in deployment activities.

· Involved in analyzing the .net code and PL/SQL blocks to find the issues.

· Designed and developed user interfaces using JSP, HTML, Angular JS and CSS

· Working on L2, L3 incidents and bringing them to closure as soon as possible.

· Responsible for the incident management process by supervising the resource.

· Involved in data loading to production, Data fixes using T-SQL and communication with the account team and business clients.

· Involved in design, development and testing phases in a fast paced agile environment.

· Documented steps taken to trouble shoot and fix the issues.

· Involved in development, enhancement, Testing, bug fixing of the Application maintenance.

· Creating and resolving the incidents and change requests for the required problem fixes

Description: For BT they have one tool to re-sign (renew) their contract with customers. But for BT Global Services, they have different source system to get data. Due to the discrepancy of data in each system re-sign tool is not in use. So we have some defined set of rules to identify and rectify the data discrepancy and make the system to function properly.

Technologies Used: Oracle PLSQL, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Eclipse

Responsibilities:

· Identify and rectify data discrepancy by changing/creating procedure.

· Monitoring the daily, weekly and monthly jobs.

· Involved in the production support activities to resolve the ongoing issues and troubleshoot the problems.

· Unit testing and integration testing of the modules.

Description: The module was developed for agents so that they can issue policy with virtual float balance. The designated user has the rights to assign virtual float balance to privileged agents along with a due date. Once this is done, the agent can issue policy utilizing actual float balance and Notional float balance. Once the due date is passed and if the policy is not settled, (i.e. the agent has not paid for the utilized notional float), the system will block the policy issuance by showing ‘0' float balance for that

particular user. Once the agent pays for notional float amount automatically, system will unlock the float.

Notional float can have impact in policy issuance, Receipt Generation and Policy cancellation etc. We are passing accounting for each notional float transactions.

Technologies Used: Oracle PLSQL, Struts,J2EE, JSP, JavaScript,Ajax, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Dreamweaver

Role: Database and Frontend Developer

Responsibilities:

· Designed and Developed Webpages using Jsp,Css,Ajax,Struts and XML

· Front end and backend validation for all the forms created using Javascript and PL/SQL

· Validated input values to make sure that they will be accepted before they are submitted to the server.

· Created packages,procedures and Functions to perform this module.

· Part of the entite life cycle of this application , beginning from the requirement gathering, designning for user interface and DB tables,Coding, Unit testing and Maintenance.

· Leading a Team to succesfull implementation of this project.

• Covernote Control Process/Scrutiny Tagging

Description : It is a process before policy Issuance. As an insurance company Bajaj Allianz aim of introducing this process is to eliminate the disadvantages of manual reconciliation, manual updation of records. By this process cover note control can be audited on real time basis.In existing process of cover note control, user needs to maintain excel sheet and manually update it on regular basis. User also does daily reconciliation with Premium register & inward register to know the current status of cover notes. This manual updation task takes lots of time and effort and also there will be possibility of errors.

Monitoring of no of books assigned to one particular IMD is also done manually and sometime it creates confusion and mismatches with the actual position. Current process involves tracing missing & intermittent cover notes, which needs regular physical verification of cover note leaves which is very time consuming & tedious process.

Hence this project aims at avoiding manual covernote reconciliation & Covernote approvals will be done through online only instead of mails. Only the correct covernote numbers will be ready for allotement to branches an all the incorrect covernote entries created will be rejected& cancelled. This is having many approval/rejection stages till it reaches to IMDs bucket.

Technologies Used: Oracle PLSQL, SQL, Java, VB.NET, Struts, JSP, JavaScript, Ajax, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Dreamweaver, Visual Studio, Eclipse, SSMS

Role: Database and Frontend Developer

Responsibilities:

· It is a New Module Developed, so able to participated in entire SDLC life cycle of this application , beginning from the requirement gathering, designing for user interface and DB tables, Coding, Unit testing and Maintenance and Enhancements.

· Part of Development and Unit Testing.

· Created this application UI Using client side technologies like JSP,Javascript, Jquery, CSS3,HTML5 and ajax.

· Developed the reusable framework for the application using VB.net, Java and MVC framework.

· Testing the application in the different phases of development cycle.

· Resolving Issues, backtracking to get the root cause, and fixing the issue.

· Provided production support.

· Experienced in documenting and writing use cases and functional requirements as well as in working with process modeling using UML diagrams and Business flow diagrams using MS Visio .

· Good experience of direct communication with clients/customers and handling escalations.

· Worked for Test Case Preparation, Test Case Execution, Bug Reporting and Bug Fixing. Create Unit test plan to test functions and conditions.

· Effectively made use of Analytical & Aggregate functions, Create Tables, Indexes, Views, Set Operators, Joins, Complex Queries, Materialized Views and Constraints, Packages, procedures and functions etc for fetching the data from database using SQL/PLSQL.

· Experience in data migration from various data sources like excel, SQL server, oracle ,xml files and flat files using SSIS packages and SQL commands. Monitoring, debugging and tuning ETL jobs and workflows.

· Experience in using SSIS tools (MS Visual studio) like import and export wizard, package installation and SSIS package designer.

· Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS utility for ETL .