Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Interests
Timeline
Hobbies and Interests
Software
Best SME for continuous 6 quarters
Generic
SANTHOSH KUMAR PANDRANKI

SANTHOSH KUMAR PANDRANKI

Hyderabad,India

Summary

Analytical and reporting professional with expertise in SAS, SQL, Tableau, Power BI and Python, specializing in data visualization and key performance indicators (KPIs) across diverse markets. Proven ability to monitor trends through comprehensive dashboards, uncover hidden insights with Tableau & Power BI, Data Management with SAS, SQL and share findings effectively using Tableau Online and Server. Extensive knowledge of Corporate Risk analytics & Risk engagement, combined with hands-on experience in managing credit card and complete retail banking products and their profitability metrics. Proficient in leveraging Toad, PySpark for large-scale data processing and machine learning, consistently delivering high-performance data solutions that drive informed decision-making across teams and departments.

Qualified Analytical Manager with proven track record in leading teams and driving operational efficiency. Demonstrated ability to implement strategic initiatives that enhance productivity and foster growth. Known for utilizing strong leadership and communication skills to facilitate team collaboration and achieve organizational goals.

Experienced with strategic planning, team leadership, and operational management. Utilizes comprehensive business acumen to drive efficiency and innovation. Track record of fostering collaborative environments and achieving high-impact results.

Management professional, bringing strategic leadership and operational excellence to drive organizational success. Skilled in project management, team collaboration, and process optimization with keen focus on achieving results. Adept at navigating complex challenges, fostering culture of accountability, and adapting to evolving business needs. Known for strong decision-making, effective communication, and building high-performing teams.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Manager

Wellsfargo
03.2023 - 07.2025
  • Tools used: Tableau, Python, SQL, Power BI, Teradata, Toad, Base SAS, SAS/SQL, SAS MACRO, and SAS/CONNECT, ORACLE, UNIX,DB2, SAS EG, Excel, Access, Excel VBA.
  • Analytics, Reporting and Data Testing in Risk Engagements for 2LOD (Second Line of Defense).
  • Risk Engagements related to multiple banking products like Credit Cards,Home lending, Auto Loans,Personal Loans,Etc.
  • Initiated various Tableau /Power BI dashboards for Data Reporting and visualization as per stake holder requirements.
  • Extensive work related to risk analytics in view of corporate risk, risk engagements in customer remediation and validation and data testing using above mentioned tools.
  • Drive business idea migration and manage ideas and imbibe into team fabric.
  • Held monthly meetings to create business plans and workshops to drive successful business.
  • Developed proposals and presentations for internal and external audiences.
  • Being SME , planned and executed functional trainings, skill upgrade trainings wherever required.
  • Evaluated hiring and promotions requests.
  • Developed and implemented new filing systems to improve organizational efficiency and productivity.
  • Provided strong leadership to enhance team productivity and morale.
  • Led cross-functional teams to achieve project milestones and deliver high-quality results.
  • Established strong relationships with clients and stakeholders, ensuring long-term partnerships and repeat business.
  • Improved team performance by providing comprehensive training and fostering a collaborative work environment.
  • Collaborated closely with peers from other departments to drive organizational success jointly as one cohesive unit.
  • Reduced costs, optimized resource allocation, and improved efficiency in managing projects.
  • Managed large-scale projects and introduced new systems, tools, and processes to achieve challenging objectives.
  • Mentored junior staff members for skill development and career progression within the organization.
  • Implemented and developed operational standards, policies and procedures.
  • Achieved operational excellence by streamlining processes and implementing best practices.
  • Demonstrated exceptional adaptability in navigating complex situations or rapidly changing environments with ease.

Associate Manager

