Client: Child Welfare Digital Services, California State•Data Team: Played a key role in a team for BI view development, Source Repository, Semantic Layer, Semantic Layer Automation, Data Model Using SQL DBM.•Snowflake is the major Database utilized in the project.•Developed complex BI Views using SQL for the Tableau team. •Optimized application performance through fine-tuning stored procedures and SQL queries for efficient data retrieval.•Utilized UDF, Indexes, Stored Procedures, Temporay tables and Materialized Views to enhance database performance.•Utilized Streams, Pipes,Tasks and Time travel to perform various tasks in Snowflake.•Received Meta data updates every two weeks from Sales Force. Utilized various macros, UDFS to to transform and load the meta data to various Environments.•Developed the Semantic layer, Source Repository and the automation of them, enhancing data representation and accessibility.•Developed automation scripts For Semantic Layer using SQL, contributing to process optimization and efficiency improvements.•As part of Semantic Layer we standardized naming convention, Augmented Helper columns, added pre joins to make it easy for Bi view developers.•Managed the deployment of various codes across different environments using Alembic, ensuring smooth transitions.•Developed comprehensive Entity Relationship Diagrams (ERDs) and Subject Areas using SQL DBM.•Conducted Reverse engineering option in SQL DBM to generate detailed data models for the project.•Created and maintained Data dictionaries using SQL DBM, providing a valuable resource for BI view developers and end clients.•Played a pivotal role in gathering and understanding project requirements in close collaboration with the state team.•Ensured project deliverables aligned with client needs, maintaining a client-focused approach.•Utilized GitHub for version control, fostering collaborative development and streamlined code management.

Instruct the Lab and maintain the student records

Tutor all computer science bachelor courses

•Client: VanguardCustom Business Solutions Team Member: Played a key role in a team responsible for providing applications, maintaining data, and predictive models to 300 business teams, enabling them to carry out their work effectively.•Managed multiple projects with diverse requirements from various business teams.•Gathered raw data from various sources and performed data preprocessing techniques to clean and transform the data for analysis.•Performed data modeling and built databases in Ms Access DB and Microsoft SQL Server.•Optimized application performance by 25% through fine-tuning stored procedures and SQL queries for efficient data retrieval.•Utilized Functions, Indexes, Stored Procedures, Packages, Triggers, and Materialized Views to enhance database performance.•Generated reports and visualized data using Power BI and Tableau, interpreting complex data sets within relational databases. Wrote complex queries using MS SQL Server and MS Access DB.•Created interactive Tableau stories with Advanced Mapping Techniques, Parameters, Custom Geocoding, Data Blending and complex calculations.•Used advanced chart visualizations in Tableau, such as dual axis, box plots, bullet graphs, treemaps, bubble charts, and waterfall chart, to solve complex problems and to create interactive dashboards/Stories and visualizations.•Developed macros and reports in Excel, enhancing efficiency and data analysis capabilities.•Few projects required developing machine learning models. Used libraries such as pyodbc, Pandas, and SQLalchemy to connect, extract, transform, and load data into SQL Server.•Transformed and analyzed the retrieved data using libraries like Pandas and NumPy.•Applied data preprocessing techniques, including handling missing values, normalization, and feature scaling using Pandas and NumPy.•Developed machine learning models using the Scikit-learn library for tasks such as classification, regression, or clustering.

•Designed and built robust databases using efficient data modeling techniques, including ER diagrams, to ensure optimal data organization and retrieval.•Collaborated closely with stakeholders and developers to gather requirements and translate them into effective database designs.•Utilized industry-standard methodologies, such as Entity-Relationship (ER) modeling, to capture and represent complex relationships between entities.•Utilized Swim lane Workflow diagrams to analyze, document, and optimize business processes across various departments.•Collaborated with stakeholders to identify bottlenecks, streamline operations, and improve overall workflow efficiency.•Developed SQL queries to populate, manipulate, and retrieve data from the databases.•Created interactive dashboards and reports to users in Tableau by connecting various data sources.•Created interactive Tableau stories with Advanced Mapping Techniques, Data Blending and complex calculations.