Oct 2019 – Sep 2023 · 3 yrs 11 mos · On-site

• Responsibilities:
• Used Sqoop to efficiently transfer data between databases and HDFS.
• Involved in creating Hive tables, loading and analysing data using hive queries.
• Created partitions, buckets in Hive to handle structured data.
• Involved in importing and exporting data(Oracle, XML, text file) from external file system and RDBMS to HDFS using sqoop
• Implemented spark using Scala and Spark SQL for faster testing and processing of data.
• Involved in converting Hive/SQL queries into spark transformations using Spark RDD’s.
• Used Spark to load data and create schema RDD and loaded data into hive tables
• Worked with various file formats like Parquet and ORC etc.
• Worked on Optimization of Spark Jobs.
• Performed data processing such as aggregation, joins, filter as per business rule.
• Monitoring and maintaining scheduled jobs and spark and SQL scripts on daily basis.
• Resolve SNOW tickets raised by the Client.
• Get in touch with relevant developer team to resolve high priority issues which needs to be addressed immediately.
• Analyzing and cleaning log files for fault tolerance.
• Attend daily meetings and calls for requirements.
• Implement Data Validation

Aug 2018 – Sep 2019 · 1 yr 1 mo · On-site

• Responsibilities as a Qlikview/Qliksense developer:
• Built and scheduled different predictive models, developed dashboards by using Qlikview and Qliksense
• Managing server-side data integration and monitoring by using Qlikview for production and quality server.
• Built different Dashboards for by using Qliksense and Qlikview.
• Performed monitoring of a different task which includes module wise applications of plant maintenance, logistics, manufacturing, sales etc.
• Scraping and handling large amount of unstructured and text data
• Creating scheduled jobs for QVD extracts and report reloads using QMC.
• Developed executive dashboards using different Qlik objects or Qlik extension objects
• Built different data models using Star Schema/ Snow Flake Schema.
• Followed best practices to be used in Qlik and worked on Performance tuning and Optimization techniques to improve Qlik application performance.
• Designed and extended an existing QlikView / Qlik Sense dashboard to include Analysis of Reports and Engagement Summary module.
• Prepared documentation, KEDBs for future development references.
• Working with Business SMEs to analyze and document business requirements and functional specification.
• Prepare demo dashboards for clients using QlikView and Qlik Sense
• Advanced scripting involving Set Analysis and integrate data from multiple data sources (CSV files, Excel files, Db2 databases, etc.) into a QlikView Data Model
• Develop a solution/framework for provisioning data for consumption by business users who create ad hoc QlikView applications.
• Task set up are done using QMC and created architecture for the interdependent applications and execute in proper order.
• Gathering data sources like QVD files, Excel, ERP, and Oracle in developing the QlikView Data Models
• Created QlikView files updated on timely basis as database updates
• Developing Scripts while loading the data, resolving issues in scripts
• Developed QlikView Functions and Reports as business needs

Nov 2015 – Jul 2018 · 2 yrs 8 mos · On-site

• Responsibilities as a Customer Quality specialist II:
• Receive Medical device complaints and related Information via Incoming Calls, Emails, Faxes.
• Individual follow up with affiliate for missing information within required timeline.
• Identify complaints record with missing data, cause code, reportability, reparability.
• Independently complete complaint entry within specified timeline
• Evaluates and creates MDR DT based on number of parts and the failures provided by service center
• Perform Device history activities.
• Use SAP-MM ERP for extracting the Device data history and check for the Non-conformances.
• Proceed the Non-conformance and CAPA with diligence to the JnJ medical Authority.
• Develops, Coordinates and ensure Appropriate training for the new associates to perform device history, evaluation and Investigation.
• Use Tableau tool to analyze the data from service center and customer.
• Building, publishing customized interactive reports and dashboards
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Designing data model from scratch to aid team in data collection to be used for Tableau visuals.