PROFESSIONAL SUMMARY

Performance-driven leader with 29 years of Information Technology experience. Hands-on DWH Architect in implementing Best Practice in Data Modeling, Architecture, Data Quality and Data Profiling with strong client needs assessment talents. A leader with mentoring capabilities for DWBI development professionals, Data Modelers and the proven ability to function as a respected thought leader among peer groups inside and outside the Enterprise. Worked as IT Professional since 1985 Atalanta/Sosnoff, Prudential, Fleet Credit Card, Credit Suisse, Chubb Insurance, CitiGroup and JP Morgan Chase, MF Global, AIG and EmblemHealth.

PROFESSIONAL EXPERIENCE

confidential

Manager, Data Architecture/Data Modeling

As a Manager and a Data Architect/Data Modeler, I am responsible for implementing Data Architecture/Data Modeling best practice, standards, policies and processes to provide Shared Services across various divisions

• Responsible for CA AllFusion Model Manager, a repository of 50 Data Models.
• Work with SMEs, data architects, and developers to maintain stable Data Modeling environment to support all Data Modeling activities.
• Review and guide a Data Warehouse architects for the Data Warehouse Data Models.
• Design and develop an Enterprise Logical Data Model for Health Care Insurance.
• Responsible for implementing Data Governance using InfoSphere tools and technologies
• Business Glossary that provides a platform for creating and managing an enterprise vocabulary.
• Metadata Workbench that provides data lineage analysis to trace data elements back to their source.
• Information Analyzer that provides data quality assessment, data quality monitoring and data rule design.
• Responsible for day-to-day activities managing, improving and implementing practices
• Translate business requirements into a clear complete understanding for development of Data Models.
• Technical reviews, discussions and issue resolutions with SMEs, ETL Developers and Data Modelers.
• Collaborate with other architects across the organization to develop best practices.

confidential

Associate Director, DWBI Principal Architect Technology Lead US

confidential

BIDW Practice Lead

As an Associate Director, collaborated closely with the Global teams to develop proposals, presentations, and SOWs. Played an advisory role to customers and prospects. Provided thought leadership recommendations in various technology areas, analytics Information Management spectrum. Worked with the identified key alliance partners and software vendors for evaluation of products and exploring opportunities for developing business.

• As a Practice Lead, engaged as a point person to work with the Data Managers to lead engagements in the areas of Data Warehouse strategy, Data Governance, Data Quality, and Data Analytics. Worked with Account/Sales teams to manage the pre-sales process with clients and provided the leadership throughout the sales-cycle from initial qualification to closure of the deal. Ensured effective deployment of business functional specific metadata.
• As a Technology Lead, managed development and delivery of Business Intelligence Architects and Business Intelligence Engineers. Conducted gap analysis comparing the current and future state, assessing current client programs, carrying out research and data collection, interviewing client's employees, management team and other stakeholders. Defined scope, expectations, and project estimates, architecture designs including data models.

confidential

• Managed a project of implementing DWH across global platform, and provided technical architecture guidance for Operational Data Store and Reporting Data Marts design. Worked closely with business analysts and data architects for ACORD standards and framework.

confidential

• Designed and developed a Liquidity Risk Infrastructure LRI data marts to support a portal that provided a central hub for accessing regulatory reports and underlying data. It also provided a suite of analytic reports or views to help Global Treasury track changes and monitor trends including variances with the general ledger.

confidential

• Led and managed a team of 60 individuals on-site off-shore to deliver the project for the Data Warehouse for a cash and derivatives broker-dealer, delivering access to products, solutions, and insights across the world's financial markets. The project involved the implementation of an enterprise-wide data warehouse and business intelligence solution. This warehouse served as a Reference Data Repository Client Product and delivered views on business data Trades, Positions, Postings, Cash Flow, Balances, etc. . This created a normalized, robust and extendable data model that evolved over time as more was learned about the data. The DWH was managing roughly 6.5 TB of data from 20 source systems. The system growth was 20 GB data per day.

