Yogesh Kumar Email & Phone Number

Toronto, On, Ca

Toronto, On, Ca

Mississauga, Ontario, Canada

1. Project: Space IQ | Client: Eptura | Domain: Workplace ManagementSpace IQ by Eptura provide employees the tools they need to manage how, when, and where they work. They help employers re-imagine their workplaces with actionable data and set sound real estate strategies. The Move Order Engine (Zeus) is one of the most important components of business logic in the SpaceIQ product and contains all the business logic and is the source of truth for all spaces, space assignments, and move orders. As a part of this project, we implemented strategic initiatives to fix existing bugs, optimize the technological infrastructure so as to reduce technical debt for the client. • Gathered requirements and fixed application bugs. • Documented the business logic for various modules of the application. • Implemented authentication support for Confluent Kafka in the application.

Mississauga, Ontario, Canada

1. Project: Data Engineering | Client: Digital Turbine | Domain: Media and AdvertisingA development, migration, and maintenance project for maintenance of existing data pipelines, development of new pipelines for better analytics for reporting team. In this project, existing pipelines were changed to efficiently use the systems/infrastructure to save cost.◦ Evaluated business needs and objectives; Analyzed, and organized raw data and Built data systems and pipelines.◦ Interpreted various trends and patterns; Explored ways to enhance data quality and reliability.◦ Analyzed new spark batch framework and migrated the jobs from existing framework.◦ Improved the test coverage of the framework by adding edge cases, Used scalafmt and scalafix as linter.◦ Developed a short-lived replica of prod environment for development purpose to save cost.◦ Implemented Restful API of different partners to collect, transform and organize data.◦ Implemented Slack’s API in Matillion for job failure/ job success alerts on slack channels.◦ Suggested and implemented monitoring jobs to check the health of various pipelines.◦ Setting up raw data as delta tables on amazon s3 to be utilized by pipelines in partitioned manner to bring down job computation time eventually lowing cost.◦ Migrated from Jenkins to Git lab Continuous Integration and Terraform for CI/CD deployments.◦ Integrated Airflow in the batch framework for job orchestration and monitoring purposes.◦ Performed query optimizations for reporting team to be utilized in data analytics tools.◦ Suggested and Implemented partitioning of a big tableau data source into multiple partitions to enable performance efficient data retrieval for reporting in dashboards.

Pune, Maharashtra, India

1. Tableau Reporting | Client: Digital Turbine | Domain: Media and AdvertisingA migration project for movement of all workbooks/dashboards using Vertica as their data source to Amazon Redshift. The development majorly entailed reports such as Daily performance reports, Sales representative dashboards, Daily Leader boards, Hourly Business dashboards, Live Campaign Details and Ad Sales Dashboard.• Migrated the Vertica SQL Queries to AWS Redshift.o Functional and syntactical differences resolution, Data Validation.o Implemented custom functions for addressing gaps between technological framework between Vertica and AWS Redshift.• Designed workbooks and dashboards on Tableau Desktop.• Implemented data-sources(embedded/published), workbooks, and dashboards on Tableau Server and scheduled refresh extracts for various workbooks and data sources.2. Customer Portal | Client: DerbySoft | Domain: Hospitality• Designed dashboards for business functions.• Monthly data cleansing of raw input files and maintenance of the same on developed dashboards.• Delivered ad-hoc requests for specific use cases via preparations of charts, bar graphs.• Performed Integration and Unit Testing to ensure quality deliverables.3. iEnergy | Client: Nexant | Domain: EnergyiEnergy DSM Central (formerly TrakSmart) provides a comprehensive DSM business process management system for improved planning, visibility, management, and control in a single, secure, web-based, system of record. The key deliverables of this project were development of Jasper reports through full implementation lifecycle and their deployment.• Deep dive discussions for business requirements with different stakeholders.• Developed complex SQL queries and Jasper reports.• Performed full cycle unit and integration testing for a quality deliverable, provided support during system integration testing, performance integration testing and user acceptance testing.

Pune, Maharashtra, India

1. WMA – Portfolio Management Reports| Client: UBS | Domain: BFSAs part of this implementation, changes to existing reports and creation of new reports were handled.• In depth sessions with business owners for requirements gathering.• Development of 22 high complexity reports namely portfolio review, bond holdings, Asset allocation summary, Asset class performance report, Security performance report, Portfolio holdings, which shows the data in the form of customized charts and tables.• Developed SOAP Queries, java utility code to create dynamic xml nodes in the soap queries.• Developed complex report templates, charts, JFree charts using Jasper Studio.• Developed column manager logics to dynamically hide/show columns for predefined report templates and performed deployments and Integration using Jasper Server UI.2. WMA (Wealth Mgmt. Americas) – Automatic Account Transfer Application| Client: UBS | Domain: BFSAutomatic Account Transfer • Developed User Interface using JSP’s and Business Logic Components using Struts.• Implementation of DAO layer using hibernate and supported the deployment of the Application on WebSphere Server.• Troubleshooting / defect fixing during integration testing.3. WMA (Wealth Mgmt. Americas) - Business Intelligence Application (BIA) Jasper Migration | Client: UBS | Domain: BFS• Layout Designing of complex report templates (involving grouped data, complex variable calculations, applying data format patterns etc.) using Jasper Report.• Unit testing in iReport with emphasis on development of reusable sub reports, style sheets (.jrtx), resource bundles.• Implementation of features like Hyperlinks, Dynamic sorting, Drill up – Drill down functionality, Go back links etc.• Deployment and integration with Jasper Server UI along with troubleshooting / defect fixing during integration testing.

Pune, Maharashtra, India

Greater Hyderabad Area