SUMMARY

• Senior Systems Engineer with 10+ years of development and support experience
• Expert skill in developing, maintaining and supporting Middleware technologies using software engineering concepts.
• Sound knowledge and good experience in managing the end to end lifecycle of SOA services, Contribution in preparation of technical architecture of the services, preparation of security and architectural patterns, preparation of standards, guiding the team in resolving the technical issues, production problems.
• Lead and participate in the management and technical delivery of consulting, services to plan, architect, design, build, implement and support information system. Able to handle multiple simultaneous projects, demonstrate a sense of ownership to drive projects to completion on schedule under tight deadlines, and be successful in a collaborative environment.
• Proficient in Informatica Power Center,Informatica BDM and Informatica Navigator
• Proficient in IBM WebSphere Message Broker, IBM Integration Bus (IIB), Transformation Extender.
• Sound knowledge and good experience in Tivoli Maximo Tool aka IBM ISM Tool. Contributed in automating several Envision Alerts/Ticket Creation.
• Sound knowledge about Big Data platforms and Structured & Un - Structured Data Hadoop Fundamentals, Hive, HBase, Apache Pig, Apache Spark,MapReduce and YARN, Sqoop, ZooKeeper.
• Sound Knowledge in Designing and developing Big Data analytics platform for processing customer viewing preferences and social media comments using Java, Hadoop, Hive and Pig.
• Sound knowledge on Hadoop Distributed File System (HDFS) and Apache Spark and Data Lakes strategies. Integrating Hadoop into traditional ETL, accelerating the extraction, transformation, and loading of massive structured and unstructured data.
• Develop the end to end project plans with the execution team using the Robotic Process Automation tool WinAutomation Tool.
• Run Steering committee meeting, execute the weekly project calls and take status of the delivery.
• Proven track record of evaluating current processes and envisioning ways to reengineer the process in order to create significant efficiencies and enhance controls.
• Provide development and testing support and follow implementation of standards and best practices in alignment with our architecture patterns.
• Ongoing contribution to the automation Practices and Frameworks in order to drive a culture of continuous improvement.
• Experience in ticket creation and change creation using ISM tool. Closed several problem incident and service request with resolutions.
• Sound Knowledge and good experience in IBM Tivoli Workflow Scheduler (TWS) Contributed in scheduling various jobs and alerts for periodic run inorder to monitor the CPU/Disk and Memory Utilization also for transferring, transmitting from midrange to mainframe systems and performance of the overall environment.
• Diverse experience utilizing Java tools in business, Web, and client-server environments including Java Platform and Java database Connectivity (JDBC) technologies.
• Expertise in different nodes of WMB such as Compute, WebSphere MQ nodes, SOAP UI, File and transformation nodes and handling the messages with XML, Cobol copy book etc.
• Experience in analysis, design, development and testing of various projects using software engineering concepts in Middleware Technology.
• Added conditional changes on transformation and translation using Java
• Experienced in developing data maps for EDI and XML using WTX tool.
• Modified WTX map type trees, interfaces for existing maps based on requirements.
• Evaluated data to find errors in X12 EDI transaction sets.
• Knowledge and Experience on IBM DataPower Caching Appliance XC10, IBM DataPower Security Appliance XS40 and Integration Appliance XI50 and X152.
• Knowledge and Experience on Configuring and Integrating DataPower SOA appliance features with IBM Tivoli Access Manager and Tivoli Directory Server.
• Experience about AAA concept and Policy Creation and Tivoli Access Manager Client Objects
• Knowledge about Informatica v10.2 (ETL) tools used to manage Data Integration in the Enterprise architecture
• Supported data Extraction and data Transformation from Mainframe to Midrange via PowerExchange
• Knowledge about Informatica (ETL) Workflow Manager and Workflow Monitor
• Support Experience on ETL Mapping Tool Designer like Informatica Power Center Designer
• Support Experience on ETL Mapping Tool Power Exchange Component(PWX).
• Monitoring of Informatica (ETL) Recycling Process and Server Process Logs.
• Good understanding of various Specialized in US healthcare and EDI clearing house and worked on for ICD10, Health Exchange and other Health care transactions.
• Expert Healthcare domain knowledge in lifecycle of Claim processing
• Claim status, Eligibility and Benefits and HIPAA standards and data formats like EDI, HIPAA ANSI X12, XML standards for transactions like 837I/P/D, 270,271,276,277,835,834,820.
• Good documentation skills to keep environment up to date
• Created an automated process to run extracts, validate and sends a status report for each to the client and the support team
• This gave back 120 hours a month back to the supporting team to work and monitor other more critical tasks that arose out of adhoc issues in monitoring
• Expert skills in relational DBMS technologies
• Middleware: WebSphere MQ V6.x, 7.x, 8.x, IIB 10.0, MQSeries 5.3
• Message Broker: V6.x, 7.x, 8.x WebSphere Transformation Extender 8.2/ITX 9.0
• Monitoring Tools: Tool Kit, MQ Explorer, Qload, RFHUtil, SOAP UI, WinAuto 6.2,7.0.0
• Data Integration: Informatica v10.2
• Exposure to a wide range of technical and business domains - ability to see big picture in a complex environment not limited to:

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh,PA

Application Developer/Informatica Developer

Responsibilities:

• Created Data Maps / Extraction groups in Power Exchange Navigator for legacy IMS Parent sources.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Parsing high-level design specification to simple ETL coding along with mapping standards.
• Have configured the Informatica BDM/BDQ/EIC/IDL 10.1/10.2.1 and integrated with the Kerberos enabled Cloudera and Horton Hadoop Frameworks.
• Applied incremental Emergency bug fixes to fix any product issues and follow up with Informatica support for any issues.
• Familiar with the Rest API Calls to run the scanner or update the Business Terms on the EDC.
• Maintain Security administration Natively or via Active Directory - support with access privileges for different levels users/groups/roles - built in or customized
• Familiar with Kerberos enabled Informatica domain for the SSO option.
• Worked on OS Profiles to help multiple development teams working on a single shared file system and use the impersonation property on the IDS against Hadoop systems since the access on the Hadoop cluster was based on the Apache Ranger Policies.
• Experienced in processing Healthcare - HL7 data files using the Informatica Data Transformation Libraries and load them into Hadoop.
• Created customized BDM mappings/workflows for incremental using Informatica Developer and deploy them as part of an application on Data Integration service for the native execution or push down using the Blaze or Spark execution engines.
• Assist developers in debugging since now the logs are scattered on BDM between the Native servers and on the Yarn - Spark and Blaze have different set of logs in different directories configured which is a pre requisite for Informatica Big Data Products.
• As part of the change control, help developers in updating the service properties and migrating the code between the environments.
• Have worked with the parameter sets/files at mapping and workflow level.
• Familiar with using Sqoop arguments required to source data from any traditional database systems into Hadoop.
• Experienced in writing Native Hive QL’s and Compare the load performances with BDM jobs.
• Create different scanners Hive/Oracle/PowerCenter/Platform to load the data assets into a single place repository - EDC.

Environment: Informatica Power Center 10.1 and 10.2, Informatica BDM v 10.2.1 10.2.2 , Hadoop 2.6 and 3.1 and HIVE and HDFS

Confidential

Senior System Engineer/ IIB & ITX Developer

Responsibilities:

• Worked to determine problems in the Blue Exchange product.
• Expertise on NPS, Blue Exchange, HIPAA, MQSeries
• Expertise on WMB (WebSphere Message Broker), IBM Integration Bus (IIB).
• Expertise on WTX (WebSphere Transformation Extender), IBM Transformation Extender (ITX).
• Expertise on WPS (WebSphere Process Server)
• Experience on WDP (WebSphere Data Power) and AIX is needed in order to properly support production issues.
• Experienced in developing data maps for EDI and XML using WTX tool.
• Modified WTX map type trees, interfaces for existing maps based on requirements.
• Evaluated data to find errors in X12 EDI transaction sets.
• Developed Message Flows and Message Sets based on the requirements.
• Developed Message Sets and Message Definition using WSDLs and Message Flows to convert (XML, CWF, TDS) and route the request and response messages to respective destinations.
• Developed SOAP Message Flows and WSDLs Files for various Business Requirements
• Designing and developing message flows along with Java and ESQL coding.
• Developing ESQL to perform computations and mappings.
• Sound knowledge and good experience in Tivoli Maximo Tool aka IBM ISM Tool. Contributed in automating several Envision Alerts/Ticket Creation.
• Experience in ticket creation and change creation using ISM tool. Closed several problem incident and service request with resolutions.
• Worked on designing several Change Request creations and supported the tasks assigned.
• Worked on designing and created several problem incidents using the ISM ticketing agent .And updating it with correct resolution code under Solution Details. And updating with Correct Work log in case of providing RCA and DSSR.
• Sound Knowledge and good experience in IBM Tivoli Workflow Scheduler (TWS).
• Scheduled various jobs and alerts using the IBM Tivoli Workflow Scheduler (TWS) for transmission of files from midrange to mainframe system using Perl scripts.
• Monitoring those scheduled jobs and alerts to ensure that transmission is always on incase of any failure
• Scheduled various alert mechanism for CPU Utilization /Memory Usage and Disk Usage across System using TWS (IBM Tivoli Workflow Scheduler) and set up threshold limit so that alerts are issued, and issues are resolved without Outage and User Impact.
• Knowledge about Informatica (ETL) tools used to manage Data Integration in the Enterprise architecture
• Supported data Extraction and data Transformation from Mainframe to Midrange via PowerExchange
• Knowledge about Informatica (ETL) Workflow Manager and Workflow Monitor
• Support Experience on ETL Mapping Tool Designer like Informatica Power Center Designer
• Support Experience on ETL Navigation Tool Power Exchange Component (PWX)
• I worked with industry leading tools and various IBM strategic remediation products such as BluePrism, IPSoft, WinAuto etc.
• Gained knowledge of programming and tool configuration
• Provided support on IBM DataPower Caching Appliance XC10, IBM DataPower Security Appliance XS40 and Integration Appliance XI50 and X152.
• Monitored Keys and certification Managements, monitoring and configuring of Webservices Proxy and Configuration of Files.
• Worked on various TWS job abends/enabling/disabling of scripts.
• Worked on entire Midrange Applications like DataPower, BlueExchange, Benefact, CXT, MWC, MWS, BASS, MBDAP, HCBO Portal and HIPAA.
• Automated Confidential Application Checkouts using Win Automation Tool.
• Provide development and testing support and follow implementation of standards and best practices in alignment with our architecture patterns.
• Ongoing contribution to the automation Practices and Frameworks in order to drive a culture of continuous improvement.
• Performed automation on various Applications like BX27X, INTERACT, Accumulation, BXBUI, BlueSquare, Capitation, Benefact, DRS, Actuate, eFDE, ICD10, CARDS, ADR, HCBO, EOB, CXT MI, CXT HZN, CXT MASS, MWS, MWC, PCS, BASS, WAS, DataPower, PMR, Informatica.
• Configuration of IISv7.0 and multiple website creations for all the environments.
• Installation and configuration of IBM WebSphere solr server.
• Automated multiple admin activities using WinAutomation and Shell Script
• Setup index replication configuration and automation of Indexprop utility for search index from staging server to production on Aix 6.1 platform.
• Installed and configured performance monitoring tools like AppDynamics and IBM health center on Aix 6.1 platform.
• Day to day Admin activities like trouble shooting, Performance tuning and monitoring on AIX platform.

Environment: WebSphere Message Broker(WMB) V8.0,IBM Integration Bus (IIB V10.0, WebSphere Transformation Extendor 8.4, ITX V9.0, IBM DataPower, Data Integration using Informatica 10.2,IBM HTTP Server 6.x,DB2, Shell Script, Perl Script, Window Server 2008, Windows Server 2012, AIX7.1

Confidential

Senior System Engineer/ Middleware Developer(IIB/ITX Developer)

Responsibilities:

• Worked to determine problems in the Blue Exchange product.
• Expertise on NPS, Blue Exchange, HIPAA, MQSeries
• Expertise on WMB (WebSphere Message Broker), IBM Integration Bus (IIB).
• Expertise on WTX (WebSphere Transformation Extender), IBM Transformation Extender (ITX).
• Expertise on WPS (WebSphere Process Server)
• Experience on WDP (WebSphere Data Power) and AIX is needed in order to properly support production issues.
• Sound knowledge and good experience in Tivoli Maximo Tool aka IBM ISM Tool. Contributed in automating several Envision Alerts/Ticket Creation.
• Experience in ticket creation and change creation using ISM tool. Closed several problem incident and service request with resolutions.
• Worked on designing several Change Request creations and supported the tasks assigned.
• Worked on designing and created several problem incidents using the ISM ticketing agents. And updating it with correct resolution code under Solution Details. And updating with Correct Work log in case of providing RCA and DSSR.
• Experienced in developing data maps for EDI and XML using WTX tool.
• Modified WTX map type trees, interfaces for existing maps based on requirements.
• Evaluated data to find errors in X12 EDI transaction sets.
• Developed Message Flows and Message Sets based on the requirements
• Developed Message Sets and Message Definition using WSDLs and Message Flows to convert (XML, CWF, TDS) and route the request and response messages to respective destinations.
• Developed SOAP Message Flows and WSDLs Files for various Business Requirements
• Designing and developing message flows along with Java and ESQL coding.
• Developing ESQL to perform computations and mappings.
• Sound Knowledge and good experience in IBM Tivoli Workflow Scheduler (TWS).
• Scheduled various jobs and alerts using the IBM Tivoli Workflow Scheduler (TWS) for transmission of files from midrange to mainframe system using Perl scripts.
• Monitoring those scheduled jobs and alerts to ensure that transmission is always on incase of any failure
• Scheduled various alert mechanism for CPU Utilization /Memory Usage and Disk Usage across System using TWS (IBM Tivoli Workflow Scheduler) and set up threshold limit so that alerts are issued, and issues are resolved without Outage and User Impact.

Environment: WebSphere Message Broker(WMB) V8.0,IBM Integration Bus (IIB V10.0, WebSphere Transformation Extendor 8.4, ITX V9.0, IBM DataPower,DB2, Shell Script, Perl Script, Window Server 2008, Windows Server 2012, AIX7.1,WinAuto v6.1, v7.0