We provide IT Staff Augmentation Services!

Ms Sql Server Developer (sql/ssis/ssrs) Resume

Pittsburgh, PA

PROFESSIONAL SUMMARY:

  • Over 7 years of professional experience on design, development and maintenance of database using MS SQL Server 2014/2012/2008 R 2/2008/2005.
  • Extensive experience in Visual Studio 2013/2010/2008/2005
  • Expertise in designing and developing - including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Import/Export data, Triggers - Database objects such as Tables, Schema, Indexed Views and User Defined Functions, etc.
  • Strong proficiency on SQL Server suite of products like SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Management Studio (SSMS)
  • Expertise in data Extraction, Transformation, and Loading (ETL) using SQL Server Integration Services
  • Developed, tested and implemented the Bulk Insert SQL Server script to load the data to the SQL Server database from csv file during production deployment
  • Highly experienced on all activities related to the development, implementation and support of ETL processes for large-scale Data Warehouse using SQL Server SSIS.
  • Involved in developing initial load/incremental load ETL packages, Staging Data ETL packages, Package Test Script onto Server.
  • Highly skillful in Data Conversion and Data Migration using SSIS services across different databases like Oracle, flat files and Excel files.
  • Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendations on server related tuning issues.
  • Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports and Parameterized Reports using SSRS based on client requirement.
  • Good experience in developing stylish reports/sub-reports/charts using Global variables, Expressions and Functions for the Business Users using SSRS.
  • Expertise in generating reports using SQL Server Reporting Services, scheduling and deploying reports on report manager.
  • Experience in working with Tableau against multiple data sources.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
  • Good experience in Logging and tracking bugs/issues using JIRA.

TECHNICAL SKILLSET

  • SQL Server 2014/2008 R2/2008/2005
  • MS Access
  • Visual Studio 2013/2010/2008/2005
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • Business Intelligence Development Studio (BIDS)
  • SQL Server Management Studio
  • Tableau 9/8 Team Foundation Server (TFS) 2010/2008
  • Jenkins
  • Jira
  • Rally
  • T-SQL
  • C++
  • C
  • C#
  • Python
  • Microsoft Office Suite
  • Visio
  • Windows 10/7/XP
  • Windows Server 2012
  • Ubuntu
  • CentOS
  • VMware

PROJECT EXPERIENCE:

Confidential, Pittsburgh, PA

MS SQL Server Developer (SQL/SSIS/SSRS)

Responsibilities:

  • Created SSIS Packages to migrate data into new database from various data sources, for example flat file, excel file, OLE DB.
  • Used various SSIS tasks such as Conditional Split, Derived Column, and Look Up which were used for Data Scrubbing, data validation checks during staging, before loading the data into the data warehouse.
  • Created SQL Server configurations for SSIS packages and deployed packages to server.
  • Designed new dynamic SSIS Packages to transfer data between servers, load data into Database.
  • Implemented ETL packages dealing with different data sources and load the data into target data sources by performing different kinds of transformation using SSIS.
  • Defined the report layout and identified data sets for the report generation.
  • Involved in planning, defining and designing Database on business requirements and provided documentation.
  • Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports and parameterized reports and created numbers of complex formula in sub report.
  • Generated weekly, monthly, quarterly, and yearly parametric, drill-down/drill-through and chart reports using SSRS.
  • Developed & implemented Financial Analysis Reports using SSRS/Tableau.
  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Index and Views.
  • Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
  • Used Tableau to create reports for product QA departments to analysis and decision making for current and future requirements.
  • Used JIRA platform to report and track issues.

Environment: MS SQL Server 2012, SQL Server Reporting Services 2012, SQL Server Integration Services 2012, Microsoft Visual Studio 2010, SQL Server Management Studio, Tableau9, T-SQL, JIRA, C#, MS Office, Windows7

Confidential, Pittsburgh, PA

BI Developer (SQL/SSIS/SSRS)

Responsibilities:

  • Created several stored procedures, triggers, and views and wrote T-SQL queries for database development.
  • Responsible for writing SQL transactions, creation and enhancement of stored procedures.
  • Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
  • Created SQL Server Integration Services packages using different tasks and transformations and moved data from various sources to appropriate destinations.
  • Transformed data from various data sources using OLE DB connection by creating SSIS packages and schedule them as per requirement.
  • Load data using Bulk Insert.
  • Implemented SSIS data transformation scripts, created maintenance procedures, and provided data integrity strategies.
  • Designed and built Data Warehouse solutions using SSIS ETL packages such as look up, union-all, multicast.
  • Created and scheduled the SSIS packages and implemented data transfer.
  • Extracted data from DataMart and generated reports.
  • Generated internal reports to cover weekly, monthly, quarterly, and annual historical information for the departments to facilitate to analysis and decision making for current and future requirements.
  • Proficient in designing and developing complex reports such as Sub-Reports, Parameterized Reports, Drill-Down Reports, Drill-Through Reports, and Snapshot Reports in SQL Server Reporting Services (SSRS) and deploying to end users through Data-Driven subscriptions.
  • Developed Invoices Reports, Expenditure Trend Analysis Reports, and Asset Depreciation reports using SSRS for departments.

Environment: SQL Server Management Studio 2012, Business Intelligence Development Studio (BIDS), SQL Server Reporting Services, Microsoft Visual Studio 2010, T-SQL, MS Office

Confidential Chicago, IL

BI Developer (SQL/SSIS)

Responsibilities:

  • Transfer Data from Database to Data Warehouse using SSIS ETL packages such as look up, union-all, multicast.
  • Transferred claim data from staging area using bulk insert to perform different data flow and control flow tasks in SSIS.
  • Used a combination of Slowly Changes Dimensions (SCDs, Type 0, 1, 2)) to extract data from staging database and load data to the Data Warehouse.
  • Validated data and converted data type before loading data into Data Warehouse.
  • Scheduled incremental data loading by incorporating Lookup and Conditional Split SSIS components to identify and manage changes.
  • Used T-SQL language in SQL Server Management Studio to create Common Table Expressions (CTEs), stored procedures, DML triggers.
  • Created parameters in packages and generated configuration file before package deployment.
  • Supported package deployment and modified parameters in configuration file.
  • Worked with Data Warehouse team to maintain and correct dimensional or fact tables that have impact on report accuracy and availability.

Environment: MS SQL Server Integration Services, MS SQL Server Reporting Services, MS SQL Server 2008, Microsoft Visual Studio 2005, C#, Visio 2007, MS Office

Confidential, WOODBURY, NY

MS SQL Server Developer (SQL/SSIS/SSRS)

Responsibilities:

  • Created and executed several SSIS packages to perform ETL operations of the data from source server to destinations server and OLTP to OLAP.
  • Maintained data integrity by performing validation checks with in SQL server and Dataview.
  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Index and Views.
  • Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
  • Developed backup restore scripts for SQL Server as needed.
  • Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
  • Used SSRS to design and develop solutions to support business intelligence reports and dashboards including Sub-Reports, Snapshot Reports, Parameterized Reports, Drill-down Reports, and Drill-through Reports.
  • Created complex reports stating revenue generation per year using cascading parameters and Tablix structure to create summarized reports in SSRS.
  • Generated reports to cover weekly, monthly, quarterly, and annual historical information for the Sales department to facilitate analysis and decision making for current and future requirements.
  • Involved in making reports layout and dataset and created SQL server Reports using SSRS 2008 from initial stage.

Environment: MS SQL Server 2008, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Visual Studio 2005, C#, CentOS, MS Office

Confidential, WOODBURY, NY

MS SQL Server Developer

Responsibilities:

  • Participated in meetings with all the members of the project to discuss, plan, and implement strategies that would ensure all the business requirements reflect in the project development.
  • Extract data from various sources including SQL Server into the OLAP Data Warehouse which was in SQL Server.
  • Created data mapping documents to provide source and destination mapping for effective Enterprise data warehouse. Involved in implementing logical and Physical Database modeling using Erwin tool.
  • Created index, stored procedures for secured data storage and efficient data manipulation.
  • Involved in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks and Unique) in writing T-SQL queries and Dynamic-queries.
  • Involved in Troubleshooting performance issues and fine-tuning queries and stored procedures.
  • Designed and developed data models and ER diagrams in Visio for the data warehouse using star and snowflake schema.
  • Created various stored procedures, functions, views, trigger based on need.
  • Created and modified views and stored procedures according to technical specifications and business requirement.
  • Developed, monitored, and deployed SSIS packages.
  • Managed and coordinated with remote user for change request and optimization of application.

Environment: MS SQL Server 2005, T-SQL, SQL Server Management Studio, MS SQL Server Integration Services, MS SQL Server Reporting Services, C#, MS Office

Hire Now