PROFESSIONAL SUMMARY:

• 5 years of IT experience as a MS SQL Server Developer 2016/ 2014/2 in various Industry verticals like Finance, Health Care and Insurance.
• Generating reports by pulling data from SQL tables to Azure SQL Database.
• Experience creating Power BI reports and Dashboards using Power BI Desktop & Web Interface.
• Experience with COSMOS, SCOPE and Cosmos Power Shell.
• Experience developing, analyzing and deploying Tabular Model cubes.
• Experience in Installation and Configuration of SQL Server 2016/2012/2008/2005.
• Experience in T - SQL queries (DDL, DML) creating and managing the databases and all the database objects.
• Excellent in using all kinds of SQL Server Constraints and Dynamic queries.
• Highly proficient in the dealing with complex Stored Procedures, Views, Data Import/Export, System Views and functions.
• Strong Experience in writing, debugging, fine-tuning and optimizing complex Stored Procedures, Cursors and Triggers in SQL Server by analyzing the Query Execution Plan and using the Profiler.
• Highly experienced in complete cycle of SQL Server Integration Services ( 2016/ 2014/2 ), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Scheduling and Monitoring ETL processes using DTS Exec utilities and batch files.
• Strong knowledge on Row Transformations, Partial Block and Block Transformations.
• Experience in Development, Deployment and Troubleshoot Reporting services using SSRS 2008 /2005 across various environments.
• Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2008 R2/2008/2005, Crystal Reports and MS Excel for the analyzing data at an enterprise level.
• Analyze large data sets and patterns using T-SQL, Power BI , advanced Excel models like PowerPivot and Power Query.
• Experience in creating Ad-hoc reports and data driven subscription reports by using Report Builder.
• Experience in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Experience in data architecture design and used data modeling tools like Erwin for designing the logical and physical data models.
• Developed a thorough knowledge in understanding business processes, gathering requirements, and coordinate ongoing iterative development of Software Development Life Cycle (SDLC).
• Excellent analytical, Communication and interpersonal skills.
• Proficient in technical writing, presentations and a good team player.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005/2008/R 2/2012/2014/2016 , Azure SQL Database, Access, Oracle10g.

Database Tools: BIDS 2005/2008, SSDT 2012, Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer, SQL Profiler, TFS.

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

Programming Languages: SQL, T: SQL, PL/SQL, VB.NET, C#.NET, ASP.NET, C, C++.

ETL Tools: SQL Server Integration Services (SSIS), Import/Export Wizard, Bulk Insert, BCP.

Scripts: PHP, JavaScript, CSS, VBScript, C#, HTML and XML.

Applications: Confidential Office 2000/2003/2007.

Operating systems: Windows 2000/XP/2003/2008.

Reporting Tools: Power BI, SSRS, Report Builder, Business Objects, Crystal Reports.

EXPERIENCE:

Confidential, Redmond, WA

SQL Server Developer/Cosmos Developer

Responsibilities:

• Gather business requirements and translate them to technical requirements.
• Create Cosmos scripts which pulls data from upstream structured streams and include business logic & transformations to meet the requirements.
• Modify the existing cosmos scripts to in corporate the new business changes and validate the same.
• Develop Daily Generic Useraction scripts for Office products according to business requirements.
• Add the new cosmos scripts into the workflow.
• Test the cosmos scripts and workflow in the INT environment.
• Deploy the scripts and workflow to Production environment.
• Schedule and monitor the cosmos jobs using XFLOW.
• Troubleshoot the failed cosmos job and fix the issues in timely manner.
• Schedule Sangam Jobs to pull in the raw data from the source into our VC.
• Develop the scripts which push the data from the cosmos output streams into SQL Server Databases.
• Maintained all the source code in the GIT. Help team member while pushing their code changes to GIT.
• Migrated, Tested and Productionalized all User Conversions cosmos scripts from old OneRM system to Iris Insights system.
• Work on ad-hoc request from the customers on priority basis.
• Investigate data discrepancies and find the root cause using iScope.
• Proactively work on analyzing and validating data from power bi and check with our source for any possible errors.
• Monitor all the workflow jobs daily.

Environment: MS SQL Server 2016/14 (Query Analyzer, SQL Profiler), SSDT, SSIS, SSAS, SSRS, ETL, SQL Server Management Studio, MS Excel, Windows 2008, GIT, VS2015.

Confidential, Spokane, WA

SQL BI Developer

Responsibilities:

• Installed and Configured MS SQL Server 2016.
• Design and develop database and database objects like, Tables, Views, Stored procedures, Functions and complex T-SQL/queries.
• Designed, developed, and delivered business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (MDX), and Reporting Services (SSRS).
• Design and develop multiple ETL packages to pull the data from source like cubes and SQL, use
• Transformations and load it into SQL Database.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Working with Power BI Gateway to schedule daily job to refresh data.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Created multiple Power BI Reports and Dashboards.
• Created appropriate documentation for deployment and build activities.
• Develop multiple Tabular Model Cubes.
• Built Power BI reports using SSAS tabular model.
• Implement security by creating roles and adding necessary Security Groups.
• Implement row level security and provide Cube maintenance.
• Developed a DQ Monitor using PowerShell which sends out a daily status email.
• Develop Dashboard using New Power BI Tool.
• Create reports using the Desktop App and Service with Tabular Model.
• Share the Dashboard individually and also using Content Pack.
• Create Power Pivot Data Models and develop Power views out of it and host on the SharePoint.

Environment: MS SQL Server 2016/14 (Query Analyzer, SQL Profiler), SSDT, SSIS, SSAS, SSRS, ETL, SQL Server Management Studio, MS Excel, Windows 2008, TFS.

Confidential, Bellevue, WA

SQL Server BI Developer

Responsibilities:

• Installed and Configured MS SQL Server 2014.
• Created Database Objects like Tables and Stored Procedures in Azure Data warehouse.
• Set up Development, Test and Production environments.
• Create pipelines from Source to Azure Destinations.
• Develop ETL workflow, to pull from different sources and load the same into Databases.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task and different data flow tasks using T- SQL
• Support Reporting Team with the requests and analysis.
• Extracted data from a staging database and perform the various transformations and load data into the Data Warehouse Database
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database
• Develop Power BI reports using Power BI Desktop App
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Troubleshoot the data inaccuracies using COSMOS SCOPE scripts and automate the same.
• SQlize Cosmos Stream into SQL Tables.

Environment: MS SQL Server 2014/2012/2008 , Azure SQL server, TFS, Query Analyzer, Windows 2008, SSIS, SSAS, Excel, Oracle10g.

Confidential, Pittsburgh, PA

SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2012.
• Create Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Create Views to maintain security of customer data.
• Create Power Pivot data model using the linked tables and pulling data from different sources (SQL DB, Analysis Services) and creating the mappings between the dimensions and the facts.
• Create calculated measures using DAX and then develop Power View reports and host it on share point.
• Schedule the power pivot data model refresh on the SharePoint.
• Developed Tabular Model cubes from dimension and fact tables and create relationship between tables.
• Create calculated columns, Measures and KPIs using DAX expressions
• Deploy Tabular Model cube to production and schedule a job for daily refresh.
• Install and Configure ASConnector/Enterprise Gateway for Power BI
• Develop Power BI reports using Power BI Desktop App.
• Create Work group space for the team to collaborate and develop Power BI reports.
• Deploy Power BI reports to Web service and develop Dashboards.
• Share Dashboard with users and other teams using the security groups.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Involved in the design, development and maintenance of different cubes using SSAS.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Created partition function, schema and file groups for fact tables.
• Implemented Unit Tests and Integration Tests.

Environment: MS SQL Server 2012/2008, TFS, Query Analyzer, Windows 2008, SSAS, Excel, Oracle10g.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases.
• Implemented batch processing using Jobs and SSIS.
• Migrated data from Flat files to SQL server 2005 using SSIS.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: SQL Server 2005, MS Access, MS EXCEL, T-SQL, Windows 2003 server.