JagadeeswaraRao Dora

Mobile : +91-812*******

Email : adhz3o@r.postjobfree.com

Professional Synopsis

9+ years of progressive IT development experience in Oracle 10g, 11g, and 12c (SQL & PL/SQL).

3+ years of experience in Postgresql development.

Investments, ERP, CMT, Banking, Life Sciences Domain and KRONOS Workforce Central expertise in Oracle SQL, PL/SQL, Oracle Forms & Reports.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, Analytical functions, developing Forms and Reports.

Experience with Informatica Designer Components such as Source Analyzer, Warehouse Designer, Transformation Developer, mapplet and Mapping Designer. ETL Design and ETL development using Informatica Power center 9.0.

Expert level Data analysis, Data profiling and Data quality process design.

Experience in Database design using Normalization and E/R Diagrams

Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Profiler, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.

Experience in developing External Tables, Joins, Indexes and sequences.

Responsible for code review, Unit and System Level testing.

System Analyst experience entails working with clients/domain experts to analyze and define business requirements, Shaping functional, technical specifications and design, giving presentations, liaising between business groups and technical team.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Experience in writing Technical design documents and developing unit test documents.

Experience coordinating, validating and undertaking unit and integration testing.

Excellent communication skills & very good team building and leading abilities and ability to articulate technical problems & solutions in a mixed team environment.

Mentor a growing onsite and offshore team in various phases of knowledge transition and day to day maintenance and production support activities.

IT Skill Set

Language : Oracle SQL, PL/SQL, Java, HTML

Front End Tools : Oracle Forms Developer 10g, VB 6.0

Databases : Oracle 8i, 9i, 10g, 11g, 12c, Postgres and MS Access

OS : Solaris, UNIX, Windows 2003 Server, Windows XP/2007

Tools & Utilities : Oracle 12c Client, Informatica 9, DBeaver, SQL Loader, Toad,

SQL Developer, PL/SQL Developer, Jaspersoft.

Honors & Awards

Shining Star Award for the Quarter, 2019 (Vitech Systems Asia)

Star Performer Award for Responsiveness, Feb 2013 (Accenture Services Pvt. Ltd.)

Star Performer Award for People Excellence, Sep 2013 (Accenture Services Pvt. Ltd.)

Team of the Quarter Award, Sep 2014 (IGATE Global Solutions Ltd.)

Education

Master Of Science (Computer Science), Andhra University, Visakhapatnam. 2007

B.Sc (Computer Science), Andhra University, Visakhapatnam. 2005

Career Highlights

Working as a Lead Developer in Vitech Systems Asia Pvt. Ltd., Hyderabad (Apr 2015 – till now)

Working as a Technical Lead in IGATE Global Solutions Ltd., Bangalore (Dec 2013 – Apr 2015)

Worked as a Sr. Software Engineer in Accenture Services Pvt. Ltd., Bangalore (Nov 2011- Dec 2013)

Worked as a Software Engineer in Ardee Business Services Pvt. Ltd., Visakhapatnam (May 2007 - Nov 2011)

Key projects handled

1)Project : V3 INSURENCE ADMINISTRATION (Query and Batch Module)

Client : Bridgewater, NTMA, ICG and MoO

Duration : Jun 19 – Till now

Platform : Oracle 12c SQL, PL/SQL, Postgres, Jaspersoft

Role : Lead Developer

Description:

V3 helps automate key front office operations such as deal flow management, investment monitoring, and fund raising as well as back office operations such as capital call/distribution processing, fee and carry calculations, and financial accounting with reporting. Whether you are tracking direct or indirect investments, V3 allows for the full lifecycle of private equity portfolio management. V3 also provides the ability to load and track company portfolio financial information, allowing individuals to perform complex variance and performance analysis from a single point of origin.

V3 CRM capabilities fully automate the generation and distribution of investor communications via advanced document management features including email and fax integration. Fund capital transactions, fees and income/expense, and investment details can be allocated to your investors, building out each investor’s capital account from these transactional details and providing immediate access to an investor’s position. V3’s effective processing provides an increased ability to provide investors with timely information and maintain transparency into fund activities.

Batch:

V3 has a batch tool that can be used for running client specific batch processes for any application in V3. Batch is the processing of transactions in a group or batch. No user interaction is required once batch processing is underway. Examples of common V3 batch processes calculate allocation of capital gains and dividend or interest income generated by the fund for the investors periodically, importing or exporting data into V3, updating data in V3, and running reports/documents in V3.

Roles & Responsibilities:

Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, distributing tasks among team members, doing code reviews, facilitate source code control.

Responsibilities implementing database objects (Package, procedures, functions, triggers).

Developed the reports using Jaspersoft tool.

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Created PL/SQL functions to facilitate business functions and calculations.

2)Project : V3 INSURENCE ADMINISTRATION (Query Module)

Client : ETF

Duration : Jan 19 – May 19

Platform : Oracle 12c SQL, PL/SQL, Postgres, Jaspersoft

Role : Lead Developer

Description:

V3 offers a complete suite of insurance capabilities and a comprehensive set of enterprise features in a single, integrated solution leveraging a single common database and user interface. This creates tremendous opportunities for system consolidation and data duplication while potentially revolutionizing your administrative capabilities and service offerings.

Query:

The query module allows for building arbitrary sql queries within V3. It supports arbitrary column selection, arbitrary criteria creation, and creation of a simple reports. The query module uses query-specific metadata, alongside with the catalog tables to present a list of artifacts that can be used to generate a query.

Roles & Responsibilities:

Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, distributing tasks among team members, doing code reviews, facilitate source code control.

Responsibilities implementing database objects (Package, procedures, functions, triggers).

Developed the reports using Jaspersoft tool.

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

3)Project : V3 INVESTMENT ADMINITRATION (C2B CONVERSION)

Client : Hauck

Duration : Jan 18 – Dec 18

Platform : Oracle 12c PL/SQL

Languages : Oracle SQL, PL/SQL

Role : Senior Developer

Description: It refers to the upgrade and/or conversion of the V3 Classic application to V3 Browser application for V3 clients that started using V3 on the Classic platform. The setup data for all artifacts is converted as a part of data conversion.

Identifies the tables in classic that need to be converted over to browser. This basically identifies tables in classic that have data that is still relevant in browser. That is pretty much every table in classic that has data. Conversion is usually done a phase at a time. Need to maintain the sequence in which the tables need to be converted. This takes the referential integrity of the columns into account. The sequence generally makes sense only within the context of the phase.

Roles & Responsibilities:

Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, distributing tasks among team members, doing code reviews, facilitate source code control.

Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers

Developed the reports using Jaspersoft tool.

Enforced database integrity using primary keys and foreign keys

Created PL/SQL functions to facilitate business functions and calculations.

Attending the daily scrums, stand up meeting etc.

4)Project : V3 APPLICATION

Client : MAINE, USA

Duration : May 15 – Dec 17

Platform : Oracle 11g and 12c PL/SQL,

Role : Senior Developer

Description: It refers to the upgrade and/or conversion of the V8 application to V10 Browser application.

Roles & Responsibilities:

Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, distributing tasks among team members, doing code reviews, facilitate source code control.

Responsibilities implementing database objects (Package, procedures, functions, triggers).

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Enforced database integrity using primary keys and foreign keys

Created PL/SQL functions to facilitate business functions and calculations.

Attending the daily scrums, stand up meeting etc.

5)Title: MRO (Maintenance Repair & Overhaul)

Client: GE Aviation

Duration : May 14 – Mar 15

Platform : Oracle 10g PL/SQL,

Role : Technical Lead

Description: This project is involved in the development of both Purchasing and Inventory modules. Thus, the Purchasing and Inventory functions for all the ESS shops in US, Hungary, Malaysia, Singapore and Japan. Purchasing is used to raise the requisition, order the part, receive the part and inspect. Inventory is used to receive parts and issue parts keep track of costs.

Roles & Responsibilities:

Responsibilities implementing database objects (Package, procedures, functions, triggers).

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Provide ad-hoc reports to business users on demand- running SQL scripts and exporting to excel.

Prepare and maintain monthly and weekly metrics for the instance to provide statistics to business.

Manage and improve team performance basing on metrics/statistics.

