SUMMARY:

Experienced information system technology currently is seeking position as Database Developer to leverage my recent education and skills sets to help the organization to manage and maintenance data.Equipped with an excellent work ethic; possess strong sense of responsibility. Self - motivated and capable to work independently or in a team with demonstrated ability to prioritize tasks to achieve maximum results.Career ObjectiveTo secure a challenging position as a Database Developer in an established organization and utilize my technical skills and IT knowledge for managing organization's projects

TECHNICAL SKILLS:

• Operating Systems: Unix / Linux
• Relational Databases: Oracle 10g RAC, Oracle 11g RAC
• Data Modelling Tool: ERWIN, Designer 9i
• Tools and Utilities: RMAN, SQL*Loader, TOAD
• Querying/Reporting: PL/SQL, SQL
• Languages: SQL, PL/SQL, C, C++, JAVA, VB.NET, UNIX Shell Scripting
• Oracle 11g.
• RDBMS.
• Technical Troubleshooting
• Hardware Configurations
• Offshore Team Collaboration
• Software Installs
• LAN Connectivity
• Problem Diagnosis
• Phone & Online Support
• Client/Server Models
• Preventive Maintenance
• User Training/Support
• Customer Service
• Complaint Handling.
• Customer Relationship.

PROFESSIONAL EXPERIENCE:

Confidential

Jr. Oracle Developer

Responsibilities:

• Created Oracle tasks, wrote script, backup, and installed and supported transactional replication
• Involved in reviewing third party code for performance issues using Oracle using SQL * Lodder and optimized application access.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Help Desk Technician/ Jr. Oracle DBA

Responsibilities:

• Work with programming staff on database design changes to meet business requirements
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Resolve database related issues and running the scripts for the application support team.
• Create documentation in accordance with tasks performed.
• Performance tuning for Oracle Day-to-day maintenance, and management of the several different databases in development, test, regression and production environments.
• Provided technical support for database maintenance.
• Supported database design, restructuring and maintenance.
• Design, tuning, build enhancements and problem resolution for test, development, production and reporting databases.
• Developed SQL & Shell scripts to automate tasks and increase productivity.
• Designed and developed reports using Crystal Reports XI version.
• Designed and developed cross tab reports, reports with sub-reports (linked and unlinked) and chart reports. Reports were based on a command object. Wrote several SQL queries to accomplish the task.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Lead for shaking out the reports and smoke testing.
• Worked with the Quality Assurance Team to resolve bugs with a very less turnaround time.
• Extensively worked on reports that contained several Static and Dynamic prompts.
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Deployed and managed reports with the aid of Crystal Management Console.
• Responsible for giving user access and setting restrictions to view the reports.
• Worked with other users and the project manager to gather requirements.
• Develop new applications using XML and other programming software available.
• Met with other programmers to determine the best direction for the network
• Write technical guides to XML applications
• Automated the installation of software to 1200 end-user PCs via DOS batch files, Symantec Basic scripting, and Novell Application Launcher snapshot technology
• Provided second level support to internal Help Desk to resolve user concerns with specific applications, including Windows 95, Microsoft Office, GroupWise, and numerous industry specific applications
• Identified and implemented technologies and methods of using existing technology to help users work more efficiently, including:
• Creating/revising macros and spreadsheets in Quattro Pro, Excel, and VBA programming
• Developing procedures and training users in electronic data transfer between applications
• Wrote articles for and reviewed the Techie Tips, Tricks And News newsletter
• Prepared documentation and training materials, coordinated technology related training
• Participated in conversion of 1200 PCs from Windows 3.1 to Windows 95
• Assisted in deploying Help Desk, including software selection and development of procedures Worked on the Help Desk to provide support for software, printing, and network access issues

Confidential, Denver, Co

Customer Service /Accountant clerk

Responsibilities:

• Schedule rental switch outs and two exchanges. Handle billing questions and issues.
• Handled 50-75+ calls per day regarding car rental inquires for National/Alamo/Enterprise. Troubleshoot customer car rental agreement issues and concerns.
• Handled 20-35+ calls per day regarding candidate staffing and client inquires. Managed the IT services included: website maintenance, network and hardware setup/maintenance.
• Developed and implemented office procedures.
• Processed candidate applications and conducted screening/interviews. Administrated and maintained office technological polices.
• Maintained executive calendars.
• Part of management team.
• Analyses purchases and sales accounts.
• Prepare marketing plan.
• Preparing purchases & sales account books.
• Prepare Tax & payment roll.
• Balancing sales & general ledger.

Confidential, Denver

Co Computer Support Technician

Responsibilities:

• Provided phone, remote and hands-on for 2,000 users in a Windows 7 & 10 environments.
• Troubleshot issues in a timely manner and maintained documentation on a ticketing system.
• Maintained Active Directory, creating new user accounts, resetting passwords and assigning permissions.
• Set up new computers and maintained printers.

Confidential, Denver, Co

Help Desk Technician

Responsibilities:

• Provided remote and hands-on for 80 local users in a Windows 7, 8 & 10 environments.
• Troubleshot issues in a timely manner and maintained documentation on SysAid ticketing system.
• Maintained Active Directory, creating new user accounts and assigning permissions.
• Maintained a private site for users in the company.
• Responsible for backed up, imaged and installed new PC’s using Acronis imaging system.
• Installed drives, RAM, PCI adapters, and video cards.

Confidential, Denver, Co

Call Center Representative

Responsibilities:

• Conduct analysis and recommend suitable solutions to real time performance issues
• Performed regular audit and evaluate the quality of customer services being delivered and issue periodic reports on the same
• Handle inbound calls and provide one-call resolution to problems reported Understand and effectively presents and delivers presentations on the suite of
• Teller mate products, features and benefits to new and prospective clients as well as internal clients to promote sales and product development
• Effectively describes the process and value-added benefits of the Teller mate
• Implementation process to new and prospective clients
• Effectively collects product feature requests into user story formats.
• Emtec Inc. Responded to client calls and provided instructions for troubleshooting
• Forwarded client complains to the concerned departments
• Provided technical and analytical support at the call center, Answer inbound calls
• Make outbound calls to potential clients in order to sell the company’s broadband service and computer equipment
• Perform data entry services for the company in regards to punching in customer information, call logs and successful sales

Confidential, Denver, Co

Accountant clerk 1

Responsibilities:

• Work with team to ensure high level of job satisfaction.
• Balancing Bank Entries “checks” from all deferent branches.
• Reconciling Bank accounts from all bank branches.
• Fixing amounts in checks and credit, or debit the outstand balance on the bank ledger and on the customer account.