CitiBank NA
01.2021 - 03.2023
  • Tools used: Tableau, Python, PySpark, SQL, Base SAS, SAS/SQL, SAS MACRO, and SAS/CONNECT, ORACLE, UNIX,DB2, SAS EG, Excel, Access,Excel VBA
  • Description:
  • SAS & Tableau SME in team.
  • Worked on SAS to Python Migration project , Handling large data workloads, converting existing SAS codes to Python codes used PySpark, Jupyter Notebook, Pandas, NumPy Libraries.
  • Large Data Processing, analytics and data integration using pyspark.
  • Improving existing tableau projects, dashboards, using both published datasource and embedded datasources.
  • Piloted new project in implementing Tableau in reporting deliverables ,Harnessing Tableau in providing better visualizations on products in Citibank Bidding going on now
  • Extensive analysis role comprising Tableau , SAS, SQL, excel , handling ad hoc requests on data, implementing Tableau wherever necessary in role, Delegating and Managing stakeholders on their requested analysis of data, Regulatory submissions
  • Role:
  • Extensive use of Tableau for creating Dashboards, Implementing Tableau to all possible existing Excel Activities, reports
  • Also involved in administration tasks such as publishing workbooks, managing ownerships, providing access to users and adding them to specific group/row level security in Tableau Server
  • Reporting and publishing required trends of KPI using Tableau
  • Mastered ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
  • Extracting data from production data warehouse, Oracle, db2 database server using SAS, SQL and other conventional tools
  • Automating and scheduling regular reporting Processes Using SAS as per stakeholder requirement
  • Maintaining data as per compliance and audit requirement standards
  • Ad-hoc request handling on various new queries.
  • Collaborated closely with senior management on strategic planning efforts, aligning departmental goals with overarching company objectives.
  • Remedied issues and conflicts among workers using negotiation and active listening.
  • Successfully managed multiple high-priority tasks simultaneously while maintaining strict deadlines ensuring optimal resource allocation.
  • Established strong relationships with key stakeholders, fostering collaboration and mutual support.

Team Lead / Specialist

Standard chartered Global Business Solutions
07.2017 - 01.2021
  • Tools used: Tableau, Python, SQL, Base SAS, SAS/SQL, SAS MACRO, and SAS/CONNECT, UNIX, SAS EG, Excel, Access, MS Excel VBA
  • Description:
  • Standard Chartered Global Business Services formerly Scope International is an in-house technology & operations service provider for Standard chartered bank
  • Global Analytics team provides and caters for all data required for making decisions by datamarting and reporting of all KPI's, Trends, Supporting all Product and segment teams by providing insights on key performance Indicators which in turn will help to take profitable decisions
  • Piloted project in converting very important excel reporting activity into tableau dashboard and successfully implemented from scratch to complete successful delivery of project for about 6 countries of standard chartered group countries
  • Evaluated employee skills and knowledge regularly, training, and mentoring individuals with lagging skills.
  • Extensive use of calculations, LODs , Table calculations, Filters, Actions and parameters.
  • Role:
  • Extensive use of tableau for creating reports from trusted data sources
  • Also involved in administration tasks such as publishing workbooks, managing ownerships, providing access to users and adding them to specific group in Tableau Server
  • Reporting and publishing required trends of KPI using Tableau
  • Mastered ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
  • Comprehensive knowledge on secured lending and unsecured lending for retail banking business
  • Extracting data from production data warehouse, db2 server using SAS, SQL and other conventional tools
  • Automating and scheduling regular reporting Processes Using SAS as per stakeholder requirement
  • Maintaining data as per compliance and audit requirement standards of Bank
  • Delivering Monthly and Weekly financial KPI reports for analytical purposes and trend projection
  • Track performance of liabilities and assets products on portfolio level and analyze customer's product holding movement and portfolio behavior on different products
  • Act as single point of contact for all data requirements for complete liabilities and assets products of retail banking for Singapore region
  • Manage delivery of all Support Analytics and reporting needs of Retail banking products
  • Working closely with Technology and Ops function and Data warehousing teams on solutions covering data quality, data assurance, and timelines, data security governance.
  • Coached team members in techniques necessary to complete job tasks
  • Trained new team members by relaying information on company procedures and safety requirements.
  • Promoted a positive work environment by fostering teamwork, open communication, and employee recognition initiatives.
  • Served as a role model for the team by demonstrating commitment to excellence, professionalism, and adherence to company values at all times.
  • Coached team members in techniques necessary to complete job tasks.

CSE

