We provide IT Staff Augmentation Services!

Etl Talend Consultant / Bi Team Lead Resume

SUMMARY

  • Overall 15+ Years of experience having around 6+ Experiences in using Talend Data Integration tool as applied to BI data analytics, reporting and dashboard projects. Experience with Talend Open Studio, Talend Cloud Hybrid Studio & Talend Enterprise platform for Data Management (V 6.1, 6.3, 6.5,7.1,7.2) and Data Integration.
  • 1 3+ years of experience in Data warehousing Business Intelligence Technologies like SAP Business objects Administration, Universe Design, Info view, Web Intelligence, Xcelsius, Dashboard Designer, Polestar, BO Explorer, BO Mobile, BO SDX, SAP Visual Intelligence Reports, Crystal reports, Power BI, Lumira, Design Studio, SAP BW, BAP BI, QlikView, Tableau 7, 8, 9,10.5
  • Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer MS Excel.
  • Expertise in working on SQL with Databases like PL/SQL, Oracle11g/10g/9i, MS SQL Server 2005, IBM DB2 V8 and Tera data V12 and 14.
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
  • Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man.
  • Very good understanding of the detail level data warehousing concepts and implemented in many assignments.
  • Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
  • Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
  • Produced attractive visuals/dashboards to convey the story inside the data.
  • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Involved in trouble shooting of performance issues which were associated with Tableau reports.
  • Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
  • Good experience in Installation and configuration of business objects in multiple servers, creating and maintaining the central management console.
  • Knowledge in creating and maintaining universes in Business objects universe designer.
  • Good working knowledge on creating and maintaining dashboards using Xcelsius and Dashboard Designer.
  • Expertise in various phases of Implementation in both SAP and NON - SAP environments.
  • Well versed with business analysis and end-user requirement analysis.
  • Scheduling and Troubleshooting load problems, Business report errors and Troubleshooting.
  • Excellent analytical, organizational, planning skills with demonstrated abilities in leading motivated teams towards achieving organizational goals.
  • Good exposure in creating and maintaining most challenging reports in web intelligence, desktop intelligence.
  • Work experience in integrating BO with SAP environment and created reports.
  • Developed Business Objects Universe, Business objects dashboards, Web intelligence reports.
  • Experience in Configuring and development of SAP BPC.
  • Excellent analytical and communication skills that are required to work effectively in the field of applications development and maintenance.
  • 6+ years of experience in using Talend Data Integration tool as applied to BI data analytics, reporting and dashboard projects. 6+ years of experience with Talend Open Studio, Talend Cloud Hybrid Studio & Talend Enterprise platform for Data Management (V 6.1, 6.3, 6.5,7.1) and Data Integration.
  • Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
  • 2+ years of experience in Cloud platform (AWS) 2+ years of experience in Cloud platform (AWS).
  • Experience in AWS S3, EC2, SNS, SQS setup, Lambda, RDS (MySQL) and Redshift cluster configuration
  • Experience on databases like MySQL, Oracle using RDS of AWS.
  • Solid Knowledge on relational database management Systems, Data Warehousing Basics and Dimensional modeling (Snowflake schema and Star schema)
  • Experience in using Talend Admin Console (TAC) in deploying, scheduling and Monitoring of the jobs.
  • Worked in Agile environment where we follow Continuous Integration using Bamboo and used GIT as version control to maintain code commits.
  • Good Experience in Talend DI Administration, Talend Data Quality and Talend Data Mapping.
  • Experience in Talend Big Data Integration for business demands to work towards Hadoop and NoSQL databases.
  • Conducted detailed research of higher education processes.
  • Analyzed software issues and developed software applications.
  • Provided assistance on advancement systems with banner products.
  • Implemented gathering of information, functions and input requirements.
  • Formulated and documented requirements for data, logical processes and operating systems.
  • Prepared technical specifications and evaluated software products.
  • Supported, programmed and customized GUI, printed outputs and interfaces.
  • Worked with datasets from Finance, Health Care, Pharmaceutical, Manufacturing and Service Industries.
  • Created complex mappings in Talend using components like tMap, tJoin, tReplicate, tParallelize, tAggregateRow, tDie, tUnique, tFlowToIterate, tSort, tFilterRow etc. And have created various complex mappings.
  • Experience in using Talend Big Data components to create connections to various third-party tools used for transferring, storing or analyzing big data, such as Sqoop, MongoDB and BigQuery to quickly load, extract, transform and process large and diverse data sets.
  • Able to work under tight deadlines and rapidly changing priorities with proactive, creative & focused approach to business needs with high analytical skill and team playing skills.
  • Excellent knowledge in deployment process from DEV to QA, UAT and PROD with both Deployment group and Import/Exports method.
  • Extensive experience in 5 End to End SAP BO Implementations. BO Versions - BO XI R2, 3.0,3.1,4.0,4.1,4.2
  • Very good understanding of the detail level data warehousing concepts and implemented in many assignments.
  • Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
  • Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
  • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Involved in trouble shooting of performance issues which were associated with Tableau reports.
  • Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.

