Shafeq Ahmed

Operational Risk Overview (ORO) Deck – This is an automation of several major applications data into a management deck from applications such as scenario Analysis, Risk Capital, Revenue, loss capture, lcaps and Key indicators to be correlated and perform different levels of aggregation and applied analytics on data to depict information in form of dashboard and canned reports for senior management review

• Architect, design and create Schema objects and developed tableau and MicroStrategy & Tableau logical data model by identifying and creating attributes, hierarchies, facts, metrics, filters, prompts, drill maps, custom groups, consolidations, auto styles, search objects, transformations and templates using tableau, MicroStrategy Desktop and Web
• Architect, Design, and Development of reporting requirements with designing of dashboards
• Analyzing data in both application and reporting databases and solving the discrepancies Data cleaning, data visualization, detection of missing data and Skewness, correlation analysis using heat maps, principal component analysis and model development were performed on the data
• Perform data mining and build statistical models on data, perform qualitative and quantum data analytics, and derive predictions on data behavior
• Experienced in different types of data modeling, like- star schema modeling, snowflake modeling and created joins according to the data model Schema between tables
• Managed multiple systems which includes Tableau maintenance, performance monitoring, tuning, capacity analysis and operation support
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs
• Least users
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server, and MS Excel
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
• Experience with data analytics and check on data accuracy to make sure data follows histogram and box plot model and apply various regression techniques on data
• Perform data mining, build statistical models, and apply analytics on data
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users
• Experience going through outlier's data and derive a conclusion on whether an outlier is valid or can be masked
• Perform data quality checks manually and an automated way to ensure reports and dashboard reflect accurate information
• Experience going through outlier's data and derive a conclusion on whether an outlier is valid or can be masked
• Generated advanced reports in Grid, Graph, and SQL mode, consisting of data analysis by combining a template with filters using MicroStrategy Desktop and Web
• Create multiple Classes and Objects and logically grouped the Dimension, Detail, Measure and Conditional Objects in tableau and similarly create subsequent attributes, facts and metrics and conditional filters on micro strategy level
• Create SQL and PL/SQL code for complex data structures to get data in a usable format to meet reporting requirements
• Create logical tables in micro strategy to achieve complex requirements to show highly aggregated data
• Conduct user training on micro strategy for application usage for their ad-hoc reports generation
• Environment: Tableau Desktop2021.2/7/9.0, Tableau Server, Tableau Prep, MicroStrategy9.4.1/10.2 (Architect, Desktop, Web, Administrator, Distribution Services), Object Manager, Integrity Manager, PL/SQL, SQL, Oracle11g/10g, python, HIVE, Impala, Bigdata, snowflake, memsql, Windows XP, UNIX (Red Hat Enterprise Linux6.0)

Loss Capture Reporting – Operational Risk system is built to align the best of class finance standards based on GOC, reporting covers the entire Citi organization at an aggregate and at business unit

Fraud Risk Management – Reports on different indicators data on various level and show trending of each indicator's month over month

• Architect, design and developed MicroStrategy logical data model by identifying and creating MicroStrategy attributes, hierarchies, facts, metrics, filters, prompts, drill maps, custom groups, consolidations, auto styles, search objects, transformations and templates using MicroStrategy Desktop and Web
• Created Schema objects Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project
• Experienced in different types of data modeling, like- star schema modeling, snowflake modeling
• Created joins and relationship according to the data model Schema
• Created intelligent cubes, scheduled and automated the cube refresh process
• Conducted meetings to gather user/business requirements and also carried out quality reviews with the Users and created documentation for the same
• Designed Templates and Filters to generate reports in grid and graph mode
• Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report
• Identify and modified source tables and columns in the warehouse required creating the Microstrategy project
• Generated advanced reports in Grid, Graph, and SQL mode, consisting of data analysis by combining a template with filters using Microstrategy Desktop and Web
• Skilled in assisting Tableau desktop users on dashboard design issues, performance challenges, query optimization to meet customer SLAs
• Worked with the respective SMEs to help the team in designing application specific tableau sites, project and security with operational standards
• Migrated data with object manager and project merge wizard
• Used Integrity Manager to verify report SQL's and validate report data between different environments to uncover inconsistencies and discrepancies in the results sets and different formats generated by MicroStrategy after object migration and system upgrade
• Developed risk assessment dashboards for KPI (Key Performance Indicator) like assessment unit and coverage ratio
• Created consolidation objects and custom groups, especially custom group banding to diversify reporting functions
• Used passthrough functions like ApplySimple function, metric-metric qualification, and relationship filter to build complex reports
• Administered the Business Users and Groups and Assigned Privileges accordingly in Central Management Console
• Extensively used Business Objects Designer to create, maintain and modify Universes for different business groups
• Created Multiple Classes and Objects and logically grouped the Dimension, Detail, Measure and Conditional Objects
• Created Derived Tables at the Universe level to reduce complexity
• Defined Cardinalities, performed Integrity Check and established Joins to maintain Data Integrity
• Set up Application Level, Folder Level Securities on various users and groups using Central Management Console
• Implemented Semantic layer overrides like Row and Object Restrictions in Designer
• Linked universes using Kernel Approach for linking universes
• Used tableau LOD detail calculations, User Filters, Parameters, Calculated Fields, and Groups wherever necessary for Instant Analytics
• Created both Full Client and Thin Client Reports using Multiple Data Providers
• Responsible for creating complex Crystal Reports like View-On-Demand reports, Ad-Hoc reports, Frequency reports, Summary reports, Subreports, Drill Down, Dynamic Grouping, Cross-Tab Reports etc.
• Created and maintained a variety of Canned/Ad-Hoc Reports using Desktop Intelligence, Web Intelligence XI/6.x and Crystal Reports2008/XI
• Combined Queries using Union, Intersect and Minus in creating reports
• Environment: Tableau Desktop2021.2/7/9.0, Tableau Server, Tableau Prep, Business Objects XI3.1/3.0 PL/SQL, SQL, Oracle11g/10g, memsql, MicroStrategy9.4.1/10.2 (Architect, Desktop, Web, Administrator, Distribution Services), Object Manager, Integrity Manager,Tableau Desktop, Tableau Server

• Claims Data Mart: Workers compensation insurance claims project for tracking claims, policies, and legal data
• Supported Business Objects landscape with a user base of1300
• Supported Business Objects versions include BOBJ XIR3.1/4.0
• Strengths include the development of audit plan and customized audit reports for BOBJ reporting infrastructure and Data analysis on Oracle, DB2 and SQL server databases
• Hands on experience in multiple migration projects, which includes application and system migration of BOBJ environment from XIR3.1 to4.0 and Oracle based universe
• A significant level of experience managing Business Objects servers and related content administration
• Involved in Data Modeling, Design of Data Mart using Star Schema and Snowflake
• Involved in writing SQLs to validate the data coming into the reports/dashboards
• Worked with ETL team to understand the details of load process, so that we can build reliable and efficient reports
• Used functionality in Designer like the creation of universe based on stored procedure using multiple parameters, the creation of customized LOV's based on security and delegate search, the creation of customized dynamic cascading prompts, table level row-level security for user groups with different functionality requirements, combining database functions in universe objects
• Extensively worked on the maintenance of complex universes
• Development includes Universe creation, final, intermediate, web /desk / crystal reports creation and development of Live dashboards using BI Web services, QAAWS, and Live office
• Proposed, reviewed and assisted in the implementation of dynamic dashboards using QAAWS
• These queries are used in Xcelsius to dynamically fetch the data from DB2 database
• Liaison with SAP Business Objects technical support on product limitations and configured the product as per the capabilities and expectations of end user's
• Created Xcelsius Visualizations and published them to business objects Enterprise, which showed key performance indicators graphically
• Created Dashboards using static data from Excel as a data source
• Also retrieved dynamic data using multiple options such as query as a web service and Live office
• Designed, Implemented and managed the User groups and formalized the process of creating corresponding groups for each new application and the process of creating new users in Business Objects CMC
• Setup the Security at the Folder level and at the Group level in the Central Management Console
• Managed Row Level Security at the universe level using designer
• Worked on personal lines audit reports explaining their user activity and session activity for higher management
• Environment: SAP Business Objects XI4.0/3.1/XIR2/XI, Xcelsius2008, Crystal Reports2008, QAAWS, DB29.2, SQL Server2000, Windows XP/2000/2008.Oracle10g, MS-Access, Informatica8 & SSIS for Dashboard

• The Longview Budgeting and Forecasting Tool is an annual and monthly budgeting & forecasting processes
• The tool is highly configurable and will be customized to meet Finance's needs via configuration
• Out-of-the-box web services, mapping tools and scripting support in the application's “Modeling Node/Application Framework” will support data imports, exports, and error-handling
• Budgeting and forecasting information will be viewed via internal dashboards and exported as-needed to CMS and the Data Warehouse
• Analyzed the logical model of the databases and normalizing it when necessary
• Involved in the identification of the fact and dimension tables
• Extensively used Informatica-Power Center9.1 for extracting, transforming and loading into different databases
• Wrote PL/SQL stored procedures and triggers for implementing business rules and transformations
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets
• Created Source and Target Definitions in the repository using Informatica Designer – Source Analyzer and Warehouse Designer
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Rank, Lookup, Stored procedure, Sequence generator
• Used Mapping Designer to create mappings
• Replicated operational tables into staging tables, to transform and load data into the enterprise data warehouse using Informatica
• Created and scheduled Worklets, configured email notifications
• Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse
• Documented Data Mappings/ Transformations as per the business requirement
• Performed testing, knowledge transfer and mentored other team members
• Environment: Informatica PowerCenter9.1, Oracle11g, SQL Server2008, Windows2008, SharePoint, Microsoft Visio

• Analyzed existing SQL queries to identify opportunities for improvements.
• Evaluated new technologies related to SQL development for potential implementation opportunities, facilitating innovation within the team''s workflow.
• Documented analysis results and provided performance improvement feedback.
• Worked closely with Quality Assurance teams throughout development to ensure a high level of code quality and adherence to requirements.
• Enhanced database performance by optimizing SQL queries and indexing strategies.
• Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
• Increased data retrieval efficiency by designing optimized views tailored to specific reporting needs of various departments within the organization.
• Performed regular database backups to prevent information loss.
• Developed in-house applications designed for company needs.

• Improved user experience, monitoring feedback and making necessary adjustments to software applications.
• Troubleshot critical incidents involving network outages or security breaches, swiftly implementing remediation plans to minimize impact on operations.
• Developed custom solutions for clients, tailoring technical specifications to meet unique needs.