SUMMARY:

• Business Intelligence/ Performance Management / Database Design / Systems Analysis / Governance, Risk and Compliance/ Financials ERP / CRM/ Geospatial Applications

TECHNICAL SKILLS:

• Oracle 11g
• ERwin
• Tableau
• Salesforce
• SQL Server BI Stack
• ESRI ArcGIS

PROFESSIONAL EXPERIENCE:

Confidential

BI/DW Solution Architect

Responsibilities:

• Major responsibility was as the lead Information Architect to design, develop, and deploy an Enterprise Data Warehouse for the agency. Responsible for gathering analytical requirements from user groups and building the Business Intelligence semantic layer. Worked as part of the Enterprise Information Architecture team responsible for managing how information and data relate throughout an organization’s business process landscape.
• Technical lead to design, develop and deploy the Proactive Preservation data mart which was the initial application for a federated Enterprise Data Warehouse built on Oracle 11g. Worked with various business units to perform the analysis necessary to gather requirements and model the dimensional design in ERwin, using Kimball conformed dimensions within an agile methodology. Performed the data mappings for the ETL process which utilized a combination of PL/SQL stored procedures and Oracle Data Integrator. Coordinated with the DBA’s to tune and optimize SQL queries.
• Technical lead to design and develop the Transparency subject area in the Enterprise Data Warehouse to comply with the requirements of Local Law 44 to publish in Open Data format the attributes of affordable housing projects the agency participated in. Also included data points related to Hurricane Sandy reconstruction funding. Supervised the creation of all physical and logical data models and the building of a staging area to serve as a temporary operational data store.
• Participated in the decision process to evaluate both ETL and Business Intelligence tools for the agency. Built initial pilots on SSIS and SSRS, but final tools selected were Oracle Data Integrator and Oracle Business Intelligence Enterprise Edition(OBIEE). Worked as part of a team to install and utilize these tools as part of the implementation strategy for DW/BI deployment. Initial task was to design the subject areas for the RPD and build a BI Portal. Integrated this BI environment with Hyperion Financials and the operational ERP.
• Collaborated with the business units on the roadmap to roll out Tableau self - service dashboards, scorecards and analytics. Collaborate with the big data team to optimize and enhance data structures to be used in BI solutions. Work with various teams to develop both static reporting and interactive visualization solutions. Perform ad-hoc reporting and visualization duties as assigned.
• Serve on the Data Governance steering committees and competency panels. Responsible for developing a data governance framework for the organization that would include data quality profiling and master data management components. Evaluate and recommend tools and business process management changes. Create an enterprise-level data dictionary, by documenting all entities, and attribute data lineage. Establish and manage the metadata management approach for the agency. Determine the overall data modeling standards, guidelines, best practices and approved modeling techniques and approaches. Provide technical leadership for the data modeling staff.
• Gathered requirements and modeled the information architecture as part of HPD’s participation in the City of New York’s DEEP, (Data Elements Exchange Program), to facilitate interagency sharing of data.
• Participate in prototype to set up a Big Data platform utilizing IBM Cloudera and Netezza to demo scenarios using the agency’s data. Work up a data strategy to in corporate Big Data into existing enterprise data warehouse and analytics environments.
• Coordinate with the project teams and others to ensure that data implementations align with the Enterprise Information Architecture, and meet the applicable standards. Participate in all data integration programs and projects — both enterprise and point-to-point efforts — by rationalizing data processing for reusable module development. Work jointly with the database administrator in developing the data objects and data models to support data services under a service-oriented architecture approach (SOA). .

Confidential

BI Data Architect

Responsibilities:

• Participate in building a Center of Excellence for the Global Wealth Management practice of the bank to spread adoption of best practices for performance management applications. Projects focusing on customer relationship, product development and compliance. Expertise in data warehousing applications for reporting and business intelligence.
• Perform Business Analyst role interfacing with subject matter experts to understand and define the functional and information requirements for logical data modeling supporting reporting applications by outlining data strategy and report specifications and documenting these in the Business Requirements Document (BRD). Understand business processes to detail the roadmap necessary to better link strategy with operations. Involved with design of different deployment options and architectural issues of enterprise vs. departmental BI. Responsible for unit testing application mock ups to ensure that business needs are fully addressed in development solutions, and work with the business units to implement roll out and training programs.
• Act as team lead Data Architect gathering requirements from business users to understand the business rules to model in ERwin for the design of the Enterprise DW/Operational Data Store (ODS) reporting structure. Utilize Microsoft SQL Server as database to capture auditing and change management data for compliance with market and credit risk regulations for Basel II and Sarbanes-Oxley at international bank.
• Design dimensional star schema data marts utilizing the Kimball methodology. Develop semantic layer in Cognos8 Framework Manager. Develop ERP and SalesforceCRM reporting applications utilizing o accessing Oracle, DB2, and SQLServer databases. Analyze requirements and perform variance analyses, accruals and departmental expense analyses. Develop dashboards and scorecards to track actual vs. planned result KPI’s for driver based planning with goDashboard. Participate in training of users to familiarize them with tools for the local analysis of data by OLAP cubes in Analysis Studio.
• Enable SAP BusinessObjects Enterprise Performance Management for measuring and aligning operations to corporate strategy by integrating ERP financial data from SAP BW into various data marts. Utilize financial statement consolidations according to GAAP and IFRS to produce reports for profitability analysis and productivity measuring effectiveness of policies to analyze actual vs. planned variances linking strategy to execution.
• Designed BO universes to support WebI reporting capability for both ad-hoc and canned reports for operational and dimensional databases including summar y tables to resolve report level complexity. Utilize Business Objects Dashboard Manager to track actual vs. planned results with KPI’s for driver based planning. Develop hierarchies for multidimensional OLAP cubes, and participate in training users to familiarize them with the tools for the local analysis of data.
• Redesign existing Mortgage Backed Securities database identifying areas of functional improvements in the system, taking into consideration time to market, back office processing, cost and revenue opportunity. Develop applications utilizing the GIS from ESRI ArcView Business Analyst to better understand the geographic component of customer and MBS data. Objective was to aid in marketing and product development.
• Participate in data architectural design for dimensional model utilizing Erwin toolset and Kimball’s star schema methodology for a SQL Server data warehouse feed by SQL Server Integration Services (SSIS), during the ETL process. Devise ways to insure the integrity of data after it was transformed into the data warehouse. Utilize advanced SQL to perform data analysis with aggregate functions and subqueries.
• Develop functional design of the metadata repository to store the organization’s reference data for master data management to be utilized as a framework for standards and procedures in customer and product data management. One specific project is to protect sensitive customer data from unauthorized use when changes are made to production data through the use of masking procedures and data obfuscation.
• Demonstrate strong Project Management skills. Proficient with Microsoft Project to manage schedules, deadlines and resources, collaborate on projects.

Confidential

Data Architect

Responsibilities:

• The brokerage division of a major Wall Street investment bank. Member of a team responsible for business strategy to develop an enterprise data architecture. Champion the effective use of information standards and techniques for Product Definition Data. Facilitate sessions with business users to derive entities, attributes, and relationships to support business processes. Reconcile data model with process model to ensure completeness and accuracy.
• Utilize Erwin in design of logical and physical data model for E-commerce online international portfolio management system. Security master included entities for equity, options, fixed income, and mutual funds with provision for currencies. Work with business users to insure that database captured necessary elements for portfolio analysis and reporting applications.
• Develop logical data model for call center CRM initiative utilizing Oracle11i E-Business Suite. The database design was made as generic as possible to allow offshore companies to utilize it in a variety of industries. Reverse engineer existing business processes from Microsoft Access to Oracle9i. Transform logical model into a physical implementation for performance optimization..
• Lead data architect in redesign of database for online Mutual Fund Center. The primary effort was changing the table structures to load content from Morningstar, instead of Lipper, to improve content delivery. Also built in new customer type functionality to allow filtering of product offering by entitlements. Responsibilities included: requirements gathering, business rule identification through extensive process modeling with users, design of the Oracle logical data model, and mapping attributes to entities utilizing ERwin.
• Responsible for design stage for dimensional model in marketing data warehouse feed by Informatica during the ETL process. Develop query and analysis reports using Hyperion Brio utilizing this data. Assist users in setting up their client reporting solutions.
• Participate in consulting project during the formulation of requirements and design of enterprise data architecture for a startup company’s website for personalized fixed income content. Work directly with investors and entrepreneurs on feasibility of business plan.
• Participate in the design of the enterprise metadata repository intended to enable best practices standards and procedures for storing master data. Upload this information to corporate intranet.