Candidates About

 

 

Sheikh, Mohammed Tausif Hussain

 

Summary

·         Over 12+ years of experience in designing and developing data warehouse applications using ETL tools like datastage including working experience with databases like SQL Server, Oracle, Netezza, Teradata and DB2 on Windows/Unix platform.

·         In depth knowledge in designing and enhancing ETL frameworks and ETL solutions.

·         Support and consistent development experience in ETL tools like Datastage and Talend.

·         Comprehensive experience in implementing dimensional model for data warehouse (Fact and Dimensional tables, Star and Snowflake Schema).

·         Have very good understanding of Relational Database Designs.

·         Hands-on experience in Healthcare, Finance, Banking, Manufacturing and Parcel delivery industries.

·         Adept in developing reports using Business Objects XI R3.

·         Extensive expertise in Data Warehousing/ETL programming and processes like data extraction, cleansing, aggregation, transformation and loading.

·         Extensive expertise in integration/Migration of data using datastage.

·         Experienced SQL, PLSQL, TSQL, and Unix Shell scripting.

·         Managing and coordinating onshore and offshore teams.

·         Good working knowledge in all stages of Software Development Life Cycle (SDLC) including Requirement gathering, Analysis, Design, Development, Testing, UAT, Production deployment and Production Support.

·         Exposure to Big Data Hadoop ecosystem Pig, Hive, Flume and Sqoop.

·         Excellent communication and intra personal skills with the ability to lead and work with a team.

·         Extremely articulate and possess ardent desire to learn new things and keep abreast with latest technologies.

 

Technical Skills:

 

ETL Tools                             Datastage Server edition 7.5, Enterprise edition 7.5.x, 8.1.x, 8.5, 8.7, 11.5

                                                 Talend Open Studio 6.4

Reporting Tool                   SAP Business Objects XI R3

Database                              Netezza, Oracle, DB2, MS SQL Server and Teradata.

Other Tools                         TOAD, DB visualizer, Nexus, Query Analyzer, Control-M, Autosys, HP -Open view.

Operating System              AIX-Unix, Linux, and Windows

Languages                           Shell scripting, PL/SQL Store Procedures and Python

 

Employment

Amko Software Solutions                                 Jun-2013 to till date   

Cognizant Technology Solutions:                    Dec-2009 to Jun-2013

HCL Technologies:                                             Jul-2005 to Dec-2009

 

Professional Experience:

Amko Software Solutions, USA

UPS, NJ                                                                                                                                        Jun ’13 – Till date

Senior Datastage Developer/Technical Specialist

 

 

The intent of this project is to consolidate global account receivables and financial collections data residing on

legacy applications, maintained by different business units in to a single application named PPS/GCS with

enhanced capabilities. The application will provide business decision support, enabling business users to query

data across geographic regions, business units and accounts for financial reporting, statistical analysis, trend

analysis and auditing .The old systems will be decommissioned in phases and data redundancy will be eliminated

once the PPS/GCS becomes live thus saving cost to the company.

 

Responsibilities/Experience:

·         Interact with Business users, Project stake holders and External vendors and understand and analyze the Business requirements, perform assessment and propose design solutions.Provide estimates for the design and development of requirements.

·         Design ETL Framework for developing Facts, Dimensions and Bridge tables.

·         Lead development efforts and review/update technical designs, Data Mapping rules and coding standards.

·         Develop datastage jobs and sequences using various stages to extract, transform and load the data in to data mart tables.

·         Analyze the PL SQL Store procedure in PPS/GCS application, replicate or enhance the store procedures into Datastage jobs.

·         Develop SQL scripts to retrofit the data between source system and datamart to facilitate new columns added to datamart and to remove data discrepancies.

·         Develop Linux scripts to execute the datastage jobs through ESP (Scheduling tool in mainframes)

·         Perform Unit and Integration testing and ensure the jobs runs end to end without any issues.

·         Create packages in Infosphere Information server manager to migrate the jobs to Production.

·         Prepare release notes and Conduct release meetings with Production Support Team.

·         Work with business users in new Enhancements/Defect Fixing.

·         Assembly Testing of Modules and support system testing (SIT).

·         Provide on call production support by resolving production issues.

·         Train and mentor team members on datastage tool and PPS/GCS application.

·         Identify and resolve issues due to migration to Datastage 11.5.

·         Performed POC with Talend Open Studio to validate the feasibility of the tool by coding Talend jobs using native components building dimension, facts and audit tables.

 

Environment: IBM Infosphere Datastage 8.7 & 11.5, SQL Server 2012 & 2016 , Linux 3.1.0 .

 

 

Cognizant Technology Solutions, USA

Blue Cross Blue Shield, RI                                                                                                Jun ’12 – Jun ’13

  

Senior Datastage Developer

