PROFILE SUMMARY:

• Total Experience: 19 years in various capacities as Data Architect, Development lead, and Systems Analyst/Developer.
• 14 years working with Oracle Database, Unix as Solution Architect, Data Architect and Development lead.
• Strong Database Experience including Oracle 12c/11g/10g/9i/8i and SQL server. Performance tuning, Data Modeling, Data Integration, PL/SQL Stored procedures/triggers, SQLPlus scripts on Unix platform, Oracle physical and logical Data Modeling using ERWIN
• Expertise across Software Project lifecycle activities, Business Requirements Analysis, Use Case Analysis, Technical/Functional Requirements specifications, Project Scoping, Effort Estimation, Data Modeling, Design Specifications, Program Specifications, Defect resolution in QA/UAT test cycles, Integration/ Regression/Acceptance Testing, System maintenance and Production Support. Development experience in Waterfall/ Agile methodologies. .
• 9i to 11g Migration Project, Oracle Performance Tuning involving large datasets using Traces, Statspack/ AWR’s, Table Partitioning, Tuning individual SQL using Hints, Oracle parameter tuning, Result cache. Strong knowledge of Database internals. Experience working with High throughput OLTP systems with time sensitive processes. Design and Development of Data Warehouse/ DataMarts for insurance and financial systems.
• Experience with various development and operating platforms - Oracle, Sybase, SQL Server, Scripting languages, Pro*C, Pro*Cobol, Business Objects, Visual Basic, File based DBMS, Java, Windows, HP-UX, Sun Solaris.
• Experience in leading development projects involving large teams and multiple technologies.
• Experience with ETL tools like Informatica, Eagle Pace Uploaders. Exposure to Data integration tools such as ODI. Experience with using Golden Gate/CDC for replication and zero downtime Database upgrade.
• Domain Experience:
• 7+ years in Financial Domain including Mutual Fund Accounting, Investment Banking, Wealth Reporting Applications and Banking systems.
• Expertise in implementation and customization of Confidential Mutual Fund Accounting System and Eagle Pace Data warehouse. Worked as SME on projects involving Eagle functionality.
• Worked closely with Business Analysts and End users to facilitate creation of BRD’s and Functional requirement documents.
• 4 yrs Insurance Domain experience with Auto/HomeOwners Insurance Rating systems.
• Technically oriented with effective project planning and execution, communication and Interpersonal skills. Proven record of successful project delivery.

PROFESSIONAL EXPERIENCE:

Data Architect/ Data Modeler

Confidential, NJ

Responsibilities:

• Designed Staging / Reporting Data Models for Integrated Enterprise Cost Management Reporting/ BI Dashboards.
• The system incorporates feeds/ extracts from major Bank Data warehouses including Ledger (Expense Accounts), Account/ Cost Center Hierarchies, HR, Technology Costs.
• Designed Data Model for operational Data store for automating Contracts maintenance and Forecasting application.
• Physical Models designed with Partitioning implemented to handle expected data volume management/ archival requirements.
• Composite Range List Partition implemented with locally partitioned indexes on the fact tables.
• Work with Tableau team to provide appropriate reporting views for dash-boards.
• Development platforms: Oracle 12c Enterprise, Toad for Oracle, Toad Data Point, Tableau

Data Architect

Confidential

Responsibilities:

• Datawarehouse was hosted on Microsoft Azure Cloud using SQL server Database. Design Tool used: Toad Data Modeller.
• Logical model was designed based on a detailed study of CFG Business Requirements and their current Business and Data Workflows. Several iterations with CFG Business Analysts & consultations with Business SME's to validate the initial drafts of the Data model.
• Model was designed as a Decision support System (DSS) Data warehouse, largely denormalised to support the planned reporting strategy via Tableau and expected ETL Data feed volumes and frequency.
• Physical Model developed with Indexes / Partitioning / referential integrity designed based on expected Daily / Monthly Data Volumes (10 GB) and reporting strategy (Tableau) including expected number of concurrent users/ transactions.

Data / Performance Architect

Confidential

Responsibilities:

• Performance architect for Non functional POC project for Intellects payments system. Projects initiated by client for Polaris as demonstration of payment products throughput capabilities based on the clients benchmark requirement specifications. Responsible for providing design inputs to the product team to help meet clients throughput and scalability benchmarks.
• Analyze and resolve DB performance issues faced at client installations. Use of Oracle Enterprise manager, AWR/ ADDMs and Active session history (ASH) reports for root cause diagnosis and periodic Database health checks on existing product installations. Provide expert troubleshooting assistance to production support teams.
• Detailed reviews of data models used by base products of the Intellect product Suite. Code analysis using Toad Code analysis tool. Guidelines for enterprise wide best practices for Data Modelling and PL/SQL Code.
• Part of management team to research ideas with product potential and analyse use cases for new platforms and technologies. As part of this effort, evaluated / researched Big data technologies currently in market. Comparison of Nosql databases like Cassandra, Hbase and Mongodb.

SME/Development LeadConfidential, NJ

Responsibilities:

• Requirement Analysis, Creation of low level design for developers based on the Design document from BBH Pricing team including Data Model and Interfaces between Java/Oracle
• SME: Explanation of Current and Proposed System architecture and Design to Java /Oracle Development Lead /developers. Mentored the team on the Business functionality of the pricing system and significance of the pricing system within Star fund Accounting System. Held regular testing sessions with developers for standardizing unit/integration testing and delivery.
• Interaction with BBH Onsite team/ Business analysts and site visits to finalize requirements and proposed design.
• Effort Estimation for the entire project. Worked with Project Managers to define project tasks, milestones, dependencies and delivery dates into project plan based on effort estimation.
• Resource/Work Allocation and oversee development and testing activities.
• High level code Reviews.

Confidential

SME, Development Lead, Technical Architect, Production Support

Responsibilities:

• Managed several projects as a Team Lead in the Ledger Processing and European Tax/Equalization Work Streams.
• 9i to 11g Migration project: Involved in the strategic effort to migrate the system from Oracle 9i to Oracle 11g database. Analysis of Statspacks from RAT Replays. Used GoldenGate for bi-directional replication to provide minimal downtime migration..
• Analyse and fix impacts of 9i-11g migration in Star/ Pace Database Code
• Identify and fix data sorting issues due to the plan differences between 9i and 11g in the way it handles Group By clauses in SQL and impact analysis of the same. Removal of deprecated Rule hints from existing Star Code and overall system impact analysis
• Actively involved in planning the migration steps and project plan.
• Actively involved in Functional and regression testing of the system.
• Performance Tuning projects to improve efficiency of the Star Application. Tuning of Equalization events in the Star schedules for Valuation and Transaction Close. This helped meet SLA’s on the larger funds.
• Designed Composite partitioned tables (Range/ Hash Partitions) to persist information about the Star Applications background parallel processes. This was designed to reduce the contention inherent in the table structures that hold diagnostic information in the original design.
• Involved in the Redesign & Performance tuning of Year End and Month End processes in Confidential to improve application performance.
• Pace Uploader/ Exporters: Create new interfaces using the inherent Uploader and Exporter functionality built into Eagle Pace. Customised Stored procedures for Exporters and Validation stored procedures for Uploaders.
• European Tax calculation projects to add new tax types, meet regulatory requirements due to changes in European Tax law to handle German Tax rules for calculation of URGL on DDI Bonds.
• Production Support: Actively involved in Production support and troubleshooting during the Star system daily cycle. On call for Production issues. Involved in troubleshooting issues in Functional modules as well as SRM and Control Center.

Confidential

Development Lead/ Technical Architect.

Responsibilities:

• Requirements Analysis, System Design, Estimation, Data Modeling, Program specs and Development, Interaction with business Analyst during the lifecycle.
• Design the Data Model to support this project.
• Design and develop the functional modules of the project to calculate unrealized/ realized amounts, maintain trades and positions by European tax types, post Equalization adjustments to the funds equalization URGL accounts.
• Design and develop module to handle fund distributions and its impact on ETax and German Tax Calculations.
• Performance Impact analysis of the various processes introduced by this application on the overall system.
• End to End participation throughout the project lifecycle from inception, Requirements stage, System Design, Data modeling, Development, code Reviews, Integration testing.

Skills Used/ Environment: Oracle 9i, 11g, Performance Tuning tools (Trace files, Statspack, AWR, Explain plan), GoldenGate, PL/SQL, Unix Shell scripting (Korn Shell), Perl, Toad (Coding Environment, Session browser, Code expert, Data Modeller), SQLDeveloper, Linux, SVN (Subversion) open source version control system, HP Quality center 9.0

Database Specialist

Confidential

Responsibilities:

• Requirements Gathering, Performance Tuning, Program specification, Development, Integration and Testing /Validation, Interaction with Business Analyst, Data quality and Quality assurance groups, Co-ordinate release efforts.
• Development of various reports - Holdings / Comparative Holdings by investor and realized/ unrealized gain/loss reports at Taxlot level, portfolio snapshot, detail reports at taxlot level.
• Performance tuning responsibility for Global price Reconciliation application, Albridge File Delivery. Successfully tuned the applications to perform under the required SLA’s.
• Development of Replication module to provide normalized data to the clients subscribing to replication data.
• File delivery module as an alternate route to provide normalized data back to clients. This was accomplished using Unix scripts scheduled through UNIX cron .

Skills Used/ Environment: Oracle 10g, PL/SQL, Toad 9.0, Linux, Unix Shell scripting (Korn Shell),.SVN (Subversion) open source version control system, Mercury Quality center 9.0 (Test Director).

Database Specialist

Confidential

Responsibilities:

• Requirements analysis with respect to data mapping between TAS and EDB. Create financial interfaces with TAS such as Portfolio Holdings and Cash and Security ledger applications. Use of Sqlloader utility to import raw data.
• Data Model changes in Oracle to accomodate new GP specific data structures.
• Responsibility for One time conversion of financial data from GP to EDB before going live with the new TAS. Conversion includes fund holdings, security registrations and restrictions, cash transaction details including details of security trades, taxlot details, tax codes etc.
• Provide additional functionality, such as YTM / Yield to Call calculation for fixed income Securities and estimated income calculations on holdings, handle multicurrency Internal and external sweep accounts, calculate net income, net principal and net cash for reporting.
• Provide support to QA testing team for financial data reconciliation related to holdings and cash ledger transactions. Assist EDB data consumers such as Cognos reporting, Centralized query system for Bank’s Client Account managers to review data.
• Defect logging and resolution, interaction with Sungard team to get issues resolved..

Skills Used/ Environment: Oracle 9i, PL/SQL (stored procedures), Unix Shell scripting (Korn Shell),.SQLLoader, Toad 9.0, SourceGear, Sun OS 5.9, Mercury Quality center 9.0 (Test Director).

Technical Lead

Confidential

Responsibilities:

• Requirements Gathering, BA interaction, Program specification, Development and Testing /Validation.
• Develop complex PLSQL packages for various functions such as data copy from datamart to staging tables/ mapping / state setup / reporting (using pipeline functions)
• Develop various shell scripts & sql scripts to provide flow of control and as a preliminary interface to backend (Oracle) utilities.
• Data Modelling and development of Homeowners Insurance datamart using dimensional modelling.
• Developed data feed for Home Ratemaking Business Objects Reporting universe using Materialised views.
• Support Business Analyst with Validation of States/Rating plans and to help setup the states for Ratemaking runs of several years of policies.
• Support BA for OffBalance Runs to analyse proposed rating plans for the company.
• Interaction with Business Analyst and users for user requirements and testing.
• Create and maintain regression test scripts and regression test data. Follow the SDLC structure for development and maintenance releases (Intg/ QA environments.).
• Represent team on Syswatch Meetings (System watch meetings to determine impact of business changes on specific systems - For eg. Rating rule changes for a specific state(s) would need to be incorporated into an existing Hartford plan and whether a system or metadata change is required).
• Setup and Monitor Quarterly Ratemaking Batch runs.

Skills Used/ Environment: Oracle 10g, PL/SQL (stored procedures), Unix Shell scripting (Korn Shell), ProCobol, Visual Basic 6.0, SQL Navigator 4.0 tool for PL/SQL coding and debugging, Accurev Version control system, Exceed X windows V7.1a, HP - UX 11.11. OS