Sql Server Business Intelligence

Senior SQL/MSBI Developer

Venkata Narayana

Email: ad6plz@r.postjobfree.com

Phone: +1-412-***-****

PROFESSIONAL SUMMARY:

Around 8+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI and Power BI.

Experience in writing T-SQL (DDL, DML and DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, common table expressions (CTEs).

Proficient in data visualization, Reporting, Analysis, Pie Charts, Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.

Hands on experience in different versions of MS SQL Server with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.

Extensive experience with all phases of Software Development Life Cycle in different environments like Healthcare, Banking, Insurance, and Information Technology.

Excellent in Design of ETL/SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.

Experience in Handling Heterogeneous data sources, databases Oracle, IBM DB2 and XML files using SSIS.

Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, and dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling).

Worked wif improving the performance on SQL, TSQL and SSRS procedures and provided the

recommendation on server related tuning issues

Created, Maintained & scheduled various reports in Power BI like Tabular Reports.

Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

Used Microsoft Azure date storage and Azure Data Factory, Data Lake.

Worked on creating Azure Data Factory for moving and transforming the data.

In-depth understanding in client requirement Analysis, Logical design, development, Testing, Deployment, Support and Maintenance of business applications using SQL Server, DTS, SSIS, SSAS and SSRS.

Implement one-time data migration of multistate level data from SQL Server to Snowflake by using Python and Snow SQL.

Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, user profiles, relational database models.

Experience in developing Custom Reports, Parameterized reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).

Involved in Every stage of Report authoring, managing, developing, deploying.

Good Working experience in designing STAR, SNOWFLAKE Schemas, database modeling, logical and physical database design using Erwin and Knowledge of how the Kimball approach has been implemented in the Microsoft BI tool.

Application knowledge in software development life cycle (SDLC), Agile, Scrum, UML, Waterfall, and Project Management Methodologies.

Utilized Team Foundation Server tool and demonstrated excellent problem-solving, multitasking, business analytical, and critical thinking skills in fast-paced environments.

TECHNICAL SKILLS:

RDBMS/DBMS:

MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000, MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97

Database Technologies/Tools:

SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools:

Power BI, SQL Server Reporting Services, Power Apps, Power Query, Crystal Reports, Power Automate, Tableau, Excel.

Operating Systems:

Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages:

T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Design Technologies/Tools:

Erwin, MS Visio, Rational Rose

DW/BI Tools

SSRS, SSIS, SSAS, Power Automate (Flow), Visual Studio 2013/2010/2008, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012

PROFESSIONAL EXPERIENCE:

Client: Knights of Columbus, New Haven, CT April 2023 - Till Date

Senior MSBI/SQL Developer

Responsibilities:

Identified report requirements and devised optimal solutions for delivering insights via Power BI reports to support organizational strategic decisions.

Developed and validated SQL queries for persistent tables utilizing techniques like Inline Views, Dynamic SQL, and Merge statements.

Contributed to the design and development of Data Warehouses and Data Marts utilizing multi-dimensional models such as Star Schemas and Snowflake Schemas for Cube development.

Created SSIS packages for extracting, transforming, and loading data into the data warehouse daily, ensuring deployment into production and environment independence via package configuration.

Utilized various SSIS tasks including Execute SQL Task, Bulk Insert Task, Data Flow Task, FTP Task, and Send Mail Task.

Skilled in Unix Shell Scripting for scheduling, automation, and system maintenance tasks in Sybase and other database environments

Developed Perl and Shell scripts for upload of data feed into database.

Designed and constructed Dimensions and Cubes with star schema using SQL Server Analysis Services (SSAS).

Created Packages using Complex Store Procedures and TSQL queries

Created and scheduled stored procedures in Azure Data Factory, as well as setting up Data factories in Azure Data Factory.

Formulated DAX queries to generate calculated columns and measures in alignment with specified requirements.

Extensive use of Python/Perl scripts and UNIX in project development.

Crafted Power BI dashboards, visualizations, and interfaces integrated with SharePoint and SSRS to offer actionable insights.

Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views

