Saabir Khan

Saabir Khan

Mentor
5.0
(2 reviews)
US$25.00
For every 15 mins
3
Sessions/Jobs
ABOUT ME
SQL Developer with 10 years of work experience
SQL Developer with 10 years of work experience

I am a SQL Developer, with 10 years’ experience. I have experience working on Analytical functions (LEAD, LAG etc), CTE, complex queries, optimizing queries and writing complex stored procedures.
I've worked on different databases like MySQL, Oracle, MSSQL, and PostgreSQL.

I love data and I'm passionate about SQL. I like to share my SQL experience with anyone who is interested in learning SQL

Hindi, English
Mumbai (+05:30)
Joined July 2019
EXPERTISE
10 years experience | 2 endorsements
My main experience and expertise is in SQL (and Procedural/transact SQL). I've got nearly 10 years of experience in SQL on databases like...
My main experience and expertise is in SQL (and Procedural/transact SQL). I've got nearly 10 years of experience in SQL on databases like SQL Server, MySQL, Oracle, MariaDB.
7 years experience
Apart from SQL, I've also worked extensively on ETL tools like Talend.
Apart from SQL, I've also worked extensively on ETL tools like Talend.
1 year experience
3 years experience
5 years experience
10 years experience
6 years experience

REVIEWS FROM CLIENTS

5.0
(2 reviews)
Harold Moore
Harold Moore
July 2019
Thoughtful, works, quickly and efficently and smart. Very happy to work with him in the future.
EMPLOYMENTS
Senior Technical Lead
Parametric Technology Corporation
2013-05-01-2018-05-01

Talend ETL And SQL Development

Technologies worked on: Talend for Data Integration (Open Source Versions – 5.2, 5.6, 6.1), MySQL...

Talend ETL And SQL Development

Technologies worked on: Talend for Data Integration (Open Source Versions – 5.2, 5.6, 6.1), MySQL 5.6, MariaDB 10.3, MS SQL 2008 R2/2012/2014, PostgreSQL, PERL, QlikSense, Chartio, SSRS

Role: Story Owner/Developer/Lead.

• Creating reports using SQL as per requirements.
• Responsible to create and maintain Talend ETL job
• Unit Testing and Functional Testing
• Co-developed, implemented, and supported the global PTC University service professional (consulting) certification program. Architected and built the associated information management system which services 975 consultants and their management.
• Furthered the development of the Lighthouse applications, including the addition of the student relationship management module.

SQL
MySQL
PostgreSQL
View more
SQL
MySQL
PostgreSQL
Talend
Microsoft SQL Server
View more
Associate
Cognizant Technology Solutions
2012-10-01-2013-04-01

ETL/SQL Development (Telecom )

Technology: Informatica 8.6, Teradata 13, Unix.

Role: Story Owner/Developer/Lead.

Con...

ETL/SQL Development (Telecom )

Technology: Informatica 8.6, Teradata 13, Unix.

Role: Story Owner/Developer/Lead.

Contribution :
• Requirement Analysis
• Development of mapping as per requirements.
• Unit/System Testing.
• Worked as a team member and independently.
• Defect fixing and verification.

SQL
ETL
Teradata
View more
SQL
ETL
Teradata
View more
Module Lead
Persistent Systems Limited
2011-01-01-2012-09-01

ETL and SQL Development (Workforce Management System)

Technologies: Oracle 10g, MS SQL, PLSQL, T-SQL, Talend Integration Suite 4...

ETL and SQL Development (Workforce Management System)

Technologies: Oracle 10g, MS SQL, PLSQL, T-SQL, Talend Integration Suite 4.2, SQL Developer.

Role: Story Owner/Developer.

Contribution:
• Developing code in PLSQL and T-SQL.
• Developing Talend jobs for Summary level procedures.
• Developing ETL jobs to implement Symbolic Time Periods.
• Identifying test scenarios and creating Test cases for unit and functional testing.
• Functional Test case execution.

SQL
Oracle
Oracle PL/SQL
View more
SQL
Oracle
Oracle PL/SQL
ETL
Oracle SQL
View more
PROJECTS
Pulse
2018
Project : Pulse System – Talend ETL Development Technology : Talend for Data Integration (Open Source Versions –6.1), MySQL 5.6, MSSQL, ...
Project : Pulse System – Talend ETL Development Technology : Talend for Data Integration (Open Source Versions –6.1), MySQL 5.6, MSSQL, Oracle 10g. Role : Developer. Description : Pulse a proprietary system providing advanced forecasting and financial reporting capabilities. We used Talend DI to pull information from various sources like SFDC, Global services Oracle database. This data is then moved to a staging area where we perform various transformations on the data based on the GS requirements and load the data into our Pulse database. Pulse application then pulls this information from the Pulse database (using SQL). Contribution : • Construct complex SQL queries with analytical functions. • Responsible to create and maintain Talend ETL jobs
SQL
MySQL
Oracle
View more
SQL
MySQL
Oracle
Talend
View more
Lighthouse
2017
Project: Lighthouse System – Talend ETL Development Technology : Talend for Data Integration (Open Source Versions – 5.2, 5.6, 6.1), My...
Project: Lighthouse System – Talend ETL Development Technology : Talend for Data Integration (Open Source Versions – 5.2, 5.6, 6.1), MySQL 5.6, MS SQL 2008 R2, PERL, QlikSense Role : Story Owner/Developer/Lead. Description : This project involved building the Lighthouse database as well as the Lighthosue application to help drive PTC’s vital corporate objectives to have a strong and growing customer education business. This business is known as PTC University. Lighthouse is a proprietary system managing customer training assets and delivery. We developed Lighthouse to be a single repository of all PTC university applications. To achieve this goal, we use Talend DI tool to pull in information from various sources like Oracle BI/Financials databases, Google Analytics. Lighthouse is a reporting application which allows improvement of information and process management within PTC univserity. As such, most of the applications are visible to an audience of PTC employees, partners and are also customer-facing. Contribution : • Creating reports using SQL as per requirements. • Designed and implemented a Google Analytics data collection and reporting program to analyze the 240k monthly visits to PTC University eLearning systems. • Managed the development of the PTC University "Find a Class" application. http://www.ptc.com/go/findaclass • Co-developed, implemented, and supported the global PTC University service professional (consulting) certification program. Architected and built the associated information management system which services 975 consultants and their management. • Furthered the development of the Lighthouse applications, including the addition of the student relationship management module.
SQL
MySQL
ETL
View more
SQL
MySQL
ETL
Talend
Microsoft SQL Server
View more