Shanthi Viswanathan
Verified Expert in Engineering
Data Architecture Developer
East Brunswick, NJ, United States
Toptal member since June 24, 2020
Shanthi has over 20 years of experience developing applications using various technologies. As an architect, she has executed several web-based applications, integrations, data migrations, data conversions, 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.
Portfolio
Experience
Availability
Preferred Environment
Node.js, R, Python, SQL, Linux, Neo4j, Oracle, Amazon Web Services (AWS)
The most amazing...
...project I've designed and coded determined the price of products based on sales promotions, order quantity, location, and customer status.
Work Experience
Data Analyst
Open Practice Solutions
- Developed ETL to bring data from multiple sources into a target reporting database.
- Automated the process of connecting to different data sources based on input parameters. Parameterized the selection of data from tables and columns in each data source.
- Built AWS Lambda functions and scheduled batch jobs to process data on a routine basis.
- Added error handling so that after a failed run, notifications are sent, and data is reset without impacting the user interface.
Data Engineer
Pfizer
- Technical architect in the development of ETLs to bring data from the Redshift data lake to project-specific Snowflake, Postgres, and Neo4j databases to represent complex relationships across different objects used for quality control.
- Built logic to provide restart capability in case of failures during the load. Produced several data pipelines and improved the performance of these ETLs.
- Developed a data model to support the UI for capacity planning, schedule optimization in labs, quality assurance, and resource management projects.
- Developed ETLs to forecast demand and perform inspection analyses using historical data.
- Designed, developed, and implemented search functionality using Elasticsearch across multiple languages. Converted the initial Postgres search logic to Elasticsearch for better performance.
- Built complex logic to reconcile source and target data. Added error handling such that after a failed run and reconciliation, notifications are sent, and data is reset in a manner that does not impact the front-end applications.
Data Integration Architect
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, and decommissioning of old systems.
- Migrated customers, products, and associated objects for over five million clients and 200,000 products using Informatica and Oracle Fusion middleware technologies.
- 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 homegrown asset management systems.
- Designed data pipelines to move data from the asset management system into a data lake.
Enterprise Architect
Biogen
- Managed product and vendor selection, technical architecture, data conversion and migration, proof-of-concept, and design standards.
- Managed the LMS-related data migration from SumTotal to SAP Success Factors. Delivered all integrations between the LMS and other systems.
- 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 in-house MongoDB database and built data pipelines to map clinical results.
Architect
GE, Celgene, 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 Middleware technologies.
- Defined the roadmap, implemented MDM, and consolidated integrations. Planned the roadmap for customer MDM at Celgene.
Architect
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 modules (OM, AR), Heiler, and other client applications.
- Spearheaded the project as the enterprise architect to bridge the business needs with the technology necessary to meet the business goals for eCommerce, master data management, document management, and product pricing.
- Integrated the new eCommerce platform Hybris with existing back-end systems like Siebel, Oracle EBS, and SQL Server.
- Responsible for the design, development of data marts, data warehouse, and OBIEE reports at Canon Europe, as a BI architect.
Technical Manager
Accenture
- Contributed to the "SOA Go-to-Market" strategy team and worked closely with client partners, senior executives, and Oracle Sales to close deals.
- Executed several projects for Accenture clients using Oracle technologies.
- Developed the canonical model based on OAGIS standards by closely working with business architects and leads.
Technical Manager
Oracle
- Led the BI portal group by managing a team of ten consultants while being billable 100%. The team’s utilization was more than 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.
- Implemented customer relationship modules (CRM) modules like iStore, iPayment, sales online, service contracts, XML gateway, and install base for clients like Canon, BMG, GE, and UBS.
- Managed onsite and offshore resources of up to 50 consultants on projects.
Experience
Quality Assurance (aka Sherlock)
Reporting of Insurance Claims for Open Practice Solutions Customers
Web Application to Capture Students' Performance
Asset Data Migration
-Oversaw and ensured delivery of all data analysis, mapping, and transfer aspects.
-Worked with program managers and business users to capture and analyze business requirements.
-Conducted gap analysis and developed data migration and integration plans.
Error Reporting of Failed Integrations
Education
ICWA (Master’s Degree Equivalent) in Cost Accounting
Institute of Cost and Works Accountants of India - Kolkata, India
Master of Science Degree in Applied Math
Anna University - Chennai, India
Bachelor of Science Degree in Mathematics
Madras University - Chennai, India
Certifications
Google Cloud Platform Fundamentals: Core Infrastructure
Coursera
Google Cloud Platform Big Data and Machine Learning Fundamentals
Coursera
Oracle Database Administrator
Oracle Corporation
Skills
Libraries/APIs
React.js, Node.js, jQuery
Tools
Oracle JDeveloper 12c, Oracle ERP, Tableau Development, ELK (Elastic Stack), Elastic, AWS, Excel Development, JDeveloper, Hybris, Informatica ETL, DataGrip, Atom, Splunk, Apache Airflow, Amazon QuickSight, Microsoft Development, Amazon WorkSpaces, Oracle Development
Languages
SQL, Python, Python, JavaScript, Snowflake, XQuery, R, Java, Visual Basic
Platforms
Linux, Oracle Development, Unix, Windows Development, AWS Lambda, Oracle Database, Apache Kafka, Oracle Development, Kubernetes, AWS
Storage
PostgreSQL, MySQL, Neo4j, NoSQL, MongoDB, Database, Redshift, Oracle Development, Amazon S3
Frameworks
Express.js, Hadoop, Django, Ruby on Rails
Paradigms
Service-oriented Architecture (SOA), ETL
Other
Data Architecture, Oracle Development, Data Migration, Data Modeling, Data Science, ATG, E-commerce marketing, Business Portals, Oracle EBS, Laboratory Information Management System (LIMS), Data Engineering, Data Visualization, Aerospace & Defense
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring