Resume

NEHA KHANDELWAL

Mobile: +1-510-***-****

Bay Area California, US

Objective

To become a part of a result oriented and highly successful team involved in implementing innovative ideas with quality standards and latest technological trends. I am seeking a challenging position with a company that is rapidly expanding and offers good advancement the best in me.

Resume Summary

●Close to 9 years of IT exp of programming experience in Analysis, Design and Implementation of Business Applications mostly in banking domain & real-time transactional environment and UAT & end to end testing, working on PL/SQL & Informatica development, crystal reports and webi report and unix shell scripting for integrating with customer requirements.

●Worked on crystal reports and WEBi reports.

●Have experience in working on ETL tools - Informatica ETL designing transformations, mappings and workflows .

●Went to onsite Germany for gathering business requirements and UAT testing for Telefonica Germany.

●Extensively used Unix shell scripting in most of the projects.

●Involved in all phases of the SDLC (Software Development Life Cycle) from requirements gathering, analysis, design, development, testing, implementation, testing, UAT, production and post-production support and maintenance with timely delivery against aggressive deadlines.

●Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.

●Involved in Purge and Archival activity and created scripts for the large database for efficient database maintenance.

●Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

●Expertise in Dynamic SQL, Collections and Exception handling.

●Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

●Technically adept and confident software programmer with exceptional skills in coding and documentation

●Strong working knowledge in Oracle 9i/10g/11g SQL and PL/SQL Programming.

●Worked with client CITIBANK at onsite UK for 6 months for FLEXCUBE Production Support.

●Performance tuning and query optimization experience.

●Understanding the requirements from the functional specification document and developing the code to implement the functional changes after proper testing and then do the impact analysis.

●Participating in requirement gathering, preparing estimation, test strategies, test cases and executing them

●Worked with the front end .dot net/java team to implement the required changes after developing the pl/sql code with proper functional & technical documentation

●Experienced in Tuning Queries for better performance with large volume of data and which are taking more time to complete.

●Good communication skills and experience in customer interaction in requirements gathering.

●Worked with SQL scripts.

●Experience in manual testing, UAT & functional software testing, backend testing and regression testing in banking domain for product FLEXCUBE

●Experience in PL/SQL enhancements & testing & support for banking product

●IBBS and 1st level Flexcube Production Support for banking product

●Creation and execution of QA and testing processes, test cases, test strategies and plans, and bug documentation and regression

●Awareness of bank functionality and industry standards.

●Defect management, Reporting, documentation and client handling

●Involved in giving trainings on testing and core banking

●SQL query writing, PL/SQL programming (Procedure, Package, function), query

optimization, Informatica Basics.

●Extensive use of packages, procedures, functions for implementing business rules

●Generating reports using SQL, PL/SQL, and UNIX shell scripting.

●Understanding business data relationships & gathering statistics.

●PL/SQL Developer Oracle certified Associate OCA 11g certified with 98%

●Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities and possess good communication skills.

●Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.

●Comprehensive technical, oral, written and communication skills

Qualification

●Bachelor of Engineering (Electronics-Instru & cntrl Engineering) June ‘2005 form “Shri Vaishnav Institute of Technology and Science”, R.G.P.V University with 73.35%

●High School Certificate from Indore Public School, Indore with 69 %

● 10th CBSE completed with 73.8%

Trainings and Certifications:

●Completed Oracle PL/SQL developer Associate 11g (OCA 11g) certification in Nov 2010.

●Certified financial professional from Oracle Financial Software Services Ltd.

●Linux certification from Tata InfoTech Education, Indore, Feb 2003

●Core java certification From Soft vision, Indore in July 2005

●Training attended: UNIX.,PL/SQL, Business communication & etiquette, Flexcube core banking, Business Objects etc

●Completed PL/SQL Developer course from System Domain Bangalore in Nov 2008

Technical Skills

TECHNICAL/ FUNCTIONAL (Application) SKILLS

Languages

:

Oracle PL/SQL 9i / 10g/11g, Unix,VBA, Linux C,C++

Web Technologies

:

Core Java

Operating Systems

:

HP Unix, Linux, MSDOS, Windows 98/2000, XP, Windows NT

Databases

:

Oracle 9i,Oracle 10 g,Oracle 11g

Middleware

:

Flexcube, Business objects, Informatica, Crystal Reports, WEBi reports

Tools

:

Toad, Flexcube, Putty, Telnet, NDM file transfer, Siebel, sql loader, Informatica

