Professional Summary

Sr. Data Architect, Data Warehouse Architect, Data Modeler, Sr. BI Architect, BI Delivery Manager, BI Analytics Strategy lead, Data Governance, Meta Data Architect

• Ashwin has fifteen plus years of experience in Data Architecture / Data Modeling / BI strategy, planning and development, expertise in delivering best in class data warehouse solutions and actionable insights for clients like JP Morgan, Deutsche Bank, PA-DLI, Nextel, Restoration Hardware, FEMA, Merck, AstraZeneca, Carlson Group, Cisco, Merrill Lynch, J J, GE Consumer Finance, TRW, HP, and Citibank. Architected, designed, built, implemented, and managed warehouses with >50TB of data, multiple interfacing systems which service > 1 Trillion portfolio's, for the above clients.
• Delivered multiple successful DW / BI implementations across the spectrum of complexity and business functions including Credit Risk / Planning / HR / Spend Analytics / Credit Ratings / Funds Control / Flood Insurance / Unemployment Insurance / PLCC Private Label Credit Cards / Manufacturing / Retail Pharmaceuticals.
• Extensive domain experience as a Data Architect for Data Warehouse DWH , Business Intelligence BI and OLTP applications across various industries like - Finance, Banking, Telecom, Procurement Systems, Pharmaceutical, E-commerce, Federal, and Automotive.
• Ability to translate technical jargon into business terms and vice versa. Able to switch hats between tech guru and business guru as and when required.
• Accomplished Data Architect / Strategist and BI Delivery Manager with proven track record of successful project deliveries, via conceptualizing, analyzing, and managing development of BI solutions.
• Expert at Dimensional Modeling as well as OLTP Data Modeling.
• Managed MDM / Data Governance solutions and hands on implementation experience of the same.
• Provided strategic guidance to client's BI programs for clients such as, Merck / RHI and Merrill Lynch.
• Created Roadmaps, Policy Guidelines and Metrics to guide top management like CEO's, COO's to align their implementation strategic BI initiatives to the organizations goals.
• Worked and reported directly to CIO's, CFO's, and Director of Operations. Initiated, conceptualized, and managed development of reporting solutions for CEO's to line supervisors.
• Was a single point of contact in managing communication between various teams, and the client organization lead's. Proactively managed risks and worked with all concerned parties to mitigate them.
• Expert at people management and issue resolution. Managed and led technical teams and met expectations on both sides, i.e. the client as well as internal team members. Worked and communicated with stakeholders from various practices and kept all teams updated, leading to a large improvement within the team's performance on all projects.
• Monitored projects for slippages/overages, made necessary adjustments in order to meet timelines. Based on the project requirements, I drove the project teams to follow the right methodologies like RUP, Waterfall and Agile.
• Conducted performance reviews and appraisals, and mentored teams to achieve their career objectives.
• Worked on RFP's, created proposals, estimations for both fixed bid and T M projects.
• Core competencies Data Architecture, Data Warehousing, Data Modeling, Dimensional Modeling, Data Analysis, Application Design and Development, BI Strategy / Solutions /Architecture, Business Analysis.
• Strengths Client Interaction at various levels, Quality Process oriented, Design Documentation, Management Skills, Innovative, fast learner, Excellent Communication and a Creative problem solver.

Skills

Expert level skills in SQL coding and have expertise in applications/tools such as ERwin / Oracle / DB2 / Netezza / Cognos / Business Objects / OWB / Data Stage TOAD. Worked on Operating systems like Windows, Linux, SUN Solaris, SCO UNIX, Banyan Vines.

Experience Summary

Confidential

Managing and handling Data Architecture, Data Modeling, BI Strategy, BI Analysis, Business Analysis, BI Architecture related activities

as a part of the BAO practice. Providing thought leadership for transforming organizations from data centric to information centric approach.

Confidential

Sr. Data/ BI Architect / Delivery Manager

