Data Analyst

RUBINDER VIRK

Dublin, CA 404-***-**** *********@*****.*** LinkedIn

BUSINESS INTELLIGENCE ANALYST

Data Analytics Professional with experience delivering data-driven solutions across financial services, healthcare technology, com- munications and logistics industries. Proven expertise in analyzing complex data to identify trends, developing ETL pipelines, and transforming business intelligence into actionable insight through dashboards. Strong track record of collaborating with cross-functional teams to resolve complex business problems through sophisticated data analysis. TECHNICAL EXPERTISE

• Technical Expertise: EDW Architecture, Business Intelligence Solutions, Leadership & Process, Agile Methodology, Requirements Gathering, ETL Pipeline Development, Advanced SQL Development, Data Modeling & ERD Design, Technical Documentation, Team Training & Development, Cross-functional Collaboration

• Reporting Tools: SAP Business Objects, Universe Designer, Web Intelligence Rich Client, Crystal reports, Data Warehouse, Data Marts, Tableau

• Databases: Microsoft SQL server, Snowflake, Oracle

• ETL Applications: SAP Data Services Designer, Airflow

• Development Methodologies: Agile

• Programing Languages: T-SQL, PL/SQL, Python

• Operating Systems: Windows, UNIX, AIX, HP-UX

• Others: AWS, Bit Bucket, Git hub, Source Tree, Alation, Jira, Visio, XML, Visual Studio, Microsoft PowerPoint PROFESSIONAL EXPERIENCE

DISCOVER FINANCIAL SERVICES (via ROBERT HALF INC.) Jun 2022 - Jan 2025 Data Analyst

Led critical data analysis initiatives at Discover Student Loans to ensure compliance with Consumer Financial Protection Bureau (CFPB) regulations, resulting in the prevention of millions in fines.

• Developed complex Snowflake SQL queries to analyze customer impact scenarios and assist with root cause analysis.

• Executed data-driven solutions to determine the financial restitution amount needed for each customer.

• Managed multiple high-priority issues simultaneously while meeting strict timeline.

• Collaborated with various teams to deliver time-sensitive analytics solutions, improving interdepartmental communication and effi- ciency

• Advanced to Quality Control DA role and validated data quality and trained junior team members on QA processes.

• Analyzed the data through queries in Excel by creating cross tab tables and graphs to assure data accuracy and identified anomalies and outliers.

INTUITIVE SURGICAL (via XORIANT INC.) Aug 2019 - Mar 2022 BI SQL Developer

Implemented Business Intelligence solution for healthcare company to support multiple business units. Provided powerful insight into the customers and identified opportunities for the company and the customers.

• Worked with the customer success team to provide 360 insight view into hospital performance.

• Led the design of ETL solution to provide key performance indicators to the marketing team, improving engagement with hospitals

• Conducted financial analysis of Medicare and Medicaid reimbursements for minimally invasive robotic surgical procedures, demon- strated positive return on investment and financial viability.

• Developed data extraction to feed into Customer Portal application, allowing customers to track their orders, RMA, debit credit.

• Analyzed existing Tableau dashboards to decipher the logic being used, enabling more efficient dashboard updates and maintenance

• Built automated sales commission data integration between Anaplan and Snowflake EDW.

• Encrypted and decrypted data between Snowflake and AWS S3 bucket for POC. PREMIERE GLOBAL INCORPORATED Mar 2013 - Mar 2019

Business Intelligence Engineer/Analyst

As a Business Intelligence Analyst at video conferencing company, I worked with SAP BI tools. I built universes (semantic layer) and created and modified SAP Webi reports in SAP Business Objects. I helped turn data into actionable insights. After being promoted to Business Intelligence Engineer role I gathered business requirements and designed ETL jobs through SAP Data Services to migrate data into data warehouse, performed all necessary transformations to populate data into table structure optimized for reporting.

• Created ERD diagrams to effectively source data into the data warehouse, enhancing data organization and accessibility

• Designed, developed, and modified SQL stored procedures, views, and tables for feeds and reports.

• Improved report query response time by implementing Indexes.

• Prepared business unit specific data marts, assisted in developing Business Objects Universes for Marketing, Customer Care and Billing team.

• Collaborated with nontechnical business users to determine specific business requirements and worked with SME to translate them into Jira stories.

• Delivered knowledge transfer sessions to stakeholders detailing work completed in two-week sprint cycles.

• Produced support documentation for use by operations team for troubleshooting and resolving issues.

• Provided direction on projects and helped adapt new technologies.

• Mined data sources to identify and analyze trends to support decision making.

• Developed ad-hoc queries, Crystal reports and SAP Webi reports, performed analyses for wide variety of reports and assisted in report scheduling.

• Managed security permissions in Configuration Management Console (CMC), controlled access levels for folders and universes.

• Performed audit analytics against the SAP BO audit database and identified risks and provided actionable insights.

• Troubleshot and resolved issues with SAP Business Object services, ensuring system reliability and performance FEDEX GROUND Jan 2007 - Mar 2013

Programmer Analyst

Supported five critical proprietary applications in automated package sortation, transportation management system, and package pickup. Performed troubleshooting and resolved issues promptly with least amount of impact to productivity and service. Worked with multiple vendors on testing the communication of new sortation facility. EDUCATION & TECHNICAL SKILLS

California State University of East Bay, Hayward, CA Bachelor of Science, Computer Science

Contact this candidate