SUMMARY:

• Over 15 years of highly technical experience in Information Technology and telecommunications areas for private, government, and non - profit clients in the US and overseas.
• Extensive experience in financial, telecommunications, service, and health industries.
• Specialized in Logical/Physical Database Design of OLTP systems, Operational Data Stores, Data Warehouses, and Data Marts, Data Conversion and Migration
• Excellent oral and written communication/presentation skills to both technical and non-technical people.

TECHNICAL SKILLS:

Data Architecture: Data Modeling / Data Architect / Data Warehouse / Data Analyst / Data Integration / Master Data Management / Data Strategy

Case Tools: Erwin, ER Studio, IBM Data Architect

Methodology: Hoberman, Ralph Kimball, Inmon

Databases: Redshift - AWS, Oracle11g, SQL Server, Sybase, MySQL, Netezza, MS Access

Languages: PostgreSQL, SQL

Other Tools: Visio, MS Project, Microsoft suite, QuickSight, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Church, VA

Data Architect / Data Modeler

• Conducted Business Analysis sessions with the client to develop Business Requirements, Data lineage, and objectives.
• Developed logical, and Physical models using Embarcadero modeling tool.
• Performed multiple data migration strategies based on integration strategies.
• Managed and maintained data dictionary and data lineage for all entities in the models.
• Developed user datatype, domains, and managed users in Embarcadero modeling tool.
• Performed Data Profiling, Data Quality and data tests working team of developers.
• Developed Star Schema by denormalization - Mapping Document, Audit Dimensions, including Aggregation.
• Developed Optimized Data Models for presentation layer for Amazon QuickSight and Tableau.
• Developed Story, Visuals, and Dashboards for both QuickSight and Tableau.
• Developed SQL scripts, and oversee deployment of databases.
• Developed naming Standards, Enterprise Data Dictionary, Abbreviations in the Embarcadero repository environment.

Confidential, Alexandria, VA

Senior Data Modeler/Analyst

• Performed requirement for new projects. Developed Conceptual, logical, and Physical models using Embarcadero modeling tool.
• Develop models on 3NF, Supertypes, Subtypes, and Abstraction.
• Managed and maintained data dictionary and data lineage for all entities in the models.
• Developed user datatype, domains, and managed users in Embarcadero modeling tool.
• Performed multiple data migration strategies based on integration strategies.
• Performed data tests working team of developers.
• Performed enhancement on existing models/Databases based on new requirement - developed enhanced models and DDLs.
• Developed SQL scripts, and performed numerous DBA functions in multiple environments.
• Developed naming Standards, Enterprise Data Dictionary, Abbreviations in the Embarcadero repository environment.
• Coordinated with Data Warehouse team with enhancement and new incentives.

Confidential, Fairfax, VA

Data Analyst

• Analyze business plans and strategies. Performed data analysis, analytics, and market research for various instruments.
• Analyzed the Historical data in the Legacy system to define architecture and strategy.
• Develop, update, and apply data models to generate reports and analysis.
• Retrieve, validate, format, and organize a variety of data from many sources.
• Conduct data analysis to answer standard or recurring inquiries and identify trends, correlation, and other relationships in data sets.
• As part of my technical improvement, attended numerous on-line training sessions for Data Modeling and Data Architecture.

Confidential, Alexandria, VA

Senior Data Modeler/Architect

• Performed Database model reviews based on enhancement of existing models. Reversed engineered existing models to add new entities and relationship.
• Supported development team with implementation issues. Worked with developers to ensure requirement and objectives were met.
• Performed analysis, user requirement for new projects. Developed Logical and Physical Models for new projects.
• Developed EDW Data Modeling Design standards and guide lines, Data Dictionaries, Source Mapping.
• Developed several star schemas for USPTO reporting group. Performed data model conversion from IBM Data Architect to ER Studio.

Confidential . Fairfax, VA

Data Analyst

• Analyzed business plan, marketing plan, marketing strategies and operational procedures Strategic Trader.
• Performed market research in the securities field. Performed data analysis, analytics, and market research for various instruments.

Confidential, W ashington, DC

Data Architect/ Data Analyst/Data Modeler and Business Process Analyst

• Developed Business requirement document for multiple projects. Performed data analysis, data profiling and data quality tasks.
• Developed Conceptual, Logical, and Physical Models for multiple projects.
• Designed Physical Models including EDW as well as Multi-Dimensional models with SCD and CDC concepts.
• Modeling Developed naming standard and Data Mapping document from source to Data marts.
• Developed strategy for MDM and Data Governance. The Environment is Embarcadero ER Studio and SQL Server.

Confidential

Data Architect and Business Process Analyst/ Project Lead

• Developed Conceptual, Logical, and Physical Data Models Enterprise-wide for all Confidential functional areas.
• Performed JAD sessions to identify all Processes/System/Data Entities.
• Reverse engineered and developed migration strategy for all manual forms, reports and other data sources into data models for automation.
• Identified areas for process Improvement and performed data quality profiling.
• Developed data strategies for Data Governance. Implemented Master Data Management for key entities to provide foundation for Enterprise-wide reporting.
• As part of the implementation, developed a scope/high level Project Plan to identify tasks and deliverables for implementation for Finance and Operations.
• Developed all reporting requirement and functional requirement for all reports.
• Developed multi-Dimensional schema for reporting purposes with Source-to-Target mapping. Developed all Queries for reporting.
• Developed test Plan, procedures, and test cases for end-to-end of data transformations to reports.
• The Environment is Embarcadero ER Studio, Netezza and Oracle.

Confidential, Falls Church, VA

Business and Data Analyst / Project Lead

• Developed reports to integrate hospital and private physician data based on services provided to patients at various locations for day-to-day analysis, and projection of new facilities and services.
• Demographic data was also captured for growth potential.
• Developed business requirement.
• Developed the conceptual, logical, and physical models based on Data Integration across multi-sources.
• Performed data profiling, data quality and data mapping (Source-to-Target).
• Developed functional requirement for reports. Managed the development and production of BI reports.

Confidential, Church, VA

Senior Data Warehouse Architect/Analyst/Lead (Security Clearance)

• Developed requirement for large historical dataset for the Confidential ’s TSA division.
• Performed data quality profiling for data completeness, integrity, duplication, validity in Oracle tables.
• Developed SQL, test procedures and generated reports concerning the above tests. Worked with ETL team to develop Data Dictionary and other data relevance information.
• Developed the data architecture, data models, Data mapping for Star Schema, and migration strategies to meet reporting requirement.