We provide IT Staff Augmentation Services!

Sr.sql Developer Resume

NJ

SUMMARY

  • Over Ten years of experience in analysis, design, development, testing and implementation of applications in ORACLE.
  • Extensive experience working on several databases which include Oracle 8i/9i/10G/11G, MS SQL Server 2000/2005 and MY SQL.
  • Extensive experience in all phases of project such as project planning, requirements gathering, analysis, design, development, execute test plans, implementation, enhancements, training and documentation.
  • Excellent command over SQL, PL/SQL, SQL *Loader, Oracle Forms 6i, Reports 6i, Cognos, Shell Programming and T-SQL.
  • 4 years of proven experience as a techno-functional resource in the field of Contracting pricing, Medicaid healthcare reimbursement and Government Pricing.
  • Trained on Model N Life Sciences Revenue Management Suite both on Functional and technical front.
  • Trained on Sanofi legacy HCRS system.
  • Experienced in identifying and understanding Business requirements, developing technical requirements, Database Design and Troubleshooting.
  • Developed the Unix Shell Scripts (Bourne, Korn and C shell) and automated the Jobs using Cron Job.
  • Designing and developing application schemas, ER Diagram, Tables (Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables), Clusters, Indexes, Views, Materialized views, Triggers, Procedures, Functions and Packages.
  • Implemented PL/SQL advanced topics like BULK LOAD, REF CURSORS, Creating XML Documents and loading data from XML files, Collections and UTL_FILE to read and write the files.
  • Experience in Oracle Data Pump, Export and Import.
  • Experience in Development and maintenance of huge data warehouses using PL/SQL.
  • Proficient in SQL Query tuning using Hints and utilities such as Explain Plan, AUTOTRACE, TKPROF, ADDM and SQL Advisor.
  • Fulfilling daily DBA activities: setting up user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.) and Disk space management (Tablespace, rollback segment).
  • Experience in Backup & Recovery using hot backups, cold backups. Familiarity with RAC, Data Guard and ASM.
  • Proficient in Data modeling using Erwin.
  • Expertise in using job scheduling tools like Autosys, Control M and Cybermation.

TECHNICAL SKILLS

RDBMS Oracle 8i/9i/10G/11G, SQL Sever 2000 and 2005, MYSQL.

Programming Languages SQL, PL/SQL, T-SQL, C, C++, C#( Sharp) Java and Shell Programming.

Utilities SQL Loader, Import, Export, Data Pump

Web Technologies Servlets, JSP, JDBC, HTML and XML

Operating System UNIX (Sun Solaris, HP-UX, Linux) , Windows 98/XP/2000/2003

Development Tools Oracle Forms and Reports (6i, 9i, 10g), Power Builder and Cognos8

ETL Tool Informatica Power Center 8.1.1

ERP Oracle Applications 11i (AOL, GL, AP and AR modules)

Tools Erwin, Microsoft Visio, TOAD, SQL *Plus,

SQL Navigator, PVCS, PVCS Tracker, CVS, Clear Case

PL/SQL Developer, Cybermation, Control M, Axiom Controller view and Autosys

EDUCATION

  • Master of Information Systems
  • Bachelor of Science

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

  • Automated the Medicaid claim import process in the HCRS application using oracle back end packages and power builder power script.
  • Developed new reports and enhancement to the existing Cognos reports.
  • Developed the conversion and interface scripts for ICW system
  • Developed the conversion scripts for HCRS system
  • Performed enhancements to the ICW upstream and downstream systems like SPM, XENON, HCRS, GPGL and CARS.
  • Trouble shooting of the direct sales, which are loaded from SAP system
  • Automated the ROSI/PQAS reports as per the CMS standards.
  • Developed the new URA component for line extension drugs (Healthcare reform PPACA)
  • Processed excel files, XML files and CSV files as the part of the integration.
  • Coordinated with the downstream systems users and upstream systems users to resolve issues.
  • Resolved the production support tickets.
  • Analyzed the existing automated SAP interface and developed the code to stop sending Genzyme checks to the SAP system.
  • Analyzed the existing programs and make sure the credit balance is not updated for the Genzyme checks.
  • Involved in the Design and Development of the ICW 24/7 availability project.
  • Unit tested the developed process, writing the test scripts and writing the implementation plan.
  • Developed Stored Procedures, Functions, Triggers and Packages.
  • Developed Shell scripts to make the jobs automated.
  • Created Tables, Indexes, Constraints, Views, DB links and Materialized views.
  • Developed SQL loader scripts and External tables to load the data from the external systems.
  • Developed SQL queries for data analysis, reporting and tuning the long running SQL queries.

