Abinaya Mohan BA

Abinaya Mohan
[email protected]
Work Experience Summary
● Experience in Data Analytics for huge data sets, Business Intelligence development in the areas of
Finance, Compliance, Risk, Sales and Marketing.
● Expertise in implementing ETL, Adhoc Frameworks, Dimensional Modelling Star/Snowflake schema.
● Experience in predictive forecasting analysis for Sales and Marketing, Risk departments using Python
● Worked with Shareholders, Key Business Customers and Project Managers to conceptualize, design
and implement products and data models.
● Strong Knowledge in Microsoft Tabular.
● Experience in working in Agile environment as a Business/Data Analyst for 5 years. Worked on two Scrum
teams and filled in as Scrum Master for Program / Project managers on several occasions.
● Expertise in Story Grooming, Refinement of the JIRA to estimate the work based on Story Points, SIT and
UAT before delivering the product back to the business.
● Experience in conducting daily stand ups, documenting meeting minutes, updating project plans, providing
project reports, monitoring all project activity, and advising Executive Sponsor on any project issues.
● Highly skilled at creating BRD, FRD, User Stories, Story narratives, User Cases & Test Cases.
● Expertise in analytics dashboard tools such as Tableau, Power BI, IBM Cognos.
● Lead UAT & training sessions for business stakeholders and ensure that client expectations are met.
Technologies:
Agile Development & Scrum Sprint Planning, Sprint Review Meeting, Daily Scrum, Impediment Log,
Ceremonies Burn down chart
Tools JIRA, Confluence, MS Project, MS Office, MS Visio, HP ALM, HP QC
Database SQL Server 2008, PostgreSQL, Oracle
Programming Languages SQL, Python
BI Data Visualization tools Tableau, Power BI, IBM Cognos
Certifications
• Database Management Essentials
• Data Modelling in Business Intelligence
• IBM Cognos Analytics
• OpenText Exstream
• Salesforce - Customer Relationship Management
Experience Details:
BI Analyst— Zycada Networks, Feb 2020 - Present - Campbell, California
• Designed interactive and intuitive dashboards for customers to monitor the millions of incoming traffic and
analyze the requests/responses using Tableau, Grafana.
• Provided business insights based on data to further improve operations and processes using data mining
techniques.
• Partner in the creation and tracking of KPI’s that monitor project performance.
• Designed tuning mechanisms to tune the huge traffic database as well as the queries to complete a set of
given jobs or tasks in optimal time.
• Build interactive ops portal to automate daily manual operation tasks.
• Published Tableau workbooks on Tableau Server with view permissions, scheduling, and authentication
features for refreshing the extracts on a particular schedule.
• Provided analysis to help develop Sales, Product Development for Sales and Marketing team to meet the
divisions' strategic and financial objectives.
• Automated routine data referencing, retrieval and entry tasks that use multiple programs and websites
using Excel VBA
• Lead team in multiple projects by completing and updating project documentation; managing project
scope; adjusting schedules when necessary; determining daily priorities; ensuring efficient and on-time
delivery of project tasks and milestones; following proper escalation paths; and managing customer
relationships
• Scheduled Jobs in Flows and ADF Pipelines,
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler, and third-party tools.
• Provided analysis to help develop Sales, Product Development for Sales and Marketing team to meet
the divisions' strategic and financial objectives.
• Created burndown charts/release plan after each Sprint to track project progression.
• Monitored project progress & milestones across various projects using appropriate metrics & tools such as:
JIRA, Confluence & Microsoft Project.
• Demonstrated good understanding of software engineering methods such as Agile (SCRUM) and proved
success in project management and SDLC processes.
• Reviewed test cases for sign off and assisted testers in testing, participated in pre-SIT testing, supported UAT
and End 2 End Testing.
Business Analyst - General Motors Financial IO – June ’15 - Jan ‘20 - Detroit, Michigan
• Participated as a Business Requirements SME to support the development of Business Requirement

Documentation (BRD’s), Functional Requirement Document (FRD’s), User Stories, Technical Designs, Test
Strategy and Plans, etc. aligned with the roadmap.
• Worked on performing various dashboard activities such as grouping, sorting, ranking and ordering the
data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Trend Analysis.
• Developed Tableau visualization with plotting line graphs, Tree maps and heat maps using MISO data.
• Design and create models in Cognos Framework Manager and publish the package
for reporting needs through Cognos using Dimensional and Relational databases.
• Restructuring SQL queries for better performance and added features to reports.
• Developing automated prediction analysis program using Python where we use
predictive modelling method to predict the risk of fraudulent customers with current available datasets.
• Gather requirements for the development and design of database and report
generation through collaboration with business analysts and end users.
• Developed a Python tool to forecast company sales for next 5,10 years so as to increase marketing to
increase the valuable customers.
• Led “Ad Hoc Reporting” project by creating Data model and reports for the Operational Data Store
that contains huge data load from raw data applications.
• Monitored project progress & milestones across various projects using appropriate metrics & tools such as:
JIRA, Confluence & Microsoft Project.
• Demonstrated good understanding of software engineering methods such as Agile (SCRUM) and proved
success in project management and SDLC processes.
• Development of front-end portal pages using JavaScript in compliance with the customer’s requests.
• Train end-users for better generation of reports.
Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
• Performed Tableau Admin responsibilities for the company: administration of the Tableau
servers, development of workbooks.
• Published the developed Tableau dashboards into production and refreshed the scheduled reports, tuned
the
performance of the dashboards and created Tableau functional design documents.
• Developed Tableau Dashboards to articulate the performance of the ETL load on a daily basis and Audit
dashboard to calculate the usage of packages and the run of online reports.
• Implemented OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views,
attributes and dimension members using SQL Server Analysis Services (SSAS).
• Worked closely with the Project Management Team to analyze and consolidate requirements
to meet the project deadlines.
• Took project ownership across all phases of SDLC and managed daily status calls to track project progress &
milestones across various projects and identified risks with project deliverables.
• Conducted Sprint planning meetings with Sprints running every 2 weeks followed by retrospect meetings at
the end of each Sprint to identify process improvements.
• Working with Shareholders to acquire the requirement specifications, consolidating the tables and columns
needed in the data model and to plan the Project deadlines, testing, and delivery.
• Requirement Gathering of changes required in the system for the
enhancement of Cognos application performance and reliability.
Project Name: Transition Arlington Technology Platforms and Cognos Report

Consolidation Summary: North America Arlington Infrastructure to incorporate LAO IO Cognos. Cleaning up
the existing Cognos Environment and make performance improvements to the Customer Chile / Colombia
reports. Modifying the Cognos / Framework Security groups to use the security directly based on Active
Directory (AD) groups and create new AD groups if necessary.
● Working with Project Managers to decide on the project timeline and aligning the project to meet
the deadlines.
● Working with Sustain teams to arrange the security groups to reflect the new security protocol.
● Moving of all the Data warehousing tools to the new environment and making sure they run
smoothly without any glitches.
Project Name: Commercial Information Warehouse

Summary: Creating Dynamic Model Framework using a Test- Driven Development environment and further
developing automated report using the same model. Working with the Business team in United Kingdom and ETL
team in Detroit to create a successful model and reports. Performing data verification in database by scheduling and
executing few respective jobs.
● Requirement gathering, design, development of critical mappings, validation, testing & move to production.
● Define, develop, and troubleshoot mapping variables, workflow variables and relational connections.
● Identify problems in existing production data and developed scripts to correct them
● Created executive dashboard which will provide the executives gets insight/details of Commercial
Vehicles performance.
● Created Tableau Dashboard using geographical and heat map visualizations for Reports landing page and
Audit for the package usage.
● Experience on Tableau admin activities such as granting access such as creating users from .csv,
creating groups and adding users to groups, publishing a workbook.
Project Name: Prediction Analysis

Summary: Developed Automated Prediction Analysis program for the Risk Department using Python where we use
predictive modelling method to predict the risk of customers being fraudulent with the current available datasets.
• Using current customers credit score and history to identify High risk and Fraud customers.
• The target variable is converted to (1,0) and then using a binning algorithm we plot the values creating a plot.
• Split the data creating the cross tab with the prediction for the High risk and Fraud Customers.
• Create automated monthly executive dashboard with the prediction chart for Risk Director and
Lead Managers to identify the department’s growth.
Project Name: Retail Information Warehouse

Summary: Developing Automated Reports using the created Relational Framework model with the Operational
Data Store. Setting up security procedures and new database connections. Worked with clients in Mexico, Brazil,
Chile & Colombia for data collection, data analysis, data modelling and to procure data from database to reports
and provide Business Intelligence solutions to their requests in a timely manner.
● Deep dive in the database model and existing application functionality, system data flow design,
study different source system to understand their sync activity and deciding system that can be
designated as source of truth for different business functionalities.
● Gather requirements for the development and design of database and report generation through
collaboration with business analysts and end users.
● Provide the shareholders with multiple solutions that work both short term and long-term advancements
that can be implemented to improve the performance and the look of the dashboards.
● Perform requirement/gap analysis; coordinate with Source system SMEs and Data modelers to deliver data
capabilities that meet application requirements.
Project Name: Customer Relationship Management (CRM) with Salesforce API data
Summary: Developing ETL Jobs, CRM Data model and Dashboards using the Salesforce APIs data to promote
Customer campaigns to increase the revenue and earn customers for life. Incorporate the CRM models with existing
Operational Data Store model to further market campaigns for customers based on their Credit history and loyalty.
● Working with Architect and reporting team for Data Modeling.

● Developed the ETLs using IBM Data Stage to source and load data into oracle database.
● Creating Run book for on-call support person.
● Developing custom ETL design and development for complex, multi-source data warehouse application.
● Quickly assess the impact of production system changes to the existing analytics and implement changes
to the warehouse ETL and reporting code to ensure consistent and accurate BI reporting.
● Implement indexes on tables for high performance along the huge tables to avoid overload on the
data servers.
Project Name: Express Approval using VBA
Summary: Automating the process of creating Credit reports using VBA so that new customers get a timely Auto
Approval with respect to their Credit Score for the Risk - Auto Approval Team in Brazil and Mexico.
● Working with the Risk Team directors to collect the requirements in what to be achieved in the
automation.
● Suggest some alternative measures to avoid manual excel inputs to make the entire process automated
to avoid human err .
● Create and execute unit test plans based on validation requirements.
● Provide follow up and sustain activities on the project.
Project Name: ROM Meeting Tool Using VBA

Summary: Developing reports for Brazil, Mexico Risk department to automatically generating a Risk report based
on set of regulations for each country to flag the high-risk customers and to identify the least Risk customers for
further campaign purposes.
● Working with shareholders from Latin America countries in getting the different policies on Risk Calculation
and Campaign discounts.
● Creating solution that work for multiple countries based on their specific policies in that country.
● Securing the automation depending on roles of the customer using the reports based on the AD groups
they are added.
● Build dashboards from the automated data for the high-level management to give an overview of the Risk
the countries face from their customers in a particular period.
Education
Wayne State University, MI — Masters in Computer science 2014-2016
Anna University, Chennai — Bachelors in Computer science 2010-2014

Abinaya Mohan BA

Uploaded by

Copyright:

Available Formats

Abinaya Mohan BA

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Abinaya Mohan BA

Uploaded by

Copyright:

Available Formats

Abinaya Mohan

BI Analyst— Zycada Networks, Feb 2020 - Present - Campbell, California

• Participated as a Business Requirements SME to support the development of Business Requirement

Project Name: Transition Arlington Technology Platforms and Cognos Report

Project Name: Commercial Information Warehouse

Project Name: Prediction Analysis

Project Name: Retail Information Warehouse

● Working with Architect and reporting team for Data Modeling.

Project Name: ROM Meeting Tool Using VBA

You might also like