We provide IT Staff Augmentation Services!

Etl Developer Resume

Harrisburg, PA

SUMMARY

  • Almost 9 years of strong experience in the IT industry as a SQL Server Developer with sound business analysis skills.
  • Extensive SQL Development experience in Banking, Insurance and Healthcare industries with a strong understanding of data and analytics.
  • Knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Joins, Keys, Indexes, Views, Dynamic SQL, Triggers and Cursors.
  • Have experience in design and development of Business Intelligence tools like SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Developed SSIS packages for Extraction, Transformation and Loading (ETL) operations using various tools like Bulk Insert (BCP), Import/Export data and SQL Server Integration Services.
  • Proficient in T - SQL for developing Stored Procedures, Triggers, Tables, User Defined Functions, SQL Joins, Views, Indexes.
  • Have experience in creating and deploying SSIS packages in production and testing environments.
  • Proficient in SSIS data transformation tasks like Conditional Splits, Aggregate, Derived Column, Event Handlers, Look-ups, and Error Handlers etc.
  • Have experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
  • Created different types of reports like Tabular reports, Matrix reports, Drill-down Reports, Drill-through Reports, Ad-hoc Reports, Charts/Graphs and also had strong ability in defining queries for generating above reports using parameters and cascading parameters.
  • Expertise in defining data source, creating data sets by query designer, creating sub-reports, formatting report layout, sorting the data, subtotals for the reports using expressions and can perform arithmetic, logical operations on data by using expressions.
  • Proficient in debugging stored procedures, SSIS packages, coding issues and troubleshoot data/logical bug.
  • Excellent written and oral communication skills and can work in a team environment as well as independently.
  • Good in understanding business requirements in banking, insurance and health care domains.

TECHNICAL SKILLS

Operating Systems: Windows 8/ 7/Vista/XP/2000, LINUX, Macintosh.

Languages: TSQL, PL/SQL, VB.NET, C#.NET, ASP.NET, HTML.

Tools: and Packages: SSMS 2012/2008/2005 , SQL, Server Business Intelligence Development Studio (BIDS), Tableau, MS Office 10/07/03, Visual Source Team Foundation.

Designing Tools: MS Visual Studio 2013.

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS).

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

ETL Developer

Responsibilities:

  • Involved in all phases of SDLC, and gathered business requirements from business people.
  • Expert in designing reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts.
  • Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
  • Developed SSIS Packages to import and export data from MS Excel, SQLServer 2008 and Flat files.
  • Creating Tables, Indexes, Constraints, Views.
  • Expert in defining data source and building data source views and recognizing fact and dimension tables.
  • Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
  • Developed Tabular, drill down, drill through, sub-reports, and navigation reports (Hyperlink) using SSRS.
  • Created Parameterized Reports, Cascaded Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
  • Used TFS extensively for bug tracking, new requests and checking the code.
  • Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: SQL Server 2012, T-SQL, SSIS, SSRS, Windows 7, SSAS.

Confidential, Lancaster, PA

SQL Developer

Responsibilities:

  • Experienced in writing complex SQLQueries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQLServer 2008 and Flat files.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Responsible for creating complex reports like Drill down and Sub reports.
  • Created Tabular, List, Matrix, Charts, and Ad-hoc reports using SSRS.
  • Deployed SSIS packages and Reports to Production Servers.
  • Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.

Environment: MS SQL Server 2008, SSRS, SSIS, MS Excel, MS Access.

Confidential, Harrisburg, PA

SSRS Developer

Responsibilities:

  • Involved in all phases of SDLC, and gathered business requirements from business people.
  • Participate in design discussions to make the decisions to drive the project in the environment that is always changing.
  • Understanding the COGNOS report and Creating Reports using SSRS according to the given specifications.
  • Writing queries to pull the required data for the reports.
  • Creating Stored Procedures required for the same. Created complex reports like Drill-down, Cross-tab reports.
  • Deployed SSRS reports to Reporting Server URL.
  • Created Subscriptions to send the reports to a group of people every day through Email.
  • Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
  • Developed Tabular, drill down, drill through, sub-reports, and navigation reports (Hyperlink) using SSRS.
  • Created Parameterized Reports, Cascaded Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Resolvedandclosedthe production tickets generated due to failure of daily incremental production jobs and provided on call support for production issues.

Environment: SQL Server 2008 R2, MS Visual Studio 2010, Windows 7, COGNOS 10.2, MS Excel.

Confidential, Danville, PA

SQL Developer

Responsibilities:

  • Involved in client meetings to understand the business need behind the TSQL queries.
  • Participate in design discussions to make the decisions to drive the project in the environment that is always changing.
  • Preparing the technical design document for the migration of the TSQL code to SSIS ETL.
  • Implemented the migration of the TSQL code to SSIS ETL.
  • Involved in analyzing long running SQL queries to improve the performance.
  • Involved in optimizing the SQL queries to reduce data and code redundancy.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS features like data conversion etc. Created derived columns from the present columns for the given requirements.
  • Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
  • Developed reports using SSRS and utilizing complex SQL queries and stored procedures.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Developed functional and technical specifications documents such as the Business Scope Documentand High Level Design Document.

Environment: SQL Server 2012, T-SQL, MS SQL Server 2012, SSIS, SSRS, Windows 7, Windows Performance monitor.

Confidential, Valley Forge, PA

SQL Server Developer

Responsibilities:

  • Actively involved in different stages of Project Life Cycle, documented the data flow and the relationships between various entities.
  • Actively participated in gathering of user requirement and system specification.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008.
  • Created Clustered and Non-Clustered Indexes for improved performance.
  • SSIS Packages using Derived Columns, Condition Split, Term extraction, Aggregate, ExecuteSQLTask, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Created Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL.
  • Scheduled automatic generation of reports, report snapshots. Also implemented caching of reports and stored them in a shared drive.
  • Involved in developing and deployed Reports from OLAP in SSRS with Charts and PIE Diagrams
  • Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: SQL Server 2008, T-SQL, MS SQL Server 2008, SSIS, SSRS, SSAS, HTML, Windows 7, Windows Performance Monitor.

Confidential, Iselin, NJ

SQL Server Developer

Responsibilities:

  • Experienced in writing complex SQLQueries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQLServer 2008 and Flat files.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Generated database monitoring and data validation reports in SSRS.
  • Created report models using Report Builder and managed reports using Report Manager.
  • Responsible for creating complex reports like Drill down and Sub reports.
  • Created ad-hoc queries from SQL Server databases for custom reporting needs.
  • Created Tabular, List, Matrix, Charts, and Ad-hoc reports using SSRS.
  • Deployed SSIS packages and Reports to Production Servers.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS.

Confidential

MS SQL Server Developer

Responsibilities:

  • Developed physical data models and created DDL scripts to create database schema and database objects.
  • Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
  • Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
  • Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time.
  • Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
  • Created highly complex SSIS packages using various Data transformations like conditional splitting, For Each Loop, Multi Cast, and Error Handling.
  • Creation/Maintenance of Indexes for fast and efficient reporting process.
  • Developed SQL Scripts to Insert/Update/Delete data, satisfying the referential integrity constraints.
  • Involved in Data Migration and used SSIS to import and export data into tables using SQL Server 2005, creating tables, views and Stored Procedures using SQL Server.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Created reports using Global Variables, Expressions and Functions using SSRS.
  • Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.

Environment: MS SQL Server 2005, MS Access, T-SQL, Stored Procedures, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), DTS, SQL Server Query Analyzer, SQL Profiler, MS Office.

Hire Now