Summary

• Professional experience in IT industry as Oracle Technical Consultant, MySQL Developer, Data Modeler.
• Experience in the analysis, design and development of database applications.
• Experience in performance tuning PL/SQL using SQL Trace, Explain Plan.
• Proficient knowledge in building database applications using SQL and PLSQL and Architecture.
• Involved in database design and data modeling. Worked on Relational OLTP and Dimensional data modeling.
• Working Knowledge of ERWIN Data modeling tool.
• Experience with Oracle 11i, 10g, 9i, TOAD Data Modeler, and TOAD Tester.
• Generating reports in different formats using BO.
• Well versed with data analysis and database modeling for a given project, extensively used MySQL, PL/SQL.
• Expertise in developing and implementing presentation layer using HTML, DHTML and JavaScript.
• Knowledge of MSSQL, PLSQL Object Types, BO, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections, Partitioning, Cursors.
• Proficiency in Unix Shell Scripting for Database Extraction and filtering, automating routine tasks using Oracle DBMS JOBS.
• Experimental working with clients on-site analyzing software requirements and developing solutions.
• Experience in developing User Interface Applications using Oracle Forms.
• Expertise in writing PLSQL/MYSQL ETL routines in data warehousing applications.
• Involved in database design and data modeling. Worked on Relational and Dimensional data modeling.
• Expertise in writing PLSQL ETL routines in data warehousing applications and Informatica.
• Sound knowledge in tuning SQL statements.
• Extensive experience in Shell Scripting and scheduling jobs using CRONTAB.
• Working Knowledge of ERWIN Data modeling tool and Information management systems.
• Working Knowledge of Oracle 10g, Crystal Reports and MYSQL.
• Expertise in all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance.
• Worked with query tools like Toad, SQL Plus, SQL Developer and Version tools like CVS, Clearcase.
• Experience in using Oracle supplied packages such as UTL FILE and Database migration/up gradation.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Strong personal drive and ability to work individually and in team environments.
• Ability to learn new tools, concepts and environments.
• Ability to explain technical concepts and communicate with users and system administrators at all levels.

Technical Skills

• Programming Languages : C, SQL, MYSQL and PL/SQL.
• Operating Systems : UNIX, LINUX, Windows 98/2000/XP.
• Project Management : Word, Excel, Access and Power Point.
• Script Languages : Shell Scripting, PERL.
• Oracle Technologies/Tools : Oracle 11g/10g/9i, TOAD, SQL Loader, Erwin,
• Crystal Reports , Business Objects.

Experience Highlights

Confidential

Role : Data Warehouse Specialist

Environment : SQL, PL/SQL, UNIX, Toad, SQL Loader

Description

Confidential is an Confidential, currently ranked among the top 20 medical schools in the United States. MSSM was chartered by Mount Sinai Hospital in 1963. Presently working on projects in the Charles R. Bronfman Institute for Personalized Medicine in building a strategic enterprise-wide Data Warehouse supporting clinical and translational research, care quality improvement, and process improvement initiatives.

Responsibilities

• Analyze the business requirements from the specification document.
• Involve in performance tuning and monitoring, tuned SQL queries using Code Statistics and Explain plan features, and analyzing number of hits and scans for an optimal execution plan, adding hints, indexes and parallel processing techniques for the queries.
• Work with Production Support team in fixing high priority bugs.
• Participate in all phases of development life cycle define requirements, code, test, debug, and document with significant guidance on analysis, and moderate guidance on system integration and coding.
• Work with Project Manager, BI analysts, data modelers, system architects and other staff to develop specifications, create processes and solve complex problems.
• Scheduling reports for researchers using Crystal Reports, Business Objects.
• Experience working with ICD-9, CPT-4, Snowmed, Loinc codes.
• Maintain and support existing ETL Extract, Transform and Load applications in a complex database environment.
• Creating ETL routines data marts for researchers using PL/SQL in data warehousing environment.
• Design and write new PL/SQL programs, and modify existing PL/SQL programs
• Provide Production support in a complex production environment ability to quickly and accurately diagnose problems and apply appropriate remedies . Support project personnel in resolving technical problems.
• Prepare detailed documents including overviews, data profiling, meta-data definitions and source to target mappings.
• Actively participate in the overall Data Warehouse/Business Intelligence strategy.
• Effectively apply knowledge of star schemas more than 15 dimensions and Oracle Database to create recommendations and solutions.
• Work with internal clients and management to resolve issues and validate programming requirements within their areas of responsibility.
• Develop test requirements, and prepare and document test scripts and data for complex system testing.
• Provide reports for the researchers use database coding techniques for the complex phenotype/genotype algorithms designed by researchers.
• Collaborates with researchers in determining approaches to data processing to meet expressed analysis needs of researchers.
• Formulate logical statements of scientific/research problems and devises procedures for solutions of the problems through the use of data processing systems.
• Supporting LIMS Production Support.
• Plays a key role in providing data for the NIH grants. Successful in getting 1 grant from NIH : 25 million USD

Confidential

Role : PLSQL Developer/ Data Modeler

Environment : SQL, PL/SQL, UNIX, Toad, SQL Loader

Description

