SUMMARY:

• Total 8 years of experience in IT including development, Analysis and support.
• 6+ years of professional experience as a Data warehouse /ETL developer in IT Industries with strong Data Warehousing, Data Marts, Data Analysis experience in RDBMS databases
• Database expertise including SQL, ETL, Reporting, and Tuning.
• Hands on Experience in development of Reports and Dashboard in Tableau. Working Experience in design and development of Tableau visualization solutions.
• Proficient in developing security metrics program and creating Tableau dashboards and various visuals in Tableau.
• Data Warehousing experience on Data Modeling using Star schema and Snowflake schema with Facts, Measures and Slowly Changing Dimensions (SCD) Type1, Type2, and Type3.
• Specialty expertise with Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more)
• Involved in Customization & Implementation of DB2 and MySQL Applications.
• Specialty expertise with Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more)
• Extensively use ETL methodology for performing Data Migration, Data Profiling, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems like SQL Server, Oracle, DB2 and non - relational sources like XML, flat files, and mainframe Files.
• Experience in scheduling tools Autosys, Control M & Job Conductor (Talend Admin Console)
• Extensively experience with Talend, SQL Server DTS & Integration Services (SSIS) Packages,
• Participated in Test Plans, Test Scenarios and Test Cases based on Business Requirements and Technical Documents for ETL
• Extracting data from production data stores, Built Data structures, Developed departmental reports for performance and response purposes by using Oracle, SQL, MS Access, MS Excel, PL/SQL.
• Experience in Data warehouse, ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Reporting, Validation and Documentation.
• Designing, Developing, implementation of the Data marts, Data Structures, Stored Procedures, Functions, Data warehouse tables, views, Materialized Views, Indexes at Database level using PL/SQL, Oracle.
• Experienced in databases - design, writing stored procedures, triggers and queries.
• Strong in analysis, requirements gathering, design, development, implementation, and management of full life cycle data warehousing projects.
• Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies

TECHNICAL SKILLS:

Operating Systems: WINDOWS NT, WINDOWS 95/98/2000 and UNIX

RDBMS: Oracle 10g/9i, SQL Server 2008/2005/2000, Sybase

Data Modeling: Erwin, Visio2000

Languages: C, C++, Java, COBOL, PL/SQL, T-SQL

ETL: SSIS, Talend, Tableau 9.x(with API)

Reporting tool: SSRS, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

ETL Developer

Roles & Responsibilities:-

• Used ETL methodologies and best practices to create Talend ETL jobs
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Experience in using Repository Manager for Migration of Source code from Lower to higher environments.
• Created Projects in TAC and Assign appropriate roles to Developers and integrated SVN (Subversion)
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger)
• Extracted data from flat files/ databases applied business logic to load them in the staging database as well as flat files.
• Designed ETL Jobs/Packages using Talend Integration Suite (TIS).
• Responsible for all technical and system specifications documents for all ETL processes.
• Implement procedures for maintenance, monitoring, backup, and recovery operations for the ETL environment.
• Creating the configuration file for maintaining Log files.
• Extracted data from flat files/ databases applied business logic to load them into Netezza tables.
• Used Netezza utilities Nzload and External Tables to load in Netezza tables in Talend.
• Designed ETL Jobs/Packages using Talend Integration Suite (TIS).
• Created Talend Mappings to populate the data into dimensions and fact tables
• 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.
• Tableau desktop and server tickets resolution (primary contact for support)
• Reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs.
• Developed tableau server audit reports to view and analyze tableau server insights ( tableau server usage, tableau server data extract failures etc.)
• Tableau server status reporting and data extract management.
• Resolving tableau dashboards development and performance issues

Environment: Talend Integration Services 5.6, Netezza, SVN, Talend Administrative Console (TAC), Tableau Desktop 8/9, Tableau Server 8/9, Tableau Public,

ETL Consultant

