Sql Data
Resume:
Seetharam Mojarla
********@*****.***
Summary:
• 7+ years of experience in Information Technology with expertise in Data
Warehousing,
Database Development, Implementation, Maintenance and Support.
• Extensive experience in developing UNIX Shell Scripts, SQL and PL/SQL
(Coding Procedures, Functions, Database Packages and Triggers).
• Experienced in developing/ tuning complex SQL queries, PL/SQL blocks
stored packages, procedures, functions, Partitions, triggers, and views.
• Excellent knowledge of database architecture, database creation and
configuration, client/server connectivity and space management.
• Hands-on new development as well as support, maintenance or enhancement
of existing applications.
• Involved in exhaustive Performance Tuning, Monitoring and
Optimization of PL/SQL blocks, created table spaces, Partitions and experience with
cold/hot backups in both Development and Production environment, for Oracle.
• Experience in writing and tuning of complex SQL statements, complex joins
and sub- queries.
• Involved in all phases of the SDLC from analysis, design, development,
testing Implementation and Maintenance with timely Delivery against aggressive deadlines.
• Expertise in Database Performance Tuning, Performance Monitoring and
Optimization using tools such as Oracle Hints, SQL Trace, Explain plans and Table
partitioning
• Managing Database Structure, Storage Allocation, Table/Index segments,
Rollback segments, Constraints, Database Access, Roles and Privileges.
• Involved in large volume data migration to Enterprise Data Warehouse using UNIX(IBM
AIX, Solaris, Linux) scripts, SQL*Loader, PL/SQL.
• Use of Oracle’s Analytical Function and SQL query is done to display various reports
• Implemented Packages (Stored Procedures, Functions, Cursors, Triggers), Data
Cleansing, Transformation Scripts and necessary test plans to ensure the successful
execution of the data loading processes for Data Warehouse and Data Marts.
• Tune SQL statements, create and maintain/modify PL/SQL packages, mentor others with
the creation of complex SQL statements, perform data modeling and create/maintain and
modify database triggers and data migration scripts.
• Proficient in ETL Processes using Oracle PL/SQL, UNIX Scripts and SQL*Loader for
data migration to Enterprise Data Warehouse with large data volume.
• Developed UNIX(IBM AIX, Solaris) Shell Scripts to run various utilities & wrote UNIX
Corncobs for the scheduled batch processes and sending E-mails to corresponding recipients.
• Extensive experience carrying analysis, design, normalization and de–normalization,
database modeling using Erwin.
• Involved in Requirement gathering and conceptual design of databases in multiple projects.
• Ability to perform well as a Team member and as an Individual, with dexterity to blend well
in any situation and environment.
• Excellent Analytical and Problem solving skills.
Academics & Professional Certifications
Master of Information Systems
Oracle 9i – Oracle certified Associate (OCA)
Oracle10g –Oracle Certified Professional(OCP)
Technical Skills:
Databases Oracle 7.x/8.x/9x/10g, SQL Server 2000 /7.0/6.5, Teradata, DB2 UDB
7.2,MySql 5.0/4.1, MS-Access. Editors ( SQL Navigator, Toad)
Oracle Tools Oracle Enterprise Manager, Quest TOAD, Statspack, SQL*PLUS,
SQL*Loader, SQL*Net, SQL Navigator Export/Import, RMAN, ERWin,
Veritas Netbackup
ETL Tools
Informatica 6.0/7.1, Data stage 7.5.1/7.1, Oracle Warehouse Builder.
OLAP/ Developer 2000(Forms 5.0,6i Reports 6i), Crystal Reports 10, Crystal
Reporting Enterprise 10.0.
Tools
Operating UNIX, HP, Sun Solaris 2.x/7/8, Windows ME/2000/2003/NT/XP, IBM AIX,
Systems Exceed ( Editor)
Programming C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN,
Skills JAVA, HTML.
Data Modeling ERwin4.0
Professional Experience:
Cleveland Water Division, Cleveland OH
Database & Crystal report Developer
Feb 2008 – Till Date
• Developed complex SQL queries for data retrieval from various database objects including
tables and views.
• Involved in creating Procedures, packages and appropriate REF Cursors to handle BULK
collects and BULK binds.
• Constructed and implemented multiple-table links requiring complex JOIN statements,
including outer-joins and self-joins.
• Generated DDL Queries for creation of new database objects like tables, views, sequences,
functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting
privileges.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for
business logic modification, Granting and Revoking Schema Object Privileges and Roles,
Responding to System Events through Triggers.
• Involved in data loading using PL/SQL and SQL*Loader, External tables and cron jobs
calling UNIX (AIX) scripts to download and manipulate files.
• Involved in developing UNIX Shell Scripts required for maintaining the data Models and
processing job.
• Developed the Procedures to be able to customize the report according to the specifications.
• Regularly analyze and review the Crystal reports developed and make enhancements to
them if recommended by users.
• Developed back end interfaces using PL/SQL packages, stored procedures object types
and triggers.
• Responsible for designing and developing new reports using Crystal Reports XI and
Oracle 10g.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
• Created On-Demand Sub reports and Hierarchical Grouping.
• Tested the reports for quality and end user validation
• Performed tuning and optimization on SQL Queries using analyze, explain plan, TKPROF
utility and optimizer hints.
• Developed automated Korn Shell Scripts to schedule the load of flat files on daily, weekly
and monthly basis.
• Run the SQL queries to fetch test data and database testing to validate the database.
• Participated in daily status meeting to report any bugs, issues and risks.
• Performed Verification and validation.
Environment: Oracle 10g/9i, Crystal Reports XI, Windows 2000/XP, UNIX-HP, SQL Navigator,
Toad 9.2, SQL, PL/SQL, SQL*Loader, Ultra edit, PERL, Informatica 7.1, Clear Case, Harvest,
Cognos 8.1, K-Shell, Toad.
HIGHMARK (Blue Cross Blue Shield) Pittsburgh, PA
Database Developer
May 2008 – Dec 2008
• Tune SQL statements, create and maintain/modify PL/SQL packages, mentor others with
the creation of complex SQL statements, perform data modeling and create/maintain and
modify database triggers and data migration scripts.
• Developed SQL Queries to fetch complex data from different tables in remote databases
using joins, views, Database links and formatted the results into reports.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix
production issues and build new functionality and improve processing time through code
optimizations and indexes
• Involved in discussions with users, managers, team leads, business users to clarify programs
issues and problems.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to
reduce Disk I/O and Sorts.
• Managing tables, views, sequences, synonyms, and enforcing business rules with integrity
constraints, selecting an index strategy to perform the query better and scale application well in large
scale transactions.
• Involved in creating Procedures, packages and appropriate REF Cursors to handle BULK
collects and BULK binds.
• Created changes in the database according new requirements (new tables in the existing
database and fields in the existing tables).
• Involved in table redesigning with implementation of Partition Table and Partition Indexes
to make database faster and easier to maintain.
• Developed back end interfaces using PL/SQL packages, stored procedures Collections,
Object Types and triggers.
• Automation of the procedures using shell scripts batch jobs to copy the data from the
production servers to the test servers on weekly basis.
• Implemented Packages (Stored Procedures, Functions, Cursors, Triggers), Data Cleansing,
Transformation Scripts and necessary test plans to ensure the successful execution of the data
loading processes for Data Warehouse and Data Marts
• Generated server side PL/SQL scripts for data manipulation and validation and created
various Materialized views for remote instances.
• Expertise in UNIX environment and Shell scripting, Perl scrpting. Excellent knowledge in
Batch Jobs using UNIX CRONTAB, Autosys, UNIX Shell Script (csh, bash, ksh) and
API’s Using PERL Scripts.
• Modifying triggers, functions, procedures to accommodate on going changes in business
logics, Scripts to automate manual tasks using oracle built-in packages.
• Extensively used SQL* Loader, Export tables, External Tables and Oracle utilities for data
loading process.
• Create the B.I reports using Cognos Report studio, Query Studio and scheduling reports, E-
mail the reports to corresponding recipients.
• Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and
Varrys.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for
business logic modification, Granting and Revoking Schema Object Privileges and Roles,
Responding to System Events through Triggers.
• Created sub programs with Dynamic SQL at both client and Server side (DBMS_SQL,
Native Dynamic SQL at Server Side and EXECUTE_SQL at Client side).
Environment: Oracle 10g/9i, Windows 2000/XP, UNIX-HP, SQL Navigator, Toad 9.2,Solaris 8,
SQL, PL/SQL, SQL*Loader, Ultra edit, PERL, Informatica 7.1, Clear Case, Harvest, Cognos 8.1,
K-Shell, Toad.
JPMChase Chicago, IL
Database Developer
Jan 2007 – April 2008.
• Hands-on new development as well as support, maintenance or enhancement of existing
applications.
• Creating .sql files that select data from an Oracle 10g database.
• Involved in data loading using PL/SQL and SQL*Loader, External tables and cron jobs
calling UNIX (AIX) scripts to download and manipulate files.
• Constructed and implemented multiple-table links requiring complex JOIN statements,
including outer-joins and self-joins.
• Generated DDL Queries for creation of new database objects like tables, views, sequences,
functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting
privileges.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases
using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based
Optimization.
• Using PL/SQL, Stored procedures and functions to support the database side of the
application.
• Automation of the procedures using IBM AIX Shell Scripts batch jobs to copy the data
from the production servers to the test servers on weekly basis.
• Optimized and enhanced the existing procedures and SQL statements for the better
performance. (Uniformed all the SQL statements used in all the procedures wherever
possible, to take the advantage of the Oracle SHARED POOL concept - SQL statement
sharing and pinning objects).
• Analyzed the existing method for data repository refresh and then developed a new package
with tuned queries to improve the performance and reduce the time taken for the refresh.
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for
business logic modification, Granting and Revoking Schema Object Privileges and Roles,
Responding to System Events through Triggers.
• Provided physical and logical design of star-schemas and slowly changing dimensions,
including demonstrative detail in the construction of table partitioning, materialized views,
query rewrite, and star transformation.
• Use of Oracle’s Analytical Function and SQL query is done to display various reports
• Developed automated Korn Shell Scripts to schedule the load of flat files on daily, weekly
and monthly basis
• Tuning of I/O, which includes Separating of Data files and Redo log files on different locations,
Striping of table data, and separating of tables and indexes on different locations. Reducing Disk I/O
Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE,
ANALYZE, HINTS etc.
• Created sub programs with Dynamic SQL at both client and Server side (DBMS_SQL,
Native Dynamic SQL at Server Side and EXECUTE_SQL at Client side).
• Extensively used SQL* Loader, Export tables and Oracle utilities for data loading process.
• Wrote PLSQL procedures to generate DDL scripts that created database objects
dynamically based on user inputs.
• Creating Shell Scripts (KSH) in UNIX environment that run the .sql files, schedule them in
UNIX CRONTAB, Autosys.
• Developed Source to Target mapping using Informatica.
• Experience in creating Transformations and Mappings using Informatica Designer and
processing tasks using Workflow Manager to move data from multiple sources into targets.
• Designed and developed Informatica Mappings to load data from Source systems
Data Mart.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier
Transformations in the Informatica Designer.
Environment: Oracle 10g/9i, SQL Server 2000, Windows 2000/XP, Toad, UNIX AIX 5.3(K-
Shell), SQL, PL/SQL, SQL*Loader, Informatica 7.1, PERL, Clear Case, VSS (Version Control),
K-Shell, Toad.
World Wildlife Fund, WashingtonDC
Database Developer
Feb 2006– Dec 2006.
Responsibilities:
• Developed complex SQL queries for data retrieval from various database objects including
tables and views.
• Developed Database Triggers to enforce Data integrity and additional Referential
Integrity.
• Responsible for getting Requirements for creating data models for data analysis and
reporting
• Analyzing the data needs for the customized reports. Mapping the data requirements
developing Stored Procedures, Functions,Packages and Triggers.
• Extensively involved in UNIX Shell scripting for writing Wrapper scripts, SQL Execution
scripts in ETL processes.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers,
Indexes and Views in Development and Production environment using PL/SQL and
SQL*Plus.
• Involved in developing UNIX Shell Scripts required for maintaining the data Models and
processing job.
• Developed SQL Queries to fetch complex data from different tables in remote databases using
joins, database links and formatted the results into reports and kept logs.
• Developed complex queries using SQL and PL/SQL (procedures, functions, triggers and
packages) for data extraction, transformation, loading and to create reports.
• Fine-tuned procedures for the maximum efficiency in various schemas across databases using
Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
• Extensively used UTL_FILE to put data in text file in a fixed length format.
• Expertise in UNIX (AIX 5.3) environment and Shell scripting, Perl scripting. Excellent
knowledge in Batch Jobs using UNIX CRONTAB, Autosys, UNIX (AIX)Shell Script (csh,
bash, ksh) and API’s Using PERL Scripts.
• Preparing documentation for requirements, design, install and Unit testing and System
Integration.
• Created Materialized Views and partitioning tables for performance reasons.
• Involved in testing the Data Integrity of the new tables.
• Use of Oracle’s Analytical Function and SQL query is done to display various reports
• Developed SQL commands, Stored Procedures to input data into Crystal Reports to increase
the performance of the reports
• Expertise in UNIX environment and Shell scripting. Excellent knowledge in Batch Jobs
using UNIX CRONTAB, UNIX Shell Script (csh, bash, ksh) and API’s Using PEARL
Scripts.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases
using Oracle Hints and Explain plans.
• Created multiple customized PL/SQL Packages for various Business needs.
• Created various ER diagrams and Dataflow diagrams using Oracle Designer.
Environment: Oracle 8i/9i/10g, My SQL 4.1, Java, SQL Server 2005, Windows NT/2000/XP,
UNIX-HP AIX,5.1, Informatica 7.1, SQL, PL/SQL, SQL*Loader, Informatica 7.1 DB2 UDB 8.1,
Clear Case,, PVCS (Version Control), K-Shell, Toad.
SCEC,Sydney Australia.
Oracle Developer
Jan 2004 - Sep 2005
Responsibilities:
• Tuned frequently used SQL Statements and PL/SQL Blocks using SQL-Lab and increased
performance by utilizing optimization techniques.
• Created various stored PL/SQL blocks including Stored Procedures, Functions, and Packages
to manipulate and transform data according to the requirements.
• Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and Varrys.
• Involved in creating Procedures, packages and appropriate REF Cursors to handle BULK
collects and BULK binds.
• Created Ad-Hoc SQL queries to verify data integrity and data analysis.
• Created Database Triggers to accommodate for data integrity and additional Referential
Integrity.
• Tuning of stored procedures & developed business logic in database layer using PL/SQL.
• Handled system utilization issues, performance statistics, capacity planning, integrity
monitoring, maintenance, reorganization, and recovery of databases.
• Tuning and resizing of redologs and redolog buffer. Creating materialized views and creating
indexes and tables using parallel query mechanism. Reorganizing the databases to reduce
space fragmentation.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback
segments, Constraints, Database Access, Roles and Privileges.
• Extensively designed and performed Backup & Recovery techniques like Hot backup, Cold
backup and Logical backups with and without RMAN.
• Migrating data with utilities including Sqlldr, Logical backup (Export/Import), Transportable
tablespaces and writing adhoc blocks to fulfill the requirements.
• Study database to reveal the inconsistency between spaces allocated to transactive intensive
tablespaces & other to specify the block level definitions [Pct free, Pct used].
• Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and
SQL Trace.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy,
and that modifications have no adverse Impact on integrated system environment.
Environment: Oracle 8i/9i, SQL Server 2000, Informatica (Power Mart, Power Center) 6.0
Windows, UNIX, Oracle Developer Suite,, SQL, PL/SQL, SQL*Loader, K-Shell, Clear case.
Cyber India Technologies(Startec Communications, MD )
Oracle developer/Oracle Developer DBA
May 2002 – Sep 2003
Responsibilities:
• Wrote scripts for indexes and Database Objects as per the Oracle Standards.
• Created SQL, Object Views and PL/SQL database objects.
• Extensively used PL/SQL Stored Procedures, Functions, Form Triggers and Packages.
• Created generic scripts to dynamically compile database objects in their Dependency order.
• Fine-tuned procedures for the maximum efficiency in various schemas across databases using
Oracle Hints, Explain plans and Trace sessions.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to
reduce Disk I/O and Sorts.
• Involved in performance tuning and monitoring.
• Designed and developed backend PL/SQL packages in the database layer, stored procedures,
functions and triggers.
• Established methods to migrate databases, objects and jobs to new servers.
• Tuning of stored procedures & developed business logic in database layer using PL/SQL.
Environment: Oracle 8i, UNIX, SQL, PL/SQL, SQL*Loader and Toad, Windows2000/XP, SQL
Server 2000.
Cyber India Technologies, India
Database Developer
June 2000 – Apr 2002
Responsibilities:
•
• Created various database objects in SQL- Server and Oracle.
• Extensively used of PL/SQL Stored Procedures, Functions, Form Triggers and Packages
• Involved in creating stored Procedures for Crystal reports for the BI team.
• Created and tested PL/SQL blocks and UNIX Shell Scripts.
• Monitored, tuned and maintained the development database.
• Tuned SQL Queries and Stored PL/SQL blocks to optimize the database performance
by reducing Full table scans and minimizing I/O entry/exit using Explain Plans and Oracle
Hints.
• I was in a UNIX admin/WinNT group that performed installation, administration tasks like
adding new users, configuring and administrating security, creating and scheduling backups
and network integration.
• Created the indexes on columns to optimize the response time of queries and stored
procedures.
Environment: Oracle 8i, UNIX, SQL, PL/SQL, Oracle Developer Suite, SQL*Loader and Toad,
Windows, SQL Server 2000.
Contact this candidate