Senior Consultant Data Analytics
TechVista Systems
Total years of experience :7 years, 11 Months
Technical lead on Data Quality project at FDC (Federal Demographic Council) Managed the technical team and designed to architecture of Informatica IDQ for Datawarehouse including (Staging, ODS, Reporting) layers. Client engagements on requirement gathering and task alignment of team. Helped data modeler to create BRS & TDD documentation Created FuzzyMatch and data quality rules and trained resources and successfully productionized two subject areas. Sessions with Informatica's Team on Data Governance tools implementation (Axon & EDC)
Lead Data Migration project for Temenos at United Bank Limited Pakistan. Worked as a Data Modular to create DMS (Data Mapping Sheet) before kicking off the project. Engagements with client on environment setup and tool configuration activity, suggested tools to client for Data Migration activity Closely coordination with client on requirement gathering and prerequisites require in development. Created project plans for multiple streams and took sign-off with client. Build development team and worked on Data Migration activity and helping team if they face issues. Successful Data Migrated for multiple streams like Retail, DCP, OMNI etc.
Build and trained to a team and lead Data Lake project of United Bank Limited Worked with client and IBM team on requirement gathering, DDL creation & SMX sheet. Delivered successful nine source systems including complex transformation on multiple layers like Stage, UTL, LDR and FSDM Development of dynamic mappings on Informatica BDM on multiple logical layers (Staging, Load Ready and Semantic) Source integration of Data Lake with Teradata Database Integration of mappings into workflow applications Unit testing of end-to-end source systems Responsible for technical analysis, design, development, testing, and deployment of IT solutions as needed by business or IT.
Managing team and working as Inference (Java Drools) & ETL developer Create ETL mapping for source file (.txt, .csv) and check data validation in case any incorrect data provided in client file. Create Target Error table to error-out incorrect data and create table in Oracle. Create different schema in Oracle and the source data we move from Source schema to OLAP schema via ETL mappings and workflows we develop in Informatica designer and workflow manger. I have built a custom workflow to Lookup OLAP data and populate in Stage schema. Work on ETL Informatica repository to export the workflows and integrated .xml in SVN. Development of dynamic mappings on Informatica BDM on multiple logical layers (Staging, Load Ready and Semantic) Source integration of Data Lake with Teradata Database Integration of mappings into workflow applications Unit testing of end-to-end source systems Responsible for technical analysis, design, development, testing, and deployment of IT solutions as needed by business or IT. Work closely with other subject matter experts to help design and build solutions for a multitude of applications, including batch processing, OLTP, OLAP and data and data warehouse architecture. Data parsing from Json format into database according to specifications in SMX documents Work with product owners and other development team members to determine new features and user stories needed in new/revised applications or large/complex development projects. Develop and test tasks, ensure adherence to agreed timelines, and communicate status of tasks to team lead. Technically involved in the Design and Development of Database objects such as Tables, Views, Index, Stored Procedures, Packages, Functions, Triggers and Integrity Constraints