SUMMARY:

• Over 14+ years of IT experience on Data/Database oriented systems
• Designed and Architect complex analytical and reporting systems
• Strong Expertise in data modeling, analysis, design and data architecture
• Hands on experience with handling large data sets, tuning and optimization
• Possess Finance domain knowledge and associated systems knowledge
• Lead and Managed collocated and distributed project teams

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i/7, Greenplum, MS SQL Server 2005/2008

Languages: SQL, PL/SQL, Pro*C/C++, UNIX, ANT script, perl, HTML, JavaScript

Environment: s: UNIX, Linux, AIX, Windows NT/2000/XP, Sun Solaris 2.6

Tools: Power Designer, ER Win, Designer, Informatica, OBIEE, Tableau, OEM, AutoSys & Control - M scheduler, SFDC.com, Source control tools Harvest, Starteam and clearcase

EXPERIENCE:

Confidential, Southboro, MA

Principal Data Architect

Responsibilities:

• Performed Data Analysis and Identified the missing data subjects required for DD CRM reports in enterprise data model
• Produced conceptual, logical and physical enterprise data models with new subjects includes knowledge base articles, service request association with knowledge base articles, articles association with product taxonomy
• Reviewed the data models with Enterprise Architects, then performed Knowledge Transfer to development team on approved data models
• Developed informatica ETL mapping documents for new subject areas as per enterprise standards.
• Defined migration plan from the current data environment to new enterprise data environment for initial and incremental data loads
• Worked closely with Tableau reports development team to develop optimized SQL query plans
• Presented new enhanced enterprise data model with Confidential business teams so that they can take appropriate action to extent the existing reports

Languages and technologies used: ERWIN 9.0, Oracle 11g, Greenplum 4.1, Control-M, Informatica 9.5/9.1, Tableau and SFDC.com .

Confidential, Smithfield, RI

Principal Data Analyst

Responsibilities:

• Identified the missing data subjects in enterprise model required for Institutional Investor Products
• Identified the existing data subjects in enterprise model, same data is sourced by Pyramis from multiple vendors by paying license cost, by eliminating this data sourcing saved the company by 4 Million dollars/year.
• Produced conceptual, logical and physical enterprise data models with pyramis institutional investment subjects
• Designed and Developed the ETL for new subject areas using informatica as per enterprise standards.
• Defined migration plan for 24 applications across 7 track teams from the current data environment to new enterprise data environment
• Enhanced the enterprise data model with client investment reporting capabilities, primarily pyramis business requirements but can be extended to use by other divisions
• Developed and Implemented historical data movement and on-going data movement for the new subjects using PL/SQL

Languages and technologies used: Sybase Power designer, Oracle 11g, Autosys, Informatica, OBIEE .

Confidential, Boston, MA

Data Modeler

Responsibilities:

• Produced conceptual, logical and physical enterprise data models for daily/monthly instrument returns.
• Developed and maintained Informatica mappings to load data from multiple vendors by getting in to staging, vendor history, ODS then finally into warehouse dimension and fact tables.
• Designed and developed the data quality verification reports and using PL/SQL
• Defined Materialized Views and used Oracle PIVOT, hierarchical and Analytic Functions for oracle views for Reporting Purpose.
• Designed, developed & supported the data access layers for various applications

Languages & technologies used: Power-designer, Oracle 11g, Autosys, Informatica, Unix, Shell & Perl Scripting .

Confidential, Boston, MA

Solution Designer

Responsibilities:

• Designed and Developed international wire transfer module
• Produced data architectural plan to support current and future business needs which includes performance, scalability, HA & DR architectures
• Developed migration code between different versions of Enterprise Bankers (using PL/SQL), used when two banks merged using EB product with different versions.
• Established best practices for PL/SQL coding, DB deployment, DB source control, code reviews, unit testing and performance testing
• Provided database performance improvements in the Confidential on-demand environment which host EB product for around 60 banks with huge volume of data.
• Developed EB-Doctor utility (using PL/SQL) to support engineering team by reporting pain points

Languages and technologies used: Oracle 9i/10g, IBM Data Architect Data Modeling Tool, Solaris, Linux.

Confidential, Boston, MA

Data Architect

Responsibilities:

• Produced data architectural blueprint to support current and future business needs which includes HA & DR architectures and infrastructure planning
• Defined data migration plan and standards for data access
• Established best practices for data modeling, PL/SQL coding, DB deployment, DB source control, code reviews, unit testing using PL-UNIT and performance testing
• Established data access standards, data quality, data lineage and data security strategies
• Designed generalized work flow process for data corrections
• Build data model using a star schema dimensional model which includes quantitative analysis of reliable time series data on funds, fund attributes, returns, holdings, indexes, benchmarks, etc.
• Defined Oracle Materialized Views and used Oracle Analytic Functions for Reporting teams.
• Effectively evaluated SAS application quarries used by quant analysts for performance optimization
• Defined best of breed and data quality strategies for various vendor feed data
• Effectively evaluated the use of Informatica in using ETL process
• Data refresh from production to non-production environment using Oracle Data Pump
• Automation of database change releases using ANT and Build Forge
• Oracle PL/SQL common frameworks (exception handling, logging & timer)
• The Oracle PL/SQL frameworks are instrumentation libraries that provide PL/SQL developers code to aid in diagnosing and repairing performances problems
• Design, develop and promoted to all the divisions in Fidelity Investment Management Technology

Languages and technologies used: Oracle 10g, Sybase Power-Designer, Informatica, AIX, Linux.

Confidential, Newton, MA

Principal Software Engineer

Responsibilities:

• Created database architecture, conducted design reviews focused on data architecture
• Provided guidance on future data use (Data Futurist) & catalyst of converting data into a knowledge base
• Designed automation of database product deployment
• Designed application and process monitoring solutions to detect and alert on failure
• Provided technical expertise to IT infrastructure operations group, QA team to assist in creation/implementation of test plans and performance optimization of Oracle application code
• Designed an infrastructure using Single Sign-On to support integration across multiple domains
• Designed a federated architecture for sharing user identity for quick integration with new applications
• Designed integration architecture with RSA, VASCO (token authentication) and Cyota systems
• Produced in cost savings by 40% in integrated authentication system across 2 proprietary applications
• Improved the designed to support account management module to work with large accounts
• Optimized the design of auditing module, reduced job execution time from 10 hrs to 20 minutes

Languages and technologies used: Oracle 8 i/9i/10g, ERWIN, Java, EJB, XML, Solaris, Linux, WebSphere 3.5x/5.0/6.0 WebSphere Clustering.

Confidential, Manhattan, New York

S enior Database administrator

Responsibilities:

• Designed data warehouse, Created ER diagrams and Data Models
• Authored AWK script (clean up the data before migration) & shell script for to run database level Jobs
• Developed PL/SQL packaged procedures for balance summaries, used SQL Loader to load the data
• Wrote Pro* C++ program to monitor the data loads
• Scheduled the jobs using AutoSys scheduler to automate the processes
• Tuning SQL for optimal performance based on cost/rule based optimization
• Tuning data storage for avoiding fragmentation, dynamic extension and chained rows

Confidential

Project Leader

Responsibilities:

• Designed Cargo Import, Export, Warehouse, Accounts, MIS, History & Archive Maintenance modules
• Responsible for performance tuning, Unix System Administration,
• Innovative idea to introduce the bar code in warehouse billing system to accurately account billing fees
• Designed & Developed program for purging the data, and retrieval of the same using SQL*Loader