SUMMARY

• 8 year’s experience as Sr. Business Analyst/Data Analyst with Strong research, analytical and problem solving skills and experience working under and meeting critical deadlines.
• Experience in full Software Development Life Cycle (RUP, Waterfall, Spiral& other SDLC implementation).
• Build and execute SQL queries for data mining, data quality, and data trend and data structure analysis.
• Extensive knowledge in Requirement Gathering Analysis through user interviews, workshops and existing systems documentation and procedures.
• Experience of working in the area data management including Data Modeling, Metadata, Data Analysis, Data Mapping and Data Dictionaries.
• Proficient in interacting with business users to identify information needs and initiating process changes and creating Use Cases, Use Case diagrams, Activity Diagrams, Class diagram, Sequence diagram based on UML methodology using tools like Rational Rose and MS Visio.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as IBM Cognos and Informatica PowerCenter.
• Functioned as Process and Product Owner, as well as Scrum Master, employing two - week sprints using Agile and Terminal Foundation Server (TFS) to architect a database to replace a manual spreadsheet process.
• Excellent knowledge on internal working of HDFS file system, Map reduce
• Generated Traceability Matrices to ensure that all the requirements are covered by the test cases
• In depth understanding of SDLC, Waterfall & Agile Methodology, SQL with relational database concepts and client server concepts. Expertise in developing web application using MVC5 and ASP .NETWeb Forms along with C#, Web API, Entity Framework, ADO.NETand WCF.
• Well versed in documentation of Product Definition Document (PDD), Business Requirements Documentation, System Requirement Specification (SRS) and Functional System Documentation (FSD).
• Worked as enhancement team member and performed the roles of Salesforce.com Business Analyst and Administrator in the organization.
• Knowledge of web services related concepts - XML, WSDL, SOA, HTML/CSS and JavaScript.
• Responsible for setting up login restrictions and resetting the user passwords.
• Implemented public access settings for sites, restricted login hours, and restricted login IP ranges on profiles.
• Worked closely with sales team and performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SalesForce.com (SFDC).
• Familiar with basic statisticalconcepts, and control charts.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Involved extensively in the inception phase for understanding the Scope of the Project, feasibility of the implementation, and definition of the risk factors involved in the project.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Data Mapping, Data Profiling, Data Modelling, Websphere and Cognos
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools
• Expertise in writing SQL Queries, SQL *PLUS, PLSQL stored procedures for databases like Oracle, MySQL, DB2 on UNIX as well as Windows platforms.
• Informatica Power Center, Datastage, Mainframes SAS, SSAS, SSIS, OLTP, OLAP, Business Objects.
• Prepared test cases and executed them in ALM.
• Experience in Tuning SQL and PLSQL codes using Explain Plan and SQL Trace files.
• Highly motivated and efficient Team Player, with excellent Interpersonal, Communication and analytical skills.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Experience in conducting GAP analysis, Workflow Diagrams, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Worked in Data Analysis, Data Profiling, Data Modelling, Data Reconciliation and Data Mapping for ETL process.
• Maintain and generate SQL/PLSQLreports via APEX and SQL Developer.
• Conducted Joint Application Development (JAD) sessions and interviewed Subject Matter Experts (SME’s), and updated the requirements.

TECHNICAL SKILLS

• Microsoft Office Suite
• Word
• Excel
• Outlook
• Publisher
• PowerPoint
• Desktop Deployment
• Microsoft Office Visio
• Microsoft Office Project
• Microsoft Windows (1997/2000/XP/NT/Vista)
• Microsoft SharePoint
• Rational Rose
• Requisite Pro
• ClearCase
• ClearQuest
• Bugzilla
• Microsoft Access
• Informatica
• TOAD
• SQL Server
• Oracle 10g
• Oracle 11i
• IBM WebSphere
• HTML
• HTTP
• XML
• ALM
• Microsoft .NET Framework
• Java
• Hadoop
• Minitab
• Pivot Tables
• Bloomberg
• Lotus Notes
• Citrix
• VPN
• Microsoft Front Page
• Adobe Dreamweaver
• AJAX
• PHP
• Wiki
• Blogs
• RSS
• GUI
• Use Cases
• Data modeling
• Research
• Analytics
• Statistical Modeling
• UAT
• Presentations
• Documentation
• Facilitation Skills
• SDLC
• Agile
• RUP
• Waterfall
• Spiral
• Prototyping
• TFS

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Sr. Business Analyst

