SUMMARY

• Highly experienced Data Architect with thorough knowledge of all aspects of implementing Data Management solutions such as DWH, ODS, Data Marts, Data Quality, MDM, Data Profiling, Data Mining, Metadata Management, Data Modeling, (3NF, dimensional, Data Object Oriented and NoSQL).
• Competent in all stages of the project lifecycle, from business analysis and data modeling to ETL architectures, performance tuning and analytic applications.
• Experienced in both on - premises and cloud solutions.
• Experience in designing data solutions in Azure including data distributions and partitions, scalability, disaster recovery and high availability
• Good balance of technical and management skills, with proven ability to lead complex, globally distributed teams and deliver projects on time and on budget.
• Engineering and technology subject matter expert with proven adaptability and innovation in program leadership, execution intelligence, and architectural design of large scale Business Intelligence and Data Analytics solutions.
• Extensive hands-on experience in Data Warehouse, ETL, Business Intelligence & Data Analytics systems including Solution Architecture, Data Roadmaps, Data Modeling, Data management, Data Visualization, Data Mining and predictive analysis.
• Seasoned professional with outstanding project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure.
• Excels at communicating with stakeholders, technology leadership and cross functional teams to provide accurate reporting and information regarding ongoing projects, risks and initiatives.
• Recent experience implementing solutions utilizing MS Azure, Informatica, Tableau, Hadoop, Hive, Pig, Hue, Greenplum, Teradata, Cloud Technology and CI/CD tools.
• Intermediate experience in AWS. Implementation knowledge of AWS components and technologies including but not limited to - Lambda functions, AWS step functions, EKS, MSK/Kafka, Dynamo DB, Single Sign-on, Scala, Snowflake/Redshift, Cloud formation Template/Terraform
• Intermediate experience: Hadoop / Big Data, Hive, HBase, NoSQL

TECHNICAL SKILLS

• Solutions Architect
• Data Visualization
• Data Governance
• Architecture Design
• AWS and Azure Cloud Solution
• Data Modelling
• Analytics
• Data Analysis
• ETL - Informatica / Talend
• Data Warehouse / Marts
• Big Data
• Hive
• Database Architecture
• Tableau
• Business Objects
• Alpine
• Teradata
• Greenplum
• Oracle
• SQL Server
• Data Lineage
• Restful Services
• Distributed Computing
• Digital Transformation

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Successfully architected, developed and supported the new automated reconciliation framework.
• Led the reconciliation work stream to identify reconciliation requirements, prepare recon specifications and assist in the development of automated reconciliation for AIG’s Claims Management Group.
• Led data driven initiatives to measure improvement, drive change and encourage learning which resulted in significant cost savings.
• Experience in implementing data solutions in Azure including Azure SQL, Azure Synapse, Cosmos DB, Databricks, ADLS, Blob Storage, ADF, Azure Stream Analytics
• Experience in monitoring and optimizing data solutions in Azure including using Azure Monitor
• In depth understanding and proficiency in automation of cloud platforms and data platforms
• Expertise in on-prem and cloud database automation and platform automation with Azure
• Developed Strategy, procedures and processes for the new team including Standard Operating Procedures, Technology Roadmap, Standardized Templates, Training Plan etc.
• Drove Prioritization and Delivery of Technology solutions using internal IT resources; provide regular status updates to Finance & IT Leaders.
• Instrumental in Solution Definition and Design, Requirements Analysis, Source System Analysis, Data Profiling, Data Analysis, Data Migration activities for Data Hub project.
• Defined and executed the methodology for the capture of business requirements, including process redesign for front, middle, and back-office activities
• Trained and fostered agile development methodologies
• Led a high performing team of Data Engineers
• Designing a rule engine which should be flexible enough to add more policy to claims link rules in future.
• Understanding business rules, doing data analysis, designing data pipeline.
• Studied the system requirement specifications and understood the system to be developed.
• Involved in the specification analysis and preparation of test plan for the testing.
• Involved in preparing/reviewing the test cases and detecting bugs
• Responsible for interacting with clients for suggestions, improvements in system.
• ETL pipelines using Informatica for loading tables. Smart dashboards designing, identifying key metrics, creating data objects fitting the requirement.
• SQL, PL-SQL code writing in Teradata.
• Experience in System Development Life Cycle - Agile with SCRUM.
• Interacting with various stakeholders, routing and sourcing information to/from right channel.

Confidential

Data Architect

Responsibilities:

• Designed Data Architecture for Xfinity Hub solutions.
• ETL designing and implementation using Informatica, Teradata, Big Data technologies and UC4.
• Working closely with data modelers for tables design, indexing partitions and metadata management.
• Designing Data Load module, Recovery module, code migration documentation, post deployment checkouts and resolving issues if any.
• Requirements gathering, capacity planning and management for datasets.
• Project Management activities, team management and coordinating with business and tech operations.
• Analyses and designing of high volume data solutions using Hive, sqoop, Hue, Pig and Teradata.

Environment: Hive 1.2, Hue 2.6.1-1, Hadoop 2.6, Pig 0.14, Teradata 15.10, Teradata SQL Assistant, BTEQ, FastLoad, Oracle 11g, Informatica PowerCenter 9.6, Linux 2.6, UC4 scheduler, GitHub 2.48, JIRA, RALLY (Scrum tool)

Confidential

Data Architect/Sr. ETL Developer

Responsibilities:

• Working in Wealth Management for multiple projects, primarily in 3D Lists. This application caters to Financial Advisors as their work stations in their day to day activities viz client information, client account details, transactions, profit/loss etc.
• Involved in Data Architecture, ETL Design, requirements gathering, development, integration and testing. Preparing the project requirements specification through interaction with business representatives.
• Involved in various new Data Analytics initiatives - Insights, Alpine evaluation, Greenplum, Fraud Analytics, Risk dashboard.
• Involved in creation of Data Models, Data Flow diagrams, Process Flow charts. Involved in system Analysis, Collection of entities, attributes & relations.
• Involved in design architecture of the data hub and writing high level and low level design documents.
• Managing offshore team and onsite liaison work with various stakeholder.
• Change Management tasks - Getting approvals from senior management, production deployment checkouts, handling post production issues if any.

Confidential

Sr. ETL Developer

Responsibilities:

• Business Metrics initiative project caters the need of the GWMG-IT group with the data services by bringing data from the different source system, consolidate it into core load. From core load various data marts are built to cater to different users among GWMG, which further consume Business objects/Crystal reports.
• Performance tuning of mapping by Establishing Baseline Performance, Setting goals, finding the bottleneck and eliminating the bottleneck. Checking of business naming conventions - code review.
• Creating and maintaining shell scripts for pre/post session operations and various day-to-day operations.
• Writing PL/SQL procedures for processing business logic in the database. Development of mappings, sessions, worklets & workflows to load the data in Staging, Dimension, Slowly changing dimension and Fact tables.