نبذة عني
Innovative Software Engineer with about 4 years of experience in the information technology and services industry. Have a deep understanding of Salesforce, Python, SQL, other ETL, and BI tools, and delivered more than fi…
Innovative Software Engineer with about 4 years of experience in the information technology and services industry. Have a deep understanding of Salesforce, Python, SQL, other ETL, and BI tools, and delivered more than five successful projects for top multimedia clients through collaborating with 5+ cross-functional teams in an agile environment on gathering requirements, resolving issues, and ensuring highest standards of data quality and system performance.
الخبرة
Analytics and Reporting Specialist
Rebranded 20+ IBM Cognos and SSRS reports from Lifeworks to TELUS Health by gathering data from multiple sources and UX designs.
Designed, developed, tested, and maintained reports according to improving requirements to fulfill the measures according to TELUS Health.
Worked in an Agile environment by using Microsoft Azure DevOps and JIRA for tracking sprints, tasks, and work items.
Worked around in SQL Server Management Studio (SSMS) to make changes in tables and views by writing DML and DDL commands.
Developed and designed complex reports using SSRS, leveraging various data sources and datasets to meet business requirements and provide actionable insights.
Collaborated with cross-functional teams to gather report requirements, translating complex business needs into functional and user-friendly reports using SSRS.
Analytics and Reporting Specialist
• Rebranded 20+ IBM Cognos and SSRS reports from Lifeworks to TELUS Health by gathering data from multiple sources and UX designs.
• Designed, Developed, Tested and Maintained reports accordingly with the improving requirements to fulfill the measures according to TELUS Health.
• Worked in an Agile Environment by using Microsoft Azure DevOps and JIRA for tracking sprints, tasks and work items.
• Worked around in SQL Server Management Studio (SSMS) to make changes in the tables, views by writing DML and DDL Commands.
• Developed and designed complex reports using SSRS, leveraging various data sources and datasets to meet business requirements and provide actionable insights.
• Collaborated with cross-functional teams to gather report requirements, translating complex business needs into functional and user-friendly reports using SSRS.
Salesforce Administrator/Quality Assurance Specialist Intern
Developed 15+ automation testing classes in C# to test 10-15 objects in Salesforce to identify or fix issues quickly and improve the quality of the application.
Customized existing Salesforce standard objects, fields, reports, dashboards, and page layouts to meet determined user requirements and improve the overall user experience.
Documented 100+ test cases in more than 10 projects in Salesforce by creating a test plan including testing schedule, objectives, resources, and results for future reference.
Managed user accounts and profiles, modified the Salesforce platform to meet the needs of the organization, troubleshot issues, and provided technical support to end users.
Business Intelligence Analyst
Developed 3+ interactive dashboards and reports using Power BI by understanding business users’ requirements, gaining insights, making data-driven decisions, and exceeding stakeholders’ expectations.
Managed data sources and performed data cleansing and transformation on 40,000+ records using Power Query to ensure accuracy and consistency.
Senior Data Analyst
Generated custom Dag’s (Directed Acyclic Graphs) using Airflow to automate and schedule data pipelines by integrating with AWS S3 to fetch and store data using EC2 setup for Airflow.
Implemented complex SQL queries to extract 100,000+ records from snowflake data warehouse.
Designed Pl/SQL procedures in snowflake to perform slowly changing dimension type 2 operation which processes ETL by extracting data stored in AWS S3 to snowflake.
Built 5+ interactive dashboards and reports by connecting to a wide range of data sources and shared the insights to the customer in Power Bi visualization tool.
Data Analyst
Analyzed data sources, data mapping documents, and validated mappings to ensure the data was being stored as expected by comparing the data sources and increased 5% of efficiency.
Prepared and executed 50+ test cases to validate the ETL process to check the quality and reliability of data being loaded into the target system.
Collaborated with developers to create custom tables, views, and procedures in snowflake to adjoin specific business requirements and wrote 70+ SQL queries to review the results.
Produced 50% impact using Tableau for visualization and Informatica PowerCenter to gather data from Oracle, SQL server and flat files.