We provide IT Staff Augmentation Services!

Ssis/ssrs Consultant Resume

SUMMARY

  • 12+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2016/2012/2008 R2/2008/2005 system in OLTP environment.
  • Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high - pressure environment.
  • Excellent experience in ETL(SSIS) and REPORTING (SSRS, Power BI).
  • Expertise on SharePoint Integrations
  • Excellent experience in integrating Microsoft Dynamics CRM with SSIS through Kings waysoft integration tools.
  • Strong experiences to Design, deploy, and maintain various REPORTING tools.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using various Reporting Tools
  • Highly expert in translating Business System Design document into technical design document
  • Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
  • In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2016/2012/2008 R 2/ 2008/2005.
  • Experience in scheduling SSIS packages using SQL Server Agent.
  • Experience in enhancing and deploying the ETL Packages from development server to production server.
  • Expert in resolving the performance issue of ETL and REPORTING tools.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools.
  • Extensively worked on ServiceNow tickets
  • Worked with onshore offshore model
  • Experienced in application maintenance and enhancement

TECHNICAL SKILLS

DB Technologies -: MS-SQL Server 2016/2012/2008 R2, PDW, SQL Server Integration and Reporting Services (SSIS/SSRS) 2013/2012/2008 R2, SSAS, Oracle 9i, MS Access

Reporting tools -: SSRS, Crystal Reports, QlikView, PowerBI

Programing languages -: T- SQL, C#, VB.NET

Software Tools -: SQL Server BI Development Studio (BIDS), MS Visual Studio 2013/2012/2008 /2005/2000, Erwin7.2/4.5/4.0, MSVisio2007/2003, ClearQuest, DTS, Rational Clear Case, Subversion Source control, Team Foundation Server(TFS), Microsoft Dynamics CRM, Kingswaysoft 7.3 (SSIS integration tools for Microsoft Dynamics).

PROFESSIONAL EXPERIENCE

Confidential

SSIS/SSRS consultant

Responsibilities:

  • Provide resolution to all of the user problems and issues within the stipulated SLA time.
  • Design, deploy, and maintain various SSRS Reports in SQL Server.
  • Write Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
  • Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
  • Involved in enhancing and deploying the SSIS Packages from development server to production server.

Tools: & Technologies: SQLServer2016, BIDS 2013, TFS (Team Foundation Server), Parallel Data Warehouse, Task Factory, T-SQL, PowerBI.

Confidential

ETL/REPORT Tool Team Lead

Responsibilities:

  • Design, deploy, and maintain various SSRS Reports in SQL Server.
  • Write Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
  • Create SSIS packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
  • Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
  • Involved in enhancing and deploying the SSIS Packages from development server to production server.
  • Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard

Tools: & Technologies: SQLServer2016, BIDS 2013, TFS (Team Foundation Server), Microsoft Dynamics CRM, Kingswaysoft-SSIS integration tool, T-SQL, Windows 2010.

Confidential

ETL/REPORT Tool Team Lead

Responsibilities:

  • Designed, deployed, and maintained of various SSRS Reports in SQL Server.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
  • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Developed complex reports using multiple data providers, user defined objects, aggregate functions
  • Created SSIS packages to migrate data from different data sources to data destination.
  • Successfully extracted transformed and load data into data destination.
  • Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
  • Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
  • Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
  • Involved in enhancing and deploying the SSIS Packages from development server to production server.
  • Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard
  • Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Tools: & Technologies: SQLServer2012, SQLServerBIDevelopment Studio (BIDS), ClearCase, Subversion, Clear quest, SQL LiteSpeed, T-SQL, MS Access, Windows XP/2007 Server.

Confidential

SQL/ETL/REPORT Team Lead

Responsibilities:

  • I was an onshore Team Lead/Developer responsible for rolling out the project till the go live of each release.
  • I was involved to provide day-to-day delivery to the client by leading the technical team along with development and support to multiple Applications using strong exposure on technical and business knowledge.
  • Designing, deploying, maintaining and migrating of various SSRS Reports in SQL Server.
  • Administering interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • I was involved in migrating SSIS packages, DB from old version to new version and from different data sources to destination database
  • Manage automating Reports for running monthly and weekly feeds from various guarantors and multiple servers and resources.
  • Enhancing and deploying the Reports from development server to production server.

Tools: & Technologies: SQL server 2008R2/2012, Windows XP/2007. BIDS 2008R2/2012, ETL, Reports, SQL Diagnostic Manager

Confidential

SQL/ETL/REPORT Developer

Responsibilities:

  • I have been involved in Requirement Analysis, Coding and Unit Testing as an onshore Developer.
  • I had to provide day-to-day delivery to the client as apart of technical team along with development and support to multiple Applications using strong exposure on technical and business knowledge.
  • Developed Report Models using report builder and distributed reports in multiple formats using Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Created Error and Performance reports on SSIS Packages, Reporting Service, Jobs, Stored procedures and Triggers.
  • Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using REPORT tool.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
  • Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.

Tools: & Technologies: SQL Server 2008R2, BIDS 2008R2, Integration Services 2008R2, ETL, REPORTING, TSQL, Rational Clear Case, MS Access, Windows XP/2003 Server.

Confidential

SQL/ETL/REPORT Developer

Responsibilities:

  • Created the reports based on the requirements using various reporting tools.
  • Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
  • Formatted the reports using the Global variables and expressions.
  • Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
  • Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
  • Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
  • Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
  • Implemented Performance tuning to optimize SQL queries using query analyzer.
  • Involved in project planning, scheduling for database module with project managers.
  • Identified and defined the Datasets for the report generation.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Developed, monitored and deployed SSIS packages.
  • Responsible for automation of maintenance jobs, locks and indexes configurations.
  • Administered SQL Server security, SQL Server automatic e-mail notification.

Tools: & Technologies: MS SQL Server 2008, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS),SSRS,SSIS, SQL Server Query Analyzer, Erwin, FTP Communication, MS-Visual Studio, MS Access, XML,XSLT, ADO.Net.BIZTalk,ASP.NET,VB.NET

Confidential

SQL /ETL/REPORT/Visual Studio Developer

Responsibilities:

  • Designed numerous ad-hoc and custom reports using SQL Reporting Services.
  • Created various Tabular and Matrix Reports using SSRS.
  • Generated Ad-hoc reports and cascading reports for historical data using SSRS.
  • Maintained databases, performed software installations and monitored Database Performance.
  • Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
  • Generated Views for specific columns on a table to maintain privacy of a customer data.
  • Created Indexes to get the high level performance.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Server Agent.
  • Designed SSIS packages for loading data from ODS to Data mart.
  • Created SSIS packages for synchronizing the data between two different servers.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.

Tools: & Technologies: SQL Server 2005, Query Analyzer, SSIS 2005, T-SQL, Excel, REPORTING, ETL Windows 2000/XP, ASP.NET,VB.NET.

Hire Now