Customer Experience Sql Developer

RAJEEV KUMAR SINGH

ORACLE PL/SQL SR. SPECIALIST

MOBILE: +1-901-***-****

***********@*****.***

PROFESSIONAL SUMMARY

Having very extensive database programming experience in different domains (Banking, Customer experience, Cards and Payments, Logistics, e-commerce, Telecom) with focus on development, data analysis, data quality analysis, data management, data auditing, reporting and database migration

Experience in developing packages, stored procedures, functions, triggers, collections, views, cursors, ref-cursors, exceptions, joins, sub-queries and set operators

Hands-on experience on creation of indexes, synonyms, sequences, jobs, database links, Martialized views, Table partitioning, Constraints, External tables and Global temporary tables

Proficient in tuning applications using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, bulk collect, bulk binds and hierarchical queries)

Experience on Performance tuning by creating indexes, hints, executing Explain plan and AUTOTRACE

Experience with Oracle supplied Packages such as DBMS_SQL, DBMS_JOB, UTL_FILE and UTL_SMTP

Expertise in client server application development using Oracle 19c/12c/11g/10g/9i/8i, PL/SQL, T-SQL, SQL*PLUS, SQL * LOADER, TOAD, SQL Developer, Putty, Tectia and MS SQL Server 2000

Hands on experience with Unix/Linux commands and Shell scripting

Experience with Data flow diagrams, Data Dictionary, Database Normalization theory techniques, Entity Relation modelling and Design techniques.

Excellent interpersonal, leadership and communication skills with eagerness to improve existing skills

Experience of software development methodologies, SDLC and SAFe Agile

Project Management skills with specialty in project execution and risk management.

Familiar with DB2, PostgreSQL, TERADATA, Oracle Forms and Reports

Familiar with different data security standards like PCI-DSS, GDPR and SOX compliance

TECHNICAL SKILLS

Database Management Systems (DBMS): Oracle 19c, 12c, 11g, 10g, SQL Server, DB2

Languages: SQL, PL/SQL, T-SQL, XML

Scripting Languages: Shell Script, VB Script, JavaScript, Python

Tools: SQL Developer, SQL*PLUS, TOAD, SQL*LOADER, PuTTY, Tectia, OEM, QMF, MS-Excel, MS-Access

Operating Environments: Windows, Linux

Methodology: SDLC, SAFE AGILE

Web Technologies: HTML, ASP3.0

Reporting Tools: Crystal Reports, Oracle Forms and reports

Security Standards: PCI DSS, GDPR, SOX Compliance

PROFESSIONAL EXPERIENCE

Client: LTIMINDTREE/ World’s Leading Private Bank Jul 2022 – Present

Project: Wealth Management Workbench

Domain: Banking-Investments

Role: Sr. Database Specialist/Architect

Project Synopsis: This project is aimed at retiring the existing investment portfolio management done in spreadsheets. It has new user interfaces and backend processes for the investments done in US with potential to grow global investments. This project provides ability to manage portfolio life cycle including rebalancing, ability to manage global asset class hierarchy and several analytics/reports including comparison of month-on-month changes and drifts.

Responsibilities:

Created and maintaining all database objects like tables, views, triggers, packages, constraints, indexes

Created robust data foot printing and audit trails as highly sensitive data involved

Implemented customized access control with track of each access to minimize any possible fraud

Created Shell scripts to invoke SQLLDR for loading data from external file feed

Created SQL scripts for Database health check & Data Quality checks

Performance tuning of queries and other database objects

Participated in periodic internal reviews, sprint calls, requirement analysis and story point estimation

Development Methodologies: Agile/Scrum

Environment: Angular, Java, Oracle 19c, SQL Developer, SQL * LOADER, Tectia, Shell Script, Autosys, Bitbucket, TeamCity, UrbanCode, Linux

Client: Atos-Syntel/ FedEx Services Aug 2020 – Jun 2022

Project: Customer Experience - Business Intelligence & Analytics (Azure Migration)

Domain: Logistics

Role: Sr. Database Specialist/Lead

Project Synopsis: FedEx Customer Experience team is contacted more than a million times per week by customers through call centers, email channel, chat, social media and the FedEx virtual assistant. Thorough analysis is done on distressed packages. Package research and recovery team work on identifying them with a focus on preventing fraudulent claims on distressed packages.

Responsibilities:

Managed a cross functional team of 12 as a technical project manager

Maintained database objects like tables, views, triggers, packages, constraints, indexes for BAU

Created database objects in Azure SQL server for migration

Created complex queries/process to speed up distressed packages detection

Analyzed data to provide insights into tailored customer experience

Maintained and enhanced procedures and functions used in legacy oracle forms and reports

Performance tuning of queries and other database objects

Created complex queries for Fraud Reporting dashboard

Development Methodologies: SAFe Agile

Environment: Java, Oracle 12c, Oracle forms and reports, Shell Script, Autosys, Azure, SQL Server, .Net

Client: Atos-Syntel/ FedEx Services Aug 2015 – Jul 2020

Project: Enterprise Discount Database (eDD)

Domain: Logistics

Role: Sr. Database Consultant/Lead

Project Synopsis: Enterprise Discount Database (eDD) is a common discount store that will serve all the OpCos (operating companies like Express, Freight and Ground) to perform pricing maintenance and administration functions. Consistent experience for sales and end –customers, when requesting pricing agreements for FedEx.

Responsibilities:

Managed a team of 8 database and Java developers as a technical project coordinator

Created procedures, packages, functions, tables, views, integrity constraints, sequences, Indexes etc.

Performed performance tuning for queries used on customer website to meet the very strict SLA

Used BULK bind for better performance and easy retrieval of data, by reducing context switching

Analyzed data and created meaningful data reports for senior management

