Sign in

Data Warehouse Lead

Aldie, Virginia, 20105, United States
October 31, 2016

Contact this candidate


Viren Papaiyawala

Professional Profile


Information Management/ Business Intelligence

Financial Services

International Experience


Data Warehouse design, Implementation


Software Development Lifecycle

Quality Assurance

Ab Initio, Informatica, Business Object, Teradata, Oracle, Unix Shell Scripting, Autosys,

Big Data, Hadoop, Python, Hive, Pig, Sqoop, Flume, Oozie, Google API/Forms


Master of Computer Science and Application – 2000.

Veer Narmad South Gujarat University, Surat, India

Bachelor of Sciences– 1997.

Veer Narmad South Gujarat University, Surat, India

Mr. Viren Papaiyawala has 15+ years of IT experience with focus on Data Warehousing, Big Data and Business Intelligence projects. Mr. Viren has successfully managed and delivered DW&BI projects across all phases including strategic assessments, roadmap definition, solution definition, design, implementation, and support in many countries. His core strength includes Data Integration Design, Development, Data Warehousing, Big Data, MDM, Data Governance and BI Reporting. He has expertise in Ab-Initio, Informatica, Hadoop, Pig, Hive, Business Objects, and Oracle, Teradata database. He has experience of leading team and projects as well as an in-depth understanding of complete SDLC. He is proficient in project management, utilizing both onsite and offshore models. He has in-depth knowledge of Ab Initio’s most advanced architectural product such as ACE, BRE, Metadata Hub, EME TR, Data Profiler, Ab Initio Environment (Standard Environment), Ab Initio’s MDW product. He is certified Big Data developer.

Mr. Viren is well-organized, calm under pressure and collaborates with individuals, groups and various teams effectively with a high level of professionalism. He is self-motivated, open to change. He has ability to constructively challenge in a skillfully diplomatic, and respectfully debate. One of Mr. Viren’s strengths resides in his ability to think critically (“healthy skepticism”) and strategically, cut through complexity, synthesize and articulate complex strategies in a simple, meaningful, jargon-free fashion.


Clarity Solution Group 03/2016-till date

Last Work Experience:

Tokio Marine North America (TMNA), Philadelphia, PA 03/2016-07/2016

Role: QA Lead/Manager

TMNA made a significant commitment to insurance platform modernization through the Guidewire (“GW”) insurance suite. As part of this effort, Customer is challenged with ensuring a smooth transition of existing reporting capabilities. Currently, premium and corporate reporting are based on data from an application called APPS. Some of this data is also sourced from RapidSure. With the implementation of GW BillingCenter, there will be three (3) data sources for reporting (APPS, GW DataHub, and best RDBMS source). The Customer approach involves minimizing existing reporting impacts by transforming data from the GW DataHub and loading GW data into legacy reporting data structures. The primary objectives of the GW BillingCenter Release 1 (“R1”) Reporting Solution project are to provide the same consolidated reports for business consumption using three (3) data sources.

As a QA Lead, my responsibilities were:

Draft overall test strategy, environment, standards, guidelines and testing methodology through rigorous design, planning, execution, monitoring, and improvement which provided end-to-end traceability.

Identify requirement gaps and help development to resolve many complex issues before migrating to higher environment.

Suggest improvements to process and managing requirement changes. Also analyzed test requirements and provides a solution in terms of test approach.

Create complex queries to perform end to end system integration testing.

Identify issues and risk to project/deliverables or requirements and communicate to Clarity project lead as well as client lead.

Technology environment: Informatica, MS SQL 2012, HP ALM, Control-M, Guidewire

Last Update: 26 Oct 2016

Papstree Inc. (Co-Founder) 12/2013-03/2016

Banorte, Mexico City, Mexico

Role: Solution Architect

Banorte, in its pursuit of becoming not only the leader in banking in Mexico but in the world, initiated the Customer Business Intelligence (CBI) program and the Customer Analytics Repository (CAR) project to transform its enterprise-wide data warehousing, data movement and analytics technology environment with the primary objectives of creating new functionality, and creating a one-stop place for all analytical data. With the CAR project enabling foundation, the other CBI efforts can focus on driving new, value-generating technology, functionality, and services to the different information consumers within and beyond Banorte. The goal of CAR was also enable Banorte to retire existing data warehouses and data marts thereby freeing up valuable resources and reducing costs using’s Ab Initio’s cutting edge product MDW and IBM’s leading financial service model BDW. As a ETL Lead, I was responsible for:

Building ground up Enterprise Data warehouse. Setting all environments from development to SIT, UAT and Production.

Creating a foundation of entire warehouse platform so many new systems can be plud-in easily in future. Achieved this through deploying a Standardized Data Integration Architecture.

Establish a Transformation Strategy with a focus on specific Data Repositories in each Release

Deploying a consistent set of metadata, from the System of Record source, through the Data Integration and Data Warehouse layers

Ensuring compliance of overall design with the enterprise development standards. Guide other developers on technical issues

Supporting the production rollout and validation activities

Serving as principle point of contact for any architectural and design consideration

Improving performance of overall application.

Technology environment: Ab Initio, MDW, ACE, BRE, IBM BDW, Unix, Oracle, Control-M

Deloitte. 08/2011-12/2013

WellPoint, Richmond, VA 10/2012-12/2013

Role: Enterprise Release Manager

In Wellpoint (WLP) engagement I worked as Enterprise Release Manager (RM) handling all aspect of Release Management which includes managing releases of one of the largest Data Warehouse EDWard (Enterprise Data Warehouse and Research Depot) of Health Care Industry. As a RM, I was responsible for:

Coordinating all infrastructure changes and application changes on those environments. Single point of contact for changes that impact EDWard environments. EDWard environments include development, testing, and production servers. If there were infrastructure change/maintenance that occurs on EDWard release weekend, then my team considered that into the release plan and communicated it to all impacted stakeholders.

Overseeing all release schedules, planning, detail time line and managing WellPoint leaderships expectation.

Gathering information in regard to each change/project and deliver weekly and monthly release report to Enterprise Integrated Release Management group (EIRM/ERM) additional to managing monthly release.

Reviewing and providing approval for EDWard off-cycle release request that occurs outside already established Enterprise Application Release Calendar.

Communicating progress of EDWard’s release/deployment to senior leadership team during the release weekend.

Providing feedback in Enterprise Release Planning meeting to discuss overall issues, mitigation step and enhancement opportunities.

Technology environment: Informatica, Teradata, Unix, Control-M

Wells Fargo Home Mortgage, Charlottes, NC and Minneapolis, MN 03/2012-07/2012

Role: ETL Architect

MIDE is a platform within Wells Fargo Home Mortgage which integrates and standardizes data from multiple sources on the Teradata platform. The multiple source files are being identified and staged on the Teradata platform. Once staged, the fields contained in the source files are available for promotion into the Integration layer, as needed, to support a specified business data requirement.

MIDE program was facing a number of issues impacting business user adoption; Low business user adoption and lack of confidence; Lack of an industrial operating model for MIDE; Large number of defects requiring a quality pause

A number of applications (CODA,AIMS etc.) being sunset in lieu of MIDE; Resource bandwidth issues due to scope and external pressures.

Lead the effort to access current state architecture; identify gaps, future state recommendations and preliminary implementation plan.

Identify areas of opportunity to bring down SLAs from evening to morning 10:00 AM.

Lead efforts of development of Technical Roadmap for MIDE ETL stream.

Provided various architecture options for a scalable ETL environment to enhance system performance, stability in 4 months of assessment engagement.

Participated in Code Branching strategy, Error and Reject processing architecture enhancements.

Technical Environment: Ab Initio 3.0.4, Unix, Teradata, Autosys

IRS, Lanham, MD 11/2011-02/2012

Role: Tech Lead

I was involved in assessing IRS systems facing various challenges in providing timely and quality releases, thus affecting its ability to serve its customers. Some challenges exist around lack of robust processes for planning and deploying each release, including end-to-end traceability, design and code reviews, application of leading practices in design and development, etc.

The objective of the Corrective Action Plan (CAP) engagement is to analyze the existing processes and technical activities, analyze gaps, and provide recommendations for improvements to ensure timely and successful releases.

Technology environment: Informatica, Unix, Oracle, DB2

Exelon, Chicago, IL 10/2011-11/2011

Role: Tech Lead

