Not Available
User

AWS

BMT Score
78
78%
  • Remote

Available for

About Sharan P

Having 5+ years of experience on various tools and technologies i.e. MicroStrategy, AWS Redshift, SQL, CSS, Google Charts. On different domains like Pharma and Insurance
Working on MicroStrategy desktop, Dossiers & Web as a Developer
Holds MicroStrategy Certified Specialist Analyst (MCSA) Certification

Tech Stack Expertise

  • Tech Stack Expertise

    Microsoft SQL Server

    SQL,Microsoft SQL Server 2014

    7 Years
  • Tech Stack Expertise

    AWS

    AWS Redshift

    6 Years

Work Experience

Images

Software Developer

  • January 2018 - November 2022 - 4 Year
  • India

Projects

Images

ERP - Merck And Co.

  • April 2018 - April 2020 - 25 Months
  • United States
Technologies
Role & Responsibility

    Merck & Co., Inc., Merck Sharp & Dohme (MSD) outside the United States and Canada, is an American multinational pharmaceutical company and one of the largest pharmaceutical companies in the world. Merck is incorporated in New Jersey. Merck & Co. is the world's seventh largest pharmaceutical company by market capitalization and revenue. Merck & Co. publishes The Merck Manuals, a series of medical reference books for physicians, nurses, technicians, and veterinarians. These include the Merck Manual of Diagnosis and Therapy, the world's best-selling medical reference. The Merck Index, a compendium of chemical compounds, was formerly published by Merck & Co. before being acquired by the Royal Society of Chemistry in 2012.
    Responsibilities:

    • Creating Dossiers and its Chapters, Pages and Standard Dashboards
    • Creating MD Security Filters
    • Implementing the Transaction services
    • Creating MTDI cubes
    • Creating users, User Groups and assigning Security roles for the project
    • Monitoring user connections, Caches and Jobs
    • Migrating object from one environment to other using Object Manager
    • Providing the access using MicroStrategy Workstation
    • Implemented Row-level security and the same Dossier is used for different roles
    • Developed basic and user-specified Metrics (level and conditional)
    • Responsible for designing and executing Application objects and Schema objects using MicroStrategy Desktop
    • Created and defined attributes from fact tables in the appropriate fields under the Attribute Definition section for each dimension
    • Maintaining Data Warehouse reports providing recommendations in increased data access and inventory data
    • Perform analysis, design, development, testing, and debugging of complex reports, ETL scripts and dashboards
    • Create, maintain and modify Attributes, Metrics, Filters, Facts, and Hierarchies
    • Use the Warehouse Catalog to move and update tables in MicroStrategy
    • Created schema, metrics, reports, and documents supporting client business goals
    • Improved performance with Intelligence Cubes
    • Provide production support for MicroStrategy report users
...see less
Images

Merck Sharp And Dohme

  • April 2018 - April 2022 - 49 Months
  • United States
Technologies
Role & Responsibility

    Merck Sharp & Dohme (MSD) outside the United States and Canada, is an American multinational pharmaceutical company and one of the largest pharmaceutical companies in the world. Merck is incorporated in New Jersey. Merck & Co. is the world's seventh largest pharmaceutical company by market capitalization and revenue. Merck & Co. publishes The Merck Manuals, a series of medical reference books for physicians, nurses, technicians, and veterinarians. These include the Merck Manual of Diagnosis and Therapy, the world's best-selling medical reference. The Merck Index, a compendium of chemical compounds, was formerly published by Merck & Co. before being acquired by the Royal Society of Chemistry in 2012.
    Responsibilities:

    • Creating users, user Groups and assigning security roles for the project
    • Monitoring user connections, caches and jobs
    • Migrating object from one environment to other using Object manager
    • Developed basic and user-specified Metrics (level and conditional)
    • Responsible for designing and executing Application objects and Schema objects using MicroStrategy Desktop
    • Created and defined attributes from fact tables in the appropriate fields under the Attribute Definition section for each dimension
    • Maintaining Data Warehouse reports providing recommendations in increased data access and inventory data
    • Perform analysis, design, development, testing, and debugging of complex reports, ETL scripts and dashboards
    • Create, maintain and modify Attributes, Metrics, Filters, Facts, and Hierarchies
    • Use the Warehouse Catalog to move and update tables in MicroStrategy
    • Created schema, metrics, reports, and documents supporting client business goals
    • Improved performance with Intelligence Cubes
    • Provide production support for MicroStrategy report users
...see less
Images

USAA

  • January 2017 - March 2018 - 15 Months
Technologies
Role & Responsibility

    Our Client is a leading Insurance firm across the globe; USAA offers a range of personal property and casualty(P&C) insurance, including automobile insurance, homeowner insurance, renters' insurance, as well as umbrella and personal property insurance. In addition to P&C insurance, USAA provides whole life insurance, term life insurance, and annuities. USAA's life insurance policies, while not completely unique in the industry, are different from most offerings since they do not include a war-exclusion clause.
    Responsibilities:

    • Creating users, user Groups and assigning security roles for the project
    • Monitoring user connections, caches and jobs
    • Migrating object from one environment to other using Object manager
    • Developed basic and user-specified Metrics (level and conditional) 

    KEY ACHIEVEMENTS

    • Secured AIR 40 in Unified Cyber Olympiad.
    • Held the position of an organizer in DST funded Technical workshop “Recent Advancement in Renewable Energy and Smart grid”.
    • Held the position of an organizer in Technical workshop “EMBEDDED SYSTEMS ARCHITECTURE AND ARM PROCESSORS”.
    • Held the position of an organizer in SET Conference.
    • Student Chair for IEEE International Conference i-PACT 2017.
    • Handled the position of the Vice-President of the “Instrument Society of India VIT Student Chapter” for the year 2015-16.
    • Currently working as, the Vice-Chair for IEEE-NPSS-VIT student chapter. 
    • Participated in National & International level KARATE BUDOKAN and secured gold, silver medals
    • Participation in Social services like Medical camps, Tree plantation etc.
...see less

Industry Expertise

Our Suggestions