Sql Server Developer, Ssis / Ssrs/ Developer Resume
Salt Lake City, UT
SUMMARY:
- Over 6 years of progressive experience in software design and development with an earned reputation for meeting deadlines and delivering mission critical solutions.
- Experienced in SSIS (SQL Server Integration Services), SSRS (Reporting Services).
- Extensive experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading
- Expert in creating complex Transact SQL (T - SQL) queries, Sub queries, Co-related sub queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
- Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing.
- Good understanding of Database Architecture concepts related to Pages, Extents, Files, File-Groups, Transaction Logs, Tables and Indexes.
- T-SQL Programming using DDL, DML commands for various business applications.
- Efficient in creating joins and sub-queries for complex queries involving multiple tables.
- Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
- Hands on experience in creating indexed views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
- Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
- Extensive experience in Extraction, Transformation and Loading tasks in SSIS while transferring the data to target destinations from various sources like Excel, CSV, Oracle, Access, Flat File, Raw File and XML File.
- Experience in building Data Integration and Workflow Solutions for Extracting, Transforming and Loading data with SSIS packages, DTS and BCP utility.
- Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.
- Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
- Expert in designing reports using SQL Server Reporting Services (SSRS), operating and troubleshooting with data sources.
- Expertise in designing complex reports likes Drill-Down, Drill-Through, Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
- Experienced in creating reports and dashboard using Tableau.
- Hands on experience in Creating Star Schema and Snow Flake Schemas.
- Awell-organized, goal-oriented, highly motivated and effective team player with excellent analytical, troubleshooting, and problem-solving Skills.
- Excellent Verbal & Written Communication skills and strong in Documentation.
- Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.
TECHNICAL SKILLS:
Databases: MS SQL Server 2005/2008/2012/2014 , MS Access 97/2000/2003 , Share Point
ETL Tools: SSBI Development Studio, SSIS, Data Transformation Services (DTS), Import/ export wizard, BCP
Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder, Crystal Reports, Excel, Tableau
Database Tools: BIDS 2008/2005, Management studio, SQL Profiler, SQL Query Analyzer, Performance Monitor T SQL, C, C#, VB, HTML, XML, R, Python
Operating Systems: WINDOWS 2016/2014/2010/2008/2003/2000/ NT Servers
Other Tools: MS Office Suite, Adobe Suite, Visual Studio, ERwin, TFS, Jira
PROFESSIONAL EXPERIENCE:
Confidential, Salt Lake City, UT
SQL Server Developer, SSIS / SSRS/ Developer
Responsibilities:
- Interacted with business users for understanding and gathering business requirements and involved in project planning, scheduling the database module with project managers.
- Worked with SQL in writing complex queries to fit the Clinical workflows and develop ad-hoc reports requested by Physicians.
- Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
- Created Reports in SSRS with different type of properties like Chart controls, Interactive sorting, SQL parameters etc.
- Monthly CIR reporting to Department of Health by generating the Immunization data in the required format.
- Maintain Crystal Reports library and custom Crystal reports for OR Manager an application documenting the patient's surgical procedure, three phases surgical preoperative, intraoperative and postoperative.
- Actively involved in extracting the workflows from Physicians that can help in writing the reports.
- Helped application teams in Query Analyzing and its optimization.
- Provided various reports for various departments including census for the development of the hospital.
- Provided Ad-hoc Query for the MLM programmers.
- Experience in developing HRSA reports for the funding of the hospital.
- Assisted with financial reporting for entire hospital network.
- Created custom fields, created custom screens and assisted in working with clinical leads to determine reporting analysis.
- Created DTS, SSIS packages for data integration from various data sources like Access, and SQL Server 2008 R2 into the operational SQL Server and deployed them by using configuration tools.
- Strong knowledge of SQL including queries, views and stored procedures, SSRS and SSIS.
- Designed cubes with star schema using SQL Server Analysis Services (SSAS).
- Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
- Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
- Created Stored Procedures, triggers, views, temp tables for data manipulation & reporting.
- Create ad-hoc reports upon request.
- Closely worked with the networking team to provide the solution for existing printer mapping.
Technology: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008 R2, Visual Studio 2008, PL-SQL, Share Point, Oracle 10g, MS Access.
Confidential, Dallas, TX
MS SQL Server/ETL Developer
Responsibilities:
- Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
- Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
- Played a key role in production support of SSAS cube and SSIS jobs.
- Migrated data from various sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
- Prepared the complete data mapping for all the migrated jobs using SSIS.
- Extensively used SSIS transformations such as Derived column, Data conversion, SQL task, Script task and Send Mail task, Data Flow task etc.
- Worked on Cube partitioning, processing and incremental synchronization of SSAS cubes and bind them to XLS.
- Created SSIS 2012 packages dynamically using SQL Server Configuration & Environmental variable.
- Converted more than 60 DTS packages to SSIS packages and created logging for error handling.
- Worked with QA team & Business Users for the validation of the data &SSIS packages.
- Involved in creating, modifying, deploying & monitoring SQL Server Agent Jobs.
- Created and maintained technical documents for ETL Process.
- Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues Matrix Reports and Charts.
- Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
- Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Technology: SQL 2012, MS SQL Server 2000/2008, MS SQL Integration Services 2008, DTS 2000, MS SQL Server Analysis Services 2008, MS ACCESS, IBM iSeries AS/400, Team Foundation Server.
Confidential, New York City, NY
BI Developer
Responsibilities:
- Involved in user requirement meeting and gathered requirement and created requirement documents from business users.
- Developed List, Cross tab, Drill through, Master-detail, Chart & Conditional formatting reports which involved multiple prompts in Report Studio.
- Created new data source connections in FM and in Cognos admin.
- Created reports containing multiple data containers like List, Cross-tab, Graphs and Repeater tables.
- Developed Executive Dashboards with drill up and drill down capabilities.
- Developed Ad-hoc reports using Tableau Desktop, Excel.
- Developed several Tableau customized views and dashboards using Tableau Desktop and presented the same to Business and IT users.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Created data visualizations using Charts, drill-down, parameterized controls using Tableau.
- Used Custom Calculations in building several Tableau Views that includes Manipulating Strings and Date
- Calculations, Aggregation Calculations, Logical Statements, Grand Totals, Sub-Totals and Table Calculations.
- Created Statistical visual views using Reference Lines, Bands, Distributions, Trending and Forecasting.
- Created Tableau Dashboards and applied interactive actions using Highlight, Filter and URL.
- Tested Cognos reports, Tableau views and dashboards against the data in the database using sql.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Published Tableau Views and Dashboards to Tableau Server, Tableau reader and Tableau Public.
- Created Context filters and data source filters while handling the huge volume of data in Tableau Views and Dashboards.
- Wrote and executed the Test cases for various reports that were developed in Cognos 10.x and Tableau 9.x.
- Actively involved in Production support. Implemented fixes/solutions to issues/Tickets raised by user community.
- Trained Business users to make their own ad-hoc reports using Cognos 10.x and tableau.
- Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
Technology: Cognos 11.x, 10.x, Tableau 8.x, 9.x, Oracle11g, 2012 SQL Developer, SQL Plus
Confidential - Westerville, OH
SQL Server Developer
Responsibilities:
- Involved in creating functional and technical specification documents after gathering requirements from business.
- Created database objects like Tables, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.
- Designed and developed data models (physical/logical data models) based on the given specs.
- Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.
- Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
- Experience in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
- Experience in migrating C# application on windows servers.
- Experience in migrating databases from one environment to another environment using linked servers.
- Designed and Developed Reports using Report Builder to easily generate reports by the user.
- Configuring SSIS packages using package configuration wizard to allow Packages run on different environments.
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
- Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on Inputs, scheduling the SSIS packages using SQL Server Agent Services.
- Creating multiple parameterized stored procedures that are used by the reports to get the data.
- Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
- Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
- Deployed SSIS package on the server and scheduled the packages using SQL Server Agent Services.
- Worked in end to end testing of the packages and validated the data after each load.
- Designed, developed and deployed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS with Report Builder.
- Generated multiple reports from SQL Server Database (OLTP) and multidimensional data model OLAP.
Technology: MS SQL Server 2012, Microsoft Visual Studio 2010, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows Server 2008.