Experience Summary:

• 15 years' experience in Information Technology with expertise in Data model design for Data Warehouse/Data Mart development, ETL design for multiple interfaces.
• Extensively involved in various projects related to Data Modelling/Data Architect, System/Data Analysis for Online Transaction Processing OLTP and Data Warehousing OLAP /Business Intelligence BI applications.
• Define data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.
• Ensure existing data/information assets are identified, stewarded and leveraged across the enterprise.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modelling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Have hands on expertise in Requirement analysis, Data profiling based on requirements to validate the business data.
• Convert the Logical models in to Physical models, and generate the delta or forward engineer DDL script, and execute in the database. Creation of view scripts for Symantec layer on top of data warehouse for end user.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Implemented Slowly Changing Dimensions - Type I II in Dimension tables as per the requirements.
• Developed mapping spread sheets for ETL team as well as for business users with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta-data definitions
• Create standard abbreviation document for logical, physical and dimensional data models.
• Worked on design the conceptual and logical model for IBM BDW data model implementation.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Exceptional communication and presentation skills and established track record of client interactions

Software Skills:

Project Details:

Confidential

Role Responsibility :

• Design overall data warehouse architecture flow assessing the requirement and define strategy.
• Deliver a project scope that directly supports the key business drivers .
• Design and deliver ETL Process , Data model of Data marts , Symantec layer for reporting user.
• Data model design using Erwin for staging area . ETL design for data load from source system and assist developer to ETL code .
• Creation of DDL scripts for tables and coordination with DBA for implementation.
• Define meta data standard abbreviation document for the data warehouse ETL , Data mart , BI .
• Creation of view scripts for Symantec layer on top of data warehouse for end user.
• Define production release requirements and sustainment architecture

Confidential

Role Responsibility:

• Leading the team for ETL design and data modelling for staging environment of EDW.
• Data model design using Erwin for staging area . ETL design for data load from source system and assist developer to ETL code .
• Creation of DDL scripts for tables and coordination with DBA for implementation .
• Create standard abbreviation document for logical and physical model.
• Requirement analysis , Data profiling based on requirements to validate the business data.

• Conducting brain storming sessions with involved stakeholders to ensure accuracy in requirement presented and solution desired.
• Create Data mapping based on the business requirement and work on design the conceptual and logical model for IBM BDW data model .
• Maintenance of data model based on ongoing changes.
• Creation of view scripts for Symantec layer on top of data warehouse for end user.

Confidential

Role Responsibility:

• Requirement analysis including indulging in meetings with business analysts, functional analysts, and end users conducting brain storming sessions with involved stakeholders to ensure accuracy in requirement presented and solution desired.
• Data analysis including examination of sample extracted data based on requirements to validate process and methodology adapted.
• Create standard abbreviation document for logical, physical and dimensional data models.
• Create logical, physical and dimensional data models based on requirements. Documentation of finalized data models, and generation of data model reports.
• Support Maintenance: Assist developers, BI team and end users in understanding developed data model. Maintain change log for each data model.
• Physical Data Modeler Role: Create sql code from data model and co-ordinate with DBAs to implement, testing, regression and production database.
• Design views to assist in report generation and performance improvement.

Confidential

Role Responsibility: Soliciting with customer on behalf of presales team from delivery perspective. Attending due diligence workshop and analysing the gap with respect to capability in pre contract stage and also identifying risk and mitigation plan on basis of customer requirement.

Confidential

• International is a part of Old Mutual Wealth Management, is the UK leader in Wealth Management . Providing the new model of long-term investments, offering flexible and tax-efficient solutions through its investment platform. It is a leading provider of offshore savings products and offers a range of innovative and market-leading investment solutions to investors around the globe
• Role Responsibility: Analysis of the business process of client in respect of requirement analysis . Identify the Gap with exiting BaNCS Insurance product and also analysis of technical feasibility of best solution to implement the requirement.

Confidential

Project Description:

• The Wholesale EIP, earlier known as BIP Business Intelligence Platform has been in existence for approximately five years and has evolved from a concept to a system supporting major business functionality.
• The core Wholesale BIP functionality provides generic processes to extract data from disparate operational systems, integrate, restructure enrich that data and then either distribute it to other operational systems or make it accessible via BI exploitation tools. and aims to follow the platform architecture guidelines and best utilise platform resources. TCS is involved in the Component Design, Development and System Testing of the project.The key technologies currently in use are : Oracle, Ab-Initio, Actuate, Pl SQL, OBI

Role Responsibility : Analysis of the business process, Gap Analysis, Studying the existing system creating the logical data model. Identification of the KPIs Key Performance Indicators ,Source System Mapping, Conceptual and Logical data modeling, Designing the extraction routines ,Review of Oracle PL/SQL codes and performance tuning using explain plan, TKProf and other tool ensuring best practices and standards are followed. Addressing support/enhance requirements

Confidential

Lead PMO

Responsibility :

