May 2025 – Present · 11 mos · United States · Remote

May 2021 – Oct 2023 · 2 yrs 5 mos · Houston, Texas, United States · Hybrid

Dec 2019 – Dec 2020 · 1 yr · Oakland, California, United States

• As Technical Solutions Architect for Enterprise Sandbox remediation initiative at BSCA, I have performed the following roles and responsibilities:
• SDM Enterprise Sandbox: Provided the techical leadership to remediate the existing sandbox data mart to a future state platform in order to sunset the existing Netezza big data appliance. Analyzed the requirements and provided guidance to data teams in building the required data models, data transformation rules, STTMs and ELT Scripts for data refreshes. Presented architecture and data flow vision to client leadership teams. It included two tracks:
• Track-1(SDM Track) – Completed the current data evaluation, re-engineering recommendations, data model recommendations, data flow road maps, UDRC Blue Prints, articulating the process using a Jaws framework.
• Track-2(TMR Track) – Designed the workflow for migration of SDM Data to TMR data layer, designed multiple solution options for remediation of current data from a Blackbox to an open architcture using Docker and Ansi SQL based Jaws framework.

Sep 2017 – Nov 2019 · 2 yrs 2 mos · San Antonio, Texas, United States

• Worked as Data Integration specialist for USAA Bank with the following roles and responsibilities.
• Big Data Platform: Hortonworks Distribution of Hadoop on Linux, SnowFlake on AWS Cloud into USAA Enterprise Data Stack.
• MPP Architecture: Netezza MPP Database, IBM DB2 on AS400.
• GPM and SAM Data Lake provides a consolidated BI Data Foundation with daily data refreshes for reporting and analytical Platforms. Additional benefits will include CFO / GL Enablement for significantly faster reporting.
• POC Initiative:
• Technology: Netezza/Snowflake/JDBC/Snowflake API/ IBM IDA – Using a combination of tools and technologies we are moving the data from Netezza Systems to Snowflake through Snowflake API and data porting using Gzip file format and Custom ELT Fabric of Control files. Test data is generated using Optim test data fabricator for data masking and compliance requirements during QA process. Developed constraint rules, knowledge base rules, analytics rules declarative transformation rules, programmatic rules for target data sets.
• My Role: As IDA Specialist I have created the required data models for the data migration and developed the test data fabrication rules for the target platform for Data Integration and UATs.

Nov 2015 – Sep 2017 · 1 yr 10 mos · South Plainfield, NJ

• Bed Bath and Beyond - Enterprise Data Enablement (EDE) will provide a new consolidated Enterprise Data Foundation Layer (i.e. integrated EDW/DW, Supply Chain, Store Operations, Bridal, etc.) with intra-day data refreshes available for reporting and analytical Platform. Additional benefits will include enabling significantly faster reporting during critical business hours, using distributed file systems based technologies on Hortonworks with a Budget of USD 2.8 Million.

Dec 2013 – Dec 2015 · 2 yrs · Greater New York City Area

• Managing Architect for Big Data Initiatives at Travelers Insurance, GE Capital, Morgan Stanley, and JPM Chase.
• Platform: Cloud Foundry, Pivotal Greenplum, Pivotal Hadoop, HAWQ, Cloudera CDH5 with Hive/Sqoop/Impala on Linux.
• Architecture: Greenplum MPP Database Architecture at JPM Chase(Real Estate Asset Management to assess Risk / Reward Relationships), Data Caching for Realtime Analytics(Brokerage, Agency Clearing and Collateral Evaluation), Data Science implementation for predictive modeling of Customer Behavior (Analysis to ascertain Next Best Action)

Nov 2012 – Jan 2013 · 2 mos · Johannesburg Area, South Africa

• Spent a brief period assisting our Project Team that was implementing Data Discovery solution for SBSA(Standard Bank of South Africa).

Sep 2010 – Dec 2013 · 3 yrs 3 mos · Greater New York City Area

• Sr. Enterprise Architect at IBM, for Data Warehouse Appliances, Data Warehouse Design, Data Architecture, Data Governance and Master Data Management. Big Data, IBM-Netezza MPP Systems.

Apr 2009 – Dec 2009 · 8 mos

• California State Fund(California State Compensation Insurance Fund) caters to 60% of employees in California and is the biggest such fund in USA.
• Current effort is to create a 360 Degree view of State Fund and empower it for active business intelligence.

Oct 2008 – Mar 2009 · 5 mos

• Data Architecture and Modeling for the Enterprise Data Warehouse of Blue Cross and Blue Shield of North Carolina.

Jan 2006 – Sep 2010 · 4 yrs 8 mos · San Francisco Bay Area

• Database Architecture
• Data Modeling
• Database Management
• Database Standards and Best Practices
• Dimensional and Relational database modeling,
• Star Schema (OLAP) Design
• Semantic Design and Modeling

Jan 2006 – Jul 2006 · 6 mos · East Hanover, NJ

• Designed and implemented the Marketing Finance and GL Data Marts.

Jan 2004 – Dec 2005 · 1 yr 11 mos

• Designed SOX reporting data mart for corporate governance, financial disclosure and the practice of public accounting and compliance reporting under Sarbanes-Oxley Act of 2002. This effort involves creation of Staging area and a reporting model for the statutory reports. Existing SOX data resides in a Lotus Notes database that has a Presentation layer for reports called Risk Navigator. Data extraction is done using a tool called SNAP.
• This environment has been migrated to a Sybase backend in a relational framework, still maintaining the SOX data in Lotus Notes, but reporting track being migrated to an MS Access Reporting universe.

Jan 2004 – Jan 2005 · 1 yr

• Worked as Data Modeler at Travelers Life and Annuity and Citibank NA during this period, building Data Marts and Data Warehouse for these two sister organizations.

Jan 1999 – Dec 2000 · 1 yr 11 mos

• Worked as Sr. Database Manager at PayPal during 1999-2000 time period.

Jul 1997 – Nov 1998 · 1 yr 4 mos

• Database Administrator / Software consultant at IBM Austin.

Jan 1994 – Jan 1996 · 2 yrs · Hyderabad Area, India

• Head of Networking and I.T Infrastructure at Karvy.

Jan 1984 – Jun 1995 · 11 yrs 5 mos

• As one of the Computerization experts, I have completed Installation of Systems and software at BPCL Offices in the Western Region of India