Amrita Rani Email & Phone Number

San Jose, California, United States

✅ Engineered and optimized SSIS packages employing advanced Control Flow Tasks, sophisticated Data Transformations (e.g., Lookup, Derived Columns, Conditional Split), and automated scheduling via SQL Server Agent, ensuring seamless and efficient ETL operations.✅ Orchestrated the comprehensive migration of big data workflows to Google Cloud Platform (GCP), leveraging GCP Data Fusion to automate processes, dramatically enhancing accuracy and processing efficiency.✅ Architected and implemented robust data governance frameworks on GCP, fortifying security, ensuring regulatory compliance, and mitigating operational vulnerabilities.✅ Revolutionized deployment workflows with advanced DevOps pipelines, facilitating seamless versioning, accelerated rollouts, and operational excellence.✅ Cultivated and mentored a team of five junior engineers, elevating technical capabilities, fostering collaboration, and driving measurable productivity improvements.

✅ Designed and meticulously optimized complex SQL queries, drastically reducing execution times and enhancing departmental reporting efficacy.✅ Automated routine data extraction processes through advanced SQL scripting and Python automation, streamlining workflows and reallocating critical team resources to strategic initiatives.✅ Collaborated with the data engineering team to rearchitect the data warehouse schema, achieving accelerated data retrieval and unparalleled reporting accuracy.✅ Conceptualized and delivered sophisticated Power BI dashboards, empowering executive leadership with actionable insights to inform strategic decision-making.✅ Conducted comprehensive analyses of customer behavior patterns, driving the refinement of targeted marketing strategies and significantly elevating campaign success metrics.

Mumbai, Maharashtra, India

✅ Amplified database performance by devising highly efficient SQL queries and procedures, bolstering system stability and operational reliability.✅ Architected and implemented advanced ETL database models, enabling seamless data integration and unlocking enhanced analytics proficiency.✅ Commanded a 30-member team to deliver uninterrupted 24/7 support for mission-critical applications, ensuring exceptional operational resilience with minimal downtime.✅ Optimized the requirements-gathering process by orchestrating collaboration with over 10 business analysts, resulting in the design of highly efficient and scalable database schemas.✅ Transformed application performance by reengineering database architectures with Erwin, delivering robust, scalable solutions aligned with strategic business objectives.

Pune, Maharashtra, India

✅ Engineered and customized over 70 BI reports in MS SSRS, delivering unparalleled reporting accuracy and tailoring insights to address a wide spectrum of client-specific needs.✅ Designed advanced multi-parameterized reports, enhancing user accessibility and streamlining data exploration for more impactful decision-making.✅ Spearheaded the resolution of operational inefficiencies in SharePoint applications, significantly enhancing system functionality and refining the user experience.✅ Conceived and implemented scalable SharePoint solutions, aligning seamlessly with client-specific objectives and driving operational excellence.

Mumbai, Maharashtra, India

✅ Engineered advanced data models to extract actionable insights, driving informed and strategic business decision-making.

Mumbai, Maharashtra, India

✅ Enhanced decision-making processes by leveraging sophisticated data modeling techniques to uncover impactful trends and opportunities.