Teradata DBA Analyst working on developing strategies for Teradata to AWS Redshift migration, Teradata on-prim to Snowflake migration, creating solution for client to develop performance-oriented architecture Worked on designing, implementing, and supporting highly scalable data warehouse solutions. performed data-related tasks and analysis in Snowflake cloud DW, Pipes, Snowpipe, SQS Notifications, Stored Procedures, Views, Streams Tasks etc. Developed AWS-S3 strategy for Migration projects, Studied and translated functional / non-functional requirements to systems requirements, developed standards and best practises for using Teradata utilities such as BTEQ, Mload, Fastload, Fast Export writing test cases and scenarios based on the specifications in the technical requirements. As a Teradata DBA, designed and maintained Teradata databases, Tables, Views, Stored Procedures, controlled user access using Teradata and AD integration techniques, developed strategy for the Teradata database back up and restore for Teradata 16.20 database. Used Teradata viewpoint for monitoring Teradata active jobs and manage any non performing runaway queries.

As a Data Architect currently working on developing strategies for Teradata to AWS Redshift migration, Teradata on-prim to Snowflake migration, creating solution for client to develop performance-oriented architecture. Worked on designing, implementing, and supporting highly scalable data warehouse solutions. Performed data-related tasks, analysing data in data lakes, source data marts, and analysis in Snowflake cloud DW, Pipes, Snowpipe, SQS Notifications, Stored Procedures, Views, Streams Tasks etc. Developed AWS-S3 strategy for Migration projects, Studied and translated functional / non-functional requirements to systems requirements, developed standards and best practises for data quality, using Teradata utilities such as BTEQ, Mload, Fastload, Fast Export writing test cases and scenarios based on the specifications in the technical requirements. Loaded data to snowflake cloud using copy, import export functions from external AWS S3. Transformed the stage tables to target snowflake tables using standard techniques in snowsql. Used snowpipe for ETL/ELT continuous data ingestion from the AWS S3 bucket using procedures. As a Teradata DBA, used ErWin for Data modeling, designed and maintained Teradata databases, Tables, Views, Stored Procedures, controlled user access using Teradata and AD integration techniques, developed standards and strategy for the Teradata database back up and restore for Teradata 16.20 database. Used Teradata viewpoint for monitoring Teradata active jobs and manage any non performing runaway queries

Senior Teradata Analyst Data Modeler Designer from Jan 2022 till present at T-Mobile Inc. for the HRA – Analytics Project in Bellevue WA. Responsible for providing solutions for Analysis, Design and Teradata Architecture for key objectives for the Human Resources Department Analytics. Worked with this same project team previously twice as well few years ago and now working with the Business and a team of 30+ developers and support personnel to provide and implement the entire solution for the HRA. T-Mobile brought in Workday for Recruiting Reinvented analysis and data and worked with Workday Interfaces to design the architecture and for data ingestion into HRA space and further consume this data for reporting purposes. This is extremely sensitive data and had provided security solution before and Designed mechanisms to encrypt and decrypt data being sensitive HRA metrics and provided a mechanism for deriving decryption logic. Designed and architected Teradata databases, tables and semantic layer for BI reporting tools from best performance perspective, as well for Snowflake initiatives, As a lead, provided necessary guidance to entire onsite and offshore teams both in India and Philippines and managed Scrum calls, created User stories, tasks to provide the accurate reporting for the upper management. Worked with Business to align requirements and strategic long term planning.

Teradata DW Consultant / Data Modeler for United States of America - DOJ Finance Staff from September 2020 till January 2022As a Teradata expert and a Data modeler worked on initiatives for onboarding data from various data sources of United States Department of Justice Bureaus and Components on to Teradata to give visibility and reporting capability on JEDI2 related Agreements, Budgets, Funds, Grants, Projects, Programs. Created a Component Assignment process that would use accounting string look up matching mechanism to identify which Components will have the visibility to the data. Created a security assignment process to assign reporting access to these underlying financial data. Extensively used Teradata Stored procedures to create an ETL flow that would run on a daily basis and refresh underlying facts and dimensions. Implemented various Teradata standards and best practices in order to get better performance, reliability and integrity in the data marts. Used Erwin Release 2020 to manage and maintain the Physical Data Model for the entire JEDI2 Project.

