Summary

Overview

Work History

Education

Skills

Certification

Work Preference

Timeline

Dejas Sekar

Senior Business Analyst

Chennai

Summary

Experienced Business Analyst with 9 years in the Banking and Finance sector, specializing in Investment Banking and Credit Card projects. Skilled in system migrations, data modelling, and developing key business tools (booking systems, reconciliation, automation, KPI reporting). Proficient in Alteryx (Certified Designer Core) and SQL, with a strong background in Agile methodologies and cross-functional team collaboration.

Certified in SAFe for Teams 6.0, with experience mentoring junior team members and driving Agile practices to enhance team productivity. Passionate about using analytical and technical expertise to transition into a Product Owner role, focused on delivering impactful solutions in the Banking and Finance industry.

Overview

years of professional experience

years of post-secondary education

Certifications

Work History

Consultant

Capgemini Technology Services India Pvt Ltd

Chennai

08.2022 - Current

Data Architecture & Integration: Collaborated with backend data teams to design and develop a new internal data structure for the bank’s credit card business, migrating from legacy SAS systems to the Ab Initio ETL tool, ensuring seamless integration and improved data management processes.
Requirements Gathering & Stakeholder Management: Led requirements gathering sessions with business owners to replicate the existing data architecture, ensuring alignment with current banking activities and regulatory standards across departments (Risk, Client Relationship, Basel Norms, Debt Management, etc.).
Business Analysis & Reporting: Defined and documented business requirements for multiple internal teams, including model owners, risk analysts, and impairment teams, providing tailored reports and data models for their strategic banking activities.
Data Validation Model Creation: Spearheaded the development of a Functional Validation Model using SQL queries to reconcile customer data during the card lifecycle, working closely with developers to ensure accuracy and alignment with business objectives.
Product Ownership & Stakeholder Communication: Acted as Product Owner for an external reconciliation model built in Tableau, gathering and translating requirements, coordinating with stakeholders, and ensuring the final product met business needs for data visualization and reporting.
Agile Mentorship & Team Leadership: Mentored junior team members using Agile and SAFe methodologies, guiding them on best practices and helping them integrate into the project’s Agile framework.
Agile Certification & Training: Achieved SAFe for Teams 6.0 certification, providing leadership on Agile processes and delivering training and coaching to new joiners, fostering a culture of collaboration and continuous improvement within the team.
ETL Optimization & Technical Expertise: Contributed to optimizing the ETL pipeline by leveraging prior experience with Alteryx, ensuring smooth data flow from source to backend systems while maintaining quality and performance.

Senior Analyst

J.P. Morgan Chase & Co.

Bengaluru

01.2020 - 08.2022

Automation Project Leadership: Contributed to an Automation and Reporting Project aimed at delivering a robust tool for reconciling Capital Market trades and creating comprehensive KPI reports for the CIO/Treasury.
Data Analysis and Solution Design: Analyzed data to propose automation solutions using Xceptor, collaborating with stakeholders to ensure business alignment and securing necessary approvals.
Documentation and Approval: Created detailed data models in Microsoft Visio and developed User Acceptance Criteria (UAC) for testing, ensuring all requirements were met before implementation.
Verification and Quality Assurance: Worked closely with testers to verify automated reconciliation results, leveraging previous experience to ensure accuracy and efficiency.
KPI Reporting Development: Developed KPI reports using Alteryx following the successful automation of reconciliation processes, enhancing reporting capabilities for the CIO/Treasury.
Continuous Learning and Certification: Pursued certification in Alteryx Designer Core to improve reporting skills, successfully applying knowledge to build comprehensive KPI reports.
Agile Team Participation: Actively participated in an Agile cross-functional team, facilitating the backlog management process in a Kanban board environment to streamline workflow.

Process Executive

Societe Generale Global Solution Center

Bengaluru

12.2015 - 01.2020

Requirements Gathering: Collaborated with business end users to gather and analyze requirements for system development, enhancing operational efficiency.
Automation Success: Developed an Automated Reconciliation Tool in Visual Basic for the Middle Office Operations team, reducing manual processes and streamlining trade verification and approval for Primary Bonds and Warrants.
Recognition for Impact: Received recognition from the onshore team for significantly improving workflow and accuracy through automation.
System Transition: Led efforts to decommission legacy systems in Paris and replicate functionality with enhanced features in newly developed local server, supporting the transition of processes offshore.
Agile Methodology: Employed Agile methodology to manage project tasks and timelines, ensuring adaptability and responsiveness to business needs.
User Acceptance Testing: Established acceptance criteria and conducted User Acceptance Testing (UAT) to validate system functionality and user requirements.
Stakeholder Engagement: Provided regular demos to end users, showcasing system behavior and facilitating feedback for continuous improvement.
Documentation Expertise: Developed comprehensive project documentation, including Business Requirement Documents (BRDs), Standard Operating Procedures (SOPs), and Data Flow Diagrams using Microsoft Visio.

Education

Bachelor of Engineering - Civil Engineering

College of Engineering Guindy

Chennai, India

08.2010 - 05.2014

Skills

Business & Data Analysis: Requirements gathering, data analysis, documentation (BRDs, UAC), data modeling, and reporting

Automation & Technology: SQL, Alteryx, Tableau, Ab Initio ETL,Visual Basic, Xceptor, automation of processes, and system integration

Agile Project Management: Scrum, Kanban, Agile coaching, backlog management, and sprint execution

Data Migration & Process Transition: Legacy system decommissioning, data migration, and process transition to offshore systems

Stakeholder & Product Management: Stakeholder engagement, product ownership, user stories, UAT, and system validation

Certification

SAFe for Teams 6.0

Work Preference

Work Type

Full Time

Location Preference

Remote