Badges
Certifications
Work Experience
Software Engineer
conduent business services India LLP•  April 2018 - Present
Handling health data of clients and providing the best solutions/methods. Before migration of an application I had to ensure that the data in new database is exactly same as in the existing reporting database. The data mismatch for each campaign (if any) with date for which data mismatch had occurred and the reason for test failures were mentioned.  Worked on applications and automating team's major tasks.  Co-ordinate with client tech team for on-boarding, technical implementation and troubleshooting.  Implementing the data feeds of various clients including their API's to be used.  To optimize/maintain the application to interact with databases along with proper validation.  Created the user interface to fetch top 100 employees who have excelled in the past 10 years for the annual day event and implemented web scraping with the help of python’s BeautifulSoup and Urllib3 libraries
Software Engineer
Optum Global Solutions•  June 2016 - April 2018
Numerous amount of claims get processed every day and filing of claims are done through Web application which are validated with any front end language(Python) and then with the help of SQL complex queries and with the help of SSIS data is converted to different destinations and business team accesses, assess, reviews and then process the claims.......  Worked with Python to validate the claims and the database information  A web interface to get information from diff databases and servers for non tech team, and provide an interface to edit the database information with validation using python  Proficient in designing complex tables, queries, writing Stored Procedures, Functions, views and Triggers.  Created SSIS packages and implemented transformations such as Sorting, Aggregate, Row Sampling, Percentage Sampling, combining data using UNION ALL transformations.  Worked with application developers to create optimized queries to minimize execution time of application.  Worked with different sources and destinations (Excel Files, Flat Files, SQL SERVER, oracle Db) to import and export data.
Education
Kulachi Hansraj Model School , Delhi
Links
Skills
bharat_khanna has not updated skills details yet.