SUMMARY:

• Oracle Data Warehouse Certified Professional with over 20+ years of experience in IT industry.
• 10+ years of experience in Data warehouse
• 20+ years of experience in Oracle
• 5 years of experience deploying, developing and supporting Oracle Identity Manager (OIM, OAM, OID) and its connector framework.
• At least 7 years of experience managing and maintaining Directory Services and LDAP
• At least 3 years of experience in Oracle Identity and Access Management Disaster Recovery
• 3+ years of experience in Oracle Financial Services Analytical Applications (OFSAA)
• 18+ years of experience in SQL Server
• Oracle Real Application Cluster Certified Professional
• Oracle Backup and Recovery Certified Professional
• Oracle Data Guard Certified Professional
• Certified Oracle Developer
• Implemented the Enterprise Architecture standards and processes, encouraging the different applications of standards across systems and organizations within the enterprise.
• Involved in Planning and designing data warehouse architectures.
• Supported the critical mission software applications, data, and interfaces for various agencies by Coordinating software changes and upgrades within agencies and vendors.
• Coordinated system performance and load testing for all major implementations, and worked with technical support to resolve system outages.
• Worked directly with departmental resources to determine needs, goals, objectives, and budget. Based on these needs, develop process and technology infrastructure requirements.
• Responsible for prioritizing, planning and managing complex ETL and data warehousing projects. Published operational dashboards and Visual Scorecards for the Client.
• Responsible for entire data feed for all the complex operational PeopleSoft and Data Warehouse systems (RMS, IMS, PPMS, WACTIS).
• Experience in Data Quality Architecture - Data quality standards, Data Profiling, Cleansing and Fuzzy matching for Customer and Product Data using tools and custom-built programs.
• Worked on variety of business Intelligence and reporting tools providing analytic, dashboard, mining and reporting functionality
• Expertise in ETL process design for data migration and continuous data extracts. Including experience of data centric application integration architectures
• Analyzed and refined systems requirements. Translated user requirements into Cognos, SAP BOBJ, OBIEE, SSRS and SSAS reports.
• Integrated hardware and software components. Wrote and maintained program documentation. Evaluated new applications software technologies and ensured the rigorous application of information security/information assurance, policies, principles, and practices to the delivery of application software services.
• Involved in installation, maintenance and porting of systems application software and approval of appropriate testing of new or modified systems software.
• Direct systems designers, engineers and programmers in the use of systems software and utilities as related to application programs.
• Developed performance plans to test the functions of complex information processing systems. Performed the necessary research and analysis to determine and document acceptable system performance thresholds.
• Applied technology to solve business problems whilst also being able to articulate complex concepts to a non-technical audience.
• Expertise in Modelling at Enterprise and Application specific level including conceptual and logical, using a variety of techniques and structures such as ERD, UML and XSD using a variety of modelling tools.
• Experience in the design of data governance frameworks to be embedded in the business. This is to ensure the sustainability and continued improvement of data management

TECHNICAL SKILLS:

Applications/Modules: SAP BW 3.5, BI 7.0, BI 7.3, SAP BI BOBJ 4.0, 4.1, SQL Server Data Tools (SSDT), Oracle ETL and BI

Databases: Oracle 8i, 9i, 10g, 11g, 12g, MS SQL Server

Languages: SQL, PL/SQL, HTML, ABAP, JavaScript, Node.js, HTML, Java

Methodologies: Catalyst

Operating Systems: MS Windows, UNIX, Linux

Software: Microsoft Office Suite, including MS Project, XML, Web Services, Microsoft SQL Server

Tools: Toad Modeler, Toad for Oracle, ODI, Informatica, OBIEE, Erwin, ER/Studio, SSDT, SAP BW/BI, SSRS, SSIA, SSAS, SQL Server Reporting Services(SSRS), COGNOS and OWB, ORACLE IAM SUITE

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Architect

Responsibilities:

• Daily administration of the Oracle, Informatica and MS SQL Server dbms (features, functions, & utilities), Cognos BI, OBIEE, SAP BOBJ, logical data modeling and physical database design using the ERWIN data modelling tools.
• Plan, Install, Configure, Manage and Troubleshooting Windows, Solaris and Linux Servers for databases.
• Provide production support for databases and data warehouses to resolve all production issues within SLA defined time frames.
• Plan, Install, Configure, Manage and Troubleshooting Oracle 10g, 11g and 12c databases on Windows, Solaris and Linux Servers.
• Install, configure and maintain the various virtual environments and VMs (Hyper V and VMware).
• Write Unix/Linux scripting, Windows batch scripting, SQL, PL/SQL for the data warehouse ETL deployment and processes.
• Use Apache Tomcat and JBoss to manage the various web applications tier and middleware tier
• Use OEM and App Dynamic to manage and support the supporting database applications and databases - 400 applications and 65 databases.
• Implemented the project planning and managing a full lifecycle COTS implementation of Identity Matching (Discovery through Production) using Initiate Master Data Service as subscriber data warehouse and identity matching engine and developed Solution Architecture pertaining to overall Enterprise and Business Architectural models.
• Duplicate Identity Cleanup - Implemented the identification and remediation of incorrect SSN data. Incorrect and orphan Identity data scrubbed and/or corrected prior to launch of automated provisioning application implementation. Responsible for the database tuning/query optimization, online analytical processing, metadata management.
• Validates that the Security solutions and Security architecture designs utilize the security components appropriately to meet Enterprise needs.
• Carry out semantics elicitation and information modelling activities by engaging with SME and appropriate business representative.
• Identified and modelled business processes including the documentation of business objectives and key performance indicators used to measure the extent to which the business objectives are being met as part of MI requirements elicitation.
• Responsible for end to end data design for the various functional areas within the Organization.
• Map data in logical data model to KPI's. Thereby identifying business data entities and attributes that represent events and transactions that occur and generate the data to be analyzed, in order to gain in-sight and to measure the performance of business activities.
• Analysis of how business processes define and consume data. What processes (create read, update and delete data). To ensure traceability between data and business processes.
• Created a multi-dimensional schema for the data mart and data warehouse.
• Supported enterprise Data Integration competency and participate in defining and refining data integration, data quality, ETL (Extract, Transfer and Load) architecture, processes and tools.

Confidential

Lead Data Warehouse Developer

Responsibilities:

• Lead on contract and change management, contract variation negotiation and approval. involved in Corporate strategic planning of the program.
• Developed, designed patterns for common problems to ensure consistency and quality of development. Implemented standards and changes to systems and processes ensuring design and development is in compliance with enterprise standards, processes and policies ensuring Data transformations are done correctly
• Collaboratively working with other groups by offering technical expertise where required. Provided consultancy on business innovative and improvement ideas and significantly contributes, through strategic advising, to the development of the long-term strategy for the Department. Identified and modelled business processes including the documentation of business objectives and key performance indicators used to measure the extent to which the business objectives are being met as part of MI requirements elicitation.
• Responsible for end to end data design for the Date warehouse projects.
• Member of the Enterprise Process and Data function. Embedded within IT and business projects, responsibility for modelling and designing enterprise wide data centric solutions whilst also helping to mature the enterprise reference architecture of the department.
• Involved in building of an integrated Business Intelligence system for the unemployed and grant system for the department nationally.
• Developed web/mobile application with Node.js, Express.js, MongoDB, JQuery, Haml, Angular.js, React.js, JavaScript as the Business Intelligence
• Built a web-based application using HTML5, CSS, JavaScript, JointJS, BackboneJS and Rappid. Rappid is a diagramming toolkit and is an extension for JointJS that implements UI and other features making it easy to rapidly create visual tools of various kinds.
• Implemented left side navigation which holding the images with additional functionalities as search, drag, drop and connect. Bottom partition represents a console view for running a set of live commands on deploying the connected diagram and Navigator control which facilitates huge connections.
• Implemented Save and upload functionality based on the saved JSON of the connected and saved nodes.
• Used HTML5 File API for providing user a way to select and upload a file functionality.
• Accessing and Updating the JIRA Bitbucket with the development on a daily basis as a version controlling tool to avoid conflicts.
• Developed modules for form validations and validating user input and throwing appropriate error messages based on the input.
• Applied client side validations using JavaScript and JQuery.
• Developed options for scrolling, implemented Modal windows for delete, upload and save actions.
• Resolving issues and updating the team about the progress following Agile methodology.
• The business objective was to increase performance and evaluation by better analysis of customer and policy data and to identify opportunities for delivering more effective marketing campaigns, such as targeting of new prospects, improving employment rate, better cross-sell/up-sell, and improved retention/attrition rates. Analyzed and documented the Key Performance Indicators to be reported on and analyzed by the BI solution, ensuring that it was aligned to the strategic balance score initiative.

