Ankita Malik Email & Phone Number

Working on the Commercial Insurance line of business managing on premises database administration, development in Agile teams.Tech Stack: Teradata, Oracle, SQL, Core Java, AWS Redshift using AWS Glue as ETL Glue catalog, Glue job, Glue Pipeline, AWS S3, AWS EC2, AWS EKS, ECS, Load balancers, Auto scaling groups and AWS IAM roles, policy,users and groups, from AWS S3. Snowflake objects as Tables, schemas, databases, warehouse, roles, stages, file formats, copy into, snowsql cli, snowflake achitecture,computing, clustering, cloud function, snowflake data sharing, users, reader accounts,role,groups.Oracle SQL, SCD Modelling and Analysis, Enhancements, Code and Data testing, Debugging, Teradata db ,db visualizer ,Informatica,Jira, Confluence

Worked on building Pilot project model and strateging design and implementation model for ETL and using Data CDC pipelines and Stored Procedure framework for data migration from several Source Db(hive,Teradata,SQL,MySQL,oracle,mangodb) to Target Db(cloud) for international banking project. Tech Stack:Teradata,SQL,MySQL,oracle, Pyspark, Python fundamental, mangodb, Hadoop, Hive,SQL stored procedure,Apache Airflow orchestration, StreamSet ETL, Autosys,AWS EC2, AWS EKS, AWS EMR, AWS IAM, AWS S3, Real Time Kinesis Data Stream Analytics, Snowflake objects, Snowsight, DWH, Db, Tables, Schema, Time Travel, Query History, Query Caching, CDC, Snowpipe,AWS SNS, AWS SQS, AWS Eventbridge, Databricks, SCD Type Modelling, Confluence, Jira, Servicenow,Rally

Worked as Senior Analyst to handle all the requirements for Insurance (PI+CI) domain. Handling the Application development implementations as per upcoming requirements.Tech Stack:SQL, Pyspark,AWS IAM, S3, EC2, Cloud Watch Metrics, Cloud watch logs, SNS, SQS, Event bridge, and AWS Athena and Snowflake Cloud , Abinitio EME, Teradata, Databricks, Confluence, Jira, Rally, PMP, Autosys schedulingTask:Data governance, data strategy, data modelling, data quality, master data management, data analysis using Teradata,Snowflake cloud databases and AWS Athena & S3, Data Extraction,Data Loading, Data Transformation, Data processing,Data Mapping, Data Analysis,functional and integration and smoke testing,Demonstrated excellent agile delivery end to end task management in Confluence, Rally.

Worked as a coding faculty for next generation of coders. Conducted Lectures, discussions, demonstrations, training and feedback sessions from fundamentals to Advanced Web Developmentincluding creation of websites, Portfolio, games, Mobile Apps, Animated stories, and simulation apps.Tech Stack: HTML, CSS,Javascript, Bootstrap, Python Fundamental, Natural Language Processing,Predictive and Semantic Analysis, Android and IOS appstore application, MITapp creation, website and application development

Worked on ETL (extraction, transformation and load) of projects involving Migration and conversion of data from one platform to another for various Healthcare domain client base.Tech Stack:Data mining tools,Data Analysis,Data Migration, Technical Specs, Data Mapping, SQL script, SQL Code , Mainframe, Database Testing, Gap analysis, Managing and Handling large datasets, Data Quality, Data Accuracy Data Validation

Gurgaon

Have gained experience working on several HRMS and Payroll projects using SDLC starting from Requirement Gathering of report, Data model Planning , Analysis, Development including development time & coding efforts, SIT, UAT, Deployment, MaintenanceTech Stack: Business Intelligence suite, MS Office Suitei) Report Studioii)Analysis Studioiii)Query Studioiv)Framework ManagerCreated DashboardUnit testing/Manual TestingFrontEnd Testing and Database testing, Integration and Functional TestingHPQC, Lotus Notes,Enhancements,Issue Tracking and Debugging