SUMMARY:

• Having 16+ Years of extensive IT experience as a AWS Solution/Data Architect for (DWBI/Cloud) using different set of ETL tools like Informatica Power Center/Cloud,Talend,AWS (EC2, S3, Glacier,EBS, Redshift,Dynamo DB, RDS, Postgres, EMR, Data pipeline, SNS, SQS,SWF,VPC, DMS, AWS SnowBall, Route53, ELB,Cloud Watch,AWS Config, AMC, AWS Athena, Elastic Search, Auto Scaling,CFT,IAM,AWS billing & Cost Management,IoT Device management, Sqoop, MSBI, (SSIS, SSAS) and OBIA/OBIEE 10 & 11G, Oracle, MS SQL Server,Teradata and Repository Database.
• Master in creation of Cloud Architecture, including Private, Public and Hybrid architectures, IaaS, PaaS and SaaS models for any domain .
• Experience in defining new architectures and ability to drive project from architecture standpoint
• Experience driving enterprise - grade Cloud services adoption across a medium-to-large organization with proven success
• Identify continuous services improvement, automation areas and prepare strategy script which helps in automating manual tasks and improve service quality and reliability
• Expertise in Analysis, design and development of ETL programs as per business specifications and assist in troubleshooting for complex business performance
• Build best practices and market trends pertaining to Cloud and overall industry to provide thought leadership (seminars, whitepapers etc.,) and mentor team to build necessary competency
• Experience in architecting, deploying and managing cost-effective and secure AWS environments, across multi-zones and regions, leveraging AWS services such as EC2, S3, RDS, VPC.
• SME for Technical and Architectural Informatica DW/BI Arch and Domain experience in Healthcare, Logistic, Life Science, Pharmacy, Clinical Trials, Telecom, Finance/Investment, Operations, process improvement and re-Engineering.
• An expert in the ETL Tool Informatica which includes components like Power Center, PowerMart, Power Connect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console
• Hands experience in using Informatica Cloud services like data synchronization, data replication, mapping configuration and object migration from Dev. to SIT, UAT and Prod Env.
• Hands on experience in creation of Global Delivery Framework model (GDF)
• Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI / Cloud projects
• Hands-on experience performing migrations from On-Premise to Public Cloud solutions
• Managed successfully developed and implemented various Cloud/DWBI projects related to end to end (HLD/LLD) development/maintenance, model optimization, workflow schedule automations and technical solutions delivery by using Tableau and OBIEE analytical tools.
• Hands on in advanced data model design/Data mart design, Dimensional data model /FACT by using Erwin and ER Studio and Vertablo .
• Expertise in Technical architecture/Data modeling and re-design of existing model for strategic Solutions
• Proven track record to solve performance issues any kind of Env.by using innovate methods/strategic solutions/ideas.
• Expertise in Analysis, design and development of ETL programs as per business specifications and assist in troubleshooting for complex business performance
• Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
• Developed complex ETL graphs using various components such as Reformat, Join, Roll-up, and Filter by Expression, Sort to facilitate cataloging flat files into EDS Data Hub. The components used rely on the various business requirements.
• Expertise in Technical architecture /Data modeling and re-design of existing model for strategic Solutions
• Ability to build relationship and have both business-level discussions with the business and technical-level discussions with internal and external technical team members.

TECHNICAL SKILLS:

Operating system: Windows (XP/ 7), UNIX . Sent OS

ETL Tool: Talend Bigdata, Informatica/Cloud, SSIS, Hadoop, SynopsysDatabases: Oracle 9i/10g, SQL Server, Teradata DB2, Sybase 15.x. Dyanmo db,Redshift, RDS, PostgreSQL

Reporting: Tableau,Cognos, PowerBI desktop, SAP BO

Languages: SQL, Unix Shell scripting, Toad, SQL Plus, MS-Project

Other Tools: WinSCP, CA scheduler, GitHub, Control-M, SVN, Git

Cloud Technologies: AWS ( EC2, S3, Redshift, RDS, EMR, Elastic Search, Dynamo DB,NoSQL,Datapipeline, SQL Server 2012, Cloud Search, SQS and SNS)

Domain knowledge: Retail (wholesale, Store, inventory), Product Promotions, Healthcare,Life science, Clinical, Pharmacy, E-commerce Retail,MultiChannel Mkt., Insurance, BFSI and Logistic

PROFESSIONAL EXPERIENCE:

Confidential

AWS Solution/Data Architect (AWS/DWBI)

Responsibilities:

• Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service for 6 companies
• Responsible for data extraction from different sources systems like Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions Veeva CRM, IMS, MDM, CDIS, Data one and IRDA DB
• Closely working with all business stakeholder and set the right expectation and define the best strategic ways to increase target Revenue.
• Write reference architecture, best practices and thought leadership whitepapers, identify and enforce AWS architectural best practices
• Create and build the Cloud Infa and responsible for continues data integration for hetrogenious sources
• Advise software development teams on architecting and designing web interfaces and infrastructures that safely and efficiently power the cloud environment
• Responsible ETL design, development and deployment for DEV, SIT, QA and Prod Env., using Talend Studio, TAC and SVN/Git and lead the entire ETL team of 30 resources which includes onshore/offshore.
• Define the scope and responsible for AWS infrastructure and creation of AWS set of service instances based on user stories for cross country/regions.
• Responsible for BI Country specific and Global level report/Dashboard metrics and making sure data model design optimistic and Business Rule Engine ( BRE) for common business rules for across the counties .
• Implement best practices to lead Global competitive market with best brand name and brand products (Medicine, pediatric and Hospital cleaning projects)
• Closely work with sales/pre-sales team to pitch the new customers for techno-functional end-to-end demos.
• Responsible for frequent travel to 06 Must Win Countries to re-factoring the DW design solutions, provide strategic solutions and define the impact analysis of downstream systems to business stakeholders/executives.
• Responsible for Multi-channel marketing for Must-win-Countries and Must-Win -Brands all channel data integration from different source system for 20 countries data into Global data mart for Global reporting dashboard
• Upfront with management for any project issues and mitigation strategies
• Frequent travel to different countries to participate Client meetings and review workshops on short notice
• Creation of new RFP for new projects and provide the effort estimation for project cost
• Develop full SDLC project plans to implement ETL solution and identify resource requirements
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL, SPARK (Scala) integration with AWS cloud services
• Extract, transform and loading data from multiple sources into Elastic Search, Dynamo DB and Redshift
• Responsible for the Configuration Management and Code Migration between various environments using Talend with Release Management and Versioning
• Project planning, effort estimation, deliverables, project costing and People management.
• Recommending and Implementing best practices for Cloud based application services Work flow configuration Task (WCT), performance Creation of the Business Requirements Document - BRD/Technical and Administrative for reporting/Dashboard abilities
• Modeling and Optimizing Elastic Search Indexes, Types based IMCM requirements
• Fixing the production bugs/job failures, collet the matrices (source and Target), uploading all resolution docs/fixes in JIRA tool.

AWS Solution Architect (DWBI /AWS) - Techno /Functional

Responsibilities:

• Build solutions secure and cost effective AWS based solutions to customer requirements
• Work with customer's IT, Engineering, DevOps and Security teams in identifying and prioritizing business and technical requirements
• Create credibility and accelerate adoption of Managed Public Cloud and Drive cost reduction/efficiency initiatives (e.g. change EC2 from on-demand to spot instances)
• Requirement gathering, creation of Data Mart from DWH as a sources Oracle, Veeva system by using data extraction tool as Informatica Cloud.
• Develop full SDLC project plans to implement ETL solution and identify resource requirements
• Discuss options with customer taking into account business needs, security, cost, and operational requirements
• Setting /Accessing Dynamo DB Env and Creation of Tables, on Demand Backup, authendation and access control etc
• Desing the Cloud infastructure and recommend the ondemand software/instances
• Lead architect in the Governance and steering of the AWS public cloud at customer
• Define the tools and technologies for project scope, artulacute the development fremework and BRD desing for dev. activities
• Work with others on the engineering team to manage the day-to-day development activities, participate in designs, design review, code review, and implementation
• Align proposed solutions with Client' public and private cloud offerings, and where needed identify alternative solutions to fill gaps
• Responsible for build and desing the AWS ( PaaS, SaaS and AaaS) and strategic cloud solution to team
• Creation of complex Informatica mappings using set of Informatica transformation (Expression, Joiner, Mapplet, Filter, SQL and Lookup) and applied complex business rules
• Business Development Support & Solutions
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL, SPARK (Scala) integration with AWS cloud services
• Extract, transform and loading data from multiple sources into Elastic Search and Redshift
• Conduct impact assessment and determine size of effort based on requirements
• Responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore
• Responsible for the Configuration Management and Code Migration between various environments using Informatica with Release Management and Versioning
• Analysis of knowledge business processes and functional requirement
• Responsible for demonstrating software to internal users
• Project planning, effort estimation, deliverables, project costing and People management.
• Recommending and Implementing best practices for Cloud based application services Work flow configuration Task (WCT), performance tuning by looking into Informatica activity log (DTM, source, trans, target) statistics.
• Modeling and Optimizing Elastic Search Indexes, Types based on eRoster Search Patterns and Requirements
• Fixing the production bugs/job failures, collet the matrices (source and Target), uploading all resolution docs/fixes in JIRA tool.
• Maintain current technical knowledge to support rapidly changing technology, always on a look out for new technologies and work with management and the development team in bringing in new technologies .

Enterprise Solution/Data Architect

Responsibilities:

• Responsible for design, development, and implementation of Cloud solutions
• Working with Business and System Analyst’s to transform business requirements into technical designs into EADW schema.
• Responsible for Security requirements and deployments, including the use of encryption, key-pairs, MFA, ... Database solutions EC2 on-demand, spot and reserved high-Availability
• Translate business requirements and operational strategy into a long-term, executable solution plan and roadmap
• Disaster Recovery solutions Storage and network solutions Cloud Formations Automation.
• Create credibility and accelerate adoption of Managed Public Cloud
• Assist with the product evaluation, selection and implementation for respective managed services that require 3rd party products to support application or business
• Write and implement the respective IAM policies as required per the respective services
• Participate in planning, implementation, and growth of our customer's Amazon Web Services (AWS) foundational footprint.
• Work with team to design, build, automate and document a multi-tiered managed services platform
• Understanding of security compliance, managed services in cloud based workloads
• Manage multiple projects simultaneously and be able to adapt to changing business needs
• Deployment and management of AWS services - including but not limited to: VPC, Route 53, ELB, EBS, EC2, S3, Dynamo Db, Redshift and Snowball
• Design and build Informatica mappings SCD-1,2 Solutions to meet customer specifications to maintain complete history
• I’ve been hands on experience in RDBMS /performance tuning and write custom SQL queries as business need.
• Task flow creation for xml upload/download files and map them run them in a schedule
• Lead and delivered multiple full lifecycle data warehousing projects with hands on experience in different phases such as requirements gathering, data mapping, dimensional data modeling, ETL and OLAP design and development, testing and overall implementation.
• Creative Ideas for Objects migration during the QA Traceability Matrixes and Deployment phases (End-to-End)
• Enhancing the existing EDW schema model and adding some additional table attributes and modifying attributes data types as business needs
• Creation of several task flows for combining multiple integration tasks

Data Architect / Data Modular

Responsibilities:

• Requirement gathering, creation of Data Mart from DWH as a sources system by using data extraction tool as SSIS.
• Designing end to end solutions and collaborating with application teams in executing those solution blueprints and plans
• Develop full SDLC project plans to implement ETL solution and identify resource requirements
• Redshift Table Design ( Dim/FACT) and define the sort and distributred key for data distribution.
• Setting /Accessing Dynamo DB Env and Creation of Tables, on Demand Backup, authendation and access control .
• Business Development Support & Suctioning
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture
• Conduct impact assessment and determine size of effort based on requirements.
• Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
• Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project
• Responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Responsible for the Configuration Management and Code Migration between various environments using Informatica with Release Management and Versioning
• Involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers
• Supporting as a project lead which included, onsite-offshore team coordination, reviewing reports/dashboards, requirement gathering, work assignment to team, Tableau Admin task etc. required Data Warehouse Consulting which include Data warehouse ETL Architect, Program Technical Lead, and Project/Team Lead
• QA and approval of logical, physical data models, QA and approval of ETL designs
• Lead design reviews with Client and participate in ETL and reporting requirements meetings
• Lead design IDW logical data models and Assist Client DBA’s in creation of IDW physical data models
• Lead the creation of detailed requirements to enable ETL design and creation of ETL integration test plans and ETL performance test plans (if needed)
• Lead design, development, unit-testing, and integration testing of ETL jobs and assist Support design of ETL reusable components
• Lead and ETL design development, unit-testing, and integration testing of ETL reusable components
• Provide oversight to ETL developers
• Provide necessary documentation to Client resources responsible for configuration of job scheduling
• Understand reporting requirements to enable design of reporting components (BOBJ Universe and BO reports)
• Lead creation of reporting migration, Tableau Server maintenance and integration test plans and reporting performance test plans (if needed)

Solution Architect/Data Modeler

Responsibilities:

• Identify and enforce AWS architectural best practices and full development life cycle
• Work with the customer success team, engineering team and professional service team to create a detailed project delivery plan and identify key delivery milestones and dependencies.
• Data modeling and transformation of large scale data sources using SQL, Redshift, Hadoop, Spark, Hive, EMR, or other Big Data technologies
• Requirement gathering from onsite, data model design finalization, re-design of existing model
• Design, build and own all the components of a high volume data-mart end to end in support of business reporting
• Architecting large-scale, modular and efficient data backend in database systems such as Redshift and Dynamo DB.
• Manag technical support teams and providing operational support in AWS Env.
• Running projects and delivery experience driving business requirements, identifying gaps and omissions, and designing solutions
• Provide blueprint, design and deploy scalable, HA and fault tolerant systems on AWS. responsible for code deployment in AWS deployment and management services
• Create POC to Migration of existing on-prem applications to AWS
• Understanding of network technologies as they relate to AWS and security features and tools that AWS provides and how they relate to traditional services
• Automate the code migration/code deployent from Dev to Prod and migration process to the maximum extent possible
• Involved in Project proposal and effort estimation for scope of project.
• Developing Web Service Framework for SIF real time data load and outbound services using Axis2 and Castor API.
• Monitoring of ETL Jobs on production system, Analysis of failed jobs, creation of tickets for failed jobs, deployment of ETL jobs from Dev. to Prod systems, creation of solution design for failed jobs, work with testing team and ETL design teams, deployment of production deliverables.
• Creation of complex ETL mappings, creation of ETL test cases, provide solution to ETL Analytics team.
• Strategic solutions for new business line, Staff augment ion onsite/offshore, Capability build for Client specific tools and technologies, Technical discussion with Maersk Like, Data Modeling, Design/ model architectural changes and part of solution design frame work.
• Solution Architect for Fastest MDM upgrade to 9.5.1 for 5 environments
• Upgrade of MDM from 9.1 to 9.5.1 HF4
• Understand current environment architecture and impact analysis
• Migration of configurations and data on upper environments
• Upgrade of Configuration and data from XU Version to 9.5 environment
• Handling Build and Migration of SIF and MDM Hub code
• Leading offshore team for upgrade.

Solution Architect / Project Manager

Responsibilities:

• DWBI Delivery Model Proposal, Define the DWBI strategic approach (ETL and Analytics), POC Creation for each business line, Staff augment ion onsite/offshore, Capability build for Client specific tools and technologies, Technical discussion with Florida Blue.
• Experience with Healthcare Data warehousing, Deep understanding of data warehousing concepts
• Good experience in physical/logical data modeling using Erwin
• Data modeling skills for data marts and data warehouse in a healthcare environment
• Deep understanding of analytics use cases in a provider scenario (especially US)
• Understanding of HL7 messaging and HL7 RIM and DICOM
• I have an extensive experience in Informatica Master Data Management to quantify of acquiring and retaining customers, improving efficiency, reducing costs and managing regulatory compliance to limit risk and enhance transparency.
• Developed and Implementation of extract, transformation, and load processes using SSIS as an ETL tool
• Participated in Mentoring of peers and higher Management seniors in WellPoint and Informatica Data Director
• Analysis of requirements, create estimates, Supported ETL architect in designing & formulating load strategy’s
• Develop the mappings as per the logical data map, optimizing the mapping to load the data, creating and scheduling the sessions based on the mappings created to load the data into the data marts
• Responsible for component deliverable for client end and onsite offshore coordinator.
• Leading 15 -20 members @ onsite/offshore on day to day basis for smooth functioning of project.
• Defining the ETL strategy for SEDW/Dart Mart Layer as business required

Data Modeler / Technical Architect

Responsibilities:

• Contributed Data Model design /Dart Mart to an inflight project in a very complex environment
• Suggested data model changes to reduce complexity and increases performance
• Architectural frame work for whole ETL process and EDW Table Model design.
• Defined subject area groups, subject areas, refined workflow roles and capabilities
• Developed spreadsheet from core data model to capture business user input on field level behaviors and workflow role access.
• Working with Business and System Analyst’s to transform business requirements into technical designs into EADW schema.
• Develop ETL mappings from source to target databases by using Ab Initio, Informatica and DS.
• Analysis of existing business logic and feasibility to implement new strategy
• Creation of Functional Documents (Interface or Conversion both inbound and outbound)
• Working as a Technical Project Lead and onsite co-coordinator for offshore team
• Innovation of performance tuning of the jobs/mappings that are developed by me and team
• Creative Ideas for Objects migration during the QA Traceability Matrixes and Deployment phases (End-to-End)

Enterprise Architect / Data Modeler

Responsibilities:

• Re-engineering of existing DW model and re-design of strategic data model
• Impact analysis of downstream team and recommendations for Semantic layer
• Design the data model for Retail Dimension and Fact tables and creation of database views for Semantic layer (Data Marts) by using Vertabelo
• Working with BA’s and business stake holders and finalized the model approaches and provide POC
• Responsible for integration of heterogeneous/homogeneous source systems and define the business drive attributes for SCD Type-2 approach.
• Performance tunings of existing ETL and apply suggestions for process methods like Bulk loading and Partition methods
• Configuration of data flow Land, Stage, Load, Tokenize, Match, Consolidate)
• Participated in Designing the Architectural frame work for defined DWBI process
• Completing the Functional Documents (HLD/LLD) new DWBI architectural Data Marts and Strategic development.
• Worked as Delivery Lead at onsite to co-coordinate for all the deliverables for offshore team
• Developed as a production instance from the onset (not proof of concept)
• Developed logical and physical data models for source data and core Siperian model.
• IDL and source data was loaded into staging areas. Landing ETL and automation were developed in PLSQL (for simplicity).
• Experience in requirements gathering, design, analysis, development of technical specifications, implementations, integration, modifications, documentation, testing

