System Analysts - Team Lead
Cybage Solutions
Total years of experience :13 years, 7 Months
Created end-to-end analytics pipeline from scratch.
Assigned tasks to the team members to work in an Agile environment.
Created CI/CD pipeline for the project.
Mentored the team members to the latest big data technologies.
Designed call center data analytics solution for a global telecom company.
Prepared the data model and used regex to preprocess the data.
Used Spark/Scala to process datasets to create use analytics.
Impala is used to read data through queries.
The reporting was done in Tableau from output after Impala queries are executed.
Responsible for implementing the Basel 3 accord for the Bank to enable them to be compliant with the Regulatory from different countries. Part of the team which was responsible for migrating the existing project from Oracle technologies to Hadoop. Duties: Importing and exporting data in HDFS and Hive using Sqoop. Experience with NoSQL databases. Written Hive UDFS to extract data from staging tables. Involved in creating Hive tables, loading with data and writing hive queries which will run internally in map reduce way. Designed database, tables and views structure for the application. Successfully transferred inbound data from various sources like flat files JSON, PARAQUET, AVRO, CSV. Developed complex SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application. Good Understanding of the Software Development Life Cycle (SDLC). Involved in process improvement in the project with some tangible outcome. Perform analytics using Spark and Scala for developing Credit Card Default Finder application. Uses Spark SQL to generatereports.
1. I have joined the telecom domain project as an Oracle PL/SQL developer in the Oracle team from start. It is service and maintenance based project . We receive service request to match the billing data. The analysis is started from Analysis through Functional requirements to Unit testing, System testing for different releases.
Roles And Responsibilities:
I am involved in user interactions, requirement gathering, analyzing of issues and impact analysis.
I work alone in mitigating the unmatched billing data between the client and the TCL using procedures and packages and find the unmatched billing data.
Involved in monitoring of applications and monitoring of the daily jobs.
Attending calls with the Business on daily basis for Requirement clarifications and delivery Issues.
I work in resolving the user issues.
I am involved in sending Weekly status reports to Onsite and Offshore leads.
I supervise the data extraction and month-end activity.
Handling new resources in team and make them output oriented and productive with assistance.
Involved in creation and updates of several SQL packages and Procedures.
Developed shell scripts to send notifications after data creation process is complete.
I am involved in performing Peer Review of PL/SQL procedures, functions and triggers.
2. I have joined thisbanking domain project in August 2011, with 10 members, every single resource is responsible for their
assigned individual tasks, My role is to develop solutions based on user needs, user may be a bank’s employee
or a direct customer of bank.
Roles and Responsibilities: Direct User Interactions, Requirement understanding, feasibility studies, requirement gathering. Designing a prototype, fixing the user’s expectations, Prepare HLR. I was involved in development of packages to validate client data, triggers and PL/SQL procedures for automation of job scheduling. Developed shell scripts to send notifications after data creation process is complete. Understanding and analysing an existing system, prepare the technical design accordingly.
Handling resources in team and make them output oriented to complete their respective task in time.
Responsible for Analysis Review, Code Review, Test results review in project.
Provide 24/7 support to database applications.
3. I have joined that Oil and energy domain project with 4 members from the start. We were given Knowledge Transition sessions from the client site. Project was started to reduce the defects log and maintain their systems. The defects were worked upon through different phases from Analysis through Functional requirements to Unit testing.
Roles And Responsibilities:
I was Involved in Interaction with client to gather the requirements.
I was Involved in development of packages and procedures for loading of financial data and validation of client data.
I worked on Change Request received from client.
I was involved in support of critical financial applications to keep them running 24/7.
I was involved in post production support of issues with Oracle packages and procedures.
I was Involved in providing permanent solutions to recurring issues.
4.Generic product of the company developed for rural web based shopping. It has many functionalities like user registration, user account, order status, cash on delivery, payment gateway options. It was developed with care of all needs for any online shopping software. It took four and half month to develop and now installed successfully at the customer end with positive feedback .It was developed in VB.Net 3.5 and Oracle 10g.
This was completely dynamic product used 17 Data base tables
Roles And Responsibilities:
I was Involved in Interaction with client to gather the requirements.
I was Involved in development of packages and procedures for loading of financial data and validation of client data.
orking As PL/SQL Developer In The Company. Developed SQL, PL/SQL Stored Procedures, Packages, Views, Cursors, Functions, Triggers following Software Development Life Cycle strictly. Rewritten stored procedures to enhance performance and improving 25% performance by using proper index, index hints to increase performance.Experience in UNIX Shell Scripting. Involved in the support, maintenance and development of critical financial systems. Have Been Appreciated And Awarded by Client (USA) And Team in Oil & Energy Domain as STAR PERFORMER at Delivery Unit Level.
2 years of experience in Oil & Energy Upstream Domain and 6 months of experience in Health & Public Services Domain.
Done B.Tech in Computer Science And Engineering
Done Intermediate in U.P. Board
Done High School in U.P. board