OBJECTIVE:

A dedicated software professional seeking an opportunity with professional growth, where I can leverage my experience gained with high-tech enterprise software companies.

Experience as project engineer: design, analysis and full project lifecycle (analysis, design, development, documentation, testing and implementation.)
Flexible, able to multitask and work effectively in an independent as well as team environments.
Strong ability to rapidly assimilate and understand the requirements/problems of customers and business users.
Responsible, creative and professional oriented with strong communication and collaboration skills.
Extensive Relational Database modeling knowledge (database design)
Extensive data manipulation knowledge (Understands the concepts of extracting, arranging and manipulating the data)
Experienced with designing reports and queries from the database
Experienced with writing advanced scripts using SQL to analyze data
Experienced with database design and development using Oracle and MS-SQL Server including development of stored procedures and database functions.
Experienced with analyzing, designing and developing applications using Oracle Designer 2000 (Project Builder, Form Builder, Procedure Builder, Query Builder, Report Builder)
Experienced with Oracle RDBMS, MS-SQL, SQL*Plus, PL/SQL.
Experienced with writing Stored procedures, Database triggers and shared PL/SQL libraries.
Experienced with developing user interfaces using Oracle Forms.
Experienced with developing reports using Oracle Reports or Crystal Reports.
Strong knowledge of Visual Basic 6.0 programming language.
Strong familiarity with design techniques that are used to support object oriented programming (Class Modules, ActiveX components, and ActiveX controls).
Experienced with Excel and Access.

Oracle Certified SQL
Oracle Certified PL/SQL
Oracle Certified Internet Application Developer 1
Oracle Certified Internet Application Developer 2

EDUCATION:

Masters of Science in Electro-Mechanical Engineering
Bachelor of Science in Electro-Mechanical Engineering

EXPERIENCE:

Confidential,Data Analyst [08/05 - Present]

• Converted data from different databases to internal products: EO (windows platform) or TWP (web platform).
• Defined and wrote business requirements for conversion development
• Analyzed the data from original systems
• Wrote procedures for validating and cleansing data
• Designed custom scripts to output the errors from original database
• Mapped the data to replicate the functionalities between the two systems
• Developed appropriate and efficient solutions for adapting functionality to new systems
• Wrote custom scripts to create the imports to input the data in the new databases
• Reconciled the data after database conversions
• Created custom reconciliation processes based on the reports provided by the customers
• Developed a process for loading catch-up transaction file to include the exercises that occur during the conversions.
• Wrote custom reports to present the data in the new system to the customers
• Performed system testing for product issues to prove the functionalities
• Provide close client assistance and support regarding new and old functionalities.
• Coordinates changes on databases with clients and Data Center.
• Designed a tool (using Oracle, MS-SQL, Access and Excel) to reconcile the converted data (catch the errors generated throughout the conversion process)
• Performed imports, exports, backups and restores on databases (Oracle and MS-SQL servers)
• Performed data modifications based on customer specification :( updates, inserts, merges, carve-outs, accelerations, splits, re-pricings, reloads, transfers)
• Analyzed and verified data when those modifications were required
• Maintaining data integrity across multiple databases
• Performed research analyses on data issues
• Prepared reports and results of data analysis and collections
• Provided analysis and documentation to support all reporting requests
• Performed upgrades and downgrades on databases (adjust functionalities, analyzing the changes in the table structure and the tables that will be lost, changes in existing import layouts, mapping, and validation)
• Created Excel macros to generate import files.
• Wrote ad-hoc scripts to manipulate data within a database.
• Created utilities for cleansing data and generating test files.
• Created custom Crystal Reports

Confidential,Consultant – ORACLE Application Developer [01/03 – 08/05]

• Performed requirement analysis and developed system specifications
• Modeled data and provided system flow charts along with detailed logic specifications.
• Designed logical and physical database structures.
• Designed and implemented tables, views, constraints and database triggers associated with data utilities and application enhancements.
• Developed stored procedures, database triggers and shared PL/SQL Libraries.
• Designed and developed various forms and reports for supporting end users.

Confidential,Project Engineer [04 / 99 – 08/05]

• Created customized software programs using Visual Basic 6.0 programming language.
• Built intuitive user interface with standard controls and Microsoft ActiveX controls.
• Built an interface to extract from database (using SQL statements)
• Performed requirement analysis and developed system specifications.
• Modeled data and provided system flow charts along with detailed logic specifications.
• Designed logical and physical database structures.
• Designed and implemented tables, views, constraints and database triggers associated with data utilities and application enhancements.
• Developed stored procedures, database triggers and shared PL/SQL Libraries (Back end).
• Designed and developed various forms and reports for supported end users.

Confidential,North Branford, CT. -Project Engineer [08 / 98 - 12 / 98]

Confidential,Meriden, CT. -Design Engineer [05 / 97 - 08 / 98]