Janofer Meeran Pillai

- Performed in-depth data analysis using SQL to identify trends, anomalies, and areas of improvement, contributing to data-driven business decisions.

- Utilized ETL tools such as Informatica to extract, transform, and load large datasets across various platforms, ensuring accuracy and efficiency in data processing.

- Collaborated with cross-functional teams in a matrix-managed environment to streamline processes and implement effective data solutions across multiple locations.

- Developed and maintained complex queries and scripts in SQL and other programming languages to support data validation and reporting efforts.

- Demonstrated strong leadership and time management by coordinating multiple tasks simultaneously, meeting project deadlines without compromising quality.

- Communicated technical insights and data findings effectively to both technical and non-technical stakeholders through reports, dashboards, and presentations.

- Engaged in business requirement gathering by asking critical questions, clarifying objectives, and ensuring alignment with project goals and stakeholder expectations.

- Analyzed client source data to identify root causes of issues, proposed actionable solutions, and worked with teams to ensure timely remediation.

- Gained hands-on experience with internal systems and processes related to data loading, analysis, and workflow optimization..

• Performed data analysis which includes inspecting, profiling, transforming with the goal of discovering useful information, suggesting conclusions, and supporting decision making.
• Performed data analysis on source data to ensure target data model design will meet requirements.
• Worked in the development of SQL data reports for executive-level presentations.
• Worked with development and maintenance of Stored Procedures and SQL Scripts.
• Formulated business logic to meet user requirements and create new algorithms to meet customization in operations and policies.
• Performed in-depth data analysis, normalization, and reconciliation using multiple large datasets to identify gaps and trends, manage data quality and integrity, and inform context-based decisions using various information sources.
• Work with business, developers, analysts, and testers to ensure completeness of test plans and test scenarios.
• Compile reports and activity status as requested by the project manager.
• Assist the Business/Product Owner in planning, preparing for and conducting user acceptance testing, including developing test scenarios and test cases.
• Analyze requirements and effectively identify testing techniques to ensure comprehensive testing coverage in a timely manner.
• Create or assist in creating, socializing, and presenting test approach, test artifacts, testing process, test metrics with appropriate teams.
• Prepare test data and ensure readiness of test environment prior to test execution. Ensure adherence to software quality criteria, policy, and guidelines.
• Promptly and effectively escalate issues as appropriate. Proactively engage with development teams and project team members to help promote the prevention of defects.
• Effectively logs defects and quality concerns using test management systems and any other reporting systems per client’s policy and guidelines.
• Performed routine data review, research, and/or reconciliation.
• Supported continuous improvement of existing processes, developed new processes, or enhanced existing processes where required including maintenance plans, procedural documentation, and custom tools for automation. Identify resources that can be utilized to support business operations or improve existing business processes.
• Analyzed, designed, documented, built, evaluated, and implemented integration technology solutions that meet the specifications of a project or service request.
• Accountable for the quality, usability, and performance of the solutions
• Involved in minor enhancement and changes to existing sessions and workflows for incidents logged by the production support team.
• Interacting with the client’s end users in gathering requirements along with the business analysts to determine the technical feasibility.
• Involved in making performance related tuning and suggested value adds to the existing system.
• Performed data mappings and design of system ETL workflow solutions.
• Provided production support for data issues from end users regarding data load problems and transformation translation problems.
• Documented ETL and database warehouse processes, procedures, and flows.
• Responsible for providing day-to-day direction of the related DQ efforts for assigned data sourcing projects.
• Participated in functional or user acceptance testing to ensure final product meets intent of customer's needs.
• Reviewed and documented functionality of existing legacy applications.
• Continually improve existing processes to increase performance, throughput, and quality.
• Collaborate with team members to create a robust, repeatable, and accurate development process.