confidential

Architect Lead

As an Architect Lead, delivered a data architecture and a data model for the Private Clients Work Station PCWS . Captured business requirements and rules, designed the associated logical models, and created all required documentations to support, communicate, and validate the data model. Designed, built and maintained the logical and physical data models to support the business requirements in a dynamic, expanding business environment. The architecture focused towards high performance, scalability and high availability.

confidential

Engagement Manager, Sr. Data Architect and Technical Advisor

Project New Jersey Office of Information Technology, NJ Dept. of Transportation

• As an Engagement Manager, worked closely with the Deputy CTO for Data Management Services at State of New Jersey to develop and execute the strategy and objectives for the development and deployment of the INDOT Data Warehouse. Worked closely with business partners to understand current ad-hoc utilization and to plan for new reports and analyzed Legacy Systems from the perspective of Data Change Management to select the protocols needed to obtain changed data from each system.
• Recruited developers, data modelers defined their objectives, evaluated performance and provided feedback. Led and mentored State development staff in the design and construction of the complete extract, transform, and load ETL environment for the INDOT Data Warehouse made recommendations to optimize designs and processes for both loading and accessing data.
• As a Sr. Data Warehouse Architect, directly participated in information gathering, analysis, specification development, project planning and data modeling to develop EDW data architecture. Designed a normalized logical model of the data in order to create the structures in the Data Warehouse that will hold the final version of the DOT legacy systems' data. Developed a Physical Data Model. Developed the Dimensional Data Models as required for functional reporting. Provide and Publish Metadata, Models and Project documents.

confidential

• As a Sr. Data Architect, worked on various projects as an advisor or technical architect.
• GDR Project: Global Data Repository unified data capture and maintenance for Alternative Investments across GWM. It offered broad reporting capabilities, and delivered complete, reliable data to the users.

F-ODS Project: Designed a data model for a Financial ODS that supported a Branch Server Elimination project. The F-ODS became a subscriber and provider of Financial Data for all systems of Smith Barney. Performed Business Analysis and requirements, conducted JAD sessions with SMEs to understand and analyse requirements, and current source systems. Designed and Developed Data Architecture using conformed Dimensions across GWM. Designed and Developed Logical Data Models, Physical Data Models, Staging Area, ETL Architecture, source-to-target mapping. Defined data transformation/scrubbing, exceptional handling, aggregation logic. Worked with Data Standard Committee for MDM and Reference Data.

• MyFi Analytics Project: The objective of this project was to deploy a data mart for the FLS business. This data environment provided comprehensive coverage of client and prospective client information within FLS, within Citi, and beyond. Multiple classes of users leveraged the data mart to exploit the business intelligence at hand.
• Risk and Compliance Project: An architecture was developed to enable risk management to stress test and determine specific security types held as margin loan collateral and owned outright in GWM client accounts. Risk management collected and stored the complete information in a single system to enable them to take suitable and timely decisions.
• Financial Life Services-Advisory Software Inc. Data Integration Project: ASI was the Wealth Management software to be used by Financial Advisors to manage and balance the customer's portfolios. Worked with the team implementing an architecture that was developed for data integration from various systems. Analyzed the FLS-ASI Data Integration Commissioned and Managed Account .
• As a Technical Advisor, worked as a Data Management committee member defined Best Practices and Standards for the Data Modeling, and Data Architecture. Designed Enterprise Logical Data Model for GWM. Performed a Metadata Proof of Concept and facilitated hosting of Metadata. As a key member of Shared Services, involved in POC, vendor evaluation, product evaluation, Metadata, MDM strategies, design standards and architecture.

confidential

Data Design and Services Manager

As a Sr. Manager in Information Systems Group Strategy team that sets direction for Chubb's Information Architecture and participates in Chubb's overall Enterprise Architecture Program, managed a centralized service unit with 9-10 senior Data Modelers. Managed an existing or new architecture for all three divisions of Chubb CSI, CPI and CCI. Managed and maintained Corporate Reference Data Architecture, implemented a Metadata Strategy and managed Metadata platform. Provided leadership in establishing data management practices.

