SUMMARY

• Dynamic and results - oriented IT Solutions Architect with over 20 years of progressive experience in IT Data and Application Solutions Architecture, specializing in Business Intelligence, Big Data Analytics, ETL, Mobile and Cloud platforms.
• Lead Big Data adoption and migration efforts to build a BI Analytics vision, adapting to rapidly changing environments. Lead a team that drives project technical leadership of reporting needs.
• Extensive experience in designing and architecting Big Data platforms to support innovative solutions across the enterprise.
• Strong technical skills in implementing IT solution architecture and integration with other enterprise applications.
• Experience in developing and implementing data lake solutions combining traditional data sources with Big Data sources such as Hadoop, and applying effective enterprise governance across their information landscapes.
• Hands-on administration, configuration management, monitoring, performance tuning of Hadoop and Distributed platforms.
• Promoted architectural and integration best practices across enterprise.
• Proven experience in leading, architecting, developing, implementing and maintaining complex BI Data engineering applications with HADOOP, IBM Cognos, MicroStrategy, IBM SPSS, SAS, Tableau, INFORMATICA and MS BI stack.
• Ability to design application systems for high availability, security, manageability and reliability.
• Strong skills in database design and management. Expertise in data profiling, querying, cleansing and data modeling for Data Warehouse/Data Mart development for Business Intelligence (BI) applications.
• Experienced in defining Data Governance, Master Data Process Design and Management. High and Low level MDM Solution Architecture and implementation Roadmap.
• Comprehensive experience working in different J2EE environments, SOA based enterprise applications and 3 tier Web Applications.
• Proven IT architecture background in applications, data, security and infrastructure.
• Experienced in Java, SQL, SQL, PL/SQL, Python, Spark, Scala and Shell scripting.
• Strong Project Management, analytical thinking, oral and written communication skills.
• Experienced in implementing and supporting BI Cloud solutions using MS Azure and AWS.

TECHNICAL SKILLS

• TABLEAU 9
• COGNOS 10
• COGNOS TM1
• SAP CRM
• SAP BO XI4.1
• WEBSPHERE7/8
• SAS 9.3
• SharePoint
• SSIS
• SSRS
• SSAS
• POWER BI
• MS AZURE
• AWS
• IBM SPSS
• R STUDIO
• PYTHON
• ALTERYX
• INFORMATICA 9/10
• CLOUDERA HADOOP
• HIVE
• IMPALA
• SPARK
• SCALA
• PYTHON
• PIG
• MAPR
• SPLUNK
• DB2 10.5
• ORACLE 10/11
• MSSQL 2012
• WIN 2012
• IBM AIX 6/7
• REDHAT LINUX 6/7
• AUTOSYS
• ITIL
• TOGAF 9.1
• REMEDY
• PVCS
• TIVOLI
• TAM
• TOMCAT
• IIS
• WEBSEAL
• ETL and AGILE

PROFESSIONAL EXPERIENCE

Confidential, DE

Big Data Solutions Architect and Data Lead

Responsibilities:

• Developed enterprise solutions with Cloudera Hadoop data lake on AWS platform for ingesting complex and voluminous data from multiple vendors which gives complete insights on respiratory biologics Confidential ts for the new product FASENRA launch charting Confidential t Journey by analyzing Confidential t Longitudinal and lateral data to predict and trigger treatment options. Provided data architecture expertise to support the agile scrum team.
• Worked on transformation, de-normalization and mashing of huge amount of medical, clinical and pharmacy Data on Terabyte scale optimized for deriving insights and visualizations. Created ETL work flows using Java, Shell scripts and HQL. Worked on importing and exporting the data using Sqoop from HDFS to Relational Database systems and vice-versa. Worked on optimizing Impala using shuffle & broadcast techniques and Hive with serde format techniques. Applied partitioning and bucketing techniques in Hive and Impala for performance improvement.
• Created conceptual, logical and physical data models. Designed and implemented the physical data structures to create schemas using Hive and Impala for the Enterprise Data Warehouse. Created and designed business critical Analytics service layer data model and implemented the same for consumption to the BI visualizations teams for MicroStrategy and Tableau.
• Performed a current state Data Management assessment and presented findings in the form of a Data Management Maturity Model. Defined and presented to upper management the future state tactical and strategic Data Management Program roadmap that outlined activities to take them to the next maturity level.
• Worked on providing self-service data analytics solution with Alteryx to perform predictive and statistical analytics in a single and repeatable workflows.
• Worked on integrating Spark streaming with Apache Kafka to bring in real time analytics. Used Oozie and Autosys for workflow Management of batch jobs. Worked on optimizations with dynamic ingestion and schema evolution using Spark & Avro. Worked on to implement ETL solutions using AWS Glue to prepare the data for analytics in a serverless fully managed Apache Spark environment.
• Involved in various phases of Software Development Life Cycle (SDLC) of the application development like Requirement gathering, Design, Analysis, Coding and Deployment. Worked with the Production support team to resolve production Issues.

Confidential, MD

Technical Project Management Consultant and Lead Architect

Responsibilities:

• Responsible for Business Intelligence Application and Server Migration from California Data Center to Pittsburg Data Center involving Big Data, Cognos10, SAP BO and Tableau infrastructure.
• Collaborated with Business and Technology teams to establish scope/guidelines, perform infrastructure discovery and application dependency analysis, determine business requirements, identify migration strategies, negotiate schedules and provide ongoing coordination.
• Deeply involved in design, planning and execution of migration plan to migrate/decommission all application instances and servers, without any disruption to Business Groups and activities.
• Track and report all application instances scheduled for migration. Host weekly status meetings with senior management, business and technology teams. Developed a dashboard tool based on the Tableau repository to track progress of migration phases.
• Coordinated closely with SAs, DBAs, Middleware Implementation Engineers, Network and Storage teams to ensure successful execution of Migrations on time with zero defects.
• Managed migration of 140+ application instances from infrastructure discovery to execution phase. Facilitated, tracked and completed decommission of application instances and servers.
• Led the triage team on the migration weekends to ensure prompt resolution of all issues and successful migration.

Confidential, NJ

Consulting Director and Lead Architect

Responsibilities:

• Worked with business and technology and infrastructure teams to propose solutions, to provide strategic direction and prioritize technology needs focused on reporting, insights, visualization and analytics. Collaborated with internal business stakeholders, vendors and industry consultants to define information needs, develop business cases and priorities. Worked on evaluating new technologies with proof of concepts to in corporate them in the platform.
• Lead and developed Big Data Solutions practice by setting the Big Data roadmap and build supporting infrastructure and team to provide Big Data services to insurance and financial business groups. Involved in analyzing the requirements and provide solutions. Worked closely with the infrastructure and technology teams in designing and procuring scalable architecture. Conducted architecture assessments to ensure all projectsare as per company strategic planning, data governance, standards and guidelines in terms of technology and applications.
• Designed and Architected MarkLogic based applications for life insurance group for customer insight and claims management. Designed to provide a highly scalable and operational database for low-latency transactions with Hadoop as a low-cost place to store data for data analytics. Worked on a POC to provide cloud solutions for the same on AWS.
• Designed in-house BaseView application for insurance division. As part of initiative, team successfully implementedand production released Hadoop ecosystem from PoC, which became centralized transactional Data Lake. Sqoop was used to source data from DB2 and Oracle databases to HDFS.Data was ingested in HDFS, Pig with shell scripting and XML was basis for ETL framework from HDFS to Hive. Hive and Impala was used as data warehouse with views andschema tables for reporting / analytics. Measure activity and usage trends for capacity planning and chargeback. Identify application usage and data to assess the impact on the entire data lake. Design and developed dashboards on Tableau to measure system stability and performance metrics.
• Architected and designed Big Data solutions for Prudential Audit Process (PAP). Existing audit system is implemented on SQL server database with scalability and functionality constraints. Prudential requires unstructureddata analysis on audit documents. Results need to be linked to structured audit information.Designed Big Data solution on Hadoop ecosystem with HIVE and Spark components. Worked with Data Science teams to conduct Link analysis & Visualization through Graph database SparkGL. Association analysis and KNN type techniques using SparkML machine learning.Conducted text analytics and predictive capabilities through the use of data analysis, data science, and machine learning.
• Provided end-to-end IT application solutions and support for several projects with IBM Cognos, MS BI, IBM SPSS, MarkLogic, Hadoop, Elastic Search and Tableau for HR, Financials, Retirement and Insurance groups in Prudential and worked diligently to optimize the Application Architecture and performance. Extensively involved in design, development, implementation and testing of several application projects and their SDLC.
• Lead and perform the gathering of Client requirements for data integration and reporting. Ensured clarity of requirements, expectations, deliverables and timing. Established planning, project management and communications processes to ensure timely quality deliverables to clients. Developed innovative solutions to meet and exceed customer expectations. Drive and implement continuous improvement.
• Collaborated in creation of Data Platform Solutions (DWH, Data Hubs, Data Marts, Cubes) with Hadoop, Oracle, DB2, Informatica and Tableau to implement ETL, Data profiling and Data parsing and to facilitate the decision making for reporting and analytic projects. Lead the development and integration of enterprise data across the organization for production, identification and extraction of data from various sources and loading into databases.
• Architected and managed IBM Cognos Shared Infrastructure and Tableau Shared Infrastructure supporting several business groups within Prudential providing self service capabilities for data and information. Accountable for quality, timely, innovative and insightful Client reporting deliverables. Resolved dependencies, issues and risks that require immediate attention.
• Architected and implemented in house Software as Service (SaaS) Tableau Multi-tenancy solution to improve elasticity and enable Self Service capabilities to internal business partners for their BI Visualization needs.
• Architected and managed IBM Open Pages Governance Risk and Compliance platform using AWS and integrated with Cognos and Tableau for reporting and dashboards. Experienced in evaluating cloud based data infrastructure solutions and making recommendations for implementation. Established and maintained policies and standards to guide data usage, storage, retention and control access to sensitive/confidential data.
• Worked to resolve several issues related to adoption, growth, policy, security and business data privacy. Defined and documented target architectures, licensing, cost model, chargeback, governance, service level agreements, anticipated growth, scalability and recommended solutions in line with business needs. Participated key architecture and project review meetings.
• Designed and developed several data warehouses and data marts and oversaw all aspects development including ETL, Metadata, Reports and Dashboards using Informatica, MS BI, Tableau and Cognos. Experienced in design and delivery principles of data integration, information delivery, analytical products, data quality, data security and data governance.
• Designed and implemented end-to-end solution for creating security reporting data warehouse for several business groups within Prudential. Worked on data identification, data analysis, data quality and transformation to build an extensive data warehouse involving security information related to various business groups from several different data sources.
• Worked on an integration effort for development and deployment of several dashboards by creating multidimensional cubes, merging BI platforms with enterprise data warehouse systems that allowed KPI's and scorecard metrics for executive decision support systems.
• Resolved several design, development and performance issues with regard to ETL and BI reporting and Big Data Analytics. Developed and executed an efficient automation process for ETL using Informatica and home grown tools to reduce the processing times by more than 60%.
• Became an early adopter of TOGAF and ITIL and established the team as the model of effectiveness in Service Desk Management within Prudential.

Confidential, NJ

Business & Functional Analyst/IT Systems Architect

Responsibilities:

• Analyze Prudential businesses and identify, design and build BI and Data architectures, strategies and solutions for global IT solutions that improve the businesses and support for its rapidly growing member base needs.
• Define BI Architecture, Data and Middleware Architecture, Governance and Risk Management.
• Technically led the diagnosis analysis of Business Continuation performance issues and evaluation of BC infrastructure and setup automated procedures for speedy BC recovery. Involved in several successful BC tests every year.
• Architected and managed SAP Business Objects and SAS for Group Insurance and Individual Life Insurance.
• Installing, configuring and administering Cognos8/10 OLAP Reporting tools on Sun/AIX/Linux/Windows platforms. Installed and configured web, websphere, tomcat and LDAP services with Netscape for Cognos.
• Installed and configured DB2/Sybase/Oracle/Data Direct database client tools for Cognos Data mining and Reporting. Automated the Cognos cube/report builds for various business partners using Unix shell scripting and Autosys. Created proactive monitoring Autosys jobs for all the processes to build the cubes and reports.
• Implemented and administered Business Objects XIR2/XIR3 with Tomcat application server for web intelligence reporting Administering and maintaining all the business objects reports for several business groups. Report administration and reports/universe promotions to QA/Production servers using PVCS. Automated the report scheduling process.
• Implemented authentication solution for Business Objects for Life using WebSeal.
• Installing, configuring and maintaining SAS 9.2 on Solaris platform for reporting and data mining.
• Configured the Cognos, Business Objects and SAS on Sun Unix systems for Oracle and DB2 UDB and Sybase databases. Installed and maintained Oracle8, Sybase and DB2 UDB database clients on all the reporting servers. Worked on AIX Server Consolidation project for USCG to move all the applications and data from old low capacity servers to high capacity servers
• Installed and configured Business Objects XIR3 for Group Insurance on Windows 2005 servers for the development, testing and production environment. Administering and maintaining all the reports and performing SDLC promotions for group insurance.