Bayt.com

Submitting more applications increases your chances of landing a job.

Here’s how busy the average job seeker was last month:

Opportunities viewed

Applications submitted

Keep exploring and applying to maximize your chances!

Looking for employers with a proven track record of hiring women?

Click here to explore opportunities now!
We Value Your Feedback

You are invited to participate in a survey designed to help researchers understand how best to match workers to the types of jobs they are searching for

Would You Be Likely to Participate?

If selected, we will contact you via email with further instructions and details about your participation.

You will receive a $7 payout for answering the survey.


User unblocked successfully
Shamim Siddique, Senior ETL consultant

Shamim Siddique

Senior ETL consultant·Saudi Business Machine

Saudi Arabia

Master's degree, Computer Science

Work experience

Total years of experience: 20 years, 9 months

Senior ETL consultant

March 2015 - Present

Saudi Business Machine

Riyadh, Saudi Arabia

March 2015 - Present

version 9.1, Netezza, SQL Server, SQL, TSQL, UNIX,

A leading university in Saudi is building Datawarehouse from different domain like student, Employee, Library, Accreditation, and Research


•I am involved here to interact with business and Solution Architect to build a road map for ETL
•I am involved in source system analysis and data profiling
•I assists data modeler in designing dimensional model as well as in relational model
• I am also involved in Estimation, Resource management, project planning including road map.
•I do the ETL design, development and testing
•Mentoring the junior team member and reviewing their activities.
•Guiding the project in different SDLC phase
Company industry:
IT Services
Job role:
Information Technology

ETL Team Lead and Lead Developer

November 2013 - January 2015

Cognizant Technology Solutions

London, United Kingdom

November 2013 - January 2015

Informatica 9.5, IBM Infosphere Datastage 8, Ascential Datasatge 7.5.2, AS400-Iseries, DB2, Oracle 10g, SQL Server 2012, SQL, PL/SQL, TSQL, UNIX,

Ace planned to migrate from Datastage to Informatica as ETL for all the existing applications
(Payment interface, Open Item, GT billing, UK and Syndicate Subscribe).
It was a complex and large scale prject. .

•I involved in impact analysis (both business and technical) interacting key IT, Business and Architect.
•I Involved in Estimation, Resource management, project planning including road map.
•I was involved in impact analysis (both business and technical) interacting key IT, Business and Architect.
•I was also involved in Estimation, Resource management, project planning including road map.
•I am guiding offshore in their daily activities in creation of mapping, development, Unit testing and all the other SDLC phase.
•I was Involved in the preparation of Reverse Engineering document, Technical design document etc.
•As a Team lead managed team of 10 offshore members.
•We have successfully migrated three applications on Informatica with better performance.
•Other applications is in UAT.
Company industry:
IT Services
Job role:
Information Technology

Project Profile

August 2005 - January 2015

Cognizant Technology Solutions

United Kingdom

August 2005 - January 2015

Company industry:
IT Services
Job role:
Other

ET Lead

August 2005 - January 2015

Cognizant Technology Solutions

United Kingdom

August 2005 - January 2015

• Experienced of leading wide variety of projects like Development, Enhancement and Production Support
• Successfully managed complex projects with global implementation, and rapidly evolving requirements.
• Experience in Proposal building, Requirement gathering, Impact/Risk analysis, Estimation, Resource planning, Project road map
• More than 7 years of experience in leading ETL project(Datastage and Informatica)
• Highly effective serving as facilitator between technical teams including Architect, and business
Unit decision makers for requirements development, coding, testing, integration planning, and systems roll-out
• Wide experience of client(Both Business and IT) interaction
• Effective communication skills and record for coordination between globally located teams.
• Project delivery under stringent timelines and high pressure.
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development, System Testing Support, User Acceptance Testing Support, Implementation and Warranty Support
• Experienced in leading 9 to10 team member
• Experience on Migration project
• Since sizeable portion of my experience is at onsite location which helped me to acquired excellent client management ability and great offshore coordination ability.
• Adept in providing Technical Support to key business Applications /solutions
• Excellent communication and presentation skills
• Since in most of the project, Datastage was involved. It helped me to gain the expertise in Datastage
• Expert in working with Data Stage Manager, Designer, Administrator, and Director.
• Expert in designing Parallel/Server Datastage jobs using various stages
• Experienced in integration of various data sources (DB2, AS400-Iseries, Oracle, SQL Server, Netezza etc.)
• Proven track record in troubleshooting of Data Stage jobs and addressing production issues
• Experienced in both ETL and Reporting Project




Technical Experience Summary

ETL : IBM Infosphere Datastage - version 9.1, version 8.,
Ascential Datasatge 7.5.2 Enterprise edition Parallel and Server, Version Control
Informatica Power Centre 9.5

Database : Oracle 9i 10g, 11g, DB2, Netezza, SQL Server 2010, SQ Server 2012

Programming Languages: SQL, Oracle PL/SQL, UNIX, TSQL

BI : Microstrategy 8, Cognos 7
Operating System: Windows XP, UNIX, AIX
Tools: Toad, WInsql
Company industry:
IT Services
Job role:
Information Technology

ETL Lead and Lead Developer

January 2009 - December 2013

GPI CFX - ACE Europe

United Kingdom

January 2009 - December 2013

Project Specific Skills: Datastage 8.0, 7.5, DB2, SQL Server, AS400-Iseries, SQL, TSQL, UNIX


Main objective of the project was to be built Claim processing system for ASPAC country. Direct Credit Receipt Processing system was also built. It involved several source/target systems like AS400-Iseries, Db2, flat files. It generates several reports in html format. Since it's payment processing system of ACE. So it was very high visibility project

•It comprises several projects ( From complex to medium) and different CR.
•I was involved in feasibility study, Proposal building
•On approval l interacted with key business to do requirement analysis and helped BA in BRD development.
•Involved in estimation process and produced the estimation document
•Involved the building project road map, Projects management and resource planning
•Involved in the preparation for high level and low level design
•Involved in preparation of Technical design document.
•As ETL team lead managed team of 4 to 5 members of offshore
•Worked as onsite coordinator as well.
•As Lead developer developed complex Datastage code using version 8.0, 7.5.2
•Used complex transformation logic to produced Complex format Citibank Payment file and same way also used complex transformation logic to read Citibank statement file.
•Coded several Datastage routines in Basic as well Unix script
•Coded several sequences using different activity stages
•Written several complex SQL queries
•Involved in Code review
•Involved in all the SDLC.
•Involved in preparation of implementation document
•Involved in warranty
Job role:
Other

Team Lead & Lead Developer

January 2009 - December 2013

ACE Europe

United Kingdom

January 2009 - December 2013

Project Specific Skills: Datastage 8, Datastage 7.5, Version Control, SQL Server, Db2, Oracle, SQL, UNIX, Iseries (Genius)

This project involves in maintenance activity for different application like, GPI, Mercury, Subscribe, CFX, and Open Item. Production incident required a strict time line to fix according to their severity.
•Incident analysis
•Fixing the incident on very strict time line, preventive maintenance
•Coordination with offshore on low priority incident. Implementation in production


ACG to Mercury
Company industry:
Insurance & TPA
Job role:
Information Technology

Team Lead and ETL lead developer

January 2013 - November 2013

GT Billing

United Kingdom

January 2013 - November 2013

Project Specific Skills: Datastage 8, SQL Server, TSQL, UNIX

The Global treaty Billing is a web based application which caters Ace Tempest Re and AIOC Business unit's GT team to generate the Bills and statements for its corresponding Reinsurers and broker participants.
The Primary data for generating the statements will be from Genius Global treaty instance and Premium Claims Data warehouse (PCW).The Broker and Reinsurer information along with the cash calls and open item transactions will be fetched from Genius. The reserve and the transaction details will be fetched from PCW. The data from PCW and Genius will be extracted and loaded into flat files and further to the GT billing database in three layer i.e. staging, reference, transaction and reporting layer through Datastage
.
•Involved in the preparation for high level and low level design
•Worked in Onsite-Offshore model son involved in Onsite Coordination
•Project management, status report preparation.
•AS Lead Developer at Client Location involved in Datastage code developement
•Requirement Analysis
•Designing Datastage jobs.
•Writing TSQL code in DB2
•Unix Shell Scripting,
•Involved in all the SDLC like Requirement Analysis, Design, Development, Unit Testing, System testing Support, UAT Support
Job role:
Other

ETL Team Lead & Lead Developer

November 2011 - October 2012

ACE Europe

November 2011 - October 2012

Project Specific Skills: Datastage 8, Db2, SQL, UNIX, Iseries (Genius
Company industry:
Insurance & TPA
Job role:
Other

ETL Team Lead & Lead Developer

July 2010 - August 2012

Open Item - ACE Europe

United Kingdom

July 2010 - August 2012

Project Specific Skills: Datastage 7.5, Oracle, DB2 SQL, UNIX, Iseries (Genius)

There was a need for Global system which give and overview of Open/Match Item. It means How Ace owns against a particular Policy on daily basis. Few countries use Genius and few Meriden. Both are an Iseries application. Datastage pulls the Data from Genius/Meridian and load into Staging Database Oracle 11g
It involved development from scratch to several enhancements
.
•I was involved in feasibility study, Proposal building
•On approval l interacted with key business to do requirement analysis and helped BA in BRD development.
•Involved in estimation process and produced the estimation document
•Involved the building project road map, Projects management and resource planning
•Involved in the preparation for high level and low level design
•Involved in preparation of Technical design document.
•As ETL team lead managed team of 3 members of offshore
•Worked as onsite coordinator as well.
•As Lead developer developed complex Datastage code using version 7.5.2 and SQL query on AS400-Iseries Db2 to extract and transform the data from AS400 and finaly load them in Oracle as target
•Coded several Unix script
•Coded several sequences using different activity stages
•Written several complex SQL queries
•Involved in Code review
•Involved in all the SDLC.
•Involved in preparation of implementation document
•Involved in warranty
Job role:
Other

ETL Team Lead & Lead Developer

January 2011 - November 2011

ACE

United Kingdom

January 2011 - November 2011

Project Specific Skills: Datastage 7.5, Datastage 8, Db2, SQL, UNIX, Iseries (Genius)

Ace is using to three big applications for their payment process. For claim payment process they used GPI and CFX and for non claim payment process they use Mercury. All are built on Datastage 7.5. As part of the upgrade GPI and Mercury was migrated from Datastage 7.5 to Datastage 8.0.

•Involved in the preparation for high level and low level design
•Worked in Onsite-Offshore model son involved in Onsite Coordination
•As a team lead reviewed the code developed by other developers
•Lead Developer at Client Location.
•Impact Analysis
•Code migration.




Sybase to SQL Server
Company industry:
Insurance & TPA
Job role:
Other

ETL Team Lead & Lead Developer

November 2010 - April 2011

ACE Europe

United Kingdom

November 2010 - April 2011

Project Specific Skills: Datastage 8, SQL Server, SQL, UNIX, Iseries( Genius )
Source system was migrated from Sybase to SQL server for Premiums Claims Warehouse (PCW).I was involved in all SDLC phase.

Migration of legacy policy management system
Company industry:
Insurance & TPA
Job role:
Other

Developer/Module Lead

October 2009 - December 2010

Industry

India

October 2009 - December 2010

Project Specific Skills: Datastage 7.5, Verrsion Control, Db2, SQL, Unix, AS400- Iseries( Genius )

I was involved from Analysis phase till implementation, warranty in Migration of legacy policy management system (Meridian) to more interactive System (GPI - GENIUS - FME) for claim processing. I was involved in development as well as in leading offshore team. I was involved in coding complex Datastage jobs using various systems i.e AS400-Iseriers, Db2, Flat files. I was also involved in reviewing offshore code
Company industry:
Industrial Production
Job role:
Information Technology

Developer

April 2008 - December 2008

Industry

United States

April 2008 - December 2008

Project Specific Skills: PL/SQL Stored Procedure, DB2, Oracle, Sql Server

The objective of this project was to utilize the data provided by International Retail to develop a reporting application providing customer, account and product level information on key metrics and business drivers, including Behavior Based Segmentation, Product per Customer and Marketing Campaign analytics.
I was involved in high level and low level design, designing the Algorithm to extract data from different Data Source, Designing the Datamart, Development of PL/SQL Stored Procedure for cleansing and Transformation and load them in staging table in DB2.

Out of Stock
Company industry:
Industrial Production
Job role:
Information Technology

ETL Developer

December 2006 - March 2008

AC Nielsen

India

December 2006 - March 2008

Project Specific Skills: DataStage 7.5.2 Enterprise Edition, Oracle, NETEZZA

I was Involved as Datastage developer in Designing, Development, running and debugging DataStage 7.5.2 Parallel Jobs, extracting data from disparate sources (viz. Mainframe Complex file stages, Text file, NETEZZA data source, Oracle data sources). to build a syndicated Out of Stock (OOS) reporting database in NETEZZA so that the facts and capabilities can be integrated into the current store level competencies so as to enhance the current offering and supersede the competition.
Company industry:
Marketing
Job role:
Information Technology

Developer

May 2006 - November 2006

Industry

India

May 2006 - November 2006

Involved as developer of Dash Board report which comprises various canned reports, as well as adhoc reports, which was done in 8 phase by using MicroStrategy
Project Specific Skills: MicroStrategy, Oracle 9i, SQL
Company industry:
Industrial Production
Job role:
Information Technology

Developer

August 2005 - April 2006

NDB ORBIT

August 2005 - April 2006

Involved as developer to generate report using Db2 stored procedure and Cognos
Project Specific Skills: Cognos 7, DB2, Pl/SQL, Stored procedure











- 6 -
Job role:
Information Technology

Datastage

-

Cognizant Technology Solutions

United Kingdom

-

Company industry:
IT Services
Job role:
Information Technology

Education

University of HyderabadUniversity of Hyderabad

July 2005

July 2005

Master's degree, Computer Science

India

GPA (percentage): 78%

GPA (percentage): 78%

Master of Computer Application (2002-2005) from University of Hyderabad (HCU) CGPA: 7.81/10 University of Hyderabad:  University of Hyderabad is the No. 1 University in the entire system of higher education in the sciences in India, according to a recent study by the Department of Scientific and Industrial Research (DSIR).  No 1 University in India by SCOPUS(http://articles.timesofindia.indiatimes.com/2009-09-30/hyderabad/28068705_1_scopus-varsities-uoh)  University of Hyderabad has been accredited by the National Assessment and Accreditation Council (NAAC) with a rating of five stars.  University of Hyderabad has been given the status of “University with Potential for Excellence” by the UGC

University of Hyderabad

January 2005

January 2005

Master's degree, Computer Scince

India

GPA (percentage): 78%

GPA (percentage): 78%

(

Skills

Netezza
Expert
Netezza
Expert
Informatica
Expert
Informatica
Expert
Unix
Expert
Unix
Expert
SQL
Expert
SQL
Expert
Datastage
Expert
Datastage
Expert
AS/400
Expert
AS/400
Expert
DATABASE ADMINISTRATION
Expert
DATABASE ADMINISTRATION
Expert
DATASTAGE
Expert
DATASTAGE
Expert
DB 2
Expert
DB 2
Expert
DESIGN
Expert
DESIGN
Expert
ETL
Expert
ETL
Expert
IBM DB/2
Expert
IBM DB/2
Expert
LEADERSHIP
Expert
LEADERSHIP
Expert
ORACLE
Expert
ORACLE
Expert
ORACLE DEVELOPER 2000
Expert
ORACLE DEVELOPER 2000
Expert
Netezza
Expert
Netezza
Expert
Informatica
Expert
Informatica
Expert
Unix
Expert
Unix
Expert
SQL
Expert
SQL
Expert
Datastage
Expert
Datastage
Expert

Languages

English
Expert
Urdu
Expert
Hindi
Expert