GULAM S.

GULAM S.

Lead Tableau and SQL Developer

Mumbai , India

Experience: 9 Years

GULAM

Mumbai , India

Lead Tableau and SQL Developer

18000 USD / Year

  • Immediate: Available

9 Years

Now you can Instantly Chat with GULAM!

About Me

Over 9+ years of experience into Business intelligence & other technologies like Tableau, SQL, SSIS , VBA & C# Having 4 Years of Experience in visualize the business data by using Tabelau Desktop & tableau server 5+ Years of experience into VBA, macr...

Show More

Portfolio Projects

Description

  • Working as a Teach lead handling team of 4 members and also an individual contributor
  • Identifying the scope of automation and providing the best suitable environment
  • Daily standup and weekly catchup with team and stake holder on project status
  • Demo and training to technical & non-technical members on various environment & projects
  • Data gathering for report requirements, storing data into sql server and maintaining database.
  • Connecting excel, csv, Oracle, SQL server as data sources to visualize data with both live and Extract connections.
  • Creating user interactive dashboards by using multiple views, quick filters, parameters and actions.
  • Created key performance indicators with Parameters, Quick filters, Table Calculations, calculation fields, sets & groups
  • Being Created KPIs with Doughnut, Horizontal Bars, Vertical Bars, Tree Maps, pie, Water Fall charts, Text View, etc.
  • Creating, testing and publishing the reports and dashboards into UAT & production environment.
  • Working as tableau site administrator and creating & maintaining projects, users, groups, schedules and subscriptions.
  • Using SercviceNow as ticketing tool to release and defect & change management

Show More Show Less

Description

• Environment: Tableau Desktop & SQL Server
• This is an interactive dashboard consist of 3 reports with different type of charts which shows Traders comments with RAG (Red, Amber & Green) across location, Desk, Traders & dates
• Scatter chart, Pie chart, Line Chart & Tables charts are used in this dashboard
• All three reports in a dashboard are using the common date, location and other filters

Show More Show Less

Description

• Environment: Tableau Desktop & SQL Server
• It shows users logs in different dimensions based on projects, regions and duration in the tabular form
• It consists of various dimensions as filters for all the reports in the dashboard

Show More Show Less

Description

• Environment: SQL Server & SSIS
• Migrated C# script to SSIS packages which uploads data into centralized SQL servers
• Daily scheduled tasks uploads data from different location flat files in to snowflake SQL server tables
• Does many conversion and manuplation like Converts time column data from seconds/minutes to hours
• Error handler which ignores and eliminates rows from the source data and stores into different flat files

Show More Show Less

Description

Bureau Veritas is an international company specialized in the inspection, analysis, audit and certification of products, infrastructure (buildings, industrial sites, equipment, ship, etc.) and management systems in relation to regulatory or voluntary frameworks.

Show More Show Less

Description

Client is Europeans largest Banking services company, Headquarters in France. The object of this project is to provide application availability for users in Risk management, Trade processing and E-solutions. Its using tableau for reporting to escalate the IT service desk to Resolve Issues. To know daily, weekly, monthly, quarterly and yearly emergency incidents & High priority incidents. I implemented end to end reports and Dashboards by using tableau.

Show More Show Less

Description

J.P. Morgan provides investment banking services to governments, corporations, institutions and individuals. The object of this project is to create reports and user tools for CIB FX and Risk departments. Its using tableau for generate the score cards for higher management. It also using Excel automation for other daily, monthly, quarterly and yearly reports with in the bank. I implemented end to end reports and Dashboards by using tableau. And excel automation

Show More Show Less

Description

Show More Show Less

Description

Show More Show Less