SUMMARY

• 8 years of IT experience on Client - Server architecture, Business Intelligence applications in various phases of IT projects such as analysis, design, deployment, coding and testing using Talend, SSIS and DataStage on OLAP and OLTP environments for Banking, Financial and Health care clients.
• 3+ years of experience using Talend Integration Suite (5.0/5.5/6.1)/Talend Open Studio (5.0/5.5/6.1).
• Extracted data from multiple operational sources including flat files, RDBMS tables, and legacy systems for loading staging area, Data warehouse, Data Marts using SCDs (Type 1/Type 2/ Type 3) loads.
• Experience in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).
• Experience in integration of various data sources like Teradata, SQL Server, Oracle, DB2, Netezza and Flat Files.
• Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and loading using Talend/SSIS and designed data conversions from wide variety of source systems.
• Experience working with Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Logical Data Modeling, Physical Modeling, Dimension Data Modeling.
• Expertise in interaction with end-users and functional analysts to identify and develop Business Requirement Documents (BRD) and Functional Specification documents (FSD).
• In depth understanding of the Gap Analysis i.e., As-Is and To-Be business processes and experience in converting these requirements into Technical Specifications and preparing Test Plans.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Extensively created mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tJava, tJavarow, tDie, tAggregateRow, tWarn, tLogCatcher,tMysqlScd, tFilter, tGlobalmap etc.
• Utilized tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• Familiar in using cloud components and connectors to make API calls for accessing data from cloud storage (Google Drive, Salesforce, Amazon S3, DropBox) in Talend Open Studio.
• Experienced in creating Generic schemas and creating Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
• Worked Extensively on Creating and Calling Complex Stored Procedures, Views, Functions, Cursors, Triggers, Indexes using SQL Server 2005/2008/2012. Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008/2012.
• Involved in migration of DTS Packages (2005) to SSIS (2008) and troubleshoot migration issues.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Created sub jobs in parallel to maximize the performance and reduce overall job execution time with the use of parallelizecomponent of Talend in TIS and using theMultithreadedExecutions in TOS.
• Created Execution Tasks in Talend Administration Center on jobs that are either saved in SVN or in Pre-generated Studio as Zip files.
• Experienced in versioning, importing and exporting Talend jobs. Set up Triggers for Talend jobs in Job conductor.

TECHNICAL SKILLS

ETL/BI Tools: Talend 5.0/5.5/6.1, SSIS, DTS(Data Transformation Services)

Databases: Oracle 11i/10g/9i, MS SQL Server, DB2, Teradata, Netezza

Programming Languages: SQL, T-SQL, PL/SQL, CSS, HTML, XML, javascript.

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

Operating Platforms: MS Windows2010/2000/XP/NT, Mac OS, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Talend Developer

Responsibilities:

• Interact with Solution Architects and Business Analysts to gather requirements and update Solution Architect Document.
• Analyze and create low level design document (LLD) and mapping document.
• Performed analysis, design, development, Testing and deployment for Ingestion, Integration, provisioning using Agile Methodology.
• Attended Daily Scrum meetings to provide update on the progress of the user stories Rally and to the Scrum Masterand also to notify blocker and dependency if any.
• Experienced in creating Generic schemas and creating Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings.
• Experienced in Talend Data Integration, Talend Platform Setup on Windows and UNIX systems.
• Created complex mappings in Talend 6.0.1/5.5 using tMap, tJoin, tReplicate, tParallelize, tJava, tjavarow, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
• Created joblets in Talend for the processes which can be used in most of the jobs in a project like to Start job and Commit job.
• Developed jobs to move inbound files to vendor server location based on monthly, weekly and daily frequency.
• Implemented Change Data Capture technology in Talend in order to load deltas to a DataWarehouse.
• Created jobs to perform record count validation and schema validation.
• Created contexts to use the values throughout the process to pass from parent to child jobs and child to parent jobs.
• Developed joblets that are reused in different processes in the flow.
• Developed error logging module to capture both system errors and logical errors that contains Email notification and also moving files to error directories.
• Provided the Production Support by running the jobs and fixing the bugs.
• Experienced in using Talend database components, File components and processing components based up on requirements.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.
• Worked in improving performance of the Talend jobs.
• Performed unit testing and also integration testing after the development and got the code reviewed.
• Involved in migrating objects from DEV to QA and then promoting to Production.

Environment: Talend Studio 6.0.1/5.5, Oracle 11i, XML files, Flat files, HL7 files, JSON, TWS, Hadoop 2.4.1, HDFS, Hive 0.13, HBase 0.94.21, Talend Administrator Console, IMS, Agile Methodology, HPSM

Confidential, Richmond VA

ETL/Talend Developer

Responsibilities:

• Conducted JAD sessions with business users and SME's for better understanding of the reporting requirements.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• 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.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• 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.
• 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 FTP operations using Talend Studio to transfer files in between network folders as well as to
• FTP server using components like tFileCopy, TFileAcrchive, tFileDelete, tCreateTemporaryFile, tFTPDelete, tFTPCopy, tFTPRename, tFTPTruncate, tFTPut, tFTPGet etc.
• Experienced in Building a Talend job outside of a talend studio as well as on TAC server.
• Experienced in writing expressions with in tmap as per the business need.
• Handled insert and update Strategy using tmap.
• 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.

Environment: Talend 5.5/5.0, Oracle 11g, Teradata V 13.0, Fast load, Multiload, Teradata SQL Assistant, MS SQL Server 2012/2008, PL/SQL, Agile Methodology, T-SQL, SSIS, TOAD, Erwin, AIX, Shell Scripts, Autosys.

Confidential, Dover NH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
• From one standard database for loans created diversified destinations for auto loans, student loans, home loans using SSIS packages.
• Created SSIS script tasks, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created Consolidations, Custom Groups and Prompts for the Micro Strategy reports.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Unit tested all the reports by running queries against the warehouse using SQL
• Created T-SQL queries, created dynamic Stored Procedures that calculates the loan sanctioning details taking the customer details as input and also Created report models for ad hoc reports when the end user wants to see the reports on fly.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.
• Calculated loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.
• Responsible for the Performance tuning and optimization with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Query Optimization handled by using extensive use of Index implementation and Index Tuning Wizard
• Designed, reviewed, and created primary objects (views, indexes, etc based on logical design models, user requirements and physical constraints.

Environment: MS SQL Server 2008, SQL server 2005, MS Server Integration services, C#, .NET, Windows7

Confidential, Grand rapids, MI

SQL Developer (SSIS/SSRS)

Responsibilities:

• Designed physical and logical database structures/diagrams.
• Created tables, relationships, triggers and indexes for enforcing business rules.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Wrote different complex SQL queries including inner, outer join and update queries.
• Developed reports for payment and BI Count to show organizational and seasonal comparison.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Worked on DTS Package, DTS Import/Export for transferring data from various heterogeneous sources to SQL Server.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Created Queries, Stored Procedures for generating drill down reports in SSRS.
• Designed and implemented stylish report layouts.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Responsible for report generation using SQL Server reporting services based on business requirements.
• Responsible to provide production support to the client.

Environment: Windows NT, Windows 2007, SQL Server 2005, DTS, SSIS, T-SQL, XML, MS SQL Reporting Services.

Confidential, Bentonville, AR

MS BI Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for personal banking system.
• Installed SQL Server 2005 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans and also database backup and recovery.
• After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2000 using DTS.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.

Environment: DB2, SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, BizTalk Server2004, IIS 6.0, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service.

Confidential

SQL Developer

Responsibilities:

• Involved in creating database objects like tables, stored procedures, views, triggers, and user defined Functions for the project which i was working on.
• Analyze the client requirements and translate them into technical requirements.
• Gathered requirements from the end user and involved in developing logical model and implementing requirements in SQL server 2000
• Data migration (import & export - BCP) from text to SQL server.
• Responsible for creating reports based on the requirements using reporting services 2000.
• Identified the database tables for defining the queries for the reports.
• Worked on SQL server queries, stored procedures, triggers and joins.
• Defined report layouts for formatting the report design as per the need.
• Identified and defined the datasets for report generation.
• Formatted the reports using global variables and expressions.
• Deployed generated reports onto the report server to access it through browser.
• Maintained data integrity by performing validation checks.

Environment: MS SQL 2000, Windows server 2000, SQL Query Analyzer and Enterprise Manager, MS Access 2000 & Windows NT platform