The objective of this project is to expand BSBSRI’s data warehouse capabilities by building new provider data structures that will establish a BCBSRI’s baseline of provider information and to add additional detailed and derived data elements to the Enterprise Data Warehouse (EDR) and other systems that will create the basis for provider performance and reimbursement analytics. The information will be used to tier the provider community through quality and efficiency measures enabling the pay for performance mechanisms that support network strategy .This dataset will also serve as the basis for expansion to support future provider initiatives for BCBSRI.

Responsibilities/Experience:

·         Design and develop data warehouse solutions to meet customer business functions and requirements, by working closely with the data architect, data analyst and business users as needed. Estimate the effort for projects, change requests and enhancements.

·         Evaluate user request to create or modify datastage by determining feasibility, cost and time required, compatibility with current system and EDR capabilities.

·         Provide expert technical, system design, current systems knowledge and datastage abilities to a project team during all phases of a project, ensure project team adherence with all BCBSRI Enterprise Information Management standards and customer requirements.

·         Convert complex project specifications in to datastage jobs to load and process data in to EDR (Enterprise data Repository)/ Data warehouse.

·         Prepare technical design documents, unit test cases and Production implementation documents and assist data analysts in preparing user training documents.

·         Create datastage jobs which are modular in design by creating shared containers for each logical block of datastage code.

·         Extensively used shared containers for reusability and ensured balanced usage of Netezza and datastage resources.

·         Parameterize the jobs to allow portability and flexibility during runtime.

·         Create audit jobs which write the record counts and summarize amounts in audit tables to ensure successful job run

·         Perform unit testing and component integration testing and co-ordinate with SIT and UAT team to fix the defects raised during testing.

·         Utilize Unix for data audit of certain modules and ftp of files.

·         Utilize CVS for version control of .dsx files and migrate the code from one environment to other.

·         Tune datastage jobs to bring down job run time and improve the performance.

 

Environment: IBM Infosphere Datastage 8.1, Netezza 4.6, Oracle 10g, Sybase, and Aix Unix 5.3,CVS

 

 

 

 

 

 

 

Cognizant Technology Solutions ,USA

Lexis Nexis –Pinnacle                                                                                                              Oct ’11 – Jun ‘12  

ETL Lead

The main aim of the project is to migrate the data from MH Siebel legacy application which is implemented in Siebel 7.5 to Total source, a new application to be implemented in Siebel 8.1 .The requirement included ensuring the data converted conforms to the functionalities of Total Source.

 

Responsibilities/Experience:

·         Work with Business Analysts and SME to understand the requirements.

·         Work with Seibel data migration team to understand the Siebel data model, source and target mappings.

·         Estimate the effort for projects, change requests and enhancements.

·         Prepare high level and low level design documents.

·         Lead an onsite/offshore model. Handle technical and operational issues in the team.

·         Design and develop jobs to extract, cleanse, transform and load the data in to Siebel EIM tables.

·         Parameterize the jobs to allow portability and flexibility during runtime.

·         Use Datastage Manager to manage datastage repository, define custom routines, Import and export jobs between different environments.

·         Use Datastage Administrator for defining environment variables and removing the job locks.

·         Extract the data from Teradata views and load in to Siebel t staging tables.

·         Work with testing team to help them prepare test scenarios and test cases.

·         Tune datastage jobs to bring down job run time and improve the performance.

·         Prepare SQL Scripts to use  in Datastage

·         Perform unit testing for datastage jobs to ensure requirements are conformed.

 

Environment: IBM Infosphere Datastage 8.5, Oracle 9i, SQL Server 2005, Teradata, Windows and Linux

 

 

 

Cognizant Technology Solutions ,India

CTS- Insight Compass                                                                                                           Dec ’09 – Oct ’11 

ETL Lead

This project was initiated to develop Business Intelligence Solution which will tie together customer, associate, project and financial information housed in PeopleSoft and non PeopleSoft applications enabling powerful analytics, drilldowns and reporting capabilities and a single source for management reporting.

Responsibilities/Experience:

·         Interact with Business Analysts to gather requirements and understand the processes.

·         Prepare the prototypes and technical design documents.

·         Understand the General Ledger data module of Peoplesoft to build and data mart for cognizant finance team.

·         Design and develop datastage jobs conforming to the requirements.

·         Design and developed control check jobs to avoid manual errors during production run.

·         Resolve several production issues related to DWH for Cognizant finance

·         Schedule and deploy datastage jobs in certification and production environment.

·         Identify and resolve incidents, coding issues, connectivity issues, data issues, configuration issues which would help maintain the Data Warehouse of Cognizant Finance .

·         Perform administrative task like creating projects ,start and stop the server, unlock the jobs and archive the logs and files older that three months in production.

 

·         Schedule datastage jobs using datastage director.

·         Manage the team by assigning appropriate tasks to team members and ensure that the tasks are completed as scheduled.

