Ritika Solanki
Services Solution Architect
Experience
AWmOpsRtKekEX(CPEliRenIEtN: CInEfoSrs.yDs,aHtaitAarcchhiiEtencetr(gAyW) S)
Global marketing analytics for Hitachi Energy as part of a global data modernization initiative aiming to enhance data retention, historical data availability and provide Eloqua's 2-year retention for remote interaction reporting and analytics.
Analyzed Eloqua's default retention policy and identified risk of data loss for records older than two years.
Designed and implemented historical data preservation strategy by creating transformed tables in the target data platform to archive older data while ensuring data quality dashboards.
Collaborated with the Power BI team to re-point dashboards from raw Eloqua imports to the newly created archival layer.
Leveraged Jira to track and manage data engineering tasks, bugs, and feature requests across Agile sprints; coordinated backlog prioritization and task assignment to align data pipeline development with business needs.
Power BI dashboard optimization:
Worked closely with business stakeholders to assess and understand reporting needs for reverse customer data.
Designed and implemented incremental refresh in Power BI to ensure daily updates without full data reloads.
Collaborated with Azure data engineers to optimize data processing and publication pipelines.
Stakeholder communication & data modeling:
Acted as liaison between Group Data Office and Technology Office to align data modelling standards.
Gathered requirements from data engineering team and participated in weekly status meetings to provide implementation updates and resolve blockers across teams in Germany, Poland, and India.
Documentation & quality assurance:
Prepared end-to-end technical design documentation, data flow diagrams, and Power BI audit guides for future reference.
Participated in UAT sessions with business users to validate data outputs and report accuracy.
UbiqueSystem
Migrated Oracle database to Microsoft Azure, incorporating data cleaning and merging with Azure services to establish a centralized data lake in Azure Data Lake Storage (ADLS) for enhanced processing and analytics.
Served as Services Solution Architect, translating business requirements into scalable Azure-based architectures ensuring cost efficiency and high performance.
Architected cohesive integration with partner systems and third-party applications alongside Development Engineers.
Assessed, migrated, and modernized legacy applications to Azure with optimal public or hybrid cloud deployment models.
Provided recommendations to optimize Azure usage costs by analyzing consumption patterns, identifying optimal resource scaling, and recommending efficient instance types.
Designed and implemented Azure cloud infrastructure including Virtual Network (VNet), Azure SQL Database, Azure Synapse Analytics, auto-scaling configurations, and compute resources.
Created assessments covering cloud deployment type, Azure cloud services, OS, COTS, codebase, database, application dependencies, and disaster recovery requirements.
Maintained up-to-date knowledge of Azure innovations, IT trends, and business requirements to identify cost-effective efficiency options.
IA Pvt. Ltd
Project 1: AWS Athena replaces PostgreSQL for Autodesk to support complex data ingestion, processing, and analytics at scale.
Led the development team in designing AWS cloud-based solutions aligned with AWS Competencies and general cloud-managed services.
Implemented Agile methodology for efficient technical operations oversight.
Developed Customer Data Platform (CDP) capable of complex data ingestion and analytics.
Created data analysis web pages on a portal with comprehensive technical information.
Generated user stories and conducted requirements analysis; evaluated internal systems and formulated training initiatives.
Project 2: Automated policy renewal using AWS services (EC2, S3, RDS), CI/CD pipelines, Kubernetes, Docker.
Created and maintained fully automated CI/CD pipelines for code deployment using Octopus Deploy and PowerShell.
Managed and monitored AWS infrastructure including backups, patches, and scaling; achieved $3,000 monthly cost reduction by eliminating unnecessary servers and consolidating databases.
Built Kubernetes clusters and deployed Docker containers to transform monolithic apps into microservices, enhancing developer workflow and scalability.
Reduced deployment time for critical agile project infrastructure from one month to a few days.
Managed GitHub repositories and permissions including branching and tagging.
SArT.ODSatSaYNArTcEhLitPeVcTt.(ALTWDS.)
Project 1: Database migration on AWS Cloud for Aegon Asset Management.
Migrated Oracle Data Warehouse to AWS Redshift using AWS SCT for schema conversion and DMS for data loading.
Engaged in consulting with customers to understand needs and propose optimal solutions.
Collaborated on system analysis and design; created Oracle RDS and Redshift instances for DMS connectivity.
Prepared technical specifications, business requirements, and process flows; developed workflow using AWS services and Snowflake.
Coordinated client demos; created Power BI dashboards and participated in testing.
Prepared runbook and ARB documentation for client approval.
Project 2: Recurring Data Set for CDPHP (Healthcare) using AWS (EMR, EC2, SQS, SNS, S3, Lambda, Athena, Step Functions, CloudWatch) and Big Data technologies.
Led a team as Big Data Engineer, coding in Scala with IntelliJ, creating JAR files via SBT and submitting Spark jobs.
Transferred data from AWS S3 to HDFS cluster using Informatica; developed Hive UDFs and addressed security privilege challenges.
Worked on SparkSQL to fetch data from multiple tables into lookup tables; implemented incremental daily loading with duplicate checks.
BSAigADMatAaTEEnCgHinNeOerLOGY INC.
Predictive Model CSAA for AAA with Hadoop, Scala, HDFS, MapReduce, Hive, Sqoop, Oozie.
Developed claim fraud and subrogation predictive models using machine learning algorithms.
Employed Oozie to orchestrate workflows involving REST API calls and R layer communication.
Worked with two datasets using HiveQL and Pig Latin; utilized Apache NiFi to automate and track data flow.
Wrote Python MapReduce code for security processes; synchronized structured and unstructured data with Pig and Hive.
Imported data from RDBMS to HDFS using Sqoop; created external tables and performed Hive subqueries; implemented dynamic partitioning and bucketing.
Scheduled and managed Oozie jobs, identified errors, and handled rescheduling.
Managed data via Hive Web Interface on Cloudera Hadoop; deployed applications on Talend Cloud AWS and Azure.
PCOroGgNraIZmAmNeTrTAEnCaHlyNsOtLOGY SOLUTION
Big Data Analytics for KeyBank: Business Banking and Credit Underwriting System (BBC) with Hadoop, Pig, Hive, Sqoop, Java.
Developed Hive queries for initial and incremental loads; ran applications through Oozie workflows.
Coordinated requirement gathering and task demonstrations with clients; assigned tasks and participated in development.
Wrote native MapReduce programs in Java; tested with JUnit; ensured timely production releases.
SNoEfStwT TaEreCHEnNgEiTnePeVrT LTD
Intellect Payment Service Hub (PSH) with Core Java, JSP, Servlet, JavaScript, WebSphere.
Centralized payment flow processing for customers, implementing automated controls adhering to payment policies.
Collaborated with internal and external clients to capture user requirements; analyzed and implemented code across development.
Modified database tables at procedural, modular, and database levels.
REDajUivCAGTaInOdNhiAPNroDuTdRyAoIgNikINi VGisBhawchaevliodryaolfaEynagineering
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Banking and Finance (7.5 years), Insurance (2.5 years), Information Technology (1.5 years), Healthcare (1.5 years), and Energy (0.5 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (11.5 years), Business Intelligence (8 years), Operations (1 year), and Marketing (0.5 years).
Summary
AWS and Azure Data Architect with 12 years of experience in designing and implementing cloud-based data solutions. Expertise in Azure Synapse Analytics, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), and Databricks. Skilled in database migration, ETL/ELT optimization, and end-to-end data architecture. Strong background in Python, SQL, and Power BI, with proven success in automating data pipelines, reducing costs, and improving data accessibility, accuracy, and security. Adept at collaborating with cross-functional teams, ensuring compliance with industry best practices for data governance and security.
Skills
- Experience In Various Solution Designs, Languages, And Architecture.
- Solution Definition And Problem-solving Skills.
- Practical Experience In Project Management And Coordination With Team.
- Familiarity With Security Management, Data Integration, Data Analysis, Data Modeling And Data Mining.
- Experience And Knowledge Of Cloud Computing.
- Good Understanding Of Business Processes.
- Strong Organizational Skills.
- Strong Understanding Of Analytical Skills And Techniques.
- Excellent Interpersonal, Communication, And Negotiation Skills.
Languages
Education
Rajiv Gandhi Proudyogiki Vishwavidyalaya
Bachelor of Engineering · Bhopal, India
Certifications & licenses
AWS Certified Solutions Architect - Associate
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Ritika based?
What languages does Ritika speak?
How many years of experience does Ritika have?
What companies has Ritika worked for in recent years?
Which industries is Ritika most experienced in?
Which business areas is Ritika most experienced in?
Which industries has Ritika worked in recently?
Which business areas has Ritika worked in recently?
What is Ritika's education?
Does Ritika have any certificates?
What is the availability of Ritika?
What is the rate of Ritika?
How to hire Ritika?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a
Nearby freelancers
Professionals working in or nearby Frankfurt, Germany
