Lalitha Gopinadham: BI Developer in , CA
Lalitha Gopinadham
BI Developer
United States
Skills
No information
Interests
No information
Industries
No information
Work experience
Matrix Medical (Remote)
BI Developer | 04/2020 - Current
Responsibilities:
• Prepare source to target mapping data, like claims, insurance and provider related data.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
• Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.
• Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.
• Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.
• Create and design logical and physical data models using ERWIN- identify entity & its relationships and define the project's informational needs.
• 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.
• 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.
Environment: T-SQL, MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), Power BI Desktop, SQL Server Analysis Services (SSAS) 2016, Tableau, Visual Studio 2016, Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), SharePoint, MS Excel, Microsoft Windows Server.
Client: The Irvine Company, CA
The Irvine Company
SQL BI Developer | 06/2018 - 03/2020
Responsibilities:
• 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.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• 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 and QA.
• 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.
Acuity Brands, GA
SQL BI Developer | 01/2017 - 05/2018
Responsibilities:
• 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.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• 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 and QA.
• 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.