SQL Server/Power BI Developer

IT & Technology

• 4+ years of strong MS SQL Server BI Developer experience with expertise in MS SQL Server 2016/2014/2012/2008 suite of products like SSIS, SSRS and SSAS.
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2014/2012/2008, Visual Studio 2013,2010 Microsoft Access 2007-97, SQL Databases.
• Highly proficient in the use of T-SQL and ETL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014.
• Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications.
• Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.
• Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators.
• Extensive experience in using Oracle seeded packages like DBMS_OUTPUT, DBMS_SCHEDULER, UTL_FILE, DBMS_SQL and DBMS_STATS.
• Expertise in handling errors using Exceptions with RAISE application clause.
• Extracted data using SSIS from OLTP (Tabular) to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Expertise in creating databases, users, tables, triggers, views, stored procedures, functions, Packages, joins and  indexes in database.
• Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS).
• Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger) with Strong understanding of OLAP and OLTP Concepts.
• Have basic knowledge on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

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

Role SQL Server BI Developer

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.

MSBI Data Warehouse Developer

Find out detailed information about Harika Vallala, SQL Server/Power BI Developer 

Harika Vallala: SQL Server/Power BI Developer

Harika Vallala

SR UNIVERSITY