Resume

Sign in

Data Sql

Location:
Delhi, National Capital Territory of Delhi, India
Posted:
December 31, 2015

Contact this candidate

Resume:

TEJASWITA KULKARNI

acsyrx@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Over NINE+ years of experience in developing and maintaining applications within systems in financial domain. Worked with Asset management companies as clients.

Strong knowledge on Oracle architecture and data base design.

Excellent skills in designing and development of applications using Oracle 11g/10g/9i SQL, PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.

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

Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.

Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.

Experience in Bulk Data loading using Oracle utilities namely SQL Loader.

Working knowledge in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.

Working Knowledge on UNIX, Windows and Shell Scripting.

Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.

In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, T-SQL using database tools like TOAD, SQL Navigator.

Strong experience working with large data sets typical to asset management companies, such as trades, positions, lots, securities, exchange rates, prices etc.

Worked extensively with Business Analysts and Business Users at the client side, knowledge of the financial terms like Security, Equity, Derivatives, Fixed Income, Future and Forward contracts, Options, Swaps etc

Expertise in Eagle Star and Pace application, with hands on knowledge in Web Panels, STAR Scheduler, STAR Message center, PACE uploaders and exporters.

Working knowledge of Control-M scheduler for scheduling the jobs.

Familiar with programming languages C, C++, VB Script, Visual Basic, HTML.

Excellent planning, analytical, written communication and Interpersonal skills.

Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

Certification:

OCA Certification (Oracle 9i), Oracle.

Capital Market Certification Level 1, Hexaware Technologies Limited.

SQL Server Certification, Infoserve school of technologies.

TECHNICAL SKILLS

Front-End Tools: TOAD, SQL Navigator, SQL Developer.

Databases: Oracle 11g/10g/9i/8i, Microsoft SQL Server, Microsoft Access.

ETL & BI Tools: Eagle STAR and PACE.

Programming: SQL, PL/SQL, T-SQL, UNIX Shell Scripting.

Operating Systems: Windows XP/2003/2000/NT/98/95, UNIX.

Other: SQL Loader, Control M scheduler.

PROFESSIONAL EXPERIENCE

Dec ‘14 - Present NBC Universal

Oracle PL/SQL Developer NY

The project Commercial Innovation (CI) Data Conversion involved development of PL/SQL procedures, functions, packages to convert the commercial ratings data for different NBCU networks into OnAir application. The client has started using a new front end application called “OnAir” for creating and maintaining the commercial ratings data such as Selling Titles, RateCards, Contracts, Plans etc. In order to start using this application, the original data needed to be converted from source systems (like mainframe, dealmaker etc.) to OnAir system. PL/SQL procedures, functions, packages etc. were written to capture the business logic for the source system in order to correctly convert the data into target system.

Responsibilities:

Interacted with the Business Analysts in understanding the business requirements for the project.

Created Technical mapping document based on the Business documents.

Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and SQL Developer.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.

Created Indexes for faster retrieval of the customer information and enhance the database performance.

Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.

Worked with Bulk Collects to improve the performance of multi-row queries.

Used Exception Handling extensively for the ease of debugging and displaying the error messages.

Used Quality center for defect creation and tracking purpose.

Environment: Oracle 11g PL/SQL, SQL Developer, SQL Navigator, Quality Center, Windows 7.

Jan ‘11 – Dec’14 Brown Brother Harriman

Oracle Developer/Eagle Developer NJ

The project Business Application Development (BAD) involved development and maintenance of the internal application. The application used Eagle Star and Pace tool for manipulating Fund accounting related information. The clients used Star Web panels to enter the accounting related information, the application used the Pace uploaders to load external data into the application. Exporters were used to report the data back to clients.

Responsibilities:

Interacted with the Business Analysts in understanding the business requirements for the project.

Gathered the requirements from the users and analyzed their business needs and created SRS documents.

Involved in SDLC including designing, coding and testing.

Design and develop Eagle Web panels for front end users as per business requirements.

Design and developed Eagle PACE uploaders and exporters.

