SAILESH KUMAR NANDA

E-mail ID: acv1e2@r.postjobfree.com Date of Birth: 15th October 1989

Mobile Number: +91-869******* Kolkata, India

: +91-882*******

PROFESSIONAL PROFILE

BI Consultant, having 3 + years of strong technical functional experience in Oracle PL /SQL Developer, Performance Tuning, Oracle Warehouse Builder: OWB (ETL Tool), Unix, Data Warehousing in CMMI-Level 5 organization.

Demonstrated knowledge of technological platforms/tools like Oracle PL/SQL, UNIX, Oracle 9i/10g/11g, Oracle Warehouse Builder 11GR2, IKAN ALM5.2 Etc.

Experience in Performance tuning, Data Warehousing, Business requirement gathering & data profiling, Teradata POC & Development.

Strong understanding of Reconciliation of different Business areas, Data Warehousing concepts like Facts, Dimensions e.g. SCD, Development as well as Performance tuning of the ETL codes.

Conversant with Agile methodology, have been involved in the different stages of the Software Development Life Cycle (SDLC)

Hands-on experience of primarily working in Manufacturing and Energy Resource Domain.

Excellent customer-interaction skills, collaboration, & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

Key areas of work:

- POC for Data Purging activities & Technical specification for development activities.

-Oracle plsql/ETL Design,Development, technical documentation & Performance improvement

-Testing, Data loading, automation, maintenance and support

-Techno functional role: client Interaction for improvement of business process & implement the same as technical perspective.

WORK EXPERIENCE DETAILS: 4 Years 1 Month

System Engineer – Tata Consultancy Services Ltd

Energy & Resource Domain

11/06/2012 to 16/03/2016

PROJECT DETAILS:

Project name

BAU Support & Enhancements

Role

Technical support analyst

Environment

Oracle PL/SQL, OWB 11gR2, Unix, Control M

Start date

5th September, 2012

Team size

10

End date

31st December, 2013

ROLES AND RESPONSIBILITIES:

Providing reliable solutions for medium & high priority incidents, tracking & closed incidents using SDM.

On time deliverables for different RFCs (Request For change).

Conducting unit-testing, integration/regression testing, preparing test plans and drafting technical documents such as test-cases.

Deployment of codes from Dev to SIT & UAT through IKAN ALM5.2; versioning tool.

Post Go live support includes Development of DBMS jobs or Control M automated packages to schedule daily data loading jobs in order to save manual effort.

Planning, execution and delivery of change requests, major/ minor enhancements and other maintenance activities.

Project name

MTT2

Role

Senior Pl/SQL Developer

Environment

Oracle PL/SQL

Start date

1st January, 2014

Team size

4

End date

31st August, 2014

ROLES AND RESPONSIBILITIES:

Analysis of the functional requirements and planning of execution to achieve the requirements during development phase.

Documentation includes preparing the Technical Specifications (TS), attributes mapping list and Unit Test Plan of the workflow.

Creation of different Packages, procedures, cursors for proper calculation target attributes for source materials & tune the same for quality improvement.

Project name

SCC

Role

Module Leader

Environment

Oracle PL/SQL, OWB 11gR2, Unix, Control M

Start date

1st September, 2014

Team size

3

End date

19th September, 2015

ROLES AND RESPONSIBILITIES:

Development & design: Extract, Transform and Load (ETL) processes using Oracle Warehouse Builder. Optimized PL/SQL code; writing efficient SQL queries and improving data quality by performing data analysis.

Development as well as Performance tuning of the ETL codes for populating multiple Layers as Stage, Integration (IDS), Data mart and Aggregate Data mart using OWB and PL/SQL.

Supporting data load processes by Creating process flows and Control-M scheduling.

Preparation of Interface Agreements/Data contracts for various ETL modules & UNIX shell scripts to rename files, so that easily recognizable to Oracle database.

Project name

Reconciliation of Finance & Manufacturing reports

Role

Business Analyst : Techno functional

Environment

Oracle PL/SQL

Start date

21st September, 2015

Team size

1

End date

16th March, 2016

ROLES AND RESPONSIBILITIES:

Create the functional documents for improvement of business processes.

Change the Technical specifications for improvement processes by interaction with customers.

Gather Actual data & Plan data from different sources in order to compare between actual & planning, calculating gross and net Profit for BI purposes.

Creating a unified Master report of Stocks; reusable for other business areas such as finance & Service deliveries.

Planning for derivation of different KPIs (Key Performance Indicators) over the actual data to make the reports much feasible, reliable & beneficial.

Associate Projects – Cognizant Technology Solutions India Pvt Ltd

AIM-Data on Demand 21st Mar 2016 till date

Project name

Data Purging Activity

Role

Development cum performance tuning

Environment

Toad, Oracle pl/sql developer, Teradata

Start date

21st Mar, 2016

Team size

2

End date

Till Date

ROLES AND RESPONSIBILITIES:

Create POC for data purging activities of transactional tables.

Analyze the impacts on existing objects & provide performance improvement solutions.

Create design document & Provide pseudo codes in technical specifications.

Develop codes using Toad, test & create result set for analysis.

POC of Procedures, joining strategies, Primary index, secondary index using Teradata.

CERTIFICATION

Oracle Certified SQL Expert Developer : Nov 2014

TECHNICAL SKILLS

Debugging Tools

pl/sql developer,sql developer, IKAN ALM 5.2

Tools

OWB 11gR2, Toad,SDM, Control M

Skills

Oracle 11 g pl/sql developer, Teradata

Operating Systems

Unix, Windows-7/XP/Vista

EDUCATIONAL QUALIFICATION

Qualification

College / University

Year of passing

CGPA / %

B.Tech. (Electronics and Instrumentation Engineering)

Siksha ‘O’ Anusandhan University, Odisha

2012

8.11 (CGPA)

XII

JAC, Ranchi

2007

74.8%

X

JAC, Ranchi

2005

75.2%

ACHIEVEMENTS & AWARDS

Got good number of appreciation from Onsite/Client team for performing excellent on assignments and Management.

Received Beyond Performance Award in Extra Curricular Activity.

PERSONAL DETAILS

Father’s Name : Mr Binoy Kumar Nanda

Gender : Male

Marital Status : Single

Nationality : Indian

Languages Known : English, Hindi,Oriya

PAN Card Details : AJSPN3142P

Declaration:

I do solemnly declare that the particulars of information and facts stated herein above are true, correct and complete to the best of my knowledge and belief.

PLACE: KOLKATA

DATE : 05/08/2016 [Sailesh Kumar Nanda]

Contact this candidate