Md Shahnawaz Afzal

• Negotiated contracts with vendors, achieving favorable terms while maintaining cost control objectives.
• Mentored junior consultants, improving their skills and knowledge through hands-on coaching and guidance.
• Reduced overall project costs by identifying areas for improvement and implementing cost-saving measures.
• Assessed potential risks during project planning stages, developing contingency plans to mitigate negative impacts on deliverables.
• Drove continuous improvement efforts within the organization by analyzing performance metrics and implementing actionable insights gained from data analysis.
• Collaborated with cross-functional teams to ensure seamless execution of project milestones and deliverables.
• Developed comprehensive project plans, outlining key tasks, timelines, resources, and budget requirements.
• Led the development of customized solutions for clients based on their unique business needs and requirements.
• Managed client expectations effectively by providing timely updates on project progress and addressing concerns promptly.
• Facilitated knowledge sharing among team members to build a collaborative work environment that fostered innovation and creativity.
• Improved client satisfaction by consistently delivering high-quality results within tight deadlines.
• Conducted regular progress meetings to update stakeholders on project status, challenges, and solutions implemented.
• Analyzed requirements, developed cost estimates, evaluated alternative solutions and supported information system acquisition and implementation.
• Prepared project lifecycle documentation and project management plans.

• Developed strong relationships with clients by providing exceptional technical support and expertise throughout the project lifecycle.
• Resolved complex issues through systematic problem-solving techniques, ensuring client satisfaction.
• Led successful project launches through rigorous quality assurance testing processes that identified potential risks early on in development cycles.
• Managed multiple high-profile projects simultaneously, delivering each within deadline and budget constraints.
• Streamlined the software development process for increased productivity and timely delivery of products.
• Investigated system issues and implemented resolutions to reduce downtime.
• Improved systems with addition of new features and infrastructure.
• Collaborated with stakeholders to transform client requirements into turnkey solutions.
• Oversaw document development across project workstreams to create internal control statements per compliance and regulatory standards.
• Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.
• Analyzed existing systems and databases and recommended enhancements to solve business needs
• Enhanced team collaboration with effective communication, coordination, and prioritization of tasks.
• Mentored junior consultants to improve their technical skills, resulting in higher project success rates.

• Managed change requests efficiently to minimize disruptions to ongoing production processes while maintaining high-quality standards.
• Implemented regular backup procedures as well as disaster recovery plans ensuring minimal loss during unexpected events.
• Facilitated seamless communication between technical teams, stakeholders, and end-users, ensuring timely resolution of incidents.
• Identified opportunities for process improvements through data analysis and continuous feedback from users.
• Reduced downtime with proactive monitoring, troubleshooting, and maintenance of production systems.
• Improved production efficiency by streamlining workflows and optimizing system processes.
• Boosted team productivity by providing comprehensive training on new technologies and best practices.

● Experienced in OracleSQL, PL/SQL, UNIX Production support and Development Projects.

● Expertise in PL/SQL (Oracle 10g, Oracle 11g) programming like writing Packages, store procedures, functions and triggers in Oracle.

● Involved in Development of the applications through Oracle using PL/SQL, created Tables, Cursors and SQL Queries.

● Worked as an ETL Informatica developer with good exposure to Reporting tools like cognos and Tableu.

● Possess good knowledge of Application support and ITIL process

● Good in Understanding of Business logic and ability to work well as a part of a team and as an individual.

● Ability to work in versatile environments, providing Application production support and preparing root cause analysis and ensuring the action points.

● Excellent in handing critical incidents and even discharged my duties as a Business Analyst and incident manager.

● Provided technical production applications support and assistance to customers.

• • Created technical design for the back end PL/SQL based on business requirement documents and the functional system design.
  • Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Involved in updating procedures, functions, triggers, and packages based on the change request.
  • Built complex queries using SQL and wrote stored procedures using PL/SQL.
  • Used ref cursors and collections for accessing comPLex data resulted from joining of a large number of tables.
  • Involved in moving the data from flat files to staging area tables using SQL loader.
  • Extensively used for all and bulk collect to fetch large volumes of data from the table.
  • Performed SQL and PL/SQL tuning and application tuning using various tools like tkprof, autotrace and dbms_SQLtune.