Business Intelligence Sql Server
Resume:
Have more than * years of experience in diverse business and technical environments with main area of focus in design, development, implementation and support of relational databases, data analysis, business intelligence, ETL, and data visualization using RDBMS databases and various reporting and visualization tools.
Well versed in all Software Development Life Cycle (SDLC) phases of specifically waterfall and Agile Scrum methodology.
Translated business requirements to physical data models, designed data element & created quality sets of metadata to achieve strategic goals.
Completely verse with Cloud methodologies and terminologies (IaaS, PaaS, SaaS, FaaS and DaaS), Cost optimization techniques, different types of Services, Server less Services, API programming using C#.
Developed end-to-end data pipelines using Azure Data Factory, integrating data from various sources into Azure SQL Database and Azure Data Lake Storage.
Collaborated with data scientists and analysts to create scalable solutions for data analytics and machine learning.
Ensured data quality by implementing validation checks and cleansing processes.
Worked on OnPrem version of DataWarehouse initially and moved to Cloud version in order to solve the challenges faced on OnPrem Servers like high CapEx and slow delivery rate.
Implemented Data Factory Pipelines to load data from OnPrem SQL Server to Azure Data Lake Storage in the form of JSON format and further loaded this data into Azure Data Bricks Data Warehouse.
Experienced in designing and developing databases with Normalization up to 3NF in Relational Database Management Systems.
Implemented many ETL workflows using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SQL Server environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
Experienced in SQL Server Analysis Services SSAS multidimensional OLAP database development including KPIs, Data mining, working with changing dimensions.
Worked on OLAP Data warehouse, Model, Design, and Implementation.
Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS) and MDX.
Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
Entered, recorded, transcribed & stored information in written documents, analyzed needs & product requirements to create design.
Very good Experienced in scheduling and deploying reports on report manger.
Expert in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill Down reports using SSRS.
Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills
SQL SERVER TOOLS & PACKAGES/ BI TOOLS: SQL Server Management Studio, Business Intelligent Studio, ETL, Erwin Data Modeler, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, MS Visual SourceSafe, Tableau SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio 2013,2017,2022
CLOUD: Azure Data Factory, Azure Data Lake, Synapse Data Warehouse, DynaTrace, SolarWinds, Azure Repos, Log Analytics.
LANGUAGE: Java, C, C++, HTML, XML, XSL, T-SQL, MYSQL, PL/SQL, DHTML, VB.NET, ASP.NET, ADO.NET Frame Work 2.0/3.0, C#, CSS, Python
OPERATING SYSTEM: Windows server 2022, 2016, Windows 10, UNIX, MS-DOS
SCRIPTING: VB Script, Java Script, UNIX Shell Scripting
RDBMS/DATABASES: MS SQL Server 2022,2019,2017,2016, Teradata Database 15.10, 16.10, Microsoft Office, MS-Access, Oracle 8i, 9i/10g, MS Access 97/2000,DB2
DATABASE DESIGN TOOLS AND DATA MODELING: MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables
DATABASE TOOLS AND UTILITIES: SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS
VERSION CONTROL TOOLS: VSS, Sub version, TFS, Git
OTHER SOFTWARE: MS Office, Adobe Professional, Agile/Scrum Methodology
BACHELOR IN COMPUTER INFORMATION SYSTEM, BARUCH COLLEGE, NYC
WELLMARK BLUE CROSS AND BLUE SHIELD - DES MOINES, IA
BI DEVELOPER - JUL 2023 TO PRESENT
Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
Worked closely with Solution Architect, gave significant input on Normalization/De W Normalization of database tables, and built Referential Integrity for RDBMS.
Designed and developed Azure Data Factory Pipelines to copy data files from network Shared Folders into Azure Storage Blobs, utilized Copy Activity, For Each Activity and Get Meta Data Activity.
Developed Parent Child Pipelines to cater nested For Each Looping activity while loading data from Blob storage to Azure SQL databases, applied expressions for dynamic mappings using metadata obtained from Lookup activity.
Optimized the performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs and System stored procedures.
Monitoring SQL Server performance using SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
Worked with project team representatives to ensure that logical and physical data models developed in line with corporate standards and guidelines.
Utilized ETL (SSIS) to develop jobs for Extracting, Cleaning, Transforming, and Loading data into data warehouse.
Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
Created Sub-Reports, Drilldown-Reports, Summary Reports, Parameterized Reports in SSRS.
Specialized in transforming data into user- friendly visualization to give business users a complete view of their business using Power BI.
Designing Interactive Reports and Data Visualization using Power BI Desktop from multiple data sources such as MS SQL Server and Oracle.
Developed and published reports and dashboards using Power BI and written effective DAX formulas and Expressions.
Deployment – CI/CD through Azure Repos, Flyway DB implementation for DB objects, Support during deployment and feature go live.
Environment: MS SQL SERVER 2022, Azure Data Factory V2 APIs, Azure SQL, Windows Server 2022,Power BI Desktop, DAX, Python.
KEYBANK - CLEVELAND, OHIO
SQL DEVELOPER - JUN 2021 TO JUN 2023
Worked closely with business analyst as a senior SQL developer to understand and translate business requirements into technical documentation such as high level and low-level design specification documents, database schema and mapping documents.
Worked on Optimization of long running Stored Procedures by rewriting the script, created temp table and indexes, recompiled stored procedure, updated statistics and make the process simpler and faster.
Tested the data acquisition, data transformation and data cleansing approach for the MDM implementation.
Experienced in Extracting Data from Mainframes Flat File and converting them into Teradata tables using SAS PROC IMPORT, PROC SQL etc.
Monitored performance, integrity to optimize SQL queries for better efficiency
Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period.
All DDM enhancements that are required to support the release, including new columns, dimension and fact tables, look-up/shadow tables, and subject areas.
The required data elements from each source system (where the data originates), the appropriate target columns in the DDM for these data elements (to where the data flows), and the transformation rules that are required from the Staging to the DDM (From which reporting is done).
Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
Created SRD (System Requirements Doc) to facilitate the ETL team to develop their SDS (System Design Specification doc)
Analyzed Complex dashboards in tableau using the various sources of data from Excel sheets, Teradata, SQL Server, Oracle databases.
Created pivot tables in Excel by getting data from Teradata and Oracle.
Analyze complex SQL queries of in scope reports, identify critical elements, complex calculation logics, and capture them in requirements template
Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
Developed strategies with HPALM (Application Lifecycle Management) for stress testing and UAT (User Acceptance Testing)
Tested data quality for MDM, customer data integration and Match-Merge process
Environment: SQL 2019 ETL Informatica, Tableau, MDM, MS Access, SQL, PL/SQL, Oracle SQL Developer, Teradata 16.10, Teradata SQL Assistant, Erwin, MS Excel, MS Word, Visio, MS PowerPoint, MS Visio, Ms Project 2010, Windows 7, SharePoint
LEMONADE - NEW YORK, NY
JR SQL DEVELOPER - MAR 2019 TO MAY 2021
Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.
Experience in managing and automating Control flow, Data flow, Events and Logging with C# using Microsoft .NET framework for SSIS packages.
Used various SSIS task such as conditional split, derived column, lookup that were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and data mapping documents from staging to data mart, cubes and reporting needs to the end user community.
Designed Dimensional Modeling using SSIS Packages for End Users. Created Hierarchies in Dimensional Modeling. Defined appropriate measure groups and KPIs.
Designed and developed the ETL data flow to populate the CER Cube Analysis Database using the SQL Server Integration Services (SSIS).
Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting.
Created Data Mapping Document and Metadata for the Enterprise Data Warehouse EDW.
Worked on building SQL queries for Data manipulation and for creating DQL objects like tables, triggers, stored procedures, views and more.
Worked on adding more data integrity check to the existing database and for the newly added SQL objects.
Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and data mapping documents from staging to data mart, cubes and reporting needs to the end user community.
Been part of Power BI POCs and actively created reports and Dashboards using Power BI Desktop.
Environment: MS SQL Server 2016, SQL Server Query Analyzer, Microsoft SSMS, Data Transformation Systems, Visual studio 2013, Visual studio 2016, Power BI, Team Foundation Server etc.
Kansas City, MO 64155
***************@*****.***
CHHIMI SHERPA
Database Developer
SUMMARY
TECHNICAL SKILLS
EDUCATION
EXPERIENCES
Contact this candidate