Over 6 years of experience in developing Business Intelligence applications using Power BI, Pentaho, SSIS, Tableau, OBIEE, Oracle ERP and EPM
Experience of working in AWS Services such as Amazon Redshift, S3, EC2, Data Pipeline, RDS, API Gateway, Lambda, Server less, Cloud Formation
Strong knowledge of Data warehousing methodologies, including Star and Snowflake schemas with implementation of slowly changing dimensions (SCDs)
Hands on experience of leading, designing, developing and deploying enterprise data warehouse solutions using 3-tier architecture
Proficient in working with T-SQL queries, Performance tuning, Stored procedures and development of Ad-hoc Reports
Experienced in data processing (SSIS), Dimensional Data Modeling (SSAS)
Having knowledge of Big Data Technologies like Hadoop, Spark etc.
Functional domain experience involves Retail, Banking and Financials
Working in offshore/onsite model and engaged in direct communication with client
Systems Limited is one of the largest software houses and IT enabled services providers of Pakistan working since 1977.
Worked on multiple projects, whose information is found under project section
Responsibility:
Performed Cloning and Patching of Oracle EBS R12 and Hyperion Planning application
User/Group creation, provisioning, role assignment and management using Shared Services
Coordinate and provide technical solutions and expertise in a variety of Oracle EBS R12 application areas and technologies including Workflow, Forms, Reports, XML publisher, Procedures, Form Personalization, PL/SQL and Linux scripting
Handle problems relating to different modules of Oracle Financials (General Ledger, Payables, Fixed Assets), Oracle Inventory and Purchasing
Development and integration of new reports, also maintenance of existing Oracle reports, changing and updating reports as and when required by the system users with documentation
Expertise in SQL and PL/SQL programming
Data uploading using Interfaces, Customized Scripts and Data Loader
Understand the business processes and gathers business requirements, analyze user requirements, and design technical solutions.