Developer Data
Resume:
Anand
Sr ETL/ Talend developer
Email: ac62ed@r.postjobfree.com
PROFESSIONAL SUMMARY:
9+ years of experience in Data warehousing using Talend 4.x, 5.x and 6.x and Informatica Power center 8.1/8.6.
Extensive experience on Requirement gathering, analysis and designed mapping documents.
Expert in source and target system analysis.
Worked on project analysis and cost estimations.
Worked on project release plan using agile methodology.
Resource planning.
Closely worked with client on requirements and deliverables.
Over 5+ years of experience in Expertise on Talend Data Integration suite and Talend Bigdata Integration Suite for Design and development of ETL and Mappings for Enterprise DWH ETL Talend Projects.
Developed complex Talend ETL job to load the data from file to Oracle Data mart.
Experience in Talend implementation and administration. Solid ETL knowledge on Talend Administration Center, implementing time & event based schedule, performance tuning and troubleshooting.
Comprehensive knowledge with Infrastructure Setup, Environments Control, Data Modeling, ETL process, QA test cases, and Business Intelligence in Data Warehouse and BI projects.
Good experience in handling a team.
Having strong knowledge in data warehousing and ETL concepts.
Extensive experience in designing and creating ETL mapping processes using Informatica power center and Talend.
Worked with Different source systems like DB2, Oracle, Exadata, Flat files, Netezza, Excel files and Xml files.
Capable of analyzing the business requirements and creating Mappings, Maplets, sessions work flows and work let’s using Informatica and Jobs using Talend.
Practical understanding of the database schemas like star schema and snowflake schema used in relational and dimensional modeling.
Worked in creating Design documents, Use case documents and Test conditions.
Strong knowledge of facts and dimensional tables and slowly changing dimensions.
Expert in Unit Testing and Performance tuning at mapping level.
Excellent communication and interpersonal skills. Good knowledge in SQL.
TECHNICAL SKILLS:
ETL TOOLS : Talend and Informatica Power Center 8.1/8.6.
RDBMS : Oracle 9i/10g, DB2 and Netezza.
OPERATING SYSTEMS : Windows and UNIX.
PROJECT DETAILS:
Project Name
Integration of ADP® Global Payroll and Workday
Client
Walmart
Role
Tech Lead
Environment
Database : Oracle Tools :Talend 6.2
Description: The most innovative players in the Human Capital Management space know that providing complementary solutions reduces technological limitations, maximizes benefits to customers and minimizes risk. ADP’s partnership with Workday is a case in point. Workday solutions help companies manage people, attract talent, improve productivity, minimize costs and gain wide visibility from a single cloud-based platform. ADP Global Payroll is a comprehensive multicounty payroll solution that synchronizes international payroll operations, minimizes risk and is designed to assist clients in their compliance efforts with fast changing global payroll requirements. The integration of these two solutions means that your control and visibility of HR extends to global payroll operations, and that you are offered a solution that allows your continued expansion across geographies
Roles and Responsibilities:
Automatic mapping of fixed data elements from Workday to ADP allows for faster up front analysis of HR integration.
Certified country integrations allow for scheduled and/or ad hoc extraction of employee data from
Workday to ADP.
ADP provides the data transformation layer required to translate Workday data elements and to create files in the ADP approved format.
Delivered ADP/Workday data mapping guide.
Delivered ADP/Workday Implementation Guide.
Delivered ADP/Workday User Guide.
In-country ADP Global Payroll experts assist client in their compliance efforts providing best practices and sustained cost efficiencies.
Project Name
Owb to Talend Migration.
Client
walmart
Role
Tech Lead
Environment
Database : Oracle Tools :Talend 6.2
Description: Eneco, the trading name of Eneco Holding N.V., is one of the largest producers and suppliers of natural gas, electricity and heat in the Netherlands, serving more than 2 million business and residential customers. Eneco headquarters are located in Rotterdam. It also carries out energy trading and is involved in sustainable energy projects.
Eneco is the largest power company in Zuid Holland.
The company is divided into five business units:[1]
Eneco New Energy - responsible for sustainable generation and sustainable energy projects
Eneco Energy Trade - responsible for trade in energy and biomass
Eneco Netherlands - the main company, supplying gas and electricity to the Netherlands
Eneco Installation Companies - responsible for heating installations and the supply of energy to customers
Eneco International - responsible for projects outside of the Netherlands
The project is to migrate the legacy Oracle ware house builder code to Talend.
Roles and Responsibilities:
Worked as ETL Lead by handling a team of 12 members.
Worked in project Demo phase.
Worked on costing and estimation phase.
Worked in Requirements, Technical solution, project design and sprint planning.
Worked closely with client on Requirement and release phase.
Translated Business processes into Talend Jobs by using various Components.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the Jobs for its better performance.
Understanding the source and target data model.
Handling the execution flow for the complete workflow.
Created mapping document based on business rules.
Project Name
Abinitio Talend Conversion
Client
Vonage
Role
Senior software Engineer
Environment
Database : Oracle Tools :Talend 5.6
Description: Vonage is a publicly held Internet telephony service provider, providing commercial telecommunication services based on voice over Internet Protocol (VoIP). The company was founded in 2001 and maintains headquarters in Holmdel Township, New Jersey.
The company first offered subscription service in the United States, then Canada in 2004 and the United Kingdom in 2005. As of July 2011, Vonage claims approximately 2.4 million subscriber lines in conjunction with their services provided through mobile applications.
The company name is said to be a play on their motto "Voice-Over-Net-AGE". The company previously used the trademark "The Broadband Phone Company", and changed the slogan later it to "Sounds Good".
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Excel and CSV, oracle and Kafka.
Translated Business processes into Talend Jobs by using various Components.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the Jobs for its better performance.
Understanding the source and target data model.
Handling the execution flow for the complete workflow.
Created mapping document based on business rules.
Involved in creating jobs to populate data mart tables.
Worked in mapping document creation.
Project Name
EDR and LLR reports to Freddie mac
Client
Chase bank
Role
Sr software engineer
Environment
Database : Oracle and Excel Files Tools :Talend 5.3.1,Informatica
Description:
The main objective of this project is to setup is the tool to Investor reporting team primarily focuses on reporting and remitting activities to Freddie Mac [investor]
Reporting and remitting, although related, are separate activities. Reporting is the process of submitting information to Freddie Mac based on the accounting activity (or non-activity) for each mortgage in your Freddie Mac portfolio. Freddie Mac processes one transaction per loan, each accounting cycle. Ocwen will report one loan-level transaction for every Freddie Mac loan Ocwen services regardless of whether any activity occurred for the loan during the reporting period. If there is more than one activity for a loan, Ocwen must summarize all activity for the cycle into one transaction. For example, if a borrower makes a payment on 08/03/xxxx and then pays off the mortgage on 08/07/xxxx, Ocwen must summarize both of these activities into one loan-level transaction
Remitting is the process of initiating a transfer of funds due Freddie Mac from Ocwen’s Freddie Mac custodial account. Ocwen will remit funds via GPI. You may access GPI from a touch-tone phone or via the Service Loans application.
The investor reporting process is comprised of monthly and interim processing.
Monthly processing is cyclical reporting and remitting completed every month at the same time. Freddie Mac’s accounting cycle is a one-month period that begins on the 16th of each month and ends at the close of business on the 15th of the following month, or the previous business day if the 15th falls on a non-business day. The accounting cycle determines the timing for monthly reporting. The timing for monthly remittances is determined by the remittance option selected when the mortgage was sold to Freddie Mac.
Monthly processing for reporting and remitting is the majority of the investor reporting process. It includes all loan-level transactions except liquidations (payoffs and third-party foreclosure sales).
As a Servicer, Ocwen must report monthly transactions no later than five business days after the accounting cutoff.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Excel and CSV, oracle and Exadata to Exadata.
Translated Business processes into Talend Jobs by using various Components.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the Jobs for its better performance.
Understanding the source and target data model.
Handling the execution flow for the complete workflow.
Created mapping document based on business rules.
Involved in creating jobs to populate data mart tables.
Worked in mapping document creation.
Project Name
Lenders One 1.4 MSM
Client
Altisource Business
Role
Sr Developer
Environment
Database : Oracle and Excel Files Tools :Talend 5.1.1
Description:
The main objective of this project is to setup is the tool which captures the proposed business plan of the member with lenders One .generates the possible cost benefits as per the plan and then does periodic review of the actual benefits received v/s earlier expected benifts.MSM also helps in being more customer focused and concentrating on each member individually.
Currently the MSM exists as a spreadsheet with data input points for capturing Member data projects and actual. The data is captured for each Member in its respective template and thus it remains in a silo. There is no holistic way of analyzing Member savings as a whole. Therefore this project aims to store MSM data for all the members in the data repository so that relevant analysis can be done on top of it. Either at Member level or an aggregated level.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Excel and CSV files to Oracle.
Translated Business processes into Talend Jobs by using various Components.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the Jobs for its better performance.
Understanding the source and target data model.
Handling the execution flow for the complete workflow.
Extracting data from excel files pivoting and unpivoting them using Oracle queries.
Created mapping document based on business rules.
Involved in creating jobs to populate data mart tables.
Project Name
Project_LendersOne-Price Weaver
Client
oracle
Role
Sr Developer
Environment
Database : Oracle xml and Excel Files Tools :Talend 5.1.1
Description:
As a part of the Lenders One consortium, the Members originate retail loans from borrowers. These Members use their own cash to fund these loans initially. However, since their primary role is to generate loans on a regular basis without having to hold these loans for the entire term, they sell these loans to prospective buyers. These buyers are termed as Investors in the industry verbiage.
The main objective of this rate data is to enable the Secondary Market team to help the Members in picking the Investor offering the best price to the Member for the loan that he wants to sell in the Secondary Market.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Excel and CSV files to Oracle.
Translated Business processes into Talend Jobs by using various Components.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the Jobs for its better performance.
Understanding the source and target data model.
Handling the execution flow for the complete workflow.
Extracting data from excel files pivoting and unpivoting them using Oracle queries.
Created mapping document based on business rules.
Involved in creating jobs to populate data mart tables.
Project Name
Payoffs Reports to Freddie Mac (GSE 2.0)
Client
Airtel
Role
Sr Developer
Environment
Database : Oracle and Excel Files Tools :Talend 5.1.1
Description:
Investor reporting team primarily focuses on reporting and remitting activities to Freddie Mac [investor] Reporting and remitting, although related, are separate activities. Reporting is the process of submitting information to Freddie Mac based on the accounting activity (or non-activity) for each mortgage in your Freddie Mac portfolio. Freddie Mac processes one transaction per loan, each accounting cycle. Ocwen will report one loan-level transaction for every Freddie Mac loan Ocwen services regardless of whether any activity occurred for the loan during the reporting period. If there is more than one activity for a loan, Ocwen must summarize all activity for the cycle into one transaction. For example, if a borrower makes a payment on 08/03/xxxx and then pays off the mortgage on 08/07/xxxx, Ocwen must summarize both of these activities into one loan-level transaction Remitting is the process of initiating a transfer of funds due Freddie Mac from Ocwen’s Freddie Mac custodial account. Ocwen will remit funds via GPI. You may access GPI from a touch-tone phone or via the Service Loans application. The investor reporting process is comprised of monthly and interim processing. Monthly processing is cyclical reporting and remitting completed every month at the same time. Freddie Mac’s accounting cycle is a one-month period that begins on the 16th of each month and ends at the close of business on the 15th of the following month, or the previous business day if the 15th falls on a non-business day. The accounting cycle determines the timing for monthly reporting. The timing for monthly remittances is determined by the remittance option selected when the mortgage was sold to Freddie Mac.
Monthly processing for reporting and remitting is the majority of the investor reporting process. It includes all loan-level transactions except liquidations (payoffs and third-party foreclosure sales).
As a Servicer, Ocwen must report monthly transactions no later than five business days after the accounting cutoff.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Excel and CSV files to Oracle.
Translated Business processes into Talend Jobs by using various Components.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the Jobs for its better performance.
Understanding the source and target data model.
Handling the execution flow for the complete workflow.
Extracting data from excel files pivoting and unpivoting them using Oracle queries.
Created mapping document based on business rules.
Involved in creating jobs to populate data mart tables.
Project Name
Foreclosure Reports to Freddie Mac (GSE 2.0)
Client
hyundai
Role
Sr Developer
Environment
Database : Oracle and Excel Files Tools :Talend 5.1.1
Description:
Investor reporting team primarily focuses on reporting and remitting activities to Freddie Mac [investor]
Reporting and remitting, although related, are separate activities. Reporting is the process of submitting information to Freddie Mac based on the accounting activity (or non-activity) for each mortgage in your Freddie Mac portfolio. Freddie Mac processes one transaction per loan, each accounting cycle. Ocwen will report one loan-level transaction for every Freddie Mc loan Ocwen services regardless of whether any activity occurred for the loan during the reporting period. If there is more than one activity for a loan, Ocwen must summarize all activity for the cycle into one transaction. For example, if a borrower makes payment on 08/03/xxxx and then pays off the mortgage on 08/07/xxxx, Ocwen must summarize both of these activities into one loan-level transaction. Remitting is the process of initiating a transfer of funds due Freddie Mac from Ocwen’s Freddie Mac custodial account.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Excel, oracle and CSV files to Oracle.
Taking Ownership of the project for Future Change Requests.
Translated Business processes into Talend Jobs by using various Components.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the Jobs for its better performance.
Understanding the source and target data model.
Handling the execution flow for the complete workflow.
Extracting data from excel files pivoting and unpivoting them using Oracle queries.
Created mapping document based on business rules.
Involved in creating jobs to populate data mart tables.
Project Name
Bradesco EDGE
Client
American Express
Role
ETL Developer
Environment
Database : Mainframe File & Netezza Tools :Informatica 8.6
Description:
The main objective of this project is to setup the available reporting currencies at the partner level and assign a default currency to be used for the partner reports. Micro Strategy multi language support, Micro Strategy localization functionality will be done. A mapping between user selected language and Micro Strategy locale will be created. Informatica will be used to process the GDR outbound file. All reports will come from Micro Strategy cubes to have consistent performance and not dependent on Netezza load. Export to text functionality will be created using Micro Strategy text export functionality. EDGE web application will log all user activity to GNSWeb database. For saved templates functionality, we are only saving modifications to filters, grid hide and show options, reporting currency selected and drill path parameters.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Main frame file to Netezza Tables.
Translated Business processes into Informatica mapping by Creating Complex Mappings using various transformation like Source Qualifier, Lookup, Router, SQL transformations and Expression etc.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the mapping for its better performance.
Created reusable mapplets/transformations embedding business logic.
Involved in Test conditions Upload to HP quality Center.
Worked in Writing SQL Queries.
Project Name
SBS Edge (Small Business Services)
Client
toshiba
Role
ETL Developer
Environment
Database : Mainframe File & Netezza Tools :Informatica 8.6
Description:
The main objective of this project is to deliver a solution that closes a major gap in the Amex Small Business product portfolio that will drive revenue while delivering growth, improved client loyalty and acquisition rates for our Partner’s businesses. This project will create a reporting solution for our GNS (Global Network services) partners to be used by their commercial card clients. This will be an intuitive solution with a dashboard front end and role based access to dynamic reports. The Reporting solution provides the visibility and details need to be able to manage their card programs and achieve the desired impacts of streamlining processes, reducing payment volumes, ensuring policy compliance and driving bottom line savings for the business. A best in class tool provides a very visible face for a corporate solution and can be a key differentiator for American Express and our partners.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from Main frame file to Netezza Tables.
Translated Business processes into Informatica mapping by Creating Complex Mappings using various transformation like Source Qualifier, Lookup, Router, SQL transformations and Expression etc.
Prepared Design documents, Use case Documents and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the mapping for its better performance.
Created reusable mapplets/transformations embedding business logic.
Involved in Test conditions Upload to HP quality Center.
Project Name
Key Management Hierarchy for CSC phase II
Client
American Express
Role
ETL Developer
Environment
Database : Mainframe File & DB2 Tools :Informatica 8.6
Description:
The main objective of this project is to provide Daily feed from PSU to Key Management Hierarchy. PSU will have a batch process that will extract the issuer details in a flat file. This will be sent to KMH in a daily basis. This will only contain the active records from PSU for that day. KMH will receive this information from PSU and will build the capability to track the information historically.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from DB2 Tables to Flat File.
Translated Business processes into Informatica mapping by Creating Mappings using various transformation like Source Qualifier, Lookup, Router, SQL transformations and Expression etc.
Prepared functional Design documents, Use case and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the mapping for its better performance.
Created reusable mapplets/transformations embedding business logic.
Involved in Test conditions Upload to HP quality Center.
Project Name
GNS_BASIL_EXTRACT
Client
American Express
Role
ETL Developer
Environment
Database : Mainframe File & DB2 Tools :Informatica 8.6
Description:
The main objective of this project is to provide Daily feed from PSU Basil. PSU will have a batch process that will extract the issuer details in a flat file. This will be sent to mainframe in a daily basis. This will contain the active records from PSU for that day. Basil file will receive this information from PSU and will build the capability to track the information historically.
Roles and Responsibilities:
Worked as ETL Developer in Data loading Phase from DB2 Tables to Flat File (Mainframe Format).
Translated Business processes into Informatica mapping by Creating Mappings using various transformation like Source Qualifier, Lookup, Router, SQL transformations and Expression etc.
Prepared Functional Design documents, Use case and Test Cases Documents.
Preparing Unit Test Plan, Unit Test Run and Checklist.
Tuned the mapping for its better performance.
Created reusable Mapplets/Transformations embedding business logic.
Involved in Test conditions Upload to HP quality Center.
Contact this candidate