Summary:

A Big Data/Data Warehouse/Business Intelligence Enterprise Architect/Solution Architect/Data Architect who is passionate about data and focused on building next generation Big Data 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.

• 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 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:

Languages Tools:

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 Social Media: Facebook API, Twitter Firehose, Gnip, DataSift Search: Lucene, Solr, ElasticSearch OpenStack, MongoDB, JAVA, SQL/NoSQL, XML languages Design patterns, framework design, data modeling, data structure, SOA Architecture REST, SOAP etc . Enterprise data Integration, data Processing, ELT/ETL, data Science and Predictive systems. Aginity workbench, , OBIEE 11g with OBIEE APPS Siebel Analytics, Contact Center Telephony Analytics, Service Analytics, Marketing and Financial Analytics, Market targeting, etc., Informatica, DAC, BI Servers, BI Delivers, ODIEE, Master Data Management, EPM, SOA Design patterns, ESB, BPM, Registry, BAM, WSM, Orchestration, SOAP, WSDL, XSD, XML, Qlikview, OBAW, Load Runner, Carda, Talend, Micro Strategy 8, NETEZZA, RALLY Agile Software, Green plum, Vertica, Sap BW ORACLE 11g, SIEBEL ANALYTICS, , , WEB DB, DB2, DB2 UDB, TERADATA INFORMIX, SYBASE, MS QL SERVER, MySQL, COGNOS SUITE, VALITY, DSS AGENT Microstrategy , MY EUREKA Information Advantage , BRIO, HYPERION PLANNING/ESSBASE, BUSINESS OBJECTS SUITE, BO XI, BO DI, DECISION BASE platinum metadata management , PRISM, PLATINUM, DPROP, SAS, CARLETON, VISUAL WAREHOUSE, ETI, PowerCenter 8, IBM DATA GUIDE, DSS ARCHITECT, IBM INTELLIGENT MINER, DARWIN, SIEBEL, ONYX, CLARIFY, SALESLOGIX, Microsoft technologies, C , J2EE, COM/CORBA, HTML, BROADVISION, WEB-RELATED PROGRAMMING VISUAL BASIC AND VISUAL C , S-DESIGNER, COBOL, RPG 400, EDI, CICS, CSP, GENER/OL, FAVER/XP, PANVALET/PANAPT, ER/WIN/Embarcadero data modeling tool, VISIO, DB2 CONNECT, ODBC, SQL/NET AND MQ Series, Red Hat Linux, Relational data Architecture RDA , DataStage, GREENPLUM Appliances / PostGreSQL etc. etc. etc. and many more .

• Hardware: WINDOWS NT, SUN SEQUENT, S/390, ES 9000, AS/400, IBM 3090, IBM 4381, UNISYS A-SERIES, IBM SYS 3X, HP9000 and SP2, IBM AIX
• Methodologies: KIMBELL, INMON, SI METHODS, BI METHODS, MICROSCOPE, OBJECT ORIENTED ANALYSIS, DESIGN AND PROGRAMMING BOOCH STRUCTURED ANALYSIS, DESIGN AND PROGRAMMING YOUDON , TERADATA SOLUTIONS

Experience Summary

Data Warehouse

• 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.
• Providing technical direction in a team that designs and develops path breaking large-scale cluster data processing systems.
• Providing solid technical and management leadership for a team
• Building monitoring solution s for the analyzing and modeling the incoming big data.
• 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
• Evaluating, recommending and building NoSQL, SQL and InMemory platform s understanding the business needs.
• Architecting and Building Big Data Platform using Hadoop ecosystem.
• As a Big data architect, Architecting and building Hadoop, NoSql, InMemory Platforms and data collectors. Team
• building one of the largest Big data platform that can ingest 100's of Terabytes of data that will be consumed
• for Business Analytics, Text Analytics, Data Services and build open platform Solutions.
• Helping to develop strategies that maximize the value of their data.

SOLUTION ARCHITECT

Confidential

• Gathered requirements and developed specifications towards complete solution
• Collaborated with Business Analysts to define high level and detailed requirements
• Designed, developed and architected EDW/Data Virtual Mart solutions in Netezza Environment. Company Overview

find more jobs with this company

• 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.

Wipro Technologies

