Ab Initio Warehouse

Email: ****************@*****.*** Cell: +1-804-***-****

Viren Papaiyawala Professional Profile (Active Secret Clearance) I have valid active secret

clearance (01/2020).

Strengths

Information

Management/ Business

Intelligence

Financial Services

International Experience

Skills

Data Warehouse design,

Implementation

Data Integration

Leadership

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

Google Cloud

Education

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 20+ years of IT experience with focus on Data Warehousing, Big Data and Business Intelligence solutions. 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, and Oracle, Teradata databases. 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. Company:

Papstree Inc. (Founder) 08/2018-Till Date

DoD (US Army)

Principle Consultant:

Has had Progressive growth in IPPS-A program and played varied roles such as Project Manager, Project Lead, Tech Lead, Solution Architect, Test Lead, Senior Developer, etc.

Developed Architect and Design Solutions in Data Management/Integration and Business Intelligence space.

Led ETL solutions for Interfaces and Conversion systems within program.

Led hybrid teams consisting of FTE members, contractors, onsite and remote resources, geographically spread across USA.

Led scoping discussions, requirements gathering, environment assessment, etc.

Coordinated efforts across functional groups to ensure implementation activities are planned on time.

Designed, developed, and maintained enterprise-wide reusable framework such as common functions, components, utilities, automation in testing to validate UAT data against expected results, etc. in Ab Initio.

Lead design and code review sessions to ensure quality deliverables in terms of coding standards, efficiency, performance tuning, documentation and maintainability.

Managed configuration changes (SCM), releases, tagging and code promotion between environments.

Maintained Ab Initio EME repository to ensure dependency analysis and data lineage.

Lead performance tuning sessions to ensure Ab Initio graphs leveraged parallelism and resources optimally.

Documentation, Knowledge transfer, Training and Roll out.

Screen new hires and contractors. Mentor junior members and provide internal training. Providing leadership and direction to the team of consultants. Last Update: 23 May 2023

Viren Papaiyawala 804-***-****

Page 2

Ernst & Young LLP (EY) 01/2017-08/2018

Ginnie Mae, Washington, DC

As a Manager, my responsibilities are:

Build entirely new Data warehouse platform for client’s new audit requirement.

Cultivate and manage business development opportunities

Design and implementation ETL solutions using leading ETL packages.

Design and implementation of an operational data store and data warehouse on one of the leading platforms

Conduct discovery, perform root cause analysis, and make recommendations for the remediation of any issues

Improve overall application performance.

Build end to end solutions using Unix shell scripts to automate and reduce manual intervention. Company:

Clarity Solution Group 03/201*-**-****

Tokio Marine North America, Philadelphia, PA

As a Tech Lead, my responsibilities were:

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

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 issues and risk to project/deliverables or requirements and communicate to Clarity project lead as well as client lead.

Explored Google cloud option to develop many applications for in-house IT staff and Data Engineering practice.

Designed and developed workflow based application using google forms, spreadsheet, and google API in google cloud. Company:

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

Banorte, Mexico City, Mexico

As an ETL Architect, 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 in which new systems can be plug-in easily. 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

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

Improving performance of overall application.

Supporting the production rollout and validation activities Company: Deloitte. 08/2011-12/2013

During engagement with Deloitte I worked with many clients on strategic as well as technical implementation assignments. WellPoint, Richmond, VA 10/2012-12/2013

Role: Enterprise Release Manager

In Wellpoint (WLP) engagement I worked as Enterprise Release Manager (RM) in 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 leadership’s expectation.

Gathering information in regard to each change request/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.

Viren Papaiyawala 804-***-****

Page 3

Wells Fargo Home Mortgage, Charlottes, NC and Minneapolis, MN 03/2012-07/2012 Role: ETL Lead

Wells Fargo Home Mortgage program-MIDE 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.

Responsibilities

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. IRS, Lanham, MD 11/2011-02/2012

Role: Tech Lead

I was involved in addressing various challenges faced by IRS Systems in providing timely and quality releases, thus affecting its ability to serve its customers. The objective of the Corrective Action Plan (CAP) engagement was to analyze the existing processes and technical activities, analyze gaps, and provide recommendations for improvements to ensure timely and successful releases.

Company: Hewlett-Packard, USA. (formally Knightsbridge Solutions, LLC) 10/2005-08/2011 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.

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

Role: Tech Lead

Responsibilities:

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

Lead offshore team.

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

Role: ETL Designer

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

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. Citi, Warren, NJ, USA

Role: Lead ETL Designer

Responsibilities:

Optima (Risk and Finance): 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. Viren Papaiyawala 804-***-****

Page 4

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

Role: Tech Lead

As an Ab Initio Tech Lead my 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. 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 using reusable Ab Initio factory. In just 6 weeks FIMS project was ready to move in production environment without any defect. BCBS, Boston, MA 04/2009-06/2009

Responsibilities:

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.

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. Hewlett Packard (Internal) 02/2008–10/2009

Role : Asst. Program Manager

Worked with Senior Leadership 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. Responsibilities:

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

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… Achievement:

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 end to solution for WLCBS-Restatement project. Visionary skill played crucial role in designing overall system flow of various application having more than 300 individual jobs. Responsibilities:

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, 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. Viren Papaiyawala 804-***-****

Page 5

Company: IBM. 11/2003-10/2005

Capital One, Richmond, VA:

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

Projects: APEX, OneView AMDD

Responsibilities:

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. Company: Patni Computer Systems 03/2003-10/2003

MOTOROLA, UK:

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 Responsibilities:

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

Designed complex BO universes & resolved “join & performance” issues at the reporting level. Developed customized macro to simplify data comparison, which reduced testing time drastically. Company: Tata Infotech Ltd 05/2001-03/2003

I worked as a Product Executive on various tools and technology. I managed enablement and adoption of Technology in Pre- Sales and Implementation cycle.

Responsibilities:

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.

Conducted 5days professional training of Business Object’s for many clients.

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

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. Technical Skills:

Architectures

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

Hadoop, Hive, Pig, Sqoop, Oozie, Flume

Databases

Oracle, Teradata, Sybase, MS SQL, MS Access, Rational Clear quest, HP QC GUIs/Reporting Tools/CASE Tools

Visual Basic, Crystal Reports, Business Object

Language

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

SpectrumSCM, Autosys, Visio, Control-M

Methodologies

Dimensional Modeling, Star Schema

Warehousing Tools

Ab Initio, EME, Informatica Power Center/Mart,

Contact this candidate