G Sumitra: SQL/ BI Developer
G Sumitra
SQL/ BI Developer
United States
Skills
No information
Interests
No information
Industries
No information
Work experience
First Midwest Bank
SQL/ BI Developer | 09/2020 - Current
Responsibilities:
• Prepare source to target mapping data, like claims, insurance and provider related data.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• 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.
• Owned up ETL process and responsible for the major architectural changes including the design of master packages and load strategies
• Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing.
• Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008 Integration Services (SSIS).
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed complex DAX Queries to generate computed columns.
• Weekly presentation to the business users about the reports and their changes as required.
• Defines and captures metadata and rules associated with ETL processes
Environment: T-SQL, MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), Power BI Desktop, Data Factory (ADF), SQL Server Analysis Services (SSAS) 2016, Visual Studio 2016, Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), SharePoint, MS Excel, Microsoft Windows Server.
CorVel, CA
SQL BI/SSIS Developer | 02/2018 - 08/2020
Responsibilities:
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical reporting and scorecard/ dashboards on SQL Server 2012/2008 R2 using SSAS, SSIS/DTS, SSRS
• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code and T-SQL code from developers
• Backing up, restoring system & other databases as per requirements, and scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• The project aims to help the company migrate from traditional reporting to more dynamic solutions and to continuously improve overall reporting performance.
• Actively participated in gathering Business Requirements that are focused on providing a user-friendly System usage or ambience
• Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).
• Involved in complete SSIS life cycle in creating SSIS package, building, deploying and executing the package in both the environments (Development and Production).
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
Environment: MS SQL Server, SQL Integration Services (SSIS), SSRS, Data Transformation Services, Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio, Windows 2012 Enterprise, MSOffice.
The Irvine Company
ETL/SQL Server Developer | 03/2016 - 01/2018
Responsibilities:
• Created T- SQL queries for data retrieval.
• Optimized queries tuned and monitored server performance.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Created and modified Stored Procedures as per the business logic.
• Created other database objects like tables and indexes.
• Created views as per design needs for security reasons.
• Successful migration of the data from 2005 SQL database to SQL 2008, 2012 database by converting and re-writing DTS packages and updating them to SSIS packages.
• Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server 2008
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Created Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Created Triggers (Instead of and After) for Auditing Purpose.
• Created tables for Data Ware Housing applications and populated the tables from the OLTP database using (SSIS) packages.
• Involved in Creating (SSIS) jobs to automate the reports generation, cube refresh packages.
• Installing, configuring, administering and securing production and non-production servers.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
• Managed up gradation of DTS packages to SSIS packages.
• Created SSIS packages to extract data from Excel File, Flat Files, and Text Files and Comma Separated Values (CSV) files using various transformations.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using SQL Server Reporting Services (SSRS).
• Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizard.
Environment: MS SQL Server, T-SQL, Windows Server, Erwin, SQL Server Profiler, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS, DTS, OLTP, XML.