• MS SQL Server Design, programming Stored procedures, triggers, database design, TSQL
• Windows 9x/NT/2K/XP server/workstation installation and administration setup user and user rights, printer sharing, TCP/IP, DHCP, DNS, IIS, etc.
• Oracle DBA, Design, programming Stored procedures, triggers, database design, Indexing, linked server, backup restore, etc.
• Visual Studio 2005/2008/2010, C , JavaScript, HTML, CSS database connection via ODBC, ODP .Net, ADO , Infragistics, Janus, ASP .Net, WCF
• SUMMARY: Over twenty-five 25 years combined experience in Programming and Information Technology IT and recently exposed to the AGILE Methodology. Knowledge in various fields as client/server and web development C , ASP.Net, Oracle, JavaScript, HTML, CSS, WCF . Positions held range from: Software Developer, Systems Analyst, Database Administrator, Database Architect, Development Leader, Product Manager, SCRUM Master. Areas of emphasis includes Windows/Web environments, C , ASP.NET, Visual Basic, Oracle Database, Oracle PL/SQL, Oracle Development Tools Forms, Reports, etc. , Linux, different flavors of Unix HPUX, Solaris, etc. DOS, Dbase, FoxBASE, BASIC, client/server programming, MS Access/Excel VBA programming, and Object Oriented application design. TECHNOLOGIES:
• Operating Systems: Windows 9x/NT/2K/XP/7, Linux, different flavors of Unix HPUX, Solaris, etc. , AIX, DOS RDBMS: Oracle, MySQL, MS SQL Server, MS Access
• Web Server: Oracle Application Server, Apache, IIS Programming Language: C .Net/VB6, ASP.Net, HTML, JavaScript, Clipper 5, C, Unix Scripting, Perl, Java, PL/SQL, TSQL Tools Packages: Crystal Reports, MS Office, Janus grid, Infragistics, Toad, Red Gate, Oracle Forms, Oracle Reports, Oracle Enterprise Manager, Oracle Application Express, Oracle SQL Plus, Oracle Designer, ERWIN Hardware: Intel Based PC Servers, Sun Servers, HP Servers, IBM, Linux Based Servers, etc.

PROFESSIONAL EXPERIENCE:

Confidential

Environment : Windows 2003 / Oracle 9i/10g/12g/MS SQL/Teradata/Amazon S3/Hive/HDFS/Azkaban

Tools : PL/SQL, TOAD, Oracle Developer 9i/10g/11g, Oracle Application Express HTML DB ,

Developer Suite 10g, MS SQL Server Management/SSIS, TSQL.

Responsibility :

• Developed and designed Oracle Forms, Reports, PL/SQL, stored procedures, etc.
• Built complex stored procedures used in the application and reports
• Built ad-hoc reports using Oracle Reports and Discoverer used in business analysis, cost forecasting and analysis, project timeline, resource utilization, etc.
• Designed data model and implemented model in Oracle.
• Designed, developed and implemented data integration with other external systems.
• Performed SQL and database tuning
• Assisted DBA's in installing and configuring Oracle RDBMS, Oracle Application Server, Oracle Reports Service, OEM, etc.
• Converted Oracle front end application into MS Win Forms, ASP .net Web forms, MS Reports using C .
• Delivered database capacity planning for new database environment.
• Upgraded Oracle RDBMS from Oracle 9i to 10gR2.
• Setup and implemented backup and recovery procedures.
• Worked as Technical Lead supervising two developers
• Implemented web services WCF using C
• Performed SQL and database tuning
• Participated in Agile Methodology using SCRUM

• Worked on database designing and modelling in a SQL Server and Teradata environment.
• Developed SSIS packages and stored procedures TSQL and PL/SQL to migrate data and synchronize data from Oracle to SQL Server and vise versa.
• Developed complex stored procedures in SQL Server used in the application using TSQL
• Developed complex queries and views in SQL Server and Teradata used in application, BI, and Analytics Report
• Created internal Wiki Page containing the Data Dictionary for the Data Warehouse Teradata .
• Participated in Agile Methodology using SCRUM
• Developed scripts to load data from file from Amazon S3 storage to the Hive repository using Unix scripts, S3 commands, Hadoop utilities, and Azkaban to schedule jobs.
• Perform SQL and database tuning in SQL Server and Teradata

Confidential

Environment : SQL Server/ASP .Net 4.0/Web Forms

Tools : Visual Studio 2008, SQL Server,

Responsibility

• Working part-time as an IT Consultant mainly providing local technical support for database development and production support.
• Also, provide assistance on the application side like bug fixing, debugging, tracing undocumented processes, etc. The application is using ASP.Net 4.0 written on C having a SQL Server 2008 back end.
• Provide database expertise as a consultant by doing performance tuning both SQL and database, assist in developing stored procedures using TSQL, build queries used in application and reports, etc.

Confidential

Environment : Red Hat Linux AS/ES 4/ Oracle 10gr2/ MySQL

Tools : PL/SQL, TOAD, Grid Control, Oracle Application Express HTML DB

Responsibility :

• Installed, configured, and maintained development, test, and production Oracle and MySQL database environments.
• Installed, configured, and maintained Oracle 10g Real Application Clustering RAC
• Create physical and logical database models as per the business requirements
• Performed design and development of database systems using ERWIN.
• Architect database infrastructure for high availability and high performance
• Developed database objects such stored procedures, types, etc.
• Performed tuning on application programs and database setting or configuration.
• Architect a data load process to load about 1TB of data once a month.
• Mentored other DB engineers

