fahmi hussain
Business intelligence Analyst/Developer · Lendistry
Work Experience
Business intelligence Analyst/Developer
Lendistry2020 – 2021
Primarily worked with business reporting and various KPI dashboards supporting the PA cares Grants and SBA lending processes. Provided insights to the lending team about the funding process directly resulting in 50% increase in funding number of loans. Additionally, developed audit processes for Lendistry which helped identify additional 20% increase in Billable Revenue for Q4 - 2020.
• Created Unified report to gain maximum insights and focus to the business. Reports helped to identify the performance of the loans in various sectors of the Lendistry business. • Created dashboards for Covid grants and provided insights into the various lending processes that were targeted towards various sectors for small business. • Created daily reporting for various finance reports and monthly reporting for investors.
Environment: Tableau 2021.1, Knime, PostgreSql, Excel.
Business intelligence Analyst/Developer
LoanMe2017 – 2020
• Design and implementation of KPI dashboards for the marketing team using Tableau. • Architected the reporting platform for various business operations including sales and marketing. • Worked on Cognos Dashboard and Cognos Reporting. • Worked on snowflake database for writing store procedures and Sql statements. • Creating reporting solutions using Cognos. • Worked on PostgreSQL and oracle, Sql Server databases. • Analyzed data trends across multiple business platforms to deliver impactful KPI and forecasting reports to the global marketing and finance teams. • Developed stored procedures for combining data sets to enable standardized reporting through the Tableau and DOMO platforms. • Developed data mappings across source and target applications based on common data reporting criteria to standardize reporting across diverse data sets and platforms. • Designed and implementation of Tableau functional reports based on what-if scenarios and business requirements. • Designed complex data sets to enable rich graphic visualization with drill down and drop-down menu options and parameters using Tableau. • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. • Generated Tableau dashboard with quick/context/global filters, parameters and calculated fields on Tableau (10.x) reports. • Performed analysis, unit testing and integrated testing with other applications of database like Oracle, Postgresql, Sqlserver before deployment to the production servers. • Developed database objects like tables, views, procedures using Oracle SQL to provide definition, structure and to maintain data efficiently. • Created different marketing KPI reports using calculated key figures using bin and parameters. • Implemented data blending to blend related data from different data sources like Tealium, Google analytics, Oracle, Salesforce, Heroku PostgreSQL. • Worked on Tealium for visitor's data and joining the data with other data sources by creating an ETL.
Environment: Tableau 10.x, Oracle 11g, SQL Server, Tealium, and Salesforce, DOMO,Cognos,Snowflake database.
Business intelligence Analyst/Developer
Mavericksoft Inc2015 – 2017
• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports. • Designed Universes, incorporating all the business requirements. • Implemented object level security universe to incorporate security for sensitive information. • Worked in migration of universe and reports between environments. • Designed universes, solved loops by creating aliases, contexts and resolved traps. • Created complex variables, breaks, sorts, filter and conditions for various reports. • Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries • Created multiple contexts for catering different functional areas in a single user query. • Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts. • Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns. • Generated various report templates for standardizing the reports throughout the organization. • Involved in developing the financial reports for the Finance Dept and successfully published the highly formatted reports and met with the end user requirements. • Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I XI R2. • Scheduled pre-canned reports through Scheduler for distribution and printing. • Understanding the requirements from business users. Suggested better ways of presenting charts, which were accepted and successfully implemented in the dashboards. • Leading Domo, Tableau dashboard project for sales commissions which included total sales, actual to quota. It involved multiple levels of hierarchies such as region, market, branch and territory.
Environment: Business objects 4.0, Tableau, Domo, SQL server 2012.
Business Intelligence Developer/Analyst
Hispanic Scholarship Fund2014 – 2014
• Interacted with various business team members to gather and document the requirements for Datawarehouse. • Modified and maintained Universes using Designer module to include objects like Dimensions, Details and Measures according to the Functional specifications. • Created new objects and classes in the Universe based on the report creation requirements. • Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity. • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
Environment: Business Objects XIR2, SQL server 2008, Salesforce.com platform.
Business Intelligence Developer/Analyst
Mazda2012 – 2013
• Leading the strategic design and maintenance of business intelligence applications. • Primarily responsible for data warehouse Identification, researches, support activities, issue tracking, escalation and resolution and reporting solutions. • Communicated needs of multiple business units across the company and co-workers to enhance customer satisfaction and ensure quality IT services and ensuring that the use of business intelligence applications enhances business decision making capabilities. • Communicated effectively with customers and co-workers to enhance customer satisfaction and ensure quality IT services • Performed technical upgrade of SAP Business Objects XI to Business Objects 4.0 including regression and validation testing, administration. • Developed various Charts, Graphs and drill down reports in WEBI. • Created bar charts, pie charts and exported them to power point, PDF and presented them in user meetings. • Worked extensively with the major functionality of BO like Ranks, Alerter, Variables, Formulas, Filters, Sorts, Query prompt, Hyperlinks in Webi. • Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView and designed and developed data models and backend queries for presenting data.
Environment: SQL Server 2008, Business objects 4.0, Business objects XI,Qlikview 3.0
Datawarehouse Analyst
Experian2012 – 2012
• Responsible for gathering requirements and data flow processes from subject matter experts • Analyzed functional problems and determined techniques and requirements most feasible for processing the data. • Collected historical and current business data to establish operational trends in the company. • Tested reports for accuracy and troubleshoot report issues including poor performance and bad data. • Testing ETl codes and create test plan to test the source data and target data. • Finalize Test plan/scenarios with business users.
Environment: SQL Server 2008, Informatica Power Center 8.6,Cognos 8.
Data warehouse Architect/Developer
City of Calgary2010 – 2011
Dimensional Modeling • Collected business requirements and defined the data model to better understand user engagement, designing the database and creating workflow for reporting of data within the Hansen environments. • Architect the data marts logical and psychical model to maximize query performance, maintain data scalability, and simple. • Was involved in project planning and management and data mapping. • Involved in Ralph Kimball's approach in which the data warehouse was modeled using a Dimensional Model/star schema. • Implemented the datamarts using Agile methodology.
Informatica Development • Developed the core ETL framework to load data and update dimension. • Created scripts in SQL for table creation and views for Source and Target tables In Oracle database. • Constructed maps using Mapping Designer in Informatica according to facts and dimensions involved. • Created reusable transformations and mapplets. • Extensively used Transformations like aggregator, router, joiner, expression, lookup, update strategy, and sequence generator. • Getting the source data from Oracle and loading into target oracle database. • Prepared the Logical Process Flow diagrams for the implemented mappings. • Created the Universe with relevant classes and objects in the designer. • Used Business Objects XI to create complex reports from universes using drill down, Slice and Dice capabilities.
Environment: Informatica Power Center 8.6, Oracle11g, Windows XP, Toad, Business Objects XI.
Informatica Developer
Walt Disney2008 – 2009
• Worked closely with the Business analysts for requirements gathering, designing the database and creating workflow. • Constructed maps using Mapping Designer in Informatica according to the business specifications. • Extensively used Transformations like aggregator, router, joiner, expression, lookup, update strategy, and sequence generator. • Created reusable transformations like Normalizer and Filter transformation to fulfill my requirement, which are further used by other mappings in the current project. • Created transformation like stored procedure. • Extensively used in setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager and used decision task, email tasks, etc.
Environment: Informatica Power Center 8.1.1, Flat files, Sybase, DB2, Windows XP, Putty and UNIX (AIX)
Education
Master of Computer Applications
Manonmaniam Sundarnar UniversityMaster of Computer Applications
Master of Science in Information Technology
Preston UniversityMaster of Science in Information Technology