SUMMARY:

• Over 10 years of Experience in IT as Programmer, DBA, Business Analyst and QA Analyst.
• 5+ years in Data Analysis, testing software applications, Documenting the Business and Functional Requirements for various projects, 5 years in Oracle, PL/SQL, SQL, Pro*C, Forms and Reports, 3 years in SQL server and T - SQL. Involved in developing and testing of software’s for the major companies, hotels, educational institutes, financial companies, hospitals, telecom and energy companies.
• Involved in Design, Coding and in Data Flow Diagrams.
• Extensively worked on Pro*C in various projects involving data manipulation, data cleansing and data analysis.
• Created Layouts of system Screens and Reports before actual programming.
• Involved in Data Analysis and Data validation.
• Extensively worked on SQL, PL/SQL, Procedures, functions, triggers.
• Provided necessary data validation checks against data entry using procedures.
• Created Stored Procedures in Oracle, SQL server. And queries in Access.
• Generated Documentation for the Code.
• Extensively worked on data imports from various file formats into Oracle.
• Microsoft Certified in Visual Basic technology.
• Worked in 24/7 production support environment.
• Received on the Spot Excellence Award for outstanding work at Confidential .
• Conceptual knowledge of Health Management, Energy and Retail industry and Oracle RAC.

TECHNICAL SKILLS:

Languages: Visual Basic 5.0 (Microsoft Certified) / 6.0, PL/SQL, COBOL, BASIC, ABAP/4, Pro*C, Java/J2EE, Shell Scripting

DBMS: Oracle 11i/10g/9i/8/11i, MS-Access, MS-SQL Server 2000/2005, Informix

OS: MS-DOS, UNIX, Windows 98/2000, Windows NT, IBM AIX

ERP: SAP R/3 (Finance Module), Oracle Financial (AP, PO, GL, AR, OIE)

Reporting: Crystal Reports (Till Ver 8), Active Reports, Data Reports, Business objects 6.5

GUI Tools: Developer/2000(Forms 4.5/6.0, Reports 2.5/6.0), TOAD, 4gl, PLSQL Developer

SC Tools: PVCS, SCCS, VSS

Others: DAO/RDO/ADO, COM, JDBC, ODBC, MQ Series, Test Director, Extra, EZ Tools, ReconNet (Cash Management Tool), Allegro

Web Tech: PWS, VBScript, ASP, HTML, JSP, VB.NET, Web sphere, HTML, OAF

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

• Developed several transformation logics using PL/SQL Functions and procedures to load the external vendor files into Data warehouse.
• Extensively worked on ETL techniques to load various external and internal files into data warehouse.
• Created customized process as per business requirement in FiServ InformEnt Warehouse Architect 9.0, Process Manager.
• Create conceptual, logical, and physical data models in design document to define the informational needs of the DW.
• Developed system test scripts, unit test scripts, detail design documents for the enhancements.
• Develop data extraction, transformation, and loading strategies and document the data movement through data flow diagrams.
• Collaborate and communicate with DBA, BA, and ETL teams to correctly implement the projects.
• Using oracle external tables extensively to improve performance of the file loads.
• Using ASG Zena software extensively for Jobs scheduling by event basis and loading the files.
• Working collaboratively with DBA and Data Architect teams on releases, new development and performance Improvement enhancements and issues.
• Use Oracle OEM for identifying any oracle related issues.
• Support on-call production on a regular rotation basis.
• Developed data Mappings between source systems and warehouse components.
• Created views, pl/sql objects to support downstream applications. Written pl/sql procedures to populate data marts into facts and dimension tables.
• Used parallel, upsert and external tables for data loads from external files to oracle tables using business Transformation Rules.
• Created logical model and deployed the code into TFS architecture using Visual Studio.
• Developed and implemented several deployment documentation tasks and procedures for the team.

Environment: Oracle 12c, SQL, PL/SQL, Shell scripting, Linux, MS Office, ASG Zena, TFS, MS SQL Server 2013.

Confidential

Application Developer

• Worked on both Agile and Waterfall methodology based development and testing.
• Written complex SQL queries against complex database schemas for analysis, data validation and PL/SQL development to support various projects in Commissions systems.
• Created project specific application design documents and test cases based on the functional and system requirements.
• Created new mappings and written transformation rules in Informatica.
• Written various shell scripts to call pl/sql packages for various projects.
• Received two I-Recognize awards for successful completion of projects with no defects and under budget.
• Worked with development and data architect to stream line the database schema objects.
• Helped in optimizing SQL Queries along with development team. Worked with DBA team to create and deploy database objects.
• Worked on Tele Logic tool for configuration management software for code versioning.
• Created Test Cases for unit testing and help testers in understanding the data and the process
• Work with QA team, create and manage system/regression test cases and user accepting testing scripts for all the projects.

Environment: Oracle 10g, SQL, PL/SQL, Shell scripting, Unix, MS Office, Informatica 9.1, Control-M, TeleLogic.

Confidential

Oracle/SQL Server DBA and PLSQL Developer

• Assist with the establishment and management of user access processes; design and implement security architecture and fine grained access controls.
• Involved in Data migration from SQL server system to Oracle. Written various scripts to load data between systems.
• Monitor security breaches, error logs, log space, user activity and resource utilization of production environment
• Collaborate with project teams as required, and assist application programmer in determining needs, setting priorities, creating project plans and setting schedule for installations/upgrades
• Maintain the ERP project team's self-service and .NET applications.
• Provide assistance in SQL, PL/SQL development and tuning
• Applying and testing Oracle patches; apply application patches from vendors in non-production and production environments
• Provide after-hours on-call support and document all related procedures
• Maintain and upgrade ERP modules and applications that are part of the Sungard Banner ERP eco-system.
• Document and implement procedures for database backup and recovery using various technologies.
• Develop, maintain, and implement procedures to guarantee the accuracy, accessibility and responsiveness of the database environment, ensuring optimal database performance and availability including the identification, analysis, and resolution of complex database issues.
• Provide assistance to applications developers in the effective use of database query and programming languages.
• Become a resource on a variety of database integration issues including migration between disparate databases, data conversion, capacity planning, and new application deployments.
• Developed components of applications packages using SQL, PL/SQL, HTML, and CSS. Captured and refined users requirements as a part of new development. Performed Data Analysis and User Acceptance testing as needed mainly using the tools SQL Developer, MS Excel, SQL.
• Create, maintain and refresh required Oracle instances/databases for development, test and production environments.
• Design and implement new standards, procedures and supporting scripts for Oracle installation and administration Help the development team with performance tuning and code rewrites.
• Create, maintain and upgrade development, QA, integration and pre-production database environments.
• Development and production Oracle DBA for Oracle 10g on Windows. Creation and maintenance of 10g standby databases using RMAN and Import/Export Utilities.
• Achieve day-to-day operational database administration and data management, proactive monitoring and support Participate in 24/7 support.
• Used Link Server to retrieve ERP data from Oracle to SQL Server.

Environment: Oracle 10g, Oracle 11i, SQL Server 2003, PLSQL developer, HTML, CSS, RMAN, Forms 10, IIS, VB.NET

Confidential

Oracle/PLSQL Web Reports Developer

• Work with the End users to collect business requirements.
• Wrote complex SQL queries against complex database schemas for analysis, data validation and reporting using PL/SQL.
• Written PL/SQL procedures, functions, SQL Statements.
• Developed SQL scripts for ETL process to load the Oracle data into MS Access environment.
• Work with development and design teams to clarify and communicate functional and technical requirements.
• Developed various reports in web environment using PLSQL tool kit for users to access from Internet browsers.
• Validated the data for reporting purposes to ensure data validity in the reports.
• Analyzed various business process and developed requirements for process changes.
• Wrote scripts to download the oracle data into Access for various reports.

Environment: Oracle 10g, TOAD, SQL, PL/SQL, Shell scripting, Unix, Windows 2003, MS Access 2007, MS Office, HTML, PLSQL Web Tool Kit, Visual Basic 6.

