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, Pharmaceutical, 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 Access

Front - 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, Master Data Management (MDM), XML Editor tools, test cases and defect verifications.

PROFESSIONAL EXPERIENCE

Confidential, Fountain Valley, CA

Data Architect

Responsibilities:

• Data modeling and 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, supply chain management and CRM traffic Areas.
• Interact with business users to understand the Dealer Data Hub Business Use cases and map them to all data elements related to Parts Sales, Parts Inventory, Repair Orders, supply chain management.
• The job also involves adhering to STAR Standards, creating BODs (XML Schemas) and final creation of Dealer data exchange portal so as to easily exchange dealer’s data with DMS providers, Dealers and HMA Partners.

Confidential, Torrance, CA

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.
• 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.
• Currently 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.

Confidential

BI Data Architect

Responsibilities:

• Data modeling of different subject areas e.g. Product, Product Catalog, Invoice, Order Header, Order Line Item, Purchase Order, Invoice and Goods Receipt pertaining to manufacturing of Geogrids, geomembranes and geotextile products 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

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.

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.

Confidential

Data Warehouse Solution Architect

Responsibilities:

• Project management and technical delivery of the SLA Reporting solutions to support the BPO Services monitoring and SLA tracking for various trade customers.
• Requirement gathering and Analysis, Ensuring on Time Delivery, Quality compliance, Status Reporting Updates to program manager, coordinating and resolving issues with other work stream etc.
• Created Business Objects Reports for various applications related to Document workflows and management solutions, eForms, Account Reconciliation, Accounts Payable etc.
• Interacted with the HP Labs Team to set up a development team at China & India for carrying out the SLA Reporting Development work.
• Involved in the architecture development discussion in facilitating the integration of SLA Reporting solution within the overall Portal Framework.

Confidential, Cincinnati OH

Sr. BI Developer / Project Manager

Responsibilities:

• Created various Detailed and Summary reports as per the business requirement.
• Developed various reports with multiple queries and by using Union and Join at the report level.
• Responsibilities included requirement Gathering, Requirement Analysis, Design, Development, Testing, Debugging, Configuration Management, Documentation for the MEO reporting Project.
• Developed and managed Cognos Visualizer Cockpit having several drill through reports to Cognos Power Play Cubes and Cognos Impromptu reports.
• Developed reports capturing various metrics for Military Engine Operations pertaining to different areas e.g. Proposals, Ordering, Supply chain, Forecasting, Inventory Management and Delivery.
• Worked on Informatica Designer, Workflow manager, Workflow Monitor, Direct Mapping and related Documentations etc. Trained several Confidential Users on Cognos front end development tool
• Created ad-hoc Reports and managed a team size of 8-10 resources at onsite and offshore for data warehouse project within Confidential Aircraft Engine.
• Prepared test cases for developed reports and Perform release activities. Prepared Technical Specification Documents and design documents for the developed reports.
• Involved in unit testing of the reports and Prepared Unit Test Plan (UTP). Helped team in handling bug fixes, Change Requests.
• Coordinated with User Interface design team in resolving issues while integration.

Confidential, Cincinnati OH

Senior BI developer

Responsibilities:

• Designed, developed and implemented reports for different customer groups in GEITS
• Developed reports using Cognos Impromptu and is used for reports and published multi dimensional cubes using Cognos Powerplay
• Developed various reports to capture different metrics related to Accounts Payable, Accounts Receivable and General Ledger in Confidential IT Solutions

Confidential, Cincinnati OH

BI Developer

Responsibilities:

• Designed, developed and implemented reports for different customer groups in Confidential, which fall under MEO.
• Developed Cognos Impromptu reports with Prompt features for Confidential MEO division to determine Unfulfilled Orders, Advance release Items, Shipped parts and billed Invoice details.
• Cognos Power play was used to summarize this data at the department, Engine Family Group.
• Published reports using Impromptu web administrator, Power Play Enterprise server administrators & Cognos Upfront.

Confidential

BI Developer

Responsibilities:

• Understanding the report specification and created various reports by using various calculations, variables, page-breaks, various formatting features, functions etc.
• Designed the reports with Master-Detail relationships and Drill through using Cognos Impromptu, Powerplay and Visualizer.
• Confidential has Siebel based CRM system for its operational requirement. The objective of the project was to design, develop and implement reports for different customer groups in Confidential, which fall under CRM.