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 MoreSkills
Positions
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
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
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 LessDescription
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