Sachin Singh
Verified Expert in Engineering
SQL Developer
Sachin is a SQL developer and database architect with over 17 years of IT experience in business and data analytics, data integration, data modeling, and Oracle PL/SQL development. He's delivered projects in a range of domains, including insurance, mobile device management, digital marketing, logistics, order management, and power. Sachin specializes in database programming, performance tuning, data warehousing, data analytics, and BI reporting.
Portfolio
Experience
Availability
Preferred Environment
Relational Databases, Data Warehousing, BI Reports, PostgreSQL, Pentaho, Redshift, Oracle Application Express (APEX), SQL, PL/SQL, Amazon Web Services (AWS)
The most amazing...
...thing I've developed is the MDM database for a company. The product was in the world's top-5 list and monitored millions of smartphones across the globe.
Work Experience
Architect
OneShield
- Developed the cloud-based (AWS) data warehouse for insurance products (policy, billing, claims) and created BI reports using Pentaho; also, developed new modules for insurance billing products.
- Responsible for managing gap implementations and defect fixes.
- Managing a US-based insurance client and taking care of the new enhancements, implementation, and deployments.
- Created PL/SQL and Java-based solutions for the new policy, billing, and claims-related workflows.
- Wrote technical and functional documents in Confluence.
Senior Solutions Architect
Birlasoft
- Worked with the Synapse Group (a division of Time, Inc.) on data warehousing, data analysis, and data integration projects.
- Oversaw data modeling and the creation of data-flow diagrams and ER diagrams.
- Developed PL/SQL packages, procedures, functions, tables, materialized views, jobs, and shell scripts.
- Created Pentaho jobs and transformations to load data from Oracle and PostgreSQL database to the AWS Redshift database.
- Managed the database team at the offshore location responsible for handling large data warehouses, datamart creation, and business reporting. Also worked as an individual contributor.
- Wrote complex SQL queries for reports and also implemented performance optimization of SQL and PL/SQL code.
Lead Software Engineer
Impetus Technologies
- Worked with GOOD technologies and BoxTone (acquired by BlackBerry Limited) on mobile-device and mobile-service management.
- Led the creation of workflows related to mobile devices tracking using technologies like Java, PL/SQL, and Apex.
- Built components like Apple, Blackberry, Windows device trackers, mail flow trackers, and problem detectors at device/carrier/server levels.
- Responsible for data modeling, data analysis, and data mining, and PL/SQL coding and performance tuning.
- Created reporting applications using Oracle Apex and migrated old applications to the new versions.
- Performed administration activities, i.e., Oracle software cloning, database creation/upgrades, patching, backups/restorations, tablespace and memory management, import/export, AWR analysis, tuning, OEM configuration, and Oracle Apex and HTTP server installations.
- Worked with Oracle support and other vendors for the third-party integrations.
- Managed the database team at an offshore location.
Senior Software Engineer
Heuristics Informatics Pvt
- Worked with many US-based clients like Atlantic Diving Supply Inc., Argus, Camden County, and the Illinois Department of Transportation.
- Contributed to multiple projects like OMS, EDI (x12 upload) tool, GEN3 Inventory system, EMCMS system for patrol schedules, and the umbrella project of Camden Country for security benefits.
- Developed applications in Oracle Apex, PL/SQL packages/procedures, SQL queries for reporting, and customized Oracle forms for the ERP system.
- Implemented SQL and PL/SQL performance tuning using the EXPLAIN PLAN, profiler, and AWR analysis.
- Developed Oracle apps R12/11i order management, AP, AR, INV, CE, OM, and PO modules.
- Contributed to the development of Business Intelligence tools like Oracle Discoverer and XML/BI Publisher.
- Worked on Oracle forms/reports 6i/10g and XML publisher.
Programmer
Reliance Power
- Worked on the electricity billing system, meter reading management, energy audit systems, and bill amendment projects.
- Designed forms and reports in Oracle forms 6i for billing and electricity meter tracking modules.
- Developed SQL queries and PL/SQL packages to extract data for business reporting.
- Created programs to load data from multiple subsystems in the Oracle database using SQL*Loader.
Experience
Oneshield Billing and BI
I was a database architect and worked on writing back-end code for billing workflows. Also, I worked on creating a new BI process for insurance-related reports.
Loyalty Program Management
Mobile Device Management and Mobile Service Management
GENIII ECWCS Order Management System
Quotation Management System and Order Upload Tool
Along with the main application, I created new plugins to parse bulk order files (X12 format) and process the orders in the ERP system.
The solution was developed using Oracle database, Oracle Apex, Oracle 11i/R12, and Linux.
Special Operational Logistics and Visibility Solution (S.O.L.V.S)
https://solvs.adsinc.com/apex/f?p=105I worked as a database developer for this project and created the database (tables, SQL, PL/SQL, package, and so on) and also developed multiple screens on the UI.
Electricity Billing and Energy Audit System
Education
Master's Degree in Computer Applications
Indira Gandhi National Open University - New Delhi, India
Bachelor of Science Degree in Physics, Chemistry, and Biology
CCS University - Uttar Pradesh, India
Certifications
Data Science Specialization
Coursera
Certified Scrum Master
Scrum Alliance
Skills
Languages
SQL, Python, R, Java, JavaScript
Tools
Oracle Application Express (APEX), JReport, Pentaho Data Integration (Kettle), Oracle BI Publisher, Oracle ERP, Oracle Forms, Confluence
Paradigms
ETL, Data Science, Agile
Platforms
Oracle, Pentaho, Oracle Database, Linux, Amazon Web Services (AWS)
Storage
Oracle PL/SQL, Relational Databases, PostgreSQL, Oracle 12c, SQL Loader, PL/SQL, Redshift, Microsoft SQL Server, Database Administration (DBA), SQL Server 2012, MySQL
Other
Data Warehousing, BI Reports, Data Modeling, Pentaho Report Designer, Batch Scripting, Oracle Forms & Reports, SAP Business Object Processing Framework (BOPF), PeopleSoft, Ajax, PostgreSQL 9
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring