Summary

• About 5.9 years' experience as a Senior ETL/Database/Java Support Analyst in all stages of the business software development life cycle SDLC , including analysis, design, development, testing, implementation Production-UAT support using ETL BI Pentaho, Talend, Informatica, Microsoft DTS , SQL Sybase, Microsoft SQL, Oracle , Core Java OOPS , Collections, Regex, JDBC
• Exceptional troubleshooting skills with ETL / Business Intelligence tools, Java Sybase T-SQL.
• Strengths: Production Support analysis, requirement analysis, enhancements, designing and strong customer interface, client services, consulting, debugging problem-solving attitude.
• Experience in Banking Finance Trading Risk , Insurance, Retail Hospitality tourism domains.
• Knowledge of JEE Technologies Spring Framework IOC, Hibernate, JSF, Web works , JavaScript, XML, LDAP, Web content management systems EMC Documentum - CMS .
• Excellent in client management inter-person management skills. Have ensured full client satisfaction through-out the carrier, by understanding and meeting client expectations.
• Efficient in meeting deadlines, without impacting deliverables. Ability to work on several projects concurrently, in a tight schedule.
• Excellent planning and organizational skills. Experience of leading module team/delivery management.
• Diligent work ethic with desire to succeed and make significant contributions to the organization.
• Always a self-learner and a good team player with strong personal and group communication skills.
• Service awards/ certification
• Received Tata Consultancy Service Ltd Service award, for commitment dedicated service of 5 years
• Received promotion from Tata Consultancy Service Ltd as IT Analyst.
• Sun Certified Java Programmer 1.5 with 84 , 2007

Technical Skills:

• Business Intelligence: Kettle-Pentaho's BI-ETL, SQL server DTS, XML transformations, Informatica 8.6 support Database: Sybase, SQL Server 2000
• Programming Languages Scripts: Java, UNIX Shell Scripts ksh/bash , SQL
• Tools Framework: Spring IOC, Spring MVC, Hibernate, Web Works, Dreamweaver, Build Automation: ANT IDE Reporting Tools: Eclipse 3.x, MyEclipse, NetBeans 4.0
• Content Management: EMC Documentum: Webtop Administrator, Content Server, Business Process Manager, Alfresco Web content management Application/Web Servers:, Apache, Tomcat 5.x/4.x
• Version/Source Control Systems: Microsoft VSS, IBM Clearcase Subversion SVN , CVS.
• O/S Environment: Windows 7/Vista/XP/2000/NT, Win 2k Server, Sun Solaris 8, UNIX, and Linux.
• Familiar with: JSF, JNDI, ORM, Spring Framework: IOC, AOP, DAO, ORM, Spring Web MVC, Java script - DOM4J, C, Microsoft IIS, Web Logic, IBM WebSphere, Oracle, MySQL, Junit

PROFESSIONAL EXPERIENCE

Confidential

Consultant Support Analyst lead

Technologies/Tools: J2EE JSP, Spring , UNIX Shell scripts, Sybase Oracle SQL, Sun Solaris based Unix environment, Clearcase, FX Option Trader, TRML, Harmony Traiana

Responsibilities/

• Front office support for Prime Brokerage FOREX Trading of derivatives like Cash Forward, SPOT, SWAP, NDF Options.
• Supporting client traders, client service transition teams on-boarding support for new clients, serving as single point of contact between clients SPOKE by supporting FX trade capture for prime broker system.
• Production - UAT Support, Enhancements, development management of FX derivatives trading system.

Confidential

Module lead, Production Support Analyst

• Description: Support, enhancements, development management of various Risk management system across Production/ UAT environments, such as
• Market Risk Global FX, Commodities, Back office support, Phoenix Market Risk, Equities Fixed Income Management system based on position acquisition, Value at risk calculation and reporting , MRS Market Risk Suite , MUREX, FX Opt ions Risk Calculator , Specific Risk, Commodity Markets, Futures, FOREX,
• Credit Risk HFAD Hedge Funds , RFAD Regulated Funds , FlaRE Flash Reporting , IRisk Issuer's risk , Common Positions Data, Equities, Hedge Fund Management System, Limits Management System, Historical Simulation Automatically processes delivery of Hypothetical PL and Scenario Ten Day Reporting system provides Risk Managers a Ten Day view of Dear Stress from Risk data mart with ability to slice dice
• Technologies/Tools: SQL Server DTS, SSIS, UNIX Shell scripts, Sybase SQL Server PL/SQL, Sun Solaris based Unix, Pentaho Kettle BI, Windows 200x servers, Log4j, ClearCase, Autosys, DBArtician, Pikachu, Java, J2EE Spring, JDBC, JNDI , Apache Ant, XML, Maximo, JIRcoA

Responsibilities/

• Led onsite-offshore team of 5 members to support back-office users/clients all above Market risk systems
• Responsible for customer interaction verification of risk numbers for risk managers using risk management tools.
• Supported hourly 24x7 batch - ETL pipe load from Sybase to Netezza data warehouse. Provided support for cube based slice dice reporting. Supported Unix based automated batch processes
• Interfaced between different Technology/business groups such as - data warehouse admins, ETL COE group, Informatica development team, DBA, UNIX admin groups, Vendors customers - for remediation of issues across Production, UAT, DEV environments also release management.
• Developed solid relationships with infrastructure teams and leveraged that to improve system stability availability.
• Worked on various POC, proposals RFP involving use of Java -ETL tools like Informatica Alfresco web content management.
• Release management using JIRA, Clearcase Maximo, following through standard bank software engineering process.

Cost savings:

