Farman Sheikh's Email Addresses & Phone Numbers

📖 Summary

Proven success as a Data Engineer (ETL, BI, Reporting, Analytics), providing a well-balanced understanding of business relationships, business requirements and technical solutions. Lifelong learner and self-starter with ability to communication with all levels of stakeholders. Unparalleled dedication to customer service, personal development, and synergistic collaboration. - CRM & ERP: Salesforce and NetSuite - CLOUD SERVICES: Microsoft Azure and AWS - DATA/DIMENSIONAL MODELLING TOOL: ErWin, ErStudio - RELATIONAL DATABASES: MS SQL Server, Oracle, MySQL, PostgreSQL - ANALYTIC (COLUMNAR) MPP DATABASES: HP Vertica, AWS Redshift - NOSQL DATABASE: MongoDB - BIG DATA ECOSYSTEM: Hadoop (1.0 & 2.0), HIVE, PIG, Sqoop, Spark, Drill - ETL TOOLS: SQL Server Integration Services (SSIS), Informatica, Pentaho - CUSTOM ETL: Python, Shell script - OLAP: SQL Server Analysis Services - ANALYTICS & REPORTING TOOLS: Tableau, Spotfire, SQL Server Reporting Services (SSRS) - SCRIPTING LANGUAGES: SQL, Python, Perl, Shell, Ruby - SQL CLIENTS: SQL Server Management Studio (SSMS), Toad Data Point, SQL Developer, SQL*Plus, SQuirrel, WinSQL, Dataloader (Salesforce), MySQL Workbench - IDEs: Visual Studio, SQL Server Data Tools, PyCharm, Notepad++, Sublime Text - PMO TOOLS: MS Projects, MS Visio - SOURCE CONTROL: Git , Perforce, VSS, MS Team Foundation Server (TFS) - DATABASE & INFRASTRUCTURE MONITORING TOOLS: Icinga, Nagios, Ganglia, Graphite - MESSAGING SERVICES: RabbitMQ - LOG MANAGEMENT: Splunk, Logstash (ELK Stack - Elastic Search, Logstash & Kibana) - VIRTUALIZATION: VSphere, VCenter - CONFIGURATION MANAGEMENT: Chef, Puppet - OS: Windows, UNIX, LINUX Specialties: Big Data Development, Data Modelling, Designing and writing (ETL) Data Pipeline, Data Analysis, Data Analytics and Visualization, Database Administration.Lead Sr Data/BI Engineer @ • Team Lead, responsible for Historical Data Migration from MS SQL Server and other source systems to Salesforce Analytics Cloud CRM and NetSuite ERP system. • Responsible for doing Project planning along with Project Manager and different members of the cross-functional team. • Responsible for creating Operational Data Store (ODS) & Enterprise Data Warehouse (EDW) Data Model – and creating Infrastructure, Design and ETL Strategy to Build, Develop and Load Data from SFDC, NetSuite and other various OLTP Source Systems. • Responsible for creating Operational Analytics Environment (OAE) for different Business groups within the Organization and to provide them with Data and Tools needed for Self-Service BI Model and Analytics. • Responsible for Extracting Data from SFDC and pushing it to WAVE Analytics platform via Informatica Cloud and creating dashboards for different Verticals within the organization. • Translated business requirements into sustainable and efficient visualizations and reporting using Tableau and SSRS. • Used TABCMD and Tableau Data Extract API using Python. Environment: Hadoop Stack, Spark, Apache Drill, Salesforce CRM, Wave Analytics, NetSuite Financials, ODS, Data Warehouse, Analytics, MS BI Stack, MS SQL Server 2012, Salesforce Object Query Language (SOQL), ER Studio, MS Visio, Tableau, MS Power BI, AWS S3, AWS Redshift, MongoDB, Tableau, Power BI, SSIS, SSRS, SSAS, Workbench, Informatica Cloud, Dataloader, Python From November 2014 to Present (1 year 2 months) Software Engineer VI (Sr Data Engineer) @ • Designing, Creating and setting up Oracle, Vertica, MongoDB and Hadoop Cluster. • Database Administration, Maintenance, Monitoring and setting up alerts with 24x7 On Call support. • Responsible for Data warehouse Dimensional Modeling, ETL design and development. • Translated business requirements into sustainable and efficient visualizations and reporting using Tableau and Spotfire. Environment: Oracle, RMAN, Data Gaurd, MongoDB (NoSQL), Vertica (Columnar DB), MS SQL Server, Hadoop - HDFS, Hive, Pig, Sqoop, Spotfire, Splunk, Ganglia, Graphite, Chef, RabbitMQ, Linux, Python, Ruby, Shell script, VM, HPCS, Nagios / Icinga , ELK ( Elastic search, Logstash, Kibana ). From June 2013 to November 2014 (1 year 6 months) Sr. Software Engineer (Sr Data Engineer) @ • Data Warehouse Dimensional Modelling. • Responsible for Data Migration from existing SQL Server and MySQL DB to HP Vertica. • New custom ETL design and development. • End-To-End reporting solution using reporting tools like SQL Server Reporting Services. • Analytics Dashboard creation using Tableau. Environment: Database (Vertica, SQL Server, PostgreSQL), Data warehouse (SQL Server, Vertica), Infrastructure (VM), Front - End Application (C# , .net), ETL, Reporting, Dashboards (Tableau), NoSql ( MongoDB ), Python, JSON, BSON From June 2012 to June 2013 (1 year 1 month) Sr Business Intelligence Developer @ Business Intelligence, Data Warehouse, ETL, Database, BA, Reporting, Dashboards, Data Architect From January 2011 to June 2012 (1 year 6 months) Database/ETL Developer (Data Engineer) @ . OLTP and OLAP Data Modelling . Developing ETL Pipelines . Providing End-to-End Reporting Solutions . BI Dashboards using Tableau . Python, Shell and Advanced SQL scripting From July 2009 to January 2011 (1 year 7 months) San Francisco Bay AreaBusiness Intelligence Developer @ From January 2009 to June 2009 (6 months) Greater San Diego AreaTest Engineer @ Qualify Cisco routers and other high-end enterprise and service provider devices for FCC and other accredited laboratories and country compliance for RF and power-related parameters. Exposed to a wide variety of Cisco products, including high-end Internet routers and switches, fiber-optical and copper network interfaces, and AC and DC power systems. From July 2008 to December 2008 (6 months) Master's Degree, Electrical & Computer Engineering @ University of Massachusetts at Lowell From 2007 to 2008 Bachelors, Electronics Engineering @ University of Mumbai Farman Sheikh is skilled in: T-SQL, MySQL, PL/SQL, PostgreSQL, Vertica, ETL, Business Intelligence, Data Warehousing, SSIS, SSAS, SSRS, Tableau, Microstrategy, C#, C