Saabir Khan

 Objectives Seeking assignments in Talend/ETL/SQL development. Experience Worked as Executive Development in Bajaj Allianz from May 2007 to Jan 2010. Worked as Module Lead in Persistent Systems Limited from Jan 2011 to Sep 2012. Worked as Associate in Cognizant Technologies Solutions from Oct 2012 to Apr 2013. Worked as Senior Software Specialist in Parametric Technology Corporation from May 2013 to Jun 2015. Worked as Technical Lead in Parametric Technology Corporation from Jun 2015 to Jun 2017 Currently working as Senior Technical Lead in Parametric Technology Corporation from Jun 2017 till date. More than 9 years of Professional work experience. Strengths Equipped with good analytical, problem solving, communications and interpersonal skills with ability to interact with individuals at all levels. Able to work in group as well as independently with minimal supervision. Able to learn new tools quickly. Excellent time management and prioritization of work tasks. Utilization of own initiative to resolve issues. Technical Skills Proficient in working and conceptual knowledge of SQL, PL/SQL and T-SQL. Proficient in writing Packages, Stored Procedures, Functions, Cursors, Views and Database Triggers using SQL and PL/SQL in Oracle and T-SQL. Experience on Data warehousing Projects. Experience in Performance Tuning & Optimization of SQL statements and Procedures using Explain Plan, Use of hints. Experience in Talend integration suite & Talend Open Studio for Data Integration. Experience in QlikSense Cloud. Extensive experience in Advanced SQL (use of Analytical functions). Skill Sets Programming Languages : Oracle SQL, PLSQL, T-SQL. Databases :Oracle, SQL Server, MySQL. ETL Tools:Talend (TIS/TOS), Informatica, OWB. BI Tools :Business Objects, QlikSense Methodology: Agile Scrum Product Developement. Operating Systems: Windows. Professional Experience 1. Project:Lighthouse (ETL/Database/Reports Development) Company: Parametric Technology Corporation Client :PTC University Systems Technology:Talend (TOS 5.3), MySQL 5.6, Oracle 11g, PERL, QlikSense Role:Story Owner/Developer/Lead. Description:Lighthouse is the single repository of all PTC university applications like Precision LMS, Saba, Google Analytics and Oracle financial systems. Contribution: Creating reports as required by the management. Developing jobs to fetch data from various sources. Developing inconsistency reports between various sources. Requirement Analysis Development of jobs as per requirements. Unit/System Testing. Working as a team member and independently. Defect fixing and verification. 2. Project:ETL Development (Telecom ) Company: Cognizant Technologies Solutions Client :KPN Technology:Informatica 8.6, Teradata 13, Unix. Role:Story Owner/Developer/Lead. Description:Closed Loop Feedback - The purpose of CLF project is to support KPN in their ambition to be the best service provider of the Netherlands. This is achieved by asking feedback from customers about the contact the customer had with KPN recently. If this feedback is negative, the specific employee will be coached by his manager to get a better performance. The CLF also measures the performance of the complete chain and the performance of the customer contact. Currently working on other customer benefit modules like Customer Permission Restrictions. Contribution: Requirement Analysis Development of mapping as per requirements. Unit/System Testing. Worked as a team member and independently. Defect fixing and verification. 3. Project:ETL Development (Workforce Management System) Company: Persistent Systems Limited. Technology:Oracle 10g, SQL, PLSQL, T-SQL, Talend Integration Suite, SQL Developer, Informatica PowerCenter (POC), Windows & UNIX. Role:Story Owner/Developer. Description:The project deals with Workforce management system which consists of a central time-keeping application (Workforce Central) and analytics product (Workforce Analytics). The Workforce Central keeps track of the employee time-information and enables managers to review and approve timesheet information for their subordinates. Workforce analytics is the analytics product of workforce management system. Analytics Core is the base element and there are three verticals healthcare, retail and manufacturing. Workforce Central has an application to Captures data from different inputs; some customers have many applications and one database. Workforce Analytics looks at data in relation to various dimensions over a range of various time-periods. It delivers data from the Time Keeper application. It provides information about labor spending, labor distribution, absenteeism and overtimes. The objective of Analytics is to generate strategies for reduction of labor cost or increase in productivity. Analytics product has following components: ETL (Stored procedures, views) which fetches the data from different sources like Time Keeper & Payroll, Analytics Data Mart, and Analytics Manager. Workforce Analytics for HealthCare is a decision support system meant for HC vertical. It supports reporting at summary or employee level. Payroll and volume data are the basic building blocks of it. This data can be loaded into the warehouse through excel files containing macros that load data into staging tables first and then into the data-mart. There is a schema called ETL DB to Load data from Workforce central to Data-mart and ETL DB has Store Procedures, Tables, Staging Tables and Temporary Tables which are used to transfer data from one Database to another. There are several atomic and summary procedures in the ETL schema for loading data from the OLTP into the warehouse. There also exist multiple wrapper procedures that control the flow of the ETL logic. 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. Removal of technical debt from the existing system. Worked as Story Owner in most of stories, ensuring the tasks are completed within the sprint. Responsible to create and maintain ETL processes, mentor other team members. Developed logic for various calculations in Fact tables and Fact to Fact comparisons. Worked with customer to develop and tune the ETL logic. Developed ETL Logic for KPI Fact tables. Ensured the ETL code delivered is running, conforms to specifications and design guidelines. Understanding of upgrade and new customer scenarios and implementing the same. Worked as a team member and independently. Defect fixing and verification. ETL development for predictive analysis. 4. Project:ETL Development and maintenance Company:Bajaj Allianz. Technology:Oracle Warehouse Builder 10g, Toad 9.x, Oracle 10g, SQL, PLSQL. Role:Developer. Description:Oracle Warehouse Builder (OWB) is Oracle’s comprehensive tool for ETL. The Objective of the Project was to use OWB and perform the mappings. The main task was to migrate data from production environment into DWH environment, which included Design, Development, Testing and Deployment of the ETL jobs. Various jobs were created reflecting entire DWH. This project includes modules like Premium, Claim, Policy, Partner, IMD & All other procedures and functions. Includes new development as well as support, maintenance/enhancement of existing applications. Contribution: Worked closely with Project manager to identify and specify complex business requirements and processes. Researched and evaluated alternative solutions and made recommendations. Created workflows within the mapping to migrate data based on the conditions given in the specifications. Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression, look-ups. Construct complex SQL queries with analytical functions. Responsible to create and maintain ETL processes, mentor other team members. Developed Logic in SQL, PL/SQL and ETL mappings. Developed processes to enable movement of ETL processing from production to DWH. Worked with programmers to develop and tune the ETL logic. Ensured the ETL code delivered is running, conforms to specifications and design guidelines. Took Initiative in completing all the ETL jobs, including jobs of other team members. Worked as a team member and independently. 5. Project:OWAZ (IDDN Report Module) Company:Bajaj Allianz. Client :Allianz Russia Technology: Informatica PowerCenter, Toad 9.x, Oracle 10g, SQL, PL/SQL. Role : Developer. Description:OWAZ is the first overseas Client of Bajaj Allianz; this Project involves automating all the processes of insurance for e.g. Policy issuance, Claim registration, Reporting etc. The scenario at the Client side was that there were different types of systems which created a difficult scenario during closure of accounts and the generation of regular reports where there was lot of trouble in integrating reports from various systems and in reconciling data from different systems. Further one of the major problems faced was the modification of the premium figures pertaining to any previous period which affects the entire reporting pertaining to the previous period & the same comes to knowledge much later. Hence a unified IT system was expected which allows all types of customized reports from a single system. Contribution: Created mappings to migrate data based on the conditions given in the specifications. Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression, look-up transformations. Was involved in the IDDN Report module. Responsible to create and maintain ETL processes, mentor other team members. Developed Procedures responsible to load the summary tables. The IDDN Report contains all the details for a given policy. Automated the manual process of loading RI (Reinsurance) Details by creating Oracle SQL scripts, PL/SQL cursors, packages, procedures, functions, tables, indexes, views, and constraints. Achievements Certified as Oracle Certified Associate (OCA) scoring 47/52 in SQL and 63/66 in PL/SQL. Academic Details Bachelor of Engineering in Information Technology from Pune Vidyarthi Griha’s COET of Pune university in the year 2006 scoring 67%. Higher Secondary School Certificates from Poona College of Pune University in the year 2002 scoring 77%. ICSE (10th) from Seventh Day Adventist School in the year 2000 scoring 66%. Personal Details “Male, Single, 32 yrs. old. Can speak, read and write English, Hindi, and Marathi”. Declaration I hereby declare that the information in this resume is authentic and true to the best of my knowledge Place: Pune (Saabir Khan)