Confidential, NJ

Lead Data Warehouse Analyst

Responsibilities:

• Lead cross organization SAP change management activities through stakeholder engagement, mobilization and the alignment of processes to support the to-be business architecture.
• Lead on the communication strategy and message, as well as other interventions.
• Responsible for managing the Enterprise Data Warehouse cadre training for end users.
• Worked on Enterprise Data Warehouse solution extension tickets for the Production Planning and Material Management functional area in SAP.
• Developed the web applications for the Business Intelligence with Node.js, Express.js, MongoDB, JQuery, JavaScript.
• Built a web-based application using HTML5, CSS, JavaScript, JointJS, BackboneJS and Rappid. Rappid is a diagramming toolkit and is an extension for JointJS that implements UI and other features making it easy to rapidly create visual tools of various kinds.
• Implemented left side navigation which holding the images with additional functionalities as search, drag, drop and connect. Bottom partition represents a console view for running a set of live commands on deploying the connected diagram and Navigator control which facilitates huge connections.
• Implemented Save and upload functionality based on the saved JSON of the connected and saved nodes.
• Used HTML5 File API for providing user a way to select and upload a file functionality.
• Accessing and Updating the JIRA Bitbucket with the development on a daily basis as a version controlling tool to avoid conflicts.
• Developed modules for form validations and validating user input and throwing appropriate error messages based on the input.
• Applied client side validations using JavaScript and JQuery.
• Developed options for scrolling, implemented Modal windows for delete, upload and save actions.
• Connecting with Rappid team in case of any issues, resolving them and updating the team about the progress following Agile methodology.
• Developed enterprise key performance indicator (KPI) dashboards and score cards, identifying performance tuning opportunities in the data warehouse.
• Worked on the LMP project in the Solution Delivery team participating in enterprise data warehouse de-signs, modelling of Info Cubes, Data Store Objects (DSO), Info Objects and multi providers.
• Designed solutions for Industrial Base Operation (IBO), Controlling and Finance with complex queries and web applications.
• Involved in requirement gathering, blue printing and realization of a BW implementation.
• Installed or transferred SAP business content objects to active versions. Designed an architected data warehouse to bring together from a heterogeneous source to satisfy business reporting requirements.
• Performed gap analysis between SAP delivered objects and client requirements to fit the development needs of the client.
• Participate in production monitoring including monitoring of daily loads of transactional data to the data warehouse and other scheduled master data loads
• Senior BI Resource in the BW 3.5 upgrade to BI 7, 7.3 and interfaced with the ECC 6.0 configuration team iteratively.
• Provided Gap Analysis, package selection, Functional and Technical specification for SAP BW related projects in ( Corporate Services Group?). Solve complex application issues including investigation, troubleshooting, on-going support and resolution in Project Participation in Business blueprint and Requirement Gathering Discussions with End Customer, Design and Development of Business Requirement &Technical Specification documents.
• Installed BOBJ Enterprise XI 3.1 SP2 and Fix pack 2.5 and SAP Integration Kit SP2 and Fix pack 2.5 on BOBJ Dev., QA and PRD systems.
• Built reports that have multiple display objects on a single page (tables and charts) in Web Intelligence for user friendly analysis of data.
• In WEBI used Calculations, Variables, Breaks, Sorting, Alerts, Prompts, slice and dice, and Drill down/up functionality for creating Master-Detail reports, Cross-tab reports related to the company’s Accounting and Financial Planning.
• Generated Canned Reports using BO Universe as the data provider. Configured QAAWS and Live office to Dash boards using Xcelsius
• Developed Executive dashboards using Xcelsius such as Net Sales, Revenue and Marketing.
• Developed Bex Queries on top of Info cubes for FICO, MM and PM Modules and on DOS for master data.
• Worked on Bex query restrictions, created Characteristic KF’S, Restricted KF’S and structures and Selection variables
• Used Single Sign on to set up users in SAP and BOBJ systems, and on security privileges such as Roles and Folders.
• Experience in Performance tuning on BOBJ and SAP BI 7.0 to 7.3. Migrated SAP BO Universes, Reports to Quality and Production Environments.
• Prepared end-user training document (UAT) and test plans in HP QC
• Worked on production support processes, process chain monitoring and resolution of process chain issues, supported weekly change control and transport processes and ticket resolution for over 20 super users and extensions of over 500 end users.
• Handled analysis, performance and tuning as part of system maintenance and stability. Using aggregates, partitions, query read modes, cache maintenance and parallel data loading. Identified bottle-necks, recommended different solution to provide low TCO, debugged and rectified errors, recover failed loads.
• Extracted and loaded data from ECC Sales Order Item data (2LIS 11 VAITM), Shipping Document Item data (2LIS 12 VCITM) and Billing Document Item data (2LIS 13 VDITM) for the SD module.
• Created Generic Extractors to load the data from the custom tables. Developed and maintained ABAP routines in Transformations and User Exits.
• Recommended and implemented changes in Client’s EDW Sales and Delivery (SD) processes resulting to a 50% post changes improvement.
• Extracted and loaded data from 3rd party source systems (Oracle & MS SQL Server) using DB Connect and UD Connect, Flat files.
• Created Start, Field and End Routines to populate the data into the Info providers and Created Process Chains to automate the data loading process
• Conducted migration of multiple BW 3.5 Data flows to BI 7.0 and 7.3 Data flows and Web templates from 3.5 to BI 7.0 and then to 7.3.
• Upgraded Routines from 3.5 Data flows to Routines in Transformations BI 7.0 and 7.3.
• Designed custom defined Cost Center Reports and SD Reports for Global Net Sales, Global Monthly Spread, Plan/Actual Periods, Analysis - Top N Vendors, Actual Cost Situation, and Analysis- Top N Internal Orders.
• Developed custom defined queries, query views and query elements; Free Characteristics, RKF, Business Content Variables, CKF, Exceptions and Conditions.

