Rushikesh Tilekar

• Currently functioning as Team Lead, IT Specialist with Volkswagen Group Technology Solutions India Pvt Ltd Pune.
• Explored new tools and technologies that enhanced the capabilities of the team members while enabling seamless collaboration across departments.
• Developed and maintained effective relationships with key stakeholders to better understand their needs and expectations.
• Created detailed project plans outlining goals, timelines, resources, and budgets to ensure alignment with company objectives.
• Conducted regular progress reviews with individual team members to identify areas for improvement and provide guidance on career development opportunities.
• Served as a role model for the team by demonstrating commitment to excellence, professionalism, and adherence to company values at all times.
• Collaborated with other department leads to streamline workflows, improve interdepartmental coordination, and achieve business goals collectively.
• Championed continuous improvement initiatives that resulted in optimized processes leading to cost savings for the organization.
• Optimized resource allocation by analyzing team member skills and project requirements, resulting in increased efficiency.
• Enhanced overall team performance by providing regular coaching, feedback, and skill development opportunities.
• Spearheaded multiple high-impact projects simultaneously while meeting tight deadlines under pressure-packed situations.
• Nurtured long-term partnerships with clients by understanding their needs accurately, delivering projects on time, and providing exceptional customer support.
• Developed succession planning strategies to ensure continuity of leadership within the team and facilitate smooth transitions during organizational changes.
• Promoted a positive work environment by fostering teamwork, open communication, and employee recognition initiatives.
• Managed risks and mitigated potential issues through proactive planning, monitoring, and timely decisionmaking.
• Increased customer satisfaction by ensuring timely completion of projects and adherence to high-quality standards.
• Minimized resource and time losses by addressing employee or production issue directly and implementing timely solutions.
• Coached team members in techniques necessary to complete job tasks.
• Trained new team members by relaying information on company procedures and safety requirements.
• Communicated KPIs outlined in annual plan to inform employees of expectations and deliverables.
• Assisted in recruitment to build team of top performers.
• Monitored time and attendance, enforcing compliance with company procedures relating to absenteeism.
• Managed leave requests and absences and arranged covers to facilitate smooth flow of operations.
• Generated reports detailing findings and recommendations.
• Supported creation of detailed, technical financial models to value potential acquisition targets.
• Established strong relationships with vendors, negotiating favorable contracts while maintaining high-quality products and services.
• Led migration projects to modernize legacy systems without disrupting daily operations or compromising security standards.
• Implemented user access controls to minimize unauthorized access risks while preserving operational flexibility for authorized users.
• Provided exceptional customer service by promptly addressing problems reported by endusers.
• Optimized network performance through regular monitoring and maintenance.
• Spearheaded digital transformation initiatives, driving innovation and competitive advantage within the organization.
• Maintained a comprehensive knowledge of current industry trends, developments, tools, or techniques relevant to the role of an IT specialist.
• Trained employees on new technologies, increasing competency levels across the organization.
• Explained technical information in clear terms to non-technical individuals to promote better understanding.
• Responded to support requests from end-users and patiently walked individuals through basic troubleshooting tasks.
• Monitored systems in operation and input commands to troubleshoot areas.
• Monitored systems in operation and quickly troubleshot errors.
• Suggested software and hardware modifications to reduce lag time and improve overall speed.
• Used ticketing systems to manage and process support actions and requests.
• Managed high levels of call flow and responded to technical support needs.
• Responded to customer inquiries and provided technical assistance over phone and in person.
• Offered assistance in implementing and developing training programs.
• Generated reports to track performance and analyze trends.
• Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
• Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
• Designed scalable and maintainable data models to support business intelligence initiatives and reporting needs.
• Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
• .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Communicated new or updated data requirements to global team.
• Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
• Documented and communicated database schemas using accepted notations.
• Designed data models for complex analysis needs.
• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Developed and delivered business information solutions.
• Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Implemented effective backup systems to ensure data integrity and availability in case of disaster recovery scenarios.
• Enhanced system efficiency by implementing and maintaining IT infrastructure upgrades.

