SUMMARY

An Assertive and Innovative BI & DW Architect with over 18 years of experience in cross- functional projects, methodology/process development, consulting and client relations.

Specialist Architect on DW, BI & Reporting solutions, modeling, Designing, Developing and Implementation.

Conceptualized, Designed, Developed and Sold an ETL Integration Product (Mapping Manager) for Business Analysts (a first of its kind).

Demonstrated proven experience with business intelligence architecture and data modeling for large complex multinational companies using SQL Server and Informatica ETL and other reporting Tools.

Expert on various Business Intelligence, Data warehouse, data mart, client/server and web-based applications.

Expert knowledge on various BigData technologies e.g. Hadoop etc.

Designed efficient ETL strategies for near real-time loads with an appropriate level of aggregation in order to support near instantaneous response times.

Skilled in multiple releases of the best-in-class BIDW platform tool-sets.

Bridging the IT and Business teams to meet the Project deadlines and deliverables.

Translate dashboard/reporting requirement to appropriate BI solutions and data needs. Architect and design semantic layers to support both ad-hoc/canned reports as well as dashboards.

Hands-on Oracle Administration, Architecture, Data modeling and Data Migration.

Worked on various levels of SDLC life cycle as Architect, Tech Lead, and analyst and as Developer.

Work with directors, business leaders and all aspects of information technology (IT) to ensure there is a business intelligence strategy and road map to accomplish the goals of the business.

CERTIFICATIONS

Oracle Certified Professional (OCP)

Project Management Professional (PMP)

Certified Scrum Master (CSM)

TECHNICAL SKILLS

Languages C, C++, Visual Basic, SQL, PL/SQL, Shell, .Net, Javascript, Java and J2EE

Databases Oracle, SQL Server, DB2, MS-Access, Teradata

Big Data Hadoop, Cassandra, MongoDB

ETL Tool’s Informatica, Data Stage, SSIS, SAP DS

CASE Tools ERWIN, Rational Rose, Visio 2003

BI/OLAP Tools Cognos, BO, ProClarity, MSAS, Brio, Panorama, OBIEE, QlikView, Tableau

EXPERIENCE

Client: Human & Health Services Commission, State of TX, Austin Oct, 2015 – Feb, 2017

Role: MDM/Data Architect

Review HHS Enterprise Metadata Repository implemented by EDG.

Review Architecture, Design and deliverable of HHS Enterprise Master Data Management (MDM).

Review and propose the design, implementation and management of security access roles and privileges for all types of metadata and master data consumers.

Participate in the development of processes and guidelines for Metadata management – change management, metadata access and sharing. This will include processes and capabilities for versioning all forms of metadata.

Represent EDW for all metadata and MDM activities performed by the Office of the Chief Data Officer (OCDO) and EDW Design, Development, and Implementation (DD&I) vendor.

Coordinate MDM program activities for the Member and Provider data domains Conduct source system analysis, and data profiling for lifecycle management.

Participate in Data Acquisition strategy for EDW.

Participate in design and deliverable reviews as needed.

Client: Otsuka Pharmaceuticals, Princeton, NJ Sept 2014 – July 2015

Role: MDM Architect

Define the required attributes for each domain to support a robust and successful deployment of a MDM platform.

Define and implement requirements for data matching and merging rules, survivorship criteria and data stewardship workflows in MDM tool.

Involved in designing and developing of Party, Product and Alignment data model.

Thorough understanding of deterministic and probabilistic matching methodologies and master data hierarchy management.

Collaborate with the Enterprise Architecture teams (data integration, data architecture, business intelligence) to develop and deliver MDM solutions.

Work with Architecture Review Board and Change Approval Board for technical reviews and approvals through the system development life cycle.

Created Data Sources for the Data Import and List of Values Validations

Designed and Implemented Data Quality processes to cleanse the data

Designed and Implemented Profiling using Discover module of Data Quality

Client: HEADSTRONG AUG, NEW YORK, NY Aug 2011 – Mar 2014

Role: Sr. Principle Architect

Architected data management solutions for various financial clients.

Lead and perform current state analysis on legacy reporting platform and developed a new robust architecture for the increasing needs of business with the capabilities of Fail over, reload, error tracking, exception handling, and Taxonomy and Metadata management. Architected the solution using Informatica MDM for crating Master Data Repository.

Responsible for Project Management, Milestones. Involved in Defining Static and Reference Data Domains, Enterprise Data Architecture (EDA) Vision for Insurance firm. Prepared Business case, executive summary on Future State Vision and Road map.

Architected a solution for an Enterprise Data Quality (EDQ) framework. Serialize Information flow from disparate source feeds into Integrated Platform on various database platforms like Oracle, Teradata and SQL Server.

Manage the team during transition phases.

Developed a strategy to migrate members, claims history and other information from Recap adjudication platform to RxClaim. Making the data available for Case retrospective and intervention activity, where the claims are analyzed based on the various business rules and determines the drug interventions for CVS Client.

Created a roadmap to migrate the complete technology platform to SQL Server based tools.

Evaluated and Demonstrated and showcased various ETL and BI tools for large Insurance clients.

Architect, Design, and manage the test harness solution for Test data Generation library, Master Test Data library, automation.

Builds framework for all aspects of test data and strategy needs with respect to data sub setting, test data generation and automation, data masking and testing methodology to align with or define relevant new TDM Strategy

Created multiyear phased roadmap for implementing and setting up Data Governance.

Client: JP MORGAN, NEW YORK, NY Apr 2009 – Aug 2011

Role: DW Architect

Architected a custom MDM solution for Instrument master data to source the instrument feeds from Bloomberg for various asset classes using the Oracle PL/SQL.

Defined and architected a generic rule based Cross Reference (XREF) approach to match and merge the securities from various sources to define a master security.

Architected and Designed an Instrument Interest list in PBSD for all consuming applications.

Integration of the master security feed into PAID and to Geneva.

Designed and developed a generic data purging component for all database purging process.

Architected a metadata based solution for recon process to decommission the legacy recon process.

Client: MORGAN STANLEY OCT 2006 – APR 2009

Role: DW & BI Architect

Designed various product, Counterparty, Issuer hierarchies to allow the drill down of the cube definition by integrating reference data into Risk system.

Migrated MSAS 2000 to MSAS 2005.

Remodeled the database design for increased efficiency for cube processing and query performance by 60% with the MSAS 2005 migration. Developed the OLAP Scribe utility for MSAS 2005 environment to generate the Cube metadata documentation.

Developed various monitoring tools to gather the usage statistics and monitor processing and query performance.

Designed and developed a custom Drill through module, using java and SOAP framework.

Implemented the load balancing and clustering solution for MSAS 2005 environment.

Designed and developed custom data model to implement Dynamic security in MSAS 2005.

Implemented the single cube project solution with the use of perspectives for various business units.

Client: EDS, PLANO, TX Apr 2006 – Oct 2006

Role: ETL Architect

Analyze source systems and understand source system applications with the help of PTS Business Analysts.

Created ETL Architecture and source system analysis document for the Project. Interacted with Informatica Administrator group, source system and Data warehouse DBA’s and source system application owners.

Design data model for PTS Metrics data warehouse using Erwin

Worked with team in preparing Source to Target Mapping and unit test case documents.

Designed, Developed and Reviewed ETL mappings from source to staging and from staging to Data warehouse.

Prepared Test Strategy and coordinated system, integration and user acceptance testing.

Prepared strategy to implement ETL code in production and load historical data in production.

Client: HP IPG-IT, BOISE, ID Sep 2004 – Apr 2006

Role: DW & BI Architect

Produced and reviewed High-Level Technical Architecture Design following the development, testing and release processes and strategy documents.

Implemented the row level security for external business partners to protect the data privacy, which eliminated the need to ftp the reports to partner sites.

Architected high-level, logical Data Warehouse and Business Intelligence solutions to meet business needs. Created the Sales compensation data mart.

Providing Project Leadership to the team including production timetable, status reporting, client/project team coordination, and quality assurance.

Defining and achieving client needs through one-on-one sessions and on-going communication. Defect tracking, organizing project assets, and reducing time to generate the quality and delivery metrics.

Establish architectural standards and best practices for enterprise business intelligence tools and solutions.

Work directly with business partner, end-to-end, development, and quality teams throughout the entire SDLC to create requirements, architecture, design, test strategy, and implementation documents.

Work with sr. management and business leaders and all aspects of information technology (IT) to ensure there is a business intelligence strategy and road map to accomplish the goals of the business.

Superior expert level guidance and vision for Enterprise Information Management principles (data lineage and governance).

Providing the technical consulting to the project team and BI Practice and participating in the review sessions of the RFP’s.

Writing SQL queries for a customized reporting on Informatica metadata. Reviewing the Call Center data mart with business to add the new dimensions into data mart.

Creating the various data marts and dimension models using MOLAP/ROLAP and HOLAP.

Creating an ad-hoc universe using Business Objects6 Designer to cater the Ad-hoc reporting requirements. Implementing the Business Objects Broadcast agent to schedule and ftp the partner specific reports. Stream lined the release process by creating the various release templates and the checkpoint documents.

Mentored other developers and trained the business team in DW concepts, processes, and technologies Possible.

Created the Virtual Cubes to join the cubes of different granularity. Have created the numerous numbers of Calculated Members and Calculated Measures to implement the rolling and snapshot averages.

Client: HP Global eBusiness Operations Pvt. Ltd., Bangalore, India Nov 2003 - Aug 2004

Role: Data Modeler & Lead Developer

Created Logical Dimensional models and data marts, using Erwin.

Created the Physical model from Logical model using Erwin and applied all the database characteristics for Oracle Database.

Created mappings and mapplets using various transformations of Lookup, Aggregator, Expression, Stored procedure, Sequence Generator, Router, Filter, and Update Strategy.

Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.

Created, Configured and Scheduled the Sessions and Batches for different mappings using Workflow Manager and UNIX Scripts. Interacted with end users to identify key dimensions and abstracted quantitative metrics feasible in deciding business solutions.

Worked on the performance tuning of the programs, ETL Procedures and processes. Involved in Testing & Performance Tuning of various mappings. Designed and developed standard reports using Business Objects. Responsible for training the end-users. Involved in technical documentation.

Client: AETNA INC., USA Oct 2002 - Oct 2003

Role: Performance Tuning & Migration Developer

Created Mapping Design document to transfer data from source system to data warehouse.

Development of Informatica Mappings, Sessions, Worklets, Workflows.

Created Complex mappings using various transformations using Informatica.

Scheduling of Informatica Jobs through Shell script.

Migrating form Informatica Power Center 5.1 to Informatica Power Center 6.2

Wrote Shell Scripts to monitor load on database and Perl Scripts to format data extracted from Data warehouse based on user requirements.

Prepared a process document from moving Informatica code from Development to Production.

Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.

80% of user-defined functions (consists of business logic) are converted into simple/complex SQL queries to process the huge volumes of data in considerable period.

Achieve client needs through the defined process and an ongoing communication.

Tuned the Pl/SQL stored procedures using the PL/SQL Profiler.

Responsible for requirement analysis, design, and implementations using the various web and database technology solutions.

Reviewing and analyzing the stats pack report for the resource usage of the application and to consider other aspects for the performance tuning.

Client: ORILLION INC., HOUSTON, TX Nov 1998 - Aug 2002

Role: Project Lead

Managed the DBA team comprises of 8 people (local and remote) for the development, QA and customer support.

Responsible for installation and up gradation of the Oracle server and application tools on various platforms, included Windows, Linux and Solaris. Extensive database and application tuning using explain plan, SQL trace, and stats pack.

Planned and created database instances, managed storage based on design and managed advanced securities.

Advanced partitioning and indexing implementation for Alarm Data.

Highly involved in the implementation of various advanced features (like Materialized views, Dimensions and Analytical functions etc. of Oracle database to improve the performance of the application.

Developed the various PL/SQL stored procedures to migrate the application schema to the newer application versions.

Contact this candidate