Jairam Devadiga
Bengaluru
Summary
Highly analytical Business Analyst with background in identifying business needs and determining solutions to business problems. Strong skills in data analysis, project management, and strategic planning, coupled with ability to communicate effectively with stakeholders at all levels. Proven track record of improving operational efficiency and driving growth by successfully implementing innovative strategies and process improvements.
Overview
13
13
years of professional experience
Work History
Business Analyst
Fidelity Investments
Bengaluru
06.2018 - Current
- Transitioned to Projects Team as Associate Business Analyst following internal interview in June 2018, and subsequently promoted to Business Analyst in January 2021
- Enhanced reporting efficiency by developing SQL MI stored procedures within agile sprint cycles, significantly reducing manual effort and delivery times for recurring client reports and streamlined process further with Control-M automation ensuring consistent and timely execution of these stored procedures, meeting critical client deadlines
- Substantially reduced case volumes by leveraging Power BI dashboards to visualize and analyze data extracted from SQL and Excel sources
- Enhanced data models with Power Query and DAX to optimize performance and accuracy
- Utilized slicers which enabled stakeholders to gain in-depth insights into key contributors to case generation, enabling targeted interventions to address root causes and improve operational efficiency
- Achieved full compliance with US Pension regulatory requirements by developing and deploying a high-performance SQLMI script that automated the process of identifying and mailing Accrued Benefit Statements to Term Vested participants
- Through integration of advanced SQL techniques such as DML, DQL, DDL, JOINS, sub queries, and date formatting the script efficiently processed over 100,000 rows, adapting seamlessly to diverse client plan rules across multiple DB systems and reduced manual intervention by 60%, improved accuracy, and ensured real-time reporting to senior management
- Executed critical updates to Fidelity's Pension Record System's Azure SQL MI Database by deploying PL/SQL data update scripts to Mirror/Acceptance environments using UDeploy
- Identified and addressed potential issues prior to production deployment, ensuring smooth data updates that aligned with requirements outlined in JIRA tickets/stories
- Developed highly accurate Azure SQL Managed Instance (MI) scripts to extract participants' pension details for Defined Benefit Plan Valuation report, ensuring full compliance with SOC 1 standards
- These scripts empowered clients to accurately assess funding requirements and make informed decisions regarding financial health of their pension plans over specified time horizon
- Successfully aligned business objectives by gathering, analyzing, and documenting requirements through BRDs, ensuring projects met stakeholder expectations
- Facilitated seamless communication between operations and development teams by translating operational requirements into clear, actionable tasks for developers, ensuring smooth project delivery and operational efficiency
- Drove system improvements by collaborating with stakeholders to identify and resolve inefficiencies within Fidelity's Pension Record System, contributing to higher operational productivity and reduced system downtime
- Scoped project resources effectively, arranging stakeholder meetings to accurately estimate project hours and costs, ensuring projects were delivered on time and within budget
Senior Specialist - DB Calculation Team
Fidelity Investments
Bengaluru
01.2014 - 06.2018
- Joined Fidelity Investments in January 2014 as Specialist in DB Calculation Team, and was promoted to Senior Specialist in June 2016
- Executed complex pension calculations for participants and beneficiaries, ensuring strict adherence to client-approved plan rules and pension administration manuals
- Led crucial initiatives to identify and resolve system bugs, improving pension calculation accuracy, and ensured seamless deployment by rigorously testing fixes in mirror environment
- Proactively facilitated cross-functional meetings with client service management teams, driving clear communication and alignment on pension calculation processes and standards
BFSI Process Executive
Infosys Ltd.
Bengaluru
05.2011 - 12.2013
- Oversaw credit card issuing process for Capital One UK, with focus on thorough credit history evaluations
- Executed in-depth assessments of applicants' credit histories by utilizing data from credit bureaus such as Equifax and Experian
- Ensured compliance with financial regulations and company policies, maintaining integrity of credit approval process
- Improved accuracy and reliability of credit decisions through meticulous verification and strategic analysis
Education
Bachelor of Science in MPCs - Mathematics, Physics,Computer Science
Mahatma Gandhi Memorial College, Udupi, Mangalore University
Udupi, Karnataka04.2011
Skills
- Data Analysis
- Data Visualization
- SQL Query Development
- Data Reporting
- Business Requirements Analysis
- Power BI Dashboard Creation
- Data Extraction and Transformation
- SQL Query Optimization
- Skilled in Microsoft Office Applications
- Cross-Functional Team Collaboration
- Pension Plan Administration
- Pension System Testing and Bug Resolution
- Requirements Analysis
- Business Requirements Document (BRD)
- Functional Requirements Document
Hobbies and Interests
Traveling, Listening Music, Playing Chess
Languages
English Upper intermediate (B2), Hindi Upper intermediate (B2), Kannada Intermediate (B1), Tulu (Mother Tongue) Upper intermediate (B2)
Accomplishments
- Received multiple Green Mile, You Have Earned It (YEI), and On-the-Spot Awards at Fidelity Investments for outstanding contributions to client satisfaction and commitment to delivering high-quality solutions.
References
References available upon request.
Timeline
Business Analyst
Fidelity Investments
06.2018 - Current
Senior Specialist - DB Calculation Team
Fidelity Investments
01.2014 - 06.2018
BFSI Process Executive
Infosys Ltd.
05.2011 - 12.2013
Bachelor of Science in MPCs - Mathematics, Physics,Computer Science
Mahatma Gandhi Memorial College, Udupi, Mangalore University
Similar Profiles
MICHAEL O'BRIENMICHAEL O'BRIEN
FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)
Nhi DoNhi Do
Transition Services Help Desk at Fidelity InvestmentsTransition Services Help Desk at Fidelity Investments
Jacob HallJacob Hall
Associate Systems Engineer at Fidelity InvestmentsAssociate Systems Engineer at Fidelity Investments