Prerna Rajai
Senior Business System Analyst
Mississauga,ON
Summary
Results-driven Senior Business Analyst/Data Analyst with 12+ years of experience in data-intensive environments, specializing in business analysis, data modeling, and translating business needs into actionable insights. Skilled in stakeholder management, program execution, and customer-facing engagements to drive data-driven decision-making. Proficient in SQL, Python, Azure Databricks, Synapse, and Power BI, with expertise in ETL pipelines, data warehousing, and integration. Adept at problem-solving, critical thinking, and working in ambiguous situations while ensuring data privacy, compliance (GDPR, PII), and high-quality deliverables. Passionate about optimizing data strategies to support business objectives and enhance operational efficiency.
Overview
13
13
years of professional experience
10
10
years of post-secondary education
3
3
Certifications
4
4
Languages
Work History
Senior Business System Analyst
Cognizant Technology Solutions
07.2021 - 10.2024
- Company Overview: (Banking)
- Led a high-performing data engineering team, driving project delivery and cloud migration strategies.
- Managed a portfolio of data-driven projects, ensuring alignment with business and technical objectives.
- Spearheaded program & product management, translating business needs into scalable Azure-based solutions.
- Led customer-facing discovery sessions, refining project scope, processes, and navigating ambiguity.
- Collaborated on architectural decisions, guiding ETL pipeline development, Informatica-to-SQL migration, and cloud integration.
- Enhanced regulatory insights by processing 1000+ data elements for financial and market analysis reports.
- Established and maintained privacy & compliance frameworks (GDPR, PII) in cloud-based data storage.
- Led talent development, fostering innovation and aligning the team with strategic goals.
- Ensured quality standards, optimized workflows, and mitigated risks for scalability and efficiency.
Data Engineering Lead
Teradata
01.2018 - 06.2019
- Company Overview: (Retail)
- Analyzed campaign data using ETL code and Teradata database to guide client focus areas and managed migration of mappings and sessions, including repository backup and restoration, and addressed Informatica repository upgrades and security
- Monitored job schedules, created ServiceNow tickets for priority issues, and provided support during data migration to Microsoft Azure Cloud platform
- Enhanced Unix scripts to resolve testing team defects and troubleshooted database and workflow issues for performance improvements and interacted directly with clients to gather requirements and communicated effectively with internal teams
- Report program status coherently and succinctly to executive leadership in the organization
- (Retail)
Senior Data Engineer
Accenture
09.2016 - 12.2017
- Company Overview: (Pharmaceutical)
- Collaborated with the Business team to implement data strategies, build data flows, and develop data models and optimized SQL query using hints to enhance performance, resulting in a 30% reduction in processing time for data sets containing 5 million records
- Developed over 20+ mappings and workflows using Informatica, conducted thorough testing, and automated Informatica workflows, facilitating onboarding routines for 3 new sources and ensured smooth integration
- Created a reusable auditing framework for the 3 sources and is adopted by internal teams
- (Pharmaceutical)
Senior Data Engineer
Cognizant Technology Solutions
12.2011 - 08.2016
- Company Overview: (Pharmaceutical, Telecommunication)
- Analyzed customer requirements, recommending data model adjustments, and developed 50+ Informatica routines and Unix Scripts to streamline data processing
- Configured SAP BW as a data source reducing 25% of processing time, ensured seamless Informatica job releases, and maintained proactive communication with clients for any data-related issues
- Designed Sales Marketing Dashboards in Cognos, reducing the size of the report by 75% for iPad, and documented setup methods for client reference
- (Pharmaceutical, Telecommunication)
Education
Bachelor of Engineering - Information Technology
Mumbai University
High School Diploma -
Maharashtra State Board of Technical Education
Mumbai 05.2001 -
Skills
- Data Bricks
- Informatica
- SQL
- Unix
- Autosys
- Teradata
- Cognos
- Pgadmin
- SQL server
- Oracle
- Azure Data Factory
- ADLS
Certification
Microsoft Azure AI Fundamentals AI 900, 12/01/20
Timeline
Senior Business System Analyst
Cognizant Technology Solutions
07.2021 - 10.2024
Data Engineering Lead
Teradata
01.2018 - 06.2019
Senior Data Engineer
Accenture
09.2016 - 12.2017
Senior Data Engineer
Cognizant Technology Solutions
12.2011 - 08.2016
High School Diploma -
Maharashtra State Board of Technical Education
05.2001 -
Bachelor of Engineering - Information Technology
Mumbai University
Similar Profiles
Janardhanan PerumalsamyJanardhanan Perumalsamy
Sr. Executive Support at Cognizant technology Solutions, Cognizant Technology SolutionsSr. Executive Support at Cognizant technology Solutions, Cognizant Technology Solutions
DIKSHA GUPTADIKSHA GUPTA
Software Engineer at Cognizant Technology Solutions, CTSSoftware Engineer at Cognizant Technology Solutions, CTS
RAJAKUMAR PERIYASAMYRAJAKUMAR PERIYASAMY
Technical Lead at Cognizant Technology Solutions US CorpTechnical Lead at Cognizant Technology Solutions US Corp
UMANG SHROFFUMANG SHROFF
Senior Process Executive - Data at Cognizant Technology SolutionsSenior Process Executive - Data at Cognizant Technology Solutions
Cassandra MandapCassandra Mandap
Nursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery UnitNursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery Unit