Improved the performance of the application by rewriting the SQL queries.

Fine-tuning the SQL queries by using index strategies and also optimization techniques.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

6)Title : KRONOS ANGOLA

Client : GE ENERGY

Duration : Jan 14 – May 14

Platform : Oracle 11g PL/SQL

Module : Kronos Workforce Time & Attendance

Role : Developer

Description: Kronos automated time-tracking software is the ultimate time and attendance system to help reduce risk of costly payroll errors and inflation. Kronos makes easy work of the tedious tasks involved with monitoring employee time and attendance. Our time-tracking software, working in tandem with our data collection devices, helps you control your labor costs, manage compliance risk, and improve workforce productivity without breaking a sweat. Workforce Activities from Kronos gives you the latest and most detailed activity tracking data. With the right information at your fingertips, you gain the power to make truly effective, knowledge-based decisions. And take action before your bottom line is at risk.

Roles & Responsibilities:

Configuring activities and Time & Attendance module in Kronos as per the business requirement

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Performed Unit testing, System Integration Testing and User Acceptance Testing.

Coordination with onsite and offshore team for application related queries on requirements.

7)Title: DSOPI (Data Seeding and Operational Interface)

Client: PFIZER

Duration : Aug 12 – Dec 13

Platform : Oracle 11g PL/SQL, Informatica 9.0

Role : Senior Oracle Developer

Description: Pfizer-ESI CAL- is an Oracle Cloud hosted data aggregation and exchange environment is the first of its kind in the industry and we believe it will change the way clinical data is aggregated, shared, pooled and analyzed. Pfizer DSOPI (Data Seeding and Operational Interface) is a data center migration project which validates and generates an XML based on the xsd, for the data available in database and place in a server. It also updates the status and also processes the acknowledgement and error files and updates the status and archives the same.

Roles & Responsibilities:

Responsibilities implementing database objects (Package, procedures, functions, triggers).

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Developed PL/SQL code for Data migration from Legacy systems to current ones.

Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.

Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.

Involved in all phases right from collecting requirements from client to PROD.

Coordination with onsite and offshore team for deliverables.

Involve in estimation, preparing design document.

Review code, design document and unit test cases.

8)Title: Smart Care

Client: CISCO

Duration : Nov 11 – Aug 12

Platform : Oracle 11g PL/SQL, Informatica 9.0

Role : Senior Oracle Developer

Description: The CISCO Smart Care application is a web based 2- tier application which provides network level services to the end customers. This portal enables the CISCO certified partners to deliver proactive Network monitoring, health checkups, diagnostics, and software repairs, in addition to technical support for entire Cisco network in a single contract.

Roles & Responsibilities:

Responsibilities implementing database objects (Package, procedures, functions, triggers).

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.

Experience writing Complex SQL queries and PL/SQL.

Extensively used for all and bulk collect to fetch large volumes of data from table

Involved in Logical & Physical Database Layout Design

Coordination with onsite and offshore team for application related queries on Database.

Performed SQL and PL/SQL tuning and Application tuning using various tools like DBMS_PROFILER, EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Review code, design document and unit test cases.

9)Project : Banking Module (LC Tracking)

Client : Ardee Business Services Pvt. Ltd.

Duration : Jan 11 to Oct 11

Platform : VB.6.0, Oracle 10g

Role : Programmer

Description: Ardee currently manages all the LC related information manually. A manual system usually consists of huge filings, which takes time in decision making. This automated LC tracking system will assist it’s user to show the current LC positions, provide queries related to LC’s, and store important information regarding different parties of the trade. The successful implementation will help the management enormously in their everyday job at the trade service department.

Roles & Responsibilities:

●Developed Different Forms as per requirement.

●Developed auto generate EXCEL, WORD, HTML Reports.

●Preparing the Technical design documents and developing unit test documents.

●Debugging and Fixing Production Data.

●Developed SQL queries for back-end data store.

10)Project : Ardeesoft (ERP)

Client : Ardee Business Services Pvt. Ltd.

Duration : Sep 10 to Dec 10

Platform : VB.6.0, Oracle 10g

Role : Programmer

