Talent's Information
-
Location
Pune, India
-
Rate
$12.0 per Hour
-
Experience
5 Year
-
Languages Known
English,Hindi
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
-
Microsoft SQL Server
SQL,Microsoft SQL Server 2014
7 Years -
AWS
AWS Redshift
6 Years
Work Experience
![Full Time Contract Images](/images/EmployementType/WE1.png)
Software Developer
- January 2018 - November 2022 - 4 Year
- India
Projects
![Images](/images/Industries/IndustryNA1.png)
ERP - Merck And Co.
- April 2018 - April 2020 - 25 Months
- United States
- 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
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:
![Images](/images/Industries/IndustryNA2.png)
Merck Sharp And Dohme
- April 2018 - April 2022 - 49 Months
- United States
- 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
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:
![Images](/images/Industries/IndustryNA3.png)
USAA
- January 2017 - March 2018 - 15 Months
- 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)
- 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.
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:
KEY ACHIEVEMENTS