Sql Server
Resume:
Praveen S. ******.*******@*****.***
Summary of Qualifications
Around 12 years of experience in analysis, design, development,
implementation, maintenance and support of large scale database systems.
Financial industry experience with large database systems processing
millions of transactions per day.
Experienced on all the predominant database servers.
Excellent knowledge of server technologies - development, configuration,
integration and administration.
Experienced on a cross section of operating environments and platforms.
Excellent communication and interpersonal skills with ability to lead and
harmonize successfully in a team.
Knowledge and understanding of Business Components, Work flow, Performance
measures and best practices.
Assess client environment/needs and identify and outline solution
requirements.
Extensive work experience in Oracle 11g/10g/9i/8i/7.x databases.
Experienced in ETL development and Data Migration using native tools of
Oracle (SQL LOADER, PL/SQL).
Experienced in all database activities such as creating and managing
Materialized views.
Experienced in using built-in packages like DBMS_MVIEW, DBMS_JOB, DBMS_SQL,
DBMS_OUTPUT, UTL_FILE and DBMS_OBFUSCATION_TOOLKIT.
Experienced in using PARALLEL_ENABLE, PIPELINED and RESULT_CACHE features
in Oracle 11g.
Expertise in using PL/SQL packages, stored procedure, and functions etc.
using user defined Cursors/Ref- Cursors /Types/Object/Tables/Varray/Dynamic
SQL and TEMPORARY tables.
Expertise in Oracle tools like SQL*Loader, EXPDP, IMPDP, Export and Import.
Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN and TKPROF.
Experienced in Normalized Database Design and Modeling.
Experienced in Partitioning Administration; Creating and Managing
Partitioned Tables and Indexes.
Experienced in DOS/Windows batch programming and UNIX shell scripting.
Experienced in designing/generating reports using Crystal report designer
using Sub-reports, Charts, stored procedure and SQL Queries.
Experienced in SQL Server 7, SQL Server 2000 databases.
Experienced in using TSQL, ISQL, BCP, Bulk Copy, Stored procedure,
functions using temporary tables etc in SQL Server.
Experienced in Sybase 12 database using ISQL, BCP, Stored procedure,
functions using temporary tables etc.
In depth knowledge of using data dictionary tables/views in Oracle, Sybase,
SQL Server and other databases.
Experienced in using PERL scripts
Technical Skills
Data Base: Oracle 8i/9i/10g/11g, SQL Server 7.0/2000/2005, Sybase 12/12.5,
MySQL, IBM DB2, PGSQL.
Data Modeling Tools: Platinum Erwin and Microsoft Visio.
Tools: TOAD, PL/SQL Developer, IBM Migration toolkit and Quest Query
tuner and Microsoft PowerPoint.
Reporting Tool: Crystal Report Designer
Versioning Tools: CVS, Accurev
Operating Systems: Windows (95, 98, NT, 2000, XP, Vista), Linux, Sun
Solaris
Experience Summary
EffOne Software Inc, Sunnyvale, CA, USA
Database Engineer / Computer Programmer Mar 2008 - Present
Foresee Information Systems Pvt. Ltd, Bangalore, India
Principal Database Engineer, Jul 1998 -
Feb 2008
Projects Summary
Client: Equity Systems Support (Wellington Management, USA)
Duration: Jul 2010 - May 2011
Description: Equity Systems is a group which gives enterprise reporting
solutions to business analysts, portfolio managers and Investors. The ETL
process extractsthe data for third-party data vendors who will integrate
the data provided to give powerful analytics which are used by the business
in their day-to-day activities.
Roles & Responsibilities:
. Writing PL/SQL packages, stored procedure, and functions using user
defined TYPES/OBJECTS/TABLES/VARRAY.
. Used BULK COLLECT, RANK and PARTITION BY features in queries to
construct an OBJECT.
. Used PARALLEL_ENABLE, PIPELINED and RESULT_CACHE in functions which
is helpful for optimization of queries in reporting.
. Used analytical functions provided by Oracle 11g.
. Created and used user-defined aggregate function which is used with
PARTITION BY features in Oracle 11g.
. Performance tuning of queries using HINTS and EXPLAIN PLAN.
. Used PERL Scripts to execute the Stored Procedures, Queries and SQL
Loader tools to manage ETL process.
. Used IBM Tivoli's Job Scheduling Console (JCS) for schedule and job
management.
. Used variable tables in Schedule definitions which will be used by
underlying jobs.
Environment: Oracle 11g, PL/SQL Developer, SQL Plus, SQL Loader.
Client: Tradeweb Autex (Tradeweb Equities, USA)
Duration: Jan 2009 - May 2010
Description: Tradeweb AutEx is an innovative platform which - helps the Buy-
Side find liquidity and evaluate broker/venue performance and helps the
Sell-Side market their trading services and evaluate their performance
versus the competition. It tailors the features and data it presents based
on the specific permissions of the user. Tradeweb Autex generates numerous
reports for Market, Sector, Symbol level and Broker level data for both Buy
and Sell sides.
Roles & Responsibilities:
. Preparation of ERD using Microsoft Visio.
. Designed and Created tables, constraints, and GLOBAL and FUNCTIONAL
indexes.
. Created multiple table spaces based on the size and the usage of
tables/indexes to store more than 500 million records.
. Used LIST PARTITION to Partition/sub-partition tables as per the
business needs.
. Writing PL/SQL packages, stored procedure, and functions using user
defined TYPES/OBJECTS/TABLES/VARRAY.
. Used BULK COLLECT, RANK and PARTITION BY features in queries to
construct an OBJECT.
. Performance tuning of queries using HINTS, EXPLAIN PLAN and TKPROF
to show the reports within seconds.
. Created Materialized views with a query which uses the tables/views
of other database/schemas using DB Links.
. Created jobs using DBMS_JOB and DBMS_MVIEWS built-in packages to
refresh the materialized views.
. Creation of reusable deployment scripts for all the environments.
. Preparation of data dictionary document
. Shell scripting in Sun Solaris for Application packaging,
Scheduling, Job automation and generation of reports.
. Designed and created parameterized reports using charts, stored
procedures and formulas in crystal report 2008.
. ETL: Data from multiple sources are extracted and loaded on a daily
basis, into transaction tables which are used by the application.
Data validation is done based on pre-defined conditions using
triggers before loading into work tables.
. Monitoring Schedulers: Monitor the user defined scheduler jobs and
log the success or failure of the job. The log message will
determine the criticality of the job. Used data dictionary views to
check the status of job.
Environment: Oracle 11g, TOAD, SQL Plus, SQL Loader, Microsoft Visio and
Sun Solaris.
Client: Tradeweb Equities Master (Tradeweb Equities,USA)
Duration: Apr 2008 - Dec'2009
Description: Tradeweb equities master is a web-based application which is
used to consolidate customer and product information and billing rules from
disparate systems into a single location and create a single UI to update
and view client/product information and billing rules. It provides single
system of record for customer data across all Equities products and managed
data change control and single reality for all Equities customers and
supports Order to Cash move to Tradeweb. It maintains the product usage
data which are sent by multiple data sources. This is one of the critical
applications as the customer data created in this application is propagated
to other equity products.
Roles & Responsibilities:
. Preparation of ERD using Microsoft Visio.
. Created multiple table spaces based on the size and the usage of
tables/indexes.
. Design/create tables, constraints, indexes, etc. as per the
requirement.
. Writing PL/SQL packages, stored procedure, and functions etc. using
user defined TYPES/OBJECTS/TABLES/VARRAY.
. Used DBMS_OBFUSCATION_TOOLKIT built-in package for encryption and
decryption of password.
. Performance tuning of queries using HINTS, EXPLAIN PLAN and TKPROF.
. Preparation of ETL scripts which includes SQL* Loader files, SQL,
PL/SQL and shell scripts to migrate the initial data from different
sources.
. Prepared scripts for data cleansing and de-normalization of tables as
changes are made during the different phases of the project.
. Designed and implemented compliance feature for the application which
shows the life-cycle of the data.
. Prepared functional, technical and application deployment documents.
. Creating partitioned tables as per the business needs.
. Writing UNIX shell scripts and creating jobs to generate reports and
process the usage data sent from multiple data sources.
. Created stored procedures in Sybase to insert/update/delete/extract
the data which is related to this application.
. Used temporary tables, index hints in queries to improve the
performance where necessary in stored procedures.
Environment: Oracle 11g, TOAD, SQL Plus, SQL Loader, Sybase 12, Microsoft
Visio and Sun Solaris.
Client: AES SONEL (The AES Corporation, USA)
Duration: Aug 2004 - Feb 2008
Description: The AES Corporation is a leading independent power company.
AES owns and operates over $33 billion of assets in 28 countries on 5
continents, including 158 power generation facilities that provide over 55
giga watts of generating capacity. The Company also runs 20 electric
distribution companies that deliver electricity to approximately 16 million
end-use customers. The AES billing application serves millions of users'
billing activities.
Roles & Responsibilities:
. Requirement Analysis and interaction with the Client.
. Planning, Creation, Performance Tuning and reorganization of
databases, monitoring table spaces, indexes, and performance tuning.
. Creating partitioned tables as per the business needs.
. Activities included server installation and configuration, tuning of
database parameters, allocation and maintenance of rollback segments,
table spaces, data files, redo log files, mirroring of redo log files
across multiple disks.
. Creation of database, table spaces, schemas, database tuning and SQL
loading.
. Involved in creating and maintaining users, roles and granting and
revoking privileges.
Designed database for Client / Server based applications.
. Prepared scripts for data cleansing and de-normalization of tables
when the changes are made for different phases of the project.
. Used CDBFLite command line tool to convert the DBF files to CSV files.
. Preparation of ETL scripts to migrate the legacy data in MS-Access to
the new application using CDBFLite (Thirdparty tool), SQL*Loader, SQL,
PL/SQL and shell scripts.
. Performance tuning of queries using HINTS, EXPLAIN PLAN and TKPROF to
give the results to users within seconds.
. Preparation of data dictionary documents about the objects
created/used.
. Planned and implemented backup strategies for the database.
. Implementation of Oracle Real Application Cluster using Oracle 10g R2
on Red Hat Linux 4 Operating system.
. Implementation of Advanced Multi-master bi-directional replication
between 2 sites.
. Preparing functional, technical and application deployment documents.
Environment: Oracle 10g, TOAD, SQL Plus, SQL Loader, CDBFLite, Plantinum
Erwin and Red Hat Linux 4.
Client: Autex FI (Thomson Financial, USA)
Duration: Apr 2004 - July 2004
Description: AutEx is the financial network providing online transaction
services globally to the registered customers for US Bonds and Securities.
It gets online data from various third party sites such as - IDC and LJS -
and provides that to their customers at their request. This vertical
application is aimed at regular and non-disruptive transfer of the data
from third party organizations to AutEx. The billing information is
maintained and calculated based on users' access and various kinds' reports
are generated based on pre-defined criteria and business rules.
Roles & Responsibilities:
. Requirement Analysis and interaction with the Client.
. Involved in the DB design.
. Created table spaces, tables, temporary tables and indexes.
. Performance tuning of queries using HINTS, EXPLAIN PLAN.
. Preparation of ETL scripts using SQL*Loader, SQL, Packages, Procedures
and functions.
. Environment Setup, writing shell scripts to download the files from
source and process and load into Autex system.
. Preparing functional, technical and application deployment documents.
Environment: Oracle 8i, SQL Plus, SQL *Loader, Platinum Erwin and Sun
Solaris.
Client: OMI International - Retalix (OMI International, USA)
Duration: Nov'2003 - Mar'2004
Description: OMI International is a leading provider of supply chain
execution and electronic commerce solutions designed for complex, multi-
warehouse, multi-facility installations.
OMI's integrated applications provide end-to-end supply chain management
enabling enterprise-wide procurement, e-procurement, warehouse management
systems, and specialized order management with real-time product visibility
throughout the organization.
The Registration, Order Management (and all its sub modules) and Backend
adaptor feed code which was developed using 3-tier architecture with J2EE
technology, Tibco, Webmethods and backend database server as ORACLE were
ported to DB2 version to use DB2 as the backend database server as per the
client's requirement. During porting the Business tools like TIBCO and
Webmethods were eliminated and the same functionality was implemented using
Java Messaging System (JMS). As the original application followed 3-tier
architecture, only the Middle tier layer with minimal changes and backend
layer (Database) were ported to DB2.
Roles & Responsibilities:
. Design of data model.
. Preparation of data dictionary documents about the objects
created/used.
. Migration of the existing Tables, Indexes, PL/SQL packages, procedure
and functions from Oracle to DB2 using DB2 migration tool and manual
migration.
. Preparation of ETL scripts to migrate the data from Oracle using SQL
and PL/SQL to DB2 using LOAD to load the data into DB2 tables.
. Used to EXPLAIN PLAN to check and improve the performance of the
queries.
. Preparing functional, technical, migration and deployment documents.
. Created scripts to setup and install the database user for the UI
application.
. Created test scripts to test the stored procedure and functions.
Environment: IBM DB2 8V, Oracle 8, IBM Migration Toolkit, Plantinum Erwin
and Sun Solaris.
Client: Thomson Connect Instant Messaging System (Thomson Financial, USA)
Duration: Jan 2003 - Oct 2003
Description: Provides subscribers with presence, instant messaging service,
built on an integration of components supplied by Dynamicsoft, Catalyst and
Thomson Financial Network.
Thomson Financials is a financial network group providing online
transaction services globally to the registered customers for US Bonds and
Securities. ThomsonConnect is an enterprise instant
messaging/communication system that supports hundreds of thousands of in
buddy lists. In addition to all the standard functionality of an instant
messaging system such as - instant messaging, contacts - online and
offline, various presence based indicators and numerous customizable
preferences, it also supports complete logging, record keeping and
retrieval for compliance purposes.
Roles & Responsibilities:
. Requirement Analysis and interaction with the Client.
. Database design, Data modeling using Erwin tool.
. Created table spaces, tables, temporary tables and indexes.
. Worked with RAW data types to store and retrieve the conversations.
. Created PL/SQL Package, procedure and functions.
. Performance tuning of queries using HINTS, EXPLAIN PLAN.
. Fast retrieval of status of subscribers and the history of their
conversations from the archives.
. Environment Setup, Writing shell scripts to deploy SQL scripts to the
database schema.
. Prepared functional, technical and deployment documents.
Environment: Oracle 8i, SQL Plus, SQL*Loader, Plantinum Erwin and Sun
Solaris.
Client: Novopoint B2B Portal (Novopoint, USA)
Duration: July'2000 - Dec'2002
Description: Novopoint is a dynamic B2B e-market place that brings together
buyers and sellers of food and beverage ingredients and provides them with
mission critical services and information. The Novopoint application is a
suite of applications that work independently or in concert. The product is
designed to enable buyers and sellers to take a phased approach to their
business process improvement efforts. The first step is to address the
areas of greatest inefficiency in their supply chains, with the second step
of adding other integrated functional modules when the time is right.
Roles & Responsibilities:
. Requirement Analysis and interaction with the Client.
. Database design, Data modeling using Erwin tool.
. Created table spaces, tables, views and indexes.
. Worked with RAW and CLOB data types to stored and retrieve the
documents and invoices.
. Performance tuning of queries using HINTS, EXPLAIN PLAN.
. Creating PL/SQL Package, procedures and functions.
. Preparing functional, technical and deployment documents.
. Environment Setup, Writing shell scripts to deploy Sql scripts to the
database schema.
. Created test scripts to test the stored procedure and functions.
Environment: Oracle 8i, SQL Plus, SQL *Loader, Platinum Erwin and Sun
Solaris.
Client: Microportal (Microportal, USA)
Duration: Dec 99 - June 2000
Description: MicroPortal provided branded, hosted Internet Services to
their customers. These services may include - Internet access, email, web
presence, web space, news groups, billing, usage stats, user profiles,
tracking, monitoring etc.
Roles & Responsibilities:
. Database design, Data modeling using Erwin tool.
. Created tablespaces, tables, views and indexes.
. Performance tuning of queries
. Preparing functional, technical and deployment documents.
. Creating PL/SQL Package, procedures and functions.
. Environment Setup, Writing shell scripts to deploy Sql scripts to the
database schema.
Environment: Oracle 8i, SQL Plus, PL/SQL, Plantinum Erwin and Sun Solaris.
Client: Status Administrator (Foresee Information System, INDIA)
Duration: July'99 - Nov'99
Description: Status Administrator is a desktop application which is used by
employees in an organization to enter their day to day tasks details. Using
this, the project managers can keep track of tasks assigned to the team and
check for completion of the project in-time. The generation of reports
based on project/tasks helps the manager to analyze the time taken for the
completion of the projects.
Roles & Responsibilities:
. Database design and Data modeling
. Performance tuning of queries.
. Created procedure and functions.
. Created an installer package of the software using Microsoft Packaging
tools.
. Designed and created different type of reports using crystal reports.
. Preparing functional, technical and deployment documents.
. Environment Setup, Writing batch scripts to deploy SQL scripts to the
database.
. Used ISQL, system stored procedures to create database, users and for
granting roles.
Environment: SQL Server 7.0, TSQL, ISQL, Crystal Report 8, Visio and
Windows NT.
Client: Energy Accounting Software (PRDC, INDIA)
Duration: Apr'99 to June'99
Description: This application stores the Energy Meter readings, which are
generated in ASCII text format from the source systems. This data file is
converted into corresponding fields and records and stored into the
database. Required calculations are done based on the meter readings and
these reading will helpful in the maintenance of accounts. Reports could be
generated by meter number, account number, time period on a daily, weekly,
monthly, quarterly and yearly basis.
. Requirements analysis and interaction with the Client.
. Database design and Data modeling
. Performance tuning of queries.
. Created procedure and functions.
. Used BCP command line tools to load the bulk meter reading into the
application.
. Used stored procedures to validate the data.
. Designed and created various reports using crystal reports.
. Created an installer package of the software using Microsoft Packaging
tools.
. Prepared functional, technical and deployment documents.
. Environment Setup, Writing batch scripts to deploy SQL scripts to the
database.
. Used ISQL, system stored procedures to create database, users and for
granting roles.
Environment: SQL Server 7.0, TSQL, ISQL, Crystal Report 8, Visio and
Windows NT.
Client: Royalex Automation System (Royalex Garments, INDIA)
Duration: July'98 to Feb'99
Description: Royalex Automation System is client server network
application, which allows Enterprise to keep track of all the information
of job workers, distributors and stock of the raw materials and finished
goods.
. Requirement Analysis and interaction with the Client.
. Performance tuning of queries.
. Created procedure and functions.
. Used BCP command line tool to import the data from distributors and
load into the application using procedures.
. Designed and created different type of reports using crystal reports.
. Created an installer package of the software using Microsoft Packaging
tools.
. Preparing functional, technical and deployment documents.
. Environment Setup, Writing batch scripts to deploy Sql scripts to the
database.
. Used ISQL, system stored procedures to create database, users and for
granting roles.
Environment: SQL Server 7.0, TSQL, ISQL, Crystal Report 8, Windows NT.
Education
1995 Diploma in Computer Science & Engineering, India.
Contact this candidate