Praveen ER

Experience

• 

  Keystone Systech Pvt Ltd

  Jun 2014 - Apr 2015

  Networking Engineer

  •Managing their devices, servers (credit card naming NAC, NCC, SNC, Hypercom) including Cisco Catalyst Switches, Cisco router 2600, 2500, 1721, PRI, PSTN lines.•Monitoring PRI, BRI and ISDN network of the client.•Providing service desk support for the customer support engineers.•Hardware and software troubleshooting of windows systems.•Installing and configuring Microsoft outlook.•Installing Symantec antivirus and updating patches. •Handling LAN and troubleshooting network problems Show less

• 

  PanApps Inc

  May 2015 - now

  Software Developer

  • Strong software experience in design, development and deployment of web-based and Client-Server business applications. Expert in working in SDLC life cycles and expert in software support activities.• Assisted in the design, development and execution and daily oversight of the CA PPM tool administration, processes, and procedures.• Managed testing cycle, including test plan creation, development of scripts and co-ordination of user acceptance testing.• Created SSIS packages to export and import data from PeopleSoft,ALM, Database, Text, and Excel. Scheduling SSIS packages to perform load Data warehouse• Installation and configuration of Jasper soft server. Creating advances reports using Jasper studio. Fetching data from Data warehouse for creating Domains, Ad Hoc view, Dashboard.• Store procedures, User defined functions, Views, T-SQL scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.• Strong Knowledge of Data Warehousing concepts, RDBMS and Dimensional modeling primarily Star & snowflake schemas.• Managing IIS and Apache web servers in Windows.• Oracle 10g database management for live and production servers. Backup & Recovery using RMAN, expdp, impdp, PL/SQL, user credential, database installation, and configuration.• Deploying and maintaining Information security policy of Indian Navy Oracle Database. • Worked in a project migrating all the applications and database in windows 2008 server to windows 2012R2. Show less

• 

  IQVIA

  Jan 2019 - now

  Application Develper Spec 1
• 

  IQVIA India

  Jun 2021 - now

  Senior Software Developer

  .