About Me
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.
Experience
Analytics and Reporting Specialist
<p>Rebranded 20+ IBM Cognos and SSRS reports from Lifeworks to TELUS Health by gathering data from multiple sources and UX designs.<br>
Designed, developed, tested, and maintained reports according to improving requirements to fulfill the measures according to TELUS Health.<br>
Worked in an Agile environment by using Microsoft Azure DevOps and JIRA for tracking sprints, tasks, and work items.<br>
Worked around in SQL Server Management Studio (SSMS) to make changes in tables and views by writing DML and DDL commands.<br>
Developed and designed complex reports using SSRS, leveraging various data sources and datasets to meet business requirements and provide actionable insights.<br>
Collaborated with cross-functional teams to gather report requirements, translating complex business needs into functional and user-friendly reports using SSRS.</p>
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
<p>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.<br>
Customized existing Salesforce standard objects, fields, reports, dashboards, and page layouts to meet determined user requirements and improve the overall user experience.<br>
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.<br>
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.</p>
Business Intelligence Analyst
<p>Developed 3+ interactive dashboards and reports using Power BI by understanding business users’ requirements, gaining insights, making data-driven decisions, and exceeding stakeholders’ expectations.<br>
Managed data sources and performed data cleansing and transformation on 40,000+ records using Power Query to ensure accuracy and consistency.</p>
Senior Data Analyst
<p>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.<br>
Implemented complex SQL queries to extract 100,000+ records from snowflake data warehouse.<br>
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.<br>
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.</p>
Data Analyst
<p>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.<br>
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.<br>
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.<br>
Produced 50% impact using Tableau for visualization and Informatica PowerCenter to gather data from Oracle, SQL server and flat files.</p>