We provide IT Staff Augmentation Services!

Sr. Ms Sql Server/ Ssis/ssrs/ssas Developer Resume

White Plains, NY

PROFESSIONAL SUMMARY:

  • 8+ years of extensive experience in Database Design, Development and Administration of applications with MS SQL Server versions 2016/2 R 2/ 2008/2005/2000 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
  • 3+ years of Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Context Filters, Sets, groups etc.
  • Extensive experience in working with Tableau 8.0/9.0/9.2 Workbooks.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Involved in all the stages of Software Development Life Cycle (SDLC) including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.
  • Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user profiles, relational database models and data integrity, SQL joins and query writing.
  • Hands on experience in installing, configuring, managing, monitoring SQL Server 2008/2005/2000 .
  • Experience with Fragmentation and Query analyzer for SQL Server 2005/2008/2012/2014/2016 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
  • In depth knowledge in T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
  • Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
  • Experience in Database Backup, Recovery and Disaster Recovery procedure.
  • Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
  • Created complex expressions using the MDX scripting to solve complex designs.
  • Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
  • Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
  • Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Reporting, Designing logical/physical databases and Troubleshooting.
  • Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.
  • Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
  • Experience in Integrating SQL Server Reporting Services (SSRS) with Microsoft Office Share Point Server (MOSS 2007).
  • Good understanding in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Experience with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
  • Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models.
  • Good team player with strong analytical skills.

TECHNICAL SKILLS:

Programming Skills: T: SQL, C, HTML, CSS,, ASP.NET, VB, C#

RDBMS: MS SQL Server 2016/2 /2005/2000 , MS Access,Teradata.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables. SQL Query Analyzer, ETL, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010/2013 Crystal Reports

Operating Systems: UNIX, LINUX, Windows7 Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

Systems familiarity: OLTP,DSS,OLAP,MDX

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

Sr. MS SQL SERVER/ SSIS/SSRS/SSAS Developer

Responsibilities:

  • Designed multiple stored procedures for the report data sources.
  • Designed, developed various SSRS reports for Confidential data which involves Merchant Transactions and Merchant Actives.
  • Interacted with the business users to gather information about the report.
  • Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, CTE s, Views, Constraints, Cursors with best execution plan in SSMS to implement the business logic for Confidential process.
  • Worked on Report Migration to move SSRS reports from Argus Environment to Confidential environment.
  • All RDL files have been downloaded from Argus environment and re - configured in BI and re-uploaded to Confidential environment and changed the data sources accordingly before Go-live
  • Designed ETL SSIS packages involving PayPal business logic to generate CSV files for Merchant Transactions and Merchant Actives Confidential data.
  • Used WinSCP client to transfer CSV files to SFTP Server.
  • Designed a data pattern such that the data moves from Confidential to Hadoop File System through SFTP Server
  • Scheduled and monitored these data pull jobs via UC4 job scheduler.
  • Created databases, tables, views on Hive to load Merchant Insights and MIS Confidential data into Hadoop File System.
  • Used PuTTY application to access UNIX terminal from Windows operating system.
  • Created automation scripts using Unix Shell Scripting to move data into Hadoop File System.
  • Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned tasks.
  • Experienced working on production support during code deployment.
  • Reviewed many T-SQL issues using management studio for better performance and working on performance tuning for slow running queries using Profiler.
  • Experienced in writing UAT scripts for code deployment on Development, Staging, and Production environments.

Environment: SQL Server 2008R 2/2012/2014/2016 , SSRS 2014, SSIS 2014, T-SQL, Hive .13, Hadoop, PuTTY, UNIX, WinSCP, Windows 7, SQL Server Data Tools

Confidential, Atlanta, GA

Sr. MS SQL SERVER/ SSIS/SSRS/SSAS Developer

Responsibilities:

  • Analyzed the client requirements and translate them into technical requirements.
  • Extensively worked on T-SQL for creating stored procedures, indexes and functions.
  • Performance Tuning of SQL queries and stored procedures using SQL Profiler.
  • Managed index statistics, Tables, Views, cursors and optimized queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
  • Extensively worked on designing reports using SQL Server Reporting Services (SSRS)
  • Worked on SSRS 2008 to generate about 30+ reports for various user groups and developer groups .
  • Developing Tabular Reports, ad-hoc Reports using SSRS Report Designer. Generating several types of drill down and drill through reports using SSRS.
  • Developing complex SSRS reports using multiple data providers, global variables, expressions, user defined objects, charts, and synchronized queries.
  • Designing and implementing parameterized and cascading-parameterized reports using SSRS.
  • Deploying reports, creating report schedules and subscriptions. Managing and securing reports using SSRS.
  • Created ETL packages with different data sources ( SQL Server, Flat Files, Excel source files, XML file ) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Extensively worked on Data Flow tasks like foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
  • Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks.
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split and many more.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Successfully migrated SSIS packages from development to test and Production environments using SSIS Configuration files and deployment wizard.
  • Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads .

Environment: MS SQL Server 2016/2014/2012 , SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS),SSAS,DB2, MS SQL Profiler, Crystal Reports, SQL Query Analyzer, Teradata, SQL Server Index Tuning Wizard, Visual Studio 2005, Cognos,Windows XP,MDX C#, ASP.NET,, XML, Erwin v4.1, MS Office 2013.

Confidential, Atlanta, GA

Sr. MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

  • Developed all the required stored procedures, user defined functions, triggers using T-SQL.
  • Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Created Cascading dashboards, data extracts Action filters for better performance of Tableau.
  • Used data sources like SQL, SSAS cubes and files to generate reports in Tableau.
  • Creation and maintenance of SSIS Packages (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
  • Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
  • Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
  • Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
  • Created business critical key performance indicators (KPIs) using SQL Server Analysis Services. Wrote MDX queries according to the business requirements.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
  • Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL.
  • Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
  • Prepared technical documents like High Level Design
  • Involved in Business Analysis & Requirement collection. Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript
  • Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS.
  • Migrate the data from an Access database to SQL Server 2008.
  • Developed web application for reporting portal using .NET, ASP.NET, C#, VSS.
  • Used VB.Net Code to create embedded functions in SSRS.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), MS SQL Profiler, SSAS, SQL Query Analyzer,SQL Server Index Tuning Wizard, MDX, Erwin v4.1, MS Office 2013, Tableau Desktop 9.0/8.3, Tableau Server

Confidential, St.Louis, MO

SQL Server Developer

Responsibilities:

  • Performed server installation and configuration using SQL server2012.
  • Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements
  • Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions and Maps etc.
  • Built complex formulas in Tableau for various business calculations.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Extensively worked and Managed on OLAP cubes using SSAS.
  • Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
  • Involved in designing calculated measures using Multi-Dimensional Expression (MDX).
  • Implemented custom SSRS Reports to Internal operation team by reading data from the QNXT Database.
  • Created Full client, Web I and Crystal Reports based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.
  • Added new users and applied roles in the QNXT UI in the Development and UAT Environments.
  • Created Reporting interface for Customer service team by reading the data from QNXT Claim, Claim Detail tables.
  • Implemented ETL Application to load Claim Payment information to QNXT Financial tables and provided access to financial team by creating custom roles in the security management.
  • Creating, Approving and Modifying PA in both Portal and QNXT and also Involved in Adding Contracts to the Provider in QNXT and associating Providers in Portal while creating claims.
  • Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
  • Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
  • Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSAS and SSIS.
  • Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
  • Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
  • Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose.
  • Worked in Enterprise Manager for job scheduling and batch queries.
  • Planned Backup strategy based on projects requirements.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Crystal Reports, SSAS, Oracle 9i/ 10 g; DB2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, MDX,Windows XP, C#, ASP.NET, BizTalk Server, QNXT, JavaScript, XML, Erwin v4.1, MS Office 2013, Tableau Desktop 9.0/8.3, Tableau Server.

Confidential, Hopewell, NJ

SQL Server BI Developer

Responsibilities:

  • Involved in Database design & Data modeling various databases.
  • Developed all the required stored procedures, user defined functions, triggers using T-SQL.
  • Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
  • Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
  • Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
  • Involved in writing MDX Scripts for the OLAP CUBES.
  • Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL.
  • Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
  • Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
  • Creating Static Reports using MDX queries and creating MDX Base Report Definition.
  • Understanding Customer requirement via interaction and writing functional specification.
  • Wrote complex stored procedures and cursors to implement various business logics as per the client requirements.
  • Optimizing existing queries and fixing query performance issues.
  • Actively interacted with end user to gather business requirement, system specification and enhancement.
  • Involved in writing Transact SQL utilities to generate table insert and update statements.
  • Generated Script files of the databases whenever changes are made to stored procedures or views.
  • Experience working in agile environment and supported iterative testing methodology.
  • Worked in on site/ off shore/ off site environment; coordinated my activities by proactively communicating with my counterparts in the other teams.

Environment: SQL Server 2008 R2/2012, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MDX, MS Access, Excel, C#, ASP.Net, Crystal Reports, Teradata, ER Studio, Performance point Server.

Confidential

SQL Server Developer

Responsibilities:

  • Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
  • Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
  • Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
  • Responsible for Design and Normalization of the database tables.
  • Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
  • Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
  • Gathered requirements for the creation of Data Flow processes for the SSIS packages.
  • Used various Control Flow Tasks in the development of various complicated packages.
  • Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
  • Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
  • Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
  • Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
  • Generated and formatted Reports using Global Variables and expressions for the reports. Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
  • Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2000/2005, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).

Hire Now