Environment: Oracle 10G and 11G, SQL Server 2005, UNIX (HP), Power builder 10.0, Modeln N, Cognos impromtu, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Control M, Visio, Microsoft Visual SourceSafe, Pl/SQL Developer and Toad.

Confidential

Responsibilities:

  • Created detail design documents for interfaces and conversion.
  • Reviewing the code and writing the automated scripts using shell programming.
  • Maintaining the code and performing code migration between different environments.
  • Created the Batch schedule to automate with the Control M.
  • Performed Export and Import of the databases to refresh the Dev and QA environments.
  • Created the packages, procedures and functions.
  • Written complex SQL queries for the business requirements and validations.
  • Created the documentation for the interfaces and conversion.
  • Developed the cognos reports.
  • Created the java program to create the EDI XML files.
  • Provided support during the integration testing.

Environment: Oracle 10g, UNIX (HP), Java, Modeln N, CPCC, Cognos 8, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Control M, CVS, Pl/SQL Developer and Toad.

Confidential

Sr. SQL Developer

Responsibilities:

  • Developed the interfaces to load the data from various sources like suppliers, Hub and distribution centers. Source files come in different formats like Excel, XML files and flat files.
  • Developed shell programs and automated using cybermation tool.
  • Providing production support to different applications and analyzing the data issues across the different systems.
  • Actively supported business users for change requests
  • Created complex Stored Procedures and functions to support efficient data retrieval and manipulation from the UI.
  • Written complex SQL queries for reporting purposes and written some anonymous blocks so that L2 can execute these workarounds.
  • Performed Database design and Data Modeling using Erwin tool.
  • Interacting with business users and identified the requirements.
  • Performed Unit testing and helping business users in integration testing.
  • Managed the offshore Production support L2 team.
  • Performed Code migration in Dev and QA environment.
  • Fulfilling daily Application DBA activities like setting up user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), logical export and import of the database and performing backup & recovery of the database.
  • Performed performance tuning on long running SQL queries.
  • Modified the functional design document so that the document synchronies with the code.
  • Coordinating with different technical teams like ETL, JDA and Java, Cognos.

Environment: Oracle 10g, UNIX (HP), Java, Informatica, Cognos 8, JDA, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Cybermation, CVS and Toad.

Confidential

Sr. Oracle Developer

Responsibilities:

  • Designed and Developed “Pfizer Integration Project”, “MESA interface” “GL Integration application” and “OTC Mercury Integration Project”.
  • Responsible for making enhancements to the existing databases.
  • Responsible for coordinating offsite team.
  • Created the Stored Procedures, Functions, Packages and SQL* Loader scripts.
  • Improved the performance of SQL queries by creating Indexes on the tables and using Hints.
  • Developed the Shell programs and scheduled using Cron Job.
  • Used the Performance tuning utilities like Explain Plan, AUTOTRACE, TKPROF, ADDM and SQL Advisor.
  • Writing Complex Reusable SQL queries using Inline Views, Sub Queries, Correlated Sub Queries, SQL Analytics and Oracle Hierarchies and documented the queries.
  • Responsible for loading historical data, loading data from Excel sheets and XML data.
  • Export and import database schemas, objects using Import/Export utility.
  • Performed DBA activities like creation of Tables (Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables), Views, Triggers and Database Links.
  • Fulfilling daily DBA activities: setting up user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.) and Disk space management (Tablespace, rollback segment).
  • Involved in Unit testing, Integration testing and documented the results.
  • Involved in entire Software development life cycle (SDLC) of Pfizer Integration Project (system design, development, testing and production support).

