Post Job Free

Resume

Sign in

Project Oracle

Location:
South Brunswick Township, NJ
Posted:
September 06, 2017

Contact this candidate

Resume:

Swadhin Ray

e-mail: ac16nb@r.postjobfree.com

Blog: http://slobaray.com

P: +1-412-***-****

Address: *** ***** **,******, *** Jersey, 08810.

Professional Summary

A highly motivated IT support professional with 10+ years of experience in technical solutioning meeting the business requirements to industries like Retail, Customer Transaction, Tendering, Power Energy, Governance, Risk, Compliance, Quality Management and gaming.

Experienced in Software Design, Development, Implementation, Troubleshooting and Testing

A successful career track and outstanding record of accomplishment for providing solutions that meet demanding time restraints and exceed expectation including managing offshore and onshore teams.

Expertly develop scalable solutions that improve efficiency, productivity, and profitability with a demonstrated ability to support during upgrades, maintenance, troubleshooting and creating bundles, patches and enhancement service

Expertise in Oracle PL/SQL, Oracle Database SQL, programming with PL/SQL (OCA)Excellent communication, interpersonal and diagnostic skills, and consistently solve problems

Proactive self-starter known to initiate process and system improvements to increase stability and staff productivity; constant Skill Set upgrades for better support Service

Over 32 articles published on Oracle and Python technology.

Core Competencies

Database Architect

Oracle Database Administration

Oracle Development

Team Management

Training & development

Client Relationship Management

Educational & Professional Development

Qualification:

Bachelors of Engineering in Computer Science from C.V. Raman College of Engineering, Bhubaneswar, India – 2006

Advance Financial Risk Management from IIMB, Bangalore 2013-2014

Professional Certifications:

Oracle PL/SQL Developer Certified Associate, Oracle Database SQL Expert, Program with PL/SQL (OCA)

Certification from Microsoft and CISCO (MCP, MCSE, MCDBA, CCNA, CISCO PIX Firewall)

Oracle/Developer and Oracle Apps

Technical certification from Genesis Software System Hyderabad

Certificate Course in Hardware Engineering from IIHT, C++ & HTML from NIIT, ETHICAL HACKER COURSE FROM ANKIT FADIA ETHICAL HACKER CERT

Enable IT from Informatics (Computer Fundamentals, DOS, Windows 98, MS Office 2000, HTML, FRONT PAGE, INTERNET, MULTIMEDIA and LINUX)

Certification from Expert-Exchange.com:

oCertified Oracle Database Wizard

oCertified Oracle Database Guru

oCertified Oracle Database Master

oCertified Python Scripting Language Master

Published over 38 articles in Oracle, Python

Received BRAVO award in year 2012 from Mahindra Satyam for my innovative idea on Oracle Automation Process.

Received best performance award in year 2014

Technical Skill

Operating Systems

Windows, Sun Solaris and Red Hat Oracle Enterprise Linux

Databases

Oracle 7.x/8i, 9i, 10g,11g,12c, MySql, SQL Server 2005

Languages

SQL, PLSQL, Python, BASH & MYSQL

Applications

Oracle APEX, SQL Developer, Toad for Oracle and MYSQL, SQL Detective, MYSQL Maestro, PLSQL Developer, Putty, Win-SCP, Informetica, SQL Yog, Swis SQL Console, Oracle Discoverer 4i, Callidus-TrueComp, CuteFTP 8, SecureCRT, LIFERAY & Finsoft Monitor tool, Oracle APEX, Metricstream Appstudio.

Professional Experience

Senior Technical Engineer

Jan 2016 – Till date

MetricStream, US –is a market leader in Enterprise-wide GRC and Quality Solutions for global corporations. It’s enterprise solutions are used by leading corporations in diverse industries such as pharmaceutical, medical device, high tech manufacturing, energy, financial services, healthcare, manufacturing, food and beverages and automotive to manage quality processes, manage corporate policies, manage regulatory and industry-mandated compliance and corporate governance initiatives.

Project 1 #

DTCC - (Feb-2016 to till Date)

