Data Analytics Machine Learning
Resume:
ONLINE PROFILES
SUMMARY
SANTHOSH KUMAR
PANDRANKI
■ Normal, USA 61761 ■ +1-309-***-**** ■ ******************@*****.*** ■
• linkedin.com/in/santhosh-pandranki-a12011105
Analytical professional with 15+ years of extensive Data Analytics and Management Experience.
•
Experience in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS/EG, SAS/Connect, SAS Studio, SAS/DDE and a strong knowledge of SQL.
•
Profound knowledge and strong experience in merging SAS Data Sets, PROCs, Producing Reports, SAS Formats, SAS Functions, SAS INFORMATs, Storing and Managing Data. Strong Competence in carrying out statistical analysis of large- scale data using SAS procedures.
•
• SAS Macro experience in creating reusuable sas macros. Developed and maintained complex SAS programs, macros, and automated scripts for efficient data updates, cleansing, and reporting.
•
Analytical and reporting professional with expertise in SAS, SQL, Python, specializing in Data Marting and key performance indicators (KPIs) across diverse retail banking products and markets.
•
Proficient in using PROC SQL and various SAS procedures for data manipulation, analysis, and reporting.
•
Proficient in working on Pass Through Facility in (PROC SQL) to ensure smooth working and less time and data space occupancy during database operations.
•
Successfully integrated Oracle with SAS for extracting, transforming, and loading (ETL) processes, improving the accuracy and speed of data analysis.
•
Developed and maintained complex SAS programs, macros, and automated scripts for efficient data updates, cleansing, and reporting.
•
Successfully implemented SAS automation processes and migrated SAS scripts to enhance operational efficiency.
•
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.
•
ACCOMPLISHMENTS
EXPERIENCE
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.
•
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.
•
Professional business leader prepared for challenges of Senior Manager role. Combines deep understanding of business operations with commitment to driving team success and achieving significant results. Renowned for adaptability in dynamic environments and collaborative approach to problem-solving, leveraging keen analytical and decision- making skills.
•
• 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.
•
HIGHLIGHTS • Base SAS • SAS Macro
• Teradata • Strategic planning
• Cross-functional team coordination • SQL
• Toad Data Point • Cross-functional collaboration
• Data-driven decision making • Python
• Excel VBA • Excel with AI Tools
• Operations management • Troubleshooting and problem resolution LEAD SAS DEVELOPER 03/2023 to 07/2025
Wells Fargo, Charlotte, NC, USA
• Sound experience in converting SAS Models to PySpark and Python. Experience in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS/EG, SAS/Connect, SAS Studio, SAS/DDE and a strong knowledge of SQL.
•
Profound knowledge and strong experience in merging SAS Data Sets, PROCs, Producing Reports, SAS Formats, SAS Functions, SAS INFORMATs, Storing and Managing Data.
•
Strong Competence in carrying out statistical analysis of large-scale data using SAS procedures.
•
Proficient in using PROC SQL and various SAS procedures for data manipulation, analysis, and reporting.
•
Proficient in working on Pass Through Facility in (PROC SQL) to ensure smooth working and less time and data space occupancy during database operations.
•
• SAS Macro experience in creating reusable SAS macros. Developed and maintained complex SAS programs, macros, and automated scripts for efficient data updates, cleansing, and reporting.
•
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.
•
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.
•
SR SAS DEVELOPER 01/2021 to 03/2023
Citibank NA, India
Company Overview: Citibank NA is a global bank providing financial services and products.
•
• SAS 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.
•
Experience in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS/EG, SAS/Connect, SAS Studio, SAS/DDE and a strong knowledge of SQL.
•
• Large Data Processing, analytics and data integration using PySpark. Improving existing Tableau projects, dashboards, using both published datasource and embedded data sources.
•
• Used SAS to handle Ad-hoc required across multiple database for CITI bank. 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.
•
• Extensive use of SAS for creating Data sets, manipulation of data, etc. 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.
• 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.
•
• Citibank NA is a global bank providing financial services and products. SR SAS DEVELOPER 07/2017 to 01/2021
Standard Chartered Global Business Solutions, India Company Overview: Standard Chartered Global Business Services formerly Scope International is an in-house technology & operations service provider for Standard Chartered Bank.
•
Expertise in Base and Advanced SAS programming, merging SAS data sets, Macro facility, SAS Functions, storing and managing data in SAS files.
•
Experience in Base SAS, Advanced SAS, SAS EG, SAS DI tool, SAS OA, SAS studio, informatica (ETL) and SAS BI tools/visual analytics.
•
Global Analytics team provides and caters for all data required for making decisions by data marshalling and reporting of all KPIs, Trends, Supporting all Product and segment teams by providing insights on key performance Indicators which in turn will help to take profitable decisions.
•
• Handled Ad-hoc SAS code development for 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.
• 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.
•
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.
• Possess strong ability to quickly adapt to new applications and platforms. 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. EDUCATION
CERTIFICATIONS
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.
•
Standard Chartered Global Business Services formerly Scope International is an in-house technology & operations service provider for Standard Chartered Bank.
•
SAS DEVELOPER 10/2009 to 07/2017
CSE HSBC EDPI LTD, India
Company Overview: 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.
•
• 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. 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.
•
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.
Bachelor of Science : Mechanical Engineering Technology, 05/2009 MVGR College of Engineering - Vizianagaram
• Tableau Desktop Specialist
PROJECT
AWARDS
HOBBIES AND
INTERESTS
• SAS Certified Specialist
Score Cards Tableau Dashboard for Front line Marketing executives across Group. SAS to Python code review and Code conversions. Mentoring and teaching Tableau to Team members. SAS/ SQL Speed test in team for quick refresh of Language. 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.
• 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.
Contact this candidate