Harika Vallala: SQL Server/Power BI Developer

Responsibilities: • Interacted with business resources on a daily basis for analyze business processes, requirements progress and deliverables. • Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow. • Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS • Prepare source to target mapping data, like claims, insurance and provider related data. • Designed and documented the entire Architecture of Power BI POC • Expertise in writing complex DAX functions in Power BI and Power Pivot. • Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages. • Worked on Data Warehouse Modeling with SQL Server Analysis Services (SSAS). • Involved in automating SSIS Packages using SQL Server Agent Jobs. Generated Parameterized reports, Sub reports, Drill down and Drill through reports using SQL Server Reporting Services (SSRS) working along with MDX queries. • Worked on all types of transformations that are available in Power bi query editor • Created stored procedures and SQL queries to pull data into power pivot model. • Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution. • Imported Data from various sources such as SQL Server, SQL DB, SQL Server Analysis services, Excel etc. Worked on data modelling in Power BI. • Tune SQL statements using hints for maximum efficiency and performance, create and Maintain/modify PL/SQL Packages, mentor others with the creation of complex SQL Statements, perform data modeling and create/maintain and modify complex database Triggers and Data Migration scripts. • Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing. • Utilized Power BI Gateway to keep the dashboards and reports up to date. • Configuring Power BI Gateway for SSAS live connection. • Developed complex DAX Queries to generate computed columns. • Storage development and design utilizing Blobs, Tables, Queues, Files • Developed and published reports and dashboards using Power BI. • Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services. • Weekly presentation to the business users about the reports and their changes as required. Tools and Technologies:MS SQL Server 2014,Visual Studio 2013, SQL Server Integration Services (SSIS), Data Warehouse, Power BI,Informatica Power Center 9.5.1, Oracle 11g, SQL, Unix, Windows 10, MS Office, MS Visio, C#, Erwin 9.2 Data Modeling, Share Point, Team Foundation Server (TFS), ERP, CRM software, Widows server 2012, Linux server.

Responsibilities: • Assisted in Business Analysts to gather technical requirements. • Developed Tables, Views, and Stored Procedures using SQL Server Management Studio. • Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination. • Published reports on Power BI services, shared dashboards utilizing within the office 365. • Created many complex database code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance. • Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS). • Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS. • Work with Service Management teams to establish and monitor service level agreements, communication protocols with data suppliers and data quality assurance policies. • Provide data quality advisory services to clients and to internal stakeholders. Recommend maintenance enhancements to data acquisition processes to improve accuracy of data warehouse data. • Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing. • Provide technology options and recommendations to solve for business challenges, Strong knowledge of database and system performance monitoring. Ability to share and communicate ideas both written and verbally to staff at various levels within the organization in a clear and concise manner that is relevant to each level. • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. • Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning. • 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. • Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task Failed Event Types. • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. • Created indexes on the tables for faster retrieval of the data to enhance database performance. • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE. • Installation of SQL Server 2008R2,2012 and 2014 with specific requirements, performed hardening and post provisioning to ensure standard and security • Configuring HA and DR solution including Replication, mirroring, and log shipping • Always On Availability groups and Failover Clustering installation and Configuration SQL 2012 and SQL 2014 • Extensive experience in database backup and restoring in testing production environment • Experience creating and rebuilding indexes • Experience creating scheduled jobs and maintenance plan • Updated statistics with full scan on a weekly basis to make sure that the query optimizer uses the most recent statistics • Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands to find the slow running queries to get the performance metrics and performance tuning • Used SQL Server Profiler(Tracing), Perfmon and windows task manager to monitor query performance and SQL Server resource utilization

Tools and Technologies: MS SQL Server 2014/2012,Visual Studio 2013,2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Microsoft SharePoint, MS Project, VBA, MS Office ,ERwin 9.2 Data Modeling, ALM for QA testing and Software Development Life Cycle (SDLC) Client: Blue Cow Software, Lynnfield, MA Nov 2016-Dec 2018 Role: MSBI Data Warehouse Developer Responsibilities: • Worked with the Claim Search group, this group deals with claims and special investigative units on applications that effect the clients directly along with revenue generation. • Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors using SQL Server Management Studio. Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance. • Implemented OLAP Cubes, Facts and Dimensions for providing summarized and aggregate views of large sets of data.Designed Cube partitioning and incremental synchronization for Tabular, OLAP, SSAS cubes. • Created SSIS Packages using SSIS Designer to export heterogeneous data from OLEDB Source, Excel Spreadsheet to SQL Server 2005. • Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service. • Developed all the required T-SQl work using MS Management Studio. • Experience in creating multiple reports (SSRS) in Drill mode (Drilldown and Drill through) and also Parameterized Reports. • Worked on SSIS Packages, changed Structure of tables and created new Columns during transformation using SSIS packages. • Developed reports using SSRS, Excel (Pivot) that could be used to send information to diverse groups. • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, partitions, facts, dimension tables using MS Analysis Services. • Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration. • Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse. Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts. • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge Joins, Fuzzy Look Ups, Script task and Send Mail task etc. • 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. Tools and Technologies: MS SQL Server 2014,Visual Studio 2013, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Warehouse, MS Office, MS Visio,ERwin 9.2 Data Modeling, Tibco Spot Fire Dashboard, Red Hat Linux, Putty, Java, Share point, XML, .NET framework, DMReader, Service Now, TriZetto, Citrix, Service Catalog.