1. Operational Management: • Oversee the daily operations of the company, ensuring that all business processes run efficiently and align with strategic goals. • Develop and implement operational policies and procedures to improve workflow and productivity. • Collaborate with department heads to streamline operations and improve overall efficiency.2. IT Strategy and Management: • Develop and implement the company’s IT strategy to support business goals. • Oversee the management of the IT department, ensuring the company’s technology infrastructure is secure, up-to-date, and scalable. • Lead IT projects, including the implementation of new systems, upgrades, and migrations. • Ensure that all IT systems are compliant with industry regulations and standards.3. Team Leadership: • Lead, mentor, and manage operations and IT teams, fostering a culture of collaboration, innovation, and continuous improvement.4. Process Improvement and Automation: • Identify areas for operational and IT process improvement, focusing on automation and efficiency. • Implement new technologies and tools to optimize business processes and reduce operational costs. • Continuously monitor and evaluate the performance of operational and IT systems, making adjustments as needed.5. Financial Management: • Develop and manage the operations and IT budgets, ensuring cost-effectiveness and alignment with the company’s financial goals. • Monitor expenses and allocate resources efficiently, balancing operational and IT needs. • Provide regular reports on operational and IT performance, including financial metrics, to the executive team.6. Vendor and Stakeholder Management: • Manage relationships with key vendors and service providers, negotiating contracts and ensuring service levels meet company standards. • Collaborate with other departments, including finance, HR, and marketing, to ensure IT systems support overall business objectives.

Work with stakeholders/business users to gather and understand the reporting requirements. Gathered business requirements, definition and design of the data sources and data flows. Experience with the data visualization tool in Power BI and Qlik sense. Responsible for gathering business requirements and technical specifications from the users.• Implemented Qlik Replicate software for real-time data integration and replication across multiple databases andplatforms.• Collaborated with QA team to perform unit testing and resolve identified users, ensuring the stability andreliability of the application.

• Work with business users to gather and understand the reportingrequirements.• Gathered business requirements, definition and design of the data sourcesand data flows.• Responsible for gathering business requirements and technicalspecifications from the users.• Involved in designing, developing, testing, publishing, maintaining, andsupporting Qlik Sense applications.• Building QVDs, QVWs, QVFs using source systems like SQL Server, Excelfiles, and Snowflake.• Involved in the requirement analysis and identifying sources and targets.• Created Qlik Sense dashboards using different objects like List Boxes,Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Barcharts, Combo charts, Straight tables, Pivot tables, Buttons, Containers.• Created tasks and scheduled the jobs in nPrinting server.• Involved in performance tuning of Qlik Sense apps for faster data reloadsand efficient response times.• Involved in design and development of SSIS packages to move data fromproduction environment to different environments within the organization.• Identified the database tables for defining the queries and datasets forreport generation.

• Collaborated with senior management, subject matter experts, and IT teams to define business requirements• Transformed business requirements into functional and nonfunctional requirements.• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.• Created complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.• Designed expressions to calculate, group, filter, parameterize, and format report contents.• Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

 Develop an optimized QlikView/Qlik Sense extraction script to extract data from multiple data sources. Used bookmarks feature which enables the ease to jump to respective report tabs with one click.  Work with business users to gather and understand the reporting requirements. Utilized Qlik Sense gateway to keep dashboards and reports up to-date with on premise data sources.  Created drill down and drill through report to go to details and child report within Qlik based on hierarchy.  Troubleshooting reports issues, ETL job failures, optimizing query performances. Optimize Qlik Sense performance by creating QVD’s. Using nPrinting for publishing existing application data into PPT, PDF & Excel formats to deliver weekly & daily data to users based on user requirements. Interacted with clients for finalizing Business Requirement Documents, KPI’s and created project plans using both agile and waterfall methods. Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation. Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes. Develop an optimized QlikView/Qlik Sense extraction script to extract data from multiple data sources.

• Involved in planning, defining and designing data base using Erwin on business requirement and provided documentation • Translating business requirements into technical design specifications • Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2012 • Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models • Installed and configured and maintained Power BI Report Server.• Created Power BI dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.• Created access for users to use the Power BI reports on the web and across mobile devices. • Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column • Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints • Designed and developed Tabular Model Cubes using SSAS 2012. Developed calculated columns and measures using DAX• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database• Wrote T-SQL queries, stored procedures and used them to build SSIS packages, SSRS reports and in Tableau. • Created user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2012 • Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software