Analyst I - Apps Programmer Resume
NY
SUMMARY:
- I am a logically sound individual with 7years of experience in software development and maintenance, with proven leadership qualities.
- I have in - depth experience in estimation, analysis, design, development and testing of Application database and Back-end patches using Oracle SQLs, PL/SQLs, UNIX shell scripts and XML.
- I have experience working in Finance domain (BankOfAmerica), Capital market( Confidential ), Insurance(MarshGlobalConsumers)
- BankOfamerica confirmed me as its employee with a promotion and increment. The project that I worked involved highly complex business rules, as it is a decade year old. It demanded a 100% focus and involvement to fix and test even minor changes. I proved my expertise though I joined the company after a year's break.
PROFESSIONAL EXPERIENCE:
Confidential,NY
Analyst I - Apps Programmer
Environment: Oracle 10g, Oracle 11g, SQL and PL/SQL, Toad, Unix Shell scripting
Responsibilities:- Developed SQLs, PL/SQLs, and Unix shell scripts to document complex business logic.
- Did the design and development of test SQLs, and PL/SQLs to automate testing.
- Migration happened at the last two months from 10g to 11g, this included some plsqls to be renamed and created for RAC.
Confidential, NY
Senior Software Engineer
Environment: Oracle 10g SQL and PL/SQL, Oracle SQL developer, Java 5
Responsibilities:- Did work break down, planning, work allocation(for a team of 4members) and timely delivery of new business projects.
- Designed, developed and did peer review of SQLs, PL/SQLs that documented complex business requirements.
Confidential
Senior Software Engineer
Environment: Oracle 10g SQL and PL/SQL, Oracle SQL Loader, PL/SQL Developer, Jasper Reporting, UNIX, XML, Java 5
Responsibilities:- Did estimation, Design, work break down, planning, work allocation (for a team of 6members), quality audits, follow up and was responsible for timely delivery of new business projects.
- Designed, developed and fine tuned SQLs, PL/SQLs, UNIX shell scripts, VB macros and Jasper reports to build reports in
- Excel formats that meet the high level as well as daily business needs
- XML format to feed data to web services, text, csv formats to feed to other reporting systems
- Involved in development of java code that feeds velocity webservices with xml's generated by the plsqls
- Migrated and synchronized data from various file formats to Oracle database, using UNIX shell scripts, SQL Loader, SQLs, PL/SQLs and Java. The source files are extracts from the DB2, SQL server, MS-Access database etc.,
Confidential
Software Engineer
Environment: Oracle 9i SQL, PL/SQL, Excel VB Macros, MS-Word.
Responsibilities:- Did a detailed system study at the client location, and transferred the acquired knowledge to team members at offshore.
- Responsible for developing PL/SQL, SQLs, oracle objects needed for migrating reports from MS-Excel to Oracle.
Confidential
Software Engineer
Environment: ASP. Net, C#, ADO. Net, Java Script, IIS 6.0, HTML, Oracle9i, Microsoft.Net Visual Studio 2003, .Net Framework 1.1, Crystal Reports 9, VSS 6.0
Responsibilities:- Did production support and developed the enhancements for this project.
- Responsible for taking project build for deployment of the application at the client end with the changes done for enhancements, and maintaining the same in VSS with proper documentation on the changes.
Confidential
Software Engineer Trainee
Environment: ASP. Net, C#, ADO. Net, Java Script, IIS 6.0, HTML, Oracle9i, Microsoft.Net Visual Studio 2003, .Net Framework 1.1, VSS 6.0, Hyperion Performance Suite 8.2, Hyperion SQR 8.3.2
Responsibilities:- Developed the Referential module of the project. This development involves ASP. Net, C#, ADO. Net, Java Script, IIS 6.0, HTML, Oracle9i, Microsoft.Net Visual Studio 2003, .Net Framework 1.1
- Developed the datamodel, design and query layers of the Hyperion BQY reports.
- Responsible for re-engineering the Datamodel design of reports and re-designing if needed to improve the performance or to fix the bugs.
- Developed and integrated of Hyperion SQR reports.
- Responsible for unit testing and bug fixing.