VIKAS MEHRA
Delhi
Summary
Experienced Technology Specialist professional with over 10 years of experience in designing creative, engaging, and easy-to-consume visual insights. Proven track record in developing and reviewing BI design specifications, data modeling, and data preparation. Adept at managing mid-size projects, mentoring junior team members, and maintaining positive relationships with clients and stakeholders. Strong expertise in Power BI, SQL, DAX, Python, VBA, and various Azure services.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Technology Specialist/Product Lead
Coforge Limited
Greater Noida
06.2022 - Current
- Designed and developed reports, dashboards, and other visualizations to address business problems.
- Authored and reviewed BI design specifications; conducted unit testing for reports and dashboards.
- Executed data modeling and data preparation tasks, providing expert advice as needed.
- Managed mid-size projects, ensuring smooth service delivery across products and engagements.
- Collaborated with project managers to identify resource needs and devise alternative solutions.
- Provided expert reviews for projects within the assigned subject area.
- Translated high-level business problems into concrete technical requirements and work plans.
- Maintained and developed positive relationships with clients and stakeholders.
- Participated in the software development life cycle (SDLC) and product development activities.
- Followed DevOps best practices, including unit testing, branching, builds, deployment, and regression testing.
- Interacted successfully with senior stakeholders and steered diverse teams.
Assistant Manager
EY
Gurugram
05.2020 - 06.2022
- Lead the end-to-end lifecycle of RPA projects, from requirement gathering, analysis, design, development, testing, deployment, and support. Ensure best practices and design principles are adhered to.
- Created a detailed work plan (project plan) which identifies and sequences the activities needed to successfully complete the Automation
- Implementation of Automation projects leveraging technologies like RPA, SQL Server, Alteryx, BI, Azure, etc
- Managed project team of 5-7 people delivering end to end solutions in RPA
- Supervised, developed, and mentored junior team members.
- Promoted the use of current technologies and tools to enhance service effectiveness.
- Developed Global Delivery Services opportunities and participated in business development.
- Developed and maintained dashboards and data visualizations using Power BI.
- Wrote SQL queries, DAX functions, and worked on “M” for data transformation.
- Designed and integrated databases with relational data sources, such as SQL Server.
- Conducted data analysis and modeling using Alteryx.
- Automated processes and scripted tasks using Python and VBA.
- Worked with various Azure services, including Azure Data Factory, Azure Data Explorer, Azure SQL, and Databricks.
- Developed solutions spanning multiple Office 365 services, including PowerApps and Power Automate.
- Followed BI best practices, analysis, visualization, and latest BI trends.
Senior Software Engineer
TCS
Gurugram
10.2019 - 05.2020
- Analyse user needs and automation requirements to determine feasibility of design within time and cost constraints
- Automated multiple processes by producing clean, efficient code using Robotics automation tools UIPath, VBA and SQL server
- Monitored customer reviews and employee feedback to implement new ways of improving services
- Developed new, efficient and well-tested code for a variety of different software projects
- Developed, published and delivered multiple Automation BOTs helping increase efficiency of multiple processes using UIPath in Banking domain
Software Development Analyst
Accenture
Bengaluru
01.2015 - 09.2019
- Developed new, efficient and well-tested code for a variety of different Robotics Automation projects
- Collaborated with designers and product managers to develop innovative Robotics products
- Develop and direct automation process testing and validation procedures, programming, and documentation
Associate Analyst
Interglobe Technologies
Gurugram
06.2014 - 01.2015
- Worked as a Junior Developer on dot net for a project named Musafir.com
Education
B.E. - Computer Science
Panjab University
Chandigarh, CH01.2014
Skills
- Business Intelligence (BI)
- Power BI, SQL, DAX, “M”
- Data Modeling, Data Preparation
- Alteryx, Python, VBA
- Azure Data Factory, Azure Data Explorer, Azure SQL, Databricks
- PowerApps, Power Automate
- Report and Dashboard Design
- Software Development Life Cycle (SDLC)
- DevOps Best Practices
- Financial Accounting
- Project Management
- Excellent Communication Skills
- Attention to Detail
- Organized and Structured
Accomplishments
- Successfully developed and implemented more than 50 RPA solutions using UIPath tools and also made POCs using Power Automate and Blue Prism.
- Automated processes in order to reduce processing time from 45 mins per task to 5 mins per task.
Certification
UiPath Certified Advanced RPA Developer (UiARD)
Projects
- Led a project to develop a comprehensive financial data visualization and reporting solution for a multinational corporation. The goal was to provide stakeholders with clear, actionable insights into the company's financial performance and streamline the reporting process. Designed and implemented data models using SQL Server and Azure SQL to support complex financial reporting needs. Integrated data from multiple sources, including ERP systems and external financial databases, using Azure Data Factory and Alteryx for ETL processes.
- Improved the accuracy and timeliness of financial reporting by 30%. Enhanced stakeholder satisfaction through intuitive and insightful visualizations.
- Reduced manual reporting efforts by 40% through automation.
- Video Conferencing Scheduling : Automation of Video conferencing process where extracting video conferencing requests from the email and scheduling call based on Employee's availability
- Insurance Premium calculation : Extracting data from the excel file after fetching from emails and the use business logics to calculate the premiums after fetching policy details from web portals.
Timeline
Technology Specialist/Product Lead
Coforge Limited
06.2022 - Current
Assistant Manager
EY
05.2020 - 06.2022
Senior Software Engineer
TCS
10.2019 - 05.2020
Software Development Analyst
Accenture
01.2015 - 09.2019
Associate Analyst
Interglobe Technologies
06.2014 - 01.2015
B.E. - Computer Science
Panjab University
Similar Profiles
Rohit GuptaRohit Gupta
Project Manager at Coforge LimitedProject Manager at Coforge Limited
PAVANI BONTHALAPAVANI BONTHALA
Associate Software Engineer at Coforge LimitedAssociate Software Engineer at Coforge Limited
Saurav KaushikSaurav Kaushik
Software Engineer at Coforge LimitedSoftware Engineer at Coforge Limited