Prajosh Technologies

Available Actively Looking

Data Architecture

11 years experience UTC+05:30 Indian Standard Time (Mumbai, Delhi, Kolkata, Chennai)

Interested in:

remotefreelancer

Responds within Within 24 hours

Email, WhatsApp

Available:Mon, Tue, Wed, Thu, Fri • 09:00 - 17:00

About

Around 10+ years of experience in full Software Development Life Cycle (SDLC), including Analysis, Design, Development, Deployment, Testing, and Implementation of client/server applications. Expertise in Microsoft .NET technologies, including C#, VB.NET, ASP.NET, ADO.NET, and strong proficiency in Entity Framework and MVC architecture. Skilled in developing three-tier, N-tier, and SOA-based applications, leveraging RESTful and SOAP-based APIs to enhance software scalability and performance. Proficient in front-end technologies like HTML5, CSS3, JavaScript, JQuery, Bootstrap, AngularJS, and Angular 10+, delivering high-quality user interfaces. Hands-on experience in building cross-platform mobile applications using React Native for both iOS and Android. Expertise in cloud deployment with AW

Skills

TableauPytestPowerShellPandasOpenAINumPyMongoDBMachine LearningLinuxLLMJenkinsIAMHTTPFeature EngineeringDynamoDBData ScienceData AnalysisContainerizationCollaborationCassandraApache SparkApacheAirflowFastAPI.NET CorejQueryWebpackUnit TestingTypeScriptTest Driven DevelopmentTerraformTDDServerlessScrumSOLIDSOAPSASSRedisRESTfulREST APIProject ManagementOAuthMaterial UILeadershipLESSKubernetesJiraJestJavaScriptJWTInfrastructure as CodeHTMLGitLabGitHubGitExcelElasticsearchETLDockerDevOpsConfluenceCommunicationCSSCI/CDC#BootstrapBitbucketBabelAngularAgileASP.NET.NETVPNSnowflakeShell ScriptingScalaSQLPythonPower BIPostgreSQLOracle DatabaseMySQLJavaHadoopGCPData WarehousingData EngineeringAzureAWSAR

Work Experience

2026-01-01 - 2026-01-01

Key Roles: ss Responsibilities: ssss

tatements to access data from SQL Server Database

SQL Server Database

2025-04-19 - Present

tatements to access data from SQL Server Database

Wrote Stored Procedures, Transactions, Triggers and SQL

Master Pages

2025-04-19 - Present

Deployed triggers for e-mail confirmations.

Role: Senior Technical Specialist

Relations | Development

2024-10-01 - Present

onverting them to technical specifications/requirements and replacing current system with Windows and Web- based application.

ation, including system architecture diagrams, ETL process guides, and SOPs, ensuring effective know

ETL

2024-09-01 - Present

ation, including system architecture diagrams, ETL process guides, and SOPs, ensuring effective knowledge management and collaboration.

UnderstandthebusinessrequirementsandcreateDataorchestrationwithAzureDataBricksPipelines&Dataflows.

Associate Data

2024-08-01 - 2025-03-01

Solutions Architect-Associate certificate.

The Emergency Rental Assistance Program (ERAP) helps District residents earning less than 40% of the

PDF

2024-04-01 - 2024-09-01

Apply best practice like unit testing, code review and documentation in every stage of development.

Redesigning ,test, and maintains callable data pipelines to ingest, process, and trans form large vo

ApacheSpark

2024-01-01 - 2024-08-01

ingupdates,customernotifications,andsupply chain decision-making.

Setup and configure RMAN jobs for daily full back ups ,incremental backups and archive log backups a

RMAN

2023-06-01 - Present

mponents in the Oracle Ex a data machines.

Establishdatagovernancepoliciesandpracticestoensurecompliancewithindustrystandardsandregulatoryrequi

AT&T

2023-06-01 - 2024-01-01

timedataprocessingframeworkstohandlestreamliningdataforimmediateanalysisandaction.

Environment: Azure Data Factory (ADF), Azure Databricks, Azure Data Lake Storage (ADLS Gen2), Azure

Azure Data Factory

2022-05-01 - 2024-09-01

ing continuous team improvement and increasing sprint velocity by 25%.

Creating Pipelines using AzureDataFactory&AzureSynapseAnalytics,andAzureDataBricksusingforsomeofthec

Client : SKY&YES

2021-06-01 - 2023-06-01

ConvertingBashShellScriptsintoPythonScript.Monitoring&SupportfortheDataLibraries.

Project: New Business Administration 07/2015

Microsoft

2020-11-01 - 2023-08-01

Implementing technical innovations to keep up with technology trend.

PerformancetuningofSparkapplicationsforsettingrightbatchintervaltime,correctlevelofparallelismandmem

ConvertedsomeexistingSqoop

