Name: Lakshmi Rani

Number: (***) – *** - ****

Mail Id: adykyt@r.postjobfree.com

Summary:

•Highly skilled Snowflake Developer with 6 years of experience in designing and implementing data solutions that improve accuracy, security, and efficiency. Proven track record in reducing data errors by 50%, improving query performance by 40%, and developing ETL processes that move over 1TB of data per day. Collaborative team player with exceptional troubleshooting and debugging skills, committed to delivering data-driven solutions that support business intelligence and analytics.

•involved in making detailed program specifications, develop test cases, document test results, interface with QA/ Test teams and other IT teams for deployment into production.

•Expertise in WEB base application development using Oracle 12c, 11g, 10g, 9i, Forms and Reports 12c, 11g, 10g, 9i, Oracle APEX 20, 19, 4.5, 3, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

•Skilled at PL/SQL, INFORMATICA & UNIX Shell scripting.

•Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

•Extensive coding in PL/SQL and very strong in performance tuning and database design expert level Oracle 11g.

•Expertise in using Oracle9i/10g/11g/12c/19c Enterprise edition

•Created and used Functions, Indexes, cursor, Table Partitioning, Collections, REFCURSOR, Views, materialized views, indexes, Packages, Exception handling, Dynamic SQL and Triggers, Stored Procedures in PL/SQL.

•Extensive knowledge of ETL including with Informatica PowerCenter (9.1) in developing and administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager & Workflow Monitor.

•Wrote Unix Shell Scripts for scheduling jobs and executing PL/SQL objects.

•Experience in DBA activity, SQL performance tuning using explain plan, query Optimizer and Cost-Based Optimization (CBO).

•Experience in using Oracle development tool such as Toad for Oracle Application Development, SQL developer and PL/SQL Developer.

•An expert in creating documentation for unit testing and requirement gathering.

•Worked on AUTOSYS scheduler to monitor and run the ETL jobs.

•Worked for report creation in PDF and Excel reporting using XML reporting tool for Oracle Database data.

•Acting as POC for Application Development projects.

•Maintaining all the documentation related to developed objects which involve a code review checklist, technical specification, unit test document, FD (functional design) checklist.

•Provided support in various phases of testing (Unit testing, System testing and Integration testing, UAT).

•I conducted class room trainings sessions for new joiners to share my knowledge and bring them up.

•Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

•Experience in evaluating and performance testing the database applications. Implemented indexes on tables for better performances on data retrieval from oracle.

•Good understanding of the Oracle database, related utilities and tools.

•Extensive experience in Oracle PL/SQL and Unix Shell Scripting

•Good team player with excellent communication, analytical, written and presentation skills with strong aptitude towards learning new technologies.

Educational Qualification:

MCA . Master of Computer Applications, VTU, Bengaluru, India - 2011

Skill Set:

Operating Systems

UNIX

Technologies

PL/SQL,Snowflake, Data warehouse, Informatica, SQR, SQL, SSIS, Oracle

Databases

Oracle 10g, PL/SQL, SQL server

Application

Online and Offline applications for Premium Auditor

Domain Experience

Insurance & Banking

Languages & Scripting

SQL, PL/SQL, UNIX

GUI/ Dev /QA Tools & others:

TOAD, Putty, PL/SQL Developer, Salesforce, Autosys, Informatica (PowerCenter 9), SSIS

Experience:

Client: Xcelenergy contract with Tata Consultancy Service TCS, Minneapolis,

Sep2022 – Till Date

Role: Snowflake Developer

responsibilities:

Developed and implemented a data quality process that reduced data errors by 50% and improved overall data accuracy by 30%.

Designed and implemented a data security and access control system that met industry compliance standards and reduced data breaches by 75%.

Collaborated with cross-functional teams to develop and maintain data pipelines and integration processes, resulting in a 25% increase in data processing efficiency.

Implementation of Enterprise infrastructure tools;

Reduction of faults, root cause analysis;

Designed and developed a data warehouse automation process that reduced manual effort by 80% and improved data processing speed by 50%.

Optimized query performance by 40% through the development and implementation of indexing strategies and query tuning techniques.

Developed and maintained data warehouse monitoring and alerting solutions, resulting in a 30% reduction in system downtime and improved system availability.

Client: The General Insurance, Nashville, TN Oct 2021 – Sep 2022

Role: PL/SQL /ETL Developer

responsibilities:

•Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.

•Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.

•Development of Packages, Procedures, Functions, Indexes, Triggers and Packages.

•Dealt with SQL Trace, Hints and understanding the SQLT Extract and AWR reports to identify the performance issues.

•Performance tuning of SQL queries, PL/SQL objects like stored procedures, functions, packages and views using Indexes and Explain Plan for efficient batch processing.

•Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.

•Worked on Policy Center, Billing Center and Claim Center DWH and analyzing

•/extracting/transforming data into common data model and generating the extracts which accepted by ISO/MSO/AAIS Bureaus.

•Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i and Reports 9i.

•Developed ETL packages using SSIS/Informatica Power Designer for various customers to fetch data from different EDW sources.

•Loading (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sysbase and SQL server.

•Worked on different LOBS related to insurance which are Personal Lines (Homeowners, Dwelling, FAL and Farm Owners) and Commercial Lines (General Liability, Crime, Inland Marine, Commercial Auto Liability/No Fault/Physical damage and Fire and Allied Lines).

•Worked on UNIX shell scripting in automation of ETL Jobs.

•Creation of logs from the UNIX shell scripts for auditing the automated Workflow process.

•Working on Agile Methodologies with daily scrum meetings and share point/Microsoft Planner to update and monitor tasks.

•Converted oracle report into SQL* Report

•Processing the Interface Data using the SQL Loader by loading the data using Flat Files.

•Working on Adhoc Reports by writing Complex SQL’s using TOAD and SQL Developer.

•Enhanced the existing ECA (Error Correction Application) application based on the client requirements.

Environment: SQL server Management Studio for different client Database, Visual Studio Management Studio, Cisco Any Connect with client Database, JIRA

Client: Cross Riverbank, Boston, MA Feb 2020 – Sep 2021

Role: PL/ SQL Developer

Responsibilities:

•Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.

•Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server to create final Roster report.

•Developed procedures, functions and packages to implements the system's business logic using PL/SQL.

•Developed various anonymous PL/SQL blocks and named PL/SQL blocks like procedure, function, trigger, cursor and packages as per need basis and tuned the underlined sql

•Configuration, Parent package variables. Worked on Project level deployment in TFS.

•Worked on various mingle tasks for different sprints contributing for hyper loop process and Bullet train.

•Created different SQL jobs and maintained those jobs in the production.

•Maintaining and Creating new DB objects like tables, procedure, function, trigger, cursor and packages as per need basis using PL/SQL

•Understand Business Requirement and prepare FRs, SRs, POC, ADD (HLD & LLD), Development to implementation with emphasis on programming in Oracle SQL, PL/SQL and Unix Shell Scripting

•Experience using, implementing, or supporting Oracle HCM applications or Cloud technology.

•Worked on the cube deployment and star schema deployment to different data bases.

•Prior experience with Oracle ERP modules (Financials, Supply Chain, Manufacturing, or CRM), ideally from a functional or techno-functional perspective

•Performed tune to optimize SQL queries using SQL profiler and query analyzer.

•Worked on deploying the code and unit testing in different team environments.

•Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

•Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using SQL

•Created Data marts for Staging and Production databases for Operational Data Stores (ODS).

•Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

•Proficient in using TOAD, Oracle SQL Developer, MS Visio

•Used Visio, Oracle SQL Developer and TOAD Data Modeler

•With the help of visualizations in Power BI, created various visualization like Pie charts, bar graphs, Tree maps etc., that will helpful easily to understand the data.

•Implemented different types of constraints on tables for consistency.

Environment: MS-SQL Server, SSIS/SSAS/SSRS, VB.NET, ASP.NET, T- SQL, MDX, DAX, ETL, Power BI, Source Safe, TFS, OLTP, OLAP, ODS.

Client: TD Bank, NJ Mar 2019 – Jan 2020

Role: SQL Developer

Responsibilities:

•The Main goal was implementing stored procedures and views. Entering Patient data, Pharmaceutical data in tables.

•Designed SSIS packages to Extract data from different sources like SQL server 2012, MS Excel, Flat file, CSV and transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.

•Developed SSIS packages using for each loop in Control Flow to process all excel files within the folder, File System Task to move file into Archive folder. Processing and executing SQL task to insert transaction log data into the SQL table.

•Responsible for data analysis/reconciling gap for missing data elements between CDB and RDR in Oracle 12c env

•Designing new tables and appropriate constraints on Oracle 11g database

•Provided design, implementation and maintenance for custom reports and quarterly reports as pie charts, bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.

•Extensively used SSIS transformations such as Lookup, Derived column, conversion, Aggregate, Conditional split, SQL task, Script task etc.

Environment: MS-SQL Server, SSIS/SSAS/SSRS, VB.NET, ASP.NET, T- SQL, MDX, DAX, ETL, Power BI, Source Safe.

Client: The Chubb Insurance, Warren, NJ Nov 2016– Feb 2018

Role: SQL Developer

Responsibilities:

•Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.

•Involved in creating specifications for ETL processes, Managed changes to the project scope, project schedule, and project costs using change management procedures.

•Designed, Developed, Configured and deployed data stage jobs, scripts and

•AUTOSYS GIL.

•Extensively used Informatica Power Center tool for extracting, transforming and loading databases from sources including DB2 and Flat files.

•Modified Unix Shell Scripts as per technical specifications and automated Batch Jobs using AutoSys.

•Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

•Maintain the Oracle Database and MDM application server's objects

Environment: PL/SQL Developer, Autosys, UNIX.

Contact this candidate