Ambuj Srivastava Email & Phone Number

Remote

As a Solution Architect, engaging with clients globally to reduce the challenges during product implementation. Creating POCs for pre-sales teams basis of Business perspectives. Onboarding clients with the product by addressing the challenges during development phase.

Gurugram, Haryana, India

Created automated migration framework to unload OMOP data from SQL Server to Amazon S3 bucket in CSV format Engaged with internal stakeholders to understand source data to perform OMOP conversion leveraging business rules and OMOP CDM conversion standards for various healthcare external stakeholdersWorked with Data Science Engineering team to migrate legacy ecosystem (SQL) to Snowflake environmentCreated stored procedures/UDF in Snowflake using Javascript language to capture data… Show more Created automated migration framework to unload OMOP data from SQL Server to Amazon S3 bucket in CSV format Engaged with internal stakeholders to understand source data to perform OMOP conversion leveraging business rules and OMOP CDM conversion standards for various healthcare external stakeholdersWorked with Data Science Engineering team to migrate legacy ecosystem (SQL) to Snowflake environmentCreated stored procedures/UDF in Snowflake using Javascript language to capture data from Insights data warehouse for underlying metrics and DQ tables for data validation and accuracy Show less

Mumbai, Maharashtra, India

Developed and maintained account plan for existing clients.Managed client engagement and relationshipAligned with delivery teams to find early dissatisfaction indicators and track client satisfactionCoordinated between business and delivery teams for project kick-offs and reviews

Mumbai, Maharashtra, India

- Worked upon OHDSI tools (open source) deployment for US HealthCare. - OHDSI tools (Atlas/Achilles) are analytical web based tools which consumes OMOP CDM data as input and produce analytical dashboards as output- OMOP CDM includes data analysis, data mapping with standard SNOMED/CPT/ICD-9/10 codes.- Preparation of OMOP CDM (Observational Medical Outcome Practices Common Data Model) using PostgreSQL which ingest the clients data in standard format defined by OHDSI community-… Show more - Worked upon OHDSI tools (open source) deployment for US HealthCare. - OHDSI tools (Atlas/Achilles) are analytical web based tools which consumes OMOP CDM data as input and produce analytical dashboards as output- OMOP CDM includes data analysis, data mapping with standard SNOMED/CPT/ICD-9/10 codes.- Preparation of OMOP CDM (Observational Medical Outcome Practices Common Data Model) using PostgreSQL which ingest the clients data in standard format defined by OHDSI community- Learned and Understood end to end functionality of the tools and analyses used within- Leveraged R to perform analyses on OMOP CDM using predefined libraries provided- Collaborate with Client's IT for deployment issuesTools: R, Excel, PostgreSQL, Oracle 11g, Apace Tomcat, SSISOS : Red Hat Enterprise Linux 7 Show less

Kanpur Area, India

Worked offsite on the analytics projects in hand.  Prepared documentation on the analysis done during the tenure.  Trained junior analyst on analysis tools and methods required to perform analysis and prepared KPI dashboards over the phone and GoToMeeting.  Mentored the analysis tasks done by other team members.  Documented the process for data conversion for new systems.

Pune

• Analyzed business issues by providing strategic recommendations and providing solutions as an analyst stating development opportunities.• Applied data mining techniques to compare and highlight top customer opinions of a product as a means to provide feedback to enhance future products.• Developed visually impactful presentations using Excel dashboards.• Extracted, interpreted and analyzed data to identify key metrics and transformed raw data into meaningful actionable… Show more • Analyzed business issues by providing strategic recommendations and providing solutions as an analyst stating development opportunities.• Applied data mining techniques to compare and highlight top customer opinions of a product as a means to provide feedback to enhance future products.• Developed visually impactful presentations using Excel dashboards.• Extracted, interpreted and analyzed data to identify key metrics and transformed raw data into meaningful actionable information.• Optimized the customer support operations by analyzing the recurring issues recorded in CRM which results in reduced incoming calls by 40%.• International Work Experience: Went on a 4 months business trip to Oregon, USA to directly work with the Marketing, Sales and Senior Management for customer retention analysis.• Generated daily, weekly, and monthly reports using Excel and Powerpoint to send out to the internal teams, which highlight sales, profit, monthly targets, and related data.• Conducted Data Mining, Data Modeling and Statistical Analysis that helped in increase of Product sales and Cloud service by 3% in 6 months.• Generated business intelligence reports using pivot tables and pivot charts from cleaned data.• Used SQL for organizing and abstracting data from MS access databases and created reports.Used techniques like Linear Regression, Logistic Regression and general analysis for couple of projects using Advanced Excel/SQL/MS ACCESS. Show less

Pune

• Lead the Data Conversion, Data Migration, Escalation and Customization teams.• Worked on multiple projects for Data Migration/Conversion from one platform to another.• Implemented data cleanup procedures, transformations via SQL scripts, stored procedures, and perform the test phase before uploading the data to Target DB,• Assisted team members on ETL process to achieve the desired result with minimum data loss.• Reviewed the tasks on daily basis assigned to each team member… Show more • Lead the Data Conversion, Data Migration, Escalation and Customization teams.• Worked on multiple projects for Data Migration/Conversion from one platform to another.• Implemented data cleanup procedures, transformations via SQL scripts, stored procedures, and perform the test phase before uploading the data to Target DB,• Assisted team members on ETL process to achieve the desired result with minimum data loss.• Reviewed the tasks on daily basis assigned to each team member and taking daily notes on what is the status and progress on it.• Assisted in the creation and development of various projects, by planning with Management the resources needed to meet the timelines set for the finalization of the project Show less

Pune Area, India

• Troubleshoot Cisco home devices such as routers, range expanders, wireless access points and wireless network adapter.• Assisted US clients over the phone and accessing their computers remotely to configure the devices.• Maintained CSAT overall.• Assisted clients in setting up wireless gaming consoles like XBOX, PS, Wii etc.