Ganesh Jagwan

CITI - Genesis-

Genesis DWH, a centralized repository

for contracts and customer data, encompassing both risk

and non-risk related information. This comprehensive data

pool was distributed across 5 regions, resulting in

streamlined access and enhanced data management.

Roles & Responsibilities-

• As a Data analyst collect information from client, consult with BA and perform analysis based on which BRD and FRD will be created.
• Once development is done validate data in PAT environment and help to get sign off from client as well.
• Developed and maintained effective relationships with key stakeholders to better understand their needs and expectations.
• Enhanced overall team performance by providing regular coaching, feedback, and skill development opportunities.
• Implemented process improvements that led to reduced turnaround times for critical tasks without compromising quality.
• Increased customer satisfaction by ensuring timely completion of projects and adherence to high-quality standards.
• Optimized resource allocation by analyzing team member skills and project requirements, resulting in increased efficiency.
• Collaborated with other department leads to streamline workflows, improve interdepartmental coordination, and achieve business goals collectively.
• Trained new team members by relaying information on company procedures and safety requirements.

CITI - Genesis :-

Genesis DWH, a centralized repository

for contracts and customer data, encompassing both risk

and non-risk related information. This comprehensive data

pool was distributed across 5 regions, resulting in

streamlined access and enhanced data management.

We developed jobs for APAC/EMEA/CHINA.

Roles & Responsibilities:-

• Collect mapping from BA to design codes.
• Create ETL workflow, data work flows and architecture.
• Develope Unix scripts, programs, Bteq scripts to load data from one layer to another.
• Extract data from various source for testing purpose.
• Test code for accuracy and completeness and performance.
• Get the code review by tester and collect unit sigh-off.
• Debug the code based on tester suggestion.
• Join various call for project updates with client.

HSBC - Buy to let-

The Bank of England proposes to collect loan-level data

from firms relating to new buy-to-let lending. This will

provide greater analytical flexibility to users within the Bank

and reflects a growing demand from users of financial data

for more granularity. It will reduce the likelihood of requests

for additional data to firms on a regulator ad-hoc basis in

the future.

Roles & Responsibilities-

• Established effective communication channels with key stakeholders to ensure timely delivery of project milestones.
• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Streamlined data flow between multiple systems through the creation of efficient ETL pipelines and APIs.
• Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
• Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
• Conducted regular code reviews to ensure adherence to coding standards and maintain overall code quality across projects.
• Contributed significantly towards meeting project deadlines by maintaining a keen focus on task prioritization.

HSBC - Firefly -

Firefly project comes under john Louis Portfolio where our
source are MIPS, FD, Exprian and others external
organization. we will be getting files from each of the source
on daily /weekly/monthly basis. We need to processed them
as per business requirement and load the data into the
tables or Transmit to JL warehouse.

Roles & Responsibility :-

• Develop new jobs and unit testing. Support for UAT and
  Production.
• Resolve issues if there any in the batch/file and Inform
  upstream and down-stream if there any delay.
• Reduced processing time for ETL tasks through implementation of parallel execution strategies.
• Supported various ad hoc requests from end-users by delivering accurate datasets as per their requirements.
• Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before impact users.
• Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
• Monitor daily schedules and check for failure if any.

HSBC - Hadoop/Hive Migration:-

• As part of this migration project , data loaded from teradata to Hadoop .
• Data was loaded using Hive queries.
• Data was so huge, we have to load data in batch manner keeping 6 month data at once.
• We load data in background to load it overnight.
• Once batch is loaded we have to validate the data in Hadoop database.