PROFESSIONAL SUMMARY:

• 11 years of IT experience in Database and ETL Analysis, Design, Development, documenting technical and functional specifications.
• Predominantly worked for Confidential clients and possess very good technical as well as business/domain knowledge. I have also worked in capacity of a Business Analyst.
• Extensive development skills in Sybase server (15.x & 12.x), ETL Tools (Informatica, Powerexchange CDC, IBM ICS and Pentaho), Data Virtualization (CISCO DVL), Unix shell scripting, Smartstream TLM (Transaction Lifecycle Management).
• Responsible for managing, development, business analysis, requirement gathering, providing the estimates for all the requirements.
• To analyze and resolve database performance issues. Tuned and optimized queries by altering database design/schema, analyzing various query options and indexing strategies.
• Well versed with Software Development Life Cycle (SDLC) and Agile model.
• Good at planning and organizing of project priorities, work towards achieving agreed objectives and quickly adapt to new technologies.
• Preparing SOP (Standard Operating Procedure) documents for Production support teams to be able to resolve the issues in a timely manner.
• Have been a part of multiple recruitment drives to help in acquiring right talent.

TECHNICAL SKILLS:

Programming languages: T - SQL, Unix Shell Scripting

Databases: Sybase 15.x/12.x, Sybase Replication Server, Oracle, SQL Server

Softwares: Smartstream TLM, RapidSQL, ER Studio, Visio, ASE-iSQL, Control-M, Putty, MS Office, ignite8, Service Now, AppDynamics, AutosysJIRA, Splunk

ETL Tools: Informatica, Powerexchange CDC, CISCO DVL, IBM Inter Change Server (ICS)Pentaho.

Domain: Confidential (Investment Banking & Credit Rating)

Version Control: APPM, Confidential Integrity Client, Tortoise Subversion

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead (Database, ETL & CDC Lead)

Technology: Power exchange CDC, Informatica Power center, SYBASE 15.7, Oracle, SQL server, Control-M

Responsibilities:

• Involved in gathering Client requirements, technical design discussions and there by producing technical specification documents.
• Assist Quality Assurance team by reviewing the test cases, providing technical details as appropriate. Participated in UAT by documenting test cases and testing the application.
• Assisting performance testing team and analyzing & resolving any performance Issues using tools like Ignite8 and AppDynamics.
• Participated in coding, testing, managing the deployment plan and ensuring a smooth deployment.
• Conducted meeting with cross functional teams and acted as a liaison between the clients, stakeholders and the development/test teams
• Supported in performance testing and tuning by providing the performance metrics, reviewing the results with optimized SQL queries.
• Investigate and resolve the production issues.

Technology: SYBASE 15.7, UNIX, Shell scripting

Tools: APPM Integrity Client, Putty, DB Artisan, ERStudio, ignite8 Composite DVL, Pentaho, Informatica

Confidential

Module Leader

Responsibilities:

• Involved in gathering Client requirements, technical design discussions and there by producing technical specification documents.
• Was part of Sybase upgrade project from Sybase 12.5 to Sybase 15.7 that entailed migration and testing of Sybase database objects in all testing phase (QA, UAT and Production)
• Participated in coding, testing, managing the deployment plan and ensuring a smooth deployment
• Assist Quality Assurance team by reviewing the test cases, providing technical details as appropriate. Participated in UAT by documenting test cases and testing the application
• Conducted meeting with cross functional teams and acted as a liaison between the clients, stakeholders and the development/test teams
• Supported in performance testing and tuning by providing the performance metrics, reviewing the results with optimized SQL queries.

Technology: SYBASE 15.0, UNIX, Shell scripting

Confidential

Senior Software Engineer (TLM, Sybase and Unix Developer)

Responsibilities:

• Building and maintaining reconciliations.
• Preparing Functional and Technical Design documents.
• Building, Testing and Reviewing reconciliations.
• Complete end-to-end TLM reconciliations development and configuration like generating KBs, creating passes, pass-list, initiation, dashboardsworkflow tool, etc.
• Investing breaks and mismatches as requested by business users.
• Working with various TLM components like Confidential Admin, Confidential Engines, Web Connect and Design Studio.
• Release management.
• Studying and gathering the requirements. Analysis & estimation of change requests.
• Development of code and enhancement as per the Technical Specifications.
• Create the Unit Testing scenarios for new developments & test the new interfaces.
• Knowledge transfer to many new joiners. Participating in project audits and briefing the audit team about the project.
• Timely execution of deliverables as per quality standards.

Technology: SYBASE 12.5, UNIX, Shell scripting, PERL

Tools: Smartstream’s TLM (Transaction Lifecycle Management), Subversion, Autosys, Informatica, Putty, DBArtisan, MS Visio, MS Office.

Confidential

Junior Software Developer (Java Programmer)

Responsibilities:

• Worked on Confidential library.
• Worked on Test Harness. Test Harness is used to test Confidential Library. Its function is to take Confidential message or object as input in the form of excel to invoke Confidential library, to write the output into an excel.

Technology: JAVA, XML

Tools: Eclipse 3.2, Subversion