SUMMARY

• Ten plus years of versatile IT experience as a Team Lead/Technical Lead/On - Site Coordinator/Senior Developer / Developer
• Managed up-to a team of 10 programmers.
• Expert in Sybase Stored Procedures, Views, Triggers, and Sub-Queries development.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL Server.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Over 2+ years of experience with MPP (Massive Paralleling Processing) systems like Greenplum.
• Experience in Greenplum functions, sub-queries and views creation.
• Expert in frame work development using shell scripts.
• Expert in existing stored procedures analysis, performance tuning and troubleshooting teh issues of complex software applications.
• Ability to migrate teh code from one database to other such as Sybase to Green plum.
• Designed Reports with Crystal Report.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Extensively worked in AIX/Solaris.
• Well conversant in detailing functional specification.
• Extensive experience in Test: Planning, Execution and Co-ordination.
• Excellent communication and presentation skills.
• Completed multiple projects successfully, meeting time and delivery requirements
• Worked very closely with Users/ Clients coming from various levels of an organization paying utmost attention to details
• Delivered multiple enhancement objects adhering to change control and change management as defined.
• Performed post release reviews and support jointly with teh users.
• Results oriented professional with a positive attitude

TECHNICAL SKILLS

Programming Languages: C, SQL, E-SQL C, Perl, Shell scripting.

Database: Sybase ASE, Oracle, SQL, Informix, SQL Server

Data warehouse: Green plum, Sybase IQ

ETL Tools: SSIS

MS Packages: MS Excel, Power Point, VISIO, Outlook, Word.

OS: AIX, Solaris, Windows Vista / XP / 7.

Reporting Utilities: Crystal Report XI, SSRS

Version Control Tools: MS Visual Source Safe (VSS), Clear case

PROFESSIONAL EXPERIENCE

Confidential, Wayne, NJ

Senior Developer

Environment: Oracle

Responsibilities:

• Worked closely with operations to understand teh requirement, proposed and implemented optimal solutions.
• Developed detailed design documents.
• Identified performance bottlenecks and provided resolutions
• Analyzed and documented teh existing system.
• Developed/Enhanced Oracle Stored procedures
• Conducted Impact Analysis.
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
• CreatedOracle PackagesandProceduresto automatically drop table indexes and create indexes for teh tables.
• Have received client appreciations for tuning teh critical procedures.
• Created test scripts for unit, integration and user acceptance testing.
• Involved in performance testing.
• Involved in UAT and Post-production support.
• Prepared teh implementation document.

Confidential, Mclean, VA

Senior Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.
• Recommended resolutions ensuring optimal performance.
• Revised teh badly written T-SQL stored procedures with a better logic.
• Created SSIS Packages to Extract, Transform and Load (ETL) teh data into Reporting instance to generate teh reports easily and quickly.
• Performance tuned teh existing long running stored procedures in SQL Server.
• Developed ad hoc and customized reports using SQL Server Reporting Services (SSRS).
• Have received client appreciations for tuning teh critical procedures.
• Created test scripts for unit, integration and user acceptance testing.
• Created test beds for performance testing.
• Analyzed teh table data and table structure and created appropriate SQL Server indexes.
• Involved in purging of duplicate data to improve performance.
• Trained / documented teh various performance tuning techniques and presented to teh entire team.
• Involved in UAT and Post-production support.
• Prepared teh implementation document.

Environment: SQL Server

Confidential, Tampa, FL

Senior Developer

Responsibilities:

• Worked closely with operations to understand teh requirement, proposed and implemented optimal solutions.
• Developed detailed design documents.
• Identified performance bottlenecks and provided resolutions
• Analyzed and documented teh existing system.
• Developed/Enhanced SQL Server Stored procedures
• Developed Functions in Greenplum.
• Debugged for logical bugs in stored procedures
• Enhanced existing SQL Server/Green plum applications as per teh requirement.
• Understanding and analysing teh flow of existing jobs and implementing teh same in Greenplum PostgreSQL.
• Modified existing ETL processes to improve performance and adapt to changing requirements
• Conducted Impact Analysis.
• PreparedETLmapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and tan to production environment.
• Performance tuned teh existing long running interfaces using show plan and internal tools.
• Analyzed scenarios causing deadlocks and provided resolutions
• Involved in purging of unwanted data to improve performance.
• Developed Autosys scripts to automate teh script execution.
• Created knowledge transfer documents
• Tested deliverables for conformance with requirements and specifications, including Unit, Module, Integration System testing, Regression Testing and User Acceptance Testing.
• Provided post go-live support

Environment: Green plum, SQL Server

Confidential, Tampa, FL

Developer / On-site Coordinator

Responsibilities:

• Worked closely with business to gather / analyse necessary requirements by conducting requirement gathering workshops and identified effective uses of technology to meet teh business needs.
• Developed detailed design documents.
• Analysed and documented teh existing system.
• Understood and analysed teh Sybase/ SQL Server code logic and implemented teh same in Green plum Postgre SQL.
• Understood and analysed teh flow of jobs and implementing teh same in Greenplum PostgreSQL.
• Managed development efforts with offshore developers
• Debugged for logical bugs in Greenplum functions
• Enhanced existing Sybase applications as per teh requirement
• Conducted Impact Analysis.
• Prepared Requirement Traceability Matrix document.
• Conducted Code Review with offshore developers
• Involved in code walkthrough meetings.
• Created knowledge transfer documents
• Generating DB scripts to deliver teh code to QA team and following up with teh DBA team until teh completion of delivery of code.
• Created test scripts for unit, integration and user acceptance testing.
• Provided QA and UAT support
• Used Clear Quest for issue tracking/resolution
• Provided post go-live support

Environment: Greenplum, Sybase 15.0.1, AIX 6.1,SQL Server

Confidential

Offshore Team Lead

Responsibilities:

• Developed detailed design documents
• Managed development efforts based on teh requirements from onsite team.
• Created a RTM
• Developed/Enhanced Sybase/ Oracle Stored Procedures.
• Debugged Sybase /Oracle Stored Procedures.
• Developed Shell scripts to minimize teh manual efforts in teh application.
• Conducted Impact Analysis during Sybase/ Oracle enhancement.
• Created test scripts for unit, integration and user acceptance testing.
• Provided QA and UAT support.
• Used Clear Quest for issue tracking/resolution
• Updated project related trackers, status reports and business related documents.
• Took end to end ownership of teh issues reported by teh user and resolved as per teh customer requirement without any impact within teh specified SLA.

Environment: Sybase 15.0.1, AIX 6.1, Shell Script, Oracle

Confidential

Offshore Technical Lead

Responsibilities:

• Conducted requirement analysis and developed detailed design documents
• Developed/Enhanced Oracle Stored Procedures.
• Debugged Oracle Procedures/Functions.
• Conducted Impact Analysis.
• Mediated between teh on-site and off-shore teams.
• Created test case / test result documents for unit, integration and user acceptance testing.
• Involved in teh monthly audit meeting.
• Provided QA and UAT support.
• Used Clear Quest for issue tracking/resolution
• Updated project related trackers, status reports and business related documents.
• Took end to end ownership of teh issues reported by teh user and resolved as per teh customer requirement without any impact within teh specified SLA.
• During teh expansion of teh team have interviewed candidates for both offshore and on-site positions.

Environment: Oracle / AIX 6.1

Confidential

Offshore Team Lead

Responsibilities:

• Managed a team of 10 programmers and provided quality code before deadlines
• Have received client appreciations for tuning teh critical jobs that were not meeting teh service level agreement.
• As an Offshore Coordinator assigned tasks to team members and tracked their status and quality of work.
• Analysed teh AS-IS business process and participated in teh design for teh TO-BE solution.
• Performance tuned teh existing long running interfaces
• Trained teh new team members based on teh AS-IS documents
• Prepared Technical Specifications and Technical Support manuals.
• Involved in teh monthly audit meeting.
• Conducted daily status meetings
• Estimated teh project and adhered to teh accepted time lines.
• Prepared Requirement Traceability Matrix (RTM) to ensure all functionality is being implemented.
• Involved in preparing teh Unit Test Case documents.
• Analysed teh client requirement and created views for generating adhoc reports.
• Prepared Shell/Perl scripts to automate teh process.
• Supported for QA and UAT Testing.
• Used Clear Quest for issue tracking/resolution
• Provided Post-Production support.
• Used VSS (Visual Source Safe) extensively to maintain documents and codes.
• Communicated teh project status of teh team on a weekly basis to Project Manager.
• During teh expansion of teh team have interviewed candidates for both offshore and on-site positions.
• Involved in teh estimation of new project proposals.

Environment: Sybase 15.0.1, AIX 6.1, Shell Scripts, Perl

Confidential

Offshore/Onsite Module Lead/Team Lead

Responsibilities:

• Managed a team of 5 programmers and provided quality code before deadlines
• Participated in teh SRS (System Requirement Specification) preparation of extraction scripts for GREF4.1.
• Conducted requirement gathering workshops with super users.
• Analysed teh AS-IS business process and participated in teh design for teh TO-BE solution.
• Planned and coordinated teh development of new requirements in shell scripts with Informix as database.
• Monitored teh enhancement for teh conversion of all teh existing Perl scripts and C programs to shell scripts.
• Coordinated development efforts with teh offshore team.
• Worked as primary source of contact for production deployment.
• Involved in fixing teh existing production issues.
• Prepared Requirement Traceability Matrix (RTM) to ensure all functionality is being implemented.
• Communicated teh project status of teh team on a weekly basis to Project Manager.
• Prepared teh system appreciation documents, user guides and delivery notes
• Prepared teh production roll out plan and scripts.
• Involved in estimating of new project proposals.
• Interviewed candidates for both offshore and on-site positions.

Environment: Informix, Solaris, Shell Script, Perl

Confidential

Onsite Module Lead

Responsibilities:

• Involved in teh SDLC of teh project including requirements gathering, analysis, design, development and testing
• Worked closely with clients to design and develop solutions that meet client requirements
• Involved in teh process of database design for teh entire application
• Involved in teh development of House Keeping component using shell scripts and Informix.
• Have got client accolades for implementing teh house keeping component within teh given stringent schedules.
• Enhanced, maintained and developed teh SQL codes to develop new enhancements.
• Coordinated development efforts with teh offshore team.
• Involved in Unit and Integration testing of application.
• Communicated teh project status of teh team on a weekly basis to Project Manager.
• Prepared teh system appreciation documents, user guides and delivery notes.
• Used Visual Source Safe for teh version management of source code.
• Prepared teh production roll out plan and scripts
• Worked as primary source of contact for production deployment.

Environment: Informix, Solaris, Shell Script, Perl

Confidential

Senior Developer

Responsibilities:

• Revised teh badly written stored procedures with a better logic.
• Performance tuned teh existing long running stored procedures in Sybase ASE
• Have received client accolades for tuning teh critical procedures.
• Developed a shell script that would generate a report of long running stored procedures.
• Created test scripts for unit, integration and user acceptance testing.
• Created test beds for performance testing.
• Analyzed teh table data and table structure and created appropriate Sybase indexes.
• Trained / documented teh various performance tuning techniques and presented to teh entire team.
• Contributed to Cognizant's core training manual on Performance Tuning.
• Involved in UAT and Post-production support.
• Prepared teh implementation document.
• Had been a part of teh interview panel.

Environment: Sybase 12.5, Solaris