CAREER PROFILE:

Software Developer with over 6.7+ years of professional expertise in Analysis, Design, Development and implementation of software applications in Financial, Banking and Health care industries mainly in the fields of Data Integration and ETL applications

PROFESSIONAL SUMMARY:

• Dell Boomi Certified Integration Developer
• Possess hands - onexperience in understanding integration requirements and building ETL data integration solutions using Dell Boomi, Actian Data Integrator (DI) v9.2 / v10, Ab initio.
• Expertise in preparing ETL design documents, Proof of Concepts (POC), creating very detailed design documents (LLD, HLD, Visio Job Linkage and etc.) and support related documents.
• Expertise in Oracle Service Cloud RightNowCX connector, RightNow Query Language(ROQL)
• Expertise in scripting languages for ETL tools - Groovy for Dell Boomi, Unix shell scripting for Abinitio, EZscript for Actian Data integrator
• Expertise in Salesforce CRM, EtQ Reliance and Agile systems
• Expertise in developing workflows, sessions, command tasks, complex mappings and all Transformations with excellent performance technique.
• Specialized in writing PL/SQL stored procedures for validating data and updating user data in DB2 application database.
• Proficient using Oracle EBS, SQL Server, PL/SQL, SQL *PLUS, DB2 database systems
• Experience in designing Source to Target graphs and testing of ETL Mapping
• Extremely effective in System Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications
• Very good exposure in Agile Lifecycle Model
• Well versed in Data Parallelism techniques using MFS file systems
• Good Experience in scheduling and administrating jobs using Operations Console scheduler
• Excellent team player and possess very good interpersonal, written and verbal skills.
• Clear understanding of business procedures and ability to work as an individual and with the team

TECHNICAL SKILLS:

ETL applications: Dell Boomi, Actian Data Integrator v9.2, v10, Ab Initio GDE 3.1.1, Co>Op 3.1.5.5, EME

Products/Software s: Oracle Service Cloud RightNow CX, Salesforce CRM, EtQ Reliance, Agile

Programming/Scripting Languages: Groovy, C,C++, Unix, EZ Script

Database Tools: Oracle EBS, MS: Access, Oracle SQL Developer, SQL Server, SQL Server 2008

Operating Systems: Windows 9x, Windows XP, UNIX, Linux

Scheduling tools: Operations Console, Zeke scheduler, CA7

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

ETL Dell Boomi Developer

Responsibilities:

• Create new Accounts, link accounts in Oracle service cloud real time using Dell Boomi REST API
• Create EBS Orders, Sales Order Notes, Parties in Oracle EBS and keep data sync in Oracle Service Cloud
• Integrate data from Oracle Service cloud into Oracle EBS, Salesforce CRM and vice versa.
• Manipulate date from Oracle service cloud into Agile, EtQ reliance systems and vice versa.
• Used REST API/ JSON profile as source to extract data from Oracle service cloud
• Hands-on design, development, deployment and management of multiple integration processes created on Dell Boomi.
• Configuration of Dell Boomi sFTP connections.
• Enable communication with application and data sources using connectors
• Used Document cache, Map components, Process properties and Dynamic Process properties.
• Execution of process from process properties, scheduling of process
• Used extension dialogue for defining extensions for components referenced in the process.
• Used Salesforce CRM as source of data integrated from Sales and Operations team.
• Created Groovy scripts to handle special mapping logic
• Create Technical & Functional Design Documents for Salesforce, Oracle EBS, Oracle Service Cloud, EtQ Reliance and Agile Integrations migrate process from Actian to Dell Boomi
• Migrate exiting batch integrations from Actian Data integrator to Dell Boomi
• Performed Unit testing and validated test results with business users.
• Transformed the source files received from various Line of business applications
• Involved into Development and Migration Approval Meetings to ensure that there are no conflicts with other team releases
• Involved in the Client user meetings about enhancements and daily SCRUM meetings.
• Coordinated with Stake holders to report the ETL rejections from reject and log files to ensure that the accounts are rejected according to the business logic and transformation rules
• Analyzed the upstream data flow received in the form of feeds and moved into the staging databases
• Created common reusable objects for the ETL team and overlook coding standards.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Expertise and Enhance capabilities of Dell Boomi functionalities by actively suggesting ideas through Dell Boomi community

Technical Environment: Dell Boomi, Dell Boomi Atmosphere, Actian Data Integrator v 10, Oracle service cloud, salesforce CRM, Oracle EBS, EtQ Reliance and Windows 7

Confidential, Columbus, Ohio

ETL Developer

Responsibilities:

• Used Process Designer and Web Invoker to make web service calls to invoke Web services from various interface applications.
• Created RIFL scripts to handle special mapping logic
• Performed Unit testing and validated test results with business users.
• Implement the maps and processes in production and automated the process to run at scheduled intervals
• Transformed the source files received from various Line of business applications using various DDE standards
• Involved into Development and Migration Approval Meetings to ensure that there are no conflicts with other team releases
• Coordinated with Offshore Developer to get the daily updates and assign the tasks
• Involved in the Client user meetings about enhancements and daily SCRUM meetings.
• Developed PLSQL stored procedures that meet business requirements.
• Coordinated with Stake holders to report the ETL rejections from reject and log files to ensure that the accounts are rejected according to the business logic and transformation rules
• Analyzed the upstream data flow received in the form of feeds and moved into the staging databases
• Created common reusable objects for the ETL team and overlook coding standards.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.

Technical Environment: Actian Data Integrator v 10, SQL Server 2008 and Windows 7

Confidential, Columbus, Ohio

ETL Developer

Responsibilities:

• Created RIFL scripts to handle special mapping logic
• Performed Unit testing and validated test results with business users.
• Implement the maps and processes in production and automated the process to run at scheduled intervals
• Transformed the source files received from various Line of business applications using various DDE standards
• Involved into Development and Migration Approval Meetings to ensure that there are no conflicts with other team releases
• Coordinated with Offshore Developer to get the daily updates and assign the tasks
• Involved in the Client user meetings about enhancements and daily status meetings.
• Developed PLSQL stored procedures that meet business requirements.
• Coordinated with Stake holders to report the ETL rejections from reject and log files to ensure that the accounts are rejected according to the business logic and transformation rules
• Analyzed the upstream data flow received in the form of feeds and moved into the staging databases
• Created common reusable objects for the ETL team and overlook coding standards.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.

Technical Environment: Actian Data Integrator v 10, SQL Server 2008 and Windows 7

Confidential

ETL Developer

Responsibilities:

• Used ETL to extract files from master account file, bank control file and transaction extracts for the external vendors and coordinated that effort.
• Migrated mappings from Development to Testing and from Testing to Production.
• Coordinated with downstream team to analyze the downstream data flow from the Operational data store(ODS) into other applications
• Performed Unit Testing and tuned for better performance.
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document.
• Reviewed Mapping documents provided by Business Team, implemented business logic embedded in mapping documents into Graphs and loading tables needed for Data Validation.
• Prepared the Detailed Technical Design Document for all the modules required for development.
• Ensured that data quality checks are satisfied for data consistency before reconciling them and moved into Operational data store.
• Involved into the staging cleanup if the position and transaction job fails to avoid the duplicates and data inconsistencies.
• System Monitoring and availability

Technical Environment: Actian Data Integrator v 9.2, SQL Server 2008 and Windows 7

Confidential

Abinitio Developer

Responsibilities:

• Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes
• Creating and Maintenance of Complex Graphs in Ab Initio
• Used Enterprise Meta Environment (EME) for version control, OpConsole for scheduling purposes.
• Creation of new environments, EME, Sandbox, data directories, OpConsole Systems, Application, Group, Calendars
• Involved into Installation and upgrade of Co> Op, Op Console, LDAP, Authorization gateway, Oracle client.

Technical Environment: Ab Initio GDE 3.1.1, Co>Operating System 3.1.4, DB2, Putty, UNIX, Operations Console

Confidential

Abinitio Developer

Responsibilities:

• Coordinate with Ab Initio support to detail study of issues faced in Ab initio environments and find solutions to fix them effectively
• Maintained locks on objects while working in the sandbox to maintain the privacy
• Responsible for deploying Ab Initio graphs and running them through the Co-operating systems mp shell command language and responsible for automating the ETL process through scheduling.
• Involved in Comprehensive end-to-end testing.
• Implemented the Test Scripts and Updated the RTM for document defects
• Involved in Metrics Calculation such as Defect Leakage, Requirement Leakage Index, Defect Aging, Defect Retest Aging and Quality of Index
• Executed SQL Queries using DBVisualizer to verify that the values imputed in the Java Transformation are properly stored in the staging table

Technical Environment: Ab Initio GDE 3.1.1, Co>Operating System 3.1.4, DB2, Putty, UNIX, Operations Console

Confidential

Abinitio Developer

Responsibilities:

• Responsible for analyzing source and target data models and making necessary changes to the mapping
• Interact with LOB’s on requirements clarifications.
• Interact with Clients on business requirements changes.
• Responsible for fully understanding the source systems, documenting issues, following up on issues and seeking resolutions.
• Assigning, coordinating and reviewing deliverable.
• Testing and Preparing the Unit Test Plans.
• Integrated and User Acceptance Test cycles execution.
• Review of design, code and testing for defect free deliverables.
• Fixing Issues out of Integrated System testing and User Acceptance Testing
• Project Implementation and Production Support.
• Provide proven problem research and resolution skills via 24/7 weekly on-call production support of daily batch jobs
• Checking the quality of the software and determining it’s degree of compliance to standards
• Monitoring performance continuously and look out for channels of improvement and cost-cutting.
• Conducting knowledge sharing sessions on various processes and technologies used in the project to other team members.

Technical Environment: Ab Initio GDE 3.1.1, Co>Operating System 3.1.4, DB2, Putty, UNIX, Operations Console