We provide IT Staff Augmentation Services!

Etl Lead Resume

Chicago, IL

SUMMARY:

  • IT Professional with 11+ years of experience in SQL Server Technology as a SQL / SSIS / SSRS / Power BI Developer and hold wide experience in design, development and maintenance of applications supported in SQL Server.
  • Experience in developing application using SQL Server as a SQL Developer in SQL 2005/2008/2012/2014 , SSIS, SSRS and PowerBI
  • Experience in all phases of software development life cycle
  • Expertise in Object Oriented Programming
  • Experience in using T - SQL in SQL Server 2005, 2008, 2012 and 2014
  • Experienced in creating Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency
  • Good in T-SQL programming skills, with experience in Query optimization and performance tuning. Used SQL Profiler, Index Tuning Wizard and Execution Plan
  • Actively engaged in design discussions for all Business Intelligence and database initiatives.
  • Experience in Extracting, Transforming and Loading (ETL) data from Flat File, Excel, Raw File, XML and any OLE BB Data Source to Excel, Flat File, Raw File, any OLE DB or MS SQL Server Destinations by using BCP utility and SSIS services.
  • Experience in developing Reliable Packages by implementing Logging, Error Handling, Transactions and Checkpoints
  • Expertized in creating parent and child packages, package configurations, Error Handling and Logging
  • Experience in Power BI Reporting services using MS SQL server and in supporting DAX technology of the analysis services.
  • Utilized Power BI to create various analytical dashboards that depicts critical KPI’s as such as billing hours and case proceedings along with slicers for end users.
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending
  • Experience scheduling, deployment of the reports and uploading files to a report server catalog from the report manger.
  • Worked with Microsoft Power BI, DAX expressions and Power View
  • Having Knowledge on SQL Azure, Azure Data warehouse
  • Experience in Migrating SQL Server databases from SQL Server 2005 - 2014.
  • Experience working on Production Server including weekends
  • Experience in providing 24x7 support.
  • Experience in project management tools like TFS, Clear case and VSS.
  • Batch process in UNIX and PERL.

TECHNICAL SKILLS:

RDBMS: : MS SQL Server 2005/2008/2012/2014 , MS Access

SQL Server Tools: : SQL Server Management Studio (SSMS), Enterprise Manager, Query Analyzer, SQL Server BIDS, SQL Profiler

ETL Tool: : SQL Server Integration Service (SSIS)

Reporting Tool: : SQL Server Reporting Service (SSRS)

Programming Languages: : Power Builder 9.0, 11.5, Core Java

Web Programming: : HTML, CSS, JavaScript, ASP

Web Services: : IIS6.0, IIS 7.0

Source Control: : Rational Clear Case, Microsoft VSS

Operating Systems: : Windows 9x/2000/XP, UNIX

Job Scheduling: : Active Batch

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Lead

Responsibilities:

  • Collaborate with Software engineering resources to deliver high quality deployments that meet department and customer expectations for quality and schedule.
  • Experience developing complex SSIS packages using SQL Server Integration Services 2016
  • Ability to create advanced SQL Queries with CTE, SQL database scripts, VB.net scripts and stored procedures in support of ETL development
  • Analyze and create complex SQL Queries, database scripts, stored procedures, triggers etc. as well as troubleshooting and optimizing.
  • Proficiency developing solutions following an Agile methodology using Microsoft technologies and platforms including .NET/C#, Visual Studio, Visual Studio Team Services (or Team Foundation Server)
  • Analyze and create SSIS / SSRS as needed to support new and evolving data integration projects and data extracts
  • Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
  • Experience conducting Unit Testing and performing QA functions for the ETL components
  • Analysis of technical specifications for ETL requirements
  • Knowledge of installation, configuration, and administration of SSIS and Visual Studio based ETL tools.
  • Participation in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications
  • Ensure that the ETL requirements are adequately understood and documented
  • Design the ETL application architecture based on the documented requirements
  • Perform QA functions for the ETL application, including ensuring that system and integration test plans are developed and executed
  • Created job scheduling dependency document and scheduled around 300 jobs in Active Batch
  • Developed Power BI reports and dashboards from multiple data sources using data blending.
  • Building Power BI reports using different visualizations available such as Table, Matrix, Pie, Bar, Map, etc.
  • Explored data in variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.
  • Adding different level of filters such as Visual, Page and Report to the report as per user requirements in Power BI and scheduled automatic refreshing after deploying reports in Power BI Report server.
  • Clearly communicate technical data to Business team.

Environment: SQL Server 2016, SSIS, SSRS, Power BI Desktop, Power BI Report server, SQL Profiler, XML, TFS, C#.Net

Confidential, Los Angeles, CA

Tech Lead - SSIS Developer

Responsibilities:

  • T-SQL programming for writing Stored Procedures, User-Defined Functions, Triggers, Cursors, Views.
  • Created and developed tables, views, indexes, functions and advanced queries for databases by using SQL Server Management Studio / Query Analyzer.
  • Developed, modified and optimized complex queries to data retrieval and modification
  • Creation and Execution of SSIS and BCP utilities for Graduation Progress modules
  • Performed Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS and BCP)
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Used SSIS custom component as required.
  • Developed Reliable Packages by implementing Logging, Error Handling, Transactions and Checkpoints.
  • Enhanced Auditing processes using Audit control.
  • Monitored and Optimized SSIS package performance to reach the expected timeframe for data loading
  • Created on demand ad-hoc heterogeneous data fixes via BIDS - SSIS.
  • Proficient in implementing all transformations available on the SSIS toolbox.
  • Creating Jobs, scheduling & running jobs and troubleshooting the failed jobs.
  • Expertise in Monitoring and troubleshooting the failed SSIS packages or not performing packages.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Attendance Reports including status.
  • Created Graduation in Progress and IGP Reports in SSRS
  • Provided extensive support during school events
  • Automated Grad Data and CCS Data Process
  • Developed integration of Power BI reports into PowerApps and interacting the data by visuals through PowerApps and modifying the existing records in real time accordingly.
  • Created Workspace and Apps in Power BI and giving access to end users to Apps.
  • Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
  • Wrote complex Measures in Power BI depending on the requirement using DAX queries.
  • Experience in Custom Visuals and Groups Creation in Power BI.

Environment: SQL Server 2014, SSIS, SSRS, SQL Profiler, XML, IIS, TFS, C# and ASP.Net

Confidential, Miamisburg OH

Tech Lead - SSIS Developer

Responsibilities:

  • As part of data migration activity created a SSIS package to export Knowledge data into txt file format from SQL Server
  • Created a package to export Admin data to txt file from SQL Server
  • Created SSIS package to export articles to tech writers to update the content to provide extensive support to customers
  • Migrated customer and call data from SQL 2005 to SQL 2014
  • Actively involved in data extraction and validation during Data Migration phase of the project
  • Closely worked with Business team to capture the rules to export articles

Confidential, Miamisburg OH

Tech Lead - SQL Developer

Environment: MS SQL Server 2005, SSIS, PB11.5, PERL, UNIX, TFS

Responsibilities:

  • Created SSIS packages to extract data from Confidential acquired products (Redwood, Travelers and BAC) to Spectrum
  • Data extracted from various sources like XLS, .SQL Server, Sybase
  • Created table, views to store customer and subscription information from product system
  • T-SQL programming for writing Stored Procedures, User-Defined Functions, Triggers, Cursors.
  • Developed, modified and optimized complex queries to data retrieval and modification
  • Created and scheduled batch jobs
  • Developed Daily Call report, CSRs call history report in SSRS
  • Involved in analysis, design, development, testing and maintenance of the system.
  • Worked at the client location, involved in the UAT Build, Configuration, Deployment, Integration, Release and Maintenance.
  • Developed an automation scripts in SQL to perform Data synch up from source system.
  • Delivered Application Health check in VB script as a Business value add.

Environment: MS SQL Server 2005, SSIS, SSRS, Power Builder11.5, TFS, Clear case, Unix and Perl

Confidential, Miamisburg OH

Tech Lead - SQL Developer, PB Developer

Responsibilities:

  • Migrated PRISM from PB9.0 to PB11.5
  • In a MDI application developed Configuration Editor and Text Editor Modules.
  • Involved in gathering and documenting the requirements
  • Involved in design, development and maintenance of the system
  • Reviewed and approved all engineering, product and project scope documents prior to delivery.
  • Created Tables, Triggers and Stored Procedures used to create and configure the Attributes and Parameters from PRISM for Spectrum
  • Created dynamic data windows to map Attributes and Parameters for Confidential product.
  • Developed SSIS job to send customer call data in text format to BI System.
  • Worked at the client location, involved in the UAT Build, Configuration, Deployment, Integration, Release and Maintenance.

Environment: MS SQL Server 2005, SSIS, Power Builder11.5, TFS, Clear case, Unix and Perl

Confidential

Software engineer - SQL Programmer

Responsibilities:

  • Involved in Requirement gathering
  • Analysis of Design Document and Requirements document
  • T-SQL programming for writing Stored Procedures, User-Defined Functions, Triggers, Cursors, Views
  • Created and developed tables, views, indexes, functions and advanced queries for databases by using SQL Server Management Studio / Query Analyzer
  • Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
  • Participates in Disaster Recovery exercises
  • Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
  • Experience in creating Jobs, Alerts and Scheduling DTS/SSIS Packages.
  • Data Migration from Flat files, CSV, MS-Access, Excel and OLE DB to SQL Database
  • Participated in implementation and support of the application
  • Convert data from Legacy system to SQL Database
  • Using SSIS, loaded XML data to the Database tables
  • Coordinating with the testing team and provided the support.
  • Monitored Performance with SQL Profiler.
  • Database Designing/Modeling of new applications

Environment: MS SQL Server 2005, SSIS, Power Builder11.5, TFS, Clear case, Unix and Perl

Confidential

Software engineer - SQL Programmer

Responsibilities:

  • Involved in Requirement gathering
  • Analysis of Design Document and Requirements document
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
  • Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
  • Participates in Disaster Recovery exercises
  • Experience in creating Jobs, Alerts and Scheduling DTS/SSIS Packages.
  • Coordinating with the testing team and provided the support.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Monitored Performance with SQL Profiler.
  • Database Designing/Modeling of new applications
  • Created Stored procedures, Triggers to process the events and subscription details
  • Developed two modules (Admin tool and Testing tool) in MDI application in PowerBuilder and SQL to process the events and codes from front end
  • Submitted SQL best practices and Coding standards document.
  • Created Nightly jobs to pass the events to BI for data warehousing

Hire Now