Manvi Tandon Email & Phone Number

Christchurch, Canterbury, New Zealand

Christchurch, Canterbury, New Zealand

• Developing stored procedures to create Dimension and Fact tables, following a star schema architecture for efficient data modeling.• Utilizing Microsoft Fabrics to architect and deploy robust data pipelines, incorporating Python notebooks for extracting data from diverse source systems.• Implementing Medallion architecture principles across data warehousing initiatives, ensuring scalability and enhancing performance of data processing workflows.• Creating Datamarts and Semantic Models within Microsoft Fabrics, optimizing data storage and retrieval efficiency to meet analytical and reporting needs effectively.

Christchurch, Canterbury, New Zealand

• Worked in Holiday Act Remediation team and processed complex datasets• Verified payroll calculations and updated models to comply with the Holiday Act and any changes by MBIE (Ministry of Business, Innovation and Employment)• Created workflows using Alteryx for data cleansing, manipulation, and data analysis• Managed SQL server, databases, and team groups to protect client data for various engagements• Recalculated entitlement for each employee and performed QA checks • Scheduled Alteryx workflows to automate data processing

Auckland, New Zealand

• Create reports using Power BI to depict reconciliation between the metering system to have an accurate billing cycle• Build reporting server, install enterprise data gateways and setup dataflows for a point in time reporting• Schedule and publish the reports to present accurate data analysis to help make business decisions by various stakeholders• Experienced in extracting, transforming and loading data from Excel, Flat file, Oracle, Microsoft Exchange to MS SQL Server by using SSIS package.• Experience in designing, configuring, deploying and implementing an incremental load on SSIS packages• Analyze data from different on-premises and cloud data sources• Experience in using R programming language, DAX formulas, M code for creating data visualizations using Power BI• Involved in creating complex measures including KPIs, aggregation by DAX in SSAS tabular model according to business requirements

Punjab, India

• Gather and translate business requirements into solutions• Prepare written proposals, requirements specifications and solution specifications.• Identify business & systems process improvements from Big Picture to the detail level.• Excellent communication skills to manage and liaise with business and technical consultants to explore business process improvement opportunities• Create models, use cases, process flows, specifications, diagrams and charts to provide direction to developers, designers, and vendors• Assist in the development of business case documentation and provide training to new joiners• Help execute projects through the waterfall and agile SDLC • Provide project support for development personnel as new functions/processes are designed, written, tested and implemented• Assist ERP systems users with data conversion, data validation, and development of test/UAT scripts• Provide clear communications to multiple groups including business partners and offshore teams to support efficient development

Punjab, India

• Created reports/dashboards using BI Publisher, Tableau and Power BI• Maintaining backups using RMAN-archive/incremental/full backup• Creating shell scripts for automating the database clone process and integrating it with OEM which saved 10-15 hours of manual work• Solaris to Linux Migration of Discoverer and OID• Non-ASM to ASM Migration• Managing concurrent programs/request, user management, sanity check, assigning responsibilities• Monitoring 500+ Oracle/SQL database and applications 24x7 using OEM• Alert tuning, UDM creation in OEM• Relinking instances after Linux patching activity• Ticket monitoring using HPSM/ITSM

Punjab, India

• Writing SQL’s to create and maintain the scheduled reports• Work on OEM alerts and monitor all databases 24x7• Work on HPSM tickets and engage bridge calls in emergency

Greater Noida

• Monitoring Oracle databases using HP OpenView• Understand Linux commands and create shell scripts to help in daily tasks• Troubleshooting database issues and performance• Patch analysis

Bachelor Of Engineering - Be, Computer Science, Cgpa 8.92

Activities and Societies: • Finance Head of 3C Tech Club • Active participation in Badminton and Chess Tournaments

Education record

Activities and Societies: • Chess (National Level) • Badminton • Swimming