JAY PATEL

• Rogers Communications Inc. is a Canadian Communication and media company operating primarily in the fields of wireless communications, cable television, telephony and internet. Rogers support 30 Million Canadians each month through managing a robust portfolio that champions leading-edge technology.

* Responsibilities:

• Develop and maintain data Governance frameworks, policies, and procedures to ensure data quality, consistency , and integrity.
• Gathered data from SAP, Excel,CSV files, SQL and other data sources. Transformed the data and produced reports using the Power BI Platform. Optimized dashboards with a focus on usability and performance. Proficiency in SQL,DAX,Power Query and data transformation processes.
• Developed and maintained a sales performance dashboard resulting in a 25% increase in sales revenue and easy to understand the data.
• Participated in the migration of reports and Collaborated with cross-functional teams to identify data sources and
  streamline data collection resulting in a 25% reduction in report development time.
• Improved dashboard usability by implementing interactive visualizations resulting in a 20% increase in user engagement.
• Proved successful working within tight deadlines and a fast-paced environment.
• Publish report and give access to user read permissions through different modes.

* Software:

• MS SQL Server 2022/2018/2017/16/14/12 , Oracle, MySQL, TOAD SQL, T-SQL, PL/SQL, Microsoft Office , Excel, SSMS, SSDT 2017/16/14/12 , SSIS 2017/16/14, SSRS 2016/2014/2012 , POWER BI, Power Query, Tableau.

* Projects:

• Telesales Inbound Achievement Dashboard - Developed and maintained a sales performance dashboard gartering all sales data from different locations and teams.
  telesales inbound department key metrics ,Total call traffic,SPC (Sales per call) Wireless, Bb (Broadband), HUP (New device) , Conversation Rate, MRR, Monthly target &
  achievement etc.
• Credit Card Transaction Report - Developed multi pages report exporting data using TOAD SQL, CSV files. Credit card transactions by Quarter, usage , transaction category,
  CC or VDC , Total revenue generated, Different Penetration rate, Account types.

• Bell Canada Known as Bell is one of the largest telecommunications companies in canada, providing a wide range of communication services to both residential and business customers. Bell Canada is a subsidiary of BCE Inc. (Bell Canada Enterprises) which manages Bell Media, Bell Mobility and Bell Aliant.

*Responsibilities:

• Collaborated with multiple teams together and understand data requirements.
• Gathered data from various sources and used that data to creating Databases, tables, stored procedures, DDL/DML Triggers, views,user defined data types, index using T-SQL.
• Designed databases, tables and view structure for web applications. Involved in ER diagrams.
• Created reports to retrieve data using database code objects , such as stored procedures , views , function and multiple TSQL queries.
• Used complex expressions to calculate , group, filter, parameterize, and format the contents of the report.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Utilized data visualization tools to effectively communicate business insights.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.

*Hardware/Software:

• SAP, MS Access, Windows, Teams, Microsoft Office, MS SQL Server 2018/2017/16/14/12 , Oracle, MySQL, T-SQL, SSMS 2019, SSIS 2017/16/14 , SSRS 2016/2014/2012, POWER BI, Power Query, Tableau.

* Projects:

• Developed Customer satisfaction Dashboard - Developed a power BI dashboard that aggregated data from multiple sources. customer care department tracking key metrics CSAT(Customer satisfaction score), avg handling time, FCR (First call resolution), avg calls per day.
• Network Performance Optimization Dashboard -Developed a real-time dashboard using Power BI to monitor and optimize network performance, reducing latency by 15% and improving service quality.

• Yellow Sky is the web design and development Company. Yellow Sky develop Ios and Android Mobile application , Corporate Branding , Corporate logo Design , Custom Portal Development , Customized Website design Ecommerce Website Development,Performance Marketing and Search Engine optimization (SEO).

*Responsibilities:

• Assisted in analyzing large datasets to identify trends and patterns using SQL and python. Analyze data to understand how users navigate the site and identify opportunities for increasing conversions.
• Use tools like Google Analytics, Mixpanel to gather data on user journeys, clicks, page views, session duration and conversion rates.
• Collaborate with designers and developers and senior data analyst to implement changes that improve conversion rates based on data-driven insights.
• Monitor website and application performance metrics , such as load times, error rates, and server response times.
• Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
• Integrate data from different platforms and tools, such as web analytics, CRM systems, Excels , and third-party applications, to create a unified view of user interactions and performance.

*Software:

• MS SQL Server 2017/16/14/12, Python , SSIS 2016/14 , SSMS, Microsoft Office , Tableau