Now you can Instantly Chat with Ajit!
BIG Data Ecosystem: Hadoop HDFS, Map Reduce, Hive, Spark, Sqoop, PySpark
RDBMS: Oracle 12c/11g/10g / 9i etc., SQL Server 2008, MS- Access etc.
Languages: Python, SQL, PL/SQ, Visual Basic6.0
EBS: Oracle Apps R12 Supply Chain Management ...
Data & Analytics
CISCO Polaris Connected Quality Insights
The project involves integration of Polaris Hadoop database to Connected Quality Insights (CQI) which is a Quality metrics dashboard. It will show the compliance & quality metrics which will be used by PQEs and Clients quality team. The dashboard is intended to measure and improve component traceability. Traceability metrics are defined to surface gaps and provide actionable insights. The purpose of the dashboard is to enable clients’ traceability stakeholder to monitor PCBA site performance, drill-down on the gaps to troubleshoot, root cause and fix the gaps.
The project involves building a self-service, data centric and analytical data layer in big data platform (Hadoop Data Lake) and to provide access to business, data stewards, data scientist and SME’s via dashboard, API’s and interactive user interfaces to perform their day to day activities in terms of analyzing, arriving on critical insights and decision making on the enterprise data related to products health and costing, product quality , six sigma goals, global supplier management/quoting, spend and savings.
The data is ingested into Hadoop from various data sources like Oracle ERP, SQL Server, Cassandra, Teradata MySQL and Cisco legacy systems like Quality for manufacturing Excellence (QMX), Cisco Manufacturing Report Centre (CMRC), customer registry, product life cycle management and global supplier management etc.Show More Show Less
Return to ‘A’ Stock (R2A)
Return to A stock (R2A) is a reverse logistic process where the customer returns are evaluated for value recovery of the goods returned and make it available for reserving against future orders. The returned products are again sold to customers with minimal activity and resource utilization. Cisco has been able to get considerable value recovery through the process.Show More Show Less
Logistic Cost Analysis Tool
: LCAT (Logistics Cost Analysis Tool) is an application essential for understanding Cisco’s Manufacturing Freight Costs. LCAT is used to allocate to the BU’s (Business Unit) freight costs based upon actual cost. It provides Logistics Finance with all information required to complete monthly Freight Cost accruals. LCAT is used to capture and allocate freight cost down to a product family level for all shipments that are paid and will be paid by Cisco. The process covers both actual freight cost and planned freight cost.Show More Show Less
SkillsOracle 12c PL/SQL
Vehicle Order Management (VOM)
Toyota Motor Europe NV/SA (TME) oversees the wholesale sales and marketing of Toyota and Lexus vehicles, parts and accessories, and Toyota’s European manufacturing and engineering operations. Toyota directly and indirectly employs around 94,000 people in Europe and has invested over €7 billion since 1990. Toyota’s operations in Europe are supported by a network of 30 National Marketing and Sales Companies across 56 countries, a total of around 3,000 sales outlets, and nine manufacturing plants.
1. Project Management (includes MSR, MTR generation, Configuration Management, Quality Management )
2. Responsible for Technical designing (Detailed Technical design doc MD70 preparation), developing, and maintaining complex PL/SQL applications built off of Oracle 11g environment.
3. Worked on code migration, database change management and data management through the various stages of the development life cycle
4. Written PL SQL procedures, complex queries, functions, packages and triggers according to business requirements 5. Performance Tuning part taken care from the beginning of the development to improve the performance.Show More Show Less
Toolsvisual studio 2010