• Developed SQL server DTS Transformation packages jobs - to facilitate automated archival transformation between various data inventories resulting cost savings of 480 hours person hours/year
• Development of ETL transformations using Pentaho Kettle for automated archival of feed files.
• Developed and enhanced stored procedures in Sybase. Created UNIX shell scripts Autosys jobs to automate manual processes.
• Enhancement development of 10 Day Risk reports using VB6 and the .net framework.
• Database Capacity management. Various value-additions contributed to business support team by automating DB archival, automating file archival jobs creating re-usable services.

Confidential

Module Lead analyst developer, web content management

• Technologies/Tools: Java, J2EE, Webworks, Documentum Query Language, Documentum Content Server 6, Documentum Webtop, Documentum Administrator, Documentum Foundation Services, J2EE Application Development Framework, Various Oracle products for identity management content management
• Responsibilities/
• Led Analysis development efforts for Fannie Mae's in-house Content Management System, TRAX , which provides functionality for the objectives of loan approval Credit Loss Management.
• Enhance and optimize current manual processes by TRAX- Valuation Engine - using the J2EE Application Development Framework, Documentum and numerous Oracle products for identity content management.
• Led research on various possible SSO approaches which includes Design of Security Generic component with the team of 2 resources.
• Responsible for designing generic Documentum view solution for all CLM/Valuation applications.
• Involved in requirement gathering responsible for deliverables of Documentum.
• Participation in Documentum generic SSO solution for document view functionality/proposal.
• Involved in designing DFC based Documentum services content Index server

Confidential

Team member, offshore support enhancements

• Technologies: Java, J2EE, JSP, Webwork, Documentum Query Language
• Special Software Tools: Documentum Content Server 5.3 SP5, Documentum Webtop, Documentum Administrator, Documentum Media Services Digital Asset Management, VPN, Citirx Metaframe, MS Remote Desktop, Quality Center, Samson, Intellij IDEA, Oracle 9i, Apache Tomcat 5.x/4.x, e-Room solution.

Role/Responsibilities:

• Supported Brand Marketing and the Content Creation Management team, through collaborative platform BrandNet Exchange , which was used for creation of initiatives, storage and management of digital assets, document management, meta-data archival initiative, workflow report management of all such activities.
• Involved in enhancement providing new functionality to users of NIKE.
• Responsible for KLO-bug support including improvement of performance of existing search functionality.
• Troubleshooting of customized Webtop. Enhancements using DFC Documentum Foundation Classes
• Leveraged Business Process Manager for document workflow, along with Content Index server
• Remediated performance related issue with content index server by troubleshooting DFC Java code
• Involved into SOW related work for other clients with similar requirement like United Airlines .
• Coordinating with onsite team, weekly status meetings with customer process documentation
• Worked with a team to manage development of new components, maintenance performance optimization of the existing BrandNetX Application.
• Implemented enhancements per client requirement. Generated reports stories to add on WIKI of NIKE.

Confidential

Associate developer team-member Business Intelligence research team

• Technologies: Java, J2EE, JSP, JSF, SPRING, HIBERNATE, HQL, SQL, XML based ETL transformations, Windows XP Windows Vista, Oracle 9i, JDBC, JNDI
• Tools: Pentaho Kettle ETL, PL-SQL, J-Unit, IBM Webshere, Apache Tomcat, IBM WID

Role/Responsibilities:

• Provided Profuturo with high-quality services, as well as the timely and efficient management of information.
• Involved in requirement validation - specifically ETL Business Intelligence use case.
• Involved in validation-enhancements of various artefacts like SRS Software requirement specification , SDD Software Design Document, Activity Diagrams and Class diagrams.
• Coordinated with onsite team for requirement design understanding.
• Carried out ETL transformation their integration as dedicated resource for all the modules.
• Suggested implemented the best practice in the various complex scenarios.

Achievements:

• Became a senior developer/ member of Open source Kettle- ETL at Pentaho's official blog
• Involved in development phase of project. Was a specialized resource for
• Development of re-usable XML transformation using ETL Kettle Talend
• ETL transformations Integration into application Database related operations.
• Implementing re-usable business services dealing with Different File's Value Objects
• Responsible for making prototype of the new system with basic framework of modules: Teller De Productos, Cuentas Certifacion Seguros. Created test cases did unit testing of use cases developed by me.
• Undergone a rigorous initial corporate training program for first 2 months - for corporate development.

Confidential

Lead consultant, designer developer.

Technologies/Tools: Core Java, ASP.Net, HTML, JavaScript, Macromedia Dream weaver, Flash website builder, Adobe Photoshop, Microsoft FrontPage Publisher, 3d Software, Analysis Tools, Visual Studio 2005

Role/Responsibilities:

• Proposed a project to Mayor of city counsel. Worked with development officials to capture the requirements.
• Involved in requirement collection, digital asset management doing photography of tourist attraction/spots.
• Responsible for all client interactions: performed website design, photo-editing development at client site
• Also offered post deployment support maintenance for 2 months, as part of the package.

Confidential

Technologies Tools: Asp.net 1.1 , JavaScript, Oracle 9i, ODPNet, Macromedia Dream weaver,

Flash website builder, Microsoft FrontPage Publisher, 3d Software, analysis Tools, Visual Studio 2005 Beta 2.0

Role/Responsibilities:

• Responsible for development phase of Employee management portal Leave, salary record management
• Worked on Jury assessment system, in which artist-students could submit their digital assets, which later could be reviewed by Juries artists across the globe to provide grades to students.
• Interaction with the officers of NID for requirement gathering, validation design.
• Performed design development of web portal database design also Digital asset gathering.