Professional Summary

Mr. Muhammad Khan is an experienced ERP, Data Management, Data Warehouse, Data Mining and ETL Specialist with over 16 years of experience in high volume multiple database development, database design, modeling and management. Mr. Khan is an Expert Microstrategy Architect. Able to take out of the box Microstrategy and implement total BI Solution. Strong technical background in Data Warehouse, ETL, Business Intelligence BI , multi-language, multi-platform programming, re-engineering, Application Integration and Data modeling with expertise in project coordination, determination of scope, priority, project implementation, and training/development of IT staff. Proficient project and time management skills, able to implement projects on schedule and within budget. Successfully developed and deployed over 15 large data warehouse projects. Dependable, versatile performer with an in-depth understanding of Data bases architecture and operations. Mr. Khan has proven track record of taking very high level BI concept and translate them into proof of concept in

Experience

Confid ential

Data Architect, Senior Microstrategy Developer

• Technical lead for Data Acquisition, Data Quality and BI Reporting. Gathered Data Acquisition and Data Quality requirements. Helped client to evaluate new Business Intelligence technologies, features and products. Translated Data Acquisition and Data Quality business requirements to technical solutions utilizing Oracle Enterprise Data Quality and Oracle Application Express. Applied advanced data modeling and physical database design concepts in the architecture of a new data warehouse. Designed and implemented ETL solution to migrate data from 30,000 different sources Pension Plan data into one data warehouse. Configured Oracle Enterprise Data Quality EDQ tool. Created multiple process using EDQ to measure data quality. Created multiple processes using EDQ to Transform Data to meet PBGC data standard. Authored Technical design document for BCVS Benefit Calculation and Valuation Service project based on Functional Design Document. Designed and implemented eData Audit utilizing Oracle Application Express APEX . Created multiple Oracle Database Objects to automate data loading processes. Created logical and physical data model using Erwin data modeling tool. Designed ETL process to implement Change Data Capture CDC , Ragged Hierarchies and Slowly Changing Dimension.
• Responsible for providing alternate design solutions along with project estimates.
• Led proof-of-concept Microstrategy Reporting project. Created Microstrategy Preliminary and detail design document based on the business requirement. Created Conceptual data model, Logical data model and Physical data model. Created Microstrategy schema objects Facts, Attributes, Hierarchies, Transformations and Logical Tables . Created Microstrategy reports, documents and Dash board.

Confidential

Data Warehouse Architect/MicroStrategy Architect

• Technical Lead for Data Warehouse Project. Responsible for Architecture, Data Model, design, development and migration of data. Responsible for reviewing user requirements, reports specifications and create a data model Star Schema that can provide necessary consistent, clean and meaningful data. Responsible for Dimensional data model, database design, ETL design and review with ETL and reporting teams. Involved in performance tuning of ETL as well as reports and make sure not to create complex multi pass report that might impact Dashboard performance. Responsible for Unit testing, Integration Testing and User Acceptance Testing. Managed migration in different environments. Created weekly project status report for Senior Management. Developed and implemented long term Data Warehouse goals and Strategies. Delivered a quality product within specified timeline and verified that all requirements were met.
• Designed Oracle 11g Data Warehouse environment for Microstrategy reporting. Designed, developed and maintained Microstrategy Project. Created and updated Microstrategy schema as per requirement. Created Microstartegy reports and Dashboards. Developed ad hoc interface, enabling end-users to generate their own report. Utilized Microstrategy reporting tools to deliver data insight to different targeted user groups. Created Microstrategy Object Prompt. Configured Microstrategy VLDB properties to optimize reports. Created explicit table alias to resolve Microstarategy Attribute Role. Created Joint Child to resolve Composite Key issue. Implemented Microstrategy Security module to set up four layers of security. Implemented standardized data dictionary for enterprise reporting and OLAP analysis using Microstrategy Intelligent server. Troubleshot Microstrategy Dashboard performance issues.

Confidential

Data Architect

• Responsible for end-to-end analysis and delivery of BI/DW solutions. Analyzed existing system and prepared and presented impact analysis. Performed data analysis and database design and development as well as created and managed Entity Relationship Diagrams, Created Data Dictionaries, Mapping documents, System Design Document, Data Validation, data acquisition/conversion strategies, interfaces and data warehouse artifacts. Optimized data warehouse assets to ensure high performance and data integrity. Diagnosed, monitored, isolated and expediently resolved issues pertaining to data warehouse and reporting systems. Designed Star Schema data warehouse model. Designed and delivered data mapping and ETL from multiple source systems to EDW using OWB Oracle Warehouse Builder . The data was moved from landing, staging to EDW.
• Delivered numerous ETL process using Informatica. Researched and defined data sources and targets for 2010 Census Data Project. Defined Business Rule conversions and extensions to satisfy metadata requirements. Created Data Dictionary using Erwin. Mapped source data and Target data using Informatica Power Center. Transformed data using Informatica Power Center. Implemented Microstrategy Project. Designed logical mapping of data for Microstrategy. Created Microstrategy intelligent Cubes, Attributes, Facts and drilldown mappings. Tuned Oracle 11g database and Microstrategy Intelligent server.

Confidential

Data Warehouse Architect

• Developed the entire data warehouse for merchandise application and managed growth. Consulted with businesses and led project teams in major Data Warehouse and Re-engineering initiative for Department of State. Worked with business line to gather the needs and translated them into a Data Warehouse solution.
• Provided technical expertise to resolve database related issues and design problems. Coordinated development tools support, implementation and resolution of information flow issues. Managed Data Warehouse production environment, monitored Data Warehouse processes and identified, researched and coordinated the resolution of data anomalies. Managed the metadata and trained end users on applications, resolving basic end-user questions and ensuring complete knowledge and understanding.
• Added new functionality, worked with business and technical managers to design and develop reports using the Microstrategy tool set with multiple summary tables. Created and configured multiple Microstrategy Projects. Led data model and database design for data mart and OLTP requirement 3NF effort. Evaluated Informatica tool for ETL process. Developed custom ETL, OWB, and Informatica based ETL processes. Built logical and physical model of business entities. Developed ETL OWB process to bring data from legacy system. Coordinated development tool support, identified, researched and coordinated the resolution of data anomalies. Trained end-users on applications, resolving basic end-user questions and ensuring complete knowledge and understanding. Managed onsite/offshore development co-ordinate with onsite developers/leads.
• Performed Domain Modeling using ERWIN. Created conceptual, logical Data Modeling. Mapped source data and target data using Informatica Power Center. Transformed data using Informatica Power Center. Created Physical Data Model. Performance tuned Oracle Database and performed SQL Query tune. Conducted training program in Oracle database.

Confidential

Database Architect

• Created Oracle databases for two large departments, from planning and testing through production. Implemented backup and recovery procedures of databases. Created Data Flow document to design how data flows through all the Data Warehouse Structures.
• Created new databases, involving importing and exporting. Installed and configured database software for Oracle Application development environment. Responsible for Oracle logical and physical databases design, implementation, and maintenance. Reorganized databases and sized database objects to meet standards and improve performance 30 . Handled database tuning, application tuning, documentation, capacity planning and database security. Maintained Oracle database.
• Training, Certifications Publications
• Completed following courses from Microstrategy University for Microstrategy 9.3
• MicroStrategy Desktop: Reporting
• MicroStrategy Administration, Configuration and Security
• MicroStrategy Architect: Advanced Project Design
• MicroStrategy Advanced Data Warehousing courses
• Completed ICAgile Certified Professionals Training