Years of business analysis experience
Omkarnath Varanasi
Toronto,ON
Summary
Solutions-oriented Business Analyst possessing unique combination of business analysis, quality assurance testing and applications development experience in top-tier organizations. Solid SQL query writing skills paired with familiarity of visualization tools and techniques. Successful provider of financial services with 8+ years of comprehensive experience.
Overview
7
7
5
5
years of post-secondary education
5
5
Years with SQL & Data Analytics
Work History
Senior Business Analyst
Scotiabank
Dec.2022 - Jul.2023
- Developed a power BI dashboard to showcase all of the loyalty platform rejects to track customer enrollment/updates, transactions & redemptions.
- Managed platform requirements from the reject dashboard and worked with platform development team from ideation until delivery
- Developed content library to maintain clear & concise documentation related to the platform management.
Product Owner
American Express
Hyderabad, India
Jun.2022 - Dec.2022
- As a PO, I was responsible for a database & application migration for the Amex Collections space.
- Reviewed SQL scripts of existing procedures, worked with table owners across AMEX for data mapping and validation.
- Led a team of data engineers to convert all stored procedures with the new data variables. Daily scrum calls to discuss status and mitigate any potential risks to ensure smooth flow until go-live.
Sr Business Analyst
SiteMinder
Hyderabad, India
Oct.2020 - Jul.2022
- As a Product Manager, I was responsible for the 'Little Hotelier Basics' project from ideation phase until delivery working with teams across Siteminder for seamless system integrations to completely automate the customer onboarding via digital self sign up, subscription based billing, customer triggered automated offboarding.
- This solution drove in 22.6% reduction of the customer service handling requests which turn out to be a saving of around A$ 55,000 monthly and a reduction in the churn rate by around 1.2% with an increase in the Return purchase ratio.
- As a PM, developed the business use cases and solution along with the architect to streamline the integration between Workday Financials & Zuora (billing platform) to ensure seamless flow of billing data into WD so our leadership has more visibility towards the payables & receivables data.
Sr. Business Analyst
TSYS
Atlanta, USA
Jun.2019 - Aug.2020
- Joined as a Senior BA working under Issuing Solutions, worked with multiple banking clients to onboard them onto TSYS's ‘Loyalty and digital engagement’ platforms to enhance their customer journey via digital account management and rewards management.
- Work with vendor technical teams to enhance integrations with in-house application for Digital engagement for credit card users using REST APIs
- Coordinate with different teams – TS2, Product engineering, Branding, ETL, Conversion, Development, Testing & Program Management to successfully work towards delivery.
Business Analyst Consultant
Ernst & Young
Atlanta, USA
May.2017 - Jun.2019
- Joined as Business Analyst working under the EY Forensics platform, delivering web-based risk analytics platform. Promoted as a Business analyst/Scrum Master by July 2018 leading project teams to deliver custom web solutions in a Scaled Agile framework in 3-week sprints across US, EMEA & APAC.
- Led a team of 8 people within multiple countries to work in an agile environment and deliver 6+ client engagements.
- Owned product backlog for Client requirements and translated into technical requirements. Involved in design of prototypes using Balsamiq and prepared process & data flow maps. Coordinated UAT & Production deployment plans.
- Applying the technical skills in Tableau and SQL in data collection, data analysis and reporting to fetch the data from the warehouses for reporting.
Business Analyst Intern
S2IT Group LLC
Atlanta, USA
Sep.2016 - May.2017
- Worked on Insurance CLAIMS applications for Auto and Property LOB and Involved in testing Auto Insurance Renewals, New Business, MVR Reports functionality.
- Used SPSS for data cleaning, reporting and developed efficient and modifiable statistical scenario.
- Extracted data from Oracle, SQL Server and legacy systems using Talend to load it into a single data warehouse repository.
- Worked on writing SQL queries in performing Data analysis using window functions, joins, improving performance by creating partitioned tables.
Education
Master of Science - Industrial Technology & Operations
Illinois Institute of Technology
Chicago, USA Aug.2015 - May.2017
Bachelor of Science - Mechanical engineering
Osmania University
Hyderabad, India Sep.2010 - May.2014
Skills
- Workflow Analysis
- Business Process Improvement
- Gap Analysis
- Requirements Gathering
- Data Mapping
- Strategic Planning
- Technical Writing
- Business Planning
- Data Mining
- Narrative Use Cases
- Process Optimization
- Product Development
- Project Management
- Product Management
- User Acceptance Testing
- Microsoft Office Suite
- Integrated Reporting Information System (IRIS)
- Pivot Tables
- Microsoft TFS
- JIRA
- Rally
- Balsamiq
- Figma
- MS SQL Server
- Oracle
- RapidMiner
- Informatica
- Tableau
- Power BI
- Alteryx
- Advanced Excel
- Azure
- Sharepoint
- Confluence
- Bitbucket
- Postman
Timeline
Senior Business Analyst
Scotiabank
Dec.2022 - Jul.2023
Product Owner
American Express
Jun.2022 - Dec.2022
Sr Business Analyst
SiteMinder
Oct.2020 - Jul.2022
Sr. Business Analyst
TSYS
Jun.2019 - Aug.2020
Business Analyst Consultant
Ernst & Young
May.2017 - Jun.2019
Business Analyst Intern
S2IT Group LLC
Sep.2016 - May.2017
Master of Science - Industrial Technology & Operations
Illinois Institute of Technology
Aug.2015 - May.2017
Bachelor of Science - Mechanical engineering
Osmania University
Sep.2010 - May.2014
Similar Profiles
Raquel JohnRaquel John
Senior Customer Care Advisor-Social Media at ScotiabankSenior Customer Care Advisor-Social Media at Scotiabank
Kevin LevyKevin Levy
Director, Commercial Card Solutions, Global Transaction Banking, North America at ScotiabankDirector, Commercial Card Solutions, Global Transaction Banking, North America at Scotiabank
Radhika NarayananRadhika Narayanan
Officer III, Commodities Wind-down Operations at ScotiabankOfficer III, Commodities Wind-down Operations at Scotiabank
Madhav MakkerMadhav Makker
Senior Customer Experience Associate at ScotiabankSenior Customer Experience Associate at Scotiabank
Sinthuja VijayarajSinthuja Vijayaraj
Intern Waitress at Cibo Wine BarIntern Waitress at Cibo Wine Bar