Business Systems Analyst/ Data Analyst Resume
New York, NY
SUMMARY:
- Experience in IT and financial services industry/banking domain with 7 years of experience in Business Analysis and data Analysis in the areas of requirements gathering, analysis, design, development, testing and implementation
- Extensive experience in banking domain working on mortgages, credit cards, loans, insurance.
- Strong skills in SQL,datawarehouse,dataexploration,dataextraction,datavalidation, reporting and excel.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in tableau.
- Experience inDataIntegration Analysis, Requirements and Implementation of BIGDATAproject using Hadoop Ecosystem and Hive. Knowledge indataingestion tools and implementation of structureddataintegration and archival process;
- Extensive experience in the Software Development Life Cycle with a proven track record of working on various projects related to new enhancements, conversions, release upgrades and BAU
- Experience of software methodologies such as Waterfall, Agile, and Rational Unified Process (RUP)
- Solid background in requirements elicitation, analysis, management and prioritization
- Proficient in creating UML diagrams (Use Case Diagrams, Sequence diagrams, Activity diagrams, Class diagrams)
- Experience in writing test cases, building test conditions, creating test data, analyzing defects and reporting
- Experience in creating Data Mapping Specification for Data integration and Data Migration
- Excellent interpersonal skills. Able to work with all levels of management, staff, vendors, and clients
- Exemplary work ethic with excellent analytical, reasoning, and communication skills
- Managed to build good relationship with the clients, internal teams and provided excellent support by addressing all queries effectively.
- Utilized organization and project management skills to efficiently prioritize, route and resolve issues faced by clients.
- Proactively suggested/implemented alternative solutions to existing processes and contributed to the success of the organization
- Successfully coordinated support teams of First Data that spanned 6 countries and 3 continents.
TECHNICAL SKILLS:
Operating Systems: Windows 7/8/10, Linux(Ubuntu), MAC OS.
Office Suite: MS Word, Excel, PowerPoint
Cloud Computing: MS Azure, IBM Bluemix, AWS, Citrix
Requirement gathering techniques: Brainstorming, Interviews, Workshops, Focus Groups, JAD sessions
Languages: JavaScript, Java, Python, R, SAS, SPSS, PLSQL.
SDLC Methodologies: Waterfall, Agile, RUP
Databases: Oracle, My SQL, Microsoft SQL, PL/SQL, NoSQL.
Project Management tools: MS Project, MS Visio
Data Analysis tools: SQL, Python, R, Tableau, Data Visualization
Other Tools: Tableau, Hadoop, Apache Hive, IBM Watson, JMP, Looker, Visual Studio, Oracle11g, Google Analytics, Adobe Analytics, Salesforce, Jira, Marketo, Visio, ERP, Excel, MS Access, Power BI.
PROFESSIONAL EXPERIENE:
Confidential, New York, NY
Business Systems Analyst/ Data Analyst
Responsibilities:
- Actively participated in gathering the business requirements by interviewing the Subject matter experts (SMEs) and documented them in a format that could be reviewed and understood by both business and technical teams.
- Producing and managed documentation on release activities to support problem resolution and post - release analysis.
- Involved in publishing of various kinds of live, interactivedatavisualizations, dashboards, reports and workbooks fromTableauDesktop toTableauservers
- Created Project Implementation Plan to determine the objectives, milestones, progress mapping, back-out dependencies & Plans.
- Involved in the below phases of Analytics using R,Python.
- Creating Process Work flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Requirement Document (FRD).
- Reviewed, evaluated, designed, implemented company databases.
- Conducted Business impact analysis, assessed risks and implemented continuity and recovery tests with the support of supply chain, risk, Audit and IT Management.
- Involving in developing test case objectives to ensure accurate depiction and computation of risk of the securities, reported errors to the appropriate team.
- Generate Customer and sales forecasting reports in MS Excel andTableau
- Developing Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
- Created requirements, monitored requirement coverage and tracked defects using HP Quality Center.
- Verifying the Business Scenarios on new builds to allow extended testing by the QA team.
- Prepared basic design diagrams including flow charts, data flow diagrams, class diagrams etc using MS Visio following the UML conventions.
- Created business and technical release notes, and presented these to end-users and project stakeholders.
- Forming a bridge between the Project Manager and different teams with effective presentations.
- Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
- Organized a number of JAD sessions wherein the SME's, designers, developers and testers could communicate to enhance the quality of the desired product.
- Assisted Quality Assurance team while conducting the User Acceptance Tests.
Environment: Windows XP, UNIX, MS Office 2007, Quality Center, HTML, Tableau, Microsoft Visio, .Net, Windows NT/XP, Oracle, SQL Server, UML, J2EE
Confidential, Fresno, CA
Business Data Analyst
Responsibilities:
- Responsible for gathering both business and user requirements
- Responsible for the creation of functional requirements for the web-based technology projects
- Played a key role in requirement gathering for the complete application during the various phases of its development.
- Worked with SMEs in gathering their experience with previous software version in order to better understand and outline scope, vision documents for the project.
- Web Scraped Internet websites, using Import.io,Python, and R, to gather demographic and contact information of companies.
- Datacleaning,DataVisualization, Detection of missingdataand skewness, correlation analysis, principal component analysis and model development were performed on thedata
- Analyzed Enhancement requests and Modification requests on a system that allows consumers to move a phone number from a wireline phone to a wireless phone Prepared departmental reports providing analytical framework related to the Corporate Actions.
- Involved in the below phases of Analytics using R and Python.
- Interacted with software developers and the rest of the technical team
- Analyzed, revised and created test plans according to business requirements.
- Wrote Use cases and Activity Diagrams
- Followed the RUP methodology for the entire SDLC process
- Analyzed consumer surveys and gave technical inputs in Business meetings.
- Gathered requirements from the customers so that the existing website could be improved and it could include portfolio diversification for decreasing market risk and doing risk management.
- Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in definition stage
- Facilitated the customer in defining the high-level functional requirements and needs
- Participated in the team for User Acceptance Testing
- Used MS Visio to design projects
- Involved in Systems validation and the Business Requirements
- Wrote numerous test cases based on test strategies
- Validated the system end-to-end testing to meet the approved functional requirements.
- Comprehensive use of MS Visio to group project use cases into Sequence and Activity Diagrams based on UML methods thereby defining the business process model.
- Experienced in providing fiscal and economic solutions through financial modeling and cost-benefit analysis.
- Created test cases based on analysis of business requirements and system specification.
Environment: UNIX, SOA, Web Services, UML, Tableau, Python, Windows 2000, Apache, and Oracle.
Confidential, Washington, DC
Business Analyst
Responsibilities:
- Actively involved in implementing loan origination module using Microsoft .NET Framework, Windows Presentation Foundation and Windows Communication Foundation for easier interface use and increased scalability and configuration flexibility.
- Worked with stakeholders, management and implementation partners to gather, manage, and prioritize requirements, raise issues, identify obstacles, and recommend options, right from inception till maintenance to ensure successful system implementation.
- Studied, analyzed and documented as-is business process and performed the fit/gap analysis.
- Gathered comprehensive, detailed descriptive needs of user, program functions, and steps required to develop or modify software applications
- Work closely with enterprise architects and technical team to align designs that enabled strategic business outcomes
- Provide preliminary mock-ups to the UI designer as well as create data and system flow charts for projects assigned
- Work with a cross functional team of developers, QA, and documentation to ensure requirements were received and understood
- Assess IT impacts and risks and assumed a leadership role in the overall design and documentation of application / data / technical architectures
- Provide requirements for enhancements and ensured implementation into appropriate materials for the documentation team
- Perform user acceptance testing to ensure developed software will meet business needs
- Provide editing and review of all documentation prior to release to external clients
- Actively participate in the development process - ensure timelines, updates, schedules and requirements were communicated clearly and all questions/issues were promptly resolved.
- Incorporated Out of the box (OOTB) functionalities into requirements to avoid gaps in requirements and keeping stakeholders’ expectations close to reality.
- Conducted UAT (User Acceptance testing) in both company and client sites.
- Worked with Tracer, Rules Inspector and Clipboard for troubleshooting.
Environment: Windows XP, UNIX, MS Office 2007, Quality Center, Oracle, SQL Server, UML, J2EE