The goal project was to designs ETL extract for Exelon-Constellation Energy Merger and Acquisition (M&A) activity for General Ledger consolidation.

I created entire JSS schedule for M&A Day 1 activity, which includes running all Unix, PeopleSoft, Oracle Stored Procedure and Informatica objects through JSS scheduler.

Technology environment: Informatica, Unix, Oracle, Teradata

Hewlett-Packard, USA. 10/2005-08/2011

(formally Knightsbridge Solutions, LLC)

Citi, Warren, NJ 06/2011-08/2011

Role: Tech Lead

The goal of the Genesis project was to populate IBM’s common Logical Data Model for Financial Services. GENESIS is a common pool of Contracts, Positions & Balances, organized on an enterprise wide basis (across all Citi Lines of Business), to a common Data Model (and reference data) based on Enterprise Data Standards, and anchored to financials for integrity and completeness.

Technology environment: Ab Initio 3.0, BRE, Conduct>It, Unix, Netezza.

CVS Caremark, Richardson, IL, USA 02/2011-05/2011

Role: Tech Lead


Analyzed business and user needs, helped in preparing high level design by doing data analysis/profiling.

Lead offshore team.

Technology environment: Informatica, Unix, Oracle, Teradata

Allstate, Chicago, IL, USA 10/2010-12/2010

Role: ETL Designer

Worked on various common reusable components for Customer/Household and policy track.


Analyzed business and user needs, prepared high level design.

Designed common reusable component for load, extract and chaining event.

Directed offshore team in construction and code review to make sure best practice guidelines were followed.

Technology environment: Ab Initio 3.0, Unix, Oracle

Citi, Warren, NJ, USA

Role: Lead ETL Designer

Worked on various projects such as Optima-CDM, Outbound, Security Master POC.


Optima: 01/2010-09/2010

Analyzed business and user needs, revised existing systems logic difficulties as necessary.

Defined scope, requirements, and worked with function team lead in Architecture and in tech lead roles to design and architect LGD, LGD to CDM and RWA to CDM processes.

Demonstrated strong analytical and integrative thinking skills. Manage project execution, monitor and control scope, schedule and resource.

Aggressively identified project risks. Mitigate issues and risks impacting project delivery with actionable steps to decision makers and resource managers.

Security Master: 01/2009-02/2009

Involved in Prototyping the leading commercial software technology to receive, acquire, transform and load market data into Security Master Central’s (SMC) normalized, integrated data structure.

Presented key feature of Ab Initio along with other talented consultants, which resulted in winning client trust, confidence and multimillion projects for Hewlett-Packard.

Design and constructed a single reusable component to transform all files having multi row, dynamic header and footer.

Technology environment: Ab Initio 2.15, Plan>It, Oracle, Sybase, Unix, Autosys

Banamex (Intellego), Mexico City, Mexico 08/2009

Role: Tech Lead

As an Ab Initio Tech Lead Mr. Viren’s role was to assist Intellego team in implementing Ab Initio’s best practice approach, review architecture; design to ensure best practice guidelines have been followed.

Technology environment: Ab Initio, Unix

BCBS, Washington, DC and Boston, MA

Role: Tech Lead/ETL Designer


BCBS-FEP - Fraud Information Management System (FIMS) 10/2009-12/2009

Project to migrate MS SQL database to DB2.

BCBS, Boston, MA 04/2009-06/2009

From technical stand point this was fairly simple project but it was very demanding in terms of good communication between geographically disperse cross functional team (client team in Boston, MA, Business Analyst team in Plano, TX and offshore development team in Chennai, India while working remotely from Herndon, VA).


Involved in Requirement Gathering, Analysis, Design and development. Being an only ETL expert in team I performed dual role of DBA and Data Integrator.

Designed and constructed Bulk Data Event (BDE) shared routine to read MQ Message Queue continuously and invoking downstream subsystem based on files/message received from queue.

Designed VDEA MSP subsystem and lead developer team working remotely.

Effectively communicated with client team (Boston, MA), Business Analyst team (Plano, TX) and offshore development team (Chennai, India) while working remotely (Herndon, VA).

Well planned activity and co-ordination efforts resulted in delivering entire subsystem well ahead of time, which was running behind the planned schedule.