Teradata Solutions Architect from December 2019 till August 2020 at Sony Pictures and Entertainment, Culver City, Los Angeles CAAs a Vantage Solutions Architect, working with business requirements, business processes and system functionality to develop strategy and solution to integrate the data source into the BI environment that involved technologies like Teradata 16.20 on Vantage Platform, Oracle, SQL Server, Business Objects and Tableau. Performing conceptual, logical and physical data modelling and designing using CA Erwin Data Modeler Workgroup Edition release 9.64.02.5011. Employing techniques for processing high volume transaction systems and designed and developing and managing the data structures required to support the enterprise through the BI program. Responsible for creating, maintaining reporting structures for Sony TV Distribution group and giving solution for very critical sales, budget data analysis to be reported via Tableau or BO universes. Introduced some high-performance techniques on Vantage platform such as data compression, multilevel table partitioning, improved upon methods of collecting statistics and bringing overall value to the reporting views with a larger user base consuming sales history, revenue and budgets for Sony TV Distribution. Implemented change data capture and incremental data load strategies while dealing with very large data sets, improving CPU usage, overall performance matrix. As part of SONY Teradata architects group proactively participated in Snowflake, AWS integrations, IRA calls, worked on initiatives and issues such as day light savings, implementation of Query Grid on Vantage Platform etc.

Teradata Developer from April 2019 till September, 2019, at T-Mobile Inc. for the HRA – Analytics Project in Bellevue WA. Responsible for providing solutions for Teradata Architecture for key objectives for the Human Resources Department Analytics. Headed a team of 30+ developers and support personnel and provided and successfully implemented the entire solution for the HRA Security Automation where Business groups would be identified that needed certain access to the BI Reporting dashboards developed on Tableau and SSRS and similar BI tools. Created roadmap for the HRA Platform and provided standards, best practices and guidance for the entire platform team and the business in order to achieve the necessary stable and reliable most importantly a secured environment for HRA application. Designed mechanisms to encrypt and decrypt data being sensitive HRA metrics and provided a mechanism for deriving decryption logic using Voltage Keys. Designed and architected Teradata databases, tables and semantic layer for BI reporting tools from best performance perspective, As a lead, provided necessary guidance to onsite and offshore teams and managed Scrum calls, User stories, tasks to provide the accurate reporting for the upper management. Worked on highly sensitive T-Mobile and Sprint Merger from HRA perspective and created environment adaptable for merger initiatives and SOX compliance.

Worked as a BI Solutions Designer in a leadership role and designed analytical data integration solutions that promoted the value and potential of BI across the Enterprise, drive strategic and tactical decisions for the Business Analysis by interviewing business users to obtain information requirements.• Performed analysis on data sources in environments such as Data lake, Hadoop, Vertica, Teradata to verify expected data content, relationships and quality• Designed and communicated conceptual and logical data models to be deployed on target environment of eCDW Vertica• Developed and communicated high-level technical designs in order to resolve complex technical and business issues, proposed processes for capturing and maintaining data from all data warehousing components• Proactively monitored data quality and proposed solutions to restore data quality issues• Provided direction and guidance in improving the data load (ETL) processes• Actively participated in the definition of best practices, standards and procedures for the BRD (Business Ready Data)• Created dimensional data model designs (ERWIN) and wrote specifications for data load strategies for normal as well as conformed dimensions• Worked with DBAs, platform team to roll out data structure designs• Directed development team to design data load strategies• Worked with Microstrategy team to design BI reporting mechanisms to cater to variety of business user groups.

Worked as a Teradata SYSDBA, Enterprise solution architect, audited Teradata Setup, Reverse engineered Physical Data Model using ErWin, Came up with Teradata Design Architecture Solutions (SDLC) (RACI) for variety of requirements,As a SYSDBA, engaged in multiple roles for managing the platforms, user access.Tuned access methods to Teradata Development and Production for all users, Handle all TAY’s alerts, Teradata failures, upgrades etc.Added new Teradata hardware, created COP entries e.g. TDPROD (2750s), TDDEV (6690s). Worked with limited space constraints and followed up on space acquisition for TD backups, installed archive software solution, ABU Utility,Commissioned and configured Teradata Viewpoint servers, managed to install upgrades of Teradata versions of Database, software, tools and utilities,Conducted Bi-weekly Teradata Homeroom meetings talking about Teradata related activities, issues, concerns, Teradata Outages, Teradata upgrade coordination, Capacity planning and management, Usage monitoring and advising the user community, overall Teradata Governance related items etc.Worked on variety of Teradata Production application developments, QA, Testing, deployments, Project Documentation, CRQ, Problem tickets etc. High volume tables analyzed for MVC compression, proposed, tested and completed LDAP / SSO implementation,Worked on Teradata firewall Access issue for Offshore folks, Worked on Teradata appliance re-racking related activities,Created users, access rights for Cognos/Spotfire connectivity and established standards, As a SYSDBA, Worked on Teradata Hardware BIOS Upgrade plan, created Data Warehouse Governance model and RACI for the data warehouse.Teradata 6690 – Purge Cleanup initiated, table skew factors identified and addressed, created SharePoint for sharing Standards, Best Practices etc.Worked with onsite support engineers, data center folks, Coordinated capacity, air-conditioning, upgrades, patches, updates, moves, floor sweeps etc.

CMS - Performance Architect and Production Support DBAhelped in identifying opportunities for overall performance tuning, monitoring SAS users, their system usageProposed new JI strategy for better SQL performance, propagated the JI strategy to base table PPI Tuned user SQL by re-writing it using SQL techniques like using derived tables, better joinsCreated the Database Object version control strategy from disaster recovery and MVC perspective

Teradata – Kaiser Permanante, TOP Team Performance Architect from October 2013 till January 2014• As a Performance Architect for the Teradata TOP team, helped identifying overall Database and SQL performance tuning opportunities for KP Northern California Teradata installation• Identified variety of venues where performace of the system can be enhanced• Provided solutions that can result into almost 12% system savings (about 3 nodes) converting into few million dollars in savings• Solutions included, better PDM designing, Better Teradata access startegies, Indexes• Tuned user SQL by re-writing it using SQL tenchniques like using derived tables, better joins• Suggested creation of summarized table structures for SAS, Tableau, BOXI reports instead of having the adhoc users load the system by repeating complex claculations, aggregations and summarizations• Appropriate statistics colletion on columns used in joins across various view layers, extensively testing solutions provided for better system performance.• Worked with a variety of users to get overall system usage patterns and suggested some TASM settings for optimum performance. Provided Teradata standards and best practises guidelines to the architectural team.

As a Teradata Solutions Architect analyzed existing data models, identified user requirements, created LDM and converted that to Teradata PDM• Worked also as a Teradata DBA for the project and created physical table structures to support the reporting reqiurents• As a unix shell script developer developed a robust UNIX Shell script based framework architecture for enabeling reporting requirements for CDC and similar clients of BCBST. • Created Shell Script Templates that would take certain paramerters required for reporting and produce reports that would be sent out via secured network to various external business entities of BCBST• Designed and develped data structures, stored procedures, macros for the automation of the reporting.

Worked as a Teradata BAR (Teradata Backup Archive Restore) Solutions consultant working on an Incremental BAR Strategy for Bestbuy Inc., and designing the overall architecture and solution for the POC. • This involves analysis of the current Teradata Databases and coming up with a new methodology for an Incremental approach for capturing the data changes, additions or deletions for archives. • These archives are also used for creating a dual active environment in future to support Disaster Recovery plan. • The tools used are Data Domain, Netbackup and Data Mover to facilitate this POC. • The biggest win in the process is to achieve a cost effective, reliable, performance optimized BAR architecture.

