SHESTA SINGHA
SENIOR ANALYST
Vizag
Summary
Senior Analyst A confident and highly organized administrative professional with experience in different projects with a proven record of accomplishment from senior business figures in the management. With 4.1 years of experience in this field, I am meticulous in my approach to data collection and presentation and wants to take challenging role and utilize my skills in providing quality service to the company.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
2
2
Languages
Work History
Accenture
08.2021 - Current
- Backend database development in MS
Database Developer
01.2018 - 02.2023
- 4.1 years), Axis Capital company is one of the biggest insurance company in US that provides dependable, competitive priced coverage to families
- The job was to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various databases in both development and production environments.
ETL Developer
01.2019 - 07.2021
- Created Packages using SSIS for data extraction from Flat Files, Excel Files and OLEDB to SQL Server
- Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Execute Script Task, DTS Import/Export for transferring data from Database to SQL Server
- Used Data Profiling Task in SSIS to identify poor data and repair it
- Experience in Designing and Building the Dimensions and star cubes with star schema using SQL Server Analysis Services(SSAS)
- Involved in performance tuning of TSQL queries and stored procedures
- Optimized query performance by creating indexes
- Created simple and parameterized reports involving Sub Reports, Charts and Graphs using SSRS
- Troubleshooting production issues both at database and operating system levels
- Assist Service Manager and Service Director in providing management status reports on daily, weekly and monthly basis
- Assist business and technology stakeholders in establishing data management framework with necessary data quality controls and governance.
Cognizant Technology Solutions
07.2018 - 07.2021
Database developer
IAG Web Finance
07.2018 - 12.2018
- Extract data from various locations like Excel and flat files to SQL server
- 2
- Create database objects like views, Stored Procedures for hosting of Microsoft .NET common language run time engine with SQL server
- 3
- Database development with Microsoft SQL server in OLAP environment using SSIS for Extraction, Transformation and Loading
- 4
- Experience in T-SQL in constructing Triggers, Tables and implementing stored Procedures, Functions, Views
- 4
- Help develop test cases and plans to complete the unit testing and support System testing
- 5
- Created SSIS package for File Transfer from one location to the other using FTP tasks
- 6
- Created Database Objects- Tables, Indexes, Views, Stored procedures and User defined functions according to the requirements of the projects
- 7
- Using reporting Services (SSRS) generated various reports
- 5
- Communicated effectively with the other external IT development teams and the local development manager on the project requirement, updates and designs
- Training Undergone: Training in Advanced java, SQL, Oracle , HTML, CSS, Web development, Azure-900 Fundamentals, Data Architect Associate Assessment
- I hereby declare that the information furnished above is true to the best of my knowledge.
Education
B.Tech -
Institute of Engineering & Management (IEM)(West Bengal University of Technology
Bachelor of Technology - undefined
08.2013 - 06.2017
10th - undefined
Delhi Public School
12th - undefined
Skills
Java, Advanced Java(J2EE), SQL, Database, PlSql, PostGr Admin db, HTML, CSS
undefinedTimeline
Accenture
08.2021 - Current
ETL Developer
01.2019 - 07.2021
Cognizant Technology Solutions
07.2018 - 07.2021
Database developer
IAG Web Finance
07.2018 - 12.2018
Database Developer
01.2018 - 02.2023
Bachelor of Technology - undefined
08.2013 - 06.2017
B.Tech -
Institute of Engineering & Management (IEM)(West Bengal University of Technology
10th - undefined
Delhi Public School
12th - undefined
Similar Profiles
JESWIN JAINJESWIN JAIN
Performance Tester at AccenturePerformance Tester at Accenture
Amanjot Kaur LambaAmanjot Kaur Lamba
Workday Integration Consultant at AccentureWorkday Integration Consultant at Accenture
Sumit PatilSumit Patil
SAP Security and GRC Consultant at AccentureSAP Security and GRC Consultant at Accenture
Priyanka GhoshPriyanka Ghosh
Instructional Design Analyst at AccentureInstructional Design Analyst at Accenture
Praveensai KundetiPraveensai Kundeti
SOC Analyst at ConcentrixSOC Analyst at Concentrix