SUMMARY:

• 18+ years of results - oriented broad-based technology and leadership experience with background in Software Development, Data Management, Product Support and IT Operations in Local Data Centers and Cloud Environments. Experience Leader in establishing standards, delivering business solutions, and building solid working relationships with clients, staff and senior management. Innovative management over the entire product life cycle from architecture and design to implementation and support.
• Organization & Staff Development
• Technology Architecture & Integration
• Product & Program Management
• Data Management & Integration
• Business Process Re-Engineering
• BI Implementation and Data Analytics
• Leadership & Communication
• Cost Control & Operational Excellence
• EDW, EDL, EDG Integrations
• Software Development and Global IT Delivery
• Process, Performance and Quality enhancement
• Big data Cloud implementations & Migrations
• Strong expertise in creating Architecture and Strategic Planning on Cloud environments
• Expertise in migrating data from legacy data centers to Cloud based AWS S3, Redshift, Azure and Google BigQuery
• Expertise in building Sales and Finance business processes for Banking, Telecom and Retail industries
• Technology expert in building EDW, EDL and EDG environments
• Strong expertise on Data data modeling techniques on RDBMS, Columnar Databases, HDFS Mapreduce technologies
• Strong experience in Customer Master, Product Master, Sales Data Analytics, Marketing data analysis, Risk data analysis
• Expertise is designing data migration strategies, data governance and data profiling
• Skilled in managing, monitoring, estimating Project Cost and Time for large projects
• Highly proficient in creating Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Detailed Design Documents
• Expertise in Data Warehouse Architecture, including Ralph Kimball and Bill Inmon approaches
• Adept at Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata/DB2/SQL Server/Snowflake/Redshift database environments
• Strong expertise in BIG data/Hadoop, Hive, HBase, PIG, Sqoop, SPARK, Storm, Kafka, Flume, etc.
• Strong expertise in Data modeling using Star Schema, Snowflake Schema and 3NF for Data warehousing / OLTP systems including RDF OWL, XLM/XSD Schema
• Hands on experience with data modeling tools ERwin, EA Data Modeler, Oracle Data Modeler, IBM Data Architect and MS Visio
• Strong expertise in Oracle SQL Loader, Export/Import, Data Pump and Teradata loading tools FastExport, Multiload, TPump, TPT, VIEWPOINT, TBAR, Performance tuning
• Experienced in Oracle SQL Performance Tuning with Oracle tools and Performance tuning on Teradata database
• Strong expertise in design and implementation of extraction and transformation (ETL) process
• Hands-on expertise on BI tools OBIEE, Tableau, QlikView, Cognos
• Active team player and self-starter with immense ability to grasp and apply new concepts
• Very strong expertise in Informatica Power Center, Mapping Designer and Workflow Manager
• Solid analytical, presentation, verbal and communication skills, and can easily establish rapport to influence management and multiple levels of the organization
• Strong expertise in Project Management methodologies with Agile, Scrum, Waterfall etc.
• Experienced in working with global teams (off-shore / On Site model)Innovation and Enterprise Solution Design and Implementation
• Designed an analytical module to aid in the clinical trial tracking and management.
• Implemented an effective and efficient Customer Master and built a successful customized PDA Companion application that complies with federal regulations.
• Designed and developed a Tablet PC based multimedia module that help sales and marketing provide consistent message to customers.
• Designed a robust data model for clinical trial study planning and site selection that includes a database design.
• Designed and managed several Data Architecture for Data Warehouses, BI application and dashboard implementations

TECHNICAL SKILLS:

AWS, Google, Azure: (S3, Redshift, Spectrum, Athena, Dynamo, RDS, Cloud watch, EMR, Google BigQuery, Matillion (ETL), Snowflake database

Databases: Oracle 10G/11G with RAC, Teradata 13/14/15, MS SQL Server, Knowledge of Hadoop eco systemData Management and BI Tools: DataStage, Informatica, Pentaho, QlikView, Business Objects, Cognos, Golden Gate

Big Data: Hadoop/HDFS Architecture, Cluster Build, Hive, MYSQL, Sqoop, PIG, Pentaho, HBase, Cloudera CDH3 &4, Cluster Performance tuning with MapReduce, R Language, RevoScaleR, Scala, SPARK, Storm, Flume, OOzie, Kafka

Program Management: Requirement Analysis, Project planning from inception to delivery and ongoing support, project portfolio tracking, controlling, cost and budget analysis, P&L management, variance analysis.

Frameworks: Web application framework, Enterprise Architecture framework.

Subject Matter Expertise & Other Skills: Customer Relationship Management (CRM), Business Intelligence (BI), Master/ Data Management Systems (MDM) for Customer and products.Program Management, Business Analysis, Requirements Definition, Vendor Evaluation and Management, Data Analysis, Data Architecture and Data Warehousing.

Software Tools: Unix: Make, Awk, SCCS, Ksh, and Oracle SQL Loader, CA ERwin, Rational Rose, SVNWindows: CA ERwin, EA Data Modeling, Oracle Data Modeling, Rational Rose, DataStage, Office 2010, Project 2010.

Hardware: iPad, HP iPAQ, Palm, Tablet PC, IBM PCs, AT&T Star Server E, Sun 3/90, Sun 6/90, HP V Class.

Methodologies & Standards: PMI Methodology, Software Development Lifecycle (SDLC), ITIL, RUP, IDEO, Agile, Scrum and Iterative methodologies.

Programming Languages: Programming Languages: C, C++,Perl, Oracle PL/SQL, SQL Loader, Fastload, Multiload, TPump, TD ViewPoint, TD Performance Tools

Operating Systems: Windows XP, Windows 2000 Server, Windows CE, Palm OS, Unix System V Rel. 4, SunOS 4.1HP UNIX, Red Hat Enterprise Linux 5, Knowledge of iOS

PROFESSIONAL EXPERIENCE:

Confidential

Sr Data Modeler/ Data Engineer Consultant

Responsibilities:

• Lead Ingestion and Modeling teams to build pipelines for Digital Core
• Work with SMEs, Business Leaders to understand, consolidate and document the business requirements with gap analysis
• Provide Leadership to BA, QA teams on data flows, objectives and s
• Helping all the teams to understand the technical access and how to access and navigate
• Lead the security aspects of the different components with the echo systems
• Make sure all the teams aligned with the agile, sprint objects and help to achive goals
• Provide an overall architect responsibilities including roadmaps, leadership, planning, technical innovation, security, IT governance, etc
• Acting as a senior architect, provide technical and process leadership for projects, defining and documenting information integrations between systems and aligning project goals with architecture
• Lead end-to-end Cloud implementation at large enterprise environment integrating with multiple legacy applications in Cloud based architectures
• Provide technical leadership and governance of the big data team and the implementation of the solution architecture in following Cloud Data Lake (Redshift, Snowflake, Aurora, Spectrum, Athena and RDS, EMR, Map Reduce, Pig, Hive, HC Catelog, Spark, Pheonix, Hbase, Storm, Kafka, Flume, Falcon, Atlas, OoZie, Ambari, Hue, Security - Kerberos, Ranger, Knox, Oracle ASO, HDFS encryption, AD/LDAP, hosting platform - AWS)
• Configure and tune production and development Database Structures and environments with the various tools
• Adopt innovative architectural approaches to leverage in-house data integration capabilities consistent with architectural goals of the enterprise
• Design and develop strategies for moving Local Oracle and other database solutions to cloud solutions
• Creating Redshift, Snowflake, Aurora, Spectrum, Athena and RDS DB solutions and data models based on client requirements
• Design and develop Serverless architecture and microservices components as part of ETL/ELT (Lambda, Glue etc..)
• Also implement strategies for Matillion, Airflow and other ETL/ELT tools
• Design and develop Streaming strategies for SDK using AWS Kinesis Data Firehouse, Mongo DB, S3, Redshift
• Create environment/tools required for Historical Data Archival and Retrieve (HDAR) system using Athena, AWS Spectrum
• Working with teams for QA/UAT/Production teams for deployment planning and operations of the new components/enhanced to production

Confidential

Lead Big Data Architect/Data Architect Consultant

Responsibilities:

• Work with SMEs, Business Leaders to understand current processes and future objectives
• Creating existing process flows, business capabilities, business and technical challenges documents
• Creating future state of architecture and roadmaps with respect to business and technology
• Guiding teams on process approaches and technology implementations
• Create Logical and Physical Data Models/Architecture for all Business Units and design of GDFs using EA Modeling
• Creating and Building the EDL/EDW integrations checklist and best practices
• Create metadata models for workflows and MDM processes
• Design XML/XSD schema and critical data elements for collecting medical payment transactions
• Building Analytics on Vertica for Patient Analytics
• Create Custom Patient and Provider MDM design and implementation on EDL with Spark and Scala
• Guide team on design and implementation of Hive/Impala Schemas from HDFS
• Design and Implementation of security and roles on EDL
• Conducting POC for Visualizations, Reporting and data explorations using Kibana, Tableau, ELK, etc.
• Work with teams on data exploration, data analysis, data volumes, data challenges
• Work with Data Architecture team to review the data models and getting approvals
• Migrate BI/Reporting to AWS Redshift, streamline process with AWS components
• Creating AWS Redshift Patient Data Model
• Migration of data to AWS on S3, Redshift, Athena, etc.
• Optimizing the environments for cost savings and better performance

Confidential

Data Architect/Data Modeler Consultant

Responsibilities:

• Work with SMEs, Business Leaders to consolidate the business requirements
• Create Logical and Physical Data Models/Architecture for JnJ Business Capabilities (Legal, Portfolio Management, Enterprise Facility Management, Human Resources Data Models using ERwin
• Creating and Building the EDL/EDW integrations checklist and best practices
• Analyze SAP ERP Data models and Integrate with EDW Wareshouse
• Create Analytics models for Risk analytics, Portfolio Management Forecasting, Budget Analytics
• Work with teams on data exploration, data analysis, data volumes, data challenges
• Work with Data Architecture team to review the data models and getting approvals
• Work with Development team to implement the data models on GDW Teradata environment
• Creating architecture and design documents for above mentioned domains
• Extensively working on Teradata GDW and Data Lake
• Creating best practices on Data Lake and Oracle/Teradata environment
• Design and development of new standards for Performance monitoring and provide suggestion and manage the implementation of performance suggestion
• Working with Sales teams, Sales systems to collect Customer and Order details for descriptive geographical analytics
• Designing and Developing the Sales Model for EDL and EDW to generate the analytics
• Very strong hands on experience on Oracle DB, Teradata env., Unix based systems, job scheduling tools etc.
• Strong hands on experience in data migration and data replications
• Design the data flows from sources systems to Teradata and Data Lake environments
• Working with Tableau/QlikView Analytics team develop dashboards, visualizations
• Work with QA, UAT and Production teams to production rollouts and GO/NO Decisions

Confidential, Jersey City

Sr. Data Architect / Data Modeler

Responsibilities:

• Conduct interviews/JAD with subject matter experts and document the features to be included in the system.
• Implement a proof of concept for the system to be developed and manage the development of the product using an existing framework built using J2EE, Oracle databases 10G/11i with RAC
• Performance tuning of application queries using TKPROF and Explain plan
• Analyzing AWR reports for performance and providing suggestions on memory and CPU usage
• Designing and implementation of Performance alters using AWR and DB SQLs which runs more than 2 sec SLA
• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata database environments
• Architecture and designing the Marts for reporting and managing the Marts
• Design W3 XML/XSD schema to capture bulk payments from clients
• Design Common format XML/XSD schema for sending the data to payment processors
• Managed the design and development of new data models for Unified Payments model which can be extendable to other service providers
• Design and development of new standards for Performance monitoring and provide suggestion and manage the implementation of performance suggestion
• Manage Production support team and provide solutions for production issues
• Manage and development of Change Management DB and prioritize the issues based on its severity, client impact etc.
• Manage ETL team for data processing, migrations
• Creating Data Stream using Kafka to Data Analytics Platform
• Creating cluster for GTS to store the payment transaction data sets
• Designing the Cluster parameters, roles, users access privileges
• Building EDL Cluster to archive the Payment data

Confidential

Teradata Architect/ Data Modeler

Responsibilities:

• Provided overall project management at the client site, coordinating design and developmental activities.
• Organized meetings between different groups responsible for collection of cost center based employee and incentive details to summarize the data sources and develop an efficient source to destination Incentive data mart process.
• Interfaced with the client business, finance and legal teams and vendors to accelerate the project delivery.
• Provided the data architecture for the data repository and all the integration points with Informatica as an ETL tool, Teradata utilities.
• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle/Teradata database environments
• Established Teradata performance tuning procedures for data migration and ongoing reporting activities; synchronized function of the QA and Development Team to ensure 100% success in implementing the process
• Designed views in Teradata that mirror BI Application requirements
• Led the implementation of custom-built End-to-End ETL solutions from sources to TDW environment

Confidential

Sr. Project Manager

Responsibilities:

• Work with requirements team to collect the enhancements
• Create design and analysis documents with the changes required for existing data model and additional report requirements
• Design and Implementations of ETL Logic and Batch Job Scheduling for extraction of Dimensions and Facts with minimum downtime to the Reporting Tool
• Creating Database Objects and PL/SQL scripts for preparation of data according to the Business requirements
• Performance tuning of Queries, Database using Explain Plan and TKPROF Oracle Utilities
• Design and develop the indexing strategies for Oracle Tables / Materialized Views
• Work with BO team to implementation BO Universes changes and BO Reports

Environment: Oracle 9i, BO 6.5, Informatica 7.1