Confidential

Environment : Windows 2003/Sun Solaris/ Oracle 9i

Tools : PL/SQL, Enterprise Architect, ClearCase, TOAD

Responsibility :

• Performed database design.
• Developed database objects such stored procedures, types, etc.
• Maintained the development database.
• Evaluated production database environment and deliver recommendation.
• Performed tuning on application programs and database setting or configuration.

Sr. Database Engineer

Confidential

Environment : Windows 2003/Sun Solaris/ Oracle 9i/10g

Tools : PL/SQL, Oracle Designer 9i, Oracle Developer Suite 9i Forms and Reports , Discoverer 9i, HTML DB

Project : ISAS Management System IMS

• Performed tuning on database and application.
• Implemented an emergency backup/recovery procedure.
• Developed management reports using Discoverer 9i.
• Administered the development and production database.
• Administered the Discoverer and Application Server.

Project : Fleet Management System FM

• Analyzed the current application written in FoxPro and documented the system.
• Prepared and presented to management a conceptual design of a new fleet management system.
• Lead the rapid application development effort of the new system using all Oracle 9i tools and database.
• Planned and designed an interface between the new system and an existing Oracle 11i Application Suite, specifically with the HR module and parts of Financials.

Project : Trouble Ticket

• Developed and implemented a trouble ticket tracking system using Oracle 10g database and HTML DB.
• Installed and configured HTML DB used for development.

Consultant

Confidential

Environment : IBM AIX/ Red Hat Linux/ Oracle 9i

Tools : PL/SQL, Perl 5.6, SQL Plus, ERWIN

Project : Data Mart Vehicle Information / ETL

• Designed and developed ETL programs using Unix scripts and PL/SQL.
• Designed data mart tables.
• Documented designed tables and created scripts.

Consultant,

Confidential

Environment : IBM AIX/Windows 2000/Oracle 8i/

Tools : Reports 6i/9i, PL/SQL, Crystal Reports 8.5

• Modified existing PL/SQL programs and Crystal reports to accommodate the converted data.
• Involved in Technical Design of Reports, database structure design and development of interface and conversion programs Unix and PL/SQL .
• Mined business rules from reports and backend programs.
• Documented Impact Analysis on all Crystal Reports and Oracle DB objects.
• Analyzed and design new ETL process.
• Analyzed and mapped the current and the new inbound data.
• Document business rules in ETL programs.
• Analyzed current ETL programs and extract business rules.
• Project: UBP Unified Brokerage Platform Data Conversion
• Project: Historical Correction
• Developed Unix and SQL scripts to load data feeds coming from different carriers.
• Developed PL/SQL scripts to validate incoming data.
• Developed management reports in Oracle Reports, Crystal Reports, and Excel Spreadsheets
• Performed programming tuning to speed up the data load and validation. Also, to speed up the reports.
• Project: ARC Automated Rep Change
• Involved in the Technical Design of Interface programs, database structure and backend programs.
• Developed diagrams and flow charts as part of the Technical Documentations using MS VISIO.
• Developed Unix and SQL scripts to load data feeds coming from different carriers.
• Developed PL/SQL scripts to validate incoming data.
• Developed PL/SQL API packages that are called by a Visual Basic front end.
• Supervised PL/SQL Developers.
• Developed Oracle programming standards to be used in current and future programming.
• Performed programming tuning to speed up the data load and validation.

Programmer, SASCO Electric

Confidential

Environment : HP 9000/HP-UX/Windows 2000/Oracle 9i2/

Tools : Forms 6i/9i, Reports 6i/9i, PL/SQL, Oracle Application Server 9i

Project: PCS Purchasing Computer System

• Conversion of old PCS system from FOXPRO to Oracle both backend and frontend .
• Provided scripts to verify the validity of the conversion
• Mapped data from FOXPRO to Oracle.
• Designed the database structure.
• Implemented the system to remote offices
• Developed Forms, Reports and Procedures.
• Applied enhancements to the system.
• Performed application performance tuning.

Consultant,

Sr. Oracle Developer

Environment : HP 9000/HP-UX/Windows 2000/Oracle 8.05/Oracle 9i/SQL Server 2000

Tools : Designer 2000 1.3/2.1.2, Forms 6i/9i, Reports 6i/9i, PL/SQL, Unix Shell, Oracle Application Server 4.0.x/9i, T-SQL, Perl

Project: IMMS Integrated Manufacturing Management System

• Redesigned both database, screens and reports to integrate with the system in the corporate office SAP System .
• Developed screens and reports using Developer 6i, stored procedures, functions and packages using PL/SQL.

Project: ECF/Transmittal system Engineering Communication Form/Transmittal System

• Redesigned and redeveloped from a Visual Basic/SQL Server 2000 application to an Oracle system.
• Developed screens and reports using Developer 9i, stored procedures, functions and packages using PL/SQL.
• Developed PERL scripts to handle email functionality of the system.
• Managed the project in terms of user communication, schedule and delivery.

Project: TVA Temporary Variance Authorization Application

• Interviewed users and gathered information. Prepared Functional and Technical Specifications
• Developed the database model from logical to physical.
• Designed the User Interface screens, reports, interface, etc.

Project: REPRO MOP

• Converting database from Oracle to SQL Server 2000.
• Started creating T-SQL stored procedures of business rules.