The overall goal of Customer Analytics Master is to construct a consumer analytics warehouse that acts as a sandbox for modeling and analytics. Key Requirements - Database containing best available customer, sales, demographic and marketing data - Customer / Consumer centric data model to facilitate analytics - Flexible data model capable of multiple hierarchies, dimensional views and POS level granularity - System capable of handling demanding analytical queries and able to quickly return results - Ability to have user defined personal schemas - Ability to have user defined shared schemas -Predefined views shared amongst user groups -Ability to run SAS against views - Ability to import external data sources into user defined personal and shared schemas - Ability to use the Aginity workbench, MS Excel and other tools via ODBC including SAS - Minimum of 7 years of data in the warehouse

• Establishing all architecture processes and lead routines to implement the processes, principles, Standards, policies and practices for Aginity architecture model.
• 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, 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 Hub configurations

Environment: 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.

Confidential

• Assisted with design and decision making on Scorecard Marketing project. This system targets diabetes patients for Insulin. Developed dashboards and Ad-hoc reports in OBIEE 11g using greenplum database appliances. Provided substantial design guidance.
• 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

Confidential

The MasterCard Assistance Center MAC 2.0 project is a technical effort to design, develop and deploy a customer service platform that can be used to service MasterCard programs globally. MasterCard is now pursuing a global expansion of their cardholder services to improve multilingual support. The RDC Regional Delivery Center project will expand the MAC 2.0 infrastructure to support a global service model that will allow MasterCard to extend the MAC 2.0 platform to multiple call centers. The RDC project will accomplish the following business objectives: 1. Simplifying the Interactive Voice Response IVR system prompts in the emergency services path.2. Clarifying IVR customer guidance scripts and options. 3. Ability to identify and route a call from the IVR to the call center most capable of handling the cardholder's request based on established criteria. 4. Providing additional menus for cardholder services in additional languages from 7 to 16 available languages.

• Created a central repository of MAC 2.0 data to generate reports from source systems a. CMS/ACD b. IVR c. Siebel d. Billing Systems e. CHS. The reporting system have the ability to generate user-defined and standard operational and analytical reports.
• 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.
• 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
• 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 .
• 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.

OBIEE Architect

• The Oracle Business Intelligence OBIEE Solution Architect worked in the Enterprise Applications COE.
• Tuned of OBIEE solutions at the reporting, metadata, database, and ETL layers and designing application security
• Developed OBIEE Repository metadata /Answers Dashboards Reporting
• Defined and scoped BI Capability including BI Analytics/Reporting Ad-Hoc Query/Online Analytical Processing/ Dashboarding Scorecarding/ Predictive Analytics/Trending Forecasting/ full adherence to Arrow Electronics architecture and standards,
• 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.
• Responsible for establishing BI Best practices methodology for gathering, storing, analyzing, and providing access to data to enable better business decisions,
• Responsible for defining OBIEE architecture and standards in collaboration with Enterprise Architecture
• 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.

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

Netezza architect. Designing developing and architecting BI/DW solutions with Netezza. Company Overview

find more jobs with this company

• 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

• 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

• 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

• Reviewing the design as one final review for the RAF Phase II data warehouse architecture under data warehousing guidelines.
• Responsible for Creating Shell Trading' 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,

• 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,

• Reviewed functional requirements and specification documents interviewed end users to refine requirements.
• Extensive experience creating KPI's and dashboards for financial application.
• for one of the fortune 400 bank.
• Responsible for designing, implementing and tuning the OBIEE/ Siebel technical infrastructure including answers
• 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 PNC 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.

Data Warehouse

• Participated in enterprise DW / BI strategy assignment.
• Provided guidance in defining and implementing specification.
• Responsible for the Architectural Design of the Data Warehouse.
• Reviewed the business needs and recommended an appropriate design to support the needs of the business and technology units.
• Facilitated broad stakeholder groups in gaining concensus on data access, analysis, trending, reporting needs and to managed the efficient performance of the system in support of the business users.
• The BI and EPM solutions from Oracle have solved critical problems and created tremendous opportunities. Data consistency has been an issue.
• Provided Solution with end-to-end analysis with OBIEE.
• Experienced in pre-built Siebel RPD METADATA process for OBIEE.
• Experienced in pre-built OBIEE dashboard.
• Coordinate security protocols and Established and manages OBIEE system security
• Participated in MDM design/Data Governance reviews.