Roles & Responsibilities:-

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design documents.
• Defined and documented the technical architecture of the Data Warehouse, including the physical database components and their functionality.
• Involved in the creation of Talend mappings to extracting data from oracle, Flat Files to load in to Stage area.
• Responsible for implementing the Talend jobs to Process the delta data load.
• Design and Implemented Talend ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Designed ETL Jobs/Packages using Talend Integration Suite (TIS)
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• 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.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Used Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more)
• Extensively worked on flat files, CSV files and involved in creation of UNIX shell scripts using different shell scripts, loading multiple files and archiving the files after the completion of loads.
• Worked data mapping, data cleansing, program development for loads, and data verification of converted data from legacy data.
• Documented the existing mappings as per the design standards followed in the project.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Talend jobs, and the Target Data.
• Testing and debugging of all ETL and database objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Interacted with developers & other team members to discuss about ETL architecture and improvements.
• Communicated with the Data Management Group Manager to discuss the status of areas I was in charge of, for maintaining data layer on a periodic basis.

Environment: Talend Integration Services (5.4), Tableau Desktop and Server 7/8, Oracle 10g DB, Unix, SVN, UNIX Shell Scripting, SQL Server 2008

ETL Developer

Roles & Responsibilities:-

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design documents.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin with Architect teams, I assisted them with Data Analysis & profiling.
• Defined, and documented the technical architecture of the Data Warehouse, including the physical database components and their functionality.
• Responsible for implementing the Talend jobs with CDC logic to Process the delta data load.
• Extensively worked on flat files, CSV files and involved in creation of UNIX shell scripts using different shell scripts, loading multiple files and archiving the files after the completion of loads.
• Involved in the creation of Talend mappings to extracting data from oracle, Flat Files to load in to Stage area.
• Worked data mapping, data cleansing, program development for loads, and data verification of converted data from legacy data.
• Designed and Created data cleansing, data conversion, validation and loading jobs with Talend.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Talend jobs, and the Target Data.
• Proposed enhancements for relational database design, stored procedures, functions, triggers and scalability analysis.
• Testing and debugging of all ETL and database objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Documented the existing mappings as per the design standards followed in the project.
• Attended project meetings and work with teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks.

Environment: Talend open Studio 4.2, UNIX Shell Scripting, SQL Server 2008/2005

ETL Developer

Roles & Responsibilities:-

• Involved in business requirements, technical requirements, high-level design, and detailed design process.
• Worked on loading of data from several flat files sources to Staging using SSIS.
• Extracted data from the source Oracle & DB2 database using SSIS and linked server and generated ad-hoc reports.
• Worked on exporting data to flat files using SSIS File import, created SSIS Packages using Transformation, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Generated excel reports and power-point reports using VBA Macros.
• Worked with the users and testing teams to implement the business logic as expected.
• Written several source to target mappings to implement the business logic.
• Performance tuned ETL Batch jobs, Reporting and Ad-hoc SQL.
• Performed Data validation, Data integrity before delivering data to operations, Business, Financial analyst by using Oracle, SQL Server, MS Excel, MS Access.
• Developed SQL queries, Ad Hoc for Extracting data from production databases to build data structures, reports.
• Developed Ad hoc queries and scripts to meet the Business Analyst’s and the Operational Analyst’s requirements by using database, UNIX, Oracle, SQL.
• Created technical documentation for database, Function documentation/specification for report requirements
• Performed data extraction, data manipulation, data validations with help of database

Environment: SQL Server, SSIS, SSRS, IBM DB2 8.x, Oracle 10g

ETL Developer / Analyst

Roles & Responsibilities:-

• 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 mappings /Transformation/Joblets in Talend 5.4.
• Designed ETL Jobs/Packages using Talend Integration Suite (TIS)
• Worked on different data sources such as Oracle, Netezza, MS SQL, Flat files etc.
• Created complex mappings in Talend 5.0 using tHash, tDenormalize, tMap, tUniqueRow. tPivotToColumnsDelimited As well as custom component such as tUnpivotRow
• 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
• 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.
• Worked on heterogeneous data sources and targets such as Oracle, DB2/AS400, SQL Server 2008
• Created physical database objects from data model to physical database like tables, indexes, views, and triggers. Also created DDL files to be deployed by production DBAs.
• Developed Talend Jobs for ETL to perform data cleansing, standardizing, and sourcing from DB2 database and load to target for initial load and for Change Data Capture (CDC) data load including absentee processing.

Environment: Talend Integration Services (4.0), Netezza DB, MS SQL Server 2008,T-SQL, Unix, Linux, Wiki, SVN, Talend Administrative Console (TAC), Java, Oracle,AS400, DB2 9

ETL Developer/Talend

Roles and Responsibilities:-

• Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions (SCD) Type1, Type 2, Type 3 to capture the changes.
• Extensive experience in extraction of data from various sources like relational databasesOracle, SQL Server, and Flat Files.
• Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL.
• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designing, developing and deploying end-to-end Data Integration solution.
• Implemented custom error handling in Talend jobs and worked on different methods of logging.
• Develop the ETL mappings for XML, .CSV, .TXT sources and also loading the data from these sources into relational tables with Talend ETL Developed Joblets for reusability and to improve performance.
• Created UNIX script to automate the process for long running jobs and failure jobs status reporting.
• Developed high level data dictionary of ETL data mapping and transformations from a series of complex Talend data integration jobs.
• Expertise in interaction with end-users and functional analysts to identify and develop Business Requirement Documents (BRD) and Functional Specification documents (FSD).
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Created context variables and groups to run Talend jobs against different environments.
• Performed requirement gathering, Data Analysis using Data Profiling scripts, Data Quality (DQ) scripts and unit testing of ETL jobs.
• Created triggers for a Talend job to run automatically on server.
• Installation of Talend Enterprise Studio (Windows, UNIX) and configuring along with Java.
• Set up and manage transactional log shipping, SQL server Mirroring, Fail over clustering and replication.
• Worked on AMC tables (Error Logging tables)

Environment: Talend Platform for Data management, UNIX Scripting, Toad, Oracle 10g, SQL Server

Data Analyst

Roles & Responsibilities:-

• Documents the complete process flow to describe program development, logic, testing, and implementation, application integration, coding
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines
• Responsible for conducting due diligence review of business banking customers
• Conducted GAP analysis to analyze the variance between the system capabilities and business requirements
• Created Report - Models for ad-hoc reporting and analysis
• Perform small enhancements (data cleansing/data quality)
• Extensively used SQL for accessing and manipulating database systems.
• Used SPSS and R for statistical analysis and data visualization
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation

Environment: UNIX, Shell scripting, SQL Server BI Development Studio, SAS/SQL, Teradata V12, R, SSIS, MS SQL Server, Flat files

Contractor- Desktop Support Specialist

Roles & Responsibilities:-

• Provided daily desktop, technical end-user support and training to over 3,000 users. This includes problem resolution via remote control, phone, network, and e-mail in person.
• Created new user accounts, profiles, assign users specific rights as well as created home directories, assign to groups and map network drives.
• Performed XP deployment rollout for over 3,000 users on site and configure/ghost new PC’s with new image.
• Used SMS/PC Anywhere and Remote desktop connection to directly control and monitor remote clients as well as shadow RAS users that are connected.
• Supported over 250 enterprise applications.
• Trained new employees in current email software and develop Quick Desk Reference Guides.
• Troubleshot and resolved a wide variety of extensive desktop applications/issues, email problems, developed software and Internet based applications.
• Troubleshot PC related problems such as printer connection, remote location, hardware, scanners and other related peripherals.
• Installed software, hardware (floppy drives, memory sound devices, etc.).
• Performed daily database backup and recovery.
• Inputted trouble tickets via help desk software in order to track user problem and resolution.
• Researched, organized and established accounts with various vendors for hardware requests, repairs, equipment and services.
• Conducted myself in service-oriented manner that is attentive, pleasant, cooperative, sensitive, respectful and kind when dealing with users, visitors, public and all employees.
• Kept clients informed of all aspects pertaining to their service request and bring all customer requests to resolution and/or escalation to management or technical support.