Role

Senior Technical Engineer (Development Manager)

Client

Depository Trust & Clearing Corporation - DTCC

Responsibilities

Playing a role as development manager

Managing multiple vendor teams associated within development and testing of the GRC applications.

Implementing Third Party Management, Internal Audit solution for DTCC with enhancement to the existing products and application.

Designed the data migration process for both tracks i.e. moving legacy data into Metricstream system including inflight transactions.

Designed and developed a custom module for DTCC called Risk Acceptance compliance process.

Managing DTCC offshore team and TCS offshore team in development process and testing.

Responsible for code review on maintain the industry standard process in place and following the guide lines defined by product teams.

Creating the Technical Design documents and MoP for development process

Implementing IT Compliance for self-assessment process for DTCC.

Senior Technical Lead

Jan 2013 – Jan 2016

MetricStream, Bangalore, India –is a market leader in Enterprise-wide GRC and Quality Solutions for global corporations. It’s enterprise solutions are used by leading corporations in diverse industries such as pharmaceutical, medical device, high tech manufacturing, energy, financial services, healthcare, manufacturing, food and beverages and automotive to manage quality processes, manage corporate policies, manage regulatory and industry-mandated compliance and corporate governance initiatives.

Project 1 #

Alliant Energy,Hydro-Québec, PG&E - (Dec 2014 – Jan 2016 )

Role

Senior Technical Lead

Client

Alliant Energy, Hydro-Québec, PG&E

Responsibilities

Implementing ISM custom solution for Case Management System for PG&E

Implementing NERC solution for Alliant Energy with GRCF, Survey and ISM modules.

Implementing CMP, eGRC, ISM, Survey, NERC for Hydro-Québec client

Managing offshore development team

Responsible for code review on Oracle for all the projects as mentioned

Creating the Technical Design documents and MoP for any process

Created the WebDoc Integration Design specification and Technical design documents.

Project 2 #

Alliant Energy,Hydro-Québec, Emblem Health, Pepsi Co - (Dec 2014 – March 2015 )

Role

Technical Lead

Client

Hydro-Québec, Emblem Health, Pepsi Co,

Responsibilities

Implementing BCM, ISM, GRCF custom solution for Emblem Health client

Implementing NERC solution for Alliant Energy with GRCF, Survey and ISM modules.

Implementing CMP, eGRC, ISM, Survey, NERC for Hydro-Québec client

Implementing eGRC, ISM, Survey for Pepsi Co client

Managing offshore development team

Responsible for code review on Oracle for all the projects as mentioned

Creating the Technical Design documents and MoP for any process

Created the Integration Design specification and Technical design documents.

Other projects:

Helped MDAPN to investigate the browser issues.

Helped other offshore teams on performance issues and developing complex codes related to reports and dashboards.

Project 3 #

Apple Inc. (“Apple”) – Supplier Audit Management - (Jan 2013 – Nov 2014 )

Overview

Apple Inc. is a $156.5 billion technology company headquartered in Cupertino, California. Apple and subsidiaries designs manufactures and markets mobile communication and media devices, personal computers, and portable digital music players; and sells related software, services, peripherals, networking solutions, and third-party digital content and applications worldwide.

MetricStream’s GRC and Quality Solutions implemented to meet Apple’s Supplier Responsibility and Governance requirements

Role

Lead

Client

Apple Inc. (“Apple”)

Responsibilities

Design and develop reports on Supplier Information Management (SIM) from Audit like:

Supplier List Report

Audit Plan List Report

Audit List Report

CAP List Report (Corrective Action Plan)

CAP Aging Report

CAV Audit List Report (Corrective Action Verification)

All the reports are developed on Oracle PL/SQL as backend and front-end with EGRCP for designing the reports and dashboards.

Creating the Bulk reassignment process for all the flow based on the organization, role and assignment tasks.

Done the integration between SIS (Supplier Information System) > EAI (Enterprise Application Integration) > SGM (Supplier Governance Management) for both inbound and outbound.

Created PLSQL coding standards for MetricStream.

