Resume

Sign in

SQL Server,SSIS, T SQL, PL SQL, Informatica

Location:
Kochi, Kerala, India
Salary:
900000
Posted:
June 12, 2018

Contact this candidate

Resume:

Summary –

*.* years of IT experience in all phases of Software Development Life Cycle. Mainly worked as an ETL developer with strong Expertise in SQL SERVER (SSIS), T-SQL and PL SQL. I am Currently working as a Systems Engineer at Tata Consultancy Services pvt Ltd in Kochi(India). I have worked in Banking financial domain for 4+ years (for an Australian Banking client). I have also worked for more than a year at client location in Sydney and was working closely with the clients. I have also got over 3 years of experience in Agile methodology for software development.

• 4.8 years as Systems Engineer with Tata Consultancy Services Pvt LTD for the Australian client CBA.

Major Strengths:

Strong Experience in ETL development

Strong experience in SSIS 2005,2012,2016

Strong experience in SQL server Management Studio (SSMS)

Strong Expertise and experience of RDBMS through writing queries, stored procedures, functions using T SQL, PL/SQL

Expertise in developing SSIS packages for various ETL operations.

Knowledge of Informatica Power centre.

Knowledge of OOPS concepts

Knowledge of SSAS cube design, MDX queries and analysis.

Experience in version controls like GIT/Stash, TFS

Experience in dimensional modelling and data warehouse design.

3 years of experience in agile methodology of software development.

Experience In JIRA, Rally

4+ years of knowledge in banking domain (especially advice stream)

Basic knowledge of programming in C, C++

Basic knowledge of Business Objects, Tableau, Teradata,Sybase

Knowledge of Unix shell scripting.

Besides the technical expertise, I was actively involved in the requirement gathering, software design, testing, deployment and maintenance phases of many projects.

Education:

Degree

Year

%

Bachelor of Technology in Electronics and Communications Engineering (ECE)

INDIA

2013

77

Higher Secondary School (Plus Two)

INDIA

2008

93

Secondary School (10th)

INDIA

2006

94

Certifications :

Certification in SSIS 2012 (E2) from Tata Consultancy Services.

Technical Summary:

Operating systems:

Windows 10/8/7/XP, Linux, Mac

Packages/ Versioning Tools:

TFS, GIT/Stash

Databases:

T SQL, Oracle SQL

Process Framework, Methodologies & Standard

Waterfall, Agile, Scrum

Tools/Utilities:

SSIS 2012,2016, SSMS, SSAS, JIRA, Informatica

Professional Experience Summary:

Organization Name

Customer/ Client Name

Start Date

(MMM-YY)

End Date

(MMM-YY)

Tata Consultancy Services

Common wealth Bank of Australia

Jan-2014

Present

Professional Experience Details:

1.Tata Consultancy Services, Kochi <Jan 2018- Present>

Role : Systems Engineer

Client: CBA (Australia)

Project Name : WM Transactional Monitoring

Project Description:

Transactional Monitoring is a project aimed at monitoring the financial transactions of the clients, detecting and reporting the possible frauds to the regulating authorities. It is a highly secured and confidential area of the bank with many complex rules for detecting the frauds.

Responsibilities:

Requirement gathering from client.

Design the solution and create documents

Develop the SSIS packages and SQL stored procedures required to load the data in to the data warehouse.

Development of SSAS cubes for data analytics

Creating reports for the Monitoring team using SQL stored Procedures and SSIS Packages.

Developing Stored Procedures and Functions and Views for the data migration.

Creating and scheduling of Jobs for the packages.

Performance tuning of stored procedures

Preparing the Unit and Integration test cases.

Developing automated test procedures and packages.

Perform peer reviews.

Test and deploy the Packages

Environment/Tools:

T- SQL, SSIS 2016, SSAS, SSMS

2.Tata Consultancy Services, Sydney <Sep 2016- Dec 2017>

Role: Systems Engineer

Client: CBA (Australia)

Project Name: Fee Disclosure Statements

Project Description:

Fee Disclosure statements is an online portal of the bank for its financial advisers. The adviser can manage the accounts of their clients and generate various business reports. They can also send financial statements to their clients using the portal. I worked at client location in Sydney for this project and got a chance to closely work with the clients.

Responsibilities:

Requirement gathering from client.

Design the solution and create documents

Develop the SSIS 2012 packages and SQL stored procedures for migrating data from various adviser organizations to the central data warehouse.

Creating Excel reports for the Advisers based on their requirements Using SSIS packages and TSQL stored Procedures.

Developing Stored Procedures and Functions and Views for the data migration.

Creating and scheduling of Jobs for the packages.

Performance tuning of stored procedures

Preparing the Unit and Integration test cases.

Developing automated test procedures and packages.

Perform peer reviews.

Test and deploy the Packages

Environment/Tools:

T- SQL, SSIS 2012, SSAS, SSMS, Agile accelerato, Stash

