Uploaded File
Asfandyar
Asfandyarrashid.bi@gmail.com
404-749-0281
10211 Arrow Creek Dr
Raleigh, NC 27617
Business Intelligence Developer
10 years experience W2
1
Recommendation
Average rating
153
Profile views
Summary

Experience
Business Intelligence Developer
Information Technology
Dec 2016 - present
Raleigh, NC
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Developed Perl and Shell scripts for upload of data feed into database
  • Developed reports in Perl for our end users
  • Created reports for the BI team using Sqoop to export data into HDFS and Hive.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Generate KPI for customer satisfaction survey results and disease management
  • Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
  • Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Experience as SQL Developer with extensive experience of analytical techniques.
  • Experience in writing SQL queries and optimizing the queries.
  • Performed data analysis and data profiling using SQL on various sources systems.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.
  • Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
  • Enforced Kanban principles as a scrum master that resulted in reduction of Cycle time by 20% thus increasing team's throughput in less than 8 weeks.
  • Coached new SM and trained global teams, which resulted in early delivery of project and reduced process waste caused by lack of common understanding.
  • Provides team leadership to ensure project tasks are completed accurately and within the time estimated.
  • Ensures that project and problem solutions meet the goals and objectives of the requesting departments.
SQL Business Requirements Data Analysis Oracle Scrum Business Intelligence Sqoop Tableau Scrum Master SQL Developer HDFS BI Developer Tableau Server Data Profiling Project Management Perl Shell Scripts
Remove Skill
References
Average Rating

0 recommendations
Business Intelligence Developer
Information Technology
Aug 2013 - Nov 2016
  • Created complex dashboards which uses BI service to feed the data into xcelsius from the source webi reports.
  • Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Created extensive custom joins for blending data from several different data sources.
  • Worked on workbook Permissions, Ownerships and User filters.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
  • Designed and developed standard reports, cross-tab reports.
  • Installation & configuration Of Qlikview Software.
  • Provide scripting support for the Analytics Department to meet complex business requirements
  • Worked on optimizing and tuning the Teradata views and SQL's to improve the performance of batch and response time of data for users.
  • Data analysis, Identifying deficiencies in business systems. Modeled all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and employee roles, timestamps and location.
  • Built leadership dashboards using Tableau to help drive multiple focus initiatives such as First Call Resolution, and agent schedule adherence.
  • Created visualization for logistics calculation and department spend analysis. Connected Tableau server with share-point portal and setup auto refresh feature.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Conducted Study to Build Universe's Classes and Objects involving everyday terms that supports Users.
  • Object properties defining Measure, Dimension and Details were created using UDT and IDT.
  • Increased new product development from one to eight. Led repair of four legacy products.
  • Facilitated Agile Adoption Retrospective for the organization with the leadership and guided teams with outcome resulting in enhanced performance.
  • Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks that increased customer satisfaction.
  • Worked with Rally, Git, IBM Slack, note
Business Requirements Data Analysis Teradata Business Intelligence MapReduce Agile Methodology Data Visualization Tableau QlikView BI Developer BSA Tableau Server Git Xcelsius Tableau Desktop
Remove Skill
Business Objects Developer
Information Technology
Aug 2011 - Aug 2013
  • Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers, worked extensively with (@aggregate aware, @prompt) to overcome the problems with database when integrating with Business Objects Gathered Reporting Requirements and arrived at the Best Reporting Model using Business Objects teams.
  • Experience in creating universe using Designer for adhoc and canned queries Created Joins, checked the integrity of the universe and resolved loops and traps using aliases and contexts.
  • Set up aliases, contexts and short cuts joins by resolving loops, cardinalities and integrity checks of the universe, set up Aggregate Awareness to enhance the performance of SQL transactions.
  • Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
  • Worked on Teradata dual active systems project.
  • Hierarchies created based on business rules for viewing data at selected level of detail.
  • Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
  • Extensively worked with alerts, filters and conditions in Business Objects.
  • Designed universe for standard reporting and ad hoc reporting requirements. Involved in the extensive standards & guidelines documentation.
  • Reviewed and verified technical specification to meet user requirement and approved architectural and design documents.
  • Managed application development of an automated Medicare reimbursement posting system in an Oracle 9i, 10,11.
  • Drafted Technical Design Documentation for the reports created as part of dashboard design.
SQL Business Objects Oracle Project Management Teradata Application Development
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Information Technology
American Military University 2017
Attended in Computer Information Systems
SPSU 2014
Skills
Project Management
2021
5
Teradata
2016
5
Agile Methodology
2016
3
BI Developer
2021
3
BSA
2016
3
Business Intelligence
2021
3
Business Requirements
2021
3
Data Analysis
2021
3
Data Profiling
2021
3
Data Visualization
2016
3
Git
2016
3
MapReduce
2016
3
Perl
2021
3
QlikView
2016
3
Shell Scripts
2021
3
Tableau
2021
3
Tableau Desktop
2016
3
Tableau Server
2021
3
Xcelsius
2016
3
Application Development
2013
2
Business Objects
2013
2
Oracle
2021
2
SQL
2021
2
HDFS
2021
1
Scrum
2021
1
Scrum Master
2021
1
SQL Developer
2021
1
Sqoop
2021
1