Post Job Free

Resume

Sign in

Data Analyst Software Engineer

Location:
Roseville, CA
Posted:
February 02, 2023

Contact this candidate

Resume:

Bhagyashree Rath

Cell: +91-809*******

E-mail: adu3h7@r.postjobfree.com

SUMMARY

A software professional with 4 years of experience in the software industry, I have worked on banking and financial products and have a proven track record of supporting associate applications which deals with finance tools by using technical skills.

PROFESSIONAL COURSES

Big Data Hadoop

JAVA

SAP BI

ACADEMIC QUALIFICATIONS

Master of computer Application (M.C.A) from Utkal University, Bhubaneswar, Odisha (2010).

Bachelor of computer Application (B.C.A) from Utkal University, Bhubaneswar, Odisha (2007).

HSC from Council of Higher Secondary Education, Odisha (2004).

SSLC from Board of Secondary Education, Odisha (2002)

TECHNICAL SKILLS

Knowledge in Map reduce, Pig, Hive, Apache HBase, Apache Sqoop, Hadoop Ecosystem.

Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.

Hands on experience in application development using Java, RDBMS, and Linux shell scripting

Experience in analyzing data using HiveQL, Pig Latin, and custom Map Reduce programs in Java.

Worked on NoSQL databases including HBase.

Experience in designing, developing and implementing connectivity products that allow efficient exchange of data between our core database engine and the Hadoop Ecosystem.

Excellent knowledge of the Quality standards and Technologies such as Oracle, UNIX, Shell programming.

Excellent understanding of oops concept, constructor, exception and collection framework in core java.

Developing and executing SQL statements and Shell Scripts.

Expertise in Insurance and Banking Domains.

Efficient in building hive, pig and map-reduce scripts

Good Knowledge on Java Technologies

Given the task of Analysis, System Monitoring, responding to customer queries as well as criticality/severity of Business Problems.

Ability to work closely with team members and understand client requirements.

Actively involved in project analysis, database and technical documentation also.

Providing support to client on 24/7 basis and weekend support also.

Excellent interpersonal and communication skills, creative, research-minded, technically competent and result-oriented with problem solving and leadership skills

PROFESSIONAL EXPERIENCE

COMPANY: Bank of America Corporation Technologies

Duration: Nov 2014 to till date

Designation: Software Analyst

Project: TMRA (Trade Management & Risk Analysis)

Client: Bank of America Corporation

Domain: BFSI

Technologies: Hive, Pig, Map Reduce, sqoop

Team Size: 8

Duration: Nov 2014 to till date

Project Synopsis:

This project is intended for analyzing customer base and different banking products used by the group of customers hence to analyze the market trend and to analyze the business based on the report generated. The banking introduces different products such as home loan, personal loan, car loan, ready cash fund, equity etc. The entire data is saved in the rdbms oracle, later it is being migrated to the hive and hdfs using sqoop with different set of rules have been framed to segregate data based on the different group category. Based on the analysis the report is generated using pentho.

Key responsibility Areas:

Sqooping data to hdfs and hive

Writing hive queries to create report

Writing map reduce program to filter data based on certain rule.

Create the documentation and generate the report such as incremental, daily etc.

COMPANY: Bank of America Corporation Technologies

Duration: May 2013 to Nov 2014

Designation: Software Engineer

Project: TMRA (Trade Management & Risk Analysis)

Client: Bank of America Corporation

Domain: BFSI

Technologies: Shell Scripting, SQL/PLSQL & Unix

Team Size: 6

Duration: May 2013 to Nov2014

Project Synopsis:

This project basically deals with derivative products for equities and fixed income securities. TMRA has 2 main departments Fixed income and Equities. The products dealt with in fixed income include Forex and Commodities (such as Energy and Precious Metals but not Agricultural Commodities).The Products dealt with in Equities are Stocks. TMRA operates through its own memberships on 53 exchanges as well through other brokers. The product of TMRA are future and options. Totally it has 18 no’s of applications.

Key Responsibility Areas:

Responsible for providing the L2 support depending on the priority of the issues to meet client’s SLA.

Interacting with the customer and get exact specifications for enhancement.

Monitoring jobs and following up with dev team to resolve slow, hanged and failed jobs and following manual completion steps to end a job.

Identifying recurring problems and escalating for permanent fix.

Monitor & resolve all the P1/P2/P3 tickets in our queue.

Sending job status report in every one hour to all the folks including dev, testing and data analyst for specific issues.

Checking health of the server regularly and taking necessary steps in case of slowdown which may restrict the team and the customers to generate reports.

Worked on Netstat to keep a track on the network.

To monitor the network for alarms or certain conditions requiring special attention to avoid impact on the network's performance.

Responsible for the performance parameters that may affect the network's health. (Interference, site uptime/downtime).

Providing workaround in the form of delta fix.

Attending in NET meeting for the purpose of deployment of various modules in the presence of client as well as senior authority.

In case of Code fix, Responsible for Creating the RFC and Working on the Approved RFC on various phases.

COMPANY: IBM Technologies Pvt. Ltd

Duration Mar 2011 to Apr 2013

Designation: Software Engineer

Project: UBS Release V.UM 3.4.12.0.HBB.2.0

Client: Habu Bank

Domain: BFSI

Technologies: Oracle & UNIX

Team Size: 8

Project Synopsis:

The system helps users to open cash account and brokerage account. It would also hold the customer fund in cash account for purchase orders, release the fund, pass financial entries for settlements & corporate initiated transactions, hold the transaction and summary details of brokerage account and generate statements for these accounts. The back-end system in India had the capability to handle cash account in multiple currencies. The brokerage front-end system did have the capability to trade in multiple exchanges.

Key responsibilities:

Responsible for providing the L2 support depending on the priority of the issues to meet client’s SLA.

Monitoring jobs and following up with dev team to resolve slow, hanged and failed jobs and following manual completion steps to end a job.

Identifying recurring problems and escalating for permanent fix.

Sending job status report in every one hour to all the folks including dev, testing and data analyst for specific issues.

Checking health of the server regularly and taking necessary steps in case of slowdown which may restrict the team and the customers to generate reports.

Bouncing environment UIs when ever getting request from onsite and if the load average is beyond the limit.

Scheduling jobs through environment GUI and scheduling cron jobs depends upon requirement.

Involved in change management procedures for all changes in jobs.

Refreshing environment UIs as per the request.

Managing known errors/issues consistently in Wiki.

Update run book, Raising CR, follow-up for approvals and perform implementation checks.

Raise GCN (Global Change Notification) to notify different teams for any planned/unplanned outage in Production environment.

Handing over the outstanding issues to the primary of the next shift

PERSONAL DETAILS

Nationality Indian

Marital Status Married

Religion Hindu

Passport Yes



Contact this candidate