Kumar Myneni Email & Phone Number

● Highly Motivated SQL Server Developer with more than 4 years of experience in professional application and database development with thorough knowledge of different phases of software development lifecycle including analysis, design, development, documentation, deployment, and system support● Experience in designing the database in SQL Server, Azure, Oracle, and skilled in business intelligence applications such as SSIS, SSMS, SSAS in Development, Test and Production Environments, as well as visualization tools such as Power BI, SSRS. The industries I have experience in are Information Technology, Security, and Finance● Hands on experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS) & Power BI. ● Extensive knowledge and experience in producing tables, reports, graphs, and listings using various procedures and handling large databases to perform data manipulations.● Experience in maintaining one to many and many to one relationship while moving data between two databases● Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.● Working experience in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) Views and Indexes. Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL). Expertise in writing T-SQL Queries, Complex Stored Procedures, creating Triggers, Cursors, User-defined functions, Joins and Common Table Expression (CTE)● Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SQL Server, MySQL, Oracle, flat file, AWS, Azure, ERP systems.) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.● Experience in report writing using SQL Server Reporting Services (SSRS) / Power BI and creating various types of reports and dashboards like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, slice and dice, bookmark, ad-hoc and sub reports features and Sub Reports● Enhanced the functionality in data ware housing concepts (OLAP) Cube by creating KPI, Actions, Perspective and Hierarchies using SQL Server Analysis Services (SSAS) and Dimensional Modeling Techniques such as Star and Snowflake schema.