Ashish Sinha

addbz8@r.postjobfree.com 720-***-****

PROFESSIONAL SUMMARY

•Senior Oracle PL/SQL Developer with 10+ years of experience in software development projects

•Proficiency in Unix/Linux environments, Oracle PL/SQL Development in versions 9i, 10g, 11g and 12c and SQL Server 2005 and 2010.

•Strong knowledge in Query Tuning and Performance Tuning.

•OCA certified Professional.

•Strong knowledge in Oracle’s Underlying Architecture.

•Expertise in data migration tools SQL* Loader, Import/ Export and Batch processing.

•Expertise in OLTP and OLAP, Data warehousing, Data modeling and reporting tools. Knowledge in implementations.

•Expert to work with partitioning of tables and indexes for better data retrieval performance from large datasets.

•Extensively used various techniques in Performance Tuning and Optimization like Hints, Indexes, Explain Plan, Trace Utility and TKPROF.

•Good experience in Data Migration techniques using Oracle External Tables, SQL* Loader, Import/Export and Batch Processing.

•Understanding in various components of ETL using Informatica PowerCenter.

•Experience in all phases of SDLC, starting from requirement gathering, solution definition, design, build and Quality Assurance (QA) and deployment, required for the successful execution of the project.

•Best practices of Waterfall, Agile and ITIL models are used in the execution of Development and Maintenance of Projects.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Informatica ETL Tool, Oracle Forms and Reports 8i, UNIX Shell Scripting,

Databases: Oracle 9i, 10g, 11g, 12c, 18 c

Operating System: UNIX, Windows

Version Controlling: GitHub, SVN, SCCS, TFS

Tools and Utilities: PL/SQL DEVELOPWER, Toad, SQ Developer, SQL Loader, HP Service, Jira, Slack, Service-Now, Informatica PowerCenter, WinSCP, FileZilla, Putty, SQR, SOAP UI

EDUCATIONAL BACKGROUND

Bachelor’s in technology (Electronics & Instrumentation) GANDHI INSTITUTE OF ENGG & TECHNOLOGY, Orrisa, India

PROJECT PROFILE:

Project Title

DNA

Client

Fiserv Global Services

Period

July-2017 – Till date

Description

This project is developed mainly for the credit unions and banks. It is subdivided into loan and deposit modules. While the deposit modules work for TD and saving, the loan modules handles diverse loan products. The front end is developed on .NET and the backend coding is all Oracle PLSQL making the system still better in performance.

Role

PL/SQL ANALYST

Location

Noida-62, INDIA- (Glastonbury CT)- USA

Responsibilities

Development of different API used in DNA loan and deposit with various Database objects using PL/SQL for Oracle 11g, 12c database.

Work with complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions and Ora_xml to create the integration routines.

Work extensively with Composite datatypes Nested tables, Arrays, Records using Bulk collect to deal with the large number of records in banking transaction

Create High & Low-level technical document for the various modules of projects. Review the design to ensure adherence to standards, templates and corporate guidelines. Validate design specifications against the results from proof of concept and technical considerations.

For application enhancements carry out requirements and System analysis, Design, coding, of PL-SQL scripts, Packages, Stored Procedures, Functions, triggers, tables and views in Oracle 12c and 11g Database versions.

Provide support during the integration testing and User Acceptance phase of the project. Also provide hyper care support post deployment.

Using SQR for generating Report.

Leading the scrum calls.

Coordinate deployment of applications in UAT/Production environments. Additionally, provide application-level support for UAT.

Carry out performance tuning for the DB objects whose performance is below SLA definitions.

Working closely with .Net developer and check the application performance

Project Title

DCB MIGRATION

Client

Nucleus Software

Period

Jan-2015 – July 2017

Description

This project is developed to maintain the LMS (loan management system) of DCB Bank. DATA is Migrated from older finnone application to FINNEON application using Informatica Power Center writing different transformation.

Role

Senior Developer

Location

Noida Sector 62, INDIA

Responsibilities

writing complex subprograms like packages, functions, procedures, Triggers using both static and dynamic datatype like varray, tables, records, objects.

Debugging the code using debugger and analyzing the performance

Using Informatica Power center to Migrate the data from FINNONE to Finnneo, Writing the Mapping using Various Transformation Used in Informatica.

