We provide IT Staff Augmentation Services!

Ms Sql/ Ssis /ssrs Developer Resume

2.00/5 (Submit Your Rating)

Nashville, TN

SUMMARY

  • Over 6 years experienced professional as MSBI developer in various domains.
  • Experienced in working on MS SQL Server 2012, 2008 R2, 2008, 2005 versions
  • Expert in writing T - SQL queries using Data Definition Language (DDL) and Data Manipulation Language (DML) commands
  • Proficient in creating Tables, Stored Procedures, User Defined Functions, Triggers, Views
  • Proficient in using Tables Joins- Inner, Left, Right, Full Outer Joins and creating highly complex queries.
  • Expert in creating SSIS packages for ETL (Extracting, Transforming and Loading) of data.
  • Experienced in using various types of sources and destinations - OLEDB, Flat File, CSV file, XML files.
  • Proficient to use Tasks in Control Flow - Data flow, Query, Execution, FTP, XML
  • Great skills of using various Transformations- Lookup, Conditional Split, Derived Column, Merge, Merge Join, Fuzzy Look up, Multi Cast, Union, Audit etc.
  • Experienced in Error handling and Event handling using - Break Points, Check Points
  • Knowledge of using Package Configurations and execution packages.
  • Knowledge of deploying SSIS project in Integration Services Catalog, Deploying SSIS package with File System and SQL server
  • Expertise in developing various SSRS reports - Grouped Reports, Multi Grouped Reports, Drill-Down, Multi-Drill Down, Cascading, and Parameterized.
  • Expert in creating Visual Format reports such as Tables, Matrix, and Pie, All kinds of Charts, Maps, and Indicator.
  • Experienced in building OLAP Cubes using SSAS for Star Schema and Snowflake Schema.
  • Strong knowledge of Data Normalizing forms - 3 NF
  • Strong concept knowledge of Relational Database management system (RDBMS).
  • Good Understanding of OLTP and OLAP systems and Data-Ware House, Data art concepts.
  • Great skills in gathering requirements and analyzing them.
  • Experience in understanding Source - Target Data mapping.

TECHNICAL SKILLS

  • MS SQL server versions 2008 R
  • SQL server management studio
  • SSIS
  • SSAS
  • SSRS
  • T-SQL
  • MS Excel
  • MS Word
  • C
  • C++
  • Java
  • Hyper Terminal

PROFESSIONAL EXPERIENCE

Confidential, Nashville TN

MS SQL/ SSIS /SSRS Developer

Responsibilities:

  • Defined source data columns and its respective mapping with target based on discussions with data modeler and application developers.
  • Identified data quality and data cleansing tasks based on review of data and data model.
  • Created stored procedures to insert in target database, views and user defined functions for target databases to be used by ETL jobs.
  • Designed SSIS flow to pull source data into staging to perform data quality and cleansing before pushing into target database using SSIS 2012.
  • Extensive use of SSIS for loading and transferring data like Sequence containers, Query tasks with T-SQL queries and Data flow tasks in Control flow tasks.
  • Applied various transformations in data flow tasks like Conditional split, Lookup, Row count, Merge, Merge join, Union, Audit etc. including unit testing.
  • Loaded transformed data into data warehouse which was having Star-Schema.
  • Worked to build OLAP cubes (Star Schema) using SSAS 2012.
  • Designed and developed parameterized reports, Excel reports with drill-down and multi-drilldown, dashboard reports using SSRS 2012 with data source as SSAS 2012.
  • Scheduled monthly, weekly, and daily reports to run automatically on dashboard.
  • Maintained traceability matrix and participated in providing demos to business for feedback.
  • Implemented exception handling using event handlers in SSIS 2012 and identified critical exceptions to be notified and logged in database.

Environment: SQL server 2012, Visual Studio 2010 shell for SSIS, SSRS and SSAS, SQL server management studio

Confidential, Charlotte NC

MS SQL/ SSIS /SSRS Developer

