VENKAT RAM REDDY PAREDDY

Email:adiydv@r.postjobfree.com Mobile#+1-925-***-****

PROFESSIONAL SUMMARY

15+ years of IT experience in the Architecting and Administration of the ETL/Data Quality/MDM platform services on-premises and Azure/AWS Cloud

Strong Management Experience in managing the data management teams

Expertise in working with business teams closely and provided advisory services for business strategic goals into actionable items

Engaged business and technology teams, determine use cases and strategies, design the data management program approach and roadmap, design programs, and advise on best practices for driving cultural change and adoption through data

Domain expertise across all areas of the data management lifecycle and capabilities, including master data, cloud, data quality, data privacy, and data integration

Participated in the development of new Advisory service offerings, including concept, positioning, collateral, enablement, and rollout

Experience in advising and designing high through put low latency systems that moved millions of rows in Near Real Time fashion

Proven ability to effectively work as a business-oriented consultant with all levels of and organization—from C-level to individual contributors

Passionate about data strategy and governance, and enjoy working with customers to solve business challenges

Provided Technical trainings to junior teams

Strong platform Administration experience in Informatica MDM, Power Center, Intelligent Informatica Cloud Services, Informatica Data Quality(IDQ),Informatica Address Doctor,

TDM, Identity Population, ActiveVOS, Denodo, Abinitio, Oracle SQL/PLSQL, Python and Shell Scripting

EDUCATIONAL BACKGROUND

Master of Business Administration – Osmania University, HYDERABAD, INDIA

CURRENT EMPLOYMENT

Apptad Inc Oct’19 - Present

TECHNICAL PROFICIENCIES

Programming Languages/ Scripting

Database/File Systems

ETL/BI

Operating Systems

Scheduling Tools

Configuration Management & Other Tools

SQL, PL/SQL, UNIX Shell scripting, Python and Perl Scripting,

Informatica Grid, Abinitio Multi-File System, Oracle9i/10g/11g/12c, DB2,MongoDB,

Teradata, SQL Server, and Erwin Data Modeling

Informatica Power Center, Intelligent Informatica Cloud Services, Informatica Data Quality, Test Data Management, Informatica MDM, Informatica DT, Informatica Data Services, Informatica Address Doctor, Informatica Data Director (IDD),ActiveVOS,E360, Denodo, Abinitio (Enterprise Meta Environment, Co>operating System & Continuous), Oracle Golden Gate, Actuate, SAP HANA

Windows, SOLARIS, and Linux,

UC4, Appworx, Control-M, Crontab and Informatica Scheduler

Clear Case, Clear Quest, GIT, PSERV, SVN, ABD and HP Service Center

Ansible AppDynamics, Azure-DevOps, TIBCO, Microsoft Dynamics

CORE COMPETENCIES:

Data collection, analysis and management

Problem assessment and analysis

Organizational and planning skills

Oral and written communication skills

Attention to detail

Critical thinking

Decision-making

Delegation and Teamwork

Negotiation

Conflict management

Adaptability

Stress tolerance

EMPLOYMENT SUMMARY:

Working as “Sr. Principal Architect ” for Apptad Inc from Oct 2019 to Till the date

Worked as “Architect” for Mphasis from Feb 2017 to Oct 2019

Worked as “Sr. Technology Manager” for MResult Services, from Feb 2014 to Feb 2017

Worked as “Sr. Solutions Architect” for Ubique Systems, from May 2013 to Feb 2014

Worked as “MTS1” for PayPal, an eBay co Inc, from Nov 2010 to Nov 2012

Worked as “Project Manager” for DXC Technologies (formerly CSC), from Dec 2006 to Oct 2010

Worked as “Systems Analyst” for LIONBRIDGE Technologies, from June2005 to Dec 2006

PROFESSIONAL EXPERIENCE

Sr. Principal MDM Platform Architect

ECOLAB, USA Oct’19- Till the date

Project#1: Ecolab Platform Architectural and Engineering Services

Key Responsibilities:

Platform & Infrastructure Engineering Services

High level environment setup and administration on both on-premise and cloud platforms for ETL/BI applications such as Informatica MDM, ActiveVOS, IDD,E360, IDQ, Power Center Application software installations, configurations and version upgrade

Application software patch and EBF installations and configurations

Capacity and resource planning for systems for day to day and upcoming projects as well

Resolving problem management escalations

Providing RCA details for production incidents and acting as an SME for the whole environment

Helping in streamline the current processes and performance tuning

Managing CAB (Change Advisory Board) meetings and analyzing and approving all the Change tickets

Effort estimation, defining standards, and implementation of the industry best practices

Assist development teams to maintain all data sources and data storage options

Coordinate with application teams and help in develop all MDM,E360, Data Quality, ETL/BI, Informatica data Director and ActiveVOS processes

Administer all requests and analyze issues and provide efficient resolution

Responsible to manage Development, TEST/QA and Production environments and manage respective CMDB (Configuration Database Management) updates

Outages Handling, for Password Changes, Patch installation (Hot Fixes /Software's), Bouncing Activities or Restarting the Services, Network Changes and for any global/local outages as per change management updates

Infrastructure management and platform monitoring proactively

Preparing Standard Operating Procedures(SOPs) and best practices to application teams and production support teams

Trouble shooting day to day basis issues in all PROD and NON-PROD environments

Co-coordinating and following up with application vendor for all critical requests

Business communication with all stakeholders

Architectural Association

Establishing the process, methodology standards at all phases of an Enterprise Data warehouse.

Systems Analysis, Fit-Gap Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment MDM,IDQ,ETL tools & Reports, conducting testing and validations, conducting user training, and documentation

Analytical, technical and business skills in architecting and designing using MDM/ETL/BI applications.

Technical leadership, mentoring and managing senior designers, developers and development teams

Work with product manager to ensure the architecture design meets the product requirements

Work with a team of architects and engineers to develop proof-of-concept components

Enforcing project processes and policies

Acting as a technical mentor for developers and assisting developers with design work, analysis and requirements gathering

Participate in peer code review to make sure that coding standards follow

Responsible for key architecture decisions

Develop test specifications and Implement Informatica MDM and Data Quality standards, guidelines and best practices

Master Data profiling & data quality rules development using Informatica Data Quality tools

Performing data analyst role for data profiling, data mapping, data validation, data manipulation, data analysis, use case, test cases etc.

Environment:

Informatica MDM 10.2 HF2,IDQ/PowerCenter 10.1.0, DB2 11.1, UNIX, Python, AppDynamics, Azure DevOPS, Windows, Microsoft Azure cloud platform, TIBCO, SFDC, Microsoft Dynamics,Salesforce, SAP HANA

Architect

First Republic Bank, USA Feb’17- Oct’19

Project#2: First Republic Bank Informatica Platform Architectural and Engineering Services

Key Responsibilities:

Platform & Infrastructure Engineering Services

High level environment setup and administration on both on-premise and cloud platforms for ETL/BI applications such as Informatica MDM, Informatica Power Center, Data Quality,TDM, DVO, Cloud Services,Denodo Application software installations, configurations, and version upgrade

Application software patch and EBF installations and configurations

Capacity and resource planning for systems for day to day and upcoming projects as well

Resolving problem management escalations

Providing RCA details for production incidents and acting as an SME for the whole environment

Helping in streamline the current processes and performance tuning

Managing CAB (Change Advisory Board) meetings and analyzing and approving all the Change tickets

Effort estimation, defining standards, and implementation of the industry best practices

Assist development teams to maintain all data sources and data storage options

Coordinate with application teams and help in develop all MDM,ETL/BI, Denodo Data Virtualization processes

Provide an efficient interface with brand for all processes across various platforms

Administer all requests and analyze issues and provide efficient resolution

Responsible to manage Development, TEST/QA and Production environments and manage respective CMDB (Configuration Database Management) updates

Outages Handling, for Password Changes, Patch installation (Hot Fixes /Software's), Bouncing Activities or Restarting the Services, Network Changes and for any global/local outages as per change management updates

Infrastructure management and platform monitoring proactively

Helping in Database sizing

Preparing Standard Operating Procedures(SOPs) and best practices to application teams and production support teams

Trouble shooting day to day basis issues in all PROD and NON-PROD environments

Co-coordinating and following up with application vendor for all critical requests

Business communication with all stakeholders

Architectural Association

Establishing the process, methodology standards at all phases of an Enterprise Data warehouse.

Systems Analysis, Fit-Gap Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & MDM, conducting testing and validations, conducting user training, and documentation

Analytical, technical and business skills in architecting and designing using MDM, ETL/BI applications.

Technical leadership, mentoring and managing senior designers, developers and development teams

Work with product manager to ensure the architecture design meets the product requirements

Work with a team of architects and engineers to develop proof-of-concept components

Enforcing project processes and policies

Acting as a technical mentor for developers and assisting developers with design work, analysis and requirements gathering

Participate in peer code review to make sure that coding standards follow

Responsible for key architecture decisions

Develop test specifications and Implement Informatica Data Quality standards, guidelines and best practices

Data profiling & data quality rules development using Informatica Data Quality tools

Performing data analyst role for data profiling, data mapping, data validation, data manipulation, data analysis, use case, test cases etc.

Environment:

Informatica MDM 10.1, Informatica Power Center 10.1.1,IICS, IDQ, TDM, Oracle 11g/12c, Denodo7.0,MongoDB, SQL Server 2012/2016, AWS, UNIX, Python, Windows and Ansible

Sr. Technology Manager

Pfizer Inc, Bengaluru, India Feb’14- Feb’17

Project#3: Pfizer Global Business Intelligence CoE-Engineering

Key Responsibilities:

Platform & Infrastructure Engineering Services

High level environment setup and administration on AWS Cloud and On-premise both UNIX and Windows platforms for MDM, and ETL/BI applications such as Informatica MDM, Informatica Power Center, ICS,IDQ, IDS, Address Doctor

Application software installations, configurations and version upgrade

Application software patch and EBF installations and configurations

Capacity and resource planning for systems for day to day and upcoming projects as well

Resolving problem management escalations

Providing RCA details for production incidents and acting as an SME for the whole environment

Helping in streamline the current processes and performance tuning

Managing CAB (Change Advisory Board) meetings and analyzing and approving all the Change tickets

Effort estimation, defining standards, and implementation of the industry best practices

Assist development teams to maintain all data sources and data storage options

Coordinate with application teams and help in develop all MDM and ETL/BI processes

Provide an efficient interface with brand for all processes across various platforms

Administer all requests and analyze issues and provide efficient resolution

Responsible to manage Development, TEST/QA and Production environments and manage respective CMDB (Configuration Database Management) updates

Outages Handling, for Password Changes, Patch installation (Hot Fixes /Software's), Bouncing Activities or Restarting the Services, Network Changes and for any global/local outages as per change management updates

Infrastructure management and platform monitoring proactively

Helping in Database sizing

Preparing Standard Operating Procedures(SOPs) and best practices to application teams and production support teams

Trouble shooting day to day basis issues in all PROD and NON-PROD environments

Co-coordinating and following up with application vendor for all critical requests

Business communication with APAC, AMER and EMEA region stake holders

Architectural Association

Establishing the process, methodology standards at all phases of an Enterprise Data warehouse.

Systems Analysis, Fit-Gap Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & MDM, conducting testing and validations, conducting user training, and documentation

Analytical, technical and business skills in architecting and designing using ETL/BI applications.

Technical leadership, mentoring and managing senior designers, developers and development teams

Work with product manager to ensure the architecture design meets the product requirements

Work with a team of architects and engineers to develop proof-of-concept components

Enforcing project processes and policies

Acting as a technical mentor for developers and assisting developers with design work, analysis and requirements gathering

Participate in peer code review to make sure that coding standards follow

Responsible for key architecture decisions

Develop test specifications and Implement Informatica Data Quality standards, guidelines and best practices

Data profiling & data quality rules development using Informatica Data Quality tools

Performing data analyst role for data profiling, data mapping, data validation, data manipulation, data analysis, use case, test cases etc.

Team Management

SOW preparation

Liaison on HR, Payroll related issues along with Team appraisals and Performance Management

Ensure staff and sub-contractors timesheets were accurately completed by both onsite and off-shore teams for Fixed bid and Time & Material projects

Team status reports to the stakeholders

Environment:

AWS Cloud, Amazon RDS, Amazon EFS, Informatica MDM 9.6.1, Informatica Power Center 9.6.1/9.5.1/9.1.0, ICS, IDQ, IDS, Informatica PowerExchange Interfaces, Address Doctor, DB2 10.1 Teradata 13.10, Oracle 11g, SQL Server 2008/2012, Salesforce, Tableau, SAP Business Objects, UNIX, Windows, UC4 and HP service center

Sr. Solutions Architect

Maersk Inc, Trivandrum, India May’13-Feb’14

Project#4: Maersk EDW Solutions & Business Technology

Key Responsibilities:

Configured and Administered the Informatica PowerCenter 9.5.1HF3, Informatica MDM Hub Web services engagements including Business Data Director(BDD) / Informatica Data Director (IDD)

Provided the Technical Solutions to define and setup the new environments as required

Managed IMS (Infrastructure Management Services)

Planning of project schedule and technical discussions

SME Architecture review of Informatica legacy systems to evaluate space requirements, account requirements and identification of non-standard configuration items.

Impact analysis of ETL/BI environments to confirm capacity and resource growth capability.

LDAP configuration for ETL/BI applications

Lead ETL Dev team, requirements gathering, code development

Resolved any problems and issues that arose technically

Escalated issues and areas of concerns to senior management and stake holders concerned

Managed customer SLAs tracking and root cause analysis by providing the status reports

Responsible for Informatica Admin roles, which include users’ account management, assigning roles, creating groups, taking repository backup and software/patch upgrade to latest versions

Configured new Informatica Power Exchange plug-ins like IBM Web Sphere Message Queues, SalesForce, and Teradata Parallel Transporter etc.

Managed Incident Management for the Maersk direct customers for managing the Single Version Truth of data against SMDS (Single Master Data Store)

Integrated external business application with Siperian MDM hub using SIF and message queues

Resolved the code deployment issues for ABD and SVN code migration processes

Worked on jobs auto restart capability for production jobs

Worked on Remedy assigned incidents tickets

Prepared Project Metrics and status reports

Environment:

Informatica Power Center 9.5.1/9.1.0, Informatica MDM 9.5, IDD, Teradata 13.10, Oracle 11g, Salesforce, UNIX, UC4, SVN and ABD

Staff Software Engineer (MTS1)

eBay/PayPal Inc, Chennai, India Dec’06-Nov’12

Project#5: eBay/PayPal ETL Operations & Production Support

Key Responsibilities:

Lead the project team up to 13+ resources and provided project support for all off-site activities

Lead ETL and BI Production Support teams and resolved all the production issues, worked on L2 and L3 on-call 24/7 support

End-To-End support of all PayPal ETL Applications. Resolved any problems and issues that arose technically in the most Complex environment in ETL commercial world which contains Informatica, Abinitio, Golden Gate, and Appworx Interfaces

Managed and Administered the world’s biggest Informatica Grid with 24 ETL nodes for ~40k daily ETL batch jobs and DR systems

Managed and Administered the 12 Abinitio ETL nodes and DR systems

Managed and Administered the SANDBOX environment on Informatica and Abinitio platforms

Managed and Administered the Informatica32 bit for data encryption, and Supporting Informatica DT related issues

Maintenance/Enhancement of the world’s biggest Informatica Grid computing environment

Manage customer SLAs tracking and root cause analysis by providing the status reports

Performance tuning

Responsible and accountable for deliveries from offshore for the assigned projects

Involved in ETL code development, maintenance and enhancements by using Informatica and Abinitio ETL interfaces

Monitored Actuate reporting jobs

Lead Data Management Services which gives guidelines for the Application teams to understand better the datasets, minimize duplicate data maintenance and reduce the total cost of ownership (TCO) of applications and provides single version of truth

Developed project plans that identify key issues, approaches and performance metrics

Assembled and coordinate multi-disciplinary project teams and monitor quality assurance measures

Implemented and managed project changes and interventions

Developed and presented reports on project progress and manage project changes and interventions

Onsite & offshore liaisons and Escalated issues and areas of concerns to senior management

Team appraisals and Performance Management

Liaison on HR, Payroll related issues along with Team appraisals and Performance Management

Ensured staff and sub-contractors timesheets were accurately completed

Participate in hiring the right talent

Set right customer expectations and worked with several vendors (RedHat, NetApp, Informatica and Abinitio) on resolving all the infrastructure related issues.

Environment:

Informatica Power Center 9.5.1/9.1.0/8.6/7.1.3, Informatica 32 bit, Abinitio, Oracle 11g, Teradata 13.10, Golden Gate, Actuate, UNIX, UC4, GIT and Clear Case

System Analyst

Merck Inc, Chennai, India June’05-Dec’06

Project#6: Customer Master Migration (CMM)-ETL development

Key Responsibilities:

Requirements gathering and analysis of requirements

Technical and architecture design for ETL applications

Created Technical Design documents

Developed Informatica Mappings Mapplets, Sessions, Tasks, Worklets and Workflow

UNIX shell scripting

ETL code testing and code deployment

ETL Code enhancements

Project Metrics preparation

Environment:

Informatica Power Center 7.1.3, DB2, Oracle9i, UNIX, Clear Quest and Clear Case

PERSONAL INFORMATION

Education Details

Qualification : MBA

Institution : Vivekananda School of Post Graduate Studies

University : Osmania University, Hyderabad, India

Year of Passed : 1998

Experience Details in months : Total 188

Primary Skill Sets : Project Manager, Informatica on premise and Cloud Platform Engineering and Architectural Services

Secondary Skill Sets : Informatica & Denodo Administration, L3/L4 support

Passport Details

Name as in Passport : Venkat Ram Reddy Pareddy

Passport No : Z4385987

Date of Issue : 12/28/2017

Date of Expiry : 12/27/2027

Place of Issue : Hyderabad, India

Visa Details : H1-B

Contact Details

Email : adiydv@r.postjobfree.com

Contact Number : +1-925-***-****

Gender : Male

Contact this candidate