SUMMARY

• 15 years of BI/DW Experience, which comprises of collaborating with system designers, analyzing data, designing databases, providing support to end users, modeling and migrating data for various IT services & Data warehouse solutions in verticals like Automotive, Transportation, Manufacturing, BPO, Finance and supply Chain Management etc.
• 13 Years of Experience in Business Intelligence (OLAP) Tools such as Cognos BI, Report Studio, Analysis Studio, Query Studio, COGNOS Transformer, PowerPlay Enterprise Server (PPES), Cognos Visualizer, Access Manager, Impromptu Web Reports (IWR), Informatica Power Center 7.1/8.1/8.5 etc.
• 12 years in Designing, Development and Implementation of Data Warehouses & various ETL solutions using ERWIN Version 7.x, 8.x, and 9.x, Informatica Power Center, Business Objects Data Integrator 11.5, Oracle 10g/9i/8i, Netezza 4.2, SQL XML Editor tools etc.
• Managed BI/DW deliveries across different domains e.g. Automotive, Finance, Manufacturing, Transportation, Supply Chain, Services and Order Management addressing customers spread across multiple regions/BU worldwide as part of my role in different companies.

TECHNICAL SKILLS

Operating System: MS Windows NT, MS Windows 95, UNIX, MS DOS

Databases: Oracle 8i/9i/10g/11g/12c,, Netezza 4.2, SQL Server 2008/2012, MS AccessFront - End ERWIN Version 7.x/8.x/9.x, Cognos Report Studio Ver 7/8/10.2, Cognos Analysis Studio Ver 7/8/10.2, Cognos Query Studio Ver 7/8/10.2, Cognos Transformer, Informatica Power Center 7.1/8.1/8.5/9.5 , SQL, PL SQL, TOAD, Meta Data Management, Dev/QA/User Acceptance testing, XML Editor tools, test cases and defect verifications.

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Working on creating File specs (Excel and XML format) for Dealer Data Integration Project for areas related to Dealer Employees & customers, Parts Sales, Parts Inventory, Repair Orders and CRM traffic Areas.
• The job also involves adhering to STAR Standards, creating BODs (XML Schemas) and finally creation of Dealer data exchange portal so as to easily exchange dealer’s data with DMS providers, Dealers and HMA Partners.

Technologies: MS Access, MS Access Query, Excel, XML Editor Tools, Database Design etc.

Confidential

Data Architect

Responsibilities:

• Prepared Erwin data models to create Dealer Credit and dealer Risk Marts. This also involved integrating data, creating XML Specs from multiple data sources and creating ETL Jobs to load the XML data from source to Hub, staging area and the risk data mart.
• Analyzed and architected the complete solutions for the Vehicle Services Mart Project which involved the changes in the Dealer data model, Dealer Credit Data Model and Credit Risk Mart and also assessed the impact on the downstream applications and reports.
• Involved in the data quality, creation of consistent and repeatable data governance process associated with Dealer Data, Consumer data, Credit Risk Data, Collections Risk Data on a portfolio of Retail and Lease loans.
• Involved in enhancing the existing Marts such as Credit risk, collections Risk, Finance, Accounting, Tax, Marketing and Profitability Mart to meet the growing requirements due to various report requirements from Risk, accounting, marketing and Finance group.
• Involved in design of Big Data framework to capture, transform, analyze and store terabytes of structured and unstructured data and also consulted with business partners and made recommendations to improve the effectiveness of Big Data systems and analytics systems.
• Involved in building the HR Mart for Confidential Financial Services by integrating data from Salesforce, Workday and Non-workday systems. This project involves bringing in around 4500 fields to the hub layer and then using 550 dimensional and fact related attributes to build the HR Data Mart.
• Documented templates, standards and procedures needed to optimize Data and Reporting performance and ensuring that all guidelines are followed.

Technologies: ERWIN Version 8.x/9.x, Netezza Ver 4.2, MDM, Informatica Power Center 7.1/8.1/8.5/9.5 , Data Warehouse, Master Data, Database Design, SQL, Big Data and cloud Technology.

Confidential

BI Data Architect

Responsibilities:

• Data modeling of different subject areas e.g. Product, Product Catalog, Invoice, Order Header, Order Line Item, Purchase Order, Currency Services, Invoice and Goods Receipt etc.
• Managed integration of master data requirements across multiple projects and building master data model in Erwin.
• Analysis of data requirements and translation of these requirements into dimensional data models.
• Involved in the design and development of the Master data, Data warehouse, Loading of the data warehouse
• Analyzed existing transactional database schemas and designed star schema models to support the users reporting needs and requirements.
• Review application, data and technical architecture deliverables throughout to ensure quality and requirement traceability
• Designed and Developed several e-commerce websites and managed database using mySQL 5.6 versions.

Technologies: Oracle 11g, Data Modeling, ERWIN Version 8.x, Cognos Report Studio, Cognos Analysis Studio, Cognos Query Studio, Informatica Power Center 8.5, Data Warehouse, Master Data, Database Design, SQL, Master Data Management, mySQL 5.6, Wordpress, Content Management Software, Drupal.

Confidential

BI Data Architect

Responsibilities:

• Data Migration and delivery of the BI/DW Reporting solutions to multiple customers across different domains e.g. Finance, Quote-To-Cash, Supply Chain Management and Services.
• Set up the DW/BI practice, Methodology and Framework for GBS Analytics.
• Co-ordination and leveraging of the best practices/Re-usable tools across our business/domains, driving knowledge Management and documentation for all the phases of DW/BI life cycle across all our projects.

Technologies: MS Access, SQL Server, Microsoft SSAS, SSRS, SSIS, Cognos Report Studio, Cognos Analysis Studio, Cognos Query Studio, Data Warehouse, Data Modeling, Master Data Management, SQL.

Confidential

IT Manager

Responsibilities:

• Design and development of the company website, domain name registration for the website and liasioning with web hosting service provider for launching the company website.
• Design and Drawing of the structural units/civil engineering drawings using CAD CAM Software like AUTOCAD and coordinating with the consultant and end client for getting the required approval.
• Instrumental and responsible for setting up of the company’s back end processes and methodologies for project execution, Recruitment, human Resource management and Information system management.

Technologies: Project Management, MS Access, SQL Server, IT Software and Infrastructure Management, SQL.