SUMMARY

• Seasoned professional with over twenty five years of hands on IT experience specializing in the full lifecycle of ETL applications, Enterprise Data Warehouses, Database, and Reporting Applications for Federal/State government agencies, Banking/Financial Institutions and Large Corporations.
• Deep experience with Shell scripting, UNIX, ETL, Perl, and Sybase.
• Well versed with the various programming languages, relational data bases and operating systems.
• Provided thought leadership on numerous projects from inception to delivery.

TECHNICAL SKILLS

Languages: SQR 4.0, C, C++, UNIX Shell Programming (Bourne, C, Bash, Perl and K Shell), Autosys 4.0 & 4.5, Java Programming, JavaScript, Micro Focus Cobol, HTML, PASCAL, Informix - 4GL, sed, AWK, Sql*Plus, Sql*Loader, PL/SQL and T-SQL.

Relational Databases: Sybase (ASE) 15.0, 12.5.3, 12.0 and 11.9.2, DB/CT Library, REPLICATION SERVER 11.9.2 - 15.7 , SQL Server, INFORMIX 5.0, ORCLE 8i - 9i, UDB 7.1, 7.2 and 8.1, DVL/GreenPlum

Operating Systems: Sun Solaris (2.6 - Solaris 10 Both 32 and 64 bit), HP UX i (Both 32 and 64 bit), AIX 4.3.2 - AIX5.3.2, UNIX, Linux (RedHat), Windows 2000, Windows XP, Windows NT

Design Tool: Erwin

ETL Tools: Informatica Power Center 8.6 & 7.1, Pentaho(PDI/Kettle) 4.4.3 and 5.0, Pentaho Report Designer

PROFESSIONAL EXPERIENCE

Confidential

Senior Consultant

Responsibilities:

• Responsible of maintaining "Global Client Profibility" application that enables robust analytics of profitability on a product, segment and CID level data from GDR, Client Incentives, Membership Rewards, Fraud and other sources and applying a consistent P&L methodology globally.
• Used Pentaho Data Integration Designer to create ETL transformations
• Developed ETL transformations that sourced from a variety of Heterogeneous sources including Microsoft Access, Text files, CSV files
• Developed ETL process using Pentaho PDI to extract data from legacy system to populate into PostgreSQL DB
• Involved in Performance Tuning Transformation for better response

Environment: Sybase 5.7, Windows XP, UNIX, Solaris, DBArtisan, SQL, KSH, Actuate, Pentaho(PDI/Kettle) 5.0, Essbase and Autosys.

Confidential

Pentaho Developer

Responsibilities:

• Developed several jobs/transformations using Pentaho PDI to automate and to assist production support in permission changes to iFM (Internal Financial Matrix) application. Prior to implementing this process, Corporate Financial Group (CFG FM) Permissions were very inconsistent with the current business practices and the developing regulatory environment. The process needed excessive helpdesk/production support calls and delays in carrying out routine credit work. In order to trigger this PDI job, this process needed an excel file, which contained cleanup related information, in a designated shared location. Once the file is placed a Control-M job will trigger this PDI job to Add, Delete, and Update permission related information in several Sybase and Greenplum databases, for single or bulk permission changes. At the end of a successful completion an email will be sent out to production support with the “User Permission Report”, being generated using Pentaho BI Designer tool, as an attachment. This scripts will serve as a tool for production support to easily update permissions.
• Developed PDI job to delete records that are older than 60 days from several database log tables.
• Pulled data from different types of input and output for various data source including table, text, csv, stored procedure and Excel files.
• Developed several jobs to loops through between two files in order to gather appropriate rating and portfolio related data and email the information to the specific portfolio manager. Before sending out the email the job will check for valid email id, any unknown mail id’s will be replaced by “deftoEmaailAddr” value. It also checks with the opt out list to check if any of the manager has been opted out, if yes will get the alternate mail id.
• Developed a pentaho mapping using Javascript so that this mapping can be used in ten different jobs, the purpose of this effort is to avoid repetitive steps and for easier maintainability. The purpose of this ktr is to assign corrent flag for viewing Private/Public data in several rating applications. Private Data that has been flagged as viewable for a set of MIS employees only. Public Data that is viewable by all Users of Confidential ’s Financial Metrics - Banking (Internal and External).
• Developed several Perl Scripts to feed HAVER Data into Greenplum and Sybase database so that the data can be efficiently accessed using Sovereign ScoreCut Application. If business needs data for a specific country, DLX export the data into an excel spreadsheet and then the data is converted into a tab delaminated output file in order to load into Greenplum using Perl scripts. Eventually this information will be used to print the Statistical Handbook. StatBook is a bi-annual publication that contains country statistics, economic, and financial data, and forecasted data on Confidential 's-rated Sovereigns.
• Developed several ETL Jobs/Subjobs/Transformations Pentaho(PDI/Spoon) to load data from Sovereign Database to SODA (Currently Confidential ’s use SODA to print StatBook. SODA application will retire once Sovereign Scorecard application goes live).
• Developed reports using Pentaho Report Designer.
• Extensive experience in migrating from Sybase 12.x version to Sybase 15.x version.
• Developed and modified several SP and views for credit rating application.

Environment: Sybase 12.5 and 15.7, Windows XP, UNIX, Linux, Rapid SQL, KSH, Perl, Pentaho(PDI/Kettle) 4.4.3 and Pentaho 5.0, Autosys.

Confidential

Workload Automation Engineer

Responsibilities:

• Responsible for SAP Autosys Adapter development and scheduling.
• Responsible for executing a full job development project life cycle, including job scheduling requirements gathering, design, development, implementation, production support, and maintenance of finance operations SAP job schedules.
• Remotely provided 24 hour support and handled daily monitoring and scheduling of AutoSys jobs in UNIX environment during a monthly on-call rotation.
• Provided continuous improvement by developing and implementing configuration management tools by providing extensive documentation including development/staging and production run books.
• Supported file transfer requirements via NDM and responsible for troubleshooting and correcting erroneous or missed file transfers.
• Utilized ixp GUI for modification, deployment, and workflow analysis.
• Configured, developed, tested, implemented, supported, and maintained AutoSys JIL scripts.
• Created, maintained, and monitored CA SAP Adapter SAPJOB and CAPCHAIN SAP job processes.
• Created and maintained UNIX shell scripts.
• Supported workload scheduling operations.

Confidential

Senior C++/Sybase/Script Developer

Responsibilities:

• Responsible for maintaining FAS (Financial Accounting System) - A client application connects to the FAS Server to post financial transactions. The FAS server processes the transactions, performs the necessary updates to the FAS database and returns results to the client application. The server is implemented as a Sybase Open Server application. The Open Server software enables the FAS Server to communicate with Adaptive Server including PowerBuilder, OMNIS 7 and other application that use Sybase Open Client software.
• Developed several Stored Procedure, Views, and Tables to generate reports for end users.

Environment: C++, Sybase 12.5 and 15, Windows XP, UNIX, Linux, Rapid SQL, KSH, Perl

Confidential

Senior Sybase/Script/Perl Developer

Responsibilities:

• Calculated CVA (Credit Valuation Adjustment) numbers and generated reports on daily basis at Counterparty and Trade level to assess default risk associated with those entities which would be used by the bank to determine its lending policies towards counterparties.
• Developed JIL Script to pull Data from Sybase to Oracle.
• Created Package and SP in Oracle to from staging table to GL table after the CVA calculation is done.
• Developed several Stored Procedures, Triggers to generate TOP Ten Counterparties trade related information.
• Gathered statistics on the database tables and using it to tune the SQL statements.
• Developed Shell scripts to automate manual process.
• Developed a tool using Unicode, ksh, Perl, HTML, DB Object to produce report from a Table and create Excel report on the fly and send HTML formatted email instantly.

Environment: Sybase 12.5 and 15, Windows XP, UNIX, Linux, Rapid SQL, KSH, Perl, Autosys 4.5 Oracle 10G

Confidential

ETL Informatica Developer

Responsibilities:

• Responsible for the development of ETL routines using Informatica 8.6 for getting data from SQL Server, Sybase and Flat file and considering various options available for getting data from the source system, analyzing them and implementing the best option suited to load Annuity and Life & Annuity information in the Actuarial Data Warehouse.
• Involved in implementation of entire testing cycle and deployment of System and tested the functionality of software during all stages of the development life cycle.
• Creation and Execution of Test Cases.
• Mapped Design for the Initial Load and subsequent loads into staging area and from staging area to warehouse.
• Mapped development using Expression, Aggregator, Filter, lookup, and Joiner transformations and Update Strategy Designing and optimizing the Mapping.
• Developed Views and Stored Procedures.
• Pre and Post Session Scripts for dropping and recreation of indexes.
• Developed various Mapplets.
• Developed workflow to create task and used workflow monitor and analyze the loading statistics.
• Created Jil scripts to run the workflows.
• Database: Sybase 15.0 and SQL Server 2005
• Language: T-SQL, C, Korn Shell, Perl, Autosys 4.5
• Data Warehousing: Informatica Power Center 8.6

Environment: AIX 5.3, Window 2000, NT, Window XP, Job Scheduling, TCP/IP, Exceed, Hummingbird, Exceed, MS Word, Rapid SQL MS Power Point, Remedy, MS Project and Clearcase.

Confidential

Sybase/Scripting Developer

Responsibilities:

• Responsible for maintaining Secondary Marketing System (SMS) and developed client server applications.
• The application contains loans that have been closed and funded. The primary responsibility of SMS is to create and deliver loan sales to the agencies and investors.
• Utilized programs on the UNIX platform to load data into the SMS Sybase database, run rules, and created outbound files and reports for external systems and users.
• Worked specific UNIX programs that interface with each loan origination system to update the SMS database using that system's interface data.
• These UNIX programs run as part of the regular SMS batch cycle where data is loaded into SMS, rules are running to categorize that data for preparation of pools for sale to investors, and reports are run for end users.
• During the regular business day UNIX programs are accessed in the background by SMS online users to create dynamic reports, run rules dynamically, etc.
• The SMS user interface is a client server based application written in PowerBuilder.
• Created several new Stored Procedures and Triggers to accommodate 40 years’ loan program, Interest only and so many others loan options.

Environment: Sun Solaris (2.9), Window 2000, NT, Window XP.

Confidential

Sr. Autosys/UNIX Shell Scripting Consultant

Responsibilities:

• Calendar Conversion SysAdmiral and Tidal, Treasury and PGOT PROD to AutoSys DEV to Environment. Determine Calendar Anatomy and AutoSys Creation Methods (at per-calendar Granularity).
• Determined Method of Calendar Re-creation in AutoSys DEV (Determined at the Per- Calendar Level).
• Created Build Book to document to include details for SysAdmiral and Tidal, Treasury and PGOT calendar Analysis results, detailed Calendar Anatomy (all per-calendar attributes, characteristics and relationships).
• Used Autosys Creation Methods to convert/re-create all SysAdmiral calendars into the Clients AutoSys DEV environment.
• Reviewed Calendar Analysis Results & Creation Approach Document with Client.
• Revised Calendar Analysis Results & Creation Approach Document based on Client Feedback.
• Used JIL scripts to create Autosys Jobs.
• Met with Client SysAdmiral, Treasury and PGOT Resources to Discuss Exceptions Found, Probable Causes, Impact and Devise Action Plan to Address.
• Created Action Plan to Address Exceptions and Distribute to Client SysAdmiral Client Resources for Review and Feedback.
• Reviewed and Revised Action Plan Based on Feedback and Determine if Further Exception Remediation is required.
• Completed Implementation for Job Exception Remediation.
• Created Implementation Plan for AutoSys DEV environment to address all jobs, calendars and job-related elements being implemented into AutoSys.
• Developed Perl and Unix shell scripting to extract Data from various Databases.
• Developed Perl code to load calendars in Autosys Database.

Environment: HP-UX (11.i), Window 2000, NT, Window XP, SQL Server 2005 and Oracle 9i

Confidential

Sybase Database/UNIX Shell Scripting Developer

Responsibilities:

• Maintained Asset Setup Maintenance Application to set up new assets and updates for transaction to be processed successfully and accurately using C++ and Sybase 12.5.
• Maintained Investment Systems Enterprise Reporting System.
• The purpose of the Application is to generate and distribute reports to the Portfolio Managers to enable them to analyze their portfolios and make investment decisions.
• These reports are generated using nightly batch application, pulls trade, Broker Commissions and other reference data from other databases using Power Center 7.1.
• Worked on several Stored Procedures to improve the performance and also to resolve occasional locking problem.
• Created and maintained stored procedures using PL/SQL and used Sql*Loader to load data into oracle tables.
• At present all applications, their data are currently shared between CRMC and GIG on the same server.
• Created stored procedures, batch job using Autosys scripts, report using SQR, new process using Informatica Power Center in order to pull data from upstream application and creating numerous Bourne and Korn shell scripts. Created new procedures and triggers to support the split projects.
• Developed ETL mappings to move client and product data into new Reporting DB
• Performed migration process development, source data analysis, coordination of data cleansing efforts, source to target mapping, Informatics transformation development, and coordination of issue resolution.
• Configured ODBC. Created new Repository, and created users & groups.
• Created source and target definitions, set up mapping between the sources and targets, created session for each mapping - and ran sessions (resulting in writing data to targets).
• Developed UNIX scripts to perform server status checking and file transfer of critical surface information file across several major applications.
• Developed and modified JIL scripts to pull data from upstream Application.
• Responsible for setting up Autosys jobs for various database activities.
• Supported for Autosys Job Instances.
• Investigated the cause for job failure.
• Responsible for troubleshooting production job failures which were scheduled on AUTOSYS.
• Developed JIL scripts.
• Developed SQR Report, Stored Procedures, Triggers, and Views.

Environment: HP-UX (11.i), Window 2000, NT, Window XP.