$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
data analyst
Vijaya Bandi
,
london, United Kingdom
Experience
Other titles
Skills
I'm offering
Having 14+ years of experience in the Information Technology (IT) industry. Experience in full life cycle of Software Engineering including design, implementation, testing, and maintenance and production support of Data Mart, Data Warehouse systems. Strong technical and development expertise in Informatica MDM, Informatica Power Center, SQL, Oracle, SSIS, FME Desktop/Server, UNIX Shell Scripting and applied in Manufacturing, Finance and telecom domain projects. Thrives in challenging environments with an aptitude for learning and applying new technologies. Key strengths are hard work, dedication and strong belief in teamwork.
Currently working on Informatica MDM implementation which includes designing, developing and delivering large volume and complex MDM solution for enhancement and customization of existing MDM solution for FORD Credit, UK.
Currently working on Informatica MDM implementation which includes designing, developing and delivering large volume and complex MDM solution for enhancement and customization of existing MDM solution for FORD Credit, UK.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2017 - 2018
unknown
Lead the RefDB
Platform & Skills.
Scala, SPARK core, Spark SQL, Streaming,KAFKA, MSBI(SSIS), FME Desktop/Server, SQL Server, MongoDB, Pig, Hive, Linux, Horton Works, Azure (ADF V2, Blob storage, data lake analytics, VM, Active Directory), shell scripting and GOOGLE Maps.
Description The Tour de France is an annual multiple stage bicycle race primarily held in France, while also occasionally making passes through nearby countries.
• Gathered the requirements, designing, and development and testing.
• Apply business knowledge to analyze and interpret data sets and identify root causes of problems and performance exposures.
• Prepare summaries, presentations, and graphic representations of projects.
• Using FME Desktop, created Jobs integrate diff formats. (DWG, GIS, Raster etc.)
• Publish the jobs using FME Server (Schedule the jobs).
• Writing scripts Scala/Python programs to Spark core & Spark SQL for processing the iterative & adhoc jobs.
• Written PIG scripts to process the HDFS data.
• Created Hive tables to store the processed results in a tabular format.
• Developed the sqoop scripts in order to make the interaction between Pig and MySQL Database.
• Setting up cron job to delete hadoop logs/local old job files/cluster temp files
• Setup Hive with MySQL as a Remote Metastore
• Moved all log/text files generated by various events into HDFS location
• Lead the RefDB for TDF product.
• Designed the RefDB in normalization modal.
• Designed & Developed ETL packages for RefDB.
Enhanced the streams code (JSON, Parquet files included the API to the streams code etc ).
Description The Tour de France is an annual multiple stage bicycle race primarily held in France, while also occasionally making passes through nearby countries.
• Gathered the requirements, designing, and development and testing.
• Apply business knowledge to analyze and interpret data sets and identify root causes of problems and performance exposures.
• Prepare summaries, presentations, and graphic representations of projects.
• Using FME Desktop, created Jobs integrate diff formats. (DWG, GIS, Raster etc.)
• Publish the jobs using FME Server (Schedule the jobs).
• Writing scripts Scala/Python programs to Spark core & Spark SQL for processing the iterative & adhoc jobs.
• Written PIG scripts to process the HDFS data.
• Created Hive tables to store the processed results in a tabular format.
• Developed the sqoop scripts in order to make the interaction between Pig and MySQL Database.
• Setting up cron job to delete hadoop logs/local old job files/cluster temp files
• Setup Hive with MySQL as a Remote Metastore
• Moved all log/text files generated by various events into HDFS location
• Lead the RefDB for TDF product.
• Designed the RefDB in normalization modal.
• Designed & Developed ETL packages for RefDB.
Enhanced the streams code (JSON, Parquet files included the API to the streams code etc ).
Scala, UP, Processing, Google, Streaming, Server, Storage, Google maps, Development, Testing, Hive, Kafka, Gis, Spark, Ssis, Hadoop, Mysql, Analytics, Scripting, ETL, Database, Active Directory, JSON, Azure, MongoDB, API, Writing, SQL Server, Linux, Python, Sql
2016 - 2016
job
Informatica 9.6, Oracle, MSBI, SAS Admin
GE Cards.
Description To GE Credit cards and other financial apps for Aus./NZ and acted as a SAS Admin for GE SAS apps.
• Gathered data analytical requirements and transformed these in to technical specification documents.
• Lead the Analysis & Development team.
• Defined new metrics and approaches to analysis for gaining a deeper understanding of our raw data.
• Ad-hoc requests for processing the data using Spark/Scala.
• Created Hive tables to store the processed results in a tabular format.
• Designed & Developed ETL's for the STAGE & Mart.
• Created shell scripts to automate the stage loads.
• Gathered data analytical requirements and transformed these in to technical specification documents.
• Lead the Analysis & Development team.
• Defined new metrics and approaches to analysis for gaining a deeper understanding of our raw data.
• Ad-hoc requests for processing the data using Spark/Scala.
• Created Hive tables to store the processed results in a tabular format.
• Designed & Developed ETL's for the STAGE & Mart.
• Created shell scripts to automate the stage loads.
Oracle, ETL, Scala, SAS, Spark, Apps, Hive, Development, Processing
2013 - 2014
job
Sales
Canon EDW.
support, Canon, Australia.
Duration Nov 2013 - Feb 2014
Platform & Skills Informatica 9.1.5., Oracle 10g, SQL Server 2012, SSIS, Salesforce.
Description Worked as a backfill to Oakton Australia resource (Zhang Nina) for 6 weeks.
• Informatica cloud Support.
• SSIS Jobs support (CR's, SR's & Incidents).
• Sales force support.
• Data Mart support.
Project Name Pricemaster, Marketshare, USA
Duration Nov 2013 - Feb 2014
Platform & Skills Informatica 9.1.5., Oracle 10g, SQL Server 2012, SSIS, Salesforce.
Description Worked as a backfill to Oakton Australia resource (Zhang Nina) for 6 weeks.
• Informatica cloud Support.
• SSIS Jobs support (CR's, SR's & Incidents).
• Sales force support.
• Data Mart support.
Project Name Pricemaster, Marketshare, USA
Sql, SQL Server, Oracle, Cloud, Salesforce, Sales, Ssis, Support, Server, Sql server 2012, USA
2011 - 2011
job
Partner Performance AGG
Juniper Networks.
Platform & Skills Informatica 8.6.1. Toad 9.7
Description The objective of this project is to implement a solution that Increase the performance at the time of BO reports data Extraction using Informatica for Juniper PARTNER's data.
Description The objective of this project is to implement a solution that Increase the performance at the time of BO reports data Extraction using Informatica for Juniper PARTNER's data.
2009 - 2010
job
Xactly Incent Sales Comp
VeriSign Services India ltd.
USA.
Duration Nov 2009 - Dec 2010
Platform & Skills Informatica 8.1.1, UNIX, .csv
Description The purpose of this project is to provide deeper visibility into the PKI product line. This will be achieved by providing a consolidated reporting platform containing all PKI sources.
Project Name & Xactly Incent Sales Comp
Duration Nov 2009 - Dec 2010
Platform & Skills Informatica 8.1.1, UNIX, .csv
Description The purpose of this project is to provide deeper visibility into the PKI product line. This will be achieved by providing a consolidated reporting platform containing all PKI sources.
Project Name & Xactly Incent Sales Comp
Unix, Sales, Pki, USA
2007 - 2008
job
UNIX, PL/SQL Developer
SIEBELUPGRADE, Alaska Communication Systems.
USA.
Duration Aug 2007 - Apr 2008
Platform & Skills SSIS (ETL), SQL Server 2005, UNIX, PL/SQL Developer
Description Data migration team will migrate the scripts from DB2 Databases to SQL Server Databases. Data migration was originally scoped to migrate data from Siebel 7.5.3 and IPS to the new application.
Duration Aug 2007 - Apr 2008
Platform & Skills SSIS (ETL), SQL Server 2005, UNIX, PL/SQL Developer
Description Data migration team will migrate the scripts from DB2 Databases to SQL Server Databases. Data migration was originally scoped to migrate data from Siebel 7.5.3 and IPS to the new application.
Sql, SQL Server, ETL, Unix, DB2, Pl/sql, Ssis, Developer, Server, USA, SQL Server 2005
2006 - 2007
job
Informatica7.1.2, Oracle, UNIX, PL/SQL Developer
CPW DWH Support , Carphone Warehouse.
UK
Duration Dec 2006 - July 2007
Platform & Skills Informatica7.1.2, Oracle, UNIX, PL/SQL Developer
Description Production support (Overnight) Project for Carphone Warehouse Data warehousing.
Duration Dec 2006 - July 2007
Platform & Skills Informatica7.1.2, Oracle, UNIX, PL/SQL Developer
Description Production support (Overnight) Project for Carphone Warehouse Data warehousing.
Sql, Oracle, Unix, Pl/sql, Developer, Support, Production
2005 - 2006
job
Sales Consumer for LightSpeed Project
LightSpeed, AT&T.
Duration Sep 2005 - Nov 2006
Platform & Skills Informatica 7.1.3, Oracle, UNIX, Toad and Teradata
Description The purpose of this Sales Consumer for LightSpeed Project (SC4LS) is to source data to the Enterprise Data Warehouse (EDW) from OMS and provide
Platform & Skills Informatica 7.1.3, Oracle, UNIX, Toad and Teradata
Description The purpose of this Sales Consumer for LightSpeed Project (SC4LS) is to source data to the Enterprise Data Warehouse (EDW) from OMS and provide
Oracle, Data Warehouse, Unix, Sales, Teradata, Enterprise
My education
n/a
MSc, Information Technology
MSc, Information Technology
Vijaya's reviews
Vijaya has not received any reviews on Worksome.
Contact Vijaya Bandi
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Vijaya directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark