We provide IT Staff Augmentation Services!

Sr. Sql Server/ssis/ssrs Resume

Seattle, WA

PROFESSIONAL SUMMARY:

  • Over 8 years of experience in Database Design, BI - Development of Microsoft SQL Serve 2014/2012/2008 R2/2008 various development, test and production environments with various business domains like Financial, Insurance and Manufacturing
  • Experience in Installation, Configuration, Management and Troubleshooting SQL Server.
  • Expertise in Business Intelligence Development Studio (BIDS), which includes SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Implemented complete BI solutions using conventional SDLC and Agile methodologies.
  • Proficient in writing and tuning SQL queries and improving the query performance, working on DTS, Data Cleansing and Data Migration.
  • Expertise in creating/modifying Tables, Views, Triggers, Joins, cursors, User Functions, Indexes, user profiles, relational database models, data dictionaries, Stored Procedures and in depth knowledge in query optimization & performance tuning.
  • Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
  • Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
  • Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
  • Experience in T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors.
  • Used SSIS Import/Export Wizard for performing the ETL operations.
  • Experience in SQL Server Analysis Services (SSAS 2008/2012) OLAP Cubes.
  • Expertise in creating Configurations to make package portable and Event handlers for handling package error.
  • Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension (SCD), Merge Join and Union
  • Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
  • Proficient in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
  • Expertise in creating and Configuring Data Source & Data Source Views, Dimensions, Cubes, Measures using SQL Server Analysis Services.
  • Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security and has an ability to define and develop Report Structure with data definition, report layout and report definition language.
  • Developed BI data mapping and BI objects (dashboards, reports, analyses, visualizations, metrics, security) design documents using Power BI.
  • Expert in calculating measures, mathematical formulas and user-defined functions (DAX) in Power pivot reports.
  • Expertise in creating InfoPath solutions and publish into SharePoint form Libraries for sharing information, implementation of Out-of-box workflows designed using SharePoint designer 2013.
  • Experienced in Upgrading and Migrating sites and site collections implementation to SharePoint 2013 environment.
  • Worked with SharePoint designer workflow for updating team work progress on project day to day development.
  • Experienced in organizing and customizing SharePoint Sites, Web Parts, Connectable Web Parts and deployment of Web Parts with SharePoint Server.
  • Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 20012/2008.
  • Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
  • Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
  • Proficient in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
  • SQL Server OLAP Database Development including KPIs, Data mining, working with changing dimensions.

TECHNICAL SKILLS:

RDBM/Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, Oracle 8i & 9i, 10g, 11g, Sybase, MS Access 97/2000/2003/2007, MYSQL

Programming, Scripting & Web Languages: C, C++, T-SQL, PL/SQL, MDX, Dynamic SQL, HTML, DHTML, XML, Shell Scripting, Visual Basic 6.0

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), Power Pivot, Power View, Power BI, Tableau

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, SQL Server Analyzer, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console,, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010/2013

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. SQL Server/SSIS/SSRS

Responsibilities:

  • Created SSIS package to load data from XML Files, Excel, CSV file by using Derived Columns, Condition Split, Data Conversion, Pivot Transformation, Execute SQL Task and Script Component Task.
  • Created Dynamic SSIS packages using expressions, variables and control flow.
  • Used Script task to write custom code using C#.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Migrated existing packages from SSIS 2008 to SSIS 2012.
  • Used Unpacked Decimal Component in main frame packages to parse any data file in packed or unpacked form to load data to destination tables.
  • After migration, performed Analysis and provided technical documentation for the given SSIS packages.
  • Used Team Foundation Server (TFS) to retain Project code during deployment process.
  • Identified data source and define data source Views.
  • Generated reports using SSRS 2008R2/2014 from OLTP and OLAP data sources.
  • Used Power BI to design interactive reports and data visualization using Power BI Desktop.
  • Developed Power BI reports and dashboards from multiple data sources using data blending.
  • Created T-SQL queries, stored procedures, user defined function and views, for faster retrieval of data by using T-SQL queries and to display specific information
  • Used various transformations in SSIS like Multicast, Conditional split, Script Component and Lookup while loading the Data into destination tables.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed, monitored and deployed SSIS packages.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Involved in developing Complex SSRS Reports (.RDL) and ad-hoc involving Sub Reports, Matrix/Tabular Reports, Linked Reports, Charts and Graphs from OLAP to deliver validated reports based on user requirements and deploy the Reports in Report Server.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
  • Worked with SSRS Reporting web service for custom applications and console applications.
  • Managed the report server to enable saved reports browsing within SharePoint integrated mode.
  • Deployed reports to the report server in native mode and SharePoint integrated mode.
  • Developed Validation Plans for SSIS packages for checking the functionality of each component and code review.
  • Preparing high level and low level design document for ETL applications, Source -Target mapping documents
  • Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Typical tasks were to manage new and updated tables/views through development, testing and into production.

Environment: s: Windows server, MS SQL Server 2014/2012, Team Foundation Server (TFS), T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Profiler, SQL Server Agent, Erwin, Tableau, MS SharePoint Server

Confidential, Richardson, TX

