Talent's Information
-
Location
Anantapur, India
-
Rate
$14.0 per Hour
-
Experience
7 Year
-
Languages Known
English,Hindi
Available for
About Ujjin
Having 7 years of Total IT experience in designing, customizing, and developing enhanced functionality to Oracle like GCP, BIG QUERY, SQL., Airflow, AXWAY And also, good understanding in salesforce front end like all the objects Contact, Account, opportunities, Quote, Quote line, opportunities.
Experience on Airflow (Python, Dag’s) Big query, Pub sub, Data flow, Data Proc, Cloud storage, Composers, Data fusion, Cloud shell, partitioning, clusters, Python.
Extensive experience in developing Data Fusion Pipelines and writing SQL query’s, Using Views, Joins, Sub Queries and Set Operators, Etc.
Good experience on Workbench and SOQL Query.
Good experience on Cloud Storage, Cloud Data Fusion, Cloud Shell.
Involved in creating data pipelines using source objects like Salesforce to Big query landing tables.
Worked on inbound/outbound process through BIG query.
Good experience on ETL process like Extraction, Transform, Loading.
Generating the Tableau Reports using View’s and Materialized View’s.
Involved Explain plan and investigate the performance issues.
Excellent understanding of SDLC.
Good experience on XML DB and GitHub, Jira.
Good Experience on Oracle Dynamic SQL.
Good Experience on writing Materialized views.
Good Experience on Unix, Shell Scripting, Bash Scripting.
Good Experience on Performance tuning.
Experience on SSIS/SSAS/SSRS
Good experience on OLTP/OLAP applications
Tech Stack Expertise
-
Big Data
Big Query
1 Years -
Oracle
Oracle
1 Years -
Python
Python
1 Years
Work Experience
DBA Developer
- January 2016 - June 2023 - 7 Year
- India
Projects
Smart Home Data
- December 2020 - June 2021 - 7 Months
-
AAA (American Automobile Association) is a federation of motor clubs throughout North America. AAA is a privately held not-for-profit national member association and service organization with over 60 million members in the United States and Canada. AAA provides services to its members, including roadside assistance and others. Its national headquarters are in Heathrow, Florida
RESPONSIBILITIES:
Extensively used GCP, Big Query, Salesforce, data fusion for daily development jobs.
Involved in writing SQL scripts as per the Client requirement.
Managing tables using Views, Sequences, and Indexes.
Involved in importing data from client files to Oracle.
Involved in Unit testing.
Involved in design of the database, which includes, table design and their relations.
Develop SQL Queries for checking data transaction and database integrity.
Involved in coding part of all respective MS SQL Objects.
DINC
- March 2020 - September 2020 - 7 Months
-
Involved in writing SQL scripts as per the Client requirement.
Extensively used GCP, Big Query, Salesforce, data fusion for daily development jobs.
Managing tables using Views, Sequences, and Indexes.
Involved in importing data from client files to Oracle.
Involved in Unit testing.
Involved in design of the database, which includes, table design and their relations.
Develop SQL Queries for checking data transaction and database integrity.
Involved in coding part of all respective MS SQL Objects.
Millennium (Health Care)
- August 2019 - January 2020 - 6 Months
-
Millennium is a manufacturer and marketer of a specialty biologic Product it promotes and sells certain specialty pharmaceutical products, and Specialty Pharmacy dispenses Products through its specialty pharmacy retail operations. In order to support various internal business functions relating to the Products (Merkle, Covance, Takeda), Millennium desires to obtain from Specialty Pharmacy a complete set of data relating to Products. Liquid Hub solution is to deploy a Specialty Data Aggregation solution using Liquid Analytics Platform to support Products and Implementing HIPAA compliant patient de-identification service, Rolling out Liquid Analytics Reporting Platform including user-specific reports and also managing the Commercial data environment to work with Various channel partners.
RESPONSIBILITIES:
Involved in writing SQL scripts as per the Client requirement.
Extensively used GCP, Big Query, Salesforce, data fusion for daily development jobs.
Managing tables using Views, Sequences and Indexes.
Involved in importing data from client files to Oracle.
Involved in Unit testing.
Involved in design of the database, which includes, table design and their relations.
Develop SQL Queries for checking data transaction and database integrity.
Involved in coding part of all respective MS SQL Objects.
Bank Of America(Financial)
- December 2017 - July 2019 - 20 Months
-
The strategic application for Asset Servicing, an operational process and service which includes collecting dividends and interest payments, processing of corporate actions and applying tax relief from foreign government on behalf of customers. Internally developed, initially to consolidate dividend processing into one system, came online in 2003 and was subsequently further developed to include corporate actions and coupons processing.
It’s actually an acronym
A – Asset
S – Services
T – Tax
R – Reclaim
I – Income
D – Dividends
RESPONSIBILITIES:
Involved in writing SQL scripts as per the Client requirement.
Extensively used GCP, Big Query, Salesforce, data fusion for daily development jobs.
Managing tables using Views, Sequences and Indexes.
Involved in importing data from client files to Oracle.
Involved in Unit testing.
Involved in design of the database, which includes, table design and their relations.
Develop SQL Queries for checking data transaction and database integrity.
Involved in coding part of all respective MS SQL Objects.
Soft Skills
Industry Expertise
Education
in Btech
Anantapur University- June 2011 - June 2014
