SUMMARY

• Knowledge of relational database on SQL Server management studio (SSMS), SSRS, and SSIS. In - depth knowledge of relational database and SQL procedures including writing complex SQL queries, backups, restores and recovery models and performance tuning techniques.
• Knowledge on creation of Databases Objects, Schemas, Triggers, Views and User Defined Functions.
• Experience in Constraints, rules, and default setting, Primary, Foreign, Unique and Default key.
• Developed joins and Sub-Queries to simplify complex queries involving multiple tables.
• Experienced in Temp tables, table variables and CTEs to enhance performance of queries.
• Created and updated Clustered and Non-Clustered Indexes to keep upSQLServer Performance.
• Well versed in Normalization/ De-Normalization techniques both in OLTP and OLAP system.
• Experienced in using Try Catch block introduced inSQLServer 2005 and error handling.
• Great deal of experience on authoring, managing, and deploying enterprise, ad-hoc, advanced and interactive reports using SQL Server Reporting Services.
• Expert in Data warehouse/Data mart environment Data Extraction, Transforming and Loading (ETL) using various tools such asSSIS, DTS, Bulk Insert, BCP, data cleansing and profiling.
• Well experiencedusing different transformations tools like Aggregate, Cache Transformation, Character map, Conditional split, Copy column, Sort column, Data conversion, Derived column, Merge, Merge join, Union all, Lookup, SCD, Import and Export column and OLE DB command.
• Implementation of point in time backup and recovery of databases, executing package, deployment, scheduling and managing jobs on SQL Server Agent and maintain good documentation.
• Managed and maintained user’s security and permissions; and migrate database objects from one server to another server and database to another database.

TECHNICAL SKILLS

Databases: MSSQL Server 2008R 2/2012/2014/2016/2017

Programming Languages: T-SQL

SQL Server Tools: SSMS, SSIS, SSRS, SQL Profiler, SQL Server agent, Configuration Manager

Development Environment: SSDT/ Visual Studio 2005/2008/2012/2016

Data Warehouse (ETL)Tools: SQL Server Integration Services (SSIS), DTS

Reporting Tools: SQL Server Reporting Services (SSRS), Power BI

Operating Systems: Windows XP/2003/2008 Server, win 95/98, Vista, Win 7

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer | Data analyst

Responsibilities:

• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Involved in developing mainly Microsoft BI Stack solutions.
• Automated SSIS Packages and reports to improve reliability and reduce production time.
• Developed new and enhanced existing database objects and SSIS packages to advance functionality and automation of systems.
• Designing, expanding, maintaining, and monitoring the functionality of ETL anddatabase schemas.
• Configured SSIS packages to validate, extract, transform and load data to data warehouse and data mart databases.
• Developed SSIS packages that would transfer data among servers and perform data transformations like data conversion, aggregate, look up, router, sort and join using flat file and excel file source.
• Loaded Type 1 and 2 SCD (Slowly Changing Dimensions) in SSIS to Multi-Dimensional Data Marts.
• Developed efficient mass update system in SSIS to avoid manual updates to data warehouse.
• Deployed, scheduled, and monitored SSIS packages and created corresponding Job in SQL Server Agent.
• Created different types of reports based on customer request and business requirement.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie and bar charts.
• Configured SSRS and effectively use appropriate Data sources and Dataset.
• Designed and Created SSRS Sub Reports, Cached, Linked, Drill-Through, Cascading, Drill-Down, Ad-hoc Reports and set properties like Chart Controls, Filters, Interactive Sorting and Parameters.
• Deploy Report onSQL Server Reporting Server and manage on Microsoft SSRS Configuration Manager.
• Created SQL Stored Procedures, Triggers, Functions, Views, and Indexes in SQL Server.

Confidential

SSIS/SSRS Developer

Responsibilities:

• Worked across multiple company departments to improve product reliability, reduce production time, automate reporting, and minimize waste.
• Involved in gathering business requirements.
• Worked with networking team on network connectivity and file sharing using Active Directory.
• Facilitated file sharing and correspondence tracking with SharePoint.
• Created SSIS packages to extract data from legacy toSQLServer objects.
• Designing, testing, and loading data into a data warehouse environment.
• Configured Server for sending automatic mails.
• Involved in performing deployment and back up mechanisms and managed jobs on SQL Server Agent.
• Responsible for migrating folders and sessions from development server to test environment.
• Data migration using DTS services across different databases like MS Excel, Access, and FlatFiles.
• Extensively used SSMS and SSIS Import/Export system for performing ETL operations.

Confidential

Business Intelligence | Power BI Developer

Responsibility:

• CreatedSSIS packages to extract data from different source then transform and load into the database.
• Used various SSIS transformations such as conditional split, look-up table and derived column for data scrubbing and validation during staging, before loading the data into data warehouse.
• Used SSIS to implement slowly changing transformation and maintain historical data in data warehouse.
• Involved in SSIS package troubleshooting, error logs, checkpoints, breakpoints, and data viewers.
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent
• Designed, deployed, and monitored various SSRS Reports inSQLServer.
• Delivered multiple BI reporting solutions in Power BI reporting services and used DAX functions.
• Utilized power BI to create various analytical dashboards that demonstrate order history divided into multiple category and billing summery along with slicers enabling end users to make filters.
• Installed and configuredmultipleSQLServers, clients, Databases, and objects.
• Installed and configured new recovery server and implemented high availability solutions.
• Set and provide appropriate security and permission to users on Configuration Manager based on the organization policy and regulations.
• Worked with Data Architects, DBAs, and Business Intelligence teams in designing and supporting end-to-end data solutions across multiple platforms.