Sr. Oracle Developer Resume Profile
PROFESSIONAL SUMMARY
- Over seventeen years of Information Technology consulting experience with extensive leadership
- In depth knowledge of project management, Release/Change management, QA/PVS test management, service delivery, infrastructure, engineering, operations support and SDLC Agile, Water Fall
- Diverse business exposure: Financial, Pharmaceutical, Insurance Healthcare, Financial, Life and Annuity , Tele-communication Device Manufacturing, Accounting, Sales, Ordering, Retail Control, Operations and Inventory Tracking
- Twelve years of engineering management experience in manufacturing related service industry dealing with Aircraft, Computers and Automotive Experience involved purchasing, inventory control, customer service, vendor management, process control, quality management as well as safety and environmental compliance
EXPERTISE
- Project Management Release Management
- Team Building Strategic System Planning and Analysis
- Customer Service Vendor Relationship and outsourcing
- Problem Solving Database Design and Development
- Capacity Planning Performance Volume Stress Testing
- Database Administration SDLC Methodologies
ACCOMPLISHMENTS
- Provided release/change configuration management services to various global groups within the Financial, Insurance as well as Fortune 100 Pharmaceuticals LPL Financials, Fidelity, Merck, Cigna, Travelers Pfizer
- Contributed towards release management process development, team building, release management service introduction and service marketing, service outsourcing, building customer relationship with business, program managers, PMO as well as global shared services groups
- Achieved several recognitions as a lead contributor/customer centered behavior in release/change management discipline
- Recipient of achievement award for successful system development and implementation in over 300 plus nationwide retail stores during a consulting assignment at Giant Foods a subsidiary of international Ahold Inc.
- Accomplished a challenging and time sensitive system conversion of SAP to Oracle ERP as part of corporate takeover Executone by Inter-Tel Lead team in fast paced Oracle development and data transformation/migration activities
TECHNICAL PROFICIENCIES
- Operating Systems: UNIX Solaris/AIX/HP , MVS, DEC VAX, WINDOWS
- Software/Tools: Visio, MS Office 2013 Tools, MS Project
- Programming Languages: C, C , JAVA, Visual Basic, SQL, PL/SQL, Packages, PRO C, Shell Scripts, Visual Studio - .NET, ASP
- Development Tools: Oracle Developer 2000 Forms and Reports, TOAD, SMART DB, Team Quest
- RDBMS: ORACLE 7.3 to 11g and DB2
- ERP Applications: Oracle Financial Manufacturing, SAP
- Testing/Issue Tracking: Quality Center JIRA
- Packaging: InstallShield, SMS,
- Application Platforms: WebLogic, WebSphere, Apache, Citrix, IIS, Oracle Applications Microsoft SharePoint Portal, SAS
- Document Management: Documentum LiveLink Microsoft SharePoint
- Reporting: Developer 2000, Cognos, Business Objects/Business Intelligence, Crystal Reports
- Config. Management: Configuration Management Database CMDB/uCMDB
- Service Desk: HP Service Manager 9.0, BMC Remedy, Peregrine Service Center
- Discovery Tool: Tivoli Application Dependency Discovery Manager TADDM
- ETL Tools: Informatica, DataStage
- Version Control: SourceForge, PVCS, Visual Source Safe, Concurrent Version System CVS , Clear Case, Visual Studio Team Foundation Server TFS
PROFESSIONAL EXPERIENCE
Confidential
Engagement Manager
Confidential
Configuration Management as well as Confidential
Services
- Participation in creating Statement of Work SOW for Change, Release, Configuration and Production Support Services to fulfil business objective to achieve 24x7 support model as well as to support Agile Development methodologies
- Procured contract to on board onshore and build offshore team totaling over 6.5 Million Dollars
- Client-vendor liaison and relationship building from the project inception onwards
- Knowledge acquisition and Process Development for the training of offshore support team
- Planning and execution of offshore-onshore support model - including core/flex team organization
- Team building, resource hiring and knowledge transition planning
- Overseeing team activity of 11 on boarded onshore contractors and supporting 8 offshore team members
- Support day to day engagement activities Labor Accounting Reports for LPL Accounting and Financial, Resource Time Tracking, HR aspects for resource onboarding
- Participation in CAB meetings as well as major/point/product/emergency Release execution
Confidential
IT Service Manager
- Provide Service Management support as a member of Configuration Management team
- Perform Application Map maintenance/update in uCMDB a database for HP Service Manager
- Contribute to Application Map Validation Process dealing with Application Owners and SMEs
- Application Map handover to Change Management for Change Governance for Survival Critical Business Applications
- Discovery and Configuration Management Tools - TADDM, uCMDB HPSM Sync up and remediation of issues
Confidential
Senior Consultant: Release Management
- Manage program level release activities involving a major consolidation of retail and institutional accounting systems
- Coordinate support and configuration management
- Collaborate with cross functional/cross divisional resources across the continent in multiple time zones
- Contribute towards planning offshore development environments conforming data security restrictions to meet information protection regulations
- Manage deployments in all pre-production as well as production environments supporting Agile/Scrum development methodology
- Follow compliance with Change and Release Governance and practices at individual Division level
- Conduct QA Triage Meetings during Functional and SIT testing phases
- Develop internal processes for Release Management
Confidential
Senior Consultant: Change Release Management
- Responsible to Manage Release Change Management activities for MRL Merck Research Laboratories - Clinical
- Contribute towards Change/Release process improvement and best practices utilizing knowledge and experience in ITIL v3.0 framework
- Closely work with Global Solution Partners, Shared Services Group and Business. Provide Change/Release Management support on Software/Infrastructure changes
- Provide strategic input in area of improvements to add further Service Management value
- Implement solutions to improve efficiency and service transparency utilizing tool based approach
- Overseeing and managing offshore UNIX deployment service group. Own and improve deployment processes and practices as part of transitioning of services
- Provide expert advice to Change Release Management Team Members in each functional discipline
- Run weekly cross functional team meetings on collaborative team efforts and decision making.
- Ensure compliance with Change Management best practices in Remedy Tool
- Chair weekly Clinical Change Review Board Meeting involving Solution Partners, Client Services, Operations and Application Technical Leads. Gain agreement on Change approval on planned changes
- Provide input on approval to CAB representative
- Collaborate and Manage Merck wide Infrastructure initiatives from Change and Release Management space. Coordinate closure on Impact Testing related to Infrastructure Changes affecting MRL wide Applications
- Contribute towards proactive Release Planning, Execution and Post Implementation Review
- Facilitate any additional cross group Planning Meetings to avoid any collision risks in context of multiple Change, Release and Operational activities and Emergency Changes
- Successfully designed and implemented Release Dash Board Calendar for Clinical Forward Schedule of Changes and UNIX Deployment Service Planning. Significant enhancement in terms of efficiencies and transparency
- Contributed to Change Release Metrics and UNIX Deployment Metrics
Confidential
Senior Business Analyst
- Responsible to create detailed ETL Functional Design Specifications, documenting the business needs and test plan for Clinical Informatics Data Warehousing Project related to Consumer Centric Data Mart CCDM
- Gained acceptance from Business and Informatics Management on Design Specifications
- Worked with Data Stage ETL developers to ensure compliance with functional design specifications
- Developed and successfully tested data mappings, and managed QA at several stages of ETL process running SQL queries on Oracle as well as DB2 Tables
- Active engagement in problem resolution and adherence to design and quality control standards
- Review and communicate test results
- Ensured timely product delivery on a business critical project with extremely aggressive deadline utilizing previous experience in Healthcare and knowledge specific to Member and Provider database
Confidential
Senior Release Manager
- Provided release management services to global project/program teams/application owners since the inception of shared release management service group.
- Relation building, service marketing and communication: Established and maintained relationship with project/program teams/application owners, line technical staff, shared services infrastructure and platform owners and SME throughout the enterprise
- Managed and conducted self-contained as well as complex integrated releases. Supported releases as part of fast track and large scale application development programs
- Change management: Monitor, track, assess and approve changes. Communicate changes with application, infrastructure and platform owners/environment managers. Coordinate risk assessment as well as capacity planning specific to shared platforms. Recommend required testing based on risk assessment. Attend change review board meeting.
- Maintain release tracking tool release dashboard : Log release schedules, platforms technologies, resources, checkpoint /gate meeting schedules and track progress records
- Release planning and coordination: Prepare release/deployment artifacts/deliverables. Identify release tasks and determine sequencing of activities. Plan resources. Define, document and get approval on backup and rollback strategy as well as contingency plan. Schedule release. Procure release notes and installation artifacts. Perform code version tracking. Conduct release communication. Track, manage, communicate and mitigate risk. Service validation and test planning. Create and track service center ticket to engage shared services and operations resources meeting OLA and SLA. Scheduling of pre, mid and post release communication as well as release closure tasks.
- Process adherence: Follow Release/Change management processes and best practices
- Meeting coordination, approval and participation: Attend project/ program team meetings, gate / release discovery and readiness meetings , defect and change approval meetings
- Participate with all external governance processes and periodic meetings
- Release execution: Manage Deployment execution into test/stage as well as production environments as per Release Plan. Work collaboratively with Pfizer Global Research and Development Informatics PGRDi , Pfizer Global Manufacturing PGM , Pfizer Global Pharmacia PGP project/program managers, technical teams and shared services teams within WTE, WTI, support services and site services group
- Post Release validation: Conduct execution of Post Release Operation and Performance Qualification testing dealing with business as well as onshore/offshore vendor resources
- Execute rollback and contingency plan in any adverse circumstances as agreed with project team and technical resources. Identify and escalate issues.
- Conduct release communication and release closure
- Debrief: Manage issues/conflicts resolution as well as release debrief meeting
- Maintain release management artifacts and builds: Update release calendar/release tracking tool dashboard . Procure release notes and installation artifacts as well as final builds. Create and preserve release package, Adhere to SOX compliance as well as applicable regulatory requirements
- Coordinate support and configuration management: Maintain and coordinate updates of changes on ARC, INFOBASE, CMDB and DBA Matrix. Ensure availability of final version of artifacts and build in Source Forge/SourceSafe.
- Plan and coordinate end user training and artifacts. Work with Project Team to procure training plans and support artifacts. Plan and coordinate training activities as agreed with Application/Project Team
- Process development: Extensive participation in change and release management process development and standardization of practices.
- Team building and resource development : Participation in hiring and mentoring newly hired onshore as well as offshore vendor resources
- Application development life-cycle methodologies: In depth familiarity with Agile, Waterfall as well as Enterprise Life Cycle Internal to Pfizer and adaptable to all industry
- standard methodologies
- Managed platform as well as infrastructure set up releases .Net, Microsoft Project Server, Grid
- Deployment platforms and technologies: WebLogic, ASP .NET, Citrix, Documentum, Data warehousing and Data Mart, SharePoint, Business Universe, Business Objects and Business Intelligence, SQL Server, Oracle 10G, Composite, Informatica
- Large scale integration project: Key player in a major global medical data warehouse GMDW integration with Development Information Factory DIF releases as part of company take over. Managed the most complex, inter dependent, business critical time sensitive phased releases dealing with shared objects, parallel deployments and multiple platforms. Successfully managed a large group of global resources from different disciplines.
- Offshore transitioning of release services: Developed and successfully implemented knowledge and work transition to offshore vendor partners in controlled, risk mitigated phases as part of outsourcing efforts
- Onshore and offshore vendor resource and workload management: Handled successful delivery managing onshore as well as off shore vendor resources from Engineering, Testing as well as Operations groups Offshore vendors: Infosys, Satyam .
- Process development: Full participation in release management process development and best practices following process compliance guidelines and ITIL Contributed towards all progressive phases of release management process maturity
- Familiar with pharmaceutical compliance and regulatory requirements
Confidential
Common Engineering Coordinator - Development Informatics
- Coordinator for the Development Informatics portfolio
- Supported communication and marketing of Common Engineering CE shared services now WTE to the project teams within the PGRDi
- Analyzed the project needs and assisted in scheduling shared resources/services during the project initiation phase
- Performed a liaison role between functional organizations, customer, stakeholders PMO
Confidential
Project Manager, Confidential
, Integrated Care Management Team
- Managed release based Performance Volume Stress PVS testing of Cigna's Integrated Care Management System ICMS
- Test planning by defining PVS test scope on Test Approach document
- Resource planning, scheduling and work plan management
- Defined and managed PVS test environment needs, data strategy and performed configuration planning
- Provided application expertise in support of PVS LoadRunner script development activities
- Test results analysis and research of PVS performance issues dealing with development team, DBA and test engineers
- Published test results and recommendations resulting from PVS testing and prepared and submitted Change Request Form CRF
- Participated in predictive model development for estimating DASD resource requirements based on membership growth Full Contribution in Capacity Planning
Confidential
Project Manager, QA Data Management, Confidential
- Provided project management support as part of Cigna's major centralization project
- Managed and ensured quality data requirement for test data bed dealing with diverse technical and business groups for end to end system testing and training environments
- Provided technical recommendations related to Central Provider File CPF batch process tuning to resolve and improve the performance of CPF data load
- Managed and assured data quality by developing and utilizing data driven automated WinRunner scripts for data loading
- Produced reports from DB2 database during various data loads to resolve IBUS transaction fall-out issues and also for intra application data verification of Providers, Networks and Demographic information.
Confidential
Technical Lead/
- Product deployment/system implementation of Life and Annuities web site and Service Log Intranet applications dealing Confidential
- and development team resources
- Supported data warehousing group in troubleshooting the batch issues related to data quality Fixed database objects - SQLs, stored procedures and Pro C scripts Assisted web developers in performance tuning of database queries and provided suggestions on database side alternatives for performance improvement
- Developed/enhanced PL/SQL procedures, SQL Loader scripts, UNIX K - Shell scripts to automate and load insurance standard ADM database to load from daily mainframe batch feed
- Assisted web development team to modify web application utilizing database side alternatives to resolve performance issues
- Provided support to Confidential
- n production implementation of ADM database and data load processes to load data from daily mainframe batch feed as well as Service Log Intranet applications
- Proposed a design alternative for database for web applications in order to minimize the time loss anticipated due to full refresh. Re-designed and modified existing scripts in support of this task
EXECUTONE
Development Lead Database Administrator
Confidential
- Lead team of three on technical development as well as DBA support on SAP to Oracle ERP Application conversion of Manufacturing/Financial modules as part of company takeover - Executone by Inter-Tel
- Worked closely with functional lead on systems analysis of pre-existing SAP system in context of mapping with Oracle functionalities
- Lead data mapping activities - SAP to Oracle interface tables
- Planned, designed and executed data transformation and migration from SQL Server to Oracle database Provided full DBA and Oracle database development support on this major conversion project Performed data migration utilizing SQL Loader, PL/SQL procedures, functions and packages
- Performed successful system conversion at full business satisfaction
Confidential
Senior Oracle Developer
- Worked on a Full Life Cycle Y2K compliant system development project of completely integrated and automated Retail Control System RCS to assist store departmental managers and accountants in accomplishing various business functions:
- Tracking inter-departmental supply/inventory transfers for accounting purpose
- Decision making and ordering groceries based on departmental income projections
- and sale deals
- Decision making on ordering perishable items for deli, meat
- and seafood departments based on Gross Profit Projections
- inclusive of shrink losses
- Sales planning and order scheduling
- Submitting price check from competitors
- Calculating and submitting perishable inventories
- Performed system analysis Planned, designed, developed and implemented full RCS system consisting of forms, reports, automation processes for loading data in store ISP In Store Processor database from a file from corporate, extraction and transfer of the files from the store ISP to corporate
- Used iterative development model dealing with business customers, business analyst and end-users to justify all business needs
- Performed unit, integrated as well as end to end system testing and Y2K compliance
- Performed code management utilizing PVCS
- Assisted DBA in deploying system to over 300 grocery stores nation wide
Achievement Award:
Recipient of prestigious Achievement Award for successful system implementation in over 300 grocery stores nationwide
Confidential
QA and Testing Sr. Specialist
- Provided integration testing services for a project involving conversion of applications from 16-bit to 32-bit format
- Contributions included in test planning, execution and risk assessment
- Conducted software packaging using InstallShield and distribution utilizing SMS
- Performed reporting of test results to requesting IT
- or Business Groups Cigna Health Care, Sales and Underwriting, Provider and Medical Management
Confidential
Oracle Developer
- Worked as a developer on a project related to Flight Safety Parts
- Designed and developed various Developer 2000 based Forms and Oracle database objects for a system consisting of various Manufacturing modules to change the part model specifications, to perform group edits on various safety-related specifications and also to process approvals on changes
Confidential
Oracle Developer
- Served on the Distribution Services/Commissions team as Oracle developer dealing with VISTA system
- Responsible for troubleshooting and modification of Oracle based database packages and modules involving financial transactions, commission calculations, tax related processes and performing databases updates as necessary
- Performed trouble shooting analysis, fixing the issues, testing and implementation
- Created extracts and performed update on database for a project dealing with postal regulation compliance