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.
• Extensive experience in business/data analysis, production/application support, leading teams, program design and development.
• Strong background in database development using PL and Transact SQL and sophisticated queries in ANSI SQL.
• Experience in developing client server and web applications.

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(training)

Responsibilities:

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

Confidential

Oracle Analyst/Developer

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

Responsibilities:

• Integrating Platts Commodities Market Data into Credit Conditions Data Hub.
• 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

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

Responsibilities:

• 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

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

Responsibilities:

• Provide support of Capital Market Automated Trading System ( Confidential ) on Trading Floor.
• Analyzed data received from Bloomberg and cross reference database.
• 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

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

Responsibilities:

• Was leading business and data analysis, development and testing of Cash Management and Accounting System - SAP Interfaces.
• These are the systems that support the operations of the business: Each source system (application) has an adaptor developed. The adaptor is designed as part of this program, and is required to prepare valid canonical transaction data to send to SAP. The adaptor must retrieve necessary data from the source application based on posting events, implement any data enrichments, lookups and data normalization procedures (e.g. from Confidential ).
• Responsibilities included:
• 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

Environment: Sybase, Java, Windows

Responsibilities:

• As a Scrum Order Capture team member involved in business and data analysis, development and testing of Front Office application for a variety of financial products.
• GSTP is a global system that provides the following functionality:
• Consolidate/streamline operating model for front and middle offices.
• Applications to support users across brokerage and IM accounts and extend globally product for Private Banks of America and International Private Banks.
• Consolidate technology platform, source code.
• Responsibilities included:
• 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

Responsibilities:

• Data Analyst-Programmer involved in business and data analysis, development and testing of middle office application for a variety of financial products.
• AIS RS is a report generator that uses Oracle queries and stored procedures as data source. Final reports have an excel format.
• Responsibilities included:
• 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

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

Responsibilities:

• 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

Responsibilities:

• 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