Career Objectives

To apply my skills and experience for the potential growth of the organization and career advancement.

Professional Summary

• Around 9 years of experience in IT profession with focus on Analysis, software design, development and support.
• 7 years of Experience in SQL and PL/SQL with proven abilities to write optimized queries with complex business/transformation logic for Application ranging from OLTP to DSS using Oracle 9i/10g/11g and UNIX Solaris HP -UX
• Expertise in Application design and performance fine tuning
• Proficient in developing Packages, stored procedures, functions, triggers, views and cursors.
• Strong knowledge in Oracle cursor management, Reference Cursor, Collections, Bulk collect and exception handling.
• Hands-on experience in implementing indexes such as Clustered index, Non-clustered index appropriately on data structure to achieve faster data retrieval and Performance tuning.
• Expertise in Table Partitioning, Sub Partitioning, Index Partitioning, gather and Compute Stats for better performance of SQL queries there by reducing Transaction cost and Time.
• Extensive experience in Database query tuning for Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• 3 years of strong ETL and data integration experience in developing ETL mappings and scripts using SQL Loader.
• Involved in gathering business requirements, documenting them, and converting them into robust system designs.
• Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Excellent organizational, planning and problem-solving skills.
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.

TECHNICAL SKILLS

Professional Experience

Responsibilities:

• Worked as Team lead, and led a team of four developers, Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Developing UNIX Shell Scripts for scheduling various data cleaning scripts and data loading scripts.
• Developing PL/SQL Procedures, Functions and Packages and ETL scripts using SQL loader to load data into database from various sources as flat files and data pull.
• Developing, Reviewing and Tuning of SQL queries and PL/SQL blocks, Analyze and Compute statistics to improve response time for queries to ensure successful completion of transaction in the stipulated time for OLTP and make reports available in time.
• Working with system analyst and business customers to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications
• Responsible for logical and physical modeling for OLTP and data base.
• Responsible for monitoring and making recommendations for performance Improvement and query tuning.
• Skills: Oracle 11g, UNIX HP UX, MS Visio, Toad, SQL Loader, HTML, Java.

Responsibilities:

• Have performed different roles in complete life cycle of the Project from System Requirements, Impact Analysis, Design, Development and Testing to post deployment support.
• Involved in Requirements gathering for computation of dispatch efficiency, Manager Roll up Reports and Ranking Reports along with business clients.
• Responsible for re-designing dashboard and reports.
• Developed ETL program to load the feed files from various systems to generate Ranking report and Manager Roll up Report. Developed procedures and functions to process loaded data according to business rules to for the newly added reports.
• Developed shell scripts to Implement Job dependencies for sequencing and scheduling the execution of Jobs and streamline the flow, so that data is processed with accuracy and no wait time.
• Implemented SQL Performance improvement and tuning mechanisms using materialized views.
• Lead team of four in creating front end Reports using ColdFusion, HTML, CSS JavaScript
• Skills: Oracle 10g/11g, UNIX Solaris, Toad, SQL Loader, HTML, Java, Cold Fusion, CSS

Responsibilities:

• Interacted with the client team to understand the requirement to design the architecture of the application.
• Installed GNUPG encryption tool in Sparc Solaris.
• Lead team of 3 to develop business logic for the Tool under tight deadlines in UNIX.
• Developed shell scripts and procedures to make the file dispatch table driven, thus helping in minimal code change when there is server lease Roll or change in IP address of the host or destination servers and thus reducing the impacts on Application from Physical environment.
• Assigned individual modules to team member, track status and integrated and deployed the application in Solaris environment.
• Developed Front end monitoring tool in ColdFusion and HTML to track the status of file dispatch in web.
• Monitored and conducted frequent informal training and code review sessions

Skills: Oracle 10g, UNIX Solaris, Toad, HTML, Cold Fusion, CSS, JavaScript

Responsibilities:

• Developed ETL Programs using SQL loader and Implemented Complex business logic in PL/SQL code.
• Developed Procedures to generate Employee reporting hierarchy for the whole organization on daily basis.
• Interacted with Client and gathered all Requirement Changes, tracked all the Change requests to completion.
• Release Lead for customizing and delivering the Application for demos to prospective clients.
• Developed monthly reports, daily reports with pre-computed values in temporary Tables and materialized views using overnight batch Jobs, so the reports are quicker in just fetching the values from Table.
• Involved in creating static content for Web pages according to the design and merged with dynamic content
• Mentored Junior Team members and new recruits by organizing and giving training sessions
• Was awarded the BRAVO award for tuning batch Jobs that drastically improved the response time and also for mentoring the team.

Skills: Oracle 10g, UNIX Solaris, Toad, HTML, Cold Fusion, CSS, JavaScript

Responsibilities:

• Designed and developed Application in Oracle Forms, ColdFusion and Oracle PL/SQL.
• Designed Login Validation Page in oracle Forms that communicates with an asp page on a common login validation server using the XML page and ASCII codes that is created by Java Stored procedure in Oracle server.
• Involved in Server lease Roll, Installed, configured and deployed a new Oracle9i Application Server on Windows 2003 Platform.
• Performed load testing and memory cache on the server to withstand peak load.
• Performance tuned batch Jobs by Index Creation, Table Partitioning and by using Hints.
• Scheduled CRON jobs to send out scores to various downstream applications.
• Fixed long pending issues analyzing the root cause and gave permanent solutions, there by streamlined the entire application.
• Created a portal in ColdFusion to mange the Employees in Bench separately.
• Created UNIX batch jobs to synchronize the data between Oracle Database and DB2 database.
• Developed and Scheduled Oracle Batch Jobs to match the Job requisition with the Employee Requisition to determine an Eligible candidate for the Job criteria.
• Received SPOT award for Oracle9i Application Server Installation and stood 5th organization wide for best Knowledge sharing practices.

Skills: Oracle 9i, UNIX Solaris, Oracle Forms, Toad, HTML, Cold Fusion, CSS, JavaScript

Responsibilities:

• Responsibility includes Testing of Wired and wireless device includes Routers, access points, network cards, gateways, modems and switches.
• Maintaining specifications of wireless devices and preparing data sheets.
• Development of static web pages in HTML and JavaScript to maintain details on device specification and data sheets for different device.
• Actively worked on development of web pages and designing layout for device simulator page.
• Devised trouble shooting guides for different device specific issues and linked the same to existing Applications.
• Created Portals on simulator pages for Routers and other configurable network products to aid support Technicians to guide customers on Installation and Trouble shooting.

Skills: HTML, CSS, JavaScript

Responsibilities:

• Actively Involved in Design, development and unit Testing of Web tool and in development of C programs for RFID
• Designed web page Interface in JSP, HTML and JavaScript to read data from RF receiver and display it to the one who monitors and records the same in database.
• Created C programs that are converted to assembly C to be fed to the micro processor in the RFID.
• Unit tested each independent module manually and ensured it is error and is in compliance with the business requirements.
• Involved in interfacing each independent modules and making the interfacing device work with Web Application.
• Prepared user guides for all the modules involved in the Project.

Skills: JSP, Oracle, HTML, CSS, JavaScript