Design and constructed many reusable Unix scripts, which were used across the projects.

Technology environment: Ab Initio 2.15, Informatica 8.5, MS SQL, Mainframe, IBM MQ Series (messaging queue), DB2, Unix, Control-M, XML, SOA


In just 6 weeks FIMS project was ready to move in production environment without any defect.

Hewlett Packard 02/2008–10/2009

Role : Project Lead/Asst. Program Manager

Worked with Senior Management team of Information Management practice and operational team in driving better business outcomes. Managed financial aspect of accounts generating more than 8 million/year revenue.


Enabled processes to be more efficient, effectively monitor & control engagement revenue for Fannie Mae and Citi’s projects.

Played key role in stream lining monthly Billing Directive process, Engagement estimation, evaluation and revenue forecast process. Maximized benefits/value for HP by timely forecasting revenue, answering client queries, providing various matrixes to management. Lowered risk, resulted from timely, optimized and simplified reporting processes, accurate revenue forecast with most up-to-date information.

Ensured individual projects are in line with overall HP's management financial plan.

Owned the business case and worked with senior executives/management to gain support for the business case.

Effectively coordinated among cross functional teams of EMs, ECOs, Client Principal, Practice Principle, Financial Service Manager, Client CRC team, delivery team, admin staff and so on…


Rewarded by HP’s management team for outstanding efforts.

Fannie Mae, Herndon, VA 12/2005-01/2008

Role: Tech Lead

Responsible for managing and delivering Requirement Analysis, design, construction, System Testing and UAT with Business team of WLCBS-Restatement project. Visionary skill played crucial role in designing overall system flow of various application having more than 300 individual jobs.


Worked on scope analysis, Work estimation, and Operational work model setup. Setup testing environment.

Performed Stakeholder Management, Scheduling, Resource allocation and Risk management.

Played key role in implementing the ETL framework and Enterprise Production Framework, which were used across the projects.

Designed and developed Accounting module of WLCBS. Involved in design and development of many Business Controls, common reusable components, Autosys JIL scripting.

Designed Common Reject Processing macro, which served as generic component to handle rejects across multiple projects and sub modules.

Effectively utilized system resource and Autosys feature to parallelized jobs through JIL scripts.

Collaborated well with cross functional teams ranging from in-house FAST Design/Code Review committee, Business Analyst Team for UAT, ROC team for post development support.

Mentored team members through presentation and technical guidance.

Technology environment: Ab Initio GDE 1.13.10 & Co-op 2.13.1, HP Unix 11, Oracle, Autosys Job scheduler, Visio, XML, SOA.

Organization: IBM. 11/2003-10/2005

Capital One, Richmond, VA:

Role: Team Lead/Tech Lead, Onsite Co-Coordinator

Projects: APEX, OneView AMDD


As an Onsite coordinator established effective communication channel between project managers, client BSA and offshore team to discover and prioritize deliverables for APEX application.

Delivered analysis factory deliverables, including component narrative and diagram, CRUD matrix, system flow, and Teradata Gap analysis for AMDD application.

Actively involved in resolving daily production incident, defect and data issues.

Creativeness and leadership skill resulted in stabilizing 4 TB of database system.

Participated in enforcing development standards and best practices for development team by conducting design reviews. Mentored offshore developers by providing examples and technical guidance.

Achievement: Rolled out more than 50 enhancements in production in 12 months without impacting daily production run. Leadership and management skills played key role in winning client trust and opened gates for future projects for IBM.

Technology environment: HP Unix, Teradata, Ab Initio 1.13, Co-op 2.13.1, Shell Scripting, Control-M.

Organization: Patni Computer Systems 03/2003-10/2003


Role: Module Lead/ ETL Designer


Next Generation Supply Chain – Demand Planning (NGSC-DP)

Project to forecast 2 years production schedule for customer and product.

Oneview upgrade

Project to migrate customized mappings, workflow of eCRM and ePROC applications from Informatica version 5.1 to 6.0


Performed requirement analysis, schema modeling, design, developed mapping and work flow.

Developed highly tuned Informatica mappings

Designed complex BO universes & resolved “join & performance” issues at the reporting level.

Created break down report of actual discounts in an invoice and sales order level given to customers.

Developed customized macro to simplify data comparison, which reduced testing time drastically.

Mentored junior team members and Conducted interview sessions.

Technology environment: HP-Unix, Oracle 8.1.7, Informatica PowerCenter Designer 6, Workflow Manager 6, Business Objects 5.1.3 and Toad.

Organization: Tata Infotech Ltd 05/2001-03/2003

Mr. Papaiyawala worked as a Product Executive on various tools and technology. He managed enablement and adoption of Technology in Pre-Sales and Implementation cycle. Delivery was through – Proof of Concept/Proof of Technology, Training/Skills Enablement, Workshops, Test and Buy drive. Supported Campaign/Technology Day, Workshops and Solutions for various scenarios were the primary activities. Key products in list are: Business Objects, SpectrucSCM, MapInfo and FontPost IVR. He was actively involved in Business Objects (5 days) and SpectrumSCM’s (2 days) corporate training. His presentation skill played important role in winning client trust in proposed product.


Worked on a variety of projects ranging in both size and scope.

Responsible for understanding the client requirements.

Contributed to continuous improvement of the product development process.

Created universe and Complex reports for various departments across the company.

Trained IT staff on Business Object’s advanced feature.

Worked with many SEI CMM-5 companies in establishing configuration management process through SpectrumSCM product.


Provided support to more than 150 clients geography spread all over India. Played major role in building team from remote location and training them. Received letters of appreciation from many clients for outstanding support.

Technology Environment: Oracle, Business Object, Unix, Script File Language (TIL’s proprietary language), MS Access, Dialogic Voice processing card

Organization: Sugasimee Softech Pvt Ltd 07/2000-05/2001

'MMS System' - a Web based E-mail application is a tool for reading, sending, and managing electronic messages. It was designed specifically with novice computer users in mind, but can be tailored to accommodate the needs of "power users" as well. It uses Internet message protocols (e.g. SMTP, IMAP, POP3) and runs on any JVM supported Operating System.

The guiding principles for MMS’s user-interface are: always present interactive menus, immediate user feedback, and highly secured and high tolerance for user mistakes. It is intended that 'MMS' can be learned by exploration rather than reading manuals.

Responsibilities :

Developed User Interface to send and receive email

Coding of send and receive email module

Monitoring the quality of s/w developed

Unit and System Integration testing

Technology Environment: Apache 1.3.12, Jakarta Tomcat 3.1, JDK 1.3, JavaMail 1.2 API, JSP, Mail Server (SendMail 8.9.2), Sun’s Forte

Training and Certification:

Tata InfoTech Ltd., 2001 -

Business Objects 5.1.3

Hummingbird Software, 2002

Hummingbird Document Management, Knowledge Management, Web Portal

Spectrum Software Inc, GA, 2002:

Spectrum SCM configuration management

Informatica, Philippines, 2004

Informatica 6.0, 7.0

Ab Initio, 2004

Ab Initio

IBM Global Services, 2004

Leadership Skills

Knightsbridge Solutions, 2006,2007

Advance Ab Initio Training, BI Pathways

Decker Communications 2007

Communication to Influence.

Hewlett-Packard 2009

Introduction to Neoview

Ab Initio, 2011

Ab Initio 3.0 à ACE, BRE, Data Profiler, Metadata Hub, EME TR

Deloitte, 2013

EMC Green plum

Big Data

Big Data Foundation, Hadoop Fundamental

Hadoop Fundamentals

Accessing Hadoop Data Using Hive

Introduction to Pig

Moving Data into Hadoop using Sqoop Flume

Controlling Hadoop Jobs using Oozie

Technical Skills:


Data Warehousing, Multi-Tier, Client Server, Distributed Systems

Big Data

Hadoop, Hive, Pig, Sqoop, Oozie, Flume


Oracle, Teradata, Sybase, MS SQL, MS Access, Rational Clear quest, HP QC

GUIs/Reporting Tools/CASE Tools

Visual Basic, Crystal Reports


Python, Unix shell (korn), Visual Basic, C++, HTML–DHTML, Java, Google Scripting

Packaged Tools

SpectrumSCM, Autosys, Visio, Control-M


Dimensional Modeling, Star Schema

Warehousing Tools

Ab Initio, EME, Informatica Power Center/Mart, Business Objects

Contact this candidate