Amiya Ranjan R. Email & Phone Number

New York, Ny, Us

New York, Ny, Us

• Partnered with stakeholders and cross-functional teams to gather requirements and brainstorm data and visualization needs.• Designed and developed data models with Azure Databricks, boosting data processing efficiency by over 25% and accelerating data availability by 30 minutes to several hours.• Led the migration of multiple tables through the Databricks medallion architecture from Bronze to Silver to Gold layers.• Created interactive dashboards for 250+ users, cutting decision-making time by 40%.• Designed and developed data pipelines processing over 400 million rows daily basis and reducing turnaround time by more than 20%.• Spearheaded the reengineering of a legacy data model and migrated 200+ reports from Cognos to Qlik Sense.• Built several Power BI dashboards to uncover ad-hoc data patterns and insights to help narrow down the decision-making time.• Delivered 30+ complex Cognos reports, generating 30,000+ monthly views for 1000+ users.• Optimized SQL queries and reports, reducing turnaround time by over 50% for the top 40 frequently used reports.• Lead an effort to collect raw and semi-structured data from Mongodb into the Data Lake, perform necessary transformations and present the data using various interactive visualizations.

• Re-engineered 5 complex Cognos reports, optimizing SQL to reduce waiting time by over 40%.• Developed a high-priority, complex Cognos report, utilizing a 200+ page SQL query, executed and burst to 50+ users within 10 minutes daily.• Architected, developed, and deployed 5 Cognos reports in each sprint, completing a 12-month project in 8.5 months.• Reengineered 40+ Cognos reports within 4 months for another client.• Wrote extensive SQL queries for data analysis and validation from various data sources.

• Streamlined the year-end ordering process, saving millions of dollars by automating monitoring using Cognos, SQL, and Tableau.• Reduced manual intervention, saving 300+ person-hours and minimizing errors.• Trained 30+ business users to maximize the potential of Cognos Reporting tool.

• Led the design and development of a highly used reporting application, reducing reporting needs from 70,000+ to 50 distinct reports, resulting in significant cost savings and maintenance efficiency.• Architected and developed 1,000+ reports across multiple projects, serving hundreds of users.• Utilized batch scripts and Cron jobs for automated data load, file transfer, and notifications.• Led a 14-member team in an onshore-offshore model, fostering growth and mentoring young talents.• Trained 50+ team members and business users on Cognos, TM1, and SQL technologies.• Played a key role in recruitment, proof of concepts, and project proposals.• Built strong client relationships and contributed to the organization's business growth.• Recognized with multiple awards and earned 2 promotions during tenure.

Bca, Computer Software Engineering

Master Of Business Administration (Mba), Information Technology

Education record

High School