TECHNICAL SKILLS

Development Tools: Talend 7.2.1, Talend 7.1.1., Talend 6.2, Talend ESB 6.2, informatica, Eclipse, Putty, File Zilla, SQL Developer, Toad, Teradata SQL Assistant, Agnity Workbench for Netezza, Quality Center, Harvest, SQL Server Management Studio.

SAP BO / Analytics / Visualizations: XIR2/XI3.0/XI3.1/4.0,4.1,4.2, Web Intelligence, Xcelsius 2008, SAP Lumira, Data Visualization, SAP BO Mobile, Dashboard Designer 4.0, Crystal reports, SAP BW, Voyager, Live Office, Polestar, QlikView, Tableau 7, 8,9,10.5

Operating Systems: MS Windows 2010/2000/XP/NT, Mac OS, Unix and Linux.

RDBMS: Oracle 11g/10g, MS-SQL Server 2000/2005/2008 , DB2 MS Access, MySQL.

Web Technologies: HTML, XML, CSS, XSD, JavaScript and JSON

Technical Languages: Core Java, SQL, PL/SQL, C, C++

Web/App Servers: Apache Tomcat 6.0, web logic8.1/9.2

Others: Quick Test Professional 9.0 & Bugzilla.

PROFESSIONAL EXPERIENCE

Confidential

ETL Talend Consultant / BI Team Lead

Responsibilities:

  • Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
  • Created Repositories, Users & assigned the security in the Multi-Team Environment.
  • Migrated from Dev to UAT and UAT to Prod version which includes Users reports/ universes/ users .
  • Monitored performance issues and troubleshooting.
  • Optimized Servers settings and tacking of trace logs on servers in case of troubleshooting complex incidents.
  • Upgraded 3.1 version to 4.2 version.
  • Regular Cold and Hot backups and 99.9% server uptime.
  • Installed patches and fix packs when released.
  • Work with IT and business users to resolve support and technical questions
  • Provide off-hours and weekend support in an on-call rotation
  • Performed installation, migration, configuration, maintenance, technical support and troubleshooting of Business Objects implementation.
  • Perform testing of Business Objects support packages and patches
  • Support changes in server configurations and troubleshooting of Business Objects SDLC environment.
  • Developed SAP reports for different modules using source as BW. BW reports have been migrated to SAP BO.
  • Made enhancements to the existing Universes for Revenue, Minutes of Usage and Leased Line Voice Grid Services as per the requirements.
  • Developed new reports using Business Objects functionalities like Queries, Cross Tab, and Master Detail etc.
  • Developed additional Dashboards for Revenue Segment wise and Group wise.
  • Understand the Requirements and Functionality of the application from specifications.
  • Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
  • Worked on Talend 7.1.1 and 7.2.1
  • Upgraded from 6.3 to 7.2
  • Experience in connecting Talend with S3, and other cloud component etc.
  • Build Talend job to load and retrieve data from snowflake, IBM Mainframes, Sales force.
  • Created Talend job that will be pulling up the all Investment data and upload them on AWS S3.
  • Created EMR Cluster using Talend Studio
  • Created edge node in the EMR Clusters VPC
  • Executed Spark job on the EMR cluster using remote Job server.
  • Analyzing the source data to know the quality of data by using Talend Data Quality
  • Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings. Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and target.
  • Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL.
  • Solid experience in implementing complex business rules by creating re-usable transformations and robust mappings using Talend transformations like tConvertType, tSortRow, tReplace, tAggregateRow, tUnite etc.
  • Developed Talend jobs to populate the claims data to data warehouse - star schema.
  • Utilized Big Data components like tHDFSInput, tHDFSOutput, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput,
  • Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
  • Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history.
  • Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines.
  • Experienced in using debug mode of talend to debug a job to fix errors. Created complex mappings using tHashOutput, tHashInput, tNormalize, tDenormalize, tMap, tUniqueRow. tPivotToColumnsDelimited, etc.
  • Used tRunJob component to run child job from a parent job and to pass parameters from parent to child job.
  • Created Context Variables and Groups to run Talend jobs against different environments.
  • Used tParalleize component and multi thread execution option to run subjobs in parallel which increases the performance of a job.
  • Implemented Third party Scheduler (Automic Schedular) to trigger the jobs in TAC server.
  • Implemented Kafka to read Json messages from the provided kafka topic.

Confidential

ETL Talend Consultant / BI Team Lead

Responsibilities:

  • HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
  • Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
  • Good working experience in Business Objects, Supervisor, Designer, Broadcast Agent (BCA), ZABO, Web Intelligence and Business Objects SDK.
  • Developed universe on top of Oracle11g/10g/9i, MS SQL Server 2005, IBM DB2 V8 and Tera data V14.
  • Retrieved information using WebFOCUS for analysis and forecasting.
  • Created databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
  • Used query tools like SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man.
  • Administration of servers, SAP Business Objects 4.1 Platform, Data Services ETL, Tomcat web servers, Crystal Reports, and Xcelsius Dashboards, Active Directory SSO.
  • Successful roll out and upgrade of a virtualized Business Objects Platform 4.1 with FP3.
  • Created reports using Web Intelligence tools with Business Objects Universe, BEX Queries and SAP HANA Studio as the Data providers.
  • Published dashboards and reports using InfoBurst tool.
  • Interpret business requirements from the business partners. Design and develop objects to facilitate information for data analysis.
  • Created complex mappings in Talend 6.2using tMap, tJoin, tReplicate, tParallelize, tFixedFlowInput, tAggregateRow, tFilterRow, tIterateToFlow, tFlowToIterate, tDie, tWarn, tLogCatcher, tHiveIput, tHiveOutputetc.
  • Write scripts as per the standards of BeeDoo framework.
  • Designed ETL process using Talend Tool to load from Sources to Targets through data Transformations.
  • Design and developed ETL process to load and extract data using BTEQ, MLOAD and Fast Export.
  • Experience in writing SQL*Loader scripts for preparing the test data in Development, TEST environment and while fixing production bugs.
  • Experience in understanding the Explain statements and optimization of queries
  • Experience in using the debugger to identify the processing bottlenecks, and performance tuning of Informatica to increase the performance of the workflows.
  • Experience in creating ETL deployment groups and ETL Packages for promoting up to higher environments.
  • Involved in various phases of the software development life cycle right from Requirements gathering, Analysis, Design, Development, and Testing to Production.
  • Performed transformations, cleaning and filtering on imported data using Hive, MapReduce, and loaded final data into HDFS.
  • Performed production support activities in Data Warehouse (Informatica) including monitoring and resolving production issues, pursue information, bug-fixes and supporting end users.

Confidential, Milan, IL

ETL Talend Developer

