Client - Macquarie1. Working on Data Pipeline to ensure Data Quality is best suited for Regulatory Returns.2. Perform manual checks and transformations to correct the data for downstream reporting.3. Prepare, Review and keep the Returns upto date that in line with conpliance.4. Develop and maintain Alteryx workflows, Documentation on Confluence and JIRAs for any change management regarding the Regulatory or Data Preparation process.5. Regular follow ups with the stakeholders regarding any upcoming change, Impact Analysis, Adhoc Data Requirements and Reports.6. Timely task completion in line with stipulated deadlines.7. Taking initiatives for any new work in pipeline and accountability for its completion.8. Managing the timelines by streamlining the tasks and automating wherever possible.9. Providing support for automating some of the key components to maintain Data Quality and ensuring correct numbers are submitted to regulators.

Client - Wolters Kluwer· Developed Ansible Collections to automate the:a. Installation and Configuration of MS SQL Server, Reporting Server and Analysis Serverb. Installation and Configuration of Wildfly, IBM WebSphere Liberty Profile and Keycloak Application Serversc. Installation and Configuration of IIS, Java, Curld. Installation and Configuration of RiskPro, RegEngine, NEA and OneSumX FS applications· Optimization of the Application Sets (Data Flow from Business Events to Journal Lines) for different entities in order to get the faster response for the purpose of Regulatory Reporting and Risk Management.· Performed Index Optimization and Query Optimization.· Implemented different strategies like Batch Insert, Scale-Up Resources, Polybase Scale-Out Group and Table Partitioning to set Benchmarks and Analyze performance gains with every step.

· Data import from SQL Server DB or using T-SQL queries into Power BI. Explore the dataset, identifying data types, filling in missing values, cleansing and transforming into a consistent dataset.· Explore the data in variety of ways and across multiple visualizations in Power BI. · Designed complex logics to analyze using DAX Measures and Calculated Columns.· Knowledge of Bookmarks, Visualizations, Dashboards, Report Synching, Drill Through, Report Page Filtering.· Used Power BI Gateways to schedule refresh in order to keep the Reports up to date.· Successfully developed Power BI Reports to assist the Business finding loopholes, opportunities, top performers, areas to focus, weak links in order to increase productivity and revenue.· Analysis of different phases of cycle of recruitment and identifying the areas to focus on.· Developed reports on User Performance based on Location, Industry, Clients and Jobs worked upon with Time Series Analysis.· Developed HRMS report depicting the Active Hours VS Productive Hours, Revenue Generated, Bad Hiring, Working Days, Attrition Rate, Jobs Assigned, Clients associated, etc.· Cost Analysis using What-If parameter to analyze Cost Applied and Revenue Generated.· Revenue Analysis in terms of the Client weightage to identify how much more effort needed in that aspect.· Hands on experience in Performance Tuning of Power BI Reports.