HSBC EDPI LTD
10.2013 - 07.2017
  • Tools Used: SAS tools (Base SAS, SQL, SAS/Connect) SQL, Excel and Access.
  • Description:
  • HSBC GSC is one of service centers which support HSBC bank in day to day operations i.e. backend support for banking operations, technical support to customers etc.
  • Our team supports HSBC in USA by providing services such as Creation of Reporting Data mart, delivery of reports, Day to Day Reporting of the Operations related to Collections & Payments
  • These reports were initially generated using Excel and other relational Databases like oracle and exported to Access database
  • Role:
  • Gather requirements from support partner
  • Worked on tool called Discover to drill down to product to be analyzed and generate flat file
  • Retrieve data from flat files and convert them to SAS data sets for Analysis
  • Validate data using several SAS Procedures
  • Create various user-defined formats and in formats
  • Transform data using SAS Functions and procedures according to analysis needs
  • Develop tabular and summary reports using SAS Procedures
  • Automate process using SAS Macros
  • Enforcing Labels and Formats to variables
  • Transforming data using SAS Base and macros
  • Adding new variables to existing Data marts as per requirements
  • Developed applications to rollup monthly data into monthly Data marts
  • Good knowledge on AML & sanction policies and compliance of same
  • Knowledge on FATF and WOLF screening
  • Actively participated in requirement analysis discussions with fellow team mates
  • ACHIEVEMENTS
  • Received appreciation from management on various occasions for my analytical and presentation skills
  • Automated and simplifies processes to reduce TAT of activity
  • Was part of team for implementing SAS best practices
  • Conducted SAS Code reviews of codes written by peers
  • Developed Standardized SAS procedures /Routines for future usage
  • Currently acting as subject matter expert in team for information on data needs and planning of data projects executed
  • Automated Critical financial reports related to Collections & payments portfolio for HSBC which helped in reducing the time spent on manual reporting.
  • Self-motivated, with a strong sense of personal responsibility.
  • Worked effectively in fast-paced environments.

Education

PGDC - Power Plant Technology

JSWECE, MSRIT, VTU
Toranagallu, Bellary
04.2012

Bachelor of Science - Mechanical Engineering Technology

MVGR College of Engineering
05.2009

Skills

  • Tableau Desktop / Server
  • SQL
  • Base SAS,SAS Macro
  • Python
  • Power BI
  • Teradata
  • Toad Data Point
  • Excel VBA, Excel with AI Tools
  • Strategic planning
  • Cross-functional collaboration
  • Operations management
  • Cross-functional team coordination
  • Data-driven decision making

Accomplishments

  • Resolved product issue through consumer testing.
  • Achieved Online dashboard by introducing Tableau, Power BI for Manual excel reporting tasks.
  • Used Tableau & Power BI & Microsoft Excel to develop inventory tracking spreadsheets & creating auto Updating Dashboard as per stakeholder requirements.
  • Supervised team of 18 staff members.
  • Collaborated with team of 6 in the development of Tableau Migration Project from Manual Excel activity.

Certification

Tableau Desktop Specialist & SAS Certified Specialist

Languages

English
Hindi
Telugu
Tamil

Interests

  • I participate in low-impact exercises to strengthen core muscles
  • Mindfulness Practices
  • I participate in various sports activities for physical activity, camaraderie, and personal growth
  • Team Sports
  • Swimming
  • Committed to improving personal fitness through regular participation in Soccer
  • Passionate about balancing physical health with mental and emotional wellness

Timeline

Senior Manager

Wellsfargo
03.2023 - 07.2025

Associate Manager

CitiBank NA
01.2021 - 03.2023

Team Lead / Specialist

Standard chartered Global Business Solutions
07.2017 - 01.2021

CSE

HSBC EDPI LTD
10.2013 - 07.2017

Bachelor of Science - Mechanical Engineering Technology

MVGR College of Engineering

PGDC - Power Plant Technology

JSWECE, MSRIT, VTU

Hobbies and Interests

water sports like water polo,Kayaking, Canoeing, Water Surfing,Para Sailing and Horse Riding

Software

  • Tableau
  • Python
  • SQL
  • SAS
  • Excel VBA
  • Power BI
  • Teradata
  • Toad

Best SME for continuous 6 quarters

Awarded best Subject Matter Expert for 6 continuous quarters for mentoring freshers, be a critical help to mid and senior staff in their code reviews, product Knowledge and Business Knowledge.

Similar Profiles

CREATE PROFILE