Sr SAS Developer & Analyst

Rekha Kumari

Cell Phone no 609-***-****; Professional Summary:

• Six year experince in complete Software Development Lifecycle (SDLC) using Oracle 10g/9i/8i/6ig on Windows and UNIX platforms in the phases of Analysis, Designing, Development, Production support and Testing.

• Extensively worked in creating, debugging and testing Procedures, Functions, Triggers and Packages using advanced PL/SQL.

• Extensive hands-on experience with Client/Server technology using Oracle Developer/2000 Forms 6i/9i/10g & Reports 6i/9i/10g.

• Experience in Data Modeling tools like ERwin, Oracle Designer.

• Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.

• Experienced in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.

• Worked on Oracle Enterprise Manager Grid Control (OEM) to proactively monitor and manage databases.

• Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.

• Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.

• Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export on UNIX platforms.

• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.

• Experienced in developing and modifying existing UNIX shells scripts and scheduling the jobs using Autosys and Crontab and monitor the batch processing.

• Solid understanding of relational databases.

• Experience with data migration.

• Experience in providing 24x7 production support.

• Good understanding of database administration tasks such as implementing relationships, handling security issues, importing and exporting databases, backup and recovery.

• Energetic self-starter with excellent analytical and problem-solving skills. Good verbal, written, and presentation skill. Effective team worker.

Technical Skills:

Databases: Oracle 10g/9i/8i/6ig, SQL Server 2005

Programming Languages: C, C++, JAVA, COBOL, PL/SQL, SQL, UNIX Scripting ,Microsoft Excel,Microsoft word, MS Tool etc.

GUI Tools: Oracle Forms and Reports 6i/9i/10g, Oracle Enterprise Manager 10g (Grid Control), Oracle Discoverer 10g

Data Modeling: Erwin, Oracle Designer

Operating System: Windows NT 4.0, Windows Server 2003, Windows Vista/XP, Mac OS X UNIX (Linux, IBM Z, Solaris 9, AIX, HP-UX)

Other Tools & Utilities: SQL*Plus, Toad, SQL Developer, SQL*Loader, Microsoft Excel, Microsoft Visio, Oracle Job scheduler, Autosys, Clear Case, PVCS, Visual Source Safe, WinSCP

Professional Experience:

Macys NJ July 2010 to till present

Tech Mahindrra, Salt lake, Kolkata April 2004 to june2010

Oracle Developer

Project: British Telecom, Support project BT is one of the world's leading providers of communications solutions and services operating in 170 countries. Its principal activities include networked IT services, local, national and international telecommunications services, and higher-value broadband and internet products and services. BT consists principally of four lines of business: BT Global Services, Openreach, BT Retail and BT Wholesale.

Responsiblities:

• Understanding the customer requirements, analysis, design, development and implementation into the system, Gather and define business requirements, improve business processes.

• Designed and developed PL/SQL functions, stored procedures, cursors, packages, triggers.

• Involved in performance fine-tuning of the queries, report using PL/SQL and TOAD.

• Involved in Database Design & Data Modeling (ERWIN).

• Creating and maintaining the data model and physical integrity of the databases.

• Designed and developed GUI front-end using Oracle Forms 10g for user interaction with the database.

• Designed and developed various reports using Oracle Reports 10g.

• Involved in writing complex queries to generate reports as per client request as a part of production support.

• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.

• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.

• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.

• Performed Application Tuning to improve the PL/SQL, SQL code by using SQL*TRACE, Explain Plan and TKPROF.

• Provide functional requirements to describe system process, as well non-functional requirements to describe performance, scalability, security and usability requirements.

• Optimized different SQL queries to insure faster response time.

• Developed screen layouts, report layouts using Forms and Reports and participated in implementation.

Environment: Oracle 10g/9ig/8ig/6ig, Windows XP, UNIX, HP-UX, SQL, PL/SQL, SQL*PLUS, TOAD, SQL*Loader, ERwin, Oracle Forms 10g and Oracle Reports 10g.

Central Mining Research Institute, India Aug 2002 – 2004 2004 Oracle Developer

Project: Project Information Management System (PIMS)

CMRI is a premier Scientific organization in India providing basic research, R & D back up, advisory services and help in technology up-gradation & adaptation to coal and mineral based industries to reach the targeted production with high standards of safety, economy and cleaner environment. This specific project, Project Information Management System (PIMS) keeps all the information of all the projects running in different mines under the supervision of all the Scientists working in Central Mining Research Institute, Dhanbad.

Responsibilities:

• Worked extensively in Designing, Developing, and Testing of Oracle PL/SQL and developer6i Forms and Reports.

• Wrote SQL Scripts for creation of database tables, synonyms, sequences and created users, roles and privileges.

• Writing Database Packages, Procedures and Triggers.

• Developed Forms, Menus, PL/SQL Libraries and Object Libraries extensively for code reusability and standardization.

• Worked extensively on the hierarchical model of Forms.

• Developed reports extensively on Oracle Reports 6i and its integration with the Application Forms.

• Written Stored Procedures, Functions and Packages using PL/SQL.

• Designed, developed and programmed interactive software in Oracle PL/SQL stored procedures.

• Converted existing system and codes to windows application (X and Oracle).

• Worked extensively in application development following all phases of system life cycle.

• Provided customer support, training and technical translation.

Education:

• M. S. in Computer Application(1999-2002) From (Magadh University-Bodh Gaya)

• Bachelor of Science (1995-1998) From (vinobha Bhave University-Hazaribagh)

Contact this candidate