OBJECTIVE

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

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 the existing database, BULK loading, Data Partitioning in order to process the 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 the technical specifications and user's manuals.
• Examined change requests to come up with the 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,

SQL Developer

Confidential

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

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.
• Post Trading production support of the large (10 TB) transactional DB (Oracle 10g).
• Monitoring of the performance, analysis of the wait events.
• Tuning of the 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

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.
• 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 the DataWarehouse.
• Used Power Center/Mart to design the 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 the 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 the 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 the loops creating aliases and contexts
• Defined logical classes, objects, and hierarchies for analysis and drilling
• Resolving the possible mistakes in case of the aggregation of the 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 the reports using Calculations, User Variables, multilevel Breaks, Sorting, Drill, Slice and Dice, custom Lists Of Values, and Alerts

Developer

Confidential

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