EXECUTIVE SUMMARY:

• 8 + Years of prevalent IT experience Business Analyst in Business Analysis, Data analysis, Business Rules, GAP Analysis and developing/creating business process documents.
• Skilled in gathering business requirements, use cases and requirements analysis.
• Experience in modeling Transactional Databases (OLTP) and Data Warehouses (OLAP) using tools like Erwin and ER/Studio.
• Extensively experienced in gathering, documenting and managing Business and Functional requirements
• Skilled in coordinating and communicating between Developers, QA Teams, Management, QA and project leads and stakeholders to keep them informed at all the times about the development and the open issues
• Conducted JAD sessions as a facilitator to discuss requirements among the group.
• Experience in carrying out Software Development Life Cycle (SDLC) in relational and object methodologies.
• Well acquainted with Workflows and (UML) (Unified Modeling Language) diagrams such as, Use case diagrams, activity diagrams and Sequence diagrams.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, creation of cubes.
• Strong experience in preparing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications
• Data Acquisition strategies to extract data from different source systems, created data mappings using different transformations and executed workflows for data loads to target systems.
• Experience in Agile, Waterfall methodologies.
• Expertise in data base programming (SQL, PLSQL,TSQL) MS Access Oracle 10g/9i, SQL server 2005/2008,XML, DB2, Data base tuning and Query optimization..
• Extensive experience in Test Data Management, creating test data suite, tracking the results and using for regression testing.
• Expertise in multiple testing techniques including functional, regression, integration, system, performance, smoke, User acceptance testing.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Through knowledge in building reports using Business Objects Web intelligence.
• Excellent problem solving and analytical skills with a proven ability to learn and understand new technologies efficiently.
• Effective team worker and can carry out individual tasks to meet the deadlines effectively.
• Competence to adapt to new software applications and products, self - starter, with excellent communication skills and understanding of business workflow.

SKILL:

Project Management: MS Project, MS Office Suite, Sharepoint, TFS, HPSC Change management, ServiceNow

Business /Data Modeling: UML, Erwin 7.2/4.0,EmbarcaderoER/Studio,MS Visio, Rational Rose

Methodologies: Rational Unified Processes, Agile Scrum, Waterfall, Lean, SixSigma

Requirement Gathering: Rational Requisite Pro, DOORS

Tools: HP Quality Center (QC), TFS, BugZilla, Velocity 7.6 (POS), VQ manager, Report center, POS analysis, MS Office, Toad, Auto sys, Putty, SAP MM.

Operating Systems/DB: Unix, MVS, AS400, Windows 98/2000/XP/Vista/7

OLAP/BITools: OBIEE 11g/10g,, SAPBusinessObjectsBIPlatform 4.1,BusinessObjects XI R3, Crystal Reports 4.0,Microsoft SSRS,MicroStrategy.

ETL Tools: Informatica 7.1, 8.1, 8.6. SQL Server DTS Packages, SSIS 2005/2008

Database: SQL Server 2008 R2, Oracle, TeraData,DB2, MySQL

AREAS OF EXPERTISE:

• Strong Analytical Skills
• Requirements Gathering for Complex Business Process Re-Engineering/ Integration Projects
• Communicating and Negotiating with different levels of Management, cross functional groups
• Vendor Management
• Data Analysis, Data Modelling and Data Mapping
• SQL Queries, Stored Procedures and Reporting
• Managing Teams in Global Delivery Model
• Staff Training and Training Documentation
• Total Quality Management and UAT
• Change Management

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Systems Analyst/BI Report

Responsibilities:

• Gathered Requirements for all the business units through one on one meeting with the subject matter experts.
• Collaborated with business partners and stakeholders to identify and define high level and detailed business/functional requirements.
• Converted the business requirements into technical requirements for the ETL and report developers
• Worked with different bank portfolios like commercial, retail, trading, Equity and securitization
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business personnel and technical personnel.
• Proficiently managed client facilitation meetings to gather Interface and Business Process Requirements from Subject Matter Experts (SME’s) in trading shares, equities and Fixed Incomes like bonds, and converted them into functional requirements by implementing the RUP methodology, authored the same in Business Requirement Document (BRD).
• Worked with third party vendors that provide data feeds for fixed income, equities and Securitizations.
• Performed Source system analysis to understand the sources and data flow.
• Analyzing the source data coming from different sources (SQL Server, Oracle, Sales force and also from flat files like Access and Excel) and working with business users and developers to develop the Model
• Conducted Requirements Analysis by interviewing risk-operating office SMEs to discuss, review and identify current and future requirements.
• Extensively used Informatica Power Center 8.6 to extract data from various sources and load in to staging database.
• Used HP Quality Centre to log and track defects.
• Worked on Moody’s Pricing and Valuation Tools and Wall Street analytics for credit risk measurement and risk calculation.
• Used Moody’s Fermat for credit research, risk measurement and valuation for the system.
• Responsible for the functional study and analysis of the business requirements, UML state chart diagrams, flow charts, business process and designing data elements
• Implemented change management process to existing applications end to end using HP service manager
• Providing QA support for UAT ETL testing, defect tracking, fixing for data integrity and governance and played an active role in product rollouts.
• Performed data validation after ETL load and communicated with developers to implement data fixes
• Lead Business Intelligence reports development efforts by working closely with OBIEE,
• ETL teams. Design, development, implementation and roll-out of Business Intelligence applications.
• Involved in Business requirements, Data analysis, and System design meetings.
• Successfully gathered approval on all projects and uploaded all approved docs in version control of Microsoft SharePoint site. Assisted in the development of quality assurance artifacts including: Quality Assurance Plan, Test Plan and Test Cases

