Oracle PL/SQL SQL Developer

AMIT MAN SINGH

Forth Worth, TX

Contact: 812-***-****

*********@*****.***

Github: https://github.com/amitms

Portfolio: https://amitms.github.io/Portfolio-Site/

Summary:

With over 12 years+ of experience with a strong foundation in RDMBS and knowledge of modern data engineering tools including NoSQL, big data technologies like Spark, and ETL tools, seeking a data role. My understanding of data management principles and certifications, combined with practical knowledge of different technologies, allows me to hit the ground running. I am eager to apply my technical skills to contribute efficiently to data-driven projects.

●Proficient in RDBMS programming skills in Oracle - PL/SQL, MS Sql, MySQL databases.

●Strong RDBMS concepts in expert in DDL/DML, tuning, writing stored procedures, functions, joins, packages and triggers in PL/SQL

●Use of T-Sql (MS Sql) in Microsoft products, Data integrating and transformation using SSIS, analytical, Modeling tools using SSAS to create multidimensional OLAP cubes. Also create client reports using SSRS.

●Familiarity with Big Data Technology landscape like Hadoop architecture, HDFS, YARN and tools on top of it like big data processing Apache Spark (Scala language, R, Python), Spark SQL and platforms like Azure Synapse Analytics which supports on-premise and cloud deployments.

●Knowledge NoSQL databases like MongoDB, IBM Cloudant, Cassandra and Data visualization tools like Tableau, Power BI, Cognos, Google Looker Studio.

●Apart from data platforms, worked and built Core Java applications (Ant, Maven), implemented TCP socked-based messaging using Java (ServerSocket / Socket) and enterprise messaging systems including VMB (Pulsar) and Kafka.

●Often created Bash shell Unix script to schedule and automate database stored procedures.

●Worked on applications with REST API web services, performed API testing using Postman, Swagger UI.

●Also familiar with front-end languages HTML, JavaScript, CSS, frameworks like Angular JS, React JS

●Understanding of data science algorithms like - Linear Regression models, Logistic Regression Model, Supervised- Decision Tree, unsupervised learning - KNN, clustering (hierarchical, non-hierarchical) etc.

●Collaborated with cross-functional Art Teams to achieve project milestones. Experience in Data Quality check of produce SDLS lifecycle, CI/CD tools like Jenkins, familiarity with Agile Methodology.

Technical Summary / Skills:

Languages/Frameworks: SQL, PL/SQL, Oracle Database 11g, Python 2.7.14, Redhat Enterprise Linux (ver5), PostgreSQL, Scala, Apache Spark, R, HTML 4, Javascript ES6, CSS

Tools: SQL PLUS, Oracle SQL Developer 4.0, Eclipse IDE 4.24, Gitlab, qTest, Jenkins, confluence, WinSCP, MT Putty, R Language, K2View, Oracle, Microsoft SQL Server 2005, Microsoft SQL Server Analysis Services. Red Hat Linux System (RHEL 5) .

Experience:

Infosys (ITL USA), Richardson, TX

Technology Lead for Verizon, JCI Controls

2019 Aug to 2025 Oct

Projects:

Project Title: JCI Controls - Datasource - BOA Dashboard/ Fire Enrollment

Duration: From April 2025 to Oct 2025

The Datasource application was an application for security / Fire customers which has a dashboard for service management, alarm from the devices,and customer management. It allows customer management such as user management, enrolling new accounts etc. the application is hosted in IBM WebSphere with portlets.

Roles and Responsibilities:

●Design and implement databases enhancement and their PL/SQL package development

●Understanding new UI/ Backend / db requirement and implementing new features of fire enrollment design, its database new objects, create packages, triggers etc.

●Working closely with backend REST APIs and UI React pages with JSP pages.

Project Title: JCI Controls - Peoplesoft SG timesheet

Duration: From July 2025 to April 2025

