Bindhu Balan

• Collaborate with stakeholders to gather and analyze business requirements.
• Translate business requirements into technical specifications and Document data requirements, including source system analysis and source to target
• Need to gather and record Technical Metadata, Source, Profile, Scheduling, Ingestion type, file details for IDC required by the Ingestion.
• Document detailed operational data needed for the ingestion of data into Akora in the Cloud.
• Work closely with development teams to ensure the accurate and efficient implementation of ingestion into Cloud Azure.
• Implementing data validation rules.
• Execute SQL queries to extract and compare datasets, identifying discrepancies, gaps, and data quality issues from SQL server, Azure data bricks .
• Communicating necessary changes and development to stakeholders in meetings.
• Worked as a part of scrum team, in an agile methodology with sprint cycles, daily stand ups and story implementation and support teams.
• Conduct review of the IDC, ETL mapping documents.
• Work with stakeholders to gain different levels of approval for the technical documents.
• Responsible for creating tickets, approval to publish the data in prod environment.
• Worked for designing and developing data workflows using Alteryx .
• Data preparation with SQL Scripting and scheduling monthly data run in Alteryx.
• Support the end-to-end integration testing by comparing the data in the reports with the source system to find out the mismatches; and find its root cause.
• Provided Demo / walkthrough of the business/technical document to stakeholder and technical team.
• Given required support to QA team.

• Collaborate with business stakeholders to understand their data visualization needs and business requirements and translate them into effective dashboards and reports.
• Perform Data Analysis and develop Visualizations using Tableau, SQL, and Excel.
• Manage workbook and data refresh schedules to ensure data is updated and relevant for stakeholders.
• Cleanse and prepare data for analysis and reporting to ensure data accuracy and integrity, and relevance.
• Partner with Product Owners and Development Team to understand the changes and define the scope of UAT .
• Supported and lead user acceptance testing (UAT) and ensure solutions meet business expectations.
• Preparing/Review of Test Data required for Migration testing.
• Performed Data Analysis to determine data quality issues.
• Identifies, analyzes and interprets trends or patterns in data sets.
• Filters and corrects data by reviewing reports and update code problems.
• Perform data analysis by querying relational databases using SQL and Microsoft Excel.

· Analyze client's business requirements and processes through document analysis and interviews. ·

· Translate stakeholder requirements into different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.

· Developed SQL code for repeatable data retrievals to update data ·

· Developed retail financial dashboards using Tableau on Teradata data source. ·

· Troubleshoot ongoing Tableau reporting issues. ·

· Created Automated tableau alerts when the reports breached certain limit.

· Prepared analysis and presentation of periodic performance management results

· Performed ad hoc analysis, participate in cross functional special projects. ·

· Identify and reconcile errors in client data to ensure accurate business requirements.

· Scheduled extract refresh for weekly and monthly reports. ·

· Developed retirement reports in Sisense and worked on converting certain tableau reports into Sisense environment.

· Performing Data analysis, Data verification, data mismatch using SQL query and compare with various source and Provide strategic Solutions to Business Users.

• Responsible for overseeing and managing backlog of new requests helping business to prioritize and define items.
• Manage a large backlog of items for relevance, priority, and business value leveraging a Jira repository .
• Manage planning for release content and timing as well as managing and identifying project risks and issues .
• Elicit requirements using interviews, document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis .
• Maintained/modified internal SSRS Reports and ad-hoc SQL scripts.
• Worked with end users to ensure the accuracy of the reports and timelines for scheduled reports releases.
• Work with data sourcing to source and validate data completeness from acquisition to report delivery.
• Work with Stakeholders during UAT to ensure reports meet requirements and ensure all deliveries are signed-off

• Prepared FRD, BRD based on a request from users.
• Analyzed data if a user reports any issue. Verification of data granularity.
• Interacted with the client/ business analyst to understand the requirements.
• Working with ETL team/ data source team(Genesis) and users to complete the requirement.
• Optimized long running stored procedures & queries for effective data retrieval.
• Produced reports to retrieve data using stored procedures that accept parameters.
• Developed PL sql Stored Procedures and views to generate various Drill-through reports, parameterized report

• Create BI Tableau report mockups based on requirements and coordinate with technical team to finalize designs.
• Collaborate with cross functional teams to ensure alignment in business needs, timelines and department standards.
• Maintain and enhance existing BI dashboards to ensure continued relevance and accuracy.
• Document, present, and recommend solutions for handling data anomalies and issues.
• Create test plans and scenarios and conduct testing to ensure quality and requirements traceability to final deliverable
• Create and maintain design documentation, metadata dictionaries, and report definitions including visual representations of workflows, procedures, and processes

• Responsible for Database validation processes for every data load and verified the dashboard data with Source data on every month.
• Verifying the record in backend matches between source and target table and verifying the new dashboard functionality in backend through SQL.
• Verified the accuracy of the column-to-column transport of the data between the source and target testing with appropriate dimensional filters on the metrics and the formula used to compute those metrics.
• Develop, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Scheduling and updating daily automation script run along with testing new enhancements by using QTP and analyzed results.

• Develop, design, and maintain interactive dashboards, reports, and visualizations using MicroStrategy tools
• Collaborate with business and end-users to gather and prioritize data requirements
• Write and optimize SQL queries for data extraction and analysis.
• Troubleshoot issues, including writing and executing SQL queries

• Participated in structured code reviews/walkthrough.
• Created reports using Oracle Report builder and integrated them to existing Oracle Forms application.
• Performed modifications to PL/SQL packages to remove any Forms specific references.
• Worked on Toad , SQL Developer for querying .