GIRISH PALIWAL

Key Skills : Oracle PL/SQL,Informatica,Unix

Norristown PA-19403, USA

Contact: +1-484-***-****; Email: adi7kw@r.postjobfree.com;

LinkedIn profile:linkedin.com/in/girish-paliwal-291a695a

Visa Status: H1B with Visa till Aug 2021

Summary

Technically competent IT Professional with over 9+ years of experience in ensuring projects to successful on time deliveries of applications that include analysis, design, development, implementation, documentation, Unit testing,issue resolution, Production support skills.

Adept at all phases of Software Development Life Cycle and Agile Process including Analysis, Program Design, Development, Unit & Integrated Testing, Maintenance, enhancements, post-implementation maintenance, and production support Performance Tuning, Documentation,etc. across Banking and Financial Services.

Experienced Oracle PL/SQL Developer with good knowledge in Basic UNIX Commands/Shell Script.

Proficient with languages like ORACLE SQL, PL/SQL; Tools like: Toad,PL/SQL Developer v4.3,HTML(Web Application),SQL Developer v4.0,Rally,Service Now, SQL plus & Database: Oracle 9i/10g/11g/12c Using Windows and Unix Platform; recognized as a hands-on, proactive troubleshooter who can rapidly identify technical problems, initiate change & implement effective business requirements in project.

Effective analytical and communication skills, verbal as well as written coupled with presentation skills having ability to perform as per expectations.

Technical Skills:

Databases: Oracle 9i/10g/11g/12c/19c

Languages: SQL, PL/SQL, Shell Scripting (Linux), HTML

Tools: Informatica Powercenter 9.6.1, Toad, PL/SQL Developer v4.3/v4.0, SQL plus, Rally, Service Now,GitHub, Control-M Job Scheduling,Jira,Putty,WinSCP

Operating System: Windows (XP, 7, 10), UNIX

Professional Experience

Client: SEI, USA

Employer: Coforge (NIIT Technologies USA)

Location: PA,USA

Role: Sr. Software Engineer/Systems Analyst

Domain: Investment Banking

Duration:November 2016 – Present

Projects Title: SEI-SWP Custom Interface (System Integration) Team

Description: SWP an initiative taken by SEI to build new wealth management platform that allowed SEI to support the existing services around investment processing. SEI-SWP Custom Interface involved in development of PL/SQL code as per business and functional requirements following the Agile process to generate outbound extract file for Bank and Advisor in different EDB Environment and that files were consumed by Client system in Production environment on scheduled basis.

My responsibilities:

Responsible for end-to-end development of application including, ascertaining the requirement, analysis, designing, coding, Code enhancement, Bug fix, code reviewing, testing and debugging, Run book creation, Production support including Job setup of several software applications.

Developed/Reviewed PL/SQL Code (Package/Procedure/Function/Performance Tuning (Using Oracle Hints) /Cursor/Analytic function etc.) for different Interface of Advisors & Banks for US and UK Market & develop Common Utility Package to minimize the No. of Code line & maximize performance and support inbound/outbound files processed via Informatica ETL Jobs.

Accountable for fixing all the bugs reported by the testers, conducting POC on issues created after testing and ensure smooth implementation of the project.

Participating in stages of Production live support and maintenance, Analysis, enhancement of code, new implementation via CHG/INC/PRB/Feature.

Participating in schema preparation task like designing of DDL, off system file (CSV Format) Data loading through Control file in Intermediate tables, creation of synonyms etc.

Involved in performance tuning in code for proper execution of code in Production; proactively fixed the issue raised in production due to data dependency within define timeline.

Coordination off shore and onsite team.

Client: SEI, USA

Employer: Coforge (NIIT Technologies India)

Location:Greater Noida,India

Role: PL/SQL Developer/Sr. Software Engineer

Domain: Investment Banking

September 2016 – November 2016

Projects Title: SEI-SWP Custom Interface Team

My responsibilities:

Participating in knowledge Sharing sessions based on Domain and application specific.

Participating in stages like requirement analysis, database design, Developed/Reviewed PL/SQL Code (Package/Procedure/Function) for different Interface of Advisors & Banks.

Client: RBS – India (Royal Bank of Scotland)

Employer: TCS (TATA Consultancy Services-India)

Location: Gurgaon,India

Role: Oracle PL/SQL Developer/Systems Engineer

Duration:March 2016 – September 2016

Domain: Banking (Risk Management)

Description: Risk Management (GRDW) involves in analyzing and loading the Source data in Oracle EDB and development of PL/SQL code for source data to generate output extract files with proper Business Validation which act as downstream for other systems and finally used by business to analyze the liquidity status of a particular assets.