Sr. SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
  • Created SSIS packages for Uploading of different formats of files (Excel, Access) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
  • Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
  • Configured Server for sending automatic mails to the respective people when a SSIS package fails.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Extensively worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Customized roles and KPIs using multi-dimensional expressions ( MDX ).
  • Designed T-SQL scripts to identify long running queries and blocking sessions.
  • Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
  • Generated reports that can handle dynamic grouping and dynamic sorting.
  • Created drill down, drill through, sub reports and many more complex reports.
  • Permitted access to the reports based on designation of the viewer like store manager or district manager or associate extra.
  • Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
  • Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Involved in creating report models and applying row level security filters for report model.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created reports from cubes by writing MDX queries.
  • Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
  • Used Pivot table to provide structure to Reports in proper manner like months etc.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports.
  • Deployment of the developed reports on to the server for the end users.
  • Deployed the developed reports and upgraded the system.
  • Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
  • Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
  • Developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key to streamline the process of replication.

Environment: s: Windows server 2000/2003, MS SQL Server 2014/2012/2008 R2, T-SQL, SQL Server Analysis Services, Report Builder 3.0, DTS, VMware, SSIS, SSRS, Power BI, Performance Point Dashboard Designer, MS SharePoint Server 2010

Confidential, Birmingham, AL

Sr. SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

  • Worked with Client/Business Analysts to define data requirements for reporting warehouse.
  • Designing and developing SQL Server 2012 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and un-pivot Control Flow Transformations.
  • Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
  • Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
  • 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 2012.
  • Proficient in creating and validating the Power BI reports.
  • Fetch the data from Oracle 11g by creating a linked server and use SQL Server to query Oracle database.
  • Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
  • Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
  • Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Design, deploy and maintain various SSRS Reports in SQL Server 2012.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
  • Created Add-ins, macros, templates, customized Ribbons and write VBA code for all suite applications, especially MS Access, PowerPoint and Excel 2013.
  • Automated the conversion and loading of data from Excel based source files using VBA.
  • Designed/redesigned Access databases tables, queries, forms and reports using designer and VBA.
  • Experience with creating VBA excel forms and spreadsheets.
  • Developed the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Developed many MDX queries for creating measures that fits business logic
  • Used ProClarity for accessing and analyzing cubes and dimensions and worked on integration of SharePoint with SSRS.
  • Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
  • Created tabular model in SSAS and developed data model in power pivot for excel by using the existing Report.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
  • Created custom calculation in power pivot by using DAX formula
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
  • Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
  • Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio, SSIS, SSRS, SSAS, MS Excel, Teradata, Power Pivot, Power BI

Confidential, Nashville, TN

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracles to SQL Server.
  • Moving data to staging tables using SSIS.
  • Wrote T-SQL code for creating cursor and handling the data validations.
  • Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints.
  • Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and Materialized views for remote instances.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
  • Configured Server for sending automatic mails to the respective people when a SSIS package fails.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format Using
  • Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Handling the orphan rows in Dimension and Fact tables.
  • Develop the Documents for Logging/Error Handling for SSIS Packages.
  • Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Participated in daily standup, scrum sessions, team retrospective sessions. Participated in a small, experienced, energetic team on a rapid, agile development schedule.
  • Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
  • Actively participated in User Acceptance Testing and Debugging of the system.
  • Extensively worked with Team Foundation Server (TFS) 2012.

Environment: MS SQL Server 2012/2008R2, TOAD, T-SQL, Oracle 10g, SQL Profiler, Rapid SQL (2016), Visual Studio (2012), Team Foundation Server (2012), Visual Source save (VSS), WIN NT, Erwin and SQL Server Integration Services.

Confidential

SQL Server Developer SSIS/SSRS

Responsibilities:

  • Involved in designing high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses Column Mapping, Data dictionary and Metadata.
  • Created complex Stored Procedures and Functions to support the front-end application.
  • Created SSIS Packages for Incremental Loading and slowly changing dimensions.
  • Created and formatted the report layout for end users.
  • Deployment of the developed reports on to the server for the end users.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Wrote database triggers in T-SQL to check the referential integrity of the database.
  • Created the MS DTS packages for executing the required tasks.
  • Created reports from database onto excel spreadsheet using DTS.
  • Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
  • Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
  • Designed and created views for security purposes, implemented rules, defaults, data types.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
  • Used SSIS transformation for Data Cleansing to remove unnecessary data.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc.
  • Created Linked reports, Ad-hoc reports etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
  • Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, (SSRS) 2005/2008
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and generated reports using Crystal Reports.

Environment: MS SQL Server 2008/2005, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Oracle 9i/10g, Windows, VB Script

Confidential

SQL Server/BI Developer

Responsibilities:

  • Developing T-SQL queries, triggers, functions, cursors and stored procedures.
  • Responsible for logical and physical design of SQL Server databases.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation and created views to restrict access to data in a table for security.
  • Expert in extracting data using SSIS from OLTP to OLAP.
  • Performed Bulk data migration using DTS and SSIS from flat files.
  • Designed and optimized all the SSIS packages and exported data from text file to SQL Server Database.
  • Identified the Data Source and Datasets for report generation and included report parameters.
  • Implemented full and differential backups and created and managed DB objects.
  • Make recommendations for File Group Creation and Placement.
  • Scheduling backups and automating weekend maintenance tasks.
  • Created users and roles for login authentication and validating permissions.
  • Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
  • Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment: SQL Server 2005/2000, T-SQL, DB Artisan, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, Oracle 9i.

Hire Now