Vinod Sharma

MICROSOFT SQL/BI SENIOR DATABASE CONSULTANT CUM ANALYST WITH 16+YEARS OF EXPERIENCE IN THE IT SECTOR at MeridianSoft
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
IN
Languages
  • English -
  • Hindi -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Higher Diploma in Software Engineering [HDSE] (2 years) - (Equivalent to PGDCA)
    Aptech
    Sep, 1996
    - Oct, 2024
  • Microsoft Certified IT Professionals [MCITP]
    Microsoft
  • Microsoft Certified Professional Developer and Enterprise Application Developer [MCPDEA]
    Microsoft
  • Microsoft Certified Technology Specialist [MCTS]
    Microsoft

Experience

    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • MICROSOFT SQL/BI SENIOR DATABASE CONSULTANT CUM ANALYST WITH 16+YEARS OF EXPERIENCE IN THE IT SECTOR
      • Mar 2012 - Present

      Strong functional knowledge of all the aspects of Software Development Life Cycle – Requirement Analysis, Design, Coding, Unit Testing and Maintenance. Worked on Waterfall, Bottoms-up, Agile Scrum and Kanban Processes. Project Management, People Management, Requirement Analysis, Estimation, SRS, Quality Assurance, Risk Management, Team Work Review and Coordination between onshore and offshore teams are the major areas of working. Total 16.3 Years of experience in the IT sector. Out of that around an 8+ years of experience in People and Project management and around 10+ years of experience in MS SQL and BI Tools (SSRS, SSIS, SSAS, PPS and Sharepoint). o Responsible to execute the MS SQL and BI Practice. o Interaction with Onshore team members to requirement gathering and work status update. o Responsible for work estimation, Sprint Planning and work Estimations. o Project work analysis, design documents preparation and build preparation. o Assisting team members whenever they need any help. o Designing new SSRS, SSIS packages and new cube related objects enhancement. o Doing Performance tuning of SSIS, SSRS, SSAS and SQL Code. o Writing code like an SQL queries, Stored Procedures and Functions. o Designing new Dimensions and Facts. o Designing Tabular semantic models for Power Pivot Reports. o Taking care of the entire production server’s health checkup (Replication, Log shipping and Other Jobs) o Responsible to deploying builds for SSIS, SSAS, SSRS and SQL objects. o Check-In/Check-Out the objects using TFS. Show less

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Regional Practice Director - MS SQL/BI
      • Jan 2010 - Mar 2012

      Responsible for MSSQL and BI Practice, People and Project Management. Responsible for MSSQL and BI Practice, People and Project Management.

    • India
    • Software Development
    • 1 - 100 Employee
    • Offshore Project Lead cum Delivery Manager
      • May 2007 - Jan 2010

      • Coordinating with onsite and offshore team members to understand the actual requirements as well as for smooth working of the project. • Doing analysis, designing, reviewing and testing work. • Doing analysis to design Dimensions, Facts and Cubes by using SSAS services. • Designing Database structure for staging and data warehouse. • Designing of ETL packages and reports by using SSIS and SSRS services. • Preparing Test Plans, test cases and doing review work for the team member’s work. • Developing and Reviewing Data validation queries for data testing end to end. • Preparing user manuals, functional and technical documents. Show less

    • Sr. Software Engineer
      • Aug 2005 - May 2007

      • Exploring technical architecture for the project. • Interaction with Onsite Team members to understand the actual requirements & smooth working. • Writing new / enhancing existing stored procedures and scripts as per user’s requirements. • Doing analysis, Designing, coding and unit testing. • Worked as Lead as well as Sr. Software developer in SQL Server 2000 / 2005 and main stress were on Analysis the requirements, Development and Unit testing. • Doing Performance Tuning for existing SPs. • Maintaining versioning of the project in Merant Versioning System (PVCS). • Taking care of Nightly Jobs Monitoring and Server performance status daily. • Creating new/enhancing packages by using ETL Services of SQL SERVER 2005. • Co-ordinate with team members for smooth working of the project. • Working on ETL and Reporting part of the project. Show less

    • Team/Project Lead
      • Nov 2001 - Aug 2005

      • Defining deliverables, planning and managing project schedules. • Explore technical architecture for the project. • Maintaining versioning of the project. • Finalized requirement analysis for the project. • Finalized writing of use cases and user interface design with data flow with the client. • Finalized database design with Software Requirement Specifications (SRS) • Defined classes to be used by self and other software engineers. • Finalized stored procedures required. • Worked on crystal reports 9.0. • Supervising unit testing of completed modules. • Client interaction to act as key bridge between the company and the client. Show less

    • Consultant to Govt., Semi Govt. Organizations
      • Sep 1999 - Oct 2001

      • Providing Software Applications consultancy to Himachal Pradesh, Jammu & Kashmir Government / Semi Government Department and IGNOU BIT/ADIT (Distance Courses) • Trouble shooting the queries regarding Front-end as well as back-end. • Installation of Front-end applications as well as back-end databases. • Providing consultancy / training in software applications to the client. • Implementation and Maintenance. • Providing the consultancy to IGNOU students for BIT/ADIT courses. • Providing Software Applications consultancy to Himachal Pradesh, Jammu & Kashmir Government / Semi Government Department and IGNOU BIT/ADIT (Distance Courses) • Trouble shooting the queries regarding Front-end as well as back-end. • Installation of Front-end applications as well as back-end databases. • Providing consultancy / training in software applications to the client. • Implementation and Maintenance. • Providing the consultancy to IGNOU students for BIT/ADIT courses.

Education

  • DOACC
    A-Level, Computer Science
  • Himachal Pradesh School Education Board
    Matriculation
  • Himachal Pradesh School Education Board.
    10+2, Physics, Maths, Chemistry and English
  • Himachal Pradesh University
    Graduation - (B.A), English, History, Hindi, Philosophy
  • IGNOU
    Certificate in Computer Science, Computer Fundaments

Community

You need to have a working account to view this content. Click here to join now