Responsibilities:

  • Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
  • Installed and tested the BI4.0 application on sandbox.
  • Worked with server team to provide them with list of specifications need to build the servers for BO4.0.
  • Worked with Developers to consolidate the Business Objects repository before migrating to BO4.0.
  • Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
  • Created Repositories, Users & assigned the security in the Multi-Team Environment.
  • Worked on the BW open Hub tables to extract the data from the BW.
  • Extracted Data from all the Relational Databases including oracle, Microsoft SQL server and loaded in different environments which include BW, ORACLE, SQL SERVER, Tera data and .txt & .CSV files.
  • Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
  • Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
  • Worked on all the standards & guidelines Best practices Documentation, and the functional & Technical design specification documentation.
  • Migrated all the Projects of the team from DEV TO TEST TO PROD, & scheduled the jobs as part of the Administrator.
  • Worked on the Data Quality, Address cleanse transformations for cleansing the data
  • Provided the technical guidance & knowledge transfer of effectively using BODS4.0
  • Developed SSIS Package to centralize the Data coming from different Data Sources which is used for developing new reports.
  • Developed SAP reports for different modules using source as BW. BW reports have been migrated to SAP BO.
  • Made enhancements to the existing Universes for Revenue, Minutes of Usage and Leased Line Voice Grid Services as per the requirements.
  • Developed new reports using Business Objects functionalities like Queries, Cross Tab, and Master Detail etc.
  • Developed additional Dashboards for Revenue Segment wise and Group wise.
  • Developed additional Dashboards for Monthly Revenue, Yearly Revenue, Number of Lines, Bandwidth Sold, Revenue by Product and Revenue by Market Segment using Xcelsius 2008
  • Understand the Requirements and Functionality of the application from specifications.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
  • Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
  • Converted existing BO reports to tableau dashboards
  • Created different KPI using calculated key figures and parameters
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
  • Involved in Extraction, Transformation and Loading of data from 10 Source Systems into our data warehouse.
  • Work with the offshore team for the day to day work and review the tasks done by them get the status updates in the daily meetings.
  • Created Jobs for Matching and Merging to cleanse the data coming from Source system.
  • Worked with different Sources such as Oracle, SQL Server and Flat files
  • Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
  • Wrote test case scenarios and unit tested the code developed in Informatica
  • Worked on the project documentation and prepared the Source Target mapping specs with the business logic and also involved in data modeling
  • Worked on migrating data warehouses from existing SQL Server to Oracle database.
  • Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scans.
  • Used Command line Shell to run the Informatica jobs.
  • Used debugger and breakpoints to view transformations output and debug mappings.
  • Implemented Performance tuning in Mappings/Jobs by identifying the bottlenecks and Implemented effective transformation Logic.
  • Created Workflows using various tasks like sessions, control, decision, e-mail, command, Mapplets/Joblets and assignment and worked on scheduling of the workflows.
  • Verify the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.
  • Wrote SQL, PL/SQL, stored procedures, triggers and cursors for implementing business rules.
  • Migrated the code and release documents from DEV to QA (UAT) and to Production.

Confidential

ETL/BI Developer

Responsibilities:

  • Migrated various applications from 5.1 & 6.5, XI R2 to 3.1and provided support to new Environment.
  • Configured servers in XI R2 for Development, Test and Production environments and created group structure
  • Designed BO Report templates.
  • Involved in day to day Business Objects Server maintenance.
  • Implemented best practices for using Business Objects Suite.
  • Provided support to resolve client technical issues.
  • Expertise in BO XI R2 CMS and complete security model at BO enterprise level.
  • Well versed in BOE architecture, Services process flows, content, security, scheduling and publishing.
  • Conducted end user training sessions and prepared training material.
  • Worked as SAP BO Consultant and Tableau Developer roles.
  • Using Tableau server versions (6.0) as a front-end BI tool and Microsoft SQL Server 2012 as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
  • Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
  • Developed a 360 business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE.
  • Implemented Tableau mobile dashboards via Tableau mobile application.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Created Repositories, Users & assigned the security in the Multi-Team Environment.
  • Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.
  • Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
  • Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
  • Constantly interacted with the Business Intelligence team and the Data warehouse Architecture team to understand the requirements and implement them seamlessly.
  • Meeting with business users and defining Functional and Technical business requirements.
  • Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
  • Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
  • Extensively used all the Transformations like source qualifier, aggregator, filter, joiner, Update Strategy, Unconnected and connected Lookups, Router, Sequence Generator.
  • Extensively worked on Workflow Manager and Workflow Monitor to create, schedule, monitor Workflows, Worklets and various tasks like command, assignment, control and session tasks.
  • Implemented Change Data Capture technology in Talend in order to load deltas to a Datawarehouse.
  • Developed joblets that are reused in different processes in the flow.
  • Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
  • Extensively worked on ETL performance tuning to tune the data load and worked with for SQL query tuning etc.
  • Developed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
  • Created staging tables to load the data in warehouse to perform ETL tasks using Informatica
  • Worked with BA’s to finalize Data Model, functional and detailed technical requirements
  • Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
  • Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.

Environnent: Informatica Power Center 8.6, Oracle 10g/9i, DB2, MS Access, TOAD 9.0, Teradata V2R6, PL/SQL, UNIX.

Hire Now