SUMMARY

• 9+ years of work experience in developing large - scale, high-performance multi-tier systems and web applications.
• 8+ years of hands on experience in SQL Server and ETL development, including MSBI suite (SSIS, SSRS) and scripting using C#.NET and VB.NET.
• 7+ years of experience, working as a consultant for Confidential .
• 5+ Years of onsite experience, working closely with business and clients.
• 3+ years with Java based application development.
• 2+ years experience with Talend development and administration.
• Expert knowledge in database design, data-warehousing principles and experience in using PL/SQL to write Stored Procedures, Functions, Triggers and very strong experience in writing complex queries in SQL Server, Oracle and DB2.
• Good hands-on experience in creating complex Talend jobs, creating custom components, deployment and administration through TAC.
• Experience in migrating SSIS and SAP DI jobs to Talend jobs.
• Good understanding of Hadoop based distributed systems, and processing using MapReduce.
• Hands-on experience optimizing and performance tuning in SQL Server.
• Experience in design and development experience in Java/J2EE technologies including JSP, Servlets, JDBC, JNDI and JMS.
• Experience in using RAD 7.0 & Eclipse IDEs and Websphere & Apache Tomcat webservers.
• Experience working in Unix/Linux environments and Shell scripting.
• Experience working with multiple web service protocols like JMS and SOAP and proficient knowledge and training in REST.
• Experience using JIRA, Remedy for Incident Management, Problem Management and Change Management
• Have good experience in offshore coordination, have handled team size of more than 10, and have good leadership skills.
• Excellent communication, interpersonal and presentation skills. Involved in multiple projects that were communication intensive.
• Fast learner and can adapt to new technologies quickly and implement in project.
• Certification on Sun Certified Java Programmer (SCJP 1.5)
• Certified Scrum Master from Scrum Alliance
• Good knowledge and experience in MS Access, MS Excel and MS Word VBA.
• Experience working on Citrix applications and Virtual Machines.
• Have good working knowledge of Waterfall model and agile methodology.
• Have experience using Version management tools like StarTeam, TFS, Stash, SVN, Microsoft VSS version control.
• Experience in using the Microsoft Visio and Microsoft PowerPoint presentation
• Good knowledge in Object Oriented Principles, Methodologies and Best Practices
• Worked with a CMMi Level 5 company all years, so have good knowledge of the process involved in the Software Development Life Cycle and have exposure to standards, procedures and documentation.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows 7, UNIX

Programming Languages: Java, JavaScript, Power Builder 9/11, Visual Basic 6, VBA for MS Office, PL/SQL, C#.NET, VB.NET, PERL, HTML

Database: MS SQL Server 2000/2005/2008/2012 (with DTS and SSIS), Oracle 9i & 10g, DB2, Microsoft Access XP/2010, Vertica, Netezza

J2EE Technologies: JDBC, JSP, Servlets, JMS, EJB, SOA Webservices, XML/XSLT

Version Control: StarTeam, TFS, Stash, MS Visual Source Safe, SVN

Tools: Remedy, JIRA, Calligo, Quality Center, Web Methods, TAC

Webservers: WebSphere 7.0, Apache Tomcat

IDE: MS Visual Studio 2005/2008, RAD 7.0, Eclipse, Talend Enterprise 5.3.1/5.6.1 , SAP Data Services (DI)

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Create and deploy new Talend jobs to extract data and from SAP and stage it in Netezza to be consumed by other interfaces.
• Migrate SAP DI jobs to Talend.
• Design the new database structure and optimize the existing queries, stored procedures for better performance.
• Design new interfaces to extract, transform/translate and process data between multiple systems.
• Install and setup TAC, and create new tasks in TAC for the new Talend jobs that are deployed.
• Migrate from the current Oracle Exadata server to Netezza database server.
• Enhancing the current system with new functionalities, performance tuning while the new system is in development.
• Work with the business team in finding the requirements for new interfaces.
• Work with the testing team in elaborating the requirements, reviewing the test cases and handing off the developed code.
• Release management, project planning, deployment planning and support.

Environment: Oracle 11g Exadata 11g, Talend 5.3/5.6, Netezza, Java, TAC, SAP DI, Unix, Subversion, JIRA, Agile.

Confidential

SQL Developer

Responsibilities:

• Design the new database structure and optimize the existing queries, stored procedures for better performance.
• Maintain existing SQL Server based applications, performance tuning and on call support.
• Create and deploy new Talend jobs for loading, validating, translating and grouping the incoming data.
• Install and setup TAC, and create new tasks in TAC for the new Talend jobs that are deployed.
• Migrate the existing SQL Server database to Vertica.
• Migrate the load and extract SSIS packages to Talend jobs.
• Enhancing the current system with new functionalities, performance tuning while the new system is in development.
• Enhance the existing SSIS packages with new functionalities, until the Talend jobs take in effect.
• Work with the product management team in finding the requirements for new retail customers.
• Work with the offshore team based on China, to dissipate the work, status check and integration of work.
• Work with the testing team in elaborating the requirements, reviewing the test cases and handing off the developed code.
• Educate the production operation team on the final application developments and enhancements.
• Release management, project planning, deployment planning and support.

Environment: SQL Server 2008 R2 (with MSBI), Oracle 11g, Talend 5.3/5.6, Java, TAC, Unix, PowerShell, Ant, StarTeam, TFS.

Confidential

SQL Developer

Responsibilities:

• Lead the Offshore team and served as a liaison between Offshore and Business.
• Involved in scoping the application requirement, creating design, functional specification and development for the new enhancements.
• Developed multiple SQL Server SSIS packages to download the renewal data from various Databases and DataMarts. The upstream system includes Oracle, DB2, Sybase DB.
• The SQL Server SSIS packages include the Scripts that were written with Java Script and C#.NET.
• Used PL/SQL to developed SQL Server Stored Procedures to do the data transformation, translation and massaging, after the download.
• Included the new business logic for new products added to the automated renewals in the MS Access databases that serves as the major part in the renewals.
• Made changes to the rating logic that is driven by actuarial spreadsheet, using the MS Excel VBA.
• Created MS Word Mail Merge documents and populated the customer data and created PDF packages.
• Used the StarTeam to maintain the project source code and do version management.
• Used Remedy to create, assign tasks and track the change request for release.
• Setup the application in Citrix to enable the application used by the Offshore.

Environment: MS Access XP/2010, Visual Basic 6, SQL Server 2000/2005 (DTS and SSIS), Oracle 10g, DB2 UDB, VBA for MS Access and Excel, Java Script, C#.NET, MS Word Mail Merge, StarTeam, Remedy, Citrix.

Confidential

SQL Developer

Responsibilities:

• Lead the offshore team and co-ordinate between business and offshore.
• Involved in developing new enhancements into the Java SOA Webservices that runs on Websphere 8.0 Application server.
• Worked on various enhancement in the application built in Power Builder that uses the webservices.
• Used IBM Message Broker to for Java webservices call from the Power Builder application to process the request from standalone application.
• Used the Remedy to create change tickets and assign tasks to the appropriate groups to support the development release.
• Worked on creating the FRD and TDD documents for the each of the project releases.
• Used Quality Center to create test cases and track them to closure.
• Used StarTeam as the Version Control System.

Environment: PowerBuilder 11, Java, J2EE, JDBC, JNDI, Websphere 8.0, SOA Webservices, RAD 7.0, XML, Power Builder 9, WCF, StarTeam, Remedy, Quality Center.