Ankush Mahajan
Summary
ROLES Business Analyst Risk Manager Data Quality Analyst Data Governance Sr ETL Developer Technology consultant Seasoned Business Analyst offering [Number] years of [Industry] industry success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Business Analyst and Technology Consultant
Deloitte Consulting LLP
11.2016 - Current
- Consultant responsible for developing, overseeing, organizing, storing, and analyzing data working in complex environments with expertise in understanding, analyzing and documenting Business Requirements, Functional Specifications and Business Process Flow
- Extensive experience in implementation of CECL (Current Expected Credit Loss) GAAP Standards for American Express
- Functional and Technical Expertise in developing and testing of end-to-end data warehouse to populate Regulatory Reporting for Disclosures 10Q & 10K filing, Unused Line of Credit reporting, Y9C reporting, Counterparty Management, Risk management etc
- Using SQL/Oracle, Tableau & Informatica
- Implementation of Data Governance and Data Quality Rules for end-to-end flow of data
- Treasury operations, FATCA reporting, Interest Rate risk, Retail Banking (Fraud and Risk Management), Insurance Services
- Extensive experience in the areas of Program / Project Delivery, Technology Integrations / Implementation, Process Improvements, ETL Analysis and Team Management
- Extensive qualifications in all facets of information systems methodology from conceptual design through documentation, implementation, quality assurance, user training and change management
- Developed strategies and processes with the customer in areas such as performance metrics and measure, escalation, change management and communication
- Excellent understanding of Financial Instruments (Bonds, CDs, Loans, Inter-Company funding, Letters of Credits, Derivatives) and regulatory and compliance reporting
- Extensive understanding of software development lifecycle (SDLC) including analysis, design, development, and testing of software application
- Conducted Joint Application Development (JAD) sessions and interviewed Subject Matter Experts (SMEs), asking detailed functionality aspects of the business process, and carefully updating the information to the requirements in an easily understandable format
- Experience in preparation of Deliverables, Business Requirement Documents (BRD), detailed Functional Specifications and Non-Functional Specifications, developing Use Cases and Test Cases
- Conducted GAP Analysis, Impact Analysis, modeling Businesses Processes, and prepared Training Manuals and Knowledge Transfer manuals
- Tracing requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM), Jira, Rally, : Current Expected Credit Loss (CECL) implementation
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Collaborated with stakeholders to define project objectives and criteria.
- Performed gap analysis to identify areas of improvement.
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Generated business intelligence reports to inform strategic decision-making.
- Executed analysis of risks and identified risk mitigation strategies.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Generated ad-hoc reports to evaluate specific business requirements.
- Created data models to support decision-making processes.
- Utilized data visualization techniques to present and explain complex data sets.
- Identified patterns and trends in large data sets and provided actionable insights.
- Developed and implemented data governance policies and procedures.
- Designed and developed data pipelines to acquire, clean and process data.
- Deployed predictive analytics models to forecast future trends.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
- Wrote and optimized in-application SQL statements.
- Interpreted data models for conversion into ETL diagrams and code.
- Verified performance and reliability of development database transformation solutions via extensive simulation testing.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Organized integration of data and migration activities to enhance operations.
- Analyzed enterprise data holdings to reduce redundancy of data within existing systems or improve conflation of datasets from one system to another.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Identified, troubleshot and corrected bugs and bottlenecks.
- Developed mappings, workflows and tasks using [Software].
- Prepared technical design documents and specifications for [Use].
Product Owner and UAT Lead
- The global financial crisis highlighted the need for new accounting standards - Current Expected Credit Losses (CECL) to provide guidance on reserving for credit losses American Express financial services corporation engaged Deloitte to their end-to-end IFRS9 and CECL global implementation
- Ankush led the Disclosure Team and facilitated and coordinated the large-scale implementation of CECL GAAP Standards, Disclosure reporting for 10 Q & 10K filing, Unused Line of Credit Reporting, Y9C, Counterparty and Legal Entity Management in alignment with global markets regional regulatory requirements
- Responsibilities:
- Lead team of Onshore and Offshore through analysis of current state, working with Business users and Product group to identify various data elements that were required for defining disclosures of the financial corporation and thereby leading end-to-end implementation of CECL -disclosures reporting
- Worked with Tech Partners to identify various data elements that were required for data integration into the existing client's data warehouse and ETL flow and Load using Oracle and UNIX
- Worked with source system developers, SMEs, Data administrators, Data integration team members and Risk professionals to determine the data transformation method and required data load strategies required for Data Integration implementation and risk mitigation strategies
- Worked with Business users and Product group to identify various data elements that were required for fraud risk rule and ETL flow and Load using Informatica
- Worked with source system developers, SMEs, Data administrators, Data integration team members to determine the data transformation method and required rule engine for fraud strategies implementation
- Worked closely with the SMEs and Risk Professionals to identify elements that contribute to risk
- Performing Quality reviews for data warehousing applications for cross checking Standards and best practices using American Express Data quality standard documents
- Presented system prototypes to the business stakeholders during JAD sessions
- Presenting business solution document walk-through to the Business, Product and Developer to help them understand the future state of the system
- Provided project status to project owners in weekly meetings and kept track of project using Rally Dashboards
- Created current and future process models and identified existing gaps that required to be addressed
- Documented requirements change requests and technical change requests for stakeholders for any requirement or technical changes that came up after business solution document sign-off
- Performed root cause analysis on bug list with Quality Analyst and developers and suggested enhancements to the existing application.
Sr. ETL Developer and Consultant
Synchrony Financial
- Synchrony Financial provides private label credit cards for various clients like Amazon, Walmart and provides credit card and fraud analytics to various fuel clients, like BP PLCC, Chevron, and Phillips 66 Consumers PLCC etc
- As with these credit cards or private labeled cards, there is always a risk of fraudulent transactions or cards being counterfeited
- So, in order to mitigate the risk and to identify the good transactions from the fraudulent transactions and also to develop strong rules so as to capture more bad transactions without affecting more good customers, we need to design good fraud capturing strategies and rules
- Responsibilities:
- Worked with Business users and Product group to identify various data elements that were required for fraud risk rule and ETL flow and Load using Informatica
- Developing Fraud control strategies using Informatica and validation of fraud rules and application data by querying directly to the database
- Worked with source system developers, SMEs, Data administrators, Data integration team members to determine the data transformation method and required rule engine for fraud strategies implementation
- Worked closely with the SMEs and Risk Professionals to identify elements that contribute to risk
- Performing Quality reviews for data warehousing applications for cross checking Standards and best practices using synchrony quality standard documents
- Presented system prototypes to the business stakeholders during JAD sessions
- Presenting business solution document walk-through to the Business, Product and Developer to help them understand the future state of the system
- Provided project status to project owners in weekly meetings and kept track of projects using MS Project for status reporting and project planning
- Created current and future process models and identified existing gaps that required to be addressed
- Documented requirements change requests and technical change requests for stakeholders for any requirement or technical changes that came up after business solution document sign-off
- Performed root cause analysis on bug list with Quality Analyst and developers and suggested enhancements to the existing application
- Project 3: Interest Rate Risk Management
ETL Developer
GE Capital
- GE Treasury Risk team performs Asset & Liability management effectively through the consolidated Risk models of GE Businesses
- Currently there is no standardized process for the data acquisition and consolidation, IT team will help the Risk team to streamline and automate the existing processes & procedures thus ensure timely and quality data available for the ALM analysis to the GE Treasury Risk Analysts and managers
- Responsibilities:
- Worked closely with project managers, business users to formalize a business idea and define requirements
- Review of functional design and impact analysis
- Developing ETL code using BDI as an ETL tool
- Planning of testing scenarios and preparation of Test cases
- Creating ETL applications using Informatica and BDI as ETL tools and writing custom SQLs
- Performing Quality reviews for data warehousing applications for cross checking Standards and best practices using GE quality standard documents
- Validation of data warehousing application data by querying directly to the database
- Developed test cases and participated in UAT (User Acceptance Testing)
- Coordination with source systems owners and quality assurance teams to maintain the standards in the data warehouse
- Analyze and resolve any real-time issues in production and help the support team by knowledge sharing and brainstorming
- 4: GECC Treasury Foreign Exchange System, incurs interest expense when it synthetically funds' assets of the businesses using FX instruments
- Synthetic funding refers to various vehicles used by GE Capital to convert funding raised in one currency (e.g., issue debt is USD) to funding in another currency (e.g., swap USD proceeds from debt issuance to EUR)
- On both a monthly and quarterly basis, interest costs incurred are allocated back to various GE businesses which require funding
- This liquidation of GE's cost of funds by GE Capital Treasury is known as the “interest allocation process”
- FXS project deals with maintaining the current and historical trade related data of Key Figures, accounting entries, summary balances, cash flow data, market rates and trade and trade leg data
- Data is captured from disparate source systems and is fed to a data warehouse where the data is organized using the Star Schema dimensional model
- It provides Reports which are used to analyze Composite Rate and to calculate GE's cost of funds for synthetic funding using FX trades, which will be used as a basis to allocate interest back to the businesses as well as for internal and external reporting purposes
- Responsibilities:
- Involved in the full Software Development Life Cycle
- Requirement gathering for production releases, review of functional design and impact analysis
- Correlate and analyze the different source systems, identify and understand the business rules
- Planning of testing scenarios and preparation of Test cases
- Creating ETL applications using Informatica and Oracle
- Performing Quality reviews for data warehousing applications for cross checking Standards and best practices using GE quality standard documents
- Validation of ETL application data by querying directly to the database
- Analyze and resolve any real-time issues in production and help the support team by knowledge sharing and brainstorming.
Education
MBA - Finance
Institute of Management Technology
Ghaziabad, India04.2020
Bachelor of Engineering - Computers Science
University of Jammu
Jammu, India07.2008
Data Scientist Tool Kit Certification -
John Hopkins University
The Language and Tools of Financial Analysis -
University of Melbourne
Snowflake -
Udemy
Skills
- SKILLS INVENTORY
- Current Expected Credit Loss
- Disclosure & Regulatory Reporting
- Risk Analytics - Credit Risk and Market Risk
- PD, LGD, EAD, ECL, Allowance, Write Off, Recovery
- Disclosure Reporting Counterparty management
- Data warehouse Development
- Client Communication Management
- Knowledge of Dual Risk Rating Framework Knowledge of Customer Ratings & Loan Ratings
- Agile Methodology - JIRA, Rally
- Analysis/Design:
- User Requirements Gathering
- Impact Analysis & System /GAP Analysis
- Design and DMS Development
- Adaptability to Client's Methodology
- Change Management and Data Flow Diagrams
- Defining Test Scope and Test Cases
- Test Planning & Execution
- User Acceptance Testing (UAT)
- Functional:
- Current Expected Credit Loss (CECL)
- GAAP Standards Implementation
- Credit Card Fraud Management
- Interest Rate Risk Management
- Treasury Management
- Loans & leases, deposits, derivatives, securities
- Technical:
- ETL Management and Statistical Analysis
- SAS, SQL, Informatica and Python
- Develop Fraud Rules using Defense Edge
- Databases (Oracle, SQL Server), Snowflake
- AWS, Machine Learning – Training
- Strong expertise on tools like Informatica, SAS, Defense Edge along with Oracle 10g, SQL/ PlSql and power curve coding
- SQL
- Product Demonstration
- Scrum Methodology
- UAT Support
- Project Management
- Enterprise Data Management
- Warehousing Solutions
- Data Warehousing Management
- Structured Query Language (SQL)
Accomplishments
- Coordinated cross-functional teams and provided business analysis for [Number] projects totaling $[Number] million.
Certification
- [Area of certification], [Company Name] - [Timeframe]
Timeline
Business Analyst and Technology Consultant
Deloitte Consulting LLP
11.2016 - Current
Product Owner and UAT Lead
Sr. ETL Developer and Consultant
Synchrony Financial
ETL Developer
GE Capital
MBA - Finance
Institute of Management Technology
Bachelor of Engineering - Computers Science
University of Jammu
Data Scientist Tool Kit Certification -
John Hopkins University
The Language and Tools of Financial Analysis -
University of Melbourne
Snowflake -
Udemy