Subramanian A Pmp Aws Csm Informatica Teradata Google Cloud Email & Phone Number

New Jersey, United States

New York, New York

Managing and Leading Data warehousing clusters and Investment Portfolio and Boutiques of Investors Clients of Newyork Life

New York, New York

• Proposed Project Roles and Responsibilities
• Business Analysis - proactively lead and collaborate with stakeholders from the business units, technology units, and related third parties to deliver the business case, requirements, specifications, use cases, and.
• Requirements Analysis and Documentation - Elicit requirements using document analysis, requirements workshops, use cases, scenarios, business analysis, task and workflow analysis, and data quality analysis.
• Project Support - Answer questions and clarify requirements for projects and enhancements during the course of the project.
• User Acceptance Support - Plan, facilitate and execute system / functional testing and UAT for projects and enhancements.

United States

I have developed and maintained contact with top decision makers of Astrazeneca key clients across countries of United States, CAMCAR Regionn, Brazil, United Kingdom,Russia and Ukraine where presented a delivery model in terms of structuring the Astrazeneca's Data Hub Interactive Reporting and Salesforce Effective programming projects which is one of the.

• Project DescriptionIt is an American multinational toy manufacturing company and ranked on the Fortune 500. The company has presence in 40 countries and territories and sells products in more than 150 nations. The.
• Analyzing business requirements from the clients.
• Analysis of source systems and profiling of data
• Created end to end data flow diagram and high level design
• Perform ETL designing, developing the Informatica mappings and scripts.
• Unit Testing & Review of Unit Test Cases.

• Project DescriptionA global biopharmaceutical company with research and development at its core, the project aims at understanding the requirements in building Netezza Procedures to handle various Quality checks like.
• Involved in requirement gathering, Design specification
• Responsible for identifying the scope, the duration and the effort required for the requirement and quality assurance activities.
• Responsible in ETL designing, developing and debugging the Informatica mappings and scripts and used CLM framework for the Informatica parameterization and sequencing.
• Performing the project lead role activity by managing a team of 12 people as part of Release 2SDM data mart design, development and coordination between onsite and offshore.
• Setting up goals and appraising the team as a mentor throughout the project and established new process by building knowledge document repositories.

• Project DescriptionUDAS project is based on the principles of Agile methodology and we have implemented it in our communications project where agile adaptive methods, delivering frequently codes in production and.
• Developing and debugging the Informatica mappings and scripts to resolve bugs, and identify the causes of failures.
• Unit Test and cross verify the user functionality requirements
• User interaction to identify the issues and frequently changing requirements part of Agile lifecycle flow and delivering the code in a fast delivery mode.
• Providing effective technical solutions and participating in scrum calls and suggesting optimal solutions.
• Understanding the business user GUI requirement and populating the data through mapping logic as expected and bridging the knowledge gap between the functional and business level by directly interacting with the clients.

• Project DescriptionThe Olympus project was aimed to decrease the time taken to carry out yearly reporting for a number of processes to 20 calendar days. The system’s source is Prophet, from where the data gets picked.
• Designing the Data model as compared to the NGW structure and the Informatica transformation logics.
• Developing the Informatica mappings and scripts to resolve bugs, and identify the causes of failures.
• Technical lead handling 13 members of Data Integration team and one of the Release 2 ProjectLead in the account
• Client interaction to identify the requirement with the data loaded through the application tillPre-Prod Server.
• Providing effective technical solutions to team members

• Project DescriptionThe key requirement for the Hub is to provide a data transfer and transformation mechanism to support inter-system interfaces throughout the Life business. The Hub provides a platform and environment.
• Primary owner for LFTP, Billing and ECS applications(ETL part) in Production environment
• Responsible for handling Change Requests and enhancement for the existing applications and for carrying out impact analysis for the same
• Responsible for chasing issues with source teams, end users and finance in case of any discrepancies in data, in case of failures or in cases where in the runs could not be completed on time due to infrastructure issues.
• Responsible for catering to data requirements of Finance team (client) for testing purposes.
• Responsible for optimizing mappings and tuning them whenever required

• Purpose is to gather data from various source systems transform and validate the data and then load the data (in the form of xml tags) in xml file. Also, it takes care of erroneous data by logging corresponding errors.
• Played a role of developer including tasks of creation of low level design document
• Created Mappings, sessions, workflows and unit testing of the same
• Development of shell script for file ftping
• Support during SYS testing, UAT, Production phase
• Worked on UNIX box while resolving defects

• Project DescriptionKey requirement for the Asset Share Hub architecture is to provide a data transfer and transformation mechanism to support inter-system interfaces throughout the Life business. The Hub provides a.
• Developing and debugging the Informatica mappings and scripts to resolve bugs, and identify the causes of failures.
• User interaction to identify the issues with the data loaded through the application.
• Providing effective technical solutions to team members
• Responsible for handling change requests and resolving tickets within the SLA.
• Guiding junior team members.

• The Transformation of Financial Back-Office Processing project was launched to analyze current Corporate and Global data and process models and to propose a best approach to streamline, componentized and standardize.
• Migration of mappings across environments
• Development and support for with Unit Testing to test the functionality of the mappings
• Involved in low level design based on ETL requirements.
• Scheduling Autosys jobs at box level and analysis and defect fixes for problems.
• Performance Monitoring and Issue fix.

• CCX is an integrated daily P&L reporting system that provided BAC (Business Area Controlling) with single controlling, reconciliation and reporting system
• Provided risk exposure information on all open positions with profit & loss and funding cost.
• Collates information from various front office (RMS) & back office systems (R&N, DBTrader).
• Balance sheet reporting is mostly done with information collated from the upstream systems.Major calculations done are Foreign Exchange impact, funding cost and bulk load and other adjustments (like opening balances).
• Caters to the Global Markets Business areas that include – Fixed Income, OTC ICT, Emerging markets, Money Markets etc.
• This application caters to the Mid Office function of the bank.Collect– Data is loaded from a number of heterogeneous source systems using ETL tool.Aggregate – Aggregate data into a hierarchy to form a balance sheet.

Master Of Computer Applications (M.C.A.), Information Technology

Bachelor Of Computer Applications, Computer Technology/Computer Systems Technology