OBJECTIVE:

An insightful, result - driven IT professional with notable success, seeks a long term employment with a company that will entail using skills at systems analysis, comprehensive design, and full lifecycle project management. Hands-on experience in virtually all stages of system development and certain to become just teh problem-solving team player teh opening envisioned. A problem solver. A team player.

SUMMARY:

• Over 15 years experience in Data Processing and Applications.
• Intensive experience in Software development using Oracle, SQL Server, Sybase, Visual Basic, VBA, Unix, Business Intelligence, Software Development life cycle.
• Strong programming, system analysis, software design, analytical, problem-solving and communicational skills.

TECHNICAL SKILLS:Languages and Tools: C, UNIX shell scripting (Bourne, Korn), Visual Basic, VBA (MS Access, MS Excel, MS Word), .NET, Powersoft, Java, C#, SQL, T-SQL, Oracle Development tools (PL/SQL, Oracle Forms, SQL*PLUS, SQL*Loader, Oracle internals), HTML, XML, SyncSort, Informatica, BRIO, PowerBuilder, Crystal Reports, Business Objects, Hyperion, Oracle 7.0 - 11g, MS SQL Server, Sybase, PostgreSQL, DB2, Netezza, Autosys, Peforce.

System platforms: UNIX ( AIX , HP-UX, Solaris) , Linux, Windows 9x/NT/2000/XP/7

PROFESSIONAL EXPERIENCE:

Oracle Developer

Confidential, NY

Responsibilities:

• Loading and processing of multiple kinds of data delivered by various methods (MQ, FTP) in multiple formats.
• Established standards in programming
• Creation PL/SQL packages, procedures and extensive usage of PL/SQL tables, cursors, user defined object types and exception handling along with loading data from flat files using SQL*Loader.
• Designed/modified/implemented stored procedures, triggers in Oracle 11R2 using PL/SQL, analysis of teh existing database, BULK loading, Data Partitioning in order to process teh data.
• Improved performance, speed, and error handling.
• Backend support of GUI development
• Designed, developed, coded, tested, documented, and implemented data modeling features.
• Coached junior programmers in development.
• Provided support to users during UAT (User Acceptance Test) and post go-live.
• Prepared teh technical specifications and user's manuals.
• Examined change requests to come up with teh impact analysis.
• Preparation of database for testing, extensive manual and automated testing.
• Production support of all kinds of applications.
• Used Oracle 11R2, SQL, PL/SQL, LINUX, TOAD, SQL*PLUS, SQL*Loader,Perforce, GIT.

SQL Developer

Confidential, NY

Responsibilities:

• Loading and processing of Reference Data delivered by various methods (Message Bus, FTP, E-mail, reading from remote DB using provided API, WEB sources) in multiple formats.
• Creation PL/SQL packages, procedures and extensive usage of PL/SQL tables, cursors, user defined object types and exception handling along with loading data from flat files using SQL*Loader.
• Tuning and optimization of SQL statements.
• Support of staging area, transformation of data for storage in Slowly Changing Dimensions of type 2 and 4, creation and support of snapshots.
• Moving of data and code among multiple development and testing environments, validation of snapshots, preparation of database for testing.
• Creation of ad-hoc and scheduled reports and transmission of them to external divisions.
• Production support of all applications.
• Used Oracle 11R2 (Exadata), SQL, PL/SQL, LINUX, TOAD, SQL*PLUS, SQL*Loader, SVN, Data Pump

Developer

Confidential, NY

Responsibilities:

• Near real time loading of big amount of market data into PostgreSQL database using C, Unix shell, psql.
• Creation of various market reports against PostgreSQL DB using Unix shell, psql, SQL.

Database Specialist

Confidential, NY

Responsibilities:

• Post Trading production support of teh large (10 TB) transactional DB (Oracle 10g).
• Monitoring of teh performance, analysis of teh wait events.
• Tuning of teh database, strategy of indexation, strategy of backup, compression, and space usage, creation of outlines.
• Tuning of separate queries, using hinting, rewriting, refactoring, analysis of explain plan, trace information, tkprof.
• Strategy of purging of database due to global indexes on partitioned tables.
• Reduction of index contention, creation of hash partitioned or reverse indexes, reduction of other kinds of contention.
• Debugging of Java code on backend using autonomous transactions.
• Creation of test plans and testing of Oracle 11 features.
• Configuration of Oracle Streams.
• Strategy of migration of Oracle 10g to Oracle 11g on another OS with different endian.

Developer

Confidential, NY

Responsibilities:

• Near real time loading of big amount of market data (1Tb per day) into Postgres database using C, Unix shell, psql.
• Creation of various market reports against Postgres DB using Unix shell, psql, SQL.

Developer Software

Confidential, NJ

Responsibilities:

• Conceptual data modeling. Logical relational data modeling - normalization procedures, business rules modeling. Dimensional data modeling: facts, dimensions, star and snowflake schemas. Physical data modeling. Design of performance-oriented data models: de-normalization, indexing, materialization, other performance improving techniques. Implementation of constraints and business rules.
• Support of DataWarehouse and OLTP (Oracle 8.0-10g).
• Development, testing, and support of various stored procedures, triggers, ETL processes.
• Design, development of Informatica Mappings to load data to teh DataWarehouse.
• Used Power Center/Mart to design teh mappings with embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank, and Source Qualifier Transformations.
• Creation of complex mappings using Unconnected Lookup, Sorter, Aggregator for population of target tables.
• Reverse engineering of existing projects to extract teh business rules.
• Justifying of business rules and coding using PL/SQL, Unix shell scripts, C programs, SyncSort, FTP.
• Proactively assigned resources to meet workflow needs.
• Production support of all applications.
• Tuning of teh queries and optimization of various processes.
• Creation and scheduling of various reports using Unix features, Oracle features, Excel features, VBA, Crystal Reports, BRIO (with SQR and javascript), and Business Objects XI.
• Creation of ad-hoc reports for top management.
• Development and production support of universes and reports for multiple users within Business Objects XIR2.
• Building Universes using Universe Designer
• Designing and building universes by Objects data model selecting/joining tables
• Creating of Derived tables using custom SQL statements
• Indicating cardinalities
• Resolving teh loops creating aliases and contexts
• Defined logical classes, objects, and hierarchies for analysis and drilling
• Resolving teh possible mistakes in case of teh aggregation of teh duplicated rows
• Building reports using Crystal Reports XIR2
• Administration of CR environment
• Created and maintained reports (including parameterized) with Standard, Summary, Charts, Cross Tabs, SQL, Selection Criteria, Grouping, Sub reports, Running Totals and custom formulas.
• Reviewed, promoted, and scheduled reports created by other developers.
• Building reports using Business Objects Enterprise Java Infoview Web Intelligence reports or Desktop Intelligence
• design, development creating Simple, Complex and Ad hoc Reports
• creating of reports using one or multiple data providers, Merged Dimensions, Union queries
• creating fine-tuning teh reports using Calculations, User Variables, multilevel Breaks, Sorting, Drill, Slice and Dice, custom Lists Of Values, and Alerts
• Used @Aggregate Aware, @Where, @Select, @Variable, @Prompt functions when required.
• Applying Drill Filters, multiple Tab reports with charts, pivots, master/detail report.

Developer

Confidential, NJ

Responsibilities:

• Production support
• Development of new processes using Pro*C, PL/SQL, and Unix shell scripting (Oracle 7.3 under HP-UX)
• Creation of test plans
• Testing
• Population of test environment with test data.
• Creation and execution of test programs
• Analysis of test results and comparison with expected results according to business rules