Overview
Work History
Education
Skills
Technical Summary
Course Projects
Additional Qualification
Projects
Timeline
Generic

Joshva (Josh) Peter

Scottsdale

Overview

21
21
years of professional experience

Work History

Database Architect

MCKESSON SPECIALTY ARIZONA INC.
06.2016 - Current
  • Installed and configured more than 150 Microsoft SQL Servers
  • Migrated Sybase IQ database to Azure SQL Data warehouse
  • Created, automated security schema code to controls HIPAA data in databases such as SQL, Oracle and Sybase databases
  • Created and automated SSIS and SSRS reports for Vantage, Vertex Shipment, Travatan and multiple business users from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
  • Implemented Time Series Algorithm using Python to track database spaces for the next 6 months to save 20% disk space cost
  • Database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs
  • Configured LDAP authentication for various databases
  • Experienced in High Availability of SQL Server clusters
  • Experienced in Deep Learning with TensorFlow, Graphical Models, Reinforcement Learning and PySpark
  • Hands on experience in installation and configuration of Hadoop HDP Clusters
  • Knowledge in Hadoop services such as HDFS, YARN, Map Reduce, HIVE, Zookeeper, Oozie, Spark and HBase
  • Involved in extracting, transforming and loading data from local to HDFS and HIVE
  • Technical Skills: MS SQL Server, SSIS, SSRS, Regression, Artificial Neural Network, Clustering, Time Series Forecasting, Azure, Hadoop, TensorFlow, Pandas, Numpy, Scikit-Learn, Flask, CUDA toolkits/libraries, Pytorch, Docker and Apache Spark
  • Achievements: Created Security Schema tool to protect all the social security numbers and PHI data with zero tool cost
  • Tool is still in use and its effective way of controlling all the database permissions and revoking permissions from unknown users.

Database Administrator

AMERICAN EXPRESS -ARIZONA
12.2008 - 06.2016
  • Installed, Configured and Upgraded multiple databases including Oracle 12C, Sybase ASE/IQ (12.6,15.3,16), Microsoft SQL Server (2008,2012,2016), Replication Server (12.5/16) and Teradata in Dev/UAT/Production environment
  • Built a home-grown job scheduler engine using Sybase ASE database to monitor Microsoft SQL Server, Sybase ASE/IQ and Bigdata jobs
  • Reduced customer cost from buying third party tools
  • Experienced in SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS
  • Created automated script for IQDBCC Check node and code release process all the modules in the repository
  • Experienced in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
  • Automated full, incremental and transactional backups at regular backups
  • Designed and developed table structures, transact - SQL stored procedures and triggers to implement business rules
  • Resolved more than 1500 DBA Issues (Ticketing System) in our environment
  • Technical Skills: Linux, SUN Solaris 2.8, SYBASE ASE 12.5, SYBASE Replication Server 12.5, Oracle 9x, Putty, Hummingbird, Teradata, Hadoop (CDH), SQL Server
  • Achievements: Worked as a Lead in Cross migration platform.

Trainee Developer

Marc Technologies- INDIA
03.2006 - 07.2007
  • Administered, configured and monitored Sybase Adaptive Server Enterprise 12.5 on Sun Solaris 2.8
  • Designed and developed table structures, transact SQL, stored procedures and triggers to implement business rules
  • Worked in Compiere Implementation and Time Sheet Projects
  • Analyzed & resolved the root causes for the deadlocks occurring in production system
  • Devised & Implemented Backup Strategies for Sybase OLTP Databases.

Trainee Developer

SSI Ltd-INDIA
05.2003 - 06.2005
  • Developed Visual basic and Java code for local vendor application
  • Conducted various training program for students regarding Java and Visual basic programming language.

Education

Master of Science - Electrical Engineering

Bridgeport
Bridgeport, CT

Bachelor of Engineering - Electrical and Electronics

Skills

Pythonundefined

Technical Summary

Enthusiastic self-starter and a team player, passionate to harness the power of data to derive actionable insights from complex datasets. Close to 14 years of IT experience with excellent programming skills and proficiency in Object Oriented Programming language like Python and Relational Databases. Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment. A strong foundation in ML/AI, computer science, Software Engineering, Data Structures, statistics and mathematics. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.

Course Projects

  • Wireless Collision Correction Algorithm using h-Binary Exponential Back off Algorithm, 2007-08-01, 2007-12-01
  • Genetic Algorithm for Solving Travelling Salesmen Algorithm
  • Stock Chart Project- Distributed Services Architecture with Caching and Load Balancing
  • XYZ Shopping

Additional Qualification

Oracle Certified Associative Programmer

Projects

University of Bridgeport, 2008-01-01, 2008-06-01, Network Security and Confidentiality -If user violates the security rules then Network and Host Agent updates the session details mentioning a violation security rules and forecasts an attack on system depending on the severity of violation. Coded and Tested Fuzzy Logic, 2004-03-01, 2005-04-01, D.C Motor Control using Fuzzy Logic - It is used to control the Speed of the D.C- Motor.

Timeline

Database Architect

MCKESSON SPECIALTY ARIZONA INC.
06.2016 - Current

Database Administrator

AMERICAN EXPRESS -ARIZONA
12.2008 - 06.2016

Trainee Developer

Marc Technologies- INDIA
03.2006 - 07.2007

Trainee Developer

SSI Ltd-INDIA
05.2003 - 06.2005

Master of Science - Electrical Engineering

Bridgeport

Bachelor of Engineering - Electrical and Electronics

Similar Profiles

CREATE PROFILE
Joshva (Josh) Peter