ETL Developer Resume

SUMMARY

Extensive experience in Database Designing, Development and Supporting Application with over 15 + years of experience by using various Microsoft technologies (SQL Server 2005/2008/2012 , SSRS, SSIS, SSAS and .NET Core) in both Production and Non - Production environments.
Creating configuration files to deploy the SSIS packages across all environments
Implementing IT development environments (DEV, QA, NplusOne, Stage and Production) for SQL Server and .Net Core
Generating, writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources
Installing and configuring reporting services and assigning permissions to different levels of users in SSRS

TECHNICAL SKILLS

SQL Server, SSRS, SSIS and .NET Core2.1, Azure DevOps, MVVM, Entity Framework, Angular, UI/UX
C# /ASP.NET, ADO.NET, Oracles dll’s, PL/SQL Plus, TOAD, Oracle Designer, OOP, DAO, ACTIVE X, XML
Microservices, cloud repository and source code, API, XSLT, JavaScript, jQuery, Python, T-SQL, Web Services
SOA and WCF, WPF, MVC, Avalon 3.0, PHP and VB.Net, OsCommerce Ecommerce shopping cart utilizing Joomla and MySQL

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

Maintain integrated data from multiple external sources such as SalesForce and Five9, into data structures that can be easily consumed for various reporting
Developed an SSIS upload package template to streamline the generation of scheduled daily uploads into the data warehouse utilizing SSIS packages to perform the uploads from .csv files into the SQL server, SQL stored procedures to transform the uploaded data before adding it to the data warehouse, Command line scripts to execute the SSIS packages and SQL agent jobs to execute the command line scripts
Provide ongoing support and monitoring of the daily Lacuna Data Warehouse process to address any performance and/or data integrity issues.
Provide analysis and advice when new data structures are needed for reporting. Collaborate with the report writing team to devise the best approach for obtaining and storing the necessary data
Primary point of contact for support of all data issues encountering in the Lacuna reporting environment.
Adapts and conforms database to meet internal system requirements.

Confidential

Sr. Consultant

Responsibilities:

Implementing IT development environments (DEV, QA, NplusOne, Stage and Production) for SQL Server and .Net Core 2.1
Creating various SSRS reports for BOM
Interacting with engineering department to determine requirements on the front end of the application to make the Database more readily accessible w/ Agile Sprints
Preparing sample code and applications for displaying various outcomes with API for Autodesk Vault
Design, code and implement enterprise application to assist engineers to upload excel files via Web UI/UX

Confidential

Sr. Consultant

Responsibilities:

Worked as Tech Lead for several project implementations and modify applications for transient insight
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008)
Responsible for creating SQL stored procedures for backend services
Initiated, lead and implemented software solutions for applications within Confidential ’s core architecture (MVC3, XSLT, JavaScript, Microservices and Entity Framework)
Prepared sample code and applications for displaying various outcomes of API applications for offshore development & training
Developed scalable modular software packages for various APIs and applications
Supported customers in optimization and improvement of existing features of current API applications
Resolved technical problems relating to API application by identification of and fixing bugs