confidential

Data Warehouse Manager

• As a Data Warehouse Manager, delivered a Data Warehouse and BI infrastructure to support Residential Mortgage Financial Reporting, Master Servicing and Analytical team. Presented a concept of the Data Warehouse using the Bus Architecture to management. Built a dedicated team for the Data Warehouse by hiring 7-8 individuals with various expertise and skills. Mentored technical staff for developing the Data Warehouse based on Ralph Kimball's methodology. The Data Warehouse provided a cost effective, and reliable reporting platform with improved data quality, better staff utilization, and increased profitability by targeting sellers. The Data Warehouse supported financial analysts, master servicing, client management, and salespeople.
• Implemented BI Infrastructure using Cognos DataStage to build The Scorecard, Product Analysis and Risk Analysis reporting platform. The platform helped marketing and products groups to shift their views from revenue-centric to profit-centric. Salespeople were able to see profitability levels by product, by seller and by channels, instead of only focusing on volume and funded amount. The WEB based reporting improved efficiency, provided flexibility, reduced reporting turnaround time and decreased expenses. Cognos Impromptu, PowerPlay, Virtualizer, and Query were used to implement a WEB based reporting environment.
• Continued working with the management to support the strategic direction for the data warehouse. Served as Liaison with BI Working Group to help define company-wide BI Methodology, reporting requirements, and conducted review sessions with business users.

As a Manager, led a technical team of Private Client Services implementing the Business Objects as BI Reporting platform worked as a Functional Lead for Data Warehouse Development.

ABHILASH GANDHI Page Four

Data Warehouse Professional

confidential

Sr. Data Warehouse Architect

confidential

Data Warehouse Architect

confidential

Data Warehouse Architect

confidential

Lead Systems Specialist/Data Modeler

confidential

Sr. Programmer/Analyst

As a Sr. Data Warehouse Architect, performed duties as a liaison to foster better communication between the business owners Consulting Group. During various engagements, supervised the staff in the data modeling design, implementation, control, and data architecture standards. Provided technical expertise to client, staff and Data processing management regarding information flow. Led a team to develop a Business Intelligence Methodology and deploy Data Warehouse using various BI tools Cognos, MicroStrategy, and Business Objects .

• As a Data Modeler, performed the logical data modeling necessary to produce the target data model, rationalized and integrated across subject areas, which formed the foundation for Data Warehouse initiatives. Worked with the design team to come up with a standard set of enterprise wide common Dimensions, comply with naming, domain and data type standards for the Dimensional Data Modeling being designed using ERwin.
• As a Mentor, facilitated and conducted knowledge sharing sessions to identify 'best practices and keep abreast of the current tools, techniques, and methodologies.

confidential

Systems Manager

• As a Systems Manager, developed and implemented a Portfolio Management and Trading systems. Worked with asset managers and traders for their day-to-day asset allocations, trading activities and portfolio reporting/analytical needs.
• TOOLS TECHNOLOGY
• Ralph Kimball University: Dimensional Modeling, Data Warehouse Lifecycle Business Intelligence: Cognos, MicroStrategy, Business Objects, MS Analysis Services, DataStage Database: DB2, ORACLE, Sybase, SQL Server Data Modeling: Erwin, Power Designer
• ADDITIONAL INFORMATION
• I was hired for my Data Warehouse Architecture Data Modeling skills. The change in philosophy implementing the Data Warehouse and change in my role inspire me to search for a position where I can contribute as a Data Warehouse Architect.
• Volunteer Work
• One Goal One Passion - Charity Music: I am a technologist by profession but a singer by passion. This passion becomes an excellence at par when it blends with the songs sung by Bollywood singers of 50's to 90's. I use my talent only for fund raising events.