Satyam and managed various BI implementations including Profitability Analysis, Procurement Cycle Analysis, and MDF Management. Designed BI systems and implemented it for Banks and PLCC businesses.

Confidential

Sr. Data Warehouse Architect and Data Architect

Confidential

• I was responsible for not just the transactional side, but also the reporting warehouse design and development. I also managed various performance tuning initiatives
• Designed and implemented various BI solutions to a wide spectrum of industries, ranging from Automobile Manufacturing to Steel Manufacturing.

• Selected Career Achievements Data Architecture / Technical Leadership Management
• Created the Spend DWH and helped J J analyze their indirect spend IS , this in-turn helped them successfully lower their IS by 10 1.4B on a total of 14B of IS.
• Helped Merck establish a robust BI organization including BI Strategy/ Roadmap/Data Governance strategy.
• Architected a highly complex Demand Data Mart RHCDD solution with a ragged-hierarchy/skipping-level. Provided RH with planning gains and buying advantages worth 100M.
• At TRW Automotive AsiaPac worked towards getting a consensus from country managers of all TRW branches to follow a consistent set of performance metrics for P L. This lead to a reduction of 7 Data marts to 1 DWH, 400 reports to 100, which left them with a savings of about 5M in s/w development costs alone.
• Proposed and implemented a BI solution for analyzing various flood related information across United States. The solution provided the users a quick access to information instead of ad-hoc report requests. The overall engagement was a big success and FEMA retained IBM's services even after the PO was completed.
• As a Data Modeler at Citibank, I was responsible for re-engineering the transaction processing database design for the MMM Million Message March where the target was to process One Million messages per minute.
• At Confidential worked on the mainframe transaction processing by removing non-essential processing from mainframe to DB2, this helped achieve a 30 performance gain. This was a significant gain as GFC handles > 1Trillion transactions across JPMC global.

Meta Data Management

As a MDF Architect, created a central product management tool to unify all aspects of product life cycle to a single guiding application. As a Meta Data Framework MDF Architect at Cisco,

Career History

Confidential

Role: Sr. Data Architect / Data Modeler

Responsibilities

• Create roadmap for Credit Risk Reporting CRR Framework implementation and organization wide deployment.
• Create CRR Model and realign all reporting metrics based on this new CRR Model.
• Create complete data lineage analysis for the new CRR Model and align all metric definitions with the new CRR Framework.
• Re-align all external and internal risk reporting to use the new CRR Framework.

Confidential

Role: Data Architect

Responsibilities

• Architected the consolidation strategy with a two step process viz. 1 Consolidate all databases on a single Exadata instance but independent schema's using compress high. 2 Merge multiple schema's into single schema with model redesign.
• Created conformed dimensions to handle reporting and analysis across multiple business functions and geographies.
• Align DB's reporting and analytics process to leverage the consolidated data. Start advanced analytics and data mining initiatives on the new consolidated schema's.

Confidential

Role: Data Architect / Data Conversion Lead

Responsibilities

• Led the conversion team for data migration from Legacy to UCMS. Managed the data architecture for the complete engagement. Was responsible for about 250 reports within R2 and R3. Managed and monitored U which is a scheduling tool used across UCMS.
• Proposed various optimization techniques to the conversion team, which achieved major performance gains based for bringing down the total conversion time from 16 days to 5 days. Was appointed to handle the reporting development as it was behind schedule. Managed to get down 1500 defects on the reports to 20 level 3 defects which allowed the reporting solution to pass UAT. Optimized U to utilize reduced set of scripts to avoid code redundancy and increase system efficiency.

Confidential

Role: Sr. Data Modeler Architect

Responsibilities

