JobsGalore.eu
JobsGalore.eu
JG
  • Log in
  • Sign up

JobsGalore.eu

  •    Post a job ad for free
  •    Upload your resume
  •    Send a message to employers
  •    Log in
  •    Sign up
  • Terms and Conditions
  • Privacy policy
  • Contact us
  • About us

Sr. System Analyst/Oracle DBA/ETL/PLSQL Developer

PROFILE HIGHLIGHTS:

  • A self-motivated and proactive IT- Software Development with successful track record of Managing Projects, Involving planning, scheduling, tracking and reporting as well as documentation of BRD/FSD, SRS, LLD, FS and Including Problem and Incident management.

  • 10+ years of IT Experience as a Technical Lead/Software Engineer involved in requirements gathering, Analysis, Design (Modelling, Migration, Mapping), Development, Implementation, troubleshooting, unit testing, production deployment and support.

  • Exclusive experience in Project Scoping, Planning, Quality & Risk management, Communication between project stakeholders.

  • Creating the databases (DDL, DML, DCL & TCL) and table spaces, Developed logical and physical data models for schemas using Erwin, database objects such as tables, views, synonyms, Indexes,

  • Writing complex queries, SQL*Plus, Stored procedures, functions, PL/SQL packages, triggers and cursors, exception handling for retrieving, Bulk Binds and Collections, UTI_FILE packages, Creating Snapshots views, API Packages, and Schema Database Objects using SQL and PL/SQL.

  • Good knowledge of Performance tuning Memory Issues from OS, Database Application level related futures such as Query Optimizer (CBO), Explain Plan, SQL Trace & DBMS_STATES, Generating & Analysing TKPROF & AWR, ASH reports, Statistics, hints, SQL Profiler, ADDM, OEM, DBMS_PROFILER etc.

  • Customs Migrations from flat files in to table using SQL*Loader, Data bump, RMAN, Golden gate for Import & Exports.

  • Good Experience of Operation & Supports in Problem and Incident management, Resolving Tickets within (SLA) using Tivoli/TWS scheduling Jobs Control-M, Autopsy’s and bringing issues to the closure during product SIT & UAT and Production support 24*7.

  • Database Administrator (DBA) with Grid DB, Oracle RAC, Data guard, RMAN, ASM, Exadata Physical database design, Database maintenance, Patching, Backup and recovery, DB links and privileges, Data Replication, Repository Management, Security administration, Database loading.

  • 6 years Strong Experience in BI & Data warehouse like data mart, data model, data mapping, design and implementation of ETL Workflow using Informatica and IBM Data stage, ODI tools, Worked SQL(T-SQL). Created SSIS, SSRS and SSAS Packages.

  • Familiarity with Visualization and reporting tools (Power BI, Tableau Qlikview, Qliksence, OBIEE, ODI, Continuous integration using SSDT and Jenkins Automation tool.

  • Good Knowledge of Big Data framework and No-SQL Apache-Cassandra, Mongo DB, PostgreSQL-9.5.1 version.

  • Java - excellent core understanding and low-level programming, Oracle Apex 4.0, HTML, CSS & Java Scripts, Oracle forms 10g, reports 6i.

  • 6 years of onsite experience working at Oman, Australia, China (HK), and Switzerland with clients.

  • 5+ year’s Functional expertise in Oracle Flex-cube, FinnOne™ Lending product including Financial (GL, AA, AP, AR, CM, FA) Modules.

  • Working with Fundamental of Risk Managements Credit Risk, Operation Risk, Market Risk, Country Risk, and Basel 1-2-3.

 

SERVICE PRACTICE:

  • Banking & Financial services, Securities, Investments and Insurance, Healthcare, Sales force (SFDC), EBS (ERP, SCM, CRM) Domains.

 

CAREER GRAPH:

Sr. Software Engineer (Oracle PL/SQL Developer) (Mar 2016 to May 2018)

EPAM SYSTEMS, INC., SHENZHEN, CHINA

Accountabilities:

  • Participated in development of Database Writing with Procedures, Functions & Packages and SQL Query Tuning Performances along with Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Assisted in Requirements Management, including elicitation/organizing requirements, translated & simplified requirements, analysis, creation of Business Case along with planning and monitoring.

  • Prepared all necessary project documents like BRD/FSD, SRS, LLD, and FS as well as created Business architecture using requirements such as Scope, Processes, Alternatives and Risks.

  • SQL Query Tuning Performances related futures such as Query Optimizer (CBO), table partitions, Explain Plan, SQL Trace & DBMS_STATES, Generating & Analyzing TKPROF & AWR reports

  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Trouble shot the bugs raised during testing of the products, by debugging the PL/SQL coding using TOAD, Oracle 9i/11g tools, Apache Cassandra, PostgreSQL DB tools, etc.

  • Loaded data into Data Warehouse, after creating various SSIS packages and used the same like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task, etc.

 

Technical Lead (Oracle PL/SQL) (Sep 2015 to Feb 2016)

INFINITE COMPUTER SOLUTIONS (P) LTD., BANGALORE, INDIA

Accountabilities:

  • Led a project for an international healthcare client for Development & Production Support, by resolution of Problem tickets, Incident management, etc.

  • Prepared all necessary project documents like BRD/FSD, SRS, LLD, and FS as well as created Business architecture using requirements such as Scope, Processes, Alternatives and Risks.

  • Executed the project, communicating with clients as well as coordination with the On-site and Support teams for monitoring jobs/application servers.

  • Participated in development of Procedures, Functions & Packages, as well as performance tuning of SQL Query and scheduling Database Full Backup, Transaction log backup & differential backup in daily Routine.

  • Diagnosed/tuned the server optimal performance using SQL Server 2008, SQL Profiler & Database Engine Tuning Wizards, while developed Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Engaged, further, in fixing of bugs raised during testing of the product, by the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

 

Sr. Oracle PL/SQL Developer (Dec 2014 to Aug 2015)

INFOSYS TECHNOLOGIES (P) LTD., BANGALORE, INDIA

Accountabilities:

  • Participated in a project for digital transformation of Centralized Processing Centre (CPC) in Department of Indian Income Tax by development of Complex Tax Accounting System, abiding with a set of rules.

  • Developed/enhanced packages, procedures, functions and other PL/SQL objects as well as Enhancement (Hot Fix/Change Requests), involving ETL Process.

  • Worked on Pre-processing, Account Receivables, Account Payables and General Ledger Modules of Oracle Applications, to account Processing details of Tax Payer.

  • Engaged in the Migration of SQL Server doing schema re-engineering conversion of TSQL Stored-Procedure to Oracle PL/SQL, along with Transformation of all MS-SQL Data table to Oracle.

  • Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

  • Additionally participated in multiple tasks - monitoring of data base changes, creating/review of Unit test Cases, Code review of System Test Scripts and detailed Specification Documents.

 

Sr. Oracle PL/SQL Developer (Jun 2011 to Nov 2014)

JNS Tech Solutions (P) Ltd., HYDERABAD, India

Accountabilities:

  • Participated in a project for an international technology leader with high service distribution of technology products and solutions for electronic system, with the responsibilities of development of Procedures, Functions & Packages, SQL Query Tuning Performances, Test Data/Test Case (including execution), various Reports according to the Business requirements, etc as well as resolution of errors raised while testing of the product and reporting of testing defects

 

Sr. Oracle PL/SQL Developer (Oct 2010-May 2011)

Oracle Financial Software Services (P) Ltd., SYDNEY, Australia

Accountabilities:

  • Participated in a project for an international bank at Australia, to implement Oracle FLEXCUBE Universal Banking (covering retail, corporate and investment banking functions), with the responsibilities of developing Money Marketing & Security functions, testing of the application, creating Procedures/Functions & Packages/SQL Query Tuning Performances/Reports, to meet the requirement, development of complex database objects like Stored Procedures, Functions, Packages and Triggers as well as fixing bugs raised while testing of the product.

 

PERVIOUS EXPERIENCE:

  • IITC LLC. (OHI GROUP), MUSCAT, OMAN as SR. ORACLE DEVELOPER (APR 2008 TO JUL 2010)

  • SYNOVA INNOVATIVE TECHNOLOGIES (P) LTD., BANGALORE as SR. SOFTWARE ENGINEER (SEP 2007 TO MAR 2008)

  • SANSPAREIL SOFT SOLUTIONS (P) LTD., COIMBATORE as PROGRAMMER (MAY 2004 TO AUG 2007)

 

PROJECT SUMMARY

Project

UBSJ CRISS- (GLAD - Global Lombard Automated Decision)

Client

UBS (Swiss Bank Corporation), Switzerland

Duration

(Mar 2016 to May 2018)

Environment

Unix Shell Script, PL/SQL, SQL*Plus, Oracle 12c, TOAD, Control-M, ETL, SSIS, SSRS, Oracle APEX, NOSQL, Forms 10g, Qlikview, JAVA, Jenkins, SVN, JIRA

Details

Credit Risk Management have the modules like Client data, Offering, Collateral Management, Scoring, Decisions & Approval. Creating New Assessment with client data and Validate UBS Business Rules, calculate some specific % Scores for getting approval from CA and Sending data to the Business Process.

Role

Sr. Software Engineer (Oracle PL/SQL Developer)

Responsibilities

  • Assisting with the Business case, Planning and monitoring, eliciting requirements, Requirements organization, Translating and simplifying requirements, Requirements management and communication, Requirements analysis.

  • Preparing BRD and FSD, SRS, and LLD, FS document, To Developed Business architecture using requirements such as Scope, Processes, Alternatives, and risks

  • To Development Database Writing with Procedures, Functions & Packages, and SQL Query Tuning Performances. Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Clients Interactions and Co-Ordinations with Onsite & Offshore Team Supports.

  • Involving fixing of bugs raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

  • Involving fixing of bugs raise while testing of the product the Debugging the PL/SQL Coding using Cassandra’s, PostgreSQL DB tools. Analysis and reporting of testing defects, fixing the bugs.

  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

 

 

Project

PPM Optics SSMO

Client

United Health Group (UHG), USA

Duration

(Sep 2015 to Feb 2016).

Environment

UNIX Shell Scripting, SQL Server 2008, SSIS, SSRS, SVN, JIRA, PL/SQL, ETL, Oracle 11g &12c, TOAD, SQL*Loader, JAVA, GEL, JIRA

Details

UHG provides health care coverage and benefits services. Health benefits and we help build a Stronger, higher quality health system that is sustainable for the long term. PPM Optics SS&MO Time sheet Management were Development & Production Support of Portfolio management, working on Problem tickets, Incident management, Monitoring jobs, and Application Servers, Enhancements, Automation.

Role

Technical Lead (Oracle PL/SQL)

Responsibilities

  • Handling the Project with Clients Interactions and Co-Ordinations with Onsite and Supports.

  • Writing with Procedures, Functions & Packages, SQL Query Tuning Performances.

  • Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.

  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards. Analysis and reporting of testing defects, fixing the bugs.

  • Involving fixing of bugs, raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.

  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Generating the TKPROF report for Analysing Tables and indexes tuning the query.

 

Project

E-Filing Systems of Tax Returns

Client

Centralized Processing Centre (CPC), Income Tax Department (Government of India)

Duration

(Dec 2014 – Aug 2015)

Environment

Unix Shell, SQL*Plus, Oracle 11g & 12c, PL/SQL, TOAD, JAVA, ETL, Informatica - Power Center, SQL Server 2008, SSIS, SSRS, SSAS, SVN, JIRA

Details

Centralized Processing Centre (CPC) is the Department of Indian Income Tax to deploy information technology to carry out regular operations of tax computation and accounting, which based on multiple Income tax and financials acts, income tax rules.

Role

Sr. Oracle PL/SQL Developer.

Responsibilities

  • To Developed the Complex Tax accounting system with the set of rules governed by Income Tax department.

  • Worked on Pre-processing, Account Receivables, Account Payables, and General Ledger Modules of Oracle Applications to account the Processing details of Tax Payer, Development Database Writing with Procedures, Functions & Packages, and SQL Query Tuning.

  • Creation and modification in packages, procedures, functions and other PL/SQL objects. (Hot fix) and Enhancement (Change Requests), Involving ETL Process.

  • Involves creation of objects (Tables, Views, and Synonyms) and data flow logic using stored procedures. Involving in tracking the data base changes, preparation of Unit test cases, Code review of System Test Scripts and Unit Test Cases, creation of Detailed Specification Documents.

 

Project

Premier Farnell Fast Delivery Systems

Client

Farnell Electronics, (UK)

Duration

(June 2011 to Nov 2014).

Environment

UNIX Shell, PL/SQL, TOAD, ETL, SQL Developer, Oracle 9i, 11g &12c, Java, Jenkins, JIRA, C#, SVN, JIRA

Details

Premier Farnell is a global technology leader, with high service distribution of technology products and solutions for design, production, maintenance and repair of electronic system.

Role

Sr. Oracle PL/SQL Developer.

Responsibilities

  • Writing with Procedures, Functions & Packages, SQL Query Tuning Performances. Test data preparation and conditioning, Test case execution.

  • Involving fixing of bugs raise while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools. Analysis and reporting of testing defects, fixing the bugs.

  • Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual, Involving ETL Process.

  • MS-SQL Server 2008 Implementation of Error Logging & Handling, Data Flows, Reporting Services, Advanced SQL Querying & Programming, DB Security and Encryption, SSIS Package Deployment/Management.

  • Created Various Reports according to the Business requirements. Provided support in UAT and Production issues and Running Batch for UAT.

  • Performances of the produce while improving the tuning with explain plain and hints, force the Indexes. Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

 

Project

Flex cube Universal Banking Product Development

Client

Citi Bank, (Australia).

Duration

(Oct 2010-May 2011).

Environment

UNIX Shell Scripting, PL/SQL Developer, Oracle 9i, 10g, TOAD, JAVA, C++, SQL Server 2008, Tarantella, JIRA, SVN

Details

Oracle FLEXCUBE Universal Banking is a real-time, online, comprehensive approach to core banking requirements around the world, covering retail, corporate and investment banking functions. The applications support multi-currency, multi-lingual and multi-entity operations.

Role

Sr. Oracle PL/SQL Developer

Responsibilities

  • Development for Money Marketing, Security and Testing of business applications.

  • Created Procedures, Functions & Packages, SQL Query Tuning Performances, reports to meet the requirement worked on.

  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using Oracle 11G, Cursors and Exception handling, Scheduling jobs with Autopsy’s.

  • Involved in fixing of bugs raised during testing of the product. Debugged the PL/SQL Coding using TOAD, Oracle 9i and 10g tools.

  • Created Procedures, Functions & Packages, Tuning Performances, Unit Testing. Designed and Development of Reports, Running the EOD Batch in SIT.

  • Involved in interacting with the client for clarifications and communicating the changes done at offshore, also uploading the status in the defect review meeting. Booking the Deal and Check for Queue, Upload the Product Process. Generating for E-Dealer reports and FICC Reports.

  • Handled the Project Team with Clients Interactions and Co-Ordinations with Onsite and Supports.

 

Project

Smart Cards Applications Project

Client

Shell Petroleum Company, (Oman)

Duration

(April 2008- July 2010).

Environment

Windows, SAP, PL/SQL Developer, Oracle 9i, 10g, TOAD, SV, JIRA, Forms 7.3, Reports 6i, Crystal Reports

Details

A smart card, typically a type of chip card, was used for filling the fuel and it contains an embedded computer chip (a memory or microprocessor) type that stores and transacts data. This data is usually associated with either value, information, or both and stored/processed within the card's chip. It was different kind of card; similar to Platinum, Cold, Silver Cards, used by the users depends upon the Various Customers.

Role

Sr. Oracle PL/SQL developer

Responsibilities

  • Design, Development, Implementation, and Testing of business applications

  • Involving fixing of bugs raise while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Analysis and reporting of testing defects, fixing the bugs..

  • Involved developing the customer Alpha & SAP Account & Cart Management using Oracle form 7.3 tools.

  • Writing with Procedures, Functions & Packages, SQL Query Tuning Performances, Batch processing, Imports the validated data using SQL Loader.

  • Involved development Generating the reports and data capturing, processing from the various filling Stations generating the report using (DB) ALPHA Server, generating the credit limit, Invoices daily & monthly using SAP Server.

  • Created Various Reports according to the Business requirements. Involving fixing the bugs while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 10g tools.

 

Duration (Sep 2007 to Mar 2008)

Project

JP Morgan Chase PHOENIX (Banking)

Client

JP Morgan Chase (USA)

Environment

UNIX Shell Scripting, Toad, Oracle 9i, JAVA, HTML, PL/SQL Developer tool, Clear case 5.2, JIRA, SVN,

Details

JP MORGAN Chase risk management that refers to the practice of identifying potential risks in advance, analyzing them and taking precautionary steps to reduce/curb the risk. When an entity makes an investment decision, it exposes itself to a number of financial risks.

Role

Sr. Oracle PL/SQL Developer

Responsibilities

  • Involved the creating self-assessment using Phoenix Application tool.

  • Involved the co-ordination with the onsite team and reporting status to the team.

  • Writing with Procedures, Functions & Packages, Tuning Performances, Unit Testing, Designed and Development of Reports.

  • Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual. Enhancement of the existing reports.

  • Documentation of the reports Enhancement of the existing reports.

  • Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual. Provided support in UAT and Production issues and Running Batch for UAT.

 

Project

WWSPS SFDC Tibco Integration (Sales Force dot com).

Client

Cisco Systems, (U.S.A)

Environment

Windows XP, Tibco Designer 5.2, SQL*Plus, Toad, Oracle 10g, and TOAD, PL/SQL. JAVA, Tableau, SVN

Details

Salesforce is the world's leading CRM software and enterprise cloud ecosystem. The Salesforce Customer Success Platform can help your business grow into a more streamlined, effective and efficient organisation across sales, service, marketing and more.

Role

Sr. Oracle PL/SQL Developer

Responsibilities

  • To Developed LTLM Packages, Procedures, Functions code Changes in PL/SQL.

  • Generating DE dupe Reports Winner and Looser Accounts.

  • Involved in Unit test cases for LTLM and working with Performance tuning.

  • Involved the co-ordination with the onsite team and reporting status to the team.

  • Writing with Procedures, Functions & Packages, Tuning Performances, Development of Reports.

  • Enhancement of the existing reports, Support for production Issues for P1, P2 Issues 24/7.

 

Duration (May 2004 - Aug 2007).

Project 1

Commercial Banking Systems.

Client

Lakshmi Vilas Bank, India

Environment

Windows XP, Oracle 8i, forms 5.0, PL/SQL, SQL* Plus, Crystal reports 8.0

Details

A commercial Bank is a type of financial institution that provides services such as accepting deposits, making business loans, and offering basic investment products, customers can take advantage of a range of investment products that commercial banks offer like savings accounts and certificates of deposit.

Role

Programmer

Responsibilities

  • Involved in development of Oracle forms 6i & reports.

  • Involved in working with performance tuning, test and report documents.

  • Test data preparation and conditioning, Test case execution.

 

Project 2

Financial Accounting System,

Client

Shakti Finance Limited, India

Environment

Windows XP, Oracle Forms 6i, PL/SQL, SQL*Plus, Crystal Reports 8.0.

Details

The Financial Accounting System (FAS) is an on-line integrated financial accounting system that records, monitors and maintains all accounting and financial transactions has a separate accounting system.

Role

Programmer

Responsibilities

  • Involved in designing and coding by using Forms 6iand Oracle 9i.

  • Involved in development of Oracle forms & reports.

  • Involved in the preparation test cases of system & unit testing.

  • Test data preparation and conditioning, Test case execution

 

LANGUAGES

  • English

  • Tamil

  • Hindi

A technocrat turned dynamic IT Professional, having over 15 years of rich and insightful experience, including over 6 years of International (Oman, Australia and China) experience, involved in Project Management for Business & Data based Solutions, Data Warehouses, etc and now seeking leadership challenges, utilizing acquired skills/experience to drive IT initiatives to align technology with business objectives to achieve Organizational & Professional Growth.

CORE STRENGTH:

  • Solution Support Service Delivery

  • Web based & Business Solutions

  • Requirement Analysis & Study

  • Enhancing Product functionality

  • Define Technical/Functional Specs.

  • Database Programming/Administration

  • Team & People Management

 

EDUCATION

  • B.E. (Electronics & Communication Engg), from PGP College of Engg. & Technology,

Periyar University, Salem, TN, India (2003) with 70%

  • Diploma (Electrical and Electronics Engg.), from KSR College of Engg & Technology, Board of Technical Education, TN, India (2000), 85%

 

ACCREDITATION

  • Oracle Certified Professional (OCP)

  • Oracle Certified Associate (OCA)

  • Trained in Indian Society for Technical Education

  • Attended workshop/seminar on Database Technology Using Oracle 10g, Business Ethics Seminar and Database Management Systems Seminar

 

TECHNICAL SKILLS

  • Operating Systems: WIN 98/NT/2000/XP, Linux, Unix

  • Languages: SQL Plus, PL/SQL, Shell Scripting

  • Databases: Oracle 9i/10g/11g/12c, DB2, MS SQL Server 2008, PostgreSQL-9.5.1 Apache-Cassandra

  • Data Tool: Erwin 4.3,

  • BI Tools: Power BI, Tableau, SSIS, SSAS, Qlikview,

  • ETL Tools: Informatica Power Center 9., IBM Data stage

  • Data Modeling Tools: Star-Schema Modeling, Snowflakes Modeling, FACT & Dimension Modeling,

  • Other Tools: Job Scheduler Control-M, Oracle RAC, Data Guard, Forms 10g

  • Reporting Tools: SSRS, Reports 6i

  • Version Tools: SVN, CVS, GIT

  • Project Tool: JIRA

 

AWARD :

Best Performer by Client (Shell Petroleum) throughout the Project, Especially During my travel to OMAN for Developed & Supporting the Client to Deliver the Product to the User in Go Live.

Anonymous

Summary

Posted: 15 April 2019

Location:  Sydney, NSW

Professional area:

  • IT
Find quickly
Send to employers

Sr. System Analyst/Oracle DBA/ETL/PLSQL Developer

Summary

Posted: 15 April 2019

Location:  Sydney, NSW

Professional area:

  • IT

PROFILE HIGHLIGHTS:

  • A self-motivated and proactive IT- Software Development with successful track record of Managing Projects, Involving planning, scheduling, tracking and reporting as well as documentation of BRD/FSD, SRS, LLD, FS and Including Problem and Incident management.

  • 10+ years of IT Experience as a Technical Lead/Software Engineer involved in requirements gathering, Analysis, Design (Modelling, Migration, Mapping), Development, Implementation, troubleshooting, unit testing, production deployment and support.

  • Exclusive experience in Project Scoping, Planning, Quality & Risk management, Communication between project stakeholders.

  • Creating the databases (DDL, DML, DCL & TCL) and table spaces, Developed logical and physical data models for schemas using Erwin, database objects such as tables, views, synonyms, Indexes,

  • Writing complex queries, SQL*Plus, Stored procedures, functions, PL/SQL packages, triggers and cursors, exception handling for retrieving, Bulk Binds and Collections, UTI_FILE packages, Creating Snapshots views, API Packages, and Schema Database Objects using SQL and PL/SQL.

  • Good knowledge of Performance tuning Memory Issues from OS, Database Application level related futures such as Query Optimizer (CBO), Explain Plan, SQL Trace & DBMS_STATES, Generating & Analysing TKPROF & AWR, ASH reports, Statistics, hints, SQL Profiler, ADDM, OEM, DBMS_PROFILER etc.

  • Customs Migrations from flat files in to table using SQL*Loader, Data bump, RMAN, Golden gate for Import & Exports.

  • Good Experience of Operation & Supports in Problem and Incident management, Resolving Tickets within (SLA) using Tivoli/TWS scheduling Jobs Control-M, Autopsy’s and bringing issues to the closure during product SIT & UAT and Production support 24*7.

  • Database Administrator (DBA) with Grid DB, Oracle RAC, Data guard, RMAN, ASM, Exadata Physical database design, Database maintenance, Patching, Backup and recovery, DB links and privileges, Data Replication, Repository Management, Security administration, Database loading.

  • 6 years Strong Experience in BI & Data warehouse like data mart, data model, data mapping, design and implementation of ETL Workflow using Informatica and IBM Data stage, ODI tools, Worked SQL(T-SQL). Created SSIS, SSRS and SSAS Packages.

  • Familiarity with Visualization and reporting tools (Power BI, Tableau Qlikview, Qliksence, OBIEE, ODI, Continuous integration using SSDT and Jenkins Automation tool.

  • Good Knowledge of Big Data framework and No-SQL Apache-Cassandra, Mongo DB, PostgreSQL-9.5.1 version.

  • Java - excellent core understanding and low-level programming, Oracle Apex 4.0, HTML, CSS & Java Scripts, Oracle forms 10g, reports 6i.

  • 6 years of onsite experience working at Oman, Australia, China (HK), and Switzerland with clients.

  • 5+ year’s Functional expertise in Oracle Flex-cube, FinnOne™ Lending product including Financial (GL, AA, AP, AR, CM, FA) Modules.

  • Working with Fundamental of Risk Managements Credit Risk, Operation Risk, Market Risk, Country Risk, and Basel 1-2-3.

 

SERVICE PRACTICE:

  • Banking & Financial services, Securities, Investments and Insurance, Healthcare, Sales force (SFDC), EBS (ERP, SCM, CRM) Domains.

 

CAREER GRAPH:

Sr. Software Engineer (Oracle PL/SQL Developer) (Mar 2016 to May 2018)

EPAM SYSTEMS, INC., SHENZHEN, CHINA

Accountabilities:

  • Participated in development of Database Writing with Procedures, Functions & Packages and SQL Query Tuning Performances along with Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Assisted in Requirements Management, including elicitation/organizing requirements, translated & simplified requirements, analysis, creation of Business Case along with planning and monitoring.

  • Prepared all necessary project documents like BRD/FSD, SRS, LLD, and FS as well as created Business architecture using requirements such as Scope, Processes, Alternatives and Risks.

  • SQL Query Tuning Performances related futures such as Query Optimizer (CBO), table partitions, Explain Plan, SQL Trace & DBMS_STATES, Generating & Analyzing TKPROF & AWR reports

  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Trouble shot the bugs raised during testing of the products, by debugging the PL/SQL coding using TOAD, Oracle 9i/11g tools, Apache Cassandra, PostgreSQL DB tools, etc.

  • Loaded data into Data Warehouse, after creating various SSIS packages and used the same like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task, etc.

 

Technical Lead (Oracle PL/SQL) (Sep 2015 to Feb 2016)

INFINITE COMPUTER SOLUTIONS (P) LTD., BANGALORE, INDIA

Accountabilities:

  • Led a project for an international healthcare client for Development & Production Support, by resolution of Problem tickets, Incident management, etc.

  • Prepared all necessary project documents like BRD/FSD, SRS, LLD, and FS as well as created Business architecture using requirements such as Scope, Processes, Alternatives and Risks.

  • Executed the project, communicating with clients as well as coordination with the On-site and Support teams for monitoring jobs/application servers.

  • Participated in development of Procedures, Functions & Packages, as well as performance tuning of SQL Query and scheduling Database Full Backup, Transaction log backup & differential backup in daily Routine.

  • Diagnosed/tuned the server optimal performance using SQL Server 2008, SQL Profiler & Database Engine Tuning Wizards, while developed Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Engaged, further, in fixing of bugs raised during testing of the product, by the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

 

Sr. Oracle PL/SQL Developer (Dec 2014 to Aug 2015)

INFOSYS TECHNOLOGIES (P) LTD., BANGALORE, INDIA

Accountabilities:

  • Participated in a project for digital transformation of Centralized Processing Centre (CPC) in Department of Indian Income Tax by development of Complex Tax Accounting System, abiding with a set of rules.

  • Developed/enhanced packages, procedures, functions and other PL/SQL objects as well as Enhancement (Hot Fix/Change Requests), involving ETL Process.

  • Worked on Pre-processing, Account Receivables, Account Payables and General Ledger Modules of Oracle Applications, to account Processing details of Tax Payer.

  • Engaged in the Migration of SQL Server doing schema re-engineering conversion of TSQL Stored-Procedure to Oracle PL/SQL, along with Transformation of all MS-SQL Data table to Oracle.

  • Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

  • Additionally participated in multiple tasks - monitoring of data base changes, creating/review of Unit test Cases, Code review of System Test Scripts and detailed Specification Documents.

 

Sr. Oracle PL/SQL Developer (Jun 2011 to Nov 2014)

JNS Tech Solutions (P) Ltd., HYDERABAD, India

Accountabilities:

  • Participated in a project for an international technology leader with high service distribution of technology products and solutions for electronic system, with the responsibilities of development of Procedures, Functions & Packages, SQL Query Tuning Performances, Test Data/Test Case (including execution), various Reports according to the Business requirements, etc as well as resolution of errors raised while testing of the product and reporting of testing defects

 

Sr. Oracle PL/SQL Developer (Oct 2010-May 2011)

Oracle Financial Software Services (P) Ltd., SYDNEY, Australia

Accountabilities:

  • Participated in a project for an international bank at Australia, to implement Oracle FLEXCUBE Universal Banking (covering retail, corporate and investment banking functions), with the responsibilities of developing Money Marketing & Security functions, testing of the application, creating Procedures/Functions & Packages/SQL Query Tuning Performances/Reports, to meet the requirement, development of complex database objects like Stored Procedures, Functions, Packages and Triggers as well as fixing bugs raised while testing of the product.

 

PERVIOUS EXPERIENCE:

  • IITC LLC. (OHI GROUP), MUSCAT, OMAN as SR. ORACLE DEVELOPER (APR 2008 TO JUL 2010)

  • SYNOVA INNOVATIVE TECHNOLOGIES (P) LTD., BANGALORE as SR. SOFTWARE ENGINEER (SEP 2007 TO MAR 2008)

  • SANSPAREIL SOFT SOLUTIONS (P) LTD., COIMBATORE as PROGRAMMER (MAY 2004 TO AUG 2007)

 

PROJECT SUMMARY

Project

UBSJ CRISS- (GLAD - Global Lombard Automated Decision)

Client

UBS (Swiss Bank Corporation), Switzerland

Duration

(Mar 2016 to May 2018)

Environment

Unix Shell Script, PL/SQL, SQL*Plus, Oracle 12c, TOAD, Control-M, ETL, SSIS, SSRS, Oracle APEX, NOSQL, Forms 10g, Qlikview, JAVA, Jenkins, SVN, JIRA

Details

Credit Risk Management have the modules like Client data, Offering, Collateral Management, Scoring, Decisions & Approval. Creating New Assessment with client data and Validate UBS Business Rules, calculate some specific % Scores for getting approval from CA and Sending data to the Business Process.

Role

Sr. Software Engineer (Oracle PL/SQL Developer)

Responsibilities

  • Assisting with the Business case, Planning and monitoring, eliciting requirements, Requirements organization, Translating and simplifying requirements, Requirements management and communication, Requirements analysis.

  • Preparing BRD and FSD, SRS, and LLD, FS document, To Developed Business architecture using requirements such as Scope, Processes, Alternatives, and risks

  • To Development Database Writing with Procedures, Functions & Packages, and SQL Query Tuning Performances. Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Clients Interactions and Co-Ordinations with Onsite & Offshore Team Supports.

  • Involving fixing of bugs raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

  • Involving fixing of bugs raise while testing of the product the Debugging the PL/SQL Coding using Cassandra’s, PostgreSQL DB tools. Analysis and reporting of testing defects, fixing the bugs.

  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

 

 

Project

PPM Optics SSMO

Client

United Health Group (UHG), USA

Duration

(Sep 2015 to Feb 2016).

Environment

UNIX Shell Scripting, SQL Server 2008, SSIS, SSRS, SVN, JIRA, PL/SQL, ETL, Oracle 11g &12c, TOAD, SQL*Loader, JAVA, GEL, JIRA

Details

UHG provides health care coverage and benefits services. Health benefits and we help build a Stronger, higher quality health system that is sustainable for the long term. PPM Optics SS&MO Time sheet Management were Development & Production Support of Portfolio management, working on Problem tickets, Incident management, Monitoring jobs, and Application Servers, Enhancements, Automation.

Role

Technical Lead (Oracle PL/SQL)

Responsibilities

  • Handling the Project with Clients Interactions and Co-Ordinations with Onsite and Supports.

  • Writing with Procedures, Functions & Packages, SQL Query Tuning Performances.

  • Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.

  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards. Analysis and reporting of testing defects, fixing the bugs.

  • Involving fixing of bugs, raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.

  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.

  • Generating the TKPROF report for Analysing Tables and indexes tuning the query.

 

Project

E-Filing Systems of Tax Returns

Client

Centralized Processing Centre (CPC), Income Tax Department (Government of India)

Duration

(Dec 2014 – Aug 2015)

Environment

Unix Shell, SQL*Plus, Oracle 11g & 12c, PL/SQL, TOAD, JAVA, ETL, Informatica - Power Center, SQL Server 2008, SSIS, SSRS, SSAS, SVN, JIRA

Details

Centralized Processing Centre (CPC) is the Department of Indian Income Tax to deploy information technology to carry out regular operations of tax computation and accounting, which based on multiple Income tax and financials acts, income tax rules.

Role

Sr. Oracle PL/SQL Developer.

Responsibilities

  • To Developed the Complex Tax accounting system with the set of rules governed by Income Tax department.

  • Worked on Pre-processing, Account Receivables, Account Payables, and General Ledger Modules of Oracle Applications to account the Processing details of Tax Payer, Development Database Writing with Procedures, Functions & Packages, and SQL Query Tuning.

  • Creation and modification in packages, procedures, functions and other PL/SQL objects. (Hot fix) and Enhancement (Change Requests), Involving ETL Process.

  • Involves creation of objects (Tables, Views, and Synonyms) and data flow logic using stored procedures. Involving in tracking the data base changes, preparation of Unit test cases, Code review of System Test Scripts and Unit Test Cases, creation of Detailed Specification Documents.

 

Project

Premier Farnell Fast Delivery Systems

Client

Farnell Electronics, (UK)

Duration

(June 2011 to Nov 2014).

Environment

UNIX Shell, PL/SQL, TOAD, ETL, SQL Developer, Oracle 9i, 11g &12c, Java, Jenkins, JIRA, C#, SVN, JIRA

Details

Premier Farnell is a global technology leader, with high service distribution of technology products and solutions for design, production, maintenance and repair of electronic system.

Role

Sr. Oracle PL/SQL Developer.

Responsibilities

  • Writing with Procedures, Functions & Packages, SQL Query Tuning Performances. Test data preparation and conditioning, Test case execution.

  • Involving fixing of bugs raise while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools. Analysis and reporting of testing defects, fixing the bugs.

  • Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual, Involving ETL Process.

  • MS-SQL Server 2008 Implementation of Error Logging & Handling, Data Flows, Reporting Services, Advanced SQL Querying & Programming, DB Security and Encryption, SSIS Package Deployment/Management.

  • Created Various Reports according to the Business requirements. Provided support in UAT and Production issues and Running Batch for UAT.

  • Performances of the produce while improving the tuning with explain plain and hints, force the Indexes. Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

 

Project

Flex cube Universal Banking Product Development

Client

Citi Bank, (Australia).

Duration

(Oct 2010-May 2011).

Environment

UNIX Shell Scripting, PL/SQL Developer, Oracle 9i, 10g, TOAD, JAVA, C++, SQL Server 2008, Tarantella, JIRA, SVN

Details

Oracle FLEXCUBE Universal Banking is a real-time, online, comprehensive approach to core banking requirements around the world, covering retail, corporate and investment banking functions. The applications support multi-currency, multi-lingual and multi-entity operations.

Role

Sr. Oracle PL/SQL Developer

Responsibilities

  • Development for Money Marketing, Security and Testing of business applications.

  • Created Procedures, Functions & Packages, SQL Query Tuning Performances, reports to meet the requirement worked on.

  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using Oracle 11G, Cursors and Exception handling, Scheduling jobs with Autopsy’s.

  • Involved in fixing of bugs raised during testing of the product. Debugged the PL/SQL Coding using TOAD, Oracle 9i and 10g tools.

  • Created Procedures, Functions & Packages, Tuning Performances, Unit Testing. Designed and Development of Reports, Running the EOD Batch in SIT.

  • Involved in interacting with the client for clarifications and communicating the changes done at offshore, also uploading the status in the defect review meeting. Booking the Deal and Check for Queue, Upload the Product Process. Generating for E-Dealer reports and FICC Reports.

  • Handled the Project Team with Clients Interactions and Co-Ordinations with Onsite and Supports.

 

Project

Smart Cards Applications Project

Client

Shell Petroleum Company, (Oman)

Duration

(April 2008- July 2010).

Environment

Windows, SAP, PL/SQL Developer, Oracle 9i, 10g, TOAD, SV, JIRA, Forms 7.3, Reports 6i, Crystal Reports

Details

A smart card, typically a type of chip card, was used for filling the fuel and it contains an embedded computer chip (a memory or microprocessor) type that stores and transacts data. This data is usually associated with either value, information, or both and stored/processed within the card's chip. It was different kind of card; similar to Platinum, Cold, Silver Cards, used by the users depends upon the Various Customers.

Role

Sr. Oracle PL/SQL developer

Responsibilities

  • Design, Development, Implementation, and Testing of business applications

  • Involving fixing of bugs raise while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.

  • Analysis and reporting of testing defects, fixing the bugs..

  • Involved developing the customer Alpha & SAP Account & Cart Management using Oracle form 7.3 tools.

  • Writing with Procedures, Functions & Packages, SQL Query Tuning Performances, Batch processing, Imports the validated data using SQL Loader.

  • Involved development Generating the reports and data capturing, processing from the various filling Stations generating the report using (DB) ALPHA Server, generating the credit limit, Invoices daily & monthly using SAP Server.

  • Created Various Reports according to the Business requirements. Involving fixing the bugs while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 10g tools.

 

Duration (Sep 2007 to Mar 2008)

Project

JP Morgan Chase PHOENIX (Banking)

Client

JP Morgan Chase (USA)

Environment

UNIX Shell Scripting, Toad, Oracle 9i, JAVA, HTML, PL/SQL Developer tool, Clear case 5.2, JIRA, SVN,

Details

JP MORGAN Chase risk management that refers to the practice of identifying potential risks in advance, analyzing them and taking precautionary steps to reduce/curb the risk. When an entity makes an investment decision, it exposes itself to a number of financial risks.

Role

Sr. Oracle PL/SQL Developer

Responsibilities

  • Involved the creating self-assessment using Phoenix Application tool.

  • Involved the co-ordination with the onsite team and reporting status to the team.

  • Writing with Procedures, Functions & Packages, Tuning Performances, Unit Testing, Designed and Development of Reports.

  • Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual. Enhancement of the existing reports.

  • Documentation of the reports Enhancement of the existing reports.

  • Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual. Provided support in UAT and Production issues and Running Batch for UAT.

 

Project

WWSPS SFDC Tibco Integration (Sales Force dot com).

Client

Cisco Systems, (U.S.A)

Environment

Windows XP, Tibco Designer 5.2, SQL*Plus, Toad, Oracle 10g, and TOAD, PL/SQL. JAVA, Tableau, SVN

Details

Salesforce is the world's leading CRM software and enterprise cloud ecosystem. The Salesforce Customer Success Platform can help your business grow into a more streamlined, effective and efficient organisation across sales, service, marketing and more.

Role

Sr. Oracle PL/SQL Developer

Responsibilities

  • To Developed LTLM Packages, Procedures, Functions code Changes in PL/SQL.

  • Generating DE dupe Reports Winner and Looser Accounts.

  • Involved in Unit test cases for LTLM and working with Performance tuning.

  • Involved the co-ordination with the onsite team and reporting status to the team.

  • Writing with Procedures, Functions & Packages, Tuning Performances, Development of Reports.

  • Enhancement of the existing reports, Support for production Issues for P1, P2 Issues 24/7.

 

Duration (May 2004 - Aug 2007).

Project 1

Commercial Banking Systems.

Client

Lakshmi Vilas Bank, India

Environment

Windows XP, Oracle 8i, forms 5.0, PL/SQL, SQL* Plus, Crystal reports 8.0

Details

A commercial Bank is a type of financial institution that provides services such as accepting deposits, making business loans, and offering basic investment products, customers can take advantage of a range of investment products that commercial banks offer like savings accounts and certificates of deposit.

Role

Programmer

Responsibilities

  • Involved in development of Oracle forms 6i & reports.

  • Involved in working with performance tuning, test and report documents.

  • Test data preparation and conditioning, Test case execution.

 

Project 2

Financial Accounting System,

Client

Shakti Finance Limited, India

Environment

Windows XP, Oracle Forms 6i, PL/SQL, SQL*Plus, Crystal Reports 8.0.

Details

The Financial Accounting System (FAS) is an on-line integrated financial accounting system that records, monitors and maintains all accounting and financial transactions has a separate accounting system.

Role

Programmer

Responsibilities

  • Involved in designing and coding by using Forms 6iand Oracle 9i.

  • Involved in development of Oracle forms & reports.

  • Involved in the preparation test cases of system & unit testing.

  • Test data preparation and conditioning, Test case execution

 

LANGUAGES

  • English

  • Tamil

  • Hindi

A technocrat turned dynamic IT Professional, having over 15 years of rich and insightful experience, including over 6 years of International (Oman, Australia and China) experience, involved in Project Management for Business & Data based Solutions, Data Warehouses, etc and now seeking leadership challenges, utilizing acquired skills/experience to drive IT initiatives to align technology with business objectives to achieve Organizational & Professional Growth.

CORE STRENGTH:

  • Solution Support Service Delivery

  • Web based & Business Solutions

  • Requirement Analysis & Study

  • Enhancing Product functionality

  • Define Technical/Functional Specs.

  • Database Programming/Administration

  • Team & People Management

 

EDUCATION

  • B.E. (Electronics & Communication Engg), from PGP College of Engg. & Technology,

Periyar University, Salem, TN, India (2003) with 70%

  • Diploma (Electrical and Electronics Engg.), from KSR College of Engg & Technology, Board of Technical Education, TN, India (2000), 85%

 

ACCREDITATION

  • Oracle Certified Professional (OCP)

  • Oracle Certified Associate (OCA)

  • Trained in Indian Society for Technical Education

  • Attended workshop/seminar on Database Technology Using Oracle 10g, Business Ethics Seminar and Database Management Systems Seminar

 

TECHNICAL SKILLS

  • Operating Systems: WIN 98/NT/2000/XP, Linux, Unix

  • Languages: SQL Plus, PL/SQL, Shell Scripting

  • Databases: Oracle 9i/10g/11g/12c, DB2, MS SQL Server 2008, PostgreSQL-9.5.1 Apache-Cassandra

  • Data Tool: Erwin 4.3,

  • BI Tools: Power BI, Tableau, SSIS, SSAS, Qlikview,

  • ETL Tools: Informatica Power Center 9., IBM Data stage

  • Data Modeling Tools: Star-Schema Modeling, Snowflakes Modeling, FACT & Dimension Modeling,

  • Other Tools: Job Scheduler Control-M, Oracle RAC, Data Guard, Forms 10g

  • Reporting Tools: SSRS, Reports 6i

  • Version Tools: SVN, CVS, GIT

  • Project Tool: JIRA

 

AWARD :

Best Performer by Client (Shell Petroleum) throughout the Project, Especially During my travel to OMAN for Developed & Supporting the Client to Deliver the Product to the User in Go Live.

Send a message

Could you help us?

JobsGalore is a young project. Could you help us? Could you tell your friends about us? Please share a link to JobsGalore.

Thank you in advance

  • About us
  • Contact us
  • Terms and Conditions
  • Privacy policy
Connect With Us:
  • Connect With Us:
© JobsGalore All rights reserved.