SUMMARY

• Oracle certified PL/SQL developer with 9+ years of Oracle development experience
• Development experience includes Oracle database design, development, performance tuning and implementation; Creating transformations, mappings and workflows in Informatica; Unix shell scripting; Jobs Scheduling in Control - M
• Extensive experience in creating PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Tables, Indexes and Directory mappings
• Used Explain Plan, hints, partitioning and creating indexes to improve the performance of SQL statements
• Experience in advanced PL/SQL concepts like Bulk collect and ForAll
• Experience includes Oracle 9i/10g/11g, Unix shell scripting and scheduling jobs using Control-M
• Experience in shell scripting, includes file monitoring scripts, data manipulation scripts and data load scripts. Extensively used VI editor.
• Good knowledge of ETL concepts and experience working with Informatica PowerCenter 9.6.1
• Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Proficient in using Informatica Workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
• Strong domain knowledge in Banking and Financial services with specialization in Asset management
• Worked extensively in Agile development model
• Excellent trouble shooting, debugging and error trapping skills
• End to end understanding of SDLC project life cycle which includes requirement gathering and analysis, design, development, review, testing and implementation of Oracle Database applications
• Excellent communication and interpersonal skills from working closely with business and technology teams
• Managed projects as Team Lead and conducted meetings with all levels of management
• Experience in onsite-offshore business model and coordinating with off-shore team
• Exposure on the various tools for project management and quality assurance

TECHNICAL SKILLS

Databases: Oracle 11g, Oracle 10g, Oracle 9i, Sybase, SQL Server

Languages: Oracle PL/SQL, UNIX Shell Script, Java Script, HTML, Core Java, C, C++

IDE Tools: Informatica PowerCenter 9.6.1, Toad, SQL Developer, Rapid SQL, Power Builder, SSRS, Microsoft Visual studio

Job scheduling Tools: Control-M

FTP Tools: Reflection FTP client, File Zilla

Version Control Tools: TFS, VSS, PVCS

Operating Systems: Windows NT/2000/XP/7/8/10

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Senior Consultant

Responsibilities:

• Developing customized reports
• Data loading, paerform validations/calculations and deliver output files/web services
• Creating new report in SSRS by creating ReportBuilder rdls and Sharepoint Web pages
• Receiving and transmitting files via FTP using UNIX scripts
• Using Oracle email functionality to send informational/alert emails and attachments
• Strong experience with batch processes and complex packages
• Optimization of existing PL/SQL Code and Performance tuning
• Maintenance and enhancements to existing application
• Provided subject matter expertise in reviewing, researching and resolving business problems presented in requirements specifications
• Code version control using TFS (Visual studio 2010)

Confidential

Oracle lead developer

Responsibilities:

• Create general technical design and high level design for the system
• Hands - on development activities
• Provide technical leadership to the development team
• Lead Architecture/Design/Development activities
• Follow Agile Scrum processes
• Manage project scope/time/cost for team
• Supervising and Tracking project deliveries using project management tools.
• Monitor project performance and publish status reports to the clients
• Resolving, tracking and escalating critical issues to minimize project risk factors.
• Communicating effectively with stakeholders and manage expectations

Confidential

Oracle PL/SQL and Informatica Developer

Responsibilities:

• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse.
• Extracted the data from SQL Server, Oracle, Files, and Access into Data warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, and Joiner.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Monitor the workflow using workflow monitor and also used to stop, Abort and Pause the sessions while running.
• Extensively used mapping parameters, mapping variables and parameter files.
• Created update strategy and stored procedure transformations to populate targets based on business requirements.
• Implemented Slowly Changing dimension (SCD) methodology for accessing the full history of accounts and transaction information.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Developed, tested stored procedures, functions and packages in PL/SQL for Data ETL.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Involved in generating various reports using Cognos.

Confidential

Oracle offshore lead

Responsibilities:

• Job Responsibilities include design, development and unit testing the Database requirements for the application
• Worked on Agile development model
• Developing the new application database
• Creating new Packages, Procedures, Functions, Tables, Views, Indexes etc. in the database
• Creating UNIX shell scripts for input file parsing and output file transmissions
• Performing code reviews and suggesting code optimizations
• Served as a mentor to junior staff
• Working closely with clients for requirement clarification and UAT support
• Test case preparation and performing Unit Testing and System Testing

Confidential

Senior Oracle Developer

Responsibilities:

• My Job Responsibilities include development and testing of the application
• Database modules transition from one database to another
• Analyzing the old database structure (tables and procedures)
• Creating new Procedures and new Tables in the new database
• Test case preparation and performing Unit Testing and System Testing
• Providing Production implementation and post-prod support

Confidential

Oracle developer

Responsibilities:

• Requirement Analysis
• Responsible for code development and deployment of the application
• Writing the unit test cases and validating the functionalities
• Performed Unit and System Testing

Confidential

Power Builder developer

Responsibilities:

• Requirement Analysis
• Solely responsible for code development and deployment of the application
• Creating unit test cases and validating the functionalities
• Performed Unit and System Testing
• Performed UAT testing along with the client partner

Confidential

Oracle PL / SQL and Power Builder Developer

Responsibilities:

• Requirement analysis, requirement clarifications, design and development
• Enhancements to the existing application and bug fixes
• Unix shell scripting
• Code version control
• Communicating the project milestone completions and status reporting
• Creating unit test cases, performing unit and system testing and creating test logs