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.

PROFICIENCIES:

• Develop transactional and dimensional data models using E-R studio and Erwin.
• Define data requirements and designing databases to satisfy client business objectives.
• Participate in analysis, design reviews, and assisting with developing functionality to specific system components.
• Develop DDLs and work with DBAs to deploy in multiple Environment.
• Develop Data Modeling Design standards and guide lines, Data Dictionaries, and Naming Standard/SOPs
• Develop and lead the effort to collect, compile and analyze data, from various structured and unstructured sources, to perform statistical and usage analyses.
• Conduct Business Analysis sessions with the client to understand Legacy system, Conversion rules & objectives.
• Conduct detailed Data Profiling tests to check data consistency & quality.
• Perform accurate comparison of data between columns of source and target.
• Develop dashboards, scorecards, story, Trending charts using QuickSight and Tableau.

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 QUALIFICATIONS:

Confidential, Falls Church, VA

Data Architect / Data Modeler

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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 sessions for Data Modeling and Data Architecture.

Confidential, Alexandria, VA

Senior Data Modeler/Architect

Responsibilities:

• 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 Confidential reporting group. Performed data model conversion from IBM Data Architect to ER Studio.

Confidential, Fairfax, VA

Data Analyst

Responsibilities:

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

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

Responsibilities:

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

Data Architect and Business Process Analyst/ Project Lead

Responsibilities:

• 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

Responsibilities:

• 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, Falls Church, VA

Senior Data Warehouse Architect/Analyst/Lead

Responsibilities:

• Developed requirement for large historical dataset for the Confidential ’s Confidential 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.

Confidential, Falls Church, VA

Senior Data Architect

Responsibilities:

• Developed the Charter, Project plan, Roadmap, and Methodology for Computing Services Directorate (CSD) Data Management strategy project.
• Developed Functional - Process - System - Data map for an enterprise-wide Metadata.
• Analyze function - process map that enables CSD to improve its business processes.
• Developed the Conceptual, Logical, and Physical models.
• Developed Data Map and lineage, data interaction to manage data redundancy and data dependency that helped to develop a data impact analysis for an Enterprise Data warehouse.
• Initiated Enablers for Process Improvement, Configuration management, Data integration, and Data governance, and MDM.

Confidential, Centreville, VA

Technical Lead / Senior Business Analyst

Responsibilities:

• Managed the Production / Analysis / Design and enhancement of management reports for Confidential LLC.
• Developed requirements and preformed Analysis/Design and Implementation of Financial reports.
• Developed user requirement, functional requirement, Multi-Dimensional models, ETL data mapping, and design in the Multi-Dimensional logical and OLAP schema.
• Managed the pre and post deployment of reports.

Confidential, Chantilly, VA

Technical Lead / Senior Business Analyst

Responsibilities:

• Provided project management support and developed business requirement for data warehouse projects using JAD sessions and interviews.
• Developed the Functional Specifications document to capture all business descriptions and business logic.
• Developed process flows and data flows.
• Developed Conceptual, Logical, and physical Data Models.
• Performed the Profiling, Data Quality, Mapping for the Logical and Physical data model to support applications using Multi-Dimensional logical and OLAP schema.
• Managed the development of the ETL logic (Informatica).
• Developed test plan and test scripts for end-to-end testing of application. Managed a team of 12.

Confidential, Reston, VA

Business Lead / Financial Analyst

Responsibilities:

• Developed the business plan, marketing plan, marketing strategies and operational procedures for a start-up US securities trading company.
• Performed market research in the securities field. Assisted in the development of a portfolio of trading products.
• Managed the requirements definition and product development. Performed fundamental and technical analysis techniques. Skilled in the use and interpretation of a variety of investments tools.
• As part of a Business Process Outsourcing (BPO) project, managed the establishment of an overseas business unit.
• Developed, including the development of all requirements, evaluation/selection of technology platforms and implementation of systems and processes to allow real time trading on US exchanges.
• Recruited, trained and directed a team of market analysts to perform technical analysis and fundamental analysis of securities investment instruments.

Confidential, Arlington, VA

Project Lead/Business Analyst

Responsibilities:

• Managed the development of Data Warehouse in the Finance industry. Full-life cycle experience, including Requirement gathering, analysis, Extract-Transformation-Load (ETL), Data Warehouse Data modeling, and architecture.
• Developed the vision statement for strategy and architecture as well as provided solutions on all aspects of Data Warehouse for Ad-hoc query, OLAP and data mining tools.
• Performed Business Requirement, Project Management, Analyst and Design for Confidential
• Managed the development team responsible for web services and production as well as the development and websites for various businesses.
• Customers include maurinet.com, srm-consulting.com, a-sportsupplements.com, etc.
• The requirement was performed using RUP/Use Case methodology and development was mostly based on the Agile system development approach.
• Managed all the Web site planning, development, administration, and information content and administrative procedures to ensure integrity of website contents.
• Managed the development of internet and intranet system technologies.
• Managed the setup and implementation of new trouble desk reporting with a team of 5 staff in providing timely telephone, e-mails, system administration, and applications.
• Provided senior level support to Confidential Y2K project office in the areas of biomedical devices and consolidated mail-out pharmacy.
• Managed the entire Year 2000 life cycle in the Assessment, Renovation, Validation, and Implementation phases. Developed Access Databases for entire project management.
• Wrote briefing materials on a regular basis to present status, progress, and plans for congressional hearings and Government Audit Office, for issues with respect to Confidential Y2K.