PRIYANK SINGH

CLIENT : NOVARTIS

PROJECT : ATLAS ENHANCEMENT

RESPONSIBILITIES :

Understand new enhancement\requirement requested by the client and create Spark/Scala-based code with Hive as data storage on the HDFS platform.Atlas4A program is set to interface via evico platform to provide the enriched HCP and HCO information to different consumers of Novartis. Utilize the BRR framework(Metadata Driven Tool) for the implementation of different inbound and outbound interfaces.
· Key Role in Analyzing requirements of the alignment data interface.
· Understanding the overall functionality of the project and interaction with different downstream.
· Implementing the incremental logic in the ODS layer.
· Scheduling jobs in Control M.
· Actively involved in code deployment in a higher environment.
· Providing hyper care support post-production.
· Imported the data in CSV file format into hive table and data validation
· Created multiple tables and views in the hive, updated parquet files, DDL files, and Scala code, and pushed it into Git.
· Implementation of Adhoc new requirements following SDLC.

CLIENT : NOVARTIS

PROJECT : VDW REBUILD

RESPONSIBILITIES :

The objective was to migrate the existing VDW (Vantage Data Warehouse) system to a new big data platform EVICO. ODS will house data captured in the Customer Relationship Management application (CRM) namely ‘Vantage’. End users/Sales Representatives log their call/sampling and all other activities in ‘Vantage’ and ODS (though DICE) Extract that data and store it in a Database (EVICO Platform) in Novartis Network. This data is then provisioned to various other systems within Novartis for easy access.

• Develop and implement code that loads data into an information product that helps to inform the organization in reaching strategic goals.
• Involved in creating Hive tables, and then applied HiveQL on those tables for data validation.
• Processing the data by applying the business rules using SparkSQL.
• Work on ingesting, storing, processing, and analyzing large data sets.
• Translate complex technical and functional requirements into simple optimized code.
• Investigate and analyze alternative solutions to data storing, processing, etc. to ensure the most streamlined approaches are implemented if any Data Quality issues occur.
• Running the spark jobs to load the data automatically using wrapper scripts.
• Running the jobs in Control-M for loading the data to different business layers.
• Analyzing and fixing the failure scripts.
• Used Git for version control.
• Helped the QA team in testing a few code changes in the QA environment.

CLIENT : NOVARTIS

PROJECT : COGNOS MIGRATION

RESPONSIBILITIES :

The objective was to compare 150+ tables containing various drugs information in MYSQL. Data were loaded in HDFS system from RDBMS, which were pushed from DEV to QA and finally to Production. We had to validate Structure,Delimiter,Data of every file.

· Prepared test cases by understanding the business requirements, Data Mapping documents

· Tested Sqoop scripts used to transfer data between RDBMS and HDFS.

· Tested Hive QL queries with Partitioning, Dynamic Partitions and Buckets.

· Compared metadata,data,structure of each file in each environment.

· Raised Bugs in JIRA\Proton as per Defect Lifecycle Concept

· Executed various Test Cases in HP Proton and captured necessary test evidences.

CLIENT : Union Bank of Switzerland

PROJECT : UBS DataLake

RESPONSIBILITIES :

The objective was to validate data and functional logic in tables containing customer related data.

· Go through the report requirements and make sure that all clarifications are done with the respective BAs.

· Complete Test Scenario/Case writing activities during Development stage within the assigned timeline.

· Actively follow up with Leads/BAs/Developers with respect to test case review and sign off, defect closure, etc.

· Ensure complete coverage of functional and non-function requirements of reports in test cases and they are mapped to the requirements through RTM for the assigned modules

· Provide regular status updates to the Test Lead in the agreed format.

· Reporting issues in JIRA, tracking of issues and interacting with the Developers for bug fixes.

· Re-test resolved defects and bring the defects to a logical closure within the agreed timelines.

· Report work progress and any problems faced to the Test Lead.

· Provide KT to the new joiners in the testing team as well as guide them technically.

· Execute the Test Cases in HP proton and capture test evidences.