SUMMARY:

• A Total of 10 Years of experience in IT/HR. Around 5 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,,HRM and Government Agencies .

TECHNICAL SKILLS:

Technology and Tools: 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, Networking.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington VA

EDW Data Modeler/Acting DBA/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
• 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, Arlington VA

EDW Data Modeler/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, Arlington VA

Enterprise Data Warehouse Data Modeler

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 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, 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, 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, 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 MKPI (Monthly Key Performance Indicator) for all Departments using a database system.
• Co-ordinate employee performance and appraisal programs
• Trend analysis on MKPI 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).

Confidential, Lagos, NG

Systems Support Engineer

Responsibilities:

• Planned, Configured and Managed Internet Café’s for clients
• Installations & Configurations of Software & hardware on desktop systems, laptops
• Installations & configurations of Dial-up internet access on systems, Routers, CPE.

Confidential, Ondo, NG

Network Analyst

Responsibilities:

• Planned and Implemented an Efficient Network (LAN, WAN & Security).
• Increased the Number of Clients on the Network (Wireless) from less than 100 to more than 150.
• Maintained Optimal Network Performance and Reduced Network Downtime.