Description: Ardee implement ArdeeSoft software of total Three Units in India. ArdeeSoft software is proposed to be an ERP Management product. This product automates various departments of an organization to ease the interoffice communication. The first version of this product contains modules viz. Staff Details, Accounts, HR, Payroll, Logistics, Sales and Marketing, Material Management, Production Planning, System Maintenance, Data Export and Import and etc,. Few more modules are proposed to be included in coming versions.

Roles & Responsibilities:

●Developed Different Forms as per requirement.

●Developed auto generate EXCEL, WORD, HTML Reports.

●Preparing the Technical design documents and developing unit test documents.

●Debugging and Fixing Production Data.

●Developed SQL queries for back-end data store.

11)Project : Inventory Module

Client : Ardee Business Services Pvt. Ltd.

Duration : May 10 – Sep 10

Platform : VB.6.0, Oracle 10g

Role : Programmer

Description: It stores Inventory transactions, summarized Inventory transactions, Stock Positions and Stock Status. It is the key the key to inventory process and provides all inventory data and give the information about the physical location of material.

Roles & Responsibilities:

●Developed Different Forms as per requirement.

●Developed auto generate EXCEL, WORD, HTML Reports.

●Preparing the Technical design documents and developing unit test documents.

●Debugging and Fixing Production Data.

●Developed SQL queries for back-end data store.

12)Project : Purchase Module

Client : Ardee Business Services Pvt. Ltd.

Duration : Dec 09 – May 10

Platform : VB.6.0, Oracle 10g

Role : Programmer

Description: Purchase module is a part of the Web Based ERP Software of Ardee Business Services Pvt. Ltd. Purchase Module is responsible for generating various Purchase related reports. The Module meets to all purchase requirement of the company.

Roles & Responsibilities:

●Developed Different Forms as per requirement.

●Developed auto generate EXCEL, WORD, HTML Reports.

●Preparing the Technical design documents and developing unit test documents.

●Debugging and Fixing Production Data.

●Developed SQL queries for back-end data store.

13)Project : Finance Module

Client : Ardee Business Services Pvt. Ltd.

Duration : Jan 09- Nov 09

Platform : VB.6.0, Oracle 10g

Role : Programmer

Description: Finance module of the ERP software will take care of all accounts related entries and their impact on the whole system. How the finance comes and how it is been utilized. Total flow of money (Cash/Bank) and total expenditures will be reflected here. As an after effect of this, the management will be able to take their important financial decision, Budgeting etc. They can come to know about company financial position at any point of time. All sorts of important financial reports i.e. Trial Balance, Trading A/c, Profit & Loss A/c, Balance Sheet, Debtor Balance, Creditors Balance, Cash/Bank Fund position and many more are covered in this module..

Roles & Responsibilities:

●Developed Different Forms as per requirement.

●Developed auto generate EXCEL, WORD, HTML Reports.

●Preparing the Technical design documents and developing unit test documents.

●Debugging and Fixing Production Data.

●Developed SQL queries for back-end data store.

14)Project : HRH (Human Resource and Hours Tracking System)

Client : Ardee Business Services Pvt. Ltd.

Duration : Aug 07 - Dec08

Platform : VB.6.0, Oracle 10g

Role : Programmer

Description: HR (Human Resources) is another widely implemented ERP module. HR module streamlines the management of human resources and human capitals. HR modules routinely maintain a complete employee database including contact information, salary details, attendance, performance evaluation and promotion of all employees. Advanced HR module is integrated with knowledge management systems to optimally utilize the expertise of all employees.

Roles & Responsibilities:

Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.

Developed Different Forms as per requirement.

Normalized to 3NF to acquire least data repetition required by business.

Analyzing personnel usage within an organization.

Modified forms, pay roll reports as per client requirement.

Personal Details

●Date of Birth :- 13-Mar-1984

●Passport No :- K2755802 (Validity up to 01-Feb-2022)

●Gender :- Male

●Marital Status :- Married

●Nationality :- Indian

●Language Known :- English/Hindi/Telugu

I hereby declare that the information stated above is true and to the best of my knowledge.

Place: Hyderabad JagadeeswaraRao Dora

Date:

Contact this candidate