About Me
Over 4+ Years of professional experience working as Data Engineer, Data Analyst and Quality Assurance Engineer. Performed data analysis on healthcare for Medicare, Medicaid, and Commercial lines of business writing compl…
Over 4+ Years of professional experience working as Data Engineer, Data Analyst and Quality Assurance Engineer. Performed data analysis on healthcare for Medicare, Medicaid, and Commercial lines of business writing complex SQL queries. Developed business strategy and data analytics to implement data collection methods to yields highest quality results. Demonstrated ability in using ETL methods, developed stored procedures, functions, packages, database triggers, schema design in Oracle, SQL Server and Google Big Query. Assisted clients from health care industry in data analysis, root cause analysis, resolve any data quality issue and generating reports for HEDIS measures Strong ability to conduct qualitative and quantitative analysis for effective data-driven decision making. Experienced in designing, updating and maintaining Oracle Application Express (APEX) tool for the reporting purposes Good understanding of data warehousing, Google cloud and big query concepts Experienced working in Agile and have strong knowledge of all aspects of SDLC Experienced in creating Test Plan, Test Cases and executing Test Cases Debugging, failure analysis, log analysis for test execution results Experienced in Back-end testing using SQL queries Understanding of basic UNIX commands to perform file manipulation and scripting.
Experience
Data Engineer
Develop a data platform from scratch and took part in requirement gathering and analysis phase of the project in
documenting the business requirements.
Worked with Hadoop architecture and the daemons of Hadoop including Name-Node, Data Node, Job Tracker, Task
Tracker, and Resource Manager.
Used AWS data pipeline for Data Extraction, Transformation and Loading from homogeneous or heterogeneous data
sources and built various graphs for business decision-making using Python matplot library
Developed scripts to load data to hive from HDFS and involved in ingesting data into Data Warehouse using various data
loading techniques.
Build Cassandra queries for performing various CRUD operations like create, update, read and delete, also used
Bootstrap as a mechanism to manage and organize the html page layout
Developed entire frontend and backend modules using Python onDjango Web Framework and created User Interface (UI)
using JavaScript, bootstrap, Cassandra with MySQL and HTML5/CSS
Analyzed SQL scripts and designed the solutions to implement using PySpark.
Used SparkSQL to load JSON data and create Schema RDDand loaded it into Hive Tables and handled structured data
using SparkSQL.
Added supportfor Amazon AWS S3 and RDS to host static/media files and the database into Amazon Cloud.
Worked in development of applications especially in LINUX environment and familiar with all its commands and worked on
Jenkins continuous integration tool for deployment of project and deployed the project into Jenkins using GIT version
control system.
Data Engineer
Developed a data platform from scratch.
Took part in requirement gathering and analysis phase of the project.
Documented the business requirements.
Worked with Hadoop architecture and the daemons of Hadoop including Name-Node, Data Node, Job Tracker, Task Tracker, and Resource Manager.
Used AWS data pipeline for data extraction, transformation and loading from homogeneous or heterogeneous data sources.
Built various graphs for business decision-making using Python matplot library.
Developed scripts to load data to Hive from HDFS.
Involved in ingesting data into Data Warehouse using various data loading techniques.
Built Cassandra queries for performing CRUD operations like create, update, read and delete.
Used Bootstrap as a mechanism to manage and organize the HTML page layout.
Developed entire frontend and backend modules using Python on Django Web Framework.
Created User Interface (UI) using JavaScript, Bootstrap, Cassandra with MySQL and HTML5/CSS.
Analyzed SQL scripts and designed the solutions to implement using PySpark.
Used SparkSQL to load JSON data and create Schema RDD and loaded it into Hive Tables.
Handled structured data using SparkSQL.
Added support for Amazon AWS S3 and RDS to host static/media files and the database into Amazon Cloud.
Worked in development of applications especially in Linux environment.
Familiar with Linux commands.
Worked on Jenkins continuous integration tool for deployment of project.
Deployed the project into Jenkins using GIT version control system.
Data Engineer
Worked directly with research groups to understand their initiatives and programs in healthcare domain.
Helped in providing the data from different sources using ETL tools.
Performed end to end data analysis using SQL queries to provide quality data for research.
Made the data available on BigQuery performing ELT process to move the data from Google Cloud Storage (GCS) bucket to BigQuery tables.
Built designing and architecting solutions in Google Cloud Platform involving huge claims data mart of Medicare and commercial population to effectively execute the queries in BigQuery.
Wrote complex Big Queries on Google Cloud Platform involving joins, user-defined functions (UDF), and jobs to help the reporting team in sending reports to higher management involving bonus, HSA incentive and comparing daily step activities across UHG population.
Extracted data from Salesforce database for research and process improvement on fitness program initiatives.
Developed automation batch framework to execute stored procedure without manual intervention and generate success report after ETL completion.
Performed SQL tuning to retrieve data from large datasets joining multiple tables.
Used query optimization techniques.
Worked closely with clients from gathering requirements and priorities deliverables.
Scheduled s for clients on new software releases and changes on the file layouts.
Coded Oracle PL/SQL stored procedures, packages, and database triggers.