Worked at T-Mobile as a Teradata Solutions Architect, mainly responsible for implementing Teradata best practices and giving guidance to the Teradata data warehouse team helping them in migrating from Teradata V2R6 to Teradata 13 for the upgrade. • Introduced Teradata Multi-value Compression, Performance Tuning for BO / BI applications, DB Archive using netvault, TARA, OPTIM, a QA environment that is consuming way too many resources and aim is to bring down database sizes to more meaningful and create a cohesive test environment for projects rolling out in near future.• In charge of Capacity, planning and forecasting for the various platforms of Teradata create resource utilization map of the system for capacity planning needs. Suggesting compression techniques and revisiting existing data models for better performance. • I worked on creating various sandboxes applications. Used Atanasoft AtanaSuite Enterprize 2012 for implementing Teradata compression. • Worked on T-Mobile & AT&T merger initiative and helping out with Teradata data requirements and platform requirements as such. • Worked on performance tuning of the Teradata Business Objects application and re-designed underlying database structures for advanced Bad Debt reporting for T-Mobile. • Worked on Teradata project for SAP BW MDM, Informatica ETL, helped lead data acquisition and metadata management for data loads and reporting needs and analysis for BI teams and group of BI users for the client.

Consulting at CiscoMy role is to provide Teradata technical architecture solutions to CA team and providing consultation on effort in bringing existing Oracle EDW applications on to New Teradata Platform. Working closely with Cisco leadership in providing overall effort logistics and technical expertise. Cisco has been treditionally an Oracle shop and new vision of leadership at Cisco will turn it into a Teradata powerhouse.

Independantly perform and lead complex Teradata infrastructure / IT tasksDesign IT Infrastructure Teradata processes, activitiesMonitor and control processes on a technical levelInterface with other infra / IT unitsProvide technical and professional guidance to other IT staff

Senior Database Administrator• Responsible for ensuring operational excellence for the Strategic Data Repository (SDR) and CCRTS application for 100% data quality and system availability. Improved batch cycle performance by implementing compression and he reduced space by performing a database cleanup that achieved a space savings of 25% hence reducing costs. As an Application DBA managed 12 SDR Databases comprising of Tables, Views and Macros on EDW Production and 24 Databases on EDW Development / System Test. Managed archival and restores of SDR databases and any SDR support and maintenance related tasks. Data archived on daily basis, both on EDWD and EDWP.• Key responsibilitieso Developed, maintained and monitored SDR "Sanity Check" reports on daily / weekly basiso Focused on business continuity/disaster recovery/security & availabilityo Maintained Application Recovery Manual (ARM) documentationo Supported client applications by providing a meaningful customer hierarchy test data from EDWP to EDWD as part of Quarterly refresho Attended EDW Developers Forum meetings and helped in conducting Teradata West Coast User Group Conferenceso Developed and maintained all SDR databases on Development and Production EDW platformso Created migration policies, methods and controlso Controlled granting access and monitoring it for various SDR databaseso Cleaned up access rights on a daily basiso Supported close to 6000 user access rights on both platforms, EDWD and EDWPo Maintained SDR Data model for each SDR Release into Production in ERWINo Provided any working around solutions for issues Teradata SQL to suite needs especially in case of spool space errors, worked around with capacity planning to handle system loads, used PMON and TASMo Routinely checked roll-off data processes, maintained tables for roll-offs or deletes, archives etco designed Migration strategy, ----- information limit reached here...

Programmer Analyst • Programmer Analyst, as an expert in Developing Data Conversions using ETI COBOL, converted Flat File to load to Teradata DSL for the Bank of America Enterprise Data Warehouse.• Key responsibilitieso Studying existing MARK IV systems and redesign / modify to an efficient COBOL systemo Data Analysis, Design, Develop and Implement various ETI generated conversions for the Bankcard application, BofA Mortgage servicing, Securities and automated Financial Systems and to load NCR Teradata database tables / views using Teradata utilities like Fastload, Multiload, Fastexporto Used BTEQ, ITEQ under VM in order to validate data that has been loaded in the tableso The development of ETI conversions included retrieving flattened Schema, plugging in the special Codeblocks, filters, cips in order to generate correct codeo The generated code was then tested using test data and finally replaced the existing MARK IV systems with the ETI developed COBOL systemso Monitored and maintained various daily weekly and monthly batch applications in order to comply with the business needso As part of the Y2K compliance exercise, helped validate various business applications in the Time Machine

