AliAkbar

Extensive experience in data analysis and reporting along with strong knowledge of database and related technologies (SQL, PLSQL, OLAP, OLTP).
Analyzed the requirements and framed the business logic for the ETL process using Talend and involved in the Talend jobs design and its Development.
Developed jobs using Talend for data loading, importing Source/Target tables from the respective databases and flat files.
Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Talend to extract the data from multiple source systems that comprise databases like Oracle, SQL Server,DB2,Postgre, flat files to the Staging area, EDW and then to the Data Marts.
Expertise in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed.
Design and develop efficient ETL processes for data ingestion, integration, and analytics.
Design and implement data models, databases, and data warehouses for data storage and analysis.
Establish and maintain technical environment for data analysis, such as databases and data warehouses in cloud environment.
Design dimensional data models, ETL workflows and SQL /PLSQL queries leveraging a variety of big data technologies.
Expertise in Data modeling techniques like Data Modeling‑ Dimensional/ Star Schema and Snowflake modeling, Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3).
Interaction with end‑users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.
Develop Tableau interactive dashboards and reports that provide clear visualizations of various industry‑specific KPIs.
Identify relevant trends, do follow‑up analysis, prepare visualizations in form of charts, graphs, and tables.
Developing dashboards to track productivity and expedite remediation of issues.
Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

Extensive experience in data analysis and reporting along with strong knowledge of database and related technologies (SQL, PLSQL, OLAP, OLTP).
Analyzed the requirements and framed the business logic for the ETL process using Talend and involved in the Talend jobs design and its development.
Developed jobs using Talend for data loading, importing source/target tables from the respective databases and flat files.
Developed and maintained ETL mappings using Talend to extract data from multiple source systems including Oracle, SQL Server, DB2, Postgre, and flat files to the Staging area, EDW, and Data Marts.
Performed data profiling, data migration, extraction, transformation, and loading using Talend.
Designed and developed efficient ETL processes for data ingestion, integration, and analytics.
Designed and implemented data models, databases, and data warehouses for data storage and analysis.
Established and maintained technical environment for data analysis in cloud environment.
Designed dimensional data models, ETL workflows, and SQL/PLSQL queries leveraging big data technologies.
Worked with dimensional/star schema and snowflake modeling, including Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3).
Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform them into technical requirements.
Developed Tableau interactive dashboards and reports that provide clear visualizations of various industry-specific KPIs.
Identified relevant trends, performed follow-up analysis, and prepared visualizations in the form of charts, graphs, and tables.
Developed dashboards to track productivity and expedite remediation of issues.
Accessed and transformed massive datasets through filtering, grouping, aggregation, and statistical calculation.
Consulted with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders.
Maintained and redeveloped regular or ad-hoc business relevant reports for key stakeholders.
Validated data and reports to ensure high levels of data accuracy and integrity.
Converted data into actionable insights by predicting and modeling future outcomes.
Data wrangled, gathered, processed, and analyzed data for different ad hoc requests.
Managed and customized ETL processes as per the requirement of data visualization.
Developed customized, data-intensive BI analytics leveraging ETL processes and SQL/PLSQL scripting.
Utilized Oracle Apex and OBIEE for visualization purposes.
Crafted and optimized SQL statements to enhance business intelligence practices.

Met clients to understand their requirements and prepare programs that are easy to use and understand.
Tested programs before delivering and ensured that all prerequisites were met.
Designed and maintained Oracle Apex Forms/Reports.
Developed forms and reports using Oracle Developer 11g.
Used critical thinking to break down problems, evaluate solutions, and make decisions.
Identified issues, analyzed information, and provided solutions to problems.
Provided professional services and support in a dynamic work environment.
Cultivated interpersonal skills by building positive relationships with others.

Responsible for support and maintenance of systems.
Tested the system and ensured proper functions of programs required by the client.
Communicated with clients and discussed their needs.
Developed forms and reports using Oracle Developer 10g and 6i.
Designed, developed, coded, tested, documented, and implemented data modeling features using TOAD and other third party tools.
Developed customized reports and screens of SAP ABAP.
Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
Updated old code bases to modern development standards, improving functionality.
Translated customer requirements into written use cases.
Corrected, modified, and upgraded software to improve performance.