PROFESSIONAL SUMMARY:

Confidential 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 short period of time.

EXPERIENCE:

Confidential, Washington, DC

Microstrategy Lead

Responsibilities:

• Mirrostrategy lead gather Business Intelligence requirement.
• Develop logical data model to support Microstrategy dashboards.
• Design and develop over 300 dashboards.
• Designd data drilling capabilities withing dashboards.
• Converted Microstrategy data source from Oraclele to SAP HANA. Design ETL process.
• Work as scrum master to facilitate design of Microstrategy dashboards using Agile method.
• Develop from concept of dashboard to working prototype in 10 business days.
• Involved in gathering requirements from the users and documenting the specifications.
• Developed Multidimensional Model, Logical Model by studying the source systems and business requirements.
• Provided solutions for complex Time Dimension related issues and analysis. Created Schema Objects Attributes, Facts for different MicroStrategy projects.
• Generated reporting object like Metrics, Filters, Prompts, Reports, Custom groups & Consolidations.
• Extensively used Micro Strategy Report Services to generate Report Documents.
• Created executive dashboards for high level management with KPI’s by presenting them in visually intuitive, easy-to-read, interactive documents.
• Used analytical and governing settings in Microstrategy VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Customized reports, Documents and deployed them to MicroStrategy web. Substantially worked on Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports. Built various Security Filters at the Group and User level to Limit data. Implemented row levl security.
• Developed scorecards and dashboards that provide users a highly graphical and summary view of key metrics. Created various schedules both Time and Event based to schedule History, Cache jobs on a daily and weekly basis. Involved in Installation, configuration and Administration of I-server, Web and Narrowcast server.
• Involved in the Unit, System and Integration testing across all the projects. Identified Object, Report and dashboard defects and entered defects into VersionOne portal and resolved them based on defect severity and priority.
• Worked with the DBA to do daily backups of the Microstrategy Metadata on a nightly basis.
• Involved in Administration tasks like creating users, assigning privileges, caching, specifying Query Governing Thresholds, and Report optimization.
• Created the Metadata & Statistic tables for the Micro Strategy projects on Oracle database.
• Worked with ETL team to collabarate on data warehouse loads for front end reporting.

Confidential, Washington, DC

Data Architect, Senior Microstrategy Developer

Responsibilities:

• 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

Responsibilities:

• 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, Suitland, Maryland

Data Architect

Responsibilities:

• 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, Washington, DC

Data Warehouse Architect

Responsibilities:

• 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.