Pushpendra Singh

• Imaging and Workflow systems used for the processing of client/account requests as well as the archiving
• Access is controlled by user profile which determines what types of work can be processed or viewed by end-users
• Workflows are setup via an Administration tool
• Web version accessed via internet Explorer.
• Task Manager (Admin system) with expertise in handling user details, document management, and insurance data to streamline application workflows
• Focused on leveraging administrative system management to drive process improvements and support organizational success.
• It maintain all document in one place to find user task and packet.
• Coordinated task prioritization across administrative modules to streamline workflow, increasing overall system responsiveness and reducing user wait times

Achievements:

• Improved data processing efficiency through optimized PL/SQL code, enhancing overall application performance and reducing execution time.
• Mentored junior analysts, fostering professional development while enhancing overall team performance.
• Improved company efficiency with the development of key performance indicators and tracking metrics.
• Enhanced team productivity by streamlining workflow processes and implementing time-saving strategies.

• Nov 2019 Business Intelligence Analyst NTT DATA (Bangalore) SEI Investments is a leading global provider in investment processing and investment management with headquarters in OAKS, US
• This is a data migration project responsible for migrating a number of firms into SWP (SEI Wealth Platform)
• Configured and integrated SEI Wealth Platform modules to streamline data workflows, increasing system reliability and reducing processing errors in client account management.
• Involved in enhancing application functionality by developing PL/SQL code and conducting thorough unit testing adhering to stringent quality standards.
• Enhanced materialized views and packages to improve data integrity and reporting reliability, accelerating downstream BI processes.
• Collaborated with clients to resolve production issues, implement code fixes, and ensure seamless system operation.
• Achievements:
• Facilitated efficient data processing through the optimized design and development of PL/SQL objects, contributing to quicker decision-making processes.
• Contributed to project success by providing comprehensive communication through regular project review meetings and status reports, maintaining transparency and alignment across teams.

• Jun 2014 Technology Specialist Wells Fargo India Pvt.Ltd (Bangalore) The Project involves various application support activities .we are supporting various applications like arrow and TDCS .the task involves many jobs .jobs are running different timing
• Analyzed the impact of new processes and DB object creation, providing insights for optimized development.
• Improved customer satisfaction by providing timely and effective technology support.
• Developed and designed software for variety of applications.
• Conducted PL/SQL code reviews and unit testing to ensure code quality and reliability.
• Utilized knowledge of key Oracle performance-related features, like Execution Plans and Indexes, to optimize database performance.
• Managed defects using QC, ensuring resolution within SLAs
• Delivered high-quality presentations showcasing key technological advancements that contributed significantly towards business growth.

• NTTDATA (HIPERIO SYSTEMS (P) LTD) (Bangalore) Oct 2014
• May 2015 Data conversion process is mainly used for by pharmacies to migrate from their legacy application to the T-Rex application (Enterprise Rx).Data conversion consists of several steps for each store being converted to Enterprise Rx
• These include executable processes such as data extraction and translation, automated processes such as data loading, and manual processes such as data validation.
• Executed thorough testing of data files within QA environments prior to production deployment, ensuring data accuracy and integrity.
• Rectified defects efficiently in conversion code, enhancing data processing reliability and reducing potential errors.
• Contributed to coding and unit testing efforts for enhancements, guaranteeing the delivery of high-quality software solutions.
• Configured environments on Quick Build for new Pharmacy vendors, streamlining the onboarding process and ensuring system compatibility.
• Analyzed PL/SQL and shell scripting code to troubleshoot and resolve bugs, promoting stable and efficient system performance.

Achievements:

• Streamlined data loading process into Production by swiftly identifying and rectifying issues that arose, ensuring uninterrupted data availability.
• Ensured system stability by proficiently analyzing PL/SQL and shell scripting code to resolve bugs and proactively prevent system errors

• Software Engineer Magna Infotech Pvt Ltd
• Translated functional specifications (FS) into technical specifications (TS) to ensure accurate and efficient development processes.
• Applied strong experience in Oracle PL/SQL for various enhancement activities.
• Developed stored procedures, functions, triggers, cursors and packages to meet specific project requirements.
• Maintained knowledge of key Oracle performance-related features such as execution plans and indexes to optimize database operations.
• Developed new extraction processes for reports using PL/SQL and Dollar Universe
• Achievements:
• Contributed to optimized database operations through knowledge and application of Oracle performance-related features.
• Enabled efficient report generation by successfully developing new extraction processes using PL/SQL and Dollar Universe

• Software development, requirements analysis, package/procedure/job development, unit testing.
• Performed as a developer in various software engineering tasks.
• Analyzed and interpreted requirements to align with project objectives.

• DB analysis, script deployment, procedure/query optimization, scheduled job execution, environment maintenance.
• Analyzed applications to identify preferred database objects and dependencies.
• Deployed database object creation scripts from development to test and production environments using Exceed.
• Modified and optimized existing procedures and queries.
• Created indexes and rebuilt indexes to improve database performance.
• Executed scheduled jobs using Unix and Oracle scheduling tools.
• Conducted setup and daily maintenance activities for several application environments
• Achievements:
• Enhanced database performance through optimized procedures & queries, and strategic index management.
• Contributed to reliable environment operations through effective setup and daily maintenance activities.