SUMMARY:

• 5+ years of IT experience, which includes Administration, System Analysis, Design, Development, Testing, Security and Support in Microsoft Database Technologies with various Industry verticals like financing, insurance and Health care.
• Over 2 years of extensive experience in Information Technology with special emphasis on Data Warehousing and ETL process using Talend OS.
• Excellent knowledge of OLTP and OLAP Systems, developing Database schemas.
• Excellent experience in Extraction, Transformation and Loading of data into Warehouse and downstream applications from heterogeneous systems using ETL tool - Talend Open Studio and Talend Integration Suite.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, Database Maintenance plans, and Database Consistency Checks using DBCC commands.
• Expertise in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Filter, Expression, Rank, Aggregator, Joiner, Union, Update Strategy and Stored procedure.
• Hands on experience on several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type I and Type II).
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2008/2005/2000 databases.
• Involved in configuring the reporting services (SSRS) and creating the reports in SQL server 2008/2005.
• Extensive experience in creating Reusable Mapplets, Worklets and used event wait, decision box, email and command tasks in Workflows.
• Extensively worked on integrating various data sources- Oracle, SQL Server, DB2, Teradata, XML files, Mainframe related data and Flat files.
• Experience with Database Backup, Recovery and Disaster recovery procedures.
• Experience with SQL Server 2008 Database Mirroring, Migration, Upgrading.
• Data migration using ETL tools like DTS services/SQL Server Integration Services (SSIS) across different databases like Oracle, MS access & flat files.
• Experience in using Microsoft’s in built tools like SQL Profiler, Windows Perfmon and DTS, SSIS, SSRS for Monitoring, Developing and Tuning MS SQL Server applications.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL, SQL Scripts and Batch files.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters.
• Expert in Configuring, Managing and optimizing transactional replication in OLTP environments.
• Experience in using DTS Import/Export utility, BCP and DTS Packages.
• Worked with Popular monitoring solutions such as SQL Diagnostic Manager, Quest Spotlight
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail and Talend OS.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Developed backup and recovery strategies for SQL Server databases.
• Documented disaster recovery plans and participated disaster recovery drills.
• Experience in monitoring the disk usage and the memory usage of the servers
• Excellent team player with good communication skills.
• Ability to adapt new technologies
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/2003/2008 Advanced Server, Windows Exchange Server 2003 Windows NT 4.0/3.5, Windows9.x, Windows XP.

ETL Tools: Talend Open Studio, Talend Integration Suite 5x/4x, Informatica Power Center

RDBMS: MS SQL Server 2008,2005, 2000, MS Access 2000, 2003

Languages: SQL, T-SQL, MySQL.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designed and built ETL mappings and workflows to load data from different sources MS Excel, SQL Server and fixed width as well as Delimited Flat files.
• Used Expression, Aggregator, Lookup, Filter, Router, Sequence Generator, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Implemented Variables and Parameters in the mappings.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Created Implicit, local and global Context variables in the job.
• 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.
• Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.
• Worked with data analysts in analyzing data to come up with an extraction strategy in processing catalog updates.
• Involved in production deployment activities, creation of the deployment guide for migration of the code to production, also prepared production run books.
• Coordinated onsite team efficiently for the projects.

Environment: Talend Open Studio V5.4.1, SQL Developer, SQL Navigator, Toad 10.6, PL/SQL, SQL Server, Windows XP.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Participated in all phases of development life-cycle.
• Designed and built ETL mappings and workflows to load data from different sources MS Excel, SQL Server and fixed width as well as Delimited Flat files.
• Used Expression, Aggregator, Lookup, Filter, Router, Sequence Generator, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Implemented Variables and Parameters in the mappings.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Created Implicit, local and global Context variables in the job.
• 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.
• Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.
• Worked with data analysts in analyzing data to come up with an extraction strategy in processing catalog updates.

Environment: Talend Open Studio V5.4.1, SQL Developer, SQL Navigator, Toad 10.6, PL/SQL, SQL Server, Windows XP.

Confidential, Pataskala OH

ETL Developer

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Developed Technical Design documents (LLD & HLD) for ETL strategy and Oracle dump approaches for both Initial and Incremental Loads.
• Designed and built ETL mappings and workflows to load data from different sources Oracle, Sybase, SQL Server and fixed width as well as Delimited Flat files.
• Used Expression, Aggregator, Lookup, Filter, Router, Sequence Generator, Sorter, Stored Procedure transformations to do necessary data calculations and manipulations according to the business rules and loaded data into Target systems.
• Implemented Variables and Parameters in the mappings.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Created Implicit, local and global Context variables in the job.
• 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.
• Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.
• Developed stored procedure to automate the testing process to ease QA efforts and also reduced the test timelines for data comparison on 500 tables.
• Worked with data analysts in analyzing data to come up with an extraction strategy in processing catalog updates.
• Wrote UNIX shell scripts to SFTP files, archive files and pre-validation scripts.
• Expertise in documenting Mapping documents, Unit test plans, test results and Deployment plans.
• Analyzed change requests and performed impact analysis and estimated level of efforts.
• Worked on advanced concepts like concurrent running of the workflow, session level partitioning techniques and pushdown optimization.
• Automated SFTP process by exchanging SSH keys between UNIX servers.
• Scheduled workflows using PMCMD and UNIX Shell scripts using Control-M for daily and monthly loads.
• Involved in production deployment activities, creation of the deployment guide for migration of the code to production, also prepared production run books.
• Coordinated offshore and onsite teams efficiently for multiple projects.

Environment: Talend Open Studio V5.4.1, SQL Developer, SQL Navigator, Toad 10.6, PL/SQL, SQL Server, Clipper DB, Progress DB, Control M, Windows XP, UNIX.

Confidential, NJ

ETL/Informatica Developer

Responsibilities:

• Coordinated with the client and gathering the user requirements.
• Designed and developed ETL process using Informatica tool.
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Worked extensively with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked extensively with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Created Connected and Unconnected lookup transformation for better performance.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Created reusable transformations and used in various mappings.
• Used various debugging techniques to debug the mappings.
• Developed mapping to implement type 2 slowly changing dimensions.
• Developed Informatica parameter files to filter the daily source data.

Environment: Informatica Power Center 8.6, Business Objects, Toad for SQL, SQL Server 2000, Flat Files, Erwin, MS Visio, Windows.