SUMMARY

• 15+ years IT experience specializing in Design, Development, Testing and Application Support and maintenance of various systems.
• Experience in all phases of SDLC and ETL, Agile methodologies.
• Strong Data Analysis, Requirement gathering skill.
• Experienced in executing Jobs on Bigdata Environment on AWS Stack
• Have knowledge in creating event processing data pipelines using Apache Kafka and Kafka producer Application to produce near real time data using Apache Kafka
• Have knowledge on Spark (Streaming, Spark SQL), RDD, Dataframe and Datasets.
• Strong Presales Solution Architecting experience.
• Strong ETL skill on Load Planning, Monitoring, Auditing and Error handling.
• Strong Analysis, Design, Build, Test, Deployment experience in Informatica, Ab Initio, Hadoop with various databases like Oracle, Teradata, SQL Server, My SQL, Redshift, PostgreSQL
• Hands on knowledge on UNIX operating systems
• Very good understanding of Project standards and Procedure.
• Strong coordination Skills (onshore & offshore)
• Adhered to 24/7 support to ETL Applications.
• Managed application development and maintenance activities which include establishing project standards and procedures, Planning and managing the work for the team members.
• Very good Exposure to Issue management, highlighting critical issues and getting it resolved within required time limit.
• Very good exposure to monitor service levels for area of responsibility and take proactive actions to address issues.
• Participated in continuous improvement efforts related to issues management or project processes.
• Managed delivery transition from client to team and vice versa.

TECHNICAL SKILLS

Databases: Oracle, Teradata, SQL Server, DB2, Sybase, MYSQL, Redshift, PostgreSQL

ETL Tools: Informatica BDM, Informatica PowerCenter, Ab Initio, SSIS

Languages: COBOL, SQL, JCL, Shell Scripting

Operating System: MVS, Windows, Unix

Reporting Tools: Business Object, SSRS, Tableau, Qlikview

Big Data Management: Informatica BDM, HADOOP - HIVE, Amazon EMR, Amazon S3, SPARK

Informatica Products: BDM, PowerCenter, EDC, Analyst, Metadata Management, IDQ, Cloud

Tools and Utilities: File Zilla, Toad, SQL Assistant, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Informatica Consultant, Technical Lead

Responsibilities:

• Administration and Development of Informatica BDM and PowerCenter Application.
• Identifying tools and technology
• Requirement Gathering
• Creating Stories, backlog, estimating work effort
• Designing application as per the business
• Developing and Testing ETL Applications as per the system Requirement
• SME application review
• Incorporating feedback on process, tools as received from client

Environment: Informatica BDM, Informatica PowerCenter. Amazon S3, Teradata, Amazon Redshift, Oracle, SQL Server, DB2, Sybase

Confidential, Greensboro, NC

Informatica BDM and PC Consultant

Responsibilities:

• Allows an incremental approach to Distribution and Marketing (Pipeline Data Management) IT applications whereby after a "rough" layout of the warehouse has been defined.
• A subject by subject area build is initiated prioritized by business benefit and feasibility.
• This design replaced the existing "Legacy" architecture of flat aggregate level summary tables and operational reports that would run directly against the OLTP schema.
• The new design assures that all data is derived from the same definitions in a consistent manner. Additional near instantaneous performance is assured by the dimensional schema.
• It is combination of on-premise and cloud applications to enhance the performance of Distribution and Marketing(Pipeline Data Management) IT applications.
• To acts as brand ambassador between the business and the various projects teams involving Application Support Team, Network, Database, Security Teams
• Develop and build infrastructure onboarding requirement on On-Prem and cloud platform
• Analyzing the Requirement
• Involved in Identifying Backlog, creating Story and Sprint planning, Developing Work Plan, Work Effort estimates.
• Designing application as per the business
• Developing ETL Application as per the system Requirement
• Testing the Application.
• Automating ETL environment as much as possible

Environment: Informatica BDM 10.1.1 HF1/10.2.1, Amazon S3, PostgreSQL, Salesforce, Springboot, MuleSoft API Gateway

Confidential, Greensboro, NC

Informatica BDM Consultant

Responsibilities:

• To provide a single platform for self-service analysis and reporting.
• The platform must support a wide range of advanced data visualizations that are easy to use, while remaining very interactive for data exploration.
• Empower users to respond to ad-hoc reporting requests and share the results, without complex processes or significant formal training.
• Maintain a highly scalable solution to support evolving business needs.
• To acts as brand ambassador between the business and the various projects teams involving Application Support Team, Network, Database Teams
• Installation and configuration of Informatica BDM and other related products
• Managing the DEV/QA/UAT/PRE-PROD/PROD environments
• Setting up access roles and privileges, appropriate ETL migration activities and scheduling jobs using AutoSys
• Automating Server Alerts, backup and notifications
• On Call Support as required during the week ends and off hours
• Developing Prototypes to be used in Environment, developing mapping and workflows and setting up environments.
• Developing Jobs to be executed on Blaze, Spark and Hive on EMR
• Root Cause analysis for ETL job failures/Data issues raised by business

Environment: Informatica BDM 10.1.1 HF1/10.2.1, Amazon S3, Amazon RDS Oracle, Informatica, Blaze, Spark, AWS EMR, Amazon Redshift, Amazon EC2, EDC

Confidential

Technical Architect

Responsibilities:

• Interact with business team to understand the current business processes
• Understand the System Requirements
• Analyzing the Requirements
• Create Models as per requirement
• Data Preparation as per the System
• Creating Data models
• Creating Views and Queries for Reporting Developers
• Colleting report matrix and analyzing the data

Environment: Tableau, Excel, SQL Server