KHIZAR ALI
San JOse,CA
Summary
Adaptable Architect brings more than 10 years knowledge in AEC team leadership, collaboration and technical knowledge. Tenacious and competent approach to supporting long-lasting designs according to federally issued mandates. Thorough understanding of critical design projects needs. Extends support for team-inclusive collaboration with knack for resolving conflict and keeping projects on track.
Overview
16
16
years of professional experience
Work History
VP Analytics Lead Architect
Bank Of America
08.2018 - Current
- Bank Of America is a leader in the banking Industry with assets all around the world
- Currently working on numerous projects
- Projects worked on include Sales and Performance Dashboards, SBA Calculator, Genesis Reporting (for Auditing)
- Worked closely with the business analyst team to collect and refine requirements
- Led a team of five developers, analysts and QA engineers, both onshore and offshore
- Managed the day-to-day activities of the team, including interactions with outside teams, to make sure we remained on time and on budget
- Participated in all agile (scrum) ceremonies, highlighted by helping our team improve their Performance in turning in deliverable in a timely manner
- Mentored Developers on how to create applications using MicroStrategy, Tableau and Power BI
- Trained Business Users on how to run basic reports on various platforms
- Optimized MicroStrategy reports by implementing intelligent cubes, adapting VLDB settings, fine tuning SQL
- This dramatically improved performance of reports on various documents by reducing load time by half
- Migrated objects across platforms, administered user security using security filters, monitored schedules
- Assisted in development of Ionic framework and Tableau apis
- Used R to apply ARIMA model in order to predict potential customer sales
- Tools Used: - Microstrategy 10.4, 2019, Autosys, Netezza, Tableau, Oracle Toad, JSON, Ionic, R-Studio, Power BI
- Strengthened communication skills through regular interactions with others.
- Adaptable and proficient in learning new concepts quickly and efficiently.
BI/Analytics Lead Architect
Disney Studios
01.2018 - 08.2018
- The Walt Disney Studios is an American Film studio, one of the four major businesses of and the Walt Disney Company main component of its Studio Entertainment segment
- Currently working with the Residuals team to assist in building reports for Cast Member Information
- Architected and developed reports that showed key metrics
- Created MicroStrategy objects including facts, attributes, filters, consolidations and custom groups
- Developed Views in PostgreSQL for Reports/Dashboards
- Worked with Angular developers to embed Microstrategy Platform into application
- Optimized MicroStrategy reports by implementing intelligent cubes, adapting VLDB settings, fine tuning SQL
- This dramatically improved performance of reports on various documents
- Tools Used: - MicroStrategy 10.2, PostGres, AWS, MS Excel, Tableau, Power BI
- Prepared detailed fee estimates used to coordinate with architect-engineering firms for design services.
- Verified construction documentation to meet client requirements and vision.
- Performed complex architectural and design assignments, applying innovative architectural design concepts and advanced professional knowledge.
BI/Analytics Architect
Data Meaning
, VA
01.2017 - 12.2017
- DataMeaning is one of the top BI Consulting companies in Eastern USA
- With its dedication to pure BI it is able to create a team and deliver a fast, visually appealing dashboard
- Currently working on various projects for Data Meaning
- Assisted in creating the Microstrategy World 2017 world mobile app
- For Microstrategy
- Microstrategy/ PowerBI Developer for Ryder
- Former Lead for Freddie Mac Servicer Team
- Created and assisted in creation of 8 dashboards
- Managed projects thru entire systems development life cycle, including creating timely/thorough status reports and status meetings
- Optimized MicroStrategy reports by implementing intelligent cubes, adapting VLDB settings, fine tuning SQL
- This dramatically improved performance of reports on various documents
- Created data source connections in Tableau to support reporting
- Developed numerous MicroStrategy attributes, facts, MicroStrategy Intelligent Cubes
- Tools Used: - MicroStrategy 10.2,10.4,10.5 rapid SQL, MS Excel, Netezza, Tableau, Power BI
BI Architect Lead
Amazon
Seattle, WA
08.2016 - 12.2016
- Amazon is the world’s largest E-Commerce company offering a wide variety of products to its members
- With fast growth and promise’s made to government to hire and diversify most of their workforce, Amazon created a team called HRBI to help gather the data necessary to make sure they are on track to keep their promise’s
- Architected and created numerous documents, dashboard and various schema objects
- Created 3 4-tier environments on the AWS cloud platform
- Worked with Business Analyst to gather requirements and also created documentation for the same
- Managed projects thru entire systems development life cycle, including creating timely/thorough status reports and status meetings
- Attended daily agile Scrum meetings to report progress and streamline project deliverable
- Configured all MicroStrategy components like MicroStrategy Desktop, Intelligence Server, Web and MicroStrategy Narrowcast Server on NT Servers
- Worked on MicroStrategy administration activities like addition of users, granting privileges, duplication of projects, object migration
- Tools Used: - MicroStrategy 10.2/10.4, OBIEE, Actuate, Oracle, Unix, MS Excel, Tableau, QuickSight
- Identified needed business improvements and determined appropriate systems required to implement solutions.
- Organized system operating procedures to strengthen controls.
- Enhanced interfaces to promote better functionality for users.
- Researched and adopted new technologies to add value to existing offerings.
- Produced charts and diagrams to assist with problem analysis.
Business Intelligence Analyst/Architect
Sears Holding
San Jose, CA
01.2015 - 08.2016
- Sears Shop Your Way, is a social CRM shopping platform offering members rewards for shopping at Sears and Kmart as well as with other retail partners across categories important to them
- EDW named ‘MAP’ was used as central repository for storing customer data from multiple channels
- Architected and developed numerous MicroStrategy documents, dashboard, Self Service BI and Visual Insight dashboards that reported key KPI for Competitor Density, customer traffic flow and Member Loyalty program
- Collected end user requirements by interviewing business clients
- Conducted white boarding sessions, wireframes and flow charts
- Attended daily agile Scrum meetings to report progress and streamline project deliverables
- Worked on data modeling in Teradata EDW for supporting MicroStrategy Schema
- Created a dashboard suite – ‘MPS’ which would give an overall and detail of many KPI such as Business Unit, Segments and Member Trend
- The report drill from top level KPI to customer level loyalty data
- Used MicroStrategy dashboard, widgets, graphs, Drill down
- Started a new dashboard with the team called “BAT” which focus on various KPI such as Transaction sales, Member vs Non-Member Sales, Channel Summary, Basket Detail ( which focused on % Penetration ) and top and bottom items
- Optimized MicroStrategy reports by implementing intelligent cubes, adapting VLDB settings, fine tuning SQL
- This dramatically improved performance of reports on various documents
- Created data source connections in Tableau to support reporting
- Developed numerous MicroStrategy attributes, facts, MicroStrategy Intelligent Cubes, MicroStrategy transaction services
- Migrated objects across platforms, administered user security using security filters, monitored schedules
- Tools Used: - Microstrategy 9.4/10.2 , Teradata, MS Excel, Tableau
MicroStrategy Developer/Architect
Citigroup Inc
Charlotte, NC
07.2014 - 01.2015
- Citigroup Inc
- Is a one of the largest banking and financial services corporation based in Newyork
- The project was to develop Basel 3 reporting solution for risk and capital management in domestic and international markets
- The project involved migrating from Qlikview to Microstrategy and creating a new portal integrated reporting suite
- Architected and developed reports and visually impactful dashboards using widgets that showed key risk metrics
- Created MicroStrategy objects including facts, attributes, filters, consolidations and custom groups
- Performed Administration tasks using Job Monitor, Command Manager, Object Manager and intelligent cube monitor
- Documented MicroStrategy Mapping to database model to support operations
- Migrated objects across servers using object manager
- Validated Reports by writing SQL queries in Sybase IQ database
- Participated in BI meetings to discuss future project scope
- Optimized multiple reports by implementing intelligent cubes, adapting VLDB settings, fine tuning SQL
- Dramatically improved the report run time and rendering
- Supported day to day operations by Troubleshooting Microstrategy reports, prompts, filters and templates in a timely manner
- Tools Used: - Microstrategy 9.4 , Sybase IQ, Unix, MS Excel, Adobe Flex
MicroStrategy Developer/Architect
Yum Brand
Louisville, KY
01.2013 - 07.2014
- Yum! Brands is the parent company of KFC, Taco Bell, Pizza Hut, A&W or Long John Silver's brands
- Worked in numerous projects that involved working with cross functional teams to gather reporting requirements and proposing cutting edge solutions
- Gathered business requirement documents by interviewing users and translated them to technical requirements
- Design data model and table structures in Netezza datawarehouse using classical snow flake schema to support business requirements
- Worked closely with ETL teams to understand data flow
- Made recommendations to make the reports more efficient
- Designed and built schema objects using MicroStrategy Architect
- Designed and created MicroStrategy dynamic dashboards for daily, weekly and periodic sales analysis
- Deployed MicroStrategy Intelligent cubes extensively for most of the projects
- Conducted POC to build Mobile applications for Regional Manager Support
- Used various visualizations and geo coding functionalities
- Created various narrowcast services and distribution services to deliver the files to users via e-mails as well as to the file locations
- Worked on implementing single sign on from portal environment to MicroStrategy
- Provided functional training to end users so that they could create adhoc reportrs
- Tuned and improved the performance of the dashboards using VLDB properties, database tuning and using cubes
- Developed personalized applications by using system prompt to secure data by role
- Created various MicroStrategy schema objects, prompted and non-prompted filters (including relationship filters) and metrics and consolidation and custom groups
- Created prompted as well as non-prompted freeform reports when the requirements could not satisfied by regular reports
- Proficient in writing pass through functions like ApplyComparison and ApplySimple
- Participated in BI initiative meetings to discuss the future project scope
- Participated in monthly release meetings to coordinate the Microstrategy reports release
- Created demo and training material for the users to display the Microstrategy office functionality
- Tools Used: - Microstrategy 9.3 and 9.2, Tableau, Netezza, Unix, Oracle, Nexus, MS Excel, Adobe Flex
MicroStrategy Developer/Architect
Best Buy
Minneapolis, USA
12.2011 - 12.2012
- BestBuy is one of the largest electronic retain chain in the country
- This project was to replace a legacy reporting process with state of the report reporting solutions
- Created around 25 dashboards
- Build Microstrategy mobile apps that used various visualizations
- Created design, developed and implemented multiple apps
- Wrote command manager scripts to automate administrative tasks like creating users and schedules
- Deployed adhoc environment to provide self-sufficient BI
- Administered Microstrategy environment by managing security, scheduling administration tasks, user creation
- Build numerous Schema objects, application objects , dashboard and documents to support business requirements
- Build dynamic cube environment
- This improved the overall performance by 25%
- Deployed Sales cock pit for Senior management which is a one stop shop for all reporting
- Tools Used: MicroStrategy 9.0.2 (Desktop, Web, Mobile) Command Manager, Teradata, Microsoft Excel, One Notes, Outlook 2010.
MicroStrategy Developer
Amica Mutual Insurance Company
Lincoln, USA
02.2009 - 11.2011
- Amica is the oldest mutual insurer of automobiles in the country
- Analyzed the business model to understand the existing systems and business requirements
- Communicated with the users to understand the requirements of dynamic dashboards and reports
- Worked with project manager for project scope, teamwork assignment and setting deadlines
- Created a standard template to be followed for object promotion
- Helped to establish standards for naming and formatting
- Helped to design the data model and architect the schema
- Made suggestions on aggregate tables and views for faster access of data
- Started a weekly meeting to brainstorm on any development issues and discuss any innovative solutions
- Designed layout of performance dashboard that would help managers and team leader to effectively manage their branches and teams performance
- Extended this dashboard to show countrywide data for executive review and setting targets
- Designed various prototypes of dashboards using Microstrategy which would give ability to the users to drill down to claim (lowest) level
- Designed reports, documents and templates to present the data in user friendly manner
- Improved the performance of the reports using VLDB properties
- Created relationship filters and advanced filters based on ApplySimple and ApplyComparison
- Created filters for getting 5 day work week using ApplySimple to resolve the issue where users would get blank reports on Sundays and Mondays
- Created filters to get previous year dates for selected current year dates to avoid re-prompting users
- Created custom metrics for various purposes like static text and count odd/even row number
- Created dummy custom groups to display static text on the reports
- Redesigned documents to simplify and to make them more easier to maintain
- Resolved issue with sending prompted documents through Narrowcast
- Troubleshooted problems with existing reports to resolve multiple issues
- Validated reports using Access database model, excel spreadsheets, mainframe, QMF and SQL Server
- Worked with datawarehouse team to resolve data issues
- Tools Used: - Microstrategy 8.1, DB2, SQL Server 2005, MS Excel, Claim Center, Mainframe, QMF, Access
MicroStrategy Developer
Bonton Stores, Inc, The Bon-Ton
Dayton, USA
01.2008 - 01.2009
- Stores, Inc
- Operates department stores under the nameplates of Bon-Ton, Bergner’s, Boston Store, Carsons, Pirie Scott, Elder-Beerman, Herberger’s, Parisian, and Younkers
- Worked on data modeling for creation of schema for the new project
- Created different objects including facts, attributes, filters, consolidations and custom groups
- Designed prototypes and created dynamic dashboards for improved marketing analysis
- Worked with users to reassess the requirements and use of prompts for better performance
- Participated in a team for MapInfo integration to display the sales and weather information on maps
- Created security filters for access control
- Created drillable reports for advanced analysis
- Trained the microstrategy team to design and maintain dynamic dashboards
Education
Bachelor of Accounting and Information Management -
UT
Masters - AI and Machine Learning
Colorado State University
Microstrategy Certified Analyst. -
Skills
- TECHNICAL SKILLS:
- Tools Used:
- MicroStrategy 104/102/94, MicroStrategy Desktop, MicroStrategy Mobile, MicroStrategy Web, Microstrategy Intelligence server, Tableau 90, 10, 2018, 2021, Power BI , R-Studio
- Databases: Netezza, Oracle , SQL Server, Teradata, DB2 95/9/1/8, Vertica, Aster Data, My SQL, PostGres
- Languages: SQL, T-SQL, PL/SQL, R
- Data modeling Tools: Toad data modeler, ERwin Data modeler, Embacadero
- Tools: SQL loader, SQL
- Plus, Toad, Queryman, Nexus, DB Visualizer
- Web servers: Apache Tomcat 31, IIS, Impala
- Operating Systems: Window 7/vista/XP/2003/NT/98, MS-DOS, UNIX, LINUX
- Office Tools: MS Excel, Access, Visio, PowerPoint, Word
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
You only have to do a few things right in your life so long as you don’t do too many things wrong.
Warren Buffett
Timeline
VP Analytics Lead Architect
Bank Of America
08.2018 - Current
BI/Analytics Lead Architect
Disney Studios
01.2018 - 08.2018
BI/Analytics Architect
Data Meaning
01.2017 - 12.2017
BI Architect Lead
Amazon
08.2016 - 12.2016
Business Intelligence Analyst/Architect
Sears Holding
01.2015 - 08.2016
MicroStrategy Developer/Architect
Citigroup Inc
07.2014 - 01.2015
MicroStrategy Developer/Architect
Yum Brand
01.2013 - 07.2014
MicroStrategy Developer/Architect
Best Buy
12.2011 - 12.2012
MicroStrategy Developer
Amica Mutual Insurance Company
02.2009 - 11.2011
MicroStrategy Developer
Bonton Stores, Inc, The Bon-Ton
01.2008 - 01.2009
Bachelor of Accounting and Information Management -
UT
Masters - AI and Machine Learning
Colorado State University
Microstrategy Certified Analyst. -
Similar Profiles
Yaquelin GuevaraYaquelin Guevara
Relationship Manager Business Owner Specialist at Bank Of AmericaRelationship Manager Business Owner Specialist at Bank Of America
Nicholas ShakanNicholas Shakan
Vice President, Portfolio Manager at Bank of America Private BankVice President, Portfolio Manager at Bank of America Private Bank
DEVI SITHDEVI SITH
Operations Consultant at Bank of AmericaOperations Consultant at Bank of America
AUSTIN MONREALAUSTIN MONREAL
Relationship Banker at Bank of AmericaRelationship Banker at Bank of America
Brandon Zaragoza-UribeBrandon Zaragoza-Uribe
Journeyman Sheet Metal Worker at Paragon Mechanical Inc.Journeyman Sheet Metal Worker at Paragon Mechanical Inc.