Domain Knowledge:

Core Banking Domain knowledge. Worked for FLEXCUBE banking product for about two years and work exp in investment banking which has added a lot of functional knowledge. Additionally knowledge on Callidus products like SAP sales cloud, CPQ, etc.

Career Profile:-

Company 1 ->

Worked in Callidus Cloud Ltd a SAP company as a Senior Data Integration consultant, working on PL/SQL & Informatica development, crystal reports and webi report and unix shell scripting for integrating with customer requirements.

March 2017 to Oct 2019

Designation: Consultant

1.

Project

:

Telefonica Germany, Clarivate Analytics, Starwood, Exlide

Client

:

Different clients based on projects

Duration

:

1 year

Technology

:

Advance PL/SQL development & Performance tuning,Oracle 10g/11 programming, Unix shell scripting, informatica

Role

:

Senior DI consultant

Roles & Resdponsibilities:-

●Participated in Requirements Gathering with the customers.

●Developed end to end solutions for the customers for data integration requirements using Oracle PL/SQL Informatica and unix shell scripting.

●Developed ETL programs using Informatica to implement the business requirements.

●Created custom reports in SAP crystal and web intelligence tools.

●Provided technical development and implementation of design as it relates to the existing applications that correspond with the architecture

●Communicated with business customers to discuss the issues and requirements, Attending various calls with customers and onsite team.

●Worked on ETL techniques using Informatica Power Center 7.x, 8.x, Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional/Dimensional Databases.

●Was involved in SIT testing and end to end testing of the Callidus Truecomp(commissions) application.

●Prepared and Executed the Test Cases during Unit Testing.

●Supported Testing team, UAT Team & Productions support team.

●Integrated data from Flat files into Oracle tables using Informatica.

●Identified Mapping Bottlenecks and Tuned performance at the source, target and mapping levels. Developed Stored Procedures, Functions and Packages to implement certain business rules.Developed UNIX Shell scripts for validating the files, running stored procedures & Informatica workflows.

●Extensively worked in UNIX Shell Scripting, AWK and file manipulation techniques.

●Have extensively worked in developing ETL programs for supporting Data Extraction, transformations and loading using Informatica Power Center.

●Responsible for writing the technical specification documents and maintaining the documentation.

●Attending various training sessions internally to gather Callidus product knowledge.

Company 2 ->

Tek systems, Client location Dell International Ltd Hyderabad

Jun 2016 to March 2017

Designation: Senior Technical Consultant

1.

Project

:

GOLF – Dell Global Order Logistics & Fulfillment Module

Client

:

Internal project for Dell

Duration

:

9 months

Technology

:

Advance PL/SQL development & Performance tuning,Oracle 10g/11 programming, Unix, asynchronous transactions using AQ

Role

:

Senior Database Analyst

Roles & Resdponsibilities:-

●Involved in Code Reviews and preparing Unit test cases as was the only DB resource in the team. Also prepared DB scripts for deployment in production

& implementation instruction documents for DBAs.

●Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds,Cast collect multiset,used cursor and global temporary tables,in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.

●Managed performance and tuning of SQL queries and fixed the slow running queries in production using utilities like Explain plan, Trace and tkprof and Hints to improve the execution plan.

●Have created purge scripts based on purge criteria for purging big tables in production and implemented the same with the help of DBA. Also added a job afterwards which will automatically purge the tables based on monthly scheduler

●Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.

●Played a pivotal role in the migration of legacy application databases from Oracle 11g to 12c in a planned manner.

●Implement and support code migration into production. Actively involved with DBA for deployment of objects to the production environment and have supported all the deployments.

●Wrote Oracle scheduler jobs and implemented Oracle Advanced Queues.

●Extensively used REF_CURSORS to support data transfer between Oracle PL/SQL and Java environments.

●Responsible for writing the technical documents and maintaining the documentation.

●Responsible for creating and developing highly complex applications using Oracle as back-end with expertise in design and development of PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced

● Techniques Bulk Processing, En-queue and De-queue, Collections. Responsible for helping set development standards for database development within PL/SQL.

●Act as a database technical resource, with a high level of technical and analytical expertise in programming languages, data communications and a strong understanding of the business operation/customer.

Company 2 ->

Societe Generale Global Solution center on C2H with Magna Infotech

Mar 2016 to may 2016

Designation: Senior software engineer

1.

Project

:

Granite SCIBML Project

Client

:

Internal project for Societe Generale

Duration

:

3 months

Technology

:

SQL pl/sql development & Performance tuning,Oracle 10g/11 programming, Unix

Role

:

Senior Team Member

Description :-

Granite is a core Investment banking data warehouse and reporting tool for bank Societe Generale

Roles & Responsibilities:-

●Requirement gathering from the BAs & analyzing the data then preparing the technical specification document, development on the basis of that then testing & then implementing the required changes in front end working with the .net developers. Finally after the testers test & UAT sign off, I will include these changes in the monthly release implementation in production using impulse.

●Development including partitioned table, triggers, packages, stored procedures, Data modeling, compression etc

●Performance tuning of partitioned table query, complex report queries and procedures which were taking longer time.

●Migration & testing of SDS application as the existing application will be decommissioned in granite so after developing all scripts and then testing data and doing impact analysis on downstream applications.

●Used optimizer hints and created required indexes to enhance performance.

●Maintaining all the golden rules followed by the business for naming convention used for tables, partitions, procedure name, triggers, variables ets in development

●Have done integration and unit testing on developed code

●Basic knowledge of ETL tools with informatica power center which is used in the project.

●Participating in requirement gathering, preparing estimation, test strategies, test cases and executing them.

Company 3 -> Oracle Financials Services Software Limited, Bangalore

June 2010 to April 2012

Designation: Senior software consultant

1.

Project

:

DBFC Reports Reengineering Project

Client

:

Deutsche Bank

Duration

:

6 months +

Technology

:

SQL Performance tuning,Oracle 9i / 10g programming, Unix

Role

:

Senior Team Member

Responsibilities:

●Performance tuning of complex report queries.

●Analyzing the query explain plan and tracing through tkprof output.

●Used optimizer hints and created required indexes to enhance performance.

●Developed Procedures/functions/Packages for complex download reports where the already existing code was in PB so analyzed the PB code also for it and handled it in oracle.

●Query optimization and fine tuning.

●Jasper domain creation

●Created synonyms and provided grants to developers to access tables not available to them

●Created procedure specific to developer requests where they want to insert data in a global temporary table and access that using JRXML.

●Converting the complex query or multi stage query into one simple query using some analytic/sql functions or joins

●Coding complex SQL queries using analytic, aggregate and window functions for checking the data.

●Mentoring team members with analysis of complex requests, fine tuning SQL queries and PL/SQL programs.

●Sql Loader was used to convert the data from the Excel/CSV to oracle tables.

●Analyzing the Data Mismatch issues between the old and the new system

●Load testing and giving access rights for the reports specific to the countries.

For Company 3 -> Oracle Financials Services Software Limited, Bangalore

2.

Project

:

SLD – Remediation and Performance Tuning

Client

:

Statestreet - Boston, MA

Duration

:

16 Months+ (Jan 2011 –April 2012)

Technology

:

Oracle 10g

Role

:

Database Analyst

Description:

This project aims to deliver improvements to the SLD database in terms of system performance and storage space used. The following areas were considered;

●Database System Activities

●Physical Database Design

●Process SQL performance

●Data Retention and Distribution

Responsibilities:

●Analyze the business requirement and TAD preparation.

●Standardize tablespaces of tables across the database.

●Development of Archive and purge procedures for archiving historical data by identifying huge tables using PL/SQL and moving data using exchange partition.

●Identify and tune badly performing queries.

●Compressions of huge tables & indexes (using CTAS & normal method) and perform impact analysis based on the performance before and after compression. After completing the compression process, I developed the plan to drop the old table with the new compressed table & move the latest data to the compressed table.

●Analyze dependencies of the objects before any changes to the database.

●Gathered statistics for analyzing the space and performance.

●Tested all the scripts thoroughly in the development environment before moving it to production.

●Checking in the latest & updated scripts in clear case.

For Company 4 -> Vault Information Technologies pvt Ltd client Oracle India

Dec 2008 to Jun 2010

Designation: Software consultant

1.

Project

:

GMSS Database Development and Support

Client

:

Oracle India Pvt Ltd, Bangalore

Duration

:

1.5 yrs

Technology

:

PL/SQL, SQL coding, Unix, Performance tuning etc

Role

:

Senior Team Member

Responsibilities:

●Coding SQL queries and PL/SQL programs for providing data to oracle Global Marketing Shared Services team which provides support for various marketing activities organized globally (EMEA,APAC,NA regions) for promotion and revenue.

