SUMMARY

• 7+ years of Extensive experience in the field of software development and 3+ years of Enterprise Application Integration (EAI) and 4+ years of Oracle developer experience.
• Experience with implementing service - oriented architecture (SOA) and enterprise application integration (EAI) using Mule soft
• Experience in analysis, design, development, testing, deployment and monitoring of EAI & ESB projects.
• Experience in designing, developing and managing APIs using Mule API gateway.
• Expert level skills with REST and SOAP web services, RAML and use of connectors for integration.
• Involved in various phases of Software Development Life Cycle (SDLC) as requirement gathering by assisting with JAD sessions, modeling, analysis, architecture design and development using AGILE methodology.
• Experience in deploying applications into MuleSoftCloudhub and MMC.
• Hands on experience on transformation using Data Weave/Data mapper.
• Ability to troubleshoot Mule ESB (debuggers/flow analyzers), deployment, and tuning.
• Good understanding of SOA and ESB concepts, integration patterns and best practices.
• Good experience in using Transformers, Filters, Flow Control, Collection splitters/Aggregators / Scatter- Gather etc.
• Excellent understanding of full Software Development Life Cycle.
• Experienced in writing, testing and implementation of Triggers, Stored procedures and Functions at Database level using PL/SQL in Oracle & SQL server.
• Excellent interpersonal, management, analytical, problem solving abilities and communication skills.
• Involved in design, built, and deployed applications utilizing AWSstack (including Amazon EC2, S3 and SQS).
• Involved in deploying applications into Mule SoftCloud Hub and Mule Management Console.
• Created custom components and configured them in mule-cofig.xml and verified.
• Ability to work as part of team and independently also quickly adapt and learn new technologies.
• Good understanding of data mining concepts, ETL processes, and data modeling concepts such as design of the dataflow, ER Diagrams, Normalization and Denormalization of tables
• Experience utilizing dynamic SQL (dbms sql, Execute Immediate) functionality.
• Experience in maintaining and developing database objects like tables, views, indexes, sequences, synonyms etc

TECHNICAL SKILLS

EAI Tools: Mule ESB, AnyPoint Studio, CloudHub

Languages: Java, J2EE, C, C++, HTML, XML, SQL and PL/SQL

Operating systems: Microsoft Windows NT/XP/vista/7/8, Linux Solaris

Application Servers: Apache Tomcat, Web Logic Server, JBoss

Protocols: TCP/IP,FTP,EMS, RV, HTTP,SOAP

Database: Oracle 8i/9i/10g/11g, SQL server 2008/2010/2012 and DB2

Modeling/ Multi/Macro Media /Tools: UML, Microsoft Visio, Adobe Photoshop, MS-Office, Altova XML Spy, TOAD, XSD, XSLT and XPATH

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Mulesoft Developer

Responsibilities:

• Reviewed JIRA tickets, confluence pages and understand Business requirements, and Business logic.
• Completely re-enforced and re-structured some already existing API's. Designed and developed several flows for new requirements and variety use cases using theMuleSoftAnypoint Studio of Mule ESB.
• Created new schemas, examples and YAML's for new API's.
• Worked on Authentication and Authorization project by using OAuth 2.0and SSL.
• Validated payment methods by using Java EPP script and created payment methods and payment API's.
• Worked exclusively on Sprint Digital - IMPL, Payments, auth implementation, Users and Subscription projects.
• Extensively used Data weave for data transformation and implementing complex logics.
• Created REST API's using RAML and developed flows using APIKIT Router.
• Worked closely with front end to resolve and design API's according to requirement and make them fully functional.
• Review the existing packages, validated and made huge contribution to try new logic and ways to support tool improvements and make the code more efficient.
• Created Global exception strategy for all the packages which includes complex API's to achieve exceptional service and supported of all integrations with proper error messages that including root cause identification and solution recommendation.
• Collaborate with other technical functional teams such as DevOps, front-end teams, Architects, Mulesoft Support teams for release and production support.
• Collaborate with Applications Development and QA teams to establish best practices.
• Integrating with DevOpsandMuleSoft for deployments in different environments that connects applications, data sources and APIs, in the cloud.
• Created various RAML resources to implement REST Based APIs as a part of project implementation.
• Mostly consumed RESTful Web Services and SOAP web services.

Environment: MuleSoftAnypoint Studio, Cloud Hub, Java, JDK 1.6, Spring MVC, XML, Oracle 11g, Mule Management Console, RAML,Connectors.

Confidential, Greensboro, NC

Mulesoft Developer

Responsibilities:

• Reviewed Functional Specifications documents to understand Business requirements.
• Prepared Technical Design and Interface Control documents (Interface document used by Service Consumers).
• Designed and developed several mediation flows of variety use cases using theMuleSoftAnypoint Studio of Mule ESB.
• Designed and developed various MuleSoft ESB applications to implement the integration in this organization.
• Developed flows to interface with third party applications called SMART and LMS.
• Involved in securing the API’s using OAuth 2.0and SSL.
• Extensively used Data weave / Datamapper for data transformation.
• Created REST API's using RAML and developed flows using APIKIT Router
• Work closely with our SAP, CRM, PR and HRMS teammates and business partners to fully understand the user functionality and identify areas of improvements.
• Review statistics, validate or challenge the way things have always been done and identify areas for process and/or support tool improvements and efficiencies
• Accountable to achieve exceptional service and support of all integrations including root cause identification and solution recommendation.
• Collaborate with other technical functional teams such as DevOps/IT/Ops/QA/Release teams
• Collaborate with Applications Development and QA teams to establish best practices implementation of methodologies and toolsets
• Work closely with functional leads/PMs to understand the partner integration requirements.
• Integrating thesalesforce.com with theMuleSoft for connecting applications, data sources and APIs, in the cloud.
• Used J2EE design patterns like Factory, Singleton.
• Involved in designing the user interfaces using JSF, HTML, Javascript, JSP, Angular JS
• Created various RAML resources to implement REST Based APIs as a part of project implementation.
• Consumed RESTful Web Services.
• Developed RESTfulwebservices using MuleSoftAnypoint studio
• Involved in Creation, Manipulation and Supporting the SQL Server Database

