Resume
Data Architect, NJ
SUMMARY
- A Leader in Enterprise architecture with 18 years of extensive experience building Data strategies, design, development and Implementation of Enterprise - wide systems (ie ERP, CRM,MDM etc), data warehouse, Business Intelligence solutions across different clients.
- Consult, Guide, Advise clients in Business process transformation, Technology Strategy, Digital Transformation.
- Build strategy around Enterprise data assets, Data quality, Data Integration and leading Digital Transformation for clients.
- Played various Leadership roles in Reporting & Analytics involving Data Architecture, Datawarehouse, Business Intelligence & Master Data Management initiatives.
- Strong program management experience (using Agile), stakeholder management, cost estimates and budgeting.
- Worked with business stakeholders and CTO organization on strategic initiatives. Managed a Global team of 4 to 25 with onsite and offshore and 3rd Party resources.
- Strong functional knowledge in Banking, Telecommunication, Pharmaceuticals, Manufacturing, Insurance, Retail.
- Worked extensively in data modeling, logical and physical design of relational, multidimensional and Bigdata databases,
- Currently member of DAMA and TDWI Organizations.
PROFESSIONAL EXPERIENCE
Confidential
Data Architect
Responsibilities:
- Involved in guiding Digital transformation for Confidential clients.
- Work closely with Stakeholders to build vision, strategy and roadmap for digital transformation for clients.
- Leading implementation to deliver digital transformation using Cloud, Non - Cloud, Hybrid architecture Evaluate current state architecture and build strategies, roadmaps, solution architecture for future state architecture for products.
- Oversee and guide selection of Hardware and software Products
- Advise, Consult, Guide Digital teams on IT Integration, M &A, Architecture principals and strategy.
- Leading the implementation of Data warehouse, Data Lake (AWS,Azure) for the Confidential internal clients and come up with strategy to build self-service BI capabilities.
- Advising on setting up solution architecture on Machine learning and Artificial Intelligence.
- me am also part of Confidential Enterprise Architecture leadership Guild.
Confidential
Data Architect
Responsibilities:
- . Leading the Data Architecture, Vision, Strategy Roadmap for implementing EDW
- Designed Customer and Product master data management for the enterprise using custom toolset
- Involved in building Party master (Provider, Customer, beneficiary, Annuitant, Agents etc) for the enterprise
- Involved in requirement gathering for divisional and enterprise level reporting
- Designed Star Schema for different areas like Policy, Claims, Payments, Providers, Parties, and Agents.
- Involved in the analysis of sources(Insurance admin systems) for various business units
- Created MDM implementation strategy and matching rules for all business units
- Designed specs to implement with Onsite and Offshore resources
- Involved in building Customer analytics
- Involved in Requirement gathering for Anti - Money Laundering for Individual Life business
- Designed Integration process and specs for EDW to FCRM system
Environment: Oracle 12, Informatica 9, Tableau, Business Objects, Pivotal (Hadoop), FCRM5/2014 - 6/2015
Confidential
Sr MDM Architect
Responsibilities:
- l Involved in Data Architecture vision, Strategy, Roadmap, integration of cloud Architecture with Enterprise Architecture
- Involved in requirement gathering with business users and stakeholders Involved in tools selection, resource planning, project planning
- Developed data design and integration architecture for integrating salesforce,Siebel systems from AP,North America,EMEA
- Designed and developed strategy for Cloud Customer master data management Initiative
- Involved in developing Data Governance Initiatives for Cloud Customer MDM
- Designed and developed integration with reporting tool (Salesforce Insights)
- Designed Executive reporting dashboard and integrating with Salesforce and EdgeMartEnvironment: Salesforce, Salesforce Insights, Cloud MDM, Linux, Informatica Cloud 9
Confidential
Lead Data Architect
Responsibilities:
- . Involved in tools selection, resource planning, Project(Agile) & sprint planning
- Involved in Requirement gathering with business user and Stake holders to define DW strategy, Vision,Road map for building MPP data warehouse.
- Developed the overall architecture for BI and Integration to Local Merck systems and 3rd party Data providers.
- Designed star schema for all subject areas like Sales, Inventory, Trade Management, Sales Force, Field Activity, Consumer Market data.
- Designed a generic integration layer to load raw data from different external, Internal Data provider and other local Merck systems using Informatica and Teradata utilities
- Involved in developing Data Governance Initiatives and built MDM for Customer and Product.
- Review Database design and make optimization/performance improvement in Reporting using Cognos and Spotfire
- Review Data Quality issues; Perform root because analyses, recommend and remediate Data quality issues.
- Designed Global Dashboard for Executive reporting, Dashboard for country level reporting using Cognos and Spotfire
- Designed and developed BI Reporting layer for Adhoc reporting for Power users.Environment: Teradata 13, Informatica 9, TIBCO MDM, Unix, Spotfire 13, Cognos 10, Erwin 8Global Integration HubGlobal data hub is an operational data store built to integrate data between Salesforce (BUZZ) and Data warehouse systems. Salesforce, territory, Customer and alignment data is sourced from local system to Salesforce (BUZZ).
- As an Architect worked with different source systems to analyse data across various countries for MCC
- Involved in the design of ODS(data hub) to source data from local sources system and 3rd party vendors
- Involved in Integration with SAP and Salesforce for Order management.
- Involved in the solution architecture for integrating from source to data hub and data hub to Salesforce(BUZZ)using Informatica Designed Integration between Data hub to BI for Reporting
Environment: Oracle 12, Informatica 9, Unix, SAP, SalesForce (BUZZ), Erwin 8,SOA
Confidential
Sr Data Architect
Responsibilities:
- As an architect worked with different business teams to gather requirements
- Involved in tools selection, Project (Agile) & sprint planning.
- Leading data warehouse design using (Aster) Involved in the design of various 3rd party clickstream data (Omniture, exacttarget, edialog etc)
- Integrated NoSQL for e - Mail marketing, clickstream social networking, twitter data with the data warehouse Designed the reporting environment using cognos and spotfire
- Designed cognos framework model for different business teams and setup user security
- Designed returns dashboard, vendor dashboard using cognos 10
- Designed reporting framework in spotfire for power users
Environment: Aster 4.5, postgress 9, Map-R, Amazon AWS, Linux, Pentaho kettle 4.2,Cognos 10,Spotfire,sql
Confidential, NJ
Sr Data Architect
Responsibilities:
- . Worked in the WM architecture team on various Data initiatives for the WM and group CTO.
- Worked on Data Strategy to rationalize in the UBS organization on mater data.
- Involved and managed Financial Instruments rationalization project with third party vendors
- Worked with Business stakeholders on various data architecture initiatives.
- Worked on optimizing the use of Market data in UBS Wealth and management and the group level.
- Used Erwin for modeling current trading, retirement and client facing systems.
Environment: Oracle 10g, Solaris 8, PL/Sql,Informatica 8.1, Cognos 8.3 Suite(Frame work manager,Report Studio,Metrics Studio), Erwin,DB2
Confidential
Data Architect
Responsibilities:
- Financial Advisory Center data mart is developed to support the business needs of financial advisory clients of Confidential /Merill Lynch
- Proposed BI strategy and road map for FAC data mart.
- Involved in the Infrastructure upgrade on databases, ETL and BI tools based on Target model for BOA.
- As an architect, Involved in the analysis and design of Projects and Initiatives like Free - for Life accounts,Booksmart in the data mart
- Involved in Logical and Physical modeling for projects/Initiatives.
- Designed the data model for data mart using Erwin and setup data dictionary.
- Designed dimension and facts for Free for Life accounts, Booksmart,
- Redesigned Client segmentation process in data mart interfacing with Siebel IVR application using Informatica.
- Involved in the Gap analysis for migrating financial advisory accounts from Confidential into Confidential accounts
- Involved in redesigning Cognos reports using framework manager and report studio
Environment: Oracle 10g, Solaris 8, PL/Sql, MS SQL Server 2005, Informatica 8.1, Cognos 8.3 Suite(Frame work manager,Report Studio,Metrics Studio), Erwin5/2008 - 4/2010
Confidential
Data Warehouse Architect
Responsibilities:
- Involved in the analysis for designing data warehouse for HCC related applications, contracts, Global expenses system, and CRM systems.
- Prepared a project plan with milestone and deliverable for different phase of Totality data warehouse.
- Designed the data model Erwin and setup data dictionary.
- Designed conformed dimensions and star schema using Erwin.
- Designed ETL specifications to load warehouse from different source systems with Informatica
- Developed ETL process using Informatica transformations with team of ETL developers from onsite and offshore
- Designed reporting infrastructure with cognos framework for internal users
- Designed and developed HCP Expense Reports for State and Federal Agencies.
- Developed Security model for Internal External Users to Health care compliance warehouse.
- Developed third party reports for external HCC related transactions
- Designed Totality dashboard for HCC monitoring clients and senior management
- Developed reports distribution process for Third Party and Internal Project managers
- Provide status to project management and senior management about HCC Reporting.
Environment: Oracle 10g, Solaris 8, PL/Sql, Informatica 8.1, Cognos 8.3 Suite(Frame work manager,Report Studio,Metrics Studio), Erwin, Kalido
Confidential, Jersey
Data Warehouse Architect
Responsibilities:
- Rhapsody is the consolidated risk data warehouse for Global Credit Derivatives in Confidential . It was developed to support traders and risk managers, senior management with consolidated risk reporting.
- Involved in the requirement analysis with the Bond, Equity, and exotic products trading systems. Designed star schema using Erwin. Designed User security at book level for different users.
- Designed the data model using Erwin and setup data dictionary.
- Involved in designing ETL Process between trading systems like Aurora, Decibel, and Vmaster using Informatica Designer, workflow manager, shell scripts.
- Designed Reporting infrastructure with Cognos models using Cognos Framework manager for traders and senior management.
- Designed and developed dashboards for traders using report studio. Developed Risk reports for Risk Managers for different trading regions based on Excel. Troubleshoot adhoc queries for traders.
- Developed audit reports for finance users. Designed and developed cubes for analyzing consolidated risk (Cash and Synthetic positions).
- Automated reports for senior management in the Cognos Portal. Managed data warehouse team of 7 resources onsite and offshore.
Environment: Oracle 10g, Sql Server, Sybase 10,Solaris 8,Unix, PL/Sql, Informatica 8,Cognos 8,Erwin
Confidential
Data Warehouse Architect
Responsibilities:
- ECT data warehouse was developed to provide state govt reporting and Confidential Finance and business reporting. Worked with business users for gathering requirement.
- Responsible for creating project plan and deliverables, acquire resources. Allocate resources and manage tasks. Managed data warehouse team of 4 resources onsite and offshore, Track Project status regularly and update management.
- Designed and developed ODS using Erwin and realtime EDP transformations.
- Designed dimensional models and Fact tables using Erwin, Developed ETL processes for loading star schema.
- Designed finance cubes and score cubes using cognos transformer. Involved in production implementation and troubleshoot production issues.
Environment: Oracle 9i/10g,Solaris 8,EDP, Unix, PL/sql, Datastage 8.0 Cognos 7/8,Erwin, Autosys
Confidential
Data Architect
Responsibilities:
- Enterprise data warehouse was developed to manage enterprise reporting for Financial, Manufacturing, Sales and distribution for Confidential .
- As an architect involved in gathering requirements with users. Conducted JAD/RAD Sessions with the business clients.
- Designed dimensional models, fact tables using Erwin data modeller, Model Manager.
- Designed ETL specifications for loading warehouse and assist a team of developers for developing ETL process using Informatica.
- Designed Sales and Finance cubes using Cognos Transformer, Developed Cognos powerplay reports for Financial and Sales reporting.
- Work with JDE teams and troubleshoot data issues in the data warehouse.
Environment: Oracle 9i, SQL, PL/Sql, HP-Unix, Shell Scripting, Cognos 7, Erwin 4.1.4, Model Manager
Confidential
Data Warehouse Architect
Responsibilities:
- ARIES is a Sales data warehouse developed for BMS Sales in different regions in the world. Designed and developed territory maintenance for different markets using, PL/SQL, Shell scripts, XML, Pro*C.
- Designed the loading process for Orders, Invoice, and GL from SAP to SAP BW. Designed the interface between Global Pricing system and SAP.
- Developed Informatica mapping for loading data from SAP to E - Hub. Performed historic sales extraction from the old system (ESPRIT) and loaded into SAP BW.
- Involved in design and development of data feeds to the various markets from SAP BW. Worked with different groups to troubleshoot data issues, performance issues. Automated data warehouse refresh process with CA-Unicenter.HR Data warehouse
- HR Data warehouse is developed for the HR division of BMS to provide more robust reporting for the HR user community, Government compliance reporting etc.
- As an architect involved in requirement gatherings, prepared conceptual design, logical design based on client requirements. Performed Logical, dimensional modeling using Erwin.
- Designed snowflake schema in HR data warehouse. Designed and developed Slowly Changing Dimensions and complex facts.
- Performed data mapping between sources (Sap, Tessaract) with the dimension and fact tables. Designed and developed data cleansing process for Tesseract source.
- Developed process to load SAP HR data into HR Data warehouse using Business objects integrator (ACTA). Designed and developed transformation using PL/SQL packages, procedures, functions, Unix shell scripts, designed materialized views. Designed Cognos catalogs, designed and developed cognos cubes using cognos power transformer, developed Impromptu, and cognos power play reports.
- Performed SQL tuning and automated data warehouse refresh process with CA-Unicenter. Worked with the BPO resources to transition production support.BEIP
- BEIP is a compliance reporting for statement government agencies. Designed the system to provide details of the employees along with their details working on specific state, research related business areas.
- Designed and developed using PL/Sql, Unix Shell scripts
Environment: Oracle 9i,SQL, PL/Sql,HP-Unix,Shell scripting,Pro*C, SAP BODI, CA-Unicenter, Cognos 7,Erwin 4.1.4,Informatica 7.1.1
Confidential
Sr Tech Lead
Responsibilities:
- Consumer medicines sales data mart receives daily feed of orders, invoices, customer, Products, deduction etc. from the source SAP OTC system.
- Worked with business users to gather requirements, conducted JAD/RAD Sessions with the business clients. Performed data mapping between source (SAP OTC) with dimension and fact tables.
- As an architect designed several star schemas, performed Dimensional modeling and complex fact tables using Erwin.. Developed the sourcing of data with the Shell, PL/SQL, and informatica power center 6.0.2. Involved in designing the ETL process between sales data mart and SAP OTC. Used Informatica power center 6.0.2 to load data into salesData mart
- Designed daily, monthly sales report, weekly deduction repots for internal business users and BMS Brokers using Cognos Transformer.
- Created report for top customers using Cognos Impromptu Involved in the design of Quarterly corporate customer scorecard which TEMPhas details about the sale of products brand wise, promotions sent on the customer etc using excel. Involved in designing sales reports. Worked with clients to design for ranking corporate customers to BMS, developed scripts using PL/SQL, Shell, and Awk.Trade Promotion Fund Management
- Consumer medicines promote their products to the clients on an ongoing basis to boost the sales. Gelco is the 3rd party system used by consumer medicines to manage Trade promotion activities.
- Designed star schema, performed Dimensional modeling and fact tables using Erwin.
- Designed interface for Trade repository with Gelco system.
- Developed interface using Informatica power center 6.2,PL/SQL, Shell, awk to load data from the Gelco System.
- Involved in designing the ETL process between trade repository and Gelco system. Automated data warehouse refresh process with CA - Unicenter.
Environment: Oracle 8i, Pl/Sql, Sql, Erwin, HP-Unix, awk, Informatica 6.2.0 Power center, Cognos Transformer, powerplay, Impromtu, Unicenter
Confidential
Sr Tech Lead
Responsibilities:
- This application is being developed to identify the potential vendors and categorize vendors based on DNB details.
- As an architect designed star schema, performed Dimensional modeling and fact tables using Erwin for preferred vendor Compliance reporting.
- me was involved in the processing of vendor information by creating scripts using Pl/sql, Shell, and Perl scripting, Used Informatica for data mapping and sourcing into operational data store.
- Used Cognos Power Transformer for building Cubes. Used Cognos Powerplay for building reports.PICASSO
- This application is being developed for the A&me, BIOCHEM and CM departments of BMS' Worldwide Medicines Group, which maintains vendor information and generates reports based on expenses, budget projections, etc.
- Involved in the ETL operations for PICASSO to extract data using Pl/sql, Shell, Perl scripting, Informatica from GWAY/SAP. Also involved in retrieval and processing of data from sites.
- me have used data cleansing tools like Syncsort and custom scripts, Used Unicenter to automate sourcing of data from data warehouse to datamart.CAESAR
- This application is being developed for the Chemicals Department of Worldwide Medicines Group to manage RFP's, bids, awards, and contract details. My responsibilities includes
- Coordinating the data sourcing from data warehouse to the data mart, including creation of mapping between source and target systems.
- Develop scripts using Pl/sql packages, stored procedures, Shell, Perl scripting, Informatica, automating the ETL process.
- Involved in building OLAP reports and providing support to users. Used Unicenter to automate sourcing of data from data warehouse to datamart.Net RFI/RFP(Web Enabled)
- This application was developed to manage the company's RFI/RFP process for outside vendors.
- Involved in the data sourcing from data warehouse to data mart, including creation of mapping between source and target systems, coding using Pl/sql packages, stored procedures,, Shell, Perl scripting, Informatica automating the ETL process.
- Involved in building OLAP reports and providing support to users. Used Unicenter to automate sourcing of data from data warehouse to datamart.CMR
- This application were developed to manage the spending with third party manufacturers
- Refund report is generated based on Bills and receipts, contracts to manufacture finished pr
TECHNICAL SKILLS
Skill Level: Artificial Intelligence:
Unspecified: Data Architecture:
Unspecified: Data Cleansing:
Unspecified: Data Governance:
Unspecified: Data Integration:
Unspecified: Data Management:
Unspecified: Data Mart:
Unspecified: Data Model:
Unspecified: Datamart:
Unspecified: Datastage:
Unspecified: db2:
Unspecified: Enterprise Resource Planning:
Unspecified: ERP:
Unspecified: ETL:
Unspecified: Hadoop:
Unspecified: Informatica:
Unspecified: Machine Learning:
Unspecified: Massively Parallel Processing:
Unspecified: MPP:
Unspecified: Master Data Management:
Unspecified: MDM:
Unspecified: Nosql:
Unspecified: Online Analytical Processing:
Unspecified: OLAP:
Unspecified: Operational Data Store:
Unspecified: ODS:
Unspecified: Snowflake Schema:
Unspecified: Star Schema:
Unspecified: Teradata:
Unspecified: Tibco:
Unspecified: Datawarehouse:
Unspecified: Data Modeling:
Unspecified: Enterprise Architecture:
Unspecified: ER Studio:
Unspecified: erwin:
Unspecified: Requirement Gathering:
Unspecified: Zachman:
Unspecified: AWS S3:
Unspecified: AWS:
Unspecified: Data Mapping:
Unspecified: database:
Unspecified: Database Modeling:
Unspecified: Database Design:
Unspecified: MS SQL Server:
Unspecified: MS SQL Server 2005:
Unspecified: SQL Server:
Unspecified: SQL Server 2005:
Unspecified: Oracle:
Unspecified: Oracle 10g:
Unspecified: PL/SQL:
Unspecified: SQL:
Unspecified: Stored Procedures:
Unspecified: Sybase:
Unspecified: Cognos:
Unspecified: Oracle Data Integrator:
Unspecified: Data Integrator:
Unspecified: Pentaho:
Unspecified: SAP Business Objects:
Unspecified: Siebel:
Unspecified: Spotfire:
Unspecified: Tableau Software:
Unspecified: Tableau:
Unspecified: AWK:
Unspecified: Linux:
Unspecified: Shell Scripting:
Unspecified: Shell Scripts:
Unspecified: Solaris:
Unspecified: unix:
Unspecified: Unix Shell:
Unspecified: BPCS:
Unspecified: CRM:
Unspecified: SAP:
Unspecified: Tesseract:
Unspecified: Application Server:
Unspecified: WEB Application Server:
Unspecified: C++:
Unspecified: Coding:
Unspecified: HTML:
Unspecified: JavaScript:
Unspecified: Perl:
Unspecified: Python:
Unspecified: Requirement Analysis:
Unspecified: Visio:
Unspecified: XML:
Unspecified: SOA:
Unspecified: GAP Analysis: