+1 (415) 644 5123
+44 1253 335595
+91 9875 492266
Gulam
Mumbai
,
India
Lead Consultant with Tableau, SQL, SSIS, VBA, Macros & C# experience
18000 USD / Year
-
Immediate: Available
9 Years
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...
- 5+ Years of experience into VBA, macros, dashboard and Excel automation
- Good leadership skill, providing training to new joiners, mentoring the team, task management, stake holder management, daily standup, weekly catch up and monthly updates with team and stake holders.
- Good experience on Tableau to create the user interactive reports & dashboards.
- Having Very good Experience in creation of Table Calculations, functions, Filters, calculation fields, parameters, reference lines, bins, sets, groups and hierarchies by using tableau
- Creating interactive reports and dashboards from Primary and secondary data sources (Data blending).
- Experienced in exposing the Views by using Dual axis.
- Being visualized the Business data into Charts like Dough Nut, Pie, Tree map, Packaged Bubbles, Text tables, Lines, etc
- Have very good experience as a site administrator and creating users, groups, projects, site roles, schedules and subscriptions in Tableau.
- Being Extracted data from multiple data sources and maintaining them as tde, twb and twbx files.
- Very good Experience in SQL server database and SSIS packages
- Proficiency in creating tables, views, stored procedures, triggers, indexes, functions and writing complex queries in SQL Server
- Having experience of performance tuning in Tableau and SQL Server
- Proficient in analyzing the Business Requirements, User Requirement Specifications (URS), Functional Requirement specifications (FRS)
- Good experience in ServiceNow ticketing tool to release the application in UAT and production server following Change management
- Tools Documentation, demonstration and presentation
Skills
Positions
Portfolio Projects
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
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
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
Verifications
-
Profile Verified
-
Phone Verified
Preferred Language
-
English - Basic
Available Timezones
BROWSE SIMILAR DEVELOPER
-
Chris M
Lead Full-Stack C# Developer
-
Abdel hadi A
Web apps Senior Software Developer
-
Danny J
Principal Software Engineer
-
Alexei K
Erlang and Java software engineer
-
Philip L
Expert Design, Development, And Deployment Of Mission Critical Applications Across Most Platforms.
-
Richard K
Senior Software Developer
-
James N
Experienced .NET Software Engineer
-
Mikhail B
Sr. Software Engineer
-
Thamil S
Project Manager
-
Mark O
Web builder with React/node plus Flask python Data Science