SUMMARY

• A Big Data 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 teh business objectives and drive solutions dat efficiently meet teh needs of teh 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 - TEMPeffectiveness.
• Very solution oriented and always focus on using these emerging technologies to solve real world problems and achieve teh 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 architecture, Map Reduce, HDFS, Hive, Pig, HBase, Zookeeper, Sqoop, Oozie, Flume, Scala, Akka, Kafka, Storm, Mongo DB
• Ability to influence business and IT in order to align to an Enterprise Big Data Roadmap with Analytics reference architecture technologies
• Hands-on experience in designing and implementing solutions usingHadoop, MapReduce, HBase, Hive, Oozie,
• Having Knowledge to implementHortonworks,ClouderaandMapRon Linux.
• Strong skills dealing with Informatica Reference data management(RDM) and Hierarchy Manager.
• Experienced in design, drive development and implementation of selected components of teh Vertica Analytic Platform
• Experience in Performance Tuning in Vertica which includes creation of projection, partition swapping.
• Experience in Enterprise Data Mart and Operational Data Mart in HP Vertica
• 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 dat supports large-scale analytics
• Do have deep understanding of teh ‘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
• Having good exposure on entity 360 in informatica MDM.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation
• Practical experience with teh data modeling (dimensional, relational, star schema’s, snowflake schema modeling with facts and dimensions)
• Informatica MDM 10.2 and later - teh MDM conceptual, system, technical, and system architectures, and in some instances teh 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) dat best fit teh business and IT strategic needs.
• NoSQL databases, ETL/ELT, MDM $ BI Tools and also with Netezza/ greenplum data warehouse appliance technologies
• Well versed in teh following data domains: Master Data, Operational Data, Analytical Data, Unstructured Data, and Metadata
• 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 teh 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 teh 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, TEMPeffective, and efficient systems development covering teh 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

Clouds: AWS

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 6, Teradata, MSql server, MySQL, Oracle, DB2, Informix, Sybase

BI Front-end 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

PROFESSIONAL EXPERIENCE

Big Data Architect and Principal Consultant

Confidential

Responsibilities:

• PrincipalSolutionsArchitectresponsible or ModernDataArchitecture, Hadoop,Bigdata,dataand BI requirements and defining teh strategy, technical architecture, implementation plan, management and delivery ofBigDataapplications and solutions.
• Provide technical thought leadership onBigDatastrategy, adoption, architecture and design, as well asdataengineering and modeling.
• Expertise in identify teh product road map and product management activities.
• Provide expert level guidance onBigDatabest practices and standards.
• Work with product owners, business SME anddataingestion and reportingarchitectsto identify requirements and consolidate enterprisedatamodel consistent with business processes.
• Prioritize and scale architecture efforts in close coordination with business teams,DataLake operational team, and other stakeholders.
• Ensure dat all measures fordataquality,datagovernance, security and compliance ofdataare adhered to
• Define and implement standards and best practices fordataingestion, analytics, and integration.
• Lead and evaluate emerging technology, industry and market trends to assist in project development and/or operational support activities
• Prioritize and scale architecture efforts in close coordination with business teams,DataLake operational team, and other stakeholders.
• 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 (reference data management) for avoiding complexity in MDM.
• Involved in Informatica issue resolution, folder migration, Administration and served as teh first line of support internally for any Informatica issues raised by teh project teams
• Architecting and building data collectors and data fabric to collect and transport data to teh Hadoop ecosystem based Big Data Platform, and designing applicable interface for APPs
• Building monitoring solution(s) for teh analyzing and modeling teh incoming big data.
• Data Centers active equipment networking, computing, storage, virtualization and migration.
• Designing cloud infrastructure, planning and testing new solutions, managing physical and cloud infrastructure, efficiency to work under pressure in critical situations and other in teh areas of Linux.
• Install, configure, VPN Direct Connections from IO Datacenter to AWS.
• Providing solid technical and management leadership for a team
• Providing technical direction in a team dat 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 dat maximize thevalue of their data.
• Vertica database architecture (column orientation, compression, projections, segmentations, partitions, high availability and recovery, security)
• Code review and Vertica Best Practices suggestions
• Design/Build teh Development/Testing/Production Environment and configuration EDW Database in Vertica

