Abinitio lead
Resume:
Basudev Paikaray
Jersey City, NJ, 07306
********.*******@*****.***
Cell: +1-201-****-***
EDUCATION
• MCA securing 81%, Berhampur University, Orissa, India, 2003
• B.Sc (Physics Hons) scoring 74%, Utkal University, Orissa, India, 1999
• I.Sc scoring 69.8%, CHSE, Orissa, India, 1996
• 10th scoring 75%, BSE, Orissa, India, 1994
TRAINING PROGRAMME ATTENDED
• Attended training on Ab Initio performance tuning by Ab Initio Corporation at Wipro Technologies Ltd.
• Attended Training on Data warehousing concept at TCS, Kolkata.
• Attended training on Ab Initio by COE TCS, Kolkata.
TECHNICAL EXPERIENCE
• 6 years of technical expertise on Ab Initio 2.14.12/2.15, Oracle 9i/10g/11g, PL/SQL, UNIX Shell Scripting.
• 2 years of experience on Talend Open Studio v 3.2.3/4.0.3/4.1.3
• 4 years of experience on ETL Designing.
• Applied for H1B USA Visa extension
WORKING EXPERIENCE
• Currently working for Wipro Technologies Limited, Bangalore from APRIL 2008 to Till Date.
• Worked for Tata Consultancy Services Limited from OCT 2005 to APRIL 2008.
• Worked for DRDA, Khurda, Orissa from Feb 2004 to OCT 2005.
EXPERIENCE SUMMARY
TOTAL EXPERIENCE: 8 years
DOMAIN KNOWLEDGE
• Banking & Finance(4 years)
• Telecom (2.6 years)
• Finance(1.6 years)
COMPUTERS WORKED ON
Computer System/Programming Languages/Special Software
• UNIX SERVERS (HP, SUN SPARC), PC (PENTIUM –III, IV)
• C, C++, PL/SQL, Core Java, D2K, VB 6.0, COBOL, HTML, DHTML,
• UNIX SHELL SCRIPTS
OPERATING SYSTEM
• UNIX (SCO, SUN SOLARIS, HP)
• WINDOWS 9x/2000/NT/XP
• Ab Initio Co-Operating System Version 2.14.122/2.15
• TalenD Open Studio v 3.2.3/4.0.3/4.1.3
DATABASE
• Oracle 9i/10g/11g
• Teradata
• SQL Server 2000/2005
• MS Access
TOOL
• Ab Initio Graphical Development Environment (GDE) Version 1.14.39/1.15
• Enterprise Metadata environment
• Talend Open Studio v 3.2.3/4.0.3/4.1.3
• SVN Tortoise
• TOAD, SQL Developer
• SQL * Loader
• Clarify eFrontOffice
• Remedy
• PR-Tool
• Actuate Reporting tool
PROJECT EXPOSURE
April 2010 to Till date Wipro Technologies Limited
Project Title Metrics Automation Platform
Client Citi Group Global Markets Inc., USA
Position Technical Lead
Responsibilities Analysis & requirement gathering, building the design, coding and unit testing, project planning & estimation. Project coordination across globe and responsible for deliverables. Technical support to team members. Prod support and bug analysis & fix.
Operating System HP UNIX, 2000/XP
Languages Oracle 10g/11g, PL/SQL, UNIX Shell Scripting
Special Software TalenD Open Studio v 3.2.3/v 4.0.3/v 4.1.3
Work Location(s) Warren, NJ, USA
Project Description
The MAP application is developed to have a single dashboard for all management reporting. The objective of MAP is to have Quantitative Measurement & Analysis of current performance of business against organization objectives. The Balance Sheet Exposure Report (BSER) is an automated weekly reporting package in the MAP application that reports various metrics such as Cash breaks, Fails, internal breaks, suspense breaks, Stock Depository breaks and payables & receivables. We extract the data in form of flat files for each metrics directly from various external source systems across the globe for NAM, APAC, EMEA and LATAM regions; transform the data based on customer business logic and load into Metrics Data Warehouse (MDW). The reports are generated from the normalized summary and historical data using the front end tools Java Flex and Business Objects technologies.
Sep 2009 to April 2010 Wipro Technologies Limited
Project Title ORE DTS – DDE Migration
Client Capital One Auto Finance, USA
Position Technical Lead
Responsibilities Building high level design, technical design, technical
advice to high level design, coding and unit testing,
technical support to team members, team coordination.
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, SQL Server 2000/2005, UNIX Shell
Scripting
Special Software Ab Initio Co-Operating System v 2.25
Work Location(s) Chennai, India
Project Description
The objective of this work stream is to migrate the ORE DTS Live on jobs to Ab Initio DDE Platform. As part of conversion, we develop IT Conduct it to pull the data from heterogeneous sources (Oracle DB, SQL Server DB and Flat files) and do direct loads for generic packages. Similarly, we also pull the data and transform it using the business logic and load for the custom packages.
Sep 2009 to Nov 2009 Wipro Technologies Limited
Project Title DHW Strategy
Client Capital One Auto Finance, USA
Position Technical Lead
Responsibilities Built Technical Design, coding, unit testing, unit test plan and test
cases preparation, TD-DRC, Code Review Checklist, Build Review
Report, SMTD
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio
Work Location(s) Chennai, India
Project Description
Capital One® is a diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK, and Canada. The DWH Strategy is an enhancement project for CapitalOne IT Application Services. IT Application Delivery Team in IT Application Services is responsible for the delivery of employee work force, and other business processes where data transmission is necessary to a build the report. Currently, Microsoft DTS packages help to move the data from EWFM database and load into the ORE database in SQL Server 2005 where the report is generated manually by joining target tables. The EWFM data movement project aims to create a new interface between the EWFM and ORE DB and extracts the data from EWFM DB, prepares clean files. The clean files will be transformed using a new custom logic and loads the load ready files into 4 target tables in ORE DB. The BI reports will be generated directly from the target tables.
April 2009 to August 2009 Wipro Technologies Limited
Project Title MISED CD
Client Capital One Bank, UK
Position Senior Developer
Responsibilities Coding, unit testing, unit test plan and test cases preparation,
Code Review Checklist, Build Review Report, SMTD
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio
Work Location(s) Bangalore, India
Project Description
The IT Application Delivery Team in IT Application Services is responsible for the delivery of marketing campaigns, and other business processes where data transmission is necessary to a third party, Williams Lea. The current working practice is to supply this data via encrypted email and encrypted CD. In addition to this Capital One provide Sentinel Card Protection [SCP] to customers through a third party insurance vendor, Affinion. At present customer details are being sent to these vendors by email on a daily basis and by encrypted CD on a monthly basis. A monthly file is also sent from Affinion to COBEP, currently via encrypted CD. The MISED CD project aims to create new interfaces to deliver a compliant data movement solution for these vendors. The solution will involve scheduled jobs transferring files from a secure data store via the DDE and EDE to the vendors via a new VPN connection and SFTP to Affinion, and use of the existing MPLS connection and Connect Direct to Williams Lea.
January 2009 to April 2009 Wipro Technologies Limited
Project Title Capital One MO2 ICM MI
Client Capital One Bank, UK
Position Designer
Responsibilities Built Technical Design document, coding, unit testing, unit test plan and test cases preparation, TD-DRC, Code Review Checklist, Build Review Report, SMTD.
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio, Teradata
Work Location(s) Bangalore, India
Project Description
Capital One® is a diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK, and Canada.
The MO2 ICM MI project is setup to automate:
a) The extract of data from the ICM system into a flat file, and
b) The load of the flat file data into EDW (Enterprise Data Warehouse) for analysis and reporting purposes.
In the current process, Capital One’s telephony engineers will extract the information from the ICM system, transform that data and store it to allow Operations Analysts to use the data to produce vendor performance metrics & reports via a manual process. No additional operational reporting is currently performed over this data due to its unreliability and incompleteness. This process is manual, performed on an ad hoc “side of the desk” basis and occupies around two hours each time it is performed (generally on a monthly basis).
Supplier invoice and performance payments are based on metric data they provide – although the above process enables some ‘sense checking’ of this data it does not support true invoice reconciliation or accurate independent verification of performance claims.
Equally the current MI does not provide granularity of data available in the ICM or analysis tools that enable performance improvement opportunities to be identified and/or tested.
In the proposed process, interface between internal systems (Staging server and DDE) will be implemented in Ab Initio using the UK DDE environment. Interface between ICM Server and Staging Server will be implemented through VB Scripting.
The data is extracted from the ICM database on daily basis and flat files are generated. The VB Script doing this task is mounted on the Staging Server. A signal file is also created on the Staging Server for every data file.
The SFTP job on the DDE will pull the flat file with its corresponding signal file from Staging Server through SFTP and land them in the init area.
The data files are validated against their corresponding signal files. If valid they are partitioned, sorted and placed in the clean area. These clean files are then transformed as per the system and data requirements and landed as load ready files. These load ready files are then loaded into the staging table and then from staging table to the main table on EDW. After the load, statistics are collected on the main table and a data quality check is done on the load by comparing the load ready file to the data loaded in the table. If there are any rejects during the load they will be sent to the MIS Application Support team for further analysis.
November 2008 to December 2008 Wipro Technologies Limited
Project Title Capital One I-Accept Phase 2
Client Capital One Bank, UK
Position Designer
Responsibilities Built Technical Design document, coding, unit testing, unit test plan and test cases preparation, TD-DRC, Code Review Checklist, Build Review Report, SMTD.
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio, SQL Developer
Work Location(s) Bangalore, India
Project Description
Capital One® is a diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK, and Canada.
The end user fills up his personal and bank a/c details for Credit Card (Classic, Master, and Platinum etc.) on an online internet application which updates on RAID server. The user account information is stored in VECTUS database for a temporary period of 1 year via Tuxedo interface.
This project is an enhancement to the I-Accept Phase 1. The daily transaction data are extracted from VECTUS database using a generic graph. The wrapper script calls the deployed script of the generic graph which in turn passes a parameter that defines dbc file name, sql query, output file dml, output base file name, output file pattern etc. and generates MFS file. The transformation graph transforms the data file as per business requirement and prepares a no. of partitioned files as application info, application extended info, primary customer address info, customer general info, customer extended info, additional customer info etc. and converts from ASCII to EBCDIC mode. The merging graph merges all the different segments and prepares MFS file to be sent to TSYS which is a Main Frame system. This ETL process area is called VECTUS-ACE interface.
August 2008 to November 2008 Wipro Technologies Limited
Project Title Capital One Data Archival Phase II
Client Capital One Bank, UK
Position Senior Developer
Responsibilities Shadowing Design Lead for building Technical Design document, coding, unit testing, coordinates among the team, guiding the team on technical issues.
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio, SQL Developer
Work Location(s) Bangalore, India
Project Description
Capital One® is a diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK, and Canada.
The CIS Data Archival project phase-2 is responsible for extracting events and non-events historical data from the Teradata database and daily data from the UK DDE daily clean files and load in APOLLO (Oracle) database.
The Historical data (for the tables like Cg_Frd_Case, Cg_Frd_Trxn, T2_Acct_Ins, T2_Authzn, T2_Evt_Data, T2_Prom_Pmt_Hist, T2_Stmt and T2_Trxn) are extracted from the Teradata database using a generic graph. Different wrapper scripts pass their corresponding parameter as value and call the oneoff extract generic graph and prepare the extract data files. More than one extract data files are joined each other and transformed and prepare the load ready files. Different load ready wrapper scripts are created for different load ready files. These scripts are executed to call the oneoff load ready generic graph using different parameter values and load the files in APOLLO (Oracle) database. This is called onetime load process.
As per the business requirement, UK DDE daily clean files for the tables like T2_Acct, T2_Card_Acct, T2_Card_Cust, T2_Cust, T2_Cust_Adr, T2_Acct_Delq, T2_Acct_Delqy_Hist would hold the historical as well as daily transaction data. The other tables like Cg_Frd_Case, Cg_Frd_Trxn, T2_Acct_Ins, T2_Authzn, T2_Evt_Data, T2_Prom_Pmt_Hist, T2_Stmt and T2_Trxn are loaded in daily load process once the onetime load process completes successfully.
More than one daily clean files are joined each other, transform and generate different data files. If existing, the data on the APOLLO DB are extracted and joined with generated data files by the composite primary keys to compare between two data files if any new data has come for insertion to happen otherwise the updating will happen on the existing data in APOLLO DB using daily load generic graph. This process is called daily load.
April 2008 to August 2008 Wipro Technologies Limited
Project Title Capital One Data Archival Phase I
Client Capital One Bank, UK
Position Senior Developer
Responsibilities Coding, unit testing, coordinates among the team, guiding the team on technical issues.
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio, SQL Developer
Work Location(s) Bangalore, India
Project Description
Capital One® is a diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK, and Canada.
The Capital One Data Archival Project is to decommission the main frame legacy systems into a single HOARDS data archival system to ease the call centre operations, to take the effective management decisions about various fields. In first phase of the development process, the Ab initio will connect the HOARDS Oracle database interface to the Main frame and other Oracle database interfaces, used to extract the data from various legacy systems, make necessary transformations and prepare the load ready files to load into HOARDS database system using load generic graph.
May 2006 to April 2008: TATA Consultancy Services Limited
Project Title Advance Services and SCF, BT wholesale
Client BRITISH TELECOM PLC.
Position Senior Developer
Responsibility As a senior developer involved in analyzing the production issues, providing fix to the code/graph, unit testing the code, deploying in production, meeting the SLA.
Operating System HP UNIX, 2000/XP
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio, EME, TOAD
Work Location(s) Kolkata, India
Project Description
British Telecom Plc. is the largest Telecom Premier in UK with wide infrastructure for Wholesale Services, Mobile Service, IT Solutions, and Marketing Service etc. BT Retail has been promised to provide the technological solutions to the company.
With BT Retail its solution provider, the Advance Services and SCF (Service Creation Framework) Application aims to automate a set of capabilities that comprises tiered services, one and two way QoS that allow the creation of new services and evolution of new broadband services with payment more closely coupled to usage than so far. The main functionality for this application is to enable service providers to perform instantaneous speed regrades on any IPStream product, using the ADQ capability, up to the maximum speed the end user line supports. The range of speed (also termed as profile) regrades is from 64K to 2M and includes 64K, 128K, 150K, 256K, 512K, 1M, 1.5M, and 2M. The activity starts through various modules from customer reporting, feasibility of connection, generation of user information, tracking inventory information to generation of billing and finally reporting to the service providers and BT internal users. The flat files are coming from CIS, Rambo and Geneva source systems, are processed by Wrapper Scripts that calls the main scripts of ETL graphs, uses lookup and reference files and generates .dat files. The .dat files are ftp-ed and loaded in external tables. The .sql scripts are running which calls the packages and loads the files from external tables to base tables in data mart. The files which fail certain data validations are loaded into reject tables. The base tables that are housekeep-ed in 13 calendar weeks are used to generate report for the service providers and for BT internal users.
October 2005 to April 2006: TATA Consultancy Services Limited
Project Title BIP Hour Glass, BT Whole Sale
Client BRITISH TELECOM PLC.
Position Developer
Responsibilities As a team member involving in analyzing the production issues, providing fix to the code/graph, unit testing the code, deploying in production, meeting the SLA.
Operating System HP UNIX, Windows 9x/NT/2000
Languages Oracle 10g, PL/SQL, UNIX Shell Scripting
Special Software Ab Initio, EME, TOAD
Work Location(s) Kolkata, India
Project Description
British Telecom is the largest Telecom Premier in UK with wide infrastructure for Wholesale Services, Mobile Service, IT Solutions, and Marketing Service etc. BT Retail has been promised to provide the technological solutions to the company.
With BT Retail its solution provider, BIP Hour Glass Application aims to provide the Data Stream (DS) Service Provider sufficient information, in order to make more informed decision regarding which DSLAM to select as part of the VP and EU Ordering processes. The Fast cap source system will automate the production of the Hourglass report and address the accuracy issues, supplying two flat files to BIP containing the pre-processed Hour Glass Report data and Capacity Reporting data. No further pre-processing of the files will be required. BIP will load and make available for the reporting purposes the two reports, along with a supporting MIS report detailing availability and timeliness of the Hour Glass Report.
November 2004 to October 2005: DRDA, Khurda, Orissa
Project Title Project Accounting & Monitoring Information System
Client P.R. Deptt., Govt. of Orissa
Position Team Member
Responsibilities Team Member involve in analyzing the problem and Coding to develop Opening Balance Sheet, Budget Head Form, Scheme Chart modules.
Operating System Windows 9x/NT/2000
Languages Oracle 9i, PL/SQL
Work Location(s) Tangi, Khurda
Project Description
Project Accounting & Monitoring Information System (PAMIS) is Software help you to perform accounting within an organization, manage & monitor projects. It processes the information efficiently – at low cost & obtains reports quickly with high degree of accuracy. It also manages & monitors activity centers such as profit centers & cost centers. It also monitors financial as well as physical progress of projects.
S/w provides General Ledger that maintains revenue and expense budgets, creates reports comparing financial data of the previous year to the current year or period to period within the same year and provides full-time audit trail. Budgets head maintains budgets for projects, profit centers and cost centers, maintains different versions of budgets and enforces budgeted amounts on transactions. Project Accounting maintains all books of accounts for projects, treats the organization as a collection of projects and subprojects and treats a project or a subproject as subdivision of the organization and hence will be able to produce all the necessary reporting. Project progress monitoring can maintain planned and actual physical activities for a project; can generate progress reports for projects. PAMIS is designed to support management to control project cost and time over runs. PAMIS integrates many disciplines such as accounting, cost accounting, project planning and monitoring to provide the management a rich set of tools to control projects.
February 2004 to October 2004: DRDA, Khurda, Orissa
Project Title Bet an
Client P.R. Deptt., Govt. of Orissa
Position Team Member
Responsibilities Team Member involves in analyzing the problem and development of Employee Personal details, Employee Earnings, Employee Deduction modules. Also involved in Debugging, Implementation, and Functional Testing.
Operating System Windows 9x/NT/2000
Languages Oracle 9i, PL/SQL
Work Location(s) Tangi, Khurda
Project Description
BETAN, a Payroll Information System is designed as per the requirement of the Panchayati Raj Department, Govt. of Orissa. The system is used to generate the Acquaintance Roll (Pay Bill) in the said format along with the various detailed Statements and Pay Slip etc., to be used by the Accounts Department for payment of monthly salary of the employees. At the end of every month all the changes / Additions in Employee Basic Information, (such as – Yearly Increment, Promotion, Sanction of New Entitlement or Loan, Withdrawal of Entitlement, Transfer, Retirement, Suspension) are the information entered/updated in the System. The earnings and deductions are reflected with the appropriate GL Head.
The Acquaintance Roll contains the Employee name, Earning columns, Deduction columns, Gross Earning and Net pay of an Employee. Different bills are prepared for different posts sanctioned under different schemes, like for different Classes of employee etc. Each bill is accompanied with specific schedules such as Loan recovery statements, Advances recovery statements, LIC deductions statement, Income Tax statement etc. Accounts Section after duly checking sends the Cash Register / Bank Register to the Section. Head for payment by Cash/through Bank.
At the end of each month user must check information of joining of new employee, transfer/ retirement of employees, promotion of employee, suspension of employee, attendance sheet of each employee, (duty pay days / no pay if leave not sanctioned), increment in basic sanction/withdrawal of entitlements, change in allowance amount, maturation of LIC policy/new policy sanction of new loan completion of a loan deduction.
All deduction Schedule can be prepared and placed for checking and confirmation. Monthly Acquaintance Role & Other Reports are prepared Class wise for use of Department.
Cash Register is prepared for payment of employees in cash and Bank Register to be sent to the concerned bank for payments to be made through bank.
Pay slip is generated and distributed to Employees.
PERSONAL DETAILS
Date of Birth 15/12/1978
Sex MALE
Nationality INDIAN
Date of Joining in
Wipro Technologies 16/04/2008
Designation Module Leader
Passport No. F6133914
Contact this candidate