Priyanka Dube

Sr. Database Applications Developer/Snowflake Architect

973-***-****

adimjx@r.postjobfree.com

www.linkedin.com/in/priyankadube/

SUMMARY OF QUALIFICATIONS:

Over 10 years of experience as an IT Professional with expertise in working on analysis, design, implementation, upgrade, customization, maintenance, automation and enhancements using Agile methodologies. Mainly worked on writing queries & performance tuning in Oracle (10g/ 11g/ 12c, 19c), SQL Server 2016, I have good experience on Snowflake (Cloud) and Mongo DB.

Designed and Developed cloud based Datawarehouse using Snowflake architecture that includes data load using ELT and created dashboards.

Single point of contact for writing code using SQL, PL/SQL, UNIX (HP and AIX) shell scripting, Python for automating various application.

Creating dashboards and reports using analytical tools like Splunk & Tableau to provide the process details & utilization of robots in Blue Prism for Robotic Process Automation (RPA).

Worked on Oracle Golden Gate Replication process for Database Replication.

Created interface between applications using REST/SOAP API & tested using Postman/SOAP UI.

Knowledge on ETL (Informatica), SQL Server Integration Services (SSIS), DataWarehousing.

Used CI/CD pipeline as part of development process.

Experience on creating docker containers for deployment.

Created job on Jenkins to run automated tests.

Experience in all phases of Software Development Life Cycle (SDLC).

Skill set:

Databases: Oracle 11g, 12c, SQL Server 2016, Mongo DB, Snowflake Cloud

Technical Skill Set: SnowSql, Snowpipe, PL/SQL, Oracle SQL, My SQL, Python, XML Publisher, UNIX, Shell Scripting, IBM Integration Bus, REST/SOAP Web services, Core Java (Basic understanding), XML Schema Definition, Splunk, Tableau

Tools: Snowflake Web UI, AWS S3, SQL Server Management System (SSMS),Toad, SQL developer, SQL plus, SQL Loader, MongoDB Compass Community, Mongo shell, OEM (Oracle Enterprise Management), Bit Bucket, Tortoise Git, Source Tree, MS Excel, Docker, Rally, JIRA, Visio, Blue Prism (RPA), WinSCP, Putty, Confluence, Golden Gate Replication, Active Data Guard, Swagger, Postman, Docker, Ops Manager, Blue Prism

PROFESSIONAL EXPERIENCE

Oct’15 – Oct’20 ADP Technology Services Inc.

Designation: Senior Application Developer

1.Worked as a Senior Application developer for designing and creating/modifying, reviewing database objects and providing solutions for Integrating different applications.

2.Designed cloud based Datawarehouse using Snowflake architecture that includes data load using ELT tools like SnowPipe that being used for data analytics in dashboarding.

3.Developed end to end cloud-based data warehouse which includes loading data from various third party applications.

4.Created SnowPipes, databases, schemas, objects, UDFs and Shares using Snowflake.

5.Responsible to design and manage all database related products for 5 different scrum teams. I was leading all the development, upgrades, migration, datawarehousing efforts single handedly. All the bi-monthly releases were reviewed and approved by me and then was put into deployment process.

6.Designing and working on proof of concept for integrating new bolt on applications.

7.Supporting and ensuring smooth deployment of releases.

8.Involved in all phases of Design, Development, QA, and Implementation and production support of all BPM projects.

9.Create and manage all database related artifacts.

10.Created dashboards to analyze ROI in terms of time and money saved with the automation.

11.Integrated BluePrism (RPA) with Splunk and created dashboards.

12.Completed proof of concept on Tableau Dashboarding.

13.Worked on Zlinux migration of the application servers from VMs.

14.Responsible for providing monthly reports to higher Management by collating data from different databases using different data modelling tools.

15.Worked on Conversion of projects from Savvion to IBM BPM.

16.Performance tuning of various database objects.

17.Perform data mapping for data Migration.

18.Defines strategies for data migration needed for conversion of different projects.

19.Review, test and sign off all the database objects/activities before moving to higher environments.

Feb’09 to Mar’14 Tata Consultancy Services

Designation: IT Analyst

Clients: Belgacom, Sky Corporation and Xerox.

1.Worked as on-site Team Lead for Sky Corporation in Edinburgh, Scotland, UK

2.Knowledge in billing configuration modules such as Rating & Billing using Kenan billing product.

3.Involved in analyzing requirements and developing solutions.

4.Worked on enhancements on core Java.

5.Involved in the development and maintenance of Billing Interface - Billing Notification and generate Usage call records.

6.Preparing Development Requirements and Technical Designs Documents and getting them approved from Clients.

7.Created reports for higher management using SQL Analytical functions.

8.Completed end-to-end implementation for Payments Process which includes writing logic to generate National Automated Clearing House Association (NACHA) files by extracting information from legacy AS400 application using IBM SOA (Cast Iron) orchestration, consolidating all eligible invoices, validating the data, preparing the file and transmitting the generated file to the Bank, developing AMEX Credit Card remittance file & setup Check Printing.

9.Worked on automation of reporting process using XML publisher and uploading the reports on servers using XML Burst feature.

10.Developed interfaces using Oracle Advanced Queues methodology.

Jun’08 to Feb’09 E-biz Technocrats Pvt. Ltd

Designation: SQL Developer

1.Implemented Payroll generation tool for the employees of Madhya Pradesh State Electricity Board.

2.Developed and maintained Database objects like Tables, views.

3.Involved in writing SQL queries (Sub queries and Join conditions) and PL/SQL programming.

4.Involved in creating and maintaining of existing database objects like Tables, Views, Functions and Stored Procedures.

5.Conducted Onsite installation, maintenance.

Certifications

Oracle Certified Professional

Oracle Certified Associate

Education

Bachelor of Engineering (BE) in Electronics and Communications from Rajeev Gandhi Technical University, Bhopal(2004-2008).

Contact this candidate