Naresh

Sr. Power BI/ MSBI Developer

Phone: 678-***-****) Email: ad3nnh@r.postjobfree.com

SUMMARY:

Around 10+ years of total professional experience as a MS SQL BI Developer, ETL Developer in various industrial domains like Insurance, Finance, Banking and Health Care.

Experience in developing BI Applications utilizing SQL Server, BI Stack and Power BI.

Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server with expertise on data normalization.

Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.

Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.

Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.

Good understanding in Database and Data warehousing concepts (OLTP & OLAP).

Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).

Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.

Used VB scripts in the script task in SSIS packages.

Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.

Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the multi-dimensional Cubes.

Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.

Highly knowledgeable in Designing, Developing, and deploying various kinds of reports using SSRS using relational data.

Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.

Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.

Experience in Reporting services, Power BI (Dashboards Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services.

Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS:

Operating Systems

Windows, Linux, Unix

Languages

C, Python 2.7, UML, Visual C++ 6.0, VB 6.0, C#.Net, VB.Net, PL/SQL, TSQL, R programming and Java EE.

Data Warehousing & BI

SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Azure Synapse, Power BI, SAP BI 7.4.

Database

MS SQL Server 2012/2008, Oracle 10g/9i/8i, MYSQL, IBM DB2 7.1/8.0 and MongoDB

Reporting Tools

SSRS 2012/2008, Crystal Reports XI/X/9/8, Power BI, Databricks, Amazon S3, Excel and QlikView

Web Services

SOAP 1.2 and REST 2.0

Web Technologies

HTML, XML, JavaScript, Angular JS, PHP, Shell Scripting, jQuery

Methodologies

Agile, waterfall and Scrum.

Tools

Eclipse 4.2, SAS, UML Rational Rose, Visio, MS Word, MS Excel, MS Access, and MS Project

Web/Application Servers

IBM Web Sphere 6.1, JBoss 3.2.x, Apache Tomcat 6.0, Microsoft IIS 6.0

Cloud Environments

Azure, AWS and Google Cloud.

PROFESSIONAL EXPERIENCE

Sr. Power BI/ MSBI Developer

Nations Benefits, Plantation, FL Nov 2021 – Present

Responsibilities:

Designed and implemented scalable and resilient cloud architectures on Azure & Extensive experience with a wide range of Azure services, including Azure Blob Storage, Azure SQL Database, and Azure App Services.

Develop, implement, and optimize stored procedures, CTE’s and complex queries using T-SQL.

Implementing trigger-based automation to initiate workflows based on events, such as data changes or system updates.

Have experience with Crystal Reports development and deployment and providing access to Users.

Utilizing Power Automate to transform and manipulate data as it moves between different applications and services.

Proficient in designing interactive and visually compelling reports and dashboards using Power BI to analyze clickstream data effectively.

Demonstrated ability to transform raw clickstream data into actionable insights, enabling data-driven decision-making.

Created and implemented with SQL relational databases and Decision Support Systems (DSS), high-performance, service-oriented, and multi-tiered environments.

Implementing robust error handling mechanisms to ensure the reliability and stability of automated workflows.

Created ssis flows to automate business processes for a variety of use cases.

Implemented CI/CD pipelines using Azure DevOps for automated application deployment & Configured and managed Azure AD for identity and access management in cloud environments.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Designed and implemented scalable and secure cloud architectures on AWS & Proficient in provisioning and managing EC2 instances for diverse application workloads.

Designed SSIS Packages to perform ETL processes on existing data into SQL Server from different environments using SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.

Implementing secure user authentication and access controls within Power Apps.

Integration of Power Apps with various data sources, including SharePoint, Microsoft 365, SQL Server, and others.

Experienced in leveraging Tableau's mapping capabilities for geospatial analysis, including plotting geographic data, customizing map layers, and conducting spatial analysis.

Integrating Power Apps with Power Automate (Flow) for workflow automation and process optimization.

Experienced in setting up and configuring Databricks clusters for optimal performance and cost-efficiency & Skilled in utilizing Databricks notebooks for interactive data exploration, analysis, and visualization.

Implemented end-to-end machine learning workflows, including data preprocessing, feature engineering, model training, and evaluation.

Hands-on experience in utilizing Amazon S3 as a reliable backup and disaster recovery solution, including cross-region replication and versioning.

Proven track record of designing and implementing backup strategies to protect critical data and ensure high availability.

Implemented Database designing Tools, Data Modeling skills and responsible for maintaining cubes using SSAS and populating cubes with data.

Worked on Multidimensional model cubes in SQL server 2008R2,2012,2016 & worked in Relational modeling constructs (model, tables, columns) and OLAP modeling constructs (cubes, dimensions, measures).

Worked on Dynamic SSAS Tabular Role Security-One Role to Multiple Cubes.

Designing and implementing scalable and efficient data warehouse solutions using Azure Synapse Analytics and Defining data structures, schemas, and partitioning strategies for optimal performance.

Implementing security measures and access controls to ensure data privacy and compliance and Managing user roles and permissions within Azure Synapse.

Used Jira for creating Use cases and bug tracking for agile board and for real time bug tracking and issue management.

Used ServiceNow for resolving incident tickets and creating change management tickets for production changes.

Created Power BI dashboard reports as per the business requirements from the legacy reports.

Monitor and maintain SQL jobs and Power BI reports for data accuracy and work on performance improvement of the reports.

Developed custom reports and developed them on server using SQL Server Reporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Back-end experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.

Export reports in various formats like MS Excel, PDF, MS Word, Text, and CSV.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), DAX, SVN (source control), Azure Synapse, MS Visual Studio.NET, C #, TFS, Visual Studio 14.0/VB.net, VB Script, ETL and Windows 2012 Server, ServiceNow.

