Prof. Syed Jaffery

• Reviewed, developed and designed data models in conjunction with the application development team. • Assist in Displaying data to client in an understandable manner • Assist in development of the design and implementation of solutions • Strong knowledge of data warehousing methodologies and concepts including Star, Snowflake and Fact Constellation Schema to correlate business analysis from OLTP to OLAP to develop decision support system DSS.

Revlon is cosmetic company in United States and Canada. I am leading business intelligence team which include 8 resources. Data Migration & Integration Project using SSIS, SSRS, Power BI, MDS (Master Data Services) .Now loading data into SAP. Used SAP.net connector to call Functions/BAPIs in exposed from SAP to retrieve and load data into SAP. Day to day meeting with the client has been conducted, Customer certification and facilitation is one of the key aspect of my career.

• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. • Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration. • Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.

Mobilink is the leading telecom company in the Pakistan. Worked as Business Intelligence Manger, leading Fraud Control & System Development team of IT professionals as a part of CRM department. Responsibilities: • Churn predictions • Wingback management • PSM (payment scoring module) for our customer. • Profile based calling system. • Bad Debt allocation to nationwide collection team.

Multi Media Data Bases Data Modeling Data Transformation

Data Bases Software Engineering Multi Media Database Data Analysis C#.Net Advance Data Bases