Created Performance Tuning document and shared within the company.

Other projects:

Done entire integration process for “ScanDisk”.

Performance tuning for Norther Trust, Citi Audits, EXXON

Senior Developer

May 2011 - Nov 2012

Mahindra Satyam, Hyderabad, India – is a leading information, communications and technology (ICT) company providing top-class business consulting, information technology and communication services. Leveraging deep industry and functional expertise, leading technology practices and a global delivery model, we enable companies achieve their business goals and transformation objectives

Project 1 #

AT&T – Automation stream - (Jul 2012 – Till Date )

Overview

AT&T holds various databases where data feeds need to be imported daily and monthly basis from various sources which need to be migrated to Oracle and SQL Server. All these activities are needed to be automated. DBA support activities are also need to be automated.

Role

DBA/ Sr.Developer

Client

AT&T

Responsibilities

Preparation and Review of Technical Design Documents

Code Development of import and export of the tables

Creating a automation process for all DBA activities such as moving the flat files from one server to another, loading the flat files from other system, checking tables spaces, lock objects, invalid objects etc.

Migrating Oracle database to SQL Server 2008

Creating automation for loading the files on SQL Server 2008 from Oracle database. And stand alone files from Linux server.

Project 2 #

CISCO – Tandberg Migration - (Feb 2012 – Jul 2012)

Overview

Extract Tandberg BOM structures and other Cisco specific data elements from Oracle to Cisco Prime i.e. Agile system. As part of PACE (Product and Compliance Enablement) project initiative, Cisco is consolidating Tandberg’s (Business Unit) Agile PLM tool with Cisco Agile PLM tool (Cisco Prime). Since Tandberg’s Agile and Oracle ERP are not in sync in terms of BOM structures, business initiative is to sync BOM structures between two systems and cleanse before the consolidation exercise.

The extract of all Tandberg’s BOM structures in Oracle ERP SJPROD is part of synching and cleansing exercise. Also creating the SIA, SRS and SRP documents for disaster recovery of the applications.

Done BAVA testing for the migrated application.

Role

Senior Developer

Client

CISCO

Responsibilities

Preparation and Review of Technical Design Documents

Code Development of ‘Extraction scripts along with Grant/Synonyms’

Code deployment using Kintana

Testing - unit testing in Development environment & testing for extracted data from ERP and import testing in Agile.

Project 2 #

CISCO – Star Net Entities (MITG entities) - (Nov 2011 – Jan 2012)

Overview

The project involves the development of Virtual Trader will that configures the MITG entities to create Intercompany Accounting for eligible transactions. Virtual trader will create Intercompany journals directly in GL without using sub-ledgers Accounts Receivables and Account Payables.

Cisco’s objective is to enable Star Net entities (MITG entities) as Type 4a entities in Oracle ERP (Buy/Sell) in three phases (Wave1, Wave2 and Wave3). During the first phase (Wave1), seven MITG entities (Germany, France, Spain, South Africa, Turkey, Singapore and Mexico) .are being enabled as Type 4a entities in Oracle ERP

Role

Senior Developer

Client

CISCO

Responsibilities

Preparation and Review of Technical Design Documents

Code Development of ‘Automation of all IC Reports Submission’

Code deployment using Kintana

Testing - unit testing & integration testing

Responsible for overseeing the Quality procedures related to the project.

Project 3 #

CISCO 2TNG (May 2011 – Nov 2011)

Overview

Major task is to enhance the existing codes with the new requirement and bug fix for all the codes that are already in production

Role

Senior Developer

Client

CISCO

Responsibilities

Design and develop web applications using in-house and Open source technologies

Diagnose and solve technical challenges that arise during the application lifecycle

Handle sustainable code development and Quality coding practices

Liaison with support and development teams to assist when required

Database Architect/Oracle Developer

Aug 2010 - May 2011

ADP Pvt Ltd, India: Automated Data Processing is one of the world's largest providers of business outsourcing. ADP offers the widest range of HR, payroll, tax and benefits administration solutions from a single source.

