Developer Manager
Resume:
VARUN ARYA
Contact: +91-996*******; E-mail: ************@*****.***
LinkedIn: www.linkedin.com/in/varun-arya
PROFILE FOR: SENIOR FUNCTIONAL ARCHITECT
EXPERTISE: Oracle (RDBMS), SQL, PL/SQL, Shell Script, JDA Demand Manager (i2) Certifications: ORACLE 9i Database Administrator Certified Professional (OCP); ORACLE Forms Developer Certified Professional (OCP); ORACLE PL/SQL Developer Certified Associate (OCA) Have 14 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation in Business Application using Oracle Relational Database Management System (RDBMS). Critical thinking, resourceful, calm under pressure, and highly flexible. Possess thirst for new challenges and offer dedication to helping populations from diverse multicultural and socio-economic backgrounds. Known for quick trust building, analytical problem solving, and time-critical project delivery during politically sensitive crisis situations. Currently associated as Principal Consultant-ERP, with Cognizant Technologies Solutions, Chennai Seeking career enriching exigent assignments in an organization of repute PROFILE SNIPPET
Highly-skilled software development professional bringing more than 14 years in software design, development and integration. Advanced knowledge of Oracle SQL and PL/SQL.
Knowledgeable Oracle Developer skilled in data collection, analysis and management. Works well under pressure and consistently meets deadlines and targets while delivering high quality work.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team. CAREER BENCHMARKS
Recognized for having created BMR Platform custom-made tools for SAP and Non-Sap applications to interact with each other and enabling Data Base migration using Golden Gate.
Won the following Certificates of Appreciation:
3M - Certificate of Appreciation in Q4 2017, Q3 2018 & Q4 2019
Cognizant - Masterstroke in Q4-2014 & Q2-2019
Cognizant- Rainmaker in Q2-2012
Avon - Shining Star Award in 2011
Avon/Cognizant- Star of Avon in 2010
Cognizant- Phoenix in Q3 -2009
Known for working on projects and issues of high complexity that requires in-depth knowledge across multiple technical areas and business segments.
Championed the enhancement of data migration job performance by 45%.
Augmented daily job performance by 30% by tuning DB scripts.
Effectively reduced down time of DB by 20% by creating DB migration scripts.
Broad based skills set encompasses proficiency in business process design, re-design, application software development and configuration, verification of application configuration through piloting, definition of required data migration & application interfaces and support go-live activities. CORE COMPETENCIES
Critical SKILLS: Project Coordination Information Gathering & Data Management Training & Mentorship Customer Satisfaction Product Functional Analysis Business Development Solutions Development System Design and GAP Analysis Technology Integration and System Upgradation Maintenance and Technical Support Risk Mitigation 2 P a g e
TECHNICAL SKILLS: Oracle SQL Oracle PL/SQL Data Base Administrator Shell Script JDA Demand Manager HighJump Performance Tuning
CAREER GLIMPSE
Principal Consultant-ERP, Jan 2009 onwards
Cognizant Technologies Solutions, Chennai
Ongoing Project: 3M – JDA I2 Demand Manager Implementation and Support project, June 2017 till date Technologies Used: JDA i2 DM, Oracle SQL, PL/SQL
Project Responsibilities:
Responsible for developing and testing Oracle Stored Procedures, Functions and Packages, tuning queries in Oracle SQL and PL/SQL, DBA activities and Shell Scripting.
Responsible for providing Functional and Technical support for JDA i2 application as a Functional Lead.
Actively involved in working on functional support requests & issues and extending key functional support to end users to improve customer satisfaction matrices.
Extending pivotal support to demand planning activities for products in different region.
Handling product issues, minor upgrades and its testing in close coordination with JDA i2 Demand Manager
Key role in review of code changes, test procedure, test plans and other deliverables using TFS.
Involved in suggesting solution for the business need.
Involved in creating knowledge base on the solution provided for customer problems.
Mentoring associates and help them in analyzing problems and improve their knowledge on product. PL/SQL Developer, Nov 2007 to Dec 2008
enVista Innovative Tech Services Pvt. Ltd. Hyderabad PL/SQL Developer, Jan 2006 to Oct 2007
Title Software Technologies Pvt. Ltd, Hyderabad
CREDENTIALS
Master of Computer Applications, IGNOU
Bachelor of Computer Applications; IGNOU
Certifications:
ORACLE 9i Database Administrator Certified Professional (OCP)
ORACLE Forms Developer Certified Professional (OCP)
ORACLE PL/SQL Developer Certified Associate (OCA) Date of Birth: 6th October 1980
Languages Known: English, Hindi
Current Address: Door No. 8, 8th Floor Block-3 PTN Pace Adarsa Selaiyur, East Tambaram Chennai 600073
See Annexure for Previous Project Contributions
3 P a g e
ANNEXURE
PREVIOUS PROJECT CONTRIBUTIONS:
Project: C R Bard – HighJump Implementation and Support project; Duration: Nov 2016 – May 2017
Technologies Used: HighJump, Oracle SQL, PL/SQL
Key Contributions:
Displayed keen acumen in discharging all responsibilities as a Functional Lead, providing Functional and Technical support for HighJump applications.
Instrumental in supporting warehouse support activities for order pick, pack, staging loading and shipping process.
Successfully implemented and maintained High Jump WMS Software in their warehouses as HighJump Techno Functional analyst.
Resolved product issues, minor upgrades and its testing by coordinating with HighJump.
Played a pivotal role in debugging process objects using visual debugger, Application/System Consoles and Virtual/Web terminals to identify the issues.
Effectively worked on few enhancements related to International Webwise reports.
Meticulously updated in SQL as required based on status of picks and requested changes by internal customers.
Generated key reports and monitored FedEx jobs.
Project: Total Gas & Power – Project Manager (Role); Duration: Apr 2016 – Oct 2016 Key Contributions:
With expertise managed all assigned functions in offshore deliverables and resourcing as a Project Manager.
Demonstrated skills in tracking project phases that affected project scope, sizing, cost & timeline of project during execution to enable timely completion and delivery.
Essayed an integral role in end to end project initiation and knowledge acquisition.
Accountable for ensuring project profitability through resource forecasting, offshore delivery, project billing management and optimal staffing.
Removed project bottlenecks by monitoring project progress in coordination with stakeholders and higher management.
Effectively coordinated with stake holders for any action items and bottlenecks related to delivery of project.
Generated key periodic reports for informed decision making by top management.
Project: Total Gas & Power – Incident/Calls, Change Request, Root Cause Analysis (Support Project); Duration: Sep 2015 – Mar 2016
Technologies Used: Oracle SQL, PL/SQL, Shell script, Oracle Forms Key Contributions:
Successfully discharged with all assigned tasks as Project lead, entailing providing project related update to the Project Managers to ensure any delivery risks or issues mitigation and management.
Efficiently planned, designed, tested and maintained applications in coordination with other software developers, business analysts and software architects.
Collaborated effectively with analysts, designers and staff to facilitate understanding and contributing to the technical solution from design through to code level.
Played a central role in timely identification of project risks and issues and their proper management.
Actively participated in reviews and meetings and provided updates on change requests.
Suggested key improvements in systems and gave proposals for cost optimization.
Scrupulously generated well-organized, optimized, and documented source code.
Deployed key documentation on status, operation and maintenance of software.
Contributed to the testing of the product in controlled, real situations before going live.
Encouraged team development efforts towards successful project delivery
Prepare reports, manuals and other documentation on the status and maintenance of projects.
Project: Elexon- Facility to enable BSC Parties to select either replacement contract notifications or additional contract notifications; Duration: May 2015 – Aug 2015
Technologies Used: Oracle SQL, PL/SQL, Shell script, Oracle Forms Key Contributions:
Displayed skills in project tracking and submitting project related updates to Project Managers.
Pivotal role in collaborating with analysts, designers and staff to suggest key system improvements and cost proposals.
Collaborate with other programmers to Instrumental in designing and implementing features by coordinating with programmers.
With expertise created and documented software tools required by other developers.
Debug existing source code and
Significantly contributed to technical design documentation, debugging of source code and polish feature sets.
Generated training manuals for users and tested products in controlled, real situations before going live. 4 P a g e
Project: Target- JDA Transportation Manager upgrade from 6.3 to 8.0 (TM Upgrade); Duration: Dec 2013
– Apr 2015
Technologies Used: Oracle SQL, PL/SQL, Shell script Key Contributions:
Significantly contributed as a Senior Consultant for data migration and performance monitoring.
Ascertained business requirements of clients for data migration needs.
Cross-functionally worked across projects to understand data usage and implications for data migration.
Extended key assistance to designing, planning and managing the data migration process.
Displayed prowess in preparing data migration plans including migration risk, milestones and quality, performing data migration audit, reconciliation and exception reporting.
Meticulously displayed system data analysis in order to manage source to target data mapping.
Effectively managed cross-program data assurance for physical data items in source and target systems.
Project: Target- One Supply Chain and Regional Fleet Management; Duration: May 2014-March 2015
Technologies Used: Oracle SQL, PL/SQL, Shell script, Erwin (Data Modeling) Key Contributions:
Efficiently designed and developed logical and physical layers for database, as Data Mode for Fleet Management application.
Leveraged best practices and tools, including SQL and PL/SQL to design database, data models, ETL processes and business intelligence (BI) reports.
Facilitated efficient and reliable database performance utilizing logical models.
Sustained data in all production and non-production databases and replication servers.
Mentored team on developing conceptual and logical database designs and physical databases.
Project: Target- Freight Estimation and Payment Authorization (FEPA); Duration: July 2013 – Nov 2013
Technologies Used: Oracle SQL, PL/SQL, Shell script Key Contributions:
As Team Leas for As a Team Lead for Developing FEPA Application development was involved in requirement analysis and developing and testing Oracle Stored Procedures, Functions and Packages with success.
Discharged with tuning queries in Oracle SQL and PL/SQL, DBA activities and Shell Scripting.
Reviewed code changes, test procedure, test plans and other deliverables using TFS.
Project: Philips BMR Console; Duration; Jan-June 2013
Technologies Used: Oracle SQL, PL/SQL, Shell script Key Contributions:
Developed EAI solutions concerning BMR platform as Senior Developer in coordination with Functional Consultants and Solution Owners.
Successfully designed EAI solutions based on BMR platform, build and implemented interfaces on BMR platform.
Instrumental in the maintenance and support of production interfaces on BMR platform.
Promptly executed services (queries, reports) for interface owners and other involved parties.
Design, build and maintained web-enabled front-end applications (GUIs) for interface monitoring-tools.
Skillfully maintained custom-made monitoring tools (BMR-Console) and troubleshot performance issues concerning BMR interfaces.
Project: Avon – USEC US; Duration: Feb 2009 – Dec 2012
Technologies Used: Oracle SQL, PL/SQL, Shell script. Key Contributions:
Demonstrated skills in requirement analysis, estimation and preparing design document as senior developer and support analyst for the project.
Instrumental in developing and testing Oracle Stored Procedures, Functions and Packages.
Reviewed code changes, test procedure, test plans and other deliverables using MKS and HP Quality Center.
Extended key assistance in Production Support, DBA activities and Shell Scripting.
Project: Avon – GI3 Brazil; Duration: Oct 2009 to Dec 2009
Technologies used: Oracle SQL, PL/SQL, Shell script, MKS and Mercury Quality Center. Key Contributions:
Led key endeavors in requirement analysis, estimation and preparing design document as senior developer.
Developed and tested Oracle Stored Procedures, Functions and Packages.
Efficiently tuned queries in Oracle SQL and PL/SQL, performed DBA activities and Shell Scripting.
Reviewed code changes, test procedure, test plans and other deliverables using MKS and Mercury Quality Center. Other Projects Handled
Project: CARQUEST US - CPI
Project: - PREVIEW (Physical Resource Equipment VIEW)
Contact this candidate