Sreejith Bhaskaran

Data Warehousing professional having worked in BI DW Platform for 12+ years under diverse domains viz, Automobile Servicing, Banking & Finance Industries

• Strong Experience with data Warehousing, Data Integration, Migration and developing business applications using IBM Infosphere Information Server ,Ascential Datastage, IBM Infosphere DataStage Manager, Designer, Director, and Administrator), Oracle, PL/SQL, SQL Server, DB2, SQL and Shell scripts.
• Specializes in Data Analysis, Data Mapping, Data Conversion, Data Integration, Business Analysis, Data Quality Analysis, Functional Design, Technical Design, and different aspects of data/information management.
• Design and build common re-usable ETL components to define audit processes and capture DQ exceptions, Job monitoring, and ETL logging processes.
• Create ETL processes to ensure data integrity (error handling) and document appropriate procedures.
• Involved in Administration and Support of ETL Platform.
• Experience in monitoring and administrating IBM InfoSphere DataStage server performance and usage.
• Experience in IBM InfoSphere DataStage jobs specification documentation preparation

SKILLS SUMMARY 

•    ETL Tools Used: IBM Infosphere information server 11.7,11.5, 9.1, Ascential DataStage 7.5
•    Database Systems: Oracle 9i/10g (10.2.0.4)/11g/12c ,DB2, MySQL
•    Languages: SQL, PL/SQL, Shell Scripting, HTML,CSS
•    Environments: Windows, HP UX, Linux
•    Supportive Tools Used: Postman, Autosys, Salesforce Cloud, Toad, SQL Developer, Erwin Data Modeler, StarTeam, Tortoise SVN, IBM Cognos, CA WORKLOAD Automation, Azure Pipeline, Tidal Automation, Putty, Service Now , WinSCP

ETL DATASTAGE DEVELOPER/LEAD

Responsibilities & Achievements

• Involved in the design and development of DataStage Jobs in 25+ Releases so far
• Create high level Designs for the impacted/New jobs
• Create ETL Designs
• Worked with business teams for requirement gathering and create the mapping document for the ETL Development.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing.
• Working on various processing stages like Transformer, Lookup, CDC, Sort, Join, Aggregate, Hierarchical, etc.
• Ability to connect and transform data from various data sources like Flat files, XML Files, JSON Files, Web Services, Oracle DBs etc.
• Extensively used Data Stage Designer, Quality Stage, and Administrator Director for creating and implementing jobs to load the Data Marts/Data Warehouse.
• Extensively used hierarchal data stage to parsing JSON data and Unstructured Data stage to read and write Microsoft Excel files.
• Knowledge on parsing xml and json data from webservice.
• Identifying the facts and dimensions for developing a logical design of the data marts.
• Optimizing low performing queries on a regular basis
• Created ETL jobs to read data from Salesforce and load data into Staging tables.
• DataStage Admin activities control includes environment maintenance.
• Installed and Configured Director, Manager, Administrator and Designer components of IBM InfoSphere DataStage.
• Schedule the jobs in Autosys and Workload automation
• Working with IBM consoles involving administration activities, Information analyzer and Data Governance
• Used IBM IS Web Console for admin areas: Security, Licensing, Logging, and Scheduling.
• Managed Security, Active Sessions, Logs, Unlock Jobs, Datasets, Scratch, Schedules and Assets from Web Console Designing and coding the data transformation interfaces to meet the data transformation needs with optimum performance.
• DataStage Migration activities
• Working on environment Upgrades and patching activites
• Working on IBM Governance catalog and Metadata Workbench
• Developed shell scripts for automated DataStage, database & Unix deployment activity for the application
• Developed Unix script for automated password maintenance management activity for the applications involved in the project.
• Involved for the Migration Activity of Commercial Data Mart from Data stage 9.1 to IBM Infosphere 11.7
• Also been SME for the deployment of CDM (Commercial DataMart) 11.7
• Also involved in the major deployment and sustain activity of Operational Data Store
• Major Involvement in CPU Configuration Change in DataStage Server and Autosys Server Installation
• Complete involvement in installing DataStage Jobs to Autosys Schedular
• Developed Unix scripts for automated deployment for the application

Msc Information Tech