Supported a Peoplesoft-based timesheet application used to capture regular, overtime and double time horse for union/non-union fire employees, Built and maintained data ingestion and integration of workflows from multiple sources, including HR employee data, kronos payroll timesheets, Fusion contract and branch data, Peoplesoft benefits and fringes and OneSpan e-signatures. Integrated and processed these datasets through DE audit logic to determine payroll eligibility. Generated CPPW payroll reports(Excel/PDF) with net pay, gross pay, taxes and fringe deductions by branch and delivered them to Fusion and Axway for downstream reporting.

Roles and Responsibilities:

●Understanding business logic for union / non-union employees work hours, deductions such as federal/state/fringes that is applicable for certified payroll generation with the clients

●Implemented them into calculations in different stages of PL/SQL package developments. Then it was generated into pdf with Java process convert to pdf.

Project Title: Verizon INMS VPNS

Duration: From May 2025 to June 2025

INMS is topology-based alarm correlation engine that enables customer-centric network management across all network domains at converged NextGen NOCs by identifying root-cause failures across multiple network domains. Integrated with impact applications, INMS (S2i) supports real-time monitoring for Network Operations Centers and enables rapid issue resolution for internal lines of business (VZT, VZB). VPNS ingests network inventory data (equipment and circuit data) from external systems such as Nautilus via a topology loader and persists it in topology databases for downstream processing. Alarms are also received from systems including UCS and BNC. Inter-system messaging is handled through VMB to ensure high availability of Verizon Package Network services.

Roles and Responsibilities:

●Development of source data client application through VMB whose messaging was through TCP sockets (in JAVA). VMB was under the Pulsar backend instead of Kafka. The application both had Pulsar producers and Consumer in the applications.

●Key technologies used are Java 1.8, ANT, Shell Scripts, SQL, HTML changes.

●Tools used Eclipse ICE 4.24, Gitlab, qTest, jenkins, Confluence, UNIX server, WinSCP, PuTTy, MT PuTTy fixes of topology loader, correlation engine rules etc.

Project Title: Verizon Netcool Project

Duration: From July 2020 to June 2021

Designed a Big Data-driven fault-management data flow using Netcool Enrichment to replace the legacy Looper system for NextGen BGW provisioning. Implemented Ingestion of network inventory data from ICON, event generation (AID), and real-time alarm enrichment for Cisco and Ciena devices. Normalized and transformed Layer-2 Netcool XO alarm datasets, built provisioning-key logic and enhanced alarm processing to support automated provisioning and scalable fault management.

Roles and Responsibilities:

●Developed and maintained PL/SQL stored procs to generate AID events for network devices, enabling automated provisioning and fault management workflows.

●Implemented data extraction and processing logic using PL/SQL and UNIX shell scripts to integrate network inventory data from the ICON database into the Netcool enrichment pipeline.

●Worked in UNIX server environment, using tools such as WinSCP, PuTTY, MT PuTTY and source like ICON db for deployment, monitoring and troubleshooting of batch and even-driven processes.

●Enhanced and fixed topology loader components to ensure accurate ingestion and normalization of network topology data.

●Updated and tuned correlation engine rules to improve alarm enrichment, reduce noise and support reliable BGW provisioning and fault management.

Project Title: Verizon EZStatus

Duration: From May 2020 to June 2020

The project was getting Telecom Ordering data from various telecom data, voice etc. product’s ordering systems sources (majority in oracle db). Then it provides tracking, status of the ordering system till the order is activated.

Roles and Responsibilities:

●Maintenance and debugging of Procedure, Packages for trouble tickets.

●Batch loading of the flat files, UNIX shell script debugging for loading, alert of the flat files, XML.

Project Title: Verizon UCP (User Customer Profiling)

Duration: From August 2019 to April 2020

The project was about data aggregation from various telecom sources, mapping into a unified views of data for the clients showing subscribed products details.

Roles and Responsibilities:

●Integrated data from multiple telecom data sources and implemented data virtualization using K2View including data modeling, mapping and deployment. The input sources were Oracle DB, Cassandra, APIs.

The K2View platform allowed real-time, unified views of data per business entity across many systems without physically moving all the data.

Screentech Designs, Columbus, IN

Freelance projects, Oracle Apex project https://github.com/amitms/load_csv

2018 Aug to 2018 Sep

Cotiviti Technology (formerly Verisk Health)

2011 Mar to 2017 Aug

Role: Senior Software Engineer (Database developer)

Project Titles: Medical Intelligence (MI), Enterprise Intelligence (EI)

This project was about Data Warehousing from various US healthcare Providers via broker companies and processing those data to provide a Medical Intelligence application to the client.

Roles and Responsibilities:

●Designed and maintained enterprise data warehouse solutions supporting healthcare analytics for Verisk Health flagship platforms:

●1. Medical Intelligence (MI). Medical intelligence (oracle platform)

●2. Enterprise Intelligence (Microsoft platform used MS SQL, SSAS)

●Built end-to-end ETL pipelines for data ingestion, transformation, normalization and integration to a Common Data Format (CDF).

●Developed dimensional schema designs (start/snowflake), performed data modeling, and implemented multidimensional OLAP cubes (SSAS) to support business intelligence and performance reporting.

●Developed and optimized SQL queries and MDX for data validation, reconciliation, analytics and reporting.

●Implemented data quality (QC) checks, data profiling and QA processes to ensure accuracy, completeness and consistency across healthcare datasets.and optimized complex SQL queries, packages for data validation, reconciliation across ingestion and transformation layers.

●Tracked and resolved data pipeline and reporting issues using JIRA.

●Used Tortoise Subversion (SVN) to maintain version control and source code management.

Other projects:

https://amitms.github.io/Portfolio-Site/

Source Codes: https://github.com/amitms

Certifications:

IBM Data Engineering Professional Certificate Credential ID: 0A07H5CSCPJM

Link: https://coursera.org/share/1ca9d6ebed7a9d79ec0bfa03051d80d1

Relational Database Administration (DBA) Credential ID: BNWWPG1AP4Q2

Hands-on introduction to Linux Commands and Shell Scripting 8C834U3AGV65

Databases and SQL for Data Science and Python NPTQUQ223C4F

Python for Data Science, AI & Development SVQP8BAWNQD1

Python Project for Data Engineering CGTF6CLTRD0A

Relational Databases (RDBMS) 0WI9AFQ20W7Y

Data Warehouse Fundamentals 3FKRL774BPQW

NoSQL Databases 0LGPRWTK2YM8

Big Data with Spark and Hadoop HUQNO0RXY41Q

ETL and Data Pipelines with Shell, Airflow and Kafka 5PL3SN1NT9HN

Machine Learning with Apache Spark O1R2WB95NKR3

Generative AI: Elevate your Data Engineering Career CPOW34WMZF8N

BI Dashboards with IBM Cognos Analytics and Google Looker DTKH9PBQED7W

SAFe 5.0 Practitioner certified

scaledagileCERTIFICATE88579900-336-***-****

compTIA Network + course from NexGen

https://user-resources.nexgent.com/28125/achievements/certificates/257.png

Front End Web development Nanodegree program (from Udacity sponsored by google)

https://graduation.udacity.com/confirm/CACQKQFN

The Data Scientist’s Toolbox (Johns Hopkins University and Coursera)

https://www.coursera.org/account/accomplishments/certificate/5ZT43GYCCKD4

Academics:

Bachelor in Electronics and Electrical Engineering

Kathmandu University, Dhulikhel, Kavre, Nepal. Score: CGPA 3.10/4 scale

References:

●Reference documents: https://drive.google.com/drive/folders/1KMPGXrjP-oHEu6Wm3sTLL0aqiCRTcNoK

Contact this candidate