3.Tata Consultancy Services, Sydney <Sep 2016- Dec 2017>

Role: Systems Engineer

Client: CBA (Australia)

Project Name: Adviser Training Tool

Project Description:

This project aims at building a system for training the financial advisers of the bank. As part of the projects all advice related production operations of the bank were created in a staging environment with sample data for various possible scenarios.

I was working at client location for this project.

Responsibilities:

Requirement gathering from client.

Design the solution and create documents

Develop the SSIS 2012 packages and SQL stored procedures for migrating data from various sources to the common database.

Creating Excel reports for the Advisers based on their requirements Using SSIS packages and TSQL stored Procedures.

Developing Stored Procedures and Functions and Views for the data migration and for adviser operations

Creating and scheduling of Jobs for the packages.

Performance tuning of stored procedures

Preparing the Unit and Integration test cases.

Developing automated test procedures and packages.

Perform peer reviews.

Test and deploy the Packages

Environment/Tools:

T- SQL, SSIS 2012, SSAS, SSMS, Agile accelerato, Stash, JIRA

4.Tata Consultancy Services, Kochi <Feb 2015- Sep 2016>

Role: Systems Engineer

Client: CBA (Australia)

Project Name: Operational Data Store

Project Description:

ODS was a project to build a near live datawarehouse that will reduce the load at mainframe systems. The semantic layer built on top of the ODS will be used by the data analytics and spotfire reporting team for customer reports.

This was a project developed from the scratch and I got a chance to get the requirements from the clients and build a complete new solution with the help of our team.

Responsibilities:

Requirement gathering from client.

Design the most suitable solution through analysis and continuous discussions with the clients, and create documents

Develop the SSIS packages and SQL stored procedures required to load the data in to the data warehouse from the mainframe.

Create Semantic views on top of the ODS (Using T SQL)

Creating Excel and Text reports for the using SQL stored Procedures and SSIS Packages.

Developing Stored Procedures and Functions and Views for the reporting team based on their requirements.

Creating and scheduling of Jobs for the packages.

Performance tuning of stored procedures

Preparing the Unit and Integration test cases.

Developing automated test procedures and packages.

Perform peer reviews.

Test and deploy the Packages

Environment/Tools:

T- SQL, SSIS 2012, SSMS, T SQL, TFS, JIRA, Stash

5.Tata Consultancy Services, Kochi <Jan 2014- Feb 2015>

Role: Systems Engineer/SQL developer

Client: CBA (Australia)

Project Name: Data Management Remediation (DMR)

Project Description:

DMR was a major project that migrated the old SSIS 2005 and DTS artifacts(packages) to SSIS 2012. All the old packages were migrated and the stored procedures were modified for better performance. As part of the project we developed automatic Test modules for each object and there by reduced the maintenance cost.

Responsibilities:

Requirement gathering from client.

Design the most suitable solution through analysis and continuous discussions with the clients, and create documents

Migrated the DTS packages to SSIS 2012 by re writing the whole logic in SSIS 2012.

Migrated the SSIS 2005 packages to SSIS 2012.

Performance tuning of SSIS packages and Stored Procedures.

Creating Excel and Text reports for the using SQL stored Procedures and SSIS Packages.

Developing Stored Procedures and Functions and Views for the reporting team based on their requirements.

Creating and scheduling of Jobs for the packages.

Preparing the Unit and Integration test cases.

Developing automated test procedures and packages.

Perform peer reviews.

Test and deploy the Packages

Environment/Tools:

T- SQL, SSIS 2012, SSMS, T SQL, DTS, SSIS 2005, TFS, JIRA, Stash

6.Tata Consultancy Services, Kochi <Oct 2013- Jan 2014>

Role: Systems Engineer

Project Name: Initial Training Program

Project Description:

The Initial Training Program of TCS. I was trained on BIPM stream. I was trained on ETL tool Informatica and reporting tools like Business Objects. I was also trained in Oracle PL SQL.

Environment/Tools:

Informatica Power center 9.1, Business Objects, PL-SQL

Personal Data:

D.O.B : 14-02-1991

Age : 27

Sex : Male

Nationality : Indian

Marital Status : Single

Father’s Name : Mohan Das K

Mother’s Name : Sujatha N V

Passport No : L5677286

Contact Information:

Mobile: +918*********

ResNo: +914**-*******

E-mail id:

ac5uok@r.postjobfree.com

Permanent Address:

Sarovaram, Nellikkayil House

Annanad P O

Chalakudy, Thrissur

Kerala, India

PIN : 680309

Hobbies & Interests

Listening Music

Story Writing

Watching Movies

LinkedIn: https://www.linkedin.com/in/sanoj-nellikkayil-06aa3a1b

Skype: ac5uok@r.postjobfree.com

Declaration

I hereby declare that the above-mentioned information is true to best of my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

Place: Kochi Sanoj N



Contact this candidate