Responsibilities:

• Interacted with various business team members to gather the requirements and documented the requirements.
• Analyzed the Scope of the Requirements, and managed requirements to avoid Scope Creep.
• In charge of conducting the UAT with the Business users, and gathering feedback and providing the same to the Development team.
• Reviewing the test cases provided by the QA team, and providing feedback.
• Worked on Agile and Scrum Methodology for Salesforce custom app implementation.
• Involved in the creation and maintenance of the business specification requirement documents, and use case software specification documents.
• Conducted user interviews, gathering, analyzing and documenting business requirements.
• Created Project Plan and assess work-effort estimates required to accomplish various phases of the Project.
• Documented the division’s business processes and business rules for work plan scheduling and resource management through a “Rules of Engagement” deliverable to improve clarity within the solutions organization and to assist business units in provisioning new work within the enterprise.
• Guiding thescrumteams and larger organization on how to get the most out of Agile/Scrum practices.
• Involved in writing Java generator for PLSQL scripting's.
• Identify select technologies for reporting, integration and data warehouse
• Assisted the business and client with Business Requirement Documents, Mapping Documents and Data Profiling.
• Elicited, documented, modeled, validated and prioritized functional and non-functional requirements using interviews, data analysis, and different modeling tools.
• Conducted many Requirement Elicitation Techniques Interviews, workshops with end-user/clients/stake holders and the development groups.
• Wrote User Stories in each sprint cycle also known as Business requirements document based on the inputs received.
• Assisted in entering and updating Issues (Epics, Stories, and Tasks) onto RallyAgile application.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Gathered business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface).
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Conducted Feasibility Analysis and Product backlog planning with the Project Manager
• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems.
• Managed and reviewed Hadooplog files.
• Implemented Advanced PLSQLConcepts for better performance of PLSQLApplications.
• Used advanced PLSQLconcepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML Operations for better performance.
• Knowledge in Salesforce.com SFA, Force.com Apex Classes, Apex triggers, Integration, Visual force, Force.com API, SOQL, and SOSL.
• Designed and analyzed Business process model at different level using BPMNEnterprise Architect Sparx tools.
• Translated business requirement into Functional requirement document
• Translate functional requirements into use cases forecommerceapplications
• Exposure to Human-Computer Interaction (HCI), User Interface (UI) Design and Usability Testing. Assisted the PM on various projects throughout the Project Management Life Cycle (PMLC) including Project Charter, Project Plan and Resource allocation.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
• Worked with various Salesforce.com objects like Accounts, Contacts, Opportunities, Reports and Dashboards
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Used Salesforc.com platform to identify issues and gaps in current reporting format and suggested implementation of the Analytical tools to enhance Reporting and Data consolidation.
• MySQL, Data Extraction, Transformation & Loading PLSQL.
• Well versed in Change Management, Gap Analysis, User Acceptance Testing (UAT), SWOT analysis, Cost Benefit Analysis, ROI analysis to check the compatibility of the existing system infrastructure with new business requirement
• Data profiling, validating, monitoring and cleansing across the enterprise.
• Used ADO.NET to implement data access layer.
• Maintained the .Netcode in Clear Case, TFS in Visual Source safe
• Supervisor responsibilities UAT testing implementation
• Handles UAT testing and implementation for various applications.

Environment: Windows, SQL, Microsoft Visio, Test Director, .Net, TFS, Salesforce,PLSQL, IBM Cognos, Agile, Rally, JavaScript, Oracle, HP Quality Center, MS Visio, MS Access.

Confidential, Greenville,SC

Business Analyst

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans
• Worked with the Management to come up with a Plan for the Data Management Strategy and Roadmap.
• Responsible for identifying and documenting business rules and Policies.
• Designed and developed Use Cases, Use Case Diagrams, Workflow diagrams and Activity Diagrams by using UML and Visio.
• Validated the ETL Informatica mappings, SQL queries and different ETL transformation.
• Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's enhancement initiatives.
• Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
• Involved in tracking and Reporting Status of the Data Management Program to Management.
• Designed and developed Use Cases, Use Case Diagrams, Workflow diagrams and Activity Diagrams by using UML and Visio.
• Assist in providing training on BPM and Sparx BPMN tool
• Worked on Agile and Scrum Methodology for Salesforce custom app implementation.
• Involved in creating oracle SQL tables and PL/SQL procedures.
• Develop, test, and deploy automated reporting utilizing VBA, XML, SQL/PLSQL, and others.
• Involved in the maintenance of the project that requires analysis and debugging .Net code and MS SQL Server stored procedures.
• Created interface with team members and helped in translating the requirements into SFDC workflow processand detailed mapping document by designing the workflow charts and diagrams for integrating various systems with Salesforce.com.
• Expressed the requirements through user stories, use cases, business rules, future state mapping and process flow diagrams.
• Performed Back End testing using SQL and PLSQLstored procedures to validate data
• Agile management utilizing TFS for electronic board management.
• Employed an Agile Terminal Foundation Server (TFS) process to implement significant RSSD improvements, including the following:
• Enabled ability for BSA Operator Leads to schedule BSA Operators and provide them server instructions from database through development of separate, web-based access.
• Provided increased patch and component update speed via a BSA application update, mitigating concerns surrounding outage time.
• Identified sourcing of data elements that are required to create all system interfaces (Data Services) and documented in ERwin Model Manager to create a data dictionary for all entities/elements.
• Proficient in transforming business requirements into functional specifications focusing on workflow analysis and design, user interface design, businessprocess reengineering and process flow modeling.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Contribute and comprehend to organizational Process maturity models using Statistical Process Control Techniques.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Conducted Joint Application Development (JAD) sessions and interviewed Subject Matter Experts (SME’s), and updated the requirements.
• Worked on ensuring Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Possess excellent Data Analytical skills such as Data Domain Discovery, Data Profiling etc.
• Have worked on Excel Data Profiling to profile the data and analyze them for different parameters to generate better transformation logics.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Constructed Requirement Traceability Matrix (RTM) using MS Excel to monitor compliance of requirements and to handle Change Requests efficiently.
• Supervised the User Acceptance Testing (UAT) to test the usability of the application.

Environment: Agile-RUP, MS Access, Informatica, Enterprise Architect, SQL Server,PLSQL, .Net, MS Excel.

Confidential

Business Analyst

Responsibilities:

• Responsible for Several Project phases such as collecting business requirements, developing business process procedures and design sspecifications, configurations and pproject planning.
• Created estimates, budgets and shuffled resources between tasks as needed.
• Developed high level design of new processes and graphically presented them along with text based requirements to IT management.
• Used UML for Visual modeling and created detailed Use-Case Specification to describe the interaction and functional requirements of the system.
• Created technical documentation on how to produce the reports & sample reports for those requirements that can be addressed with native Clarity tool.
• Used user controls and custom controls on the Web Forms with ASP.NET and C#.
• Extensive experience with Team Foundation Server (TFS), Oracle HRMS, HP Quality Center (QC), SharePoint Content Management and Enterprise Architect for defect management.
• Authored user manuals for Salesforce.com application: SFDC- Outlook
• Played a key role in internal process improvement efforts such as the design of our production support intake process. Identified the appropriate tool for managing request details, task tracking and adherence to SDLC processes (Microsoft TFS)
• Designed and analyzed the model at different level using BPMNand EPC methodology - Sparx and ARIS tools
• Identified and developed Use Cases from the business and functional requirements (BRD and FRD). Created external tables to load data into oracledatabase from data files.
• Worked on creating several new Oracle Forms and Reports for adherence to business needs and recommended changes.
• Implemented account targeting by adding custom target flags and using Veevaout of box Call Class and Potential fields at the TSF level.
• Conducted meetings with business users and SMEs to identify and gather various functional and non-functional requirements.
• Interacted with business owners, project stakeholders and cross functional teams in defining project charter, providing estimates, scope management and resource management.
• Analyzed the Business and Functional requirements of the application and also developed detailed test plan and test cases.
• Responsible for schedule, costs & budget and risk management; earned many achievements and successful deliverables.
• Worked as enhancement team member and performed the roles of Salesforce.com Business Analyst and Administrator in the organization.
• Performed Back End testing using SQL and PLSQLstored procedures to validate data.
• Performed Data mapping, logical data modeling, data profiling, created class diagrams and ER diagrams and used SQL queries to filter data
• Prepared Activity Diagrams, Use Case Diagrams and State Diagrams using Visio and Rational Rose.
• Extensively used SQL, PLSQLto create complex queries, SQL Override, Stored Procedures, and Triggers.
• Maintained and kept track of stakeholder’s requests for enhancements and changes using Rational Clear Quest. Written SQL scripts to pull the data from the existing database based on the business rules.
• Worked closely with sales team and performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SalesForce.com (SFDC).
• Designed the training manual to be used for the CI System including the Process Flow Diagram in Visio. Lead requirements analysis and verification
• Organized weekly project status meetings, created PowerPoint presentations, and project updates using MS Project for management review.
• Implemented Traceability Matrix (TM) and User Requirement Specification Document (URS) to verify the functionality coverage.
• Involved in data mapping and migration of data from legacy systems to SalesForce.com Objects and fields.
• Worked with System Analysts to create application’s Functional and Non-Functional Requirement Document.

