Pratheesh Punchayil Joseph
Calgary,Canada
Summary
Innovative professional in engineering field known for high productivity and efficient task completion. Skilled in project management, problem-solving, and technical writing. Excels with strong communication, teamwork, and adaptability, ensuring successful project outcomes and collaborative work environments.
- More than 15 years of experience in IT & Data Management.
- Extensive experience in Data Analysis, Data Architecture, Data Quality, Data Governance and Data Privacy.
- Expertise in data management with data management tools like Informatica IICS, IDMC, TDM etc.
- Managed and executed projects that involved Swiss Secrecy, PII, Basel II/III, CCPA& GDPR Regulatory needs.
- Championed in Data Obfuscation projects with ILM and CA TDM tools for large investment banks in USA.
- Extensive knowledge in TDM Products ie, CA TDM (GT Data Maker), Delphix , ILM and IBM Optim
- Expert level knowledge of BI, ETL Development and Data Warehouse Architecture.
- Expertise in DWH ETL tools Informatica Power Center, IICS, IDMC,OWB and ERWIN.
- Strong experience with Informatica Data Quality (IDQ & CDQ) & Data Governance (CDGC).
- Experience with Informatica Enterprise Data Catalog (EDC/CDGC) development & administration
- Best knowledge in ER, DWH, OLAP, FACT, Dimension/Data modeling with Erwin tool.
- Good knowledge in extracting, transforming data and loading into Star/Snowflake schemas
- Expert in SQL,PL/SQL,triggers, functions and procedures at database level
- Data analysis and reporting with various analytics tools.
- Hands on experience in Databases Snowflake, Microsoft Azure, MS SQL, ORACLE, DB2, Sybase and TeraData.
- Expertise in SQL, PL/SQL, XML,Stored Proc and UNIX Shell Scripting.
- Expertise in Informatica Power Center, IICS, IDQ, Mappings, Maplets and Rules.
- Expert knowledge in Agile/scrum and waterfall methodologies
Overview
18
18
years of professional experience
Work History
Senior Data Analyst
SOBEYS CAPITAL INC
Calgary, Canada
06.2023 - Current
- Understand the business needs from the stakeholders, prioritizing & translating those needs into technical requirements for the data & analytics engineering team.
- Ensure all outputs & deliverables adhere to consistent frameworks and standards, including business rule logic & taxonomy
- Develops analytic models to understand complex business issues and provide data-driven insights
- Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing
- Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with CDQ
- Work closely with business teams and Design DG/DQ processes and create scorecards
- Create data profiles and scorecards as per the business needs
- Create required pipelines from Assure Data Lake using ADF for the DQ works
- Extracting, transforming data coming from various data sources and loading into Snowflake Database
Data Analytics Architect
WIPRO LIMITED
Bangalore, India
07.2019 - 02.2023
- Architect, develop and drive scalable and resilient data platform to address the business requirements
- Provided ETL & TDM (Test Data Management) consulting and solutions to various clients in Wipro
- Perform data assessment for different Regulatory complaints and data protection acts (PCI/CCPA/GDPR)
- Manage and support leadership to build the enterprise Data Governance model
- Drive industry best practices around ETL, Data Quality, Data Governance, Privacy and Metadata mgmt
- Review user stories, the technical design and implications from a Data Integrity perspective
- Conduct Assessments and develop roadmaps & strategies and provide implementation support
- Provide IICS, TDM, DQ and DG solution and supports required for the Wipro practice
- Profile source data and determine all source data and metadata characteristics
- Design and execute the data quality mappings that will cleanse and de-duplicate
- Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment
- Document all mappings, mapplets, and rules in detail and hand over documentation to the customer
- Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ/CDQ and IICS
Data Architect
SLK SOFTWARE
Bangalore, India
01.2018 - 02.2019
- Implemented Enterprise TDM and Data Privacy solution for the major US banks
- Analyze different regulatory complaints for data protection
- Worked closely with IT Directors, Audit Team and PM Office to implement TDM Solutions
- Develop TDM roadmaps & strategies and provide implementation support
- Setup TDM Environment and applications on-boarding
- Application Data Privacy identification and Prioritization
- Perform Data Profiling and Data Masking for multiple applications
- Required TDM/PL/SQL & Shell scripts, rules, Mappings and workflows design & development
- Design technical solutions for data collection/storage/cleansing from different Application/Audit teams
- Work closely with Enterprise Architects and Design DG/DQ process for the various projects
- Participate in the requirement gathering and feasibility analysis
Project Lead/ Data Consultant
TATA CONSULTANCY SERVICES LTD.
Bangalore, India
10.2012 - 11.2017
- Provided TDM (Test Data Management) solutions to various clients across the globe
- Part of TCS TDM CoE (Practice team) and help to define TDM strategy for multiple customers
- TDM tool comparisons, matrix, hands on and solutions with Informatica TDM, CA TDM and Delphix
- Conduct TDM Assessments, Road map creation, Resource Estimation and PoCs at the customer locations
- Setup TDM Environment and applications on-boarding
- Perform detailed data discovery and data privacy assessments
- Design & Develop Synthetic Data Generation, Sub setting and Masking rules
- Pre-sales activities, RFP/RFI creations from a technical point of view and presentations to the clients
- Required TDM/PL/SQL & Shell scripts, rules, Mappings and workflows design & development
- Key TDM activities are Data Discovery, Data Profiling, Data Archiving, Synthetic Data Generations, Data Subsetting, Data Masking and Data Refresh
Business Analyst
CREDIT SUISSE AG
Singapore, Singapore
06.2011 - 06.2012
- Managed and Prioritized BOW for more than 20 projects and releases
- Analysis and Design of ETL processes and validating data sources
- Extracting, transforming data coming from various data sources and loading into star/snowflake schemas
- Co-ordinated team for all BAU delivery with Credit Risk teams in Singapore, Zurich, US, London and Pune
- Liaised with CRM/Scenario/Counterparty users for various enhancements and new business needs
- Developed necessary MS Access, Sybase queries, Macros & VBA codes for the credit reporting team
- Review and sign off UAT, test cases, regression testing results in accordance to project timelines
- Participate in the design, analysis and testing of key Risk Systems Change Requests (CR)
Team Lead
CREDIT SUISSE AG
Singapore, Singapore
02.2007 - 06.2011
- Lead & Co-ordinate team of 10 members between business and IT
- Design and development of data models for OLTP (On-line Transaction Processing) and OLAP (On-line Analytical Processing)
- Design and Development of ETL (Extract, Transform, Load) processes and validating data sources
- Extracting, transforming data coming from various data sources and loading into star/snowflake schemas
- Automate and optimize complex data ETL processes using Informatica Power Center
- ETL/PL/SQL & Shell scripts, rules, Informatica Mappings and workflows design & development
- Requirement gathering from CRM Team in Singapore/Zurich and CR implementation
- Responsible for analysis and data base design to meet business requirements
- Regression testing, Functional/UAT testing and support production issues
Education
Masters Diploma - Computer Applications
National Institute of Electronics & Information Technology
Calicut, India01.2024
Computer Engineering Diploma -
Go.t. Poly Technic College
Shoranur, India01.2000
Skills
- ETL (Extract Transform Load)
- Data modelling
- Test Data Management (TDM)
- SnowFlake
- IICS and IDMC
- Data Visualisation
- Business Intelligence
- SQL
- Azure Data Lake
- Azure Databricks
- Synapse
- Power BI
- Fabric
- Tableau
- UNIX
- Python
- Machine Learning and AI
- PCI,PHI, GDPR and PII
- Data Analysis and Reporting
- Data Quality & Data Governance
Timeline
Senior Data Analyst
SOBEYS CAPITAL INC
06.2023 - Current
Data Analytics Architect
WIPRO LIMITED
07.2019 - 02.2023
Data Architect
SLK SOFTWARE
01.2018 - 02.2019
Project Lead/ Data Consultant
TATA CONSULTANCY SERVICES LTD.
10.2012 - 11.2017
Business Analyst
CREDIT SUISSE AG
06.2011 - 06.2012
Team Lead
CREDIT SUISSE AG
02.2007 - 06.2011
Masters Diploma - Computer Applications
National Institute of Electronics & Information Technology
Computer Engineering Diploma -
Go.t. Poly Technic College
Similar Profiles
Denis ViensDenis Viens
Commis at SOBEYS CAPITAL INCCommis at SOBEYS CAPITAL INC
Pardeep BalPardeep Bal
Sobeys Pharmacy at Sobeys Capital IncSobeys Pharmacy at Sobeys Capital Inc
Shoaib ZaziShoaib Zazi
Network Specialist at Sobeys Capital Inc.Network Specialist at Sobeys Capital Inc.
Osama NedalOsama Nedal
Healthcare Security Officer at Paladin Security GroupHealthcare Security Officer at Paladin Security Group
TOMISIN BABALOLATOMISIN BABALOLA
Volunteer at Beddington Pentecostal ChurchVolunteer at Beddington Pentecostal Church