SUMMARY

• 7+ years of IT experience as a MS SQL 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 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.
• Experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• 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 Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• 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 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.
• Schedule jobs using Zena agents.
• 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.
• 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.

TECHNICAL SKILLS

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

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, Zena.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Sr. SQL Developer

Responsibilities:

• Gather business requirements and translate them to technical requirements.
• Create scripts which pulls data from upstream sources and include business logic & transformations to meet the requirements.
• Modify the existing cosmos scope scripts to in corporate the new business changes and validate the same.
• Develop new test case scope scripts for Bing Maps Team based on request for new validation requests from business.
• Execute the onboarded testcases for release validation tests for every release and generate reports for downstream partners.
• Use the processed data to generate Metrics and compare between previous vs new release and send reports to business.
• Test the cosmos scripts in the INT environment.
• Deploy or onboard the new testcase scripts to Production environment.
• Develop the scripts which push the data from the cosmos output streams into SQL Server Databases.
• Experience working with Azure SQL Database Import and Export Service.
• Experience in deploying SQL Databases in AZURE.
• Design and developed SSIS packages using different Control flow tasks, Transformations and Dataflow tasks.
• Automate the SSIS Packages using the Azure Data Factory and troubleshoot the SSIS packages whenever necessary.
• Transfer data from various data sources/business systems including MS Excel, MS Access, Flat Files to SQL Server usingSSIS.
• Refresh Power BI dashboard after every release with new data uploaded from Azure SQL DB.
• Monitor, Triage, Track and resolve issues with the Excel Power BI reports.
• Maintain all the source code in the GIT.
• Schedule and monitor the cosmos jobs.
• Troubleshoot the failed cosmos job and fix the issues in timely manner.
• Work on ad-hoc request from the customers on priority basis.

Environment: MS SQL Server 2016/2014, SSDT, SSIS, SSAS, SSRS, ETL,SQL Server Management Studio, MS Excel, Windows 2008, Azure Data Lake, Azure Data Factory, Azure SQL DB, JIRA, TFS, GitHub, Bit bucket, Source Tree, Office 365, SCOPE, VS2017/2015.

Confidential, Atlanta, GA

Sr. SQL Developer

Responsibilities:

• Gather business requirements and translate them to technical requirements.
• Create database objects tables, indexes, views, store procedures, and functions for data extraction from staging tables to dimension tables and fact tables.
• Develop ETL workflow, to pull from different sources, transform and load the same into Databases.
• Use various advanced SSIS functionalities like complex joins, conditional splitting, and column conversions for better performance during package execution.
• Create and Improve performance of T-SQL stored procedures.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Work on upgrading of Oracle databases from 11g to 12c.
• Work on building and rolling out new 12c databases for Test/Dev/QA environments.
• Generate server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Participate in the full development life cycle, end-to-end, from design, implementation, and testing, to documentation, delivery, support, and maintenance and producing comprehensive, usable dataset documentation and metadata using JIRA.
• Maintain all the source code in the GIT. Help team member while pushing their code changes using GIT.
• Commit the SQL code using Source tree into the Bit bucket.
• OptimizedSQLqueries, stored procedures for maximum efficiency.
• Identify, test, and resolve database performance issues (monitoring and tuning) to ensure database optimization.
• Deploy environments/applications fixes, patches, improvements.

Environment: MS SQL Server 2016/2014, SSDT, SSIS, SSAS, SSRS, ETL,SQL Server Management Studio, MS Excel, Windows 2008, JIRA, GitHub, Bit bucket, Source Tree, Office 365, VS2015/2012.

Confidential, Richardson, TX

Sr. SQL BI Developer

Responsibilities:

• Gather business requirements and translate them to technical requirements.
• Create database objects tables, indexes, views, store procedures, and functions for data extraction from staging tables to dimension tables and fact tables.
• Set up Development, Test and Production environments.
• Develop ETL workflow, to pull from different sources, transform and load the same into Databases.
• Use principles of Normalization to improve the performance. Involved in ETL code using PL/SQL to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Design SSIS packages for synchronizing the data between two different servers.
• Use the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Create PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Implement 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Create PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.
• Modify the existing scripts to in corporate the new business changes.
• Responsible for creating SQL datasets forPowerBIreports.
• Create multiplePowerBIReports and Dashboards.
• Create new Zena processes, tasks, variables, and logins in Zena and schedule them.
• Deploy Zena packages to Production environment.
• Create database table partitions, functions, and schemes to enhance performance and troubleshooting.
• Support Reporting Team with the requests and analysis.
• OptimizedSQLqueries, stored procedures for maximum efficiency.
• Identify, test, and resolve database performance issues (monitoring and tuning) to ensure database optimization.

Environment: MS SQL Server 2014/2012, Oracle 11g, SSDT, SSIS, SSAS, SSRS, ETL,SQL Server Management Studio, MS Excel, Windows 2008, JIRA, GitHub, Office 365, VS2015/2012.

Confidential, Redmond, WA

SQL 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 User-action 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.
• Migrate, Test and Productionalise all User Conversions cosmos scripts from old One-RM 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: MSSQLServer 2016/14 (Query Analyzer,SQLProfiler), SSDT, SSIS, SSAS, SSRS, ETL,SQL Server Management Studio, MS Excel, Windows 2008, GIT, VS2015.

Confidential, Spokane, WA

SQL BI Developer

Responsibilities:

• Install and Configure MS SQL Server 2016.
• Design and develop database and database objects like, Tables, Views, Stored procedures, Functions and complex T-SQL/queries.
• Design, develop, and deliver business intelligence solutions usingPowerBI, 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.
• Monitor performance and optimizedSQLqueries for maximum efficiency.
• Fine-tuneSQLQueries for maximum efficiency and performance.
• Work with Power BIGateway to schedule daily job to refresh data.
• Explore data in a Variety of ways and across multiple visualizations usingPowerBI.
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports.
• Create multiplePowerBIReports and Dashboards.
• Create appropriate documentation for deployment and build activities.
• Built Power BIreports using SSAS tabular model.
• Implement security by creating roles and adding necessary Security Groups.
• Develop Dashboard using New Power BI Tool.
• 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: MSSQLServer 2016/14 (Query Analyzer,SQLProfiler), SSDT, SSIS, SSAS, SSRS, ETL,SQL Server Management Studio, MS Excel, Windows 2008, TFS.

Confidential, Bellevue, WA

SQL BI Developer

Responsibilities:

• Install and Configure MS SQL Server 2014.
• Create 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.
• Perform ETL operations to support incremental, historical data loads and transformations using SSIS
• Use 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.
• Extract data from a staging database and perform the various transformations and load data into the Data Warehouse Database
• Create 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
• Schedule Jobs using SQL Server Agent.
• Identify, test, and resolve 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

Jr. SQL Developer

Responsibilities:

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

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