Environment: Windows, MS-Project, Java, MS-Office Suite, MS Visio, Quality Center, Quick Test Pro (QTP), PLSQL.

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Interacted with client groups to determine user requirements, Business rules and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document (BRD).
• Interacted with Subject Matter Experts (SME’s) and stakeholders to get a better understanding of client business processes and gather business requirements.
• Analyzed business requirements and segregated them into high level and low level use cases, activity diagrams, and sequence diagrams using Rational Rose according to UML methodology.
• Experience and sound and knowledge on e-commerce(EDI, online transaction processing, etc)
• FollowedAgile Iterative development approachand was involved with all iterations of the development life cycle and risk management.
• Worked on data modelling, data profiling and produced data mapping and data definition documentation.
• In charge for closing each financial month in Oraclefinancials and data warehouse.
• Prepared Business Process Models and business rules that included modeling of all activities of business from conceptual to procedural level.
• Understood and articulated business requirements and rules from user interviews and then converted requirements into technical specifications.
• Extensively worked with Project Manager to determine the current best practices for requirement gathering.
• Extensively used SQL, PLSQLto create complex queries, SQL Override, Stored Procedures, and Triggers.
• Set up Demand deposit accounts automatically to adjust with interest rates when rate changes occur in money market accounts like mortgage accounts, bond accounts.
• Used MISMO standards in an open process to develop, promote and maintain voluntary electronic commerce procedures and standards.
• Analyzed the strategies of Risk management, Mortgage, Fixed Income and Derivatives in the investment division and conducted Portfolio Performance measurement: return, calculation and attribution.

Environment: Agile, UML, Requisite Pro, Rational Rose, GPP, Clear Quest, SQL,PLSQL, Windows XP, MS Office Suite (Word, Excel, Access, Power Point, Outlook)

Confidential

Business Analyst

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements and data specifications.
• Involved throughout the business Solution Development Life Cycle (SDLC).
• Followed Agile with Scrum SDLC.
• Created and reviewed business requirements, functional specifications, project schedules, and documentation.
• Involved extensively in the inception phase for understanding the Scope of the Project, feasibility of the implementation, and definition of the risk factors involved in the project.
• Conducted JAD sessions for communicating with all project managers, senior management, and other stakeholders.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams, and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Conducted meetings with business users and SMEs to identify and gather various functional and non-functional requirements.
• Helped identify reports for decision support system and interacted with database designers and architect to gather the requirements for reporting.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Environment: MS Access, MS office 2003, MS Excel, Rational Rose, MS Visio, MS Office

Confidential

Business Analyst

Responsibilities:

• Interacted with stakeholders to get a better understanding of client business processes and gathered business requirements and documented them in Business Requirement Document, Functional Requirement Document and User Requirement Document.
• Followed the UML methodology to generate Activity Diagrams, Sequence Diagrams, Class Diagrams and Collaboration Diagrams using Rational Rose.
• Extracting the business requirements from the stakeholders keeping in mind their need for the application and documenting them using Rational Requisite Pro.
• Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narrative using the UML methodologies.
• Created Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in Rational Rose.
• Conducted JAD sessions with management, SME’s, vendors, users and other stakeholders for open and pending issues.
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions.

Environment: Lead Management, Informatica, Oracle 8i, UML, Rational Clear Quest, Product