PROFESSIONAL SUMMARY:

• 5 Years of IT experience in all phases of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance for Integration related projects.
• 3 Years of experience in Integration development using Dell Boomi (Simple Shapes Set Properties (Dynamic Document Property, Document Property, Process Property, Dynamic Process Property), Program Command, Notify . Conditional Shapes Decision, Route, Business Rules, Try/Catch, Branch Shapes Branch, Connectors FTP, SFTP, Disk, RDMS Database, Database, AS2, Webservice, MQ (Active MQ), Salesforces Data Modification Shapes Map, Message, Load from Cache, Data Process Shape Data Process, Path Completion Shapes Stop, Exception, Add to Cache, Connector .
• Experience in creating Boomi EDI profiles (EDI Mapping, EDI Identifier Instance) EDI - 850 Purchase Order, XML, JSON, Flat Files and Database Profiles.
• Excellent experience in creating Boomi Mapping EDI Profile - XML Profile and XML Profile - EDI Profile
• Involved in Boomi Deployment process in Test and Production environments, set up Boomi extensions, Manual Execution, Batch Create Schedule to execute on specific schedule
• Closely working with Administrators to setup Boomi Atom, Database Instances (Schema, Connections), MQ Instances, Webservice Security setup.
• Having One Year of experience as a SQL developer and involved in database design, development and administration with Microsoft SQL Server 2014/2012/2008/2005/2000 using SQL Server Integration Service (SSIS) in Finance, Banking and Healthcare domains.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP).
• Implemented Data Modeling and deploying with STAR and SNOWFLAKE techniques using Erwin in Data Mart.
• Worked on developing address standardization, exception handling, and data masking on informatica and also worked on existing systems, application and technology standards.
• Very much comfortable in analyzing, debugging, troubleshooting and solving problems in application.
• Highly motivated and a self-starter with effective communication and organizational skills, combined with attention to detail and business process improvements.
• Committed to excellence, highly self-motivated, self-motivator, fast-learner, team player, ability to deal with people diplomatically and a prudent developer with analytical and strong problem-solving skills with excellent communication

TECHNICAL SKILLS:

Integration / ESB: Dell Boomi (Atom Version 19.03.0)

Tools: Soap UI and Postman

Languages: Transact SQL, PL/SQL, Java Script, HTML.

Databases: SQL Server 2016/2014/2012/2008/2008 R2/2005/2000R2, MS Access, Oracle 9i, Oracle 10g, 11g, MySQL, DB2

ETL Tools: DTS, SSIS, Data Stage, Informatica, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports 8.5/9/10/11

Data Modeling Tools: Erwin, Microsoft Visio 2000/2003, ER Studio

Operating Systems: Windows NT/2000/XP Pro/Vista, Windows Server 2000/2003/2008, Linux, Unix

Version Control/Utilities: CVS, SVN and GIT Hub 2.12.0, JIRA, Citrix

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Boomi Integration Developer

Responsibilities:

• Working as a Dell Boomi Integration Consultant to identify, analyze, develop, test, and implement integration processes using Dell Boomi platform including Connectors, Design Center and Java API management.
• Worked with Administrators to set up Atom, Molecule, Database Instances (Schema, Connections), MQ Instances, MQ Instances Load Balancer (Master and Slave), HTTP Load Balancer for web services, Web service Security setup (IBM DataPower).
• Experience in Setup Trading Partners Standards (X12), X12 Standard Configuration (ISA and GA), Communication (FTP, SFTP, Disk), Registered Document Type for Acknowledgement.
• Process Deployment and Execution: Deploy process in Test and Production environments, set up Boomi extensions, Manual Execution, Batch Create Schedule to execute on specific schedule, Event-Driven Real-Time Integration Webservice, Listeners.
• Developed Multiple Interfaces for the Success Factor Integration with SOAP, REST, XML, WSDL, XSD, UDDI and JSON profiles in Dell Boomi.
• Worked on Dell Boomi Connectors like FTP, Mail, Database, Salesforce, Web Services Listener, HTTP Client, Web Services SOAP Client, SuccessFactors, Trading Partner.
• Dell Boomi API Management: Excellent experience in creating SOAP and REST Webservices, publish and centrally manage APIs on-premises or in the cloud.
• Used Boomi and Internal framework to notify, generate service tickets and retry 'process documents' if any exception occurs in the Boomi Process.
• Used Boomi and Internal "Rule Engine and Cross Reference Frameworks" to meet the business requirements in this area.
• Designed and Developed Boomi Integration flow for Employee data and payroll data from Success Factors to the Legacy System.
• Extensively worked with Flat files such as .CSV, XML by configuring FTP creations in Dell Boomi.
• Worked on solving and maintaining interface issues between Boomi, SAP and Salesforce. Also monitored the process logs to check for any errors
• Integrated Database with Boomi and written SQL Query and Stored procedures.
• Worked with Dell Boomi integration technology for the proposed architecture of integration processes.

