Summary
Overview
Work History
Education
Skills
Engagement Overview
Timeline
AccountManager

MOHAMMAD SHOAIB INAMDAR

Bukit Jalil

Summary

Total 13 Years of Experience in IT industry on which 8 years in Data warehousing with application development and Implementation of ETL tool Data Stage, Informatica and ODI. Have 7 years of experience in Data warehousing ETL tools (Data Stage), Informatica. Have 2 years of experience in Teradata. Have 1+ years of experience in Reporting Tools. Knowledge of Hadoop/Impala/Hive/Airflow. Knowledge of Azure data Lake, Azure Delta Lake, Azure SQL Database, Data bricks, Azure Data factory, Azure Data Lake storage. Solid organizational skills and focus on accuracy and attention to detail. Excellent analytical, problem solving and troubleshooting abilities. Self-motivated with the ability to work both independently and in a team environment. Providing accurate and timely estimates for tasks. Provide support and leadership in critical production support issue resolution. Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan. Worked with team to achieve timely resolution of all production issues meeting or exceeding Service Level Agreements. Conducted code review to ensure the work delivered by the team is of high-quality standards. Ability on technically managing the medium to large applications with complete technical ownership. Experienced in handle the design, architecture and implementation. Experienced in performance management of large and complex applications. Strong analytical and problem-solving abilities. Good interpersonal and communication skills and Experience working with all levels of business. Ability to handle complex large applications technically. Establish technical quality processes, templates, checklist for application and ensure delivery with respect to the same. Enhance the quality of deliverables. Experience in producing technical documentation. Provided technical support to the development team. Overall Infosphere DataStage (Developer) experience: 5 years. Experience in Installing, Configuring, Updating and Administering DataStage. End to End IBM InfoSphere Information server suite installation. Understanding the business functionality & Analysis of business requirements. Converted requirement specifications into detailed design and implementation. Design and developed ETL jobs using various stages in server and parallel mode. Extracting data from sources like oracle, Teradata and flat files and transforming them using business logic and loading the data to the Data warehouse. Worked on Slowly Changing Dimensions. Production support, implementation, defect fixing, enhancements activities and release. Worked extensively on different types of stages like CFF stage, Aggregator, Change capture, Copy, Funnel, Join, Lookup, Merge, Remove duplicates, sort, Transformer. Worked on several Development/ Debug stages. Involved in Unit Testing, performance Tuning, support and implementation. Installed IBM InfoSphere Information Server 9.1 on windows 2008 server. Efficient is using Work Load Management server (WLM) and its best practices. Resolved complicated code issues for development team. Granting appropriate privileges to users in DataStage. Established rsh setup by co-coordinating with UNIX admin. Resolved Ssh and rsh connectivity (secondary node for effective communication). Migrated of DataStage components from Development server to QA and Production servers. Creation of new projects and roles setup. Expertise architecting data integration solutions. Worked with development teams, DBA's, Unix admin, network, storage and other technology teams to resolve performance issues with ETL code or database loads.

To obtain a demanding and challenging opportunity that will allow me to leverage my technical skill set in conjunction with my proven leadership record to deliver successful Implementations of technology.

Overview

13
13
years of professional experience

Work History

Senior ETL Consultant

HTC Global Services
07.2023 - Current
  • Given responsibility to perform DataStage Tech-refresh from IIS 11.7 to 11.7.1.4 and configure the projects
  • Performed Installing, Configuring, Updating and Administering DataStage
  • End to End IBM InfoSphere Information server suite installation
  • Configured 3 projects (RDM/MEP/BASEL) and around 3000 jobs compiled and tested successfully
  • Prepared unit test cases and testing
  • Develop different data transfer mechanism for various data sources to load into the staging server
  • Created a ETL Data Mapping Sheet for multiple sources to staging tables comprising of business and validation rules
  • Responsible to provide results users in UAT environment based on their request
  • Responsible to schedule jobs in Zena scheduler
  • Review ETL Design and Code and recommended changes if any
  • Worked on BAU task such as data quality and data validation issues.

ETL Developer

Encora Technology
07.2021 - 07.2023
  • Understanding the existing project requirement (on urgency) and the bridge the gaps towards the workable solution
  • Prepare and delivered detail technical design (DTD) document comprising of Architecture, Dimensional Model, Report and Server Specification and Operational Model
  • Develop different data transfer mechanism for various data sources to load into the staging server
  • Created a ETL Data Mapping Sheet for multiple sources to staging tables comprising of business and validation rules
  • Review ETL Design and Code and recommended changes if any
  • Worked on BAU task such as data quality and data validation issues.

