San Francisco Bay Area
Oracle Certified Associate and Data Engineer with 5+ years of experience. Passionate about Cloud, DevOps, and leveraging cloud technology design. Expertise in AI, Data Analytics, and Data Engineering. Specialize in process development for healthcare, insurance, and product development. Delivering technology-enabled business solutions, including curation, data extraction, cleansing, governance, and management for downstream use in Enterprise Data. Thorough understanding of the Software Development Life Cycle and consistently meeting deadlines.
Worked for the client : VDSS(Virginia Department of Social Services) and SANDAG(San Diego Associates of Government ) ● Designed, developed, and implemented multiple data migration solutions by using AWS Glue, Python, and PySpark. ● Developed ETL scripts from scratch through Pyspark and SQL. ● Created multiple work orchestration workflows. ● Collaborated on AWS Glue ETL (Extract Transform and Load) tasks, ensuring data integrity and verifying pipeline stability leveraging AWS services such as Amazon S3, Amazon Cloud Watch, etc. ● Worked extensively on writing complex SQL queries to perform data analysis. ● Collaborated with the Infrastructure team to troubleshoot the DB environment issues. ● Developed and maintained ETL (Extract, Transform, Load) processes to migrate data between systems. ● Performed data mapping and transformation activities to ensure accurate and efficient data migration. ● Implemented data validation and quality assurance processes to maintain data integrity and accuracy throughout the migration process. ● Create a source to target data mapping as per business needs using the source is MS SQL, and the target is a Postgres database on AWS. ● Performed database tuning, indexing, and normalization to improve query performance and maintain data integrity. ● Managing the schedule and monitoring of batches in TEST and PROD Environments using BMC Control M Scheduler. ● Worked extensively on full builds, selective builds (Jenkins), hotfix deployment (Putty, WinSCP, and Linux command lines). ● Scheduled and managed jobs using CONTROL-M.
Worked for the client: Conduent ● Collaborated on various micro-services implementations using Spring Boot framework, which involves database insertion and fetching the details. ● Enhanced workflow with continuous code quality with the help of SonarQube. ● Leveraged Oracle databases to extract and manipulate large datasets, optimizing report generation, and data visualization. ● Employed Java, Spring, Spring Boot, Spring Data, and Hibernate to develop the backend. ● Worked extensively on writing complex SQL queries to analyze data and develop database objects like tables, stored procedures, and views. ● Worked on the Swagger for the spring boot documentation and for testing the service ● Implemented REST web Services by using Spring MVC and annotations. ● Developed Git repositories to manage my code with my team. ● Maintenance and development of web-based applications. ● Performed Junit testing with mockito. ● Actively gathered information about the requirements, analyzed, and prepared the document of understanding.
Worked for Internal Project ● Used React and Redux to develop the frontend and track the information across several states. ● Employed Java, Spring, Spring Boot, Spring Data and Hibernate to develop the backend. ● Utilized Material UI for implementing the design of the web page. ● Adopted H2 Engine to host my database, and it is written in SQL. ● Enhanced our workflow with continuous code quality with the help of SonarCloud. ● Handled all aspects of the web applications, including maintaining and deploying them using Jenkins and AWS. ● Made several design patterns such as Singleton, Factory, Front Controller, DAO, and MVC. ● Included Asana in assigning tasks and viewing completed tasks.