ETL Architect / QA Manager

Responsibilities:

• Creating the Technical specification documents for ETL process, and providing user privileges using Informatica Admin.
• Created reusable components that are used across the team
• Supported ETL architect in designing, formulating load strategies and analysis of requirements and create estimates, DW Data Mart design proposal and solutions and define the DW strategies.
• Working with Business and System Analyst’s to transform business requirements into technical designs into EADW schema
• Creation of Functional and Technical Specification documentation and co-coordinator to offshore team and co-ordinate with offshore/onsite team weekly review meetings
• Develop and implement effective communication plans and tools with onsite project managers, BAs and TAs

Enterprise Architect / SME

Responsibilities:

• Interacted with various teams across the globe and effectively done the requirements gathering
• Responsible for building the reusable components like Transformations, reusable lookup’s and other components that are streamlines for a better coding methodology
• Supported ETL architect in designing & formulating load strategy’s
• Augmentation of mappings to take care of new emerging requirements which impact business
• Involved Mappings development and optimizing the mappings to load the data into different data marts with different targets (Teradata, Oracle) and performance tune.
• Versatile roles as DBA, Informatica MDM Developer, Informatica ETL Developer, Cognos Report Developer, SQL, PL/SQL Programmer on Oracle 10g, Oracle Forms and Reports Developer also worked as Data Model Designer using Erwin.

Enterprise Solution Architect

Responsibilities:

• Responsible for Informatica MDM Administration, Informatica MDM HUB & IDD configuration, Software Upgrade, DBA, Applying Patch and also responsible for Code migration from Development to Production through QA using Metadata Manager
• Developed user interface for MDM-In-a-BoxTM using Informatica Data Director for hosting in Informatica Cloud
• Analysis of existing business logic and feasibility to implement new strategy
• Closely worked with business Analyst’s and data modular to transform business requirements into technical designs documents
• Analysis of various relational and non-relational source systems data creation volumetric and Estimation Supported ETL architect in designing & formulating Fact and Dimension load strategy’s

DWBI Data Modeler / Technical Architect

Responsibilities:

• Responsible for Informatica MDM Administration, Informatica MDM HUB & IDD configuration, Software Upgrade, DBA, Applying Patch and also responsible for Code migration from Development to Production through QA using Metadata Manager
• Developed user interface for MDM-In-a-BoxTM using Informatica Data Director for hosting in Informatica Cloud
• Analysis of existing business logic and feasibility to implement new strategy
• Closely worked with business Analyst’s and data modular to transform business requirements into technical designs documents

DWBI Architect / Techno Functional

Responsibilities:

• Develop ETL mappings from source systems to target database using Informatica power center
• Create client for MDM XREF services
• Working as MDM Lead and involved in Design, Analysis and Implementation of new requirements, Team Management & Providing Solutions for complex problems
• Extensive Knowledge of Informatica MDM Hub Configuration
• ETL Strategy Planning for Stage, Dimension, Fact on both Initial and Incremental and Mapping Design (Initial, Incremental)
• Peer code review of mappings, sessions and workflows, unit test and data validation
• Client interaction and analyze the requirements gather
• Creation of design documents and explaining them to the team
• Repository/Code migration from Dev. to QA to Production

ETL Developer /Report Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Front ending the customer from onsite for business requirements and technical design doc. creation
• Involved in development of the ETL mappings that loads data to different dimensions and fact tables
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Conducted code reviews developed by my team mates before moving the code into QA.
• Analyze requirement and Functional documents and explaining them to the team and imparting business knowledge to the team
• Provide training for offshore & Preparation of Technical Design documents
• Augmentation of mappings to take care of new emerging requirements
• Developed mapping in multiples schema data bases to load the incremental data load into dimensions