• GFC Global Funds Control is a risk mitigation engine within the Treasury and Securities Services TSS division of JPMC. GFC is responsible for approving all transactions for accounts which have any form of credit line with JPMC. Currently GFC primarily runs on mainframes and all reporting takes place on mainframe green screens. The two tasks for this effort were: Firstly to remove all non essential processing out of GFC core engine, this is completely running in core memory for z/OS. Secondly, all reporting on GFC would be driven from the DB2 instead of the core. Thus allowing the core process to do its jobs and reduce non-essential load on the core memory.
• Worked with clients BA's and mainframe teams in understanding all reporting requirements. Proactively worked with other downstream / upstream applications and included their reporting needs as a part of this exercise. Thus increasing the utility of the solution and improving ROI for this program. Created the data model to support all the reporting requirements.
• Phased the complete project work in manageable steps which were aligned with the org wide releases that happen thrice a year.

Confidential

Role: Data Architect Modeler / Data Governance

Responsibilities

• Handled a very large DWH design and delivery for the BIDW project based on IBM's TDW model for the client's requirements on Reporting and Adhoc analysis. The DWH developed was common across the geographies, but the source model was from different versions and systems across geographies. This design helped the DWH design to be source or geography agnostic. The BIDW gave the HQ a single view of all geographies. It also provides common metrics to measure / compare performance across geographies.
• The program also established a common data governance program across geographies which made sure the new BIDW program would not get derailed. The solution catered to multiple and complex hierarchical structures and handles multiple dimensions that change slowly.

Confidential

Role: Data Architect / BI Architect

Project: RH Company Dashboard and Drilldown Restoration Hardware lacked a common set of metrics and reports to analyze business on a daily basis in a manner that is efficient and well understood. The RHCDD project was initiated to produce a Company Dashboard and Merchant Drilldown and gain concurrence across the company on the exact definition of all key metrics and establish a new merchandising hierarchy

Responsibilities

• Analyzed the requirements for the reporting framework and source system structures.
• Created the data model for Staging and Target based on the drill down and dashboard requirements.
• Designed the complex ETL solution behind the ragged hierarchy of products, which was a key factor to the new drill down. Also handled skipping of levels which was expected to be handled in the new application.
• Provided BI Architectural design solution for the Drill down and Dashboards in this engagement.

Confidential

Role: Data Architect / Data Modeler

Responsibilities

• Was the Lead Data Architect / Data Modeler on this project, led the project for the DWH of RQT Rapid Query Tool . Was instrumental in designing their adhoc reporting. Also managed all DB related changes for various releases of MIP including SP 14 15. Designed and built application architecture and individual components that encourage performance, architectural reusability, portability, ease of maintenance and completeness.
• Defined, developed and maintained MIP application data models and high-level design. Maintained and enforced data architecture integrity, assessed technical risks and recommended mitigating actions. Was also responsible for any backend data pulls on emergency requirements that occurred due to natural disasters, such as California Wildfire, Ohio floods etc.

Confidential

Role: Data Governance Lead / Data Architect

Responsibilities

• The Client was seeking to develop a robust data warehousing and analytical environment to meet their current and future information/analytical needs. Current environment included several disparate systems which lead to information being unavailable where/ when and the form it was required in.
• Lead the study of data governance model in place during initiative on which IBM was responsible to chart out the Roadmap. Worked with both IBM and Merck teams and worked around analyzing the various disparate source systems and came up with a high level end state for the final solution. Also came up with a roadmap for phased implementation of the initiative to phase it into manageable steps.
• Established a Data Governance Council to handle any and all changes across all the systems. This helped the initiative to not be ambushed by changes to one system that may not have been cascaded to all dependent systems.

Confidential

Role: Sr. Data Modeler / Reporting Architect

Responsibilities

• Designed the entire Reporting solution including Data Model of Target Data Model for ADS Analytical Data Store , which is responsible for all the reporting sourced from the DDS a Details Data Store. The ADS had customized structures to support high volume reporting and aggregation / calculations. And DDS was more normalized to reflect the exact business rules. ADS, was responsible for various lines of business including Sales, Representative Performance, Brand Performance, Operational Reporting, Contracts Management etc. ADS replaced 3 existing warehouses and created a unified structure for better analysis. Was instrumental in convincing the client the importance of an MDM initiative to manage the Customer and Product.
• Led the MDM initiative and helped the client establish rules around the MDM effort, and also the data governance processes to handle the constantly evolving Product master and customer master.

