Manager Python

Gulshan Veeraragavan

Senior Software Engineer, Capgemini

Permanent address: 1, South Street, Thirubuvanam. 612103. Gmail: adibcq@r.postjobfree.com

mobile: 978-***-****

LinkedIn: Gulshan Veeraragavan

CAREER SUMMARY:

2 years and 5 months of IT experience as an ETL, SQL, PL/SQL, Python, shell script, BI developer.

Expertise knowledge and hands on experience in Informatica tool. Expert in creating mappings and workflows.

Expertise knowledge on databases such as Greenplum, db2 and Sybase, Postgres, MS SQL Server. Expert in creating tables, views, procedures and functions.

Expertise knowledge on PL/SQL

Expertise knowledge on data warehousing concepts and agile methodologies.

Expertise knowledge on scripting languages such as Unix shell scripting, Python and Perl. Expert in automating process using scripts.

Expertise knowledge on issue tracking tool - Jira.

Expertise knowledge on job scheduling tool - Autosys R11.

Expertise knowledge on issue tracking tool - Jira.

Expertise knowledge on reporting tools – Boxi, IBM Cognos.

Expertise knowledge on yaml creation.

Expertise knowledge on version controlling tool -Perforce, GIT.

Good knowledge on banking domain.

Strong interpersonal skill to communicate with clients and team members across the globe.

Quick learner and smart worker.

KEY SKILLS:

Languages: Pl/SQL, SQL, Python, C, C++, Basics of Java

Operating system: Windows, Unix

Database: Oracle, DB2, Greenplum, Sybase, Postgres, SQL Server

ETL Tool: Informatica

Reporting Tool: Boxi, IBM Cognos

Issue – Tracking tool: Jira

Job-Scheduling Tool: Autosys

Version-Control Tool: Perforce, Git

RELEVANT EXPERIENCE:

Organization- Capgemini Technology Services India Limited Client – Morgan Stanley (Worked in client location) April 2019-present Project name: Brokerage and Clearance Reporting (BCLR) Project Description: BCLR deals with cohesive views of all charges incurred by the firm. BCE DataMart will include brokerage, clearance and exchange fess of all asset classes globally.

Roles & Responsibilities:

Migrated internal/external feeds flow from Sybase to Greenplum due to data size limit.

Enhancing and tuning the performance of functions and views.

Created Python script for automating user requirements.

Created Python script for partitioning the table and sending mail regarding partitioned data.

Worked on Huge data bolt comparison tool.

Stick to established coding standards and group procedures individually and in teams.

Worked on perforce for version controlling in Unix.

Face of the project for 10 days per month. Finding out business requirement and providing solution.

Created TCM for production release.

Involved in Manual Testing, Bug fixing and posting defects.

Identify design problems and advise elegant solutions. Unit testing, code review and task assignments.

Documentation of all functional requirements and technical documentation.

Project monitoring and control: Validate the scope, controls the schedule, manage the quality and integration of modules.

Attending daily status calls and provide inputs required by client manager.

Getting hands on GIT repository and train deployment. Organization- Capgemini Technology Services India Limited Client – Morgan Stanley Nov 2018 – Apr 2019

Project name: Client Relationship Management (CRM) Project Description: CRM deals with managing and developing Client Relationship with other teams.

Roles & Responsibilities:

Developed Informatica mappings and workflows for user requirements.

Enhancing PL/SQL and tuning performance.

Created Shell script for exporting and importing workflows.

Stick to established coding standards and group procedures individually and in teams.

Worked on perforce for version controlling in windows.

Created TCM for production release.

Involved in Manual Testing, Bug fixing and posting defects.

Identify design problems and advise elegant solutions. Unit testing, code review and task assignments.

Documentation of all functional requirements & sprint estimation.

Project monitoring and control: Validate the scope, controls the schedule, manage the quality and integration of modules.

Attending daily status calls and provide input to Client Manager. Organization- Capgemini Technology Services India Limited FLP Training: Business Intelligence May 2018 – Oct 2018 Project Description:

This project deals with cleansing of data that is received from 9 different flat files, containing details of batsmen, bowler and fielder in all three formats which are test, T20 and ODI. The tables are then joined using Informatica tool and presented in 3 summarized tables. The reports are then depicted using IBM Cognos software. Roles & Responsibilities:

ETL developer, Decision Maker

Documented and verified project details

CERTIFICATION:

Oracle Database SQL Certified Associate-Oracle 11g release 2 to 12c release 1

(1Z0-071)

IBM data science professional certification

SQL certification from Hackerrank.

REWARDS AND RECOGNITION:

Rising Star award for H1 2019 in Capgemini Technology Services private limited. HIGHER EDUCATION:

K. Ramakrishnan college of Technology B.E., Electronics and Communication Engineering May 2018

Sri Saraswathi Patasala Girls Higher Secondary School HSC APR 2014

Sri Saraswathi Patasala Girls Higher Secondary School SSLC APR 2012 DECLARATION:

I hereby declare that all the information provided above is true to the best of my knowledge and belief.

Contact this candidate