Summary

• A competent professional with nearly 13 years of IT experience in Data Warehousing, Business Intelligence, Data Architecting and Dimensional Modelling with extensive experience in Oracle, PL/SQL, DataStage, DataArchitect Erwin.
• Developed competency in leading multiple teams, coordinating external application teams for interfaces, onsite/offshore coordination, user interaction training, system deployment.
• Involved in all areas of project management process initiation, planning, execution, control, closure of projects Leading and coordinating the management of full life cycle of DW/BI projects.
• Capable of handling multiple concurrent projects of moderate to high complexity.
• Skilled in developing a detail test plan and implementation schedule during major implementations.
• Rich experience in Data Modeling / Dimensional Modelling, Data Flow Diagrams, Database Design Development with proficiency in analysing, designing, developing and reviewing ETL Application Data Models.
• An effective leader with proven ability in leading and guiding the teams during the project phases and enabling knowledge sharing among the teams.
• A keen planner, strategist and implementer with demonstrated success in end-to-end project management by ensuring effective management of various resources to meet the project objectives.
• Proficient in SDLC processes i.e. Configuration Management, Release Management, Testing Tools Integration.
• Insightful experience in IT project management activities including project scoping, estimation, planning, risk management, finalization of technical / functional specifications, resource administration optimization, and quality management of the product / software application.
• Implemented a large-scale Enterprise Data Warehouse system using partition SQL server2008 R2 database size of 10 Terabyte.
• Excellent CRM skills with due onsite-offshore coordination combined with experience in product design, development and implementation.
• Solutions-oriented professional IT consultant who excels at managing projects, collaborating with project teams, interfacing with clients, and deploying technology to build successful solutions for clients.
• Strong problem solving technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs.
• In-depth domain experience in Banking Finance, Insurance, Manufacturing and Process industries business processes.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business.
• Strong expertise in all phases of Software test management: defining requirements, planning testing process, test automation Execution, analyzing and reporting results, tracking and managing defects.
• Specialties in Agile Standard Software Development, BI , Process Management and resource management.
• Involved in go-live Product implementation for medium and large size banks.

Summary of Skills

Key deliverables across the tenures:

Proficiency Matrix

• Project Management - Requirement Definition Management - Client Relationships
• Project Execution - Internal Stakeholder Management - Effort Estimation
• Planning Implementing PMI's- Team Building, Mentoring Evaluation - Data Modeling
• Business Requirement Analysis - ETL Architecting - Staffing Training
• ISA standard data models - TOGAF

Software Development / System Analysis

• Handling various technical aspects like project documentation, system design integration, monitoring critical paths taking appropriate actions.
• Planning and Designing of test plans and strategies, test cases and test scripts/procedures, UAT activity and gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Delivering and implementing the project as per scheduled deadlines planning and coordinating post-implementation and maintenance support to the technical support team and client.
• Evaluating the job and creating the skill matrix for the employees.
• Providing innovative feasible solution to increase the efficiency and productivity.
• Interacting with client for requirement gathering, system study analysis.
• Drafting functional requirements using models and diagrams to represent the processes and functions involved.
• Assisting in functional testing of the new system and ensuring that it meets the user specifications.

Data Warehousing

• Managing database administration functions involving:
• Installation, configuration, up-gradation patching of Oracle server software and hardware.
• Disk space management, user profile creation and user rights management.
• Writing SQL codes for different requirements.
• Creation administration of all database objects, including tables, indexes, views, sequences, packages, procedures and database replication.
• Planning and implementing modules in Oracle Forms.
• Database / SQL tuning, performance monitoring and troubleshooting.
• Resolution of database starts up problems and database reorganisation.
• Developing detailed architecture and technical work plan to ensure successful development and implementation of the applications.
• Managing applications middle tier, system administration, patching and cloning.
• Preparing technical work plans for Database upgrade version from 8.0.2 till 9.2.0.7.
• Disaster recovery planning, implementation and Management, supervising technical team to restore database during system failure.
• Implementing regular backups along with recovery, exporting / importing databases, monitoring procedures and ongoing support.
• Controlling database changes, reference data changes and menu changes through development life cycle.

Professional Experience:

Data Architect/ ETL Architect

Confidential

Synopsis: The purpose of this project is to implement a new KYC solution, replacing the CRF and associated tools, and to improve process surrounding the risk rating of an AML client. The CRF was developed based on a shorter term temporary solution. It is very focused on New Client Take on NCTO and has limited ability to maintain a true risk history of a client.

The key roles and responsibilities include:

• Executing activities related to data analysis, modeling and design specific to a Data Warehouse / Business Intelligence environment for NTRS Banking products.
• Analyzing the source systems.
• Scoping the requirements for BI based on current functionality built in existing Misys banking products.
• Designing / customizing the BDW logical models and designing the physical data warehouse.
• Identifying and managing data quality issues.
• Database planning configuration for the product requirements.
• Performance tuning and Optimization.
• Experience in using CA Erwin Tool to design Physical and Logical Models.
• Experience in writing SQL scripting and creating data base table structure.
• Configuration management for product deployment to various platforms and releases.
• Identify and resolve data mapping issues.
• Developing ETL jobs with complex mapping and creating bridge between application to application with MDM development techniques.
• Identifying VBT binding techniques to bind the two same records and collapse to single record.
• Prepare the strategy for data migration from OLTP applications to BI database OLAP.
• Prepare package implementation strategy.
• Implemented a large-scale Enterprise Data Warehouse system using partition Oracle 11g.
• Designing Data warehousing schemas and Data Marts based on business requirement.
• Designing Business intelligence solution for analytical and reporting needs.
• Develop guidelines and best practices to ensure data standardization and consistency.
• Perform data cleansing and data auditing as necessary to ensure data quality.
• Ensure operational and analytical data warehouses are able to support all business requirements for business reporting across the organization.
• Define technical requirements, technical and data architectures for the data warehouse.
• Define meta data standards for the data warehouse.
• Collaboration with various teams ETL team, QA team, Source team, BI team and DBA resources.
• Used Agile methodology process of SDLC.

Environment: CA ERWIN 9.2, Data Stage 8.5,SQL Server 2008 R2, DB2, Oracle 11g, Java platform, Control-M ,Windows 2007 server.

Data Architect

Confidential

Synopsis: Misys Business intelligence is a product of Misys data warehousing business intelligence. It covers major core banking subject areas Equation, Bank Fusion Equation, Midas and Universal banking products. This module covers ETL process with BI reports. These has structured reports like Scorecard, Dash board, Balance sheet reports, profit loss report and turnover summary reports. This also has Credit risk module. Personalizing the customer service experience for each customer it enables you to quantify a customer's historical, present, and future value to the organization

The key roles and responsibilities include:

• Executing activities related to data analysis, modeling and design specific to a Data Warehouse / Business Intelligence environment for Misys Banking products.
• Analyzing the source systems.
• Scoping the requirements for BI based on current functionality built in existing Misys banking products.
• Designing / customizing the BDW logical models and designing the physical data warehouse.
• Identifying and managing data quality issues.
• Database planning configuration for the product requirements.
• Performance tuning and Optimization.
• Experience in using CA Erwin Tool to design Physical and Logical Models.
• Experience in writing SQL scripting and creating data base table structure.
• Configuration management for product deployment to various platforms and releases.
• Identify and resolve data mapping issues.
• Prepare the strategy for data migration from OLTP applications to BI database OLAP.
• Prepare package implementation strategy.
• Implemented a large-scale Enterprise Data Warehouse system using partition SQL server2008 database size of 10 Terabyte.
• Designing Data warehousing schemas and Data Marts based on business requirement.
• Designing Business intelligence solution for analytical and reporting needs.
• Develop guidelines and best practices to ensure data standardization and consistency.
• Perform data cleansing and data auditing as necessary to ensure data quality.
• Ensure operational and analytical data warehouses are able to support all business requirements for business reporting across the organization.
• Define technical requirements, technical and data architectures for the data warehouse.
• Define meta data standards for the data warehouse.
• Collaboration with various teams ETL team, QA team, Source team, BI team and DBA resources.
• Used Agile methodology process of SDLC.

Environment: CA ERWIN 9.2, Data Stage 8.5,SQL Server 2008 R2,Cognos 10.1, DB2, Oracle 11g, IBM-iseries, Windows 2008 R2 64-bit server.

BI Solution Architect / Data Architect

Confidential

Synopsis: HV General Insurance data warehouse and Business Intelligence solution is being designed and developed to provide consolidated view of Policy, Premium and Claims information to the business users for efficient decision making regarding Policies and claims. Solution goal is also to achieve 360 view of customers by deduplication of customers' data existing multiple systems, identify profitable customers, customer by LOB, products etc. Business Intelligence solution provides analytics for Quote to Policy conversion ration analysis by underwriter, agent, product, Analysis of lead time between quote to policy stage by underwriter, agents, products, Analysis of claims data along with corresponding policy details, Time elapsed for claims settlement, Analysis of number of claims for any given customer segment e.g. geography, customer profession , Fraudulent claims pattern detections etc.

The key roles and responsibilities include:

• Designing Data warehouse architecture keeping mutli-system, multi-branch consolidation and real time data integration requirements
• Designing data integration solution to integrate data from various sources like Core Insurance Application, mFund, Oracle Financials, CRM application
• Preparing industry standard Data models to meet ACORD standards
• Designing MDM solution for customer data
• Identifying and managing data quality issues.
• Designing Business intelligence solution for analytical and reporting needs
• Develop guidelines and best practices to ensure data standardization and consistency
• Perform data cleansing and data auditing as necessary to ensure data quality
• Ensure operational and analytical data warehouses are able to support all business requirements for business reporting across the organization.
• Database planning configuration for the product requirements.
• Define technical requirements, technical and data architectures for the data warehouse
• Define meta data standards for the data warehouse

Environment: CA Erwin 9.2,Data Stage 8.5,SQL Server 2008,TERADATA, Cognos 10.1, DB2, Oracle 11g, Windows 2008 R2 64-bit server.

ETL Lead Architect

Confidential

Synopsis: Quotes and Trade related data associated with Equity, fixed-income, financial derivates, currency and other investment instruments. Delivery of Price data from exchanges to users, such as traders, is highly time-sensitive, approaching real time.

The key roles and responsibilities include:

• Executing activities related to data analysis, modeling and design specific to a Data Warehouse / Business Intelligence environment.
• Designing the logical and physical data warehouse.
• Analyzing the source systems and creating mappings to target data warehouse.
• Identifying and managing data quality issues.
• Optimizing ETL performance, designing and developing packages program / function units.
• Ensuring query performance tuning and optimization.
• Coordinating with offshore team members for work item development and on time delivery.
• Performing reviews on problem analysis, impact analysis and ETL changes that are being done from offshore.

Environment: Trading Domain, Data stage, Oracle 9i, QuickTest Pro, TestDirector for Quality Center, Visual Studio, VB Script, XML, Windows XP, UNIX sell scripting, Web functional/regression test tool.

Team Lead/Developer

Confidential

Synopsis: The Wealth Management Alternative Investments AI Reporting project is one of several components of the IMD multi-year Wealth Management Reporting WMR initiative

The key roles and responsibilities include:

• Create ETL processes that extract data from different source systems and transform data from Oracle and loading into target tables in SQL server 2008.
• Perform data analysis resulting in requirement specifications, analysis of different aspects of the data warehouse.
• Responsible for getting the data dictionary, designing and modifying the Data stage jobs using Data stage Designer Created mappings based on the data dictionary.
• Used Data stage Designer to create Data stage applications jobs , where all the required mappings, transformations, routines and formats are designed to load the data into Oracle.
• Used the Data stage Director and its run-time engine to schedule jobs and monitor processes.
• Used Data stage Designer to create Data stage applications jobs , where all the required mappings, transformations, routines and formats are designed to load the data into target.
• Participated in the creation of project framework, including: defining standards, best practices and testing procedures, creating functions, establishing naming conventions participated in the test plan composition.
• Performed reviews and quality audits of functional requirements and specifications.
• Regression testing, Database level testing, Functional testing, Smoke testing, Multi user testing
• Created new and updated existing test cases according to the business requirements and functional specifications.
• Performing major role in understanding the business requirements and designing and loading data into data warehouse ETL .
• Active interaction with testing and development team.
• Involved in preparing Monthly project metrics, Weekly Status reports, DPP Cost of Quality report, Monthly Dashboard and Billing for customer

Environment: Investment Banking Domain Oracle 9i, PL/SQL and Informatica 9.1, Windows XP

ETL/BI Specialist

Confidential

Synopsis: The ADW Encryption Processing project is part of the PCI Compliance effort for GRM. The two GRM databases, ADW and ODS, store sensitive guest information account numbers including checking account and credit cards, SSNs, Driver's Licenses and Tax identification numbers in encrypted format. This data reaches ADW and ODS from multiple sources, both internal and external to Target. In addition, some GRM processes share part of this information with external vendors for business reasons.

The key roles and responsibilities include:

• Testing application based on specifications and requirements
• Conducted Installation of Application in machines
• Prepared Builds and Release to client
• Regression testing, Database level testing, Functional testing, Smoke testing, Multi user testing
• Conduced peer review
• Test case enhancement during the build.
• Reporting and prioritizing software bugs in Test Director 8.0
• Active interaction with testing and development team
• Regression testing, Database level testing, Functional testing, Smoke testing, Multi user testing
• Created new and updated existing test cases according to the business requirements and functional specifications.
• Performing major role in understanding the business requirements and designing and loading data into data warehouse ETL .
• Implementing Slowly Changing Dimensions Type I in different mappings as per the requirements.
• Using Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
• Using Debugger to troubleshoot the mappings.
• Creating Workflows, Worklets using Workflow Manager.
• Developed several reusable transformations and mapplets.
• Active interaction with testing and development team
• Involved in preparing Monthly project metrics, Weekly Status reports, DPP Cost of Quality report, Monthly Dashboard and Billing for customer