Confidential

Role: Data Architect / Data Modeler

Responsibilities

• Created the Data Model design for PPR Planning Performance Reporting and a BI framework for the PPR initiative which is basically reporting based off of the SAP and other operational data. As a Data Architect for the PPR team I created the Data Models for the various reporting streams including, ESS Enterprise Strategic Sourcing , Financial Management, and Project Management.
• Was also responsible for interacting with Business to come up with a good model. Also interacted with reporting teams to come up with the appropriate data structures to support various reporting methodologies.

Confidential

Role: MDF Architect and Data Architect

Responsibilities

• Re-architected MDF to be a completely in-memory application, to optimize its performance. Modified the architecture of MDF, by creating API's for MDF which allowed other applications to retrieve product information from MDF.
• Worked with Cisco.com CDC group to integrate it with MDF, and also use rules from MDF for CDC content generation.
• As a Data Analyst had to analyze scenarios where the data was not consistent and advice business on getting it updated, of ramifications of change in data.
• Led the onsite/offshore team to get changes implemented to the core MDF application itself.

Confidential

Role: Sr. Technical Architect / Business Analyst

Responsibilities

• Gathered detailed requirements by analyzing internal business processes and interacting with the Business team. Interacted with various application teams for sourcing data and feeding data into them. Analyzed various architectural approaches to have a viable and high performance solution.
• Created and delivered logical and physical data models for the OLTP as well as reporting DB using ERWin.
• As a Data Analyst verified that all the source data conforms to the mentioned business rules and is in a proper format. This in turn eliminated costly time overruns during Data Migration Phase.
• Recommended modifications in the existing process to support better reporting and analysis of the data.
• Created Detail Design Documents for the final solution, and the derived approach was confirmed and designed as a Technical Architectural Solution for the Reengineered LTIGS.

Confidential

Role: BI Solution Architect/Delivery Manager

Responsibilities

• Communicated with the senior client management to make sure all interested parties were updated with the progress of this initiative, along with any issues identified.
• Created and Documented the data model for the spend mart Implementation. Managed project staffing based on the solution proposed and led the overall project delivery.
• Proactively initiated data analysis task which helped identify data quality issues ahead of time. Worked with J J leadership to evaluate Data Cleansing tools.
• Recommended changes and streamlined standards for consistency that would avoid future data quality issues within the Ariba Buyer process. Managed project risk by taking proactive measures, which was not part of the project plan.

Confidential

Role: Sr. DWH Data Modeler/ Business Data Analyst

Responsibilities

• Interacted with the IT team to come up with the SRS Documents apart analyzing business requirements.
• Analyzed data and interacted with business to revalidate their data requirements, in order to re-model the data for optimal performance. Developed data models for VLDB's, which would be used for analysis and reporting. Redesigned ETL models for performance tuning with DBA's for resolving problem areas.
• Reduced processing time for various downstream applications, by creating PL/SQL procedures for pre-aggregation of data. Designed a solution for data analysis with proper problem definitions, by interacting with business technology teams. Debugged Ab-Initio graphs, and created Business Objects Universe.

Confidential

Role: BI Architect Data Modeler

Responsibilities

• Gathered and analyzed requirements and created logical and physical data model. Also designed and defined DB design standards followed by all geographies, implemented them via onsite /offshore model.
• Created a consistent set of metrics for all countries worked on receiving a buy-in from all geographies.
• Lead the entire DWH team, analyzed specifications provided by the client, covering all aspects of the management's requirements for Dimensional Modeling of the DWH.

Confidential

Role: Sr. Data Architect / Data Modeler

Responsibilities

• Analyzed, business and functional requirements, and created logical physical data model structures and data Access Layers DAL .
• Designed developed data models for DWH OLTP systems US Disbursements Global Payments stored procedures for aggregates to speed data retrieval for the OLTP application.
• Interacted with various application teams for sourcing/feeding data.