• Sales and After sales Dashboards of VW group. ( VW,AUDI,SKODA) Volkswagen IT Services India Pvt. Ltd. (VW ITS) is a strategic internal technical delivery arm for the Volkswagen Group .This project is to Create sales, Aftersales of VW group cars reports in provide users as per their requirements. ex. Vehicle history Report
• Evaluated new business intelligence software and tools, recommending appropriate solutions based on organizational needs.
• Delivered comprehensive training sessions to end-users on the utilization of newly developed BI tools and solutions.
• Championed the adoption of agile methodologies within project teams resulting in increased productivity and reduced timetodelivery.
• Managed multiple simultaneous projects, consistently delivering high-quality results within deadlines.
• Assisted clients in making more informed strategic decisions through the generation of detailed forecasting models.
• Collaborated with cross-functional teams to define key performance indicators and develop actionable insights.
• Contributed to team success by sharing knowledge about industry best practices, emerging trends, and innovative technologies in the field of business intelligence consulting.
• Leveraged advanced SQL skills to conduct in-depth data mining for the purpose of uncovering previously hidden insights.
• Streamlined data integration processes for improved accuracy and efficiency in reporting.
• Developed strong relationships with clients by understanding their unique business challenges and providing tailored solutions.
• Increased stakeholder satisfaction by presenting clear, concise, and insightful visualizations of complex data sets using qlikview, PowerBI and SAC.
• Designed customized data collection models for specific visualization tasks.
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Developed complex dashboard and reporting tools to track business performance metrics.
• Provided ongoing support for end-users, troubleshooting issues with BI reports and ensuring timely resolution of problems.
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
• Collaborated with stakeholders to identify business needs and data sources.
• Developed customized reports, summarizing and presenting data in visually appealing format.
• Created dashboards to monitor and track key performance indicators.
• Generated ad-hoc reports to evaluate specific business requirements.
• Updated and developed scripts and queries to extract and analyze data from multiple sources.
• Deployed predictive analytics models to forecast future trends.
• Analyzed data to identify root causes of problems and recommend corrective actions.
• Conducted thorough analyses of client requirements, translating them into actionable project goals and objectives.

Dealer Customer Care Index of VW group . (VW,AUDI,SKODA).

Data Source: DMS System, SQL Server 2008/2012, Excel, SFDC

QlikView 11.2,SQl ,Nprinting2

The Goal of this Project was to build an dashboard which will help the business Stakeholders to get an Overview of Customer Experience using different KPI’s at dealer end .This was achieved by different KPI wise Max points obtained by the dealer to its respective parameters and Score range provided. KPI used for this purpose were Voice Of customer(VOC),Quality Closure, Appointment Scheduling, Escalation Handling i.e. No of cases escalated /total cases received.

• Increased revenue generation through targeted marketing campaigns designed to attract new customers while retaining existing ones.
• Enhanced profitability with cost reduction initiatives, resource optimization, and process improvements.
• Monitoring Jobs, setting up alerts , analyzing & assisting in fixing the issue.
• Improved client satisfaction by analyzing business processes and implementing customized solutions.
• Maintained overall safe work environment with employee training programs and enforcement of safety procedures.

Qlikview Production Server Mirroring of VW group. ( VW,AUDI,SKODA).

• Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.

VW German and VW Plant

Feb 2018 – Dec 2018

DMS System, SQL Server 2008/2012, Excel, SFDC

Qlikview 11.2,SQl ,QMC

4

The Source System i.e. DMS System was migrated from 3x to 7x Database because of which we faced lot of changes at application level like data integration, transformation & report logics.

Major Qlikview dependent KPI needed to been re-aligned . During this project following Major KPI’s were realigned.

o KPI’s such SMS, Aspire, PSF, Vehicle History Report, Part Stock, Dealer migration.

o Historical and live data integration.

o Dealer rollout issue – individual to group etc.

Key Objective was to increase server performance and reduce job failures.

o CPU and RAM utilization is under control and functioning properly.(40-60% server utilization only)

o Server restart which was a very common issue has been resolved.

o Created unique ID’s for each developer for server tracking purpose.

In addition to that during this Project also provided L2 support to business stakeholders to close incidents and tasks within Stipulated timeframe of business.

• Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
• Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs.
• Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
• Evaluated emerging technologies to identify opportunities for improving database operations and reducing costs.
• Ensured database security with implementation of role-based access control and regular vulnerability assessments.
• Trained junior team members on best practices for database administration, promoting a culture of continuous learning within the organization.
• Modified databases to meet needs and goals determined during planning process.

