Professional with extensive experience in Application Development, Support & Maintenance in Banking and Financial domain. Skilled in Oracle PL/SQL, Ab Initio (ETL) and Unix. Proficient in working in stimulating and challenging environment.Closely worked with Business users and customers from understanding requirements to providing end user delivery and support.Hardworking, good in guiding and managing team and efficient in delivering defect free products in short deadlines.
-
Senior ConsultantInfosys Nov 2022 - PresentKolkata, West Bengal, India -
Technical LeadTata Consultancy Services Oct 2017 - Oct 2022Kolkata, West Bengal, IndiaCitibank - Geographic Revenue Attribute Calculation Engine➢ The project objective is to automate the geographic revenue calculation process in a standardized way and make it available globally so that any Citi user can access the reports from any country without operational and control risks➢ Actively interacting with Business users/analysts to gather project requirements, analysis of the BRD for providing architectural solutions and capturing them in FRD and TSD➢ Guiding and leading DEV, SIT and UI development team members for understanding the business needs and properly delivering the products➢ Working in Defect prevention, Code Optimization and Automation activities to reduce manual efforts and flaws➢ Partner with business resources to troubleshoot issues, manage capacity, and plan for the optimization and expansion of environments➢ Collaborate with the architects, developers, business analysts and company executives to determine the software’s technical direction, system design and implementation plan -
Etl DeveloperTata Consultancy Services Aug 2015 - Sep 2017Kolkata, West Bengal, IndiaCitibank - Allocation Processing Settlement System➢ Allocation processing and settlement system is built to deliver E2E processing capability for handling intercompany GOC to GOC expense, revenue, or balance sheet allocations globally within Citi and to form a key service capability for planning/budgeting/forecasting expenses➢ Actively promotes and participates in process improvement. Be part of architecture review team and assist in development of processes and applications➢ Provide technical consultation and support in the development of ETL applications and programs for data warehousing class of system➢ Provide critical thinking to develop creative and innovative solutions to the business problem➢ Develop Ab Initio code to process EXCEL and DATA files as well as database retrievals in an agile environment➢ Serve as technical SME in all phases of system life cycle (gap analysis, design, develop, implement)➢ Serve as project team liaison with business partners to analyze the impact of new requests and business process changes on existing systems and processes -
Application SupportTata Consultancy Services Mar 2011 - Jul 2015Kolkata, West Bengal, IndiaCitibank - Global Production Assurance Support➢ Global Production Assurance (GPA) support team in Citi works globally to provide customer support and works towards optimizing the IT environment by standardizing production platforms➢ Supporting Batch processing (Abinitio) across Citi for different regions (APAC, EMEA, NAM, LATAM and Global), modules and applications.➢ Monitoring ETL jobs through Control Centre and Autosys and taking necessary action in case of any failure due to Data issue, DB issue etc. during the loading process➢ Automating all the repetitive and time-consuming manual processes to reduce manual effort and timing➢ Dealing with Citi clients for regular status reporting for each application, any application issue or batch failures and coordinating different teams to find out the resolution➢ Supporting daily production activities with extensive knowledge in Unix shell scripting and Ab Initio development (components usage, EME, migration process, branching etc.) and Using Database level analysis (PL/SQL queries execution on ORACLE Developer) to support customer queries -
Application DeveloperTata Consultancy Services Mar 2010 - Feb 2011Mumbai, Maharashtra, IndiaCanadian Imperial Bank of Commerce - Product Data Management➢ Migration of Job scheduler (Tidal to Autosys)➢ Preparation of a Case Study based on Tidal to Autosys Migration for CIBC L-Bank➢ Analyzing the FRD provided by the client, designing the TSD and after developing the code execution of UT, DIT and SIT plans➢ Being a part of the development structure and team, played a significant role in solving and facilitating the business to flow without a hitch -
Assistant System Engineer TraineeTata Consultancy Services Oct 2009 - Mar 2010Mumbai, Maharashtra, India
Sudipa Roy Education Details
-
Kalyani Government Engineering College 1028.25 -
Rajlakshmi Kanya Vidyapith89.25%
Frequently Asked Questions about Sudipa Roy
What company does Sudipa Roy work for?
Sudipa Roy works for Infosys
What is Sudipa Roy's role at the current company?
Sudipa Roy's current role is Senior Consultant.
What schools did Sudipa Roy attend?
Sudipa Roy attended Kalyani Government Engineering College 102, Kalyani University Experimental High School, Rajlakshmi Kanya Vidyapith.
Who are Sudipa Roy's colleagues?
Sudipa Roy's colleagues are Afreen Khan, Padmanabha Bhat, Pallavi Sharma, Mayur Karpe, Susmitha Reddy, Satz T, Krapa Noronha.
Not the Sudipa Roy you were looking for?
-
Sudipa Roy
Mumbai -
-
Sudipa Roy
Kolkata -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial