­

TECHNICAL SKILLS:

Expertise: Strong Data Architecture, Team management, Data Modeling, Data Analysis, Data processing, Metadata analysis, Supply Chain, Data warehousing, Business Intelligence, Reporting, Data Integration, Metadata infrastructures, Strong communication skill.

Environment: Financial, Brokerage, Telecommunications, Mutual Funds, Insurance, Healthcare, Medical, Manufacturing, Engineering, Human Resources.

Databases: SQL Server, Confidential, MySQL, DB2, Sybase.

Operating Systems: Windows, Unix.

Programming Languages: SQL/TSQL, PL/SQL, Dot - Net, Java.

Design Methodology: UML.

Data Modeling Tools: ERWIN, ER/Studio, Power Design, SQL Enterprise Manager, Visio.

Data ETL Tools: SSIS, Informatica, ODI.

Reporting: OBIEE, SSRS, Cognos, Business Objects, MS-Access Reports, MS-Excel, Crystal Reports, Custom Reporting Tools.

Collaboration and Source Control: SharePoint, TFS, VSS.

PROFESSIONAL EXPERIENCE:

Confidential, Boston MA

Data Architect/ Project Manager

• I operated as a Data Architect and project manager for a data warehouse project
• Team included 10-15 professionals
• Overall team was made up of a number of smaller teams: development, business analysts and QA
• I was responsible for defining work requirements, goals and milestones
• During my tenure we implemented multiple phases of the DW project with hundreds of reports and multiple dashboards.
• I provide guidance and review all project disciplines
• I implemented a variety of systems and quality assurance methodologies
• I implemented methodologies for simplification and validation of all data transformations including ETLs and other data transformations.
• Was responsible for implementation of different DW layers
• ETL - including metadata and documentations
• ODS - including schemas
• DW core data - including conceptual/logical/physical models
• Specialized Data marts - including conceptual/logical/physical models
• Report business logic - including functional and technical specifications
• Reporting Dashboards - including metadata definitions
• S/W and Methods: E/R Studio, OBIEE, Confidential ODI, Confidential PL/SQL, MS-Project.

Confidential, Brookline MA

Contributor in startup initiative

• Designed and built a management system for Electronic devices
• Note: this project was more of a self initiative operation within a startup
• S/W and Methods: SQL Server and VB tool stack.

Confidential, Needham MA

Data Architect/Data Analyst

• Designed the ODS for the EDW
• Designed master data components (MDM) including Product master and Party/Organization/Accounts master
• Designed data models and developed (Schema and coded API) special “Value Matching Engine” to support a wide variety of financial reconciliation use cases.
• Designed and developed generic “Media Management” architecture and engine (Schema and coded API) to standardize the import processes of a variety of file formats (for financial reconciliations).
• Set standards for data modeling
• Project management - Build Project proposals, developed requirement documents and project task time-lines.
• Process analysis - Built systematic methods for recording and analysis of legacy SQL code (reverse engineering) in order to identify business rules, then used methodology to conduct a rigorous analysis of legacy financial systems.
• Set standards for business rules collection
• Data Analysis - Built systematic data profiling techniques to identify relationships in data, undercover hidden Entities, data anomalies, Attribute interdependency, implicit rules within the data, “selectability” of data points, and other characteristics of data.
• Analysis was compiled and presented to the business team in special review sessions.
• S/W and Methods: Sybase Power Designer, SQL Server 2008, TSQL, UML, VSS (as source control).

Confidential, Boston MA

Data Architect/Data Modeler

• Lead the design and data architecture for Financial Instruments.
• The focus of the design was on accounting aspects of financial securities
• Design followed analysis of general securities and contract based securities
• Developed generic data models that uniformly accommodate existing financial instruments along with newly engineered financial instruments
• In this experience I was fortunate to collaborate with some of the top financial SME in the industry.
• As part of my responsibilities I set architecture standards for data modeling and ETL
• S/W and Methods: ERWin, SQL Server 2008, TSQL, UML, Team Foundation Server (as source control).

Confidential, MA

Team Lead Data Architect/Lead Data Modeler

• Responsible for the data architecture and the construction of core data models for the new corporate enterprise system.
• Defined and modeled a number of master data components (MDM) including People and organizations and Products.
• System was designed top down identifying strategic business needs down to data subject areas down to physical implementation in an iterative manor.
• System was designed in accordance to supply chain architecture. Data components designed as independent subject areas. All modules accompanied with full detailed design documents and diagrams.
• Designs included process models to support the data.
• Designs included dataflow diagrams
• Supply chain modules include: Organization and people management, products and pricing, Orders management, Quotes, Geographic boundary, Security and others.
• Lead analysis sessions with business, built project proposals and project plans.
• S/W and Methods: UML, ERWin, SQL Server 2008/2005, Confidential 11g, TSQL, prototyping tools.

Confidential, Boston, MA

Lead Data Architect/Developer

• Confidential Convergex Group provides customized trading and investment tools.
• Designed a data warehouse (star schema) to support analysis of securities trades.
• Provided SQL server performance tuning and benchmarking of high availability reporting.
• Provided high end reports via SQL Reporting services
• S/W: SQL Server 2005 SQL Reporting services, SSIS, TSQL, Stored procedures.

Confidential, Boston, MA

Lead Data Architect

• As a member of the Systems Data Architects team, proved data architecture services to a variety of projects
• Fidelity Systems group formed expert teams for different disciplines of data projects.
• All data projects were assigned to the Expert Data Architecture team, in return data architects provided data solutions in the form of Data models, Process models and other artifacts in a series of design documents.
• Daily tasks included facilitating business Requirements sessions and data design.
• Conducted systematic data discovery initiatives within large legacy environments.
• S/W: TOAD, Confidential Designer, Visio, Power Designer, Confidential PL/SQL.

Confidential, Boston, MA

Data Architect/Data Modeler

• Defined Master data (MDM) architecture and strategy for Customer/Account subject and for products subject areas
• Designed and implemented a corporate data warehouse to support corporate product sales.
• Responsibilities included Analysis sessions and production of functional and technical specs.
• ETL analysis included comprehensive research into Confidential ERP for GL and AP components.
• System was then developed and tested.
• S/W: SQL Server 2005 SQL, SSIS, Confidential PL/SQL, TSQL, Stored procedures, ASP.

Confidential, Boston, MA

Data Architect/Database Modeler

• Responsible for the design and implementation of the corporate Data warehouse.
• Design included conceptual, logical and physical models.
• Design included ETL definitions and implementation.
• S/W: SQL Server 2005, SSIS, SQL 2000, TSQL, Stored procedures.

Confidential, Brookline, MA

Confidential, Norwood, MA

Data Architect/System Analyst

• Designed and implemented a data warehouse for the ‘Software Release Development Group’.

Confidential, Boston, MA

Data Modeler/Marketing Analyst /Programmer

• Designed and implemented a data warehouse for the Order Management System.

Confidential, Prudential Tower, Boston, MA

Database Architect /Programmer/Analyst

• Designed and Implemented a number of modules within the Finance data warehouse

Confidential, Boston, MA

Database Architect

• Designed and implemented a reporting environment for the ‘Time Management’ data.

Confidential, Boston, MA

Database Developer

• Designed and implemented a Physician procedure utilization system

Confidential, Boston, MA

Database Architect /Programmer/Analyst

• Designed and deployed Fund Performance Analysis tools

Confidential, Boston, MA

Database Architect /Programmer/Analyst

• Designed and implemented a brokerage reporting system

Confidential, Boston, MA

Database Architect /Programmer/Analyst

• Designed a system to parse and store life insurance illustration data.

Confidential, Boston, MA

Programmer/Data Analyst/Business Analyst

• Analyzed, developed and deployed a number of management systems