SUMMARY:

A Total of 11 Years of experience in IT/HR. Around 6 years of extensive experience in the field of Data Analysis, Database Development and Design with more than 4 years of experience in Data Modeling and Design and developing solutions (Reporting Applications) in the Telecommunications/Financial industries,Healthcare,Education,HRM and Government Agencies .

TECHNICAL SKILLS:

SQL, SSMS, SQL SERVER 2008, SSIS, Python Scripting, TOAD, Brio Intelligence, Minitab, JMP, MS Office Suite, Advanced Excel, Advanced Access, MS Project, Visio, Project Management, SAP Order Provisioning, SAP Security, Oracle 11g/10g/9i, ERWIN Data modeling, Embarcadero ER Studio, Informatica Power Center 9.5, Informatica IDQ Analyst Tool 9.5.1, Clover ETL, IBM BPM, Visual Studio, Applications Development, Orange HRM Administration, Six sigma training, Networking.

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Data Architect

Responsibilities:

• Analyze functional and non - functional business requirements and translate into technical data requirements and create or update existing logical and physical data models.
• Create data models (logical) and DB designs (physical), using the organization’s approved Enterprise Data Modeling tool, that depict the business areas and systems in the organization to ensure the integrity of the business data is being maintained; in corporate applicable standard data elements (SDEs); ensure solutions are accessing the system of record for shared or enterprise data; and ensure adherence to technical DB design standards in accordance with the approved Enterprise Data Modeling and DB Design Standard.
• Refine existing data models of the Confidential ’s business areas and systems.
• Facilitate data modeling sessions, ranging from information gathering to model validation.
• Create the data architecture sections of the System Design Document (SDD) for development efforts.
• Provide requirements analysis support to development teams and educate project and development teams on the proper usage of the data structures.
• Analyze data access and modification requirements to ensure efficient data retrieval/ ingestion and optimal DB design.
• Perform DB design, review DB design from development team, and generate initial Data Definition Language (DDL), as needed.
• Design and develop a data migration strategy and source to target mapping to migrate the data out of the legacy systems into the relational DB.
• Provide optimal design for structured and non-structured data using SQL and NoSQL databases.
• Enhance DB performance from physical DB design perspective, such as creating indexes, defining constraints, linking tables, and partitioning tables.
• Provide technical advice and prepare technical documentation on data architecture related trends, issues, and tools and provide input into the agency-wide data architecture standards

Environment: ER Studio, Oracle 12c, SQL Developer, TOAD, MS Visio, MS Office, Windows, Agile(JIRA)

Confidential, Arlington, VA

Confidential Data Modeler/Data Analyst/Acting DBA

Responsibilities:

• Elicit and document Detailed Business requirements
• Source System Data Analysis, Data Profiling, Data Cleansing and Data Standardization
• Translate business requirements into conceptual, working logical and physical data models for Data warehouse and Data marts applications
• Design Dimensional Data Models for Enterprise Data Warehouse using Embarcadero ER Studio
• Create and maintain Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• Validate and update the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generate high-level data access documentation for processes
• Manage Logical and Physical Data Models in Embarcadero ER Studio Repository
• Design Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conduct all data model reviews as appropriate during project lifecycle
• Update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintain data model and synchronized it with the changes to the database
• Provide input to resolve data limitation and issues
• Performance tuning
• Create Detailed ETL (Extract Transform and Load) Specifications for Data Integration implementation.
• Perform Database access and maintenance activities.
• Attend and participate in information and requirements gathering sessions (JAD).
• Ensure that business requirements can be translated into data requirements
• Review Project Charter and provided input into project plan

Environment: ER Studio, Oracle 12c, SQL SERVER 2012, SQL Developer,OBIEE, SAS Data Integrator 9.4,Dataflux Data Management Studio 2.6, SQL Developer, MS Visio, MS Office, Windows, Agile(JIRA)

Confidential

Data Modeler/Data Analyst/Business Analyst

Responsibilities:

• Elicit and document Detailed Business requirements
• Translate business requirements into conceptual, working logical and physical data models for Data warehouse and Data marts applications
• Design Dimensional Data Models for Enterprise Data Warehouse using Embarcadero ER Studio
• Create and maintain Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• Validate and update the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generate high-level data access documentation for processes
• Manage Logical and Physical Data Models in Embarcadero ER Studio Repository
• Design Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conduct all data model reviews as appropriate during project lifecycle
• Update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintain data model and synchronized it with the changes to the database
• Provide input to resolve data limitation and issues
• Performance tuning
• Attend and participate in information and requirements gathering sessions (JAD).
• Ensure that business requirements can be translated into data requirements
• Review Project Charter and provided input into project plan

Environment: ER Studio, Oracle 12c, SQL SERVER 2012, SQL Developer,OBIEE, SAS Data Integrator 9.4,Dataflux Data Management Studio 2.6, SQL Developer, MS Visio, MS Office, Windows, Agile(JIRA)

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Translated business requirements into conceptual, working logical and physical data models for Data warehouse and Data marts applications
• Designed Dimensional Data Models for Enterprise Data Warehouse using Embarcadero ER Studio
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated high-level data access documentation for processes
• Managed Logical and Physical Data Models in Embarcadero ER Studio Repository
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintained data model and synchronized it with the changes to the database
• Provided input to resolve data limitation and issues
• Performance tuning
• Attended and participated in information and requirements gathering sessions (JAD).
• Ensured that business requirements can be translated into data requirements
• Reviewed Project Charter and provided input into project plan

Environment: ER Studio, Oracle 12c, SQL SERVER 2012, SQL Developer,OBIEE, SAS Data Integrator 9.4,Dataflux Data Management Studio 2.6, SQL Developer, MS Visio, MS Office, Windows, Agile(JIRA)

Confidential, Reston, VA

Enterprise Data Modeler/ ER-Studio Admin

Responsibilities:

• Translated business requirements into conceptual, working logical and physical data models for Transactional, Data warehouse and Data marts applications
• Designed 3NF and Dimensional Data Models for Enterprise Data Warehouse using Embarcadero ER Studio
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated high-level data access documentation for processes
• Managed Logical and Physical Data Models in Embarcadero ER Studio Repository
• Performed ER Studio Repository Administrative tasks.
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintained data model and synchronized it with the changes to the database
• Master data management
• Provided input to resolve data limitation and issues
• Performance tuning
• Attended and participated in information and requirements gathering sessions (JAD).
• Ensured that business requirements can be translated into data requirements
• Reviewed Project Charter and provided input into project plan

Environment: ER Studio, Oracle 12c, SQL SERVER 2008 R2, TOAD, MS Visio, MS Office, Linux, Windows, Agile(Rally)

Confidential, Reston, VA

Enterprise Data Modeler

Responsibilities:

• Translated business requirements into conceptual, working logical and physical data models for Transactional, Data warehouse and Data marts applications
• Designed 3NF and Dimensional Data Models for Enterprise Data Warehouse using Embarcadero ER Studio
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated high-level data access documentation for processes
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintained data model and synchronized it with the changes to the database
• Master data management
• Provided input to resolve data limitation and issues
• Performance tuning
• Attended and participated in information and requirements gathering sessions (JAD).
• Ensured that business requirements can be translated into data requirements
• Reviewed Project Charter and provided input into project plan

Environment: ER Studio, Oracle 11g R2, SQL SERVER 2008 R2,TOAD, MS Visio, MS Office, Linux, Windows, Agile(Rally)

Confidential, Reston, VA

Application Data Modeler

Responsibilities:

• Translated business requirements into working logical and physical data models for Transactional, Data marts applications
• Designed 3NF Data Models for Enterprise Data Warehouse using Embarcadero ER Studio
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated high-level data access documentation for processes
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintained data model and synchronized it with the changes to the database
• Master data management
• Provided input to resolve data limitation and issues
• Performance tuning
• Attended and participated in information and requirements gathering sessions (JAD).
• Ensured that business requirements can be translated into data requirements
• Reviewed Project Charter and provided input into project plan