Environment: ApacheSpark, Apache Zookeper, Apache Flume Horton Works Hadoop/HBase 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, Vertica 6, 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 teh MDM, data-warehouse as well as business-intelligence reports to be used by teh 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 teh ability to translate users
• Worked on Proof of concept and prototyped activities to assess whether teh proposed architecture and components meet teh non-functional requirements; reliability, performance and maintainability
• Engaged in activities like teh 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.
• Involved in folders migration between environments to follow SDLC.
• 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, Informatica PowerCenter 7/8/9 Oracle/MS SQL Server/MySQL/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 teh 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 dat will ensure best standards for data quality management
• Leading and mentor teh efforts of data quality completeness initiative for Informatica based ETL architecture.
• Lead teh core team, dat will be accountable for teh principles, processes, standards and ensure routines and outcomes are followed and executed in a timely manner.
• Serving as a primary liaison for teh business/technology of Confidential, inc. to interface on architectural governance routines.
• Involved in Informatica issue resolution, folder migration and administration and served as teh second line of support internally for any Informatica issues escalated by project teams.
• Driving complex and comprehensive business architectures and relates those structures to teh technology data environment.
• Responsible for planning, installing, and supporting AWS infrastructure.
• Providing critical alignment between Technology and Business processes. Ensuring Data is sourced from one dat comprehensively addresses multiple business processes.
• Ensuring critical alignment to Enterprise data standards Quality, Metadata, Linkage, Reference 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, ETL/Informatica Power Center 6.4.1, Informatica (8.6.1), Maestro (8.1.5) Teradata Utilities (TPT), Dimensional modeling / Nzsql, Nzload and SPROC is using to populate teh data.

GreenPlum Architect

Confidential, Princeton, NJ

Responsibilities:

• Developed in PostGreSQL/RDBMS with PostGreSQL Database Concepts
• Design of teh 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 teh business user and created reports mock ups/functional requirements.
• Designed teh 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.
• Installing Connections from Datacenter to AWS.
• 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 teh MDM Party and Product Model.
• Build scripts for MySQL database with buckets for RDS migrations.
• Implemented teh MD5 algorithm in Informatica to compensate lack of keys in target tables.
• Customized reports with OBIEE Answers and integrated them into teh 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 teh OBIA Case Management Analytics delivered STAR). Used data modeling skills (me.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 teh roles and security levels within OBIEE dat allows for teh 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 teh development of test scripts to validate dat requirements have been met & established and maintained requirements traceability throughout teh lifecycle of an implementation project. - Case management and/or contact center processes/best practices.
• Managed teh 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

Responsibilities:

• Teh Oracle Business Intelligence (OBIEE) Solution Architect worked in teh Enterprise Applications COE.
• Participated in and led teh 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,
• Involved in folders migration between environments to follow SDLC.
• Developed OBIEE Repository (metadata)/Answers & Dashboards (Reporting)
• Tuned of OBIEE solutions at teh 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 teh 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 teh proposed architecture and components meet teh non-functional requirements; reliability, performance and maintainability.
• Involved in Informatica issue resolution, folder migration and administration and served as teh second line of support internally for any Informatica issues escalated by project teams.
• Estimation of work efforts for projects
• Works with teh key business representatives, data owners, end users, application designers and data architect to model teh 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 teh reporting and analysis specifications, designed technical architecture, installed and configured all components of OBIEE 11g, implemented teh metadata layers including physical, semantic, and presentation layers and generated reports and dashboards using various OBIEE components.
• Drived business and process team members through teh 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 teh RPD, as well as teh building teh reports
• Architected and delivered Business Intelligence, Performance Score Card across Walmart Pharmacy.
• Represented teh 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.