SUMMARY

• 6 years of extensive experience as a software developer in Oracle based applications.
• 6 years of professional experience in developing applications in Retail Domain.
• Strong Analytical, problem solving, and process oriented background.
• Experience working with relational data modeling
• Experienced with all Software Development Life Cycle - Design, Development, Testing, Deployment, Maintenance, Support and Enhancement.
• Test Driven Development and Agile software development experience.
• Rich experience in data modeling, database integration and database performance.
• Professional expertise in Oracle 10g/11g.
• Experience with data warehousing and ETL processes.
• Hands on experience with Netezza Database.
• Hands on experience with NoSQL database MongoDb.
• Expertise in creating Stored Functions, Packages, Procedures, Dynamic SQL, Ref Cursors and Bind Variables.
• Professional expertise in SQL and PL/SQL programming, developing database triggers, Functions, Procedures, Packages.
• Have worked in creating applications in PowerBuilder.
• Have basic Java knowledge.
• Participated in collecting the requirements, analyzing the System Requirements.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Experienced in using Explain Plan for SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns.
• Extensively used UNIX shell Scripts for automating batch programs.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.
• Fast and self-studying learner of new and required technologies.
• Possess excellent Interpersonal, Communication and written skills.
• Experience working with relational databases such SQL Server, Oracle etc.
• Expert knowledge Oracle Tools: SQL Developer, PL/SQL Developer, SQL*Plus, Explain Plain
• Expert knowledge with database development methodologies, design and implementation

TECHNICAL SKILLS

Operating Systems: Unix, Windows

Databases: Oracle (11g, 10g), MongoDB, Netezza

Development tools: SQL Developer,Pl/SQL developer, PowerBuilder

Database Languages: PL/SQL, SQL.

Programming Languages: UNIX Shell Programming, Ruby

ETL: Informatica

Configuration Management: Chef

PROFESSIONAL EXPERIENCE

Confidential, Minnesota

Technical Lead / Senior Software Engineer

Responsibilities:

• Content systems are a group of five applications which manages the content displayed in Confidential .com.
• Responsibility includes identifying and fixing any issues related to the content displayed in the Confidential website.
• Helped the team to resolve any Oracle related issues.
• Reverse engineered the existing applications to create the Data Flow and Data Model.
• Mapped the interactions between different content systems.
• Using Chef as configuration management tool worked on to implement the Sharding and Replication in MongoDB.
• Worked along with Taxonomist to create a better taxonomy to display the products.
• Worked with different application teams to stream line the process and data flow.
• Worked on to improve the performance of the daily jobs.
• Worked on to resolve the issue in current systems and suggest process improvements.
• Worked on Oracle, Unix shell scripting.
• Was responsible for providing reports to business on a need basis.
• Helped to identify issues in data and worked on to rectify them.
• Facilitated Requirement gathering for enhancements with business partners.
• Responsible for Design, development, coding, unit testing, System testing, End-to-End testing, onsite-offshore coordination, UAT support and Production implementation.
• The Confidential Program is Data warehousing project with Netezza as Database.
• Responsible for onsite-offshore coordination, UAT support.
• Responsible for data analysis and report generation.
• Facilitated Requirement gathering for enhancements with business partners.

Confidential, New York

Technical Lead / Project Engineer

Responsibilities:

• EPM is a production financial application hosted on Unix Server, and Oracle database. The project involved baseline support.
• Prepared project proposals for business process and system improvements.
• Worked on baseline support, handling regular tickets for data issues and data requests.
• Worked on Oracle, UNIX ksh and INFORMATICA, PowerBuilder enhancements on the application.
• Facilitated Requirement gathering for enhancements with business partners.
• Responsible for Design, development, coding, unit testing, System testing, End-to-End testing, onsite-offshore coordination, UAT support and Production implementation.
• Verify data for upstream and downstream interfaces, applications controls posting and consumption, SOX auditing IT support for financial applications.
• Confidential is an online application which maintains item and bottler information.
• Project uses Oracle as DataBase and Informatica and Pl/SQL objects to work on the data.Front end is built on Java.
• Worked on baseline support, handling regular tickets for data issues and data requests.
• Worked on Oracle, UNIX ksh and INFORMATICA enhancements on the application.
• Facilitated Requirement gathering for enhancements with business partners.
• Responsible for Design, development, coding, unit testing, System testing, End-to-End testing, onsite-offshore coordination, UAT support and Production implementation.