Tableau


Results-driven Workforce Management Manager with 15 years of experience leading teams and optimizing operations through strategic planning and data analysis. Skilled in aligning staffing strategies with business goals and collaborating across departments to enhance talent development. Committed to fostering accountability and driving outcomes that support company success.
Key duties:
Managed GBS GMO business support while collaborating closely with the COO on reporting governance improvements. Ensured thorough data consolidation for effective business-level reporting. Integrated key scorecard metrics across all sub-lobs, focusing on operations, and risk components. Handled forecasting, budgeting, and headcount management efficiently. Supervised operational tools at the GBS level aimed at addressing audit control issues. Pursued operational excellence through dedicated efforts toward responsible growth. Interacted regularly with senior management and various stakeholders to maintain transparency. Promptly escalated issues for rapid resolution.
Coordinate activities:
Strategy development
Performance optimization
Data analysis
Excel automation expertise
Power Apps development
Team management
Resource coordination
Collaborative decision-making
Experienced with VS Code
GitHub engagement
Copilot prompting
Mainframe PSI Macro - VBA Macro Bank of America
Description: PSI Macro shows all the borrow charges on stock loans which needs to be enter in Mainframe application {IBM QWS3270). The normal Manual Hours takes Approx. 03 Hours for 180 Entries wherein Macro does the same job in 10 mins without any issue.
Responsibilities:
• Collect the Data File from SourceATCS.
• Created a Macro were it will open QWS3270 application through TELNET connection
• Auto Enters or post the transaction details to mainframe
• Auto corrections the incorrect accounts details/Charges. Same highlight and represents the lines as miss in the report.
Susquehanna Settlements - VBA Macro Bank of America
Description: Susquehanna Macro shows the SOD/MOD/EOD all fail numbers by market and also by work driver for Settlement team. The normal Manual Hours takes Approx. 02 Hours per day to finish 3 Reports wherein Macro does the same job just in 01 min without any issue
Responsibilities:
• Collated the required information from the different sources like CSW Application.
• Created a Macro with interactive options to show Daily Fails, Market Wise, Pipeline business and Work Driver or dedicated associate for all the Susquehanna Markets
• Refreshing the all the Pivot tables dynamically.
• Auto Generate and sends the email once the report is Ready.
Euroclear Borrows Report -VBA Macro Bank of America
Description: Euroclear Macro shows the all the Borrows (securities) taken from Euroclear bank. The normal Manual Hours takes Approx. 02 Hours per day to finish 3 Reports wherein Macro does the same job just in 01 min without any issue
Responsibilities:
• Collated the required information from the different sources like CSW Application, Euroclear clearing house, MARS Database Etc.
• Created a Macro Were it will populate all the securities with Borrow Charges with all required condition.
• Generate and calculates all the charges for bank in separate sheet.
• Auto Generate and sends the email once the report is Ready.
• Also added a feature to validate the filled in information.
Tableau
Alteryx
Power Platform
Power Apps
VBA Microsoft Developer
Tableau
VBA Microsoft Developer