SUMMARY:

IT professional with experience working for financial companies analyzing data and developing different reports and application and providing production and application support on different levels. Skilled in Business/ Data Analysis/ Application and Production Support/ Full Life Cycle of Development. Experience also includes working with various development methodologies.

TECHNICAL SKILLS:

Languages: PL/SQL, T/SQL, ANSI SQL, Shell script, VBScript, Powershell, PowerScript, HTML, JavaScript, JSP, ASP.

Databases: Oracle, Sybase, MS SQL, MySQL, MS Access.

GUI Tools: Toad, DB - Artisan, Rapid SQL, Oracle Navigator, SQL Developer, SQL-Loader, MicrosoftVisual Studio, Eclipse, bloodshed Dev-C++

Version Controls: Visual Source Safe, Mercurium.

OS / Hardware: Linux, Unix, Windows, Mac.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Analyst/Developer

Environment: Oracle, Data Warehouse, Big Data

• Data Analysis
• Extraction
• Data layout
• Data profiling
• Mapping
• Data quality
• Data dictionary
• Integration

Confidential

Oracle Analyst/Developer Market Data/Agile/Commodities

Environment: Data Warehouse, JSON API, Oracle, PL SQL, Golden Source Framework, SQL Loader, Excel, MS Word, MS Access, VBA, Powershell

• Market data management
• Data Analysis (Platts Commodities Market Data)
• Data layout
• Data profiling
• Data/columns mapping
• Data quality
• Data dictionary
• Data integration
• Created business rules
• Prepared data flowchart
• Created Platts Commodities Data Model in Golden Source Framework
• SQL coding.
• Prepared DML SQL queries and files for setup
• Implementation in Development, QA, UAT, Production
• Review and sign-off UAT implementation.
• Prepared Runbook

Confidential

Production and Application Support/Prime Brokerage/Agile/Equities Swaps Cash

Environment: Jasper Reporting System, Oracle, PL SQL, Linux, Bash Script

• Analyzed data received from different vendors, identified and fixed data discrepancy.
• Verifying files received, rerunning files as needed, responding to alerts with overnight batch issues, investigating file issues.
• Provide quality, specialized, technical support including batch monitoring and health check as well as production incident management.
• Production problem diagnosis, cause identification, solution discovery and implementation.
• On-boarded new clients using shell script and SQL.
• Scheduled batches for new clients.
• Wrote SQL and ran queries to report on web site activity and web status.
• Developed financial and KPI reports using Jasper Reporting System.
• Developed Support Automated Tool(java server pages) for offshore team.
• Scheduled Oracle jobs using Oracle Scheduler.
• Coordination with other developers and supporters from local and offshore teams.
• Track production changes using JIRA

Confidential

Production Management/Application Support/ Wealth Management/Capital Market/Trading Desk/Bonds

Environment: Linux, Shell Script, Windows, Sybase, T SQL, FIX protocol

• Provide support of Capital Market Automated Trading System (CMAT) on Trading Floor.
• Provide written detailed updates using an incident management tool to enable efficient and effective trending of issues, escalate severity issues as appropriate, create and maintain support documentation for both our onsite/offshore teams.
• Independently manage day to day service delivery problems and work on special projects as assigned.
• Document all user issues via ServiceNow.

Confidential

Business/Data Analyst/Developer/Cash Management/Accounting System/Commodities

Environment: Oracle, MS SQL, T/SQL, PL/SQL, Sybase, VBS, Windows Scheduler, Windows XP, Windows 2008 R2.

• Analyzed business requirements
• Analyzed and mapped data.
• Designed and developed database in MS SQL and Oracle.
• Designed and developed VBS controller.
• Scheduled jobs using Windows scheduler.
• Created tables, views, stored procedures, functions and packages.
• Optimized queries and improved performance.
• Provided UAT processes.
• Participated in meetings to resolve issues and problems during design, coding, unit testing, system testing, integration testing, performance testing and production release.

Confidential

Team Lead/Business and Data Analysis/Private Banking/Wealth Management/Scrum/Equities Options

Environment: Sybase, Java, Windows

• Analyzed business requirements
• Analyzed and mapped data
• Created tables, views, triggers and stored procedures.
• Optimized queries and improved performance.
• Supervised setting of Sybase servers for RPC.
• Participated in Scrum meetings to resolve issues and problems during design, coding, unit testing, system testing, integration testing, performance testing, and production release.
• Provided day-to-day production support and maintenance.

Confidential

Data Analyst/Derivatives

Environment: Oracle, PL/SQL, ShadoSuite Financial Accounting System ShadoSuite Scheduler/FX Swaps Bonds Equities

• Analyzed business requirements.
• Analyzed and mapped data.
• Developed financial reports based on stored procedures and sophisticated queries in Oracle
• Daily Reconciliation Reports
• Balance Sheet
• Cash Flows Report
• Profit and Loss Report
• Journals for adjustment General Ledger Balance and trade broker files for prime brokers.

Confidential

Senior Programmer/Analyst /Equities Fixed Income Cash Flow

Environment: Oracle, PL/SQL, Sybase, MS SQL, T/SQL, ANSI SQL, Visual Basic, Microsoft Access, Powerbuilder 6/9, ASP, VBscript, JavaScript, HTML, Windows

• Migrated database objects from Sybase to Oracle RDBMS.
• Analyzed the requirements and the architecture of the applications.
• Analyzed and mapped data, based on Mainframe reports and Oracle data structure.
• Involved in creation of tables, views, triggers, indexes and stored procedures in Oracle.
• Developed ASP as presentation and implemented business logic at server side using Visual Basic dlls
• Developed Private Client and Institutional Financial Reports utilizing MS Access and Oracle stored procedures.

Confidential

Project Manager/Risk Measurement

Environment: Sybase 11, T/SQL

• Analyzed data.
• Executed conversion of stored procedures into Risk database.
• Developed new stored procedures.
• Created new tables, views, triggers, indexes in Risk database.
• Provided maintenance and performance tuning.
• Forced indexes and created temporary tables.
• Interacted with management and business analysts

Confidential

Application Developer

Environment: Sybase 11, T/SQL, Powerbuilder 5-6.5, MS SQL 7

• Participated in data analysis.
• Developed stored procedures, tables, views, indexes, rules, defaults and triggers to facilitate data integrity and retrieval using Sybase 11.
• Developed new modules for existing Powertool and PFC based Powerbuilder 5,6.5 application.
• Provided maintenance and production support .