Responsibilities:

  • Gathered requirements and designed teh data sourcing and data flows.
  • Developed SSIS packages to extract data from different sources like OLTP databases, Excel files, Flat files, from FTP servers about Confidential ’s usage data.
  • Applied various SSIS transformations like look-up, conditional-split, derived column data conversion extensively.
  • Loaded transformed data into OLAP system which contains analytical data for creating reports.
  • Involved in configuration and deploying packages or projects to catalog.
  • Wrote T-SQL queries, common table expressions, Store Procedures and used them to build packages
  • Created help manual for support team to take appropriate action for any critical exceptions affecting SLA.
  • Created and Deployed OLAP cubes using fact and dimension tables with star schema using SSAS 2012.
  • Generated various report presentations according to business needs which include Tabular, Matrix, Drilldown, Multi drilldown, Parameterized, Cascading Parameterized Chart reports using SSRS 2012.
  • Deployed and published SSRS reports on report server for business users as per teh requirement.
  • Participated in defect resolution discussion with testers to analyze teh defect and provided resolution for teh same.

Environment: MS SQL server 2012, Visual Studio 2010 shell for SSIS, SSRS and SSAS, SQL server management studio

Confidential, Charlotte NC

MS SQL/ SSIS /SSRS Developer

Responsibilities:

  • Worked with project lead to understand data sourcing and created Source to staging and staging to Target mapping document.
  • Developed and validated SSIS package to load data in data warehouse using SSIS 2008 R2.
  • Involved in configuring monitoring for various ETL jobs and providing help document for support team to take action.
  • Worked on various tasks such as Execute SQL task, Bulk insert task, Data flow task, FTP task in Control flow.
  • Used various transformations in Data flow task such as Data conversion, Conditional split, Derived Column, Row count, Lookup/ Fuzzy Lookup.
  • Utilized Package Configurations and Event handlers in SSIS to make a package more portable and to handle errors in package.
  • Generated various dashboard reports for ease of business users.
  • Created Drill Down, Multi-Drill down, cascaded parameterized, Chart reports with attractive and simplified design.
  • Designed ad-hoc and custom reports for high level management.

Environment: SQL server 2008/ 2008r2, Visual Studio for SSIS, SSRS and SSAS, SQL server management studio

Confidential, Charlotte NC

MS SQL / SSIS Developer

Responsibilities:

  • Worked with project lead and HealthCare system users to understand basic HealthCare EDI standard and terminology.
  • Involved in implementation of package which was designed for parsing data using SSIS 2008R2.
  • Used XML task to apply operations on source XML file, merge multiple XML files and save and validate them.
  • Used Merge transform, Derived column transform, Lookup transform with teh use of various string functions.
  • Implemented extensively SSIS tasks like for each loop, sequence container in control tasks and Audit transform for metadata logging purpose.
  • Parsing teh EDI data based on knowledge bank and loaded it appropriately in data warehouse.
  • Worked on preparing documentation to capture EDI field’s definition and format.
  • Was involved in preparing release document for team to deploy in various lower environments.

Environment: SQL server 2008/ 2008r2, Visual Studio for SSIS, SSRS and SSAS, SQL server management studio

Confidential, Mooresville, NC

MS SQL Developer

Responsibilities:

  • Studied business requirements, processes and translated into functional specifications.
  • Developed various documents for data flow and data model as per teh discussion with project lead.
  • Was involved in creating various documentation of data mapping documents for Data Source to Target.
  • Created stored procedures with output parameters and return values and tested by executing procedures using various test cases.
  • Created scalar valued and table valued user defined functions to perform various aggregation operations for numeric data.
  • Used CTE function of SQL extensively to write queries for retrieving important data.
  • Created simple ETL package for aggregating teh Sales order values using conditional split, sort, row count transform using SSIS 2008.
  • Created simple tabular, drill down, multi-drill down reports using SSRS 2008 for Sales department.

Environment: SQL server 2008/2005, Visual Studio for SSIS, SSRS and SSAS, SQL server management studio

We'd love your feedback!