Zoheb Syed

Background

About Zoheb Syed

PROFESSIONAL SUMMARY- • A skilled software professional in creating OLTP and OLAP Data ware house using Microsoft SQL Server • Worked on the complete Software Development Life Cycle (SDLC). • Strong knowledge in OOP’s (Object Oriented Programming) concepts and 3-Tier Architecture. • Proficient in writing T- SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization. • Created ETL Metadata Driven Framework to maintain standard across all ETL Developer and company standard. • Hands on experience on the whole ETL (Extract Transformation & Load) process. • Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, MySQL, PostgreSQL, flat file, Text Format Data). • Worked on upgrading from DTS to SSIS packages and also have experience with Infomatica ETL tool. • Experience in designing Database Models using Microsoft Visio and creating class diagrams, activity diagrams, use cases diagrams, sequence diagrams and flow charts using UML. • Worked on Notification services in setting up the Scheduled jobs and alerts. • Hands on experience on Data warehouse Star Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling. • Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology. • Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills. TECHNICAL SKILL- Database: SQL Server MySQL, Microsoft Access, TFS, Visual studio 2017 ETL Tools: SSIS, Informatica. Data Modeling Tools: ERWIN, MS Visio. Programming Language: T-SQL, ASP.NET, C#,VB.Net C, C++, Visual Basic 6.0 Reporting Tools: SSRS, Crystal Reports, Great Plain 2010, MS Access, MS Excel.