We provide IT Staff Augmentation Services!

Ms Sql Server/ssis/ssrs Developer Resume

Minneapolis, MN

SUMMARY:

  • Over 8 years of experience in Data Integration, Report Development and Analysis Services using Microsoft SQL Server Integration, Analysis and reporting tools (SSIS, SSAS and SSRS).
  • Experience in design, development and maintenance of various BI/Data Integration Projects in various financial domains.
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from various sources such as flat files, Excel files and load into various Business Entities.
  • Expertise in SQL Server 2005/2008 Reporting Services and developing Stored Procedures and Triggers in SQL - Server and in publishing the SQL server reports.
  • Excellent knowledge in RDBMS concepts, Kimball approach, and data models, Star/Snow Flake Schemas.
  • Excellent understanding in database and data warehousing concepts (OLTP and OLAP).
  • Highly expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
  • Excellent knowledge and recent experience with all aspects of SQL Server Management Studio (SSMS) including Query Editor, Server objects, SQL Server Agent, Management and Notification Services .
  • Excellent experience in creating Parameterized, drill-down, drill-through, sub-reports, matrix, tabular and Various Charts in Reports using SQL Server 2005/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Expert in job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
  • Expert in creating and configuring Data Source & Data Source Views, Dimensions, Cubes, Measures and KPI’s using SQL Server 2008 Analysis Services.
  • Expertise on performance point server and dashboards, scorecards, building reports and created management report.
  • Outstanding oral and written communication skills. Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

MS SQL Server 2000/2005/2008/2008 R2/2012, Microsoft Access, SQL Server Integration Services (SSIS), DTS,SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS) SQL Profiler, Query Analyzer, SQL, TSQL,C#,VB.Net, XML, HTML, DHTML,ERWIN, MS Visio, Windows Server 2003/2007

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

MS SQL Server/SSIS/SSRS developer

Responsibilities:

  • Designed SSIS package to parse the connection strings updated/added in any of the CMDB environment and load these details to SQL Server destination.
  • Created SSIS packages which extracts data from various TFS OLTP Databases and loads them to the TFS warehouse.
  • Worked on linked servers to create connection between Oracle source and SQL Server destination.
  • Created jobs to schedule the packages to run using SQL Server Agent.
  • Created stored procedures for SSIS packages and reports.
  • Developed chart reports to display the team work progress extracted from TFS Warehouse and OLAP cube using MDX Queries.
  • Created dashboard reports for bug status, team progress, workflow of different teams.
  • Created sub reports to use them in multiple dashboard reports.
  • Created drill through reports so that end users can see the TFS page of the particular work item.
  • Created various reports like tabular, bar charts, pie charts, matrix reports, and drill down reports.
  • Extensively used global variables and expressions for formatting the reports.
  • Tuned the performance of the reports and optimized stored procedures/queries using different Microsoft tools
  • Worked on upgrading Reporting Services from SQL Server 2008 R2 to SQL Server 2012.
  • Worked with the team in creating and configuring OLAP Cube (Star Schema) using SQL Server 2008 Analysis Services
  • Created KPIs for analyzing the team’s bug resolving rate using SQL Server Analysis Services.

Environment: Microsoft SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Data Tools, TSQL, MS Excel, MS Visio 2010, TFS 2010/2012/2013.

Confidential, Kansas, MO

MS SQL Server/SSIS/SSRS developer

Responsibilities:

  • Involved in designing the data warehouse on business requirement and provided relevant documentation.
  • Designed SSIS Packages to Extracting OPM Audit Data from various sources like Text Files, SQL Server, Excel and Access to SQL Server.
  • Developed the packages to send MSP (Medicare Secondary Payer) and Non MSP (Medicare Primary Payer) files to CMS
  • Used SSIS to perform and to support the incremental, historical data loads and transformations.
  • Used various transformations like conditional split, look up, audit, character map, derived column, merge, multicast, and sort.
  • Created SSIS packages to extract data and Scheduled Jobs to call the packages and Stored Procedures using SQL Server Agent.
  • Fixed issues of existing stored procedures and made changes to increase the performance.
  • Developed SSIS packages for different tasks like data cleansing and standardizing, back up and involved in scheduling of SSIS packages
  • Created various Tabular and Matrix Reports using SSRS.
  • Created reports to retrieve data using Stored Procedures that accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports
  • Developed several reports with consistent drill-down functionality including Drilldown reports and Sub-Reports.
  • Prepared AD HOC reports through report builders.
  • Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notification using SSIS and SSRS.
  • Worked with Project team during deployment of SSIS Packages from development server/QA server to production server.

Environment: Microsoft SQL Server 2012/2008/R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio (BIDS), TSQL, MS Excel, MS Visio 2010, TFS.

