SUMMARY

• Having 10+ years of experience in IT industry specializing in software development and support in the technologies,Oracle 11g, PL/SQL, SQL Server, Informatica, Microsoft Business Intelligence (SSIS and SSRS) ETL, Java and Unix.
• Experienced in Design, Development, Testing, Implementation and Production, support SDLC of
• Data Warehouse, Client/Server, RDBMS and Web Based Application. Involved in Analysis of requirements for the enhancements and preparation of the High level and low level documents accordingly. Used MS VISIO for flow diagrams. Have been part of Agile methodology and waterfall model.
• Involved in meetings with Business analysts and Line of business to understand the existing system and their requirements in the enhancements and feasibility study of the same from the technical perspective.
• Having experience on Oracle and PL/SQL in Creating and implementing few packages, functions, tables, views and Stored procedures, Materialized views. Involved in performance tuning SQLs to make them optimal, effective and efficient. Strong in writing SQL Joins, Nested Queries, Unions and Multi - table joins. Worked with DBA in database migration.
• Having in depth knowledge in SQL server / T-SQL programming. I am involved in creating database tables, views, triggers and Coding Stored procedures in T-SQL as required for enhancements and change requests.
• Created ETL packages in Informatica using Informatica power center 9.0.1 . and SQL Integration services (SSIS) for various data loads and extracts from heterogeneous sources and various types of destinations. Have automated many existing manual processes as part of this and could save significant man-hours.
• Worked on UNIX shell and JIL scripts while creating few SQL and ETL jobs and scheduled using the tool Autosys. Also Perl scripts to find special characters and certain data, substitutions as part of some data masking in the flat files that we receive from neighboring applications.
• Involved in preparation of few Tabular, Graphical reports to the line of business using SQL Server reporting services (SSRS) which serve them as tools to understand the metrics of the past, present and to analyze the road map for the future based on that.
• Managing the offshore team, delegating tasks across the team from onshore to offshore, reviewing the code developed by the team members and delivering it to the customer. Performed code review and code cleanup activities to make sure the coding has been done as per standards and no errors or exceptions. Have been logging the incidents, user issues and tasks in the tool JIRA and have been monitoring the same for the team that I manage.
• Involved in testing the components that are developed by me and our team to ensure no defects would be carried to the higher environments. As part of this, I have Prepared test scripts and actions for the test cases.
• Have been a critical resource that involved in many releases to the production environments working with various implementing teams like database administrators, application server / web server administrators.
• Worked on post deployment verifications and fixes for the code releases. Coordinated with the Line of business team ensuring the releases fulfilled their requirements in the production environment and obtaining their sign-offs for the same.
• Also have been supporting the application issues, user issues that arise on a daily basis. Will be working with users directly in case of any issues that they may face and would resolve the same as per the service level agreement.

TECHNICAL SKILLS

Languages: T-SQL 2008, PL/SQL, HTML, Java 1.4 JSP, Hibernate, PERL, C and C++.

RDBMS / Databases: MS SQL Server 2008/2005/2000 and Oracle 11g.

ETL and Reporting: Informatica, SQL Server Integration services (SSIS) and SQL Server Reporting services (SSRS). I am adaptable to switch to other ETL tools.

Database Tools: Toad for Oracle and PL/SQL developer, SQL server management studio, SQL Server Profiler, TOAD for SQL 2.0,.

Modelling Tools: Microsoft VISIO 2003 and Erwin 4.1

Defect Management Tools: HP Quality Center 9.1

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr Oracle PL/SQL Lead Developer

Responsibilities:

• Involved in creating and implementing several database Tables, Views and packages in Oracle and PL/SQL.
• Coding several Stored Procedures, Triggers and Functions in PL/SQL.Used Collections, Indexes and Partitions as part of the job. Involved in performance tuning SQLs based on the execution plan. Have worked on SQL Loader and SQL* plus. Involved in Data export and import processings.
• Also Worked with DBA in Data base Migration from SQL server 2005 to Oracle 11g.
• Helped Application development team by providing them complex SQL queries to retrieve and data manipulation in their business logic.
• Have been providing technical support by fixing defects and issues since from the development phase till production. Worked on supporting the Java web application. Involved in Hibernate mappings while connecting the frontend application with backend. Also involved in debugging issues in java front for the production and UAT defects that arise.
• Creating ETL workflows in SSIS and Informatica for various data loads and extracts from different types of sources like SQL Server, Text, CSV flat files, Excel to destinations like Oracle, Text, CSV flat files, Excel.
• Worked on UNIX shell and JIL scripts while creating few SQL and ETL jobs and scheduled using the tool Autosys.
• Worked on Perl scripts to find special characters and certain data, substitutions as part of some data masking in the flat files that we receive from neighboring applications.
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for Change data capture. Used several transformations in Informatica.
• Also involved in gathering the requirements with the line of business along with the application manager, technical discussions for analyzing the same, working with various stakeholders for the deployments starting lower environments till production.
• Have been working on several Change requests for the modules from development till they are moved to the production environment.
• Managing and Leading the offshore team, delegating tasks across the team from onshore to offshore.
• Reviewing the code developed by the team members and delivering it to the customer.

Environment: Oracle 11g, Informatica power center 9.0.1, Toad, PL/SQL (Stored Procedure, Trigger and Packages), Erwin and MS Visio.

Confidential, Charlotte, NC

Sr. Oracle,PL/SQL Developer

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the same.
• Analysis of requirements followed by preparation of High level and low level documents accordingly.
• Have used MS VISIO for flow diagrams.
• Responsible for working with DBA and Data Modellers for project coordination.
• Coding Stored procedures, functions and triggers in PL/SQL.
• Creating ETL packages in SQL Integration services (SSIS).
• Also involved in creating few reports for the line of business using SSRS.
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for Change data capture.
• Used several transformations like Aggregate, Sort, Audit, Conditional split, Data conversion, Derived Column, Lookup, Merge, Multicast Pivot and SCD etc.
• Created XML Package Configuration files to make the packages easily portable across the environments.
• Involved in unit testing and fixing the bugs identified and Involved in team weekly and by monthly status meetings.

Environment: Oracle 11g, BIDS (Business Intelligence Dev Studio) Toad, SQL, PL/SQL (Stored Procedure, Trigger and Packages), Erwin and MS Visio.

Confidential

Sr. Developer

Responsibilities:

• Involved in Development of Stored procedures and packages.
• Took part in creation of tables and views in Oracle.
• Prepared High level and low level documents based on the customer requirements.
• Involved in designing front-end screens using Java script, JSP, HTML and DHTML.
• Used JDBC for connecting from frontend to Oracle and called stored procedures and prepared statements etc.
• Helped Application development team by providing them complex SQL queries in their business logic.
• Have been providing technical support by fixing defects and issues since from the development phase till production.
• Have been working on several Change requests for the modules from development till they are moved to the production environment.
• Used Clear case as repository and for version management.

Environment: Oracle10g, PL/SQL, TOAD, eclipse, Java, JSP and Webspere.

Confidential

Software Developer

Responsibilities:

• Involved in understanding the existing manual process, feasibility study of the same to make the application online along with gathering the requirements with the line of business and with few users, technical discussions for analyzing the same.
• Working with various stakeholders for the deployments starting lower environments till production.
• Prepared High level and low level documents based on the customer requirements.
• Involved in Development of Stored procedures and packages and in creation of tables and views in Oracle.
• Designed and implemented the presentation layer using Java Server Pages (JSP), tag libraries, and cascading style sheets.
• Involved in preparing the business logic in JAVA servlets.
• Used JDBC for connecting from frontend to Oracle and called stored procedures and prepared statements etc.
• Have been providing technical support by fixing defects and issues since from the development phase till production.
• Consistently met deadlines and exceeded expectations achieving recognition.

Environment: Oracle10g, PL/SQL, TOAD, eclipse, Java, JSP and Weblogic.