Sr. Integration Consultant Resume

SUMMARY

Dynamic & techno - savvy IT / BI Professional with 17 years of well-honed experience in analyzing Business Requirements, Software Development in Telecom, OIL & Gas, Energy and Retail domains and System Integration.
Provided Application Development, Administration support and maintenance to Various BI Applications
Strong knowledge of Informatica Power Center, Informatica cloud, Apache Spark (Big Data Map reduce processing) and thorough understanding of Hadoop framework.
Thorough understanding of AWS Infrastructure ( EC2, IAM, VPC, S3,CloudWatch,SNS,EMR,Glue,Athena, AWS Lambda, AWS Parameter Store)
Acknowledged trouble shooter with excellent comprehension of business processes culminating in definition and documentation of business requirements, process definition and follow-up of solution realization, and identification of development opportunities
Strong collaboration and team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
Ability to manage multiple complex projects under tight deadlines; successfully coordinate among Team Members and Developers to accomplish the project within scheduled time.
Have expert level experience in Linux OS worked on various Linux distributions - RedHat, Fedora, Ubuntu and CentOS.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Integration Consultant

Responsibilities:

As a Data Lake Architect, set up an RBA data lake, co-designed. Implemented the complete architecture including the AWS security/Access architecture. Data ingestion techniques are used to bring in data from various source systems MS SQL, Flat files, CSV’s, Weblogs, etc. into AWS S3
Once data arrived in S3, Various Crawlers are written using AWS Glue which creates the schemas for the data.
Lambda functions have been written in Java, Python using AWS Lambda service which gets executed based on certain business rules defined in AWS cloud watch.
An appropriate Notification system is developed and configured which notifies the business users and stakeholders in case Schema changes, crawler failed etc.
Various users have been created in the system whose access has been configured using IAM roles, policies, fine grained access has been provided using AWS inline policies where appropriate.
Amazon Athena is used to provide access to the business users (Data Analysts/Data Scientists) to query the data stored in data lake.

Confidential

Environment: Specialist

Responsibilities:

As an Environment Specialist in Confidential Communications my role is to establish a consistent, reliable and continuous running of Informatica BI Apps.
Developed an integration PFP (Pay for Performance) using Informatica Power Center. Created mappings and Workflows which translates the business logic and load the data into the EDW . Data from EDW is used for the commission payouts to the Confidential Agents.
Successfully upgraded the Informatica 9.51 to Informatica 10.1, also upgraded the DVO from 9.6 to DVO 10
Designed and developed a monitoring solution to monitor 24*7 Confidential ’s Informatica Infrastructure and Integrations using PMPC3.0 HF1 (Proactive Monitoring for Power Center) in Pre-Prod and Production environments. In Pre-Prod also implemented the Governance piece where Developers are enabled and forced to follow the Informatica’s development best practices.

Confidential

Sr. ETL Developer

Responsibilities:

Designed and Developed a solution(CWS UltriPro To I&R) in Informatica cloud to extract the data from Calfrac’s UltiPro HR Application transforming it and then loading the same to the I&R site using REST API’s. The integration contains a mapping in which various Informatica cloud transformations are used to implement the business logic before loading the data into the third party’s REST API’s
Designed and developed a solution (CWS UltiPro to CWS AD) in Informatica cloud. Confidential Services Ltd. is an oilfield services corporation, where different parameters have been set for the employee records in the HR database. This solution extracts the employee records from the UltiPro HR application and loads the employee data into the Calfrac’s Active Directory. The integration uses various Informatica’s transformations to process and implements the business logic before loading the data into the Active Directory.