Environment: Dell Boomi, web services, XML, Microsoft Dynamics 365, AWS S3 bucket.

Confidential, Austin, TX

Boomi Developer

Responsibilities:

• As an Integration Developer in Confidential, My Roles and Responsibilities to work with Integration SME team to provide best solutions by understanding current systems, applications. Services to identify and decide data communication channel (HTTP, FTP, SFTP), data formats (EDI, JSON, XML) and data audit & security.
• We are using Dell Boomi ESB for all integrations with different services to meet business requirements.
• Please see below a few which I used Boomi components.
• Boomi Process Start Shape: Data Passthrough, No Data
• Boomi Connectors: Disk, FTP, HttpClient, JMS, Webservices Soap Client and other connectors.
• Boomi Actions: I used different actions and operations for above connectors.
• Boomi Webservices Consuming: I created Webservice client to send information to Services.
• Profiles: EDI, Webservices, XML, Database
• Map: EDI - XML, XML - EDI, XML - Database
• Scripting: JavaScript, Groovy

Boomi Developer

Confidential

Responsibilities:

• Worked with Technical Architects and Integration Enterprise Technical Architects for the Design integration process.
• Understand business requirement, Involved in Identify data communication channels and data formats.
• We are using Dell Boomi ESB for all integrations with different services to meet business requirements.
• Used various properties in Boomi such as Process Properties and Document Properties to modify the files being picked from Salesforce according to the requirement.
• Identified, analysed and developed interfaces and Integration flows using Dell Boomi Event-based integration, Connectors, Atmosphere Java API.
• Understand and Follow the Boomi Guidelines and standards for individual process.
• Created common folder and create & keep all common connections in this folder.
• Created common process to provide Audit, Exception and Re-Try Mechanism.
• Split orders information based on Orders Request using Data Process based on profile.
• Involved in EDI - 850 Purchase Order to send information to Database.
• Created JMS process to send and receive Active MQ messages.
• Involved in Build Mapping components (EDI - XML, XML - JSON, Database - JSON).
• Created environment extensions, schedule process and created document tracking variables.
• Involved in infrastructure setup for this total integration process.
• Created cross reference table in Boomi product codes.
• Monitor the Boomi processing log for any errors to reprocess.
• Involved in Setup Boomi extensions, Deployment Process and Monitor Boomi processes.
• Closely work with testing team for Integration testing.

Environment: Boomi Atom (19.03.0), Java Applications

Confidential

SQL Server (SSIS) and Integration Developer (Dell Boomi)

Responsibilities:

• Collected business requirements from analyst and translated them as technical specifications, designed database and documents for development.
• Involved in Boomi Integration process to send enrollment application Florida Blue Gateway to enrollment application.
• Involved in develop Boomi process to access Assign Contract ID, Rate Engine and Agent application Webservices to collect information from these services.
• Used Boomi Map functionality to transform EDI to XML Data.
• Hands on experience in installing, configuring, managing and monitoring SQL Server 2000 to 2014 Servers. Involving in new SQL Server builds on Cluster servers along with the pre-and post-steps and patching on standalone servers.
• MS SQL Server installation, configuration, performance tuning, client/server connectivity configuration, query optimization, back-up/recovery and database consistency checks using DBCC.
• Worked on High Availability technologies log-shipping, failover clustering management, database mirroring.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2012using SSIS.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.
• Generated parameterized queries in SSRS 2008/2012/2014 using data from SSAS Cubes and various heterogeneous data sources.
• Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers of strategic planning.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Designed and developed the user interface using JavaScript, and XHTML

Environment: Dell Boomi, SQL Server 2014/2012, Oracle 10g, SSIS (2014/2012/2008 ), Visual Studio 2010/2013, PL/SQL, MS Excel 2010, Power BI, (Framework Manager, Report Studio, Query Studio, Analysis Studio, Connection)

Confidential

Python SQL Developer

Responsibilities:

• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from with the help of SSIS Business Intelligence Development Studio.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Writing REST APIs, as part of developing web-based applications for insurance premium calculations, using Django’s REST framework.
• Heavily leveraged Python’s graphics APIs for creating graphics & serialization libraries for encoding data in XML/JSON formats.
• Responsible for configuring NoSQL databases like Apache Cassandra and Mongo DB to for increasing compatibility with Django.
• Designed and created backend data access modules using PL/SQL stored procedures.
• Good experience in writing SQL Queries and implementing stored procedures, functions, packages, tables, views, cursors, triggers.

Environment: Microsoft SQL Server 2005/2008 R2 Enterprise edition, SSAS, SSIS, SSRS, BIDS, Microsoft Visual studio, Windows server 2003, Internet Information Server (IIS), MS Excel 2007