My responsibilities include:

Interacting with client for requirement gathering,Analysis of Source data and develop PL/SQL Code (Package/Procedure/Function/Cursor/Analytic Function/Collection/Records etc.) to generate extract files consumed by other system and used by Business to analyze the liquidity status .

Developed the Unit test cases and proactively fixed the issue raised by QA Team.

Involved in performance tuning of code for proper execution of code in application.

Client: RBS – India (Royal Bank of Scotland)

Employer: TCS (TATA Consultancy Services-India)

Location: Gurgaon,India

Role: Unix and Oracle PL/SQL Developer/ Systems Engineer

Domain: Banking - AML (Anti Money Laundering)

Duration:August 2015 – February 2016

Project Title: Filter Quality Assurance (AML-Filtering)

Description: Filter Quality Assurance involves in creation or modification and executing the Scripts in UNIX Platform for different filters (SAAEMEA/CIB/SAAAPAC)provided by FircoSoft to filter out Suspicious Transaction in Real Environment.

My responsibilities include:

Created Scripts based on Unix Platform to automate manual runs activities of different filters (SAAEMEA/CIB/SAAAPAC) to minimize the manual efforts and cost.

Executing manual runs and involve in Unit testing using UNIX scripts to generate the output files corresponding to inputs files (contain Transaction Details) and LRR files (contain Business logics)for different filters (SAAEMEA/CIB/SAAAPAC).

Modification and maintaince of scripts in Unix Platform for different filter version as per requirement of client.

Client: SEI, USA

Employer: Coforge (NIIT Technologies India)

Location: Greater Noida,India

Role: PL/SQL Developer/Sr.Software Engineer

Domain: Investment Banking

Duration:September 2013 – July 2015

Description: SEI-GWMP Data Migration involves in analyzing the client data and development of PL/SQL code for migration of client data from mainframe based system Trust 3000 (T3k) to Oracle EDB data base as per SEI-GWMP Standard with proper Business Validation. Also, ensure that Data integrity should be maintained in EDB.

My responsibilities include:

Managing implementation of banks & advisors in SWP.

Analyzed the Business requirements& Client Raw Data develop PL/SQL code (Package/Procedure/Function/Performance Tuning (Using Oracle Hints)/Cursor/Analytic function etc.) Migration of client data into Oracle EDB tables.

Data loading for .txt or .csv files through Control file in Intermediate tables of migration.

Developed the Unit test cases for business & Load Validation and provide knowledge sessions to peers and new members of the team and to review their code and documents.

Also worked on DBA Activity, like creation of Data base objects (Tables, Synonyms, assigning privileges to a user, code deployment etc.)

Client: SEI, USA

Employer: Coforge (NIIT Technologies India)

Location: Greater Noida,India

Role: PL/SQL Developer/Software Engineer

Domain: Investment Banking

Project Title: SEI-GWMP Custom Interface

Duration:August 2011 – September 2013

Description: Global Wealth Management Platform (GWMP), an initiative taken by SEI to build new wealth management platform that allowed SEI to support the existing services around investment processing. SEI-GWMP Custom Interface involved in development of PL/SQL code as per requirement to generate outbound extract file for Bank and Advisor in different EDB Environment and that files were consumed by Client system in Production environment on scheduled basis.

My responsibilities:

Developed/Reviewed PL/SQL Code (Package/Procedure/Function/Performance Tuning (Using Oracle Hints) /Cursor/Analytic function etc.) for different Interface of Advisors & Banks of US and UK market.

Involved in performance tuning in code for proper execution of code in Production proactively fixed the issue raised by QA.

Created Database Objects (Collection, Synonyms and GTT etc.) and carried out changes in existing Code for New Releases as per requirement. Developed and executed Unit Test Cases (UTC) for development regarding activity; extend support to peers by reviewing the code.

Education/Certification:

B. Tech (CSE), Dehradun Institute of Technology, Uttarakhand Technical University, 2011

Oracle 10g (Administrator Certified Associate)

CISI Certification in Introduction to Securities & Investment (International)

Oracle10g PL/SQL Developer Certified Associate.

Online Training course for Informatica Power Center 9.6.1

Key Achievements

Won Award for outstanding performance in developing a bug free interface

Recipient of PAT on BACK Award for creating reusable Module for different interface of Bank

Entitled for getting special allowance after successful Completion of Domain Based training & Exam of CISI Certification in Introduction to Securities & Investment (International)

Contact this candidate