Qualification Highlights

• 9 years of experience as Business Analyst/ Data Analyst in Corporate Finance Accounting, Capital Markets, Corporate Actions and Investment Banking
• Expert level knowledge in MS EXCEL, MS Access, MS Power Point, SQL, MS Visio, creating use case diagrams, activity diagrams and data mapping
• Motivated, self-starter and active team player/leader with strong focus on success and self/team-accomplishment
• Exceptional creativity, leadership, effective communication, interpersonal skills, multi-tasking skills, problem solving, and strong analytical skills are possessed
• Always functioned in growing and fast-paced environments
• Ability to manage projects efficiently and proven knowledge of project delivery methods
• Master in creating work stream and training plans and leading or managing others as well as providing support to the project manager
• Adaptive in Follows the company standard development processes to make the best use of limited resources time, money, people resulting in a stable, maintainable product that meets user requirements
• Expert in facilitating the clarification of specification issues as they arise during the software development process
• Ability to write detailed description of end user needs and program functions
• Demonstrated experience with Process Design, Business Process and Business Systems analysis
• Experienced with relational database concepts and client-server concepts
• Demonstrated experience in reviewing, analyzing, and evaluating business user needs
• Experienced in developing systems requirements that align to business strategies
• Master in documenting Business Requirements and gathering requirements
• Expert in conducting analytical review meetings as required with business stakeholders and subject domain experts to acquire the necessary details to write functional specifications
• Proficient in designing user interface mockups, visual models, charts, flow diagrams and other specification components.
• Experienced in collaborating with business, marketing, technical and design teams to develop requirements, prioritize enhancements, translate into Business Requirement Documents BRDs and Functional Requirement Documents FRDs and drive projects to completion
• Capable of identifying the functional definitions of the systems, completing with workflow, impacting to existing applications, and navigation
• Successfully implementation of reference data management and data sourcing
• Knowledge of test process and test case development ability to guide testers in test case creation and evaluation of expected results on key banking transactions
• Demonstrated experience with Finance/Accounting systems and processes
• Experience and knowledge of accounting practices especially involving sub ledger and general ledger postings/transactions
• Knowledge of Accounts Payable, Accounts Receivable and Reconciliation best practices
• Proven knowledge of securities, Capital Markets regulatory system and participants of finance industry
• Proficient in implementing Capital Market systems, financial services and technology
• Motivated, self-starter and active team player/leader with strong focus on success and self-accomplishment
• Complete knowledge in GAAP and IFRS
• Expert in Banking Operations and systems global banking regulatory standards Basel II Basel III banking transactions and products system to system data flow on banking events
• Experienced in Liquidity Risk Management, Liquidity Ratio Analysis, and Basel Regulatory Standards

Business/Technical Skills

Leadership/Supervision, Team Building, Time Management, Office Management, Problem Solving, Critical Problem Analysis/Resolution, Data analysis, Accounting principle, Financial Reporting, Presentation, Investment analysis and recommendation, Stock/Proprietary/Currency trading, MS Office Programs, VBA,SAP, SPSS, MEGASTAT, QuickBooks Pro, MS Access, MS Visio, MS Project, Erwin, UML 2.0, SharePoint, Rational Rose, Regression and Performance testing, SQL, Six Sigma, Quality center

Languages

Written and Verbal Communication in English, Russian, German, Turkish, and Uzbek

Professional Experience

Confidential

Business Analyst/ Accounting Finance

Responsibilities:

• Executed project management functions including project planning, budgeting, business requirements, technical design, system specifications, and project deliverables
• Assessed feedback from project employees and determined project completion date
• Documented and validated acceptance, integration, performance, and regression test plans
• Provided technical support for technical project staff and customers
• Continuously completed problem solving, problem analysis and creativity functions during, namely used knowledge and logic intensively
• Organized communication bridge between technical and non-technical project staff
• Continuously worked with database while gathering the business requirements for the inbound data feeds and outbound data feeds for the finance department
• Worked with Data Warehouse for data mining, making consolidated reports and finding relationships correlations
• Documented business processes, operational processes and fulfilled test case and testing plans
• Created features list for the analysis of the players in the market , the financial data and divided them into release plans
• Monitored the progress of the project by maintaining the product burn down charts
• Completed product backlogs and divided them in to different sprints
• Tracked and reported event activity and/or trends that have occurred resulting from the data load to the client counterpart
• Implemented reference data management and provided the required info for the main system
• Created, managed and documented client data feeds specifications, set the production schedule, and work with others to ensure the feeds are brought into production, and monitor the process to ensure successful stabilization
• Processed and/or review daily/weekly inbound data load files to include research and data resolution of load file errors
• Gathered data about liquidity risks, analyzed regulatory reports and applied risk measurements
• Researched and resolved assigned specific issues and general inquiries reported through issue tracking
• Analyzed trending activity related error reports including numbers, whether or not received, error type, percent of total records, etc.
• Created ad hoc reports inquired by the client and/or internal staff
• Assisted in the testing of all phases of open enrollment/special projects including system functionality, forms, WEB and online screen functionality
• Originated various reports and report formats for from the General Ledger GL , cash flow and P/L statements
• Extensively used EXCEL/ACCESS and VBA for the ad hoc analysis of the data

Confidential

Business Analyst Accounting/Finance

Responsibilities:

• Directed all aspects of project management for multiple projects, which resulted in project completion within planned time frame and budget
• Interacted with business partners concerning project specifications, which resulted in increased satisfaction levels upon completion
• Assisted project manager in project schedule maintenance and risk management
• Acted as a leader for different groups within the project
• Built and developed effective working relationships with both internal clients and external clients, providing project progress updates and managing expectations as necessary
• Demonstrate strong MS PowerPoint skills in order to create Executive-level presentations
• Effectively worked with business, technical and design teams to develop requirements, prioritize enhancements, translate into Business Requirement Documents BRDs and Functional Requirement Documents FRDs and drive projects to completion
• Conducted analytical review meetings as required with business stakeholders and subject domain experts to acquire the necessary details to write functional specifications
• Facilitated the clarification of specification issues as they arise during the software development process
• Ensured accuracy, completeness, and clarity of specifications.
• In cases where business requirements or scope documents were not provided, assisted in gathering business requirements from the appropriate sources
• Played a key role in training internal and external customers on application functionality
• Worked with large scale data, namely, analyzed merchandising and R D in both companies prior to the merger
• Learned supplier relations in both companies and created consolidated database about supplier interactions
• Analyzed the Chart of accounts of both SNY and GENZ
• Mapped the chart of the accounts from one system to the other, analyzed the data required from on SNY G/L record and studied the G/L information captured in the GENZ system
• Loaded the data from GENZ system into MS Excel and performed the missing value analysis for each column
• Enriched the data by gathering the missing data
• Helped in creating the data mappings and transformations
• Analyzed the reject rows manually and informed the finance manager
• Tested the merged data with running various reports such as balance sheet, cash flow, income statement
• Created cash flow models, spreadsheets, databases using Microsoft Excel, and budget preparation
• Assessed profitability through analysis of financial statements and ratios
• Demonstrated strong MS Excel skills in order to facilitate consolidation and analysis of financial and/or other data
• Maintained accuracy and integrity of data record information
• Provided enhancements and improvements to budget and consolidation tools, including creating consolidation templates as needed
• Summarized financial outputs into charts, tables and/or other presentation-friendly materials for executive-level use
• Involved in creating test plans

Confidential

Business Analyst/Financial Analyst

Responsibilities:

