We provide IT Staff Augmentation Services!

Bi Developer/systems Engineer/talend Developer Resume

Alpharetta, GA

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.

Hire Now