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 other appropriate project artifacts.• 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 pilot projects of Astrazeneca to bring the Data Model of CDH(especialy MDM Module) which is the heart of Astrazeneca's Business reporting and stategic decision interface. Focussing client's requirement and introducing innovative contribution to the development of proposal pharmaceutical pricing strategies and increasing the sales model practised.Successfully manifested vast experience in expressing though leadership to the Executive Directors/CIO and other business senior IT leadership team.

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 scope of the project is to get Knowledge Transition from Client and provide DI design and solutions in Informatica for project. Also to perform production support as required. The production issue and service request will be logged in to remedy portal/service connect and the offshore team will process the service request/ incidents created and get it resolved within the SLA time based on the priority of the tickets. Enhancements will be logged in the Remedy as P4 priority and team will perform the enhancement.Roles and Responsibilities• 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.• Fixing the issues and doing the enhancement for existing Informatica mappings• Monitoring UC4 jobs and resolving the job failures.• Involved in design, development, testing and scheduling of data models & analyzing issues from the error reported by client side reporting users.• POC for all GBI Project related issues for offshore and provided guidance.• Applied the hot fixes across the entire environment• Analyzed the system resource usage for the new• Deployed Informatica objects, parameter files and the scripts among different environments

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 Record Count, Record Validation, Hash Validation b/w the Source and Target data.Implementing the DQ FrameWork after the ETL load and performing various DQ checks for the loaded records.Roles and Responsibilities• 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.• Specific SME for the subject area of FSIP which managed single handedly and also for APLD as one of the SME.• Deployed the Informatica queries to upper environment by shouldering the Informatica Admin activities• Having hands on experience in Installation and configuration of distributed environment in windows and Unix OS Installation and configuration of the Informatica Power Center Domain, Node, and application services (i.e., Integration Service & Repository Service)

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 iterative modeling for each sprint with designated scrum meeting with client. Using UDAS-VSDA's Grant Management function, an operator centrally manages the footprint wide grants. Via two GUIs, dashboard landing page and the main, multi-level management window BSS Package content and grants are managed for every market within client’s IPTV service area.Roles and Responsibilities• 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 up for processing and is loaded to warehouse. The liabilities data for calculation will be extracted from Monthly Store (Data warehouse for Olympus) and delivered to the CRR calculation team in the form of Business Objects reports.Roles and Responsibilities• 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• Responsible for handling the CR’s and requirement changes as part of model and as related to both up streams and down streams for the live environment.• Guided 9 team members for the same project as their mentor.

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 within which those interfaces can be managed, executed and monitored. Hub Support team caters to the maintenance, support and enhancement of Norwich Union Life applications. All the applications are built on Informatica Power Center and some of them have reporting using Business Objects.Roles and Responsibilities• 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• Responsible for loading the files to warehouse till the last execution part and verifying the same inWarehouse.• Responsible for exercising code performance test at the unit, integration and system levels of the software testing process and had been involved in the specification testing, data flow testing.

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 into an error file.Roles and Responsibilities• 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 platform and environment within which those interfaces can be managed, executed and monitored. For Release 4, there are three source systems - Unisure, S32/LAP (V5) and MC. Unisure consists of three types of files: Context or Policy data or Model Point File (MPF), ADI-OFF file and ADI-ON file. There will be two types of files from V5 and MC source system - Asset share Result set file (RES) and ADI-OFF files. These data- files are interdependent and follow a logical processing flow.Roles and Responsibilities• 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.• Supporting the System Integration Testing and User Acceptance Testing phases

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 these models within the financial scope to best position the institution for stability, risk mitigation and future growth. The Financial Close Transformation (FCT) project will address immediate and strategic business needs associated with the financial close automation cycle from critical path source systems to SAP and also analyze local NAC requirements and ensure architectural alignment with Corporate Center initiatives such as ONE-BIZ.Roles and Responsibilities• 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) posted by users.• 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 and determine the Profit and Loss. Reconciliation – Reconciles data between two external systems.Adjust – Allow users to post adjustments to correct positions. Report – Generates reports accessed through intranet.Roles and Responsibilities• Involved in low level design based on ETL requirements.• Development of Informatica mappings, workflows and sessions• Unit testing of modules developed.• Worked during SIT phase by fixing testing defects and User Acceptance Testing• Production support and monitoring of the loads• Fixing of the production tickets.

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

Bachelor Of Computer Applications, Computer Technology/Computer Systems Technology