Shashank . Email & Phone Number

California, United States

• My role involved actively engaging with end users to meticulously gather their requirements. • Worked closely with stakeholders to understand their specific data needs, ensuring a thorough grasp of the project's objectives from the outset. • Demonstrated expertise in designing, developing, and maintaining BI solutions using Power BI.• Obtaining the necessary data for reports, navigating through diverse data sources, including SQL Server databases and Microsoft Azure SQL databases.… Show more • My role involved actively engaging with end users to meticulously gather their requirements. • Worked closely with stakeholders to understand their specific data needs, ensuring a thorough grasp of the project's objectives from the outset. • Demonstrated expertise in designing, developing, and maintaining BI solutions using Power BI.• Obtaining the necessary data for reports, navigating through diverse data sources, including SQL Server databases and Microsoft Azure SQL databases. • Strong SQL writing skills for designing, coding, and testing Oracle SQL queries.• Applied dimension modeling techniques in BI DataMart/warehouse design.• Proficient in using ETL tools such as Alteryx for efficient data extraction, transformation, and loading.• Solid experience in writing and implementing Data Analysis Expressions (DAX) in Power BI for advanced analytics.• Utilized UX Wireframes tools like Figma to deliver visualizations, collaborating closely with the product team.• Worked on Power BI extraction, transformation, and loading (ETL) of data in Power BI, ensuring that it's ready for report generation. • Key contributor, in charge of task assignment within the development team. • Emphasizes strategic allocation of responsibilities, ensuring that team members are aligned with project goals and deadlines. • Actively participate in the development phase, leveraging my expertise to create custom Power BI visualizations and interactive dashboards. • Importing and integrating data from SQL Server and Azure SQL databases into Power BI, which enables to generate of insightful reports that drive data-driven decision-making. • Created custom Power BI visualization and dashboards, imported data from SQL Server DB, and Microsoft Azure SQL DB to Power BI to generate reports. • Delivered projects/reports/dashboards with 100% assigned tasks within the agreed budget and earned appreciation from business, team leads, and solution architects. Show less

Covington, Louisiana, United States

• Have involved in requirement gathering, meeting customers, understanding the data needs, and working with the data team to get the data for reports.• I created 95% custom Power BI visualization and dashboards, imported data from SQL Server DB, and Azure SQL DB to Power BI to generate reports.• Delivered 95% of the projects throughout my career in 100% assigned tasks within the agreed budget and earned appreciation from business, team leads, and solution architects.• I created Dax… Show more • Have involved in requirement gathering, meeting customers, understanding the data needs, and working with the data team to get the data for reports.• I created 95% custom Power BI visualization and dashboards, imported data from SQL Server DB, and Azure SQL DB to Power BI to generate reports.• Delivered 95% of the projects throughout my career in 100% assigned tasks within the agreed budget and earned appreciation from business, team leads, and solution architects.• I created Dax Queries to generate computed columns in Power BI, and generated computed tables in Power BI by using advanced DAX features.• Involved in creating new stored procedures and optimizing existing queries and stored procedures.• Experience in using Power BI, and Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.• Published Power BI Reports in the required originations and Made Power BI Dashboards available to Web clients and mobile apps.• Developed and implemented a reports/dashboard theme that is used for all reports in Power BI.• Used Power BI to collaborate with different users and stakeholders to work on live data sources.• Imported data from Oracle Database to Power BI, creating data models to generate Power BI reports.• Created Security in the models based on the Access for the user.• Working on Power BI paginated reports to separate single reports into multiple based on department and implemented data security to access only department data.• Explored data in a variety of ways and across multiple visualizations using Power BI, used Power BI Gateways to keep the dashboards and reports up to date by setting up refresh schedules in the apps.• Published reports, and dashboards using Power BI, Created Dax Queries to generate computed columns in Power BI, and generated computed tables in Power BI by using Dax. Show less

Raleigh, North Carolina, United States

• Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.• Utilized ETL/ELT processes, data analysis, and Power BI to ensure data accuracy and completeness, creating various chart types, including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots, and Slicers.• Delivered actionable insights and key business performance metrics by creating custom Power BI dashboards and… Show more • Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.• Utilized ETL/ELT processes, data analysis, and Power BI to ensure data accuracy and completeness, creating various chart types, including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots, and Slicers.• Delivered actionable insights and key business performance metrics by creating custom Power BI dashboards and visualizations.• Provided solutions for data warehousing, system engineering, and business intelligence.• Developed a data warehouse by loading data from structured, semi-structured, and unstructured data (CSV, HTML, XML, JSON, PDF) using Python, MySQL, and shell scripts to load data into relatable data tables.• Developed end-to-end web-scraping scripts using Python, beautiful soup, and regular expressions to gather information from public documents and websites.• Automated the collection and normalization of data from various sources into a single data repository, data warehouse, or framework.• Manipulated and analyzed large datasets using Microsoft Excel, including sorting and filtering data, creating pivot tables, and using advanced functions such as VLOOKUP and SUMIF.• Leveraged Microsoft Excel to identify trends, patterns, and anomalies in data, resulting in improved decision-making and business outcomes. Show less

