Bakkiyalakshmi P
Lead Consultant
CHENNAI
Summary
At highly results oriented IT professional with 12 years of experience and a proved track record in supporting and maintaining project in Prodapt, RBS, WellsFargo, client Duetsche Bank and Credit Suisse . Currently working in Virtusa Consulting Services solutions for Client British telecom. A quick learner with the ability to work under pressure and meet deadlines. Develop relations with business community and the out sourced service providers, quick response to the changes and innovative in creating solutions are my key strengths. Smart working and committed with strong leadership and co-ordination skills
Overview
13
13
years of professional experience
6
6
years of post-secondary education
Work History
Lead consultant
Virtusa Consulting Services
Chennai
11.2022 - Current
- Roles and Responsibility:
- Involving in Technical interviews panel for informatica technology
- Training and mentoring the employees in oracle pl/sql and unix shell scripting.
Lead Engineer, Business Intelligence
PRODAPT SOLUTIONS
Chennai
01.2020 - 11.2022
- Advitium Data Migration:
- Advitium data migration is the development project to migration the SRIMS oracle data(table format) into the json format in couhbase database
- The SRIMS is existing data warehouse project which process fixed and mobile telecom data from various stream i.e: electrical, tower, STR(street)building, floorplan, hevacomp of BT into oracle database
- Roles and Responsibility:
- PL/SQL and Unix shell scripting coding to migrate data from oracle to couchbase and back-up the relevant files from Windows to UNIX environment
- Performing unit and integration testing for the developed Coding
- Preparing low and high level document for Advitium project
- Attending the daily scrum call and catchup call with client, BA and testing team
- Involving in requirement analysis with client to achieve business goal
- Set high standards to improve data and metadata by fixing data quality issues in existing application
- Maintain the version control of the developed code in GITHUB
- VTR, :
- The VTR Business Intelligence project handles data from multiple CRM sources, transforms & stores in an enterprise data warehouse from which the normalized data can be mined by business users as well as reporting via multiple delivery methods
- Roles and Responsibility:
- SSIS Job and report delivery monitoring
- Issue troubleshooting and resolution
- Sql server Database Management
- Performance issues in the critical BI jobs
- Assist in deployment and testing activities
- Prepare documents on BI jobs and implement processes wherever necessary
- Implement of tools to monitor/analyze to increase performance of jobs & database (E.g
- Sentry One)
- Weekly project update to clients and management
- Leading 6-member team
- Preparing metrics and discuss with onsite counterpart to improve the quality of work.
Professional
ROYAL BANK OF SCOTLAND
Bangalore
10.2017 - 01.2020
- Regulatory Reporting:
- The Regulatory Reporting team is in place to support the submission of Regulatory Returns to the FSA and IFSRA from a Group perspective
- Axiom support work closely with GCA, other teams within SSF and the business areas to collate the data required to support production of the returns, providing flexibility around timelines without compromising the submission deadlines
- Roles and Responsibility:
- Maintain a culture of continuous improvement, always looking at ways to improve the working practices in place
- Working closely with the project teams to ensure deliverables are in line with business requirements and supporting them in the definition of the business operating model
- Fixing daily job failures, user service request and working on user access
- Maintain database backups and recovery
- Creation of a new databases for test and dev
- Database auditing on scheme objects
- Oracle network Administration by Configuring tnsnames.ora, listener.ora
- Application Tuning using Explain plan, TKPROF with SQL trace
- Scheduling of jobs by using crontab on the project
- Performing hot and cold backups
- Performing logical backup using export utility and recovering specific object or schema using import utility and data pump
- Adding the additional datafiles to the existing tablespaces for resolving space issues
- Implemented Partitioning on huge tables to improve the performance
- Creating Relevant Indexes for the best Performance.Implementing the AXIOM releases and involving in migration and DR Activity
- Valuating Service Management KPI like CW, DR, CIA and GEL overdue and co-ordinate with concern team/Person to adhere the same.
Senior Analyst
WELLSFARGO EGS
Bangalore
07.2015 - 10.2017
- WDM (Wealth Data Mart), The WDM project is Single, Consistent, Business Validated Data Source of Commonly used Business functions of trust, private banking, family wealth, compliance, referrals and compensation, finance, brokerage, client link, and marketing
- This information is used by business and technology partners to enhance their strategic and tactical decision making
- WDM maintains vast amount of data in logical domains and robust security policies and practices are followed and enforced
- Roles and Responsibility:
- Supporting and maintaining the infrastructure and framework of Wealth Data Management
- WDM team supports both production and non-production systems
- Informatica administration support and promote code from lower environment to Prod FIX and production
- ETL Batch monitoring, working on SR & INC tickets and project Continuous improvement
- DB2 support: Deadlock, historical data load, Data replication, backups and user access in database
- Application certification and Vendor management(Teleran, Dataguise, Oracle, Informatica, IBM, etc) and User/service accounts certification, Audits and remediation for application used
- Involving in Releases Migration, BCP planning and testing
- JIRA and Change management (WOs, CRs, WRs) review, approve and execute
- As part of Information security management, User/service accounts certification, Audits and remediation, data masking in lower environment.
System Engineer
CREDIT SUISSE
Bangalore
06.2014 - 07.2015
- Credit Risk:
- Credit Risk application is the Risk management team for the Credit Suisse Investment Banking business, it offers securities products and financial advisory services to corporations, governments and institutional investors
- TITAN, Primo and EMG Risk Engines are globally used by the Credit Suisse in order to calculate risk and atlast ETL tool will be staged and incorporate the Business logics by data cleanse, process, combine and loaded into VRT Database
- Data warehoused data will be fetched using Excel add-in tool by the trader depends on their requirement
- Roles And Responsibility:
- To check Application Availability, Proactive, Corrective and their Maintenance
- Response to fix-on-fail production support issues and providing solutions to complex business critical applications during major incidents and if required escalating issues to development
- Project Metrics Analysis, Weekly and Monthly Reporting based on the Incident and Problem Management System based on ITIL practices
- Maintenance Operations and Enhancement Activities
- Creation of functional and support documents on various applications.
Software Engineer
Deutsche Bank, HCL
Bangalore
10.2010 - 06.2014
- DBFeeds (RWA):
- DB-Feeds is the implementation of an ETL Solution, to eliminate the point to point nature of the feeds process, together with the centralized management of enrichment and translation logic
- It acts as an interface between multiple systems that are spread across the bank
- It converts data (Cleansing) from different application into required format (GFIS)
- Handles HR, Finance and
- Risk weighted Asset
- Roles and Responsibility:
- ETL Batch monitoring, Incident and Service Request Management
- Knowledge management by creating KCS documents
- Problem Management for recurring S3 Incidents
- Involved in Disaster recovery planning and implementation
- Performing the code deployment with adhering to change management process
- Writing Shell Scripts & PL/SQL code to Automate the manual works
- Linguistic proficiency: English, Tamil
Education
B.Sc computer science -
Thiruvalluvar University
06.2007 - 05.2010
MBA - General
Annamalai University
06.2013 - 05.2016
Skills
Scripting Language: PL/SQL, SQL, Unix shell ScriptingOperating Systems: Windows, UNIXRDBMS: DB2, Sybase, oracle 9i, 10g, 11g, 12cETL/Other Tools: SSIS, Informatica, Geneos, autosys, Control-M, putty, TOAD, datastudio, SQL DeveloperTicket/mailing tool: Service now, JIRA, Remedy, DB symphony, lotus notes, Microsoft outlookReporting tool: Power Bi, AXIOM, OBIEEDOMAIN KNOWLEDGEInvestment BankingData warehousingData MigrationITILCredit RiskPlatform/Risk ManagementRegulatory ReportingTelecom
Client Relationships
Troubleshooting
Project processes
Data Warehousing
Product Life Cycle Management
Team Leadership & Development
Processes and procedures
Accomplishments
- Received 5 ‘Love Our Values’ from RBS Business users and developers for the best performance during Submissions.
- Wells Fargo awarded ‘Achieving Excellence’ award for the 4th quarter in 2016.
- Wells Fargo awarded ‘Star of the week’ award for the 1st quarter in 2017.
- Awarded with ‘LIVE WIRE’ HCL Motivation certificate for the best performance in project. Involved in Transition phase of the project.
Timeline
Lead consultant
Virtusa Consulting Services
11.2022 - Current
Lead Engineer, Business Intelligence
PRODAPT SOLUTIONS
01.2020 - 11.2022
Professional
ROYAL BANK OF SCOTLAND
10.2017 - 01.2020
Senior Analyst
WELLSFARGO EGS
07.2015 - 10.2017
System Engineer
CREDIT SUISSE
06.2014 - 07.2015
MBA - General
Annamalai University
06.2013 - 05.2016
Software Engineer
Deutsche Bank, HCL
10.2010 - 06.2014
B.Sc computer science -
Thiruvalluvar University
06.2007 - 05.2010