Enterprise Solutions Consultant Resume NY - Hire IT People

PROFESSIONAL SUMMARY:

5+ years of Experience in design and development of Database applications in Client/server environment using Oracle Database PL/SQL Programming.
ExcellentSQL skills, expertise in writing Complex SQL queries, PL/SQL Stored Procedures, Functions and Packages for business needs.
2 +year experience in Epicor ERP.
Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers Using SQL and PL/SQL in Oracle.
Strong in using tools such as TOAD, SQL*Plus, SQL Developer and SQL*Loader.
Experience in Debugging, Testing, and Deploying the Applications.
Experience in communicating with end users when working on Production Support.
Good Understanding of HTML.
Expert in creating inbound and outbound workflows using Epicor Service Connect Version: 5.1.0.0
Expert in creating FTP scripts to send and receive files from different servers.
Expert in creating Technical Documents and User guides
Expert in rdf and Discoverer reports
Expert in Crystal Reports
Expert in SSRS Reports
Expert in creating Epicor BPMs.
Good experience in handling various phases of software development Life cycle (SDLC) including requirement gathering, business and functional specifications, design, development, Enhancements, maintenance, testing and .
Good experience in creating Unit test cases, testing and deploying the components.
Strong interpersonal skills, ability to interact with people at all levels.
Excellentcommunication and presentation skills and a quick learner.

TECHNICAL SKILLS:

Tools: TOAD,XML Publisher, Discoverer, SQL Plus, SQL*Loader, Putty, WinScp, Epicor Service Connect

Languages: SQL,PL/SQL,HTML, ABL

Database: Oracle 11g/10g/9i,My - SQL

Reporting Tools: Crystal reports, Oracle Reports 6i, Discoverer 10g,XML Publisher, SSRS Reports

Other Tools: Putty, Oracle SQL Developer.

Operating System: Windows XP,UNIX

PROFESSIONAL EXPERIENCE:

Confidential, NY

Enterprise Solutions Consultant

Responsibilities:

Interact with the users to analyze business requirements, propose solutions and convert requirements into design documents.
Writing SQL Queries.
Database Objects Recreation on Development after Refresh from Production
Worked on performance tuning of SQL, PL/SQL.
Data migration
Working in Epicor 9.05.701
Creating inbound and outbound workflows using Epicor Service Connect Version: 5.1.0.0
Creating Crystal and SSRS reports
Automated FTP scripts to send and receive files from different servers.
Creating Technical Documents and User guide
Involved in full life cycle implementation including requirement gathering, design, and development and testing.

Environment: Oracle Applications R12, Oracle 9i/10g/11g,Toad, XML Publisher, crystal reports

Confidential

Pl/Sql Software Engineer

Responsibilities:

Analyze, design, develop, implement and test detailed software applications and enhancements according to project requirements using database programming tools like PL/SQL,stored procedures, functions, trigger and packages.
Used SQL Tuning Techniques to prevent performance degradation.
Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
Created Custom Packages, Procedures, and functions according to the project requirement.
Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQLand TOAD.
Applied database concepts i.e. normalization/de-normalization, table spaces, temporary tables, views, indexes, sequences, etc.
Used many database Utilities like UTL FILE, UTL MAIL.
Helped business analyst to prepare the functional document. Prepared technical document based on the functional document and product technical documents.
Environment: SQL developer, PL/SQL, Toad, Oracle 11g, SQL Plus, Reports, Forms,Oracle Alerts