PROFESSIONAL SUMMARY:

• Having 7+ years of experience in IT industry as SQL Developer in MS SQL Server 2014/2012/2008/2005/2000 in Production, Quality & Development environments.
• Worked on Software Development Life Cycle (SDLC), data modeling, business analysis, and data warehouse.
• Proficient in design of logical and physical data modeling using Erwin, VISIO data modeling tool.
• Expert in creating Database Objects - Schemas, Tables, Indexes (clustered and non-clustered), Views, User defined functions (UDFs), Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Worked wif T- SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Efficient in building queries using CTEs (Common Table Expressions).
• Experience in ETL (Extraction, Transformation and Loading) using Data transfer services (DTS) and SQL Server Integration Services ( SSIS) from various Data sources .
• Hands on experience in writing testing and debugging stored procedures, triggers and troubleshooting database issues.
• Experience in query optimization (SQL tuning) using SQL Profiler, Database Tuning Advisor (DTA), Index tuning wizard and Performance monitor for performance tuning.
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.
• Experience in developing, configuring, and deploying teh SSIS packages and providing security for teh packages.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Data Validation issues.
• Expertise in managing project versions and source code changes using source control tools like Visual source safe and TFS.
• Created different types of SSRS reports like tabular, matrix, list, gauge, and ad-hoc reports.
• 3 years’ experience in Talend DI and Bigdata Integration and Admin experience
• Highly proficient in teh integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, Teradata, and non-relational sources like Flat Files.
• Created Talend Development Standards. This document describes teh general guidelines for Talend developers, teh naming conventions to be used in teh Transformations and development and production environment structures.
• Very familiar wif Talend Admin Console.
• Used TAC for creating execution plans and scheduling.
• Implemented Error Handling and logging in Talend.
• Implemented orchestration of Jobs and Published Jobs to Nexus and TAC.

TECHNICAL SKILLS:

Operating Systems: Windows 2003/2007/2008/2010 Server, Windows XP, Windows Vista, LINUX & Unix

MS SQL Server components/environment: SQL Server Management Studio, Business Intelligence tools ( SSIS , SSAS, SSRS ), ETL, Performance Tuning, Database modeling by using Erwin Data modeler, Master Data Services

Languages: C, C++, PL/SQL , T-SQL, PostgreSQL, Visual C#, Visual Basic, HTML. Sql Workbench

RDBMS: SQL Server 7.0/2000/2005/2008/2012/2014, MySQL, MS Access, Oracle 9i/10g/11g, PostgreSQL

Application: MS-Visio, Erwin, Visual Studio, .NET, C#, VB.NET, ASP.NET

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS) and SSDT

Visualization Tools: Power BI and Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

BI Developer/Systems Engineer/Talend Developer

Responsibilities:

• Worked closely wif teh Business Users to halp resolve issues on related to form submissions, data viewing & metrics and report level issues
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Managed Drive application as primary owner.
• Managed Employee System as secondary.
• Converted SSIS code to Talend code as part of migration project.
• Worked on different data sources such as MS SQL, Teradata, Oracle, MySQL, Flat files etc.
• Worked on Database components in like tMSSQLInput, tMSSQLOuput, tOracleOutput.
• Used different components in Talend like Database Lookup & Join, generate rows, Calculator Java Script, add constant, add Sequence, tmap, tmssqlinput, tmssqloutput, tFileInputDelimited, tFileOutputdelimited, tUniqueRow, tLogcatcher, tFileList, tAggregate, tSort, tFilterRow/Coumn and tCacheInput, tCacheOutput and tUnite
• Used Context variables and Context Groups for passing teh values dynamically during runtime and running teh job in different environments like Dev, QA or Prod.
• Used tJava for overwriting teh context values.
• Used tmap for joining multiple datasets and transformations in Talend.
• Used Orchestration components like tPreJob, tPostJob, tParallelize, tReplicate and tSleep.
• Used components like tDie, tLogCatcher and tLogRow for error handling and logging.
• Developed SSIS packages as part of new projects or Enhancements.
• Made Code changes to SSIS packages to fix bugs and make performance improvement.
• Created documents related to ETL design, changes, and support.
• Created job schedules for teh packages developed.
• Developed reconciliation process between source and target and scheduled a report to send alert on discrepancy.
• Wrote stored procedures and User Define Functions to be used in teh SSIS packages and SQL scripts.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.

Environment: Talend Open Studio 7.0.1, SQL server 2008/2008R2/2012/2016 on Windows 2003/2007/2008/2010 server, Visual Studio, SSIS, SSAS, SSRS, BIDS, SSDT and SSMS.

Confidential, GA

MSBI/Talend Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Worked on preparing ETL and Cube design documents.
• Implemented unit test plan for teh code development and testing.
• Collaborate wif teh team and users and work towards a right solution for a problem.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Created and maintained logins, roles and permissions on teh SQL instances and databases and provided required privileges as per teh user’s requirements.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created Clustered indexes and Non-Clustered indexes and optimized queries using execution plan.
• Extensively worked on tuning teh queries to optimize performance.
• Correct and patch bugs in teh existing code/process in T-SQL, SSIS, SSRS and SSAS.
• Created Scheduled and Maintained Sql Agent Jobs related to data load and cube process jobs.
• Designed SSIS packages to transfer data across different platforms, validate data during transferring and archived data files for different RDBMS.
• Extensively worked wif SSIS tool suite, designed, and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Worked on migrating SSIS Packages from 2008R2 to 2016.
• Created framework to audit teh SSIS data flow.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Implemented Kimball methodology and extensively worked wif star schema.
• Worked on Talend 7.0 to design jobs to load data from Sql Server to AWS S3 and from S3 to Redshift.
• Worked on designing both Talend Standard and Bigdata jobs.
• Used Job lets for code reusability as part of teh common framework which logs information about teh jobs into tables.
• Extensively used components like tContextload, tMsSqlConnection, tJDBCConfiguration, tS3Configuration, tHDFSconfiguration, tjDBCInput, tDBInput, tFileInputDelimited, tFileOutputDelimited, tCacheoutput, tCacheInput, tMap, tUnite, tUniqueRow, tfiltercolumns, tSqlRow and tRunJob.
• Used Context variables and Context Groups for passing teh values dynamically during runtime.
• Used tJava for overwriting teh context values.
• Used tMap and tSqlRow for joining multiple datasets and transformations in Talend.
• Used Orchestration components like tPreJob, tPostJob, tParallelize, tReplicate and tSleep.
• Used components like tDie, tLogCatcher and tLogRow for error handling and logging.
• Published jobs to Nexus and used teh right version to schedule in TAC.
• Deployed jobs on teh TAC Server as snapshots.
• Used Talend Admin Console to create execution plans and schedule jobs based on teh trigger time.
• Analyzed logs from TAC when their are failures.
• Used Sql Workbench to query data from Amazon S3, Redshift for data analysis.
• Used GitLab for source code and versioning.

Environment: SQL server 2008/2008R2/2012/2016 on Windows 2003/2007/2008/2010 server, Visual Studio, SSIS, SSAS, SSRS, BIDS, SSDT and SSMS, Talend 7.0, PostgreSQL, Sqlworkbench, AWS (EC2, S3, Redshift), Git.

Confidential

SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Worked on preparing ETL and Cube design documents.
• Implemented unit test plan for teh code development and testing.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Created and maintained logins, roles and permissions on teh SQL instances and databases and provided required privileges as per teh user’s requirements.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in teh SSIS packages and SQL scripts.
• Created Clustered indexes and Non-Clustered indexes and optimized queries using execution plan.
• Extensively worked on tuning teh queries to optimize performance.
• Created, Scheduled and Maintained Sql Agent Jobs related to data load and cube process jobs.
• Designed SSIS packages to transfer data across different platforms, validate data during transferring, and archived data files for different RDBMS
• Used various transformations in SSIS to load data from flat files and FTP to teh SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Migrated old data from MS Access and Excel into SQL Server 2008/2012 using SSIS Packages in BIDS/SSDT.
• Created SSIS packages (.dtsx files) using BIDS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed SSIS packages to transfer data across different platforms, validate data during transferring and archived data files for different RDBMS.
• Configuring teh data flow, configuring teh individual data flow elements and Monitoring teh Performance of teh Package.
• Implemented Kimball methodology and extensively worked wif SSAS star schema, Designed/Implemented OLAP Cubes.
• Regular responsibilities for updating, staging, ODS and dimensional databases as well as rebuild teh Dimensions and Cubes in SSAS using different types of processing options.
• Created SSAS Cubes using different facts and dimensions.
• Mapped teh dimensions to measure groups in teh cube.
• Extensively worked on creating perspectives for a business area.
• Created calculated members using MDX and created KPIs for visual analysis.
• Created partitions in SSAS cube to process teh measures incrementally.
• Fixed teh issues in teh existing cubes and worked on optimizing teh performance in teh cube.
• Deployed SSAS cube on to analysis services server and scheduled it to process from SSIS packages.
• Extensively worked on creating and deploying SSRS reports using Report Designer.
• Extensively worked wif SSRS report templates, shared data sources and shared datasets for code reusability.
• Created parameterized SSRS reports wif drill down and drill through capabilities.
• Worked wif SSRS tabular, matrix and Sub Reports, Cached Reports, Snapshot Reports other report types.
• Worked on improving teh performance of SSRS reports.
• Worked on creating SSRS reports connecting to SSAS Cubes.
• Developed MDX code and procedures for SSRS reports data.
• Managed permissions and subscriptions on Report server.
• Deployed SSRS reports on to Report server and managed reports folders from SSRS Report Server Manager.
• Creates SSAS cube using different types of facts and dimensions.

Environment: SQL server 2005/2008/2008 R2/2012 on Windows 2003/2007 server, .Net using C#, Visual Studio, SSIS, SSAS, SSRS, BIDS, SSDT and SSMS.

Confidential

SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Worked on preparing ETL and Cube design documents.
• Implemented unit test plan for teh code development and testing.
• Gather requirements from teh business users regarding SSRS Reports and Cube development
• Extensively used T-SQL to create stored procedures and functions maintained them.
• Extensively used Joins wif Views, Temp Tables and CTEs to simplify complex queries involving multiple tables.
• Worked on debugging teh T-Sql Code, SSIS and SSRS reports.
• Created Clustered indexes and Non-Clustered indexes and optimized queries using execution plan.
• Extensively worked on tuning teh queries to optimize performance.
• Created, Scheduled and Maintained Sql Agent Jobs related to data load and cube process jobs.
• Designed SSIS packages to transfer data across different platforms, validate data during transferring, and archived data files for different RDBMS
• Used various transformations in SSIS to load data from flat files using FTP to teh SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Migrated 2005 versions of SSIS into SQL Server 2008R2 using SSIS Packages in BIDS.
• Created SSIS packages (.dtsx files) using BIDS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed SSIS packages to transfer data across different platforms, validate data during transferring and archived data files for different RDBMS.
• Worked on implementing SSIS frame work for code reusability.
• Implemented Kimball methodology and extensively worked wif SSAS star schema, Designed/Implemented OLAP Cubes.
• Regular responsibilities for updating, staging and dimensional databases as well as rebuild teh Dimensions and Cubes in SSAS
• Created SSAS Cubes using different facts and dimensions.
• Mapped teh dimensions to measure groups in teh cube.
• Extensively used Role Playing Dimension and Degenerate Dimension in SSAS cubes
• Extensively worked on creating perspectives for a business area or purpose.
• Created partitions in SSAS cube to process teh measures incrementally.
• Fixed teh issues in teh existing cubes and worked on optimizing teh performance in teh cube.
• Deployed SSAS cube on to analysis services server and scheduled it to process from SSIS packages.
• Extensively worked on creating and deploying SSRS reports using Report Designer.
• Created parameterized SSRS reports wif drill down and drill through capabilities.
• Worked wif SSRS tabular, matrix and Sub Reports, Cached Reports, Snapshot Reports other report types.
• Worked on improving teh performance of SSRS reports.
• Worked on creating SSRS reports connecting to SSAS Cubes.
• Developed MDX code and procedures for SSRS reports data.
• Managed Security and subscriptions on Report server.
• Deployed SSRS reports on to Report server and managed reports folders from SSRS Report Server Manager.

Environment: SQL server 2005/2008/2008 R2 on Windows 2003/2007 server, .Net using C#, Visual Studio, SSIS, SSAS, SSRS, BIDS and SSMS.