Sql Project
Resume:
Papiya Banik
Quincy, MA 02169
Email:********@*****.***
Phone: 617-***-****
Summary:
. 5.8 years of experience in the IT industry, involved in complete SDLC
including analysis, design, development, integration, testing &
maintenance of software business applications.
. Delivered responsibilities as Team Leader, Programmer/Analyst and
Software Developer.
. Excellent experience in PL/SQL programming, SQL Loader, SQL*Plus,
Toad, Oracle Forms(9i & 10g),Oracle Reports (9i & 10g), XML Publisher,
Discoverer, JDeveloper and Unix shell scripting mentored other junior
programmers.
. Excellent experience in Oracle9i,10g writing Stored Procedures,
inbound and Outbound Interfaces, functions, triggers, views,
collections, analytical functions, dynamic SQL & exception handling
also involved in optimization & performance tuning of SQL queries,
stored procedures, functions, triggers & views using Query Analyzer,
SQL profiler.
. Functional knowledge in modules OM (Order Management), PO, AR, INV,
Pricing etc.
. Proved Expertise in Database performance tuning using TKPROF, SQL
Trace, and Explain Plan.
. Established solid skills in programming using SQL and PL/SQL.
. Extensively used TOAD for performance monitoring and managing PL/SQL,
SQL etc.
. Performed bulk Data transfer using SQL * Loader.
. Working knowledge of Oracle Workflow and SOA (ESB & BPEL).
. Proven Expertise in Discoverer using Discoverer Desktop, Discoverer
Admin and Discoverer Plus.
. Customized and developed new Forms and reports using Forms9i/10g,
Reports10g/9i, Discoverer and Oracle BI Publisher.
. Worked on various version controls like PVCS, IBM RPM and SVN.
. End to end R12 implementation project experience.
. Dynamic, self-starter, quick learner with strong sense of
responsibility & positive attitude with proven ability to work as a
team player as well as an individual.
. 24/7 production support and involved in implementation of coding
standards and Data Base change requests.
Technical Skills:
DB Utilities : PL/SQL, SQL * Plus, SQL Loader,
Import/Export, Developer 2000, Oracle Forms (9i/10g), Oracle Reports
(9i/10g), Discoverer Tool, XML Publisher, JDeveloper Tool, SOA (ESB, BPEL),
Oracle Workflow, TOAD etc.
ERP : Oracle EBS 11i and R12
RDBMS : Oracle 10g, 9i
GUI : Oracle Forms, Reports and MSCA (Mobile
Supply Chain Management).
Version Control : PVCS, SVN
Languages/Utilities : C, C++, Java, HTML, PL/SQL
OS : Windows 2000/XP, Windows 7, UNIX
Others : Quality Centre, BMC Remedy tool
(Ticketing tool), SharePoint and WMS, Good exposure in Quality Management
Services (QMS) and PMO activities.
Functional Skills:
. Order Management (OM)
. Inventory (INV)
. Purchasing (PO)
. Account Receivable (AR)
. Pricing Module of Oracle Application 11i and R12.
Availability:
Available immediately.
Education:
Bachelor of Technology (B. Tech), WBUT, India.
Professional Experience:
IBM India Private limited, India Aug 2005 -
Till Date
Designation: Senior System Engineer
Assignment History:
Client : AMWAY (USA) Aug 2009 -
Till Date
Project Name : Alticor Atlas AMS Support & Enhancement
Role : Sr. Technical Designer/Lead
Environment : Oracle 10g, SQL, PL/SQL, Forms 10g, Reports 10g, UNIX,
PL/SQL Developer & TOAD, BI Publisher, Discoverer
10g,SOA(ESB,BPEL),Oracle ERP Release12(R12)
Roles & Responsibilities:
. Worked on the existing R12.0.4 system to add some extra features to
rollout new version R12.1.2
. Production Support for existing applications.
. Communicating effectively with external clients and internal teams to
deliver product's accurately.
. Requirement gathering and analysis, estimation of development, design
of enhancements to the existing application.
. Co-ordinate with client, interact with different teams to collect
business rules/logic and with QA team & production team for completion
of deployment.
. Responsible for performing code reviews.
. Responsible for SQL tuning and optimization using Analyze, Explain
Plan, TKPROF utility and optimizer hints.
. Defect Tracking & Reporting using HP Quality Center 9.2.
. Review of User Manual.
. Preparation of Training Material.
. Involved in bug fixing of tickets.
. Extensively using SVN as version control system to checkin and
checkout the objects.
. Support client in their day to day business issues.
. Managed a team of eight developers acted as team lead for this
project.
. Manage, update and distribute/assign tickets among team members using
Remedy tool.
. Maintain version control of both databases and as well as the front
end. Integrate coding done by the development team and prepare for
deployment.
. Manage codes, documents and Service requests using various tools like
Quality Centre, SharePoint, SVN and HPPM etc.
. Debugging, system/application tuning by identifying long running
reports
. Preparation Unit Test Data.
. Execution of Unit Test Plan Conditions and Test Cases.
. Simulation and Code Walk through.
Client : AMWAY (USA)
Feb 2008 - July 2009
Project Name : Alticor Atlas Oracle Engagement Implementation
Role : Sr. Technical Designer/Developer
Environment : Oracle 10g, SQL, PL/SQL, Forms 10g, Reports 10g, UNIX,
PL/SQL Developer & TOAD, BI Publisher, Discoverer
10g,SOA(ESB,BPEL),Oracle ERP Release12(R12)
Roles & Responsibilities:
. Collecting and analyzing the project's business requirements and
transferring the same knowledge to development team.
. Providing suggestions or helping the development team during the
development stage to meet the client's business needs.
. Communicating effectively with external clients and internal teams to
deliver product's accurately.
. Requirement gathering & analysis, data modeling, design & development
of application.
. Understand Amway's retail business logic. Customers are known as IBOs
in Amway Identify the business rules they want to customize and
incorporate in Oracle standard Order Management cycle and the logic to
identify the changes i.e. customizations of existing order entry
screen and add various custom extensions on it.
. Developed technical specifications for various back end modules from
business requirements. Specifications are done according to standard
specification formats.
. In order to fulfill Amway's chain business logic the standard Order
entry screen was customized. I was a part of Order Management track
and was a key member to understand their business logic and
implement/customize the Oracle ERP to fit in their daily business
activities.Like adding new qualifiers, modifiers, giving promotions
and discounts etc.
. Developed stored procedures, triggers, views, materialized views,
collections, dynamic SQL, cursors & complex queries using PL/SQL.
. Data loading using SQL *loader & performance tuning of procedures,
functions, SQL scripts done using Explain plan.
. Preparation of technical documents for reports (rdf and XML), forms.
. Writing Relevant SQL, PL/SQL, Stored Procedure etc.
. Creating database objects as per the requirements of the project and
future expansions.
. Developed PL/SQL stored procedures, user defined functions for complex
calculations and bundle them into stored package that could be invoked
from the Forms triggers.
. Creating of Tables, Indexes, Sequences, and Constraints as required.
. Coding for both Inbound and outbound Interfaces.
. Preparation of version controlled promotion packages, which include
installation shell scripts and LDT files.
. Perform technical specification review.
. Developed web services in SOA Technology.
. Perform AOL related activities like Request registering and creation
of value sets for reports and interfaces etc.
. Develop Discoverer Reports with Discover Desktop, Discoverer
Administrator and Discoverer Viewer in various modules like HRMS and
AR.
. Maintain version control, of both databases and as well as the front
end. Integrate coding done by the development team and prepare for
deployment.
. Analyzed and designed tables based on small and large database
transactions.
. Utilized Toad in developing all back end database interfaces.
. Responsible for performing code reviews.
. Developed user documentation for all the application modules. Also
responsible for writing test plan documents and unit testing for the
application modules.
. Maintained application between development, testing and production
server and co-coordinated with DBA's for moving database between
development, testing and production.
. Involved in Unit testing and Integration testing with the Functional
Team
. Take part in Quality audits.
. Coordinating Project quality stuffs among team members.
Client : MDS (CANADA) Oct 2005-Feb
2008
Project Name : Common Business Systems (CBS)
Role : Application developer
Environment : Oracle 9i, PL/SQL, SQL, TOAD, Discoverer, Shell
Scripting, ERP Oracle 11i
Roles and Responsibilities:
. Worked on the existing software system and add some extra features and
did enhancement jobs.
. Production Support for existing applications.
. Communicating effectively with external clients and internal teams to
deliver product's accurately.
. Fixed bugs in existing system.
. Requirement gathering and analysis, estimation of development, design
of enhancements to the existing application.
. Co-ordinate with client, interact with different teams to collect
business rules/logic and with QA team & production team for completion
of deployment.
. Supported existing version of the software to clients.
. Creating database objects as per the requirements of the project and
future expansions.
. Developed PL/SQL stored procedures, user defined functions for complex
calculations and bundle them into stored package that could be invoked
from the Forms triggers.
. Creating of Tables, Indexes, Sequences, and Constraints as required.
. Unit test and system test performed for the enhancements.
. Developed stored procedures, triggers, views, materialized views,
collections, dynamic SQL, cursors & complex queries using PL/SQL.
. Maintain version control, of both databases and as well as the front
end. Integrate coding done by the development team and prepare for
deployment.
. Maintained application between development, testing and production
server and co-coordinated with DBA's for moving database between
development, testing and production.
. Development and customization of reports in the areas of Order
management Requisition to Pay, Inventory and Shipping.
. Preparation of Technical design documents, MD070 for reports, forms
and interfaces.
. Writing Relevant SQL, PL/SQL, Stored Procedure etc.
. Coding for both Inbound and outbound Interfaces.
. Data import using SQL Loader.
. Preparation of version controlled promotion packages, which include
installation shell scripts and LDT files.
. Perform technical specification review.
. Develop extraction and loading programs to move data from one server
to another.
. Create value sets for reports and interfaces.
. Support users by solving their problems related to day-to-day
Activities.
. Develop Discoverer Reports in Discoverer Desktop and Discoverer Viewer
in different modules like HR, GL etc.
. Developed new forms and have customized the existing forms.
. Code review and performance tuning of the stored procedure.
. Analyses, resolved and Support Production issues.
. Developed different kinds of reports using reports 9i like before
parameter, after parameter, before report, between pages, after
report, formula Columns etc.
. Developed Tab Canvases in Forms to organize and display related
information.
. Involved in problem analysis and resolution, troubleshooting,
performance tuning and code fixes of various Stored Procedures running
in development and production environment.
IBM Entry level training
Aug 2005-Oct-2005
Contact this candidate