Dhruvkumar Limbachiya

• Responsible for the development of SSIS packages to business requirements.
• Create Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the project's requirements.
• Develop and modify applications with the Product Owner and the business.
• Design SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Agile scrum team environment, 2-week sprints, daily stand up, team player, and collaborative.
• Develop reports and dashboards using Power BI based on the requirements of historical healthcare data.
• Develop Datasets for the Reports and Dashboards. Write Stored Procedures for Reports/dashboards to pull data into the Power BI query editor. Write the DAX Functions in Power BI and Power Pivot.
• Create reports in the Power BI preview portal utilizing the SSAS Tabular via the Analysis connector.
• Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Develop custom-calculated measures using DAX in Power BI to satisfy business needs.
• Responsible for handling the entire deployment life cycle of the dashboard from DEV to PROD, created the Power BI Service level datasets, scheduled the refreshes nightly and implemented row-level security on each report.
• Develop Analytical Dashboards, PBI Dashboards and Paginated Reports using Power BI.
• Responsible for refactoring and optimizing the code based on the analysis for the T-SQL objects, SSIS packages and Power BI reports.
• Enable Row Level security for the tables on DW, so that not every user can see the confidential data.
• Embed Power Apps in a Power BI report to Perform Data Manipulation.
• Use Power BI gateway to schedule daily jobs to refresh data and establish RLS (Row Level Security). Use custom visuals, third-party connectors, Power Query, Power Apps, and CDS as part of the Power BI project.
• Create user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts, slicers, and Drill and drill-through features.
• Create DAX Queries to generate calculated columns and measures in Power BI.
• Publish Power BI Reports on Service and provide access to Web clients and mobile apps.
• Use Power BI report builder to publish paginated reports.
• Using Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Collaborated on a project for a startup that aims to enhance customer growth by offering metrics on various services provided by the company.
Translated stakeholder's requirements into tangible deliveries such as functional specification document, data flow diagrams and designed appropriate dimensional design to provision reporting to build necessary metrics for analysis.
Analyzed the stocks of both companies and compared the data using SQL language.
Utilized ML libraries to filter and cleanse the data provided by the organization and then utilized the cleaned data to create a dashboard using Tableau/Power BI tools.
Designed and executed ETL processes, ensuring efficient extraction, transformation, and loading of diverse data sets for informed decision-making.
Evaluated and presented information in a manner that will facilitate management's understanding of the results and impact.
Developed, analyzed, and monitored new, routine, and ad hoc reports.
Supervised and developed documentation effort from an analysis standpoint.
Followed a structured approach to organize requirement into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
Identified and documented constraints, limitations, assumptions, risks, and mitigation plans.
Gathered and documented non-functional requirements such as performance, load, disaster recovery and availability.
Performed comprehensive map evaluations to assess accuracy, data completeness, and spatial representation, ensuring high-quality cartographic products.
Utilized GIS tools and methodologies to analyze geospatial data and optimize map design for effective visualization.
Created visually impact dashboards in excel and tableau and Power BI for data reporting by using pivot tables and VLOOKUP.
Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful data.

Addressed inquiries and resolved complaints with a high degree of professionalism, enhancing customer satisfaction and maintaining positive client relationships.
Managed a high-volume phone system, promptly answering all incoming calls, redirecting them to the appropriate personnel, or efficiently relaying messages.
Handled incoming and outgoing mail, including drafting correspondence, packaging parcels securely, and ensuring timely distribution to relevant recipients.
Organized and managed email correspondence, sorting and forwarding messages to the appropriate departments or individuals, resulting in improved email communication efficiency.
Demonstrated strong organizational skills by maintaining updated payment records, meticulously tracking financial transactions, and ensuring accuracy in accounts payable and receivable.
Processed payments to vendors and employees, adhering to established protocols and financial regulations, minimizing errors and delays.
Maintained a tidy and presentable front desk area, ensuring the availability of necessary materials like pens, forms, and paper for staff and visitors.
Exhibited proficiency in operating office machines, including fax and printer, to support daily operations and meet office equipment needs.
Utilized MS Office, particularly Excel and Word, to create reports, correspondence, and maintain records, contributing to streamlined administrative processes.
Leveraged excellent communication and interpersonal skills to interact with clients, visitors, and colleagues in a courteous and professional manner, creating a positive office environment.
Demonstrated strong multitasking abilities, effectively managing various responsibilities simultaneously to meet deadlines and organizational needs.
Utilized problem-solving skills to address ad-hoc tasks and challenges efficiently, ensuring smooth office operations.
Showcased exceptional typing skills, accurately transcribing documents and maintaining a high level of data accuracy.
Utilized background in accounts payable and receivable to support financial processes and enhance accounting efficiency.
Generated detailed CRM reports and dashboards, providing valuable insights to management for strategic decision-making and facilitating data-driven business strategies.
Actively participated in CRM software upgrades and enhancements, providing input on user experience and functionality to ensure the system met the evolving needs of the company.
Implemented a customized CRM data segmentation strategy that improved targeted marketing efforts, resulting in a 10% increase in email engagement and lead conversion.
Led a cross-functional team in the successful migration of customer data from a legacy system to a new CRM platform, minimizing downtime and ensuring data integrity throughout the transition.
Recognized for consistently maintaining the highest standards of data accuracy, earning the "Data Accuracy Champion" award within the company.

Efficiently managed and maintained accurate records of company data, utilizing Microsoft Excel and specialized data entry software, resulting in streamlined operations and improved data accuracy.
Conducted regular data quality checks, identifying and rectifying discrepancies promptly to ensure data integrity and minimize errors.
Collaborated with cross-functional teams to gather and input critical business information, supporting effective decision-making, and ensuring seamless communication across departments.
Coordinated the organization and storage of physical and digital documents, implementing an improved filing system that enhanced accessibility and reduced retrieval time by 25%.
Assisted in the preparation and distribution of various reports, presentations, and correspondence, demonstrating strong attention to detail and proficiency in Microsoft Office Suite.
Managed office supplies, inventory, and vendor relationships, optimizing procurement processes and reducing supply costs by 15% through negotiations and strategic purchasing decisions.
Assumed responsibility for scheduling appointments, coordinating meetings, and maintaining the office calendar, ensuring efficient time management and smooth office operations.
Supported the HR department by assisting in the onboarding process of new employees, including data entry, documentation, and orientation coordination.
Played a key role in organizing company events and team-building activities, fostering a positive work environment, and strengthening employee morale.