SUMMARY:

• Over 10+ years of experience in Software Development Life Cycle that includes Analysis, Design, Development, Testing, Implementation, Migration, Documentation and System Support using Quality Standards.
• Having 10+ years of experience as a Sybase developer including hands - on experience in coding, testing and deployment. Hands-on experience as UNIX & Shell/Perl Scripts developer including XML, XSL and Autosys.
• Working knowledge of Big Data.
• Hadoop - including HDFS file system, Map-Reduce, YARN.
• Apache Spark including Spark SQL. Spark framework, Machine learning Spark lib, RDD
• Apache Kafka & Kafka clusters, PIG, HIVE, Oozie, HBase
• Oozie, capturing data with Apache Flumes & integration with Kafka, Apache Spark streaming
• Expertise in Advanced Sybase performance tuning and query optimization.
• Sound foundation in Relational Database design methodologies.
• Involved in the Development of Unix-based RDBMS Perl/Shell scripts for production server operations support like data download engine.
• Used Stored Procedures, triggers, views database design, query optimization. Wrote complex queries using Transact-SQL.
• Expertise in Creation of all database objects, Index management, Transaction Management, System Tables, TSQL.
• Involved in the Development of Unix-based RDBMS Perl/Shell scripts for scheduled cron jobs, Data Migration and other batch processes.
• Extensive use of Embedded SQL techniques through the use of Cursor and non-Cursor database calls.
• Coded XML, XSL and scheduled the jobs on Autosys, created JIL scripts. Client receives the output in email.
• Worked on maintenance and development of Crystal reports.
• Worked with Citrix Administrator for staging application on Citrix server. Map N/W drive through application.

TECHNICAL SKILLS:

O/S: Windows 3.x/NT/9x/XP/2000/Windows2000 Server, UNIX, DOS, VAX/VMS

Languages: PowerBuilder 5.0/6.5/8.0/9.0/ PFC, .NET (VB.Net & ASP.Net), JAVA

Databases: Sybase11, ASE12.5.3, Transact-SQL, ISQL, Sybase SQL Anywhere, Sybase IQ12.7, 15.1, Oracle, P/L SQL, SQLPlus, Microsoft SQL Server 2000

Others: Microsoft FrontPage, HTML, and JavaScript, VB Script, DHTML, XML, XSL, JDBC, Servlets, Enterprise Java Beans (EJB), JMS, Swing, RMI, Networking, IIS Perl, UNIX, Autosys, Filenet, Crystal Reports, ETL, Sybase IQ, Power Designer

EXPERIENCE:

Confidential, Jersey City, New Jersey

Responsibilities:

• Analysis, development & unit testing of CNS web based UI. This is a reconciliation interface used by data analysis team to suggest the reconciliation required by business.
• Analyzed existing code and modified for enhancements and bug fixing as required.
• Worked independently and as team member, participate actively in various phases of project till implementation
• Responsible for Analysis, Designing and Coding for Confidential Enhancements.
• Worked on regular sprints for bug fixes.
• Created Optimized stored procedures including Nesting and parameters to build the business logic and populate feeds for downstream system and operations group.
• Used cursors for row level data handling.
• Performed technical documentation including process flows.

Environment: Sybase ASE v15.7, Transact-SQL, Sybase IQ 16.0 UNIX Shell Scripts, Perl, Tidal scheduler, Aqua Data Studio, SVN source control

Confidential, Weehawken, New Jersey

Responsibilities:

• Analyzed existing code and modified for enhancements and bug fixing as required.
• Working independently and as team member, participate actively in various phases of project till implementation
• Responsible for Analysis, Designing and Coding for Confidential Enhancements.
• Created Optimized stored procedures including Nesting and parameters to build the business logic and populate feeds for downstream system and operations group.
• Used cursors for row level data handling.
• Performed technical documentation including process flows.

Environment: Sybase ASE v15.0, Transact-SQL, Oracle 11g, P/L SQL UNIX Korn Shell Scripts, Perl, Autosys, Aqua Data Studio

Confidential, Jersey City, NJ

Responsibilities:

• Analysis of the database objects for the required changes for migration of the code.
• Analyzed batch jobs including Perl/shell jobs to find out any migration changes required.
• Performed the code changes and implemented to compile the changed code.
• Interacted with the application team and DBA team for preparing the development environment setup for both the versions. This involved co-ordination in getting the dump/load and ensuring the environment.
• Prepared the unit test cases and performed unit testing. Compared the results across both the versions to ensure consistency and check for no changes in functionality and results.
• Compared and analyzed query plans to ensure better performance in migrated environment. This included recommendations to prevent table scans, reformatting, deferred updates, etc.
• Prepared various tools that include regression testing using shell script.
• Participated in code promotion across the environments that include development to UAT to Production.

Environment: Sybase ASE v15.0, Transact-SQL, UNIX Korn Shell Scripts, Perl, Autosys, AquadataStudio, CVS version controller. The application has Java/C# Front End and Sybase Back End.

Confidential, New York City

Responsibilities:

• Analysis, designing and coding for Regulus enhancements.
• Create Optimized stored procedures including Nesting and parameterized to build the business logic and populate data extract feeds for operations group.
• Perform GUI enhancements with the help of generation of metadata.
• Develop the stored procedures to upload the data with the CAT (Central Adjustment Tool). Some of the functions are Leverage Ratio and Settlement Currency.
• Processed the uploaded data to the data warehouse (data enrichment) and data mart (caching) databases.
• Built the display screen interface with the metadata and plugging the stored procedures.
• Write technical documents and test documents including process flows.
• Analysis of existing code and modified for changes and bug fixing as required.
• Work independently and as team member, participate actively in various phases of project till implementation. Co-ordinate with the business analyst and business end users for testing.

Environment: Sybase ASE v15.0, Transact-SQL, UNIX Korn Shell Scripts, Perl, Autosys, Embarcadero DB Artisan, Perforce version controller. Regulus consists of a C# Front End, Sybase Backend, a Perl Job Scheduler called Arbiter, a File distributor called Cygnus with an ETL Tool called AbInitio.

Confidential, Jersey City, New Jersey

Responsibilities:

• Analyzed existing code and modified for enhancements and bug fixing as required.
• Worked independently and as team member, participated actively in various phases of project till implementation
• Responsible for Analysis, Designing and Coding for MTS.
• Generated feed files for downstream systems, output for the operations group, scheduled on the Autosys jobs to send email attachments.
• Created Optimized stored procedures including Nesting and parameters to build the business logic and populate feeds for downstream system and operations group.
• Used cursors for row level data handling.
• Shell scripts scheduled via Autosys.
• Performed technical documentation including process flows.

Environment: Sybase ASE v15.0, Transact-SQL, UNIX Korn Shell Scripts, Perl, Autosys, Embarcadero DB Artisan, WebSphere, Tomcat, MQ, SVN

Confidential, New York City

Responsibilities:

• Responsible for Analysis, Designing and Coding for Matisse Repositories.
• Worked on ETL jobs to populate data to staging tables from the data load that comes from Paris to NY daily. The data loads are uploaded to the shared location. ETL jobs are scheduled on Control-M.
• Used Parameter files and list files for ETL jobs to access the data source location and other parameters.
• Created Optimized stored procedures including Nesting and parameters to build the business logic and populate data from staging tables to repository tables with enriched data.
• Used Dynamic SQL for stored procedures that had table names decided while execution.
• Used cursors for row level data handling for account balancing.
• Shell scripts scheduled via Autosys. Now changed to Control-M.
• Participated in Database architecture to build Repository Data Model.
• Used Power Designer for creating Data Model.
• Performed technical documentation.
• Analyzed existing code and modified for enhancements and bug fixing as required.
• Worked independently and as team member, participated actively in various phases of project till implementation.

Confidential

Responsibilities:

• Responsible for analysis, coding and testing Matisse GL project.
• Analysis of the existing systems: Summit, Sophis, Munigic, Core, ACBS etc. to derive ‘Combined Systems Field Alignment’. This was done by analysis of Perl scripts, shell scripts, stored procedures, triggers, etc. of these systems.
• Created a view as an immediate interface solution for business. This merged the data across the systems to have a comparative scenario.
• Source: Data existed in Sybase, Sybase IQ database, txt files. Created ETL Job to generate similar to DataMart / Data Warehouse. Co-ordinated with DBA to create Cross server joins for some systems to avoid redundancy.

Environment: Sybase ASE v12.5.0.1/v15.0, Transact-SQL, UNIX Korn Shell Scripts, Perl, Autosys, Control-M, Embarcadero DB Artisan, Informatica ETL, Power Designer

Confidential, Weehawken, New Jersey

Responsibilities:

• Responsible for Analysis, Designing and Coding for Auto- Settlement.
• Extensive use of Store Procedures including Nested Stored Procedures with and without arguments.
• Created Oracle Stored Procedures to extract data from EOWIN database for reconciliation with Sybase Checks & Journal database.
• Coded Perl job including Perl modules for reconciliation process for various products ESOP, SAR, RSA & ESPP.
• Implemented Optimized queries using appropriate table joins and indexes for queries.
• Used cursors for row level data handling.
• Coding of Triggers for implementing business rules on database.
• Used BCP in and out for data in database.
• Read existing code and modified for enhancements and bug fixing as required.
• Worked independently and as team member, participated actively in various phases of project till implementation.

Environment: Sybase ASE v12.5.0.1/v15.0, Transact-SQL, Oracle 9i UNIX Korn Shell Scripts, Perl, Autosys, SQL-DBX

Confidential, Scranton, Pennsylvania

Responsibilities:

• Responsible for Analysis, Designing and Coding for CFE DB Support.
• Extensive use of Store Procedures including Nested Stored Procedures with and without arguments.
• Implemented Optimized queries using appropriate table joins and indexes for queries.
• Used cursors for row level data handling. Coding of Triggers for implementing business rules on database.
• ETL tasks, shell scripts scheduled via Autosys.
• Used BCP in and out for data in database.
• Analysis, coding, unit testing, implementing and verifying production fixes.
• Reading existing code and modifying for enhancements, bug fixing as required.
• Working independently and as team member, participated actively in various phases of project till implementation.

Environment: Sybase ASE v12.5.0.1/v15.0, Transact-SQL, MS SQL Server 2008, UNIX Korn Shell Scripts, ETL, Autosys, Cyber fusion, BMC SQL-Programmer Expert

Confidential, Piscataway, New Jersey

Responsibilities:

• Responsible for Analysis, Designing and Coding for Confidential Applications.
• Store Procedures including Nested Stored Procedures with and without arguments were used to interface with database. Optimized queries and used cursors for processing row level data.
• Coding of Triggers for table updates.
• Converted Confidential applications from MS Access to Sybase, Oracle and PB Client Server applications.
• Performed unit and system testing of Confidential Applications.
• Worked with Citrix Admin for staging the applications on Citrix server. Created bat files to map and delete network drives. Maintenance/Upgrades of MS Access/VB code applications: Worked on maintenance of MS Access and Excel VBA applications with linked tables.
• Coordinated with the off-shore team for DBA tasks, staging of the applications on the Citrix server and various other tasks.

Environment: Powerbuilder11.0 & Sybase ASE12.5.3, Transact-SQL, UNIX, Oracle 10g PL/SQL, MS Access2000, MS Access2007, Excel VBA

Confidential, Mount Laurel, New Jersey

Responsibilities:

• Responsible for Analysis, Designing and Coding for Confidential .
• Extensive use of Store Procedures including Nested Stored Procedures with and without arguments.
• Optimized queries included appropriate table joins and indexes for queries.
• Used cursors for row level data handling.
• Modification of the PB GUI code for the changes.
• Performed unit and system testing of Confidential .
• Worked on maintenance and development of Crystal reports.

Environment: Powerbuilder9.0 & Sybase ASE12.5.3, Transact-SQL, UNIX, SQL Advantage, MS SQL Server 2000

Confidential, Boston, Massachusetts

Responsibilities:

• Responsible for Analysis, Designing and Coding for Confidential .
• Used Store Procedures including Nested Stored Procedures with and without arguments.
• Implemented Optimized queries using appropriate table joins and indexes for queries.
• Used cursors for row level data handling. Coding of Triggers for table updates.
• Used XML, XSL for developing jobs to be scheduled on Autosys. The client receives this output as attachment in the Lotus Notes emails.
• Created JIL scripts for porting Autosys jobs across the environments.
• Modification of the PB GUI code for the changes.
• Performed unit and system testing of Confidential . Participated in Production release of the project.

Environment: Powerbuilder9.0 & Sybase ASE12.5.3, Transact-SQL, UNIX, CAST, SQL Advantage, Autosys, XML, XSL, Python

Confidential, Minneapolis, Minnesota

Responsibilities:

• Responsible for Analysis, Designing and Coding for LNR.
• Coded Store Procedures including Nested Stored Procedures with and without arguments.
• Implemented Optimized queries using appropriate table joins and indexes for queries.
• Used cursors for row level data handling. Coded Triggers for table updates.
• Use of XML Data windows for developing testing tool for data validation of XML data with Arrow database data.
• Varbinary Surrogate Key population for the loan id column tables.
• Coding and modification of Shell scripts and Perl scripts.
• Modification of the PB GUI code for the changes.
• Performed unit and system testing. Participated in Production release of the project.

Environment: Powerbuilder9.0 & Sybase ASE12.5.3, Transact-SQL, UNIX, Enterprise Java Beans (EJB), Java Message Service (JMS), Rapid SQL, SQL Advantage