Pranay Kumar Raini
Data Engineer
Summary
Over 4.5 years of professional IT experience which includes Application support for trading desks (Prime, Equity Derivatives and Futures & Options) in the EMEA/AMER locations and experience in accessing data using Hadoop components such as HDFS, HIVE and Impala. Ability to adapt to evolving technology, strong sense of responsibility and accomplishment
Overview
5
5
years of professional experience
3
3
Certificates
Work History
Application Support Analyst
HSBC
04.2021 - Current
- Business Engagement and Incident Management
- Engage actively with traders and support trading floor activities by promptly resolving production queries, requests, issues under a highly pressured environment
- Identify, communicate, diagnose, and resolve functional and technical incidents for business users
- Proactively record and track actions from system incidents to ensure root cause remediation and recurrence prevention
- Change Management and Subject Matter Expert around impact assessment(F2B flows)
- Plan, review and execute regular application change releases into production environment and work closely with business stake holders, application developers and QA teams to minimize change related incident
- Conduct regular stability review with application owners and act as regional subject matter expert for assigned products and applications in cash equities trading
- Regularly working with ServiceNow and JIRA to keep track of tickets.
Data Analyst
BNY Mellon
08.2019 - 04.2021
- Experienced in Hadoop architecture and various components such as HDFS Job Tracker Task Tracker NameNode Data Node and MapReduce programming paradigm
- Resource management of HADOOP Cluster including adding/removing cluster nodes for maintenance and capacity needs
- Managing, defining and scheduling Jobs on a Hadoop cluster
- Imported/exported data into Hadoop from RDBMS/DWH (Teradata, Oracle) using Sqoop / HIVE and vice versa
- Wrote Hive queries for ad-hoc reporting and ETL
- Worked with different file formats such as Text, Sequence files, ORC and Parquette
- Implemented test scripts to support test driven development and continuous integration
- Responsible to manage data coming from different sources
- Implemented in setting up standards and processes for Hadoop based application design and implementation
- Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa
- Constructed product-usage SDK data and Siebel data aggregations by using PYSPARK, Spark SQL and Hive context in partitioned Hive external tables maintained in AWS S3 location for reporting, Data Ingestion for Adhoc queries.
Transaction Risk Investigator, Amazon Contractor
12.2018 - 06.2019
- Responding to queries via chat, email, or phone
- Provided technical assistance on various questions and issues
- Used SQL queries, PL/SQL stored procedures & triggers in data retrieval and updating of information in the Oracle database using JDBC
- Trained NEW joiners on troubleshooting, diagnosing problems, and system known issues
- Aligned individual decision making and established procedures within team goals to function independently within the organizational mission.
Associate
Wipro
08.2017 - 12.2018
- Monitoring, troubleshooting & reporting daily backup status for all critical production UNIX server’s enterprise wide
- Document all new resolution steps from L2 within UKS(Universal Knowledge System)
- Incident management & Change Management resolving recurring issues on Smart Stream
- Experience in resolving the issues within the SLA’s and Logical volume management
- Process administration and management like monitoring, start/stop/kill various processes.
Education
Certified Investment Banking Operations Professional (Completed) Securities and Derivatives End to end Trade life cycle - undefined
Imarticus Learning
Bachelors of Technology - undefined
Keshav Memorial Institute of Technology
M.P.C - undefined
Board of Intermediate Education
S.S.C - undefined
Board of secondary Education
Skills
Technical Skillsundefined
Certification
Completed Course on Big Data, Linux, Oracle SQL.
Additional Information
- ACHIEVEMENTS , Client driven award for peak month at BNY Mellon. 2 SPOT Achievement awards at Wipro for detecting Bugs on migrated systems and efficient processing.
Timeline
Application Support Analyst
HSBC
04.2021 - Current
Data Analyst
BNY Mellon
08.2019 - 04.2021
Transaction Risk Investigator, Amazon Contractor
12.2018 - 06.2019
Associate
Wipro
08.2017 - 12.2018
Certified Investment Banking Operations Professional (Completed) Securities and Derivatives End to end Trade life cycle - undefined
Imarticus Learning
Bachelors of Technology - undefined
Keshav Memorial Institute of Technology
M.P.C - undefined
Board of Intermediate Education
S.S.C - undefined
Board of secondary Education
Similar Profiles
Navmita Das NandiNavmita Das Nandi
AVP Employee Engagement - Reward and Recognition at HSBCAVP Employee Engagement - Reward and Recognition at HSBC
Mohammed ShadabMohammed Shadab
Business Test Manager at HSBCBusiness Test Manager at HSBC
Tess FungTess Fung
Vice President at HSBCVice President at HSBC
Marisha PereraMarisha Perera
Senior Application Developer / Business Analyst at HSBCSenior Application Developer / Business Analyst at HSBC
Bhushan Umesh SalviBhushan Umesh Salvi
Technical Support Specialist/Application Support Analyst at IBKR (Interactive Brokers)Technical Support Specialist/Application Support Analyst at IBKR (Interactive Brokers)