Summary
Overview
Work History
Education
Skills
Certification
Work Qualification
Timeline
Generic

Vinopriya Udayakumar

Mississauga,ON

Summary

As a Software Engineer Developer, proactive team player, and highly motivated assiduous individual with overall 3 years of total IT experience in Ab Initio development, shell scripting, and DB2 data warehouse applications play significant roles in banking and finance . Proficient in all phases of SDLC and Agile methodologies with extensive experience in Requirement Analysis, Design, Development, deployment, and Status Reporting.Experienced in full project life cycle from design to implementation to integration. Detailed understanding of Multistage components and Continuous graph concepts. Expertise in parallel processing concepts and successfully managed multiple development, modernization projects, and Production Support.


Soft Skills and Techno-Functional Abilities:

• Analyze the user stories, assess the code changes and estimates required for the overall effort

• Develop the technical solutions to support the data needs of American Express Global commercial applications including Regulatory, Third-party, and External customers

• Partner with Portfolio Solution Architect in preparing Solution Architecture Review documents and disaster Recovery documents to be compliant with the Software Development Life Cycle

• Hands-on experience and strong proficiency in ETL Ab Initio Batch, GDE, and EME

• Designed and deployed applications in different models such as star and snowflake schemas.

• Experience in Project coordination using the Onsite-Offshore model

• Designed, developed, and deployed solutions to perform Data Analysis, Data masking for PI Data, Data Cleansing, Data Transformation, Data Migration and Data validation Ab initio.

• Excellent knowledge of Data Extraction, Transformation and load to the target systems

• Prepare System Requirement Specification Documents, High-level Design, and Low-Level Design Documents.

• Conceptualized, designed, developed, and socialized variable reusable utilities and Unit Framework to perform unit Testing and validate the data per Design Document using Unix Shell Scripts and Ab initio metaprogramming.

• Designed and developed the generic pset creation to create the psets to execute the code using Unix shell scripting.

• Designed and built DML to DDL creation using Unix shell scripting to convert the DMLs to DDLs across environments and applied the rules to convert the fields.

• Worked with senior stakeholders to define high-level business requirements and translate business requirements into comprehensive, complete, and accurate functional and technical specifications

• Proficient in writing Business Requirement Documents, Software Requirement Specifications and customizing already existing business practices, workflows, activities, and deliverables

• Preparing graphical depictions of use cases including Sequence diagrams, activity diagrams, and use case diagrams including the business workflow

• Provide technical support to promptly resolve escalated incidents/outages

• Had a work experience in Service Now Tool and have knowledge on Python

• Have knowledge in designing ,Developing and testing ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.2, Analyzing data from various sources, including databases and flat files

• Works closely with other subject matter experts to help design and build solutions for a multitude of applications, including; batch processing, OLTP, OLAP and data and data warehouse architecture

• Facilitate Project Documents & Requirements walkthrough for Impacted Application's Test Team along with Business to ensure successful project delivery.

• Excellent verbal and written communication with the ability to effectively articulate an communicate vision, possibilities, and outcomes across all levels in the organization.

• Proficient with MS Office with a good understanding of Visio and Sharepoint.

• Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Software Engineer

Syntel
11.2013 - 10.2014
  • Project Title: EMEA GDR Data Integration – Markets in the UK and Spain
  • Client: American Express
  • The main objective of this overall initiative is to provide consistent, quality data to clients and internal systems to help manage their commercial card programs. It provides the core infrastructure to receive/Store transactions, hierarchy, and demographic data related to commercial cards on G*. The core includes both data currently stored in GDR as well as data not currently stored. The data is necessary to maintain existing client/internal MI reporting as well as allow for the decommissioning of regional reports as accounts migrate to the G* platform.
  • Involved in the analysis, design, and preparation of the functional specifications documents and detail design documents.
  • Improved software performance by identifying and resolving bottlenecks in the code
  • Development of Ab Initio ETL graphs.
  • Handling all the calls with business from a Technologies standpoint and driving internal status calls and meetings
  • Collaborated with cross-functional teams to deliver high-quality software products on schedule
  • Looking after the quality-related process for the project to prepare test plans and test data for assigned work, perform unit/program tests, and apply fixes as needed.
  • Prepared the test cases such as Unit and Component test cases, the same had been uploaded in QC.
  • Create/Update documentation for the application/testing as code changes are applied.
  • Coordinating Weekly deliverables review and status reporting.
  • Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check-in and checkout were used for this purpose.
  • Fixing the Defects by analyzing the root causes of the defect and arriving at the resolution before modifying the graphs
  • Implementation and post Implementation activities

