We provide IT Staff Augmentation Services!

Business Data Analyst Resume

Alpharetta, GA

SUMMARY:

  • IT Professional with 8+ years of industry experience in Business Analysis, adept in discovery, requirement analysis, system design, testing and SDLC documentation, successful record of achievements in data analysis, database management and Data warehousing.
  • Experienced in working in Agile, Scrum, Waterfall - Scrum Hybrid and Waterfall environments.
  • Comprehensive experience in Banking, E-commerce, Retail, Research & Development domain.
  • Gathered and documented business requirements from planning sessions using dashboards.
  • Proactively classified opportunities for workflow management and process improvements.
  • Facilitated Scrum ceremonies - Sprint Planning Meeting, Daily Stand-ups, Sprint Review and Sprint Retrospective Meetings, and activities like - Backlog grooming, Release planning.
  • Created and maintained information radiators like Sprint Burndown charts, Release Burnup charts, Task boards in order to track sprint progress and also to forecast the future sprints.
  • Produced and maintained artefacts including Requirement Traceability Matrix, Software Requirement Specification Documents, Test Plans & Test cases and User manuals.
  • Acted as a skilled liaison between the development teams and the Business.
  • Elicited requirements using Document Analysis, Interviews, Brainstorming, conducting Joint Application Development (JAD) sessions, Survey and Questionnaire.
  • Worked with cross-functional teams in forecasting improvements using metrics and business process improvements by Value Stream Mapping and Cause-Effect analysis.
  • Skilled at Planning Poker, T-shirt size and Dot-voting methods to estimate user stories in Scrum.
  • Handled high volumes and variety of data combining data discovery components: Data Preparation, Visualization and Mining/Advanced Analytics, thus reducing time to generate insight.
  • Facilitated meetings to help the team break down Product Backlog Items PBI’s into user stories based on the INVEST criteria and SMART criteria to break user stories into Tasks in Scrum.
  • Well versed with MoSCoW, Business Value based, Walking Skeleton techniques for User Story prioritization and assisted teams with wireframes, prototyping for designs and data modeling.
  • Adept in creating design models using UML diagrams including Sequence Diagrams, Use-case Diagrams, Class Diagrams, Activity Diagrams and Data Flow Diagrams.
  • Experience in Continuous Integration, Continuous Deployment, Release Management, Master Data Management, Data Profiling, Data Analysis, Data Discovery, Source to Target (S2T) data mapping documents using parsers like Oracle APEX, Java DOM.
  • Extensive hands-on experience creating prescriptive data lineage, active data lineage using Informatica Metadata Manager combined with Informatica Developer.
  • Created lineage tables to extract/consolidate ODI and OBIEE metadata using OBI-EE data lineage and Oracle Data Integrator (ODI) for data storage.
  • Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, Fact and Dimensions tables.
  • Comprehensive understanding and experience in Web-Services and technical writing in JSON, XML.
  • Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Microsoft SSIS, IBM InfoSphere, Informatica PC.
  • Aided improve the Know Your Customer (KYC) by using available data to segment customer base.
  • Experience working with database environments like Oracle, SQL Server, MySQL.
  • Assisted Testing team with data debugging by tracing the data flow from flow diagrams.
  • Adept in analysis and testing of benchmarking the application against industry standards like Payment Card Industry Data Security Standards PCI DSS, Customer Identification Program CIP, Suspicious Activity Reporting SAR as per the Bank Secrecy Act.
  • Worked closely with compliance to develop an excellent understanding of rules and regulations. Familiar with regulations for FINRA, BSA, Basel I, II and III, NACHA.
  • Aggressive Problem solver, technically precise, Analytical Thinker, Sharp troubleshooting skills, excellent written and verbal communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Mac OSX

Databases: Oracle, MySQL, Microsoft SQL Server 2012, IBM DB2

Version Controllers: Subversion, GIT, IBM Clear Case.

App dynamic, Service Now, BMC Control: M, Oracle ITSM.

Languages: SQL, PL/SQL, C, C++, HTML/CSS, Swift/ Objective C, VB.NET

