14 + Years of Expertise in RDBMS (Oracle /MS SQL Server / PostgreSQL) Database design, Development, Report Development (Microsoft Power BI) and cloud-based data warehousing -Snowflake1. Oracle Development (7 years Approx):• Designed, developed and optimized complex SQL queries, PL/SQL procedures, functions, and packages.• Performance tuning and optimization of database queries and PL/SQL code.• Implemented advanced features such as partitioning, Sub-Partitioning, materialized views, hints and SQL Plan Baselines,2. Microsoft SQL Server Development (4 years Approx):• Designed, Developed, optimized, and maintained T-SQL queries, stored procedures, and triggers.• Developed complex SQL queries and including writing multi-join queries, subqueries, Analytical function and CTEs • Performance tuning and optimization of database queries and T-SQL code.• Used data modeling tools such as ER/Studio and ERwin3. PostgreSQL Development (1 years Approx):• Developed, and optimized complex SQL queries and PostgreSQL functions, triggers, and views.• Developed complex SQL queries and including writing multi-join queries, subqueries, Analytical function and CTEs4. Cloud-based DW (Snowflake and AWS) (3 years Approx):• Implemented Snowpipe ,Integrated AWS S3 for data storage and AWS Glue ETL for data transformation and loading into Snowflake.• Utilized AWS Athena to query data stored in S3• Configured AWS Glue Crawlers and catalog metadata from data stored in S3.• Developed and managed AWS Glue pipelines ,AWS Lambda ,integration tasks.• Utilized Python (PySpark) for advanced data processing and transformations, integrating results with Snowflake for further analysis.• Worked on Python development, utilized libraries like Pandas, NumPy, and PySpark for data manipulation.• Developed complex SQL queries, stored procedures, and user-defined functions in Snowflake • Designed and implemented permanent, temporary, and transient tables • Developed and optimized standard and materialized views • scheduling tasks to handle routine and complex data operations.5. Microsoft PowerBI Report Development (1 years Approx):• Designed, developed, and maintained interactive Power BI reports and dashboards • Created and managed pagination in reports to handle large datasets efficiently, enhancing user experience and performance.• Implemented dynamic SQL queries based on input from Power BI reports to interactively query real-time data from databases.• Developed complex DAX formulas to support advanced data modeling and calculations within Power BI reports.
