SUMMARY:

• I am an experienced architect who excels in driving business transformation by leveraging technology and leading strategic initiatives.
• I have successfully executed large programs that provide value, optimize productivity, reduce cost and increase organizational flexibility.
• Responsible for integrating and coordinating technology and business strategies, fostering a culture where business partners become strong advocates on the creation of innovative solutions to cultivate and advance key technologies such as big data, portals and business intelligence.

CORE COMPETENCIES:

Large - scale system implementations, Strategic planning and execution, Application design & development, Analytics and business intelligence, Enterprise Architecture & Technology operation, Managed Service and enterprise data, Program and project management, IT Financial/Budget Management, Strategic planning and execution, Outsourcing, Data Virtualization, Big Data & Data Warehouse and Cloud integration (SaaS, IaaS, PaaS)

TECHNICAL SKILLS:

Database: Netezza, Oracle, Sybase, SQL Server, Redshift (AWS MPP), SQL Data warehouse (Azure MPP), MySQL

Business Intelligence Software: Microsoft Power BI, Cognos, Business Objects

Data Integration: Informatica, Ab InitioMethodologies: Agile methodology, EVM (Earned Value Management)

Cloud Infrastructure: Microsoft Azure, Amazon AWS, Rackspace

Master Data Management Tools: STIBO

Big Data Technologies: Horton Data Platform (On Premise/Cloud), Cloudera Data Platform (On Premise/Cloud)

Linux: RedHat, Ubuntu, CentOS

Architecture Framework: TOGAF (In progress)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Solutions Architect

Responsibilities:

• Member of the Enterprise Architecture and Technology leadership Team.
• Principal solution architect responsible for designing and building an enterprise data platform.
• Responsible for delivery of an enterprise data management infrastructure in the cloud using Hadoop and SQL Data Warehouse (Azure’s Elastic MPP Database, fully-managed, petabyte-scale data warehouse ). Core deliverables include:
• Design and implementation of a metadata driven infrastructure for loading data by subject area
• Design and implementation of a metadata driven infrastructure for extracting data by subject area
• Design and implementation of a metadata driven infrastructure for distributing data by subject area on demand to an MPP Database Infrastructure.
• Design and implementation of a business intelligence infrastructure that consumes data from Hadoop.
• Managing large scale cross-functional projects. Formulate and lead Enterprise Information Management (EIM) for the Company. Responsible for re-platforming and consolidating programs.
• Established foundational blocks of data management including data governance, ETL, metadata, master data, data warehousing, BI, data profiling & quality, enterprise modeling, canonical modeling and content management.
• Created and presented Architectural road-maps, Architectural Designs and Presentations.
• Design and implementation of Performance management metrics, interactive customer analytics, statistical transformations and corporate dashboards.
• Solid Hadoop Experience including:
• POC Installations and configuration of Cloudera Distribution and Horton Works on Linux Redhat and Centos
• Performance analysis using Cloudera Manager (Cloudera) and Ambari (Hortonworks)
• Programming using Pig and related patterns, Hive Programming
• Developed a Hive Sync Utility for Cloning and Synchronizing Hive Databases from higher environments (PROD) to lower (QA)
• Hadoop Data Modeling (File Formats (Parquet, Avro, ORC); Compression Strategies; Metadata Management, Partitioning, Buckets)
• Developed a high-performance data ingestion mechanism using Sqoop and DBMS utilities.
• Developed an ingestion interface between HDFS and MPP Databases (Redshift and MS Data Warehouse - Petabyte MPP)
• Solid experience working with integration of On-Premises Data with Hadoop in the cloud (Elastic MapReduce - Amazon AWS and Azure HDInsight - Microsoft Azure)

Confidential

Senior Solutions Architect

Responsibilities:

• Analyzed clients’ business strategy and determined system architecture requirements to achieve business goals.
• Formulated strategic plans for component development to sustain future project objectives.
• Gathered detailed business requirements and use cases, and translate technical specifications into product requirements.
• Create team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.
• ETL Architecture infrastructure using Ab Initio, Teradata and Netezza.
• ETL architecture and implementation using Ab Initio.
• Solution Architect and Technical Lead for the development of a Data Pump for migrating data from Oracle, Sybase to Netezza.
• Managed a team of 8 Ab Initio ETL Developers, 3 on shore and 5 offshore.
• Responsible for delivery of the following ETL Solutions using Ab Initio:

Confidential

Data/ETL Architect

Responsibilities:

• Worked on integrating data from different sources (Trading Systems) to the New Strategic Market Risk data model.
• Worked on Position and Book level Risk Scenario Data (Calculated sensitivities by risk factor; impact of fluctuations in interest rates, exchange rates, equity and commodity prices, credit spreads, and other systematic risks).
• Managing and coordinating Database and ETL Proof of Concepts (POCs).
• Developed Use Cases and Benchmarks for a POC comparing: Oracle, DB2, Sybase and Netezza.
• Prepared management executive summary.
• Core Data Technical Lead, Database Migration Sybase 12.5 to Netezza:
• Analysis of data elements, data relationships and attributes, data flow and storage
• Developed an ETL Infrastructure to migrate data from Sybase to Netezza
• Technical Lead, Database Migration Sybase 12.5 to IBM DB2 9.5 for LUW with DPF
• Analysis of data elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities for DB2
• Developing a Technical Migration Plan including migration resource estimates.
• Development of migration tool to move data from Sybase to DB2
• Conversion of stored procedures and function from Sybase to DB2
• DB2 Physical Database Design including Schemas, Tablespaces, MQT, MDC
• Provide input and recommendations on design/technical issues to project manager/senior managers.
• Analysis of all reporting requirements.
• Migration of Transact SQL to DB2 and development of new reports.
• Database Performance Management
• Provides consultation on Data Warehousing design principles
• Tune SQL queries
• Conduct peer reviews of completed procedures and data models
• Gathering requirements and then developing and implementing data solutions
• Provides consultation on Data Warehousing design principles
• Assist in the design of an efficient, reliable ETL mechanism for updating the data
• Work with Development teams to review data access requirements
• Lead the effort of translating data access requirements into an effective data designs.
• Implementations using Dimensional Modeling techniques and design skills to integrate new data into the database as well as continuous re-evaluation of existing data to ensure optimal performance.

Confidential

Data Architect/Developer

Responsibilities:

• Data Architecture and Modeling
• Implemented and managed a Star Schema for the Assets Under Management (AUM)
• Responsible for all logical design issues: subject areas, fact tables, dimensions, snowflake schemas, normalization and denormalization.
• Evaluated and implemented a reporting package (Micro Strategy DSS Agent 5.1) for general reporting.
• Responsible for physical design and related performance issues.
• Management of the Assets Under Management Data Warehouse. Daily tasks include:
• Management, validating, loading and reconciling data
• Performance tuning
• Implementation of new feeds
• Evaluating ETL products like Infomatica, Data Junction
• Migrating all legacy shell and Perl scripts to Java
• Responsible for developing a universal data transformation and load utility using:
• Java and Java Server Pages Technology
• Sybase and MS SQL Server Databases
• Responsible for writing and tuning queries and stored procedures for developers.
• Data Warehousing and reporting using Business Objects.
• Backend Support of Morgan Online.
• Management of Statements IBM DB2 7.0 Datamart

Confidential

Data Architect

Responsibilities:

• Involved in the general design and development of Sales and Trade Server.
• Developed the logical and physical data model for the Sales and Trade Server.
• Converted a number of object models to logical data models.
• Worked very closely with developers and testers to resolve all database performance issues (Queries/Stored procedures).
• Technical support for the trading desk on a rotational basis.
• Involved in the design and development of the new reporting infra structure.
• Worked very closely with developers and testers to resolve all database issues and query performance issues in Development, System test and UAT environments.

Confidential

Data Architect

Responsibilities:

• Responsible for the overhauling and reengineering of the Outcomes Analysis system. Project tasks included the following:
• Responsible for correcting problems in the Logical and Physical data model that were causing performance problems.
• Responsible for Data modeling (Logical design, Physical Design and Query Performance Analysis)
• Analyzing back-end Sybase and MS SQL Database performance problems.
• Preparing management findings report.
• Implementation of a cross database reporting system pulling data from Sybase, Microsoft SQL Server, Oracle and DB2.
• Other responsibilities included:
• Development DBA responsibilities.
• Development ETL responsibilities.
• Building Database Utilities

Confidential

ETL Architect

Responsibilities:

• Responsible for the system architecture and implementation of a 24 X 7 web enabled Compliance Monitoring data warehouse.
• Responsibilities include analysis, architecture and development of a Data Warehouse, and data marts consisting of the trading data. This project included the following tasks:
• Analyzing data from various departments.
• Data modeling (Logical design, Physical Design)
• Analyzing and loading ADP files to databases. Files included:
• TRANSACTIONS,OPEN/CLOSED TAX LOTS, POSITIONS, SECURITY MASTER, PRICE
• Writing a client and server program for sending and collecting data for the web server.
• Developing transaction management and recovery programs.
• Developing data reconciliation and Referential Integrity (RI) utilities.
• Analyzing web/intranet/internet security and performance issues.
• Lead architect for analysis, design and development of a Universal Data Loader to parse, apply business rules and then load the data into the Data Warehouse.
• Solid Sybase and Microsoft SQL Server experience
• Solid programming experience using SYBPERL, PERL 5, KORN Shell, C and JAVA.
• Responsible for the entire Y2K certification for this project.