Web/Application Servers: Apache Tomcat, HTTP Server, Oracle WebLogic, Oracle Glassfish

Tools: IBM InfoSphere, Tableau, Talend, Jenkins, JIRA, Erwin data modeler, TOAD, Informatica PowerCenter, SSIS, HP QC-ALM, CA Agile Central (Rally), Selenium, Enterprise Architect, Star UML, X-code, R-Studio, Eclipse, NetBeans, VMWare, Weka, IBM Emulator, PuTTY

PROFESSIONAL EXPERIENCE:

Business Data Analyst

Confidential, Alpharetta, GA

Responsibilities:

  • Worked closely with the Business to gather requirements based on the change requests raised.
  • Wrote SQL queries for Data validations in SIT and UA Testing environments.
  • Worked with Business to carry out impact analyses bases on the Change Requests.
  • Carried out core banking system’s query migration from SIT to UAT using IBM Mainframe Backend and performed the recompilation of each of the queries during every upgrade.
  • Created data mapping documents based on the source to target data flow requirements.
  • Used PuTTY to access SAS grid to resolve file delays that would impact the current day data loads and reported any missing files or empty files received to the source team to retransmit the data.
  • Testing environment query scheduling based on the Business’s service level agreement.
  • Worked with Data Warehouse team to find out the SLA for the new Change requests.
  • Created a new set of Mainframe queries and scheduled them in Prod Environment.
  • Worked with QA team to create test scripts and Data Validations using SQL database and created testing plan to identify risks and issues and close them before deployment.
  • Created a project deployment plan for the Secured card project release in co-ordination with the Core Banking system’s SLA to make sure any upgrades would not impact the release.
  • Performed data validations for 2-week SLA for consumer banking project deployment.

Environment: IBM Emulator, Oracle 11g, PuTTY, SAS grid, MS Excel, SQL Developer, Planview, Sharepoint

Sr. Business Systems Analyst

Confidential, Santa Clara, CA

Responsibilities:

  • Involved in defining the scope of the project and business rules, gathered business requirements by conducting Interviews, Joint Application Development (JAD) sessions, Focus Groups, Brainstorming sessions with the Business Users and key-Stakeholders.
  • Documented and maintained Business Requirement Documents (BRDs), Functional Specification Document (FRDs) and Software Requirement Specification (SRS) documents.
  • Responsible for advanced analysis of non-commercial customer enrollment data, product data, transactional data and demographics to create through reports and identify potential risks.
  • Mitigated risk factors through careful financial and statistical data analysis and managed changes.
  • Developed metadata documentation using MS Word (printable) and LucidChart for online demo.
  • Worked with the Scrum Team and Product Owner to negotiate delivery of Minimum Viable Product.
  • Assisted team in making achievable task commitments through user story selection and resizing, thereby reducing development times by 15%.
  • Tracked sprint progress by maintaining burndown charts, task boards and defect matrix.
  • Created and maintained Data Dictionaries, Discovery documentations mapped with legacy systems to resolve inaccurate data entries during ETL process, assisted in accurate S2T data mapping.
  • Conducted release planning in Agile environment & coordinated releases with development team & software quality assurance team for timely delivery.
  • Proposed business solution by defining Key Performance Indicators (KPI’s), designed and developed an automated solution using Tableau.
  • Used a Decision Tree model to rank input variables based on the priorities set by Business owners.
  • Actively involved in reading data from varied file types created standard and ad-hoc reports using PL/SQL and Erwin, generating delimited files and SQL script to load data into SQL tables.
  • Executed SQL scripts to manage data from legacy systems and monitored and tracked ongoing data quality levels on a regular basis to identify, resolve and ensure data integrity and data quality.
  • Managed source codes, software builds, software versioning & defect tracking on software maintenance tasks/projects using Git Version control system.
  • Assisted on new initiatives like the University Program Initiative which involved integrating University databases with banking database, ensure data integrity and security.
  • Worked closely with compliance coordinator to gain understanding of United States’ Banking Compliances and Federal Regulations.

