Experience

• 

  Tech mahindra

  Jan 2009 - Jun 2011

  Oracle PL/SQL Developer(BSS)Environment: Windows, Linux, Oracle 9i,10g,SQL,PL/SQL, Pl/SQL Developer, ToadPrecise:Telecom Operations Prepaid, Oracle Developer, DBA with a wide range of experience in managing, designing and building custom applications using Oracle databases and tools in UNIX and Window environments using SQL, PL/SQL Developer, TOAD . Troubleshooting, maintenance, and installation of telecom operations and use my expertise in Foris System. Duties and; Responsible for the delivery of complex customized reports for Sistema Shyam TeleServices Limited Telecom, real time solution.Developed complex financial reports for Oracle SQL*Plus/UNIX environmentImplemented complex views, procedures, functions, packages and triggers in PL/SQL Tuned performance of existing SQL statements and PL/SQL code.Implemented back-end business logic of the ERP system.Database installation, SQL scripts development, DBA tasks, schema management Gained experience of BSS module.Automation of various business related reports by cron job, packages.; Monitoring instance parameters and health of the system.Monitor alert log and other application-related logs and take corrective actions.Monitor application, database usage and record the data for further analysis.Check performance parameters and tune accordingly.Manage application or database cloning.Monitor and manage COLD or HOT database backups.Managing users, responsibility, profiles.Support for Oracle Real Application Cluster database.Support for backup and recovery through 'Recovery Manager (RMAN). Weniger anzeigen

  • Technical Associate

    Jan 2009 - Jun 2011

  • Junior DBA

    Jan 2009 - Jun 2011

  • Telecom Developer, OSS/BSS

    Jan 2009 - Jan 2011
• 

  Hdfc bank

  Jun 2011 - Apr 2012

  Technical analyst, oracle plsql developer

  Over 2 years of experience in Oracle PL SQL Development and DBA. The Technical Analyst, a key individual in this process, will analysis and enhance business, manufacturing, financial and logistics software & systems, test, implement and evaluate results. develop logics and business processes to meet the needs of end users and vendor ,extract and evaluate data using SQL queries; and develop reports. Energetic self-initiator with excellent analytical and organizational skills. Achieves goals, objectives and milestones in an accurate and consistent manner. Enjoy taking responsibility for projects from start to finish. Weniger anzeigen

• 

  Impetus

  Jan 2012 - Nov 2013

  Software enginer

  • Implementation of Oracle stored packages, procedures, functions, Bulk options, Collections, triggers, database objects, Shell scripts.• Confirmed program operation by conducting tests; modifying program sequence and/or codes.• Developed Postgres database in Data warehouse to be able to implement tuning and scaling of scripts.• Perform ETL operation to transform the data into the target.• Provided performance tuning for team built (Redwood ETL) system before and after operation.• UNIX Shell Scripting.• SQL statement tuning.• Development and Migration of Oracle concept into Post gre SQL.• Prepared documents for the database system. • Assisted in solving all technical problems that occurred in the application and migration projects.• Stored multiple server applications in one-layered platforms for equal tuning and partition. • Operated the database and ensured that it was as per the storage requirements of the system.• Ahead looking for the Hadoop implementation over Oracle. Weniger anzeigen

• 

  Saama

  Jan 2014 - Feb 2016

  Consultant

  Informatica Developer, Talend, SSISEnvironment: Windows, Shell Scripting,Informatica 9.5.1,Oracle 11g,SQL,PL/SQL,SQL ServerTo Develop, test and deploy the development of various subject area's.Fine tune the code at Oracle level as well as at Mapping level.Experience in working with Informatica Power Center, SSIS, SQL Server,Oracle, UNIX, performance tuning techniques, etcAbility to take the requirements from the client and convert into Design and disseminate the sameto teamAnalyze requirements, perform impact analysis, design modules, build and unit test the codeHands on experience in writing complex Database queries, Procedures, FunctionsExcellent problem solving and analytical skills; including trouble shooting skills Weniger anzeigen

• 

  Hcltech

  Feb 2016 - Jun 2019

  Avaloq Certified ProfessionalAvaloqEnvironment: ICE, JIRA, Oracle 11g,SQL,PL/SQLTo Develop and enhance reports, AMI test and deploy the development of various subject area's.Fine tune the code at Report level.Experience in working with Script packages, Layouts , Task templates, Migr after/before scripts, Classification, Additions, Workflow and context action.Excellent problem solving and analytical skills; including trouble shooting skills

  • Team Lead

    Feb 2016 - Jun 2019

  • Avaloq Consultant

    Feb 2016 - Jan 2019
• 

  Ibm

  Jun 2019 - Apr 2020

  Senior advisor consultant specialist
• 

  Hsbc

  Apr 2020 - Jan 2023

  Avaloq certified professional
• 

  Hcltech

  Jan 2023 - now

  Technical architect