Environment: Oracle 8i, Oracle 9i, MYSQL, Unix (HP), Windows 2003, Java, Power Builder, Microstrategy, SAP, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Mainframe, CVS and Toad.

Confidential

Sr. PL/SQL Developer

Responsibilities:

  • Developed CMS inbound and outbound interface and performed enhancements to the interface.
  • Created the SQL* Loader scripts and External tables to load the data from Flat files.
  • Created the database objects like Tables, Clusters, Indexes, Views and Materialized views.
  • Created the Stored Procedures, Functions, and Packages.
  • Tuned SQL queries for optimum result.
  • Developed the Shell Scripts and Used the Autosys for scheduling Jobs.
  • Export and import database schemas, objects using Import/Export utility.
  • Promoting code, Applying data fixes, resolving application related database errors in Production Environment.
  • Debug and Fix production fallouts due to code fixes on a day-to-day basis.
  • Performed database table partitioning, as after consolidation the table sizes would have grown very large.
  • Fulfilling daily DBA activities: setting up user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.) and Disk space management (Tablespace, rollback segment) and Backup & Recovery using hot backups, cold backups and RMAN backups.
  • Performed the Application tuning using Oracle performance tuning tools like Explain Plan, SQL*Trace and TKPROF.
  • Extensively worked in writing SQL Queries.
  • Used Collections like variable arrays, nested tables extensively.
  • Performed the Data modeling using Erwin.
  • Worked with various business groups, functional experts to implement their business and functional Knowledge into working Procedures.
  • Used the PVCS tracker for bug tracking and PVCS for code versioning.

Environment: Oracle 9i, SQL Server 2000, Java, J2EE, Windows 2003, Unix, SQL, PL/SQL, T-SQL, Shell Programming, SQL Loader, PVCS, PVCS Tracker, Autosys, Erwin and SQL Navigator.

Confidential

PL/SQL Developer

Responsibilities:

  • Involved in analysis, database design, development and implementation of Oracle systems.
  • Worked on the designing of the Central customer database and the decision support system.
  • Created various SQL and PL/SQL scripts for verification of required functionalities.
  • Used SQL*Loader extensively to upload legacy data from flat files into Databases and validated the data with PL/SQL procedures.
  • Tuned SQL queries for optimum performance.
  • Created various Database triggers using PL/SQL.
  • Used extensively PL/SQL, to develop Packages, Stored Procedures and Functions.
  • Created the database objects like Tables, Clusters, Indexes, Views, Synonyms and Database Links.
  • Written UNIX scripts to perform batch operations.
  • Extensively used the Imp/Exp tools, parallel processing wherever possible for data processing and to improve the performance.
  • Automated UX Shell scripts using Control - M Job scheduler.
  • Developed and maintained scripts for monitoring, troubleshooting and administration of the databases.

Environment: Oracle 9i, Java, J2EE, Unix, SQL, PL/SQL, SQL Loader, CVS, PL/SQL Developer and Control - M Job scheduler

Confidential

PL/SQL Develope

Responsibilities:

  • Customized the application based on the client’s requirements.
  • Fixed bugs reported by the testing team and by clients.
  • Design, development, testing, implementation and documentation of any enhancements requested by the clients.
  • Created multiple database objects, triggers and PL/SQL packages
  • Created Table level triggers using PL/SQL during data insert and update
  • Tuning SQL Statements.
  • Involved in the testing of new releases of the applications.
  • Involved in the integration of Kenexa Recruiter with Kenexa’s Career Tracker.
  • Prepare estimates for enhancements and change requests

Environment: Oracle 9i/8i, SQL, PL/SQL, Shell Scripts, SQL*Plus, HTML, TOAD, Windows NT/2000.

Hire Now