Domain Architect

• Oct 2016 - Present

Programmer

Senior Software Engineer

• Mar 2015 - Jul 2015

• Creating UNIX scripts for loading and transforming data from extraction of files • Involved in warehousing concepts – fact and dimension loading. • Creating solutions that is basis for multiple retailers/manufactures to avoid repition of code. • Use of external tables for load of huge data. • Performance tuning of data using hints, gathering STATS, etc. • Transforming data in the database using pivot and unpivot operations • Creating UNIX scripts for loading and transforming data from extraction of files • Involved in warehousing concepts – fact and dimension loading. • Creating solutions that is basis for multiple retailers/manufactures to avoid repition of code. • Use of external tables for load of huge data. • Performance tuning of data using hints, gathering STATS, etc. • Transforming data in the database using pivot and unpivot operations

IT Analyst

• Feb 2013 - Feb 2015

• Creating scripts for automation of manual reports and handling adhoc tasks. • Working with SQL queries and PL/SQL procedures and packages • Analysis on UBR Restructure that impacts the reporting criteria of critical reports. • Creation of scripts in Qlikview for processing huge data files and creating automated reports. • SSIS package creations for loading huge data into database. • Involved in CTB(Change The Bank) activities. • Requirement gathering for re-engineering of… Show more • Creating scripts for automation of manual reports and handling adhoc tasks. • Working with SQL queries and PL/SQL procedures and packages • Analysis on UBR Restructure that impacts the reporting criteria of critical reports. • Creation of scripts in Qlikview for processing huge data files and creating automated reports. • SSIS package creations for loading huge data into database. • Involved in CTB(Change The Bank) activities. • Requirement gathering for re-engineering of existing application and functional testing. Show less • Creating scripts for automation of manual reports and handling adhoc tasks. • Working with SQL queries and PL/SQL procedures and packages • Analysis on UBR Restructure that impacts the reporting criteria of critical reports. • Creation of scripts in Qlikview for processing huge data files and creating automated reports. • SSIS package creations for loading huge data into database. • Involved in CTB(Change The Bank) activities. • Requirement gathering for re-engineering of… Show more • Creating scripts for automation of manual reports and handling adhoc tasks. • Working with SQL queries and PL/SQL procedures and packages • Analysis on UBR Restructure that impacts the reporting criteria of critical reports. • Creation of scripts in Qlikview for processing huge data files and creating automated reports. • SSIS package creations for loading huge data into database. • Involved in CTB(Change The Bank) activities. • Requirement gathering for re-engineering of existing application and functional testing. Show less

System Engineer

• Dec 2009 - Dec 2012

• Creating UNIX and PL/SQL scripts for automation of manual jobs. • Day-to-day communication of technical/business clarifications to onsite team and co-ordinate with offshore for problems faced and solution to fix the same. • Meet up with Business team to baseline the requirements of the daily and weekly releases. • Designing the business rules for the daily and weekly releases. • Review and perform the impact analysis of the new project requirements on production online… Show more • Creating UNIX and PL/SQL scripts for automation of manual jobs. • Day-to-day communication of technical/business clarifications to onsite team and co-ordinate with offshore for problems faced and solution to fix the same. • Meet up with Business team to baseline the requirements of the daily and weekly releases. • Designing the business rules for the daily and weekly releases. • Review and perform the impact analysis of the new project requirements on production online programs. • Testing in UAT to make sure the online campaigns work correctly. • Testing in QA Tool for internal verification. • Scheduling of batch jobs using the Unicenter Autosys Job Management tool. • Release planning and implementation. Show less • Creating UNIX and PL/SQL scripts for automation of manual jobs. • Day-to-day communication of technical/business clarifications to onsite team and co-ordinate with offshore for problems faced and solution to fix the same. • Meet up with Business team to baseline the requirements of the daily and weekly releases. • Designing the business rules for the daily and weekly releases. • Review and perform the impact analysis of the new project requirements on production online… Show more • Creating UNIX and PL/SQL scripts for automation of manual jobs. • Day-to-day communication of technical/business clarifications to onsite team and co-ordinate with offshore for problems faced and solution to fix the same. • Meet up with Business team to baseline the requirements of the daily and weekly releases. • Designing the business rules for the daily and weekly releases. • Review and perform the impact analysis of the new project requirements on production online programs. • Testing in UAT to make sure the online campaigns work correctly. • Testing in QA Tool for internal verification. • Scheduling of batch jobs using the Unicenter Autosys Job Management tool. • Release planning and implementation. Show less