Environment: Talend, Tableau, Microsoft SQL Server 2012, MS SQL Server Management Studio, JIRA, Trello, GIT VCS, Jenkins, Microsoft Visio, Selenium.

Sr. Business Systems Analyst

Confidential, Wilmington, DE

Responsibilities:

  • Directed business process improvement projects and entire life cycle for near real-time payment system for business groups thus improving business results.
  • Managed IT activities, processes, system progress, improved organizational efficiency and effectiveness, used AxiomSL for Regulatory Reporting.
  • Created business and compliance risks documents that drive data governance, the areas of risk associated with master data that require data management and governance scrutiny.
  • Documented business opportunities, assessed benefits, risks and success factor of applications.
  • Skilled at breaking down Epics into user stories based on INVEST, Tasks using SMART criteria and making sure the Product Backlog Items meet DEEP criteria working in Agile framework.
  • Created and maintained Data Discovery documentation containing information about Id, Data source, Description, Data-types, Author/creator using organizational data discovery templates.
  • Extensively used tools like JIRA for User Story, Tasks, Defects and Issue tracking and helped the team resolve the identified impediments and potential blockers.
  • Handled high volumes and variety of data using data discovery tools like Informatica for data preparation during ETL process, OBIEE for mining and Tableau for data visualization.
  • Created guidelines, standards, procedures, processes, applications by following technical writing and ability to write paper-based and online technical reference documentation.
  • Optimized performance using Data Verification, Validation, Data Cleansing during ETL process.
  • Created Data Dictionaries, mapped with legacy systems to resolve inaccurate data entries.
  • Performed transformations like Merge, Sort and Update to get data in required format.
  • Maintained data access using restrictions and issuing electronic and automatic renewals upon CD Certificate of Deposit maturity.
  • Reduced data latency for existing high volumes and variety of data combining data discovery components: Data Preparation, Visualization and Mining/Advanced for transactions including Savings/Checking accounts, Deposits.
  • Involved in Functional testing: Regression testing, Smoke testing, Sanity testing User Acceptance testing and Non-Functional testing.
  • Performed loading operation from source to target data using SQL *Loader for Oracle databases.
  • Created business intelligence reports based on predictive analytics using Tableau, Ad-Hoc query and reporting after ETL using Oracle Business Intelligence- Enterprise Edition (OBI-EE) and R-based Oracle Data Mining (RODM) interface for Data mining.

Environment: Enterprise Java Beans (EJB), J2EE runtime Environment, Oracle 11g, Tableau, Informatica, Oracle WebLogic, JIRA, RODM, AxiomSL, Akamai Reverse Proxy, Erwin Data modeler, Apache Tomcat 7.0, RESTful APIs, Java API for XML-RESTful Services (JAX-RS), HTML/CSS, JavaScript, Jenkins.

Process Automation Business Analyst

Confidential

Responsibilities:

  • Developed Business Requirement Documents, functional requirements specifications, use cases, storyboards and GUI mockups.
  • Created workflow to automate Business process using Nintex and SharePoint.
  • Acted as liaison with offshore business analysts, software QA engineers, software developers.
  • Developed written interactive tutorials for technical writing and aid customer interaction.
  • Experience with analysis of logs and performing root cause analysis for various issues coming up.
  • Monitoring Live Traffic logs, Memory utilization, Disk utilization.
  • Proactively communicated and collaborated with personnel of the client, including executives and managers, to analyze software system needs and functional and business requirements.
  • Monitored, tracked ongoing data quality levels on a regular basis, identified and established optimal approaches to resolve data quality issues through root-cause analysis.
  • Worked with teams to complete short term business goals. Elicit business requirements to implement and improve Business Intelligence (BI) software systems using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis.
  • Created service-oriented architecture, client-side object model API’s for JavaScript applications.

Environment: Adobe CMS suit, Adobe Lifecycle, MS Access, MSWord, Excel, Docuware, Nintex workflow

Jr. Business Analyst

Confidential

