Master of Science in Managing Information Technology

BI Developer

IT & Technology

• Having 4+ years of IT experience in the areas of Microsoft Business Intelligence (MSBI) applications primarily using Microsoft SQL Server 2012/2014/2016.
• Strong knowledge and Experience in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.
• Strong T-SQL experience in creating different database objects Tables, Stored Procedures, DDL/DML Triggers, Functions and User defined data types. Skilled in writing and reviewing T-SQL code and maintaining coding standards.
• Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
• Experience with Relational and Dimensional data modelling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modelling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2014/2012/2008.
• 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
• Excellent knowledge in creating Databases, Tables, Stored Procedures, Common Table Expression (CTE), Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Expertise STAR Schema data warehouse design, slowly changing dimension,
• Scheduling the ETL workflows SQL server agent jobs. Logging and Error handling during the ETL Process.
• Creating packages for implementing ETL by using various control flow items like For Each Loop, For Loop, Execute SQL and Data Flow Transformations like Conditional Split, Multicast, Derived Column, Lookup, Sort, Union all etc.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Expertise in SQL Server Analysis Services (SSAS) for Developing Tabular Model, Creating Measures, Key Performance Indicator, Hierarchies, Attribute Relations, Creating Prospective and Translations.
• Expertise in Analysis Using Excel, Power Pivot Reports and Drill-Through Reports Dashboards Using Warehouse and OLTP Connections.
• Expert in Creating and developing Power Bi Dashboards in to rich Look.
• Knowledge in all types of Database migrations with all the versions of SQL Server.

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

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.

SQL BI Developer

Find out detailed information about Lalitha Gopinadham, BI Developer in , CA

Lalitha Gopinadham: BI Developer in , CA

Lalitha Gopinadham