TECHNICAL SKILLS:

Operating Systems: Sun Solaris, AIX, Microsoft products, Linux, HP - UX 11, DOS

Handson expert in: Perl, Python, PL/SQL, SQL (Oracle, Microsoft, PostgreSQL, DB2 flavors), VBA/VB, Shell scripting both Unix and DOS, VBScript, UML, JavaScript, Java, Pro*C, XML, C/C++, Lingo, Prolog, Veriwell Hardware Simulator

Databases: Oracle 8.0-11g r2, Netezza, MS SQL Server(6.2-2008), MySql 4.0, MS Access, FreeBSD, Progress 9.1D, DB2

Applications Servers: Oracle 10g Application Server OEM, Oracle 11g RAC

Analytics & Reporting: OBIEE, Oracle Warehouse Builder, Informatica Power center, Microstrategy, Oracle Discoverer, Talend, Pentaho, Business Objects 4.0, Cognos

Tools: ERStudio, ERwin, Toad Products, Aginity, DBArtisan, SQL*Navigator, Oracle RMAN, SQL*Loader, MS IIS, Apache, Visual Studio Application Suit, JDeveloper

PROFESSIONAL EXPERIENCE:

Confidential

Technical architect

Responsibilities:

• Ground up BI platform deployment: Cognos, IBM InfoServer with Netezza centerpiece.
• End-to-end setup configuration and automation of Netezza backend (server admin & dba).
• Integration and configuration of IBM Information Server components (FastTrack, Business Glossary, DataStage, Cognos) with Netezza and Oracle.
• Installation and configuration of IBM Information Server and Cognos Server.
• Hand on development: shell-scripting, automation, data integrity testing, SQL, NZPLSQL.
• Performance tuning, optimization. Solving complex data movement problems.
• Specializing in process optimization and task automation. Netezza best practices expert.
• Main subject matter expert for Netezza appliance.

Confidential

Data Architect / Netezza Admin/Developer

Responsibilities:

• Key technical resource for enterprise wide Database Platform Upgrade project from for Mainframe to Netezza.
• Netezza configuration, set up, migration, development, hard-core tuning.
• Intergrade and tune DataStage ETL processes. Database design tuning.
• Expert technical advisor on implementation and troubleshooting issues.
• Performance optimization. Automatic programming: programs writing programs.
• Integration of IBM Financial Standard Data Model at Netezza with DataStage ETL.

Confidential

Lead Data Architect

Responsibilities:

• Design and develop VLDB Enterprise data warehouse system Oracle 11g RAC & Netezza.
• Managing expectations and deliverables closely working with senior management and business users.
• Implement business process automation, design and implement ETL processes
• Designed and implemented automated data quality test processes, with early notification controls.
• Senior expert in database tuning, code tuning, code refectory, model redesign.
• Design data mining procedures, implement prediction models, and advanced statistical calculations.

Confidential

System Developer (consultant)

Responsibilities:

• Designed and developed online transitional system with Oracle-based processing engine.
• Implemented automated predictive analytics engine in PL/SQL and Oracle data miner.
• Designed and implemented asynchronous Oracle - based file parsing, archiving and storage system to facilitate online user experience.
• Implemented complex user transaction management system for number of administrative users utilizing virtual private database (VPN) and row-level security (RLS) functionality.

Confidential

Data Manager (consultant)

Responsibilities:

• Managing data processes in highly transactional database environment. Integrated dispersed data sources.
• Designed and implemented process flow procedures to ensure uninterrupted and consistent data to service a group of 30+ QA annalists and 40+ Java developers.
• Provided senior expertise in database performance tuning and ETL process implementation.
• Developing strategic vision for the department future, bringing in new professional culture.
• Lead and managed a team of four developers in ground-up end-to-end design and implementation of the enterprise data warehouse along with unified reporting system and standard presentation layer.
• Managing and participating hands-on in several migration projects getting away from legacy mainframe DB2 systems to the Oracle-based platform. Automating the migration of the old reports and processes to Oracle 10g Discoverer and third party reporting tools.
• Designed and implement the processes that integrate the disjointed multi-platform data into one unified Oracle-centric platform. Migrating to Oracle Warehouse Builder ETL.

Confidential

Oracle and SQL Server DBA / Data Architect (full time)

Responsibilities:

• Lead planning, design, implementation, and administration of heterogeneous system with integrated Oracle 4 TB data warehouse for WebMD Business Intelligence Department.
• Lead ground up design and implementation of production data warehouse with end-to-end business process automation and developing and integration a report-on-demand web based system.
• Administering, automating, and tuning database performance, backup, space management, disaster recovery of over the terabyte system. Working with developers tuning application code and SQL.
• Designing and implementing end-to-end ETL process. Heavy programming in PL/SQL, Perl, Java, DOS/shell scripts and Oracle utilities. Complete Linux/Windows OS administration.
• Implementing jobs in Informatica Power Center for ETL data loads from external data sources. Integrating third party databases using the aforementioned tool..
• Implementing highly complex automated reports in various formats: web publishing, spreadsheets, pdf, text, email attached, graph data. Heavy data massaging, parsing, formatting, archiving in Perl.
• Establishing and implementing data cleansing strategies. Designing and imposing system metrics. Justifying business rules and implementing fuzzy logic processing.
• Implemented automated online report-on-demand system enabling users with real time data mining capabilities. (CGI, JavaScript)
• Supporting and writing the online system documentation. Facilitating the documented system errors, ideas exchange, and tip lookup between company developers via centralized BI forum.

Confidential

DBA/Oracle Developer (consultant)

Responsibilities:

• Performed database re-organizations as required assisting performance and ensuring maximum uptime of the databases.
• Created and maintained repository of ER-Diagrams for production and development systems utilizing Embarcadero ERStudio.
• Ultimately responsible for user enrollment. Implemented and enforced security for all of the Oracle Databases.
• Developed triggers, procedures and packages. Conducted code analysis and tuning for best performance (SQL, PL/SQL).
• Performed data transfer using SQL*Loader, Export and Import utilities. Assisted developers with integration of the calls to these utilities from their code modules.
• Produced custom html formatted financial reports for the management staff (SQL, HTML).
• Provided technical support to application development teams. Conducted feasibility studies, contingency planning, and change impact analysis
• Supported web based registration system. Was ultimately responsible for database design and administration. Installed and configured Oracle 8i server on Sun Solaris OS.
• Controlled migrations of programs and database changes through the system development life cycle. Planed and implemented backup and recovery of the Oracle database.

Confidential

Application Developer/Junior DBA (full time)

Responsibilities:

• Designed and developed Securities Management System.
• Designed and implemented user entitlement module to give system administrators the full control on user/group rights. Developed Custom Reporting System (C++, Unix, HTML).
• Created Oracle packages to encapsulate set of back-end tasks supporting the system (Oracle 8.0)
• Assisted Senior DBA with database tuning and performance monitoring. (DBArtisan)
• Performed general technical trouble shooting and consulting the development team.