As a Data Analyst and BI Developer, I specialize in leveraging advanced tools and techniques to optimize data processes and deliver insightful analytics. Data Analysis and Quality: Identifying data sets, source data, and metadata. Performing data validation, cleansing, verification, and resolving data mismatches.Informatica and SQL: Creating data profiles using Informatica Data Explorer (IDE) & Data Quality (IDQ). Automating data cleaning using SQL scripts and migrating DTS packages to SSIS.ETL and Data Migration: Utilizing SQL, SSIS, and SAS for ETL processes. Migrating data from various sources to SQL Server databases and ensuring data integrity.BI Reporting and Visualization: Designing and implementing Power BI dashboards and SSRS reports. Developing tabular and matrix reports, charts, and graphs based on customer requirements.Data Modeling and MDM: Designing STAR schemas for data marts and developing MDM data models. Creating roadmaps for MDM solutions and ensuring data consistency across systems.SQL and PL/SQL: Writing complex queries for data validation and analysis. Developing stored procedures, views, and conducting performance tuning for OLTP and OLAP environments.Customer and Business Engagement: Translating business requirements into data solutions, performing root cause analysis, and documenting requirements. Delivering high-quality data insights and reporting.Passionate about turning data into actionable insights and continuously improving data processes to support strategic decision-making.

Collaborated with customers to identify and troubleshoot problems, delivering proactive support and guidance to enhance their experience.Maintained a high level of customer satisfaction by delivering excellent service and ensuring timely resolution of customer concerns.

As a dedicated Data Analyst and BI Developer with Accenture in Hyderabad, I successfully delivered impactful data solutions from July 2019 to August 2021. My role involved leveraging cutting-edge tools and technologies to enhance data quality, streamline reporting, and optimize data warehousing processes.Data Quality and Transformation: Utilized Informatica Data Quality (IDQ) to create comprehensive data quality mappings, enhancing data integrity and accuracy. Employed various IDQ transformations, such as Labeler, Parser, and Standardizer, to clean and standardize data.Business Intelligence and Reporting: Developed insightful reports and dashboards using Power BI and SQL Server Reporting Services (SSRS) to meet business requests and ad hoc requirements. Prepared detailed financial deliverables, including quarterly and budgetary reports, for funding agencies.ETL Processes: Designed and implemented ETL packages using SSIS to extract, transform, and load data into data warehouses and data marts. Documented Source to Target Mapping (STM) documents with precise data transformation logic.Collaboration and Documentation: Worked closely with data modelers and ETL developers to create comprehensive Data Functional Design documents. Contributed to building a specific data-mart as part of a Business Objects Universe, significantly improving reporting efficiency.Data Analysis and Validation: Conducted thorough data analysis and validation using advanced SQL queries in TOAD against Oracle databases. Identified and addressed design flaws in data warehouses, ensuring high data quality and performance.