Home

Shamika - SQL BI Develoepr

[email protected]

Location: Los Angeles, California, USA

Relocation: Any

Visa: H1B

ABOUT ME: Senior MSBI / SQL Developer, Technology enthusiast, I have over 9+ years of experience working with MSBI. Currently, I work as Power BI/SQL Developer improving products and services for our customers by using advanced analytics, standing up big-data analytical tools, creating and maintaining models, and onboarding compelling new data sets, writing SQL, stored procedures, Functions, Triggers packages as per business logic In my current role, I develop, derive data in sights and enhance customer experience by leveraging Microsoft BI capability with Advanced SQL queries with multi-table joins, group functions, subqueries. Focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence with SQL Server, MSBI (SSIS/SSRS). Proficient in Visual studio ETL. Deep understanding of the Data Warehousing SDLC and architecture of ETL, and reporting and BI tools. Developed jobs in visual studio for various sources using different components for achieving the required transformations and loaded output data to the databases using input and output database components. Business Insights & Reporting, Data Analytics, Data processing, Data Visualization, Business Intelligence Tools (MSBI), Data Strategy, Database Architecture & Warehousing, Data Management and Power BI. Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting. SQL Server / Azure SQL Database Azure Synapse Analytics SQL Performance Tuning & Optimization Data modeling, OLTP/OLAP Azure Data Factory ADF / ETL / ELT / SSIS Azure Data Lake Storage Azure Databricks Power BI / SSRS PROFESSIONAL SUMMARY Microsoft BI Developer (SQL Developer with Analytics) 9+ Years of experience in MS Power BI, SSRS, SSIS, SSMS, Visual Studio), MSBI Suite, Oracle with experience in building data solutions using SQL Server, MSBI and Azure Cloud with strong SQL capabilities. 3+ years of experience in Azure Cloud, Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure Analytical services, Azure Cosmos NoSQL DB. Build, Deploying and managing SSIS packages with SQL server management studio, Extract data from various data sources, Apply transformations like Derived Column, Conditional Split, Data conversion and Load data into various destinations. Experienced with SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages. Adept at utilizing BI tools such as Power BI for enhancing reporting capabilities and developing BI applications in accordance with client requirements. Performed Key Role in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager. Highly proficient in the use of T-SQL for developing stored procedures, triggers, tables, user defined functions, relational database models and data integrity, SQL joins. Well versed in Data warehouse concepts normalization/denormalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints Worked on Data Modeling and Data analyzing in MS SQL Server and good knowledge in query optimization, Tuning SQL queries and T-SQL queries, MDX and improving the performance of the queries. Experienced in managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Sources (Oracle), Excel Spreadsheet to SQL Server. Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility and automation with SSIS, got good scripting skills on python and PowerShell. Good Understanding in creating and managing Linked Servers across SQL server databases. Worked on Data Marts, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services. Worked on SQL Server DTS and SSIS (Integration Service) package design, constructing and deployment, SQL queries involving multiple tables inner and outer joins, stored procedures. TECHNICAL SKILLS: SQL Server Tools SQL Server Management Studio, SQL Server Business Intelligence Development Studio BI Tools Power BI, SQL Server Integration Services (SSIS), .Net, XML, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Master Data Management (MDM), Performance Tuning, Data Modeling, SQL Server Data Design, Data Transformation Services (DTS), DBA, MS Performance Point Databases MS SQL Server 2017/ 2012/ 2008/2005/2000, MySql, Oracle 12c,19c, Azure DB, Mango DB Languages T-SQL, C# Operating Systems Windows server, Linux, Unix, Mac MSBI Stack Skills Levels SSIS --> High Data warehousing --> High Azure cloud --> Medium SSRS --> High SQL -> High SSAS --> Medium PROFESSIONAL EXPERIENCE Bean Infosystems Client: BenefitMall (Remote) Role : Sr. SQL/Power BI Developer November 2023 till present Project Description: BenefitMall is a national provider of Employee benefits, Payroll, HR and Employer services. The Business Intelligence project takes care of enterprise Data Warehouse and supports all applications for the backend functionality, Analytics and also for the Business Intelligence Reports. This Project is migration of SQL Server to Oracle. Key Contributions: As part of the Business Intelligence team, worked as ETL Developer playing a key role in designing, developing, and supporting new and existing BI solutions for our users. Participated in every stage of the Software Development Life Cycle (SDLC) from requirement analysis, documentation, testing, and maintenance to developing Business Intelligence (BI) solutions in an agile environment. Worked in a Data migration project from SQL Server to Oracle,Azure, where I have working knowledge of Azure Data Lake Storage, ADF Data Flow, ADF Pipeline and Azure Synapse. Skilled in performing data transfer between different heterogeneous systems (Excel, Flat Files, XML file, JSON, OLTP DB) and SQL server as part of Data migration, Data maintenance. Developed and implemented reporting, analytics, and Data visualization solutions with Power BI. Leveraged Power BI, DAX, and SQL to construct dynamic dashboards displaying key business metrics, increasing decision-making efficiency by 35% Experience at creating, configuring, and maintaining system databases. Worked in Oracle DB and have experience with performance tuning and working with DB objects Experience developing database applications in PL/SQL using Packages, Functions, Procedures and Complex PL/SQL queries Responsibilities: Gathering and analyzing requirements of clients, understanding and converting them into database solutions with solid exposure to architecture, analysis, design and deployments. Worked closely with various teams across the company to identify and solve business challenges. Created database schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers. Design and implement SSIS packages to import daily for OLTP Applications to Data warehouse and T-SQL scripts for transforming data . Applied conditional formatting in SSRS to highlight key areas in the report data. Created reports like Drill down, Drill through, Chart, Sub reports using SQL Server Reporting Services ( SSRS) Import data from different sources to create Power BI reports and Dashboards. Responsible for performance tuning of SQL Servers and application issues related to migration. Transform,define, navigate the data from various data sources and performed transformations like Merge, Pivot, Unpivot, Column Split and Append queries in Power Query Implemented complex query techniques of passing Multi-valued parameters and cascading parameters in MDX. Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI Created Hierarchies in Power BI using visualizations like bar chart, line chart etc Worked both with Direct and import data to get data into Power BI and create powerful visualizations. Experienced in advance Data modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations Proficient in data visualization, Reporting, Analysis using Pie Charts, Bar Charts, Box Plot, Scatter Plots, Geo Spatial visuals, Gauge charts ,KPI cards in Power BI according to the end user requirement Environment: Oracle 11g SQL, Oracle Database 11g PL/SQL, Power BI(Desktop & Service),Power Query, MS SQL Server 2014/2012, Microsoft Visual Studio 2012, XML, MS SQL Query Analyzer, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS),Excel. Western Digital Role : Power BI Developer February 2023 -November 2023 Project Description: Western Digital offers an expansive portfolio of technologies, storage devices and platforms for business and consumers. The data-centric solutions consist of the Western Digital , G-Technology , SanDisk and WD brands. This Project implementation of data management is for client s business on Extraction Transformation and Loading (ETL) Microsoft SSIS Data Warehouse Solution Design Dimensional Modeling using Kimball Methodology, Analytics OLAP Cube Development Microsoft SSAS, Production Support, SQL queries,creating reports and dashboards in Power BI to keep an eye on the industry and company s product volume, sales, sentiment, to increase market share and discover growth opportunities. Key Contributions: Database migration to Azure Cloud. Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS) Develop complex SQL scripts to convert business requirements into technical scripts. Used SQL Profiler, Execution Plans, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization. Worked on Advance SQL, relational database design, packages, views, triggers & indexes. Data flow diagrams, Normalization, E-R modeling and design, large data sets, Data, ETL, Pipelines SQL Records, Tables, Dynamic SQL, Reference Cursor, and SQL Analytic functions Used Joins, correlated and non-correlated subqueries for complex business queries involving multiple tables & calculations from different databases. Database design, creating normalized tables, constraints, functions, stored Procedures, services. Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions, System Defined Functions and T- SQL statements, Constraints and Indexes using various DDL and DML Commands. Developing objects, Stored Procedures, Functions, Packages, Views, Materialized Views Triggers. Responsibilities: Created Azure Data Factory Pipeline to load data from On-premises SQL Server to Azure Data lake. Utilize Azure s ETL, Azure Data Factory (ADF) services to ingest data from legacy inspirate data stores to Azure Data Lake Storage. Designed SSIS Packages to extract data from OLTP sources to MS SQL Server Extensively worked with SQL Server Integration Services (SSIS) to design and create mappings using various transformations like, Conditional Split, Lookup, Aggregator, Multicast and Derived Column. Worked on Migration of data from on prem SQL to Cloud databases (Azure Synapse Analytics DW & Azure SQL DB) Designed and Published BI Visualizations and Dashboards by using Power BI to various Business Teams for Business use and Decision making. Used DAX Queries to create calculated Measures and Calculated Columns. Used Azure OMS & Power BI for visualizing the activities. Worked on Azure App Insights, Alerts and Log Analytics for Monitoring as part of OMS. Expertise in deploying Azure AD connect, configuring ADFS installation using Azure AD connect. Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse. Used SQL Server Profiler to trace the slow running queries and the server activity. Created appropriate Triggers to assist efficient data manipulation and data consistency. Experienced in Agile Scrum and waterfall methodology, testing, automation and managing the product life cycle, sprint planning, sprint review and sprint retro user story prioritization. Participated in Agile sprint backlog grooming, sprint planning and sprint review in sprint retrospective. Involved in fine tuning queries and stored procedures using SQL Profiler and Execution plan in SQL Server, Created SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server. To analyze long running slow queries and tune the same to optimize application and system performance in Database Administration (DBA). Created views in the intake-database for the MS Sales hierarchies to be used in the store procedures in staging database. Used Joins, correlated and uncorrelated subqueries for business queries involving multiple tables & calculations from different databases. Expert in performing T-SQL DDL/DML/DCL commands using SQL server management studio (SSMS) Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime. Environment: Power BI(Desktop & Service),Power Query, MS SQL Server 2014/2012, Microsoft Visual Studio 2012, XML, MS SQL Query Analyzer, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS). Hudl Role: Microsoft Power BI /SQL Developer July 2017 - October 2022 Project Description: Hudl is a pioneer in performance analyst s technology, now helping more than 200k Teams in 40+ global sports prepare for and stay ahead of the competition. Every product, feature and tool is designed with one purpose in mind: to ensure coaches and athletes make every moment count. For Hudl. I have collected, organized, manipulated, and analyzed a wide variety of data. Identified, designed & developed various reports/dashboards in Power BI. Used advanced analytics and visual design to take BI reports to the next level. To track KPIs, compare performance across markets, analyze category profitability, and identify high-value customers. My Key Contributions: Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages. Involved in Data Extraction, Transformation and Loading (ETL) between Homogeneous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert). Involved in error handling of SSIS packages by evaluating error logs. Successfully extracted, transformed and loaded data into a data warehouse. Created reports using SSRS from OLTP and OLAP data sources and deployed on a report server. Created Power BI Dashboards with interactive views, trends and drill downs along with user level security. Strong understanding of advanced Power BI reporting including calculated columns, parameters, table calculations, row-level security,Measures, joins, data blending, and dashboard actions. Resolved the issues and updated the correction documents in intranet to share the information using SharePoint. Used T-SQL in developing User Functions, Views, Indexes, Relational Database Models, Stored Procedures and SQL joins to maintain referential integrity and implemented complex business logic. Responsibilities: Created various Tabular, Cross-tab, Matrix and Ad-hoc reports using Power BI. Designed and implemented complex SSIS packages to migrate data from multiple data sources for data analyzing. Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics. Generated complex Drill down and Drill through and cross- tab reports with Drop down menu option, bookmarks, complex calculations and visualizations in Power BI. Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like MS SQL Server and Excel. Scheduled Jobs for executing the stored SSIS packages which were developed to update the database. Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures, and Triggers. Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors and hardware errors. Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa. Working on report building, transforming data, creating table relationship and maintaining the dashboards on Power BI Desktop Created Stored Procedures, T-SQL, Triggers, Views and Functions for the database Application. Proficient in data visualization, Reporting, Analysis using Pie Charts, Bar Charts, Box Plot, Scatter Plots, Geo Spatial visuals, Gauge charts,KPI cards in Power BI according to the end user requirement. Involved in reviewing business requirements and analyzing data sources from Google Big Query, Excel, SQL Server, MySQL for design, development, testing, and production rollover of reporting and analysis projects within Power BI Desktop Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SSAS, SSRS, OLTP, Power BI Business Intelligence Development Studio, SQL Server Profiler, SQL Server Management Studio, Excel. S K Shetty & Co Role : SQL / BI Data Analyst June 2016 - July 2017 Project Description: Designed different dashboards to analyze the data related to makes and models, customers, sales and service. The dashboards are, Corp to Dealer, customers by geo, Sales and service revenue dashboard, service response/repair order, Sales & Service advisor performance dashboard. Key Contributions: Developed Reports for business end users using Report Builder with updating Statistics. Created parameterized reports, Drill down and Drill through reports using Power BI/SSRS. Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS. Develop SSIS packages to read data from XML source and insert into target SQL table. Performance tuning for long running T-SQL scripts and stored procedures. Roles & Responsibilities: Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc. Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS). Conducted unit tests of ETL processes, and reports. Created and scheduling maintenance jobs in a new environment using SQL Server Mailing Agent in SQL Server. Designed SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS. Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, DB2, XML files, flat files to SQL server 2008. Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouses and data marts. Production Support and maintenance. Worked with end customers and non- technical staff to resolve incident tickets. Ensured crucial project deadlines/milestones are met without compromise on Quality of the work Product. Involved in fixing the acceptance bugs reported, coding based on the enhancements. Performed complete impact analysis on system software due to suggested modifications/ enhancements and prepared detailed design documents identifying program and database design changes required for successful implementation of change module. Resolved the issues and updated the correction documents in intranet to share the information using SharePoint. Worked with T-SQL to create Tables, Views, and triggers and stored Procedures. Environment: T-SQL, Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SharePoint, SQL Server, MS Office, Windows, Query Analyzer. Infosys Ltd Role : Systems Engineer July 2014 - April 2016 Project Description: Engaged in all phases of the software development lifecycle which include gathering and analyzing user/business system requirements, responding to outages and creating application system models. Participate in design meetings and consult with clients to refine, test and debug programs to meet business needs and interact and sometimes direct third party partners in the achievement of business and technology initiatives. My Key Contributions: I designed, developed and tested Extract Transform Load (ETL) applications with different types of sources. Worked closely with Business Analysts to gather requirements and design reliable and scalable distributed solutions using Horton works distributed Hadoop. Identify new metrics and enhance the existing KPI & Dashboard Visualization through Power BI Building, publishing customized interactive reports dashboards, reports using Power BI Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard. Involved in creating calculated fields, mapping, and hierarchies. Data Visualization (PLX Dashboard, Google Spreadsheets, Power BI desktop) creating dashboards and reports, and working with PLX / Google Data Studio Developed complex triggers in reports before/after for validation of user input. Involved in database performance tuning and monitoring. Responsibilities: Created Mappings using Designer, Extracted the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse. Developed Mappings by using Aggregator, SQL Overrides by using Lookups, source filter by using Source Qualifiers and Data Flow Management into multiple targets using Router Transformation. Generated tabular, matrix, drilldown, Drill through, summary Reports, sub reports, detailed reports, Parameterized and linked reports using Power BI. Performance Tuning of Stored Procedures, SQL queries using SQL Profiler Index Tuning Wizard in SSIS. Data migration from text files, csv, excel files to SQL server. Created indexes on the tables for faster retrieval of the data to enhance database performance. Understanding existing functionality and database design. Built efficient SSIS packages for processing fact and dimension tables with complex transformations implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference. Worked on Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Power BI. Involved in automating SSIS Packages using SQL Server Agent Jobs. Created an ETL summary report which consists of the summary information for all the loading activities done each day and month. Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. Created packages using the various control flow tasks such as data flow tasks, and executed SQL tasks. Created SSIS Packages/projects to move data from source to destination by using Visual Studio Involved in design, Development and testing of web applications and integration projects using object-oriented technologies such as core JAVA, J2EE, struts, JSP, JDBC, spring Framework, hibernate, web services REST/SOAP, XML, XSLT, XSL and Ant Environment: Power BI, XML, Putty, PL/SQL Developer, T-SQL, Business Intelligence MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SharePoint, SQL Server, MS Office, Windows, Query Analyzer. Keywords: csharp business intelligence database active directory rlang microsoft procedural language Colorado