Senior SQL Server/MSBI Developer

Gain well Technologies, Dublin, Ohio

Mar 2020 – Oct 2021

Responsibilities:

Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Have experience with Crystal Reports development and deployment and providing access to Users.

Created and implemented with SQL relational databases and Decision Support Systems (DSS), high-performance, service-oriented, and multi-tiered environments.

Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using SQL Server Integration Services (SSIS). Created Pivot tables using Power Pivot and power Query.

Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL..

Experienced in integrating clickstream data from various sources such as web servers, applications, and third-party tools into Power BI for comprehensive analysis.

Knowledgeable in implementing real-time analytics solutions using Power BI Streaming Dataflows or Azure Stream Analytics to monitor and visualize clickstream data as it occurs.

Skilled in storytelling with data, effectively communicating insights and findings to stakeholders through compelling narratives and annotations within Tableau dashboards.

Involved in performing incremental loads while transferring data from OLTP to data warehouse.

Developed and optimized stored procedures and functions using T-SQL & experience in creating Roles using T-SQL

Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the

multi-dimensional Cubes.

Different data flow and control flow tasks in Business intelligence studios using SSIS.

Created and deployed ARM templates for infrastructure as code (IaC) deployments & set up monitoring and logging solutions using Azure Monitor and Azure f.

Identifying and resolving issues related to data loading, processing, and analytics within Azure Synapse and implementing robust error handling mechanisms for automated workflows.

Collaborating with cross-functional teams, including data engineers, analysts, and stakeholders and Documenting data warehouse processes, configurations, and best practices.

Implemented scalable and durable object storage solutions using Amazon S3 & managed relational databases on AWS using RDS for MySQL, PostgreSQL, etc.

Designing approval workflows to streamline decision-making processes within an organization.

Debugged SSIS Packages using Data Viewers and Breakpoints. Used various transformations like derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.

Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.

Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed dashboard reports using Reporting Services, Report Model using Report Builder.

Optimizing Power Apps for performance, including minimizing load times and enhancing responsiveness.

Developing and using custom connectors to extend functionality and connect to external systems.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart, and matrix report).

Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Writing database procedures, functions, and triggers and Assist developers with database activities & tune database queries and Monitor application related jobs and data replication activities.

Worked in Relational modeling constructs (model, tables, columns) and OLAP modeling constructs (cubes, dimensions, measures).

Worked on Dynamic SSAS Tabular Role Security-One Role to Multiple Cubes & experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server and Experienced in working with agile methodology.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), DAX, Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), Power BI, SVN (source control), Azure Synapse, Informatica, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0/VB.net, VB Script and Windows 2012 Server.

Sr. SQL BI (SSIS, SSAS, SSRS) Developer

Molina Healthcare Inc. Long Beach, CA Oct 2018 – Feb 2020

Responsibilities:

Conducted DB management, Performance measurement and Performance tuning for new databases by using SQL Profiler, Data Engine Tuning Advisor and Index Tuning Wizard.

Designed Star Schema (identification of facts, measures and dimensions) and Snowflake Schema.

Fine-tuning Stored Procedures to improve the performance by removing the unnecessary cursors.

Usage of Active Directory to identity management design for providing strong authentication and authorization for internal and external websites.

Configured and maintained VPCs to isolate and secure network resources & implemented network security using AWS Security Groups and Network Access Control Lists (NACLs).

Management of T-SQL Views, Cursors, Index statistics, Tables and query optimization using execution plan for tuning the database.

Implemented different types of constraints on the tables and usage of Try, Catch and error for exception handling.

Development of physical and logical data modeling tools such as Erwin and ER/Studio.

Generation of periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS).

Creation of Cross Tab Reports, Drill-down, Drill-through and Sub-Reports using RDL.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View, Power Map and Power Pivot to visualize reports.

Expertise in designing and building Model-Driven Apps for data-centric applications.

Proficient in identifying and resolving issues through effective troubleshooting and debugging techniques.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.

Used the SSIS Import/Export, migrate the Heterogeneous Databases such as Access database, Oracle and flat files to SQL server 2014.

Worked in developing Tabular model for Dashboard and Generating the power view Reports.

Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.

Developed multi-dimensional objects (cubes, Dimensions) using SSAS and expert in creating Star schema cubes using SSAS.

Involved in analyzing, designing, building & testing of OLAP cubes with SSAS 2014 & responsible for maintaining cubes using SSAS and populate cubes with data.

Involved in development of ASP.NET/ C# / SQL Server Web Applications.

Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Configured replication servers and transactional replication between production & standby server for disaster recovery.

Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: SQL server 2008/2012/2014 Enterprise Edition, SSRS, SSIS, SSAS, Power BI, .NET Framework, C#, ASP.NET, ADO.NET, Oracle 11g/10g, Visio, MS IIS, XML, MS Excel, Access and Visual Source safe.

MS SQL BI Developer

Regions Bank, Birmingham, AL Jan 2017 – Sep 2018

Responsibilities:

Involved in writing scripts for the client's requirements for reporting purposes.

Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.

Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).

Responsible for deploying/scheduling SSIS packages as per schedule.

Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.

Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Created SSIS packages to pull data from SQL Server and exported it to Excel Spreadsheets and vice versa.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. Created ETL packages using SSIS to extract data from different data sources reformats the data and load the reformatted data into destination tables.

Used Scripts task for Data Flow and Error Handling in SSIS & generated Monthly, Yearly, Quarterly, and daily reports in POWER BI.

Configured and optimized Azure networking components, such as Virtual Networks and Traffic Manager & Implemented security best practices and ensured compliance with industry standards on Azure.

Worked and joining the queries and merging the tables in POWER BI & used reporting objects like Matrix, Sub Reports, Parameterized reports using SSRS 2012.

Developed several stored procedures to handle large amounts of data manipulation & used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL Server Reporting Services (SSRS) 2008/2012

Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS).

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Involved in DAX operations for SSAS 2012 and 2008 OLAP databases and developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2008/2012, SSIS, SSRS, SSAS, T-SQL, Access, Excel, Visual Studio, Data Analyzer, Business Objects 6.5, ER Win 4.0, Visual Studio.NET 1.1, IIS, ASP, C#, Oracle 9i.

SQL BI Developer

IKS Health Hyderabad, India May 2015 – Nov 2016

Responsibilities:

Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

Created Data-driven Packages in SSIS 2012 as part of the automating process for the Referral Process.

Developed free-form reports using reports using MS-SSRS tool for consulting multiple reports into single reports delivered in .pdf format to the power users.

Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.

Worked on SSIS (DTS, DTSX) packages for Data Integration Services. Used SSIS to produce a Data Mart for reporting.

Extensively used System variables and created User-Defined variables for SSIS packages.

Implemented SSIS data, created maintenance procedures and provided data integrity strategies.

Developed custom reports and developed them on server using SQL Server Reporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.

Implemented complex query techniques of passing multi-Valued parameters and cascading parameters in MDX.

Created reports using stored procedure and experience in building reports on Analysis Services cubes (SSAS).

Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQL Server 2012/2008 R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS. SSAS, OLAP, XML, SharePoint, Agile, Visual Studio 2010, .Net Framework 3.5, Window 8

SQL Developer

HDFC LIFE INSURANCE, Hyderabad, India Aug 2013 – Apr 2015

Responsibilities:

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

Created SQL scripts for tuning and scheduling & performed data conversions from flat files into a normalized database structure.

Created and managed users, roles and groups and handled database security.

Created Triggers to enforce data and referential integrity and Defined Check constraints, Business Rules, Indexes, and Views.

Worked closely with developers, end users and Administrators in designing and creating databases and other objects.

Actively involved in designing databases for the system and created Snapshot Replication for the Development and Testing Databases across different Servers.

Created and scheduled jobs and alerts and involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.

Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

Involved in performance tuning using indexing (Cluster Index, NonCluster index) tables.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Performed development support, document reviews, test plan, integration of the system.

Creation/ Maintenance of Indexes for fast and efficient reporting process.

Involved in regression testing, evaluating the response times, and resolving the connection pooling issues.

Environment: SQL Server 2008, T-SQL, PL/SQL, TOAD, Forms 6i and reports 6i.

Contact this candidate