Sasikala Chockalingam

Email: acs10r@r.postjobfree.com

Phone: 848-***-****

Worked as an Senior Database Developer with over 13+ Years of experience in Data Management System and handling the projects in the areas of Insurance, Legal, Publishing, Pharmaceutical, Financial and others.

SKILLS SUMMARY

Strong working experience as an Oracle PL/SQL developer and Data Modeler.

Extensive Experience in ORACLE SQL Scripts, ORACLE PL/SQL and Performance Tuning.

Created Different Database objects like Tables, Views, Synonyms, Triggers, Packages, Functions Etc

Involved heavy pl/sql coding and used latest features of PL/Sql including Bulk Operations,

Dynamic SQl, PL/SQL Tables, Temporary Tables, XML functions, XML/XSL Transformation etc.

Hands on experience in SQL Server Database and its related products.

Extensive Experience in Unix Shell Scripting.

Actively involved in Performance Tuning.

Hands On experience in Informatica PowerCenter 9.5.

Created Multiple Oracle Schemas, DB objects and Monitor Database Performance.

Extensive Experience in SQL Loader, Export and Import Oracle Utilities, GoldenGate and Oracle CDC.

Good Experience in Oracle Forms and Oracle Reports.

Work in a team environment and potential of providing individual effort.

Experience in data analysis, design, migration, integration and data warehousing concepts.

Experience in SDLC, Database design/modeling, Object Oriented Programming Concepts, Waterfall & Agile Methodologies.

Extensive Experience in Client /Server Methodology, On-line Transaction processing (OLTP) system, Batch Processing System, ETL and Datawarehousing and backend support to Web applications.

A keen communicator with exceptional analytical and relationship management skills.

Education:

MS in Mathematics, Annamalai University, India

Post Graduate in Computer Science & Applications, University of Madurai, India

Skill Set

Languages : SQL, PL/SQL, TSQL, HTML, XML

Database : ORACLE 11g/10g, SQL SERVER, MS Access

Shells : BOURNE, KRON, PERL

Operating System : UNIX (SUN, HP, AIX), Linux, WINDOWS

Software : Oracle 8/9/11i and Oracle Exadata, Informatica PowerCenter, TOAD,

Microsort SQLSERVER Management Studio, Oracle Enterprise Manager,

Oracle Developer Suite/Designer, Sql Loader, Export/Import,

SharePoint, PVCS, SVN, Jdeveloper, Sql Developer, Tidal Scheduler, Autosys

Career Highlights

Sanofi - Aventis

Senior Database Developer

Project : Labeling Lifecycle September 2015 – Till now

Labeling System helps to monitor and provides Healthcare Authorities one view of end-to-end safety labeling changes from safety signal detection to Health Authority Approval to Production of Labels. It also helps to track the changes, send alerts and report key performance issues.

Responsibilities:

Worked as Senior Database Developer in a fast paced environment.

Involved in the logical and physical database design, understand and convert the business logic to technical information.

Analyse the data and created interface between three different data sources.

Implemented the business logic in PL/SQL code using bulk operations, dynamic sql, PL/SQL Tables and triggers.

Created DB deployment scripts to deploy the code to SIT, UAT, and PROD Environments.

Actively involved in performance tuning and sql query optimization to improve query performance.

Environment : Oracle, .Net

Bank of America

Senior Database Developer

Project : Corporate Operational Risk Management June 2014 – September 2015

COR System has a common operational risk compliance platform collects the data from downstream resources called Enterprise Resource Data to provide common taxonomy and reference data to other different work streams like Operational losses, Risk Assessment, Key Measures, Vendor Management and Monitoring and Testing.

Responsibilities:

Worked as Senior Database Developer in a DataWarehousing and ODS environments.

Involved in heavy pl/sql coding and used latest features of Oracle to implement business logic using Bulk Operations, Dynamic Sql, PL/SQl Tables, Temporary Tables, Analytic functions, triggers, Materialized views, DB links, GoldenGate and Oracle CDC to replicate the data from different data source to the target database.

Developed Informatica mapping and workflows for initial and incremental of dimension and fact data loads using Informatica Powercenter.

Understand SQL Server Database objects and TSQL and populate the data to oracle database using different features of informatica ETL Tool.

Created DB deployment scripts in SVN to deploy the code to SIT, UAT, QA and PROD Environments.