Senior Technical Specialist

IBM Malaysia
09.2013 - 05.2021
  • Understanding the existing project requirement (on urgency) and the bridge the gaps towards the workable solution
  • Prepare and delivered detail technical design (DTD) document comprising of Architecture, Dimensional Model, Report and Server Specification and Operational Model
  • Extensively involved in gathering requirements from internal users to validate and cross check the reporting requirement based on the complexity and priority to architect the ETL process
  • Created the Dimensional Data Model (3 different layers) Using IBM Cognos FM to cater the report requirements
  • Develop different data transfer mechanism for various data sources to load into the staging server
  • Created a ETL Data Mapping Sheet for multiple sources to staging tables comprising of business and validation rules
  • Review ETL Design and Code and recommended changes if any
  • Design and document the persistent layer (DB) for the staging server including the sizing for future growth.

Software Engineer

Tentacle Technology
08.2011 - 09.2013
  • Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.

Education

Bachelor of Science - Computer Science

V.T.U University (BLDEA’s College Bijapur Karnataka)
Vijayapura, Karnataka India
02.2008

Skills

  • Azure Data Lake
  • Azure Data Factory
  • Azure Databricks
  • Azure SQL database
  • Python
  • Spark SQL
  • Hadoop
  • Hive
  • HDFS
  • Impala
  • Airflow
  • IBM Data Stage 11714
  • Informatica 964
  • ODI 12c
  • Data Visualization
  • Tableau
  • Teradata
  • DB2
  • MS SQL Server
  • Oracle
  • Netezza
  • UNIX
  • Windows 10
  • Windows 7
  • Friendly, Positive Attitude
  • Teamwork and Collaboration
  • Customer Service

