Swadhin Ray
e-mail: ac16nb@r.postjobfree.com
Blog: http://slobaray.com
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