The motive behind this project is to submit the processed student's data to CSIS California School Information Services where they maintain comparable, effective, and efficient student information systems that will support LEA Local Educational Agencies daily program needs and promote the use of information for educational decision making by school-site, district office and county staff. The data submitted comprises of two modes: Spring Submission Fall Submission. The data submission includes student demographic information, course information, program information, teacher credentials etc. The other phase of the project involves submitting data to CALPADS California Longitudinal Pupil Achievement Data System which provides LEA's access to longitudinal data and reports on their students and immediately access to information on new students enabling them to place students appropriately and to determine whether any assessments are necessary.

Responsibilities

• Analyzed the business requirements from the specification document.
• Involved in creating materialized views for retrieving the data from legacy systems.
• Created tables, views, functions, procedures based upon the business requirements.
• Extensively wrote 27 procedures for processing the student data K12 data
• Developed PL/SQL scripts for ETL processing.
• Involved in writing complex queries to validate ETL process.
• Involved in performance tuning and monitoring, tuned SQL queries using Code Statistics and Explain plan features, and analyzing number of hits and scans for an optimal execution plan, adding hints, indexes and parallel processing techniques for the queries.
• Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL Loader to perform bulk data loads into database tables from external data files.
• Design and Development of data validation, load processes, test cases using PL/SQL /MYSQL Stored Procedures, Functions, Analytical Functions using Oracle 11g/10g.
• Extensively used correlated sub queries, aggregate and analytical functions and inline views.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Records and Collections.
• Wrote several complex SQL queries to extensively test the ETL process.
• Run batch jobs for loading database tables from flat files using SQL Loader.
• Responsibilities includes creating Queries for Business Objects to produce reports, working with the Production Support team to fix many high priority bugs.
• Took an active part in OEM activities with leading Business Intelligence tools, participated in strategy meetings, recommended and demonstrated technical solutions.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages,
• Involved in User Acceptance Testing. UAT .
• Scheduling jobs in the background using crontab in UNIX.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle Tools like PL/SQL, SQL Plus, SQL Loader.
• Documenting business rules and processes.
• Involved in all phases of testing and production.
• Took logical Backups using Export, Import and performed Recovery when needed.
• Developed SQL loader scripts to load data in the custom tables.
• Worked in the Production Support team and fixed high priority bugs.

Confidential

Role : MySQL Developer/Database Performance Engineer.

Environment : MySQL 5.1, Erwin, SQL, PL/SQL, UNIX, Toad,

Confidential

Description

Confidential as a startup company started coming up with product for provider practice to maintain the status of the claims submitted for various payers. As part of this application, Application product has provision to parse and analyze the customer and remittance data from the end providers. Application also has certain administrative privileges apart from their remittances aspect using single sign on methodology. It also has the provision to maintain various types of reports for various provider specific business functionalities. Application also has provision to interact with Practice Management. Application acts as one stop for all the providers with respect to the claims and remittances and which will be used for their evaluation specific.

Responsibilities

• Involved in Requirements gathering of the application.
• Designed the Database/ER diagram using ERWIN.
• Involved in working with Remittance and claims data.
• Involved in Application Architecture.
• Responsible for database development by creating MySQL Functions, Procedures, Triggers, Records and Collections.
• Developed completely Report agent module, independent contribution.
• Developed various reports using Crystal Reports.
• Developed the various modules of the application using struts frame work.
• Used PPPS parser to parse 835 Remittance / 837 Claims Data.
• Designed 87 Tables based on the parser output.
• Developed Cron jobs to generate reports based upon facility ids.
• Part of Application customization with customer specific.
• Part of Design review team.
• Involved in Onsite/Offshore co-ordination.
• Used CVS and Subversion for version control.
• Involved in doing the release management activities.
• Involved in Onshore-Offshore process activities.
• Took logical Backups using Export, Import and performed Recovery when needed.
• Configuring, Troubleshooting database related Issues.
• Worked on EDI claims parser for data parsing.
• Created Record, Tables, Objects, Collections Nested Tables and Error Handling.
• Created Informatica work flows and mappings and scheduling jobs.
• Read data from flat files and load into Database using Informatica.
• Developed various UNIX Shell Scripts to automate the routine tasks.
• Participated in Performance Tuning using Explain Plan and TKPROF.
• Generating DDL files to create new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges by incorporating business standards throughout the files

Confidential

Designation : Oracle PL/SQL Developer / Forms Developer

Environment : Oracle 9i, TOAD, SQL, SQL Loader, PL/SQL, Windows NT,

UNIX, Forms 6i, Reports 6i, Informatica, Erwin, XML.

Description

This project makes use of SQL Loader to load the data into database tables. This work was basically done in background. Performance tuning was also done for this project and reporting using Oracle Reports.

Responsibilities

• Interacted with Business Analysts and client representatives in doing research and solving client specific data issues.
• Designing of new system based on new requirements of the business rules.
• Design and Development of data validation, load processes, test cases using PL/SQL /MYSQL Stored Procedures, Functions, Triggers using Oracle 9i.
• Created partitions for parallel processing of data.
• Implementations of logical and physical data models and reverse engineering using Erwin.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages,
• Detected and corrected bugs during system integration and user acceptance testing.
• Responsible for designing and maintaining fully integrated and multiple level help system for the modules.
• Created XML documents to create dynamic SQL statements for different Compensation groups.
• Used Informatica tool extensively to extract data from database and load it into data warehouse repository.
• Involved in SQL Tuning to optimize the SQL queries for better performance
• Worked on production support team for receiving the production support if any errors or problems arise in production from end users.
• Responsible for some automated Oracle jobs running using with CRON Tab
• Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL Loader to perform bulk data loads into database tables from external data files.