Sunil Kumar Singh
Database Developer @Fidelity Investments
Signup · Get unlimited contacts
WORK HISTORY
Database Developer @Fidelity Investments
Working as a SPOC of Funds Network Database with the role of the independent contributor in B2B. • Being a solo person, I was responsible for CR Application stability, prod support, and resiliency. • Working on Agile mythology and deliverable-based on sprint duration and organization goal. • Able to build trust and relationships with customers to bridge the gap, so they are providing their requirements directly to me. • Adhoc report is also part of my responsibility. Many times customers are asking for Daily, weekly, or monthly reports. • Implementation of a reporting application, OBIEE report in this application, so RM’s can generate reports as a self-service model. And there is less load on developers for repetitive requests. • Create Technical specs, Unit test cases, Transition, and Op-docs. • Actively involved in Functional and technical discussion/design related to the project and supply the estimates for the work items. Also, being responsible for Create, Update & Review FDD & TDD. • ETL development using Informatica 9.6x, which migrated to10.2x and within a warehouse environment with star schema. • In an extension of that being L3 resource will manage bug identification and defect verification which will be part of the post-deployment process. • Developed Complex database objects like Bulk Collect, Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL based on use-case. • Also, being involved in the performance tuning of SQL queries. E.g, Oracle database design, development, and performance tuning. Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes, materialized view. In addition to that Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, and AUTOTRACE. • Based on the use case, have built advanced features of PL/SQL like Arrays, Records, Nested Tables, Bulk collect and Dynamic SQL.
EDUCATION
Indira Gandhi National Open University
BCA, Computer
Indira Gandhi National Open University
MCA, Computer
SKILLS
ABOUT SUNIL KUMAR SINGH
Having 15+ years of Information technology experience including all aspects of…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.