Environment: Domain: Retail-Guest Relation Management, PL/SQL and Informatica Power Center 9.1, Windows XP C , SQL server 2005

Senior Developer

Confidential

Synopsis: The Check/ACH Payment Processing initiative is intended to streamline the IntelliRescue payment processing by automating the Axapta journal entries and outsourcing the payment processing to Bank of America. The outsourcing of the payment process will also provide Asurion the ability to pay vendors electronically via the Automated Clearing House ACH network. The ACH payments will provide a cost reduction in the payment process and more timely payments to vendors.

The key roles and responsibilities include:

• Performing major role in understanding the business requirements and designing and loading data into data warehouse ETL .
• Using ETL Informatica to load data from source to ODS.
• Using Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source Target definitions and code the process of data flow from source system to data warehouse.
• Implementing Slowly Changing Dimensions Type I in different mappings as per the requirements.
• Using Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
• Using Debugger to troubleshoot the mappings.
• Creating Workflows, Worklets using Workflow Manager.
• Developed several reusable transformations and mapplets.
• Active interaction with testing and development team.
• Involved in preparing Monthly project metrics, Weekly Status reports, DPP Cost of Quality report, Monthly Dashboard and Billing for customer.

Environment: Windows 2000, Oracle 9i, PL/SQL and Informatica Power Center 7.2

Sr. Software Engineer

Confidential

Synopsis: This is a business application where the property details can be created and maintained on a central location and different parties such as the seller/owners, buyers, and lenders can perform various business transactions among them. It contains the various modules like Files, Orders Reminders, Banking, Reports, and Administrator.

The key roles and responsibilities include:

• Implementing Slowly Changing Dimensions Type I in different mappings as per the requirements.
• Using Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
• Using Debugger to troubleshoot the mappings.
• Creating Workflows, Worklets using Workflow Manager.
• Developed several reusable transformations and mapplets.
• Map source to target element mappings from legacy System to Sybase and Sybase to Oracle database using data dictionaries for different jobs.
• Perform unit testing and debugging jobs. Use shared and local containers, to reduce coding.

Environment: Retail domain, Informatica, PLSQL, SQL ,Quality centre 9.0

Software Engineer

Confidential

Synopsis: With Distributed File System DFS , system administrators make it easy for users to access and manage files that are physically distributed across a network. With this, files distributed across multiple servers appear to users as if they reside in one place on the network and users no longer need to know and specify the actual physical location of files in order to access them. File Replication Services available with the DFS also manages to replicate the files and folders across locations and keeps the users connected to resources in case of network failures.

The key roles and responsibilities include:

• Testing application based on specifications and requirements
• Setup test environment
• Installation of Application in machines
• Up gradation and maintenance of Application servers
• Preparing Builds and Release to client
• Preparing test scripts in Test Director 8.0
• Regression testing, Database level testing, Functional testing, Smoke testing, Multi user testing
• Localization testing
• Conducting peer review
• Test case enhancement during the build
• Training new members and imparting functional knowledge
• Reporting and prioritizing software bugs in Test Director 8.0
• Active interaction with testing and development team.

Environment: Finance, Insurance domain, Quality centre 9.0, ASP.NET 2.0, C

Software Engineer

Confidential

Synopsis: This system is used for managing the materials in the stores .The User Department makes the request for material planning department when there is shortage of the materials in the store. The Planning Department is responsible for raising the MPR to the purchase department. Purchase department will prepare the purchase order after using the technical feasibility analysis along the material-planning department does the selection of vendors. The purchase order is then sent to the selected vendors. Suppliers will send the materials to the receiving stores. Receiving Report will be prepared and the stock is updated in holding stores after the rejection of flaw materials.

The key roles and responsibilities include:

• Testing application based on specifications and requirements
• Involved in Manual testing and also automated testing for Inventory module, Sale-Purchase module and Reports
• Conducted Functional testing regression testing.
• Setup test environment
• Installation of Application in machines
• Up gradation and maintenance of Application servers
• Preparing Builds and Release to client
• Preparing test scripts in Test Director 8.0
• Regression testing, Database level testing, Functional testing, Smoke testing, Multi user testing
• Conducting peer review
• Test case enhancement during the build
• Training new members and imparting functional knowledge
• Reporting and prioritizing software bugs in Test Director 8.0.
• Active interaction with testing and development team

Environment: Retail domain, Quality centre 9.0, ASP.NET 2.0, C SQL Server 2005