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 the issues of complex software applications.
• Ability to migrate the 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 the 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 the requirement, proposed and implemented optimal solutions.
• Developed detailed design documents.
• Identified performance bottlenecks and provided resolutions
• Analyzed and documented the 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 the tables.
• Have received client appreciations for tuning the critical procedures.
• Created test scripts for unit, integration and user acceptance testing.
• Involved in performance testing.
• Involved in UAT and Post-production support.
• Prepared the 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 the badly written T-SQL stored procedures with a better logic.
• Created SSIS Packages to Extract, Transform and Load (ETL) the data into Reporting instance to generate the reports easily and quickly.
• Performance tuned the 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 the critical procedures.
• Created test scripts for unit, integration and user acceptance testing.
• Created test beds for performance testing.
• Analyzed the table data and table structure and created appropriate SQL Server indexes.
• Involved in purging of duplicate data to improve performance.
• Trained / documented the various performance tuning techniques and presented to the entire team.
• Involved in UAT and Post-production support.
• Prepared the implementation document.

Environment: SQL Server

Confidential, Tampa, FL

Senior Developer

Responsibilities:

• Worked closely with operations to understand the requirement, proposed and implemented optimal solutions.
• Developed detailed design documents.
• Identified performance bottlenecks and provided resolutions
• Analyzed and documented the 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 the requirement.
• Understanding and analysing the flow of existing jobs and implementing the 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 then to production environment.
• Performance tuned the 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 the script execution.
• Created noledge 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 the business needs.
• Developed detailed design documents.
• Analysed and documented the existing system.
• Understood and analysed the Sybase/ SQL Server code logic and implemented the same in Green plum Postgre SQL.
• Understood and analysed the flow of jobs and implementing the same in Greenplum PostgreSQL.
• Managed development efforts with offshore developers
• Debugged for logical bugs in Greenplum functions
• Enhanced existing Sybase applications as per the requirement
• Conducted Impact Analysis.
• Prepared Requirement Traceability Matrix document.
• Conducted Code Review with offshore developers
• Involved in code walkthrough meetings.
• Created noledge transfer documents
• Generating DB scripts to deliver the code to QA team and following up with the DBA team until the 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 the requirements from onsite team.
• Created a RTM
• Developed/Enhanced Sybase/ Oracle Stored Procedures.
• Debugged Sybase /Oracle Stored Procedures.
• Developed Shell scripts to minimize the manual efforts in the 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 the issues reported by the user and resolved as per the customer requirement without any impact within the 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 the on-site and off-shore teams.
• Created test case / test result documents for unit, integration and user acceptance testing.
• Involved in the 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 the issues reported by the user and resolved as per the customer requirement without any impact within the specified SLA.
• During the expansion of the 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 the critical jobs that were not meeting the service level agreement.
• As an Offshore Coordinator assigned tasks to team members and tracked their status and quality of work.
• Analysed the AS-IS business process and participated in the design for the TO-BE solution.
• Performance tuned the existing long running interfaces
• Trained the new team members based on the AS-IS documents
• Prepared Technical Specifications and Technical Support manuals.
• Involved in the monthly audit meeting.
• Conducted daily status meetings
• Estimated the project and adhered to the accepted time lines.
• Prepared Requirement Traceability Matrix (RTM) to ensure all functionality is being implemented.
• Involved in preparing the Unit Test Case documents.
• Analysed the client requirement and created views for generating adhoc reports.
• Prepared Shell/Perl scripts to automate the 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 the project status of the team on a weekly basis to Project Manager.
• During the expansion of the team have interviewed candidates for both offshore and on-site positions.
• Involved in the 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 the SRS (System Requirement Specification) preparation of extraction scripts for GREF4.1.
• Conducted requirement gathering workshops with super users.
• Analysed the AS-IS business process and participated in the design for the TO-BE solution.
• Planned and coordinated the development of new requirements in shell scripts with Informix as database.
• Monitored the enhancement for the conversion of all the existing Perl scripts and C programs to shell scripts.
• Coordinated development efforts with the offshore team.
• Worked as primary source of contact for production deployment.
• Involved in fixing the existing production issues.
• Prepared Requirement Traceability Matrix (RTM) to ensure all functionality is being implemented.
• Communicated the project status of the team on a weekly basis to Project Manager.
• Prepared the system appreciation documents, user guides and delivery notes
• Prepared the 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 the SDLC of the project including requirements gathering, analysis, design, development and testing
• Worked closely with clients to design and develop solutions that meet client requirements
• Involved in the process of database design for the entire application
• Involved in the development of House Keeping component using shell scripts and Informix.
• Have got client accolades for implementing the house keeping component within the given stringent schedules.
• Enhanced, maintained and developed the SQL codes to develop new enhancements.
• Coordinated development efforts with the offshore team.
• Involved in Unit and Integration testing of application.
• Communicated the project status of the team on a weekly basis to Project Manager.
• Prepared the system appreciation documents, user guides and delivery notes.
• Used Visual Source Safe for the version management of source code.
• Prepared the 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 the badly written stored procedures with a better logic.
• Performance tuned the existing long running stored procedures in Sybase ASE
• Have received client accolades for tuning the 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 the table data and table structure and created appropriate Sybase indexes.
• Trained / documented the various performance tuning techniques and presented to the entire team.
• Contributed to Cognizant's core training manual on Performance Tuning.
• Involved in UAT and Post-production support.
• Prepared the implementation document.
• Had been a part of the interview panel.

Environment: Sybase 12.5, Solaris