Technical Team Lead • As a Technical Team Lead for two systems, Loss Management (LMS) Front End System and IP&L system worked to provide technical expertise and leadership. The application systems used CICS, DB2 and COBOL on IBM mainframe for processing claims for insurance policies for AIG, the multi-national Insurance Group.• Key responsibilitieso Responsible for managing these two teams with goals of maintenance of these application systems, the environment, the programs, the data files, modules and provide an on-going production support to provide solutions to production related problemso Actively involved in user education and other activities that would help in smooth day-to-day operation of the application systemo Other duties included software maintenance related analysis, modifications and controlling software versions among various development projects within the systemo As part of production support resolved problem tickets maintained on Lotus Notes / MAGIC & Infoman database on a daily basis, user interaction and communication are major activities that are needed to be performedo Also responsible for Higher-level management related reporting for project status as well as other activities performed during production support

ETI Conversion Specialist for the client, Safeway Inc., Oakland CA, the third largest retails and groceries chain in Northern America, having an objective of a single integrated image of Information Systems, went through an effort of IT-re engineering in order to remain competitive. • As a Data Conversion Analyst, my role was to design technical conversion strategy, develop COBOL programs using Extract as a CASE tool, create high-level unit test plans, execute tests and create conversion related documentation for conversion strategies. • The conversion comprised of translation of data from heterogeneous environments into a DB2 database.

MIS Track Manager for the ONGARD (Oil & Natural Gas Administration and Revenue Database) information system developed for the client State of New Mexico. The objective of MIS development group was to provide the State with a system that would go beyond the realm of reporting data and events to a system that provides Decision Support. The system was developed in IBMs 4GL tool Application System Version 3 Release 1 that worked under MVS operating system on IBM ES 9000 mainframe system.• Key responsibilitieso Managed development of 130 MIS processes designed and developed by the MIS AS development groupo Worked as AS Administrator for the State of New Mexicoo That included user profile management, access control, and setup maintenanceo Performing tasks to maintain AS software environmento Extensively used AS software procedures, DB2 queries, report layout-designing products and screen interaction tools for development of the systemo Designed and Standardized AS procedures, navigational menus, and look-up and on line help facility and documentation packet templates and standards.o Database Administrator for the ONGARD (Oil & Natural Gas Administration and Revenue Database) system developed for the client State of New Mexicoo Worked for designing the Logical data model for the project using Bachman as a CASE toolo Involved with data integrity issues, entity normalization, repository management of elements and record structures, executing change control procedureo Used Bachman tool to create physical data model on a regular basis to support the phased implementation of the system and the DB2 tables underlying each releaseo Worked with the DBA to support physical implementation of the DB2 tableso As an expert with Excelerator case tool, worked to keep the data repository organized by creating timely reports showing status of the data definitions and responsible for maintaining the overall integrity between the components of the Excelerator repository.

• As a Senior Software Engineer underwent some in-house training for various software platforms at Patni Computer Systems, Bombay, India. • Assigned to General Electric Plastics division, Selkirk, New York for development of Maintenance Management System. • This involved analysis of existing IDMS system and development of new system on IBM 3090 mainframe using CICS, DB2 and COBOL. • Used Application Development Workbench (ADW) and Information Engineering Workbench (IEW) as the CASE tools to analyze, design and construct code. • Used MFCICS, MFCOBOL and XDB to simulate the mainframe environment for testing and integration of the system.

Sandvik Asia Limited - Pune India July 1988 - July 1991 Analyst Programmer • Analyst Programmer in the Data Processing Department of the company at Poona, India. • During this period assigned for designing, developing and implementing the Order Processing System using Foxpro. • As an in-house analyst programmer worked for various data processing systems within the company. • Developed Imprest fund accounting system and helped office automation processes for the sales offices of the company. • Developed COBOL programs for IBM S/34 / 36 systems in order to assist overall data processing needs of the company.