Experienced in different business Intelligence tools and technologies e.g. Oracle BI (OBIEE)
Expertise in Advanced/Complex PL/SQL
Expertise building ETL processes from scratch
Exposure to BI tools (OBIEE and OBIA) with Oracle E-Business Suite as a source
Strong relational database modeling (SQL Server, Oracle, MySQL)
Experience with OBIA BI Apps ETL objects
Experience with BI Publisher, Oracle Data Integrator (ODI) and Informatica, MS SQL Server, Oracle, Machine learning
Good programming experience in C# .Net, VB.Net, Access VBA, Java, Servlet, ASP (.NET and Classic) Strong Database development experience in writing functions, procedures, triggers and views in MSSQL
Personal Strengths: Adaptability, Communication, Quick learner, Research, Innovation
Tools:
ETL Development (Informatica, Oracle Data Integrator)
BI Publisher (with Siebel CRM, Oracle EBS)
Data warehouse architecture
OBIEE Answers (Direct Database Request)
QlikView
CRM (Siebel, Zoho)
Data Mining (Oracle Data Miner, RapidMiner)
Business Intelligence (BI)
Designing and developing BI solutions and data models
Extracting, transforming, and loading (ETL) data from various sources into data warehouses or data marts
Creating reports, dashboards, and visualizations using BI tools like Oracle BI, QlikView, or Power BI
Performing data analysis, identifying trends, and generating insights to support decision-making
Software Engineering and Development
Designing, coding, and testing software applications using programming languages such as Java, C#, or Python
Applying software engineering principles and best practices for developing scalable and maintainable solutions
Utilizing software development frameworks and tools to streamline development processes
Collaborating with cross-functional teams to gather requirements, design solutions, and ensure successful software delivery
Database Management
Designing and managing relational databases, including schema design and optimization
Writing complex SQL queries to retrieve and manipulate data efficiently
Ensuring data integrity, security, and performance through proper indexing and database maintenance
Familiarity with database technologies such as Oracle, SQL Server, or MySQL
Data Integration and ETL
Extracting, transforming, and loading data from various sources into data warehouses or data marts
Implementing ETL processes using tools like Informatica, Microsoft SSIS, or Talend
Data profiling, cleansing, and validation to ensure data quality and consistency
Tools
Siebel Analytics 7.x
Oracle Business Intelligence
Informatica 7.x, 8.x, 9.x
Data warehouse Application Console (DAC)
PL/SQL
QlikView
Sisense Prism Business Intelligence
Siebel CRM
Zoho CRM
Oracle Data Integrator 11G/12.1.3
BI Publisher
Extract Data from OLTP perform calculation on data as Business need and load it in OLAP Develop graph, charts and other representation techniques to show data.
Development of reports and dashboards in Oracle BI Publisher
Develop ETL jobs as per business rules using ETL design document
Validated the report generated using PL/SQL queries.
Creating trending reports for senior management reporting such as annual and quarterly comparisons
Define best practices in Data Warehouse, Business Intelligence & Data Management.
Perform data modeling activities, data integration/ETL strategy, data conversion, and validation & migration strategies.
Participate in database design sessions with other developers.
Participate in daily mentoring activities of on-shore resources.
Design/develop testing processes to ensure end-to-end performance, data integrity and usability