Jairam Devadiga

• Transitioned to Projects Team as Associate Business Analyst following internal interview in June 2018, and subsequently promoted to Business Analyst in January 2021.
• Developed stored procedures within agile sprint cycles to automate generation of recurring client reports.
• Utilized Control-M to schedule database jobs incorporating multiple client-level stored procedures, thereby ensuring consistent and timely delivery of reports to clients.
• Extracted data from diverse sources (SQL, Excel, APIs, cloud services) using Power BI.
• Transformed raw data using Power Query and DAX to clean, merge, and reshape datasets for analysis.
• Loaded and optimized data into Power BI models for efficient reporting.
• Automated ETL processes with scheduled data refreshes to ensure up-to-date reporting.
• Performed updates to Fidelity's Pension Record System's Azure SQL MI Database using PL/SQL scripts, based on requirements outlined in JIRA Tickets/Stories. Additionally, executed bulk data updates for Corporate Action Projects.
• Experienced in tracking and managing bugs to ensure efficient resolution and maintain high project quality using JIRA.
• Deployed Azure SQLMI scripts to UDeploy server and subsequently ran those scripts in mirror environment to analyze results and script behavior using UDeploy tools before executing them in production environment.
• Built Azure MS-SQL scripts to extract plan participants' pension payment details, facilitating preparation of valuation files necessary for pension fund managers, actuaries, and financial planners to assess financial health of pension plans and make informed decisions about funding levels and benefit distributions.
• Expert in gathering, analyzing, and documenting business requirements through BRD to ensure alignment with project goals and meet stakeholder expectations.
• Proficient in using draw.io for creating detailed flowcharts, process diagrams, enhancing clarity in technical documentation.
• Facilitated communication between operations and development teams by gathering requirements from operations and translating them for developers. Generated necessary reports for further analysis and tested script in acceptance environment to ensure smooth and reliable application development.
• Collaborated with stakeholders to identify and resolve underlying issues within Fidelity's Pension Record System, optimizing processes and enhancing system efficiency.
• Scoped project hours and costs by arranging meetings with stakeholders and comprehensively understanding project requirements.

• Joined Fidelity Investments in January 2014 as Specialist in DB Calculation Team, and was promoted to Senior Specialist in June 2016.
• Conducted pension calculations for participants and beneficiaries, ensuring compliance with client-approved plan rules and pension administration manuals.
• Led efforts to identify and resolve system bugs that affected pension calculation accuracy, testing fixes in mirror environment before deployment.
• Facilitated meetings with client service management teams to provide updates and ensure alignment on pension calculation processes and standards.

Capital One UK Client

• Managed credit card issuing process for Capital One UK, focusing on credit history evaluations.
• Conducted comprehensive assessments of applicants' credit histories using credit bureaus such as Equifax and Experian.
• Ensured compliance with financial regulations and company policies.
• Enhanced accuracy and reliability of credit decisions through meticulous verification and analysis.