SUMMARY:

• Results - driven data integration lead with enormous experience in evangelizing and implementing enterprise data driven applications based on Data Integration, Enterprise Data Warehouse, Master Data Management, Data visualization as well as building Custom applications solutions on both on-cloud & on-premises environment. Proficient in partnering with several stakeholders of customers and managing project delivery.
• Experienced in capturing business requirement, creating product backlogs, and transforming business requirement into technical solution.
• 16 years of IT industry experience encompassing a wide range of skill set, roles, and industry verticals in multi-vendor, multi-stakeholder scenario.
• Over 7 years of experience in Human Capacity Management (HCM) with Workday & SAP system in J&J.
• Experienced in leading team in geographically dispersed locations across USA-NJ, India & Philippines.
• Responsible for project delivery of large team that contains data modelers, developers, and testers.
• Served as a Subject Matter Expert for HR, Compensation, payroll supply chain business flow.
• Performed busyness requirement analysis and liaising between business, product line owner, technical and test team in data integration project
• Proficient in implementing ETL/ELT type of integrations and master data management processes using IICS, Informatica Power Center, SnapLogic & MDM.
• Experience in data modeling (Erwin), and managing large-scale global Data Warehouse (Teradata) systems and their integration with several downstream systems.
• Working on AWS integration & (IICS) for different heterogeneous source and house data in Amazon S3 to PostgreSQL RDS and finally publish the data to several consumer.
• Architecting scalable and high performing technology solutions for a data visualization using Tableau.
• Performed source/target data analysis & data quality assessment using Informatica Data Quality.
• Experienced in Object Oriented Programming (ASP.Net- C# & VB) & Scripting languages (JS, Telerik)
• Well versed with Agile methodologies (Scrum, Kanban), using tools like Jira & Confluence.
• Experienced for supporting application and follow Incident, Service Request, Problem and Change Request process using Service Now (IRIS)
• Worked on Proof of Concepts (POC)’s on various upcoming technologies, looks for innovative solutions as well as to win new opportunities.
• Executed software projects for different domains like Life Science and Healthcare, Engineering, Shipping, Communication, Retail Service industry.
• Responsible for planning, organizing, and directing the completion of specific projects to ensure these projects delivery can be done on time, on budget, and within scope. Experienced in performing effort estimation, price case preparation & resource planning, assisting on-boarding. Managed cost, scope, schedule and quality of the project and efficient in team building activities, idea generation (BAG), year-end performance assessment and nomination. Ensure project risks within control or escalate in case of new risks or issues to the higher management.
• HCM Integration (Workday): Maintaining and enhancing Global Data Integration (GDI) as well as Global Data Warehouse (GDW) systems for effectively extracting and storing Worker (both Employee and Contingent), Position, Organization, Comp Allowance, Location, Global Mobility (IA), and leave of absent data (LOA) data from Workday and US/PR Payroll data from (SAP) systems. Then finally publish the data in specified format to different in-premises or externally hosted downstream system like Concur, Legal Hold, Benefit, XConnect, GCraft etc. Extensive business knowledge on Equity Management system indicative and mobility and reconciliation process.

TECHNICAL SKILLS:

HCM: Workday Data Integration (ETL): Informatica Power center (IPC v 9.6/10.2)

API Management: Oracle Eloqua Bulk API, PostMan

Master Data Management, Cloud Service: Informatica MDM 9.x, IICS, SnapLogic

Data Warehouse: TERADATA v.16.1/15

RDMS: PostgreSQL, ORACLE(9i-12c), MS SQL Server ( )

Data Modeling: Erwin R9.8

BI & Reporting Tool: Tableau, Crystal report XII

Agile Development: JIRA & Confluence

SIT & UAT Test Tracking: HP ALM (12.55)

Cloud Services: Amazon Web Services, IBM Bluemix (Platform-as-a-Service)

Scheduling Tool: Tidal, Control M

Languages: C#, VB.NET, XML, XSD, XSLT, Classic ASP, Core Java, UNIX-shell script.

Server Side: ASP.NET (WebForm, WinForm)

Client Side Scripting: HTML, CSS, Javascript, JSON

Middleware: IBM MQ 6 (Message Oriented Middleware)

Tool: DBeaver, Teradata SQL Assistant, SQL navigator, Toad, Eclipse (Java), WinSCP, Cloudberry, VSTO 2008, Ektron7.6 (CMS 400 min), Telerik Control (RAD), IRIS Service-Now, Remedy.

Source Control Tool: VSS, TFS, IBM Rational Team Concert (v3), Serena PVCS

PROFESSIONAL EXPERIENCE:

Confidential

Data Integration Architect

Responsibilities:

• Working on SnapLogic integration with Data Lake built on AWS S3.
• API Management using Postman to consume and publish Data for SAAS platform -Oracle Eloqua System for marketing automation.
• Working on Exasol, SQL server and other Databases using Data Visualizer

Confidential

Data Integration Lead

Responsibilities:

• Worked on AWS integration different heterogeneous sources like (Workday, Summit-Enterprise data Lake) and house data in AWS RDS and finally facilitate data to be consumed by Workforce Analytics and Planning system Visier
• Extensive use of Informatica Intelligent Cloud Services (IICS) to pull data from (Workday, Salesforce, Data Lake) system to AWS S3 in CSV format and load S3 files to RDS.
• Use Cloudberry Explorer for file management for Amazon S3.
• Implementing DB objects in Amazon PostgreSQL using DBeaver.
• Using Informatica Cloud Secure Agent program to runs all tasks and enables secure communication between in-premise data and IICS. Running task to connects Informatica Cloud hosting facility to access task information directly and securely to sources and targets and transfers data between them.
• Perform Extensive data analysis to achieve
• Creating and executing Control M scheduling for all the jobs used.
• Implementation of complex business logic in the integration using Informatica power center (10.1) to parse the data received from Workday and OurSource (SAP) payroll data and merge them into specific fixed length file and encrypt it before putting into MBOX.
• Implementation of Java. Jar file to merge multiple CSV into on excel file.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• File format conversion (UTF 8 to ASCII), Email notification and archival for important files and MBOX file retrieving and publishing work has been achieved by Unix Script implementation.
• Creating and executing Control M scheduling for all the jobs used.
• Perform Extracting, Loading & Transforming (ETL) data of Heterogenous Source (CSV, XML, TXT) for complex system using tools such as Informatica Power center, Informatica Master Data Management (MDM) and Data Warehousing technology like Teradata with Unix Scripting skill.
• Involved in development of Informatica Mappings, Mapplets and Workflows for complex Business rules.
• Implementing store procedure, user define functions using Oracle 12C using Toad.
• Extensive use of Teradata by bringing the CSV/XML Files and loading into the Teradata Temporal and normal Tables by using the BTEQ, TPT utilities.
• Creation of One-to-one, Semantic layer and standard view and Macro in Teradata.
• Configured Landing, Staging and Loading processes, Trust and Validation rules, Match and Merge process using Informatica MDM.
• Worked on generating various dashboards in Tableau using different data sources such as AWS Athena, Excel, SharePoint List, Enterprise data lake.
• Involved in dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions, and measured facts.
• Responsible to work on IRIS service now tool and tickets based on the requests from the Business Users of client.

Environment: Informatica Power center (IPC v 9.6/10.2), Informatica MDM, Teradata 15-16.1, Oracle 11g-12c, Tableau 20.2, Jira, Confluence, Unix Shell Script, IDQ, HP ALM, Tidal, Asp.net.

Confidential

Enhancing & Supporting Web Applications to track shipmentMa

Responsibilities:

• Extensively use IBM WebSphere MQ for middleware communication through .net Application.
• Parsing XML received from MQ and ingest data in SQL DB.
• Creation of Asp.net web application from Classic ASP business critical application
• Global Printing process implementation using WMI script.

Environment: Asp.Net (C#, VB), MS SQL Server (2005/2008), IBM MQ (v6), XML, JavaScript, HTML, CSS, WMI, Web Services (WSDL), XML, XSD, Crystal Report.

Confidential

Senior System Engineer

Responsibilities:

• Asset Harvester Assistant (A-HA) (Used for MS Word Document Set as well as XMI set cleansing and structuring those based on specific model) created in C#.NET 3.5, Core Java and VSTO2008.
• ReAL Asset Contributor (RAC) (Used for download /upload assets to/from RAM server based on different specification) developed in Core Jav
• Expensive Use of Service Orientated Architecture (WCF & Web Services) for VIN Search
• PayPal Integration.
• Developing solutions using Ektron7.6 (content management system), C#.net, MS SQL Server.

Environment: MS Visual Studio (C#, VB), Ektron 7.6 (cms400min), XML, WCF, MS SQL Server 2008.

Confidential

Software Engineer

Responsibilities:

• Product Development, by designing web pages in such a way that it works differently for different client and Implementing the functionality in the back end level, and business layer and finally implementing Presentation layer in AJAX using Telerik RAD Controls.
• Writing complex store procedures, triggers, functions.
• Designing the web page and implementing the logic in web application.
• ER Diagram, Data modeling for all main module using ERWIN.
• Writing stored procedure with maintaining proper coding structure in MS SQL Server

Environment: MS Visual Studio (C#), MS SQL Server, ERWIN 6, HTML, CSS, Classic ASP, JavaScript.

Confidential

Software Developer

Responsibilities:

• Designing the web page and implementing the logic in web pages and style sheet using Classic Asp, Asp.Net, HTML, and CSS.
• Providing operation support as per customer need.
• Writing stored procedure with maintaining proper coding structure

Environment: MS Visual Basic 6.0 (VB), MS SQL Server, JavaScript, HTML, CSS, Classic ASP.