Rajesh Yadav

Rajesh is a seasoned Business Intelligence/Data Engineering/Data Science/Big Data consultant and Architect with knack to understand the Core system and perform system analysis and use hands down approach to shape the system architecture, implement and deliver measurable business values and tangible outcomes. In his career he is responsible for business requirement analysis, Client Engagement and Coordination with team, prepare technical and functional manuscript to meet business requirement and involve in end-to-end SDLC process. Engaged with Marketing Directors and Business PM’s as a Data consultant and generating the IT needs and its execution delivery. Having 16+ Years of IT Experiences in Data Modelling, Data Mart Development & Maintenance of Data Warehousing and Client server Application with Banking & Finance, Manufacturing with expertise in MS SQL Server 2005/2008 R2/2012 and products like SSAS, SSIS, SSRS, Multidimensional (MDX), Data Analysis Expressions(DAX), Tabular Model, Power BI, SharePoint, .NET(C#, VB, ASP), WCF Services, Web Services, Microsoft Azure Services, Azure Data Lake, Azure Data Factory, Crystal Report., Informatica, Rest API Integration, Dell Boomi, HIVE, SPARK, Python, SCALA, AZURE DATABRICKS, STREAMING, KAFKA, EVENT HUB, NoSQL, MONGODB, COSMOSDB, ELASTICSEARCH, AZURE SYNAPSE ANALYTICS, SNOWFLAKE, ML. Architected and implemented Data Science Infrastructure using Microsoft Azure Cloud and designed and implemented the VNET based architecture. Architected and designed the model creation and deployment strategy for Data Science projects. Experienced in Data Extraction, Migrations, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2008 R2/2012/2014/2017 respectively. Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS). Experiences in various types of tasks control flow and data flow in SSIS. Good Experience in Implementing Checkpoint, Transactions in SSIS. Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 R2/2012 (SSRS). Strong Experience in Creating Different Reports like Drill through Dashboard Reports, Drill down Report , Matrix Reports, Sub Reports, Ad hoc Reports, Tabular Reports, and Chart Reports. Strong experience in Stored Procedure/TSQL coding, Performance tuning, and Query Optimization. Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins. In-depth knowledge of working and implementation of WCF services and Web Services. Worked on all phases of software development life cycle including Analysis, Design, Development, Testing, Peer Code Review and Support. Having Good knowledge of Big data, Hadoop and Microsoft Windows Azure concepts and tools, technologies. Good knowledge of Cloud integration using SSIS and Dell Boomi. Drafting business proposal and architecture for various projects. Good knowledge on Private Banking, Investment Banking, Leasing and Manufacturing Process. Good knowledge on IOT and Azure Services. Good understanding of OOAD and OOP’s concepts. Versatile Solutions Architect adept at working with stakeholders to enable and enhance technical development efforts and accomplish business goals. Well-organized project and team manager with a tactical and test-oriented approach. Ready to bring 16+ years in IT and pursue a new professional challenge.

• Academy Accreditation - Generative AI Fundamentals Databricks
• SP800-Az: Getting Started with Apache Spark DataFrames (Azure Databricks)