SUMMARY

• Over twelve years of extensive experience in Information and Technology focusing in banking, logistics, and retail industry
• 12+ year’s experience working with and developing RDBMS schemas (Oracle, SQL server and MySQL).
• Strong hands on experience in Oracle database administration, production support, installation, configuration, performance tuning, and backup/recovery on multiple platforms like Sun Solaris, Red Hat Linux and Windows
• Database software installation, patch and upgrade to BAT and production servers.
• 3 year’s experience in Data Warehouse and worked on ETL tool such as Informatica.
• Created database objects like Stored Procedures, Functions, Packages and Triggers in Oracle and SQL server.
• 5+ year’s of extensive hands - on experience with Oracle BI Publisher 10g & 11g.
• 11 year’s experience working with Crystal reports.
• 3+ year’s experience working with Cognos, Oracle reports and Oracle forms.
• Excellent team player with problem-solving and troubleshooting capabilities; quick learner, highly motivated and results oriented.

TECHNICAL SKILLS

Databases: Oracle DB (9i-12c), MSSQL ( ), MySQL

Development Tools: Crystal Reports (8-11i), OBIEE, Cognos, Oracle reports, Oracle forms, SSRS, PowerBuilder, Toad, Sql*Loader, Eclipse, Netbeans, Informatica, Warehouse Management System(Exceed), Oracle Retail (RMS, ORSIM, ORPOS, RPM, ReIM, RIB), Oracle E-Business Suite R12

Languages: PL/SQL, T-SQL, VB6.0, Java, JSP, HTML 5, JavaScript, PHP, XML, Mobile jQuery

Platforms: Windows, Linux, Solaris

Web Servers: Tomcat, WebLogic

Fusion Middleware: Oracle SOA Suite, BPEL Process Manager, WebLogic

Packages: MS Office, Visio, Project

PROFESSIONAL EXPERIENCE

Software Developer

Confidential

Responsibilities:

• Develop, test, and maintain complex web integration to hundreds of bank/credit card web sites.
• Design, develop, and unit test applications in accordance with established standards.
• Analyzing and resolving technical and application problems.
• Adhering to high quality development principles while delivering solutions on time.
• Providing third level support to business users.
• Working on Oracle 11g, PL/SQL, HTML, CSS and JavaScript.
• Using GIT for version controlling.
• Zendesk ticketing system for tracking and solving the issues logged by clients.

Database Analyst

Confidential

Responsibilities:

• Daily management, administration, monitoring, and support of Oracle databases on Linux Platform.
• Maintaining various databases in production and development environments using SQL Server 2008/2012 on windows platform.
• Strong experience in report development using Oracle OBIEE(XML, XSLT, SQL and Stored Procedures)
• Working on Oracle Fusion HCM Cloud (11.1.8.0.0 ).
• Creating complex reports and dashboards using Crystal Reports and OBIEE (11.1.1.7.20 ) in Oracle 11g
• SQL server which comprise of sub-reports, graphical reports, drilldown, conditional formatting, complex formulas and running totals.
• Experience gathering and documenting report requirement s, process mapping and data mapping.
• Developed and maintained Oracle PL/SQL code, including packages, stored procedures, and database schema structures.
• Working knowledge of PeopleSoft application.
• Provide training to users about DMTR and OBIEE tools.
• Prepared test scripts, conducted performance testing and documented test execution results.

Oracle Developer

Confidential

Responsibilities:

• Installed and configured Oracle 11g (11.1.0.7.0 ) and Oracle Application 10g (10.1.3.4) on Linux platform.
• Managed daily administration, maintenance, monitoring, and support of Oracle databases.
• Responsible for regular backup, recovery & tuning of databases.
• Administration and configuration of ORPOS, ORSIM, RIB, ORRMS, ReSA and RPM.
• Created reports and dashboards using OBIEE (10.1.3.4). Designed Oracle BI Publisher Data Models, Data sets and Templates / sub templates
• Experience in designing complex RTF, PDF and Excel templates for Oracle BI Publisher
• Worked on Oracle Fusion middleware (SOA suite and WebLogic Server).
• Ran daily batches and processed RTLOGS.
• Updated items & price files for back-office. Monitored daily health on POS (Queue clogged).
• Installation, administration and configuration of POS, BO and CO for new stores.
• Validated sales data of POS, RMS & ReSA.
• Implemented and tested Oracle Financial R12 GL, AP, AR and purchasing modules.
• Performed configuration setup for AP, AR and GL, including budgets, multi-org & multi reporting currency.
• Performed business requirements mapping for GL, AP, AR and Purchasing.
• Logged, monitored and closed Technical Assistance Requests (TARs) online: Oracle Metalink and Oracle Applications Patch Management

Application Analyst

Confidential

Responsibilities:

• Responsible for administration, maintenance, monitoring, tuning, support, backup, and recovery of Oracle databases on Solaris and Windows platform.
• Created and maintained various databases in production and development environments using SQL Server 2005. Installed and configured SQL Server Reporting Services.
• Created reports using Crystal reports, SSRS and PowerBuilder 5.
• Created procedures, packages and functions in Oracle and SQL Server.
• Created and implemented put-away, replenishment and picking strategies.
• Administered and configured WMS, Portal and Boomi.
• Configured WMS as per user requests; checked and resolved billing automation process for errors.
• Deployednew Wex files. Integration of WMS with other client software’s through Boomi.
• Created documents/SOP on DR Exceed servers.
• Installed, configured, and administered of TAMS and Biostar.
• Monitored RF devices & troubleshooting errors.

Programmer

Confidential

Responsibilities:

• Administered and maintained Oracle 9i/10g and SQL Server 2005 on Linux and Windows platform.
• Performed tuning, backup and recovery of Oracle/SQL databases.
• Client/Server technology using Forms 6i & Reports 6i as front-ends with Oracle 9i as back-end.
• Prepared advanced reports using SQL Server Reporting Services and Crystal reports.
• Created procedures, packages and functions in Oracle and SQL Server.

Datawarehouse Analyst

Confidential

Responsibilities:

• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup .
• Supported multiple business functions, like risk analytics team
• CRM analytics team, sales and marketing, and collection teams, for their analytical requirements, scorecard development and implementations.
• Customer interaction on functional and technical matters.
• Managed the production data-warehouse upload.
• Ran 11 upload procedures used for monthly uploading of data from OLTP database to data mining database.
• Defined and managed Service Level Agreement (SLA) with business users.
• Developed procedures, and created packages and functions in Oracle and SQL Server.
• Created reports in Crystal reports and Cognos using Oracle 9i and automated them for weekly, monthly and yearly schedule using Crystal reports.