Nitin Sharma

• Automated ETL processes, making it easier to wrangle data and reducing time by as much as 40%.
• Strong experience on developing SQL,PL/SQL ,Hive, Big Data ,Spark ,Scripts
• Implemented Hive Generic UDF to incorporate business logic into Hive Queries
• Developed multiple jobs in python for data cleaning , preprocessing and automation.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using MULTI LOAD, Informatica
• Experience in developing applications using Data Bricks, Hive for data extraction, transformation and load
• Setting up AWS and Azure Databricks Account
• Evaluated employee skills and knowledge regularly, training, and mentoring individuals with lagging skills.
• Managed schedules, accepted time off requests and found coverage for short shifts.
• Trained new team members by relaying information on company procedures and safety requirements.
• Coached team members in techniques necessary to complete job tasks.

• 
  
• Working on Regulatory project using OFSAA
• Expertise in BASEL Regulatory Reporting using OFSAA and its components
• Used various Automation tools like Atomic, Shell Scripting for Automation
• Strong knowledge in OFSAA Data model and Data Modeling using Erwin data Modeler, compatible tools in OFSAAI
• Strong knowledge of OFSAAI Infrastructure OFSAAI solutions installation and troubleshooting
• Extensive experience in OFSAA Batch Execution Engine (Run/Rule Framework)
• Expertise database performance Tuning and Capacity Planning
• Good expertise in configuring DQ rules, building T2T (Table to Table) transformations in OFSAA

• Analyzing the requirements of the COLT and writing the Functional Design (FD) and Technical Design (TD) Documents with the help of BRDs
• Developing the Modules using Struts1.2 framework and writing PL/SQL procedures and functions
• Reviewing of forms framework & PL/SQL codes and testing of the developed system during development, SIT and UAT
• Presenting the System to Users through Demos and adding few enhancements based on the feedback
• Creating and execution of batches and improving the performance of the system through tuning of PL/SQL codes

Analyzing the requirements of the SCL Indonesia and writing the Functional Design (FD) and Technical Design (TD) Documents
Developing the Modules using Struts1.2 framework and writing PL/SQL procedures and functions
Reviewing of forms framework & PL/SQL codes and testing of the developed system during development, SIT and UAT
Detail MIS including XML based graphs

• Coordinated with other engineers to evaluate and improve software and hardware interfaces.
• Developed robust, scalable, modular and API-centric infrastructures.
• Delivered unit-tested systems within customer-prescribed timeframes.
• Collaborated with fellow engineers to evaluate software and hardware interfaces.