Summary

• Having 13 years of experience in IT industry with extensive skill set dedicated to business and systems analysis, data modeling, client - server and web-enabled systems.
• Expertise in Oracle 11g/10g/9i/8i/7.x, SQL server 2008/2012 with experience in SQL, PL/SQL, T-SQL, Web PL/SQL, Jobs, Triggers, and Stored Procedures and Packages, SQL Loader, ETL, Datastage, Database Application Tuning, Shell scripts, SSIS, SSRS, Perl scripts, Developer suit Forms, Reports , Microsoft SQL Report.
• Worked as a Junior DBA to Set up New Database Instances, New users, s, grants and privileges on objects according to business. Backup databases regularly and restore to recover lost information or refresh lower environment by migrating from different environment.
• Exposed to Datastage, Informatica, APEX, PHP, Perl, Python, CGI, OCI, HTML, DHTML, ASP, C, COBOL, VB scripts, Java, JavaScript, JSP, PostgreSQL.
• Expertise in VMWare, Virtual Box installing and configuring.
• Experienced in all stages of the software life cycle functions requirements gathering, analysis, design, development, test and implementation. Prepare technical specification, develop project plans and schedules.
• Managed large projects with time management, issue resolutions, setting priorities. Ability to handle a Team, maintaining team synergy which leads to meeting the deadlines effectively.
• Acquired proficiency in all key aspects to provide Systems and on-call Support.
• Good communication, interpersonal and presentation skills. Excellent work ethics, self-motivated and quick learner. Willing to learn, adapt new technologies and third party products.
• Sound Knowledge in Quality Management System.
• Experience in using Visual Source Safe, Clear Case, CVS and SVN.

Skill Set

• Operating Systems Linux/Unix/AIX, Windows95/98/2000/NT/XP/Vista/Win7,
• VMWare, VirtualBox Installation and configuration
• RDBMS Oracle 11g/10g/9i/8i/7.x, 10g RAC, SQL Server 2008/12, DB2 and Ms-Access
• Languages SQL, PL/SQL, T-SQL, Java, C, COBOL, Unix Shell Programming, Perl, VB scripts, Python, PHP
• Web Technologies Web PL/SQL, HTML, DHTML, Perl CGl, JavaScript, JSP, ASP, Apache, Tomcat, IIS, Oracle Application Server
• Java, J2EE, web logic
• ETL Tools Datastage, SSIS
• GUI Tools CSS, Developer Suit Forms 4.5/5.0/6.0/6i/9i , Visual Basic
• Database Connectivity JDBC, ODBC, ADO, RDO
• Reporting Tools Crystal Reports4.6/6.0/8.5, Developer Suit Oracle Reports 2.5/3.0/6.0/9i , SSRS
• Developer Tools TOAD, SQL Developer, SQL Navigator, Dream Weaver, Eclipse, SQL Loader, SQL Plus, Oracle Export/Import, Informatica7, DataStage using PX
• CM tools CVS, Clear Case, Clear Quest, VSS, STAR Team
• Job Scheduling tools AutoSys, ESP
• Domain Knowledge
• Banking, Stock Markets, Finance, Manufacturing, Retail Industries.
• Professional Experience Company Project wise

Confidential

Sr. Database Analyst

Environment Oracle 9i/10g, 11g RAC, SQL, PL/SQL, T-SQL, TOAD, SQL Developer, Linux, Datastage 8.1, Perl, PHP, SSRS, SSIS, SVN, Clear Case, Clear Quest.

• CreditView is an In-house built Corporate Loan Manager portal application. This application is used to record all the information related to corporate loan. Since the clients are corporate clients, the loan amount which they borrow also very huge. CreditView is a 3 tier application having J2EE as front end and Oracle as Back end.
• Responsible to gather requirement and analyze from Business analysts.
• Responsible for developing and implementing identified business enhancement requirements.
• Responsible starts from gathering requirements to project delivery meeting the entire milestone.
• Design and developed database code to accommodate new development and business enhancement work.
• Converted Legacy Unix batch jobs into Datastage Jobs.
• Designed and developed Restartable framework module in Datastage, created datastage template jobs, Routines and sending emails in HTML format when job aborts or at the end of job completion.
• Design and work with team, mentor them on business while converting each of the legacy jobs into Datastage jobs.
• Developed automation script to generate Autosys script file for any new deployment.
• Developed Linux scripts to process everyday inbound SOR files that are run by AutoSys.
• Responsible for documenting day-today enhancement development changes.
• Responsible for planning development efforts
• Responsible for Optimizing SQL, PL/SQL for better performance.
• Responsible for writing Ad-hoc queries for Business / testing team.
• Analyzing and converting complex queries with simplified Analytical functions.
• Maintain existing Perl scripts that are used in the reporting servers.

Confidential

Sr. Database Analyst

Environment Oracle 9i/10g, 10g RAC, SQL, PL/SQL, TOAD, SQL Developer, Linux, Datastage 7.5, PostgreSQL, Perl, PHP, SSRS, BI, CVS, Clear Case, SVN, Clear Quest.

• Mini-Q team is internal to GAP for production support and enhancement development work.
• Responsible to analyze datastage job for UNICODE compatibility and alter the required Datastage Jobs.
• Design and develop new Datastage jobs.
• Analyze and develop solutions for all production defects that are introduced by other application team
• Design and develop database work for Web developer and other offshore team members who have Database part in their development.
• Responsible to verify and fix offshore developed Database scripts.
• Responsible for query tuning and do peer review.

Confidential

Sr. Database Analyst

Environment Oracle 9i/10g, 10g RAC, SQL, PL/SQL, TOAD, SQL Developer, Linux, ETL using Datastage, Perl, PHP, Microsoft SQL Report, CVS, Clear Case, Clear Quest.

• CreditView is an In-house built Corporate Loan Manager portal application. This application is used to record all the information related to corporate loan. Since the clients are corporate clients, the loan amount which they borrow also very huge. CreditView is a 3 tier application having J2EE as front end and Oracle as Back end.
• Responsible to gather requirement and analyze from Business analysts.
• Responsible for developing and implementing identified business enhancement requirements.
• Responsible starts from gathering requirements to project delivery meeting all the milestone.
• Responsible to write Microsoft SQL reporting
• Developed inbound data feed jobs and Linux scripts which are run daily by AutoSys.
• Developed procedure and packages to incorporate all the business rules.
• Responsible for documenting day-today enhancement development changes.
• Responsible for planning development efforts
• Responsible for Optimizing SQL, PL/SQL for better performance.
• Responsible for writing Ad-hoc queries for Business / Testing team.
• Analyzing and converting complex queries with simplified Analytical functions.
• Maintain existing perl scripts that are used in the reporting servers.

Confidential

Technical Lead, Sr.Developer-cum-DBA

Environment Oracle 9i/10g, SQL, PL/SQL, TOAD, Perl, Teradata SQL Assistant, SQL Developer, Linux and Windows Script writing, ETL, Informatica7

• IKB is external vendor software to design the store plans and Floor plans. Generating Floor plans PDF and publishing it in website. Published PDF will be downloaded by the participating stores and implement the plans in the store on the set sell dates. This application also helps the team to design participating store's space planning with company's products.
• Responsible for inbound and outbound data to IKB from Mainframe and ADW.
• Responsible for testing and implementing new patches released by IKB.
• Responsible for writing Windows scripts to implement patches to all the user machines in silent mode.
• Developed inbound data feed jobs, written Linux scripts to backup the production database automatically daily by a cron job.
• Developed procedure and packages to
• Pull receipt data from Teradata billing application and generate performance of each product based on sales. The calculated values are then fed to IKB performance tables for further report generation.
• Validate product master data to identify the new and old product and accordingly insert or update product table on cumulative basis.
• Pull the pending to go live plans and allocate them according to their start fiscal week. This was very challenging to identify the plans are updated before they go live and refresh fiscal week plan table. All the new plans are verified to decide whether it is a continuation plan or new plan based on their start date and expiry date, accordingly updated the impacted rows in fiscal week table.
• Developed ETL packages using Oracle PL/SQL.
• Responsible for documenting the day-today issue reported by users group and fixing the problems with the help of JDA.
• Responsible for planning development efforts
• Responsible for monitoring Database table size and taking preliminary steps.
• Optimizing SQL, PL/SQL for better performance.
• Analyzing and converting complex queries with simplified Analytical functions.
• Exporting and Importing Production database to the non-production boxes as and when the Team or users group needs.
• Create users and grant access to various s according to Business rules.
• Written perl scripts to read huge log files and display results in browser based on user's criteria.
• Documenting complete project details starting from Business requirement to UAT.
• Part of on-call support team to provide production support.

Confidential

Technical Lead, Sr.Developer

Environment Java, CVS, TOAD, Oracle 9i, Windows 2000, VB scripts

• This is an interface module between TANDEM and BarTender Tool external vendor software . This interface module will open a socket connection and accepts the incoming requests from Tandem clients. Whenever a new request is received, this module will open a separate thread and start receiving the Stream data, validates the stream data and creates trigger files in the specified folder so that the vendor tool will start processing the trigger files and print bar code labels
• Responsible for requirement gathering and Analysis.
• Responsible for preparing Proof-of-concept for system design
• Responsible for designing full module and database,
• Manage issues and risks
• Provide leadership to the offshore project team and plan development effort
• Developed code for various levels of front-end validations
• Responsible for code repository and version control of code.
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files.
• Documenting complete project details starting from Business requirement to UAT.

Confidential

Technical Lead, Sr.Developer

Environment Oracle 9i, J2EE, JSP, CVS, VSS, TOAD, XP, Linux, Solaris, Tomcat, Apache, Weblogic

• This project aims at supporting Freescale's innovation initiative. It will enable employees to submit ideas, work flows to review/approve/transfer ideas, and for leadership team to evaluate overall progress and financial impact. Best ideas are chosen monthly for Rewards.
• Responsible for requirement gathering, Analysis and designing of this project
• Responsible for Designing the backend Database, Triggers to enforce data integrity
• Developed views, packages, stored procedures and scheduled packages, stored procedures to perform various operations based on business rules in the Oracle database.
• Created SQL queries for data verification and analysis
• Responsible for code repository and version control of code.
• Resolved production issues in Oracle and meeting the SLA
• Manage issues and risks
• Provide leadership to the offshore project team and plan development effort
• Involved in post production on-call support
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files.
• Documenting complete project details starting from Business requirement to UAT.
• Received Outstanding IT Leadership Certification from client as a note of thanks.

Confidential

Technical Lead, Sr.Developer

Environment Oracle 9i, SQL Loader, J2EE, JSP, CVS, VSS, TOAD, XP, Linux, Solaris, Tomcat, Apache, Weblogic

• This is an HR application containing collection of employee's benefits and management links. These links are stored in database. When the user logs in, the system validates them and according to their profile's language and region the pages will get generate. This module was released in English, French, Malay, Japanese and Chinese.
• Responsible for requirement gathering, Analysis and designing of this project
• Responsible for Designing the backend Database, Triggers to enforce data integrity
• Manage issues and risks
• Provide leadership to the offshore project team and plan development effort
• Developed materialized views, packages, stored procedures and scheduled packages, stored procedures to copy data from old database on regular bases using complex views.
• Created SQL queries for data verification and analysis.
• Responsible for code repository and version control of code.
• Designed the multiple lingual search pages based on the name, keywords or description.
• Written Packages to Manage insert, update, delete multi-lingual data by admin team. This package was used to maintain web page contents in different language corresponding to English content.
• Responsible for developing a utility package used for error tracking in various levels.
• Resolved production issues in supported applications and meeting the SLA.
• Responsible for moving data from old database to UTF database.
• Involved in post production on-call support.
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files.
• Documenting complete project details starting from Business requirement to UAT.

Confidential

Technical Lead, Sr.Developer

Environment J2EE, JSP, CVS, VSS, Linux, Solaris, Tomcat

• This project helps to connect to external partner's application from the Summit Portal with single sign on. Some of the partners who are connected thru SSO are CWT, Ethics, Authoria, Traq, GetThere and PeopleClick
• Responsible for requirement gathering, Analysis and designing
• This module takes the login details from internal summit portal when the user logs in and allows the user to navigate to external partner web sites suppressing the login and passing the login credentials to called websites.
• Responsible for code repository and version control of code.
• Involved in post production on-call support.
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files
• Documenting complete project details starting from Business requirement to UAT.

Confidential

Sr.Developer

Environment Oracle 9i, SQL Loader, J2EE, JSP, CVS, VSS, TOAD, XP, Linux, Solaris, Tomcat, Apache

• This is a portal application allowing employees and contractors to register and manage their requests for Calling card, Remote Access SecurID tokens, Friendly alias and wagon wireless network cards throughout Freescale. This application is one stop shop to order.
• Responsible for requirement gathering, Analysis for enhancement and redesign.
• Responsible for Designing the backend Database, Triggers to enforce data integrity
• Developed materialized views, packages, stored procedures and scheduled packages, stored procedures to copy data from old database on regular bases using complex views.
• Created SQL queries for data verification and analysis.
• Defining the reusable objects,
• Worked in SQL Database 2000 to retrieve the Data.
• Responsible to write stored procedures and functions in SQL database.
• Responsible to provide Ad-hoc queries to clients.
• Responsible for writing Backend Database and Cron scheduled jobs.
• Written packages to
• o Sync local database with vendor's data. Often local database goes out of sync due to incapable of front end validation. We need to import data from vendor database and validate each user's activities and update local database accordingly.
• Generate UTL file reports based on the user's activities and send statistics in email to manager.
• Responsible for code repository and version control of code.
• Responsible for developing a utility package used for error tracking in various levels.
• Resolved production issues in supported Applications and meeting the SLA.
• Responsible for moving data from old database to New Database.
• Involved in production on-call support.
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files
• Documenting complete project details starting from Business requirement to UAT.

Confidential

Sr.Developer

Environment Oracle 9i, SQL Loader, Linux, Solaris, perl, Toad.

• OPD is a Dataware hub. Application teams will send the data feed to OPD in a flat file format. SQL Loader script will upload these feeds to respective tables. SDW team will take these uploaded feeds and process it further according to their requirement.
• Responsible for monitoring all the scheduled jobs.
• Responsible to clean the failed jobs and re-run the job.
• Responsible to alter the database objects and corresponding loading scripts whenever the dependent applications make changes as per business rules.
• Responsible to create the every year financial applications database objects.
• Responsible for creating Index, synonyms, Views and SQL loader scripts
• Created SQL queries for data verification and analysis.
• Responsible to provide Ad-hoc queries to clients.
• Written perl scripts to filter, validate size and format, before loading in to database.
• Responsible for setting up maestro jobs.
• Responsible to monitor the table space and accordingly request DBA to increase the table space.
• Resolved production issues in supported Applications and meeting the SLA.
• Responsible to Facilitate the new application team with required tables, index, views, SQL Loader scripts and new load schedule etc
• Involved in production on-call support.
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files

Confidential

Sr.Developer

Environment Oracle 8i/9i, Web PL/SQL, JSP, CVS, VSS, TOAD, XP, Linux, Solaris, Tomcat, Perl, Apache

• EARMS is a repository of information on existing software applications such as associated documents, contact information, decommissions and implementation plans. With it's wealth of information about applications and their use, EARMS helps in determining the impact of implementing new systems and decommissioning existing systems.
• Responsible for requirement gathering, Analysis for enhancement and redesign.
• Responsible for Designing the backend Database, Triggers to enforce data integrity
• Developed materialized views, packages, stored procedures and scheduled packages
• Customizing the existing module and redesigning the application. Web pages were in Web PL/SQL, which had very challenging task to embed dynamic web pages with in PL/SQL code. Needed to write very large procedures and package to create these web pages and library files.
• Developed perl pages to generate new quotes based on the market price provided by marketing team.
• Responsible for creating Index, synonyms, Views and SQL loader scripts
• Created SQL queries for data verification and analysis.
• Responsible to provide Ad-hoc queries to clients.
• Defining reusable objects according to coding standards
• Improving the look and feel with suitable cosmetic changes
• Resolved production issues in supported Applications and meeting the SLA.
• Involved in production on-call support.
• Involved in Integrating Development, UAT and Production environments.

Confidential

Sr.Developer

Environment Oracle 8i/9i, Web PL/SQL, JSP, CVS, VSS, TOAD, XP, perl, Linux, Solaris, Tomcat, Apache

• Dante is the Sector standard Program Management Information System to manage programs and projects world wide. Dante contains all of the data records and functions required to Manage the project, Plan meetings and send meeting minutes, Track action items, Delegate responsibilities, View another organization's projects, Print reports and make presentations, Review performance and project metrics.
• Responsible for requirement gathering, Analysis for enhancement and redesign.
• Responsible for Designing the backend Database, Triggers to enforce data integrity
• Developed materialized views, packages, stored procedures and scheduled packages
• Developed perl scripts to validate the inbound text data before inserting into Database.
• Customizing the existing module and redesigning the application. Application contains very large procedures and packages to validate user project management details. The application was in web PL/SQL, which had very large complex codes to generate dynamic pages.
• Responsible for creating Index, synonyms, Views and SQL loader scripts
• Created SQL queries for data verification and analysis.
• Responsible to provide Ad-hoc queries to clients.
• Defining reusable objects according to coding standards
• Improving the look and feel with suitable cosmetic changes
• Resolved production issues in supported Applications and meeting the SLA.
• Involved in production on-call support.
• Involved in Integrating Development, UAT and Production environments.

Confidential

Senior Software Engineer

Environment Developer 2000 Forms 6.0 6i , JSP, Oracle 8.16, Star Team, TOAD, SQL Navigator, Windows 2000, Sun Solaris, IAS

• Securities Lending is a means of reducing the gap in the demand supply chain in the securities market. The main players in this segment are the lenders, who want to gain some income out of their portfolio, the borrowers, who are in need of securities for a short time span and are ready to pay for the same, and the approved intermediary, who facilitates in the lending and borrowing activity. SHCIL is one of the first Approved Intermediaries as per SEBI for this activity. It is one of the main products in the basket of products provided by SHCIL in the Indian Capital Market.
• Responsible for requirement gathering, Analysis for enhancement and redesign.
• Responsible for Designing the backend Database, Triggers to enforce data integrity
• Developed materialized views, packages, stored procedures and scheduled packages, stored procedures to copy data from old database on regular bases using complex views.
• Created SQL queries for data verification and analysis.
• Defining the reusable class objects and libraries for Forms and reports.
• Responsible to provide Ad-hoc queries to clients.
• Responsible for designing and coding to download the new forms to client machines automatically on login.
• Responsible for implementing the Enforced Security in the front end and back end objects.
• Responsible for writing Backend Database and Cron scheduled jobs.
• Responsible for code repository and version control of code.
• Resolved production issues in supported Applications.
• Responsible for moving data from old database to New Database using SQL Loader.
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files

Confidential

Software Engineer

Environment Developer 2000 Forms 4.5 5.0 , Oracle 8i, Star Team, TOAD, SQL Navigator, Windows 98, Sun Solaris

• This is a centralized accounting system, which brings all the accounting products of SHCIL under one umbrella. This integrates accounts of clients across India. This consolidates accounts across multiple units from cost-centers to company level in order to get consolidated Balance Sheets, Profit and Loss Statement and Trial Balance. The system generates reports to the company, division, department and cost-center wise financial statement.
• Responsible for requirement gathering, Analysis for enhancement and redesign.
• Responsible for Designing the backend Database, Triggers to enforce data integrity
• Developed Views, packages, stored procedures and scheduled packages, complex views.
• Created SQL queries for data verification and analysis.
• Defining the reusable property classes, Visual Attributes and libraries for Forms and reports.
• Responsible to provide Ad-hoc queries to clients.
• Responsible for designing and coding to download the new forms to client machines automatically on login.
• Responsible for implementing the Enforced Security in the front end and back end objects.
• Responsible for writing Backend Database and Cron scheduled jobs.
• Responsible for code repository and version control of code.
• Resolved production issues in supported Applications.
• Responsible for moving data from old database to New Database using SQL Loader.
• Involved in Integrating Development, UAT and Production environments.
• Involved in unit testing, integration testing validating output report files