SUMMARY

• Hard working, driven and result - oriented senior technologist with over 12+ years of IT experience with close to 8 years experience in Investment Banking.
• Strong leadership with emphasis on collaborative teamwork. Experienced in delivering new project from start.
• Experienced in partnering with senior business and technology stakeholders and cross functional teams to manage the expectations and timely delivery of projects.
• Expertise in hands-on management of new development, re-architecture and support projects.
• Experienced working as Scrum Master.
• Technical expertise in Architecture, modeling, design and development of performance critical distributed and large scale systems usingOracle (11g) PL/SQL, SQL Loader, Data Modeling, Dimensional Modeling, Informatica PowerCenter, XML and UNIX Scripting.
• Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using SQL Loader and Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Extensive experience in developing Stored Procedures, Functions, Packages, Views, Materialized Views, Triggers, Complex SQL queries.
• Experience in redesigning the existing application by studying the existing application and coming up with a new Data-Model.
• Expertise on Performance Tuning of Complex queries and Processes using Explain Plan, DBMS Profiler and AWR reports.
• Hands on development experience in Python.
• Good knowledge in the financial domain.
• Good understanding of financial asset classes and related products such as Equity, Bonds, Swaps, Options, Futures/Forwards, Structured products.
• Financial engineering, time series, derivatives. Researched, designed, built profitable analytics/models, and trading systems across major asset classes: fixed income, equities, currencies and commodities. Structured products, volatilities, and credit derivatives.
• Very strong Debugging and Performance Tuning skills.
• Worked extensively in developing procedures, functions, packages, materialized views, Oracle streams, collections, partitions and complex queries
• Have a good experience in analyzing Explain Plan, AWR and Tkprof reports
• I have taken training on Big Data - Map-Reduce, Hive, Hbase, Sqoop and Pig,Spark.

TECHNICAL SKILLS

Database: Oracle 11g, 10g, 9i, 8i

Language: Oracle PL/SQL, Pro*C, Python, UNIX shell scripting, Developer 2000 Forms 6i and Reports 6i

Tools: Informatica Power center, Putty, SharePoint, Control-M, Quality Center, AppWorx, Microsoft Visio, SQL Loader, Import Export utilities

IDE: PL/SQL Developer, TOAD 8.5

Scheduling Tools: Control-M, AppWorx, Autosys

Functional tools: Know-how of Perform, Sophis Risque and Latent Zero (suite inclusive of Tesseract, Minerva and Sentinel)

Version Control Tools: Subversion (SVN), CVS, Perforce

Other Notable Skills: Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Participate in the planning/requirement gathering meetings for new projects. Analyze requirement and Development Design based on a Business Requirements Document.
• Studied existing application and worked on to re-designing the application. Proposed new Database model to enhance Performance of existing application plus make sure the changes are transparent to the downstream users.
• Implemented solutions using Oracle PL/SQL packages, Procedure, Functions, Materialized views to cater business needs.
• Worked on tuning the Complex Queries using DBMS Profiler, EXPLAIN PLAN, HINTS, Materialized Views and rewriting queries to use optimum execution plan.
• Developed Autosys jobs for scheduling nightly batches.
• Developed scripts using UNIX shell scripting and Python.
• Developed ETL solutions using SQL Loader and Autosys Jobs.
• Have the exposure of communicating with BA’s for the business requirement.
• Involved in code review process.
• Prepared Design specific documents for the development work and completed unit testing and prepared deployment plan of the release.
• Involved in mentoring new team members functionally and technically. Involved in estimation and resource allocation.

Technology Used: Oracle 11g, UNIX, SQL Loader, Microsoft Viso, Autosys, SQL Loader, XML, Python scripting, Dimensional Modelling, Partitioning, Materialized views, DBMS Profiler.

Confidential

Data Architect / Team Lead

Responsibilities:

• Participate in the planning/requirement gathering meetings for new projects. Analyze requirement and Development Design based on a Business Requirements Document.
• Worked closely with all stakeholders to develop the the EMDD application from scratch. Designed Logical and Physical model to cater to the OLTP application.
• Developed solutions using Packages, Procedures, Triggers, Functions, Views etc to cater business needs.
• Worked on tuning the Complex Queries using DBMS Profiler, EXPLAIN PLAN, HINTS, Materialized Views and rewriting queries to use optimum execution plan.
• Developed Autosys jobs for scheduling nightly batches. Worked on developing batches to work in parallel in autosys.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into EMDD database using SQL Loader and Autosys Jobs.
• Involved in development and code review process.
• Prepared Design specific documents for the development work and completed unit testing and prepared deployment plan of the release.
• Involved in mentoring new team members functionally and technically. Involved in estimation and resource allocation.

Technology Used: Oracle 11g, UNIX, SQL Loader, Microsoft Viso, Autosys, SQL Loader, Python scripting, Dimensional Modelling, Partitioning, Materialized views, DBMS Profiler.

Confidential

Data Architect / Team Lead

Responsibilities:

• Participate in the planning/requirement gathering meetings for new enhancement. Analyze requirement and Development Design based on a Business Requirements Document.
• Creating of new/change existing database objects required for development in Sophis .
• Developed solutions using Packages, Procedures, Triggers, Functions, Views etc to cater business needs.
• Worked on tuning the Complex Queries using EXPLAIN PLAN, HINTS, Materialized Views and rewriting queries to use optimum execution plan.
• Developed Autosys jobs for scheduling nightly batches. Worked on developing batches to work in parallel in autosys.
• While working in the project, have the exposure to understand business closely and own the application completely
• Have the exposure of communicating with actual users on business requirement.
• Prepared Design specific documents for the development work and completed unit testing and prepared deployment plan of the release.
• Involved in mentoring new team members functionally and technically.

Technology Used: Database Oracle 10g, Oracle PL/SQL, Performance tuning, Oracle streams, Replication, AWR reports, Explain Plan, Partitioning, Materialized views, Complex queries, Unix Shell Scripting, SQL Loader, Autosys, Toad, Oracle