Senior Software Developer
UST Global
Total years of experience :8 years, 9 Months
Experience in developing, testing and production support of multiple data warehousing
applications, for various fortune 500 clients like PepsiCo, NetApp, Debenhams UK and
Anthem.
Lead the data warehousing offshore team, for various DWBI projects, driving team calls,
mentoring junior resources and onsite client interactions. SME for DWH applications of
the fortune 500 clients
Hands on experience in developing and supporting ETL Mappings using INFORMATICA
Power center (V 9/9.5). Basic level of experience in developing mapping in ODI, Microsoft
SSIS and IBM DataStage.
Experience in coding SQL scripts, stored procedures, functions and macros in Teradata,
IBM Netezza, Oracle, MySQL, Sybase and SAP HANA.
Coding and enhancement of UNIX/LINUX shell scripts to support and automate the DWBI
process.
Experience in using Teradata utilities like FASTLOAD and MULTILOAD.
Experience in monitoring and analyzing large datasets, and performance tuning of SQL
queries whenever applicable.
Basic experience in development of Tableau reports and dashboards.
Basic experience in data modelling using Erwin Data Modeler
Experience in scheduling DWBI jobs using ControlM, knowledge of Autosys and ESP
scheduling tools.
Designing test artifacts based on the proposed Business requirements and
implementation plan.
Functional and regression testing of developed ETL code and OBI EE/Tableau reports and
dashboard.
Test case design and Defect tracking using HP ALM, JIRA and Microsoft VSTS.
Worked in Agile and Waterfall, software development lifecycle models.
Involved in production support activities, as 24/7 On-call for DWBI applications. Hands on
experience in developing ad-hoc on-demand scripts, for trouble shooting live production
issues.
Completed Electronics and communication Engineering under Mahathma Gandhi University, Kottayam , Kerala . Passed with first class