Analyst Programmer

Syntel
02.2013 - 10.2013
  • Project Title: APA wave 2 GDR data integration
  • Client: American Express
  • The objective of this project is to bring profile data from Global corporate client profile (GCCP) to Global data repository (GDR) and transactional data from Globe Star (G*) to GDR. The tables in GCCP are highly normalized and a replica of GCCP table structure is created in the IRI schema for the tables that are required by the process and replication is done by the Golden Gate tool. DTU denormalization process applies business rules to extract data needed for client reports and data files.
  • Involved in analysis, design, and preparation of functional specifications documents and detailed design documents.
  • Coordinating with all End-to-end interfacing system teams.
  • Conducting reviews for code and verifying if all design requirements are met.
  • Development of Ab Initio ETL graphs.
  • Handling all the calls with business from Technologies stand point.
  • Driving internal status calls and meetings
  • Prepare test plan and test data for assigned work, perform unit/program tests, and apply fixes as needed.
  • Prepared the test cases such as Unit and Component test cases, the same had been uploaded in QC.
  • Create/Update documentation for the application/testing as code changes are applied.
  • Coordinating Weekly deliverables review and status reporting.
  • Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check-in and checkout were used for this purpose.
  • Fixing the Defects by analyzing the root causes of the defect and arriving at the resolution before modifying the graphs.
  • Looking after the quality-related process for the project and implementation activities.

Analyst Programmer

Syntel
04.2012 - 01.2013
  • Project Title: Pegasus India/Singapore Conversion
  • Client: American Express
  • This Pegasus conversion process is revisited for India and Singapore markets in which a new hierarchy comes into existence and it is a single-time historical update. The POD hierarchies were replaced with the POA hierarchies where the 9-byte control accounts were converted into 15-byte control accounts to bring in uniformity. Because of this change in the control account level, the historical transactions in the GDR database had to be updated as per the POA hierarchy.
  • Involved in the requirement gathering for the data warehouse creation
  • Designing graphs through mapping documents to load data into the tables using transformations.
  • Created a fully automated process that could transform the received data into a type of data loaded into the table, and load the proper data into a specific table.
  • Coordinating with all the End-to-end interfacing system teams. • Conducting reviews for code, and verifying if all design requirements are met.
  • Development of Ab Initio ETL graphs.
  • Handling all the calls with business from a technology standpoint.
  • Receive and appropriately load the file for transaction data properly into a table after loading check on amount values to ensure it's not disturbed.
  • Create load files from received data to downstream.
  • Prepare test plan and test data for assigned work, perform unit/program tests, and apply fixes as needed.
  • Prepared the test cases such as Unit and Component test cases, the same had been uploaded in QC.
  • Create/Update documentation for the application/testing as code changes are applied.
  • Coordinating Weekly deliverables review and status reporting.
  • Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check in and checkout were used for this purpose.
  • Fixing the Defects by analyzing the root causes of the defect and arriving at the resolution before modifying the graphs.
  • Co-ordination and knowledge sharing amongst team member

Education

Master of Science - Master of Computer Application

RMD Engineering College
Kavarapettai,TamilNadu,India
04.2011

Bachelor of Science - Bachelor of Computer Science

Sri Devi Arts And Science College
Ponneri,TamilNadu,India
04.2008

Skills

  • Domain Banking and Financial Services
  • Technical AbInitio, Informatica Powercenter 102, Unix/Linux scripting, SQL, DB2,Python
  • Test Management Tools│ Quality Center/ALM 115 Rally JIRA
  • Scheduling Control M
  • Database DB2, Oracle 11g & SQL Server 2008
  • Operating Systems Windows 10

Certification

• Microsoft Azure Fundamental AZ-900. Completed

• Certified on DB2 9 Fundamental. Completed

• GCP-Associate Cloud Engineer. In-Progress




Work Qualification

Work Qualification : Open Work Permit

Timeline

Software Engineer

Syntel
11.2013 - 10.2014

Analyst Programmer

Syntel
02.2013 - 10.2013

Analyst Programmer

Syntel
04.2012 - 01.2013

Master of Science - Master of Computer Application

RMD Engineering College

Bachelor of Science - Bachelor of Computer Science

Sri Devi Arts And Science College
Vinopriya Udayakumar