Asmath Begum Shaik
Sr Software Developer
Summary
- 8+ years of experience in Data warehousing and Analytics experience in Oracle Business Intelligence (OBIEE), Oracle Data Integrator (ODI), OAS, BIP, Power BI and Qlik Sense.
- Hands-on experience in all activities related to the Development and Production Support of implementing for large scale data warehouses using ODI & OBIEE tools.
- Experience in Analysis and design and development including implementation of Business Intelligence BI Solutions using OBIEE Analytics.
- Worked along with the Business Analyst, developers, management professionals and with the business users from various locations of customers to gather requirements. Experience in dimension modelling such as start schema, snowflake schema, creating facts, dimension, and measures.
- Specialized in design and development of OBIEE repository, dashboards, reports. Experience in implementing the Oracle BI Security Setup (Application Roles, Groups, Users, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
- Experience in creating Hierarchies with drill-down capabilities using global & local Filters, creating static, dynamic and session variables. Extensively worked on Oracle Data Integrator (ODI) Topology manager, Designer, Operator and troubleshooting of the packages.
- Extensive experience in delivering load plans, packages and job scheduling, good knowledge in creating master and work repositories in different RDBMS products like oracle 11g.
- Good understanding on ODI navigators like Designer, Topology, operator and Security Navigator. Developed different Procedures, Packages, Scenarios and Load Plans in ODI.
- Creating Variables, Sequences, Procedures, Scenarios, Load Plans, Interfaces and Packages in ODI. Experience in handling errors with static and flow controls, designing temp tables, calculations, incremental runs...etc.
- Involved in Unit Testing, Peer Review, and migration process across different environments. Creating Qlik Sense reports, QVD files and scheduling in Qlik.
- Creating apps adding features through Qlik Extensions. Data modeling through joins between tables. Created Common filters, navigations, background images for Qlik reports.
- Complete knowledge on project life cycle. Good Basic Knowledge on UNIX Commands.
- Creating dashboards and visual interactive reports using Power BI Identifying KPIs with clear objectives and monitor them consistently/ Analyzing data and present it through reports that can help in decision-making.
- Converting business requirements into technical specifications and decide the timeline to accomplish tasks. design, develop, and deploy Power BI scripts and perform efficient detailed analysis.
- Performing DAX queries and functions in Power BI creating charts and document data with algorithms, parameters, models, and relations explanations using filters and graphs for a better understanding of the data defining and design new systems by analyzing current ETL processes making technical changes to existing BI systems to enhance their functioning.
Overview
8
8
years of professional experience
3
3
Certifications
Work History
Sr Developer -Oracle Hospitality Reporting Product
Oracle
7 2022 - Current
- Extensively worked on RPD and SA development from the scratch.
- Designed updates to existing RPD to meet changing customer demands.
- Managed software versioning using Git, enabling smooth collaboration among team members while maintaining detailed change records for future reference.
- Mentored junior developers, promoting a culture of continuous learning and knowledge sharing within the team.
- Optimized performance through testing and tuning of applications.
- Improved Query performance by identifying and resolving bottlenecks in backend code.
- Evaluated and improved development work of other developers on team, working to provide training, constructive criticism and knowledge transfer.
- Optimized datamodeling structures, resulting in faster query processing times and improved data integrity.
- Conducted data modeling, performance and integration testing.
- Proved successful working within tight deadlines and a fast-paced environment.
Sr Associate Consultant - GE Appliances
Infosys Ltd
12.2019 - 07.2022
- Extensively worked on OBIEE report and Dashboards
- Extensively worked with onsite team to get the requirement and get the clarifications if we required any inputs on the tasks
- Analyzing logs and troubleshooting the issues
- Worked with users to provide quick fixes on UAT and PROD issues
- Migration of Objects across all the environments
- Designed various reports i.e
- Drill Down, Pivot, in Answers and Configured Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill down to detailed level Information
- Loading data from various sources involving flat files using Oracle data integrator
- Designed and conceptualized the extraction strategies and methodologies for data integrity
- Involved in the OCI migration
Software Engineer - Igloo
Forsys Software India Pvt. Ltd
07.2016 - 09.2019
- Extensively worked on OBIEE report and Dashboards
- Understanding requirements and customizing the Repository to meet the requirements i.e., Physical Layer, Business Model & Mapping and Presentation Layer level
- Created Drill down Hierarchies and implemented Business Logics and Facts
- Identified the Facts, Dimensions, and grain of the Dimensional model, and referential joins
- Designed various reports i.e
- Drill Down, Pivot, in Answers and Configured Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill down to detailed level Information
- Security – Over all security, Object Level security, OBIEE content and Data level security etc
- Involved in modification of local object mask to simplify the creation of more number of interfaces
- Involved in data quality analysis to determine cleansing requirements designed and developed ODI interfaces for data loads
- Loading data from various sources involving flat files and oracle tables using Oracle data integrator
- Reverse engineering the required tables for the development
- Designed and conceptualized the extraction strategies and methodologies for data integrity
- Designed and developed interfaces, packages, procedures, variables and scenarios
- Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware Housing OLAP Model
- Created master & work repositories and configured ODI connections for source and target using Topology
- Extensively worked with yellow interfaces to handle complex requirements
- Involved in production support activities
- Implemented Email alert to the DBA when an interface execution failure
- Development activities in ODI such as Interfaces and use of knowledge modules
- Extensive knowledge on using of Knowledge Modules
- Good experience on using the ODI commands like OdiFileMove, OdiFileAppend, and OdiFilecopy
- Debugging the master jobs and packages by using operator navigator
Software Engineer - Calix
Forsys Software India Pvt. Ltd
07.2016 - 09.2017
- Working closely with users to gather the requirement and participating in the client meetings
- Training the Business Users in Ad hoc reporting
- Customizing & developing RPD, Configuration of Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports)
- Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table)
- Creating new users/groups and providing the access to the respective reports/subject areas
- Monitoring the OBIEE Services (Dev, QA, UAT and Production), Agents, Help Desk Ticket System and Emails for the user tickets
- Migrating the RPD and Web Catalog across all the Environments (Dev, QA, UAT and Production) based on business requirements
- Migrating the User Accounts among multiple environment (Dev to QA, QA to UAT and UAT to Production)
- Bouncing the server’s whenever it is required
- Understanding business requirements in the BI context and design data models to convert raw data to meaningful insights
- Creating dashboards and visual interactive reports using Power BI
- Identifying KPIs with clear objectives and monitor them consistently
- Analyzing data and present it through reports that can help in decision-making
- Converting business requirements into technical specifications and decide the timeline to accomplish tasks
- Design, develop, and deploy Power BI scripts and perform efficient detailed analysis
- Performing DAX queries and functions in Power BI
- Creating charts and document data with algorithms, parameters, models, and relations explanations
- Conducting data warehouse development
- Performing SQL querying for best results
- Using filters and graphs for a better understanding of the data
- Defining and design new systems by analyzing current ETL processes
- Making technical changes to existing BI systems to enhance their functioning
Education
M.Tech -
Priyadarshini College of Engineering
B.Tech -
Sri Raghavendra Institute of Science And Technology
Skills
OBIEE 11g & OBIEE 12c
Certification
Oracle Cloud Infrastructure Foundations, 2021
Projects
- HGBU- Oracle Hospitality Reporting and Analytics product, Oracle Ltd, Hyderabad, OBIEE Developer, Sep 2022 – Till the date
- GE Appliances, Infosys Ltd, Hyderabad, OBIEE/ODI Consultant, Dec 2019 –Jul 2022
- Igloo Inventory and Shipment Management, Forsys Software India Pvt. Ltd, Hyderabad, OBIEE Developer, Sep 2017 – Sep 2019
- Calix, Forsys Software India Pvt. Ltd, Hyderabad, OBIEE/ODI Developer, Jul 2016 – Sep 2017
Languages
English
Telugu
Hindi
Timeline
Sr Associate Consultant - GE Appliances
Infosys Ltd
12.2019 - 07.2022
Software Engineer - Igloo
Forsys Software India Pvt. Ltd
07.2016 - 09.2019
Software Engineer - Calix
Forsys Software India Pvt. Ltd
07.2016 - 09.2017
Sr Developer -Oracle Hospitality Reporting Product
Oracle
7 2022 - Current
M.Tech -
Priyadarshini College of Engineering
B.Tech -
Sri Raghavendra Institute of Science And Technology
Similar Profiles
Paige DedmanPaige Dedman
Consultant at OracleConsultant at Oracle
Debabrata DashDebabrata Dash
Consulting Member of Technical Staff at OracleConsulting Member of Technical Staff at Oracle
Sijith VJSijith VJ
Principal Software Engineer at OraclePrincipal Software Engineer at Oracle
Mykola LaznikMykola Laznik
Senior Software Engineer at OracleSenior Software Engineer at Oracle
Phani Subhash KancherlaPhani Subhash Kancherla
Senior Consultant at Infosys TechnologiesSenior Consultant at Infosys Technologies