IT Professional with 13+ years of experience in requirement analysis, Oracle database administration and development, data warehousing, software quality, application implementation, application testing support and project management. Possess excellent communication skills with strong work ethics and have consistently demonstrated strong teamwork and looking to challenging long-term commitment to projects.
2.0+ years of strong experience in Lawson and Customized Enterprise Resource Planning (ERP) systems using Oracle 10g, Toad, Unix shell scripting.
3.0+Experience performing Oracle,SQL Server DBA activities.
6.0+ years Database Design and Development using Oracle Tools including Oracle 10g/9i/8i/8x/7x, PL/SQL, Reports 3.0/2.5, Forms 6i/4.5, Oracle SQL Loader, Oracle Designer 2000, Developer 2000, SQL Server.
Extensively used QUEST Tools (TOAD, SQL Navigator) and SQL*PLUS, SQL * Loader. Experience in developing Stored Packages, Functions, Procedures and Triggers.
EDUCATION Madhav Institute of Technology, Gwalior, India
MS in Computer Applications (MCA)
Science College, Gwalior, India
BS in Mathematics/Statistics.Gov.
Project Management (PMP)
Oracle Database Administration by Oracle Corp
Business process Management (PEGA)
Essential Software Project Management
Languages PL/SQL, SQL, XML/HTML, VB6, JAVA
Operating Systems HP-UNIX, SUN Solaris, AIX,Linux ,Windows 7/XP/NT 4.0/2000
Databases Oracle 10G, Oracle 9i, 8.x, SQL Server 7, MS Access
Applications/ Tools Lawson ERP, Oracle, SQL,PL/SQL, SQL*Plus, TOAD, SQL Navigator ,UNIX shell programming ,Crystal Reports 11, HEAT ,Oracle 10g/9i database administration, SQL Server 2005 Database administration, Data Stage, Informatica, VBA programming, WS FTP, I-many GP, MS project, Appworx,Business Objects Enterprise XI, Forms 4.5/3.0, Reports 2.5/1.1, Export/Import,SQL*loader,Oracle, Designer 2000,SQL Developer, SQL Station, PL/SQL Developer, Clear Quest, Sub Version, Visio, , Documentum, Visual Source safe, Eclipse,Object Cycle 2.0.
Oct-2011- Nov 2011
Client :Cigna, Wilmigton ,DE
Sr Development Specialist
Worked as a PLSQL/UNIX developer International Claims system for Cigna. Create Pl/SQL packages/procedure for extracting data to create flat files and transmitting them to the file shares using FTP Connect Direct.
Developed reports using SQL queries and Unix Scripts as requested by the business.
Worked on system enhancements and data extracts development using PL/SQL to automate manual claims check void/reissue process and the defect fixes as reported by the business during QA/UAT testing. Performed SQL tuning of poorly performing queries by creation of indexes, Oracle hints in a high volume real time environment.
Client: Pfizer INC, Collegeville, PA
Worked as a developer /support consultant supporting iMany government pricing (GP), iMany Medicaid applications. at Pfizer.
Responsibility of GP/Medicaid data loads from vendors using ORACLE PL/SQL and UNIX scripting. Data analysis and resolution of issues with the incoming data. Document the design and test scripts for data loads. Resolve data violations in GP due to data loading.
Analysis, design and development of interfaces to extract the data using PLSQL and UNIX scripts.
Worked on resolving the system defects, implement data fixes ,create data loads using Pfizer Change management system. Monitoring GP/Medicaid interface executions on a daily basis and co-ordinate resolution of interface errors due to system issues.
2009 – 2010 Paragon Computer Professionals, Conshohocken, PA
Client: Merck & CO, Lansdale, PA
Worked as an analyst lead supporting government pricing (GP) application at Merck.
Oversaw project construction working with business analysts and developers resolving release defects. Developed solutions in GP by Performing GP configuration changes using PL/SQL and XML.
Recreated a process to support corporate integrity agreement in MS Access & Oracle. Analyzed and Performed modifications in GP SQL Packs/Report Packs and informatica Jobs as requested by customers. Coordinated with offshore testing and deployment groups to implement system changes.
Performed analysis, developed, tested, peer reviewed modifications. Created and modified oracle views and pl/sql packages..Assisted the business users during UAT of application modifications using change management process.
2008 – 2009 Catholic Health East, Newtown Square, PA
Served as interface developer/Support Consultant for Lawson ERP application used at CHE.
Developed interfaces for HR/Payroll, Finance and Supply Chain suites of Lawson using PL/SQL and UNIX scripting and Cobol Programming .Created design and rollout documents.
Built a process for legacy data conversions for HR module creating Lawson jobs. Coordinated with the implementation team and technical team to support the Lawson interfaces Implementations. Improved and implemented interface development process. Resolved Support tickets using call tracking system HEAT.
Created & modified SQL and UNIX scripts for Lawson LSF 9 upgrade. Involved in analysis and strategy for the upgrade. Developed reports using Crystal Reports 11 & SQL.
2007 – 2008 TEVA USA, North Wales, PA
Served as a senior analyst/developer assuming overall responsibility for supporting I-many GP application.
Worked on I-many GP application upgrades/Patches. Coordinated with I-many representatives, database administrators and also performed upgrade tasks.
Implemented I-many federal supply schedule (FSS) module .Performed modifications to GP application (SQL Packs/Report Packs), data stage jobs. Created New Appworx chains to run data stage jobs on a daily/weekly basis. Created database scripts to load data into FSS tables using SQL and PL/SQL scripts.
Designed and Developed I-Many GP reports. Created GP Data validation Reports using Pl/SQL and discoverer.
2005 – 2007 TekSystems Inc, Blue Bell, PA
Worked as a technical architect for following Teksystems clients:
Client: GLAXOSMITHKLINE, Philadelphia, PA (2006 – 2007)
Served as a technical architect for Government Pricing calculator (GPC) application to support various government pricing program efforts primarily through performing various pricing calculations.\
Performed modifications to Annual Sales Price calculations due to reporting rule from CMS (Center for Medicare & Medicaid Services). Developed a Smoothing Credits/Chargeback’s Methodology for Non- Federal Average Manufacturing Price.
Implemented the modifications to GPC due to Deficit Reduction Act (DRA) requirements and other application enhancement requests.Wrote Unit test plans, test scripts and Peer review plans. Improved GPC Filtering application performance by 90% optimizing the database queries.
Client: Wyeth Pharmaceuticals, Collegeville, PA (2005 – 2006)
Worked on IMPACT Hercules upgrade project for Clinical trial management system IMPACT which also includes merging clinical tracking data residing on 3 different database instances.
Upgraded clinical data warehousing system (Clinical Master File) and various downstream applications as a single feed making sure minimal impact on downstream applications. Created and modified tables, views, Materialized views and PL/SQL packages; Created installation qualifications, test scripts, change control plan, change control summary reports. Coordinated with system testing teams resolving production and system testing issues.
Provided development and production support for IVR randomization systems. My responsibility was to set up the protocols,create database scripts in PL/SQL and SQL reports to generate automated faxes to the sites. Resolved various day-to-day support issues using change management system.
Designed, developed and deployed Business intelligence reports using Crystal reports & PLSQL.
2004 – 2005 Aetea Infotech, Blue Bell, PA
Worked as Consultant for following AETEA clients:
Client: E-DUCTION, Blue Bell, PA (2005)
ORACLE DBA/ DATABASE DEVELOPER
Worked as a Database administrator /developer for E-duction maintaining oracle databases.
Installed Oracle server and client on Unix Sun Solaris and windows. Set up Database monitoring using Oracle Enterprise Manager. Migrated Oracle databases to different machines. User and Space management using oracle enterprise manager.
Created database alert scripts, monitoring scripts and backup procedures. Set up automated backup scripts using Unix Cron jobs. Performed Export/Import and Oracle instance tuning.
Developed /modified PLSQL procedures, packages.
Client: Merck & Co., Blue Bell, PA (2004)
Worked on Clinical trial system CTMS used for Administration of Clinical Trials. CTMS integrates the planning, administration and tracking of clinical trials Conducted by Merck worldwide.
Deployed Diamond version of CTMS worldwide & Oracle 9I upgrade of CTMS databases. Convergence of the oracle databases to ensure quality and consistency of all reference data.
Developed CTMS real time recruitment project via data integration from various sources of patient data using UNIX shell scripting, SQL*LOADER, SQL and Pl/SQL. Created Transaction data entry Forms using Oracle Developer 6I and Ad-hoc Reports using SQL, PLSQL and Oracle Discoverer.
Worked on CTMS first site ready initiative. Developed a process to automatically update certain CTMS milestones. Used PL/SQL scripts and Job scheduling.
Developed and deployed reporting tables and patient recruitment graphs using graphing feature of Microsoft Excel & VBA accessed worldwide on Merck Intranet.
Developed a patient Visits forecasting Reporting environment to help the subsidiaries to get resource estimates based on actual patient visits forecast It made an efficient process of using CTMS to drive Clinical Planning analyses.
2001 – 2004 RCG InfoTech, Conshohocken, PA
Worked as a consultant for following RCG clients:
Client: GLAXOSMITHKLINE, King of Prussia, PA (1999 – 2004)
Acted as Application engineering representative for the Clinical Program Monitoring system (CPMS), a customized oracle-based application used for worldwide development of collecting, reporting and tracking the progress of Phase I–IV Clinical studies.
Converted VAX based version of CPMS to windows environment using Oracle developer 2000 tools such as Oracle forms, Reports and PL/SQL. Developed many critical user interfaces with enhanced functionalities.
Created a reporting website to report CPMS data real time on the GSK intranet using Oracle Web server technology. Developed PL/SQL packages using Dynamic SQL to generate HTML pages. Created views, snapshots, and database indexes to improve performance.
Built a combined reporting environment for 3 clinical systems operational at the same time. This involved data extraction from CPMS and transfer of data between systems of SmithKline & GlaxoWelcome.
Acted as a technical lead/Subject Matter Expert on a Migration-decommissioning projects replacing CPMS and implementing customized Siebel eClinical system.
o Facilitate dcommunication between the technical team and the business teams. Propose data mappings for specified data items; characterize situations where mappings are not straightforward from the source legacy system and the new system.
o Designed and administered technical environment for extracting/transforming data. Developed Unit specifications, unit test plans for the migration load routines. Developed a test strategy.
o Developed database objects and migration routines. Liaise with business user group and developers in verifying the correctness of migrated data and obtain resolution of specific processes, migration, or rollout issues. Migrated tracking data for around 1100 clinical trials to the new system.
O Conducted decommissioning activities and reconciled the external interfaces to work with the new system. Performed archiving of the legacy data and application source code.
1998 – 2001 BIRLASOFT INC., Edison, NJ
Client: Philadelphia Gas Works, Philadelphia, PA (1999)
Designed and developed an application for tracking actions in meetings held for PGW using Oracle*Forms 5.0 and Oracle*Reports 3.0.
Programmed and implemented Various General Ledger Account Balances reports to supplement the company’s Oracle Financial system using ORACLE*Reports 3.0. Created complex stored procedures, functions and packages
1995 – 1998 SYSTEMS ANALYST
Worked as a lead Developer /Systems analyst for Birla soft, New Delhi and its client companies.
Clients included: Diamond Cements (Damoh, India), Orient Paper Mills (Amlai, India), Medical Administration and Technical Services (Canada), National Engineering industries (Jaipur, India).
Applications: Inventory Management System, Payroll System, Financial Accounting System, Sales Module, Resource Management System and Market Analysis System:
Developed various customized ERP applications on a time and material basis. Responsible for end user interaction & existing system study. Designed payroll and finance modules independently. Was a member of the design and development team for sales and inventory modules?
Performed various database administration activities.
Implemented software’s at client sites & provided post implementation support.