SUMMARY:

• 17+ years of Business Intelligence Solution Architect/Technical Manager experience with full life - cycle implementation of Enterprise level Data warehousing, Business intelligence, BigData, Cloud BI and Data Analytics applications
• Experience in Healthcare, Public Sector, State Govt, Insurance, Energy, Utilities, Retail and analytics.
• Extensive implementation experience in DW/BI, Cloud Computing, Big Data, and Data Analytics using multiple commercial and open-source stacks.
• Hands on Experience in Influencing and driving the Customers in implementing BI and BigData solutions
• Experience in implementing the self-service- Modern BI roadmap including Assessment, Capacity Planning Architecture, Installation, Design, Development, Deployment, Performance and end-user Training.
• Implemented End to End Oracle BI Solutions at Enterprise Level for Various Clients in different domains
• Hands-on experience in implementing Big Data analytics using Hadoop, Hadoop eco system, Pig, Hive, Hue, MongoDB, NoSQL,FLUME,Spark, R Programming, python, Pentaho, Splunk, MongoDB, Cassandra, Amazon Cloud Solutions, Cloudera, Hortonworks Environments, Datameer, OBIEE11g, OBIA 7.9.6, Tableau, EPM, and other Data Integration & Visualization tools.
• Implemented Financial, Supply Chain & Order management, Procurement & Spend, Human Resources Analytics and Global sales analytics using OBIA 7.9.6.x and OBIEE 11g, DAC.
• Expertise in Requirement Analysis, Performance Management, Enterprise Architecture and Data Modeling.
• Ability to work with cross-functional teams to convert business challenges into requirements/BI solutions.
• Worked in various decision making and execution roles such as: Technical Project Manager, Mentor, Advisor, Leader/Architect and Data Scientist.
• Experience in providing Enterprise Reporting Architecture Solutions to several Public Sector and Healthcare customers.
• Experience in enabling executive decision making on Big Data and BI Investments through implementation of BI/Big Data Use Cases using various technologies for several Fortune 500 and other multi-billion dollar customers.
• Advanced Dimensional Modeling Skills: Star and snowflake schemas, slowly changing dimensions, mini dimensions, advance fact tables (snapshot, accumulating snapshots & fact less fact tables).
• Installations and configurations of multi-nodes fully distributed clustered Systems for Business intelligence systems.
• Expertise in OBIEE,Tableau 9.x/8.x implementations
• Designed and build Dynamic & Interactive dashboards. Delivered actionable information to business users resulting improved business processes, and meeting business goals.
• Hands on experience on evaluating tools like datameer,atscale,Jethro,tableau for BigData capabilities

AREAS OF EXPERTISE:

• Data Analytics, Data Management and Reporting.
• Implementing Modern BI architecture
• Business intelligence, Big data, Cloud BI - Solution Enterprise Architecture, Deployment, Development, Technology management
• Road Map consulting for BI and Big data and Cloud Solutions.
• Techno-Functional with Pre-Sales experience.
• Project management (Businessintelligence,bigdata and analytics )

MANAGEMENT COMPETENCIES:

• Delivery Excellence: On Time delivery within the budget with customer satisfaction and profitability through delivery.
• Build Competency on existing and emerging market / technology trends
• Provide Technical / Solution Architecture framework to business intelligence and data warehouse applications
• Act as Solution Architect to transform the client’s requirements to viable and optimum solutions
• Implementing Process automation controls benefiting both Internal & External Customers
• Experience of managing multiple customers across geographies
• Anchored as Project Manager and is instrumental in Design, Development, Testing and Deployment of all
• Complete Ownership of Service delivery pertaining to Production support and maintenance key process areas such as Incident/Change/ Problem/Operations/Availability/Escalation/Release Management.
• Primarily responsible for submitting daily/weekly/Monthly/Quarterly Status Reports and escalations if any.
• Effectively managed resources (work delegation/work reviews/periodic assessments, motivating and mentoring the team towards Quality Assurance, value add to the customer, process improvements and high customer satisfaction) and proven track record of successful completion of all assigned engagements.
• Engage End-to-End programs in complete software life cycle based on global deliver model
• Worked on different horizontals and verticals in DWH/BI space
• Good understating of various SDLC models such as V, Waterfall and Agile methodologies
• Handled team of 5 to 20 members at onshore and offshore by assigning and monitoring the task on daily basis and addressing their issues/concerns
• Handled Multiple Projects from multiple locations, handled teams from multiple locations
• Build Road map and end to end Solution Implementations on BigData and data analytics for health care clients
• Performed detailed analysis of business problems and technical environments and use this in designing the overall data lake architecture.
• Designed and recommend approaches for big data ingestion strategies from any data source or type, including use of leading third party or open source tools and their integration with overall enterprise solution
• Built Data lake for healthcare client from structured and unstructured sources
• Migrated Traditional data warehouse and DataMart’s from different sources to Hadoop Environment
• Migrated BigData Applications to Production environments
• Evaluated Traditional multiple Traditional BI Reports and BigData analytical Tools from data lake
• Designed, developed general DataMart from different Healthcare source systems to BigData environment
• Research new technologies in the big data space and how they fit into the overall direction and architecture. Apply knowledge of emerging technologies to define new solutions.
• Installations and configurations - multi-nodes fully distributed Hadoop eco system cluster, HDFS for analyzing multi format structured and unstructured data from different sources.
• Created Use cases on handling and processing the unstructured Big Data, Clinical data and Cerner data on to Hadoop, Hadoop Ecosystem.
• Created a pilot project using Sqoop to pull the raw data from unstructured data into the HDFS. Used
• PIG scripts to explore and transform the data into the structured data. Used HIVE for the data and query analysis.
• Projects implemented on handling the large amount of different data sets using Hadoop, PIG, SQoop, FLUME,Hcatalog, Hive to handle the data and loading to Stage, offloading the ETL jobs performing Historical load.
• Integration of Hadoop with Splunk and Tableau, OBIEE, R, Excel, SSRS Reports, BO.
• Guided the full lifecycle for the Big Data solution including requirements analysis, technical architecture design, solution design, solution development, testing and deployment.
• Managed deployed services across AWS. Focused on EMR/Hadoop data analysis and processing
• Excellent knowledge and Hands-on Big Data solutions in Hadoop, HortonWorks,Cloudera,

TECHNOLOGY:

ETL and Reporting Tools: Informatica 6x, 8.6.1,9.1DAC,OWB, IBM Web sphere data stage 7.5.2, 8.x,9i,ODI,GOLDENGATE11g,ALTERYX,Pentaho Tableau 7.x/8.x/9.x, OBIEE11g, Business Objects, QlikView, Splunk, Cognos, java,Streamsets,Python,Spark.

Bid Data Environment: Hadoop, NoSQL, Big Data, Cloud, Web Services, Mahout, Machine Hadoop eco system: HBase, Hive, HUE, Pig, Zoo Keeper, Oozie, Spark Horton works, Cloudera, Amazon Elastic MapReduce, EC2,S3, Flume, Sqoop,Kafka,Avaro,MapR,FLUME,Spark,python,javascript,Redshift,Apache solr, Apache Lucene,Python,R Implemented both Cloudera and Hortonworks Stack, Installation and configuration of Hadoop using Hortonworks and Cloudera

BI Applications: OBIA 7.9.6.x,Peoplesoft EPM

Databases: Oracle 11g, Teradata v12; Big Data platform, MongoDB, Oracle R12,EBS,Vertica,Cassandra,SAPHANA,DB2,Sqlserver2012,Sybase, SAPHANA

Version control tools: Harvest 8, ClearCase, Tortoise SVN,ERWIN,GitHub,Artifactory

Database development & Performance tuning: Scripting (SQL, PL/SQL), Unix, TOAD 8/9

Scripting/Programming languages: Python, R Programming, Machine Learning

Operating Systems: Windows XP/7/8, UNIX, HP-UX, AIX/Linux Red-Hat 64 bit

Project Management Tools: MS Project & Jira, Microsoft VSTS,Agile Methodologies

PROFESSIONAL EXPERIENCE:

Confidential

Sr BI and Big data Solution Enterprise Architect

Technologies: BigData Coludera stack, Python, Hadoop Ecosystem Tools, spark, SparkSql, Hive, Tableau 9.x,Bobj, Sybase, SAPHANA, Oracle, Agile Project management, Enterprise Solution architecture, MS Project

Responsibilities:

• Responsible for Implementing Modern BI and BigData Architecture for Confidential Data Platform (CDP)
• Give the End to End Road map and Solution Architecture for BigData projects.
• Moving Tradition BI applications and systems to BigData environments.
• Working with various stakeholders and providing architecture recommendations and developing target architectures.
• Responsible for providing architectural guidance in building Confidential data platform
• Responsible for Solution Delivery for 5 projects under CASC NA strategy
• Evaluated new technologies and implemented Use cases to prove the architecture
• Implementing projects under Agile Methodology

Confidential

Sr BI and Big data Solution Enterprise Architect

Technologies: BigData, Hortonworks, R, Python, Hadoop Ecosystem Tools, Tableau 9.x, Sqlserver, Db2, Sqlserver2012, Datameer, Agile Project management, Solution Architecture, spark, SparkSql, Hive, Hbase

Responsibilities:

• Completely Responsible for Implementing Modern BI and BigData Architecture for Enterprise Analytics
• Enhancing and Migrating the Traditional BI Systems to Future Modern BI (BigData Env)
• Given the Road map, Architecture, Introduced cutting edge Technologies to the new Architecture for EA dept.
• Research new technologies in the big data space and how they fit into the overall direction and architecture
• Solution Architecture presentation to C-level Executives and various stakeholders in the organizations
• Shown the Value implementing Advanced analytics and modern BI by implementing many uses cases
• Implemented Proof of concepts on BigData and Advanced Analytics to prove the Modern BI architecture value
• Taking care of Installations, configurations of Big data systems
• Architecting, Design, development and managing the solutions for Enterprise analytics Department
• Implemented Predictive analytics for Revenue Cycle management, length of stay using R, Python, and Tableau etc.
• Migrating the Current traditional BI systems and old legacy systems to BigData environment.
• Designed and implemented Data ingestion full load and incremental to the data lake and Reporting to downstream predictive analytics developed on Revenue cycle management to identify the patient pre-auth claims and denials using R,python,HIVE,Tableau
• Built Patient and Diagnosis DataMart’s in HIVE and generated reports excel,tableau,bo,SSRS and modern BigData analytical tools like datameer,atscale,kyosinshights to the Reporting capability on Data lake
• Successfully show the BI on HADOOP capabilities using most of the traditional and analytical the Reporting tools in the market
• Building General DataMart from different source like Cerner, DB2,PAMA,clinical and Epic data warehouse source to a single DataMart for appointments
• Conducted trainings to the customer on educating the BigData capabilities and tools capabilities
• Built use case on predictive analytics like claims and denials,pre-authorization, bed availability for patients

Confidential, Pondera

BI Solution Architect

Technologies: OBIEE 11.1.1.7.0 , OBIA7.9.6.4, Oracle 11g, AWS CLOUD, Salesforce.com, mainframes, unstructured data sources, EBSR12, BigData, Hortonworks, Hadoop Ecosystem Tools, Tableau 9.x

Responsibilities:

• Requirement analysis of business problems and technical environments and use this in designing the overall data lake architecture.
• Recommend approaches for big data ingestion strategies from any data source or type, including use of leading third party or open source tools and their integration with overall enterprise solution
• Research new technologies in the big data space and how they fit into the overall direction and architecture. Apply knowledge of emerging technologies to define new solutions.
• Requirement Analysis on the Enhancements of Data warehousing Environment
• Implemented POC and POT using open source stack for data visualization
• Implemented New Tableau based reporting environment, architecture and best visualization practices, upgraded existing OBIEE reporting Env and implemented box HR analytics using OBIEE and OBIApps
• Built Sandbox and data exploration data lake and analytics platform
• Worked on the Proof of Concept building Big Data analytics on Amazon cloud.
• Implemented lambda architecture using amazon stack as part of Solution study for Real-time analytics
• Build Hadoop Env as part of analytics platform for the customer to extract the data for further different sources to the downstream application for data visualization and predictive analytics analysis
• Worked with business users/ business analysts to define technical and process requirements.
• Designed developed and manage data on Hadoop cluster
• End-to-end performance tuning of Hadoop clusters and Hadoop Map/Reduce routines against very large data sets
• Monitor Hadoop cluster job performance and capacity planning
• Manage nodes on Hadoop cluster
• Hadoop cluster connectivity and security
• Conduct Hadoop cluster training

Confidential

BI Reporting Architect

Technologies: OBIEE11g, Oracle Exadata, Splunk, Cognos, BI Architecture, Hortonworks

Responsibilities:

• Designed complete Reporting solution for Enterprise data warehousing project.
• Designed conceptual, logical, and physical architecture for the Reporting solution and presented it to the C level Executives.
• Built High availability BI and Big Data clustered environments.
• Created dashboards on Data visualizations Tools using OBIEE
• Set up BI Environments, Estimations, and Capacity planning.
• Involved in building Data modelling and Data layers.
• Built Reports and Dashboards utilizing Reporting tools.
• Configured security, Active Directory integration, and usage tracking.
• Setup and configured Analytics applications.
• Built High availability BI clustered environments.
• Built OBIEE server both cluster and non-cluster environments
• Configured security, Active Directory integration, usage tracking, MUDE
• Configured Primavera Analytics applications
• Setup and configured PRIMAVERA (p6) Analytics) applications
• Migration of Congo’s Reports to OBIEE
• Implemented POC on BigData using Horton works for Data lake

Confidential

Technology Management/ Solution Architect

Technologies: OBIEE 11.1.1.7.0 , OBIA7.9.6.4, Oracle 11g, AWS CLOUD, Salesforce.com, EBSR12, Tableau

Responsibilities:

• Led Product Data Intelligence program (BI & Reporting tools work-stream) for implementation of “Business Analytics as a Service” Platform
• Worked as a Project Manager/Solution architect for the client on implementation of all BI Modules on AWS Cloud based solutions.
• Implemented New Tableau based reporting environment, architecture and best visualization practices, complementing existing OBIEE reporting infrastructure.
• Implementation of HR analytics using OBIEE and OBIApps.
• Managed offshore Team.
• Worked on the Proof of Concept building Big Data analytics on cloud.
• Worked with business users/ business analysts to define technical and process requirements.

Confidential

Technical Leader and Project Management

Technologies: ORACLE 11g, OBIEE 11g, OBIA7.9.6.3, Oracle R12, Marketing Segmentation

Responsibilities:

• Complete end to end activities of project management activities, Technical Design, Development and enhancements of the existing Confidential Application. Performed all the technical activities related END to END data warehousing Implementation.
• Created a sales dashboard for monitoring sales activities such as actual vs. projected using analysis at the product/account level. This included metrics such as: sales forecast, revenue, sell through and sales orders.
• Built an Analytical model based on deep analysis of end users for Confidential ’s marketing department. This resulted in a 60% increase of successful marketing promotions.
• Created Sales and Marketing dashboard using Tableau to manage and measure monetization efforts.
• Optimized the manufacturing process based on daily sell through data.
• Created an inventory dashboard to help the operation team with manufacturing and logistic activities.
• Managed a team of 10 members, both onsite and offsite locations.
• Other various Project Management tasks.

Confidential

Sr. Consultant and Project Management

Technologies (for entire period): ORACLE 10g/11g, Power Center 8.6.1/9.1, DAC 10.1.3.4.1 , OBIA 7.9.6.2/ 7.9.6.3 , OBIEE 10.1.3.4.1 /OBIEE 11.1.1.5 and 11.1.1.6,, Salesforce.com, EBSR11i,R12.PeopleSoft EPM, Data stage; ODI

Responsibilities:

• Analysis, requirement gathering and scope finalization.
• Making overall plan of Application design, development, testing and deployment.
• Resource, time and delivery management.
• Worked directly with client account managers, business analysts and business customers to understand current/future BI requirements, and design solutions using the OBIEE platform.
• Implementing Architecture and standards, metadata strategy, data quality strategy, ETL, Master Data Management
• Designed the ETL architecture and data flows for the new interim and global systems from R11 and R12 source systems.
• Source to Target mapping analysis. Built High availability BI clustered environments.
• Built 9 OBIEE server both cluster and non-cluster environments
• Configured security, Active Directory integration, usage tracking, MUDE
• Configured OBIAPPS and Primavera Analytics applications
• Setup and configured PRIMAVERA (p6) Analytics) applications
• Designed and developed Reports on OBIEE and ETL Solutions
• Configuring complete End to End OBIApps application for various modules.
• Developed Custom BI Apps (Financials Analytics, Supply chain and order management Analytics) Setups.
• Handled Team of 4 to 18 members across various projects including both onsite and offshore locations throughout oracle tenure.

Confidential

Technical Lead

Technologies: Oracle 9i, OWB, SAPBW, BO5.1, datastage7.5, Business Objects 5.1

Responsibilities:

• Held the role of a Team Lead and Project Lead, Technical Design of the ETL and Report Development.
• Application Support for various projects
• Executed various Data warehousing projects in all phases of development activities for all the clients in Confidential .
• Handled Team of 2 to 8 members across various projects, both onsite and offshore locations throughout Confidential
• Implemented Migration process for Business Objects XI R1 to XI R2 such as readiness assessment and deployment plan, Migration and system Upgrades, Co-Existence Planning, Deployment services and Education delivery.
• Supported MIS applications in ONSITE and OFFSHORE..
• Worked on Applications Migration projects