SUMMARY:

• Skilled database architect with over 14 years of experience in business information systems, with last 6 years focused on extensive experience in Data warehousing, ETL development and Datamart applications using Oracle PL/SQL, Unix Korn Shell scripts, AWK, SED, Java and JDBC.
• Excellent Knowledge of data warehousing, design principles, and software architecture.
• Strong in SQL Performance tuning, denormalization techniques and designing flexible and scalable ETL process requiring minimal modification as the Data warehouse evolves.
• Good experience in design and development of high performance ETL applications for very large volume ranging in Tetrabytes of data.
• Strong programming and software design skills.
• Good team player and work diligently to share skills and information with other team members.
• Good written composition and language skills.
• Ability to learn very quickly and apply new skills to existing problems.
• Commitment to quality from requirements through design, construction, testing, and installation.
• Fundamental knowledge in US Financial industry gained by working in companies like Merrill Lynch, Capital One, Standard & Poors and Albridge Wealth Management solutions.

TECHNICAL SKILLS:

Hardware: Intel, SUN, HP, Digital Alpha

Op. Systems: Sun Solaris, HP - UNIX, NT 4(Server/Workstation), W95, W2000, Windows 3.1

Software: PL/SQL, UNIX C, SQL, AWK, SED, Java and JDBC.

Databases: Oracle, Sybase and MS Access

Internet: HTML, JAVA (working knowledge)

Other: MS Office, MS Project, Visio, TOAD, SQL Navigator, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Senior Tech specialist

Responsibilities:

• Design and develop oracle OLTP modules to capture trades as per Business requirement documentation.
• Designed and developed packages, procedures, functions and Triggers in oracle to provide quick response.
• Provide expert advice to improve performance and proper choice of tools for developing a particular module.
• Perform code reviews/ mentor offshore development team.
• Provide UAT testing assistance, release management and production support.
• Interact with users in refining the requirements.
• Produced system architecture diagram in Visio.
• Maintained the Erwin data model.
• Determined appropriate data storage, archive, purge and backup strategies by collaborating with DBA and system Administrators through weekly Meetings.
• Established standards and formulated scripts for sanity checks after major release.
• Maintained multiple database schemas to conduct parallel testing of different phases of GTPL. Involves working with the release team and the development team to synch the database changes for different phases.
• Provided impact analysis on existing procedure due to schema changes and estimating the amount of change required to in corporate the change.
• Provided performance tuning on existing OLTP queries in production as well as development environment.
• Enforced database standards and naming convention.
• Worked closely with the Java developers in providing certain components as web services to other enterprise application.
• Converted the existing Phase I PL/SQL procedure used for loading reporting database to Ab Initio Graphs. Involved in design and testing phase.
• Created an awk, korn shell script to generate multi environment Autosys JIL script.
• Successfully developed and implemented the phase II of GTPL and involved in design of Phase III.
• Designed and mentored offshore team on creating and writing efficient PL/SQL code.
• Responsible for developing PL/SQL functions, procedures, packages and triggers.
• Used Korn shell and PL/SQL procedures and packages for Batch data Loads.

Confidential

Senior Programmer/ Analyst

Responsibilities:

• Created batch jobs to load all incoming asset transactions and position to oracle database using Korn shell, Awk, PL/SQL and SQL Loader.
• Used Korn Shell, AWK and SED to manipulate the flat files received and loaded it into Oracle using SQL Loader.
• Created Korn shell scripts that automatically expands the zipped files and loads it using SQL Loader calls.
• Used Java and JDBC connection for running batch process that could be stopped and re- started by operations depending upon the load.
• Used Java to parallel process certain batch jobs.
• Used DB-Links to copy and mask data for Beta and UAT testing environment setup.
• Used materialized views to speed up aggregate query performance.
• Developed Oracle stored procedures, Triggers and functions with Unix Korn shell scripts to generate monthly, quaterly and annual reports.
• Developed database stored procedures and packages in the backend to implement application business rules and complex reports.
• Involved in Query-tuning and optimization of the stored procedures and sql to enhance database performance.
• Data Warehouse schema design and modeling.
• Database object, such as large partitioned tables, indexes, and synonyms implementation.
• Data integrity verification and database synchronization.
• Database applications development based on PL/SQL, Packages, and Stored procedures.
• ETL tools development based on PL/SQL and Unix Shell.
• PL/SQL performance tracing, execution plan analyzing, tuning and optimization.
• Korn shell and Perl scripts based batch jobs implementation, management.
• Requirement, specification and detail design for data warehouse and data mart.
• Responsible for maintaining the physical database schema in ERWIN.
• Adhoc queries and reports to suite individual clients..
• Demonstrate good communication skills, convey information effectively and timely to co-workers, present ideas clearly and concisely
• Adhere to the SDLC process and coding standards

