Manish Roy
Howrah
Summary
Over 8.5+ years of IT experience in Data warehousing and Business intelligence in Banking and Finance domain with an emphasis on Application Design, Development, implementation, and maintenance of client/server Data Warehouse. Seeking to have a challenging career in Data Warehousing and Business Intelligence with growth potential in technical as well as functional domains and to work in critical and time-bound projects where can apply technological skills and knowledge in the best possible way.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Technical Lead (IT)
HCL Technologies
01.2024 - Current
- Working in a team of 10 members in the Anti-Money Laundering (AML-Nexus) application of a US Banking client.
- Bulk loading from external stage (AWS S3), internal stage to snowflake cloud using the COPY command.
- Loading data into snowflake tables from internal stage using snowsql.
- Used COPY, LIST, PUT and GET commands for validating internal stage files.
- Used import and Export from internal stage (snowflake) and from external stage (AWS S3).
- Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.
- Used SNOW PIPE for continuous data ingestion from S3 bucket.
- Created clone objects to maintain zero-copy cloning.
- Loaded data into CSV and then to Snowflake using DBT
- Cloned Production data for code modifications and testing
- Monitored and troubleshooted data loads and data quality issues.
Deputy Manager
Union Bank of India
07.2022 - 01.2024
- Worked as Deputy Manager handling responsibilities of day to day operational and functional tasks of Nationalized Bank.
- Implemented seamless banking keeping Anti-Money laundering(AML) practices in place.
- Enhanced branch production rates by handling staff efficiency, evaluations, hiring, and termination processes and coaching employees on company protocol and payroll operations.
- Assessed employee performance and developed improvement plans.
- Met deadlines by proactively managing individual and team tasks and streamlining processes.
- Created strategies to develop and expand existing customer sales, resulting in increase in annual sales.
- In charge of all operations, including market assessment, forecasts, setting financial goals and achieving branch business objectives, including attaining deliverables on time.
- Generated financial and operational reports to assist management with business strategy.
Assistant Manager
Paschim Banga Gramin Bank
04.2022 - 06.2022
- Worked as Assistant Manager(trainee) ,handling responsibilities of day to day operational and functional tasks of Regional Rural Bank.
- Generated repeat business through exceptional customer service and responded to customer concerns with friendly and knowledgeable service.
- Offered hands-on assistance to customers, assessing needs, and maintaining current knowledge of consumer preferences.
- Monitored cash intake and deposit records, increasing accuracy, and reducing discrepancies.
- Managed Customer accounts and monitored them to offer different banking products, thereby increasing business profits and financial inclusion to rural and semi-urban sector.
IT Analyst
Tata Consultancy Services Limited (TCSL)
10.2015 - 04.2022
- Developed and implemented a robust data pipeline using Snowflake's advanced features, enhancing the data flow efficiency and significantly improving the data quality.
- Crafted and maintained ETL pipelines that processed over 1 million records daily, ensuring data accuracy and accessibility.
- Customized SnowSQL scripts to enhance data load performance, accommodating an increase in data volume.
- Facilitated team knowledge sharing by documenting ETL and data transformation techniques, which reduced onboarding time significantly.
- Extensively used complex SQL queries for Data validations based on the business requirements.
- Participated in daily Scrum meetings and weekly project planning and status sessions.
- Performed SOX audits of the servers and application and resolved the security vulnerabilities of the server.
- Bug fixing of the application's PL/SQL code and performed data extraction using SQL queries.
- Managed service communications and stakeholder confidence for incidents, Service requests and applications management.
- Analyzed and resolved data reconciliation issues in batch processing during financial Month Ends and Year Ends.
- Transferred files to different servers using SFTP and SSH file transfer protocols.
- Managed SLAs for incidents and service requests.
Education
Bachelor of Technology - Electronics And Communications Engineering
College of Engineering And Management, Kolaghat
Kolaghat, India07.2015
Skills
- Cloud Technologies: Snowflake
- Programming Languages: PL/SQL, SnowSQL
- DataWarehousing: Snowflake
- ETL: IBM DataStage
- DBMS: Oracle, MS SQL Server, PostgreSQL
- Operating System: Windows, Linux
- Tools: Data Build Tool (DBT), Control-M, WinScp, Putty, Toad, Oracle SQL Developer, MS Office, HPSM
Certification
Languages Known: English, Hindi, Bengali
Date of Birth: 05-09-1993 (DD-MM-YYYY)
Marital Status: Single
Nationality: Indian
Timeline
Technical Lead (IT)
HCL Technologies
01.2024 - Current
Deputy Manager
Union Bank of India
07.2022 - 01.2024
Assistant Manager
Paschim Banga Gramin Bank
04.2022 - 06.2022
IT Analyst
Tata Consultancy Services Limited (TCSL)
10.2015 - 04.2022
Bachelor of Technology - Electronics And Communications Engineering
College of Engineering And Management, Kolaghat
Similar Profiles
Srinivasan NandagopalSrinivasan Nandagopal
ETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ LtdETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ Ltd
Pooja SaxenaPooja Saxena
Senior Analyst at HCL Technologies Pvt. Ltd, HCL technologies Pvt LtdSenior Analyst at HCL Technologies Pvt. Ltd, HCL technologies Pvt Ltd
GIRISH KORIGIRISH KORI
Senior Software Test Engineer / Technical Leader at HCL Technologies Ltd. & HCL GMBHSenior Software Test Engineer / Technical Leader at HCL Technologies Ltd. & HCL GMBH
Abhishek KumarAbhishek Kumar
Data Engineer/Technical Lead at HCL Technologies Limited (HCL Tech)Data Engineer/Technical Lead at HCL Technologies Limited (HCL Tech)
Bibek DasBibek Das
Diploma Engineer Trainee - C&I at Wood India Engineering and Projects Pvt LtdDiploma Engineer Trainee - C&I at Wood India Engineering and Projects Pvt Ltd