Jayveer Bhadauriya

 Jayveer Singh Bhadauriya Mobile: - Email:- Professional Summary: 5+ years of IT experience in Analysis, Design, Development, Implementation and Support of Data Warehousing and Data Integration Solutions using Informatica, SQL and UNIX and sound knowledge of Hadoop Eco system. Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Experience in database programming in PL/SQL (Stored Procedures, Functions). Well versed in UNIX shell scripting. Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center. Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies. Working in Agile Development and DevOps methodology using Bitbucket, Jenkins and Nexus. Technical Skills: ETL Tools Informatica Power Center(9.x,10.x) Database Oracle 10g/11g, SQL Server Reporting tool Business Objects XIr3/ BI4 Ticketing tool BMC Remedy, HP Service Center, Service Now, Service First Operating System UNIX, Windows Languages PLSQL, Shell scripting, Python Scheduling Tools Autosys, Informatica Scheduler Hadoop Eco System Pig, Hive, Sqoop, Flume, Oozie, Kafka, Spark and Scala Educational Qualification Sl. No Qualification University/Board Percentage 1 M. Tech ABV – IIITM Gwalior(M.P) 7.25 (CGPA) 2 B.Tech Institute of Technology and Management, Gwalior(M.P) 71.75% 3 12th Jawahar Navodaya Vidyalaya, Bhind(M.P) 74.4% 4 10th Jawahar Navodaya Vidyalaya, Bhind(M.P) 84.4% Professional Experience: Project information: Client : Barclays Duration: Feb 2017 – Present Role: ETL Developer/Analyst Technologies: Informatica PowerCenter, Oracle PL/SQL, UNIX, Autosys, DevOps Responsibilities Interact with Client Business Analysts to understand new requirements or issues within the system. Gathering and analysing the requirements and preparing business rules.  Investigate, analyse and deploy fix for defects /bugs/issues in the code. Initiating the process to release changes to Production environment Helping associates in case of any issue and assigning tasks to them. Developing and maintaining ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and load them back into Oracle database.  Developing sessions, workflows to fetch data from source, transform it and load it in database. Creating new tables, modifying existing tables, creating procedures/functions etc. Developing UNIX shell scripts to load and modify data. Creating autosys jils to schedule workflows and shell scripts. Migrating code (SQL, UNIX, Autosys JIL and Informatica workflows) from lower environment to another environment. Project information: Client : Pfizer Duration: July 2016 – Jan 2017 Role: Informatica Admin Technologies: Informatica PowerCenter Responsibilities Migrating code (Workflows/mapping/sessions) from one environment to another. Creating users, assigning them appropriate permissions to respective Folders/repositories/Integration service. Creating Folders in Informatica repository. Taking Repository and Domain Backups on every week. Restarting Repository services/Integration service whenever they are down. Checking Memory on Informatica servers and making space on it when memory is full. Tagging the latest code in Development and then migrating it to production environment. Scheduling Informatica workflows in validation/Production environment. Project information: Client : AstraZeneca Duration: Jan 2015 – Jun 2016 Role: ETL Developer Technologies: Informatica PowerCenter, Oracle PL/SQL, UNIX. Responsibilities Performing Root Cause analysis, making necessary change in system accordingly through ITIL process. Tagging changed code to migrate it from lower environments to higher environments. Interact with Client Business Analysts to understand pain points of users. Developing Informatica mappings, sessions, workflows to fetch data from source, transform it and load it in database. Creating new tables, modifying existing tables, creating procedures/functions etc. Developing UNIX shell scripts to load and modify data. Developing technical specification documents and providing it to Business Analysts/Users. Project information: Client : AstraZeneca Duration: July 2013 – Dec 2014 Role: Application Support Technologies: Informatica PowerCenter 9.1, Oracle PL/SQL, UNIX, SAP BO XI R3/BI4. Responsibilities Perform Daily Data loads in system using Informatica workflows and provide refreshed data in BO reports. Analyse Informatica mappings/PLSQL Procedures/BO reports and Fix any issues observed during data loads. Investigate and Analyse issues related to Application and/or various interfaces. Most of the application analysis is used to done at the database level using SQL Developer and business object reports. Interact with Clients in weekly Service review meeting. Interact with multiple teams to analyse and fix platform issues. Creating events for event based scheduling in Business Object reports. Instructor led trainings: Technology: SQL-PLSQL / Informatica PowerCenter development / UNIX Duration: Feb 2013 – June 2013 Technology: Hadoop Eco System (Pig, Hive, Sqoop, Flume, Hbase, Kafka, Spark, Scala) Duration: Dec 2017 – March 2018 Personal Details Name Jayveer Singh Bhadauriya Date of Birth 30th July Gender Male Address F-601, 64 Green Meadows, Village – Marunji, Pune - 411057 Marital Status Married Languages Known English and Hindi