Created Unix Shell scripts to execute and monitor batch jobs to load data using Autosys.

Actively involved in performance tuning and sql query optimization to improve query performance.

Environment : Oracle, Java, Informatica, Sqlserver and Unix

LexisNexis Inc Feb 2008 - Dec 2013

Senior Database Developer/Application DBA

Martindale.com

Martindale.com is Martindale-Hubbell website for legal professionals. It helps to find lawyers, law firms, corporate counsel, legal articles, ratings, peer review ratings, client review ratings, community network to connect legal professionals through blogs, forums, webinars and more. It contains millions lawyers profile and law firms in United States, Canada and other countries.

Lawyers.com

Lawyers.com is leading online legal directory to find an attorney or lawfirm by location, area of law, legal news, legal information by topic, get advice from lawyers.

Responsibilities:

Worked as Senior Database Developer/Application DBA in Agile Environment

Involved in Sprint planning and scrum meetings.

Managed all phases of supporting the website in database development, including designing, configuring, creating modules, implementing, testing and post-launch support.

Created different Database objects like Tables, Views, Synonyms, Triggers etc.

Involved in heavy pl/sql coding and used latest features of PL/SQL including Bulk Operations, Dynamic Sql, PL/SQl Tables, Temporary Tables, functions, triggers, XML/XSL Transformation in an oracle database.

Excellent Experience in Creating Database Objects in SQL Server Database and TSQL coding.

Involved in transferring the data between SQL Server and Oracle Database.

Created Unix Shell scripts to create and monitor batch jobs to load data.

Actively involved in performance tuning and sql query optimization to improve website performance

Implemented Object Oriented Programming technique concepts in .NET

Managed database support for QA environment and Production environment also.

Partner with all other teams (database management team, software development team, designers) and users to provide best solutions by maintaining the best standards of practice

Provided database related support to maintain the website martidale.com, lawyers.com, Martindale Connected.

Extensive Experience in advanced Extract/Transact/Load Techniques.

Created and Monitored batch jobs to load the data hourly, nightly and fortnightly.

Used Tidal Scheduler to schedule and monitor batch jobs running in oracle

Environment : Oracle, .Net, Sqlserver and Unix

2. Pharmacopia, NJ Jan 2006 - Dec 2007

Information on Chemical and Drug Discovery (ICD)

Senior Database Developer

ICD system was developed to keeping track of Chemical and Drug discovery process. This system allow the chemists and biologists to define and register the library, register the compound, Tag and decode information, plate screening, production and track deliverable information.

Responsibilities:

Involved in Project Management Life cycle.

Logical and Physical Database design/Modeling using Erwin/ER Studio

Provide Technical Expertise to the development Team.

Developed Various PL/SQL stored procedures, packages

Worked in Oracle Forms 10g and Oracle Reports 10g

Tuning SQL Queries to improve performance.

Application Rollout from Development to Production.

Environment : Oracle, Oracle Forms and Reports and Unix

Cover-All Technologies Inc, NJ. Mar 1998 – Dec 2005

Senior Database Developer/DBA

Cover-All is providing customized software solutions for insurance companies. Cover-All provides full policy lifecycle management of policy administration for new policies, additional endorsements, return premiums, cancellations and renewals etc., rating and issuance, billing, claims and reports.

Responsibilities:

Worked as Senior PL/SQL Developer as well as Database Administrator

Involved in full application development life cycle with JAVA application development team

Worked closely with business analysts to implement business logic

Designed algorithm, charts and database design for developing the product

Maintains the application database repository using Oracle Database Designer

Developed application product modules using latest oracle features

Developed SQL Scripts and VariousPL/SQL packages, procedures, functions and triggers

Created Reports and Screens using Oracle Forms and Oracle Reports

Extensively involved Tuning and improved performance of the application

Worked extensively on improving query performance using Oracle Hints and TKPROF

Maintains the technical documents for all the modules

Involved in the product release process to the customers

Installed and Maintained Oracle 9i database in Unix Environment

Worked extensively on Database Tuning, Backup and Recovery Strategies

Created Unix Shell Scripts for Export/Import and data loading procedures

Developed Unix Shell Scripts for batch processing, Hot and Cold Backup automation

Implemented Daily Hot backup and Weekly Cold backup of the oracle database

Environment : Oracle, Java, Unix

Contact this candidate