·         Review coding done by the team and coordinate the whole effort.

·         Design and develop audit jobs to log and handle exceptions.

·         Preparing knowledge base for resolving production issues which will be helpful for others in future and also increase the knowledge of the team.

·         Design and develop Web Intelligence and Desktop Intelligence reports in Business Objects XI 3.1

·         Design and Develop Universe in Business Objects XI 3.1 and XI R2 using designer.

·         Create Ad-hoc and complex reports using multiple data providers, slice and dice, complex filters, prompts and sub queries.

·         Create cardinalities, contexts, joins, external strategies and aliases for resolving Loops and check the Integrity of the Universe.

·         Use complex variables, breaks, sort, calculations and alerts for creating Business Objects Reports.

·         Prepared SQL scripts, test cases and test scenarios.

·         Prepared DB2 export, import scripts to transfer huge volume of data from files to tables, utilized range partition technique to improve performance.

·         Perform unit testing and migrate the projects to production and provide level three support.

·         Prepared unix shell scripts to ftp files, trigger DB2 scripts to export /import of files.

·         Performed sever administration activities using Unix like checking the disk spas ,starting and stopping DS Engine ,unlocking job locks.

·         Performed POC to check the feasibility of using Green plum database.

 

Environment: Datastage 7.5 Server edition, DB2, Business Objects XI R3, Windows and Unix.

 

HCL Technologies Ltd. ,India

Lloyds Bank –Moody’s Risk Frontier                                                                                   Feb ’09 – Dec ’09 

Senior Datastage Developer

The data from BIR (Business Intelligence Repository) is used as a source to design the dimensions and facts as required by the Moody’s (a leading supplier of quantitative credit analysis solutions to lenders, investors and corporations) and the data is loaded in to Moody’s database, The Risk frontier   analyses the  dimensions and facts from BIR and provide the ratings which will be loaded back in to BIR for reporting/decision making by portfolio management team.

Responsibilities/Experience:

·         Interact with onsite team to gather requirements and understand the processes.

·         Provide estimation for new projects and enhancements.

·         Execute projects using agile methodology for meeting tight deadlines.

·         Prepare physical design documents using logical design documents as input.

·         Design datastage jobs as per the physical design document.

·         Load high volume data and tune the performance of datastage jobs.

·         Unit test datastage stage jobs and ensure jobs are meeting the requirements.

·         Promote the jobs,sql scripts, input files to certification and production environments

·         Work with the testing team to provide them with sample data to test the jobs.

·         Assist testing team in functional, integration and user acceptance test cycles.

·         Schedule the datastage jobs using tivoli scheduler.

·         Provided support to the system testing and resolve issues raised by system testing team.

 

Environment: Datastage 7.5.2 Enterprise edition, Oracle 10g, Windows and Linux.

 

 

HCL Technologies Ltd. ,India

Rockwell Automation-EMEA BI                                                                                           Dec ’05 – Jan  ’09 

Datastage Developer

The main aim of this project is to  maintain and support the Rockwell’ s EMEA Data warehouse, by enhancing the existing applications, developing the new applications based on the requests from the business users.

Responsibilities/Experience:

·         Member of EMEA Business Intelligence team.

·         Interact with client, analysts and subject matter experts to understand processes and requirements.

·         Prepare technical specification documents for the requirements including key project assumptions, technical flow, process flow, ETL Logical design, logics and Error handling.

·         Extract the data from EMEA datawarehouse cleanse and transform the data in to files and submit the files to SAP database.

·         Create jobs in datastage to extract from heterogeneous data sources like Oracle, SQL Server, Flat files and  XML.

·         Parameterize the jobs to allow portability and flexibility during runtime .Apply business rules and logic at transformation stage and load data into data warehouse.

·         Prepare efficient designs for complex requirements  by using stages such as hash file, transformer, aggregator, pivot, link partitioner, start loop activity, end loop activity,inter process and link collector.

·         Develop logic to accommodate SCD1 and SCD2.

·         Fine tune datastage jobs for optimal performance.

·         Prepare scripts for database operations.

Schedule and monitor the jobs using Control M Scheduler.

·         Prepare test cases and test scenarios.

·         Comply with RFC and SOX Standards to deploy the developed jobs.

·         Provide on time solutions to service calls raised in HP Open view  to comply SLA’s.

·         Handle change requests from business and business analysts.

·         Reported the status from time to time to Managers and Client.

·         Mentor and coach team members, and peers for better understanding of  projects and processes.

·         Deputed onsite to carter client specific processes, standards, coach and guide the team in Offshore.

 

 

 

Environment: Datastage 7.5.2 Server edition, Oracle, SQL server, Windows and Linux

 

Education Details:

Bachelors of Engineering in Electrical and Electronics, University of Madras.