Used application platforms Eagle Star, Pace, Scheduler, and Message Center etc.

Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.

Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.

Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.

Created Indexes for faster retrieval of the customer information and enhance the database performance.

Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.

Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Interacted with offshore team for new development deliverables. Also conducted code review for offshore team.

Environment: Oracle 10g, 11g PL/SQL, SQL Navigator, UNIX, Windows XP, T-SQL, Putty, Eagle STAR and PACE.

Mar ‘08 – Dec ‘10 Hexaware Technologies LTD

Oracle PL/SQL Developer/Offshore Team Lead India

The project ePACE Development involved loading the business data into the client side data warehouse called ePACE. Loaders were used to load the external data from flat files into the data warehouse. The business logic was then applied to the raw data using PL/SQL procedures, functions, packages to transform the data as per business standards. The exporters were used to export data to the internal reporting system called CRS.

Responsibilities:

Actively participated in gathering Business Requirements and System Specification from system users.

Responsible for Analysing requirements, designing, maintaining and updating data models.

Analyse the current data management procedures in practice and suggest ways for automating the process or improving the existing system.

Developed stored procedures to apply business logic on raw data.

Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.

Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.

Maintaining daily batch cycle and providing 24/7 support.

Used Control M scheduler in order to schedule the loader, uploader, and exporter jobs.

Involved in unit testing and integrated testing.

Involved in preparing the User Test plans.

Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.

Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.

Tuned complex stored procedures for faster execution and developed database structures according to the requirements.

Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.

Involved in importing the production data to work environment through TOAD.

Involved in handling the changes in compiling scripts according to the database changes.

Co-ordinate and manage offshore team to ensure timely and quality delivery to the client and reviewing offshore deliverables.

Environment: Oracle 9i/10g, UNIX Shell Scripts, PL/SQL, Control M Scheduler, TOAD, PL/SQL Developer, SQL Optimizer, Putty, PVCS, JIRA.

Jun ‘07 – Feb ‘08 Hexaware Technologies LTD

Oracle PL/SQL Developer India

Best Pricing was the internal client application for calculating the best price for the security. The application used to receive the security price data from various external vendors. This data used to get loaded in the client side data warehouse. Some business hierarchical rules used to get applied on all the possible prices in order to come up with the best price for a particular security for that day.

Responsibilities:

Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.

Worked as part of the development team, along with the Systems Analysts/Business Analysts.

Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.

Created PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.

Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.

Used Control M scheduler in order to schedule the jobs.

Developed UNIX Shell scripts for calling the stored procedures.

Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.

Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.

Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.

Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.

Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.

Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.

Effectively used Triggers to track the user profile updates and to send the messages to downstream systems.

Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.

Environment: Oracle 10g/9i, PL/SQL, SQL Server, UNIX Shell Scripting, TOAD, Control M Scheduler.

Jun ‘05 – May ‘07 Hexaware Technologies LTD

Oracle PL/SQL Developer/Jr. Oracle Developer India

Pacesetter was the internal client application for developing and maintaining the data warehouse at client side. Loaders were used to load the external data from flat files into the data warehouse. The business logic was then applied to the raw data using PL/SQL procedures, functions, packages to transform the data as per business standards. The exporters were used to export data to the internal reporting system called CRS.

Responsibilities:

Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.

Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.

Prepared Business Requirement Specification that gives the comprehensive details about the requirements.

Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.

Developed / modified scripts to create tables, views and executed them using SQL Plus.

Created SQL*Loader control files for moving the data from Flat Files to staging area tables.

Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.

Used Control M scheduler in order to schedule the jobs.

Prepared the procedures to update the internal structures to reflect the newly loaded data.

Used batch scripts to loop from database to database, to perform system-wide functions.

Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.

Environment: Oracle 9i, TOAD, SQL Navigator, UNIX Shell Scripting, Control M scheduler.

EDUCATION

Bachelor of Engineering (Information Technology), Fr. CRCE College of Engineering, Mumbai University, India, 2001 – 2005.

Higher Secondary School Certification, Sathaye Junior College, Mumbai, India, 2000 –2001.



Contact this candidate