SUMMARY

• 10+ years of extensive experience in IT, Business Analysis, Data Analysis, Data Quality and Process improvement programs utilizing various project management methodologies both Waterfall and Agile across Banking, Finance and Health sectors.
• Key strengths include excellent leadership, detail oriented problem solving, working across multiple teams and geographies, reliable work ethics, self - driven and strong interpersonal and organizational skills with positive affirmation to meet the goal.
• Experience in gathering user requirements, preparing and analyzing Business Requirement Documents (BRD), Design Document, System Requirement Specification (SRS), and propose changes as per various internal and external requirements gathered for process improvement.
• Conducted Joint Application Development (JAD) sessions and interviewed project stakeholders and SME’s, asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in Data Profiling, Data Manipulating and Data Parsing using complex SQL queries against various Database Environments.
• Cleanse and process data using Excel, SQL, Ab Initio. Perform trend analysis on data to fetch useful insights from data.
• Generated Tableau reports and dashboards for Data Quality Metrics to track Critical Data Elements performance.
• Skilled in Use Cases and Unified Modeling Language (UML) for requirements gathering.
• Performed GAP Analysis between AS IS and TO BE workflow models
• Experience performing Unit testing, User acceptance testing (UAT), Regression testing.
• Experience in working under different SLDC environments such as Agile, RUP and Waterfall.

TECHNICAL SKILLS

Databases: SQL Server 2008/2005, Oracle 11g, 10i 9i/8i, 2000, DB2, Teradata 12, MS Access 2007.

Programming Languages: PL/SQL, R, Finacle scripting

ETL: Ab Initio, Informatica Power Center 9

Tools: Tableau 9/10, MS Office, TOAD, Teradata SQL Assistant, Clear Quest, ALM, SharePoint, Quality Center, JIRA

Environment: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3

PROFESSIONAL EXPERIENCE

Sr. Business Data Analyst/Product Owner

Confidential, San Leandro, CA

Responsibilities:

• Participating in Data Governance Domain Council meetings, gathering Data Quality requirements for source systems, strategic systems and Application Provisioning Points.
• Data discovery, analysis and profiling using Tableau, Ab Initio, SQL and Excel
• Analyzing Data Quality requirements for various Domains like Consumer Lending, Master Reference Data and Financial Reporting for Risk and Regulatory reporting
• Creating Data Quality business rules as per Enterprise Data Governance standards.
• Implementing and supporting Data quality rules using various platforms which includes Ab Initio, Informatica and SQL
• Developing Data Quality Metrics for Application Business Data Owners, Data Management Solution leads and upper Management which includes creating mockups, getting approvals, working with technology teams and working across multiple domains and SMEs.
• Acting as Product Owner for Data Quality Metrics Dashboards in Agile environment leading the Sprint Planning sessions and participating in Daily stand up calls, Sprint review, Defect review and Go/No-Go calls.
• Creating Data Lineage with application teams. Functional specification and test plan reviews with Technology team and coordinating post production end user testing and final business validations.

Senior Business Analyst

Confidential, San Leandro, CA

Responsibilities:

• Perform System and requirement analysis. Interact with the business stakeholders and users and create BRDs to capture the new requirements, enhancements and functional specifications.
• Conducted Joint Application Development (JAD) sessions and interviewed project stakeholders and SME’s, asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format
• Conduct workshop sessions for the Enhancements involving different business user groups.
• Write SQL queries to extract information from the database for data analysis.
• Conduct weekly production research status review meetings.
• Coordinating with offshore team on daily basis and help understand the business requirements.
• Providing SIT, UAT support and production rollouts.
• Manage the issues raised by business and QA in Application Lifecycle Management (ALM) and assign the work items to the team and take up critical work items.
• Participate in the production deployment meeting.

Technology Analyst

Confidential, Walnut Creek, CA

Responsibilities:

• Review functional requirements and provide technical solutions.
• Development and Customization of complex Reports for Member Services like Pension, Claims, Eligibility and Benefits.
• Working with databases such as Oracle 10g/11g and writing SQL and PL/SQL procedures, functions, Triggers, Cursors as per the business needs to extract data.
• Interact with outside vendors to finalize Data File format and wrote stored procedures and packages to extract the data from Vitech, a custom front-end application.
• Working on Automation of Legacy Eligibility Data from MS Access.
• Working on Data Migration, Data conversion and Data mapping to import the data from Legacy system to new system.
• Schedule Daily, Weekly, Monthly jobs to run in Vitech and validated the results once the files are ready before sending it to business.
• Involved in the creation and publication of ad hoc reports and Dashboards for various business partners.
• Testing and validation of data in the reports using the Vitech (v3) front-end application.

Technology Analyst & Onsite Coordinator

Confidential

Responsibilities:

• Worked as an onsite coordinator for a team of 20 members spread across 3 locations.
• Worked as an Interface between the business users and the different teams involved in the application development for the better understanding of business and IT processes.
• Analyzed Business Requirement Documents and created Use Case Diagrams & Activity Diagrams using MS Visio to support the design phase and ensure that the development team has a clear picture of the requirements & functionality of the system.
• Used SQL to extract data from the database to create reports for analysis.
• Acted as single point of contact to assess, analyze, document and resolve issues
• Involved in post live customizations of the bank and fixed many critical defects.
• Involved in scope, approach, design, coding and implementation of formatting the address details of the customers of the bank in a predefined format finalized by extensive interactions with the Clients across all the statement, receipts and welcome letter issued by the bank.
• Involved in direct client interactions and acted as SME to understand and design the requirements for Finacle implementation in Emirates NBD, London.

Software Developer & Functional Analyst

Confidential

Responsibilities:

• Extensively worked across all stages of product implementation including requirement gathering, design, coding, unit testing, system integration testing, implementation, user acquaintance testing, go-live and support.
• Designed and developed use cases, functional specifications, activity diagrams using UML
• Conducted weekly status meetings after collecting status of development progress
• Led teams of 10 in theUser Acceptance Testingphase to ensure sign off
• Facilitated Onsite - Offshore task-coordination and documentation management.
• Assuring both quality and customer service while leading and driving the tasks to successful completion with minimal possible defects.
• Mentoring new joinees in the project. Volunteering Knowledge sharing sessions to the new joinees in order to help them acquaint to the new requirements and the steps to be followed to meet them.