Ankit Bhardwaj Email and Phone Number

Filing insurance claims and registering patient data.Handling claim corrections.Data Analysis using Tableau and Excel.

Leading a team of 5 as Project Manager to provide consultancy to MXOtech for new product.Spearheaded research for a healthcare claim correction software; identified similar products and vendors to define strategy.Analyzed demand by interviewing providers and payers; presented market insights by analyzing industry data using Tableau to present detailed graphs and trend curves to assist in insightful decision making.

Designed the business process flows for the e-commerce transaction.Developed the database design and implemented on MySQL.Designed the site map for the e-commerce websiteIdentified different modules for the application development.Developed web application using Java based on JSP, JSF and HTML hosted on Tomcat.Delivered the future strategy and steps to complete and scale the application.

Worked as Software Engineering Analyst in the Business Intelligence and Data Warehousing domain and worked on visualizations tools like OBIEE 11g, Tableau, SSRS and ETL tools like Informatica, SSIS. Also worked Oracle R, R and SAS to develop predictive models and integrate R visualizations with OBIEE 11g dashboards. I have worked for leading consumer goods company in the world and for Accenture's internal capability which was a research and development unit within Accenture.My work included:• Developed RPD and BI reports, scorecards and dashboards using OBIEE 11g out of Oracle database and OLAP cube.• Developed Tableau dashboards and story in Tableau desktop connecting to multiple sources like Oracle, Excel, etc.• Created context filter, calculated columns, KPIs, visualizations like mosaic graphs and maps, combined multiple files.• Created complex SQL queries for validating BI reports, data analysis and data cleaning on large data to ensure data integrity.• Designed logical and physical model to identify functional requirements, subject areas, dimensions, facts, and schema design for building data ware house in Oracle using Informatica.• Extracted, loaded and transformed data using Informatica Power Center and SSIS (ETL tool) into data warehouse.• Performed master data management, data quality checks, data profiling and data migration across systems.• Performed unit testing at various levels of the ETL and actively involved in team code reviews.• Worked on database tuning following Oracle performance pyramid for SQL, Object, Workload and Server tuning.• Developed predictive models using algorithms like GLM, logistic regression, and decision trees to predict cases like the likelihood of patient being readmitted in hospital within one month for same symptoms on health data.