SUMMARY

• Over 5 years of experience with SQL Server as Business Intelligence developer/Data Base developer.
• Designed and developed backend SQL Database objects such as Tables, stored procedures, Functions, Triggers, Views, index & roles.
• Used Joins, correlated and sub - queries for complex business queries involving multiple tables & calculations from different databases.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 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.
• Implemented Cleansing process and data profiling using DQS tasks in SSIS packages for detecting and correcting inaccurate data from the sources and to track data quality.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Strong ability in defining queries for generating drill down reports, parameterized reports and creating stylish report layouts in SSRS 2008/2012/2014/2016.
• Deployed reports, created report schedules and subscriptions.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Designed and implemented SSAS Tabular Cube and Used DAX scripting to access data from Tabular Model.
• Designed and implemented Row Level Security & Roles for SSAS Tabular Model And deployed into SQL Server Analysis Server 2016.
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service.
• Worked in Agile/Scrum Methodology with daily stand up meetings and great knowledge in Confidential ( Confidential )
• Problem solver, team player, detail-oriented and quick learner.
• Strong analytical and interpersonal skills as well as work ethics. Also, effective at meeting project objectives & deadlines while working under pressure.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008/R 2/2012/2014/2016, Azure SQL Database, Oracle 9i, PL/SQL, T-SQL, MS Access, MongoDB

SQL Server Tools: Enterprise Manager, Query Analyzer, Export & Import (DTS), Business Intelligence Development Studio (BIDS), ETL Tools, SQL Profiler, SSIS, SSRS, Power Pivot

Programming Languages: C#, C++, Java, JSON, PowerShell

Platforms Windows, UNIX: Methodologies Agile, Scrum, RAD, SDLC, Waterfall

Operating Systems: Windows XP/7/8/10, Windows Server 2003/2008

Application: Word, Excel (PowerPivot), Access, PowerPoint

PROFESSIONAL EXPERIENCE:

SQL Database Engineer

Confidential, Redmond, WA

Responsibilities:

• Managed crisis situations that may involve technically challenging issues and diverse audiences.
• Automate database creation, scaling up/down, enabling auditing and treat detection using PowerShell and ARM template
• Design and write elastic queries to access data across database
• Configure database replication from on premises to Azure SQL DB
• Configure data sync and migration of database to and from Premise /Azure SQL DB
• Database performance tuning, connection troubleshooting.
• Query performance tuning using SQL sentry.
• Worked on Azure SQL/on Premise Replication/ geo replication.
• Use trace analysis, debug skills, source code, and other proprietary tools, to analyze problems and develop solutions to meet business requirement needs including rewriting code.
• Azure SQL Automation using PowerShell /runbook for back up, service tier change, performance tuning
• Created logins/ users/security groups using active directory authentication and SQL server Authentication
• Deployed Azure SQL databases and other Azure settings using PowerShell and Json

BI Developer

Confidential, Seattle, WA

Responsibilities:

• Designed and developed backend SQL Database objects such as Tables, stored procedures, Functions, Triggers, Views, index & roles.
• Used Joins, correlated and sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 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.
• Implemented Cleansing process and data profiling using DQS tasks in SSIS packages for detecting and correcting inaccurate data from the sources and to track data quality.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Strong ability in defining queries for generating drill down reports, parameterized reports and creating stylish report layouts in SSRS 2016.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Designed and implemented SSAS Tabular Cube and Used DAX scripting to access data from Tabular Model.
• Designed and implemented Row Level Security & Roles for SSAS Tabular Model And deployed into SQL Server Analysis Server 2016.
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Experience in working in SCRUM/Agile development process model.
• Create reports in Power BI utilizing the SSAS Tabular Model & multi-dimensional Cubes via Analysis connector.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service.

BI Developer

Confidential, Silver Spring, MD

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2008R2/2012, Oracle, .CSV, Excel and Text file from Client servers through FTP.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process of pulling data from different sources.
• Created SSIS packages for file transfer from one location to the other using FTP and Scrip tasks.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different databases.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Utilized several Transformations like Lookup, slowly changing dimension for implementing the Transformation Logic in the Packages.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion, Derived Column, Fussy Lookup and Fussy Grouping.
• Created Jobs and scheduled Packages using SQL Server Management Studio for Daily and Hourly Loads.
• Created Alerts for successful or unsuccessful completion of scheduled jobs.
• Supported an enterprise database infrastructure with hundreds of databases.
• Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality.
• Experience in working in SCRUM/Agile development process model.
• Experience on Power Pivot, Power View and Power Query.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Managed relationship between tables in Power BI using star schema.
• Experience on publishing Power BI reports on dashboards in Power BI server.

Database Developer

Confidential

Responsibilities:

• Involved in gathering business requirements and Installation and configuration of SQL Server.
• Created database, tables, writing stored procedures for developers and users.
• Created SQL scripts and defined functions, check constraints, indexes, and views.
• Created triggers to enforce data and referential integrity.
• Create new SSIS package (2008R2) to extract the date from legacy to SQL Server objects.
• Extensively used SSMS and SSIS Import/Export system for performing ETL operations.
• Performed data conversion from a flat file and excel into a normalized database structure.
• Developed, monitored and deployed SSIS packages (2008R2) and Configured Server for sending automatic emails and Generated Snapshot,
• Drill Down, and parameterized reports using SSRS
• Prepared Ad-hoc reports through report builders and published through Report Manager.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users in report manager and server.
• Design and created different types of reports like Sub Reports, Drill-Through, Cascading, Drill -
• Down, ad-hoc Reports in visual Studio and deploy and manage on Confidential SQL Server Reporting Services Configuration Manager.
• Worked on Advanced Excel functions using large data set