PROFESSIONAL SUMMARY

• More than eight years of experience in Software Development Lifecycle SDLC as an Oracle developer, involved in complete SDLC including analysis, design, development, testing, implementation maintenance of application software.
• Extensive experience in Oracle 11g/10g/9i databases using SQL PL/SQL Stored Procedures, Functions, Packages and Triggers
• In-depth Knowledge of Schema Objects Tables, Global Temporary Tables, Views, Materialized views, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences, Database links and SQL,PL/SQL features like Partitioning, Bulk Inserts/Updates ,FORALL loops, Hierarchical queries, CURSORS/ REF CURSORS, Regular expressions, Query refactoring, Dynamic SQL, Exception Handling, Autonomous Transactions, Table functions, Oracle XML DB, Pipelined table functions and Flashback Operation Concepts
• Very good understanding of Cost Based Optimizer CBO query plan and various indexing schemes like B-Tree, Bitmap, Function based indexing.
• Experience in Application performance tuning/Query tuning using various utilities like EXPLAIN PLAN, AUTOTRACE, TKPROF, STATSPACK, AWR, ADDM.
• Experience in taking database/Schema/objects backup using database export utilities like EXP,IMP,EXPDP,IMPDP and ETL data load using SQL Loader.
• Experience in Database upgrade from 9i to 10g, 10g to 11g, 9i to 11g.
• Very Good experience with Informatica power center, which is used as a ETL tool to Extract and Load Data from heterogeneous and homogeneous sources Flat Files, Tables, CSV
• Very good knowledge in Data warehousing concepts.
• Knowledge of Job scheduling tools such as AUTOSYS tab to create, modify, troubleshoot jobs, schedule and automate daily/weekly/monthly/quarterly jobs
• Hands on experience in UNIX Shell Scripting, Perl Scripting.
• Very good experience with Data cleansing, conversion and data validation.
• Worked extensively on PARTITIONS to enhance performance and archiving of a DW.
• Good working knowledge in TOAD data modeler, MS VISIO
• Experience in creating various reports using Crystal Reports.
• Experience in providing production support and provide critical and normal patches for technical and business related bugs
• Experience in working with Onsite/Offshore delivery model.
• Experience in creating data flow diagrams, Process flow diagrams, Impact analysis documents and technical design documents for reference and maintenance.
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Capable of forming and maintaining positive and productive working relationships in internal / external and team environments.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Ability to work under tight time constraints with changing requirements.
• Experience in creating data flow diagrams, Process flow diagrams, Impact analysis documents and technical design documents for reference and maintenance
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Capable of forming and maintaining positive and productive working relationships in internal / external and team environments.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Ability to work under tight time constraints with changing requirements.
• Self-motivated, diligent with the ability to quickly adapt to new environments and changes.
• Exposure to stages and methodologies of SDLC- agile/scrum, Water fall development methodology.
• Good understanding of the .net applications.

• Database Technologies: Oracle 9i/10g/11g, MS SQL 2005/2008, Sybase 12.5 /15.5
• BI/ETL Tools: INFORMATICA 8.6, 9.0.1 , AUTOSYS , SSIS
• Development Tools: SQL PLUS,TOAD, PL/SQL Developer, SQL Developer
• Source Control Software: Visual Source Safe VSS , SVN, Perforce.
• Operating Systems: Windows 2003/XP/Vista, Unix
• Web: XML, CSS , Cloud SalesForce
• Scripting language: VBScript, Shell script
• Object Oriented Language: Java
• ECM systems: SharePoint
• Reporting: Crystal reports
• Domain Knowledge: Banking and Financial Services, Securities , Insurance

PROFESSIONAL EXPERIENCE

Confidential

Sr. Developer

