BI Manager / IT-Consultant

• May 2019 - Present

Lead BI Developer

• Aug 2017 - Apr 2019

Working as a lead developer for an ETL requirement with DNB.Responsibilities:- Analysis, Solution design, detailed design, coding and testing. High quality Development that ensures good performance and reusability. Work in Agile Development and Test Driven Development (TDD). Work on ticketing systems like Service Now.  Involve in knowledge transfer workshops. Interact with upstream and downstream applications and make sure the functionality switches with low impact.  Work on Reusable components and Scripts to reduce redundancy and space utilization. Work on Data Modelling, fixing the issues, Automation scripts for migration etc. Designed several optimized jobs to help time saving. Also, helped better design the application in a scalable manner. Involve in Installation, Production monitoring of monthly and daily processing cycles ensuring business continuity. Interact with clients on a regular basis to elicit architectural and non-functional requirements.  Ensure quality, performance, scalability, reliability, availability and maintainability Walkthroughs with the clients and offshore team membersTechnologies and Tools: DataStage 9.1, Teradata, SQL, Unix, DB2, Service Now, Erwin, SVN Show less

Technology Lead

• Aug 2016 - Jul 2017

Worked as a lead developer on a server migration project for Bank Of America. Responsibilities:- Design solutions in ETL without disturbing the existing functionality of each module in the Old server. Test each module, compare the results. Ensure quality and data verification with downstream applications.  Design reusable components and solutions wherever possible. Analysis, detailed designing, coding and testing. Worked in Agile Environment and have exposure to Test Driven Development (TDD). Exposure to ticketing systems like Service Now.  Exposure to Data Modelling, fixing the issues, Automation scripts. Designed several optimized jobs to help time saving. Also, helped better design the application in a scalable manner. Developed project for new product launches for the Bank. Involved in Production monitoring of monthly and daily processing cycles ensuring business continuity. Interact with clients to elicit architectural and non-functional requirements.  Ensure quality, performance, scalability, reliability, availability and maintainabilityTechnologies and Tools: DataStage 9.1, DB2, Autosys, Linux and Service-Now. Show less

Technology Analyst

• Jan 2015 - Jul 2016

Worked as a lead developer for an American Express ETL and data modelling requirement that involves New Product Launch system for the bank.Responsibilities:- Worked in Development of jobs in ETL and DB2 stored procedures that supports as backend for New product launch (NPL) application of the bank. Analysis, detailed designing, coding and testing. Worked in Agile Environment and have exposure to Test Driven Development (TDD). Exposure to ticketing systems like Service Now.  Performance improvement scripts to validate each stored procedure to ensure faster request processing from front-end. Designed several optimized jobs to help time saving. Also, helped better design the application in a scalable manner. Took overall responsibility for new product launches for the Bank with backed development project. Involved in Production monitoring of monthly and daily processing cycles ensuring business continuity. Interact with clients to elicit architectural and non-functional requirements.  Ensure quality, performance, scalability, reliability, availability and maintainability Walkthroughs with the clients and offshore team membersTechnologies and Tools: Informatica 9.1 & 9.6, SQL, Unix, DB2 Stored Procedures Show less

Techology Analyst

• Jan 2013 - Dec 2014

Worked as a lead developer for the same banking domain project with one of the leading banks of US.

Senior System Engineer

• Jan 2011 - Dec 2012

Worked as a developer for a banking domain project with one of the leading banks of US.Responsibilities:- Worked in Development, maintenance, support and optimization of the project  Analysis, detailed designing, coding and testing. Worked on Server migration from Unix to Linux.Technologies and Tools: DataStage, DB2, Unix, Linux, VM-Nomad and CTRL-M.

System Engineer

• Apr 2010 - Dec 2012

Worked as a developer for a retail domain based JCPenny project. Responsibilities:- Analysis, detailed designing, coding and testing. Involved in Production monitoring of monthly and daily processing cycles ensuring business continuity. Interact with clients to elicit architectural and non-functional requirements Technologies and Tools: DataStage7.5, Mainframe JCL, COBOL, DB2 and Unix

Systems Engineer Trainee

• Nov 2009 - Mar 2010

Intern

• May 2009 - Oct 2009