Key Skills: Oracle Development, SQL, PL/SQL, Oracle Forms, Oracle Reports, JDeveloper, Unix, Informatica, SQL Server, SSIS

EXPERIENCE

Confidential

Responsibilities:

Worked on various Client Projects that included ETL and Database development work primarily at VHA. The clients include Novation, Provista, Aptitude, Apexus etc., generally deal with Contracts with various vendors on over 8 Million Medical Products which are part of the Supply Chain Management that the Business takes care. There are verity of Information that is captured and processed including thousands of Member data around the business in more than 50 production databases between the conglomerate companies. The work methodology is Agile and very fast paced. Duties include Meeting with Clients t gather requirement/ discuss production problems t advice/code solutions. Responsibilities include writing large SQL queries, Modifying large procedures, developing ETL Packages from Scratch and modifying packages t address production issues.

EXPERIENCE

Confidential

Responsible for the application maintenance and Transactional Load from the 4000 stores. High Touch system at POS will generate flat file which are loaded int the enterprise production database which is called the SIMS application by TIBCO using many Oracle backend procedures and packages. I am responsible t maintain these procedures and als the Data that we load through TIBCO which involves Data correction/validation during and after the loading. Loading the Data warehouse environment using Informatica as ETL tool.

Confidential

Responsibilities:

Primarilybuilding the database part of the offers for DIRECTV in TAOS application. Creating detailed design documents from COR centralized offer requirements documents and functional specification documents for the projects I have worked on. Worked with BA's and SA's for all the requirement gathering. Predominantly worked on production problems Service Desk Problems logged by the Operations team. Releasing code related t projects and SDP's t SQA and production environments and supporting it as and when required. Worked on change requests and Change Orders from business and other groups. Worked on new projects t support the ever changing business needs. Modify existing code/Build new code, which involved creating and altering tables and constraints, indexes, triggers, synonyms, complex PL/SQL procedures/functions/packages and writing Unix shell scripts. Responsible for documenting the changes as well as unit testing each component that is worked on. Documenting the existing processes if not already documented. Work within the development team and with different teams across the enterprise on all the Projects. Schedule and attend meetings as necessary t discuss the status, issues, design etc. Identify batch process with higher execution times in production and fine tune them.Loading reporting database and data warehousing environments using Informatica as the ETL from the source STMS database.

EXPERIENCE

Confidential

Responsibilities:

Data warehousing application development using PL/SQL and SQL. Modifications t the application ETL and queries. Responsibilities include development, testing and release. Worked on tw different project for the client at the same time, one is creation of a new data warehouse called ODS with the development of the ETL t pull data from different sources, second is called Surveillance Dash board for whichDatabase objects and the ETL was developed. This tool is a reporting tool and can show the details that does not exist in the current system, as the current system gets updated from 30 t 45 days later and for executives wh make decisions, this time is a lot and s they can now depend on this new tool t get the current information reported off of different sources. Performance tuning is one of the main jobs that went with both the projects. I have designed tables t take advantage of parallel processing by partitioning tables and created materialized view where appropriate. Extensively used bulk methods where ever possible. Worked with client very closely t get information and business rules that was coded int ETL. Performance tuning the application was necessary at every step of the code as some of the tables have more than half a billion records.

EXPERIENCE

Confidential

Nokia NetAct OSS is a proprietary tool that offers a complete solution for managing mobile networks, ranging from network monitoring and performance management software t software for telecom network optimization. It provides network data storage and reporting for operators. NetAct collects data from network elements in the form of xml, binary and text files and calculates KPI key parameter indicators and stores them in the data warehouse for GSM, GPRS and UMTS network elements. It als has easy interfaces t add new network elements.

Responsibilities:

• Primary responsibility is Data Warehousing application development using PL/SQL and SQL. Modifications to the application ETL, queries and performing tuning. Responsibilities include testing and release management. Multi vendor Ericsson,Nokia,Nortel integrations are implemented using oracle 10G, SQL and the OS is HP-UX. Developed adaptations for Ericsson and Nortel BSS, MSC, MMSC, CCN, Call break down, radi characteristics and integrated them t NetactDeveloped XMLModeled and implemented oracle database schema including table space, user creation, tables, views, synonyms, indexes, triggers and functions.Implemented optimized functions using PL/SQL t improve performance of BSS adaptorsResponsible for creating ANT Build Scripts and build application server EAR files and deployed them in web sphere server.
• Involved in full SDLC of the project from requirements, Analysis, Design, development and testing.

EXPERIENCE

Confidential

Responsibilities:

Application Development using PL/SQL and SQL. Modifications t the application for all the 27 different clients. Testing and Release management. Als worked in database administration. Creation of new databases and cloning of existing databases. Maintaining production servers/Standby and managing spaces. Providing reports of the spaces and other database related monitoring. On call support of 27 production databases. Development of PL/SQL, SQL, extracts and creation of all schema objects related t the projects assigned and all maintenance related activities. Writing Unix scripts for the above activities and scheduling the cron jobs. Working directly with clients t get the requirements and estimating the resources, working on the same projects and releasing after testing t clients. I was responsible for the testing and support my own code. Working with Account managers/ projects managers and DBA manager for all the projects I work.

EXPERIENCE

Confidential

Senior Programmer Analyst

• Project Title: Caradigm - This project deals with Claims management. Caradigm application is used by CCAH t deal with the 12 Medi-cal claims from six counties in California.
• Working with the Business Analysts t identify the new requirements and Changes t the existing modules.
• Developing new forms from scratch.
• Fixing bugs in the Existing modules.
• Coding for Enhancements in the existing modules.
• Writing new function and packages.
• Modifying the existing Database Packages.
• Writing Reports in Oracle Report writer.
• Handling Production Issues and Fixing bugs and involved in Releases.

TECHNICAL SUMMARY

• Operating Systems: Microsoft Windows, NT, UNIX, Solaris
• Applications and Tools: Oracle Forms9i, Reports9i, PL/SQL, HTML, XML, Discoverer, SQL Loader, TOAD, ERwin 4.0, Designer 6i, VSS, UNIX Shell Script, Infra, Start Team, Open Road, Core Java, Visual Basic 6.0, Data Warehousing, Informatica, Cognos, Oracle Financials 11i, SSIS.
• Databases: Oracle 8.x/9i, 9i DBA, Cache 5.0, SQL Server