We provide IT Staff Augmentation Services!

Mdm Consultant/ Big Data//bi Solution Architect Resume

Eagan, MN

SUMMARY:

  • A MDM/Big Data/Data Warehouse/Business Intelligence Enterprise Architect/Solution Architect/Data Architect who is passionate about data and focused on building next generation applications. Working with business partners and other IT departments to understand the business objectives and drive solutions that efficiently meet the needs of the business.
  • Hands on with most technologies in order to understand critical details and lead teams by examples, while keeping a big picture view for high scalability, high reliability, cost - effectiveness.
  • Very solution oriented and always focus on using these emerging technologies to solve real world problems and achieve the firm’s goals. Always do my best to gain other people’s trust, encourage others thorough positivity, be helpful and resourceful. 20+ years in IT with 15+ years’ experience focused on Big Data, Business Intelligence and Data warehousing.
  • ‘Big Data’ technologies such as Hadoop, NoSQL databases, ETL/ELT, MDM $ BI Tools and also with Netezza/ greenplum data warehouse appliance technologies
  • Informatica MDM 9.7.1 - the MDM conceptual, system, technical, and system architectures, and in some instances the systems/process architecture for major areas of development. A thorough understanding of how source systems may integrate within MDM through researching, evaluating and selecting technologies (existing or emerging) that best fit the business and IT strategic needs.
  • Strong skills dealing with Informatica data management(RDM) and Hierarchy Manager.
  • Application integration technologies such as ESB's and SOA
  • Experience in Integrating and aggregating large data sets into high-volume data warehouse applications using highly-varied and high-velocity data collection systems
  • Experience in recommending, architecting, designing, operating and maintaining an enterprise architecture that supports large-scale analytics
  • Do have deep understanding of the ‘Big Data’ technologies such as Hadoop, NoSQL databases, ETL/ELT, MDM $ BI Tools
  • Ability to understand complex data relations, business requirements, formulate efficient and reliable solutions to difficult problems
  • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation
  • Practical experience with the data modeling (dimensional, relational, star schema’s, snowflake schema modeling with facts and dimensions)
  • Well versed in the following data domains: Master Data, Operational Data, Analytical Data, Unstructured Data, and Metadata
  • Ability to influence business and IT in order to align to an Enterprise Big Data Roadmap
  • Ability to architect scalable infrastructure and platform to collect and process very large amount of structured and unstructured data
  • Expert knowledge around designing and leading Enterprise Data Warehouse, data mart, and BI solutions
  • Solid understanding of Data Structures, Algorithms & Object-Oriented design concepts
  • Proficiency with relational database / SQL development
  • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation
  • Practical experience with the data modeling (dimensional, relational, star schema’s, snowflake schema modeling with facts and dimensions)
  • Experience and detailed knowledge of application integration technologies such as ESB's and SOA
  • Experience and detailed knowledge of integrating and aggregating large data sets into high-volume data warehouse applications using highly-varied and high-velocity data collection systems
  • Experience and working knowledge with schedulers, workload management, availability, scalability and distributed data platforms
  • Experience and working knowledge with agile/scrum methodologies to iterate quickly on product changes, developing user stories and working through backlogs
  • Experience in technical product road map creation and implementation
  • Experience with High performance computing, in-memory DB, caching optimization, compression techniques, cluster management, etc.
  • Experience with Agile development teams and good inter-personal skills
  • Ability to provide leadership and mentorship to developers and testers
  • Excellent communication skills
  • Ability to integrate research and best practices into problem avoidance and continuous improvement
  • Exercise independent judgment in methods, techniques and evaluation criteria for obtaining results
  • Customer service and solution oriented
  • Extremely knowledgeable of industry standards and trends
  • Ability to demonstrate analytical and problem solving skills
  • Hands on experience with data profiling tools and processes
  • Expert knowledge of normalized and dimensional modeling techniques
  • Knowledge of cloud computing infrastructure (e.g. AWS, Elastic MapReduce)
  • Knowledge of different technologies making up the BI & OLTP stack.
  • Experience in Netezza /green plum data warehouse appliance technologies
  • Experienced in implementing 5 projects involving OBIEE 11g with OBIEE APPS Answers, Interactive Dashboard, and Reporting
  • Strong Techno-Functional expertise in OBIEE and Oracle BI Apps/OBIA
  • Hands on experience working with range of enterprise source systems includes Oracle EBS/PeopleSoft/Siebel CRM/JD Edwards
  • Experienced working with Siebel Analytics- OBIEE, Business Objects, Cognos, Micro strategy, SAS and many BI tools
  • Experienced working with Informatica/DAC and many other data integration tools
  • Exposed to and understanding of Web Services design and engineering (JAVA, SOAP, WSDL, XSD, XML)
  • Experienced in Oracle’s highly integrated and highly scalable set of Business Intelligence (BI) and Enterprise Performance Management (EPM) solutions
  • Completed 5 full scale life cycle DW implementations
  • Expert in Data Architecture, Logical and Physical Data Modeling, Data Warehousing, Data Marts/OLAP, MOLAP, DOLAP, HOLAP, Data Mining, and Decision Support Systems
  • Experienced with IAA enterprise canonical model
  • Proficient in conducting comprehensive, effective, and efficient systems development covering the full system Development Life Cycle based on extensive knowledge of Information Technology and Business Processing and Reengineering methodologies, techniques and programming
  • Successfully performed engagements for clients in a broad range of industries, including Food, retail, telecommunication, insurance, financial Services, operation, costing, banking, distribution and government

TECHNICAL SKILLS:

Hadoop: Apache Hadoop, Cloudera, Hortonworks, Hive, Pig, HCatalog, YARN, Tez, Oozie, HBase, Mahout (Taste), RHadoop, Sqoop, Flume, ZooKeeper, MRUnit, Storm, Spark, Datameer, Karmasphere

NoSQL: Bigtable, Cassandra (DataStax), HBase, MongoDB, Couchbase, Aerospike

Graph: Property Graph, Neo4j, OrientDB, Netflix-Graph, Titan, Faunus, Giraph, Hama, GraphChi, GraphLab

SQL on Hadoop: Apache Drill, Hortonworks Stinger, Cloudera Impala, RainStor, Greenplum HD, Pivotal HD, HAWQ

Social Media: Facebook API, Twitter Firehose, Gnip, DataSift

Search: Lucene, Solr, ElasticSearch, OpenStack, MongoDB, JAVA, SQL/NoSQL, XML languages

Databases/ appliances/workbench: Netezza/Aginity Workbench, Greenplum/PostGreSQL, Vertica, Teradata, MSql server, MySQL, Oracle, DB2, Informix, Sybase

BI Frontend Tools/Apps: Tablaeu, OBIEE/Apps, MicroStrategy, Business Objects Suites, Cognos suites, Qlikview Carda, Hyperion

Data Mining: SAS, IBM INTELLIGENT MINER

MDM: Informatica 9.7.1, IBM (InfoSphere MDM), Oracle (Siebel UCM)

Data Integration/SOA/ETL/ELT: Informatica, Oracle warehouse Builder, DataStage, AbInitio, ODI, REST, SOAP

Data Modeling: Er/win, Embarcadero, Sbase

Languages: C, C++, J2EE, JAVA, XML, HTML, Visual C++, COBOL, RPG

Operating Systems: Linux, Unix, Talend, Windows

Methodologies: SDLC, Rally Agile, Kimbell, Inmon, SI Methods, BI Methods, Microscope, Object Oriented Analysis, design and programming (BOOCH) structured analysis, design and programming (Youdon), Teradata Solutions

EXPERIENCE SUMMARY:

MDM Consultant/ Big data//BI Solution Architect

Confidential, Eagan, MN

Responsibilities:

  • Architecting and Building Big Data Platform using Hadoop ecosystem.
  • Evaluating, recommending and building NoSQL, SQL and InMemory platform(s) understanding the business needs.
  • Technical/Functional Design for Informactica MDM 9.7.1 implementation along with Data Quality/de-duplication
  • Responsible for GAP Analysis to help identify current and proposed structure of MDM system.
  • Managed MDM Technical and Data Governance teams along with activities for integrating data while managing and enhancing quality on Informatica MDM platform.
  • Managed data through RDM ( data management) for avoiding complexity in MDM
  • Architecting and building data collectors and data fabric to collect and transport data to the Hadoop ecosystem based Big Data Platform, and designing applicable interface for APPs
  • Building monitoring solution(s) for the analyzing and modeling the incoming big data.
  • Providing solid technical and management leadership for a team
  • Providing technical direction in a team that designs and develops path breaking large-scale cluster data processing systems.
  • Designing strategies and detailing approaches to integrate Hadoop with existing applications, including but not limited to Oracle, DB2 and Enterprise Data Warehouse and Data Mart applications.
  • Helping to develop strategies that maximize thevalue of their data.

Environment: Informatica, Informatica MDM 9.7.1, Hadoop Eco system projects, HDFS, Flume, Sqoop, WebHDFS, Pig, Hive, Hbase, Accumulo, Solr, Yarn, Oozie, zookeeper, Avro, Parquet, Mahout, Storm, Cassandra, CFS, etc.. etc.

MDM Solutions architect

Confidential, FL

Responsibilities:

  • Gathered requirements and developed specifications towards complete solution
  • Collaborated with Business Analysts to define high level and detailed requirements
  • Deployed new MDM Hub for WM SITEs in conjunction with user interface on Informatica BDD application.
  • Led effort for gathering business requirements for the MDM, data-warehouse as well as business-intelligence reports to be used by the senior management
  • Designed, developed and architected EDW/Data Virtual Mart solutions in Netezza Environment.
  • Designed architecture and strategy roadmap to implement Informatica MDM as enterprise solution
  • Heavily involved in analytical and designing with the ability to translate users
  • Worked on Proof of concept and prototyped activities to assess whether the proposed architecture and components meet the non-functional requirements; reliability, performance and maintainability
  • Engaged in activities like the Netezza data warehouse appliance, data warehousing, working with very large data sets and SQL
  • Worked with business units to troubleshoots difficult database problems, including slow running queries and resource contention.
  • Provided knowledge transfer to a designated employees.
  • Worked on improving company’s products to meet industry standards and Client’s needs.
  • Implemented succefully a high level architecture designed Virtual data mart.

Environment: Informatica,, Oracle/MS SQL Server/My SQL/Netezza appliances, tableau BI tool, Business Objects, Embarcadero data modeling tools, etc.

MDM SOLUTION ARCHITECT

Confidential, MN

Responsibilities:

  • Establishing all architecture processes and lead routines to implement the processes, principles, Standards, policies and practices for Aginity architecture model.
  • Defined a multi-phase multi-year MDM rollout strategy with business value delivery with each iteration
  • Defined Architectural Vision and Implementation pattern and selection of fit for purpose implementation patterns
  • Designed Solution Architecture leveraging Informatica MDM and Propose and institutionalize principles of MDM data model lifecycle management that will ensure best standards for data quality management
  • Leading and mentor the efforts of data quality completeness initiative for Informatica based ETL architecture.
  • Lead the core team, that will be accountable for the principles, processes, standards and ensure routines and outcomes are followed and executed in a timely manner.
  • Serving as a primary liaison for the business/technology of Best Buy, inc. to interface on architectural governance routines.
  • Driving complex and comprehensive business architectures and relates those structures to the technology data environment.
  • Providing critical alignment between Technology and Business processes. Ensuring Data is sourced from one that comprehensively addresses multiple business processes.
  • Ensuring critical alignment to Enterprise data standards Quality, Metadata, Linkage, data, Provisioning strategy etc.
  • Responsible of Netezza appliances/Architecturing/Data Modeling/NZSQL & XML Scripting/Analyzing & optimizing Query Performance/NZ Event and Event Processing/materializing views
  • Responsible of BI Reporting/Analytics from Netezza Appliances hands-on experienced with Informatica MDM 9.7.1 Hub configurations

Environment: Informatica, Informatica MDM, Netezza 1000, Aginity Workbench, Linux, Informatica (8.6.1), Maestro (8.1.5) Teradata Utilities (TPT), Dimensional modeling / Nzsql, Nzload and SPROC is using to populate the data.

GreenPlum Architect

Confidential, Princeton, NJ

Responsibilities:

  • Developed in PostGreSQL/RDBMS with PostGreSQL Database Concepts
  • Design of the Database
  • Querying
  • Functions
  • Table Partitioning
  • Table Inheritance
  • Performance Tuning
  • Used pgAdmin GUI and psql command line tools.
  • PostGres database monitoring

Environment: OBIEE 11.5.5/ Green Plum database appliances/PgAdmin/Unix/Windows

SOLUTION ARCHITECT

Confidential, O’Fallon, MO

Responsibilities:

  • Integrated OBIA 7.9.6 with Contact Center Telephony Analytics, Service Analytics and marketing.
  • Utilized OBIA Architecture& OBIA suite( Oracle Database, Informatica, DAC,OBIEE)
  • Gathered/analyzed and translated requirements from the business user and created reports mock ups/functional requirements.
  • Designed the ETL source flow to maximize parallelism while loading into MDM database
  • Completed Architecture, Data modeled, Designed and POCs
  • Had very clear understanding of data access requirements, including transactional data, business query, and analytics.
  • Used Siebel Analytics/OBIEE repository (Physical, Business Model and Mapping and Presentation layers)
  • Developed Oracle BIEE Metadata repository( rpd) model using aggregates, dimensions, hierarchies & time series functions
  • Designed and Developed Informatica Mappings to load the MDM Party and Product Model.
  • Implemented the MD5 algorithm in Informatica to compensate lack of keys in target tables.
  • Customized reports with OBIEE Answers and integrated them into the Dashboards
  • Created highly interactive dashboards for accessing business intelligence and applications content.
  • Produced creative solutions to complex requests
  • Designed complex reports (pivot tables, drill-downs, report navigation, complex formulas, Go URLs, etc.)
  • Delivered reports in OBIEE against an Oracle Siebel CRM and/or Case Management source system (e.g. leveraging the OBIA Case Management Analytics delivered STAR). Used data modeling skills (i.e. conceptual, logical and physical model design, Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling).
  • Develop requisite business case to acquire business buy-in, and necessary project funding of Enterprise-wide MDM
  • Setup BI Delivers for Scheduling jobs.
  • Defined the roles and security levels within OBIEE that allows for the appropriate separation of duties and integrated with Siebel Web to have Single Sign on Security. Always maintain security best practices and standards in assigned areas of responsibilities.
  • Guided the development of test scripts to validate that requirements have been met & established and maintained requirements traceability throughout the lifecycle of an implementation project.- Case management and/or contact center processes/best practices
  • Managed the Project with Project Management skills using Microsoft Project Plan and estimation techniques.
  • Managed onsite & offshore delivery model.

Environment: OBIEE 10.1.3/ Informatica /DAC (ETL), Oracle 11g, OBIA 7.9.6 with Contact Center Telephony Analytics, Service Analytics, Market Targeting Analytics, etc.

Architect

Confidential, Phoenix, AZ / Melville, NY

Responsibilities:

  • Participated in and led the requirement gathering /solution architecture for MDM initiatives.
  • Experience in integrating external business application with Informatica MDM hub using Batch process.
  • Responsible for defining OBIEE architecture and standards in collaboration with Enterprise Architecture
  • Responsible for establishing BI Best practices & methodology for gathering, storing, analyzing, and providing access to data to enable better business decisions,
  • Proposed areas MDM will support integrated data warehouse strategy including data quality management, business relevance, scalability, accessibility, transparency and governance in Informatica MDM and Data Quality Center
  • Responsible for OBIEE Platform roadmap/lifecycle plans and application/solution delivery (planning, design, delivery) including data profiling and data quality solutions and integration into ETL code.
  • Defined and scoped BI Capability including BI Analytics/Reporting & Ad-Hoc Query/Online Analytical Processing/ Dashboarding & Scorecarding/ Predictive Analytics/Trending & Forecasting/ full adherence to Confidential architecture and standards,
  • Developed OBIEE Repository (metadata)/Answers & Dashboards (Reporting)
  • Tuned of OBIEE solutions Confidential the reporting, metadata, database, and ETL layers and designing application security

Environment: Informatica and DAC (ETL), Oracle 11g, OBIEE 11g with Market Targeting Application. Hyperion Planning and Essbase..

Solution Architect

Confidential, FL/IL

Responsibilities:

  • As a lead architect,and substantial experience with big data solution have in-depth knowledge of NSSQl, NZLoad, NZSQL and NZ PL/SQL
  • Collaborated with Business Analysts to define high level and detailed requirements
  • Gathered requirements and developed specifications towards complete solution
  • Developed high level design and working with developers, project managers, and business experts
  • Performing code reviews and provide assistance in customizing the product
  • Working on improving company’s products to meet industry standards and Client’s needs.
  • Worked on Proof of concept and prototyped activities to assess whether the proposed architecture and components meet the non-functional requirements; reliability, performance and maintainability
  • Estimation of work efforts for projects
  • Works with the key business representatives, data owners, end users, application designers and data architect to model the MDM data and Data Governance.

Environment: Composite /Netezza/ Datastage/Oracle/ XML structures and UNIX shell scripting/SQL/PLSQL

OBIEE Architect

Confidential, Bentonville, AR

Responsibilities:

  • Gathered business requirements, documented the reporting and analysis specifications, designed technical architecture, installed and configured all components of OBIEE 11g, implemented the metadata layers including physical, semantic, and presentation layers and generated reports and dashboards using various OBIEE components.
  • Drived business and process team members through the process of understanding and uncovering business needs/intent and reporting requirements
  • Designed and developed logical and physical data modeling, mapping data elements from Oracle 11g and teradata data sources and loaded DW objects including dimensions, hierarchies, fact tables, and aggregates, building the RPD, as well as the building the reports
  • Architected and delivered Business Intelligence, Performance Score Card across Walmart Pharmacy.
  • Represented the walmart by providing solutions to difficult technical problems associated with specific projects.
  • Mentored OBIEE tools with team such as BI Answers and BI Publisher. Works closely with technical shared service teams to deliver solution in line with corporate IT standards
  • Configured dashboards and report security with strong technical knowledge of Oracle/Siebel Analytics architecture and Admin Tools.
  • Defined Reporting Strategy and made it happens. Interacted with Pharmacy business users to define, analyze, and deliver customer requirements
  • Configured OBIEE security and integrated with Active Directory identity management systems
  • Used Oracle BI Server architecture and metadata management strategy.
  • Participated in MDM design reviews including Data Governance.

Environment: Teradata, Oracle 11g, Qlikview for proto-typing, Informatica 8/DAC for ETL, Netezza and OBIEE with Pharmaceutical and Financial Analytics applications. Hyperion Planning and Essbase.

ETL Architect

Confidential, Plano, TX

Responsibilities:

  • Our solution approach provided the basis for recommendations and provided guidelines to manage business criticality, technology constraints and the architectural aspect of the solution.
  • Defined specification for ensuring audits, balance, and controls between the source system of record and the eCDW (Enterprise Consolidated Data Warehouse).
  • Developed data monitoring techniques for data quality
  • Defined the project’s data quality requirements captured from the project team
  • Evaluate the existing data management solutions impacting the project for effectiveness
  • Identified any existing data management gaps and issues risking project and existing eCDW data assets
  • Recommend actions to the project team.
  • Responsible for managing the monitoring and reporting on the data defects identified through the data quality controls implemented using various data quality monitoring techniques for the Business and IT stakeholders.
  • Applied best practices with Enterprise Data warehouse, Data Integration (ODIEE) and Master Data Management (MDM)/Data Governance.