Lead the code review process and mentored/coached other developers

Issue resolution and maintenance of PL/SQL code used in Oracle Forms and Reports

Created several utilities helped daily health checkup of the database

Development Methodologies: SAFe Agile

Environment Oracle 11g, SQL Developer, OEM, Linux, Java, Angular

Client: Syntel/ First Data Commercial Services (FDCS) Feb 2007 – Jul 2015

Project: Clientline

Domain: Cards and Payments

Role: Sr. Database Consultant/Lead

Project Synopsis: Clientline, a multilingual reporting tool for credit card transactions, used by FDCS Management as well as by Merchants for analytics and reporting. It supported nine different languages and was capable of handling millions of data of card transactions for First Data Commercial Services (FDCS). Management decided to use Hadoop Ecosystem. So that, 7 years’ worth of data of all platforms can be retained for analytics and as well as for legal requirements

Responsibilities:

Managed a team of 14 developers across different locations as a technical lead

Created packages, procedures, triggers, functions and views to implement business logic

Consumed web service in PL/SQL code and performed Query optimization, Performance tuning

Ingested files on HDFS and reproduced these data on Hive tables.

Worked on data quality exercise using ATACCAMA DQ

Performed data analysis and data quality analysis along with ad-hoc data reporting

Created and maintained processes used to detect credit card frauds

Maintained and modified legacy Crytal Reports and created new crystal reports for new requirements

Conducted Code reviews and SQL training sessions at project and at organization level

Development Methodologies: Waterfall

Environment Oracle 11g, EXADATA, TOAD, UNIX, Hadoop, ATACCAMA DQ Tools, ASP.Net, Crystal Report

Client: Datacons Pvt. Ltd/ i-flex Solutions Ltd. Dec 2005 – Jan 2007

Project: Felxcube Global Support

Domain: Core Banking

Role: Programmer Analyst

Project Synopsis: Flexcube, a core banking suite and proprietary of I-flex solution and has a global presence. Global Support (GSupp) worked round the clock to provide support to banks across the globe on issues. GSupp team used to track and handle issues from inception to closure in an in-house tool named i-support. It kept track of every change related to any issue and kept all stakeholders posted with auto-generated emails.

Responsibilities:

Maintained, enhanced and supported i-support tool

Analysis and resolution of production issues on Flexcube

Maintained, enhanced and created database objects like Packages, triggers, Tables, indexes, views etc.

Maintained and enhanced Crystal reports

Collaboration with banks on their issues/resolutions and best practices

Development Methodologies: Waterfall/Production Support

Environment Oracle 9i, TOAD, SQL Server, VC++, VB, XML, Crystal Reports

Client: Gateway TechnoLabs Pvt. Ltd/ Wovel, NDDB Apr 2005 – Dec 2005

Project: Wovel.com and NDDB-MIS

Domain: e-Commerce

Role: Programmer Analyst

Project Synopsis: Wovel.com is a web site for organization in trading of Machine used to shovel the snow. The site will have the feature of referral code, which earns Online credits for its existing customers and some discounts to new customers being referred.

Worked on MIS of National Dairy Development Board (NDDB). NDDB was founded in 1965 to promote, finance and support producer-owned and controlled organizations. It has helped transforming dairying into an instrument for the development of India's rural people.

Responsibilities:

Wrote SQL queries using joins, sub queries and correlated sub queries

Created package, procedures, triggers and functions

Created new Crystal reports and maintained & enhanced the existing reports

Analyzed, resolved and documented issues

Development Methodologies: Waterfall

Environment MS SQL Server 2000, ASP.Net (C#), Java Script, Oracle 9i, ASP, Java Script, VBScript, Crystal Reports

Client: Ace InfoTech Inc/ Tudor India Ltd Aug 2004 – Mar 2005

Project: Store and Purchase Modules

Domain: ERP

Role: Software Engineer

Project Synopsis: Tudor was a leading battery manufacturer in India. Worked on Store, Purchase and Dispatch Modules of the ERP. Store Module handled all operations related to stores i.e. Gate and Store Inward, Quality Check, Material Requisition, Material Return, Material Rejection, and Material Issue. Purchase Modules performs different operations pertaining to Purchase Department, i.e. Purchase Indent, Tender Inquiry, Quotation, Comparative Statement, CAPEX, Purchase Order and Purchase Order Amendment.

Responsibilities:

Worked on Store Module’s UI

Created package, procedures, triggers and functions. Brought DMLs into PL/SQL blocks

Created Crystal reports based on the requirements

Development Methodologies: Waterfall

Environment Oracle 9i, VB.NET, Web Service, Crystal Report

Client: TATA Teleservices Ltd Oct 2003 – Apr 2004

Project: Business-Tracking System (BTS)

Domain: Telecommunication

Role: Software Engineer

Project Synopsis: BTS was basically a software for Tata Indicom 8282 call center. Which tracks the potential customers based on the information given by callers and assigning those leads to the Tata Business Franchises

Responsibilities:

Wrote SQL queries using joins, sub queries and correlated sub queries

Created package, procedures, triggers and functions

Created new Crystal reports and maintained & enhanced the existing reports

Analyzed, resolved and documented issues

Development Methodologies: Waterfall

Environment Oracle 9i, ASP, Java Script, VBScript, Crystal Reports

EDUCATION

Master of Computer Applications (MCA): - IMCC, University of Pune, India -2003

Bachelor of Science (BSc): - Y.M. College, Bharti Vidyapeeth University, India -2000

CERTIFICATIONS

Azure Fundamentals: - Microsoft Corporation -2022

Project Management Professional (PMP): - Project Management Institute (PMI) -2013

Oracle Certified Associate (SQL, PL/SQL): - Oracle Corporation, 2009

Contact this candidate