Learn Data Skills
Beta
Divya Basir

Divya Basir

Certified

Data Analyst

Titanium Transportation

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Insightful puzzle solver, piecing together data fragments to reveal the big picture.

My Work

Take a look at my latest work.

DataLab

Project: When Was the Golden Era of Video Games?

course

Introduction to Python

course

Intermediate Python

DataLab

Subjects Score Analysis

DataLab

Competition - Certification competition

7Upvotes
DataLab

Project: When Was the Golden Era of Video Games?

My Certifications

These are the industry credentials that I’ve earned.

SQL Associate

SQL Associate

Other Certificates

Microsoft Azure Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Titanium Transportation Group Inc. | Jan 2022 - Present

Data Analyst-SQL Specialist

• Created program views, functions, execution of stored procedures, triggers, window functions for complex SQL queries. • Utilized problem solving, critical thinking, data modulation, transform data to star schema and testing skills for Titanium reports using MS SQL Server Reporting Services (SSRS) and Microsoft Power BI. • Responsible to provide Power BI workspace and SSRS Report access as per the role to maintain privacy. • Developed an excellent understanding of Titanium’s business and data flow with team communication to ensure the accuracy of reports and dashboards and gather requirements for data manipulation and analysis specifications. • Created and maintained client dashboards, Informational reports, Paginated Power BI reports, Analytical reports, Scorecards, Product (Truck) Performance reports, Trucking and Logistics KPI Dashboard, Financial reports, Department and Progress reports using data visualization tools such as Power BI, SSRS, and Excel, and harmonized dataset by writing SQL queries, DAX, Time Intelligence functions, and M (Power Query) for data analytics. Also, created ad-hoc reports, data validation, critical thinking, query optimization and provided data-driven insights and collaborated with stakeholders. • End to end implementation of Reporting Services with innovative ideas using tools like Power BI, SSRS, SQL and Excel. Troubleshooting and maintaining reports and dashboards. • Performed modelling data analytics with strategic thinking and generated insights as per business requirements. • Gather requirements and communicate with Senior Management, document all the business requirements and send it as a MOM to make sure everyone’s on the same page. Projects • ‘Commission Report’ built in SQL and SSRS determines each Sales Representative’s monthly commission by calculating generated Revenue, Margin and Payout. Report helped the CFO to distribute monthly commission and saving 5-6hours of manual calculation. • ‘KPI Dashboard for Trucking and Logistics’ (Power BI, DAX- time intelligence functions, SQL for data manipulation) collects Trucking and Logistics yearly Revenue, Carrier Cost, Gross Margin, Total Miles, Available Trucks, Revenue Generating Trucks and Unutilized trucks. Utilized snowflake schema in Power BI to compare and analyze Prior Year, Actual and Budget numbers, aiding strategic decision-making. • SSRS Report ‘Payroll Accrual for Company Drivers’ for Accounting Team to analyze revenue and pay details for all the terminals fetched from TMW (Trucking Management) and match with GL (Great Lakes) in a single report. • ‘Logistics Incentive Dashboard’ (Power BI, DAX, SQL for data manipulation) for Director’s decision making of next quarter budget. Dashboard also includes estimation of Target based on predictive analysis and Incentives made by ‘Carrier Procurement Specialists’ and ‘Customer Service Representatives’. Implemented Row-Level Security to make the Dashboard visible to Management level only. • ‘Fleet Uptime’ (Power BI, Query Editor, DAX-Measure/Column, SQL) for Maintenance Director and CEO to track active truck delivering a load, active idle truck, and trucks under maintenance. The dashboard helped them to track unused trucks and increase revenue by a minimum of 10%. • ‘Demurrage Time’ Power BI Dashboard for Operations Team to track trucks sitting at Customer Warehouse for a long time and calculate demurrage charge for each customer and adding approximately $20,000 to the company Revenue.
Show More

Adobe | Jan 2020 - Feb 2021

Application Specialist

• Level 2 Application Specialist for Adobe Campaign Standard using SCRUM methodologies. • Extensively worked on database platforms such as Oracle DB, MS-SQL Server, PostgreSQL. Worked with Web APIs (SOAP/REST), handled AJAX calls. Hosted web applications on AWS Elastic Beanstalk. • Automated customized workflow (ReactJS, CSS) to calculate active profiles active profiles targeted from the Adobe Campaign PostGreSQL database and fetch the data to Node.JS Backend. Workflow target profiles increased 25% from the previous year, making the client upgrade Adobe Campaign package. • Resolved a critical phishing attack. Users were getting spam emails from a client domain which was hampering Client's domain reputation. White-listed the SSL certified domains and IPs which improved IP/Domain Reputation of the client by 25%. Received appreciation from the stake holders for this. • Automated workflow to track log files of real-time and batch events from MS SQL Server targeted in Adobe Campaign. Helped the Client to monitor status of real-time and batch events, resulted in an increase in accuracy rate to 71%.

UnitedHealth Group | Jul 2017 - Aug 2019

Software Engineer

• Analyze Database schemas, strong T-SQL script creation, DDL/DML queries and ETL process used in ad-hoc analysis and object creation with Application Release Automation (ARA) team. • FTE Tracker (Node.js ES6, CSS, MS-SQL Server) - Developed internal web application tracking full time and part time employees, number of hours worked, projects assigned, making life of Supervisors and SMEs easy by automated tracking of daily attendance in just a single UI. FTE Tracker accelerated the process of tracking employee attendance by 50%. • WIM - Workforce Inventory Management (NodeJS, MS-SQL Server). Workforce Inventory Management based on IRIS methodology. Around 1500 processors used the web application. Automated task assignation increased the productivity of team by 70%. • ICUE – IMS (Integrated Clinical User Experience Inventory Management System) - Integrated WIM with ICUE Management System (ReactJS, CSS). Confidential details which were maintained on hard copies were transformed to soft data using ICUE IMS making claim process 10 times faster.

PISoftek | Jan 2017 - Jun 2017

Application Specialist

• Part of the Application Support Team - ‘OCTIV’. Responsible for data modification, validation, analysis and quality review of deliverables. Maintain complex database in MS SQL Server management studio. • Design and Deliver training to raise competency levels in using data, including data warehouse, new reports and enhancements, SQL, and visualization tool by Analyzing business requirements of both internal and external stakeholders. Research and analysis of available data. Perform MDX queries for data visualization.

HCL Comnet | Jun 2014 - Nov 2015

Analyst

• Worked with Performance Management (PM) team of ‘SC Johnson’. • Creation and management of database in MS-SQL Server. Proficiently handled all Outlook functionality, utilizing Pivot function of MS Excel extensively along with knowledge of Active Directory, exchange mailboxes, distribution lists. • Database maintenance and tuning for fast performance. Query optimization using tools (MS SQL Server) and knowledge. • Created complex reports on SSRS using SQL Server and turned manual work automatic. • Created Dynamic SSRS Report ‘Billing Report’ showing customer’s products under different categories and their sales. • Created internal SSRS scheduled report using MS-SQL ‘Employee Onboarding’ for managers to track new joiners within the team and design Onboarding tasks. • Translated data into informative report and visuals using SSRS, MS-SQL and Excel • Documented and maintained all business processes to follow a standard operating procedure to maintain accuracy. • Documented all customer requirements, expectations, communication needs and project life cycle components to ensure alignment with project objectives as per the agile methodology.

NSN - Nokia Solutions and Networks | Dec 2013 - Jun 2014

Alarm Monitoring Engineer

• Monitored alarms of Base Station Controller (BSC), Base Transceiver Station (BTS) and Mobile Switching Centre (MSC) and generated SMS for faulty sites • Worked on tools such as BMC Remedy, AWE and SMS Generator. Sent fault SMS and restoration message once site was restored.

UDCL (Videocon Mobiles) | Feb 2013 - Jul 2013

Management Trainee

I performed Functional testing of smart phones

Intex Technologies (India) Ltd. | Jun 2012 - Jul 2012

1 month Training

Experimented on following gadgets: - CRT TV Tuner Box - LCD TV TUNER Box - Keyboard - Optical mouse - Wireless mouse - SD Data Card

Escorts Limited | Jun 2011 - Jul 2011

1 month Training

I studied about CNC and PLC machines there.

My Education

Take a look at my formal education

Database Application Developer, Database Application Developer  · (JanuarySeneca College | 2021
Bachelor of Technology (B.Tech.), Electrical, Electronics and Communications EngineeringB.S.A.I.T.M | 2013
higher secondary SOS Hermann Gmeiner School | 2009

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free