 Actively participated in gathering business requirements to implement functional and technical specifications. Installed, managed and administrated SQL Server 2019/2017/2016/2014/2012 Databases. Used Agile methodology and SCRUM process for project developing. Expertise in migrating BI applications to AWS/Azure Platforms. Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bulk Insert task, Script task in SSIS… Show more  Actively participated in gathering business requirements to implement functional and technical specifications. Installed, managed and administrated SQL Server 2019/2017/2016/2014/2012 Databases. Used Agile methodology and SCRUM process for project developing. Expertise in migrating BI applications to AWS/Azure Platforms. Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bulk Insert task, Script task in SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Data Flow. Designing, developing, and testing the ETL (Extract, Transformation, and Load) strategy to populate the data from various source systems feeds using SSIS. Configured and deployed the application on QlikView server and Imported data from different sources Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC. Created Ad-Hoc Reports, Sub Reports and Summary Reports for the financial accounting team using R Programming. Worked with both the version in Azure Data Factory such as V1 & V2. Wrote and executed various MySQL database queries from Python using Python- MySQL. Integrated data from varied sources using SSIS – SQL Server, Azure Data Lake, Spreadsheets and Flat Files. Migrating databases\instances from SQL Server 2017 to SQL Server 2019 version. Proficient in designing and maintaining relational databases using platforms like Microsoft SQL Server, Oracle, or MySQL. Wrote a python-based SQL generator that helped speed up a weekly reporting from several days. Developed the batch scripts to fetch the data from AWS S3 storage and do required transformations in Scala using Spark framework. Used Spark processing framework such as Spark SQL, Data Warehousing and ETL processes. Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc queries. Show less

 Involved in translating the business questions and business requirements to actual and final dashboard technical requirements. Imported Data from SQL Server DB Azure SQL DB to Power BI for generating Reports. Wrote data queries in DAX and SQL and Expertise in writing Complex Dax functions in Power BI and Power Pivot. Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python. Onboarded several applications & services in PPE… Show more  Involved in translating the business questions and business requirements to actual and final dashboard technical requirements. Imported Data from SQL Server DB Azure SQL DB to Power BI for generating Reports. Wrote data queries in DAX and SQL and Expertise in writing Complex Dax functions in Power BI and Power Pivot. Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python. Onboarded several applications & services in PPE, Production, Azure cloud environments. sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS). Used R to extract the data from Cosmos and load it into SQL database. Used Power BI, Power Pivot to developed data analysis phototype, and used Power View and Power Map to visual. Configurated and Deployed of all reports across various SDLC environments and deployed the packages to production using XML package configuration. Developed application in PowerApps using Common Data Service CDS, Flow, Excel, Forms and SharePoint online. Used Power BI, Power Pivot to developed data analysis phototype, and used Power View and Power Map to visual. Developing web applications where the price calculation and comparison of various cloud services like Azure and AWS are done. Took part in creating Star Schema, Snowflake dimensional schema in MS analysis services (SSAS). Experience in getting data from different data sources like SharePoint, Excel, CSV, APIs etc., and transforming raw data as per requirement. Deploy Clarity reports using both BOE (BusinessObjects Enterprise) Infoview and Epic Crystal Reports integration. Added new users and applied roles in the QNXT UI in the Development and UAT Environments. Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. Developing interactive reports and dashboards using tools like Power BI, Tableau, or QlikView to enable data visualization and insights. Show less

 Interacted with the client for requirement gathering/ implementation. Maintained BSO cubes and participated in data loading to BSO cubes from flat files. Working with Business, SMEs (which includes mockups, assumptions, current reality and use cases), scheduling meetings, preparing minutes (MOM), action items, maintaining log files and follow-up. Design project plan, road map and project status evaluation. Working with SQL, and T-SQL, VBA. Designing and customizing… Show more  Interacted with the client for requirement gathering/ implementation. Maintained BSO cubes and participated in data loading to BSO cubes from flat files. Working with Business, SMEs (which includes mockups, assumptions, current reality and use cases), scheduling meetings, preparing minutes (MOM), action items, maintaining log files and follow-up. Design project plan, road map and project status evaluation. Working with SQL, and T-SQL, VBA. Designing and customizing reports and embedding with dashboard Troubleshooting and being accountable to application end users Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data into data warehouse databases. Experience in refreshing datasets using Power BI gateway. Work with IT team to create users, groups and assigning roles according to the requirements. Report design, drill through reports using OLAP cube features, Power Pivot. Created dashboards using SQL Server Reporting Services (SSRS). Extensively worked on agile scrum environment for several claims processing modules Acted as Data analyst and Interacted with business community and gathered requirements based on changing needs. Aiding the support and supervision of BI software programs Security implementation, administration, troubleshooting, and RPD migration Excellent analytical, problem solving and Tableau and SQL debugging skills. Supported in creating KPI, Calculation Members and Measure groups and MDX queries. Designing and deploying RPD using OBIEE environment BI data modelling as per business rules and business matrices to support reporting. Wherever required, the ETL process was created, the reports will be stored, refreshed, and utilized in the report on a daily basis. Show less