Manoj Sharma

Manoj Sharma E-mail:-Mobile: - Summary Have trained and certified Level-1 in .NET in IGATE. Involved in Microsoft Project activities like development, testing & Maintenance. Involved in Wealth Management Project activities like development, testing, documentation & maintenance. Expertise in writing codes, debugging and in error handling. Enriched with the ability to learn new concepts & technology within a short span of time. An effective team player with exceptional planning & execution skills coupled with Interpersonal & Communication skills along with clarity of fundamentals with perseverance to succeed & zeal to achieve. Key skills Core skills: SSRS, SQL, SSAS, Power BI Secondary Skills : C#, . Net Web development: ASP.NET, HTML, CSS, Web Services Windows Development: WPF, Win Forms Databases: Ms SQL/T-SQL, ADO.Net Entity Framework IDE, Components, Tools: Visual Studio 2008/2012, SQL Server 2008/2012, HPQC, Report Builder Relevant experience Tata Consultancy Services: Sept 2015 – Till Date IGATE Global Solution: June 2013 – Sept 2015 Tata Consultancy Services: Assignment 1 Client: Microsoft. Period: April 2016- Nov 2017 Project Name: Search Analytics Project Type: Development & Maintenance Key Skills : SSIS, SSAS, SQL, Power BI Tools : Visual Studio 2008/2012, SQL Server 2008/2012 Role: System Analyst Responsible for: Manipulating Bing Data from Cosmos Creating the Power BI Reports using the tabular cubes created by us. Testing and maintaining the SQL Jobs & the reports created by us. Creating the new Stored Procedures to pull the data from the cube using SQL Brief description of the project: In Search Analysis, Bing Data of Microsoft is pulled from COSMOS using Scope script and dumped in SQL tables. We are creating the Stored Procedures to pull the data from the data warehouse of Microsoft and dumping that in SQL tables. Here we are creating Power BI reports to represent the daily, weekly & monthly data to the client for analysis. Earlier we were using the Power View for that but now we have migrated the reports from that to Power Bi Desktop. Assignment 2 Client: Microsoft. Period: Sept 2015- March 2016 Project Name: Windows Development Group Project Type: Development & Maintenance Key Skills : SSIS, SSAS, C#, SQL, Power BI Tools : Visual Studio 2008/2012, SQL Server 2008/2012 Role: System Analyst Responsible for: Developing the new ETLs(Packages) Creating the Power BI Reports using the tabular cubes created by us. Testing and maintaining the packages & the reports created by us. Creating the new Stored Procedures to pull the data from the cube using SQL Brief description of the project: Windows Development Group generally works with the windows work of the Microsoft. We are creating the packages to pull the data from the data warehouse of Microsoft and dumping that in SQL tables. Here we are creating Power BI reports to represent the daily, weekly & monthly data to the client for analysis. Earlier we were using the Power View for that but now we have migrated the reports from that to Power Bi Desktop. IGATE Global Solution: Assignment 1 Client: Royal Bank of Canada. Period: Nov 2014- March 2015 Industry: Banking (Wealth Management) Project Name: Asset & Account Processing (APP) Migration Project Type: Migration & Development Key Skills : ASP.NET 4.5, C#, SQL Server 2008/2012, Crystal Report, SSRS Tools : Visual Studio 2008/2012, SQL Server 2008/2012 Role: Sr. Technical Developer Responsible for: Assessing 34 applications and its components and understanding the flow and architecture of the same Documentation of the approach/assessment of the applications and doing POC’s for the same. POC for migration of reports from crystal report to RDLC file and estimation and documentation of the same. Assessment of databases getting affected and the documenting the same Brief description of the project: CWM intended to migrate 34 application and the associated jobs with the applications and the class libraries used. It includes migration of database from MS SQL 2005 – MS SQL 2012 and applications from 1.1 framework to 4.5.2. In this the web services involved need to be migrated to WCF and crystal reports need to be rewritten in RDLC. Assignment 2 Client: Royal Bank of Canada. Period: June 2014- Oct 2014, April 2015-Sept 2015 Industry: Banking (Wealth Management) Project Name: Fee Billing Project Type: Maintenance & Reporting Key Skills : SSRS, SQL 2008, C#, VB, ASP.Net Tools : Visual Studio 2008/2012, SQL Server 2008/2012 Role: Sr. Technical Developer Responsible for: Analyzing the report design & coming up with the report using the SSRS reporting tool. Developing the Stored Procedure for each report according to the requirements. Resolving issues which comes after mapping the Stored Procedure with the Report. Writing the Formulae & expressions in the report according to the Requirements. Grouping the data fields according to the requirement. Optimizing the Stored Procedure & Queries. Creating the Unit Test cases for each report & testing the same. Providing QA support and also fixing defects during QA stage. Brief description of the project: CWM intended to create the RDL Reports for the Fee Billing Project. For each reports different Stored Procedure are created & mapped with it. Grouping & formulae are used in designing of the report. Assignment 3: Client: Royal Bank of Canada. Period: Dec 2013 – May 2014 Industry: Banking (Wealth Management) Project Name: PHN Project Project Type: Reporting & Development Key Skills : SSRS, SQL 2008, C#, VB, ASP.Net Tools : Visual Studio 2008/2012, SQL Server 2008/2012 Role: Technical Developer Responsible for: Analyzing the report design & coming up with the report using the SSRS reporting tool. Developing the Stored Procedure & Queries for each report according to the requirements. Resolving issues which comes after mapping the Stored Procedure or Query with the Report. Writing the Formulae & expressions in the report according to the Requirements. Optimizing the Stored Procedure & Queries. Creating the Unit Test cases for each report & testing the same. Providing QA support and also fixing defects during QA stage. Providing support during Production implementation. Brief description of the project: Data Warehouse & Business Intelligence group of RBC Investor services intendeds to create the reports using the SQL 2008 & BIDS. The purpose of this development is to have all the data in the systematic manner & user friendly. To fetch the data from the database, Stored Procedure are created and mapped accordingly with the reports. Certificates Pat on Back Award - For helping the Human Resource team in the Annual Appraisal-2014. Education & Learning Competency Competency Proficiency Category Sub Category Core .NET Technologies E2 Architecture & Tools Microsoft Platform Architecture Quality Management for Delivery E0 Delivery Quality Management for Delivery C# 4.0 E0 Foundation Core Platform SQL Server 2012 Development E1 BIPM Microsoft SQL Server 2012 Business Intelligence SQL Server 2012 Integration Services (SSIS) E1 BIPM SSIS C# 5.0 E1 Foundation C# Certification Certification Name Acquired On Expired On Version Microsoft : Core.NET - C# 5.0 Intermediate 08-Mar-2017 1.0 Process : ITIL 2011Foundation_Foundation 12-Jan-2017 1.0 Process : Agile Delivery Foundation 04-Jun-2016 1.0 Foundation : Microsoft Core .NET - C# Five_Foundation 03-May-2016 1.0 Digital : HTML5-CSS3 Intermediate 29-Sep-2016 1.0 Digital : BigData and Hadoop Ecosystems_Foundation 15-Apr-2016 1.0 Education B. Tech – Himachal Pradesh University in 2012 69.2% Senior Secondary-PCM(CBSE) Delhi Public School-Jhakri, Shimla(Himachal Pradesh) 67% Secondary- CBSE DAV Public School-Rampur, Shimla(Himachal Pradesh) 84% Declaration: I hereby declare that above information is correct to the best of my knowledge and belief. Place: Pune