2020-03-01 - 2021-06-01

PerformancetuningofSparkapplicationsforsettingrightbatchintervaltime,correctlevelofparallelismandmemorytuning. ReviewedSparkCodeandworkedwithdevelopmentteamstocorrectproblems,runtestscenariosandpreparefordeployment. ConvertedsomeexistingSqoop,HiveJobstoSparkSQLapplicationstoreaddatafromRDBMSusingJDB

Environment: Azure Data Factory, Azure Synapse, Azure Databricks, Azure Lake Gen2, Azure SQL Databas

Implemented Azure Functions

2019-10-01 - 2022-05-01

Implemented Azure Functions for real-time, serverless data processing, transformation, and validation.

nvertedsomeexistingSqoop,HiveJobstoSparkSQLapplicationstoreaddatafromRDBMSusingJDBCandwriteittohivet

nvertedsomeexistingSqoop

2019-09-01 - 2020-03-01

nvertedsomeexistingSqoop,HiveJobstoSparkSQLapplicationstoreaddatafromRDBMSusingJDBCandwriteittohivetable.

Conduct and lead user acceptance review sessions and collaborates with other team members to perform

Windows Azure

2018-08-01 - 2020-11-01

Conduct and lead user acceptance review sessions and collaborates with other team members to perform unit testing.

Environment: Python, Hadoop, Hive, Spark, Kafka, HBase, Cassandra, MongoDB, Talend, Azure Data Facto

Hadoop

2017-05-01 - 2019-09-01

lability, and efficient resource utilization.

Environment: Environment: C#, BizTalk Server, Oracle 11g, EDI, SQL Server 2008/2012,Web API, Angular

TFS

2017-02-01 - 2018-07-01

Prepared the documentation and uploaded the documents in Confluence.

