Hi, I’m
SUDHARSAN GANESAN
Mississauga,Canada
Summary
Detail-oriented Data Engineer designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive applications in Banking and Finance domain.
Overview
12
years of professional experience
1
Certification
Work History
Wipro Technologies (Client : Citibank)
Big Data Engineer / Team Lead
08.2021 - Current
Job overview
- Spearheaded end-to-end design, development, and deployment of complex ETL pipelines for financial and regulatory reporting, leveraging Apache Spark (PySpark), Hive and HDFS
- Worked on On-Premise cloud platforms like CDH (Cloudera Distributed Hadoop) and CDP (Cloudera Data Platform).
- Designed and built complex rule-based engine that takes all the business rules and calculate them using huge volume of actuals data to report the RoTCE and SVA of the financial institution
- Successfully led a team of 4 engineers, mentoring and guiding them to deliver high-quality solutions within tight deadlines
- Collaborated closely with cross-functional teams including business analysts, and stakeholders to gather requirements and translate them into technical specifications
- Managed all metadata for the business rules using a Metadata Management (MDM) tool, Tibco EBX
- Leveraged advanced Oracle SQL skills to optimize queries and improve data retrieval efficiency, resulting in 20% reduction in report run times
- Introduced and implemented performance tuning techniques, enhancing overall pipeline efficiency
- Led the migration of legacy ETL processes to modern PySpark-based workflows, resulting in enhanced maintainability, scalability, and reduced maintenance costs
- Played a key role in ensuring compliance with regulatory standards, applying extensive domain knowledge of financial data and reporting requirements.
Wipro Technologies (Client : Citibank)
Programmer Analyst
10.2018 - 08.2021
Job overview
- Engineered end-to-end ETL pipelines using PySpark, Hive, and HDFS to process and transform large-scale financial datasets, improving data accuracy and accessibility
- Built the ETL jobs for monthly financial data acquisition from ledgers that validated and transformed the entire data and prepared it for financial and regulatory reporting
- Pipeline comprised of series of data quality checks, business validations, ALB checks, attributions, derivations, equitizations and inter-company eliminations
- Worked on data modeling exercises using Oracle RDBMS and Apache Hive to design efficient data models, ensuring data consistency and integrity throughout the reporting lifecycle
- Reduced the overall time by 30% for the whole data preparation process for financial reporting by optimizing the data models
- Re-designed the business process in ETL that performed the corporate Global Consolidations, resulting in 50% reduction in process runtime
- Analyzed the existing financial close modules for pain points and made process improvements by introducing automation
- Actively participated in code reviews, enforcing best practices and coding standards, resulting in higher-quality code and improved team efficiency.
Wipro Technologies (Client : Citibank)
Programmer Analyst
10.2015 - 09.2018
Job overview
- Engineered a huge data acquisition project that collects data from country ledgers across the globe and produced an enterprise-level view of the daily Balance Sheet.
- Architected the data models and partition strategy for the entire application that is capable of storing and retrieving millions of records in a day.
- Boosted the efficiency of overall data processing by 40% by optimizing the code and reduced the report generation time by 60% by updating the PL/SQL functions and SQL queries with hints, indexes, and materialized views.
- Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications.
- Contributed to successful project completion with effective time management and prioritization skills, meeting tight deadlines consistently.
Wipro Technologies Ltd.
PeopleSoft Techno-Functional Consultant
02.2012 - 10.2015
Job overview
- Maintained a high level of expertise within Oracle PeopleSoft EPM and GL modules.
- Designed and implemented Banking and Finance applications by creating sophisticated components and interfaces using PeopleSoft 9, App Designer 8.51, App Engine, and PeopleCode.
- Developed complex App engines by being proficient in SQL and PL/SQL.
- Conducted code reviews and recommended improvements to the existing PS processes.
- Continuously monitored PS job performances, proactively addressing potential issues before they escalated to avoid downtime..
- Increased user satisfaction by providing timely and accurate support for reported issues and concerns.
Education
Anna UniversityTamil Nadu, India
Bachelor of Engineering (Computer Science and Technology)
01.2011
Skills
- SQL
- Apache Spark (pySpark)
- Python Programming
- PL/SQL
- Hive
- Unix shell scripting
- BitBucket / Git Version Control
- Jenkins
- Tableau
- Microsoft Azure
Accomplishments
- Recognized with 'Best Subject Matter Expert (SME)' award for exemplary leadership and significant contribution to project success.
- Participated and won badges in online coding contests like Techgig, Codechef
- Completed basic and advanced courses on Tableau
Languages
English
Full Professional
Certification
- Databricks Certified Associate Developer for Apache Spark 3.0
Timeline
Big Data Engineer / Team Lead
Wipro Technologies (Client : Citibank)
08.2021 - Current
Programmer Analyst
Wipro Technologies (Client : Citibank)
10.2018 - 08.2021
Programmer Analyst
Wipro Technologies (Client : Citibank)
10.2015 - 09.2018
PeopleSoft Techno-Functional Consultant
Wipro Technologies Ltd.
02.2012 - 10.2015
Anna University
Bachelor of Engineering (Computer Science and Technology)
- Databricks Certified Associate Developer for Apache Spark 3.0
Similar Profiles
Rajkumar GuruswamyRajkumar Guruswamy
QA Automation Architect at Wipro Technologies, Chennai, India | Client: Edwards Life Sciences, USAQA Automation Architect at Wipro Technologies, Chennai, India | Client: Edwards Life Sciences, USA
SUPRIYA JONNAKUTISUPRIYA JONNAKUTI
SAP Security Consultant at Wipro Technologies (Philips Client)SAP Security Consultant at Wipro Technologies (Philips Client)
Prem Sundar APrem Sundar A
SoC Power Validation Engineer- Wearables & IoT at Client - Qualcomm,Hyderabad. Pay Roll - Wipro TechnologiesSoC Power Validation Engineer- Wearables & IoT at Client - Qualcomm,Hyderabad. Pay Roll - Wipro Technologies