Responsibilities:

  • Analyzed data contained in the database using SQL, and Tableau and business performance reporting using Geneos v3.1.0 and facilitated team reviews weekly, Bi-weekly, monthly, and quarterly.
  • Analyzed raw data and metrics to back up assumptions, developed business cases and created Gap analysis document by conducting Fishbone Analysis to solve business problems.
  • Created Software Requirement Specification (SRS) and Functional Requirement Specification (FRD), Request for Proposal (RFP), Use cases, Test Cases and Unified Modeling Language(UML) diagrams under the supervision, guidance and support of Sr. Business Analyst.
  • Worked with cross-functional teams in forecasting improvements using metrics and business process improvements by Value Stream Mapping and Cause-Effect analysis.
  • Performed end-to-end, load and regressing testing of the system, managed critical deliverables with 98% Service-Level Agreement (SLA) compliance.
  • Maintained stability of production environment, testing(QA) and development environment for distributed Data Warehouse application, achieving a customer satisfaction index of 95%.
  • Maintained ETL solution utilizing various database, data blending & visualization in Tableau to continually improve reporting and analytic capabilities and designed data models to in corporate decision support system to identify Data Quality pain area by cleansing and verifying data integrity.
  • Created stored procedures using SQL Server Business Intelligence Development Studio and used them to create dashboards, charts, and reports.

Environment: CA Agile Central (Rally), Tableau, BMC control-M, Geneos (APM), Agile (Scrum/Kanban), Boards, SQL Server Management Studio, Microsoft Visio, Eclipse Indigo.

Business Analyst

Confidential

Responsibilities:

  • Facilitated Business meetings and coordinated with Business teams to elicit requirements precisely.
  • Well versed with SDLC phases - Requirements Gathering, Analysis and Design, Development, Testing, Implementation and Deployment and deliverables of each phase.
  • Responsible for creating Technical Requirement Documents and Software Requirements Specification.
  • Participated in daily scrum meetings with cross-functional and self-organized teams.
  • Created work flow diagrams and cost-benefit analysis to help support product initiatives.
  • Participated in managing the scope of applications and related changes.
  • Proposed business solution by defining Key Performance Indicators (KPIs), designed and developed an automated solution; Reduced team effort by 30%.
  • Served as a critical point of contact between the business and the development team working closely with business users to gather and document the Functional and Non-Functional requirements.
  • Generated reports of the issues identified including impact, firewall policies and proof of concept.
  • Supported the development team in addressing and integrating Security in SDLC by using techniques like Penetration testing, Risk Management and Threat Modeling.
  • Created test plans by examining the flexibility of the application against identified threats and assisted testing team in conducting Integration and Smoke tests.
  • Executed application security tests for Mobile application and thick clients to ensure quality performance and Nmap to conduct pentests.

Environment: Agile Scrum, Apache HTTP server, Akamai (content delivery), HTML/CSS, JavaScript, HP Quick Test Professional, Nmap.

Database Engineer

Confidential

Responsibilities:

  • Designed, developed and implemented data solutions to include: architecture design, prototyping of concepts to proof of concept, development of standards, design and development of test plans, code and module design, development and testing, data solution debugging, design and implementation of a solution that followed efficient design techniques and development that met and exceeded the intent of the design of the data solution.
  • Proactively monitored databases, tuned their performance and performed troubleshooting.
  • Developed and maintained ETL process to allow continuous inflowing data to sync with database.
  • Created new database instances, refreshed and cloned databases.
  • Performed disaster recovery exercises which involved switchover and failover over primary and standby database sites and database or schema level refreshes using the traditional Export/Import using data export and import wizard and backup utilities.
  • Involved in periodic archiving and storage of the source code for disaster recovery.
  • Experience with MySQL GUI tools MySQL Workbench, MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
  • Data migration between environments using Export/Import, Transportable Tablespace.
  • Developed normalized Logical and Physical database models to design OLTP system for the project.

Environment: MS SQL Server 2008, MS Excel, SQL Server Management Studio, Microsoft Visual Studio 2008 including Visual Studio Debugger, MS Server Migration Assistant.

Hire Now