Jaya Prakash Reddy
Big Data/NoSQL Engineer with AWS
*************@*****.*** 915-***-****
SUMMARY:
• Possess experience with Big Data, NoSQL technologies such as Key Value Stores, In Memory Data Grids/Caches, Data Warehousing, MPP systems
• Hands-on experience with Greenplum development and administration
• Experienced AWS engineer
• Supported multiple deployments of Pivotal stack on on-prem and cloud platform
• Hands on data warehousing development including ETL/ELT and BI development
• Designed and implemented DW solutions using WhereScape RED
• Professionally trained and experienced with Couchbase
• Provided product expertise to customers including POCs, performance assessments and health checks
• Experienced in writing and tuning SQL Queries
• Excellent team player familiar with AGILE/SCRUM methodologies and possess experience working closely with the various tiers and functional groups within an organization TECHNICAL SKILLS:
Greenplum 4.X Couchbase 4.X AWS WhereScape RED
PostgreSQL 9.X Java Javascript Hadoop Ecosystem
Oracle 10g Attunity Python Spark
MS SQL server Bash GIT
PROFESSIONAL EXPERIENCE:
zData Inc., Professional Services, Cloud Engineer
08/2016 – Present
IoT project (POC) for a transportation company to collect, standardize and alert on vehicle data from various telemetry providers. Wrote SpringXD to collect, process and load to a Gemfire cluster and backup to S3 storage. Spring-XD will also be used to cache any persisted lookup data. Worked with the project team to design and implement the data ingestion process using Gemfire for ingestion sink and Python to automate the process. The initial setup was to get the ingested data into S3 and then use it as a source for real time analysis and test additional client use cases and higher data volumes. Assisted with cluster administration, workflow and proactive log monitoring
zData Inc., Financial Services client, Greenplum Engineer/Administrator 05/2016 – 08/2016
Developed Greenplum assessment blueprint and completed the initial engagement for a key Pivotal customer in the financial sector. Focused on completing a thorough assessment of the customer Greenplum environment and the data ingestion processes and provided recommendations to improve as well as mitigate any issues. Conducted a thorough exam of the environment including settings at the OS level and any GUCs set at the instance level. Completed root cause analysis for all stability, performance and availability issues and provided recommendations. Identified Tuning & Performance Optimization opportunities, reviewed Distribution Policies and partition strategies analyzed existing resource queues and workload Management policies. Also completed assessment and recommendations for the Backup and Restore process. Studied existing data ingestion processes and pointed out potential optimization opportunities. Educated DBA's to use the logs to uncover any existing or looming issues and provided knowledge transition sessions on technical matters and best practices to proactively manage and maintain a Greenplum environment. Findings and recommendations from the engagement was presented to a larger group at the organization
zData Inc., Healthcare Services client, Greenplum /Data Warehouse Engineer 09/2015 – 05/2016
Designed and implemented a data warehouse utilizing Greenplum. Designed the data ingestion architecture to source data from SQL server transactional systems and stage in Greenplum. Real-time CDC was implemented using Attunity Replicate and designed/configured to minimize the load on the source systems. Worked with Business Analysts and Development Team to load, cleanse, and conform the required data into the data warehouse using WhereScape RED. Setup multiple environments and instilled processes to deploy and migrate code. Conducted knowledge transfer sessions on Greenplum, Attunity, Wherescape RED and query tuning
zData Inc., Managed Services team, Greenplum Administrator/Data Engineer 06/2015 – 09/2015
Focused on providing support and product expertise for Pivotal implementations at multiple clients. Key responsibilities include Greenplum administration, monitoring and ensuring system availability, gpload/gpfdist scripts development, setup backup processes, user configuration and resource queue management setup. Have completed and supported multiple installations, upgrades and expansions. Perform routine health checks to assess environment status and performance. Work closely with on-site DBA's/Operations team to pro-actively monitor key metrics including data growth and day-to-day usage and alleviate any potential issues. Tasks also include providing clients with best practices and recommendations on Greenplum development and operations
MedeAnalytics Inc., Business Intelligence/SQL Developer 08/2014 – 05/2015
Worked as a developer for MedeAnalytics’ Health Plan Solutions business unit on BI development using SQL Server Analysis Server (SSAS) including developing cubes, dimensions, metrics and measures. Supported development and automation of ETL operations by designing processes and coding SQL queries to perform data loading and scripting. Complemented Business Analysts by collaborating with developers and business users to fine tune the requirements and identify and prioritize the KPIs. Cognizant Technology Solutions, Application/SQL Developer 06/2011 – 07/2013
Functioned as an SQL/Front-end developer in a larger team focused on creating a custom CRM application using mod-PL/SQL on Oracle database. Primary focus included writing SQL and Front-end development in Oracle Forms 10g and also utilizing HTML, Javascript and XML. Also used Generation from Oracle designer with the use of Oracle Headstart and CDM Ruleframe. Supported additional project tasks including functional and technical design activities, testing and release management. EDUCATION:
The University of Texas at Dallas – Masters in Management Information Systems, 2013 – 2015 Vellore Institute of Technology – Bachelors in Information Technology Engineering, 2007 – 2011