Environment: ER Studio, Oracle 11g R2, SQL SERVER 2008 R2,TOAD, MS Visio, MS Office, Linux, Windows

Confidential, Cedar Rapids, IA

Data Analyst/Data Modeler

Responsibilities:

• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated high-level data access documentation for processes
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur
• Maintained data model and synchronized it with the changes to the database
• Master data management
• Provided input to resolve data limitation and issues
• Performance tuning
• Attended and participated in information and requirements gathering sessions (JAD).
• Ensured that business requirements can be translated into data requirements
• Reviewed Project Charter and provided input into project plan

Environment: Erwin, Oracle 11g, IBM DB2,SQL SERVER 2008 R2,TOAD, MS Visio, MS Office, Linux, Windows

Confidential, Akron, OH

Database Developer

Responsibilities:

• Designs and codes software components, units, and modules that meet product specifications and development schedules primarily using MS Access and/or Visual Basic.
• Supported and enhanced Microsoft Access applications programmed with extensive Visual Basic customizations.
• Ensure daily and nightly SQL Server jobs run accurately and to completion.
• Monitored transaction activity, system utilization or load levels. Prepare and/or review status, progress and performance reports.
• Performed overall administration, performance tuning, backup /recovery.
• Performed Access database upgrades as needed for improvement and maintenance of the databases to include rollout and upgrades.
• Troubleshot and solved problems of SQL and Access development.
• Utilized data modeling knowledge to provide designs that will meet performance and scalability requirements.
• Ensured data integrity on the applications developed. This included a deep understanding of Relational Database Management principles to logically design normalized relational data models and table structures.
• Performed Testing and debugging of assigned components and units.
• Wrote and updated technical documentation such as user manuals, system documentation, and training materials.
• Maintained effective working relationships with internal customers and external contacts.

Confidential, Akron, OH

Process Improvement Engineer Intern

Responsibilities:

• Assisted with conducting cross functional review meetings and project report to stakeholders within all levels of the organization.
• Lean and Six Sigma Training, Participation in Kaizen events
• Gap analysis, CAPA initiation and execution
• Identified priority areas for improvements; improve quality systems and maintain compliance
• Statistical analysis, data trending, metrics and cycle time monitoring for decision making
• Business Excellence - Preventative management, people development, continuous training, innovation
• Continuous process improvement - Reduce waste, reduce downtime, increase cycle time, increase efficiency

Confidential, Lagos, NG

Human Resources-Information Systems Analyst

Responsibilities:

• Analyzed, maintained and troubleshot human resource information systems and other human resources computer applications and systems.
• Trained employees on systems and applications usage.
• Designed and Developed in-house applications to maintain employee data for analysis and reporting purposes(Excel, Access DB etc)
• Facilitated projects which impacted data maintenance on the HRIS, including mass updates.
• Planned and developed analyses, reports, and presentations.
• Acted as an administrator in creating security model based on functional responsibilities and configure HR system to enforce the security access to data.
• Assisted in analyzing appraisal results and make performance-based recommendations to Unit Head on placement, redeployment, training and career development
• Reviewed and provided Unit Head with report on manpower and skill requirements for all user groups/units
• Assisted in articulating and maintaining company-wide job descriptions for accuracy and completeness
• Collection & Collation of Confidential (Monthly Key Performance Indicator) for all Departments using a database system.
• Co-ordinate employee performance and appraisal programs
• Trend analysis on Confidential reports for staff promotion and appraisal, compensation and Management decision.

Confidential, Lagos, NG

Data Analyst/Workforce Management Analyst

Responsibilities:

• Developed and implemented a Performance Management Systems Application for the Back office (Resolution & Telemarketing Units) and the Call Center.
• Generated Daily, Weekly and Monthly Productivity reports for the prepaid call Center based on data gathered from Brio Intelligence Application.
• Forecasted and Planned based on historical data gathered over a period of time (interactive Volume, Average Call Handling Time etc.).
• Monitored Agents’ Daily adherence to schedule & Company policies & regulations using the Genesys Workforce Management Software/ Systems.
• Trend Analysis on Data captured by standard ERP tool (Siebel).