Professional Summary

• Over 8 years of experience in development using Oracle SQL, PL/SQL, MySQL and Developer Forms and Reports.
• As a Database Developer involved in designing and development of an Inventory application for keeping track of Inventory, taking online orders from users and generating reports from online thru UNIX shell scripts in the backend.
• Extensive experience working in database programming with Oracle 7.x/8.x/8i/9i/10g/11g Systems and Oracle 11g/10g/9iAS application server, SQL, PL/SQL, Oracle Forms 10g/9i/6i, Developer/2000, Reports 10g/9i/6i, SQL Loader, Export, Import and SQL Plus, Enforcing data integrity using Integrity constraints database triggers, Stored procedures Data warehousing, PeopleSoft, SQR. Experience in Performance Tuning, Database Upgrades/Migration and Planning Backup Recovery Strategies, optimization, Software Configuration Management
• Experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in XML stages like XML input, XML transform and XML output stages.
• Experience in Multi-Terabyte environments, solid experience in coding using SQL, SQL plus, PL/SQL, stored procedures/functions, triggers and packages.
• Experience in unit testing, system integration testing, implementation and maintenance.
• Data Warehousing assistance, Application Development and Production Support.
• Experience in all the stages of Software Development Life Cycle SDLC including business requirement analysis and data mapping.

skill set

• Computer Languages:
• MySQL, PL/SQL, SQL PLUS, JAVA, HTML, XML, XSLT, SQL PLUS, VISUAL BASIC, SQR, COBOL, PRO C, SQL REPORT, C, C , UNIX Shell Scripting.
• Tools:
• Oracle Oracle database, Forms, Reports , Crystal Reports XI V 2.0, PVCS, SCM, CMM, DB2, Toad, JDeveloper, SQL Loader, Export/Import, Ms Access, XML SPY, Microsoft Visual Source Safe, FTP Tools, People Soft, VISIO, VI Editor, MS Office 2000/2003.

Environments:

MS Windows 95, 98, 2000, NT, XP, 7 , MS-DOS, UNIX HP-Unix, Sco-Unix, Sun Solaris , SQR Server

Projects summary

confidential

Role: Lead SQL Developer

Responsibilities:

• Involved in Creating Database schemas, Design Database, Review, analyze, and modify programming systems including encoding, testing, debugging, and installing Clinical software systems such as CLINTRIAL, JREVIEW web based , DSNAVIGATOR web based , LIMS applications.
• Assist in the planning, design, development and deployment of new applications and enhancements to existing applications.
• Involved in project phases for installation and maintenance for newly acquired applications.
• Create system models, specifications, diagrams, algorithms, flowcharts to provide direction to software development.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Analyze, design, develop, implement and support Business Intelligence technical solutions.
• Work with analysts, software consultants, and information technology personnel as part of a development team to develop, test, validate, and roll out applications.
• Maintain production systems managed by Information Technology group, including problem-fixes and upgrades.
• Provided user support and applications support for applications like IMPACT Diamond, IMACT Polaris 3.2.1, Specification Management System SMS 1.0 and Global Vision Document Proofing System GVDPS .
• Assessing conditions for optimal use and deployment of the system on an ongoing basis, through user feedback and configuration management locally and globally.
• Use PL/SQL to write queries, procedures and function to perform data transactions to process requests and enhancements in the production region on various DBs like Oracle and MySQL.

• Run MySQL queries on the old CMS for accurate data and files retrieval.
• Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle10g/11g.
• MySQL processes, security management and queries optimization
• As a DBA involved in Creating Database schemas, Indexes, Extents, Tables, design metadata database structure , Create users/ user group accounts, Manage passwords, Set up and maintain security for all Clinical modules, Set system parameters, Produce reports about system activities, batch loading the data, exporting, importing the data among different schemas, Validate and merge clinical data in the database, Create queries for retrieving data, Backup, Performance tuning, Query optimization.
• Log and track system errors and interact with system vendor for technical support.
• Provide regular updates to the Director and/or the Project Manager regarding project status, and milestones achieved.
• Experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Designing creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Participate in system testing activities, to include the verification of test scripts, cases, scenarios, and data as well as the execution of system integration testing and system acceptance testing.
• Enhance existing Code, Conduct Walkthroughs, testing, implementation, Spec docs, User training and documentation, Managing and Support of the application. Created Ad hoc/Formal reports based on User requests to produce output in .html, .xls, .pdf, and list formats. Integrate application modules.
• Created simple to complex ad-hoc reports using SQL Plus and TOAD for the business users.

Environment: Oracle 11g/10g/9iAS, Crystal Reports XI, SQL PL SQL, Forms 10g/9i, Reports 10g/9i, SAS 9.1/9/.2/9/3, Reflection, shell scripting, TOAD, SQL PLUS, MS Word, MySQL, SQL Loader, Import, Export, Clinical Software, FTP Tools

confidential

Role: Database Administrator

Responsibilities:

• Developed procedures to migrate spatial data to space-delimited SQL Loader formatted files. Developed script that was scheduled to move data files via FTP. Analyzed performance issues with wait events.
• Designed oracle stored procedures, cursors and triggers to perform data operations.

