SUMMARY

• Dedicated and focused Data Management consultant with proven track record in Implementing, Consulting & Analyzing IT Solutions.
• Also worked as a ETL Architect, Business Analyst, Developer having great experience with all strategies of Software Development Life Cycle including designing, developing, testing and rolling out complex projects.
• Profuse knowledge on mapping different File formats like XML, CSV, SAP IDOC, Positional and other Client Proprietary formats.
• Worked on different ETL Products like TALEND, EDIFECS, Sterling B2B Integrator, Gentran, GIS, Sterling File Gateway, TLE, GXS, Wherescape, SSIS.
• Developed Complex Talend Jobs to Load the data from Existing Enterprise Data Warehouse to Data Vault 2.0 (Involved in all phases of Data Vault like staging, Raw Vault, Business vault and Data marts/Info marts).
• Used different components in Talend Data Integration (V6, V6.3, 6.4.1, 7.1) and Talend Master Data Management (V6.4.1, 7.1) and Involved in the Migration of Talend Servers from 6.4 to 7.1.
• Extensive experience in EDI transaction sets like 850, 855, 856, 810, 997, 834, 835, 837, 270, 271, 840, 843, 940, 945, 947, 861, 846 and EDIFACTS Standards.
• Configure Projects in TAC, set - up users in TAC and grant access to users with appropriate roles to the respective projects and Scheduled jobs in TAC in Dev, QA and Production environments.
• Developed Talend jobs to load Master Data Management Tables with Cleansing and matching rules for entities like Provider, Member, Claims data.
• Worked on different Data Sources like MSSQL, Oracle, MySQL, Netezza, Flat files, MoveIt, Sybase, Facets, Teradata, DB2, Azure SQL Database, Excel.
• Experience in using AWS cloud components and connectors to make to make API calls for accessing data from cloud storage (Amazon S3, Redshift) in Talend Enterprise Edition
• Strong knowledge on various procedural and Object Oriented Programming languages like C#
• Developed, Scheduled, Improved performance and Deployed ETL jobs in Talend, Wherescape, SSIS.
• Interacted with trading partners and creating standard specifications for various Health care, Retail and logistic transaction sets for both inbound and outbound using ANSI X12 and EDIFACT standards
• Created configurations for mailboxes, users, profiles, and auditing for Managed file transfer (MFT) using SFG and multiple protocols (e.g. FTP, SFTP, VAN, AS2, AS1).
• Extensively worked with the QA Team and the Business users during UAT & Sign-off process. Tracked issues/bugs and resolved it in timely manner to meet Service level agreement (SLA) and provided end to end documenting
• Ability to learn things quickly and high motivated team player with strong skills and passion to learn new technologies, methodologies, strategies and processes. Can work under pressure in achieving organizational goals.

TECHNICAL SKILLS

ETL Platform: Talend, Wherescape, Gentran, Gentran Integration Suite, Sterling B2b Integrator, EDIFECS.

ERP: SAP, Oracle EBS, Mainframes, Salesforce

Languages: SQL, PL/SQL, Shell Scripting, PostgreSQL, Java/J2ee, JavaScript, PHP, Python, Hadoop, C/C#/C++, HTML, CSS

Operating Systems: Unix, Windows, Z/OS, Linux

Database: MSSQL, MYSQL, POSTGRESQL, Oracle, Teradata, Azure SQL Database, SYBASE, DB2.

Tools: SharePoint, ServiceNow, SSDT, Rapid SQL, Jira, TFS

Cloud: AWS, Azure, Snowflake, Salesforce

Methodologies: Agile, Waterfall, Kanban

Visualizations: Tableau Desktop, SSRS, Excel.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Responsibilities:

• Worked through all the phases of the software development life cycle
• Served as a subject matter expert to the team. Technical and design inputs to multiple development teams on applications, ensured implementation of design and coding standards.
• Designed and developed batch processing using Spark jobs and Scheduled.
• Developed oozie workflows and processed them on HUE dashboards.
• Reviewed the ETL code developed and unit tested before migrating to Production on bi-weekly basis.
• Involved in the Talend migration from v6.3.1 to v7.0.1.
• Worked on ESB components, Routes and Routines in the talend studio.
• Worked on Hadoop and used several services like HDFS, MapReduce, Hive, Sqoop, Flume, Hive, HBase, and MongoDB.
• Utilized Big Data components like tHive Input, tHive Output, tHDFS Output, tHiveRow, tHiveLoad, tHive Connection, tOracle Input, tOracle Output, tPreJob, tPostJob, tLogRow
• Hands on experience on many components from the palette to design Jobs & used context variables to parameterize Talend jobs.
• Implement performance tuning strategies to improve the performance of existing Talend ETL jobs/processes, SQL and UNIX scripts etc.
• Stored MapReduce program output in Amazon S3 and developed a script to move the data to RedShift for generating a dashboard using QlikView, Tableau
• Experience in analysis, design, and development using Amazon Redshift and AWS.
• Used AWS Services (S3, EC2, EMR, RDS, Amazon RedShift) in DEV, Test and PROD Environments
• Responsible for develop the jobs using ESB components like tESBConsumer, tESBProviderFault, tESBProviderRequest, tESBProviderResponse, tRESTClient, tRESTRequest, tRESTResponse to get the service calls
• Cloud Computing on Amazon Web Services - AWS (EC2, EMR, S3, IAM, VPC, Redshift, Lambda, Cloud Formation, SNS/SQS etc.)
• Create Talend Jobs for data comparison between tables across different databases, identify and report discrepancies to the respective teams.
• Configure Talend Administration Center (TAC) for scheduling and deployment of jobs.
• Involved in performance tuning of Talend jobs.
• Experience in AWS S3, EC2, SNS, SQS setup, Lambda and Redshift cluster configuration.
• Hands on experience in creating generic schemas, context groups and variables to run jobs against different environments like Dev, Test and Prod
• Created standard and best practices for Talend ETL components and jobs.
• Lead the team in the migration of ETL jobs from Data Stage to Talend.
• Created S3 buckets for each inbound and outbound file and loaded the data into Redshift tables.
• Created Talend jobs for encrypting the source data and processing it and loading into Redshift and SQL tables.
• Developed the ETL processes for extracting, cleansing, transforming and integrating the EDW data.

Confidential, Sunnyvale, California

EDI B2B Analyst/Developer

Responsibilities:

• Set up of AS2 connections with the Trading partners
• Involved in purchasing and 3PL projects
• Onboarding different playbook projects
• Worked on gShip, MOB tools
• Worked on Oracle ERP
• Worked on 940,945,947,856,846 and 861 warehouse transactions for 3PL side and 850, 855, 856, 860 and 865 for purchasing side.
• Involved in System Integration Testing and UAT testing (User Acceptance Testing) and compiled the function and non-functional requirements and created Test scenarios and Test Scripts
• Initiated the offshore team for onboarding the projects
• Monitoring of EDI file processing, troubleshooting issues affecting successful receipt or delivery of client files.
• Setup and testing of new trading partners
• Extensively worked on Oracle, SQL Server Databases to test the back-end data.
• Developed SQL queries/XML Files for checking the EDI files in MOB
• Worked on Agile SDLC approach implementation for the whole testing life cycle
• Actively participated in all phases of testing lifecycle.
• Participated in all Status Calls, Release Management Calls, Test Case Review meetings and Sign-Off meetings
• Experience in resolving and documenting issues related to EDI transactions
• Created the Test Plan document which describes about the Test Strategy, In-Scope, Out of Scope, Assumptions, Risks, Dependencies and Timelines etc.

Confidential

EDI B2B Analyst/Production Support Specialist

Responsibilities:

• Gathering business requirements and articulating them into EDI mapping sheet for integration with SAP.
• Understanding B2B concepts and other document standards like Rosettanet, ANSI X12, and EDIFACTS.
• Implemented EDI messages integrating SAP on various modules.
• Worked on SAP IDOCS.
• Migrated SI 5.2 to Sterling Integrator 5.2.5
• Communicated with various stakeholders for EDI on boarding.
• Experienced on implementing end-to-end EDI setup’s including stages like requirement gathering, mapping, testing and support.
• Knowledge on business messages like Purchase orders/ Invoices.
• Worked on the Sterling Integrator for map development.
• Worked on the ClearQuest tool for tracking the workflow integration.
• Prepared user Stories for every Sprint for each AGILE release based on the requirements gathered from the Business users through our Requirement gathering sessions
• Sound knowledge on SAP basic Tcodes.
• Worked on the PR1, QA5, and DV5 of SAP environments.
• Worked with EDI transactions WE02, WE05, BD87 and EDPAR tables.
• Resolved Tickets as a part of production support for issues related to EDI and GXS
• Involved in map development activity using GXS AI tool
• Coordinate with the Sterling team for resolving mapping issues.
• Worked with the offshore team for production support.
• Resolution of EDI/IDOC for the inbound and outbound interfaces.
• Worked on end-to-end testing with the customers in the SAP and Sterling environment.

Confidential

Grad Assistant

Responsibilities:

• Worked as Assistant in the Office of International Programs.
• Maintained the student profiles in the School Database and updated accordingly.
• Created Web Applications using C#.
• Designed GUI using C#
• Worked with the team in developing the School Website and Student Portal.
• Worked with Accounts Receivables and Accounts Payables entering/depositing checks and entering/paying bills.
• Maintained the student information and admissions in the Excel sheets on daily basis.
• Managed Student Employment records and their Timesheets.
• Designed and Populated specific tables, databases for collection, tracking and reporting of student data.
• Assisted students with questions pertaining to the course program

Confidential

EDI Developer

Responsibilities:

• Requirement Assessment
• On-boarding partners
• Understanding scope of B2B and implementing
• Used Trusted Link Enterprise Mapping Workbench for developing maps.
• Understanding the mapping documents. Enhanced map as per business requirement.
• Testing the EDI files for all EDI syntax errors.
• Worked on Gentran on Unix
• Conducted knowledge transfer sessions and documented them
• Have experience on both the X12 & EDIFACT Standards and XML & IDOC's.
• Developed web forms in ASP.NET using C# as the code-behind language.
• Involved in modification of Existing Maps in Visual Mapper, Application Integrator & Map Editor.
• Responsible for creating Mapping Requirement Specification (MRS), Technical & functional design
• Documents and UTP (Unit Test Plan).
• Analyzing & debugging the existing code.
• Updating trading partner information
• Involved in Component and Unit Test
• Communication of project status effectively to the management and client.
• Documented entire EDI process
• Prepared Production Support documents.