Vignesh Sekar
SINGAPORE
Summary
14 years of professional IT experience spanning across multiple technologies and platforms. 5+ years of experience as a Technical Business Analyst in Bigdata & Data warehouse and 11 + years of experience in ETL & DWH development which includes Informatica, Business Objects, Tableau, Oracle, PLSQL, Teradata, DB2, SQL server.
Overview
14
14
years of professional experience
Work History
BA Cum Project Manager
DBS Bank
Singapore
04.2019 - Current
- Prepared Business Requirement Document(BRD) to capture business requirement from Product owners.
- Prepared Function Specification Document(FSD) to provide detailed requirement by citing examples, providing flow diagrams, including upstream/downstream impact assessment details to ensure business as usual. Maintained clear communication between stakeholders and technical team.
- Provided impact analysis by identifying source tables and prepare source to target mapping to be used for technical specification.
- Collaborated with technical lead to calculate number of man hours required and worked on costing and vendor payments.
- Conducted daily standup with technical team to understand progress and address blockers. Achieved project deadlines by coordinating with vendors.
- Verified test cases, execution results and validated results in backend, performed sanity and functional testing in SIT/UAT and involved in business verification in production environment.
- Coordinated across teams for UAT support and issue tracking.
- Mentored new joiners by providing business overview and conducted knowledge transformation sessions within team.
Business Analyst/Senior ETL Consultant
DBS
, SINGAPORE
05.2016 - 04.2019
- Develop ETL mappings to source in data from data mart and apply required transformations.
- Fine tune long running Mappings/Store Procedures in BAU.
- Analyzed key aspects of business to evaluate factors while migrating to new stack.
- Understanding the requirement by conducting regular stand ups with Product Owners for enhancements.
- To carry out Impact assessment thoroughly to make sure existing flow is not disturbed.
- Understand the country specific reporting requirements and implement precisely.
Senior ETL Consultant
UOB
, SINGAPORE
05.2014 - 05.2016
- Gather requirements from FINANCE counter parts and prepare the technical document and conduct feasibility study.
- Prepare ETL mappings using Informatica power center.
- Write shell scripts to invoke informatica jobs from CTRL M environment.
- Schedule jobs based on the business requirements to run on specific business days.
- Create reusable transformations, worklets and mapplets to implement common logic across different modules.
- Worked on Oracle database migration from 10g to 11g.
- Served as team leader for cross-functional teams, making decisions on team-wide goals, timelines and personnel assignments.
- Mentored and guided employees to foster proper completion of assigned duties.
ETL Developer
NCS
, SINGAPORE
10.2012 - 05.2014
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL, CSV and flat files.
- Write code to pick ETL mappings from file list.
- Write ETL logics in unix shell scripts to handle small volume files.
- Used PLSQL store procedure extensively to create ETL logics.
- Used cursors and triggers to facilitate fast loading.
- Used java transformations to facilitate if else statement to change configuration table for individual workflows.
- Used IBM CLEAR CASE & CLEAR QUEST for object migration to higher environments.
ETL Developer
HP
, INDIA
07.2011 - 10.2012
- Design ETL mappings as per HLE and complete as per agreed time line.
- Created reusable Informatica components.
- Creation of reports in Business objects repository and debug few long running reports by fine tuning ETL/PLSQL store procedures.
- Write UNIX shell scripts to invoke Informatica jobs.
- Work with on site team to understand business requirement and prepare ETL design document.
ETL Developer
CTS
, INDIA
07.2008 - 06.2011
- Work with onsite team to understand business requirement and code ETL logics.
- Write PLSQL store procedure to call if from Informatica store procedure transformation.
- Use Informatica Lookup, Expression, joiner & update strategy to SCD transformation.
- Worked on Teradata migration and written MULTI LOAD program to facilitate faster source file loading.
Education
Bachelor of Engineering Technology - Production Technology
05.2008
Skills
- Thorough knowledge in regulatory reporting as well as MIS reporting
- Good at reading/writing in ETL tools Informatica, SSIS, Business Object, Unix shell scripts and PLSQL store procedures
- Good understanding in Basel reports
- Good at Relational databases like Oracle, Teradata, MS SQL and open source Maria DB
Timeline
BA Cum Project Manager - DBS Bank
04.2019 - Current
Business Analyst/Senior ETL Consultant - DBS
05.2016 - 04.2019
Senior ETL Consultant - UOB
05.2014 - 05.2016
ETL Developer - NCS
10.2012 - 05.2014
ETL Developer - HP
07.2011 - 10.2012
ETL Developer - CTS
07.2008 - 06.2011
Madras Institute Of Technology - Bachelor of Engineering Technology, Production Technology