Shiwani Pal

Offering over * years of experience in PL/SQL with a focus on Oracle, SQL Server, and ETL tools, with a passion for taking on challenging roles, utilizing expertise in data migration, code optimization, and business logic implementation to drive success; preferably in Delhi/NCR.

+91-999*******

Noida

ad3z1t@r.postjobfree.com

www.linkedin.com/in/shiwani-pal

EDUCATION

MCA from UPTU in 2014

BCA from Kanpur University in 2011

CORE COMPETENCIES

Data Migration

Code Optimization

Database Schema Design

Data Validation

Performance Tuning

Data Modeling

Requirement Gathering

Project Management

Unit Testing

Report Generation

Documentation

Collaboration and Communication

TECHNICAL SKILLS

RDBMS: Snowflake, Aurora Mysql, Oracle,

Teradata, SQL Server, PL / SQL

Programming,

MySQL.

ETL Tool: DataStage, Talend

Programing Language & Concept: Python, C,

C++, OOPS concept.

Application tool: MS Excel, MS Word, MS,

Visual Studio 2008, 2010

Power Point, Thin Client, Source Tree, SQL

Developer

Operating System: Win98, Win 2000, Win

XP, Win7, Win8,8.1, Win10

CLOUD: AZURE

CERTIFICATIONS

Azure Fundamentals AZ900

Azure Data Fundamentals DP-900

PROFILE SUMMARY

Possess over 9 years of expertise in PL/SQL development, showcasing proficiency in Oracle, SQL Server, and diverse ETL tools, contributing to robust database solutions.

Excels in eliciting requirements, executing standard modifications, scheduling tasks, crafting scripts, and enhancing code efficiency, ensuring seamless project delivery.

Adept at implementing business logic using Materialized View, Joins, Data conversion, Merge, Triggers, Views, Indexes, Sequence Stored Procedures, and Functions, gained knowledge in Azure Data Factory.

Showcased proficiency in Oracle 19c, Microsoft SQL Server, Jira, Source Tree, and MS Excel 2010, operating seamlessly on the Windows 10 platform, ensuring efficient project management and execution.

Possess skills in Python, C, C++, and OOPS concepts, enhancing the ability to develop complex algorithms and optimize code for efficient database operations.

Recognized for optimizing code, unit testing, and detailed design documentation, ensuring seamless validation and deployment using Bitbucket and Stash.

Recognized for driving improvement in data accuracy and system efficiency through the seamless execution of data migration.

Achieved improvement in database performance through code optimization and query tuning, resulting in enhanced system efficiency and reduced query execution time. WORK EXPERIENCE

Lead – Developer Empenofore Technologies Feb 2023 - Sep 2023 Client: Macquarie Bank Team Size: 11

Role:

Extracted customer requirements and executed standard modifications, ensuring precise alignment with project objectives and client needs.

Managed job scheduling, script composition, DB patching, and seamless roll implementation, ensuring streamlined project operations and execution.

Crafted and backed ad hoc requirements, formulating intricate logic utilizing diverse database elements, ensuring tailored solutions for dynamic project needs.

Verified code integrity through Bitbucket and Stash, enhancing code efficiency and executing comprehensive unit testing, ensuring robust code quality and performance.

Engaged in comprehensive data mapping and design documentation, ensuring precise project alignment and streamlined development processes.

Implemented a new database indexing strategy that resulted in reduction in query execution time, improving overall system performance and user experience.

Introduced a streamlined code review process, resulting in reduction in code errors and enhancing overall code quality, leading to improved system stability and reliability.

Technologies Used: Oracle 19c, Microsoft SQL Server, Control-M, Jira, Source Tree, MS Excel 2010, Windows 10

IT Analyst (Developer) Tata Consultancy Services Apr’22-Oct’22 Client: Walmart Team Size: 17

Role:

Gathered requirements from the customer and evaluated DOM documents.

Executed data migration using Azure Data Factory, creating pipelines and data flows.

Conducted data transformation and code optimization, along with unit testing and detailed design documentation.

Spearheaded the successful migration of terabytes of data for Walmart using Azure Data Factory, ensuring seamless data transfer and minimal downtime.

Implemented a new data transformation algorithm that resulted in an improvement in data processing speed, optimizing data flows and enhancing overall system efficiency.

Technologies Used: Azure Data Factory, Microsoft SQL Server, Jira, MS Excel 2010, Windows 10 Senior Software Engineer Impetus Technologies India Pvt. Ltd. Feb’21 to Mar’22 Client: Bank of America, LBrands, Pfizer, United airlines Role:

Led data migration, prioritize precise data mapping, develop a strong understanding of current data structures and mapped them to the target system.

Conducted a thorough analysis to anticipate challenges, dependencies, and data quality issues, ensuring a seamless transition and minimizing the risk of discrepancies.

Divided the migration into manageable phases, validating data integrity at each step.

Conducted data validation and executed jobs using ksh, Autosys, and Unix for Hive scripts.

Validated SQL, stages, and jobs, ensuring seamless data migration.

Technologies Used: Datastage, Talend, Pyspark, Snowflake, Vertica, Hive, Python, SQL, Unix PL/SQL Developer Impressico Business Solutions Feb’18 to Oct’20 Client: TriMed Technologies (United States),

Role:

Developed SQL scripts for reports and maintained SQL scripts for the portal and task scheduler.

Conducted database backup, restoration, and migration from Oracle to Aurora MySQL.

Technologies Used: Oracle 10g, 11g, Aurora MySQL, MS SQL Server 2014, MS Excel 2010, Windows Server 2010

Senior Analyst Indxx Capital Management Pvt. Ltd. Dec’16 to Dec’17 Client: STOXX (Switzerland Stocks Maintenance Industry) Role:

Utilized XML for mapping with different servers and conducted remote testing and implementation of scripts.

Conducted database backup, restoration, and unit testing, ensuring efficient data handling.

Technologies Used: MS SQL Server 2014, MS Excel 2010, Windows 10 SQL Developer Orasol Info Tech Jul’14 to Dec’16 Client: LIC, New India Insurance

Role:

Collaborated with the offshore development team, contributing to the entire SDLC, ensuring seamless project delivery and team synergy.

Engineered database elements, formulated functions, and validated accurate data integration into the warehouse, ensuring robust data management and accessibility.

Worked on Triggers, Cursors, Views, Functions & Stored Procedures.

Technologies Used: Oracle 10g/11g, SQL Server 2008R2/2012/2014, T-SQL, PL/SQL PERSONAL DETAILS

Date of Birth: 7th December 1989

Languages Known: English & Hindi

Address: Noida

Contact this candidate