About Me
Having around 20+ Years of experience (6+ years in US) in Business (Technical) Analysis, architecting enterprise BI solutions, Certified Scrum Master & Data Modeling for Telecom, Financial, Banking, Manufacturing, Energy & Utilities, Insurance, Healt...
Show MoreSkills
Portfolio Projects
Description
RS Data Architect Solutions wants to design and develop a cloud based integrated POS & ERP system for their clients. This involves data model design, solution architecture design and Implementation design. This product has been successfully implemented with 3 clients so for and successfully running. Basically, this POS & ERP product is to provide solutions for client business with critical analysis reports against their business problems.
Show More Show LessDescription
IBM proposes to address the current state challenges by building, from the ground up, an enterprise wide solution, built on the foundation of mature and proven frameworks. The future state solution will address the pain points and provide a strong foundation for Phase 1, by establishing and implementing the following.
• Change management processes
• Tools standards and best practices
• Financial industry best practices
• Standard data definitions
• Layered architecture designed as per best practices
• Pre-defined guidance on critical data elements
• Error handling framework
• Audit, balance and controls framework
• General purpose structures enabling FAST single view of member
Responsibilities:
- Responsible for Analysis, design, development, testing and implementation of IBM DataStage jobs, Control-M Schedules, Data Model of IIW and Netezza DB Scripts.
- Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
- Responsible for providing high level design and low-level design deliverables along with test plan and test strategies.
- Responsible for providing inputs and validate Data Quality and Data Governance process.
- Design and developed Audit & error handling model and implemented.
- Work with Business Analyst in translating business requirements into Functional Requirements Document and Detailed Design Documents
Description
USAA wants to redesign its data warehouse to support the following business initiatives: Faster and more accurate reporting New reporting to provide money movement and experience based insights Stronger data quality and governance Potential cost savings To support these objectives, IBM provides Services to achieve the following data management objectives: 1. Redesign and implement a new data warehouse schema to organize and normalize data 2. Redesign and implement new data movement routines 3. Integrate data sources, further defined below, to support the USAA Life Company (Life), USAA Investment Management Company (IMCO) and Financial Planning and Advice (FP&A) including Enterprise Advice Group (EAG) lines of business IBM proposes to address the current state challenges by building, from the ground up, an enterprise wide solution, built on the foundation of mature and proven frameworks. The future state solution will address the pain points and provide a strong foundation for Phase 1, by establishing and implementing the following. Change management processes Tools standards and best practices Financial industry best practices Standard data definitions Layered architecture designed as per best practices Pre-defined guidance on critical data elements Error handling framework Audit, balance and controls framework General purpose structures enabling FAST single view of member
Show More Show LessDescription
Many of National Grid electricity assets in use today were built in the1950s or 60s and are now reaching the end of their useful technical lives. They need replacing, refurbishing or more extensive maintenance. National Grid also must increase the capital investment to respond to future challenges faced by the UKs energy networks by facilitating the connection of new sources of demand and generation, including new nuclear plants, wind farms and gas-fired power stations. This project will deliver a decision support tool for Risk and Criticality based asset maintenance of all assets in scope by building a latest technology based IS Framework consisting of relevant condition and operation data feeds along with analytics and visualization capabilities. This project will be delivered within SAM programme which is a sub-programme of TFO programme. The process and procedure changes required to increase data accuracy and setting up data governance will be addressed by TFO programme.
Show More Show LessDescription
Established by Royal Charter in 1907, Siam Commercial Bank PCL (SCB) was Thailands first bank. At the time of its establishment, the only banks in the country (then known as Siam) were branch offices of foreign banks. SCB currently provides a comprehensive range of financial products and services through its branch, exchange booth, ATM network, and Business Relationship Centers (BRC) nationwide. Enterprise Data Warehouse is a centralized warehouse which provides service for the entire enterprise. SCB selected Teradata as the platform for its enterprise data warehouse project. Before choosing Teradata, SCBs data warehouse ran primarily on an IBM mainframe. Siam Commercial Bank uses technology from Teradata to replace a series of disparate, inconsistent data marts with a centralized enterprise data warehouse to improve business decision-making across the bank. It involves extracting and transferring all critical data and information from source and consolidates within the centralized Teradata EDW platform, where it will present a single, holistic view of the banks entire business. The outputs are used to support functions such as personalized customer relationship management and marketing programs, credit risk management strategies and financial analysis and reporting. SCB EDW loads the data warehouse regularly so that it can serve its purpose of facilitating business analysis. To do this, data from one or more operational systems needs to be extracted and copied into the data warehouse. The challenge in data warehouse environments is to integrate, rearrange and consolidate large volumes of data over many systems, thereby providing a new unified information base for business intelligence.
Show More Show LessDescription
WellPoint, Inc. is one of the largest health benefits companies in the United States. The company delivers many leading health benefit solutions through a broad portfolio of integrated health care plans and related services. WellPoint, Inc. was formed when WellPoint Health Networks Inc. and Anthem, Inc. merged in 2004 to become the nations leading health benefits company. Headquartered in Indianapolis, Indiana, WellPoint, Inc. is an independent licensee of the Blue Cross and Blue Shield Association serving members in the US. WellPoint Inc has used many legacy systems over a period to perform specific tasks. These Legacy systems get their data feed from various sources to further distribute to the client. Hence information is distributed over distinct, unlinked databases. It is a challenging task to search for data may or may not be in the same format, across functional areas. The Decommissioning Project aims at linking data from all different sources to a single new Data warehouse called Edward. The task is to integrate the data in a standard, non-repetitive format for reporting purposes.
Show More Show LessDescription
IBM proposes to address the current state challenges by building, from the ground up, an enterprise wide solution, built on the foundation of mature and proven frameworks. The future state solution will address the pain points and provide a strong foundation for Phase 1, by establishing and implementing the following.
• Change management processes
• Tools standards and best practices
• Financial industry best practices
• Standard data definitions
• Layered architecture designed as per best practices
• Pre-defined guidance on critical data elements
• Error handling framework
• Audit, balance and controls framework
• General purpose structures enabling FAST single view of member
Responsibilities:
- Responsible for Analysis, design, development, testing and implementation of IBM DataStage jobs, Control-M Schedules, Data Model of IIW and Netezza DB Scripts.
- Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
- Responsible for providing high level design and low-level design deliverables along with test plan and test strategies.
- Responsible for providing inputs and validate Data Quality and Data Governance process.
- Design and developed Audit & error handling model and implemented.
- Work with Business Analyst in translating business requirements into Functional Requirements Document and Detailed Design Documents
Description
Disney is a leading entertainment company and IBM provides critical technical solutions for their day to day technological issues. As the Database is growing everyday Disney planned to have a new application as Commuter Assistance Rideshare and Report Distribution Enterprise Service (RDES) for Co-Branded Credit Card (C3) and Enterprise Stored Value Card (ESVC). This will help the users to get most performance oriented services and can get information on the fly. The IT team of Disney is facing issues such as getting the data analysis faster and getting a good dashboard reporting system. IBM will assist Disney to overcome these issues and will provide a performance oriented application against existing analysis services.
Show More Show LessDescription
Bell Canada is a leading telecom provider in Canada and IBM provides more solutions for their technical issues. Bell Canada has implemented a two-year roadmap to assess opportunities within its Order to Cash (OTC) processes enterprise wide. This program reflects Bells commitment to ensure that the Bell RA organization evolves to become a next generation leader in revenue assurance management and therefore can minimize revenue loss. As part of the Roadmap, RA, in association with IT, has implemented a centralized tool called MoneyMap. This tool is the primary enabler for RA to implement controls along the targeted OTC processes. This project is part of the RA Roadmap and more specifically it is the result of analysis of areas of revenue leakage related to the Enterprise and SMB Markets Order to Cash Processes. The projects initial scope, as taken to Gate 1 IT Council for approval, including implementation of controls for the following: Wireline Order to Billing Wireline Order to Network IP and Broadband Products Order to Billing
Show More Show LessDescription
IBM proposes to address the current state challenges by building, from the ground up, an enterprise wide solution, built on the foundation of mature and proven frameworks. The future state solution will address the pain points and provide a strong foundation for Phase 1, by establishing and implementing the following.
• Change management processes
• Tools standards and best practices
• Financial industry best practices
• Standard data definitions
• Layered architecture designed as per best practices
• Pre-defined guidance on critical data elements
• Error handling framework
• Audit, balance and controls framework
• General purpose structures enabling FAST single view of member
Responsibilities:
- Responsible for Analysis, design, development, testing and implementation of IBM DataStage jobs, Control-M Schedules, Data Model of IIW and Netezza DB Scripts.
- Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
- Responsible for providing high level design and low-level design deliverables along with test plan and test strategies.
- Responsible for providing inputs and validate Data Quality and Data Governance process.
- Design and developed Audit & error handling model and implemented.
- Work with Business Analyst in translating business requirements into Functional Requirements Document and Detailed Design Documents
Description
Worked as Business Analyst as well as BI architect for Retirement Group of technologies on Retirement Benefits plan management. Worked with a team on customizing the out-of-box product to get the look and feel of the ExSOP (Executive Stock Option Plan) – Retirement Plans application and abilities of Crystal Enterprise like exporting, previewing, printing and emailing the reports. Lead teams on multiple projects like Migration of Crystal 10 to Business Objects XI Release 2, Million Dollar Tracking System, Performance Shares (Equity related project). Headed the team of Crystal Reports Developers, developed the reports as well as got them done by team on time for the releases. Designed and documented the multi server architecture of Crystal Enterprise 9/10. Created report publishing utility for multi-user Business Objects Enterprise XI cluster environment using ASP.NET SDK. Configured and Standardized the APS Cluster environment in Crystal Enterprise. Trained developers on steps involved in migration of reports from Crystal 8.5 to 9.0 and then 9.0 to 10 Migrated Crystal Web environment from Crystal Enterprise 8.5 to 9.0 and from 9.0 to 10.
Show More Show Less