• OTIS BI System:

Its aim is to delivers seamless analysis, reporting and dashboard to business users with business

Strategies for greater transparency.

Company works in manufacturing domains. World’s largest manufacturer and maintainer of people-moving products, including elevators, escalators and moving walkways. In this Project data source is JDE and then it is transformed using Datastage as an ETL tool with SQL Server as Target and then QlikView BI platform plugged on top of it to leverage the IN- MEMORY architecture and drive the Data visualization and business insights. This project is to Migrate the reports developed in MSBI to Qlikview 11.2 and Qliksense 3.2.

• Optimized data processing for faster insights by designing efficient ETL processes and data models.
• Ensured compliance with industry regulations and internal policies through careful design of security protocols within the BI infrastructure.
• Proactively identified potential roadblocks during project implementation phases, working closely with team members to develop effective solutions.

Insurance Enterprise View (IEV) is an Insurity product designed and developed for catering the Insurance industry in USA. IEV combines rich, robust functionality with multi-level control and security so that critical,

business-changing information can be delivered without compromising data security or integrity

• Worked as QlikView Consultant at Larsen Toubro Infotech Ltd.
• Managed client relationships through regular check-ins and updates on project progress.
• Enhanced communication among team members to foster collaborative and supportive work environment.

As a Team Member, was responsible for,

• Designing the data model and Development of dashboards and reports.
• Data Fetch from different sources like Xml, SQL, MS Access and creating QVD and loading the same.

o Incremental Load with daily updating Record, Security Access, user Creation optimizing Technique.

o Dashboard creations as per business requirements.

• Implemented Best Practices & Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys.
• Developed Complex Graphical User Interactive reports using various Qlikview Objects.
• Strong Skills in Data Modeling ( Star Schema, Snow Flake Schema) & Loading data from Multiple data sources.
• Installation & configuration of Qlikview Software.

o Creating maintaining and Scheduling the reload Tasks.

o Monitoring the jobs, Setting up the alerts.

o Analyzing & assisting Fixing the Failures.

o Deploying Qlik applications.

• Involved in Performance Tuning & Deployment of QlikView Applications.
• Ensured technical completeness and verification of documents used in various phases of development and implementation are in accordance with the client standards.

Mentor team members and help them resolve their queries.

• Cultivated positive relationships with vendors to deliver timely and cost-effective supply of services and materials.
• Conducted regular reviews of operations and identified areas for improvement.
• Supported clients with business analysis, documentation, and data modeling.
• Conducted thorough market research and analysis, providing valuable insights for client decisionmaking.

• Worked as Software Engineer at Larsen Toubro Infotech Ltd.

Reporting Decisions provides reporting features for Policy administration, claims administration and billing administration. It also provides third party integration capabilities too.

As a Team Member, was responsible for

• Understanding Client requirement, develop and Design SSRS and Qlikview Reports.
• Migration of SSRS reports to Qlikview Reports for few clients.
• Impact analysis on SSIS Packages, SSRS & SQL Jobs during database change.
• Staging objects like stored procedures, Triggers and scripts to run on different Client servers and Updating Team Foundation Server (TFS) for the same.
• Designing, Modifying and testing different SSRS Reports as per client requirements.
• Controlling transactions and handling errors for stored procedures .

Involved in Development, maintenance and support of ETL and Report requirements.

• Worked as Graduate Trainee Engineer at Larsen Toubro Infotech Ltd.
• Enhanced project efficiency by streamlining communication between cross-functional teams.
• Optimized existing systems by employing advanced troubleshooting techniques and root cause analysis methods.
• Assisted senior engineers with research and data analysis, supporting informed decision-making processes.
• Maintained up-to-date knowledge of industry trends, best practices, and emerging technologies through ongoing professional development activities.
• Provided technical support during installation, commissioning, and maintenance of engineering systems at client sites.
• Participated in training sessions designed to enhance teamwork skills and cross-functional collaboration among colleagues.
• Developed comprehensive documentation for engineering projects including specifications, drawings, test plans, and user manuals.
• Studied corrections from senior engineers to learn and grow professionally.
• Developed comprehensive engineering documents for all projects.