Ramakrishna M.

Background

About Ramakrishna M.

Experience in MS SQL Server 2008/2008R2/2012/2014/2016/2019 and Hands on experience in installing, configuring, managing, monitoring, and troubleshooting. • Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS). • Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing. • Experience with all phases of software development life cycle (SDLC) and project methodologies. • Good hands-on Azure Data Factory. • Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages. • Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands. • Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server, Oracle Database, Excel, and Flat file to Microsoft SQL Server by using SSIS and DTS utility. • Excellent experience in.NET Platform Technologies in both Web Forms and Win Forms using ASP.NET, C#, Web Services, XML/XSLT. • Experience in SAS ETL in design and development of ETL processes for data integration projects to build data marts. • Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP. • Extensively used performance monitor/SQL profiler to solve dead locks/long running queries. • Experience in working with report development in MS-Office Access, MS Excel, and Crystal Reports. • Experience in working on administration tasks such as data loading, batch jobs, data unloading, user and application table management, upgrades, creating databases/ file groups/ files/ transaction logs. • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools. • Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server). • Scheduled Jobs in Flows and ADF Pipelines • Experienced in manual, automation, integration, and performance testing. • Quick learner and good performer both in team and independent job environments.