Data Sql Server

SUMMARY

Over three plus years of experience in database design, development, administration, and support of MS SQL Server and Business Intelligence applications. Having expertise in writing T-SQL Queries, sub-queries and complex joins for generating stored procedures, triggers, user-defined functions, and views. Adept in using SSIS to create ETL Packages to validate, extract, transform and loading data into target database tables from heterogeneous sources including OLEDB database tables, excel, csv, flat file, text format data, and legacy systems. Effective in the design, development and deployment of SSRS reports. / Data

TECHNICAL / FUNCTIONAL SKILLS

Experience in MS SQL Server 2012/2014/2016 suite of products like SSIS, SSRS and SSAS.

Experience in RDBMS Concepts, database management systems, database physical and logical design, data mapping, table normalization and data modeling.

Working knowledge in T-SQL queries (DDL and DML) for developing complex stored procedures, batch scripts, triggers, tables, views, relational database models and data integrity, and SQL joins.

Knowledge in data profiling and optimized queries using query execution plan.

Capabilities in working on OLAP, OLTP platforms, developing reports, performing data cleansing, data scrubbing, and data migration related tasks using SSIS.

Efficiencies in developing SQL Server SSIS packages for importing, transforming and loading data from diverse heterogeneous sources into intended destination tables.

Develops MDX Scripts for querying cube data and validating against BI client application used in reporting.

Working knowledge on cube partition creation, dimension hierarchy creation, within SSAS cubes dimensions and then processing and deploying the SSAS objects.

Experience in gathering business requirements and converting them into technical requirements.

Develops and maintains SSRS reports including interactive drill down reports, report models and parameterized reports.

Good understanding of SSRS with report authoring, report management and report delivery.

Works on Helpdesk Ticket resolution on production-related issues daily.

Excellent communication skills, organizing skills, highly punctual and an excellent listener.

PROFESSIONAL EXPERIENCE

Data Analyst / SQL Developer

Polaris, Plymouth, MN (02/2018 – Present)

Optimize the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Create and optimized database objects such as views, functions and stored procedures.

Develop SQL scripts to insert, update and delete data in MS SQL Server OLTP database tables.

Creates different SSRS reports based on requirements provided by the various business units.

Create standardized SSRS portrait and landscape report templates used in report development.

Create complex stored procedures with parameters and generated multi parameterized SSRS reports from them, whereby the user has option for selecting parameters of choice.

Create and updates both clustered and non-clustered indexes for effective SQL Server performance.

Design and creates ETL Packages in SSIS to extract, transform, validate and loading data.

Use different transformations such as Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.

Transfer data from various data sources systems including MS Excel, MS Access, flat files to SQL Server using SSIS.

Create and deploys SSIS packages and scheduled the jobs to run automatically.

Provide logging, error handling by using event handler, and custom logging for SSIS Packages.

Design ETL packages for ad hoc data transfers using the SSIS Import/Export wizard.

Create dashboard reports using Power BI Desktop.

Environment: SQL Server 2012/2014/2016, SSIS, T-SQL, SSMS, SQL Server Data Tools, Excel 2013/2016, SharePoint 2013, Power BI, Visual Studio 2013/2015, Helpdesk Ticketing, Microsoft Teams.

Junior ETL Developer

SPIRE Credit Union, Falcon Heights, MN (03/2016– 02/2018)

Extensively used T-SQL to manipulate and architect to produce results for users.

Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.

Developed SQL Queries used in fetching complex data from different database tables using joins and using output in SSRS report dataset.

Created Tabular Matrix reports, Charts and graphs per user requirements using SSRS.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Assisted in designing and deploying SSIS packages for data transformation and loading.

Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on monthly and weekly basis.

Performed data cleansing, analysis and interpretation.

Created and optimized ETL workflows by translating business requirements into ETL specifications.

Environment: SQL Server Management Studio, SQL Server Profiler, Advanced Excel, Import & Export Wizard, MS Visual Studio, Microsoft Access, SQL Server Data Tools, MS Visio.

EDUCATION

Colorado Technical University

Master’s in Computer Sciences (Data Sciences) – In Progress

Bachelor’s Degree in Law.

Contact this candidate