As the Lead PMO of the Platform : Analysis and follow up for meeting Platform Projection targets with Onsite leads and Offshore Delivery managers. Ensure PO Approval on time and no Work At Risk. Continuous monitoring of resources wrt to available Cost Budget. Ensure timely allocations and releases based on performance .Ensure that correct profile associates are available at the earliest from the RMG and SRM team so that there is no effect on the project delivery timelines. Ensure that the Onsite-Offshore, Senior-Junior ratio ,trainee percentages as agreed for the Platform is maintained within all LOBs.Ensure that the DSOs for Invoices are always the least possible by following up with BT Line Managers for timely approval. Ensure that the Contracts are timely Vetted from TCS Corporate Legal and all the PO revisions are correctly uploaded. Quarterly PMO functions like WON creation, Contract Vetting,PV CB approval, Resource allocations. Perform trend analysis on the resource utilization vs revenue recognition and sharing with Platform Delivery Heads. Raising of invoices on time and ensure zero billing leakage.

Confidential

Data Acquisition CoE, The main task of DA horizontal is to analyze the requirements drafted in the RIA then service the request with possible reuse of available components in a such a fashion that downstream layers can suitably exploit the available information to meet the CE program requirements. The primary objective of DA horizontal is to procure the data from diverse source systems spanning across various business areas land it on a common platform.

Confidential

Project Details : General Insurance System is an Insurance Package, which caters to all the requirements of Operating Offices for companies doing General Insurance Business. The Modules incorporated in the system addresses Accounting, Underwriting, Claim Processing and Consolidation aspects of the Operating Offices. MIS reports are one of the strong features of Genisys. It also provides facility of porting data from different Systems into it. This system caters to all phases of Proposal processing starting with Underwriting, Endorsements, Renewals of Multitude Policies viz. Motor, Fire, Engineering, Marine Cargo, Marine Hull, Personal Accident and Mediclaim etc. , Claims Processing Related Accounting and the MIS requirements for Divisional Offices as well as Branch Offices. The system also provides a strong On-Line Query facility.

Role :Leading a six member team for customisation of client RGICL requirement. Analysing the new requirement and implementation of that requirement depending on feasibility. Preparing Documents for requirements and allocating resource accordingly. Direct dealing with customer for any sort of issues like bug fixing, delivery of new requirements. Query tuning for performance enhancement .Taking care of the collection of payments from clients. Maintaining good rapport with clients for future prospects.

Confidential

Platform Conversion of Existing Branch System with additional modules

Platform: VB 6 Front-end and SQL 7.0 Backend

Project Details:

• This project is mainly Conversion of Existing Branch System with new operating platform along with Centralised concept. And also various new Operational concept e.g. Uses of multiple operating bank, multiple account head in a single voucher etc. .It also includes various control reports e.g. Instalment Reminder letter for Hirer ,Insurance pending report on period basis etc.
• Lead Analyst involved in all phases of the Software Development Life Cycle. Am part of the core team involved in User requirement gathering, map requirements with existing system and lead the technical team. Responsibilities include study analysis of user requirements, database design, planning implementing changes in system and end user interactions for post implementation issues. Responsible for Technical Team management.

Database Management of Financial Accounting

Duration: Ongoing support activity

• Highlights: The job is basically implementation of new logic as per requirement of Accounts Department in existing software package.
• Role: Programmer Analyst involved in understanding and analysing user requirements and/or changes to existing software package. If required, co-ordinate to get the necessary modifications done and also resolve some urgent issues on case-to-case basis. The requirements are raised mostly from Accounts department.

Confidential

Highlights: The system was used for generating datasheet of agreements at branch level. This includes agreement generation, datasheet printing and also repayment schedule for hirer. After that generation of arrear statement considering the receipts and payments of each agreement. Role: Programmer Analyst involved in System Study, Design, implementation and resolving post implementation issues. Also involved in technical discussions, work allocation between team members and project schedule monitoring.

Hire Purchase System

Highlights: This system was developed for maintaining the record of each agreement starting from 1st instalment to settlement of the agreement. Further, performance report of field officers in every month about the instalments collection is also provided by the system. Multiple MIS reports were developed for all the concerned departments with special emphasis on reports for Hire Purchase Department.

Involved in Design, Coding, Implementation and end-user training.

Confidential

Role: Study of existing system and coding of different modifications as per the various requirements of Personnel Department. SQL was used extensively for reporting.

Branch Computerisation System

• Project Details: This system was developed to Computerise the branches' daily transaction starting from Receipts and Payments voucher generation of Fixed Deposit, Debenture, Hire Purchase to Cash Book generation. Collected data at branches of Fixed Deposit Debenture share are send to Head Office where Certificates are generated and then data of respected shares were send to branch for further correspondence.
• Role: Analysis of the Branch daily function after extensive user interaction, study and development of various functions as per requirement of Marketing people. Involved in the initial study, design and coding. Major responsibilities include writing code to capture data with validation from the clients. Extensive use of SQL queries to perform complex functions.