SUMMARY:

• A highly - motivated Business Intelligence Analyst (7+ years) with diversified experience in areas like project management, reporting, requirements gathering, data analysis and testing.
• Experienced in mapping business processes, identifying and managing project risks and dependencies.
• Proficient in gathering and managing business requirements, use cases, and requirements traceability matrix.
• Hands on experience in writing complex SQL queries
• Initiated role of agile Scrum Mater during development and testing team transition
• Strong understanding of financial markets, banking, and basic decision making in business.
• Confident exposure with data analysis, drilling down to the smallest possible data elements.
• Skilled in creating ad hoc reports and dashboards, within Tableau, Google Analytics and in-house tools.
• Adept in ETL methodologies of data from multiple sources of data.
• Ability to identity business process improvements from big picture to detail level.
• Keen understanding of data and BI/BO technologies to design end-to-end marts.
• Strong documentation and communication skills with attention to details.
• Expertise in MS Visio, MS Project, Excel, macro analysis, and reporting
• Certified into Google Analytics, Adwords and Power BI
• Comfortable managing onsite and offshore team
• Proficient in creating UI designs and mockups.

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Responsibilities:

• Act as a liaison to assist treasury, and other entities covering all business aspect to create reporting environment.
• Managing data mart to ensure data availability and accuracy with periodic audit to ensure data quality.
• Creating financial models for ongoing reports, interpret data, and analyze results
• Collaborating workshops to discuss open issues, close out gaps and decision project lifecycle.
• Work Closely with PMO directors to prioritize business needs
• Write SQL queries to validate that actual test results match with expected results.
• Analyze the impact of new requirements on the existing functionality with the EDW environment.
• Document data definition dictionaries with the help of clients.
• Creating decisions trees on how each Loan, deposit, or security is to be mapped within the report.

Confidential, San Francisco, CA

Responsibilities:

• Designed requirement for report automation offering user’s activity based on the compliance and policy rules.
• Automated reports managing alerts from actimize, a third party tool triggering fraud alerts and creates risk scoring.
• Created testing strategies with the help of third party vendors.
• Performed impact analysis to improve efficiency of current system focusing towards online security.
• Identified and managed project risks, issues, and dependencies.
• Created and tracked data mapping between Confidential fields and Actimize data fields for reporting needs.
• Studied past fraud cases and worked closely with fraud analytics for reporting purpose.
• Create data mapping diagrams to discuss with developers and testers on data accuracy and quality.
• Implemented excel algorithms and formulas to college and quantify large amounts of data.

Confidential, Boston, MA

Responsibilities:

• Create and manage all the functional and data requirements for newly built ad-hoc reports and dashboards.
• Create, develop, test, and maintain reports with SQL querying
• Managed database objects including tables, relationship, stored routines, triggers and users.
• Analyze and test the data present in the source system before migration to the target and identify data gaps
• Provide clarifications to the ETL team about the kind of data required to be migrated
• Work with front end GUI design team to create the UI screen shorts and presented to the business leads
• Drive towards standardization of the report/ dashboard offering and maintaining a library of reports based on the different data sources
• Performance testing of the new database by executing database queries and generating reports.

Confidential, New York, NY

Responsibilities:

• Gathered requirements for newly built reports on Tableau dashboards involving data requirements, wireframes, and graphical mockups.
• Provided a link between the media team, client and the development team
• Studied system behaviors and conducted data analysis.
• Participated in solution discussion to ensure business needs were met
• Used Erwin to design data structure with tables and relationships which was used as a guideline to ETL coding.
• Reviewed test cases to manage the efforts of the testing team.
• SQL querying to check the integrity of data.

Confidential, Houston, TX

Responsibilities:

• Managed projects and initiatives working as a single point of contact for client; responsible for requirements, testing and documentation.
• Created use case and interaction diagrams analyzing corporate strategies using business-modeling techniques.
• Blue-printing the software logic for key business triggers and subsequent notifications to business users
• Built test plans, requirement traceability matrix, mapping documents and user guides
• Analyzed and documented the analytical needs of ticketing business unit by analyzing web traffic.
• Identified, defined collected, tracked key business metrics, for new and existing products.