Confidential

Senior Systems Analyst

Responsibilities:

• Responsible for all development database administrative functions and coordinating with the client DBA.
• Wrote stored procedures, functions and SQL scripts for Data loading and Data cleaning.
• Tuned the databases and application for optimal performance.
• Created packages, procedures and functions.
• Fine-tuned application SQL statements using Explain Plan, SQL Trace.
• Prepared functional, technical, and program specification and design documents.
• Created SQL scripts to execute stored procedures.
• Used SQL-Loader to bring the data from flat files.
• Generated revenue data in flat file to feed downstream applications. Used utl file utility to generate flat files.

Confidential

Environment: UNIX, Powerbuilder 7.0, NT workstation, Oracle 8 i, Shell scripts, Control - M.

Responsibilities:

• Designed and created tables, triggers and constraints for Balance Transfer with Fee module.
• Modified existing Functions in Oracle packages according to requirements.
• Created and Performance tuned a PL/SQL report that queries four tables largest having 75 million records.
• Used nested loops and star joins for performance tuning.
• Consolidated UNIX shell scripts that resulted in synchronous transfer of data files to UNISYS.
• Performed Developer on call duties.
• Documented the existing Baltrax application and created a bug and enhancement log in excel spreadsheet
• Attended user meetings for enhancement modification.
• Participated in migration from Oracle 8.1.7 to Oracle 8i.

Confidential

Environment: UNIX, Powerbuilder, Oracle 7.3/8 i, Korn Shell scripts, Autosys

Responsibilities:

• As a data architect, provided leadership and guidance to the group on all issues pertaining to Oracle development.
• Designed the database in Oracle and ported the exiting information from Sybase database.
• Performance tuned Front-end, SQL Queries and Stored Procedures.
• Created stored procedures and packages in PL/SQL
• Conducted user requirements analysis meetings and involved in user acceptance testing.
• Managed the enhancement of the application.
• Maintained three other Data warehousing systems in Oracle 8i (Automated Journal Entry, Tritech and EMAP Systems) used by finance group. Tasks included user requirements analysis, provide and design database changes to accommodate the enhancements to the ETL Process.
• As a developer on Reporting system which uses OLAP, data warehousing tools and Oracle Express servers to provide budget and forecast reports for the finance group, responsible for developing UNIX shell scripts, PL/SQL Packages and Web reports using HTP package provided by Oracle.

Confidential

Environment: UNIX, Powerbuilder 5.0.02, NT workstation, Oracle 7.3/8.0.1, Shell scripts

Responsibilities:

• Analyzed, designed and developed new modules and user-interface windows for the system according to user requirements.
• Created packages and stored procedures for accessing, validating and updating data in Oracle 7.3 database server in UNIX environment using Sqlplus 3.3.
• Created functions for PL/SQL packages.

Confidential

Environment: UNIX, Powerbuilder, NT workstation, Oracle 7.3, Shell scripts

Responsibilities:

• Analyzed and designed the system using Object Oriented methodology.
• Created packages and procedures in PL/SQL in UNIX environment.
• Analyzed and designed the user-interface in Powerbuilder 5.0.
• Design and developed base classes used by other applications across the department.
• Performance tuned the user-interface.
• Implemented the system using loosely coupled architecture that was unique to the client.
• Used Rational Rose.

Confidential, NJ

Developer

Environment: Powerbuilder, NT workstation, Watcom SQL, UNIX, Oracle 7.3, UNIX, C++

Responsibilities:

• Designed and developed the user interface for Announcement Management System which manages announcement phrases and places announcements on switching circuits used by the Telecommunication Industries. Developed pre-defined and ad hoc reports for this system in Powerbuilder 4.0 and Watcom SQL.
• Managed the implementation and configuration of PNDM system on UNIX platform with Oracle 7.3 as database server. This system provides the physical layout of all the devices in a hybrid of Fiber-optic and co-axial cable loop for telephone lines. Managed the integration of the system everyday using shell scripts and Sublime. Implemented shell scripts that loaded test data in HP UNIX environment using Oracle 7.3. The front - end used C++ .

Environment: Powerbuilder 3.0, Windows 3.1 and MS SQLServer 4.2

Confidential

Research Engineer

Responsibilities:

• Developed a Model in C that can predict the flow of fluids in open channel.
• Developed an experimental setup and used C program to read the input from the sensors to a file which can later be imported into excel for analysis of the experimental result.
• Designed and developed Hazardous waste management system, project tracking, job scheduling and accounting system. These systems use Powerbuilder 3.0 and SQL Server 4.2 as the database server.