Profileimage by Umashankar Vasanthakumar Team Lead - IT (Information Technology), Senior Software Engineer - IT (Information Technology), Sof from BRLIN

Uma shankar Vasanthakumar

available

Last update: 06.09.2022

Team Lead - IT (Information Technology), Senior Software Engineer - IT (Information Technology), Sof

Graduation: not provided
Hourly-/Daily rates: show
Languages: German (Elementary) | English (Native or Bilingual)

Attachments

Oracle_Certified_Professional.pdf
umashankar_CV.docx
Umashankar_Technical_Lead_DB_ETL_TABLEAU.docx

Skills

ERP, SQL Queries, Database, Database Administration, Backup, Oracle, RMAN, query tuning, SQL, IBM, Oracle Database, Oracle 10g/11g database, Oracle Databases, cursors, PL/SQL code, script, Joins, Sub Queries, PL/SQL, SQL Programming, Data Processing, Data Modeling, Functional Testing, Stored Procedures, HIVE, OOZIE, Oracle Certified Professional(OCP), Oracle Certified Associate(OCA)

Project history

09/2016 - 11/2019
Assistant Manager - ISIT(Information system and Information Technology)
Renault Nissan Business and Technology Private Limited

  • Development of Informatica mappings, workflows and database objects wherever needed.
  • Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Strong    experience in Talend DI installations and its components like tMap, TJavaRow, tAggregateRow, tFilterRow, tFilterColumns, tJoin, tHDFSGet, tHDFSPut etc.
  • Preparing and assigning work assignment, designing the ETL architecture, Load Strategy and Data Flow, providing guidance, and/or review the work of other team members.
  • Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Expertise Configuring Repository, Create/Manage Dashboards, Reports/Answers and Building Physical, Business Model and Presentation Layer.

02/2016 - 09/2016
Team Lead - IT (Information Technology)
Magna Info Tech Private Limited

  • Strong understanding of Data Modeling (Star Schemas and Snow Flake Schemas), Conceptual / Logical / Physical models, DWH concepts, ER diagrams, Data Flow Diagrams / Process Diagrams.
  • Good understanding of PL/SQL Packages, Procedures, Functions, Triggers and other database components. Experience in converting PL/SQL procedures to ETL Interfaces.
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.
  • Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

08/2011 - 07/2015
Senior Software Engineer - IT (Information Technology)
IBM India Private Limited

  • Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.
  • Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, MYSQL, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
  • Involved in completing minimized the space related errors in Oracle Databases by conducting month review with Senior Management and addresses the space issues proactively.

11/2009 - 08/2011
Software Engineer - IT (Information Technology)
UST Global India Private Limited

  • Strong understanding of Data Modeling (Star Schemas and Snow Flake Schemas), Conceptual / Logical / Physical models, DWH concepts, ER diagrams, Data Flow Diagrams / Process Diagrams.
  • Good understanding of PL/SQL Packages, Procedures, Functions, Triggers and other database components. Experience in converting PL/SQL procedures to ETL Interfaces.
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.
  • Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

08/2006 - 11/2009
Software Programmer - IT (Information Technology)
Roadmap IT Solution Private Limited

  • Developed and supported software for company needs. Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
  • Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
  • Design, development, and maintenance of applications written in PL/SQL, Oracle 11i forms, Oracle 11i reports, Python and UNIX.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
  • Created and maintained developer-level and user-level artifacts that included software version or requirement documentation, deployment guides and user manuals as well as generated project reports using Python Report Lab for clients as required.

Local Availability

Open to travel worldwide
Yes

Other

Dear Sir/Madam,
I am writing this letter to express my interest in JUNIOR DATA ANALYST role at ALLOT GMBH. My experience aligns well with the qualifications you are seeking at oracle programming. ALLOT GMBH is leading in the IT service provider on since 1999 onwards. The company has huge transaction daily in a different department and huge volume data in-store at Database, Me as a Database developer and Administrator can contribute towards the success and growth of ALLOT GMBH Germany is an economically strong country. Germany has more opportunity for skilled employees in IT which caught my attention and interest to get settled here in the future. I am at present in Germany on EU BLUE CARD valid from 14.04.2020.
 I have ore than 12 years of experience in designing and building custom applications using Oracle Database specialist and ERP application tools in Windo­w environments with expertise in Tableau/ETL/Oracle 10G, 11G and 12c pertaining to relational DB designing and comprising physic            al/logical designing .General Insurance / Health Insurance / Inventory Management / Planning and Manufacturing / Purchase Order Management domains.
