Farkhanda Asma
Skill Score
Seasoned Professional (4/6)
Finance Tech
Solution Architect at Cibc

I am a Solution Consultant who loves building AI Products. I completed Udacity’s AI Product Manager Program. I recently developed a Nanodegree Program in Google AutoML that lets AI Modeler to train Model for different Data Sets.It generated data by calculating Prediction & Recall. I’d love to combine my passion for learning and teaching with my software development skills to continue building personalized learning products for Multiple Industries.

Evaluated for Director of Product and Technical PM role archetype
Performance by Category
Top Skills
Metrics definition Listening Database structure Negotiation Writing and presentation Market analysis Product roadmap System design API integration Data retrieval Performance tracking Relationship building
Skill Progression

Solutions Consultant

Advisory BI Analsyt

Project: BBCP
• Used Informatica ETL Tool for the creation and implementation of metadata Extract from Oracle and SQL as data source.
• Scope, plan, develop and implement a variety of reports to create workspace for dashboards using Cognos Business Insight..
• Developed Multidimensional package for different business scenario in BBCP Project with IBM as Vendor.
• Design TM1 Front for users and calculate at child level after connecting with multi data source for Business Users.
• Used Multi-dimensional & Star Schema for designing the Cube in Transformer Modeling.
• Created Filter and Join in FM in order to have different set of Data for different type of reports.
• Used Drill through definition, Master Detail and Combination of Charts in Report Studio and Query Studio.
• Monitor report usage and speed to attain the highest level of achievable performance.
• Significant experience and understanding of IBM Cognos Administration to be integrated with current requirement of company.
• Experience with development of a BI solution as part of application development using Cognos Business Intelligence Suite.

BI Consultant

Project: CPIN
• Experience in Framework Manager for development including dimension and facts tables.
• Define User Roles according to business need and apply security for reports and packages.
• Translate business requirements into Technical Design Spec mapped data fields into report requirements using in Cognos 10 Report studio.
• Experience with OPS including the Enterprise Architecture process and required deliverables.
• Perform analysis, design, programming, testing, and walkthroughs Testers for reports.
• Produce unit test cases with different business scenarios and perform test execution.
• Participate in knowledge transfer within the team and with our technology partners.
• Develop ETL Package in Informatica to bring data for reports in Data warehouse using SQL and database skills e.g. modeling, scripts.
• Experience in Quality Assurance methods and Power Designer for data modeling.
• Experience with development of a BI solution as part of application development and deployment having formal change and release management processes

Product & Solution Manager

CIBC Bank, Toronto, ON, 2013 to Present
 Enterprise Product & Solution Manager

  • Experience in managing large programs and projects across multiple organizations and partnering with multiple disciplines with strong written and verbal communications and interpersonal/team skills
  • Support and strengthen database stability for cross-functional teams by overseeing an enterprise DBA team tasked with managing various Oracle, Netezza, PostgreSQL, databases.
  • Align objectives and bridge communications with IT personnel to certify all enterprise portfolio roadmaps and infrastructure projects as well as align roadmaps and projects, such as the timely migration of Oracle to Netezza DB to a new platform, with IT infrastructure and operations.
  • Oversee all aspects of Application, such as operations, upgrading, upstream & downstream and managing over 15 direct resources.
  • Implement Integration & Movement of dataCalculation via Feed hub, Secure Gateway, Cognos Command Center and Autosys.
  • Deliver dynamic leadership and training to on-shore and off-shore Development teams in order to prepare Product Solutions and collaborate architects.
  • Reduced job queue and enhanced SLA management for critical jobs by optimizing workload management through the development of over petabyte size db. framework based in best practices.
  • Minimized incidents and facilitated change management efforts by restructuring Application solutions for SAS, Congo’s, 10K+ ETL jobs, and various teams.
  • Spearheaded full-scale Netezza upgrades with new data compression techniques through effective DBA team management, resulting in extended storage shortages in DB platforms.
  • Prioritized successful and efficient patch deployment aimed at protecting critical systems from daily threats by coordinating and managing a team.
  • Enhanced job processing, storage consumptions, and SLAs by incorporating columnar database solutions (BLU).
  • Liaised with a Development team to facilitate management of unplanned work through a data-driven waterfall & Agile culture.

