Sandeep Kumar Swain

• Assisted with planning, designing, coding, debugging, testing, documenting, and maintaining software applications.
• Developed PL and SQL stored procedures, functions and packages for data extraction, transformation and loading.
• Provided technical support for end users in Oracle DBMS and functional support in Oracle EBS application specifically in modules like PO,OM,AP and AR.
• Performed database tuning and query optimization to improve performance.
• Developed and customized Oracle reports and forms to meet functional business requirements.
• Managed version control systems such as Git and SVN for tracking changes in source code files.
• Designed interactive dashboards and reports using Power BI, empowering stakeholders with data-driven decisions.
• Conducted exploratory data analysis using Python libraries like Pandas, NumPy, Matplotlib, and Seaborn to identify patterns and trends.
• Collaborated cross-functionally to define KPIs, gather requirements, and present insights through compelling data visualizations using PowerBI and EXCEL .

• Optimized existing queries for better performance using SQL query tuning techniques.
• Experienced in Database Design, utilizing Entity-Relationship Diagrams (ERDs), normalization techniques, and data modeling to create well-structured and optimized databases.
• Skilled in T-SQL and leveraging SQL Server Management Studio (SSMS) for efficient database programming and management.
• Generated reports using Advanced Excel features including Pivot Tables, Charts, and Dashboards, and performed ad-hoc data analysis.
• Provided technical support for the development of reports with tools such as SQL Plus and TOAD.

• Optimized existing queries for better performance using SQL query tuning techniques.
• Resolved customer service requests related to database errors or performance issues quickly and efficiently.
• Conducted unit testing of all database objects before deployment.
• Created database objects like tables, views, indexes and synonyms in Oracle 10g database.
• Developed stored procedures, functions and triggers to support application requirements.

• Optimized procedures and triggers for production use by simplifying complex queries involving multiple tables through the effective utilization of joins and sub-queries, ensuring efficient data retrieval and processing.

• Developed SQL queries to extract data from multiple tables and generate CSV reports, providing valuable insights to business stakeholders and end-users, enabling data-driven decision-making.

• Developed and maintained complex SQL Server databases, stored procedures, triggers, and views to support business applications.
• Collaborated with cross-functional teams to gather requirements and translate them into efficient database solutions.
• Created database design and done data modeling activities, ensuring adherence to best practices and normalization principles.
• Performed database administration tasks, including backup and restore operations, index maintenance and performance tuning.