SUMMARY:

• Snaplogic Developer with 5+ total IT and 3+ years of experience analyzing specifications, designing, developing and managing pipelines to integrate various data sources and targets.
• 2+ year experience with Java technologies including Java/SE, J2EE, Spring, Hibernate, JSP, Maven, Git, SOAP and REST Web services, HTML/HTML5, CSS, JavaScript, Jquery.
• 5 years of experience with relational databases like Mysql, Oracle 11g, SQL Server and good knowledge of NoSQL data stores like Mongodb and Hadoop ecosystem.
• 2 years of proven experience designing, developing and managing columnar data stores like Amazon Redshift.

TECHNICAL SKILLS:

Integration Tools: Snaplogic and familiarity with Attunity replica, Informatica.

Languages: Java SE/EE, C, C++, SQL, Python, Shell, HTML, JavaScript, CSS, XML and JSON.

Databases: Amazon Redshift, PostgreSQL, MySQL, Oracle 11g, SQL Server and Mongodb.

Tools: and IDEs: Eclipse, STS, Maven, Gradle, SVN and Git.

Frameworks and API: MVC, Spring, MapReduce, Snaplogic API, SOAP/REST web services.

Platforms and Services: AWS, Workday, Salesforce.

PROFESSIONAL EXPERIENCE:

Confidential

Java/Snaplogic Developer

• Worked independently on designing, developing, deploying and monitoring pipelines to process large amount of data directly in Redshift using Copy commands from S3 for faster processing.
• Utilized Amazon S3 as a main storage for loading files.
• Developed auditing and error handling mechanism that stores data in a relational database.
• Collaborated directly with QA and other teams to identify issues and resolve them on a timely manner.
• Participated on biweekly standup Meetings to report progress and receive new tasks.
• Documented projects and debugging instructions according to company standards.

Confidential, Chicago, IL

Java/Snaplogic Developer

• Led team of two offshore developers on design, develop, manage and monitor pipelines to integrate Workday Financial Management and Human Resources data with SQL server Data warehouse and other sources/targets using Snaplogic Elastic Integration iPaaS.
• Participated in data analysis, requirement gathering and preparing requirement documentations process.
• Integrated both Financial management and human resources reports and transformed and cleaned as per requirements.
• Collected the company's social media pages (Facebook and Twitter) data into one for social analytics use.
• Utilized workday REST and SOAP API's, CSV files extracted to on - premise FTP server, and Snaplogic workday snap to collect reports.
• Worked with data warehouse team on designing and developing databases.
• Lead two offshore developers and worked closely with QA and data warehouse teams to identify issues/bugs and resolve them in timely manner.
• Utilized Microsoft Team Foundation Server(TFS) for Version Control.
• Participated on a daily standup and Sprint Planning Meeting.
• Prepared releases, documentations and led sprint deployment to QA and Production.
• Wrote python and shell scripts to perform operations or tasks that are currently not supported by snaplogic.
• Managed Snaplogic servers, pipelines and scheduled/triggered tasks.
• Documented projects and debugging instructions according to company standards.

Confidential, Manchester, NH

Snaplogic Developer/Data Integrator

• Designed, developed, managed and monitored pipelines to process FTO and e-commerce data using Snaplogic Elastic Integration iPaaS. Collected data from heterogeneous sources like flat files, Excel sheets, archives, Oracle and SQL Server databases, SOAP and REST services and loaded to Amazon Redshift and other SaaS.
• Processed and loaded billions historic and hundreds of millions daily incremental feed data to Amazon Redshift to be used by analytic team.
• Participated on daily and weekly meetings with team members and analytic team discussing data integrity between sources and target data.
• Generated reports, identified data integrity issues and worked with data vendors to get monthly restatement files to collect changes that was not captured on the daily feeds.
• Trained 2 employees on how to use Snaplogic integration tool, Amazon Redshift and related technologies, assigned tasks and managed one.
• Worked directly with stakeholders to gather requirements, design, develop and test pipelines for following amazon e-commerce orders through ChannelAdvisor's SOAP/REST services.
• Followed documentation, analyzed and understood pipelines and implemented new requirements on existing project that integrates on premise CRM with salesforce.
• Used Amazon S3 as a main storage for loading files and as backup storage Redshift snapshots and unload operations.
• Managed Snaplogic sidekick, users, projects and tasks.
• Configured Amazon Redshift cluster designed and created database, users, schemas, tables, views and other dependencies.
• Documented projects and debugging instructions to be used by all level developers.
• Worked directly with Snaplogic support team to debug and fix issues and wrote python and shell scripts that run using script snap to temporarily fix issues or missing functionalities like unzipping files and managing ftp files.

Confidential, Union, KY

Java Developer

• Worked on web application called Remall that allows users to manage appointments, communicate to their customers by sending scheduled emails, text messages, or connect and share information through social networks such as Facebook, Twitter and LinkedIn.
• Participated in requirement analysis, high and Low Level Design and full SDLC of the application.
• Implemented Spring MVC framework, N-tier architecture and participated in developing all three components of the application (Controllers, Services and Dao/Repositories)
• Worked with Spring Quartz and Spring Social to schedule text message and emails to the clients.
• Used TortoiseSVN to share code with offshore team and manage versions.
• Created Jar and War files Utilizing Maven as a main build tool and deployed into Apache Tomcat application container.
• Involved on testing, debugging and exception handling of the project using Junit, spring exception handling and log4j to generate logs.