Confidential, Tulsa, OK

Senior Business Systems Analyst /Data Analyst/Modeler

Responsibilities:

• Maintain the logical and physical data model for the application database
• Participate in the scrum meeting every day to gather new requirements for the iteration
• Work on the data model enhancements Using ER studio and does a peer review of the changed data models
• Create DDL statements for the data model and send it to the DBA to execute them
• Carry over any changes in the application data model to the data warehouse data model
• Maintain the logical and Physical data warehouse data model
• Wrote Functional requirements specification (FRS) documents as per the Business requirements and process flow.
• Developed Source to Target Mapping Documents for ETL Developers.
• Provide requirements for enhancements and ensured implementation into appropriate training materials and documentation for business
• Defined ETL strategy to capture new data, store historical data and update data warehouse in the most efficient way. Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Performed Data cleansing as required on the legacy data with the help of SMEs
• Identified and analyzed rules and regulations, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
• Maintained the results of test data and performed regression testing, negative testing based on the result set.
• Write complex queries to test the data flow from Source to target.
• Used Quality Center to store, schedule test cases and report bugs.
• Wrote Functional requirements specification (FRS) documents, SWOT analysis as per the Business requirements and process flow.
• Worked on different areas of SAP implementation like Enhancements, Conversions, Interfaces and Reporting.
• Raising tickets for Change Management and making sure change management processes are being followed for deployment.
• Documented User Scenarios for the project and worked with business Team to ensure every possible GAP and error has been identified and communicated

Confidential

Senior Business Systems Analyst/Data analyst /Report analyst /POS Admin

Responsibilities:

• Gathered requirements from different business units, conducted one on one interviews with SMEs to understand the business and develop complex transformations to load data.
• Dealed with a variety of legacy source systems like mainframe, flat files and developed migration and integration plan from different source systems to Oracle.
• Had brain storming sessions with application developers and DBAs to discuss about various Denormalization, partitioning and indexing schemes for physical model
• Developed several mapping documents/Conversion mappings for the ETL develop to develop code.
• Lead the development of the overall application, database, supporting system technology and integration design from a data flow and technology perspective working with the application development, application support, operations and teams in defining the target structural design leveraging best practices from existing as well as external best practices
• Generated DDL Statements for the creation of new objects like Tables, Indexes using Erwin.
• Perform data Analysis for measures POS, Inventory units and dollars to ensure that data loaded into the system is accurate.
• Manage the VPC (Process Control file) to map the input feeds with the database columns.
• Management and making sure change management processes are being followed for deployment.
• Develop data sources Using VQ manager which are in used as source to design SSRS report for the users.
• Monitor loads, schedule jobs and perform admin functionality to make sure the data is loading correctly
• Coordinated the Migration of the PSCT application from QA to Production.
• Designed Tax reports in the Tax reporting project using SSRS
• Worked as Onsite lead for the projects POS and Product safety Certification Tracking.
• Creation and Customization of the OBIEE Repository (Physical, Business and Presentation layer) and Added extension columns in fact and dimension tables.
• Developed many Reports in Oracle BI Answers and created interactive Dashboards using features like Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters.

Confidential, Raleigh, NC

Business System Analyst/BI Reporting

Responsibilities:

• Worked with project manager, traders, and other stakeholders to define project scope, plan, and requirements.
• ConductedJADsessions with the stakeholders, end users and SME, to determine the criticalbusinessprocesses and identify key functional requirements for system adhering to the financial regulations and policies.
• Implemented change management after the application is in production and ensured the changes moved into production via DBA and ETL and were implemented in production with all approvals
• Involved in preparing Logical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Identified businessprocess and developedbusinessprocess flow diagrams for loan preapproval, loan application and loan process with the help ofMS Visio.
• Performed GAP analysis of current new account opening processes and compare with proposed system enhancement.
• Used Rational Rose to design Use Case diagrams, Activity diagrams, and Sequence Diagrams to simplify thebusinessprocess for stakeholders and developers
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• Designed complex report Published to Crystal Enterprise for end users to view, schedule, and share reports over the web (Info View).
• Created documentation and test cases, worked with users for new module enhancements and testing. Conducted logical data model walkthroughs and validation.
• Used Crystal Reports to generate reports from different databases of different asset classes like equities, bonds, derivatives, and commodities, for all business needs.

Confidential

System Analyst/Report Developer

Responsibilities:

• Gathered business requirements through interviews, surveys with users and Business analysts.
• Involved in preparing Logical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Drafted the Business Information Requirements documents according to standard templates, and then collaborated with stakeholders/SMEs to validate those requirements and obtained a Sign off on those documents.
• Performed Gap Analysis on the existing system with an idea of figuring out the necessary mapping steps towards the new "Target" system.
• Createdconceptual, logical and physical data models using Erwin.
• Created table and column level constraints using the suggested naming conventions for constraint keys.
• Developed excel reports using Pivot table and Graphs concepts in Excel
• Documented the end to end process for future references.