• Wrote reports to extract data for analysis using filters based on the analysis
• Worked on complex information model, logical relationships, and the data structures
• Kept informed the management about Corporate Actions, political and economic trends that influence the company performance
• Analyzed market conditions to determine optimum time to execute investment operations
• Prepared financial reports to monitor client and corporate finances
• Completed documents to implement plan selected by clients
• Implemented standardized office automation system supporting corporate-wide accounting, trading, and personnel
• Executed project management functions including project planning, budgeting, business requirements, technical design, systems specifications, and project deliverables
• Extensively used EXCEL/MS access VBA
• Summarized financial outputs into charts, tables and/or other presentation-friendly materials for executive-level use
• Worked with minimal supervision, to deliver on schedule, and to coordinate and prioritize multiple job requests
• Successfully managed stakeholders/clients expectations
• Informed risks/issues to senior management when necessary
• Managed the milestones related to every task, assuring the deliverables were submitted within the defined timelines, by creating the time charts and schedules
• Worked with the tools like MS Visio and UML to represent Use Case Development and ER Diagrams Activity diagrams, sequence diagrams, Collaboration diagrams, class diagrams

Confidential

Business Analyst - Finance Responsibilities:

• Worked as the Business analyst on reengineering and automation of an existing paper based process of sending statements to the clients, through a web based application named E-Delivery
• Took care of on boarding businesses like Wells Fargo Auto loan, collections, mortgage, and various other businesses located in different geographical locations
• Elicited and gathered business requirements following Agile methodology and using Case Complete
• Created and monitored the project deliverables matrix to organize and identify the resources responsible for delivering the related materials
• As the part of the business team, involved in gathering, eliciting and documenting the information from a variety of sources following agile methodology
• Conducted interviews and JAD Joint Application Development sessions to develop the architectural solution, meeting the business requirements, resolve open issues, and change request
• Created and dealt with logical data modeling, workflow modeling, use case analysis, and business process modeling
• Regularly dealt with Wells Fargo's ISA International Society of Automatization / Infrastructure team to drive the standard procedures to onboard the application, and to create the functional users of the web console
• Regular discussions and reviews on the format and allocation of the data fields and the records, and to identify the issue/ gaps and the appropriate solutions with the stakeholder, business users and the Data warehouse team
• Worked with the data warehouse team for the integration of the reference data/ tables in the master database for all the E-Delivery teams in order to have access to the reference data e.g. Region, Business, and Products etc.
• Took responsibility for test cases, test scenarios, test plan, unit testing, system testing, system integration testing and conducting UAT User Acceptance Testing
• Organized the User Interface manual for the web users and ISA Guides for the security administration based on the GUI Graphical User Interface functionality and the user accessibility decided by the business and the stakeholders, while being adhered to the compliance

Confidential

Financial Analyst

Responsibilities:

• Developed financial plan based on analysis of clients' financial status, and discussed financial options with clients
• Identified potential clients, using advertising campaigns, mailing listed, and personal contacts and solicited business
• Devised competitive pricing programs, product positioning, market penetration approaches, and contract negotiation policies
• Provided high level of support during annual State audits
• Wrote reports to extract data for analysis using filters based on the analysis.
• Worked on complex information model, logical relationships, and the data structures
• Kept informed the management about political and economic trends that influence the company performance
• Analyzing market conditions to determine optimum time to execute investment operations
• Prepared financial reports to monitor client and corporate finances
• Prepared documents to implement plan selected by client
• Implemented standardized office automation system supporting corporate-wide accounting, personnel, manufacturing, and sales
• Designed, developed and implemented cost capital budgets, engineering business plans, scheduling systems, manpower and material resource reports
• Tracked and forecasted annual sales for residential long distance products in the consumer market

Confidential

Finance Associate

Responsibilities:

• Kept the track of accounts
• Verified the accuracy of procedures used for recording financial transactions
• Maintained accurate records of sales and tracking monthly sales
• Prepared reports of business transactions and kept expense accounts
• Analyzed general journal and ledger entries
• Reviewed and examined cost reports
• Handled budget management functions
• Processed accounts payable/receivable transactions,
• Conducted monthly bank and supplier reconciliation
• Recorded month-end accrual entries
• Provided cash-flow analysis for non-capital activities.
• Prepared monthly financial reports, cost/ revenue budgets
• Modified amortization schedules for capitalized hardware system
• Participated in interviews of potential clients and employees
• Performed Excel Spreadsheet modeling, including building discounted free cash flow models, net-asset-value models, and other financial models for the current and potential production projects in the company