Prashant Upadhyay Email & Phone Number

San Francisco, Ca, Us

Seattle, Wa, Us

Seattle, Wa, Us

Mountain View, California, Us

As a Big Data Consultant, I have provided services to many enterprise customers such as H&R Block, Sprint, Intuit and Aetna Insurance. Summary of tasks undertaken at various projects in Auropro are as below:• Design and develop Datta Strategy for Migration to Big Data Platforms.• Alignment with Business sponsors on objectives and outcomes.• Designed Test strategy and test Plan creation• Involved in daily Sprint meetings and plannings• Status Reporting to Management Executives and Business owners• Data Warehouse Migration to Hadoop Stack using real-time as well as batch processing frameworks for HBase, Hive in HDFS. (Lambda architecture)• Enterprise Data Lake creation using Hadoop technologies such as Sqoop, Flume, Hive and EDW DB2 for faster analytics on Big Data and to save cost on EDW infrastructure• DWH systems I have migrated include MSSQL Server, Netezza and Teradata and target Hadoop stack comprised Spark, Kafka• Lambda Architecture design and development using Hadoop and IBM Netezza technologies• Defined development and ETL strategy using hql and Scala Spark sql for External and internal Hive tables• Data deduplications from source and lookup into target before inserting it into hive using file format like ORC, Parquet etc.• Performing ETL using hive query language on incoming data and loading it into Hive tables• Reading encrypted Google’s Protobuf files using Spark and loading the data in HBase using HBaseContext. • Extensive performance tuning for Hadoop cluster optimization, Hive query Optimization, Spark jobs etc.• Aggregations and data roll ups based on data frequency and business requirements• Developed Oozie workflows to launch hql jobs, shell scripts, java codes based on business logic and needs• Developed Airflow data pipeline and workflows to launch load files and perform ETL on raw data before moving it into target• Used Amazon Cloud architecture and Azure HDInsight architecture for Big Data as part of POC’s

Mumbai, Maharashtra, In

>> Worked on a range of technologies in various roles (Lead, Architect) for variety of Projects.>> Informatica Certified Developer and Oracle Certified Associate>> Big Data Solution Design, Business Requirement Analysis, Data Mining, Data warehousing and >> Business intelligence (BI) Applications, Designing, Application Development, Product Configuration, Maintenance Operations, & Team Management.>> Hadoop ecosystem and No SQL Technologies>> Machine Learning algorithms and tool sets (including Mahout and R)>> Amazon Web Services – AWS cloud computing (EMR, EC2 and S3 services).>> Excellent knowledge on MySQL, Oracle, DB2 and RDBMS.>> Working knowledge of .Net programming, creating msi installers, SQL Server 2005, DB2 and Java Programming.>> Undergone client sponsored training for Share Point Admin and Nintex Workflow.>> Experience in producing detailed technical specifications.>> Have won many TCS GEMS and Accolades for giving best performance, innovation and achieving the difficult deadlines before time.>> Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.>> Proficient in handling Onsite-Offshore business model.

Au

>> Webpage development using JSP as front end, MYSQL as back end and Apache Tomcat server.>> Preparing screen layouts and functional requirement specifications.>> Preparing Unit Test cases, test data and verification of Unit test Results.

In

>> Project involved software development to streamline the maintenance activities of BARC’s DHRUVA Reactor’s Electrical Department, under the Department of Atomic Energy. >> Software was developed for better availability, reliability and maintainability of the equipment's. >> Project was proposed to be implemented as Inventory Management & Maintenance Management software at the site.