Environment: Java, J2EE, JDK 1.6, Spring MVC, MuleSoftstudio, Hibernate, XML, JQuery, Ajax, Javascript, Angular JS, DB2 9.5, Oracle 11g, MuleSoftAnypoint Studio, Cloudhub, Mule Management Console, RAML,Connectors, RAD 8.0.

Confidential, Winston Salem, NC

Senior Oracle PL/SQL Developer

Responsibilities:

• Interacted with BA’s and the DBA’s to analyze the issues that were encountered while testing the applications.
• Involved in Data analysis and Data profiling.
• Responsible to validate the data between the various systems and drive changes that ensure the integrity based on Business Rules and Transformations.
• Involved in reading and analyzing the data mapping documents.
• Strong ability in developing advanced SQL queries to extract and calculate information to fulfill data and reporting requirements .
• Used the Toad Data Analyst to compare the results between the Source and the Target .
• Used the ALM tool to write the test cases and to track the defects.
• Extensively worked with Excel advanced commands for preparing and comparing the data.
• Developed ETL’s for data extraction, Data mapping and Data Conversion using SQL, PL/SQL.
• Performed system testing, functional testing and Integration testing and the regression testing.

Environment: Toad 12, SQL developer, Unix, Putty, Notepad++, Oracle 10g/11g,ALM12.0

Confidential, Utica, NY

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in Data Analysis, and Design the Process flows in the more efficient way then earlier flows.
• Worked individually in developing the Procedures, Functions, Cursors, Complex Queries and Performed Data loading using ORACLE ODI (oracle data Integrator).
• Experience in using Dynamic SQL's, BULK COLLECT, REF Cursors and VARRAYS and Collections..
• To develop Test Plan and participate in UNIT testing and System Integration Testing for Production Implementation.
• Involve in Unit testing PL/ SQL Stored Procedures and Functions.
• Used Soup UI for Testing the DATA and to make a keen analysis on the raw data by generating the Test suite.
• Fine-tuned the SQL queries using Explain Plan.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for generating various kinds of reports as per the user requirement.
• Provided support for the application database related issues.
• Involved in reports designing and developing. Involved in integrated reporting capability.
• Developed various reports using oracle reports builder 6i and upgrades the existing reports .
• Developed the Stored procedures using PL/ SQL Tables and records to generate the output in XML format.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, SQL Plus, SQL, PL/SQL, UNIX (HP), Shell (Bash) Script,Windows XP, LINUX, Soup UI

Confidential, Greensboro, NC

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in creating Oracle tables, views, procedures, packages, triggers, functions and indexes.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables.
• Manipulated large amount of data.
• Extensively wrote SQL queries for generating various kinds of reports as per the usual requirement.
• Debugged SQL and provided alternate ways to write SQL for DB performance improvements.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in the monitoring of database performance in Enterprise Manger console.
• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing with client.

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, SQL Plus, SQL, PL/SQL, UNIX (HP), Shell (Bash) Script, Windows XP, LINUX, Soup UI

Confidential, Hoover, Alabama

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in designing, developing, and testing of PL/SQL stored procedures, packages and triggers.
• Developed complex SQL and PL/SQL queries.
• Created database objects like Tables, views, synonyms, Indexes etc
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for generating various kinds of reports as per the user requirement.
• Used Informatica Designer (Power Mart) to create complex Mappings
• Developed several Informatica mappings that transfers data from source the Data Mart.
• Created Source definitions, Source Tables, Target definitions and Target Tables.
• Used Informatica Server Manager to create sessions/ batches to run with the logic embedded in the
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Used Erwin for designing Database both logical and physical data modeling.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in the monitoring of database performance in Enterprise Manger console.
• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing with client

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, Perforce, WinScp, SQL Plus, SQL, PL/SQL, UNIX (HP), Shell (Bash) Script, AWK, SQL * Loader, Windows XP, LINUX, Erwin, Informatica Power Center 9.1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing with client.
• Designed, Partitioned, Developed and Maintained the necessary database objects
• Participated in implementation meeting strategies.
• Involved in developing Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
• Developed ETL’s for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various shell scripts in Data stage.
• Involved in writing Oracle PL/SQL functions, procedures and packages in Oracle RAC environment.
• Written Bash Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used Bulk processing for performance enhancement.
• Created UNIX shell scripts using SQL*Loader, SQL*Plus and PL/SQL programs that run as nightly interfaces.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Erwin 7.3,SQL Navigator, XML, Shell Scripting, SQL*Loader, Shell Scripting, SQL developer, Reports 10g/6i,CSS, DBMS JOB,UTL FILE,UNIX.