SUMMARY

• 9+years of experience in IT industry as an Analysis, Design, Development, Implementation and Maintaining the applications in Oracle 9i/10g/11g usingOracle (SQL, PL/SQL) and SQL Server (SSIS, SSAS, SSRS) using Microsoft technologies and Business Intelligence.
• Experience in Avaiation, HCM, ERP domain.
• Strong Experience in designing and developing oracle objects Tables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
• Developedmaterialized viewsfor data replication in distributed environments.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Exception Handling, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Execution Plan, TK - Prof and DBMS PROFILER.
• Familiar with SQL*Loader to load data from external source like flat files into database tables.
• Knowledge of creation of Oracle/SQL Users, Roles, and privileges.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Proficient in creating reports using Crystal Report / SSRS and programming DTS and SSIS packages using SQL Server Business Intelligence Studio.
• Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.
• Good experience in Autosys jobs, Automatic Job Alert.
• Proficient in performing various administrative tasks in SQL such as Attaching and detaching database, backup and restore the database, creating users and granting permissions on database.
• Experience in writing JavaScript,VBScript and batch files using DOS Commands.
• Experience in working ICloud Server. Cloud applications can be updated, tested and deployed quickly, providing enterprises with fast time to market and agility. This speed can lead to culture shifts in business operations.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Strong analytical and problem solving skills, excellent communication and presentation skills, and good team player.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i

Database tools: SQL Server 2000/05/08/12, PL/SQL Developer, SQL* PLUS, SQL Loader, Oracle Forms 6i, TOAD, Oracle Enterprise Manager, Data Stage.

Operating systems: MS DOS, Windows 9x/NT/XP

Languages/Utilities: VB, ASP, HTML, JavaScript, T-SQL, SQL, PL/SQL, HTML

Server: On-premises, Icloud.

PROFESSIONAL EXPERIENCE:

Confidential - Cherry Hill, NJ

Senior - SQL Server Developer

Responsibilities:

• Applications is existing from the year 2016 and Mobility services.
• Document the solution definition for Business intelligence Reports like Crystal report & Qlikview & Finance enhancements.
• Involved in developing, implementing, and project supporting using SQL Server 2008, T-SQL, Stored procedures, user defined functions, triggers, views, complicated queries, indexing, etc.
• Client older version data bases migrated into systems thru Oracle Data Integrator is an Extract, load and transform tool uses for a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
• T-SQL Queries for Adhoc reports for customer daily day to day transactions.
• Defects simulation & resolution through adherence / compliance to quality standards.
• Understanding the business requirement from customers for enhancements and customizations. Liaising extensively with clients for functional clarifications.
• Created data queries and reports using QlikView, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Performance tuning with the help of SQL Profiler and Analyser tool to find the long running queries in existing back end 2012.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development. Designed, developed and tested software using Agile Methodology.

Environment: PL/SQL,SQL Developer,QlikView&SSRS

Confidential - Baltimore, NJ

Senior - SQL Server Developer, PL/SQL

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures, Functions, T-SQL and Packages in PL/SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Extensively used Dynamic SQL, REF Cursors, Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Performance Tuning of the SQL queries, which takes long time to process the request using SQL Profiler, Query Analyser, Explain Plans to reduce the response time.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• For the reporting MS Visual Studio using SSIS, and SSRS with extensive complex queries.
• Complex logic using T-SQL in stored procedure used for deriving financial SSRS reports and transactions.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Involved in writing test cases, unit analysis and integration testing for the development. Designed, developed and tested software using Agile Methodology.

Environments: SQL 2012, PL/SQL,SSIS, SSRS

Confidential - Spring Field, Massachusetts

Senior SQL Server Developer

Responsibilities:

• Prepared program specification for the development.
• Created new UI for requirement.
• Developed new Tables, views, triggers, cursors, stored procedure, T-SQL, functions and SQL scripts.
• Executed SQL blocks using cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Client older version data bases 2002 migrated into systems thru an Extract, load and transform tool uses for a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
• Created numerous processes through MS Visual Studio (SSIS, SSAS, and SSRS) and MS SQL Server 2008/2002 to develop a data warehouse project.
• Modified existing code and developed procedures to perform certain function.
• Created partitioning, indexes and Explain plan for Query Optimization.
• Created test scripts and test cases to perform Unit and integrated testing.
• Worked on Code Reviews for the code developed by other developers.
• Prepared technical and release documentation.
• Designed, developed and tested software using Agile Methodology.

Environments: SQL 2012, PL/SQL,Crystal Reports

Confidential - New Jersey

Senior - SQL Server Developer / PL/SQL Developer

Responsibilities:

• Prepared program specification for the development.
• Created new UI for requirement.
• Developed new Tables, views, triggers, cursors, Stored Procedure, T-SQL, functions, packages and SQL scripts.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Involved in developing, implementing, and project supporting using SQL Server 2008/2012 database. T-SQL for Adhoc & SSRS reports.
• Complex logic using T-SQL in stored procedure used for deriving financial SSRS reports and transactions.
• Performance Tuning of the SQL queries, which takes long time to process the request using SQL Profiler, Query Analyser, Explain Plans to reduce the response time.
• Defects simulation & resolution through adherence / compliance to quality standards.
• Liaising extensively with external and (or) internal clients for functional clarifications.
• Designed, developed and tested software using Agile Methodology.

Environments: SQL 2005, SQL 2012, Microsoft SSIS, SSRS,PL/SQL

Confidential - Portland - Oregon

SQL Server Developer

Responsibilities:

• Created numerous processes through SSIS,SSRS Reports and MS SQL Server 2008 to develop a data warehouse project. Some of the reports migrating from Client old system Crystals report. Provide training on BI reports.
• Developed numerous ad-hoc queries and reports to collect and present information that satisfied clients and contributed to achieve organizational goals.
• Develop new reports using T-SQL/ Automatic Job Alert alerts based on business criticality and gaps identified.
• Generated database design to the highest level of scalability and performance.
• Created database Triggers for the security purposes and Auditing data.
• Creating SQL, Object Views, and database objects. Developed the stored procedures for data transformation purposes.
• Involved in developing, implementing, and project reports using SQL Server 2008.
• Understanding the business requirement from customers for enhancements and customizations.
• Integrated functional and Regression testing
• Designed, developed and tested software using Agile Methodology.
• Involved in daily stand up meeting and weekly demo for each sprint.
• Create complex JIRA workflows including project workflows, field configurations, screen schemes, permission schemes and notification schemes.

Environment: Environments: SQL 2008, Crystal Reports, SSIS,SSRS

Confidential, Houston - Texas

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures, Functions and Packages in PL/SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Extensively used Dynamic SQL, REF Cursors, Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and worked on Oracle databases which is to develop and maintain for the real production environment.
• Jasper reporting is extensively used in PL/SQL Scripts.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development.

Environment: Oracle 9i, SQL, PLSQL, SQL Developer,Jasper Report.

Confidential

SQL Developer

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Procedures, Functions and Materialized Views, Dynamic SQL, Database Triggers and involved in creating to meet business requirements.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.
• Responsible for analyzing, Design and developing the code logic in SQL databases which is to develop and maintain for the real production environment.
• For the reporting purpose extensively used SQL Scripts.
• Document the solution definition for Business intelligence Reports like Crystal report & Finance enhancements using MS SQL Server 2008.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development.

Environment: SQL Developer, Crystal report.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed Oracle objects such as Tables, Views, Indexes, Procedures, Functions and Packages in PL/SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Extensively used Dynamic SQL, REF Cursors, Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and worked on Oracle databases which is to develop and maintain for the real production environment.
• Document the solution definition for Business intelligence Reports like Crystal report & using PL/SQL.
• Created Unit Testing Document with all possible Test cases/Scripts.
• Involved in Unit testing, System testingto check whether the data loads into target are accurate.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and integration testing for the development.
• Prepared technical and release documentation.

Environment: Environments: Oracle 9i, Jasper reports, Crystal Reports