Mohammad Asad

Joined as the divisions first data management employee, and established the data management standards as users increased from 50 to 1, 100, data increased from 8TB to 92TB, servers increased from 10 to 275, and data centers grew from 0 to 2. Ensured that all data is consistent, safe, and easily retrievable for world-class healthcare and medical research. Met or beat all budgets, and saved $2M to $12M every year.
• Increased the number of applications from 3 to >25, including Tableau, Confluence, Power BI, Clarity Console Server, Compass, Attunity, Data Brick, Azure, Logic Monitor, Idera, MS Ofice 360, Infobust, Caboodle, SlicerDicer, Calibra, and others.
• Managed the worlds largest implementation of Epic, and reduced its operating costs by 5% by providing >50 ideas to enhance the software, including how to upgrade (reduced the time from 20 hours to

Earned several gift cards for expanding the companys abilities to manage huge amounts of data as it grew >4x.

• Expanded data management from data in the U.S. to data in China, India, and Europe. Migrated, cleaned, and integrated it into an enterprise-wide source of business and operational intelligence.
• Enabled the company to be the first Oracle Exedata customer in the U.S.
• Decreased data loading times from >8 hours to 2 hours.
• Understood and documented business rules, output requirements, and data source. Ensured that data was accurate and consistent in all databases, including DBII. Used business rules for data profiling, data analyzing, and data cleansing.
• Developed physical and logical architecture and knowledge modules, using TOPOLOGY.
• Modeled the data warehouse in a multidimensional structure, using Snowflake.
• Optimized the entire data management infrastructure, including Sun Solaris, MS Windows, Oracle 10g, Oracle Data Integrator 10g (ODI), Oracle Business Intelligent 10g (OBIEE), AS400, PL/SQL, and PL/SQL Developer.
• Developed dashboards that provided 360-degree intelligence on business and operations worldwide.
• Created staging area and operational data store (ODS) for periodical data from several sources, including legacy databases.
• Created data warehouse objects, including fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, and dimensions.
• Installed and configured Oracle Database, ODI, and OBIEE. Created ODI interfaces and scenarios, and converted SSIS packages to ODI. Configured the OBIEE server, and created physical, business, and presentation layers in OBIEE>.
• Improved performance by optimizing queries and tracing the query execution plans.
• Maximized database and application security by creating users, roles, and rules.

Took on a major XML transformation after the previous consultant left in the middle of it, and finished on schedule.

• Created a tool for loading data in XML formats, and automated the process.
• Analyzed business rules, output requirements, and data source. Ensured that data was accurate and consistent in all databases. Used business rules for data profiling, data analyzing, and data cleansing.
• Developed physical and logical architecture and knowledge modules, using TOPOLOGY.
• Modeled the data warehouse in a multidimensional structure, using Snowflake.
• Optimized the entire data management infrastructure, including MS Windows, Oracle 11g, PL/SQL, Oracle Data Integrator 10g (ODI), Oracle Business Intelligence 10g (OBIEE), Oracle Application Server 10g, TOAD, and ER Win.
• Developed dashboards that provided comprehensive insights on business and operations worldwide.
• Created staging area and operational data store (ODS) for periodical data from several sources, including legacy databases.
• Created data warehouse objects, including fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, and dimensions.
• Installed and configured Oracle Database, ODI, and OBIEE. Created ODI interfaces and scenarios, and converted SSIS packages to ODI. Configured the OBIEE server, and created physical, business, and presentation layers in OBIEE>.
• Improved performance by optimizing queries and tracing the query execution plans.
• Increased database and application security by creating users, roles, and rules.

Worked as a systems integrator at the largest software company in Bangladesh. Began as a junior software engineer, and earned promotions up to the head of IT. Led systems integration and data management projects for clients in many industries, including telecom, finance, news, and transportation.
• Built a data warehouse for Telenor (IBCS-Primaxs first large global project).
• Implemented the first microcredit banking system in Bangladesh.
• Developed software for a major bank.
• Created infrastructure for a railroads ticketing system.
• Optimized the infrastructures for systems integration and data management, including Sun E25K, Sun Solaris, Oracle 10g, PL/SQL, Oracle Warehouse Builder 10g (OWB), Oracle Discoverer 10g, Oracle Enterprise Manager (OEM), and TOAD.
• Migrated the database and OWB from 10.0.1 to 10.2.0.
• Used business rules for data profiling, data analyzing, and data cleaning.
• Generated many business intelligence and analytical reports and a portal, using Oracle BI Discoverer and Oracle Portal.
• Installed, patched, troubleshot, baked up, and maintained Oracle Application Server 9i and 10g.
• Monitored ETL of data from legacy databases and flat files to the staging area and the data warehouse.
• Enhanced performance by optimizing queries and tracing query execution plans.
• Created users, roles, and rules to ensure security of databases and applications.

• Performed logical and physical data modeling.
• Normalized data and developed E-R model, using SD Pro.
• Created database schema, and implemented business rules via triggers. Created views, roles, synonyms, and grants.
• Developed several stored procedures and functions for database applications.
• Designed, developed, and implemented user interface screens, using Oracle Forms.
• Performed data migrations and data loads, using SQL*Loader.
• Maximized data and application security by creating users, roles, and rules.
• Designed, developed, and implemented reports, using Oracle Reports.

Prior experience as a database architect, data modeler, and PL/SQL and forms