Published Power BI Reports across relevant platforms and made Dashboards accessible to web clients.

Spearheaded the creation of data visualizations including Clustered Column Charts, Line Charts, Slicers, and Gauge Visualizations using Power BI.

Experienced in using Perl scripting for data validation, automation, and manipulation tasks in database environments

Skilled in Unix Shell Scripting for scheduling, automation, and system maintenance tasks in Sybase and other database environments

Utilized Perl scripts for data masking and anonymization to ensure compliance with data privacy regulations.

Leveraged Power BI Gateway to maintain real-time dashboards and reports connected to on-premises data sources.

Designed and implemented visual reports, dashboards, and KPI scorecards within Power BI Desktop.

Integrated Power Apps with Power BI to facilitate the write-back functionality from Power BI.

Implemented views, triggers, and user-defined functions to streamline business processes and automated stored procedures.

Established and managed Power BI environments, configuring app workspaces, deploying apps, and Power BI Gateway.

Developed and enhanced complex T-SQL Stored Procedures, functions, and views to streamline data manipulation processes.

Formulated DAX queries to generate calculated columns and measures in alignment with specified requirements.

Crafted Power BI dashboards, visualizations, and interfaces integrated with SharePoint and SSRS to offer actionable insights.

Published Power BI Reports across relevant platforms and made Dashboards accessible to web clients.

Spearheaded the creation of data visualizations including Clustered Column Charts, Line Charts, Slicers, and Gauge Visualizations using Power BI.

Implemented pipelines for data movement from source to destination within Azure Data Factory (ADF V1).

Implemented data validation rules and constraints in Sybase databases to ensure data integrity and consistency.

Engineered intricate SSAS solutions incorporating multiple dimensions, perspectives, hierarchies, measure groups, and KPIs to analyze performance at both Strategic Business Unit and corporate levels.

Employed MDX scripting in SSAS for querying and manipulating multidimensional cube data.

Developed extensive T-SQL / P-SQL queries for Join conditions, Unions, Aggregations, and Expressions for SSRS Reports.

Participated in Unit and UAT testing phases during the deployment of SSRS reports.

Generated diverse monthly, quarterly, bi-yearly, and yearly reports utilizing SSRS.

Automated resource and resource group creation using PowerShell scripts.

Environment: MS SQL Server Integration Services (SSIS), shell, MS SQL Server Analysis Services (SSAS), TSQL, Power BI DAX, T SQL, SQLMS Excel, ADF.

Client: Travelers, New York, NY Jan 2021 - Mar 2023

MSBI Developer

Responsibilities:

Enhanced SQL Queries to optimize procedure performance from 5 minutes to 60 seconds.

Created SSIS packages for daily extraction, transformation, and loading of data into the data warehouse. Utilized package configuration for environment-independent deployment.

Developed complex SSAS solutions employing multiple dimensions, perspectives, hierarchies, measure groups, and KPIs for analyzing business performance.

Expert in TSQL. Wrote thousands of lines of TSQL code, developed many Stored Procedures, Triggers

Extracted data from internal data warehouse systems for SSRS reporting.

Designed and developed stored procedures, queries, and views to support SSRS reports.

Created and scheduled SSIS Packages for data processing from various sources like SQL Server, Salesforce, Teradata, MS Excel, and Flat files.

Designed and implemented a prototype SQL Server DB, SSIS, and Power BI solution for reporting telemetry usage data on a SaaS cloud platform.

Developed extensive T-SQL / P-SQL queries for SSRS reports including Join conditions, Unions, Aggregations, and Expressions.

Implemented Event Handlers and Error Handling in SSIS packages and communicated process results to user communities.

Wrote intricate DAX functions in Power BI and Power Pivot, sourcing data from diverse platforms including SQL Server, SAP BW, Oracle, SQL Azure, Amazon Athena, and SSAS Cube.

Continuously analyzed existing KPIs, reports, and dashboards to align with stakeholder requirements.

Collaborated with business stakeholders to establish a formal business glossary and define metrics and KPIs.