asetomeetuniqueneedsandgoalsdeterminedduringinitialevaluationandplanningprocess.Retail Case Study (M

Retail Case Study

2016-09-01 - 2019-09-01

asetomeetuniqueneedsandgoalsdeterminedduringinitialevaluationandplanningprocess.Retail Case Study (MySQL,HadoopEcosystems):Objectivewastolocally loaddataintoMySQLandapplyTransformations.

Built scalable distributed data solutions using Hadoop, leveraging expertise in data processing, sto

Spark-SQL

2015-03-01 - 2016-12-01

to pick up data from REST APIs, Data Lake, and SFTP servers, sending it to Kafka brokers.

Ford plans to offer later this year through its new Service Delivery Network is the ability to autom

SQL Server

2015-01-01 - 2015-07-01

ed stored procedures and Triggers using SQL Server

InvolvedingatheringrequirementsfromdifferentteamstodesigndatamigrationprocessfromexistingRDBMStoHado

DatabaseMigration

2013-08-01 - 2016-09-01

DatabaseMigrationfromOracletoPostgreSQL&MySQLtoPostgreSQL.

Created stored procedures to extract the data from the SQL Server.

Application

2012-02-01 - 2014-12-01

Extensively used Application and page level tracing feature of .Net to trace and debug the code.

The Main advantage of this project is to create an automated process to Capture, Extract BINs (based

LINQ

2010-07-01 - 2011-11-01

rotocol) for communication of application.

nvironmentsbeforemigratingittoExadataX6machinesto match with Bundle patch version.

MigratedusingDatapumpExport/Importforsmalldatabasesandnon-criticaldatabasesandusedDataGuardtoMigrate

2009-07-01 - 2013-06-01

nvironmentsbeforemigratingittoExadataX6machinesto match with Bundle patch version.

Company: ADEA Technologies India Pvt Ltd Role: Senior Software Engineer

ASP.NET

2009-05-01 - 2010-06-01

back end services using C# and ASP.NET and SQL Server.

Assist production support team if there are any major issues. And was involved in bug fixing.

PARTS

2007-02-01 - 2009-04-01

Involved in implementation of PARTS module.

Certifications

Synamedia Limited, Bengaluru Jun 2021 to Jun 2023

Resume Import

Supportforproductionissuesresolvingdataflow&AzureDataFactoryPipelineissuesandperformanceissuesforSparkscriptsandHiveScriptsalongwithAzureBlobStoragediscrepancyissues.

Resume Import

WorkedextensivelywithSqoopforimportingandexportingthedatafromHDFStoRelationalDatabasesystemsandVice-Versa.

Resume Import

Role :Oracle Developer

Resume Import

LoadDataLocallyinMySQLthenextractthatdatawithairflowschedulerthroughpythonscriptsintoAmazonWebServicesS3buckets.

Resume Import

WriteMapReduce programtofindtotalpromotionsalesgeneratedonweekdaysandweekends.

Resume Import

Redesigning ,test, and maintains callable data pipelines to ingest, process, and trans form large volumes of structuredandunstructureddatafromvarioussources(e.g.,IoTdevices,trackingsystems,customerrec

Resume Import

DevelopedaSchemadetectionandcorrectionapplicationinpythonaspartoftheSqoopingestionframeworktohandleall theschema changes while importing the data into HDFS.

Resume Import

Work Experiences

Resume Import

Writing SQL Queries as per customer requirement and developing.Involve in creating and managing tables, indexes, DB links and privileges.

Resume Import

Role :Senior Oracle Database Admin

Resume Import

Python ,Py Spark, Shell Scripting

Resume Import

Role :Data Engineer

Resume Import

ReviewedSparkcodeandworkedwithdevelopmentteamstocorrectproblems,runtestscenariosandpreparefordeployment.

Resume Import

SetupandconfigureRMANjobsfordailyfullbackups,incrementalbackupsandarchivelogbackupsandarescheduledusingCron.

Resume Import

InvolvedinBugfixing,RootcauseAnalysisandfollowingagilemethodologieswithdailystatus.

Resume Import

UnderstandthebusinessrequirementsandcreateDataorchestrationwithAzureDataBricksPipelines&Dataflows.

Resume Import

Cloud Services

Resume Import

TransformdatainS3andloaddatatoSnowflakeforanalysis.

Resume Import

Implementreal-timedataprocessingframeworkstohandlestreamliningdataforimmediateanalysisandaction.

Resume Import

SetupDataGuardbetweenmultipledatacentersfor12productiondatabases.

Resume Import

Troubleshootandresolveperformancebottlenecksinprocessingandquerying.

Resume Import

Modifiedexistingdatabasetomeetuniqueneedsandgoalsdeterminedduringinitialevaluationandplanningprocess.Retail Case Study (MySQL,HadoopEcosystems):Objectivewastolocally loaddataintoMySQLandapplyTransform

Resume Import

Orches tratedall data pipelines using Air flow to interact with services like Azure Data Bricks ,Azure Data Factory, Azure Data Lake and Azure Synapse Analytics.

Resume Import

InvolvedingatheringrequirementsfromdifferentteamstodesigndatamigrationprocessfromexistingRDBMStoHadoopclusterusing

Resume Import

SparkProject:PracticeusingSparkRDDtoloaddata,filterrecordsandusecomputationsfordifferentsectionsofdata.

Resume Import

Client : Northern Trust (Securities),Chicago. Mar 2020 – Jun 2021

Resume Import

AWS Certified Solutions Architect-Associate certificate.

Resume Import

WorkedwithStorageteaminconfiguringNetbackupandDatadomainonExadataX6machines.

Resume Import

Sqoop.

Resume Import

CapturingmetricsrelatedtoDatalibrariesconsistingofmultipletablesinPowerBIDashboard.

Resume Import

Wipro Limited, Bangalore

Resume Import

PerformfunctionsincludeSQLtuning,databaseapplicationdesign,anddevelopersupport.

Resume Import

Data Warehousing

Resume Import

SparkSQL to load and transform data for output.

Resume Import

Hadoop, Hive Sqoop, Kafka,Spark, Oozie,Impalaand Data bricks

Resume Import

AWS Data Engineering

Resume Import

GCP Data Engineering

Resume Import

Developandoptimizedatabasestructures,storeprocedures,dynamicmanagementviews,DDLtriggersanduserdefinefunctions.

Resume Import

ExtractTransformandLoadProcessforingestingdataintocloudsoftwareandanalysisoperation.

Resume Import

InstallationofOJVMpatchon11gR2databaseson ExadataX2andX3environmentsbeforemigratingittoExadataX6machinesto match with Bundle patch version.

Resume Import

EnsureseamlessintegrationbetweendifferentdatasystemsandapplicationswithintheBNSFRailwayecosystem.

Resume Import

Data Lineage for the business tables from Data Product Universe.

Resume Import

Creating Pipelines using AzureDataFactory&AzureSynapseAnalytics,andAzureDataBricksusingforsomeofthecustomersto build & deploy pipelines as per requirements.

Resume Import

PCAD(Certified Associate Data Analyst with Python)

Resume Import

DatabaseMigrationfromOracletoPostgreSQL&MySQLtoPostgreSQL.

Resume Import

MCA(Master of Computer Application) in AnnaUniversity,Chennai,2007.

Resume Import

Organization: Tech Mahindra ,Bangalore

Resume Import

AZ-500-MicrosoftCertified:Azure Security Engineer Associate

Resume Import

Client : AT&T (E2E) June 2023 – Jan 2024

Resume Import

Azure Data Engineering

Resume Import

GCP ,Azure ,AWS

Resume Import

Client : SKY&YES

Resume Import

Client :PHILIPS, Netherlands Sep 2016 – Sep 2019

Resume Import

Designedandimplementedareal-timedataprocessingpipelineusingApacheSparkandSnowflake, resultinginfaster datainsightsand improved decision-making.

Resume Import

Client :AVVNL(ENU)&UPPTCL(ENU)

Resume Import

CreatedPipelinesinADFusingLinkedServices/Datasets/PipelinetoExtract, Transformandloaddata fromvarioussourceslikeSQL Server, Azure SQL, Blob Storage and Azure Synapse Analytics.

Resume Import

DatabaseMigration fromOn-PremisestoAWSCloud (EC2,RDS, S3,CloudWatch,VPN,DMS,SCT) ManagedRHL/AWSRoleBasedSecurityandHadoopAdminLoadBalancingonAWSEC2Clusters.

Resume Import

Continuouslycoordinating with Oracle DBA Team.

Resume Import

Client : UPS(United Parcel Service) Aug 2024 – Mar 2025

Resume Import

FineTuningSparkjobsperformance,QueryoptimizationbyenablingAdaptiveQueryOptimization,Propershufflepartitions,Optimizing Tasks & Stages execution.

Resume Import

InvolvedindevelopmentofscriptsformonitoringtheresourceusageinSnowflakeenvironment.

Resume Import

Develop complexPL/SQLpackages,procedures,functionsfortheapplication,accordingtobusinessrequirementsinUNIXandwindows environments.

Resume Import

UsedprogramminglanguageslikePython,Java,Scala,orSQLtodevelopandmaintainworkflows.

Resume Import

Client :NECCorporation,Japan. Sep 2019 – Mar 2020

Resume Import

Roles &Responsibilities:

Resume Import

WorkwithtoolsandplatformslikeAzure,AWS,GCP,orUPS’sin-housesystemstodeployandmanagedata solutions.

Resume Import

Role : Data Engineer

Resume Import

Designsolutionsforreal-timedataprocessingtosupporttrackingupdates,customernotifications,andsupply chain decision-making.

Resume Import

Oracle, MySQL, PostgreSQL, Mongo DB,SQL ServerandHBase

Resume Import

Client :Charles Schwab(Securities),Denver,USA. Aug 2013 – Sep 2016

Resume Import

AutomatedataextractionandintegrationworkflowsusingETL/ELTtoolslikeDatabricks,ApacheSpark,or Informatica.

Resume Import

ICSA(INDIA)LIMITED, Hyderabad July 2009 to June 2013

Resume Import

ConvertedsomeexistingSqoop,HiveJobstoSparkSQLapplicationstoreaddatafromRDBMSusingJDBCandwriteittohivetable.

Resume Import

Optimizedatapipelineandstorageperformancetohandlehighvolumesofdatageneratedbylogisticsoperations.

Resume Import

AI Engineer (AR Ti BA)– Pursuing.

Resume Import

Educational Details

Resume Import

Designandimplementdataingestionprocessestocollectdatafromvarioussourcessuchassensors,trainmanagementsystems, external data providers.

Resume Import

Role : Senior Data Engineer

Resume Import

Scripting

Resume Import

ConvertingBashShellScriptsintoPythonScript.Monitoring&SupportfortheDataLibraries.

Resume Import

MigratedusingDatapumpExport/Importforsmalldatabasesandnon-criticaldatabasesandusedDataGuardtoMigratehugeand critical databases with 99% uptime.

Resume Import

CreatedandmodifiedcomplexSQLbasedqueriestoaccess, exploreandpulldatafrommultiplesources,responsibleforacquisitionand maintenance of data stored in a Hadoop.

Resume Import

Establishdatagovernancepoliciesandpracticestoensurecompliancewithindustrystandardsandregulatoryrequirements.

Resume Import

Modify,maintainanddevelopPL/SQLcodesfornewcustomerrequirementswhichinvolve cursors, functions,procedurestriggersand collections.

Resume Import

Visualization

Resume Import

Workedwithnetworkandlinuxteamstoconfigurethenetworkon theExadatax6machinessoOracleACScaninstallGridinfrastructure 12cR2 and Databases 11g R2 and 12cR1

Resume Import

Power BI

Resume Import

Snowflake ,Red shift and Big Query

Resume Import

Client : BNSF Railway Jan 2024 – Aug 2024

Resume Import

Setupandmanagedatalakesforstoringraw,unstructured,andsemistructureddata.

Resume Import

Big Data Technology

Resume Import

ImplementedaSnowflake-baseddatalakearchitecturethatreduceddataprocessingcosts.

Resume Import

ImplementDataqualitychecksandmonitoringtoensureaccuracy,consistency,andreliabilityofdata.

Resume Import

DataAnalysisandEnd-2-EndDataQualityduringEnd-2-EndMigration.

Resume Import

Databases

Resume Import