This project to capture all the customer reward, redemption and offer points obtained from the store in US and Canada

CareFirst one of the leading health care account in US offers various products and policies to its subscribers to encourage them to be healthy by providing incentives to healthy members. Project involves extracting member claim information from third party vendors and loading them into data store. Also involve in creating Universes for various claims under Part C and Part D document of Pharmacy Benefit Management EDI files

The main objective of this project is to deliver online User interface to the clients to view their Fund related information on various Fidelity product.

The main objective of this project is to deliver a solution that closes a major gap in the Amex Commercial product portfolio that will drive revenue while delivering growth, improved client loyalty and acquisition rates for our Partner’s businesses. The reporting solution will: Deliver the key information to clients supporting the Commercial Payment Solution value pillars of driving savings and increasing control provide a superior, best in class, user experience

CareFirst one of the leading health care account in US offers various products and policies to its subscribers to encourage them to be healthy by providing incentives to healthy members. Project involves extracting member claim information from third party vendors and loading them into data store. Also involve in creating Universes for various claims under Part C and Part D document of Pharmacy Benefit Management EDI files. Responsibilities involve - Technical Project Manager, Project Scoping, estimation, getting approval from client, pro-actively proposing solutions by identifying the business problems and creating functional and technical specification, creating ETL jobs on Pentaho, resource utilization, project planning and program management activities. Also involve in people management, delivering the project following the SDLC process, ensuring the quality of the deliverables. Involved in setting up AWS RDS environment for DB, Configuration of CLI to sync with S3 bucket. Configuration of EC2 instances for Multiple user remote connection on AWS. Configuration of EBS for snapshot of DB as per schedule.

The main objective of this project is to deliver online User interface to the clients to view their Fund related information on various Fidelity product. Involved in gathering requirement and preparing technical spec for High level design. Involved in development and Production Support activities. Managing team in developing ETL Mappings and creating dashboard for BI reports. Preparing dash reports of the Incident management and Change Management tickets per month for higher Management meetings. Production support Management, Sprint planning and roaster scheduling Tasks and Code review, resource engagement meetings Creating batch script, FTP/SFTP and configuring AXWAY gateway for inbound/outbound feeds Involved in end to end deliverables of the project in various tools Prepared Resource Managements, Project Planning, Project Scope, Project estimation and Risk Management Plan Documents, Program Management activities. Involved in Project management and Vendor Management

By integrating rewards with health, Humana Vitality provides the tools and support necessary to help Humana members live healthier life, and also keep track of the sales and cost to customer based on its policy. Involved in gathering requirement and also preparing technical spec for the High level design. Extensive knowledge on EDI files, healthcare Universes and includes Domain expertise. Analysis of Functional and Technical design. Designed and development of ETL using Informatica. Created and used scripts for scheduling. Defined Source and target Definitions in Informatica. Configuring and running test sessions using Informatica Workflow manager. Created Reusable transformations and Mapplets.

Barclay is maintaining a Database for Trade and capital Investments for Its marketers, agent and brokers for Products Involved in reviewing the project high level design and low level design documents with the scope document with extensive knowledge in Informatica Power Center product Preparing the planning, report and risk mitigation plan for the project. Deliver the planning document to the Business Specification owners which will undergo a client review process to implement the code. Involved in development based on the agreed plan with the support of expertise in tools Playing a major role in development/architecture/planning the functionalities using Informatica. Involved in running the standalone Jobs which is a development activity Involved in preparing the batches to load the data into data warehouse environment. Coordinate with the QA team for other functionalities related to derivatives, fungibles and bonds team. Attending Weekly Status meeting with the client on the project status and also have a daily status meeting with the team on the queries and coordination. Delivering the Mid-term report and project wealth report on quarterly to the client at the middle of the project and the final execution summary at the end of the project. Informatica Power Center, Oracle, Autosys and UNIX shell scripting and web based tools for performing these duties

Principal Global Services is maintaining a Database for Anti-Money Laundering System Training Handling for Its marketers, agent, brokers for selling PFS Products Functional analysis of ETL jobs. Development of ETL using Informatica. Created and used scripts for scheduling. Defined Source and target Definitions in Informatica. Configuring and running test sessions using Informatica Workflow manager. Used Session Parameter and Workflow Parameter

SingTel Retail new stack (Siebel) customer calls were needed to be routed to the correct call handling agent to offer them a personalized Customer service, avoiding increased costs resulting from internal call transfers. The objective of this project is to provide a repository of customer in CIDB (Customer Identification Database) and routing information, fully integrated With SingTel Retails key systems, that will enable rapid and accurate identification and routing of SingTel Retail customers when they make contact with the business. Development of ETL using Informatica Mapping, Sessions and Workflows. Worked on creating scripts for scheduling. Defined Source and target Definitions in Informatica. Configuring and running test sessions using Informatica Workflow manager. Created Reusable transformations and Mapplets.

Market Analysis Information Warehouse has been developed to provide flexible, efficient, timely information on revenue, costs, profitability, volumes, Productivity and service metrics by product, region, market segments and customer. Collectively this information will present new services and Revenue opportunities. A part of the project is to track customer interests too. Designed and development of ETL using Informatica. Created and maintained Informatica mappings. Defined Source and target Definitions in Informatica. Configuring and running test sessions using Informatica workflow manager. Created Reusable transformations and Mapplets.

First National Bank (FNB), in line with the rest of the global banking community, has a need to meet new Basel II Capital Accord guidelines by the end of 2007. As a large Africa regulated bank, FNB expects to utilize the new internal modeling approaches for capital calculations - and be expected to support these with strong risk management analytics, processes and disclosure. Information and data management is a particular challenge for global banks like FNB, with FNB having operations, customers and supporting technology in more than 6 countries. Used Informatica Power Center for loading the data from various sources involving flat files and oracle tables to the integration area. Involved in the Informatica Designer to create various mappings, extracting, transforming and loading operations. Implemented Aggregation, Expression, and Lookup and Update Strategy transformation and Stored Procedure. Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformation developer.

Banc724 – Branch Module is an advance branch automation solution with customizable Approach to the solution design. The solution is designed to address the changing needs of the banks, in terms of meeting the banks Customer requirements & banks requirements to expands its services & do effective internal information management .It is an integrated, accounting, transaction handling, customer service and management Information system. It includes various sub modules within itself like Cash Receipt Entry, Cash Payment Entry, Transfer Entry, Outward Cleaning, Inward Cleaning, General Voucher View, and Cash Denomination. Job Executing and solved the error. Creating tables, views, triggers, indexes, and sequences. Conversation of data and data migration from COBOL based software to oracle tables using SQL-Loader. Met deadlines in various occasions of need. Worked with the customers for the customization of the software to fulfill their needs.