Candidates About

 

Lisa Young

 

SUMMARY:

 

·         Overall 8+ years of total experience in IT and professional experience in Extraction, Transformation and Loading (ETL) experience using Talend Data Integration 5.x, 6.0, DataStage 9.1/8.7/8.5 Parallel Extender.

·         4 years of experience in using Talend Data Integration tool for Extracting, Transforming and Loading Data.

·         Expert level Experience in Talend DI tool, Talend Data Quality and Talend Data Mapping.

·         Designing ETL framework, data flow and processes, analyzing data mapping requirements, identifying functional specifications, guiding and developing mappings.

·         Created complex mappings in Talend using components like tMap, tJoin, tReplicate, tParallelize, tAggregateRow, tDie, tUnique, tXMap, tFlowToIterate, tSort, tFilterRow etc. and have created various complex mappings.

·         Advance Knowledge, excellent concepts and experienced in decision support system (DSS), querying and analysis, Extraction Transformation Loading (ETL) Data Stage, Talend and Data Warehousing.

·         Extensively worked on Server Edition, Enterprise Edition (Parallel Extender) and Development of Data Warehouse/Data Mart Applications.

·         Extensively made use of all stages Aggregator, Sort, Merge, Join, Change Capture, Peek stages in Parallel Extender job.

·         Used Data Stage Manager to import/export Data Stage projects and jobs to define table definition in repository.

·         Used Data Stage Director to debug, validate, schedule, run and monitor Data Stage Jobs

·         Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.

·         Dimensional data modeling using Data Modeling, Star Join Schema/Snowflake modeling, fact and dimensions tables, physical and logical data modeling.

·         Proficiency in Linux, UNIX and shell scripting and automation.Expertise in SQL, PL/SQL, functions, triggers, stored procedures and packages.

·         Experienced in Informatica Power Center 9.x/8.x/7.x, Power Connect, Power Exchange.

·         Strong Knowledge of Data Warehouse architecture in Designing Star Schema, Snow Flake Schema, FACT and Dimensional Tables.

·         Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.

·         Involved in Performance Fine Tuning of ETL Datastage programs.

·         Excellent experience in Relational Database (RDBMS), Oracle 11g,10g,9i, Microsoft SQL Server.

·         Involved in Logical and Physical Design, Backup, Restore, Data Integration and Data Transformation Service.

·         Excellent communication skills and active team player and as an individual with self-motivated, fast learner, good listener and very flexible in maintaining work schedule. Ability to work overtime if required.

·         Experience in logical/physical data models and Forward/Reverse Engineering using ERwin.Experience in UNIX Pre and Post Session command tasks.

 

 

 

TECHNICAL SKILLS:

ETL Tools:                                           Talend 6.1.1, 5.x, IBM InfoSphere DataStage 9.x/8.x, Data Stage 7.5, Informatica, Ab Initio, Pentaho

Reporting Tools:                                  Tableau, Crystal Reports 8, Business Objects XI 3.1, Microstrategy, SSRS and SSIS

Tools & Utilities:                                  SQL Plus, SQL Loader, TOAD, PL/SQL, NO SQLand Win SQL

Operating Systems:                              UNIX Solaris 5.1, IBM AIX, Windows 2000/XP/7, HP UNIX

Methodologies:                                    Test Driven Development, Agile, RUP and UML, Waterfall

Programming Languages:                    SQL, Unix Shell scripting, Python

Databases:                                           Oracle, DB2 UDB, Teradata, Netezza, Cassandra, MongoDB, MySQL,  and SQL Server

                                                           

 

 

 

 

PROFESSIONAL EXPERIENCE:

 

Fitch Ratings,Reading PA                                                                                                        July16- Till Date,

ETL Developer

 

Fitch Solutions is the primary distributor of Fitch Ratings’ proprietary credit ratings and industry-leading research. Credit ratings data includes Fitch ratings, watches and outlooks—over 140 different data fields and up to 35 years of historical rating actions, including defaults. While Fitch research provides insight and transparency into the thinking used in the calculation of a rating through in-depth special reports and timely market commentary on a broad range of sectors, entities and securities. Together they enable you to understand credit trends and make informed investment decisions.

AgentRanking:This project is mainly into calculating Banks ranking for all the International Active agents. Ranks will be calculated in both global and national level on yearly basis.

Manage risk and maintain regulatory compliance with access to four levels of market sector indexing and 25 distinct ratings types, including recovery, national, local currency, country ceiling, volatility, and viability ratings, in addition to outlook, watch and solicitation status.Historical rating, outlook and watch status coverage on issuers and issues including those that have expired, defaulted, matured or are no longer covered by Fitch Ratings. Reduce costs and improve efficiency by eliminating the need to manually track, input, and maintain current and historical ratings and credit market information.

Responsibilities:

·         Worked on Talend Open studio for Big Data 6.2.1.2 version with Mongodb as input and output.

·         Develop Extract, Transformation, and Load (ETL) procedures for implementing data integration and data loading tasks.

·         Design, develop, test, and deliver code for the project's user interfaces, system interfaces, and back-end components

·         Designed jobs for calculation Ranks in both global and national level based on total assets.

·         Designed job for calculating ranking deltas and percentage change of ranking for current year ranks and previous year ranks.

·         Develop complex Oracle PL/SQL programs for the Data Warehouseand high-volume Relational databases and SQL Query performance tuning.

·         Wrote UNIX shell scripting for automation the process.

·         Solely responsible for the daily loads, handling the reject data and extensively worked in the performance tuning.

·         Used SQL tools TOAD to run SQL queries and validate the data in warehouse.

·         Fixed invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica sessions, batches and the target data.

·         Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

·         Meet the SLA at all times and improved the Performance of loading data from Key Data sources.

·         Maintained facts and Dimensions using Star Schema and Snowflake Schema.

·         Prepare documentation on all aspects of ETL processes, definitions and mappings.

·         Rigorous unit testing and functional testing to reduce the defects before QA.

·         Analyze transaction errors and troubleshoot issues in the software

·         Develop bug-fixes and oversee performance-tuning efforts

·         Designed job for total asset deltas based on current and previous year deltas.

·         Used components like tmongodbConnection, tmongodbinput, tmongodboutput, tmap, tJavarow, tJavaflex, tdenormalize, tLibraryload, tContextload, tBufferoutput, tBufferinput etc.,

·         Worked in Amazon web services (AWS) cloud environment.

·         Done some analysis for missing fields in dev environment and QA environtment.

·         Created Analysis reports for Refresh ETL process.

·         Involved in Unit testing and Sanity testing process, wrote mongodb queries under the process of testing.

·         Created test cases and design documents as the part of development.

·         Expertize working in JIRA, CONFLUENCE and BITBUCKET SERVER.

·         Cloned the code from bit bucket and committed the changes in bitbucket server.

Environment:Talend Open studio for Big Data 6.2.1.2, MongoChef Core, Oracle, SQL, Pl/SQL, SQL, Unix, Shell Scripting, Python, Tableau, AWS, JIRA, BitBucket, Confluence, Autosys, Windows, Cybermation.

Walgreens, Deerfield IL                                                                                                            Aug 15 – June 16

Talend Developer

The Walgreen Company is an American pharmaceutical company which operates the largest drug retailing chain in the United States of America. In 2014, the company agreed to purchase the remaining 55% of Switzerland-based Alliance Boots. Under the terms of the purchase, the two companies merged to form a new holding company, Walgreens Boots Alliance Inc.,

Rx Renewal Integration: The project is mainly Integration Team to develop integration workflows, load the data from Integrated Solutions – OWG and provide the same to RxMS and sending updated Prescriber, Patient and product related data from RxMS to Integrated Solutions – OWG. Store conversion is the major part of this project. Initial load, Delta load, publish and updates are also part of this project. Project includes designing Talend jobs to fetch the List of prescriber, patient, drugs, Allergy Conditions etc.,

 

Responsibilities:

·         Working with business analyst and system analyst for requirements gathering and business analysis.

·         Designed and developed Talend jobs for loading the data from different sources like Oracle, flat files and xml files, loading it into the data ware house tables.

·         Designed jobs to generate xml files and used routines to increase the performance of the jobs.

·         Used different components like tMap, toracleinput, toracleoutput, tFileinputdelimited, tfileoutputdelimited, tfileinputXML, tfileoutputXML, textractXMLfield, tXMLMap, tHashinput, tHashoutput, tUnique, tFilelist, tAggregate, tSort, tFilterRow, tconverttype, tJava,

·         Derived the delta extraction and loading logic for each target table based on the source data.

·         Created Context groups and defined contexts for database connections, file paths for migrating to different environments in a project.

·         Experience in using JIRA, confluence and BitBucket server.

·         Created and scheduled Worklets. Setup workflow and Tasks to schedule the loads at required frequency using Workflow Manager.

·         Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer.

·         Involved in validating Talend jobs and worked on tuning the performance of the Talend jobs.

·         Involved in developing Test Cases and Performed Unit Testing, End to end System Integration Testing, UAT Testing

·         Wrote SQL complex queries for implementing business rules and transformations.

·         Maintained facts and Dimensions using Star Schema and Snowflake Schema.

·         Prepare documentation on all aspects of ETL processes, definitions and mappings.

·         Rigorous unit testing and functional testing to reduce the defects before QA.

·         Coordinated with campaign and reporting team for the change requests and availability of Data.

·         Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives.

·         Worked on Power connect, Power Exchange and Power Center to pull data from  sources like Oracle.

·         Strong experience in OLAP Data Modeling using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

·         Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.

 

Environment: Talend Open Studio 6.1, Oracle 12c, BitBucket, Informatica Power Center 9.6.4, Informatica Data Quality (IDQ),PowerExchange, Scheduler, Work Flows, ETL, Visio, Flat Files, Oracle 11g, XML, PL/SQL, TOAD 9.6.1,Unix Shell Scripts, BASH, SQL Navigator, Windows XP,Putty, Winscp,Web methods and UNIX.

 

 

 

 

HSRI, Providence RI                                                                                                                 Apr14 –Mar15

Talend Developer

Chartered under the Affordable Care Act, Healthsource RI is the Health Benefit Exchange of Rhode Island. They connect Individual and Small Businesses to with brand-name health insurance companies, enabling them to compare health insurance plans and costs and purchase the right coverage.

Predictive Analytics Project – TABNER, Inc. has been awarded the Project by the State of Rhode Island to develop an end-to-end Analytics Platform to support Operational Reporting, Dashboards and Predictive Models. Deliverables included Data Analysis for the various source data sets, build subject data models, design and build ETL Processes, Setup and manager Analytics Infrastructure and build Predictive Models around behaviour and propensity to buy insurance for individual and small businesses.

 

Responsibilities:

·         Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

·         ETL design framework for using Talend for data movement between OLTP and OLAP DB’s at Real-Time.

·         Develop the ETL mappings for XML, .csv, .txt sources and also loading the data from these sources into relational tables with Talend.

·         Used different components in Talend like tMap, tmssqlinput, tmssqloutput, tFiledelimited, tUnique, tFilelist, tAggregate, tSort, tFilterRow.

·         Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.

·         Worked on Talend Administration Console (TAC) for scheduling jobs and adding users.

·         Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.

·         Experience in using Talend DI for Data Quality for data quality, data cleansing and data conversion, monitoring and reporting on data quality issues across the enterprise.

·         Implementing Data Integration process with Talend BigData Integration Suite.

·         Also used Talend Big Data components like tHDFS, tHDFSRowCount, tHIVEConnection, tHIVERow, tPigAggregate, tPigFilterRow, tPigAggregate, tPigJoin.

·         Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.

·         Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.

·         Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

·         Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.

 

Environment: Talend 5.6.0, Talend Big Data, Tableau 7.0, 8.0 and SQL Server, TAC.

 

 

 

VERIZON, Irving, TX                                                                                                                           Sep 13 – Apr 14

ETL/Talend Developer

