Ms Sql/ Ssis /ssrs Developer Resume
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