Manoj Kumar Email & Phone Number

• 12+ years of experience in area of Software Development as SQL Server and SSRS developer. • Experience in Complex queries, transactions, sub queries, procedures, nested procedures, triggers, TVP (Table Valued Parameter), user defined functions (Scalar, Table Valued), performance tuning of queries, creating tables, views.• Experience in Drill through, drill down, cascading parameters, dynamic columns, dynamic chart types, dynamic images and deployment of reports (SSRS).• Worked in Agile SCRUM methodology and involved in full life cycle of a product design, development, Deployment and support• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.• Configure the report server and generated the report models for user interactions.• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.• Experience in Data Modeling and created Entity Relationship (ER) diagram by following Normalization and Denormalization techniques.• Excellent skills in Log Shipping, Transactional, Snapshot Replication, Database Backup and Linked Servers.• Expert in transforming complex business logic into Database design and maintaining it by using Stored Procedures, User Defined Functions, Views, TSQL Scripting and Jobs.• Used TFS for database version control with CICD (Continuous Integration Continues Deployment).• Worked on patch release of database changes using T SQL scripts and DACPAC deployment.• Experience in Complex queries, transactions, sub queries, procedures, nested procedures, triggers, user defined functions, performance tuning of queries, creating tables, views and deployment of database object changes in My SQL.• Expertise in installing, designing, developing, maintaining and tuning of SQL Server 2014,2012,2008 and 2005.

Listed skills include Microsoft Sql Server, Sql, Html, Web Services, and 8 others.