SUMMARY

• Having 7+ years of IT experience working in Database/Data Warehousing Technology, Java Application development with web development skills.
• 6 years of experience in development and maintenance of SQL, PL/SQL, Stored procedures, functions, analytic functions, constraints, indexes and triggers.
• 2.5 Years of Experience in ETL development process using Talend for Data Warehousing, Data migration, Data Integration TAC and Production support.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inmon) - Star/Snowflake schema, SCD, Surrogate keys and Normalization/De-normalization, BI Intelligence/Analytics.
• Experience with SQL Developer database tools to query, test, modify, analyze data, create indexes, and compare data from different schemas.
• Expertise in designing and developing ETL using Talend, Hadoop, Hive .
• Experience in developing Extracting, Transforming and Loading (ETL) and full life cycle implementation of data ware house.
• Worked on Slowly Changing Dimensions (SCD's) to keep track of historical data.
• Experience in AngularJS.
• Experience in developing cross platform server side applications using Node.js to achieve scalability in real-time web applications.
• Hands on experience in version control tools GIT and SVN and package manager NPM and Bower.
• Good experience in working with Core Java, J2EE Based Applications, Servlets, JSP.
• Worked on concurrent package and Java Multithreading.
• Experience with backend techniques such as Java Spring MVC, Hibernate .
• Experience with IDE tools such as Eclipse, Net Beans and Sublime Text2 .
• Experience in using Software development methodologies such as Agile, Scrum workflow, Waterfall and SDLC.
• Strong experience in writing and updating the technical documents on daily basis with the changes made to the existing environment on daily basis.
• Excellent interpersonal abilities, communication skills, with ability to understand both technical and non-technical concepts, time management and Team skills with an intention to work hard to attain project deadlines under stressful environments.

TECHNICAL SKILLS

ETL/Middleware Tools: Talend 6.4, Hive, Hadoop

Data Modelling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension tables, Physical and Logical Data Modeling.

Database: Amazon Redshift, MySQL, Oracle 10g/9i, MS SQL Server, PostGresql, Mongo DB

Tools: Aginity Workbench for Amazon, TOAD, SQL Plus, SQL*Loader

Web Technologies: Spring, Hibernate, JSP/Servlet, Apache Tomcat, HTML/HTML5, CSS3

JavaScript Libraries: Angular.js, Node.js, Bootstrap, JQuery

Web Services: XML, JSON, AJAX, Restful API

Programming Skills: Core java, JAVA/J2EE, SQL, Oracle PL/SQL

Version controls: SVN, GIT, Rational Clear Case

Operating Systems: Windows 8/7/XP/NT/2x, Unix-AIX

IDE's: Eclipse IDE, Net Beans, Edit Plus, Citrix, Sublime text, WinSCP, Postman

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. ETL Developer

Responsibilities:

• Independent Responsible to build Enterprise Data Warehouse which include Credit card detail, Bankruptcy Data, Funded loan for Cogent from the Akcelerant and OSI source System, build the foreclosure module, Mortgage Data, Loan Application data, Case, Liability, Asset data, Finance Data etc Using Talend, Hive, hadoop, Sql Server, Oracle .
• Strong Knowledge on java to help the team member to manipulate the java object in the talend jobs and provide the appropriate solution to maintain the logs and handle the context variable in the Talend job .
• Deploying the Code in TAC(Talend Administrative Console ) and maintain the scheduling and provide production support .
• Attend meetings with business users to gather the business requirements and provide data
• Leading offshore team to understand the data and provide guideline for new requirement .
• Standardizing the code by doing code review.
• Work with other team members and co-ordinate data flow into the EDW.
• Develop and maintain Talend jobs for ETL Data load process.
• Perform Quality Assurance on the ETL code, Database objects, and help migrate it to higher environments like SIT and PROD.
• Provide end to end application support from the complete life cycle .
• Closely work with Data Modeler and do the data profiling .
• Staging layers and finally to downstream Enterprise Data Warehouse for the sources identified as flat file.

Environment Talend, MSSQL Server, Oracle, Hive, Hadoop, TAC (Talend Administrative Tool), Unix, Putty, WinSCP .

Confidential

Sr. Application Developer

Responsibilities:

• Analyze data requirements for the Project Customer 360 EDW to build Talend Jobs.
• Attend meetings with business users to gather the business requirements and provide data
• Accordingly without discrepancies.
• Work with other team members and co-ordinate data flow into the EDW.
• Develop and maintain Talend jobs for ETL Data load process.
• Perform Quality Assurance on the ETL code, Database objects, and help migrate it to higher environments like SIT and PROD.
• Staging layers and finally to downstream Enterprise Data Warehouse for the sources identified as flat file.

Environment Talend, MYSQL, Amazon Redshift, Tableau, SugarCRM, Aginity, Unix.

Confidential

Sr. Application Developer

Responsibilities:

• Analyze data requirements for the Project IAPP EDW to build Talend Jobs.
• Attend meetings with business users to gather the business requirements and provide data
• Accordingly without discrepancies.
• Work with other team members and co-ordinate data flow into the EDW.
• Develop and maintain Talend jobs for ETL Data load process.
• Perform Quality Assurance on the ETL code, Database objects, and help migrate it to higher environments like SIT and PROD.
• Interact with vendors to setup SFTP (Secure File Transfer Protocol)
• Staging layers and finally to downstream Enterprise Data Warehouse for the sources identified as flat file.

Environment Talend, MYSQL, Amazon Redshift, Tableau, Aginity, Sugar CRM, SVN

Sr. Java Developer

Confidential

Responsibilities:

• Make the Timesheet application project from the scratch and handle the complete database and data model design itself .Handle the complete responsibility of development, testing, deployment and give the demo and presentation to the senior team member.
• Responsible for Backend web applications using Spring MVC, Hibernate Restful services.
• Use Angular,js, JQuery Datatable framework to build-up most of the tables and grid lists and use its Datatable Editor to create, edit and remove deployment list.
• Perform backend development involving Java Spring MVC framework, Hibernate; Prepare HQL statements, for MySQL database; Tomcat as application server .
• Worked in scrum process attending daily stand up and completing tasks in sprints.
• Used SVN tortoise for file Management.
• Used the Jira tool for tracking the bugs and progress rate of the issues.

Environment Core Java, MYSQL, Spring MVC, Hibernate, Angular.js, MySQL, JavaScript, Ajax, JQuery, HTML, XML, Linux, Windows,, IDE- Eclipse, Source Control - SVN .

Confidential

Travel Port application

Responsibilities:

• Responsible for Backend web applications using Angular.js, Spring MVC, Hibernate Restful services.
• Use JQuery Datatable framework to build-up most of the tables and grid lists and use its Datatable Editor to create, edit and remove deployment list.
• Use Restful API services to fetch and post the data from the server side.
• Worked on travel domain to understand the complete concept on ticket booking and banking transaction system.
• Use Eclipse for Front-end IDE development tool.
• Perform backend development involving Java Spring MVC framework, Hibernate; Prepare HQL statements, for MySQL database; Tomcat as application server .

Environment Core Java 1.6, MySQL, Spring MVC, Hibernate, MySQL, Angular.js, JavaScript, Ajax, JQuery, HTML, XML IDE- Eclipse, Source Control - SVN .

Confidential

Java Developer

Responsibilities:

• Handle the complete responsibility of development, testing, deployment and give the demo and presentation to the senior team member.
• Responsible for Backend web applications using Spring MVC, Hibernate Restful web services.
• Prepare HQL statements, for MySQL database; Tomcat as application server .
• Used SVN tortoise for file Management.

Environment Core Java 1.6, MySQL,Spring MVC, Hibernate, MySQL, JSP, Servlet, JavaScript, Ajax, JQuery, HTML, XML, Linux, Windows, TCP IP IDE- Eclipse, Source Control - SVN .

Confidential

Responsibilities:

• Develop the LTE and WCDMA nodes for AT&T client.
• Work on the Confidential domain and understand the TCP IP, CDMA, WCDMA and LTE node cell and their implementation concepts.
• Work on import and export the network cell to CEX tool to monitor the network node and there cells.
• Make the presentation for importing the all types of nodes in different products.
• Worked in scrum process attending daily stand up and completing tasks in sprints and follow the Agile mythology.

Environment: Core Java 1.6, MySQL, TCP IP, OOPS, Spring Framework, XML, Linux, Windows, IDE- Eclipse Juno, Source Control - Rational Clear Case.

Java Developer

Confidential

Responsibilities:

• Develop a new product from scratch and handle the complete UI module of Android front-End.
• Worked on Android 2.2, 2.3 and 4.0 versions.
• Worked on core java, Java/J2EE framework and concurrent Api and OOPS concept.
• Client interaction and understand the client requirement and provide time to time demo to client and deliver the product on time.
• Used SVN for file Management.
• Handle the complete responsibility of UI bug fixing.

Environment: Java 1.6, Multithreading, MYSQL, SDK, ADT, core java, XML, Linux, Windows, IDE- Eclipse indigo, Source Control - SVN.

Confidential

Java Developer

Responsibilities:

• Worked on Android 2.2 versions.
• Worked on Java/J2EE framework and concurrent Api and OOPS concept.
• Use Eclipse for Front-end IDE development tool.
• Used SVN for file Management.

Environment Java 1.6, Multithreading, SDK, ADT, XML, Linux, Windows, IDE- Eclipse, Source Control - SVN. Core java, MYSQL.