AMANJOT SINGH

PL/SQL DEVELOPER

Location: New York Email: ady4zs@r.postjobfree.com Mobile: 317-***-**** SUMMARY:

• Experienced Oracle database administrator /SQL Server Database Analyst with certified Oracle Professional with over 9+ years of experience in the areas of Telecom Billing, Oracle on Linux, HP- UX, and Windows servers.

• Experienced in writing and optimizing SQL queries Oracle database /SQL Server Database.

• Experience as SQL Developer with extensive experience in analytical techniques.

• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.

• Performed data analysis and data profiling using SQL on various sources systems

• Extensive knowledge and experience in producing tables, reports, graphs, and listings using various procedures and handling large databases to perform data manipulations.

• Lead the design and development of ETL processes using SSIS to extract data from various sources, transform it according to business requirements, and load it into target data repositories.

• An excellent team player and technically strong person who has the capability to work with business users, project managers, team leads, architects, and peers, thus maintaining a healthy environment in the project.

• Excellent written, communication, and Interpersonal skills.

• Collaborate with team members to collect and analyse data.

• Manage the configuration and maintenance of data sources for SSRS reports. Ensure that the data sources are secure, reliable, and accessible to authorized users.

• Structure large data sets to find useful information

• Worked with Whale Cloud & BSNL Pune as System Executive in Billing & Rating system.

• Worked with Excise & Taxation Chandigarh in Oracle server management.

• Worked with TCS & BSNL Chandigarh in the Intec Interconnect/Mediation Billing system.

• Worked as Migration Lead (OSS & BSS) (CDR Migration of North Zone.) Association with TCS Migration Team, Gurgaon

• Having experience in Production Database administration & Telecom Applications on clients (BSNL, TCS). SKILLS:

OPERATING SYSTEMS LINUX, WINDOWS, MAC

RDBMS ORACLE 10G, 9I, SQL SERVER, MYSQL, SSIS, POSTGRESQL, SSRS LANGUAGES SQL, PL/SQL, HTML

TOOLS TOAD, ULTRA EDIT, CUTE FTP

METHODOLOGIES SDLC, AGILE, SCRUM

NETWORKING TCP/IP PROTOCOL

APPLICATION DOTSOFT (I.T.PC., PUNE), INTEC MEDIATION AND BILLING SYSTEM EDUCATION:

MBA degree in Information Systems 2010

Sikkim Manipal University

B.Tech degree in Information Technology 2006

Punjab Technical University

EXPERIENCE:

Epsilon, New York, USA May 2021 – Current

Role: PL/SQL Developer

Responsibilities:

• Build SQL scripts that include complex queries for large databases with a complex authentication process.

• Validated and tested reports, then published the reports to the report server.

• Oversee the planning, execution, and completion of SSIS projects. This involves defining project scope, creating timelines, allocating resources, and monitoring progress to ensure successful project delivery.

• Performed and conducted complex custom analytics as needed by clients.

• Conducted research to collect and assemble data for databases – Was responsible for the design/development of relational databases for collecting data.

• Built data input and designed data collection screens - Managed database design and maintenance, administration, and security for the company.

• Develop and maintain a reporting strategy that aligns with the organization's business goals and objectives. This includes identifying reporting requirements from various departments and creating a roadmap for implementing SSRS solutions.

• Discussed intelligence and information requirements with internal and external personnel.

• Data output - Made data chart presentations, coded variables from original data, conducted statistical analysis as and when required, and provided summaries of analysis. Environment: Oracle, PL/SQL Developer, Excel, Windows, Linux, SSRS, SSIS Tenet Computer & Comm Pvt Ltd, Pune, India Feb 2020 – Oct 2020 Role: PL/SQL Developer

BSNL is an Indian Telecom Company. The business objective of the project is to carry out the data operations under CDR-based customer care and Convergent Billing System. The CDR-based system had been implemented by BSNL to provide an integrated and flexible solution to overcome the limitations of the existing legacy system. And the main purpose is to Generate the bill for usage of customers as per the opted plan.

Responsibilities:

• Involved in client-side requirement discussions.

• Created Procedures and SQL queries for discussed requirements. Analysing the requirement and creating procedures and writing SQL queries to provide required data, providing inputs and feedback to clients to change the requirement according to system architecture.

• Implement and enforce security measures for SSRS reports to ensure that sensitive information is only accessible to authorized individuals. This includes setting up role-based access controls and data-level security.

• Debugging procedures as part of incident management and problem-solving.

• Involved in e-invoicing changes.

• Involved in bug fixing with respect to production issues.

• Processed data load requests, manually entered data, reconciled data conflicts, and created data extracts and reports.

• Monitoring Oracle Apps Database of production.

• Handled client issues (O&M And AMC) for Billing Applications.

• Develop and maintain a data integration strategy that aligns with the overall IT and business goals. This includes identifying data sources, defining data transformation processes, and establishing data quality standards.

• Creation of tables for customer requirements.

• Coordination with the backup team for full backup and archival backups and other backups.

• Failover testing carried out every quarter.

• Active involvement in keeping track and daily monitoring of processes/activities during billing. Environment: - Convergys Billing Tool, PL/SQL Developer, HP Service Manager, Putty, WinSCP, WebLogic Server, Oracle 10g SSRS, SSIS

Mind Solutions Technologies LLP, Chandigarh, India May 2018 – Feb 2020 Role Oracle database analyst

Responsibilities:

• Installing and configuring Oracle Server Software.

• Creating an Oracle Database using DBCA.

• Creating an Oracle Database Manually.

• Knowledge of Oracle Architecture.

• Administering Users (Creating Users, Assigning Privileges, and Roles etc).

• Storage Structures (Managing and Creating Tablespace etc).

• Using Enterprise for performance Tuning (Segment Advisor, Memory Advisor, etc).

• Database Auditing (General Auditing, fine-grained Auditing).

• Oracle data export and import using DATAPUMP utility.

• Having a basic knowledge of DATA GUARD.

• Taking cold and Hot backups of the Database using RMAN.

• Using flashback to recover the deleted Row and Tables.

• Creating tables, views, synonyms, sequences, and indexes.

• Deleting and dropping the objects.

• All single rows and multiple-row functions.

• Having knowledge of PL/SQL like operators, loops, cursors, procedures, packages, etc. Environment: - Oracle RAC, RDBMS, TOAD, HP-UNIX, PL/SQL, LINUX, Shell-Scripting MAXTEL INFOSYSTEMS PVT. LTD, Chandigarh, India Sep 2011 – Mar 2018 Role: Technical Associate

IOBAS (Inter Operator Billing and Accounting Systems) North Zone at Data Center Panchkula project with all O&M and billing activities between different Operators. It includes Mediation, Pricing, and Billing system. IOBAS Web Portal generated for invoice generation and for report generation (Cover note, POI wise and TGP wise, etc). Responsibilities:

• Managing Operations Interconnect Billing Team.

• Guiding team members on day-to-day operational activities and business requirements

• Migration of new scenario implementation.

• Interaction with business and network teams for call scenario Configurations

• Ensuring the Reference data configuration (like Switch/trunks, Tier, CNP, Rate & Calendar

• Configurations etc) and switch-related issue resolution within given SLAs

• Day to Day call details Records rating, Re-Rating, and Resolution of rejected EDRs occurred due to incorrect/missing reference data configuration at Interconnect operations or Mediation End.

• Bill Period Closure, Financial Extraction and thus providing Summaries to BSNL as per their invoice generation requirement.

• File Reconciliation & CDR Reconciliation.

• Application/DB System Health Check & Server Maintenance.

• CDR Extraction.

Environment: - Oracle 10g RDBMS, TOAD, HP-UNIX, PL/SQL, LINUX, Shell-Scripting, Interconnect V7.1 MAXTEL INFOSYSTEMS PVT. LTD, Chandigarh, India Feb 2010 – Sep 2011 Role: Migration Lead (OSS & BSS)

BSNL CDR Project, which is the largest System Integration Project of 334 SSA’s PAN India into 4 DC, transforming over 55 million active subscribers, BSNL CDR means Call Details based IRB System, We are implementing world-class OSS BSS in BSNL CDR, which includes applications like SAP CRM, SAP FI, Clarity, IRB (Infamy’s Rating and Billing) System, etc. CDR Project world’s biggest Data Migration Project of Call Details Record (CDR) based Billing and Convergent Systems in the North Zone (110 SSA’s) of BSNL. Our responsibilities in this project include assisting in implementing next-generation State of the Art CDR-based Customer Care and Convergent Billing Systems, and deployment of Centralized Integrated Billing Systems with supporting technological and communication infrastructures. Migration from various Oracle Versions to Oracle 10G in a 1-year long project involving more than 50 TB of data Responsibilities:

• Meetings with heads of Telecom circles as well TCS Teams for exact requirements and resolution of pre-Go-live issues.

• Validation of Inventory data in Oracle at the SSA level & circle level using SQL queries despite MS Excel.

• Gap analysis and Impact analysis after understanding customer requirements.

• Providing SQL/PLSQL for data cleansing activity as per requirement.

• Imparting training to BSNL Users regarding Applications. Environment: - UNIX, LINUX, Oracle 8i,9i, 10g, RMAN), Exp/Imp, Monitoring, Security, SQL, PL/SQL, MySQL 5.5

Contact this candidate