SUMMARY

• He is a Senior IT Solution Architect responsible for leading Data Ingestion, Integration, Transformation, Governance, Virtualization & Business Intelligence initiatives.
• He has over 20+ years of experience in delivering information systems to top - tier Insurance, Financial, Product & IT consulting firms.
• He has implemented over 35+ IT projects, releases, prototypes and production support structures using emerging technologies.
• This includes 20+ Data warehouse, Business Intelligence, executive reporting, data governance and analytics projects.
• Extensive experience in architecting, delivering and operationalizing enterprise data warehouse, Data Lake and reporting solutions.

TECHNICAL SKILLS

• Informatica Power Center 10.2/10.1/9.6.1/9.5.1/9.0.1 /8.5/8.1
• Informatica Intelligent Cloud Services platform
• Informatica Metadata Manager 10.2/10.1/9.6.1/9.5.1/9.0.1
• Informatica Data Quality 10.2/10.1/9.6.1/9.5.1/9.0.1
• Data Validation Option 10.2/10.1/9.5.1/9.0.1
• Informatica Support Console, Proactive Monitoring 3.0. Operational Insights
• Denodo Platform 7.0
• Oracle 12c/11g/9i, SQL Server 2000/2005, Sybase.
• C, C++, VC++, VB, SQL/PLSQL, HP-Unix 11.0 shell scripts.
• Window 7/Windows 10, Linux
• Visio
• Load 7.x, Db view, SQL Developer, SQL Dbx
• Crontab, Job Trac, Autosys

PROFESSIONAL EXPERIENCE

Confidential

Senior IT Solution Architect

Responsibilities:

• Perform the role of Informatica Product owner and promote tool adoption.
• Establish Informatica shared services function across the organization.
• Support ETL customers and assist them with their cloud migration journey as needed.
• Develop a strategy and detailed implementation plan for new tenants migrating into Informatica shared platform. i.e., Multi-tool multi-platform migration, cross technology migration
• Developed an Informatica Workload management dashboard solution using Denodo & Tableau to support platform health checks, measure utilization and capacity planning.
• Phase 2 of Informatica Workload management dashboard released to support operational requirements around chargeback, licensing etc.,
• Design, Architect and developed an AI-ML based Data Discovery solution using Informatica Analyst, along with Python, Pandas and Power BI for visualization.
• Design, Architect and developed an IDQ service externalization solution to promote utilization of IDQ services to non-Informatica users across the organization.
• Review Data Integration requirements related cloud based source/targets (e.g. Snowflake, Workday, AWS S3) and assisted shared utility tenants in adopting IICS Data Integration for implementation of the same.
• Gathered requirements from various IICS tenants across the organization to consolidate and establish a shared services set-up for IICS platform.
• Evaluate new business requirements and opportunities and convert them to appropriate technical solution which can be implemented using Informatica suite of tools both on-premises & cloud.
• Periodically evaluate and provide recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• Define and Implement ETL standards and best practices.
• Responsible for developing and implementing Data quality platform with discovery and analytical capabilities.
• Manage and support a team of architects and developers working on varied technology and platforms.
• Responsible for building an ETL roadmap for the organization in line with their growing demands.
• Developed Standards and Processes for DW/BI Projects and successful implementation of the same.
• Establish TDM platform and enable QA team to adopt and manage the same.
• Develop a process to generate Informatica shared platform license reconciliation and validation process.
• Defined standards for Informatica metrics gathering and reporting.
• Responsible for troubleshooting production ETL problems, including performance, minimizing system downtime and develop strategic solution.
• Worked closely with the developers to provide guidance and plays a key role in problem resolution.
• Also made sure that the ETL design process is repeatable, documented and put under proper change control.
• Responsible for leading the design of prototypes and determining final design to ensure client satisfaction with product.
• Create Software upgrades plan and work with administrator's to implement Informatica software patching and upgrades.
• Developed and implemented first Business continuity test plan for shared utility and assisted platform tenants in implementing the same successfully.
• Conduct impact assessment with business in order and determine high level design and size of effort based on requirements.
• Drive design and determine the ETL requirements for BI projects.
• Partner with the Data architect to drive improvements and enhancements to the current data landscape and future strategy.
• Assists in the development of ETL-related Service Level Agreements.
• Communicates risks and ensures understanding of these risks.
• Playing a key role in mentoring other staff members and a proven track record in knowledge transfer to other team members and departments.

Environment: Informatica 10.2 suite, IICS, Denodo Platform 7.0, AWS, Oracle 12c, DB2, SQL Server 2017, BitBucket, JIRA, Linux 3.10 and Autosys.

Confidential

Senior ETL Solution Architect

Responsibilities:

• Involved in setting the vision, gathering requirements, gaining business consensus, performing vendor and product evaluations, mentoring business and development resources, deliver solutions, training and documentation.
• Defines and achieves the strategy roadmap for enterprise data management using Informatica tools such as Metadata Manager and Data quality (IDQ).
• Ability to translate broader business initiatives into clear team objectives and concrete individual goals, aligning appropriately with other groups for efficient, coordinated action.
• Works with staff and customers to understand the business requirements and business processes, design data warehouse (“DW”) schema and define extract-translate-load (“ETL”) and/or extract-load-translate (“ELT”) processes for DW.
• Involved in developing a technology roadmap for the organization.
• Performs a key management and thought leadership role in the areas of advanced data techniques, including data access, data integration, data visualization, data discovery, design and implementation.
• Creates discover-access-distill (“DAD”) strategies to bring significant value data understanding.
• Draws conclusions and effectively communicates findings with both technical and non-technical team members, providing active leadership skills across project team and business community.
• Design & Implement Metadata management solution using social collaboration.
• Closely work with Enterprise architecture team to obtain approval for the Infrastructure and Application architecture to implement Metadata management platform.
• Defined Metadata development & deployment standards and best practices for a Private Cloud platform.
• Developed Private Cloud based solution architecture to consolidate various version of ETL tools into a single version/platform.
• Worked closely with QA to enable the adoption of the Informatica TDM tool.
• Proposed and implementing an Informatica upgrade plan to the latest version (10.1.1).
• Work with various stakeholders to gather requirements for enhancing the current Archival solution involving Structured, Un-structured data and Emails across the organization.
• Involved in creating a Hadoop ETL data integration environment for a new business area (LOB).
• Developing a high level upgrade plan for all relational databases across the organization to ensure its current and to secure support from the vendor.
• Maintain a library of best practices in order to support knowledge sharing between various data consumer teams.
• Work closely with Hadoop administrator to improve and enhance the performance of ETL processing.
• Diligently teaming with the infrastructure, network, database, application and business intelligence teams to guarantee high data quality and availability.
• Function as integrators between business needs and technology solutions, helping to create technology solutions to meet clients’ business needs.

Environment: Informatica 10.1.1/9.6.1/9.1/8.1 , Data Quality 9.1, Metadata Manager 9.1, TDM 9.6.1, BDE 9.6.1, Podium, Media Wiki, Oracle 11g, SQL Server 2007, DB2, Teradata, BitBucket, AIX 6.1, Maestro and Autosys.

Confidential

Lead ETL Architect/Administrator

Responsibilities:

• Design ETL Architecture keeping in mind the organization’s tactical and strategic needs.
• Install, Configure and Administer Informatica suite of applications across all regions.
• Create Software upgrades plan and manage Informatica software patching and upgrades.
• Responsible for building new Data quality environment using Informatica Data quality.
• Redesign existing ETL architecture to process Real time data and achieve high scalability.
• Implement maintenance routines to high availability of servers across all regions.
• Responsible for building new data lineage environment using Metadata manager.
• Defined access groups and security standards for data lineage tool.
• Responsible for building 5 year ETL roadmap for the organization.
• Developed Standards and Processes for DW/BI Projects and successful implementation of the same.
• Involved in performing data cleansing and data auditing to ensure data quality.
• Responsible for establishing Informatica connectivity with MQ message queues to process real time data.
• Responsible for performing ETL license compliance study periodically.
• Developed and enforced best practices for ETL architecture.
• Work with the Source system analysts to understand the windows available for data extraction.
• Generated and published monthly Server performance and quarterly Health check reports.
• Worked on performing a pilot of Complex event processing tool Support Console.
• Defined standards for Informatica metrics gathering and reporting.
• Automated the Informatica code deployment process using UNIX shell scripts.
• Employed SAR scripts to obtain CPU utilization data from AIX servers.
• Ability to identify and mitigate infrastructure risks.
• Ability to develop technical specifications based on business requirements.
• Manage Informatica Users and Roles in order to enforce data security, while making sure all users have the necessary access to perform their tasks.
• Experienced in interacting with Delivery Leads & Team in communicating and socializing standards and techniques.
• Responsible for troubleshooting production ETL problems, including performance, minimizing system downtime and develop strategic solution.
• Also responsible for managing Cognos BI application.
• Performed Cognos code deployment across various regions.
• Maintain a library of best practices in order to support knowledge sharing.
• Overseeing the ongoing development and operations of an EDW architecture that enables fact-based decision making and ad hoc analysis and insight generation.
• Worked closely with the developers to provide guidance and plays a key role in problem resolution.
• Also made sure that the ETL design process is repeatable, documented and put under proper change control.
• Performed the Role of Reviewer/Approver for Code deploys & Tool access grants.
• Ability to work well with clients and technical and functional teams
• Maintaining a highly detailed plan and obsessively caring about the progress on it.
• Applying personal skill and judgment to make crucial decision in the project.

Environment: Informatica 9.5.1, Oracle 11g, SQL Server 2007, Progress 10, PVCS, AIX 6.1 and Autosys.