Nishi Mayank Nyaya

Email: ad3q8y@r.postjobfree.com Phone: +1-614-***-****

Professional Summary:

• Around 7 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.

• 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.

• Implemented 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.

• Extensive experience in working with NO SQL Databases that include Mongo, DataStax Graph.

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

• Extracted and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS.

• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

• Well versed in Using MDX/DAX Queries to retrieve data from Analysis Services Cubes.

• Explored data in a variety of ways and across multiple visualizations using Power BI Desktop and Service.

• Application knowledge in software development life cycle (SDLC), Agile, Waterfall and Project Management methodologies in different environments like Banking and Information Technology.

• Used Microsoft Azure date storage and Azure Data Factory, Data Lake. Worked on creating Azure Data Factory for moving and transforming the data.

Education:

• Bachelors in computer engineering, Gujarat Technological University, Gujarat, India

• Masters in information systems, Denton, Texas, USA Professional Experience:

Blue Cross Blue Shield, Vermont, USA Nov 2023-Till Date Role: Business Analyst

Description: Blue Cross Blue Shield is a nationwide network of independently operated health insurance companies, providing comprehensive coverage and healthcare solutions to individuals, families, and businesses across the United States. Roles and Responsibilities:

• Develop and maintain Python-based applications and scripts to support various business needs, such as data processing, automation, and analytics.

• Design and implement data pipelines and workflows using Python libraries and frameworks like Pandas, NumPy and Matplot lib.

• Write clean, efficient, and maintainable code following best practices and coding standards.

• Design, develop, and maintain Microsoft SQL Server databases and data warehouses to support business intelligence (BI) and reporting needs.

• Develop and optimize SQL queries, stored procedures, and functions for data extraction, transformation, and loading (ETL) processes.

• Building data models in Power BI using techniques such as relationships, measures, and calculated columns to provide a solid foundation for reporting.

• Integrating data from various sources into Power BI, including SQL Server databases, Excel files, APIs, and other data repositories.

• Optimizing data queries and performance within Power BI to ensure efficient report rendering and responsiveness.

• Implementing row-level security (RLS) and other security measures to ensure data privacy and compliance with regulatory requirements.

• Designing, developing, and maintaining Power BI reports and dashboards to visualize and analyze healthcare data.

• Adroitly navigated complex healthcare datasets, extracting actionable insights through adept application of statistical analysis, pattern recognition, and correlation identification.

• Conducted thorough process analysis and contributed to the development of comprehensive documentation, aligning with data governance initiatives to drive process improvement, standardization, and risk minimization.

• Document code, processes, and workflows to facilitate knowledge sharing and maintainability. Environment: Python, MS SQL Server, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Power BI Desktop, Power BI Service, DAX.

Sears Holdings Corporation, Hoffman Estates, IL, USA Mar 2020 – Oct 2023 Role: MSBI Developer/PowerBI Developer

Description: Sears is a leading integrated retailer focused on seamlessly connecting digital and physical shopping experiences to serve our members - wherever, whenever and however they want to shop. Roles and Responsibilities:

• Developing and maintaining data models to support financial analysis and forecasting.

• Worked on DAX query to create calculated columns and calculated measures based on Requirements.

• Developed Power BI dashboards, visualizations, and interfaces with SharePoint and SSRS to deliver meaningful and actionable insight.

• Involved in creating data visualizations like Clustered Column Chart, Line Chart, Slicer, Gauge Visualization etc.

• with Power BI.

• Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.

• Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and Triggers.

• Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL DDL, DML statements for various applications.

• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

• Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements.

• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.

• Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.

• Design and implement the ETL processes using SSIS which involves collection of data.

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

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

• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multidimensional models such as Star Schemas and Snowflake Schema for developing Cubes.

• Troubleshooting reports issues, ETL job failures, optimizing query performances.

• Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection.

• Building the pipelines to copy the data from source to destination in Azure data factory.

• Creating stored procedure and scheduled them in Azure Data factory and Creating Data factory in Azure Data factory.

• Collaborating with cross-functional teams to understand business needs and provide data-driven recommendations. Environment: MS SQL Server, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, MS Excel. State Bank of India, Hyderabad Oct 2017 – Sep 2019 Role: MSBI Developer

Description: State Bank of India (SBI) is an Indian multinational public sector bank and financial services statutory body headquartered in Mumbai, Maharashtra. SBI is the 49th largest bank in the world by total assets and ranked 221st in the Fortune Global 500 list of the world's biggest corporations of 2020, being the only Indian bank on the list. Roles and Responsibilities:

• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script.

• Responsible for optimizing all indexes, queries, stored procedures to improve the quality of software.

• Trained and guided offshore team members on building and maintaining No SQL application standards, policies, and procedures.

• Scheduled the jobs for SSIS packages under SQL Server Agent.

• Designed and developed Tabular Model Cubes and Dimensions using SQL Server Analysis Services (SSAS).

• Created database objects like tables, users, roles, stored procedures, triggers.

• Created some SSIS packages to import and export data from various data sources.

• Worked on tuning up and changing some of the existing SSRS reports as requested by the user.

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

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

• Extensively involved in Unit and UAT during the deployment of SSRS report.

• Worked on writing DAX queries and manipulating multidimensional data.

• Developed calculated columns and measures using DAX in Power BI.

• Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.

• Created interactive reports customized for the business using Power BI Desktop.

• Experience in combining data from different sources by using Power Query. Environment: SQL Server, Power BI, T-SQL, PL/MYSQL, SSIS, SSRS, SSAS, DAX Tata Consultancy Services, Hyderabad, India Jan 2016 – Sep 2017 Role: SQL/Power BI Developer

Description: Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company with its headquarters in Mumbai. It is a part of the Tata Group and operates in 150 locations across 46 countries. In July 2022, it was reported that TCS had over 600,000 employees worldwide. Roles and Responsibilities:

• Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.

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

• Wrote T-SQL queries, stored procedures and used them to build SSIS packages, SSRS reports and in Tableau.

• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.

• Troubleshooting reports issues, ETL job failures, optimizing query performances.

• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.

• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

• Designed and built-up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.

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

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

• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various data sources and thus, developed Cubes.

• Created user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.) Environment: MS SQL Server, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, MS Office, No SQL, MS Excel.

Contact this candidate