Confidential - Kansas City, KS

Technical/Business Consultant

• Work with the users to collect business requirements.
• Wrote complex SQL queries against complex database schemas for analysis, data validation and reporting using PL/SQL.
• Written PL/SQL procedures, functions, SQL Statements, Views to support the projects.
• Developed SQL scripts for ETL process to load the external data into data warehouse environment.
• Create business and functional requirements documentation in DOORS repository.
• Work with development and design teams to clarify and communicate functional and technical requirements.
• Write and optimize SQL Queries along with development team. Work with DBA team to create and deploy initial schema.
• Use Tele Logic tool for configuration management software for version management.
• Create Test Cases for system and User Acceptance tests, validate the test cases and upload the same into Quality Center.
• Validate the test results from the development team and complete the testing steps in HP Quality Center.
• Work with QA team, create and manage system/regression test cases and user accepting testing scripts for all the products using test director.
• Prepare QA Manual and process maps for each type of testing.
• Create and maintain traceability matrix between requirements and test cases.
• Conduct and complete User Acceptance Test for various projects and various builds.
• Create Test Exit review document for final review before production code drop.

Environment: Oracle 10g, TOAD, SQL, PL/SQL, Shell scripting, C, Pro*C, Unix, EDP, Telelogic, DOORS, Windows 2003, MS Visio, MS Access, MS Project, MS Office, HP Quality Center.

Confidential

Consultant

• The module is tightly integrated with Accounts Payable module.
• Design, code and tested the inbound and outbound credit card interface using SQL loader.
• Extensively worked on writing SQL queries, procedures according to the business requirements.
• Worked in customizing the workflow using JDeveloper as per the requirements.
• Extensively worked on customizing the XML documents based on user requirements.
• Customized the seeded code in Oracle Application Framework and personalization.
• Involved in performance tuning for various PL/SQL procedures and data load programs.
• Developed ad-hoc queries to support business requirements using TOAD.
• Extensively worked on writing interfaces for data loads from AP, AR to OIE.
• Written Pro*C programs to generate internal reports for business validation purpose.
• Analyzed various data structures to write data load programs to retrieve external data.

Environment: Oracle 11i, Oracle E Business suite 11i, Oracle Internet Expense version K, IBM AIX, UNIX, PL/SQL, SQL, ProC, JDeveloper, Oracle Application Framework, Java, XML, HTML, TOAD.

Confidential - St. Louis, MO

Consultant

• Worked with cross functional groups like sales and finance to meet their schedules and deadlines.
• Extensively worked on building complex views, SQL using 9i/10g features for reporting.
• Worked in system integration and object-oriented software development.
• Worked from inception, to scoping, requirements gathering, analysis/design, construction, testing/QA, deployment, maintenance/support and change management.
• Wrote complex SQL queries against complex database schemas for analysis, data validation and reporting using PL/SQL.
• Written PL/SQL procedures, functions, SQL Statements, Views to support the projects.
• Worked in Customer Support role to resolve customer complaints with software and responded to suggestions for improvement and demonstrated software to technical and non-technical business users.
• Written Pro*C programs for data transfer between various systems. Used Pro*C as an ETL tool.
• Supported the business users during month-end, quarter-end and year-end financial close cycles.
• Extensively used PLSQL Developer tool for DDL and DML operations.
• Worked on optimizing existing PL/SQL Packages.
• Generated several ad-hoc reports to support Sales and Financial applications.
• Extensively worked in generating reports from and to Excel to MS SQL Server.

Environment: Oracle 10g/9i, Visual Basic 6.0, MS SQL Server, PL/SQL, SQL, Pro*C, Allegro 7.7, VB .NET 2.0, PLSQL, Developer, Win XP, Business Objects ver 6.5, Zabo, VSS.

Confidential- Kansas City, KS

Technical Consultant

• Payment Operations Enterprise Tool is an Accounts Receivables tool which handles and reconciles the Payments from the bank to Treasury.

Environment: Oracle 8.x/9.x, PL/SQL, SQL, VSS, PLSQL Developer, Extra, Visual Basic 6, ReconNet, MZ tools and Win XP, VB.NET.

Confidential, Rochester, NY

Technical Consultant

• Worked on Paychex Accounts Receivables Invoice System is a field database that store’s all billing information. When the field runs a payroll or the month end billing process, the EIP records are inserted into the PARIS System. The Fetret—Fetch and Return process copies this information from PARIS into the corporate system. ACH records are then automatically created and sent to the bank.

Environment: Oracle 9i/10g, Oracle 9 IAS, Forms 6i, Reports 6i, PL/SQL, SQL, SQL Loader, Pro *C, Unix, Rational tools, Clear Case, Toad, Win XP, SQR and Shell Scripting.

Confidential - Kansas City, KS

Technical Consultant and Lead Oracle Developer

• Worked on CIRAS CIRcuit Administration System; a standard engineering system that provides an industry standard design process for Access and Non-Access Circuit Provisioning, Facility, and Trunk Design. This is an Inventory Management System. Worked on C2P Circuit to Packet Edits involved in analyzing programs with the current business requirements.
• The work involved was studying the CIRAS forms and mapping it into Excel spreadsheet for analyzing the current business process. Document the program flow and logic to identify the obsolete code.
• This project is a conversion project. Worked on CIRAS production support involved in fixing the data and code problems. Users will open a ticket (bug) if they find any problems in CIRAS system. Using Forms 6i and Reports 6i and Oracle 9i as database on Unix Aix Servers.

Environment: Oracle 8/9i, Forms 4.5/6i, Reports 2.5/6i, PL/SQL, SQL, SQL Loader, Pro *C, Unix, PVCS, Toad, Test Director, Win NT, MQ Series and Shell Scripting.

Confidential, California

Oracle Developer

• USL Financial Systems was a conversion project (from SQL Server) involving complete reengineering the existing applications to Oracle environment using Developer 2000 in client server technology on a 3 - TIER System. The total system involved 7 modules; Account Receivables, Account Payables, Control System, Purchase Order, General Ledger, Inventory and Payroll. Involved in designing, coding flowcharting the Processes and created written specifications for the scope of new Application. Created database triggers according to the business rules. Created complex queries (stored procedures) to control from the back end.
• Created Layouts of system Screens and Reports before actual programming. Developed Stored procedures, Triggers for validation against user inputs. Reporting tool used to create ad-hoc reports was in Oracle reports.

Environment: Oracle 8i, PL/SQL, SQL Server, TOAD, Win NT, PVCS.

SAP(ABAP) Consultant

Confidential

Environment: SAP R/3 4.6C

• Role in the implementation phase was a team member. The implementation was in FI/CO and CD (Collection and Disbursement) modules. The project involved in data transfers from the legacy to SAP system. The interfaces were online with business process validations.

Environnent: SAP R/3, ABAP, Oracle, Win NT.

Confidential, California

Technical Consultant

• System involved in the reconciling the Accounts receivables and cash between the company accounts and bank statements. The system is developed in Oracle Developer 2000 in client server technology. The system has 7 types of files, which we import from the AREV system into the access database, with parsing of the ach, csv, dat, prn, txt files into the Oracle system with parsing routines.
• The transactions are posted (moving from daybook to general ledger) and reconcile the transactions with the bank records. Generated various reports using oracle reports and in the excel spreadsheet. The project involved in developing Financial Reports for Accounts Receivables, Projected Receivables, Cash Reconciliation, Deferred Revenue and Expense Modeling.
• Responsible to code import routines, design the front end, code and Quality Assurance for Financial Reports. Developed detail exception Report’s to identify data anomalies and to assist in reconcilement process. Involved in develop code for returns, return analysis, user profiles, flowcharting, documenting, design and performance tuning of files importing into the system. Designed GUI and developed reports. Developed modules to parse, validate and error processing. Extensively used excel as reporting tool. Developed security modules to restrict the user to access only the specified screens under his work group.

Environment: Oracle 8, Developer 2000, Excel, Win NT and PVCS.