尚Viswanathan，美国新泽西州东不伦瑞克的开发商
Shanthi is available for hire
Hire Shanthi

尚Viswanathan

Verified Expert  in Engineering

数据工程开发人员

Location
东不伦瑞克，新泽西州，美国
至今成员总数
June 24, 2020

Shanthi has over 20 years of experience developing applications using various technologies. As an architect, 她执行过几个基于web的应用程序, integrations, data migrations, 数据转换, and data warehousing projects with significant hands-on as well as leadership responsibilities. She keeps up-to-date with the latest technologies and can effectively match the business needs with those technologies.

Oracle Fusion中间件SQLOracleLinuxOracle JDeveloper 12cPostgreSQLData ModelingUnix面向服务的架构(SOA)WindowsJavaScriptMySQLPythonPython 3Tableau

Portfolio

Pfizer
Python, R, SQL, Redshift，实验室信息管理系统(LIMS)...
世界卫生伙伴
MySQL, MongoDB, Django, Python
Exelon
Apache Kafka, Hadoop, Python, Oracle数据库，Informatica ETL...

Experience

SQL - 20 years数据工程——10年数据建模——9年Python 3 - 3年Neo4j - 2 yearsR - 1 yearReact - 1 yearNode.js - 1 year

Availability

Part-time

首选的环境

Node.. js, React, R, Python, SQL, Linux, Neo4j, Oracle

The most amazing...

...project I've designed and coded determined the price of products based on sales promotions, order quantity, location, 以及客户状态.

Work Experience

Data Engineer

2020 - PRESENT
Pfizer
  • Technical architect in the development of ETLs to bring data from the Redshift data lake to project-specific Postgres and neo4j databases to represent complex relationships across different objects used for quality control.
  • Built logic to provide for restart capability in case of failures during the load. 生成了几个数据管道，并改进了这些etl的性能.
  • Developed a data model to support the UI for capacity planning and schedule optimization in labs.
  • Developed ETLs to forecast demand and inspection analysis from historical data.
技术:Python, R, SQL, Redshift，实验室信息管理系统(LIMS), DataGrip, Oracle SQL开发人员, Atom, Neo4j, 数据架构, Data Modeling, Kubernetes, Splunk, Apache Airflow, Tableau, PostgreSQL, 亚马逊网络服务(AWS)

技术经理

2019 - 2019
世界卫生伙伴
  • Designed and developed a web application to be used in rural schools for capturing student performance using Python, Django, MySQL.
  • 设计数据架构，捕捉学校, courses, offerings, 教师和教师/学生评价.
  • 规划了未来的阶段，并为云部署提供了路线图.
技术:MySQL, MongoDB, Django, Python

数据集成架构师

2017 - 2019
Exelon
  • Delivered integrations across several systems with the enterprise asset suite management system.
  • Led a 15-member team of offshore and onsite developers in the delivery of all integrations, data migrations, 旧系统的退役.
  • 迁移的客户, products, 和相关的对象为超过500万的客户和200,000产品使用Informatica和Oracle Fusion中间件技术.
  • Used GitHub as a source repository and Maven and Jenkins for continuous deployment.
  • Designed the data architecture for data migration and data cleansing of the home grown asset management systems.
  • Designed data pipelines to move data from asset management system into data lake.
技术:Apache Kafka, Hadoop, Python, Oracle数据库，Informatica ETL, Oracle Fusion中间件

企业架构师

2015 - 2017
Biogen
  • 管理产品和供应商选择, 技术架构, 数据转换和迁移, 概念验证, 设计标准.
  • Managed the LMS related data migration from SumTotal to SAP Success Factors. 交付LMS和其他系统之间的所有集成.
  • Managed the reporting framework to produce dashboards and customized reports by integrating data from several of Biogen's core systems. The architect for reporting solutions using Informatica, Spark, and Tableau.
  • Loaded 23AndMe data into an inhouse MongoDB database and built data pipelines to map clinical results.
技术:Oracle Fusion中间件, Tableau, MongoDB, R, Python

Architect

2014 - 2015
通用电气，新基因，DirecTV
  • Acted as the release captain responsible for the implementation of a heavily customized web-based Java application built on Oracle HR.
  • Acted as the enterprise architect responsible for defining the roadmap for the integration of LifeShield operations with DirecTV using Oracle Fusion中间件 technologies.
  • 定义路线图、实现MDM和整合集成. 为Celgene的客户MDM规划路线图.
技术:Oracle融合中间件、主数据管理(MDM)

Architect

2011 - 2014
SelectComfort, CanonEurope, Panduit
  • Acted as the solution architect responsible for delivering an integrated web experience to distributors and partners using Webcenter Suite, UCM, Oracle EBusiness模块(OM, AR), Heiler, 以及其他客户端应用程序.
  • Spearheaded the project as the enterprise architect to bridge the business needs with the technology necessary to meet the business goals for eCommerce, 主数据管理, 文档管理, 以及产品定价.
  • Integrated the new eCommerce platform Hybris with existing back-end systems like Siebel, Oracle EBS, and SQL Server.
  • 负责设计, 数据市场的发展, data warehouse, OBIEE在佳能欧洲报道, 作为BI架构师.
技术:Oracle Fusion中间件、电子商务、ATG、SAP Hybris

技术经理

2007 - 2010
Accenture
  • Contributed to the “SOA Go-to-Market” strategy team and worked closely with client partners, 高级管理人员, 以及甲骨文销售公司终止交易.
  • 使用Oracle技术为埃森哲客户执行了多个项目.
  • Developed the canonical model based on OAGIS standards by closely working with business architects and leads.
技术:Oracle Data Integrator (ODI), 面向服务的架构(SOA), Oracle Fusion中间件, XQuery, Python

技术经理

1997 - 2007
Oracle
  • Led the BI portal group by managing a team of ten consultants while being billable 100%. 团队的利用率超过90%. Actively involved in recruiting, training, resourcing, mentoring, and growing the team. Organized portal night classes and training and invited several key senior members to give talks.
  • 实现客户关系模块(CRM)模块，如iStore, iPayment, sales online, 服务合同, XML gateway, 并为佳能等客户安装底座, BMG, GE, and UBS.
  • 管理项目中多达50名顾问的现场和海上资源.
技术:Oracle融合中间件、Oracle EBS、Java、业务门户

Web应用程序捕捉学生的表现

Architected a web-based application for 世界卫生伙伴 (India chapter) to be used by rural schools to enter students’ performance on quizzes. I designed the database objects and APIs from scratch to be used in the web application built with Python and Django and deployed in AWS. 我还使用Python、MySQL和MongoDB数据库开发了核心api.

资产数据迁移

The client had over six million customers in their CRM system and half a million assets in the GIS system. I was responsible for migrating these customers and assets one time into the new Asset Management System and plan for the syncing of updates between the two systems.

*Oversaw and ensured delivery of all aspects of data analysis, mapping, and transfer.
*Worked with program managers and business users to capture and analyze business requirements.
*进行差距分析，制定数据迁移和整合计划.

集成失败的错误报告

The client had several integrations - real-time, batch, and near real-time. 由于硬件问题或软件故障，集成失败. Many times it is hard for the source system to resend the data for failures. I built a semi-automated error handling framework to reprocess failed transactions wherever possible—built reports with a drill-down feature to get to the bottom of the erroneous transaction for root-cause analysis. 我使用Python、XML和PL/SQL开发了一个web应用程序.
1987 - 1989

具有成本会计硕士学位同等学历

印度成本和工程会计师协会-加尔各答，印度

1982 - 1984

应用数学理学硕士学位

安娜大学-金奈，印度

1978 - 1982

理学学士学位，主修数学

马德拉斯大学-金奈，印度

2020年5月至今

谷歌云平台基础:核心基础设施

Coursera

2020年5月至今

谷歌云平台大数据和机器学习基础

Coursera

2005年10月至今

Oracle数据库管理员

甲骨文公司

Libraries/APIs

React, Node.js, jQuery

Tools

Oracle JDeveloper 12c, Oracle ERP, Tableau, JDeveloper, SAP Hybris, Informatica ETL, DataGrip, Atom, Splunk, Apache Airflow

Languages

SQL, Python, Python 3, JavaScript, XQuery, R, Java, Snowflake

Storage

PostgreSQL, MySQL, Neo4j, NoSQL, MongoDB, 主数据管理(MDM), Redshift, Oracle SQL开发人员

Platforms

Linux, Oracle, Unix, Windows, Oracle Database, Apache Kafka, Oracle Data Integrator (ODI), Kubernetes, 亚马逊网络服务(AWS)

Paradigms

面向服务的架构(SOA)

Frameworks

Express.js, Hadoop, Django, Ruby on Rails (RoR)

Other

数据架构, Oracle Fusion中间件, Data Modeling, ATG, eCommerce, 企业门户网站, Oracle EBS, 实验室信息管理系统(LIMS), 工程数据

有效的合作

如何使用Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

选择你的才能

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

开始你的无风险人才试验

与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.

对顶尖人才的需求很大.

Start hiring