Senior Solution Architect
Current• Assist team in gathering business requirements, document them and get sign-off.• Analyzing, creating, manipulating, and organizing database systems.• Perform source system discovery and data analysis.• Create BI reports that help businesses make strategic decisions.• Functional and Technical specification documents.• Design relational and dimensional Enterprise BI data models.• Development and testing of ETL Informatica Mappings and optimization.• Installed and Configured OBIEE 11g, OBIA 7.9.6.2, DAC11g and Informatica 9.0.2.• Analyzed and redesigned existing complex PL/SQL packages in to Informatica ETL mappings.• Developed reusable mapplets, transformations and tasks for data cleansing and audit purposes across the team.• Used Unix scripting to archiving and Ftp-ing the files to other interface.• Develop OBIEE 11g repository and build Reports/Dashboards/iBots/Agents for users.• OBIEE Administration - Security, Configuration, and Maintenance (manages web catalog objects, archive/unarchive, set permissions and ownership, start/stop server, deploy RPD, etc.).• Design Physical, Business Model and Presentation layers; define logical views and physical data Security structures.• Document technical work and create operational manuals.• Design, Develop & Monitor production interface jobs through Datawarehouse Administration Console (DAC).• Perform software system upgrades and maintenance.• Database administrations to ensure optimal performance of ETLs & Reports.