Project 1 #

ADP Middleware Automation (Jan 2011 – May 2011)

Overview

The project involves the automation of all DBA activities like CLONEING, Scheduler, and BACKUPS through Oracle APEX. This development helps the DBA’s which have saved lots of time and monitoring the DB too. All the manual work is been transformed into APEX application

Role

Database Architect/Oracle Developer

Project 2 #

ADP Retirement Services (Aug 2010 - Jan 2011)

Overview

It involves designing, modeling, implementing and migrating external source to MS SQL Server 2005 and Oracle from external source like flat files, MS Access, Main Frame DB and DB2 database. Migration includes automation on all the RS process. Writing stored procedures and packages to automate the process with ADP org

Role

Database Architect

Responsibilities

Developed Oracle code as per Technical and Functional Specifications

Optimized code and application queries wherever possible

Worked on daily and critical production issues of the application

Analyzed codes and amended them as per the requirements

Focused in improving performance, best practices and in keeping knowledge management systems updated

Handle clustering, consolidation of data, enterprise level experience, experience with architecture and design

Oracle Developer

Apr 2007 - Aug 2010

Sierra Atlantic, Hyderabad, India: They also specialize in providing our services to discrete manufacturing, process manufacturing and financial services industries

Is a leading IT company that offers complete lifecycle application management solutions, with excellence in business application implementation, integration, upgrade, and support, providing superior value with our global delivery model

Project 1 #

Sierra AMS Shared Services (Jun 2010 - Aug 2010)

Role

Oracle Developer

Client

Hempel, Ferring, Semetronics

To resolve issues based on service request.

Performance-tuning for SQL & PL/SQL codes, reports customization, discover report customization

Modifying RDF’s and Discoverer reports etc

Project 2 #

KOFAX – (Feb 2010 – Jun 2010)

Overview

The project involves migrating existing Markview application for PeopleSoft 5.9.x functionality to the new Markview for PeopleSoft 6 which supports Markview 6.x, PeopleSoft 9.1 and PeopleTools 8.50

Role

PLSQL Lead

Client

KOFAX

Project 3 #

Finsoft Ops (Operation) - (Apr 2009 - Feb 2010) – Onsite Project

Overview

The scope of the project includes setting up Databases, Making changes to the backend components, verification and other software installation

Role

Oracle Developer

Client

Finsoft Ltd, BetFred – UK & Belgrade (Serbia) Onsite Project

Responsibilities

Provide DB (Oracle) support for Finsoft Operation teams

Handle changes in the backend components, verification and installation of other software

Automation for installing software like Oracle

Responsible for technical and process documentation

Project 4 #

AT Competency Portal (Mar 2009 – Apr 2009)

Overview

This project was for designing the Portal for AT (Advance Technology) Competency. Application Technology is a Leading Competency having expertise in Oracle, People Soft and JD Edwards. This site provides information about the various aspects like the resource graph, projects, latest news in the technology and general news. Users of this site will also be able to access the Reusable components stored in the repository. Besides, one can enlighten his/her colleagues through Blogs. All the online users can also avail chat option through this portal. The Portal was designed in Liferay Technology along with HTML and tools like Dreamweaver, Fusion Charts, PDF converter etc. I was the team lead and my responsibility was to manage and design the portal along with two fellow resources.

Role

Oracle Developer/Team Lead

Client

Sierra Internal Competency Project

Project 5 #

Form Factor Migration (Dec 2008 – Mar 2009)

Overview

This project is a migration project for the existing MYSQL database to Oracle database. The data migration includes Query conversion from MYSQL to Oracle. Where the Registration database via a JDBC/HTTP connection and also involved many front-end application from where the converted queries will be called via JDBC/HTTP.

Role

Oracle Developer

Client

Form Factor Inc

Project 6 #

SCMC (Service Contract Management Centre) - Encover Application (CS Apps) (Sep 2007 – Dec 2008)

Role

Team Lead

Client

Juniper Networks, USA

Responsibilities

Worked as an offshore operational team member/Team Lead

Responsible for updating information like Customer, Site, Contact, Product, Asset information, Service Contract information, Subscription contract information from various other sources like Oracle, Clarify, Siebel, Agile, Registration database via a JDBC/HTTP connection and LMS

Keep the contract details as with the related links update includes data purging activity too

Utilizing resources for running the Application smooth

Manage and mentor the team to meet deadlines

Project 7 #

SCMC Data Cleanup Project Version 2.0 (Jun 2008 – Sep 2008)

Client

Juniper Networks, USA

Role

Team Leader - Offshore

Responsibilities

Developed a package for purging and cleaning the unwanted data from SCMC database for better performance and running the application smoothly with the business objects like assets, contacts, sites, division, company and contract details etc

Performed testing, Unit testing and Integration testing are also involved and with a proper guidance of document has been sent to Client too

Project 8 #

Vastera Application (Vastera Trade Sphere Support) (Apr 2008 – Jun 2008)

Overview

Exporter module is used in Juniper. It provides functionalities to enable Juniper to comply with export compliance/regulations by screening entities against RPL, Embargo, EPCI, Government, as well as checking license requirements for exported highly regulated encrypted equipments. All Oracle orders will need to go through TradeSphere for export compliance screening before shipments can go out the door and before export documentation can be generated. This is a packaged application. IT-Support might be limited to supporting only certain parts of Vastera Usage areas in Juniper.

Technologies involved: Forte based custom scripting language, Oracle-DB, Web Sphere. Vastera Trade Sphere is an Export Compliance Management application.

Client

Juniper Networks, USA

Role

Team Leader - Offshore

Responsibilities

Working as offshore Lead, Vastera application has multiple modules in the suite (Trade Sphere Exporter, Trade Sphere Importer, Trade Sphere Restricted Party Screening, and Trade Sphere Finance)

Project 9 #

True Comp Sales-Compensation Application (Callidus Support Team) (Apr 2007 – Sep 2007)

Client

Juniper Networks, USA

Role

Oracle Developer

Responsibilities

Working as offshore operational team member responsible activities are briefed below:

Bug-Fixing for User Issues

The issues raised by the users during the Planning Cycle will be addressed. Typical issues include:

User access issues

Portal and Dashboard issue.

Generate the reports from the Portals.

User home page issue

Reporting issues

Refreshing reports for Accural reports

Report refreshing from the Web logic Server for the Sales comp

Resolving issue on call

Reports Generation on True comp 5x

Accolades & Achievements

Received appreciation letters from clients and management

Successfully trained the new resources on application and its complete functionality

Extra- Curricular

Received award from the STATE SCHOOLS ATHLETIC ASSOCIATION, ORISSA for representing ORISSA in the UNDER 14 Cricket Tournament in 1998

Received award from BALASORE DISTRICT ATHLETIC ASSOCIATION for representing BALASORE DISTRICT in the UNDER 16 Cricket Tournament in 1999

Attained award from the STATE SCHOOLS SPORTS ASSOCIATION, ORISSA for representing BALASORE DISTRICT in the Cricket Tournament in 1999

Award from BALASORE DISTRICT ATHLETIC ASSOCIATION for representing BALASORE DISTRICT in the UNDER 16 cricket tournaments held in CUTTACK in 1998

44TH NATIONAL SCHOOL GAMES award organized by the DIRECTOTATE OF EDUCATION GOVT. OF N.C.T. DEHLI for representing ORISSA in the VINOO MANKAD, UNDER 16 Cricket Tournament in 1998

First Prize in the TABLA Examination held in the year 1997-1998 from the SAI NRUTYA SANGEET MAHAVIDYALAY conducted by PRACHIN KALA KENDRA, CHANDIGARH

Personal Details

Date of Birth

31st January, 1984

Gender

Male

Nationality

Indian

Passport Number

G5033413

Alternate Address

Vyasakabi Nagar, Sahdevkhunta, Balasore, Orissa, India - 756001

Languages Known

English, Hindi, Oriya & Bengali

References Available Upon Request



Contact this candidate