Jan 2019 – Jun 2021 · 2 yrs 5 mos

• End to end Product management - Design, Conceptualization, prioritization, testing, and client engagement for an Advisor facing application critical for client.
• Worked closely with UX/UI Designers, Back End Services team, Platform Engineering Teams, DBAs, Client Leaderships and other cross development teams to execute product releases and to drive continuous innovation.
• Perform activities related to Agile/Scrum and managing User Stories and Backlogs through Jira.
• Providing Technical Architecture direction for SD team to resolve some of the critical technology problems.
• Worked on a constructive solution with Cross platform teams to avoid usage of adobe reader for blob parsing in turn saving $50K from SD Budget.
• Improved Agile scrum model by effectively leading scrum of scrums with multiple SD, QA and BA Teams to develop the product effectively.
• Owned key product/business metrics and define the strategy and road-map to achieve the goals.
• Used Informatica IDQ for Data Analysis.
• Worked Proof of concept for AWS where data was sent to AWS Datalake and from there it was fetched through on premise PowerBI [To work on PoC did TCS SuperLeage program for AWS and got AWS Cloud Practitioner certification]
• Received Award for excellence from TCS for exceptional effort in executing the product development.

Jan 2017 – Dec 2018 · 1 yr 11 mos

• Received a special award from Client and TCS Leadership for leading and handling National Day of Mourning activities on Dec 5th The whole Financial Market was declared holiday and due to large settlement processing, all the brokerage related processing was running and majority of the brokerage systems were handled manually.
• Handled Multiple projects on Informatica and Oracle Platform as a Onshore Tech Lead.
• Conducted Design discussions and meetings to come out with the appropriate Data warehouse at the lowest level of grain for each of the Dimensions involved.
• Re-designed the existing Star Schema model to Snowflake model in order to gain savings on backup as well as SAN perspective.
• Used various PowerCenter Transformations like Lookups, Joiner, Expression, Router, Update strategy, Source Qualifier, Aggregator, SQL, filter, XML, Sequence Generator, Normalizer, Stored Procedure to accomplish the mapping design.
• Created User Defined functions, reusable transformations to increase the re-usability during the development life cycle.
• Created re-usable mapplets for performing Data profiling and calculating the formulae as per the business requirements.
• Used Debugger in troubleshooting the existing mappings.
• Creation of Partition Primary Indexes to maximize the performance of the system.
• Tuned the existing SQL's to gain better performance in terms of runtime and resource consumption by understanding the EXPLAIN PLAN and DBQL.
• Written Unix Shell scripts in error handling and loading adhoc job streams.
• Used Tivoli Workload Scheduler for monitoring the loads.
• Environment: Informatica Power Center 9.1, PowerCenter Designer, Workflow Monitor, Workflow Manager, Repository Manager, PowerXchange, Unix Shell Scripting, TWS, Unix AIX, Oracle and MS SQL DB, Tableau, PowerBI

May 2014 – Dec 2016 · 2 yrs 7 mos

• Received certification of appreciation from Ameriprise leadership optimizing the statement batch. Ameriprise Financial has Statement batch processing which is very SLA specific and required at most attention and any delay due to issues could cause legal implications. So as a part of the optimization after doing extensive analysis and impact assessment a new design was introduced without changing the core logic of the batch which reduced the run time of the batch by 75%.
• Worked on Multiple Mainframe project from Development to Support.
• Environment: COBOL, CICS, JCL, DB2, VSAM, DFSORT, Jobtrac, IBM Fault Analyzer, IBM Debugger Tool, IBM File Manager/DB2, ChangeMan tool, CA Jobtrac, JHS, Omegmon Rational Developer - RDz

Oct 2011 – May 2014 · 2 yrs 7 mos

• Received TCS award for Delivery excellence Operations Team.
• Active involvement in the Application intake process, take transition of new applications and provide continued application life time support.
• Identify opportunities for process improvement in Incident Management and Problem management to avoid repetitive work and improve operational performance.
• Application and batch monitoring during Maintenance and communication to downstream applications.
• Analysis and resolution of high severity issues on bridge calls with several cross-commit teams.
• Perform analysis of single user issues and provide logical justification of system design.
• Effort Estimation for transitioning of application from project phase to production phase.
• Analyse recurring issues through problem management and implement break fixes.
• Owner of the Change management and Problem management process to make sure that processes are coming under ITIL V3 best practice processes
• Improve the Quality of Service provided to clients and improve the availability & capability of the application.
• Code walkthrough to stake holders, cross commits and technical team based on standards.
• Environment:
• Mainframe Technologies [COBOL, DB2, CICS, VSAM, DFSORT, Multiple Mainframe tools along with scheduling in JobTrac]
• Informatica Technologies [PowerCenter 9.x/8.x tools, UNIX, Shells Scripting, Oracle 11g along with TWS as scheduler]

Jul 2011 – Sep 2011 · 2 mos

• 3 month of Technology Training:
• IBM Mainframe Technologies, IBM DB2, CICS, VSAM, JCL.
• Build a sample project comprising of above technologies.