SUMMARY:

• Oracle 7 through 12c, Oracle query tuning and optimizing, Generating Execution Plans, Collections, Analytical functions, Oracle RAC, Oracle clustering, Oracle Replication Enterprise Manager, Oracle EBS 11i, SQL, PL/SQL, Oracle Forms, Oracle Reports, Packages, Procedures, Functions, Triggers, DbVisualizer, ERWin, Oracle E - Business Suite, Pro*C, SQL*LOADER, SQL*Menu, SQL*Net, Toad, SQL Developer, PostgeSQL, Informatica, MySQL 5, MySQL Cluster 7.1.3, Advanced Queuing, SQL, SSMS, SSIS, SSRS, T-SQL, SQL Server, MySQL Procedures, Mysql Triggers, OLTP and OLAP database, Logical/Physical Modelling, Perl, data Modeling, C/C++, Visual C++, Java/JDBC, JQuery, JavaScript, XML,HTML, Perl, PHP, iReport 4.1, C#,MS Access, MS Excel, TCP/IP, tkprof, rlogin, rsh, rcp, ssh, scp, FTP, SFTP, Data Transfer across remote databases, Netware, CMVC, PVCS, SVN, Bugzilla, JIRA, PVCS, CMVC, SQL Navigator, MySQL Workbench, Visual Studio
• Creating Business Requirement documentation, High Level Design, Software Requirement Specifications, Pseudo-Code documents. Test Plan & Test Cases according to Agile & Waterfall environments.

TECHNICAL SKILLS:

Operating Systems: Linux Redhat, Unix, Centos, IBM AIX 5.1 through 5.3, Sun/Sparc 20/81, Sun Solaris 2.x, HP-UX, Unisys U-6000, Windows NT, Windows XP, Windows 2000, Windows 2000, Windows 98, Windows 95, SAN (Storage Area Networks)

WORK EXPERIENCE:

Confidential

Senior Database/BI Developer

Responsibilities:

• Design & Loading of Data Warehouse for Healthcare Systems, Calls & Meals. Monitoring from external systems.
• Negotiated with client & BAs to design optimal architecture. Tuning applications to run optimally on DW environments.
• Design, Development & Implementation of Encounters system for companies like Humana, Centerlite, Integral, Village Care, Extended Care etc. Analyzed inputs from external systems to create a common loading mechanism. Encounters systems gets inputs like CMS, MAO and 277 at state and company Levels. Inputs from Companies are consolidated into database to produce outputs like acceptance and rejection percentages on a regular basis. Process was automated so that files are loaded into Warehouse when available and reports generated on a regular basis.
• Design, Development & Implementation of systems for MSO claims and membership. DBF files received from MSO were loaded into SQL Server database on a regular monthly basis. Interacted with client Humana and BA to set realistic expectations.
• Design Development & Implementation of CAFÉ systems to gauge companies profitability. CAFÉ data was maintained on an external Firebird database. SSIS was used to import data from external database into companies SQL Server to generate reports. Conferenced with BA’s of Firebird to understand architecture and fix inputs needed.
• Oracle 11g,SQL/PL-SQL
• SQL Server rel. 12
• MySQL
• ETL,SSIS,SSMS,SSRS
• Firebird, RazorSQL
• XML,C#, .NET
• Tuning applications to run optimally on DW environments
• Agile/Scrum
• JIRA for issue tracking

Confidential

Developer

Responsibilities:

• Designed, Developed and Implemented of extensions to customized Oracle EBS Price Engine & Fee Engine for Oracle EBS 11i.
• Attended SCRUM sessions with Business to understand requirements and analyze options as per expectations.
• Customizations were done using SQL & PL/SQL to add new functionality according to business requirements.
• Extensions used standardized Oracle APIs as interface. FlexFields were setup to store data needed by these extensions.
• Oracle 11g/12c
• Oracle EBS 11i
• SQL
• PL/SQL, Bulk Collections, Dynamic SQL
• Pro*C
• Oracle Collections, query tuning and optimizing
• Agile/Scrum
• JIRA for issue tracking/Movz’art for version control

Confidential, Boca Raton/Alpharetta

Software Engineer

Responsibilities:

• Company’s business involves providing sensitive information like insurance information, terrorism, driving history etc.
• Development & implementation of software for deploying this information using various technologies like Oracle, MySQL, Confidential, Unix/Linus/Perl.
• Company uses Thor, a multi-node Linux cluster consisting of 500-1000 machines for data refinery and Roxie another cluster for interaction and generating reports for clients.
• Designed and developed automated systems for implementation of software modules for automated deployment using Shell Scripting, Perl, PHP MySQL/Oracle and Confidential .
• Attended meetings to understand requirements and extend functionality by developing flexible mechanisms to deploy new datasets (for Motor Vehicle Records, Driver Licenses etc.).
• Oracle, MySQL, Perl, PHP, PL/SQL Packages, Triggers
• Confidential
• Sun Solaris, Linux, Windows 7
• Unix/Linux shell scripting, Perl
• Ab Initio
• Perl/PHP/XML
• SVN version control

Confidential, Fort Lauderdale

Senior Software Developer/DBA

Responsibilities:

• Managed and administered databases for national and international clients on Oracle and MySQL.
• Performed Data Modeling, recommended and implemented generic strategies for clients.
• Supervised client staff and guided them through problem resolution. Architecture, design and development of generic systems using freeware.
• Developed disaster recovery and tuning solutions for mission critical systems.
• Designed procedures for and performed load testing.
• Application tuning to run optimally on replicated Oracle environments.
• DBA/Developer, Oracle 10g, Enterprise Manager, Oracle RAC, ASM, RMAN,. Replication, SQL, SQL*PLUS, PL/SQL, Packages, Procedures, Functions, Triggers, Pro*C, T-SQL, ETL
• MySQL 5.125, MySQL Clusters 7.1.3, Packages, MySQL triggers
• PostgeSQL
• TOAD, SQL Developer
• Shell scripts, ksh, bash
• AIX 5.3Linux Redhat, CentOS, Windows XP
• Subversion, Bugzilla, CMVC,
• Java, iReport
• LAMP
• SVN Version Control
• HTML/XML
• Partitioned/Non-Partitioned Tables, Temporary Tables

Confidential, Miami

Software Developer

Responsibilities:

• Company’s business invoves Remittance, billing, foreign exchange services and phone cards. Supervised, designed, created and modified Oracle forms and Oracle reports. Designed processes for transfer of custom data to Oracle applications using oracle interfaces. Customized various application modules for utilization of Oracle data.
• Oracle E-Business Suite 11i, GL, HR, AP, AR, Inventory, Sales Compensation, Cash Management
• Oracle 9i, Oracle 8i, Oracle Forms, Oracle Reports, SQL, SQL*PLUS, PL/SQL, Packages, Procedures, Functions, Triggers, TOAD
• Java, JDBC, C/C++, Pro*C
• Windows NT Servers, Windows 2000

Confidential, Fort Lauderdale

Consultant

Responsibilities:

• Oracle 8i, 9i, DBA, Developer, SQL, SQLPLUS, PL/SQL, Oracle Replication, Packages, Procedures, Functions, Oracle Forms, Oracle Reports, Triggers, Pro*C, Developer 2000, Oracle Forms, Oracle Reports, TOAD, IBM Cognos
• Oracle Applications 11g, 10.7, Oracle 8i, GL, Inventory, AP, AR, Cash Management, Billing
• UNIX shell scripting, Perl
• Java
• VB, MS Access, MS Excel
• Lawson
• Linux, AIX, Sun, Solaris, HP-UX, Windows NT
• Consulted for
• Norwegian Cruise Lines - 12 months - Constructed ETL processes for bulk data handling of star and snowflake databases.
• Equitrac Corporation, Miami - 4 months -: Designed cross-tab summary reports.
• Analyzed Oracle Inventory for sub-inventory management.
• Teleware Global, Miami: - 12 months - Telecommunication switching - Administered database.
• Supervised development and design of stored procedures for call routing.
• Designed GUI for real time VCO control. In charge of disaster recovery and tuning.
• Nortel Networks, Fort Lauderdale - 4 months - Converted complex views to snapshots.
• Developed modules to split POs and compute discounts.
• Nations Rent, Fort Lauderdale - 5 months
• Designed and developed PO interfaces, interfaces for invoice matching, asset transfer and inventory tracking.
• Citibank, Fort Lauderdale - 12 months
• Tuned database and developed application using advanced oracle features for faster query execution.

Confidential, New York

Consultant

Responsibilities:

• Oracle 7.2 - 7.3
• Developer 2000, Forms & Reports
• SQL, PL/SQL, Packages, Procedures, Functions, Triggers, Pro *C,
• C/C++
• UNIX, Shell Script, HP-UX servers
• WINDOWS 95 workstations.