Vignesh Sekar
DBS Bank
SINGAPORE
14
years of professional experience
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.
Work History
BA Cum Project Manager
7 Years 6 Months- 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
2 Years 11 Months- 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
2 Years- 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
1 Year 7 Months- 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
1 Year 3 Months- 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
2 Years 11 Months- 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
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 - CurrentRead More
Business Analyst/Senior ETL Consultant
DBS
05.2016 - 04.2019Read More
Senior ETL Consultant
UOB
05.2014 - 05.2016Read More
ETL Developer
NCS
10.2012 - 05.2014Read More
ETL Developer
HP
07.2011 - 10.2012Read More
ETL Developer
CTS
07.2008 - 06.2011Read More
Madras Institute Of Technology
Bachelor of Engineering Technology from Production Technology
Read More