Satyam Prakash Email and Phone Number

· Initiated and managed the successful implementation of cutting-edge big data data governance procedures and policies, driving overall organization performance and efficiency.· Designed and implemented data marts and warehouses that enabled the enterprise to take a holistic view of their online and offline sales, campaigns, customer behaviour etc.· Developed workflows to process various incoming data in different formats and save it to GCS/BigQuery which are being fetched both batch wise and real time.· Developed UNIX shell scripts, python scripts, scheduled SQL scripts to harness data from different sources on to GCP environment.· Different sources include S3 bucket, REST APIs, files being SFTP to GCS on a timely routine· Prepared aggregated views/tables in Bigquery to be utilized by stakeholders from variety of teams like Marketing/CRM etc. to prepare monthly/weekly reports, summary charts etc.· Tuning of the efficiency of existing workflows and housekeeping· Worked with company’s Info Sec team and implemented various features like SSO organization wide, for automated user access management, DevSecOps implementations to secure the software development boundaries.· Posed a SME for company’s internal stakeholders, team members and vendors and assisted them with their requirements.

· Developed workflows to process various data in different formats and save it toHadoop/NoSQL tables which are being fetched both batch wise and real time.· Developed data pipelines using PySpark, UNIX shell scripts, python.· Data migrations from RDBMS to Hive· Tuned of the efficiency of existing workflows and developed housekeeping rules· Designing, building and configuring Hadoop for Big Data Platform on Cloud· Requirement gathering from clients for new features.· Fixing existing issues in the system and writing code for enhancements.· Team Management

· Implemented spark jobs in Java using Spark SQL, Core, Streaming (Datasets,Dataframe, Shards, etc.)· Data Modeling and migrations from SQL Server to Hive· Handled XML and JSON data through Java-Spark code.· To Write a Pig Latin scripts to transform the data in required format· Written Java code to connect Hive, HBase, Cassandra through Spark and have doneSOQ code.· A total of 6 stored procedure have migrated from SQL Server to Java Program in spark dataframe.Associate Software Engineer

· Involved in importing data from MySQL to HDFS using SQOOP.· Involved in writing Hive queries to load and process data in Hadoop File System.· Involved in working with Impala for data retrieval process.· Analyzed the rental policy based on the attributes· Prepared data for modelling by selecting variables and selecting rows using systematic sampling.· Designing, building, and configuring Hadoop Eco System.

· Played a key role in the enablement of process automation and implementation ofPLM.· As a Supply Chain Analyst, used to analyze day to day Purchase data and prepare executive reports using Excel.· Constantly liaising with the IT to get the custom data from the database usingMySQL.· Constantly liaising with Design and development team to generate the inputs for automation and Project Lifecycle Management project running in the organization.· Constantly liaising with the Manufacturing and Quality teams to get the essential inputs on the project completion status.· Closely working with the Marketing Team to keep a track of customers and new business prospects.

Supply chain and vendor management.Production Shop Floor Management