Rockville, Maryland, United States

• Designed and developed Power BI visualizations based on business requirements and created Dashboards, apps, and shared reports to end users.• Developed Restful APIs using Python Flask and data models as well as ensured code quality by writing unit tests using Pytest.• Worked with the line of business and developers ‘to capture data lineage as well as a business and technical definition for elements.• Installed and configured MS SQL Server 2016 along with Visual Studio on a network… Show more • Designed and developed Power BI visualizations based on business requirements and created Dashboards, apps, and shared reports to end users.• Developed Restful APIs using Python Flask and data models as well as ensured code quality by writing unit tests using Pytest.• Worked with the line of business and developers ‘to capture data lineage as well as a business and technical definition for elements.• Installed and configured MS SQL Server 2016 along with Visual Studio on a network domain system.• Worked on Snowflake with Python to create databases, views, and tables.• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.• Have contributed to building multidimensional data models in TM1 (including Perspectives, Architect, Contributor, Web, Rules, and Turbo Integrator).• Good experience in identifying the Facts, Dimensions, Levels/ Hierarchies of Dimensional Modelling.• Worked with various Python libraries such as Pandas and Matplotlib for analysis and Manipulation • Created Tabular Models using DAX queries in analysis services and deployed them.• Worked on admin activities like tenant changes, user access, update gateway connections.• Created measures, columns, hierarchies, and tables using Tabular Editor.• Created scripts to create new tables, views, and queries for new enhancement using Snow SQL.• Worked on-premise on a cloud migration project which involved data from Hadoop to AWS (data warehouse).• Built SSIS packages to Load data from source systems to the Data warehouse.• Validated the ETL load between different sources (Oracle and Flat files) to Hive target tables using HQL and Python.• Good experience in creating public objects like Metrics, Filters, Prompts, Custom groups, Consolidations and Reports.• Created hierarchies in Power BI reports using visualizations like Bar charts, Line charts, etc.• Responsible for creating Row-Level Security (RLS) based on business requirements. Show less

Houston, Texas, United States

• Worked on creating dimensional models using star schema and snowflake schema.• Designed Facts and Dimensions that supports the business requirements and reporting needs.• Created ETL packages with different data sources (SQL Server, Oracle Source, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages• Worked on Creating SSIS Packages to load the files from SFTP Path on daily basis.•… Show more • Worked on creating dimensional models using star schema and snowflake schema.• Designed Facts and Dimensions that supports the business requirements and reporting needs.• Created ETL packages with different data sources (SQL Server, Oracle Source, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages• Worked on Creating SSIS Packages to load the files from SFTP Path on daily basis.• Created SSRS inventory management reports, focused on findings to save company millions of dollars in Client members Performance Health management by providing Incentive, Claims, Biometrics file feeds. • Designed and developed stored procedure, queries and views necessary to support the SSRS reports.• Created various Drill through, Parameterized, Tabular reports and matrix reports using SSRS and created subscriptions for users.• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time). • Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer. • Worked on Creating, Modifying and updating the Views and Functions.• Modified the existing stored procedures to get the new functionality depending on the client requirement.• Worked on Views, CTE's, schemas, permissions issues with client/server database design.• Written Calculated Columns, Measures, and Queries in Power BI desktop and also Tabular model to show good data analysis techniques.• Worked on creating Power BI Dashboards using tabular model.• Data Visualization development using Tableau to create complex, and innovative dashboards. Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports.• Converted existing SSRS reports to Tableau and created different KPI using calculated key figures and parameters. Show less

India

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment for SQL Server 2008R2.• Developed Database Triggers to enforce Data integrity and Referential Integrity.• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.• Assisted in creating fact and dimension table implementation in… Show more • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment for SQL Server 2008R2.• Developed Database Triggers to enforce Data integrity and Referential Integrity.• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.• Defined relationship between tables and enforced referential integrity.• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc• Established connectivity to database and monitored systems performances.• Performance tuning and monitored both T-SQL and PL/SQL blocks.• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.• Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.• Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables. Show less