Data Sql
Resume:
Sandeep Pola
*******@************.***
Summary:
. Over six plus years of software development experience in analysis,
design, development and maintenance with excellent analytical and
programming skills.
. Experienced in design and implementation of Structured and Object
Oriented methodologies and Relational Database.
. Worked extensively in financial industry with Banking and
Transaction Management related projects.
. Very strong in SYBASE, PERL, T-SQL, K SHELL and UNIX.
. Experienced UNIX developer especially on Solaris.
. Experienced in Autosys, Job Scheduling tool.
. Extensive experience in using T-SQL to write Stored Procedures and
Triggers.
. Hands on experience in SQL Performance Tuning Operations.
. Have good knowledge to plan and execute all phases of software life
cycle starting from requirement study, analysis, design,
development, testing, implementation and maintenance.
. Experience in performance tuning, testing, and deployments.
. Excellent written and verbal communication skills and demonstrated
ability to mentor others.
. Understanding the skills necessary to work on deadline-oriented
projects with strong teamwork and proven problem solving ability.
Technical Skills:
Languages Perl Awk Sed, C, T-SQL, Unix Shell, Java,
CGI
Web Design Tools JavaScript, XML/AJAX, ASP, VBScript, HTML.
Database and Sybase 11.x, 12.x, MS SQL Server 7.0/2000,
tools MS Access, Oracle 9i/10g
Tools& Technology MS Office2003, Visio, MS Visual Source
Safe, PVCS, CVS, Crontab, DBI/DBD, Apache
Web Server, Aqua data, Telnet, Ultra
Edit, Core FTP, FileZilla, BCP, DBartisan
and Sql Advantage
Operating Systems UNIX (HP UNIX, AIX UNIX, Solaris 2.x),
Linux (Red Hat Linux, Fedora Linux), Mac
OS X, Windows XP/NT/2000/2003
Web Servers IIS, Apache
Professional Experience
HSBC, NJ Jul 07-
Present
Programmer Analyst
Project: DAPS (Developer Access to Production System)
Description: DAPS is a web-based tool capturing and reporting all
privileged accesses to production systems by developers and other users.
DAPS uses the firm-wide PAC (Production Access Control) policy for
reconciliation and to provide an audit trail for all privileged (SCSU/SU)
accesses to root & privileged accounts. TIScan (Technology Infrastructure
tool) is used to scan production/COB and UAT servers for all privileged
accesses on a daily basis. A separate business process known as electronic-
workflow (eWorkflow/EW) generates notifications to the respective
individuals and their managers to reconcile the activity. Access logs are
parsed to generate e-Workflow events for each access and an email
notification is sent to user that accessed the machine. DAPS generates
various online reports on a daily, weekly and monthly basis for Senior
Management to review and assess all developer accesses. It also provides
various metrics for different organizations on a regular basis.
The front-end is built using Perl, CGI and html and supported by various
batch jobs developed in Perl & KSH using Sybase database.
Contribution:
. Support and maintain all application processes using Autosys.
. Create Perl/KSH batch programs to handle TI-scan data for review and
signoff.
. Design and develop Sybase tables and stored procedures.
. Used SybPerl / CT-Library to connect to Sybase from Perl scripts
. Create and support scheduled jobs using cron and Autosys
. Data load from flat files into Sybase tables using BCP in Perl and KSH
. Handle feeds from various applications for processing and reporting
. Extensive use of T-SQL, Perl and UNIX shell scripts
. Co-ordinated production and development Unix server migration
. Co-ordinated in Sybase upgrades
. Development of Test cases, Testing, implementation & performance
tuning
. Handle the complete spectrum of application development and support
processes
. Provide suggestions and resolve issues involving users from different
regions
. Used PERL scripts for creating ad-hoc reports.
. Worked in TSQL batches for data handling in the backend.
. FTP data to Mainframe server and other UNIX systems.
. Designed and Generated Excel and CSV reports using Perl and KSH.
. Enhanced and fixed existing Perl and Korn Shell Scripts
. Extracted data from FLAT files to load Sybase table using PERL.
. Designed and developed many new PERL modules and packages.
. Designed and developed many Sybase tables, stored procedures,
triggers.
. Wrote SQL scripts for enhancements and maintenance for various
database modules.
. Design and development of many SQL batches using KSH / PERL with ISQL
& DBI/DBD connectivity with Sybase
. Created Indexes for Sybase performance tuning.
. Created test cases and worked in creating test database.
. Took part in Unit / system testing and documentation.
. Regular checking, maintenance of overnight processes, feeds between up-
stream and downstream systems.
. Participated in user meetings and application review
Tools & Technology: Perl, CGI, KSH, SybPerl, CT-Library, HTML, Sybase 12.x,
Solaris 2.x,
CVS, SCCS, Autosys
Lincoln Financial Group, PA Jan 06 - June 07
Programmer Analyst
Project: Portfolio Management Guide (MG)
Description: Application managers and their teams use MG to guide them with
various changes and project life-cycle notifications for their
applications. There are different alerts that are generated, like SDLC
alerts, application wellness alerts, scheduled jobs and development project
alerts reminding users of important events in their ongoing projects. There
is a built-in data collection utility that's used for creating tasks and to-
do items for these alerts. It can also be used for creating surveys to get
feedback from the organization regarding any process migrations, releases
or the mandatory Required Absence from work.
The system has a front end developed using Perl and JavaScript to view all
the information. It has utilities to do information searching based on
complex search algorithms and text data given for search. The application
was developed using Perl, KSH and Sybase.
Contribution:
. Created and managed primary data base objects such as Tables, Views,
Indexes, Triggers and Stored Procedures.
. Resolve issues for application users with alerts and data collection
utility
. Develop and support enhancements to handle changes to data feeds
. Design and develop database tables and stored procedures
. Provide overnight support for application processes and issues
. Data load using JDBC connection pooling
. Update MG alerts maintained in XML files
. Extensive use of T-SQL, Java/J2EE and UNIX shell scripts
. Development of Test cases, Testing, implementation & performance
tuning
. Created T-SQL queries and fixing issues in existing queries and re-
writing existing SP in Sybase.
. Involved in enhancements and maintenance activities including
performance tuning, rewriting of stored procedures for code
enhancements and modifying target tables.
. Created Perl packages and modules for data handling and manipulation.
. Scheduled and maintained batches using CRON TAB.
. Used DBI/DBD for data base connection and SQL from PERL programs.
. Wrote new modules in PERL and Shell to support the reporting system.
. Designed and developed the Sybase tables for the new reporting system.
. Involved in design and developed the complex reports for customer
transactions and balance data using KSH, PERL and T-SQL scripts.
. Worked in data handling using KSH, BCP and T-SQL
. Worked in query optimization
. Used BCP extensively for data handling between data files and Sybase
tables.
. Created T-SQL scripts to include DML, DDL statements using T- SQL.
. Used Unix Shell Script for invoking Reports.
. Created many T-SQL Queries, stored procedures for database to meet
business requirements.
. Developed and enhanced the application using PERL and Sybase.
. Regular checking, maintenance of overnight processes, feeds between up-
stream and downstream systems.
. Extracted data from FLAT files to load Sybase tables using unix
scripts.
Tools & Technology: T-SQL, KSH, PERL, UNIX, Sybase 12.x, BCP, ISQL, Windows
XP, CVS, Solaris 2.x, Rapid SQL, Apache Web Server, MS Office 2003
Bear Stearns, NJ Jun 04 - Dec
05
Sybase/Unix Developer
Project: Corporate and Reference Data Management
Description: This System maintains reference and corporate data structure
for the entire firm. It has feeds coming from D&B to update the current
data on corporate structure of all the firms it is doing business with,
location data, contact data etc. This data is used as a reference data by
different systems throughout the firm including Accounting, trading,
reporting, client sales, and risk management group. This system has well
defined batch process to feed the system from third party data and
reconcile it from time to time. It has modules and API available for other
system to access the system data.
The system has a front end developed using Perl, CGI, HTML and JavaScript
to view all the information. It has utilities to do information searching
based on complex search algorithms and text data given for search. The
application was developed using Perl, KSH and Sybase.
Contribution:
. Designed the application using PERL, HTML and JavaScript.
. Handled complete coding and implementation of middleware, coding the
business logic and backend data processing and loading the data using
PERL and Unix Shell scripting.
. Design and development of many SQL batches using KSH / PERL with ISQL
& DBI/DBD connectivity with Sybase.
. Day to day basis interactions with Product Controller to resolve the
Problems and Queries.
. Enhancement of various modules Performance, Tuning and Optimizations
of the System.
. Designed and developed many new PERL modules and packages.
. Developed many PERL modules for data mirroring for report front.
. Enhanced Shell scripts for Sybase connection.
. Worked extensively in supporting the application by giving production
support and bug fixing. Optimized queries for better performance in
Sybase.
. Designed and developed many Sybase tables, stored procedures, and
triggers. T-SQL scripts for enhancements and maintenance for various
database modules.
. Daily, weekly reports were generated to users and detailed reports for
the managers using KSH and T-SQL.
. Developed Documents and other mandatory reports.
. Developed Database Logic for integrating the modules using T-SQL on
Sybase.
. Involved in complete life cycle of web development planning, analysis,
design and implementation.
. Client side validations were done using JavaScript for checking time
slots of application.
Tools & Technology: T-SQL, KSH, PERL, DB Artisan, Sybase 12.x, Windows XP,
Core FTP, PVCS, Solaris 2.x, DBI/DBD.
ITC, INDIA July 03- May 04
Programmer/Developer
Project: Order processing & Invoicing System
Description: Order processing and Sales Invoicing System is an online
integrated system covering various areas such as order entry, order
management, invoice generation, invoice payment follow-up and etc., the
objective of the system is to ensure all the orders received are billed and
products are delivered on time based on the payment terms. Application was
created using PERL, JAVA, UNIX and Sybase
Contribution:
. Creating Sybase objects including tables, Stored Procedures and
Triggers.
. Creating backend modules for order processing using PERL and Korn
Shell Scripts.
. Worked on Sybase for bug fixing and enhancing existing Stored
Procedures.
. Created many Java, JSP based front screens.
. Trouble shooting the application to improve the invoicing module.
. Creating KSH scripts for add hoc queries on the database.
. Developing PERL scripts for creating text file reports.
. Creating email modules for periodical email of invoicing amount/order
processed to upper management.
. Designing normalized Sybase tables
. Creating indexes to increase performance
. Design and development of PERL modules for database interaction
. Debugging and enhancing existing PERL modules
. Creating PERL packages for data manipulation
. User meetings for requirements analysis and project reporting
. Requirement Analysis, Design and writing codes in SQL.
. Created Database Objects Tables, Views, Indexes.
. Used RDBMS Parent Child Relation for creating Tables.
. Used Unix Shell Script for invoking Reports.
Tools & Technology: Perl, DBI/DBD, Html, JavaScript, Apache Web Server,
TSQL, Java, JSP, Sybase 11.X, Solaris 2.X, Windows NT.
Contact this candidate