SUMMARY

• Over 15 years of varied Experience like System architecture, Project management, Software process definition, System analysis, Data Analysis and Business analysis experience
• Have 6 years of Life science industry and 4 Years of Automobile industry experience
• Have 5 years of Informatica cloud experience and 3 years of Microsoft Azure Integration experience
• Extensive experience in gathering User and Business Process Requirements and creating Business Requirement Documents (BRD) and Use Cases
• Expert in Application Integration Cloud (AIC) and Data Integration Cloud (DIC)
• Hands on experience in leading and implementing Client server, Cloud based ETL integration projects using Informatica IICS, Oracle, Microsoft Azure, Informatica BDM, AWS and Hadoop environment
• Strong knowledge in SQL, PL/SQL procedures, functions and packages
• Experience includes Microsoft Azure, dynamics, CRM365, Portal, Informatica Intelligent Cloud services (IICS), and Informatica Cloud Real Time(ICRT), Informatica Developer (BDM), Informatica Data Quality(IDQ), Data Integration Hub (DIH) and Informatica Power center
• Have a good experience in AWS environment instances like EC2, S3, RDS and Redshift
• Have a hands - on experience on Big Data Platform with Cloudera Hadoop, HDFS, and Hive DB
• Having good knowledge on web services like SOAP and REST based API’s
• Have a solid knowledge with core XML Technologies XML, XML Schema, XPath and Xquery
• Proven skills in all phases of Software Development/SDLC using SCRUM, Agile, Waterfall and Iterative methodologies
• Executed application development initiatives with global teams that had business users from Germany, China and Development team based out of India.
• Expertise in the ETL process with managing the implementation of the development in various environments.
• Proactively identify and resolve problems using data analysis skills.
• Gathered Requirements from Cross functional Teams, Designed and Developed an ETL-Informatica templates for different integration patterns
• Instrumental in defining Application Development Process Improvement with focus on Coding Standards and Delivery Process
• Lead the project which has over 50 applications encompassing various Microsoft Azure/ Informatica Intelligent Cloud Services, Oracle, SQL Server, DB2, and Webservices
• Performed Lead role for IICS integration tool upgrade, which involved coordinating functional users, business groups and technical team for Technology Improvement, Business Process Change and User Acceptance Testing.
• Lead the team for Integrating Informatica Intelligent Cloud services to Microsoft Azure application

TECHNICAL SKILLS

Operating System: Windows and LINUX

Programming Languages: C#, SQL, PL/SQL, KSH & JAVA

Databases: Oracle 8i/9i/10g/11g/12c, SQL Server, Teradata, Hive and Redshift

GUI: Microsoft Azure, Dynamics D365, USD, Portal, Informatica intelligent cloud services (IICS), Informatica 10.1, Informatica Application Integration & Data Integration, Data Integration Hub (DIH), Informatica Data Quality (IDQ), Informatica BDM, Visual Studio, Tableau9.3, Cloudera CDH 5.9.2, and AWS services

Tools: Used: Rally, Autosys, SVN, VSS, MKS, DIET, Toad & PL/SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Working on the Global Contact Center Technology (GCCT) Project from the beginning.
• Working with Ford, Microsoft architects about the system analysis, designing for application integration with Microsoft Azure
• Participate in development of new ETL processes and refinement of existing ETL processes
• Sharing expert knowledge through mentoring the onsite/offshore team, educational development and delivery, speaking engagements and blogs
• Have a good knowledge on call center channels like mail, chat, voice, sms and push notifications
• Have a good experience on creating REST API’s for NICE URL to get voice messages
• Finding optimal solutions for the complex data flow environment using RTSA (Azure)
• Implementing the optimization techniques for the large scale data handling environment
• Working with architects to reduce the Azure logic apps cost optimization
• Executes on cutting edge of product roll out including first time installations, projects and use cases with new technology
• Working with different stakeholders like Ford business, IT, Microsoft, DXC and Accenture teams to prepare the Functional and Technical requirements.
• Good knowledge on Microsoft CRM “Customers” Module (customer, Account, vehicle & dealer relationships)
• Having good knowledge on Configuring business units, teams & User GUIDs
• Worked on gap analysis for the existing and future state technical details
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Worked on ICS and IICS upgrades.
• Creating many new integrations using Application Integration (API) and Data Integration (mapping)
• Provide the solution for feasibility of connecting different connectors, drivers in IICS environment
• Provide the solution to handle the Real Time Streaming data in Informatica environment
• Working on Azure logic apps, Function apps, Façade, Keyvaults and Web pages
• Provide the solution to access the DB2 data using execution language BPEL
• Invoking third party application API’s using service connectors, services to get the external details
• Proving solution to integrating different interfaces to Microsoft Azure and load data into dynamics
• Configure the GECHUB server for ford external file transfer
• Worked with third party vendors to implement the GECHUB server
• Conduct the POC to connect the Informatica BDM and AWS, Hadoop environments.
• Provide the solution to connect the Redshift DB using Informatica BDM
• Involved data modelling, data mining, data Quality check activities
• Provided the guide to create and manage Oracle, Teradata, Hive, HDFS, Postgres connections.
• Managing Cloudera to check the name node, data node and edge nodes status
• Creating Informatica mappings, workflows, session tasks, reusable transformations, reusable tasks and worklets.
• Creating topics, applications, publications and subscriptions in Data Integration Hub (DIH)
• Used constraint-based loading & Target load ordering to efficiency load tables with PK-FK relation in the same mapping.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Trouble shooting of long running sessions and fixing the issues.

Technical Stack: Microsoft Azure, Dynamics D365, USD, Portal, IICS, Informatica 10, Visual Studio 2019, MS SQL Server, Github, Tableau, Linux, IBM APIC & Autosys

CTS Offshore: May’06 - May’12

• Involved in preparation of requirement analysis, estimation, design and coding
• Developing Oracle Forms, Reports
• Creating Oracle DB Packages, Procedures & Functions
• Writing Unix shell scripts
• Involved in code review and test case review
• Managing offshore team and communicating status, issues, and risks to project stakeholders in a consistent, timely manner.

Technical Stack: Oracle SQL, PL/SQL, Forms, Reports and Unix Shell scripts