Engagement Overview

  • Project #1, AmBank Malaysia, 07/23 - Present, Datastage 11.7.1.4, Netezza(NPS), Windows 10, Unix, The term Advanced IRB or A-IRB is an abbreviation of advanced internal ratings-based approach and it refers to a set of credit risk measurement techniques proposed under MEP and Basel II capital adequacy rules for banking institutions., Given responsibility to perform DataStage Tech-refresh from IIS 11.7 to 11.7.1.4 and configure the projects. Performed Installing, Configuring, Updating and Administering DataStage. End to End IBM InfoSphere Information server suite installation. Configured 3 projects (RDM/MEP/BASEL) and around 3000 jobs compiled and tested successfully. Prepared unit test cases and testing. Develop different data transfer mechanism for various data sources to load into the staging server. Created a ETL Data Mapping Sheet for multiple sources to staging tables comprising of business and validation rules. Responsible to provide results users in UAT environment based on their request. Responsible to schedule jobs in Zena scheduler. Review ETL Design and Code and recommended changes if any. Worked on BAU task such as data quality and data validation issues.
  • Project #2, MayBank Malaysia, 07/21 - Present, Informitca 9.6.4, ODI 12c, Teradata, Hadoop, Windows 10, Unix, The RSME Digital Loan is responsible for the Development of advanced analytics/machine learning models targeting Existing to Bank(ETB) and New to Bank(NTB) customers in business. It require actual real data to better understand the Retail SME (RSME) customers and business in order to formulate the rules and machine learning algorithms for RSME., Understanding the existing project requirement (on urgency) and the bridge the gaps towards the workable solution. Prepare and delivered detail technical design (DTD) document comprising of Architecture, Dimensional Model, Report and Server Specification and Operational Model. Develop different data transfer mechanism for various data sources to load into the staging server. Created a ETL Data Mapping Sheet for multiple sources to staging tables comprising of business and validation rules. Review ETL Design and Code and recommended changes if any. Worked on BAU task such as data quality and data validation issues.
  • Project #3, IBM Malaysia, 05/18 - 05/21, Data Stage 8.7, DB2, Windows 10, Linux Red hat, The Workforce Management Analyst is responsible for the daily efforts to provide a great customer and employee experience by effectively delivering real-time (intra-day) management with the purpose of optimizing resources to achieve business objectives. Key functional responsibility includes the ability to demonstrate a strong understanding of how planning/forecasting staffing requirements translate to the creation of optimal schedules and real-time (intra-day) management to support multi-department contact center operations. The ability to create forecasting and scheduling to that forecast is crucial. This position requires some evening and weekend availability as business needs arise., Understanding the existing project requirement (on urgency) and the bridge the gaps towards the workable solution. Prepare and delivered detail technical design (DTD) document comprising of Architecture, Dimensional Model, Report and Server Specification and Operational Model. Extensively involved in gathering requirements from internal users to validate and cross check the reporting requirement based on the complexity and priority to architect the ETL process. Created the Dimensional Data Model (3 different layers) Using IBM Cognos FM to cater the report requirements. Develop different data transfer mechanism for various data sources to load into the staging server. Created a ETL Data Mapping Sheet for multiple sources to staging tables comprising of business and validation rules. Review ETL Design and Code and recommended changes if any. Design and document the persistent layer (DB) for the staging server including the sizing for future growth.
  • Project #4, IBM Malaysia, 04/17 - 04/18, Informatica 9.6.4, Oracle 11g, windows 7, Linux Red hat, Customer portal is online portal. Every policy holder has access to this portal where he can check his status of policies. Have up-to-date info regarding each policy such as person covered, nominees, payer, agents etc. Here he can also check his funds respective to each policy. He is able pay instalment and check due payments., Responsibilities (Senior Consultant). Entire project was handled by me. Involved in the design of CWP architecture, code reviews of DataStage jobs and implemented best practices in DataStage jobs. Designed the DataStage jobs, job sequences and Shared Containers to implement the business requirements and design specifications. Worked as DataStage Administrator, defined projects, environment variables, user groups and privileges and set up different environments (Dev/QA/Prod). Created master controlling sequencer jobs using the Data Stage Job Sequencer. Expertise in working with various operational sources like Oracle, Flat files into a staging area. Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, wait for File activities to control and execute the DataStage Parallel jobs. Developed functional specifications for data Extraction, transformation and load processes for implementation. Designed and Developed UNIX shell Scripts for file validation and scheduling Data Stage jobs Developed DataStage Jobs, define job parameters. Extensively used the CDC (Change Data Capture) stage to implement the slowly changing Dimensional and Fact tables. Used stages like Transformer, sequential, Aggregator, Data Set, File Set, Remove Duplicates, Sort, Join, Merge, Lookup, Funnel, Copy, Modify, Filter, Change Data Capture, Surrogate Key, External Source, External Target, Compare and Schedule jobs through UNIX shell scripts. Performed debugging, troubleshooting, monitoring and performance tuning using DataStage. Used different Parallel Extender Partitioning techniques in the stages to facilitate the best parallelism in the Parallel Extender jobs. Modified Configuration file according to space constraints. Writes technical specifications document and design process diagrams. Extensively used Restart Ability Techniques in the job sequencers. Provided Standard Documentation, Best practices, Common ETL Project Templates
  • Project #5, IBM Malaysia, 09/11 - 04/17, Windows Xp, Windows 7, This project was involved in making the business applications of the organization to MSI packages ready for deployment with the clients packaging standards. The applications were first being reviewed on the SOE client image builds provided. Applications need to function as per the client requirements before and after packaging. Later on the applications were reviewed for Quality process as per the client standards and functionality testing was performed., Responsibilities (Senior Consultant). Entire project was handled by me. Application review and analysis. Technical assistance to the team, wherever necessary helping the team to resolve the technical issues to speed up the delivery. Involved in shared delivery model, repackaging with different client standards. Re-packaging the application according to the standards set by the customer. Performing the quality analysis of the application according to the standards set by the customer and Microsoft. Troubleshooting the MSI installation using tools like WUtilLog, Filemon, Regmon, and Procmon. Creating custom actions for MSI installation according to the client standards. Packages deployed using SCCM2012 tool.

Timeline

Senior ETL Consultant

HTC Global Services
07.2023 - Current

ETL Developer

Encora Technology
07.2021 - 07.2023

Senior Technical Specialist

IBM Malaysia
09.2013 - 05.2021

Software Engineer

Tentacle Technology
08.2011 - 09.2013

Bachelor of Science - Computer Science

V.T.U University (BLDEA’s College Bijapur Karnataka)
MOHAMMAD SHOAIB INAMDAR