Business Systems Analyst / Data Analyst Resume
Memphis, TN
SUMMARY
- Over 7+ Years Professional Experience as Business Systems Analyst, Data Analyst in Financial, Banking, Customer Facing B2B, B2C CRM & Retail Environment.
- Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
- Excellent in Developing and evaluating business process Models.
- Proven success as a data analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
- Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
- Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a data analysis methodology for application functionality designs using IBM's Rational Rose.
- Experience in Service Oriented Architecture, writing requirements in an SOA environment.
- Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
- Excellent in Developing and evaluating business process Models.
- Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
- Proven success as a data analyst through the years, conducting data mapping, data profiling, data cleansing tasks.
- Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
- Used SQL to conduct Data Analysis and System Testing. Strong knowledge of SQL ( Inner Join, Right Join, Left Joins, Unions & SQL Functions )
- Professional experience in data analysis, operations management and development, design, documentation and testing.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
- Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
- Advised management on improvement strategies, Competitive & Profitability Analysis.
- Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
- Strong experience in conducting System Testing, User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
TECHNICAL SKILLS
Operating Systems: Win /NT/2K/XP, MS DOS, Sun Solaris, UNIX.
Analysis/Testing Tools: Rational Clear Quest, Win Runner 7.x, Test Director 8.0, Load Runner 7.6, Quick Test Pro 6.5, and
ERP Packages: Oracle ERP (PeopleSoft Financial and SCM modules).
Languages: C, C++, Java, UNIX Shell Script, TSL, PERL, VBScript, PL/SQL.
Web Development: HTML, XML, Java Script, Java, ASP.
Network Protocols: HTTP, TCP/IP and SMTP.
Web Server: Web Sphere 5.0, IIS 5.0, Apache, Web Logic Server.
Front End Tools: VB 6.0and Visual studio.
MS-Suite: MS-Word, MS Excel, MS-Project, MS Outlook, Microsoft Office
Data Bases: Oracle, MS-SQL Server, MS-Access, Sybase and DB2.
Data Warehousing: Informatica PowerCenter 8.1.1/7.1.3/7.1.1/6.2 , Power Exchange, PowerConnect for SAP, Siebel, Autosys, Control M, Maestro, OLTP.
PROFESSIONAL EXPERIENCE
Confidential, Memphis, TN
Business Systems Analyst / Data Analyst
Responsibilities:
- Facilitated requirement-eliciting sessions (JAD sessions) with Subject Matter Experts and other Key Users and documented the requirements in an easy to understand format by both the business and technical stakeholders
- Elicited functional specifications, system requirements, conducted feasibility analysis and performed current state and future state analysis
- Elicited Business Rules and other Non-functional specifications for the new system by interviewing the Subject Matter Experts to further understand the business models
- Handled Requirements throughout the project life cycle including scope/change.
- Conducted Data mapping of fields from Total systems platform (TSYS) to First data (FD) platform.
- Performed Data mapping and used SQL queries to filter data.
- Accurately identified the field's functionality in Total systems and mapped to the corresponding fields in First Data.
- Debugging and Troubleshooting Informatica Mappings
- Work with the SME to understand the definition of the fields.
- Liasoned with the IT, vendor and business user to drive the required solution.
- Analyzed the business requirements and the impact of outbound and inbound interfaces with other legacy applications (processes and reports)
- Compiled source to target mapping documents that was used by the developers for coding.
- Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
- Provide ad-hoc reporting and analysis using SQL from data sources including Oracle and SQL Server Reporting services.
- Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
- Analyzed and developed large quantities of data in SQL to manipulate modify and debug various tables for reporting services. Used Inner Join, Right Join, Union & SQL Functions
- Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
- Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
- Translated Business processes into Informatica Mappings for building Data marts.
- Worked with the developers to make sure that the functionality of the fields in total system is not changed when converted to the First Data platform. Any changes to the functionality were properly documented.
- Created test cases and worked with the QA team to identify the defects.
- Maintained and tracked UAT Bug Reports and coordinated with development team to ensure high priority bugs get fixed in a timely fashion
- Ensured successful UAT testing, training and end user sign off
Environment: Microsoft Office Suite, Informatica, Microsoft Visio, Windows NT/XP, HTML, SharePoint Server, SQL, EVPN, HP Quality Center 10, COBOL, TOAD, Axure / iRise, MS Project, DataStage - IBM
Confidential, DE
Business Analyst/Data Analyst
Responsibilities:
- Liaised with Business and Functional owner during risk engineering and High-level review sessions to derive and execute action plans, meeting deadlines and standards.
- Worked on Validation and Testing Complex Scenarios and projects and in the maintenance of Quality Standards with data mapping analysis, and data quality analysis.
- Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).
- Ensured all artifacts complied with corporate SDLC Policies and Guidelines.
- Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
- Performed GAP analysis of Business Rules, Business and System Process Flows, User Administration, and Requirements.
- Re-designed ETL mappings to improve data quality.
- Developed Use Case with UML for new product functionality
- Involved in creating Business Processes and Modeling Diagrams using Rational Unified Process (RUP).
- Actively Analyze and Classify with Web services Experience and consumption as business in terms of Business Functions &Processes and the information they use
- Performed GAP analysis of System Integration solution wise for migration CPC with XML and UML for file feed and file transformation.
- Created Sequence Diagrams and State Diagram. Experience with technical and user documentation, software conversions with BOFA with Hawaiian Conversion.
- Worked with System Owners for System Architect Diagram, and pega work flow experience
- Worked on Retail Front End and Authentication level for internal and external users
Environment: UML, MS Office (MS Word, MS Excel, MS PowerPoint, XML, MS Visio), MS-Project, Orcale 8.0, XML.SOA, SOAP Windows 2000, Microstrategy, Quality Center, JIRA & TSYS.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Designed the business requirement collection approach based on the project scope and SDLC Methodology
- Wrote business requirements for the Foreign Exchange Options electronic trading platform and the European Repo electronic trading platform after doing a market gap analysis. The FX options electronic trading platform is Tullett's first 24*7 global (targeting both emerging and developed markets) product and is universally acknowledged as the most functional among its competitors. The E-Repo electronic trading platform recently went live in the European market.
- Gathered and wrote business requirements through interview of three regional heads one each for the Americas, Europe and Asia and their teams and observations of existing products in the market.
- Facilitated and led team projects that improved the relationship between voice brokering team and electronic brokering team - teams that didn't historically work well together.
- Understand and articulate business requirements from trader and broker interviews and then translate requirements into functional and technical specifications.
- Wrote requirements for the FXO API Application. The Application needed to be integrated with MS Excel to allow users to upload trade orders from their Excel Worksheet to the system.
- Gathered and wrote the requirements for the Admin. Tool which administers the privileges and rights of the client banks to trade on the FX Options System.
- Worked on integrating the front end application with RTNS, Drive, Indy and Post:marker (STP Gateway developed in-house) back office systems
- Similarly, gathered and wrote enhancement requirements for existing Fixed Income electronic trading products like trading in General Collateral repo's, Bulk Order Entry etc.
- Developed a work product review process for business team documentation and responsible for ensuring proper process implementation.
- Creation management reports on trade activity, liquidity on the electronic trading system in excel using pivot tables and V-lookup functions in order to quickly and effectively generate actionable and insightful analysis.
- Co-authored documents for full life cycle research, development, and initial implementation of pricing models for credit derivatives to be used by the trading desks using Pivot tables, V-lookups and Offset functions.
- Carried out the business impact analysis and maintained documentation
- Involved in Joint Requirement Planning (JRP) sessions with the business Group.
- Conducted joint application development (JAD) and requirements review sessions with the IT and QA group.
- Worked closely with the UI to model the screens, which met user defined requirements, organizational and regulatory standards.
- Responsible for the completion of projects within specified time and budget dealing with financials, project workflow, change management and dealing with vendor relationships.
- Efficiently responded to customer inquiries and resolved discrepancies.
- Identified and prioritized essential business requirements based on customer feedback.
- Managed credit exposure associated with the banks broad range of foreign exchange, Derivatives, and Treasury Management products.
- Gathered requirements from various user groups, author system specifications and communicated them to the client, development and testing teams.
- Responsible for all business activities associated with each project's product deliverable, including building a better relationship and communication with the client as well as the development team.
- Instrumental in creating a formal release management process including templates for the requirements and testing documentation.
Environment: RUP, UML, Rational Requisite Pro, Enterprise Architect, MS Project, MS Office, DOORS, SQL, Bloomberg.
Confidential, Bridgeport, CT
Business Analyst
Responsibilities:
- Reviewed the Business Requirement documents with the business and development team to understand the architecture and functionality of the application.
- Involved in gathering business, technical and performance requirements.
- Converted the User Requirements into Business Requirements, Functional Requirements and Technical Requirement. Also created Business Process Models from the requirement specifications.
- Created Use Case specifications, Business flow diagrams, Activity/State diagram and Sequence diagram using MS Visio, so the developers and other stake holders can understand the business process according to their perspective with possible alternate scenarios.
- Communicated extensively with the Financial Examiners and with different levels of management to identify requirements, use cases and to develop functional specifications.
- Implemented RUP and followed iterative, Use Case driven process for requirement documentation and deployment.
- Designed and developed automation and manual regression test strategies for functional testing.
- Maintained defect tracking and metrics, final assessments of the product on test.
- Involved in Message Que Configuration on Unix Env.. And validated on XML Messages on Message Que Hub.
- Involved in build approvals releases on QA Track.
- Meeting to the Developers to resolve the issues
- Performed migration of Projects from Test Director 8.0 to Test Director 9.0
- Performed Adding of Projects, Migrating and Administration of Test Director Quality Center.
- Developed Test Plan, Test Cases and Test Scripts in Test Director.
- Used Test Director for tracking and reporting defects, enhancement requests, and assess the real status of project throughout the life cycle.
- Participated and Initiated Team meetings on a regular basis and involved in active discussion in order to improve the testing quality by better strategies and testing approach.
Environment: Test Director 8.0 & 9.0,QTP, .Net, SQL Server 2000, PVCS Tracking Tool, Microsoft Office, MS Project.