Manager Data

Rachita Sarkar

Email: ******.*******@*****.***

Mobile: 408-***-****

Summary:

10+ years of experience in Database Development.

Strong Knowledge in Database Architecture, Data Modeling, SQL, Pl/SQL scripting, Performance tuning.

Extensive work experience in Oracle 12c, 11g, 10g, Oracle 9i databases.

Experience in using UNIX platform with shell scripting.

Development experience in Oracle Financials Technical 11i and R12.

Experience in MongoDB.

Experience in Python.

Technical Proficiency:

Database Applications: SQL, PL/SQL, Oracle12c/11g/10g/9i, Oracle Application 11i EBS suite, SQL Server, MongoDB.

Operating System: WINDOWS, UNIX

Tools: Oracle Developer, ER Studio, Toad, Autosys.

IT Experience:

1. Project: APTARE Storage Console and Backup Manager

Organization: APTARE Inc. Duration: February 2015 – June 2017

Description: The APTARE management platform is a suite of products designed to measure and forecast enterprises storage usage and provide backup infrastructure.

Responsibilities:

Working with product management teams and customers to turn business requirements into release product functionality using PL/SQL.

Developed database installation / upgrade processes.

Engaged in translating business requirements into data models.

Developed Backup Manager for multiple vendors.

Performance tuning & bug fixing for capacity manager, backup storage console.

Involved in design and implementation of noSQL dynamic reporting tool.

2. Project: Online ticket buying system

Client: StubHub Ebay Duration: June 2012 – February 2015

Description: StubHub is an online marketplace provides services to buy and sell tickets for sports, concerts and other live entertainment events. This project involved implementing new features (Gift Card, new APIs, Mobile Price Alert, Reward and View from Section) for Buy scenario in StubHub website and mobile app.

Responsibilities:

Interacted with business users to gather Requirements & create data model.

Implement Code/Data Fix and coordinated with functional team.

Data base object creation like table view, sequence, synonyms.

Involved in performance monitoring and tuning of SQL code.

3. Project: Business Engine Support

Organization: Bank of America Continuum Solutions Duration: May 2010 – April 2011

Description: BEN (Business Engine Support) tool was used in Merrill Lynch to store timesheet information to a data warehouse. This was migrated to Clarity, similar tool used in Bank of America.

Responsibilities:

Modified Oracle Objects like PL/SQL Stored Procedures and functions to existing process for Data load coming from Up Stream (RDR) of BEN, BENIP and BENDW.

Executed BEN to Clarity migration activities.

Interacted with users, gathered the Business Requirements.

Created and managed jobs running under AUTOSYS.

Executed production support activities, e.g., DB refresh, report generation.

Created Informatica mapping to load data from Ben to Ben warehouse.

Involved in performance monitoring and tuning of SQL code.

Implemented Complex Queries for Report Generation.

Developed UNIX shell scripts to automate routine tasks.

Developed various Unix Shell Scripts to create report, custom FTP utility, file archiving for Autosys job.

Used explain plan to increase the performance of SQL statements.

Developed Triggers on tables to capture data where there is a change in the tables.

Coordinated with DBA in Creating and Managing tables, indexes, DB Links and User Privileges.

Extensively used PL/SQL advanced features like PL/SQL tables, collections etc.,

Participated in Peer code reviews and verifying coding standards.

4.Project: FGI –GL & Sub Ledger Support & Enhancements

Organization: Bank of America Continuum Solutions Duration: April 2011 – April 2012

Description: Maintenance and enhancement Bank’s Ledger & Sub-Ledger. Data from various applications are consolidated by standalone applications and are fed to GL Interface using concurrent processes. Then Ledger data are processed for Financial Reporting.

Responsibilities:

Interacted with users, gathered the Business Requirements.

Created partition on GL tables for five years.

Created PL/SQL package procedure to automate code combination id disabling.

Created box Job and shell scripts in Autosys based on change requirement.

Involved in performance monitoring and tuning of SQL code.

5. Project: Axiom

Organization: Wipro Technologies

Client: UBS (Union Bank of Switzerland) Duration: March 2009 – May 2010

Description: Axiom’s Controller View application is a tool to enable regulatory and management financial reporting.

Responsibilities:

Developed short-hands, Portfolios, Aggregations and reports.

Implemented SQL trigger to maintain data consistency between source table and target table in Axiom database.

Involved in bug fixing for SQL queries and store procedures.

Involved in performance monitoring and tuning of SQL code.

Involved in Informatica mapping modifications.

Used External Table to load date from files provided by interfacing applications.

Extensively used PL/SQL advanced features like PL/SQL tables, collections etc.

Wrote queries involving multiple-joins to generate user reports.

6. Project: Marketing mix

Organization: Wipro Technologies

Client: Novartis Pharmacy AG Duration: December 2007 – February 2009

Description: The Novartis Brand Platform tool provides a new approach for marketing teams and associated groups in the CPOs to define and manage the marketing approach of medicines with all its facets.

Responsibilities:

Designed and implemented SQL queries to show break up of KPIs (e.g. expenditure) at sub target groups and sub activities level in UI.

Developed store procedures to cross compare KPIs across brands, regions, time.

Involved in implementing change request and bug fixing for multiple modules.

Used SQL*Loader to load data from flat files (excel/access) to Oracle database.

Involved in performance monitoring and tuning of SQL code.

Involved in writing test cases, unit testing.

7. Project: Global Reporter

Organization: Wipro Technologies

Client: Nokia Siemens Networks Duration: August 2006 – November 2007

Description: Global Reporter is a scalable, centralized data warehouse and reporting solution for the efficient collection, storage and analysis of network and service-related performance, usage and quality information. It enables operators to drill down into their data to deliver customized reports on network elements, the overall network and individual services.

Responsibilities:

Interacted with users, gathered the Business Requirements.

Designed and Implemented PL\SQL packages to developing a tool which partitions multiple 3G RAN tables which contain raw or summarized (DAY, WEEK, BH, WEEKBH) PM data from network elements.

Qualifications:

Passed MCA in 2006 from National Institute of Technology (N.I.T, formerly known as Regional Engineering College (REC)), Durgapur in 2006 with CGPA 8.27 .

Passed B.Sc. in Computer Application from Calcutta University 2002 with 70% Marks.

Contact this candidate