Aug 2013 – Apr 2015 · 1 yr 8 mos · Columbus, Ohio Area

• Working in Chase enviorment for one of the high profile project which has a direct impact on customer profiling.
• Been involve in understanding the business requirement and providing the most efficient solution with different approaches considering volume of data getting processed, meeting SLA requirement, Scalability, Maintainability, parallel processing is a part of my role.
• I am involve End to End business solution also in performance tuning of the code,Automation of process by ETL tools,gudiance to peer colleagues and standard improvements are some of the day to day activities.

Jul 2011 – Aug 2013 · 2 yrs 1 mo · New Jersey

• Worked on NextGen analytics and business intelligence product offerings for Citi Group providing them solutions on ETL and performance front for their build in Global Transaction Services (GTS) business.
• Harness Utility:
• Skills used: Abinitio 3.02,Oracle,Unix,Java
• It is performance testing utility, which gives flexibility to user to scale up and scale down the data as per user requirement. Addition to it also gives the user to end to end integration of application.
• It is innovative approach used for getting the performance testing of applications robust.
• Mart Applications:
• Skills Used: Ab Initio 3.02, Oracle, Unix
• This project is critical to success of the bank and its share in a tough environment for Financial Services Industry.
• Responsibilities:
• Team Lead/Sr.Software Engineer
• Supervise the day-to-day activities of ETL developers in the capacity of Team Lead
• Assign tasks and track progress.
• 30/30 (30 minutes every 30 days) feedback sessions with my team members
• Design/Build Graphs
• Design and build reusable ab initio graphs and sub-graphs
• Design custom Ab Initio graphs
• Perform design and code reviews
• Use knowledge as a designer to provide insight into the designs to developers
• Provide design approach to designers/developers when they are stuck
• Forum for discussing common issues
• Onshore/offshore coordinator:
• Coordinating between onshore and offshore activities/tasks
• Task assignments and reporting progress to onshore counterparts.
• Issue Driver/Tracker/Reporter:
• Providing developers with quick paths to resolution for their issues
• Tracking and status reporting on issues
• Helping developers determine the severity of the issues
• Filter out issues that can be handled offshore versus those that need to be followed up with the designer

Oct 2009 – Jul 2011 · 1 yr 9 mos · PUNE, FRANCE

• FT-Herman was basically responsible for extracting the data from the Enterprise Data
• Store (Oracle Apps), performing the required transformations on the data as per the business requirements and loading this data into the Oracle Apps and DW-STORES database.
• Ab-Inito Team is responsible for the end user data generation is as per the business expectations. As there are process which runs for 24*7, so there is huge amount of data which is processed on the daily basis. So it is very important to ensure the quality of data is as per the standards or not. To ensure that we are using another DW-MARTS. That is called as audit. These audit checks are execute as per the audit points; Which tracks the quality of data throughout the process.
• The goal of DATA INTERFACER is to consolidate data from CDW, FDR, Fraud, and ADS Warehouses into a single source of consumer card data which supports business requirements for reporting and analysis. It provided a single view of consumer data and allowed new applications (e.g. RDC) to be added in a timely fashion with reduced cost.
• DATA INTERFACER was made up of 3 Projects:
• Data Model Consolidation
• ETL Standardization
• Technical Infrastructure Upgrade
• Customer-centric consumer model, without explicit customer-account relationship
• Retail Dual Telephone Card
• Authorization (ASC & CD tables)
• Billing Promotions Subject Area
• Fraud Subject Area

May 2008 – Sep 2009 · 1 yr 4 mos · Pune

• Worked on development of various Data Warehousing projects to automate the processing of several customer related information in order to provide our client “Discover Financial Services”, required data.
• Extracted, transformed, cleansed, and loaded (ETL) various Telemarketing Solicitation information for DFS in Teradata Database
• Providing Support to various applications running on production, developed by Card Member Ware House.
• Created MLOAD script for UNIX to load various processed load files into the Teradata Database.
• Created different design documents for various applications as per the Client Requirement.
• Card Member Decision Support System (CDSS) Team:
• CDSS was basically responsible for extracting the data from the Enterprise Data
• Store (EDS), performing the required transformations on the data as per the business requirements and loading this data into the IDS and CIMS database.
• Integrated Data Store and Data Quality (IDS) Team:
• Worked on the development and maintenance of the applications for the Integrated Data Store. The key feature of this data store is to maintain the quality of data which is loaded to the Teradata Tables. To achieve the data quality, another special data mart is maintained which is used as the standard reference data. Various Referential Integrity checks were built using this Reference Data Mart. This data in the IDS is the current data which is maintained in the database over a month’s time

Jan 2008 – Jan 2008 · 0 mo · Pune Area, India

• Developed in house application on dot net environment called as Royalty Reporting System.
• Worked with End client understanding there needs and translating to technical requirements.
• Generation of unit test cases and testing the application is part of my responsibility.
• Have also worked in mobile game testing, and reporting the bugs to development team.

Sep 2004 – Mar 2005 · 6 mos · Pune Area, India

• Working on call support for day to day, customer requirements.
• Maintaining ADS directory.
• Network trouble shooting and fixing issues permanently. Switching of network
• From primary to backup etc.

Jan 2002 – Jul 2004 · 2 yrs 6 mos · Jabalpur, Madhya Pradesh

• Working on the RDBMS environment for report generation.
• Generating of customized forms on oracle 6i.
• Working with end terminal customer on there technical issues. Providing resolutions in SLA's.
• Maintaining high data volume for daily transaction.