Environment: ETL tool - Informatica, Databases - Teradata, Oracle and MS SQL Server, data model - Erwin.

Data Warehouse Solution Architect

Confidential, Houston, TX

Responsibilities:

  • Reviewing the design as one final review for the RAF Phase II data warehouse architecture under data warehousing guidelines.
  • Responsible for Creating Confidential ’ enterprise wide view of the data sourced from the RAF Phase II data warehouse, with the goal of leveraging a common single data model / data warehouse for global use.
  • Responsible for leading the initiation and delivery of a Master Data Management(MDM)/Data Governance functional process and technical solution across the enterprise.
  • Responsible for translating user requirements into technical architecture vision and recommend solution.
  • Develop and maintain all standards pursuant to data structures and models.
  • Develop and optimize operational data structures / schemas through use of best practice methodologies in data design, conceptual and logical modeling.
  • Responsible in performance tuning heavy queries and optimizing Informatica PowerCenter workflows.
  • Responsible for validating the design which provide operational continuity, Scalability, and extensibility for next 10 years.
  • Exposed to New emerging technology ‘information fabric,’ defined as a virtualized data layer that integrates heterogeneous data and content repositories in real time

Environment: ODS in 3NF and DW is in de-normalized data structure using ORACLE 11g, Informatica Power Center, Netezza, ODIEE, etc. etc.

OBIEE Architect

Confidential, Tyler, TX

Responsibilities:

  • Architected and delivered Business Intelligence, Siebel Analytics, and Performance Management solutions across the enterprise.
  • Business Intelligence Architect who implemented Oracle Business Intelligence Enterprise Edition (OBIEE version 10.1.3.4) components in a standalone configuration.
  • Designed and delivered business and technology solutions within a complex environment like Admission and Recruiting, Campus Solutions, Students Financial Aids, Students Records and CRM that helped UT, Tyler gain competitive advantage and evolved into high performance.
  • Gathered business requirements, documented the reporting and analysis specifications, designed technical architecture, installed and configured all components of OBIEE, implemented the metadata layers including physical, semantic, and presentation layers and generated reports and dashboards using various OBIEE components.
  • Configured dashboards and report security with strong technical knowledge of Oracle/Siebel Analytics architecture and Admin Tools.
  • Designed and developed logical and physical data modeling, mapping data elements from Oracle 10g and Microsoft server 7.0 data sources and loaded DW objects including dimensions, hierarchies, fact tables, and aggregates, building the Reporting Metadata layer, as well as the building the reports
  • Integrated to third party security frameworks with LDAP
  • Used Oracle BI Server architecture and metadata management strategy.

Environment: Qlickview for proto-typing, Informatica/DAC, OBIEE and Oracle BI Apps/OBIA with Financial/Human resources/Procurement and Spend Analytics.

OBIEE Architect

Confidential, Pittsburgh, PA

Responsibilities:

  • Responsible for designing, implementing and tuning the OBIEE/ Siebel technical infrastructure including answers for one of the fortune 400 bank.
  • Extensive experience creating KPI’s and dashboards for financial application.
  • Reviewed functional requirements and specification documents; interviewed end users to refine requirements.
  • Researched source data locations to validate requirements.
  • Performed the task designing, developing, and managing reporting/BI solutions to meet business needs.
  • Developed standards and techniques to support reporting and advanced drill down capabilities.
  • Served as a technical resource for other members of the development team in ensuring data processing standards, guidelines and procedures are practiced.
  • Used predictive modeling to finely segment Confidential customers and make real-time decisions about promotions, pricing, fraud and other applications.
  • The total round-trip can take hours, dominated by the latency of large data transfers.
  • This entire process can now be done within the Netezza appliance, in a fraction of the previous time, enabling real-time offers and promotions to the right customers.
  • Participated in MDM and Data Governance design reviews.

Environment: Qlickview for proto-typing, Informatica/DAC, Netezza and OBIEE/Oracle BI Apps/OBIA with Financial/Service/Procurement and Spend Analytics. Hyperion Financial Planning.

Hire Now