• Involved in designing and development of an Inventory application for keeping track of Inventory, taking online orders from users and generating reports from online thru UNIX shell scripts in the backend.
• Performed through data profiling by using the Investigate stage of Quality Stage and also by writing PL/SQL queries to identify and analyze data anomalies, patterns, inconsistencies etc.
• Worked with different Sources such as Oracle, MS SQL Server and Excel, Flat files.
• Write MySQL, PL/SQL stored procedures and functions to manage data, MySQL queries for necessary requirements, and MySQL triggers for data automation.
• Installed, security, and maintenance of Linux based systems including MySQL 5.0.22 configuration.
• MySQL database administration on a large scale MySQL installation
• Used Data Stage Administrator to create Repository, User groups, Users and managed users by setting up their profiles and privileges.
• Responsibilities included data modeling, data mapping, data analysis, data migration, preparing functional, technical specifications and coding, design high level flow diagrams, develop batch scripts, SQL Scripts, HTML page structure, content, programming, graphics, web form pages for consultants pay roll systems preparing functional, technical specifications design high-level flow diagrams,
• deploying reports for the Intranet application, generating reports according to the requirement, provide user training, Optimizing, performance tuning, mentoring, Coordinating and monitoring. In addition, libraries, templates, SQL scripts and stored procedures, user/technical documents were developed to improve performance and to assist in administering the development environment.
• Designed DataStage Jobs to extract data from XML files using XML input stage, Used XML transformer stage to cleanse and transform the data to load it into the Data Mart.
• Worked under GDP and 21CRF part 11 Guidelines.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.

Environment: Shell Scripts, TOAD, SQL PLUS, Advanced SQL PL SQL, Visual Basic, Windows NT, UNIX, FTP, Visual Source Safe, SCM, SQL Loader, Import and Export, People Soft, SQR server, SQR, MySQL and Oracle database, Oracle EXPORT/IMPORT, Windows NT

confidential

Role- Database Administrator

Responsibilities:

• Understanding the customer requirements by participating in the requirement Walkthrough sessions.
• Wrote and executed SQL statements to retrieve and compare data.
• Worked under GDP and 21CRF part 11 Guidelines.
• Used SQL Loader to load data from external files into Oracle Database.

• Created schemas for new users and managed the security and access the database by granting appropriate privileges and roles to the users based on client policy.
• Managed Table spaces, Database structure and storage allocation, Undo segments, etc.
• Wrote extensive SQL and PL, SQL Procedures, Functions.
• Monitored database activities, performance, and size. Increase the size if required and identified and resolved performance issues.
• Tuned SQL queries using indexes and table partitioning and correct database.
• Analyzed the database tables and indexes and then rebuilt the indexes if there is fragmentation in indexes.

Environment: Shell Scripts, TOAD, SQL PLUS, Advanced SQL PL SQL, MySQL, Visual Basic, Windows NT, UNIX, FTP, Visual Source Safe, SCM, SQL Loader, Import and Export, People Soft, SQR server, SQR, SQL and Oracle database, Oracle EXPORT/IMPORT, Windows NT.

confidential

Role Research Assistant

Responsibilities:

• Statistical analysis using SPSS Multiple regression and path analysis, Hypothesis testing T-test, ANOVA, chi-square
• Preparation of chemicals needed for the Experiments.
• Guiding project members with Analysis of samples, data reviewing and report drafting.
• Maintenance of database and statistical analysis of the various projects.
• Training project members with SOPs, Safety standards.
• Clinical Trial Manager CTM managed multiple projects going in the Research.
• Calibration of lab instruments and preparation of quality documents COA's .
• Preparation of lab documents and manuals for the undergraduates laboratory work.
• Inspection of laboratory instruments and setup lab for the undergraduates.
• Clinical Research Organizations CRO in managing various protocols and case reports and as a budget keeper in the ongoing projects.
• Expertise in analyzing and coordination with clinical trial data, generating reports, tables, listing and graphs.
• Optimized performance using data validation data cleaning on Clinical Trial data using statistical procedures.
• Involved in writing standard operating procedures SOP for reviews and approvals.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Database Creation and Table Programming for Integrated Summaries of Efficacy ISE and Safety ISS .
• Maintenance of database and statistical analysis of the various projects.

Environment: Oracle 11g/10g/9iAS, SQL PL SQL, SAS 9.1/9/.2/9/3, SPSS 16.0.1.

confidential

Database Analyst

Responsibilities:

• Database objects creation.
• Create Oracle tables, Columns/Fields using Oracle SQL, SQL PLUS.
• Create/Execute DDL, DML, DCL, TCL statements.
• Validation of theoretical models.
• Inserts/update data based on user request.
• Experience in analyzing medical claims data interfacing SAS with MS office application such as Access/Excel.
• Extracting Data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Transferring and migrating data from one platform to another to be used for further clinical analysis.

Environment: Oracle 11g/10g/9iAS, SQL PL SQL, SAS 9.1/9/.2/9/3.