SUMMARY:

• 11+ years of strong experience in the areas of Software Design & Development in financial ( Corporate Investment Banking & Fixed Income Accounting Systems) and healthcare domains.
• Used different methodologies of SDLC e.g. Agile, Waterfall, Iterative model.
• Experience in working with teams across different geographic locations (US, Europe & Asia)
• Experience in Oracle 11g/10g/9i/8i/7, SQL, PL/SQL, MySql, NoSQL (DynamoDB).
• Experience on Oracle Exadata platform.
• Experience of AWS (Amazon Web Services) - EC2, S3, RDS, EMR, DynamoDB, MySQL.
• Experience in Eagle Star Platform.
• Working knowledge of trading life cycle.
• Hands on experience on implementing BASEL III regulatory reporting requirements for financial clients.
• Technical hands on experience and deep domain knowledge of Fund Accounting Systems.
• Technical hands on experience and deep domain knowledge of AML/KYC and Client on-boarding for investment banking area.
• Hands on experience on designing data model for new applications using Power Designer (Oracle), Workbench(MySql).
• Proficient in ETL(Extraction Transform and Load ) concept and developing ETL programs using tool or PL/SQL.
• Experience in performance tuning and optimization using Toad, Oracle text indices, table partitioning, analysing, Oracle STATSPACK, Explain Plan, Trace Plans, hints, TKPROF, SPM ( SQL plan management ) etc.
• Extensive hands on experience of SQL & PL/SQL programming using Oracle Procedures, Packages, Functions, Triggers, Global Temp tables, Views, Materialized views, Pipelined Functions, Indexes, Table Storage Parameters, DBMS locks, External Tables, Locks etc.
• Knowledge of Oracle ETL features such as Merge Statement, SQL Loader, External Tables, Pipelined/Table functions, Multi Table Inserts, Collections, Copy commands, PL/SQL bulk collect features etc.
• Hands on experience in redefining tables in Oracle online using DBMS REDEFINITION package.
• Working knowledge of oracle XML datatypes.
• Extensive hands on experience in job scheduling using Autosys, Cron or Oracle DBMS Scheduler.
• Proficiency in writing reporting queries for various business needs.
• Worked independently on projects with high visibility and accelerated momentum in Legal Entity On-boarding, Institutional Sales Reporting (Sales Client Hierarchy), Client Account on boarding, AML/KYC, compliance reporting etc.
• Actively coordinated multiple initiatives parallel.
• Actively working in sync with business people to understand client expectations and reviewing the delivery in accordance.
• Strong communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Expertise in Unit Testing, Integration Testing, System Testing and experience in preparing the Test Cases, Test Scenarios and Test Modules and Test plans.
• Maintained various windows based desktop applications designed using Visual Basics.
• Basic knowledge of Core JAVA.
• Expertise in Visual Basic 6.0. Basic knowledge of maintaining MS Excel macros.

FUNCTIONAL SKILLS:

• Mapping client/business requirements and providing software solutions involving finalization of project specification and selection of appropriate techniques.
• Conducting periodic project progress review meetings to ensure specified time parameters and being met.
• Handling various technical aspects like analysis, design, development, testing for new applications, monitoring critical paths & taking appropriate actions.
• Enhancements catering business needs for the existing application.
• Implementing and delivering the deliverables as per scheduled deadlines.
• Played as idea parking anchor for projects regarding technical enhancements.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g/9i, Oracle XML, MySql, DynamoDB, MS Access, Sybase

Database Appliances: Oracle Exadata

Cloud Technologies: AWS (Amazon Cloud Services)

Operating Systems: Windows9X, Windows2000/XP, DOS, UNIX

Computer Language: Oracle PL/SQL, SQL, MySQL, DynamoDB, Oracle XML, Visual Basic 6.0, JAVA

Scripting Language: UNIX Shell Scripting, VB Script

SDLC Méthodologies: Agile, Waterfall Model, Itérative Model

SCM: Perforce, CVS, VSS, SVN, Accurev, GIT

Job Scheduler: Oracle DBMS job scheduler, Autosys, Crontab

Tools: SQL Workbench, Talend, PL/SQL Developer, Power Designer, Toad 9.1, MS Access

PROFESSIONAL EXPERIANCE:

Confidential

Senior Data Analyst/Architect

Responsibilities:

• Used Online redefinition (DBMS REDEFINITION) to partition un-partitioned tables.
• Developed packages/procedures/functions/views/materialized views for various database components.
• Used different kind of refresh techniques for materialized views - FAST, Complete, and Partition Change Tracking.
• Used oracle DBA views extensively to complete various data analysis for roles, privileges etc.
• Worked on retiring schemas, required lot of co-ordination and repointing queries to use new tables.
• Worked on designing and implementing database objects for search screen requirements. Used Merge Inserts, Exadata hybrid columnar compression, creating indexes etc.
• Worked on performance tuning and query optimization using various oracle methodologies like partitioning, hints, indexing, subquery factoring, query rewriting etc.
• Worked on creating interval partitioning methodology for huge tables
• Worked on creating Virtual columns for partition tables with timestamp fields.
• Created triggers to store audit data in flat files using oracle file handling methodology.
• Worked extensively with database links, synonyms (remote & local), roles and grants.
• Worked with oracle external tables for loading data.
• Worked on launching various types of EC2 T2 instances - Nano, Micro, large etc.
• Used Amazon EC2 instance to configure Cron jobs and deploy Talend workflows.
• Used Amazon S3 to save data in CSV files exported from Oracle 12C.
• Used compression, versioning & encryption for storing files on S3.
• Developed customized metadata information system using MySQL on Amazon RDS for files stored on S3.
• Created S3 instances and stored archive data exported from oracle.
• Participated in schemes designing, used reverse engineering to develop data model for existing database.
• Performed many data quality analysis work.
• Created procedures to refresh and gather stats on tables on daily, weekly and monthly basis.
• Use Crontab for scheduling jobs.
• Used Talend for defining workflows.

Technologies: Oracle Exadata, Oracle 11g, Oracle PL/SQL, SQL, PL/SQL Developer, Amazon Web Services, Crontab, Accurev, Putty, MS Excel, MS PowerPoint

Confidential

Senior SQL Developer

Responsibilities:

• Participated in defining requirement scope and timelines.
• Worked on translating business requirements into high level and low level design.
• Worked on creating unit test plans.
• Helped in end user acceptance testing by showcasing output to business groups.
• Worked on creating historical trend reports on volume etc.
• Designed database schema from beginning.
• Developed ETL using SQL, PL/SQL & Autosys.
• Created procedures & functions used by JAVA layer rules engine.
• Created end to end configurable reporting framework.
• Actively involved in production deployment planning and implementation.
• Actively involved in production support activities.
• Worked on partitioning, compression, indexing, user defined types, bulk collect features, pipelined functions, SQL loader, global temp tables, user defined exceptions, exception logging, autonomous transactions, external tables, SQL Loaders, file handling etc.
• Worked on maintaining schema level stats by creating daily, weekly and monthly jobs for gathering stats.
• Worked on performance tuning and query optimization.
• Worked on creating reconciliation jobs using PL/SQL and Autosys.
• Created shell scripts to validate file format etc.
• Configured sFTP and created shell scripts to sFTP files.
• Generated schema diagrams using Power Designer & MS Visio using reverse engineering concept.

Technologies: Oracle PL/SQL, SQL, Shell Script, Toad 11.6, Tortoise SVN, SQL Loader, Power Builder, Putty, MS Visio, Aginity, MS Excel, MS PowerPoint, Sybase Power Designer.

Confidential

Senior SQL Developer

Responsibilities:

• Issue identification and fixes for Oracle 11G migration.
• Performance tuning for different modules.
• Redesign existing data model to enhance performance.
• Worked on oracle compression techniques for very large tables.
• Worked on 11g specific partitioning methodologies, indexing, clustering etc. to optimize performance.
• Used Global temp tables to enhance performance of existing reports.
• Used bind variable and dynamic SQL to enhance database scalability.
• Used oracle locks to implement serialization coming from various front end tools.
• Worked on table storage parameters to resolve deadlocks.
• Used user defined exceptions.
• Used oracle bulk collect feature to load huge tables.
• Used oracle merge statements.
• Worked with Oracle advanced queues.
• Design the automation processes on Eagle Star/Pace platform for various manual process.
• Writing PL/SQL and SQL code using Toad 9.1 to meet business requirements.
• Used autonomous transaction for logging mechanism.
• Ensure Unit testing is completed for the process.
• Create historical reports using Oracle PL/SQL programs.
• Used explain plans and STATSPACK to analyze various performance issues.
• Used Global Temp tables, materialized views, pipelined functions, indexes, table storage parameters, locks.

Technologies: Eagle Star/Pace, Oracle PL/SQL, SQL, Shell Script, Crontab, Autosys, Toad, SVN, SQL Loader

Confidential, New York, NY1

Technology Analyst/Consultant

Responsibilities:

• Involved in data element mapping exercise between LEO/MCD and newly designed PCORE application.
• Worked on Tuning programs designed in Oracle PL/SQL.

Technologies: Oracle SQL, PL/SQL, Oracle 10g, Perforce, Toad 9.1

Confidential, New York, NY

Technology Analyst/Consultant

Responsibilities:

• Worked on defining Oracle XML based data model for the application.
• Designed and developed Data Conversion routine using Oracle PL/SQL from legacy relations database to new XML database.
• Used materialized views, indexes, external tables, packages, procedures, functions, triggers etc.
• Integration with workflow rule engine - BPM using Oracle XML features, Oracle PL/SQL stored procedures, functions, packages.
• Design and developed data feed routines for downstream systems using Oracle de-normalized tables and triggers.
• Helped in database optimization to improve performance of Oracle stored procedures/queries.
• Knowledge Management anchor for the team.
• Developed reconciliation and reporting jobs using Autosys and Oracle DBMS scheduler, Shell Scripting *& Perl Scripting.
• Used Perforce as source Version control.
• Design/Development for product on boarding component for various regions and line of businesses.
• Design/Development for Users’ Profile module for application.

Technologies: Oracle PL/SQL, SQL, Oracle 10g, Autosys, Perforce, Toad 9.1, Shell Scripting, Perl

Confidential, New York, NY

Technology Analyst/Consultant

Responsibilities:

• Used materialized views, indexes, external tables, packages, procedures, functions, triggers etc.
• Single point of contact for providing details for Client and Legal Entity data.
• Played a key role in designing and developing Data Conversion program using Oracle PL/SQL from source to target system.
• Played a key role in designing and developing reconciliation and reporting jobs using Autosys, Shell Scripts and Oracle PL/SQL.
• Used Perforce as source Version control.
• Developed various oracle PL/SQL components to maintain application and to be used by GUI.

Technologies: SQL, PL/SQL, Oracle 10g, Autosys, Sybase, Perforce, Toad 9.1, Shell scripting

Confidential, New York, NY9

Technology Analyst/Consultant

Responsibilities:

• Worked on defining requirements of the overall integration.
• Worked proactively to come up with a design and release schedules for the project.
• Designed and developed Data Conversion routine using Oracle PL/SQL from legacy systems to new system.
• Perform releases.
• Developed nightly jobs using Autosys, Shell Scripts, Perl, Core JAVA and Oracle PL/SQL to keep various systems in sync.
• Designed and developed various data feeds for downstream systems for revenue reporting using Oracle Views, Materialized Views and de-normalized tables.
• Used Perforce as source Version control.

Technologies: SQL, Oracle PL/SQL, J2EE/Java/JSP/Servlets, Struts, JDBC, Weblogic 8.2, Perforce, Toad

Confidential, New York, NY

Technology Analyst/Consultant

Responsibilities:

• Worked proactively on defining requirements and writing Oracle PL/SQL program for entire conversion.
• Followed Agile methodology for development.
• Worked on designing data model using Erwin.
• Participated in high-level/detail design of the overall application.
• Designed and developed workflow engine and approval flow component using Oracle PL/SQL packages.
• Developed Oracle Views, functions, partitioned tables and stored procedures to be used by application.
• Implemented contains search using Oracle Text Index feature.
• Developed scheduled jobs using Autosys, JAVA and Informatica.
• Performed a marathon release that lasted for 40 hrs including data conversion efforts.
• Did data analysis and provided resolution for couple of show stopper issues a week before release. Was appreciated & recognized well by client & Infosys for timely resolution.
• Used Perforce as source Version control.
• Created various utility tools using MS Access and Oracle to be used by application e.g. user creation tool etc.
• Worked on integration with trading systems like Bloomberg, INA, MBSE etc.

Technologies: SQL, Oracle PL/SQL, Oracle 10g, Autosys, JAVA, Informatica, Shell Scripting, Perforce