YOG CHAUDHARY

• Led development of NLP and ML-based plagiarism detection system, enhancing capability to analyze and manage complex datasets and systems architecture
• Demonstrated strong analytical and quantitative skills by achieving F1-Score of 0.96 in system testing, optimizing system performance based on detailed analysis

Environment Skills: Microsoft Power BI, Microsoft Excel, NLP, NLTK, LLM, Leadership, Statistical Data Analysis, Business Analysis, Analytical Skills, Statistics, Teamwork, Statistical Modeling, Problem Solving, Tableau, Communication, Data Science, Python (Programming Language), Data Analysis, Postgres SQL, and Machine Learning

• Developed and optimized a range of database objects including tables, views, and functions using Oracle SQL Developer and SQL Server (2017, 2019) to enhance application functionality and performance
• Implemented complex business logic through highly optimized stored procedures and functions using T-SQL
• Engineered robust data architectures utilizing Hadoop, Hive, Spark (Scala), and Kubernetes to support large-scale, cloud-based analytics
• Developed and optimized a range of database objects and ETL processes for high-traffic, cloud-based environments, significantly enhancing data functionality and performance
• Managed real-time data flows with Kafka and configured data pipelines, ensuring efficient data ingestion and analysis
• Actively managed DataMart operations and utilized advanced data warehousing technologies such as Snowflake and Redshift to optimize storage and support complex analytics and business intelligence reporting
• Designed and executed SSIS packages to facilitate the ETL process, improving data validation, extraction, transformation, and loading capabilities
• Spearheaded the migration of DTS packages to SSIS, enhancing data integration workflows
• Built and maintained robust data pipelines, automating the flow of data from various sources including databases, APIs, and external services into analytics-ready formats, ensuring efficient data querying and analysis
• Collaborated with business analysts and data scientists to refine analytics tools and dashboards, employing BI tools like Tableau and Power BI for effective data visualization and decision-making support
• Employed SQL Server tools like Performance Monitor and SQL Profiler for performance tuning, significantly reducing processing times and improving system responsiveness
• Ensured data accuracy and integrity through rigorous quality checks and compliance with governance standards

Environment: SQL Server 2017/2019 Edition, SQL scripts, PowerShell SQL Queries, XML, AWS Cloud, GCP, Hadoop, Hive, Snowflake, Kubernetes, Cloud, API, Kafka, Big Query, Teradata, Airflow, Apache Scala, Docker, Jenkins, JSON, Teradata, and PostgreSQL

• Engineered and maintained database objects such as tables, views, and functions, utilizing SQL Server 2017 and 2019 to develop highly optimized stored procedures and functions
• Created and managed SSIS packages for data export and import between SQL Server and various formats including Access, Text, and Excel files
• Leveraged cloud platforms like AWS and Azure for deploying applications and managing big data clusters, with hands-on experience in automating processes using Python scripts and BOTO SDK
• Configured and managed AWS resources such as EC2, Cloud Watch, and Cloud Formation.
• Developed a robust data interface layer using ASP.NET and C# to facilitate efficient data access and manipulation, aligning with the application’s functionality and performance requirements
• Developed and managed scalable data pipelines using Hadoop, Hive, and Spark (Scala) for enhanced data processing efficiency
• Developed Spark/Scala scripts for data extraction from various sources and provided insights and reports
• Designed and maintained scalable data pipelines using Python and SQL to enhance data processing efficiency
• Optimized ETL processes and query performance in Snowflake or Redshift, improving data indexing, query tuning, and workload management
• Managed data storage and processing using GCP, and AWS services, and integrated Docker container orchestration with Kubernetes
• Developed interactive dashboards using Tableau significantly improving decision-making processes across departments by providing actionable insights
• Automated ETL processes to reduce manual intervention and enhance data accuracy for business operations and reporting

Environment: SQL Server 2017/2019 Edition, JavaScript, SQL scripts, TDD, SQL Queries, Project, .NET Framework, C#, ASP.NET, SSIS, Azure Cloud, Hadoop, Hive, Spark using Scala, Kubernetes, Cloud, API, and Windows 2003 Server, ETL (Extract, transform and load)

• Actively engaged in the full SDLC, including analysis, design, implementation, and deployment, collaborating closely with front-end design teams to align back-end functionalities with user interface requirements
• Developed and managed a variety of database objects using Oracle SQL Developer, including tables, views, materialized views, and procedures
• Utilized SQL Server Integration Services (SSIS) to design, test, and execute data extraction, transformation, and loading processes across diverse data sources
• Implemented SSIS packages for efficient data migration between heterogeneous sources such as flat files and Excel, and optimized database performance through partitioning, bulk collections, and advanced SQL querying techniques including sub-queries and dynamic SQL
• Performed extensive server-level tuning and query optimization, utilizing SQL hints, indexes, and performance monitoring tools to enhance database operations and responsiveness
• Designed and developed comprehensive reporting solutions using SQL Server Reporting Services (SSRS), including dynamic, parameterized, and drill-down reports, enhancing data accessibility and decision-making across the organization
• Created web-based ASP.NET applications linked to SQL databases, facilitating firm-wide access to data and integrating complex business logic within interactive applications

Environment: SQL Server 2012/2016 Enterprise Edition, Enterprise Manager, JavaScript, ERWIN, UML, MS Project, Windows 2012 Server, .NET Framework, C#, Mongo DB, ASP.NET, AWS Cloud, Hadoop, Hive, Teradata, Spark using Scala, and Data Lake

• Developed and managed project budgets for multiple large-scale construction projects, ensuring alignment with financial goals
• Conducted comprehensive analysis of financial data to identify trends, forecast future financial conditions, and inform strategic decisions, enhancing company's financial planning and budgeting processes
• Developed and implemented cost control measures that significantly reduced unnecessary expenditures, improving company's overall financial health and increasing profitability
• Produced regular financial reports using advanced analytics tools, providing critical insights into revenue streams, expenditure patterns, and investment opportunities, which guided executive decision-making
• Collaborated with project managers and department heads to gather financial data and insights, ensuring alignment of project budgets with company financial goals and objectives
• Designed and monitored key performance indicators (KPIs) related to financial performance and construction project efficiency, driving improvements in operational workflows and economic outcomes