Involved in Data modelling of Finneo application and performed the Migration on Datawarehouse module

Implementation of Finneo In DCB BANK

support during the integration testing and User Acceptance phase of the project. Also provide hyper care support post deployment.

Create Change Requests (CR’s for UAT/Production implementation of application changes.

Coordinate deployment of applications in UAT/Production environments. Additionally, provide application-level support for UAT.

Carry out performance tuning for the DB objects whose performance is below SLA definitions in Oracle 12c and 11g environments.

Project Title

Proof Of Delivery

Client

L.G

Period

March -2014 – Dec-2014

Description

This project is developed to maintain the POD (prrof of delivery) of stock, fixed asset and pallet Report of the various place, branch and warehouse across LG users. The documents is uploaded in oracle database and is visible to the admin The project also uses the feature to send mail through oracle as well as mapping of various warehouse with place and branch which is done through use of collection

Role

Software Developer

Location

Grater Noida India, INDIA

Responsibilities

Writing packages, procedures, function, triggers, using collection for plsql codes to provide the Output on the frontend

Use of sql-loader and writing pl/sql program to load data into interface table.

Use of Utl_file for creating flat file on unix server and also used DBMS_LOB package for uploading images into database.

Interact with other teams (helpdesk, hardware support teams, network support teams etc.) to bring the best resolutions to the issues faced by users.

Provide support during the integration testing and User Acceptance phase of the project. Also provide hyper care support post deployment.

Create Change Requests (CR’s for UAT/Production implementation of application changes.

Coordinate deployment of applications in UAT/Production environments. Additionally, provide application-level support for UAT.

Project Title

Karma

Client

Orange Business Services

Period

July 12 to march 14

Description

This project designed for customer s Device management For the customers in France and other European countries. Day - day management of devices like firmware up gradation configuration upgradation is done through this project. This project contains various modules like conf module for configuration update, Rules for Firmware update etc. The Device automatically connects to Karma in a scheduled time to get it’ s upgrade.

Role

Associate Engineer

Location

Gurgaon, INDIA

Responsibilities

Providing operational support and production support

Generating reports through SQL queries. : working with cursors and exception handling..

For application enhancements carry out requirements and System analysis, Design, coding, and testing of PL-SQL scripts, Packages, Stored Procedures, Functions, triggers, tables and views.

Carry out performance tuning of queries in SQL for slow running database reports and processes.

Interact with other teams (helpdesk, hardware support teams, network support teams etc.) to bring the best resolutions to the issues faced by users.

Provide support during the integration testing and User Acceptance phase of the project. Also provide hyper care support post deployment.

Create Change Requests (CR’s for UAT/Production implementation of application changes.

Coordinate deployment of applications in UAT/Production environments. Additionally, provide application-level support for UAT.

Project Title

Bhart airtel (Postpaid Billing)

Client

Bharti Airtel

Period

Sep 2010 July 2012

Description

This project handles postpaid billing for airtel pan India

Role

System Engineer

Location

Noida Sec 62

Responsibilities

Providing operational support and production support

Developing tools for better monitoring and performance of the application.

L2 On-call weekday and weekend support.

Create High & Low-level design document for the various modules. Review the design to ensure adherence to standards, templates and corporate guidelines. Validate design specifications against the results from proof of concept and technical considerations.

For application enhancements carry out requirements and System analysis, Design, coding, and testing of PL-SQL scripts, Packages, Stored Procedures, Functions, triggers, tables and views on Oracle 11g Database.

Carry out performance tuning of queries in SQL for slow running database reports and processes.

Monitor and configure Workflows in Informatica Workflow Manager as necessary which carries out ETL operations from Teradata Database to Oracle 11g Database.

Configuration Management, Documentation, detection of bugs and suggest solutions.

Addressing the queries raised by Business users

Provide support during the integration testing and User Acceptance phase of the project.

Address: 7600 E caley Ave, Greenwood village Colorado Denver.

Linkedln: https://www.linkedin.com/in/ashish-sinha-560b1219/

Blog : https://sinhaashish4u.wixsite.com/website/blog

Stackoverflow: https://stackoverflow.com/users/2940216/ashish-sinha

Contact this candidate