Confidential, Charlotte, NC

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP
  • Worked extensively with complex T-SQL queries, Created Database Objects - Tables, Triggers, Indexes, Views, User defined functions, Stored Procedure and Constraints.
  • Created many tables with the cluster and non-clustered indexes on columns for optimizing the performance.
  • Monitored performance and optimized SQL queries for reports that took long execution times using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server.
  • Created new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP using various tasks like execute SQL task, dataflow task, file system task, send email task.
  • Designed and developed SSIS packages to extract data from various data sources such as Access database, excel spreadsheet and flat files into SQL server for further data analysis and reporting by using multiple transformations provided by SSIS - Data conversion, conditional split, derived columns, Percentage sampling, Merge, slowly changing dimension and Union all.
  • Scheduled batch jobs and batch queries. Implemented failure alerts using email in SSIS.
  • Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers
  • Designed and implemented stored procedures and triggers for automating tasks
  • Generated Reports using Global Variables, Expressions and Functions for the reports and created stylish Report Layouts and Deployed the Reports using SSRS 2008
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
  • Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI using SQL Server Analysis Services 2008(SSAS).
  • Supported performance related issues in production database and optimized stored procedures/queries with the help of different Microsoft tools.

Environment: Microsoft SQL Server 2008/R2, SQL Server Integration Services (SSIS), SQL Server

Reporting Services (SSRS), SQL Server Business intelligence Development Studio (BIDS), T-SQL,

MS Excel, MS Visio 2010, TFS.

Confidential, New York City, NY

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Gathered Requirements from the end user and designed ER diagrams for mapping data into database tables.
  • Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects
  • Created SQL scripts to insert/update and delete data in MS SQL database.
  • Created database tables, wrote stored procedures to update and clean the old data. Performed tuning for optimizing the existing stored procedures.
  • Used common table expressions, temp tables and pivot tables in various stored procedures.
  • Created various scalar functions and table valued functions.
  • Created SSIS packages to extract data from various data sources such as oracle database, SQL server database, excel spreadsheet and flat files into SQL server using multiple transformations provided by SSIS - Data conversion, conditional split, derived columns, merge, slowly changing dimension, and Union all.
  • Created various types of reports like parameterized reports, drill down reports, sub reports.
  • Implemented conditional formatting using reporting services.
  • Formatted the reports using the Global variables and expressions.
  • Created subscriptions for delivering reports on scheduled time.
  • Created cubes and dimensions for analysis purpose using SSAS.

Environment: Microsoft SQL Server 2005/2008, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services, SQL Server Business intelligence Development Studio(BIDS), SQL Profiler, T-SQL,MS Excel, TFS.

Confidential, Pittsburgh, PA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
  • Managed index statistics, Tables, Views and optimized queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
  • Used SQL Profiler to collect the workload and updated clustered and non-clustered indexes.
  • Designed and developed SSIS packages to extract data from various data sources by using multiple transformations provided by SSIS - Derived column, conditional split, sort, merge and multi cast.
  • Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, and Log Providers etc.
  • Scheduled SSIS Packages for batch job on the basis of dependencies.
  • Created reports like tabular, cross-tab, drill down and drill through reports in SSRS.
  • Created reports to retrieve data using Stored Procedures that accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports
  • Involved in creation of performance dashboards, building reports and management report.
  • Used various expressions for formatting the reports.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services (SSRS), Business Intelligent Development Studio (BIDS), SQL Server Integration Services (SSIS) Visual Studio 2005, SQL Profiler, MS Excel, SVN.

Confidential, McLean, Virginia

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Associated in User Requirement gathering and Technical Specification Documentation.
  • Involved in designing of the logical and physical database.
  • Created new database objects like stored procedures, functions, indexes, views, triggers, cursors using T-SQL in Development and production environment for SQL Server 2000.
  • Involved in migration of DTS packages to SSIS by using update wizard and package migration wizard.
  • Created SSIS packages and performed ETL operations using various tasks like dataflow task, send e mail task and transformations like copy column, derived column..
  • Involved in scheduling jobs for performing batch operations.
  • Designed, developed and deployed various reports like table reports, cross tab reports, cascade reports by using SQL Server Reporting Services
  • Extracted and reviewed data from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.

Environment: MS SQL Server 2000/2005, SQL Server Reporting Services 2005, SQL Server Integration Services 2005,Microsoft Visual Studio 2005, SQL Server Management Studio, MS Excel, T-SQL, Erwin, SQL Profiler, SVN.

Confidential

MS SQL Server Developer

Responsibilities:

  • Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Tables, Stored procedures, Functions and Triggers, Constraints, Views, Defaults and complex SQL statements.
  • Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
  • Created crystal reports.
  • Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel. 
  • Created new tables, written stored procedures for Application Developers and some user defined functions.
  • Created Triggers to enforce data and referential integrity.
  • Performed data conversions from flat files into a normalized database structure.
  • Created linked servers for data retrieval using OLEDB data source and providers.

Environment: SQL Server 2000/2005, Enterprise Manager, SQL Server Management Studio, SQL Profiler, T-SQL.

Hire Now