SAP BI Analyst

• Crystal reports Migration & repository object with historical instances (PDF, Excel) from BOXI Windows environment to BO 4.0 Linux using Import Export wizard in BO 3 and Upgrade Management Tool in BO 4.
• Set up TNS connection in Linux box and configure Crystal report services, Life Cycle management services and connectivity services.
• Created .biar File to Promote crystal report 2011 changes in BO 4 using LCM.
• Developed new Crystal reports using existing Business Views repository object, calendar and categories.
• Created Business foundations, Business Elements and Business View using Business View Manager.
• Created Users Group to setup different type of securities.
• Developed relation database universe and cube base universe using BOBJ universe designer.
• Reports migration of existing and new report has been deployed to production successfully by providing migration documentation.

BI consultant

B1 Interface
• Using Data Manager/ OLAP Technique for the implementation of metadata from Excel, Oracle and SQL 2008 as data source.
• Design Active reports in Cognos connected with multi data source.
• Used Multi dimensional & Star Schema for designing the Cube in Dynamic Cube.
• Created Filter and Join in FM in order to have different set of Data for different type of reports (HR, Finance).
• Used Drill through definition, Master Detail and Combination of Charts in Report Studio and Query Studio.
• Significant experience and understanding of IBM Cognos Administration to be integrated with current requirement of company.
• Providing technical expertise in the design, implementation, and maintenance of BI functionality, interoperability and ongoing administration and support of Cognos 8 or Cognos 10 infrastructure.

BI Consultant

B1 Interface
• Lead technical implementation of universe designing, development and training of current Team.
• Being Business Object analyst and other functional area experts define business requirement in order to design, refine and optimize data structure and sources to integrate SAP BW with BOBJ and create report.
• Create Users Group to setup different type of security.
• Developed relation database universe and cube base universe using BOBJ universe designer.
• Create and schedule report in web intelligence 3.1 and crystal report 3.1 from relational DB.
• Develop Dashboard using BOBJ Xcelsius 2008
• Schedule Webi documents for Business User in Info View.

Programmer Analyst

ETL Foundation
Involved with different projects to design, develop, implement and maintain ETL components for the sales data mart to provide analytical information. A data Mart was built with sources including MS SQL.
Interacted with Business Analyst to understand the business requirements.
Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, and Mapping Designer.
Extensively involved in Fine-tuning the SQL Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
Participated in the detailed requirement analysis for the design of data marts and star schemas.
Built SSIS packages to extract source data, transform it, and load it into destination fact and dimension tables. Utilized custom components and maximized performance and maintainability by using new features available in SQL Server Integration Services. Implemented SSIS best practices.
Migrated from Cognos based Cubes and reporting to a MS SQL 2005 based data warehouse. Rebuilt cubes in Analysis Server 2005. Provided standard reports using SQL Server Reporting Services and implemented ProClarity based analytical reporting solution.
Migrated DTS Package to SSIS package for best performance using Business Intelligence tool.
Schedule jobs using SQL Server 2005 Notification Service.
Resposible all developement in SAP BOBJ Tools e.g. Crystal report, Webi, Universe Designer, Xcelcius, Explorer, Live Office
Support Cognos
Leading a project called BI road Map as Project Manager.

Claims /Disability Web Services

Designed Policy, Claim, Health, member XML Web Services to call base Web Services using Visio.
Developed business logic layer to call XML Web Services asynchronously using Visual studio .Net.
Developed .Net classes to implement asynchronously using Visual studio .Net.
Documented Business and Development process for developed XML services.
Implementation into live environment.

Software Developer

Degree Programs

Master’s degree, Computer Science

Licenses and Certifications

Certified SAFe® 5 Agile Product Manager

Big-Data and Hadoop Developer

Big Data Professional