Confidential, Switzerland

Sr. Oracle Database Administrator

Responsibilities:

• Worked as the sole DBA in a team that is responsible for the development and support of the Global Positions Sheet (GPS) and the Risk Data Mart (RDM) for the wealth management and Business banking.
• The management of the database was carried out manually & also via the DBAPI utility which allows for standardization of DBA commands.
• Performed database Tuning, providing solutions, liaising with other groups like cc-oracle, performance tuning, monitoring, writing shell scripts and day-to-day administration & problem resolution.
• Worked in the Global Wealth Management & Business Banking Development Team. Responsible for tuning The Risk Data Mart (RDM) t database.
• Responsible for tuning the performance of the Global Positioning Sheet (GPS) globex re-ports as they have not been running within the agreed time limits.
• Being the only DBA in the team, provided support to the developers within the team with regards to application releases and sql tuning.
• Involved with providing production support for databases and data warehouses to resolve all production issues within SLA defined time frames.
• Liaised with other oracle teams with UBS to provide solutions to issues and problems that occur on the live databases. Worked within cross functional teams to resolves application issues.
• Responsible for configuring ASMM on the live databases to improve their performance.
• Involved in documenting procedures, processes and writing road map plans and work plans as well as writing documentation.
• Involved in the Solaris 10 migration projects which involves migrating 4 terabyte databases from Solaris 8 to Solaris 10 platform. The challenge here being how to migrate such a large database.
• Involved in project work which involves setting up Oracle PKI or applications in the Wealth Management & Banking Business group.