OBJECTIVE:

Looking forward for a career in Database Development where I can exercise my expertise and knowledge that fosters quality, creativity, productivity and continuous learning.

SUMMARY:

• Approximately 8 years of IT experience, 5 years of Oracle PL/SQL programming experience.
• 2 - 3 years of Unix Shell programming experience.
• Building software components using Oracle 8i, 9i, 10g, 11g, 12c (SQL, PL/SQL).
• Maintaining user interface components to enhance functionality for company web application using ColdFusion 8-11, Dreamweaver CS4, Eclipse, Subversion.
• Performing Unit Test for the software components before the release.
• Incorporating Agile SCRUM methodology within a SDLC platform.
• Expertise in writing SQL queries.
• 24X7 support in Production.
• Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
• Feasibility study, planning, implementation, testing, deployment and close-out
• Created logical and physical Database Design, data structures, Data Modeling, Schema Design
• Applied Database Tuning and Optimization, Normalization in the new database design
• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
• Granted resources, privileges and roles to users
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
• Wrote Audit programs for data consistency check and validation
• Used SQL*Loader, Import/Export, UTL FILE, DBMS XMLQUERY, DBMS PIPE and other Oracle built-in packages
• Automated SQL*Loader to load the data from the flat files
• Used Materialized Views, Packages and Dynamic SQL
• Created programs to transform data from Legacy systems into Oracle database
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables
• Tested and modified codes for quality

SOFTWARE:

• VB, VB.net, ASP.net, Visual Studio 2003/2005/2008/2010/2012
• Oracle PL/SQL, SAS, C MySQL, PHP, ColdFusion, STATA
• ASP, HTML, SQL, Adobe Photoshop, Dreamweaver
• C++, Microsoft Visio, Oracle PL/SQL, MS SQL Server
• CSS, JavaScript Toad, SQL Developer, SQLPlus
• UNIX, Matlab Microsoft Office Suite

WORK HISTORY:

Adjunct Instructor

Confidential

Responsibilities:

• Teach material from approved curriculum and develops daily lesson plans to include instructional aids.
• Develop daily lesson plans to include instructional aids.
• Assist student in Achieving completion of objectives. Provides regular and timely feedback to students
• Participate in school retention initiatives by maintaining productive contact with students and by getting in touch with and offering assistance to absent students.
• Advise students in matters related to academics, attendance and behaviors.
• Motivate student to actively participate in all aspect of the educational process.
• Maintain and reports student grades and attendance in accordance with company policies.
• Complete professional development and in-service activities in accordance with college standards.
• Participate in department curriculum meetings.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Develop and revise program code based on clearly defined requirements.
• Prepare required documentation, including both program-level and user-level documentation.
• Draft test plans for system tests, integration test, and stress tests.
• Test all functionality of applications based on test plan.
• Assist in the setup of production environment including application servers and database servers.
• Assist in the implementation of applications into production.
• May be required to analyze system capabilities to resolve input/output problems.
• Must be able to communicate effectively, work in a team environment and think analytically.
• Perform maintenance on programs currently in production.
• Develop and maintain complex Oracle PL/SQL stored procedures and functions. Provide programming direction as necessary to lower level programmers as appropriate to position level.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Develop and revise program code based on clearly defined requirements.
• Prepare required documentation, including both program-level and user-level documentation.
• Draft test plans for system tests, integration test, and stress tests.
• Test all functionality of applications based on test plan.
• Assist in the setup of production environment including application servers and database servers.
• Assist in the implementation of applications into production.
• May be required to analyze system capabilities to resolve input/output problems.
• Must be able to communicate effectively, work in a team environment and think analytically.
• Perform maintenance on programs currently in production.
• Develop and maintain complex Oracle PL/SQL stored procedures and functions. Provide programming direction as necessary to lower level programmers as appropriate to position level.

IT Applications Analyst

Confidential

Responsibilities:

• Program and test code using PL/SQL and other programming languages as specified.
• Assist in performing all development tasks required to ensure the accuracy of each software program within the specified timeframes.
• Work closely with management on assigned projects from inception through implementation ensuring adequate internal communication and user involvement is maintained.
• Analyze client and customer needs as required.
• Assist in the requirement process, development, unit testing of simple to moderately complex code.
• Proactively obtain information needed for the successful development of software programs.
• Assist in investigating issues and developing resolution in a timely manner with a technical author.
• Complete required documentation as needed to provide a full and clear history of development and changes.

Instructional Technologist Assistant

Confidential

Responsibilities:

• Provide technological support for students and staff, including training, assistance with decision-making, and maintenance of hardware and software
• Under direct supervision of certified staff, plan and deliver instruction to students in computer labs and other situations for the purpose of assessing the skills and knowledge outlined in the University Technology Plan
• Repair and upgrade the building computers and provide troubleshooting for hardware and software problems
• Research and make recommendations regarding overall technology needs; upgrades, maintains, inventories, and makes purchase recommendations on computer hardware and software
• Provide technical assistance with BlackBoard support calls/tickets
• Maintain and administer the building Local Data Network (LAN)

Data Specialist

Confidential

Responsibilities:

• Perform all tasks related to processing accounts payables and/or accounts receivables.
• Identify and make recommendations to improve and control department processes to ensure performing at optimal levels.
• Provide customer service and quality assurance to clients and vendors.
• Maintain sensitive customer financial information and other organized financial records, both paper and electronic.
• In collaboration with others, interpret data and develop recommendations based on state findings
• Develop graphs, reports, and presentations of project results
• Serve as SME for Weatherization Assistant NEAT AUDIT
• Provide quality assurance to clients, auditors, and contractors

Graduate/Research Assistant

Confidential

Responsibilities:

• Identify problematic areas and conduct research to determine the best course of action to correct the data
• Identify, analyze, and interpret trends or patterns in complex data sets
• Acquire and abstract primary or secondary data from existing internal or external data sources
• In collaboration with others, develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
• Proctor exams and act as head tutor for the Department and Mathematics faculty