• PCS group in Capital Group Companies is into a full-service private client group, managing some 18 billion in equity and fixed-income assets for a select group of high-net-worth individuals, trusts, foundations and endowments nationwide.
• Projects Pluto, CRMS, Risk Matrix MSCI , SellHold Analysis, QUAD, PCSCentral SalesForce , Table Maintenance and xPresso
• Excellent analysis and problem resolution skills under high pressure environment.
• Successfully supporting .net application.
• Deployed .net applications to production using application release team.
• Worked on several complex projects for server consolidation and application porting.
• Sql Server upgrades 2000 to 2005.
• Performed development, code review, packaging, staging, deployment support activities to support complete SDLC cycle.
• Worked on the query optimization of long running SQL using EXPLAIN PLAN, AUTOTRACE.
• Autosys job design and development.
• Supporting and troubleshooting .net application for reported bugs from business.
• Troubleshooting windows services on application.
• Preparing efficient solutions for the client based on the requirement.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers with extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into the application.
• Wrote large complex SQL scripts for database object management and space management to move / rebuild indexes / tables and reporting packages.
• Design and develop powercenter workflows for various data feeds like via, XML, Flat file, databases, salesforce.
• Active participation in agile ceremonies like scrum, sprint planning, retrospective.
• Salesforce integration using Informatica powercenter.
• Coordinated cross testing with upstream and downstream system.
• Facilitated and monitored program issue resolution, risk identification and mitigation plans.
• Managed and facilitated Program Change Management Process.
• Performed impact analysis for all change requests.
• Ensured integration among all the teams and managing multi location offshore development teams.
• Sprint planning and review after complete with team members.
• Developed crystal reports as per business requirement.
• Cross functional team like departments like quality assurance, middleware, Operations coordination for project execution.
• Created Oracle views, functions, procedures, triggers, synonyms, packages using PL/SQL SQL to develop new modules.
• Documented technical specifications and technical manuals for future reference.
• Mentored and coached junior team members.
• Successfully supporting client environment in 24x7 model.

Environment:- Oracle 11g, Sql Server 2000/2005, Sybase 12.5/15, Autosys R11, Informatica Powercenter 9.0, Perforce, Quick Build, Jaws, Unix shell scripts, Crystal reports 2008, .net 4.0 , visual studio 2008.

Technology rationalization Oracle Upgrade and server consolidation - Capital Group Irvine, CA As part of technology rationalization project reducing number of server used to host databases and upgrading oracle databases from 10g to 11g was goal of the technology road map for the Capital Group. Sr. Developer

Confidential

• Involved in Requirement Gathering, Technical Design, Coding, Testing, Deployment, Post Production Support.
• Understanding of the applications for migration
• Identifying integration points and
• Prepare mitigation strategy for the different components
• Migration support for the applications
• Post migration support to the applications
• Identifying incompatibilities from database versions
• Preparing release plan for the migration day.
• Optimize database systems for performance efficiency.
• Ensure that database design meets performance and quality requirements.

Environment:- Oracle 10g, Oracle 11g, Sql Server, Powercenter, Shell Scripting, Autosys

Confidential

• Senior Software engineer Projects Responsibilities include coding, bug fixing, testing and coordination with the other team members for the overall integration of the project.
• Development and bugs fixes /change of request for further enhancement.
• Unit and System testing of the Features developed.
• Created Unix shell scripts to do various flat file validations, to connect to Oracle database and execute the stored programs, to invoke the informatica workflows, to load data using SQL Loader.
• Developed ER diagrams/ Dimensional diagrams for new requirements.
• Conducted periodical code reviews, peer-to-peer testing and defect preventions.
• Prepare design specifications and functional documentations for assigned database projects.
• Maintain batch data functions for databases.
• Created table functions, Pipelined table functions to do complex data processing inside SQL.
• Wrote several triggers using Autonomous transactions to enable auditing.
• Identifying root cause of an issue.

Environment:- Oracle 10g, Oracle 11g, Sql Server, Powercenter, Autosys, Pl/Sql, .net 2.0, visual studio 2003

Confidential

• Software engineer Bank of America acquired ABN AMRO, so project involved migration of the databases from ABN AMRO to bank of America
• Projects Data Center Migration Assessment
• Involved in project development
• Interaction with global fields for requirements gathering and functional analysis.
• Design and development of the functional and technical document.
• Develop database tables and dictionaries.

Environment:- Oracle 10g, Oracle 9i, Sql Server 2000/2005

Confidential

Software engineer

Confidential

• Involved in project development
• Design and development of the functional and technical document.
• Fixing the bugs/change of request for further enhancement.

Environment:- Oracle 10g, Oracle 9i