Currently I am associated with Renault Nissan (P) Ltd., India as a Senior Technical Lead. In my last stint, I have worked with Magna Info Tech (P) Ltd., India as a Team Lead / IBM India Pvt. Ltd., India as a Senior Software Engineer / UST Global Technology, India as a Software Engineer / Roadmap IT Solution Pvt. Ltd., India as a Software Programmer.
                                                                                                                                                                                                                       
With hands-on experience w­­ith Oracle10g,11G,12c / ORACLE Developer suite 10g, 11G / SQL,PL/SQL, Forms and Reports / TOAD ,DBA,SQL*Plus, MS-SQLSEVER(SSIS & SSRS),MYSQL,ETL(SSIS,SSRS,TALEND),PYTHON,TABLEAU technologies, I am adept in programming, designing, developing, and debugging. Moreover, while my on-the-job experience has afforded me a well-rounded skill set, including first-rate interpersonal, communication, and project management abilities.
Few of my expertise include:
  • Dexterous in SQL and PL/SQL, Oracle Forms/Reports, SQL Query Tuning and Data Migration on RAC.
  • Strong experience in SSRS, SSIS, OLAP,Talend DI and BD installations and its components like tMap, TJavaRow, tAggregateRow, tFilterRow, tFilterColumns, tJoin, tHDFSGet, tHDFSPut. Multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.
  • Design, development and analysis of indexes, views, triggers and like structures; Reviews performance stats, recommend changes for tuning databases, servers, and storage configurations, as well as application SQL.
  • Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc to extract, transfer and load (ETL) data from OLTP to OLAP databases.
  • Created Mappings using Mapping Designer to load the data from various sources into multiple targets, using different transformations like Aggregator, Expression, Filter, Lookup, Sequence Generator, Router and Update Strategy. (ETL) extraction, transformation and loading data from heterogeneous source systems into target database
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities
  • .Good understanding of PL/SQL Packages, Procedures, Functions, Triggers and other database components. Experience in converting PL/SQL procedures to ETL Interfaces.
  • Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
  • Design in report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio 2017.
  • Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
  • Scripting expertise with common scripting tools as well as with Python and UNIX as well as real functional experience with SQL Server and PL SQL.
  • ERP / MES (Manufacturing Execution System) – strong ERP knowledge and good understanding in manufacturing domain.
  • Mapping business requirements to technical specifications and design logic for implementing the same. Developed data mappings using various transformations between source systems and warehouse using TALEND Designer.
  • Design and develop Tableau and SSRS visualization solutions.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
  • Strong T-SQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, and SQL tuning.
  • Oracle Application Express, JavaScript, CSS, HTML, jQuery and Javascript frameworks preferred.
  • Proficient in Database Administration, Archive and Circular Logging Database, Backup & Restore Management, Process Management, Security Management, Space Management & Reporting.
  • Analysis, Design, Development, Implementation and Testing of various stand-alone and client-server architecture based enterprise application software in Python on various domains.
  • Operate independently or part of a team to provide quality work products to an engagement. Cooperate with the wider community to resolve issues and design solutions.
In addition to my experience & personal qualities, I have a solid educational foundation & a passion for programming. Professionally, I am an Oracle Certified Professional (OCP). I have completed Master of Science (M. SC) in Computers. Currently I am leaning German Language at German coaching Center. I believe a relationship with your company would be mutually beneficial, as I am seeking a challenging work environment where I can exercise my skills to the fullest extent. I look forward to hearing from you, and would love to explain my skills further during an interview. Please find a detailed account of my work history in the attached resume. My resume is enclosed for your consideration. Should you have any questions or wish to schedule an interview, please do not hesitate to call me at +49 015775511703. I look forward to hearing from you soon.                   
I appreciate your time and consideration.   
Sincerely,
Umashankar V
Profileimage by Umashankar Vasanthakumar Team Lead - IT (Information Technology), Senior Software Engineer - IT (Information Technology), Sof from BRLIN Team Lead - IT (Information Technology), Senior Software Engineer - IT (Information Technology), Sof
Register