Sachin S.

Architect

New Delhi , India

Experience: 15 Years

Sachin

New Delhi , India

Architect

61120.2 USD / Year

Notice Period: Days

15 Years

Now you can Instantly Chat with Sachin!

Chat Now

About Me

Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Mining, DataIntegration and Metadata Management Services.Expert level experience in Oracle SQL, PL/SQL (Packages, Stored Procedures, Functions, Triggers, Cursors,Co...

Skills

Positions

Director of Engineering

Managers

Software Engineer

Chief Engineer

CIO-Chief Information Officer

Portfolio Projects

Description

Working with Oneshield India Pvt. Ltd. on Insurance billing product & business intelligence.
Responsible for managing gaps implementation & defects fixing.
Managing the Oracle data warehouse & Pentaho BI reporting modules.
Responsible for data modeling. Creating data flow diagrams, ER diagrams for all new features.
Creating PL/SQL packages, procedures, functions including tables, Materialized views, job creation, and shell scripting.
Also, playing as a scrum master role and responsible for managing all the business/technical user stories.
Writing technical/functional documents in Confluence.

Show More Show Less

Description

Worked with Synapse Group Inc. (A division of Time Inc.) on data warehousing, data analysis & data integration projects. Also, working on data science projects like probabilistic matching for MDM, Automated Data Quality & Sales data analysis using machine learning algorithms.
Managing the database team at offshore location which is responsible for handling large data warehouses, DataMart creation & business reporting. Also working as an individual contributor.
Responsible for data modeling. Creating data flow diagrams, ER, Sequence, State diagrams etc.
Responsible for creating Pentaho jobs & transformations to load data into AWS Redshift database.
Creating PL/SQL packages, procedures, functions including tables, Materialized views, jobs creation and shell scripting. Also managing the Redshift databases used for data warehousing.
Writing complex SQL queries for data retrieval.
Playing a scrum master role and responsible for managing all the business/technical user stories.
Writing technical documents & logs.

Show More Show Less

Description

Worked with GOOD technologies & BoxTone Inc. (acquired by BlackBerry Limited) on Mobile Device Management, Mobile Service Management. Responsible for creating design documents and creating complex functionalities related to mobile devices tracking and management using Oracle PL/SQL, Oracle Apex, Jreport and other technologies. Built several components like, Apple, Blackberry, ActiveSync devices trackers, mail flow tracking, problem detection at device/carrier/server levels and data warehousing for complex data reporting and dashboards.
Handling large database team at offshore location and also worked as an individual contributor.
Responsible for data modeling, data analysis and data mining and PL/SQL programming including creation of tables, views, indexes, packages, procedures, functions triggers, DB links, materialized views etc.
Creating applications in Oracle Apex. Also, migrating old applications to the new versions.
Writing complex SQL queries for data retrieval.
Working with Oracle support and other vendors.
Handling database administration activities including Oracle software cloning, DB creation/Upgrade, Patching, Backup/Restore, tablespace management, memory management, Import, Export, AWR analysis, Tuning, OEM configuration & Oracle Apex & http server installation/configuration.
Designing DFDs, ER diagrams, Sequence, State, Class Diagrams, Pseudo Code, and Descriptions.
Organizing meeting for reviews and team co-ordination.

Show More Show Less

Description

Worked with many US based clients including Atlantic Diving Solutions (ADS), Argus, Camden County, Illinois Department of Transportation (IDOT) on quotation management system for Oracle EBS, EDI (x12 upload) tool, GENIII Inventory system, EMCMS system for Patrol scheduling, EAP-Argus, Umbrella project of Camden Country for security benefits.
Worked on Oracle Apps R12/11i Order Management, AP, AR, INV, CE, OM and PO modules. Also, worked in Business Intelligence tools like Oracle Discoverer and XML/BI Publisher.
Acted as a technical lead for development, customization and information gathering.
Development of SQL queries & PL/SQL packages/procedures and development of forms and Reports in Apex.
Also worked on Oracle forms/reports 6i/10g, XML publisher.
Import/export of the database and database monitoring.
Designing of Apex reports with Scheduling, emails & other complex features.
Directly communicating with the client to handle day to day problems and changes.
SQL & PL/SQL Performance tuning using explain plan, profiler & AWR analysis.

Show More Show Less

Description

Worked in Electricity Billing System, Meter reading management, Energy audit systems, Bill amendment modules.
Designing of billing & meter reading related forms and reports in Oracle forms 6i.
Developing SQL queries & PL/SQL Program units to extract data for business reporting.
Data loading from multiple subsystems in Oracle database using SQL*Loader.

Show More Show Less