SUMMARY:

Highly motivated to work in dynamic environments in OLAP,OLTP systems. Worked from small companies to Fortune 50 companies. Experience in projects with full software development lifecycle with focusing on database application development as well as on software development .

SKILL:

Oracle, SQL, PL/SQL Sybase, DB2 SQL Developer, SQL*Loader, Toad, ETL Tools: ODI, OWB

PHP, GitHub, Symfony, Zend2, PHPmyAdmin, Excel

Erwin, Rational Rose, PowerBuilder, PowerTool Foundation class, APS Case Tool

CICS, COBOLII, VSAM, JCL and Utilities, QMF, Platinum, Windows, UNIX Shell Scripting

EXPERIENCE:

Database Developer/ Data integration Modeler

Confidential

Responsibilities:

• Designing, developing, and integrating multiple subsystems for Data warehouse - centric ETL insurance systemmember of ETL development team.
• Gathering business specification to perform Data modeling, Data integration and Data mappings; defining and developing star schema data models, data partitioning; generating, and executing DDL scripts to develop physical data model.
• Performing Data profiling, Data transformation, and Data quality management; created new calculated functionalities, aggregations;
• Monitoring, and fixing performance problems at the database, and application levels; performed extensive query optimization using Explain Plan, SQL*Trace, TKPROF and Autotrace.
• Building advanced BI reports, formulating and writing complex SQL queries.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Writing database interface using PHP, Git source repositories within Zend2 Framework .
• Writing SQL code for Quoting and Booking functionality, transaction histories, General Ledger module to payoff fees and services for accounts.
• Enforcing data Integrity for different business units.
• Providing application level security for authorized user s access on data - level, role-level and restrictions based permissions
• Creating stored procedures, triggers, indexes
• Upgrading PL/SQL modules into new releases: implementing cursor, collections, bind variable for bulk operations, ref cursors, inline functionsMDX queries, analytical function, data aggregation yielding significant performance improvement.
• Working with inbuilt Oracle DBMS packages, statistics gathering.
• Creating test cases for unit and integrated testing.

Technologies: Oracle (11g/10g/9i), MySQL, PHPmyAdmin, SQL *Loader, TOAD, SQL Developer, PHP4, Apache, Windows, UNIX Shell Scripting

Consultant

Confidential

Responsibilities:

• Writing complex SQL queries that provided creation of demographic and geographic categories definition, bookversion Queries
• Utilized advanced SQL features for asynchronous query execution, dynamic caching services, distributed batch reporting.
• Enhanced existed functionality's for Mockup Issue Planning, Component Query Collection by using extended class libraries for
• Component queries for range, and Active Categories.
• Resolved performance problems; fixed various bugs during release cycle.
• Created reports; debugged and troubleshooted issues.

Technologies: PowerBuilder 6.5, Sybase 11.5x, PowerTool foundation class.

Associate

Confidential, New York

Responsibilities:

• Member of team worked on development of Trading Customer Information System.
• Analysis and design using an iterative approach of component - based architecture; experience working with class diagrams, data modeling, and entity relationship.
• Defined and developed database schema; created stored procedures, triggers for database retrieval, update, and data integrity.
• Developed re-usable business objects, defined business rules.
• Developed datawindows, data validation and business logic objects within framework of foundation classes.
• Supervised two programmers.

Technologies: PowerBuilder 5, Sybase 11.5x, Rational Rose/PB, Power Tool foundation class.

Confidential

Member of the development

Responsibilities:

• Developed a cash flow module to present the cash flow details and cash flow summary for different entity types and entities over the requested period of time.
• Participated in analysis and design of application framework, application flow and modules, including external interface of Control Entries module with Loan Servicer, Property Manager, and Accounting systems.
• Development of a test case security extraction criteria in terms of business rules and requirements for the new Smart segregation System
• Developed test cases for parallel testing of files for all related domestic and international transactions.
• Wrote set of report files, set of reconciliation reports.
• Performed manual, and automated testing.

Technologies: COBOL II with MVS JCL, VSAM and TSO/ISPF.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Analyzed, designed and implemented Human Resources management DSS client - server applications.
• Developed multiple search windows, a user driven dynamic query, composite reports utilizing MDl, Inheritance, OOD, reusable User Objects, embedded and dynamic SOL.
• Created, tested and implemented Stored Procedures, and Triggers.
• Analyzed, designed and developed GUI front - end application against mainframe host transactions using interface for Confidential human resources areas.
• Designed, implemented subsystems for Confidential human resources management tracking and database correction's modules applications utilizing Participated in conversion projects from VSAM-access to DB2.

Technologies: CICS, DB2, VSAM, Flashpoint (KnowledgeWare), RumbaWall and COBOL.