●Analysis of request and existing data for feasibility of request and advising marketing and sales managers about various options to get perfect customers for organizing events and launching oracle campaigns and products.

●Responsibilities include creating and fine tuning multi-strategic complex scripts using SQL and PL/SQL Packages, Procedures & Functions on UNIX and Windows platform based on event/campaign.

●Reviewing shell scripts, SQL queries, modifying shell scripts, SQL queries and PL/SQL programs as per the region wise and request specific logic changes.

●Query optimization and fine tuning.

●Solving requests in Siebel CRM to arrive at data mapping estimation, performance issues between existing system and Siebel CRM.

●Coding complex SQL queries using analytic, aggregate and window functions for providing different levels of data comparisons to end users.

●Mentoring team members with analysis of complex requests, fine tuning SQL queries and PL/SQL programs.

●Analyzing SQL queries on cost incurred to execute it, performance issues and incorrect/illogical queries.

●Sql Loader was used to convert the data from the Excel/CSV to oracle tables.

●Created database triggers to automate the transactions that take place online.

●Understanding business terminologies used in the request from the perspective of data in the database. This requires exploring Oracle website to study product categories, sub categories, partner and competitor specifications, support products, product versions etc. Based on this data are searched using SQL queries.

●Identifying data quality issues and routing it to proper channels.

For Company 5-> Polaris software Lab ltd, Mumbai

Aug 2005 to Feb 2008

Designation: Associate consultant.

1.

Project

:

IBBS - 7.X

Client

:

Citibank Egypt

Duration

:

8 Months

Technology

:

Oracle 9i, PL/SQL

Role

:

Team Member

Responsibilities:

●Enhancements: Writing of procedures to enhance the existing services to client and providing excellent support in releasing the same to production.

●BAU support for production systems.

●Problem Resolution within the agreed SLA.

●Periodic review of outstanding issues with the branches and reach agreement on priority with the customers

●Enhancement Requests - Complete involvement from requirement gathering, BRD Review, development, Code Review, testing, production installation and handover to BAU support after agreed timeframe.

●Efficient work distribution for the team and end-to-end tracking of team output with appropriate tools.

●Develop SME for various modules through training/ Mentoring.

●Ensure Change Control and Release process is followed Strictly for each bug fix/development

●Good client communication.

●Analyzing and fixing business critical cases rose against various modules of IBBS.

●Complete Impact Analysis and fixation of the bugs.

For Company 5 -> Polaris software Lab ltd, Mumbai

3.

Project

:

Flexcube London, 1 st Level Production Support

for FX/MM and Loans agency and TLM application

Client

:

CitiBank (London), Onsite

Location Belfast UK

Duration

:

About 6 Months (From sep 2007 to Feb 2008)

Technology

:

Banking & financial services, PL/SQL,Unix, Flexcube,Business Objects, VBA

Role

:

Team Member, Providing 24/7 Production Support.

Description:

First Level Production Support for Flexcube London-FX/MM and Loans Agency and also adhoc Functional testing for enhancements and rollouts for Core banking application (Flexcube) for CITIBANK London branch.

Responsibilities:

●Provide 24/7 production support for any issues in FX/MM, Loans and TLM application and also during the EOD batch run

●Handling testing for all the new enhancements coming in after the test planning and documentation.

●Have to handle all the Job Failures during the batch run.

●Have to check any issues if there is any change in the batch date.

●We have to get all the holiday maintenance done by the OPS team.

●For some testing we have to establish the connectivity with CITIFT, CSSLITE, MQ etc so have to coordinate with various teams and get it done.

●Provide user support to perform user acceptance tests for production rollouts

●Assisting Flexcube UAT support by coordinating with the geographically distributed teams

●Support Co-ordination with UNIX, Oracle for problems co-related

●Attending conference call(s) and answering queries.

●Reporting and documentation of work.

Achievements and Awards:

●Completed OCA certification in first attempt with 99%

●I’m responsible for the training for the new joiners joining my project as was the most senior in the team both functional and technical

●I was single point of contact for about 4 months for the project and single handedly solved all the issues and requests from the client CITI and got very good feedback from them.

●Responsible for the documentation and quality related activities.

Visa Validity:

●UK visa expired after coming back from onsite

●US Work Authorization L2 EAD.

I hereby declare that the information given above is true to the best of my knowledge.

Yours Sincerely,

(Neha Khandelwal)

Contact this candidate