Summary

• 8 years of IT experience in System Analysis, Design, Development and Testing of Data Warehousing implementations across Financial, Educational, Construction and Retail Industries.
• ETL/MDM: 5 years of Data Warehousing experience using Talend Integration Suite 4.2/5.0 /Talend MDM 5.x , Datastage Pentaho. Designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, and legacy systems.
• SQL Server Integration Services: 5 years of Data Warehousing experience using SSIS. Designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS table, and legacy systems.
• Data Modeling: 4 years of Dimensional Data Modeling experience. Dimensional Modeling, Star/Snowflake Modeling, Datamarts, FACT Dimension Tables.
• Databases: 8 years of experience using MS SQL Server 2005/2008 and MS Access. 3 years of experience using Oracle 11g/Oracle 10g/9i. 2 Years of experience using Netezza and MySQL Databases.
• Business Intelligence: 6 years of experience providing historical, current and predictive views of business operations. Using Predictive analytics to take historical and current trends to make predictions of future trends.

Technical Skills

Work Experience

ETL/MDM Developer

Confidential

Used ETL methodologies and best practices to create Talend ETL jobs.

Extracted data from flat files/ databases applied business logic to load them in the staging database as well as flat files.

Developed jobs in Infosphere Datastage and involved in job migration from Datastage to Talend.

Used Datastage extensively to load the data in the staging, and datamarts.

• Developed mappings /Transformation/Joblets in Talend 5.0.
• Designed ETL Jobs/Packages using Talend Integration Suite TIS
• Talend MDM 5.1.1.Designed and developed the Business Rules and workflow system.
• Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM.
• Developed data validation rule in the Talend MDM to confirm the golden record.
• Developed data matching/linking rules to standarize the record in Talend MDM.

• Worked on different data sources such as Oracle, Netezza, MySQL, Flat files etc.
• Created complex mappings in Talend 5.0 using tmap, tmssqlinput, tmssqloutput, tfiledelimitede, tfileoutputdelimited, tmssqloutputbulkexec, tunique, tFlowToIterate, tintervalmatch, tlogcatcher, tflowmetercatcher, tfilelist, taggregate, tsort, tMDMInput, tMDMOutput, tFilterRow.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history.
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Frequently used Talend Administrative Console TAC
• Implemented new users, projects, tasks within multiple different environments of TAC Dev,Test,Prod,DR .
• Worked with clients and created specific MRS documents to ensure mapping was to their specification.
• Worked with third party vendors on specific requirements needed for new feeds.
• Created and managed Source to Target mapping documents for required jobs.
• Ensured jobs, projects and MRS documents were up to date on the SVN within different environments.
• Was involved in the creation and fixing of jobs for four different teams. One of which was the release team for Sony.

Environment: Talend Integration Suite 5.0 , Netezza DB, MySQL DB, Unix, Linux, Wiki, SVN, Talend MDM, Java, Infosphere Datastage 9.1 Designer/Director

Business Intelligence Developer

Confidential

Used ETL methodologies and best practices to create Talend ETL jobs.

Extracted data from flat files/legacy databases applied business logic to load them in the staging database.

• Developed mappings /Transformation/Joblets in Talend 4.2.
• Designed ETL Jobs/Packages using Talend Integration Suite TIS
• Implemented population of slowly changing dimensions to maintain current information and history information in warehouse tables with change data capture CDC .
• Worked on different data sources such as Oracle, SQL Server 2008, Salesforce, Flat files etc.
• Created complex mappings in Talend 4.2 using tMap, tJoin, tReplicate, tParallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Created Talend ETL job to receive attachment files from pop e-mail using tPop, tFileList, tFileInputMail and then loaded data from attachments into database and archieved the files.
• Design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.

Environment: Talend Integration Services TIS 4.2 SQL Server 2008 Oracle 10g Salesforce Wiki Windows 2003 Server

Database ETL Developer

Confidential

• Installation of SQL Server 2008.
• Created and managed Source to Target mapping documents for all Facts and Dimension tables

Used ETL methodologies and best practices to create Talend ETL jobs.

Followed and enhanced programming and naming standards.

• Created and deployed physical objects including custom tables, custom views, stored procedures, and Indexes to SQL Server for Staging and Data-Mart environment.
• Design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Designed ETL Jobs/Packages using Talend Open Studio TOS
• Used Talend most used components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher,

tRowGenerator, tSetGlobalVar, tHashInput tHashOutput and many more

• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
• Developed reports and also create Data Model for users to generate ad-hoc reports from database using SQL Server Reporting Services SSRS
• SSRS installation and report server configuration.
• Created database objects, stored procedures, tables, views etc in physical database.

Developed the Conceptual, Logical, and Physical Data Model for Staging and Dimensional Schema.

• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Interacted with developers other team members to discuss about ETL architecture and

improvements.

Environment: Talend Open Studio TOS 4.2/5.0 SQL Server 2008 SQL Server Reporting Services Windows 2003 Server

Business Intelligence Developer

Confidential

• Extracted data from flat files applied business logic to load them in the staging database
• Created the mapping documents based on the data model and the client requirements.
• Used Talend TOS 4.2 most used components tMap, tDie, tConvertType, tFlowMeter,
• LogCatcher, tRowGenerator, tSetGlobalVar, tHashInput
• tHashOutput and anymore Responsible for testing and migration of ETL maps from the
• development to production environment.
• Prepared test cases and test plans.
• Implemented populate slowly changing dimension to maintain current information and history information.
• Loading the data received from the wholesalers, distributors, and customers into the database
• on daily and weekly basis.
• Involved in analysis of data in various modules of the project.
• Worked with MS-Excel spreadsheet and MS-Word for Documentation.
• Set up reporting services SSRS to enable reports can be pulled for exact specifications.

Environment: Talend Open Studio TOS 4.2 SQL Server 2008 SQL Server 2008 Windows 2003 Server Java SQL Server Reporting Services

Database Developer

Confidential

• Extracted data from flat files applied business logic to load them in the staging database
• Created the mapping documents based on the data model and the client requirements.
• Developed Mappings/Transformations/Deployment using SQL Server Business Development Studio SSIS using Aggregate, Lookup, Condition Split, Derived Column, OLE DB Command, Sort, and Merge Join.
• Responsible for testing and migration of ETL maps from the development to production environment.
• Prepared test cases and test plans.
• Implemented populate slowly changing dimension to maintain current information and history information.
• Involved in analysis of data in various modules of the project.

Worked with MS-Excel spreadsheet and MS-Word for Documentation.

Set up reporting services SSRS to enable reports can be pulled for exact specifications.

Creation of Data Models within ERWin 4.1.1

Involved in the end to end system planning, design, mapping and data delivery.

Data modeling conceptual, logical, and physical .

Data migration strategy and planning

Performed Data analysis to find trends and Data Profiling.

JAD meetings with Lead for responsibilities and ideas.

Environment: SQL Server Business Intelligence Development Studio SSIS, SSRS SQL Server 2008 Windows 2003 Server