We provide IT Staff Augmentation Services!

Sql Data Analyst/ssrs Resume

NyC

PROFESSIONAL SUMMARY:

  • Over 6+ years of experience in MS SQL Server 2017, 2014, 2012, 2008, 2005 and 2000 in Production, Test, Development and Replication.
  • Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
  • Expertise in Writing SQL Queries and Stored Procedures to validate the data
  • Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
  • Having Good knowledge of SQL server Integration Services, SQL server reporting Services and SQL server Analysis Services.
  • Excellent report creation skills using Microsoft SQL Reporting Services (SSRS).
  • Expertise in report generation (automating, managing and security of reports) using SQL Server Reporting Services (SSRS).
  • Created, designed and deployed Tabular, Matrix, Chart, Drill-down and Ad-Hoc reports on report server.
  • Experienced in using global variables, expressions and functions for the reports.
  • Expertise in Creating, Deploying and managing Reports through MS SQL Server Reporting Services (SSRS) and Crystal Reports.
  • Expertise in ETL (Extraction, Transformation and Loading) development using SQL Server Integration Services (SSIS).
  • Experience in creating Jobs, Alerts, SQLMailAgent and Scheduled SSIS Packages.
  • Good Experience in creating Master Child Packages in SSIS and in generating on-demand and scheduled reports for business analysis using SSRS.
  • Extract, Transform and Load data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS &SSIS packages.
  • Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
  • Hands on experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
  • Good interpersonal Skills result oriented, hardworking with quest and zeal to learn new technologies.
  • Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
  • Excellent communication, presentation and interpersonal skill and a very good team player
  • Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2012/2014, MS Access 2000, Oracle 9i/10g/11g

Database Utilities: Enterprise Manager, Query Analyzer, SQL Server Configuration Manager, TOAD, Business Intelligence Development Studio (BIDS), SQL Server Surface Area Configuration, Database Engine Tuning Advisor, SQL Profiler

ETL Tools: Export & Import (DTS), SSIS (Integration Services)

BI Tools: SQL Server Analysis Services, SQL Server Reporting Services.

Data Modeling: Erwin, Microsoft Visio

Languages: C/C++, JAVA, J2EE, C#, T-SQL, PL/SQL, ASP.NET, Visual Basic

Web Technologies: HTML, XML, XSL, CSS, JavaScript, AJAX

Web Servers: Microsoft IIS, Apache, Apache Tomcat

Operating System: Windows Server 2000/2003, Windows NT/98/XP/Vista, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, NYC

SQL Data Analyst/SSRS

Responsibilities:

  • Ensure data quality by writing and executing procedures for cross checking totals and identifying data anomalies.
  • Create, modify and troubleshoot SQL queries, stored procedures and jobs.
  • Created SSIS packages extract, transform and load data into database Scheduling SSIS Packages using SQL Server Agent job .
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Used C# scripts in SSIS script task to run custom scripts in package flow.
  • Created checkpoints and configuration files in SSIS packages .
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server .
  • Deployed SSIS packages with minimal changes using XML configuration file.
  • Designed and developed stored procedures, queries and views necessary to support SSRS reports.
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
  • Involved with Query Optimization to increase the performance of the Report.
  • Used SVN version control tool for Check-in/check-out SSIS package,SSRS repots.

Environment: MS SQL Server Management Studio 2017, Microsoft Visual Studio 2015, MS Excel, Window 10, ASP .NET,C#.

Confidential, Jersey City, NJ

SQL/SSIS /SSRS Developer

Responsibilities:

  • Worked as a developer in creating stored procedures,triggers,functions,constrains,indexes,tables,views and other T-SQL code and SQL joins for applications. .
  • Performance tuning of SQL queries and stored procedure using SQL profiler and Execution Plan.
  • Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
  • Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse .
  • Scheduling SSIS Packages using SQL Server Agent job .
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Used C# scripts in SSIS script task to run custom scripts in package flow.
  • Created checkpoints and configuration files in SSIS packages .
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server .
  • Deployed SSIS packages with minimal changes using XML configuration file.
  • Used PVCS version control tool for Check-in/check-out SSIS package.
  • Prepared ETL design documents for implemented work flows and loaded the documents in the project share point site.

Environment: MS SQL Server Management Studio 2014, Microsoft Visual Studio 2015(SQL Server Data Tool), MS Excel, Window 10, ASP .NET,C#.

Confidential, Buffalo, NY

SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Involved in gathering user requirements and system specifications.
  • Using Red Gate SQL Data Compare compares and synchronize data from within SSMS.
  • Created Views to validate the data and facilate easy user interface implementation.
  • Created Store Procedure to move data from old structure to new structure.
  • Involved in creating Indexes for faster retrieval of data.
  • Using SQL to query database performing various validation and mapping activities.
  • Maintain, Update and Monitor the existing databases on daily basis.
  • Created SSIS Package to import and export data from Flat Files and csv files to SSMS.
  • Imported data from various sources into a staging area, merge the data into OLTP data model and Presents it to all levels of users.
  • Data Migration (Import & Export utility/BCP) from text files to SQL Server.
  • Created drill down,drill through,sub report using SSRS.
  • Generated Multi parameterized reports and make them user friendly.
  • Created drill down,drill through,sub reports using ssrs as well as managed subscription reports As per client’s requirements using SSRS.
  • Created join and sub queries to involving multiple tables.
  • Developed Table, CTE, Temporary table, Function as per Business Requirement.
  • Involved in Testing and Validation of Automation Process.

Environment: MS SQL Server Management Studio 2012,MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Visual studio, MS Excel, Windows XP, Red Gate .

Confidential, Charlotte, North Carolina Area

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

  • Involved in requirement gathering and database design using Erwin.
  • Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
  • Designed and developed Complex SSIS packages for auditing using SQL SERVER 2005 Integration Services (SSIS).
  • Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit and Data Conversion etc.
  • Worked with different Control Flow elements like For Loop Container, For each Loop Container etc.
  • Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
  • Involved in Maintenance and Deployment of SSIS Packages.
  • Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
  • Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
  • Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005.
  • Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
  • Used Query Analyzer, Index Wizard, DB Engine Tuning and SQLProfiler for performance tuning.
  • Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
  • Created Complex Stored Procedures and automated them using SQL Server Agent.
  • Created Triggers (Instead Of and After) for Auditing Purpose.
  • Created Views and Indexed Views for the Performance Tuning.
  • Created automated T-SQL scripts to process summary database transactions that run off-hours.
  • Created Linked Servers to retrieve data from other databases.
  • Monitored and modified Performance using execution plans and Index Tuning.
  • Involved in preparing detailed technical documents.
  • Involved in code review and preparing unit test cases.

Environment: MS SQL Server Management Studio 2005/2008,MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports, ASP .NET.

Confidential, New York, NY

SQL Server Developer SSRS/SSIS

Responsibilities:

  • Actively involved as a part of a team for gathering and analyzing the User Requirement.
  • Created ASP .Net C# code for SSIS Package.
  • Gathered Requirements from the users and checked the structure of the schema and data with The Data Modular.
  • Create database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.
  • Creating and managing schema objects such as tables, views, indexes, procedures, triggers and Maintained Referential Integrity.
  • Extensively used SSIS for transferring data manually from DTS to SSIS packages using SSIS 2005
  • Create SQL Server Integration Services (SSIS) Packages.
  • Created UNIX Shell scripting to load data into database.
  • Generated reports using Global Variables, Expressions and Functions based on the requirements Using SSRS 2005.
  • Design Reports Using SQL Server Reporting Services (SSRS) Identified the database tables for definingf the queries and defined datasets for report generation.
  • Defined reports layouts including report parameters and wrote queries for drill down reports As per client’s requirements using SSRS 2005.
  • Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS.
  • Generated daily, weekly and monthly reports for the managers.
  • Administered interface to organize reports and data sources, schedule report execution and delivery and track reporting history SSRS 2005.
  • Tested the reports and fixed bugs in the stored procedures.
  • Maintained the physical database by monitoring performance, integrity and optimized sql queries for Maximum efficiency using SQL Profiler.
  • Established backup and recovery of SQL reporting services
  • Involved in building SSAS cubes that used the built-in SSAS features for the time dimension and Associated time intelligence.
  • Knowledge in MicrosoftExcelTemplates according to the client’s requirement and choice by writing VBA macro to populate the data and format the Excel file.

Environment: SQL Server 2005 Enterprise Edition, SQL Server Reporting Services, SQL Server Analysis Services, SQL CLR, XML, Windows 2000, IIS 5.0.ASP .NET

Confidential

SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Developed stored procedures, functions and database triggers.
  • Maintained referential integrity and implemented complex business logic.
  • Involved in installation and configuration of SQL server 2005 with latest service packs.
  • Created and executed SSIS packages to populate data from the various data sources.
  • Created SSIS packages using SSIS designer for export heterogeneous data from OLEDB Source (Oracle), Excel spreadsheet to SQL Server 2005
  • Migrated DTS packages to SSIS packages and modified those packages.
  • Designed ETL packages dealing with different data source and loaded the data into target data sources by Performing different kinds of transformations using SSIS.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, crosstabs, and charts.
  • Design, deployment and maintenance of various SSRS in SQL Server 2005.
  • Designed and implemented parameterized and cascading parameterized reports using SSRS.
  • Worked with SQL profiler for troubleshooting, monitoring and optimization of SQL Server and non Production database code as well as T-SQL code from developers and QA.
  • Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
  • Managed the security of servers, creating the new logins and users, changing roles of users.
  • Involved in developing logical and physical model of database using Erwin.
  • Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for Improved performance and availability.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, SQL Server 2005 Management StudioSQL Analyzer and Enterprise Manager, SQL Agent.

Hire Now