SUMMARY:

• 13+ years of experience in Analysis, Design, Testing and Deployments in Information Technology with expertise in analytics for driving business solutions.
• Over 10+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• 3+ years in design and customization of Clinical Trials using Confidential ’s Electronic Data Capture (EDC) InForm Architect software.
• Significant involvement in planning, providing technology direction and ability to rapidly evaluate new environments, understand data models and mobilize high growth organizations towards execution.
• Extensive knowledge and working experience on Software Development Life Cycle (SDLC), Agile development, Kanban in Development, Migration and Maintenance projects.
• Excellent programming skills and development experience in Oracle Database technologies, UNIX shell programming, Python, VB scripts and Excel macros, Python, R, SQL, PL/SQL, SAS, Java, JSP, JDBC and schedulers Autosys and Control - M.
• Used Tools such as HP Service Center, HP Quality Center (ALM), SharePoint, Jenkins, ITSM, EPV, Futrix, Subversion, Visual SourceSafe, StarTeam, TOAD, SQL Developer, Rational Rose and TDMS.
• Extensive and proven experience in relational database using Oracle 9i/10g/11g, SQL, PL/SQL, SQL* Plus, SQL*Loader, Informatica.
• Worked extensively on XSLT, XML, using SAX, DOM Parsers components.
• Worked in IDEs like Eclipse, JDeveloper and webservers like Websphere 6.1 and Apache Tomcat 5.6
• Expertise in OOAD Technologies developing Use Cases, Activity diagrams, Sequence Diagrams and Class Diagrams using case tools like Rational Rose.
• Extensive experience in leading project development, Database technologies such as Oracle, MS-Access, SQL Server, HIVE and Cassandra.
• Strong knowledge in Banking & Financial Services and HealthCare domains. Also worked in Life Sciences Computer System Validation.
• Roles include Project Lead, Architect, Sr. Applications Developer, Sr. Data Analyst, Process Manager (Validation) and Oracle DB Analyst.

TECHNICAL SKILLS:

Operating System: Windows 2000/XP/10, Ubuntu, UNIX

Languages: Java, JSP, Servlets, JavaScript, JDBC, Java Mail, HTML, XML, Unix Shell Scripting, Python, R, SAS, SQL, CQL, Oracle PL/SQL.

Databases: MS Access, Oracle 11g, SQL Server and Hadoop.

Tools: Eclipse, NetBeans, Toad, SQL Developer, MS- Office, Lotus Notes, Autosys, Control-M Workload Automation, HP Quality Center, Futrix, Pentaho, Subversion, Visual SourceSafe, StarTeam, Putty, WinSCP, ITSM and TDMS

Methodologies: Agile, Waterfall Model, UML

PROFESSIONAL EXPERIENCE:

Confidential

Applications Developer & Lead

Responsibilities:

• Lead Applications Developer in User Defined Business Applications (UDBA) Project. Activities include creating Technical requirements, code development for enhancement of applications and managing Change requests.
• As part of User Defined Business Applications (UDBA) work in advanced Database development, tools and technologies such as Oracle 11g, SQL, PL/SQL, SQL*Plus, UNIX programming, Control-M automation, Futrix, Toad and Windows 7 Enterprise.
• Migrated Business applications to new Unix/Oracle platform with 100% compliance of Risk Controls implementing EPV Standards, Subversion, Black Duck Scan, Jenkins, Static code Scan and automation of UNIX batch using Control-M and Autosys schedulers resulting in huge dollar savings.
• Resolved database performance issues by rewriting legacy PL/SQL code and reorganized big history tables using interval partitioning.
• Proficient in creating ad-hoc reports using Oracle PL/SQL and data models for Business Analysis.
• Created weekly and monthly Excel based (ODBC connection to Oracle) monitor dashboards for Credit Risk Management with key metric pivots around applications, decisions, approvals, bookings, exceptions and average turn-time to monitor credit risks.
• Resolved critical report reconciliation issues for Confidential and ensured risk cubes are accurately generated in Futrix.
• Lowered Business risk by masking sensitive data for normal users using enterprise policy PI settings in Oracle.
• Automated Credit Review sample report for Quality Control over manually decisioned loans using UNIX, PL/SQL and Control-M.
• Designed potential Daily Suspicious Activity daily reports (SAR) for Auto Finance Fraud review.
• Consistently maintained the application, resolved Control-M batch performance issues, provided reports to internal auditors, supported 150+ application users, downstream users of SAS platform and maintained Futrix cubes by performing ongoing changes.
• Worked on Proof of Concepts using Apache Hadoop platform and Hive to migrate legacy history tables with 10 years of application data to Ecosystem.
• Created tables for specific queries in Cassandra, designed the partitions required for best fit performance, performed data loading and ensured query performance for getting applications received year and month.
• Also trained in Apache Spark, Scala, Python and R.
• Performed 100+ implementations using ITSM and Change Management Process.
• Engaged various Operate teams, DBAs, File Transfer team, Access Admin team, Application Operations team and GTI effectively over the period to resolve various issues.

Environment: Windows 7 Enterprise, UNIX, Oracle 11g, SQL, PL/SQL, Hadoop, Hive, SAS, Futrix, Pentaho, EPV, Jenkins, SharePoint, HP Service Center, HP Quality Center (ALM), Control-M and Autosys.

Applications Developer

Responsibilities:

• Responsible for development of technical requirements for Business requirements and enhancements of applications. As part of Oracle development that requires advanced PLSQL skills, worked in Java/J2EE framework using technologies such as Oracle 11g, SQL, PL/SQL, SQL*Plus, Unix Shell, Toad and Windows XP.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Reviewed Use cases and Pricing change requirements with Business Managers.
• Developed complex pricing calculations in Oracle for better application performance.
• Actively participated in validating configuration setup to develop new pricing event in the schema.
• Extensively used bulk collection in PL/SQL objects for improving the performing. Created collection objects for improving Query performance and Dynamic SQL for handling datasets through J2EE procedure calls.
• Proposed design and solution including new development, code changes and ensures solution meets Business requirements. Also modifies database objects (packages, procedures, functions) to support enhancements for the existing application.

Environment: Windows 7 Enterprise, UNIX, Oracle 11g, SQL, PL/SQL, Hive, SAS, Futrix, Pentaho, Control-M and Autosys

Report Architect

Responsibilities:

• Worked as Report Architect responsible for creation of Data Model/Data Points required to publish real time reports.
• Provided feasible design and tools required for automating reports and implementation. Analyzed reporting and data requirements to automate reports for QA estimation, execution and forecasting for Mortgage Banking applications.
• Created VBA Modules to include loop thru form controls along with SQL Statements to report data.
• Created real time Defect status and execution reports using Oracle ODBC connection, VB macros and embedded SQL queries that saved 2 hours in publishing daily status reports.
• Expert in using HP Quality Center data model. Developed strategic data points for MIS dashboard reporting, data summaries and key indicators from Quality Center data model.
• Created various test execution reports and correspondent release reports for Management meetings.
• Created Tester Score Card excel report for Mortgage Banking Originations projects.
• Volunteered creation of dynamic “QC Activity Test Report”. This report was greatly appreciated by Business that helped Quality Center projects consolidation activity.

Environment: Windows 7 Enterprise, Oracle 11g, SQL, PL/SQL, HP Quality Center, Excel Macros, Microsoft ODBC

Lead Applications Developer

Responsibilities:

• Worked as Project Lead in Post-Discharge Call program for Confidential Inc., Responsible for Estimation, Design, development and Implementation of post discharge Eliza call program for National, Commercial and FEP accounts.
• Created technical requirements, developed code, participated in testing, managed the sign-off and implementation.
• Responsible for validating the interface development and data transfer with outside vendor Eliza for successful outreach.
• Automated transfer of “Post discharge Call program” feed using UNIX secure copy protocols to remote Vendor host.
• Continuously suggested enhancement and process to improve the project efficiencies that are critical for project outcomes.
• Created analytical reports and data points to support Business decisions and strategy.
• Implemented “Do Not Call” list internally and ensured inbound call results are received back securely for Business review and Operations.

Environment: Windows, UNIX, Oracle 11g, SQL, PL/SQL, Crontab, KSH Shell Script

Lead Applications Developer

Responsibilities:

• Worked as Technical Lead in “ Confidential Data Sourcing” Project for Confidential Inc. Confidential is a medical decision-tracking system utilized by medical management physicians, nurses and utilization representatives to house member, clinical and case management data.
• Developed technical requirements for data extract project and also handled change requests part of post implementation and support. Implemented extract logic for fields, formats, calculations, record types and derivatives.
• Developed test plans for the conduct of a structured and comprehensive approach for testing software/system. He designed, develop and automated complete extract system as scheduled job.
• Reviewed Medical System Data Model to design delta feed transfer to warehouse processing.
• Built large outbound data feed to transfer both delta and complete patient history to Vendor with over 600 fields in a record including various details in file.
• Recommended data transfer solutions that helped Informatica team to develop Data hub interface.

Environment: Windows 7 Enterprise, UNIX, Oracle 11g, SQL, PL/SQL.

Database Analyst

Responsibilitie:

• Worked as Oracle-Database Analyst in “IM Performance Implementation” Project in Confidential ’s Corporation to analyze recommendations suggested by Performance Assessment team for IM Project.
• Performed impact analysis and feasibility study on performance recommendations.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and AUTOTRACE.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Analyzed dependent Data load jobs, systems, interfaces and calls. Implemented performance recommendations related to database and API changes.

Environment: Windows 7 Enterprise, J2EE, UNIX, Oracle 11g, SQL, PL/SQL.

Validation Analyst

Responsibilities:

• Ensured new team members complete trainings as per Standard Operating Procedures.
• Performed fit gap analysis on user requirements between existing Confidential US and Canada systems in order to create a single FDA compliant system.
• Improved validation strategy by introducing fit gap analysis, Risk Based Test (RBT) approach that reduced testing window from twelve weeks to five weeks helping project completion on time.
• Conducted training workshop in US and Canada on script preparation and explained testing methodology.
• Maintained traceability matrix and approved Test scripts in Technical Document Management System as per FDA compliance.
• Coordinated testing among various workstreams like Finance, Order to Cash, Purchase to Pay, Plant maintenance and Supply Chain Management.
• Presented changes to Change Control Board including Business and IT Leads during UAT migration and go-live cutover.
• Gathered all test results and evidence and filed them for storage.

Environment: Windows 7 Enterprise, SAP/ABAP, SQL, MS-ACCESS, TDMS.

Applications Developer

Responsibilities:

• Worked in IT Transformation Project under iSLC ReMArc stream that provides PGRDi teams with a common framework for managing the migration, archival and retirement of Validated computer systems, including server, database and data components.
• Activities of the project include retirement, migration and archival of the applications and deployment instances of applications in Confidential sites across the globe.
• Interacted with Business and stakeholders to determine application disposition criteria ie., (Retirement, Migration or Archival).
• Designed Questionnaire checklist, conducted 2-day workshop for information gathering with Business and Technology officers to fast track project.
• Suggested archival strategies to Business to store application data based on legal hold.
• Migrated user share folders and critical research documents to new location.

Environment: Windows 7 Enterprise, Java, Servlets, JSP, SQL, PL/SQL and Oracle 9i

Validation Analyst

Responsibilities:

• Worked for the Client Confidential Pharmaceutical’s Analysis & Reporting Transformation (A&RT) project as the Validation Lead and his responsibilities included correspondence with the client, understanding the requirements, preparing the Validation documents, getting approval from the client and coordinating the execution of project from the Client Site.
• Organized Configuration management folders, creating test scripts, review and coordination of test execution in Client Site.
• Discussed with Test leads for test data required for script execution.
• Created test scripts in detail required for security testing.

.Environment: Windows 7 Enterprise, Java, Servlets, JSP, SQL, PL/SQL, VSS and Oracle 9i

Application Engineer

Responsibilities:

• Worked in Confidential ( Confidential ) as a member of the Advanced Technical Team providing solutions for the issues and events that cannot be initially resolved in the Confidential technology suite of applications including the Validation Check rules, InForm ITM, Lab Upload, Lab Coding, Web Portal, ICDS and XML Integration, Infusion, IVRS and reports.
• Confidential team works to identify and maintain streamlined processes that allow for rapid turn-around time and quality delivery for the client’s most complex challenges.
• Extensively used the Client specific tools and managed the technical issues with his team and ensured efficient handling of cases.
• Communicated detailed information about problem resolution and incorporated lessons learned into continuously improving standard processes and ensured high quality in all the deliverables and solution provided to the client.
• Monitored the quality of resolution provided by his team by doing a thorough review over the technical resolution in technologies such as ASP, Oracle 9i, MS Access, SQL, PL/SQL, Toad, VB Script, InForm Server, Html, XML and Windows 2000.

Environment: Windows 2000/XP, ASP, Oracle 9i, MS Access, SQL, PL/SQL, Toad, VB Script, InForm Server, InForm Architect, Html and XML.

Confidential

Application Engineer

Responsibilities:

• Worked as an Application Engineer for the Clinical Trials Customization Project and was responsible for resource allocation & management, streamlining Clinical Trial Design & Setup using the base product InForm Architect.
• Responsible for elucidating the Client requirements to the offshore development team in addition to conducting deliverable review, technical review and metrics collection.
• Successfully developed Data Upload batch process using Oracle and MS-DOS scripts to update Patient Lab results clinical data to specific site and visit forms.
• Handled resource allocation and management for Clinical Trial Study development.
• Developed custom Trial Data Extracts using Oracle Views and SAS for study.
• Reviewed Edit Check query requirements and developed them effectively with zero QA defects.
• Performed second level review on technical solutions.
• Resolved issues reported by InForm users across global sites on the following technologies ASP, VB Script, Java Script, HTML, XML, CSS, PL/SQL along with the tools like Toad, VSS and coordinated with the client as part of his module development.

Environment: Windows 2000/XP, ASP, Oracle 9i, MS Access, SQL, PL/SQL, Toad, VB Script, InForm Server, InForm Architect, Lab Coding, TDE (Trial Data Extract), HTML and XML.

Applications Developer

Responsibilities:

• Handled change Management and enhancements for Confidential ’s Clinical Data Management Suite of applications especially INSPIRE, which is a web-based EDC (Electronic Data Capture) application designed for Collecting and Managing Clinical Trial Data.
• Developed queries for backend to create eCRF forms and edit checks.
• Maintenance and enhancements work also included Design and Development of eCRF’s (Electronic Case Report Form), handling Oracle Change requests (Level-3) for the application.
• Attended key trainings in Regulatory Compliance (GLP, GCP & cGMP) in line with FDA regulations to supplement project assignment on developing validated systems.

Environment: Windows 2000/XP, Java, Servlets, JSP, JDBC, ANT, Toad, Rational Rose, VSS 6.0 and Oracle.