Data Architect / Data Modeler / BI Architect / Technical Architect Resume

SUMMARY:

Over 17+ years of experience in analysis, database architecture, database design and database modeling in various business intelligence, data warehouse, data integration and application implementation projects.
Gathered business requirements and translated them into technical requirements. Created business and system use cases for demonstrating the process and behavior of the application.
Known as a quick learner, have experience in understanding existing database models and structures and processes between systems by performing intense data analysis.
Worked on projects which require data migration from one database to another database.
Experience in creating conceptual, logical & physical models for operational systems, data integrations and data warehouse projects.
Experience in dimensional Modeling using Star and Snowflake schema methodologies.
Wrote functional and technical design specifications and source to target field mappings between systems as per the industry standards and followed the client methodologies.
Experience in High - level design and low-level design documentations.
Experience in writing Source to Target mappings with complex data transformations
Acted as a liaison between various technology teams, support teams, and business units to analyze, document, review, and secure agreement on business/technical requirements.
Excellent understanding of Meta data management. Created and designed Meta data repositories.
Experience in working in master data management projects.
Planned and conducted review meetings with the Practice leads and peers.
Over 14+ years of experience in architecture, design and development of various ETL methodologies for data warehouse and data integration projects.
Experience in designing and development of complex ETL flows and reusable data transformations which includes slowly changing dimensions using Informatica Power Center and Power Exchange.
Experience in designing process flows from beginning to end of the schedule including complex dependencies.
Proficient in the implementation of Data Cleanup procedures, Stored Procedures, Scripts and execution of Test plans for loading the data successfully into the various types Targets (Relational and flat file)
Over 8+ years of report design and development experience.
Executed and performed in various business intelligence projects, data marts and operational databases.
Experience in designing and development of complex Crystal reports using database tables, stored procedure. Have experience in building business Views for Crystal reports.
Have experience in building Business Objects Universes and development of reports.
Managed and led a team of resources for building data integrations on timely manner.
Experience on travel to overseas for business data analysis. Have worked on projects involving on-site/offshore model.
Have excellent understanding of business process. Established and Ensured development standards and best practices throughout the life cycle of the project.

TECHNICAL SKILLS:

Methodologies: Data Warehousing Business Intelligence OLTP, OLAP Master and Meta Data Management Integration & ETL/ELT Methodologies Conceptual Modeling Logical & Physical Modeling Relational & multi - dimensional architectures and models ERD, UML Modeling Agile/Scrum Methodology

Systems Applications: Power Designer Erwin v7.x/4.x/3.x Visible Advantage Quest Toad Informatica Power Center Informatica Power Exchange Crystal Reports Business Objects/Web Intelligence IBM Data Stage

Other Technologies: Oracle, DB2, Teradata, SQL Server, MS Access PL/SQL, SQL, NO - SQL, PRO*C, Shell Scripts, VB, ASP HP Unix, Sun Solaris Unix, Linux BKFS/LPS MSP, CSC ER, BKFS PM, Adage, CXL, EO, Oracle Apps, GEMMS, JDE, Aurus, PeopleSoft HR, PeopleSoft Finance, Unilab, Interspec, Demantra OBIEE/OBIA, DAC SAP HANA, Hadoop, Big Data

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship