PROFESSIONAL SUMMARY:

• 15 years of IT experience in the Design, Development, Implementation, Testing of End - to-End ETL/BI Architectural, On premise and Azure/AWS Cloud Platform Engineering, Administration, Development, Operations and 24x7 production support for mission critical OLAP Data Warehousing and OLTP Systems
• Strong platform Administration experience in Informatica MDM 10.2, Power Center 10.2, Intelligent Informatica Cloud Services, Informatica PowerExchange CDC for DB2/SQL Server interfaces, Informatica Data Quality(IDQ), Informatica Data Services-Data Virtualization, Informatica Address Doctor, Test Data management, Identity Population, Informatica Data Director(IDD),ActiveVOS,E360, Denodo, Abinitio, Oracle SQL/PL SQL, Python and Shell Scripting
• Implemented the largest ETL Informatica Grid first ever with 24 active nodes, 12 Abinitio nodes and processing nearly 15TB of daily data, Informatica High Availability, Load Balancing and load into several application databases Oracle, SQL Server, DB2 and Teradata warehouse.
• Experience in Disaster Recovery(DR) implementations
• Experience in designing high through put low latency systems that moved millions of rows in Near Real Time fashion
• Strong experience in MDM, Data Quality, ETL infrastructure projects & Platform Engineering Services, Informatica Administration, Denodo Administration, Abinitio Administration and Operations
• Expertise in Applications’ security setup, SSL, Kerberos, LDAP, Single Sign-on authentication implementations
• Extensively implemented and configured Power Exchange for SQL Server, Power Exchange for Salesforce, Power Exchange for MongoDB, Power Exchange for IBM Web Sphere Message Queue, Power Exchange for Teradata TPT, Power Exchange for WebServices, Informatica DT, Informatica 32-bit plug-ins in Informatica commercial world
• Strong experience in 24x7 production support
• Knowledge of various job scheduling tools such as UC4/Control-M-Appworx. and UNIX crontab utility
• Experience with various data platforms such as Oracle, DB2, MongoDB, SQL Server, Teradata, Flat files, Golden Gate trail files, Salesforce and IBM Webspehere Message Queues
• Extensive experience in using tools like SQL Plus, TOAD, Teradata SQL assistant
• Experience in Performance Tuning, Trouble shooting, Datacenter migration related projects
• Lead on upgrading Informatica and Denodo stacks with minimal downtime
• Expertise in ETL infrastructure capacity analysis and resource plan for expansion
• Expertise in Informatica, Denodo and Abinitio software installations, creating grids environment on Linux and Solaris Unix hosts, Clusters configuring, scheduling the jobs
• Defining and deploying data quality programs and tools on enterprise data quality projects
• Expertise in moving the ETL Infrastructure across data centers
• In-depth knowledge on support, analyze, diagnose, replicate, troubleshoot and resolve the infrastructure related issues and Established key alliances, worked with software providers like Red Hat, Solaris, NetApp, Informatica, Denodo & Abinitio
• Experience in lead and manage onsite and offshore teams and processes from project proposal through deployment
• Expertise in providing Technical trainings to junior teams

TECHNICAL PROFICIENCIES:

SQL, PL/SQL, UNIX Shell scripting, Python and Perl ScriptingInformatica 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 LinuxUC4, 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

PROFESSIONAL E XPERIENCE

Sr. MDM Administrator

Confidential

Responsibilities:

• 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
• 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
• 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
• 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

Confidential

Responsibilities:

• 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
• 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

Confidential

Responsibilities:

• 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
• 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.
• 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
• Implemented PowerExchange (CDC) for DB2 and SQL server
• Implemented an automation processes for ICS secure agent auto alert and auto restart processes
• Implemented the data virtualization services
• Incorporated the sales force data with corporate relational data bases and vice versa
• Implemented the Address validation check for all key customers across the globe
• Implemented eHealth portal reports for all ETL/BI servers for day to day system performance monitoring process
• Established key alliances with software providers and vendors
• Established/Mentored/assimilated an offshore team of 10+ at Bengaluru in a span of 12 months and turned it into one of the best teams to work for Confidential

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

Confidential

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 Confidential 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
• Successfully implemented many automation processes for monitoring the ETL systems and file systems manually across the whole organization
• Implemented the Informatica MDM Hub Web Services for Single Master Data Store implementation
• Successfully implemented the Informatica plug-ins such as IBM Web Sphere Message Queues, SalesForce, Teradata Parallel Transporter

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

Confidential

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 Confidential 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.
• Successfully implemented an automation processes for producing the on-time report to save ~$1 million every month
• Informatica High Availability and load balancing
• Lead on Informatica upgrades to 8.6 to 9.1 and 9.5.1 Upgrades to Dev/QA/Prod: Successfully upgraded 6-node Dev, 8-node QA Informatica grids.
• Planned and executed a smooth Production GRID(24-node) upgrade with minimal downtime(30min).
• Phoenix ETL Data Center migration: This was major initiative in Confidential 2007. Worked as lead to this project, planned & executed the project on migrating 5K daily ETL jobs without any issues.
• SLC ETL Data Center migration: This was another major initiative in 2012. Worked as lead to this project, planned & executed the project on migrating 22K daily ETL jobs with planned downtime and not impacting to any customers. This involves complete migration of ETL servers, Informatica Grids, NAS, SAN and Databases.
• Created many automated scripts to send alerts and purge scripts, Automated INFA repository backup processes
• Lead on designing the near real time transactional data process for EDW solutions
• Set up the world largest Informatica GRID computing environment with 24 nodes for managing 40k daily ETL jobs
• Implemented Disaster Recovery (DR) systems with 36 nodes for ETL environment for both Informatica and Abinitio interfaces
• Created a middle tier distributed file system with Informatica and Abinitio Interfaces which handle 50 Million transactions and growth of 15 TB per day to serve the business for their prompt decisions
• Established key alliances with software providers and vendors

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

Confidential

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