We provide IT Staff Augmentation Services!

Etl/reporting Developer Resume

SUMMARY:

  • 3 + years of working experience in software design, development, and coordination.
  • Experience in Database development in MS SQL Server 2008/2012/2014 .
  • Strong experience in creating database objects and writing complex queries on MS SQL Server
  • Extensive experience in Microsoft Business Intelligence and ETL technologies such as SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Experience in importing/exporting data between different sources like SQL Server, Access, Flat files, Excel etc. using SSIS.
  • Expert in creating, configuring and fine - tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
  • Used most of the transformations in the data flow task using SSIS.
  • Experience in developing SSIS Packages to Extract, Transform and Load (ETL) data into the data warehouse.
  • Worked independently as part of a team for creating database objects in SQL server for new development projects for enhancements.
  • Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
  • Expert in creating and deploying SSRS reports on the portal for user accessibility.
  • Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
  • Exposure to development of scripts using Unix shell scripting.
  • Worked in building the ETL process using stored procedures and UNIX shell scripts through scheduled batch process.
  • Extensive experience in designing the Data models for OLTP & OLAP database system.
  • Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling.
  • Knowledge in designing reports using Power BI and Tableau through training.
  • Exposure to all types of transformations that are available in Power BI query editor.
  • Knowledge in Utilizing Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Knowledge in creating and developing Power BI reports and dashboards with data sources like SQL Server, Excel, CSV files, oracle and other services.
  • Knowledge in using Table, Matrix, Bar, Card, Gauge, Slicers visualizations and custom Visualizations like multi slicer and Hierarchy slicer.
  • Good knowledge on DAX expressions like filters, Aggregate, Mathematical Functions etc.
  • Knowledge in creating calculated columns and measures using DAX Expression.
  • Comfortable in working with filters, relationships and transformations of Edit Query section.
  • Knowledge in using Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Experience in Object oriented analysis, design/development methodologies.
  • Strong skills in creation of shell scripts for reporting and file transfer.
  • Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
  • Good ability to quickly grasp and master new concepts and technologies.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Good experience in project flow design and preparation of Detailed Technical Design document and Technical Specification Document.
  • Managed multiple tasks simultaneously with the ability to appropriately prioritize tasks as needed.
  • Excellent verbal/written communication, interpersonal, analytic skills and strong ability to perform as part of a team.
  • Self-starter and self-organizer and the ability to work in a high pressure fast paced environment

TECHNICAL SKILLS:

Tools /Methods: MS SQL Server Integration Services (SSIS), MS SQL Server Report Services (SSRS), SQL Server Management Studio (SSMS), Power BI, Tableau, Microsoft Excel

DB and Languages: MS SQL Server 2008/2012/2014, TSQL

Scripting Tools: UNIX Shell Scripting

Operating Systems: Windows, Unix

Other Skills: HTML, CSS, Microsoft Office tools, MS Access, notepad++, Data-modeling, Requirement Documentation, Technical Design Preparation, Project Design, Development, Testing, Implementation, Project Planning and Estimation

PROFESSIONAL EXPERIENCE:

ETL/Reporting Developer

Confidential

Responsibilities:

  • Worked in multiple projects for the team in design, creation and loading of new database models and enhancement of the internal applications in SQL Server.
  • Designed and implemented the dimensional model, SSIS package configuration and ETL for the project in SQL Server 2008 and 2012.
  • Collected the business requirements from business team and prepared the requirement document coordinating with them.
  • Analyzed the requirements and converted them to the technical design document.
  • Worked on the normalization and de-normalization of data models to optimize the performance of reconciliation and reporting logics.
  • Worked on the enhancement projects, analyzed and fixed the existing issues with the application in ETL and SQL jobs calling SSIS packages.
  • Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
  • Data Loaded in SQL Server 2008 using SSIS ETL and developed different packages in SSIS for the task.
  • Analyzed the data requirement and created the database models in SQL Server.
  • Developed SSIS packages to implement ETL involving multiple databases, data files, complex transforms, file transfers and control flows.
  • Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Worked in Design, Development, Testing and Implementation of Data Models and ETL process.
  • Worked on the development requests for the Allocation - Reporting - Reconciliation applications.
  • Created project specification, design and testing documentations and worked in database and process enhancement projects.
  • Created database objects - Tables, Procedures, Functions, Triggers in SQL server as part of the project enhancements.
  • Developed TSQL procedures and functions involving complex algorithms to create reports and generate data files for the downstream systems.
  • Created SQL queries for the user requirements and helped the business teams when they needed urgent data from the central database.
  • Designed, created and deployed SSIS packages for the ETL enhancements.
  • Designed and developed multiple reports in SSRS and configured the schedules and delivery based on the requirement.
  • Worked closely with the business team in gathering the requirements for developing the reports
  • Coordinated with the application teams, vendor teams and support teams to fix the existing application issues and to enhance the functionalities.
  • Within the short period, learned the application systems and worked in multiple enhancements and automation projects.

ETL Tools: MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS)

Technologies: SQL Server 2008/2012, TSQL, Data Modeling

Tools: Visual Studio 2008/2012, MS Access, MS Excel, MS Office tools, SQL Server Management Studio (SSMS)

SQL Developer

Confidential

Responsibilities:

  • Worked as part of the Database team and involved in the database and ETL Development tasks.
  • Developed various database components and SQL Queries on SQL Server for the reporting requirements.
  • Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors, Triggers etc. in coordination with the application development team.
  • Designed and implemented ETL process and ETL enhancements for reporting projects for the client.
  • Designed and developed SSIS packages for loading data from Source databases to Data Warehouse in SQL Server.
  • Loaded data in Dimension Tables in SQL Server using SSIS Packages.
  • Extensively used most of the SSIS transformations for the ETL process of new projects and enhancement of the existing projects.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created SSIS Packages using SSIS Designer for export data from OLE DB Source, Flat files, Excel Spreadsheet to SQL Server 2008.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Created Data Models from data sources and defined the dimensions, levels and measures in the model.
  • Worked in Unix environments and involved in modifying some of the legacy system reports in Unix.
  • Implemented client reports using the scheduled UNIX jobs coded in shell scripts and SQL stored procedures.
  • Created reports from Data Warehouse using SQL Server Reporting Services (SSRS).
  • Created complex stored procedures to generate reports using SSRS.
  • Analyzed the business requirements and created the detailed technical requirements documents based on that.
  • Debugged and fixed the issues in existing application components.
  • Provided extensive pre-delivery support for bug fixing.
  • Production support tasks including handling the user requests and bug fixes for the applications.
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Tuned complex Stored Procedures for faster execution and Developed database structures as per the requirements.

ETL Tools: SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS)

Technologies: MS SQL Server 2005/2008, T-SQL, UNIX shell scripting, Data Modelling

Tools: SQL Server Management Studio (SSMS), Visual Studio, MS Office Tools, MS Excel

SQL Developer

Confidential

Responsibilities:

  • Involved in Design, Development, and Testing and Support phases of Software Development Life Cycle (SDLC).
  • Joining as a programmer trainee got trained in Database development with SQL/TSQL, ETL/BI tools -SSIS, SSRS and UNIX shell scripting.
  • Worked in development projects and involved in Requirements gathering, Requirement analysis, defining scope, Design analysis, impact analysis, Integration and deployment.
  • Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures as part of various projects.
  • Involved in handling the changes in scripts and procedures per the database changes.
  • Developed reports using complex queries for the client requirements and set up the FTP using shell scripts.
  • Coded MS SQL packages and procedures to perform data loading, error handling and logging.
  • Designed and developed transactional and analytical data structures.
  • Debugged and modified software components.
  • Created and modified several UNIX shell scripts as per the changing needs of the project and client requirements.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Databases: MS SQL 2008

Technologies: UNIX shell scripting, TSQL

Tools: SQL Server Management Studio (SSMS), MS Access, MS Excel

Hire Now