Sai Ram N

Sai Ram Nethikar Email:-Phone No: - BACKGROUND Sai Ram Having 10+ years of experience as Lead Implementation engineer in System Development Life Cycle (SDLC), which includes End to End Project Delivery, Business Analysis, Application Programming, Support, Testing, Implementation, Crystal Reports development, and overall Product Maintenance in Oracle SQl, PLSQL, SQl Server, TSQL, CRYSTAL Reports and trained on Hadoop and Python. EXPERIENCE SNAPSHOT ❖ INDUSTRY EXPERTISE ❖ Functional: • Work closely with Account Management Teams and other Department stake holders to ensure the successful implementation of project as per client need. • Good knowledge on ISP, VOIP, Data Centre and Pay TV domain in Billing and CRM Product. • Proficient in analysing client's business process and delivering the accurate solution to incorporate the same business logic in software product. • Overall ownership on all deliverables of the project including requirement analysis and be the single point of contact to business partners for any issues. Technical: • Having database experience using Oracle/Microsoft, SQL,T-SQL,PL/SQL, Sub Queries, Joins, Constraints, Views and Indexes, Partitions, Writing Complex Queries, Stored Procedures, Functions, Triggers, Index, Views, Cursors, Troubleshooting, Debugging, performance tuning and knowledge on Oracle standard API’s. • Migration/Porting of Data from Client’s Old Application to MagnaQuest Application. • Analyse existing SQL queries for performance improvements and suggest or develop new queries. • Good Knowledge in developing reports using Crystal Reports. • Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors, etc. WIPRO EXPERIENCE Npower, Project description (Dates 04/21 to Present) • • • ISP (Internet Service Provider) • Pay-tv • Banking Domain TECHNICAL SPECIALIZATIONS • SQL, PLSQL-Oracle • SQL Server,T-SQL • Crystal Reports • Unix ROLE SPECIALIZATIONS • Requirement Analysis • Software Build/Release Management • Client Interaction • Working at on site/Client location • Giving demos to Users • Working on POC’s (Point of Concept) INTERESTS NPower Limited is a British supplier of gas and electricity to businesses. It is a subsidiary of E.ON • Cloud based deployment Sairam Joined Alectra project for data migration for Single view customer from SAP, Mongo DB, Oracle … to Jenifer database using SQL Server. • Big Data • Key Contributions: • • • • Involved in preparing migration plans, Technical Design Document Prepared DB scripts for Migration project Giving Demos for POC Created Procedures, Cursors, Dynamic SQL Query’s, Functions, Performance Tuning, Query Optimization Created SSIS Packages. Working with the support team to support the project until it gets stable after it goes live • • • Energy and Utilities • Python • Hadoop • Tableau TOOLS • SQl Developer , SSMS , SSIS • Toad • SQL Loader • Putty Sai Ram Nethikar CAPGEMINI EXPERIENCE DBS, Development Bank of Singapore – (07/19 to 11/2020) As a Senior Consultant DBS Bank the development bank of Singapore is a leading financial services group in Asia. DBS provides multinational banking and financial services for individuals, Wealth solutions with an Asian advantage, solutions for business ranging from SMEs to MNCs Sairam joined the DBS Finance Consolidation team. He has been contributing in solution design, estimations, Code development, modifying existing code and change requests over the past 1.9 years. Key Contributions: • Modified existing code and developed PLSQL packages and procedures to load huge amount of data into base tables. • Loading upstream data into base tables by executing TWS jobs manually. • Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors. • Used JIRA tool for project management and bug tracking. • Solving HPQC defects raised by clients. • Data downloading activities from production to UAT. • Created solution design and technical specification documents. • Fix if any regression on already released patches. MAGNAQUEST TECHNOLOGIES EXPERIENCE Magna Quest Technologies is a leading software solutions provider in the areas of subscription management, billing, customer engagement, and enterprise security. Our customer management, billing and operations support solutions focus on Pay TV, Broadband, Convergent and On-line service providers. Enterprise security solutions are offered for finance, government, and defence verticals. We have more than a decade of domain experience, and our customers span over 25 countries. With our focused products, dedicated service and deep knowledge, we are committed to deliver value. Sai ram Joined Magnaquest technologies as a trainee implementation engineer and relieved as a Lead Implementation Engineer with total 6 years of working experience. WEBSURFER, NEPAL – (04/17 to 06/19) As a Lead Implementation Engineer. Web Surfer Nepal is one of the largest Network Service Providers in Nepal. With a network spread across 55+ districts, Web Surfer provides Layer 3 intranet connectivity to banks, insurance companies and business houses. Sai Ram joined the Websurfer Implementation team during first stage of implementation. He has been contributing in solution design, estimations, Product development, and change requests over the past 2 years. Key Contributions: • Analysis of existing billing solution and preparing the FSD mapping with the new requirement • Developed specific customizations using Oracle SQL, PL/SQL • Onsite Support to client for 2 Years. • Designed Crystal reports for Billing Systems, Order Management, CSR, B2B, B2C. Sai Ram Nethikar • Giving Demos and user training of Magnaquest ‘s product to Users and stake holders. • Done 3rd party integrations with Provisioning systems (SIMA, INTRAWAY and CONAX), Payment Gateways (LINK, BANALCO...etc.) & TAX integrations. • UAT support & Test Case preparation GRUPO-TV, BUENOS AIRES, ARGENTINA – (02/13 to 04/17) As a Senior Implementation Engineer. Grupo-TV is one of the top 5 leading Service Provider Company to in Argentina and their corporate office in Buenos Aires, Rosario, Salta & Santiago del estero. Grupo-TV provides triple play service (Pay TV, ISP & VoIP) for various types of customer like Individuals, Resellers, and Organizations etc. Key Contributions: • Analysis of existing billing solution and preparing the FSD mapping with the new requirement • Developed specific customizations using Oracle SQL, PL/SQL • Designed Crystal reports for Billing Systems, Order Management, CSR, B2B, B2C. • Giving Demos and user training of Magnaquest ‘s product to Users and stake holders. • Done 3rd party integrations with Provisioning systems (SIMA, INTRAWAY and CONAX), Payment Gateways (LINK, BANALCO...etc.) & TAX integrations. • UAT support & Test Case preparation EDUCATION B-Tech, Jawahar lal Nehru technology University, Electronics & Communication Engineering SKILLS SUMMARY SKILL NUMBER OF YEARS SKILL LEVEL* 7 5 2 2 2 2 3 3 3 3 3 3 7 4 5 3 3.5 3.5 0.3 6 6 1.9 3 4 4 3 Technical skills SQL PLSQL Crystal Reports Unix SQL Server (SSMS) T-SQL IT disciplines Software Developer Senior Software Technical Design Industry knowledge Energy and Utilities ISP Pay-Tv Banking * 1 = basic, 2 = familiar, 3 = competent, 4 = expert