Designed and optimized database schemas, indexes, and partitioning strategies to improve query performance and scalability in Sybase environments.

Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.

Generated impactful reports using visualizations like Bar charts, Clustered Column Charts, Waterfall Charts, Gauges, Pie Charts, and Tree maps in Power BI.

Developed database objects like views, triggers, and user-defined functions to streamline business processes and automated stored procedures.

Implemented data management and processing solutions in SSIS, including Error Handling and Slowly Changing Dimensions.

Utilized various SSIS tasks such as Execute SQL Task, Bulk Insert Task, Data Flow Task, FTP Task, and Send Mail Task.

Designed and constructed Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Engaged in Dimensional modeling, Data cleansing, and Data Staging using ETL processes.

Crafted complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, and User Defined Functions to implement business logic.

Configured Integration Runtime (IR) for data movement from on-premises to cloud.

Utilized PowerShell scripts to automate resource creation and management.

Experience with Azure Data Warehouse, including TSQL code for external tables to load data from ADL to ADW.

Generated detailed technical documentation for staging area operations for future reference and guidance.

Participated in System Integration Testing (SIT) and User Acceptance Testing (UAT), including bug fixing and documentation updates.

Environment: Power BI, SSRS, T-SQL, SQL Server Management Studio, MDX, SQL Server Integration Service, SSAS, SQL Server 2012/2014/2016, Enterprise Manager, Erwin, shell, SQL Server DTS, Jira (Scrum), SSMS, Query Analyzer, Azure, Sybase, Profiler, PL/SQL, Visual Studio, MS Visio.

Client: Nextiva, Scottsdale, AZ Feb 2019- Dec 2020

Role: SQL /MSBI Developer

Responsibilities:

Wrote extensive T SQL / P SQL query for Join conditions, Unions, Aggregations and Expressions for SSRS Report

Created SSIS packages to extract data from multiple flat files, CSV, Excel and XML files and scheduled jobs to call the packages.

Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.

Developed highly complex SSIS packages using various Tasks, Containers and Data transformations.

Executed Transact-SQL batches, system procedures, and script files at the command prompt using SQL CMD Utility.

Gathered user requirements to develop the business logic and analyzed and designed the packages and database solutions.

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Experience working with Team Foundation Server (TFS) and Visual SourceSafe.

Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.

Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS)

Responsible for regression testing ETL jobs before test to production migration.

Used configuration files, to migrate SSIS packages from development stage to quality analysis (testing) without having to reconfigure the packages.

Proficient in creating database objects like Procedures, Functions, Triggers, and Cursors in Sybase for data manipulation and processing

Developed stored procedures using T-SQL programming to meet the business requirements.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily/weekly/monthly basis.

Worked with SSIS packages involved FTP tasks, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations.

Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure, Amazon Athena, SSAS Cube.

Environment: DB2, MS Visio, MS Excel, Visual Studio 2016, MS SQL Server 2016/2014, T-SQL, SQL Server Agent, MS Office, ETL, XML, SQL SSIS, TFS, XSLT.

Client: Standav Corp, Chennai, IN Jun 2014- Jul 2017

Role: SQL Developer

Responsibilities:

Created Database Objects, Tables, Indexes, Views, User-defined functions, Cursors, Triggers, Stored Procedures, Constraints.

Worked on Deploying Packages and providing security while deploying.

Defined Calculated members, named sets, and executed other script commands using MDX expressions.

Implemented database management techniques that include backup/restore, import/export, and generated scripts.

Implemented new enhancements in the existing functionality meeting given timelines and with agreed service levels.

Involved in Query Optimization, Performance Tuning, and rebuilding the indexes at regular intervals for better performance.

Worked in designing and developing Data Warehouses, Data marts, and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX.

Tuned, monitored, and maintained SQL Server Jobs.

Experience in maintaining SQL Server jobs and involved in developing\maintaining SSIS packages and SSAS cubes.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers, and user-defined functions.

Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.

Environment: MS-SQL Server 2008 R2/2012, Windows Server 2008/2012 SSIS, SSRS. MS Office suite 2010.

Education:

Bachelors

Contact this candidate