SUMMARY

• Business/ Data Analyst with 8 years of experience with strong domain expertise in Banking and Finance.
• Excellent understanding of business processes and functionality and experience in converting these into Functional Requirements Specifications (FRS), System Requirement Specifications (SRS), Business Requirements Documents (BRD)
• Excellent Business Analysis skills and experience in interacting with various stakeholders and Subject Matter Experts (SME’s), elicit requirements, writing Use Case requirements, creating UML Flow Charts, Use Case diagrams, ER diagrams using Microsoft Visio and Enterprise Architect
• Strong working knowledge of SDLC methodologies like Rational Unified Process, Waterfall and Agile Scrum methodologies
• Effectively facilitated Joint Application Development (JAD) sessions to gather requirements and to resolve conflicts.
• Experience in Data Analysis,data migration, Data Modeling, Data cleansing, preparation of scenario based data and clarification of requirements with SME (Subject Matter Expert).
• Extensively worked on Data analysis and reporting the data using advanced Microsoft Excel skills. Effectively used vlookup, regression, pivot tables, etc to map data to informative reports.
• Experience with data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snowflaking etc. Worked with Star Schema, Data Models, E - R diagrams and Physical data Models.
• Worked on Tableau and created adhoc reports and dashboards
• Sound Knowledge of Business Intelligence, Data Warehousing, and Business Architecture.
• Proficient in creating UI designs and creating Wireframes and Mockups.
• Strong knowledge of software architectures like client-server, n-tier, and service oriented architecture (SOA) and J2EE and Web-services like WSDL, SOAP.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Worked on tools like MS Visio, Sharepoint, Documentum, Snagit,Balsamiq, Dreamweaver and SQL Server.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica.
• Good Knowledge of technologies Java, HTML, XML, CSS, JavaScript, and PHP.
• Good knowledge of mobile platforms, web services, API integration.
• Tested the build and covered requirements throughUser Acceptance Testing, Smoke Testing.
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives (Strong in Options),Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
• Understanding of the implementation of regulatory guidelines such as the USA Patriot Act, Sarbanes - Oxley Act, SEC Rule 10b-5, Securities Exchange Act of 1934 and basics of DTCC, FINRA, ISDA, ISIN, SEC, ECNs, SWIFT, STP, Dark Pools, Crossing Networks, etc. in Financial Institutions.
• Deep understanding the knowledge of Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Solaris, Windows 2003/2008

Tools: /Utilities: Enterprise Architect 9.0, MS Visio 2010, MS Project, Snagit 11.0, Balsamiq Mockups 2.2,Dreaweaver, CSS, UML, Rational Rose, MS Office, HP Quality Center, Informatica

SDLC Methodologies: Rational Unified Process (RUP), Agile, Waterfall

Languages: SQL, HTML, XML, C++. C, Java

Databases: Oracle 9i, MS Access, Teradata, MS SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, LA, CA

Senior Business / Data Analyst

Responsibilities:

• Performed GAP analysis and communicated it with the cross functional and international teams to ensure project success.
• Conducted JAD session to develop process model to monitor all phases of the application delivery lifecycle from explore/discovery to application deployment, warranty and production support until transition.
• Conducted Data analysis with the customer records using SQL queries and excel pivot tables also to support order-management system and revenue mapping.
• Responsible for translating business requirement to technical reporting requirement
• Handled Immensely large dataset that loaded around 4 billion (5 TB) records DAILY
• Gathered requirements from business to define scope and prioritize the critical KPIs for business reporting needs and created BRDs for the same
• Educatedand consulted the team on writing highly tuned complex Teradata SQL queries keeping in mind the size of the underlying tables and architecture of the DW
• Worked with Data Modeling team to come up with the aggregate and denormalized table structures for some specific business reporting requirement or/and improve performance of reports
• Organized and participated in Dimensional Modeling sessions to create Star Schema for reporting layer
• Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables
• Used advanced Microsoft Excel for providing prototype of reports prior to actual Tableau implementation.
• Created the POC and prototype Tableau reports and dashboards with the key metrics
• Participated and hosted bi-weekly scrum planning meetings to prioritize and delegate the tasks to the reporting and data teams. Collaborated with the scrum team to generate a relative size estimate for sprint backlogs and assisted in developing burn down charts.
• Worked with the QA team to come up with test scenarios and test cases to validate the aggregate datasets with the base tables
• Provided post implementationsupport for production reports and handled ad hoc usage related questions from business teams by interpreting data into meaningful information
• Used Jira extensively to log bugs, support requests and user stories
• Worked with the Product Managers to enhance the Behavior Insights product with new metrics and KPIs as per the business requirements
• Worked on R to implement clustering on behavior data.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Developed complex e-metrics by using customer data from the site such as propensity to buy, likely length of visit and possible expenditure.
• Analytically evaluated information gathered from multiple sources, reconcile conflicts, and decompose high-level information into details, abstract up from low-level information to a general understanding.
• Created Mockups and wireframes using Dreamweaver to define concepts and enable visualization.

Environment: Enterprise Architect, Oracle 9.0, SharePoint, MS Visio, MS SQL Server, SnagIt, ETL, Teradata, Balsamiq, Agile, Jira

Confidential, Trenton, NJ

Sr. Business / Data Analyst

Responsibilities:

• Documented to-be (proposed) business process to reflect changes to self-service options
• Interviewed business (end) users to solicit and document Business Requirements (BRD), using Rational Requisite Pro
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Requirement analysis including data analysis and gap analysis.
• Designed and developed project document templates based on SDLC waterfall methodology.
• Developed business requirement specification documents as well as high-level project plan.
• Functioned as the primary liaison between the ETL developers, PMs and Business teams
• Led the JAD sessions and was responsible for the field-to-field mapping activities between the source and target for the subject area
• Devised the business transformation logic to be implemented in the ETLs and developed validation scripts for the same
• Was responsible to ensure that standards are followed for missing and default value handling
• Worked with the data modelers to come up with the fact table structures that conformed the business reporting requirement as well as performance requirements
• Used Teradata SQL to Query on large datasets (approx 30 TB)
• Came up with Test cases and performed QA and User Acceptance Testing on data processed into the EDW
• Generated POC ETL scripts using Teradata SQL for giving demo on complex business transformation logic to implement the backout logic
• Was responsible for getting the sign offs and approvals prior to release
• Handled changes and evaluated the effort and feasibility of accepting adhoc scope or requirement changes.
• Advanced use of Microsoft excel for giving a quick picture of various key metrics to the business users that helped in getting high level view of the data.
• Conducted brainstorming and JAD sessions with select-end users and SMEs to define and document new web page mock-ups and control flows, reflecting the required changes to the employee self-service options
• Created process flow diagrams to reflect underlying business processes for existing self-service options and as well as the proposed business process flow, using MS Visio
• Collaborated with SMEs and database experts, to define and document database impact and updates to existing Entity Relationship Diagram (ERDs).
• Generated ad-hoc reports as directed, for the management team, on progress of each requirement completion, delivery time-line, test and UAT schedules etc. and provided presentations and demo’s to all levels of management and partnering groups
• Conducted weekly status meetings with the outsourced development (DEV) and QA teams to review on-going progress and assessed potential show-stoppers.
• Worked on the Enterprise Meta data repositories for updating the metadata and also involved in Master Data Management MDM .
• Defined a Change Request (CR) template to track and manage and prioritize all pre go-live and post go-live change requests
• Managed release calendar to prioritize, track and manage project milestones

Environment: Oracle, MS Visio, MS Project, MS Excel, SnagIt, Balsamiq, ETL,Teradata, Windows XP

Confidential, Boston, MA

Business Data Analyst

Responsibilities:

• Handled Immensely large dataset that loaded around 4 billion (5 TB) records DAILY
• Gathered requirements from business to define scope and prioritize the critical KPIs for business reporting needs and created BRDs for the same
• Educated and consulted the team on writing highly tuned Teradata SQL queries keeping in mind the size of the underlying tables and architecture of the DW
• Worked with Data Modeling team to come up with the aggregate and denormalized table structures for some specific business reporting requirement or/and improve performance of reports
• Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables
• Used advanced Microsoft Excel for providing prototype of reports prior to actual Tableau implementation.
• Created the POC and prototype Tableau reports and dashboards with the key metrics
• Participated and hosted bi-weekly scrum planning meetings to prioritize and delegate the tasks to the reporting and data teams.
• Collaborated with the scrum team to generate a relative size estimate for sprint backlogs and assisted in developing burn down charts.
• Worked with the QA team to come up with test scenarios and test cases to validate the aggregate datasets with the base tables
• Provided post implementation support for production reports and handled ad hoc usage related questions from business teams
• Used Jira extensively to log bugs, support requests and user stories
• Worked with the Product Managers to enhance the Behavior Insights product with new metrics and KPIs as per the business requirements
• Worked on R to implement clustering on behavior data).

Environment: Agile, Version1, Teradata, SDP,OMS,, X/HTML, PL/SQL JAVA SCRIPTS, IBM Websphere Commerce Server, JSP, Web 2.0, ClearQuest,, SharePoint

Confidential, Cincinnati, OH

Business Analyst

Responsibilities:

• Interacted with business users to understand their business processes and current IT support
• Gathering requirements and use cases for business definition of Inventory Management and Pricing Management
• Documented functional and business requirements, work flows, use cases, data modeling using Rational RequisitePro.
• Creating business requirement document (BRD), functional requirement specification for application development
• Prototyped the application by providing screen shots for better visualization
• Organizing and facilitating directed and focused JAD discussions to produce tangible and documented outcomes
• Created and managed project templates, use case templates and traceability matrix
• Gathered requirements through discussions with the customer and various stakeholders within the enterprise and prepared business requirement documents and functional specifications document.
• Conducted Requirement analysis using Data analysis & Gap analysis.
• Involved in various stages of project lifecycle from the Business Case development through to post implementation and support
• Analyzed the impact of new requirements on the existing functionalities and systems
• Worked on making Requirement Traceability Matrix and Change Management Matrix
• Developed Proof of Concept and prototypes of new reports. Also worked on making reports for key performance Indicators across different user segments
• Used Teradata SQL for firing SQL queries to perform data analysis.
• Participated in Dimensional Modeling sessions.
• Worked on Cost- Benefit Analysis, SWOT Analysis & Feasibility Analysis.
• Was involved in analyzing the data and providing business insights & forecasts
• Created Business Rules and Business Processes for Promotions and Exchanges of Point of Sale System
• Participated in User Acceptance Test sessions and partnered with the users in analyzing the impact and assigning a priority to the defect opened
• Conducted training sessions to other team members once the project went into maintenance mode
• Presented to internal and external stakeholders to keep them abreast with the project progress
• Created Mockups and wireframes using Dreamweaver and HTML.

Environment: RUP SDLC, Enterprise Architect, MS Project, MS Access, Dreamweaver, MySQL database, IBM RequisitePro