The project was mainly a migration work from Oracle to SQL Server and developing the web application. It includes Extract, Transform and Load (ETL) tasks to populate the transactional database using SSIS packages from Oracle data source to SQL Server and also ETL tasks to populate data warehouse. Designing Jobs to Load data into data warehouse and developing various reports using SSRS 2008 that runs against the transactional database and also the warehouse.

 

 

Responsibilities:

·         Implementing Data Integration process with Talend Integration Suite, designing, developing and deploying end-to-end Data Integration solution.

·         Developing the ETL mappings for XML, .csv, .txt sources and also loading the data from these sources into relational tables with Talend ETL.

·         Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL mapping.

·         Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.

·         Created transformations and mappings.

·         Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

·         Configure SSIS Package for run time Parameters and Configuration file using XML configuration and environment variables.

·         Created stored procedures to do two phase load of data to staging area and then to warehouse using SSIS packages.

·         Created complicated reports like parameter based reports, Sub reports, well-formatted reports, matrix reports, chart and tabular using SSRS 2008.

·         Interacted with business users for gathering requirements for Projects Dashboards.

·         Prepared Use cases and look and feel documents and got reviewed with end users.

·         Created actual orders and target orders view with Trend lines, table calculations to see the difference between each quarter.

Environment: Talend Integration Suite 5.1.0, 5.1.1, Oracle, SQL Server 2008, SSRS, SSIS, Windows, UNIX, flat files.

 

 

J P Morgan Chase, Irvine, CA                                                                                                              Oct 11 – May 13

ETL DataStage Developer

CIG (Corporate Internet Group) of JPMorgan Chase which takes the Ownership and Maintenance of the Chase.com and JPMorganchase.com portal for business and retail customers. Involved in all major module and performance validated the Quick Deposit, Segregation of duties, Mobile Rewards, Entitlements, Mitek Image processors, Chase Mobile Native app, Mobile Banking, Enhanced Mobile Browser, Mobile Analytics and Application Migrations.

PSCIO (Procurement Supply Chain Integration & Optimization): Chase is in the process of integrating the functionality of its Procurement modules with SAP environment. In support of that effort, we have been engaged to design, develop and system test business requirements identified by the business unit for the Chase Nov 2011 PSCIO Integration Release. The main objective of this project is to develop and customize the Data-stage jobs to load the mainframe file, Xml file and Oracle table’s data into Oracle data ware house.

The scope of the R.3 EPM data warehouse is as follows:

·         Deliver aggregated spend calculation check for a specific vendor via web service to the services procurement module

·         Deliver informational-only email notification to strategic sourcing managers when a contract threshold has been reached for a particular tier for a vendor

·         Load master vendor information from PeopleSoft purchasing available in PSCIO

 

Responsibilities:

·         Working with business users and business analyst for requirements gathering and business analysis.

·         Designed and developed ETL jobs for extracting the data from different sources like SQL Server, Oracle and flat files and loading it into the data ware house tables.

·         Identifying the common functionality between the processes and created reusable ETL code.

·         Derived the incremental extraction and load logic for each target table based on the source data.

·         Used QualityStage stages such as investigate, standardize, match and survive for data quality and data profiling issues during designing jobs.

·         Analyzing the dependencies between the jobs and scheduling them accordingly using the Work Scheduler.

·         Worked on tuning the performance of the ETL jobs.

·         Facilitated the Production move ups of ETL components from Acceptance to Production environment.

·         Used Autosys to schedule ETL batch jobs on daily, weekly and monthly basis.

·         Involved in developing Test Cases and Performed Unit Testing, End to end System Integration Testing, UAT Testing

·         Wrote SQL complex queries for implementing business rules and transformations.

Environment: IBM InfoSphere Datastage 8.5, QualityStage, SQL Server 2005, Oracle 10g, UNIX, Windows 7, Autosys.

 

Nike Inc., Portland, OR                                                                                                                         Oct 10 – Sep 11

Datastage Developer

Nike is an American multinational corporation that is engaged in the design, development, manufacturing and worldwide marketing and sales of footwear, apparel, equipment, accessories and services. The company is headquartered near Beaverton, Oregon. It is one of the world's largest suppliers of athletic shoes and apparel and a major manufacturer.<