SUMMARY:

• Over 8 years of IT experience in Database Design, Development, Implementation and Support using various Databasetechnologies(SQL Server 2008/2012, 2016 T - SQL, Azure Big Data) in both OLTP, OLAP and data warehousing environments
• Expertise in SQL Server and T-SQL (DDL, DML and DCL) in constructing Tables, Joins, Indexedviews, Indexes, Complex Storedprocedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules
• Strong technical knowledge in SQL Server BIsuite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS and various 3rd party tools
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
• Experience managing Big Data platform deployed in Azure Cloud
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
• Experience in Monitoring and Tuning SQL Server Performance
• Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin, and other Data modeling tools
• Expert in creating, debugging, configuring, and deploying ETL packages designed MS SQL Server Integration Services (SSIS)
• Experience in configuration of report server and report manager for job scheduling, giving permissions to different level of users in SQLServer Reporting Services (SSRS)
• Experience in creating OLAP Data marts using SQL Server Analysis Server (SSAS)
• Experience in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions.
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Servicesusing multi-dimensional expression (MDX), mathematical formulas, and user-defined functions
• Responsible for creating Requirements Documentation for various projects
• Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease
• Experience in writing code in R for data loads, extracts, statistical analysis

TECHNICAL SKILLS:

Languages: Databases

Reporting Tools: ETL Tools

Other Tools: GUI

Web Languages & Scripting: SQL Server Programming 2008, 2012, 2016

Diagramming Tool: Methodology

Application: Miscellaneous MS Office Suite, Photoshop

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

SQL BI Developer (T-SQL, BI, Azure, Power BI)

Responsibilities:

• Installed SQL 2016 SQL server Database engine, SSIS & SSRS features in the Development environment as needed.
• Experience in dealing with ambiguities to create rational and functional solution from imperfect requirements
• Performed DB ADMIN activities on the Server by taking Back-up & restoring the DB, providing user access privileges, creating linked servers.
• Responsible for extracting the data from OLTP and OLAP using SSIS
• Worked with various tasks and transformations in Control flow and Data flow items
• Developed SSIS packages that can extract data from various sources and merge into one only source for Power BI reports
• Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables
• Worked in Creating DAX Expressions and implement Partitions in Tabular models
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
• Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers
• Created notifications and alerts, subscriptions to reports in the Power BI service
• Wrote Kusto queries to pull telemetry data for analysis
• Used R to extract the data from Cosmos and load it into SQL database
• Knowledge of managing security and metrics of the data presented using the Admin portal
• Used Visual Studio Team Services(VSTS) for version controlling, assisted in documentation, and creating data dictionary

Environment: SQL Server Management Studio 2016, Confidential Visual Studio 2015, VSTS, Azure SQL, Azure Storage Explorer, Azure Blob, Power BI Desktop, PowerShell, C# .Net, Avocado tool, Kusto, R

Confidential, Bellevue, WA

SQL BI Analyst (T.SQL, Teradata)

Responsibilities:

• Translated business requirements to technical definitions to help develop a solution for mapping scenarios.
• Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed map strategy
• Worked independently in troubleshooting the issues, data mining, data analysis and provide estimates for planned activities
• Worked in migration project to migrate customers from legacy rate plans to new rate plans using Alteryx tool
• Scheduled Alteryx modules and monitored the out coming data results
• Provided various mapping solutions based on the business need, troubleshoot the reasons for unmapped customers
• Used Teradata utilities fastload to load data
• Wrote views based on business reporting requirements, performance tuning and various complex SQL queries optimization
• Extensively used SQL Analyzer and wrote complex SQL Queries using joins, sub queries and correlated sub queries
• Created New SSRS Reports and did Adhoc changes/Fixes to the Existing Reports.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the Dev. Team if any stale data or ETL failed.
• Developed Power BI reports using Power Query from SharePoint&different Data sources.
• Monitor, Triage, Track and resolve issues with the Excel Power BI reports.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks
• Created Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed Event Types
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler, and third party tools
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports

Environment: Teradata SQL Assistant, SQL Server Management Studio 2008R2, Confidential Visual Studio 2008, SSRS, SSIS, Alteryx Designer 9.1, Teradata Fastload, Teradata FastExport

Confidential, Redmond, WA

SQL BI Developer (T.SQL, SSIS, SSRS, CRM)

Responsibilities:

• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings
• Involved in writing heavy T-SQL stored procedures, complex joins, new SQL2008 T-SQL features like Merge, Except commands
• Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server using SSIS using various features like ‘’mkdata conversion
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
• Involved in Creating User Security and RolesIn Reporting Services at both Parent Level and Report Level.
• Responsible for admin related tasks like adding users, backup and restore database, adding linked servers, Job scheduling, configured SQL server maintenance plans grant database access roles to the other users.
• Created and maintained various views and dashboards in Dynamics CRM
• Handled ad hock data requests and tickets for CRM,provided general production support for CRM related tickets

Environment: SQL Server Management Studio 2008R2/2012, Confidential Visual Studio, MS BIDS, SQL Server Data Tools, SSRS, SSIS, SSAS, Active Directory, .NET 2.0/3.5 Framework, MS Visio, Dynamics CRM

Confidential, GA

BI Developer (SSIS.SSRS.T-SQL)

Responsibilities:

• Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
• Provided input to technical solutions in architecture meetings determining project scope, tasks, timeframe, resources to provide project estimates for the BI Team Lead.
• Interaction with a variety of internal and external users to develop technical designs and reviews with the rest of the project team as appropriate.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Developed Stored Procedures to support ETLs and Reporting.
• Wrote T-SQL for the retrieval of the data. Identified the Data Source and defining them to build the Data Source Views.
• Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
• Developed Query for generating drill down reports in SSRS 2008. Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Created insert and update script to fix data problem, created database objects like View, Stored Procedures, and Functions. Check in Code into TFS (Source Control).
• Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2008 as assigned.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service

Confidential, Houston, TX

BI Developer

Responsibilities:

• Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs
• Point of contact for all Data processes, Data Mappings, Data dictionaries, Data pulls
• &reporting solutions
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server.
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Involved in User communication for requirement gathering and Change control and code control policies and procedures

Confidential, Irving TX

Data and Report Developer

Responsibilities:

• Used T-SQL queries and views based on business reporting requirements, performance tuning and various complex SQL queries optimization.
• Developed ETL packages using SSIS and stored procedure for data loading. Wrote Stored Procedures and modified existing ones and tuned them such that they perform well.
• Assisting with data cleansing and preparation to facilitate enhancement of existing databases and tools for analysis and decision making.
• Bug entry and reporting into Visual Studio.
• Testing various applications for bug regressions to be reported back to the Development Team Communicated with SDETs, senior leads, and project management on daily project statuses

Confidential, Temple TX

QA Tester

Responsibilities:

• Responsible for writing test scripts for the testing processes, involved in various techniques like data conversion, screen testing, user acceptance testing and functional module testing.
• Provided documentation for all kinds of test case scenarios.
• Fixed issues in the existing test cases.
• Provided general production support for tickets. Responsible for maintaining the accuracy and quality of the data.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in requirements gathering sessions with the users and Business Analysts to understand business analysis functions to be supported.
• Developed ETL packages using SSIS and stored procedure for data loading.
• Dropped and recreated the Indexes on tables for performance improvements.
• Developed roles, policies, and procedures for ensuring the security and integrity of the report.Fixed issues in the existing reports.
• Written technical design documentation for alterations to current business logic and future project designs.