Gaurav Ashokrao Deshmukh

GAURAV ASHOKRAO DESHMUKH Associate Consultant, Datamatics Pvt. Ltd. Address: Hariangan Building, Near Akurdi Railway Station Pune-411035 Contact: (- E-Mail:- There are no secrets to success. It is the result of preparation, hard work and learning from failure. PROFESSIONAL SUMMARY Currently working as Associate consultant with Datamatics Pvt Ltd since March 2019. Experience in analysis, development, enhancement and production support for various Database/MSBI applications. Responsible for database design, development, Performance Tuning, maintenance and Support. Extensively used tools MS SQL Server 2012, 2016 SQL Server Business Intelligence Development Studio, MS Visual studio 10/12/13 and Visual Source Safe 2005 for projects. Adept in developing T-SQL queries and writing stored procedures, Functions, Triggers, View using MS SQL Server for project requirement. Worked on SVN, Git as version control tools. Worked through all the phases of Software Development Life Cycle (SDLC) including requirements gathering, analysis and design, coding, unit testing and deployment. Efficient use of Agile Methodology. A problem solving aptitude and willingness to take up ownership and Initiative. Efficient and quick defect solving capability. Involved in the Post development support, maintenance, code Fix and Data Fix activities. SKILL SET Databases MS SQL Server 2012 ETL Tools SSIS Integrated Development Environment SQL Server Business Intelligence Development Studio, MS Visual Studio 2010/2012 Languages Known SQL,HTML,C#,ASP.net Version Control Visual Source Safe 2005, Tortoise SVN. Rich Exposure towards SSRS PROJECTS EXPERIENCE Project:Delarue CertifyJanuary-2020 to till date Client: De La Rue, UK Domain: Logistics Company: Datamatics Pvt Ltd Role: MSBI Developer. Team Size:35 Description: De La Rue provides governments and commercial organizations with products and services that underpin the integrity of trade, personal identity and the movement of goods. Operating in the fundamental areas of cash supply chain and supports customers across the map in managing every part of the cash supply chain, De La Rue design, integrate, manufacture and deliver banknotes, banknote paper, polymer and security features to ensure currencies are secured against the threat of counterfeit and fraud. Technology used: SQL server database 2016, SSIS 2016.  Responsibilities: Owing all responsibility for Data Migration, Data Mart Design, DB object maintenance, DB code optimization and code review of developers. Created HLD, LLD & source to target mapping for ETL development. Build, test and deploy database objects, ETL jobs, SQL procedures/scripts. Modification of Database Objects, Procedures, Views and Functions as per business need. Communication with the Onsite team & solving technical problems. To analyze and accommodate changes in client requirements, after performing impact analysis and effort estimation. Build and test changes in development as well as in UAT environment before production deployment. Project:Mis projectMarch-2019 to December 2019 Client: Manipal Cigna Mumbai. Domain: Health Insurance Company: Datamatics Pvt Ltd Role: SQL and MSBI Developer. Team Size:5 Description: Mis is responsible for providing various business reports on daily basis. Reports are divided into channel, hierarchy level, and region wise. Reports are used for analysis, business growth, strategic decisions and actuarial science. Technology used: SQL server database 2012, SSIS and SSRS, excel.  Responsibilities: Requirements Gathering and direct interactions with the Stakeholders. Create stored procedure for new requirements. Create SSRS reports as per end user requirements. Create SSIS package for ETL development as different sources of getting data. Enhancement in existing report and bug fixes. Create ad-hoc report based on user requirements. Share daily and monthly reports as part of BAU. Automating excel reports into SSRS. Project–Syntelligence Portal-From Aug 2016– Mar 2019 Client: - Syntel Pvt Ltd, Mumbai, India Designation: - Software Engineer Domain: - Internal HR Company: Atos Syntel Description: Syntelligence Portal manages all the data related to employees working in Syntel. It is a huge data center with onsite and offshore employees Attendance details, Leave details, Headcounts and Policy Enrollments. Microsoft SQL Server 2012 is used to store and retrieve data efficiently. Technical glitch is handled by backend changes and Stored Procedures. Role:SQL Developer. Team Size:8 Technologies Used:SQL Server 2012, SSRS, SSIS Responsibilities: Requirements Gathering and direct interactions with the Stakeholders. Writing Stored procedures, triggers, function, view and T-SQL queries. Created SSRS projects and SSIS packages. Enhancements in existing procedures and scripts. Query optimization. Unit testing and bug fixes, Post production support. Complete Documentation. EDUCATIONAL DETAILS Course Year Name of Institute University /Board Marks Obtained (%) B.E. Computer 2016 SSBT College of Engineering,Jalgaon North Maharashtra University Final year:-79.8% Aggregate:-74.4% HSC 2012 Y. M. College, Nanded Latur Board 72.17% SSC 2010 M.P.H.School, Nanded Latur Board 99.64% ACCOLADES Rated Excellent-20 in the yearly appraisal cycle at Syntel. Promoted from AC-AC1 (Application Trainee) to AC-AC2 (Software Engineer) at Syntel. Appreciations from Clients and Project Manager for solving complex issues. Took accountability and executed multiple projects simultaneously Extra-Curricular Activities Coordinator of ShodhPrakalpPratiyogita. Coordinator of Online Event Registration Committee. Participate in various National Level Events. Published IEEE paper on GDPUS KEYPAD BASED ALGORITHM FOR SECURED TEXT COMMUNICATION Personal Detail Gender : Male Marital Status: Single Date of Birth: 29-June-1994 Languages Known : English, Hindi, Marathi Nationality: Indian. I hereby declare that information furnished above is true to the best of my knowledge. Place: Pune Gaurav Ashokrao Deshmukh Date:.