Ms Senior Ms Sql Server/ssis/ssrs/etl Developer Resume
SUMMARY
- A strong experience in Microsoft SQL Server in administration, testing, development and production environment as an MS SQL Developer.
- Experience in Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts.
- Strong experience in creating T - SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
- Experience in Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL/SSIS processes, dimensional modeling and reporting tools.
- Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
- Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing. creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
- Strong experience in MS SQL Server 2017/2014/2012/2008 r2/2008 suite of products including SSIS, SSRS and SSAS.
- Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
- Experienced in creating, configuring and scheduling the Dynamic SSIS packages.
- Extended knowledge of using VB.net and VBScript for data manipulation.
- Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
- Experience in designing and developing dashboards using QlikView/Qlik sense by extracting the data from multiple sources (SQL Server, Web Services, Teradata, Flat files, Excel, Access etc.)
- Good at developing reports using different Reports Tools SSRS, Tableau, and MS Power BI.
- Involved in Developing Excel Power View, Power Query and Power Pivot dashboards for data analysis.
- Design data visualization to create multiple charts by using MS Power BI and Tableau for business analysis.
- Highly experienced in Performance Tuning, Handling Indexes, and Query Optimization.
- Team orientedindividual with a results driven attitude, strong interpersonal and Communication skills in effective information exchange and interaction with clients at all Levels of management
- Excellent communication and inter-personal skills, accustomed to work in a team Environment with tight schedules and capable of working efficiently under pressure.
TECHNICAL SKILLS
Database: MS-SQL Server 2017/2014/2012/2008 r2/2008, Oracle 11g Express, My SQL 6.0 and Microsoft Access, T-SQL, PL-SQL VB.Net.
Database Tools: SSIS, SSRS, SSAS, SQL Server Management Studio.
Design Tools: MS Visio, Erwin 9.0/7.1, ER Studio.
BI Tools: QlikView 11/10, QMC, Qlik Publisher, Qliksense 3.x, Power BI.
Platform & Frameworks: Windows 10/7, Windows Server 2003/2008, DOS, etc.
Other: Microsoft Project, TFS, Microsoft Office Suite.
PROFESSIONAL EXPERIENCE
Confidential
MS Senior MS SQL Server/SSIS/SSRS/ETL Developer
Responsibilities:
- Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
- Worked with Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts.
- Created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
- Wrote Distributed Queries between SQL Servers.
- Worked with various tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
- Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
- Created reports which retrieve data using Stored Procedures that accept parameters.
- Created various reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation.
- Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
- Built the email QC system to analyze the accuracy of the data warehouse ETL process and generate the email to all the team members.
- Built the automated ETL system for the Group Practice data mapping by utilizing the Lookup, slow changing dimension and developed C#/ VB.NET in script task and script component in SSIS.
- Performed transformations like Conditional Split, Sorting and included data about the environment using the Audit Transformation.
- Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).
- Created reports using SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.
- Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
- Integrated Custom visuals based on business requirements using Power BI desktop.
Environment: MS SQL Server 2014/17, T-SQL, SSRS, SSIS, SSAS, Oracle 10g, Windows server 2008, Visual Studio 2015, Tableau Desktop 9, C#/VB.NET, Windows 10
Confidential
Senior MS SQL Server/SSIS/SSRS/ETL Developer
Responsibilities:
- Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
- Designed and developed Logical Data Flow by applying complex transforms as per business rules for loading the extracted data into Enterprise Data warehouse.
- Developed User Defined Functions, store procedure. Responsible for error handling in stored procedure, indexes to generate the distinct data based on the type of the customer base, wrote T-SQL queries.
- Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
- Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
- Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
- Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
- Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
- Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
- Developed various Error Handling Strategies for the successful run of the build packages.
- In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN 9.0.
- Advanced Microsoft excel Knowledge such as pivot, functions, macro and VBA script.
- Knowledge in connecting forms in VB to SQL or MS Access database.
- Created dynamic reports using SSRS, generated report models using report builder for the end users.
Environment: MS SQL Server 2012, SSIS, SSRS, T-SQL, Microsoft Visual studio 2010, Windows server 2008, Windows7, MS Office 2010, ASP.NET 3.5, C#/VB.NET,.
Confidential
MS SQL Server /SSIS/SSRS Developer
Responsibilities:
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures.
- Wrote data retention process for reporting database to keep 60 days report history.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
- Designed ETL packages to load data from multiple sources.
- Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
- Created SSIS Packages for feed process 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.
- Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
- Used SQL Server Reporting Services to generate reports by passing parameters through URL Developed reports.
- Worked with the QA and Production Team for setting the Configurations for the SSIS packages for Test and Production Deployment.
- Created staging, processing and QA environment on the server, and managed the daily job for the data processing across these environments
- Work closely with Business Management to prioritize business and information needs.
- Optimized the entire reporting system performance by tuning the procedure queries and build indexes in the Reporting system.
- Used Section access and Sheet access to make the application available to desired users.
- Modify existing Qlikview dashboard based on business requirement.
Environment: MS SQL Server 2008R2, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2008, MS Office 2007, QlikView 11, C#/VB.NET, Windows 7.
Confidential
MS SQL Server /SSIS/SSRS Developer
Responsibilities:
- Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
- Successfully Installed and configured MS SQL Server 2008r2 on the production server.
- Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
- Involved in designing system including tables, Stored Procedures, Indexes, UDF and triggers.
- Implemented SSIS (ETL) to extract and transform data from DB2, Oracle, RDBMS and Flat files/CSV, SQL Server 2008 instances and to load into staging and then to DW 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, lookup, fuzzy lookup, fuzzy grouping and merge join and derived column.
- Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
- Created and maintained PL-SQL scripts and stored procedures.
- Developed, tested, debugged and documented Oracle PL-SQL packages and types in accordance with company policies, company standards and industry best practices.
- Improved performance and stability of database systems.
- Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill- down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) also based on Business Requirement Document Designed and created Report templates, bar graphs and pie charts based on the financial data.
- Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
- Evaluated database performance and performed maintenance duties such as Tuning, Backup.
Environment: Microsoft SQL Server 2008r2, SSIS, SSRS, Microsoft Visual studio 2008, Windows server 2008, Windows 7.
Confidential
MS SQL Developer
Responsibilities:
- Designed and analyzed the SQL Server database and involved in gathering the user requirements.
- Logical and Physical design of database for project on basis of user requirements.
- Created new tables, stored procedures for Application Developers and some user defined functions.
- Performed data conversions from flat files into a normalized database structure.
- Created Triggers to enforce data and referential integrity.
- Defined Check constraints, Business Rules, Indexes, and Views.
- Extracted the data from Flat Files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse.
- Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables
- Used triggers and constraints to maintain the consistency of the databases.
- Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
- Modified the existing database by adding the tables and maintained relationships between the tables.
- Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server 2005 Reporting Services.
- Created report subscription using data driven subscriptions and setting up automatic delivery of user.
Environment: MS SQL Server 2008, Microsoft Visual studio 2008, Windows 2007, Erwin v7.0, Crystal Report 8.5