Syed Najib Ali Jafri

Syed Najib Ali Jafri FLAT A11, CROWN SHOPPING APARTMENTS, SHADMAN 2, NORTH NAZIMABAD TOWN, KARACHI, PAKISTAN • Cell: - • Email:- • Skype: syed.najeeb6 Summary I’m a highly dedicated and goal/work oriented BI/DWH engineer with an extensive experience of more than 2 years using Microsoft BI Stack and Talend. Most of my experience lies in working for Retail/Call Center/pharmaceutical business domains. I don’t only work well in my projects but I live my projects. I’m experienced in dealing with both local (onsite and offsite) and international clients. Goal: I thrive to work on a position in Information management domain as a technical consultant that will allow me to apply my vast knowledge and skills in order to bring technology, analytics and peoples together to ensure the success of strategic initiatives. Experience Organization: Qordata Duration: April, 2017 – Present  Designation: Technical consultant Responsibilities: Actively involved as technical consultant in creating and managing ETL processes for the health/life science domain business using SSIS. Actively involved in writing and tuning complex SQL queries. Extra ordinary communication skills, which enables me so quickly to directly deal with the Spain based clients. Also acting as a business analyst in order to directly gather requirements from the clients. Organization: Afiniti (TRG) Duration: October, 2016 – Present  Designation: Analyst Software Engineer Responsibilities: Actively involved as technical consultant in creating and managing ETL processes for the Insurance clients call center business using Talend. Actively involved in optimizing MySQL complex queries. Actively involved in overall monitoring of all the ETL processes of my clients. Take the ownerships of the processes so quickly, which enables me to directly deal with the US based clients. Scheduling the jobs using Windows task scheduler. Leading the ETL processes of two different projects. Organization: Systems Limited Duration: March, 2015 – September, 2016  Designation: Software Engineer Responsibilities: Actively involved as technical consultant in creating and managing DWH for different projects using SSIS on Microsoft Dynamics AX (ERP) projects. Actively involved in data modelling using star dimension and snowflake dimensions as well as data marts creation. Actively involved in gathering requirements for the reports, dashboards and OLAP cube, which have to be built on DWH using SSRS/SSAS. Actively involved in optimization at all levels either in SSIS packages, SQL queries, SSRS report/dashboards and SSAS cubes. Actively involved in SSAS cubes implementation and in MDX formulas. Actively involved in projects as a technical consultant to deeply analyze the requirement given by the client because of my expertise in retail business domain and then create the DWH to cater such requirements. Actively involved in creating and managing large size OLAP cube efficiently from the very scratch. Actively involved in moving the SSIS ETL packages from development server to QA and then to production smoothly. Actively involved in scheduling the SSIS ETL packages execution by making its job using SQL Server Agent Services smoothly. Expert in query writing (SQL). Actively involved in creating stored procedures, indexing, functions etc. Most of the experience is in retail business domain. Else, I also worked with Production and Finance business modules. Leading a team of 2 DWH/BI Jr. developers team. Technical Skills Crystal Reports SQL Server 2008/2012/2014 SQL Server Data Tools 2010/2012/2014 SSIS – SSDT/BIDS SSRS OLAP Cubes (SSAS) SQL/T-SQL/ MySQL Talend Certifications 70-461 : Querying with Microsoft SQL Server 2012/- : Implementing a data warehouse with SQL Server 2012/2014 Core Competencies Quick learning ability, strong team building, prioritize tasks & management skills supplemented with insightful experience of dealing with tight deadline scenario. Cohesive team player with excellent communication and interpersonal skills. Excellent writing and editing skills and has writing experience with blogs. Very passionate and experienced in maintaining good relations with the client and colleagues. Experienced in entertaining last minute request of clients, which stands me out as a reliable resource. Believe in finding a “wow factor” among my team mates and use that factor to boost them up. Education NED University of Engineering & Technology-| B.E in Computer & Information System Engineering Personal Information Father Name : Syed Najmuddin Jafri Marital Status : Single CNIC # :- Date of Birth : Oct 9th ,1992 Languages : English, Urdu Passport : AQ- Projects To be furnished upon request.