VILVAKUMAR

*** ******* ****** *****, ***** York, ON 647-***-**** adlse3@r.postjobfree.com

www.linkedin.com/in/vilvakumar-vellaichamy-61aa1b183/

ETL DEVELOPER

INFORMATICA DEVELOPER DATA ENGINEER ETL DEVELOPER DWH DEVELOPER POWER BI

Significant IT experience in design, development, customization, testing, and support of business applications using Oracle ERP Client-Server architecture on a number of platforms. With 10+ years of experience in development and support using various technologies; Out of which have 5.2 years of experience in Informatica Power center, Design, development, implementing Data model, support, and testing. Exceptional knowledge in SQL, PL/SQL function and procedure scripting. Worked on Oracle SQL server, DB2 database as well as Informatica Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplet Designer to extract sources, transform data and load into Target. Used Informatica Workflow Manager to create Workflows and Sessions. Highly experienced in developing and implementing ETL processes using Informatica PowerCenter, Informatica TDM, DataStage to move data from sources into target with basic knowledge in Python programming and Tableau.

CORE COMPETENCIES

●Application Development

●Cross-functional Team Liaison

●Implementation & Support

●Building Client Relationships

●Software Architecture & Design

●Software Testing and Debugging

●AIM, Waterfall, & Agile Methodologies

●Performance Tuning & Optimization

●Problem Analysis & Resolution

●Teambuilding & Leadership

●Analytical & Organizational Skills

●Written and Verbal Communication

COMPUTER SKILLS

ETL & Tools: Informatica PowerCenter, Informatica TDM, DataStage, Power Mart Autosys, SVN;Git,Database: Oracle Database, SQLSERVER, DB2, Data Warehousing,Big Data, MS SQL db.; Oracle Tools & Languages: SQL, PL/SQL, MS SQL Pro*C Unix Shell Scripting, XML, Python, Perl, Java; Domain Knowledge: Finance, Banking, Insurance, Retail; Operating Systems: Sun Solaris, HP-UX, UNIX, Windows 95/98/NT/2000/XP, Linux; Change & Incident Management: HP-ALM Service Now and SM7, Control M, Oracle Service Bus, Jira; Reporting Tool: Power BI/ Tableau; Methodology: Agile, Waterfall, SDLC; Utility Tools: SQL*Loader, Toad, SQL Developer.

PROFESSIONAL EXPERIENCE

ETL DEVELOPER August 2019 – October 2020

TD Bank (Contract Full Time) Toronto, Canada

●Responsible for developing SQL script for monthly archiving and purging process. Creating SQL Agent jobs for automating rollback and email notification. Managing code repository using Github and Microsoft TFS. Writing ETL scripts in Informatica Power center and Data Stage to fetch data from different data sources.

●Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.

●Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS)

●Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one.

●Experienced in enhancing and deploying the SSIS Packages from development server to production server.

●Raised change requests, incident Management, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments, during the runs using JIRA ticketing system

●Maintaining the job scheduling database for the automated scheduling system to schedule the execution of application and support batch.

●Scheduling Autosys Jobs Using JIL and Design Batch Jobs Flow.

●Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access.

●Deploy the SQL code changes, AutoSys JIL scripts, into UAT&Prod environments for Risk management system.

SENIOR CONSULTANT April 2018 – June 2019

Dell EMC (Outsourced by Anlage InfoTech Pvt. Ltd.) Bangalore India

●Oversaw the Dell Omega – Sustenance Engineering Support Project that involved Oracle Application in Development, Support and Maintenance, and Activities, wherein all processes follow the Accelerated Implementation Methodology (AIM) and Agile Methodology.

●Expertly built the transformation rules to extract, transform, and load data into the target systems using Informatica PowerCenter 9.1 Designer, by careful source data analysis from various source systems such as Oracle SQL Server, DB2, and Flat-File database.

●Developed the logical and physical data flow models for ETL applications resulting to efficient data integration strategies.

●Scheduling the Batch jobs on Autosys PRODUCTION and TEST Servers according to the request of

●Skillfully designed, developed, automated, and supported complex applications that extract, transform, and load data while identifying and managing interfaces, service levels, standards, and various configurations to ensure proper functionality.

●Eagerly demonstrated proficient knowledge in Informatica PWC & PWX 8.6.1 or 9.X, SQL Server 2005/2008 or equivalent databases, SQL, Oracle/Golden Gate, Windows server 2003/2008, Autosys Scheduling, data files, Web Services, and XML.

TECHNICAL CONSULTANT October 2015 – February 2018

GalaxE Solution Pvt. Ltd. Bangalore, India

●Designed, developed, and tested ETL Mappings, Mapplets, Workflows, Worklets by using Informatica PowerCenter 9.1 and identified efficient and resourceful ways to improve the design and development processes for Health Care Services projects.

●Performed exemplary work in a fast-paced environment under minimal supervision while providing essential technical guidance and support to the team members and worked closely with Onshore and Offshore Application Development Leads.

●Responsibly managed database schema designs, extensive SQL development, integration testing, and other necessary projects through seamless collaboration and consistent support, resulting to achieving the collective goals of the team.

●Consistently imported data from MySQL to HDFS using Sqoop, fixed invalid mappings, handled troubleshooting of the technical problems of the database, and performed unit testing at various levels of the ETL, while being actively involved in team code reviews.

SENIOR CONSULTANT January 2014 – December 2014

Mahathi Software Pvt. Ltd. Bangalore, India

●Competently worked for the sustaining engineering (US) team as an individual contributor, and was an instrumental part of the development & performance team on enhancing, debugging, and tuning the RMS module for versions 12, 13, & 14.

●Directly liaised with customers, along with the internal solution architects to understand and analyze customer issues, especially those that are not reproducible, then propose smart solutions, make reviews, and generate a release build as a localization fix.

CONSULTANT March 2013 – December 2013

Primedia IT International East Riffa, Bahrain

●Significantly involved in support activities such as daily monitoring, which involved morning checks, pre-processing of load, checking the status of each job’s completion, and providing clear communication to business users on load completion or delays.

●Adhered to Service Level Agreement (SLA) processes for all the Severity 2 tickets and provided quality solutions to business requests.

●Displayed a thorough understanding and study of the code by identifying a production bug in the ETL transformations which reduced numerous discrepancies in dealer related information while proactively identifying and urgently resolving issues during data mart load.

ASSOCIATE CONSULTANT August 2009 – February 2013

Atos India Eindhoven Netherland

●Managed the project tasks of customizing and providing support for the Albert Heijn (AHOLD) Retail application in Netherlands.

●Supervised the development of new objects and interfaces related to the business requirements through the use of Oracle PL/SQL.

●Actively participated in defect fixing, testing support, and development activities for Informatica/ETL tool and Cognos reports.

●Delivered commendable performance on the customization and support of the Philips ECS application project in Netherlands.

EDUCATION

Master of Arts, – Loyola College, Madras University, India

Bachelor of Arts – Madras Christian College, Madras University, India

Diploma in Computer Application – Liba Loyola College Information Center, India

CERTIFICATIONS & TRAININGS

Oracle Certificate Associate (OCA) – Oracle Corp

Information Technology Infrastructure Library (ITIL) – ATOS

Testing Tool (WinRunner, LoadRunner) – STC

Contact this candidate