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.
• Gatheird 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-TEMPEffect 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 noledge 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 me, 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 2013, IBM DB2

Version Controllers: Subversion, GIT, IBM Clear Case.

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

Programming/ Query 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, REST Client, Backtrack 4 R1/R2, OBI-EE, MS Access

PROFESSIONAL EXPERIENCE

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 TEMPeffectiveness, used AxiomSL for Regulatory Reporting.
• Created business and compliance risks documents dat drive data governance, the areas of risk associated with master data dat 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, 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 and Data Cleansing.
• 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.
• Conducted feasibility studies for Requirement Churns thus ensured triple constraint balance.
• Reduced data latency for existing high volumes and variety of data combining data discovery components: Data Preparation, Visualization and Mining/Advanced Analytics.
• Worked on Change Data Capture (CDC) to implement Slowly Changing Dimensions (SCD).
• Developed test plans and test cases using HP QC Application Lifecycle Management.
• 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 using Oracle Business Intelligence- Enterprise Edition (OBI-EE) and R-based Oracle Data Mining (RODM) interface for Data mining.
• Worked on service-oriented architecture (SOA), RESTful API’s generating JSON, BSON, XML responses using PL/SQL and JDBC drivers to establish connections with databases.
• Responsible for writing the Release Notes, documenting all the useful info about the release, software versions, changes implemented in current release, Defects fixed, Labels applied.
• Assisted testing team with data debugging by tracing and replaying the data flow via flow diagrams.
• Involved in periodic archiving and storage of the source code for disaster recovery.
• Worked closely with compliance to develop an understanding of rules and regulations.
• Familiar with regulations for FINRA, Basel Accords, Same Day ACH and Bank Secrecy Act (BSA).

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.

Sr. Business Systems Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Involved in defining the scope of the project and business rules, gatheird 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, theirby 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 and assist 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.
• Analyzed data contained by the databases using Structured Query Language (SQL and PL/SQL) and Tableau to confirm data accuracy and integrity of various reports.
• Quality Assurance testing of new iterations, created and executed test plans, test cases, identified and documented bugs by working closely with the development team.
• 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 2013, MS SQL Server Management Studio, JIRA, Trello, GIT VCS, Jenkins, Microsoft Visio, Selenium.

Business Systems Analyst

Confidential, Deerfield, IL

Responsibilities:

• Worked on project for strategy development, industry trends, competitive analysis following industry practices to third party operations and procedures
• Extensively practiced all phases of SDLC with responsibility of carrying out root cause analysis, delivery of system and business process.
• Analyzed System Requirements Specifications (SRS), Functional Specifications Documents (FSD), business process analysis and design documentation, prepared Solution Design Document with requirement & data mapping from source to target (S2T).
• Analyzed trends derived from data and designed implementation model to optimize performance and reduce disruptions doing Business Impact Analysis.
• Worked with cross-functional teams in forecasting improvements using metrics and business process improvements by Value Stream Mapping and Cause-TEMPEffect analysis.
• Tracked sprint progress by maintaining burndown charts, task boards and defect matrix.
• Created work flow diagrams and cost-benefit analysis to help support product initiatives.
• Participated in managing the scope of applications and related changes.
• Ensured consistency and traceability between user requirements, functional specifications and testing & validation using Requirement Traceability Matrix and HP QC-ALM testing tool.
• Responsible for conducting complex and thorough research of existing processes, systems, systems logic, hardware deployment and desired objectives to develop detailed systems specifications to meet the objectives of the assigned projects.
• Improved usability of web application using HTTP accelerator, Load Balancers redesigned the request-response services using REST API to reduce response latency by 35%.
• Assisted Product Owner in creating User Stories and Prioritizing the user stories during Backlog Grooming session using Business Value Based Prioritization technique.
• Conducted time-boxed Retrospective Meetings including Silent Writings, Mad-Glad-Sad, SSKML and ORID technique and successfully helped the team inspect the sprint performance and adapt to the changes for the upcoming sprints improving team’s efficiency by 20%.
• Created and analyzed test scenarios, test plans, test cases, identified and documented errors by working closely with the development and testing teams.
• Created guidelines, standards, procedures, processes, applications by following technical writing and ability to write paper-based and online technical reference documentation.
• Utilized SQL skills including Stored procedures, Indexes, Views, User Defined/ Named Set of Values (Domains), Triggers, Bulk Copy Program (BCP) utility and Bulk Insert for Data Import and Export to and from SQL Server Databases.

Environment: JIRA, Confluence, Apache SVN, SQL/ T-SQL, HP QC-ALM, XML/JSON, Jenkins, REST client.

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.BusinessAnalyst.
• Worked with cross-functional teams in forecasting improvements using metrics and business process improvements by Value Stream Mapping and Cause-TEMPEffect 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 dat followed efficient design techniques and development dat 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 standbydatabasesites and databaseor 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 withMySQLGUI toolsMySQLWorkbench,MySQLAdministrator,MySQLQuery Browser andMySQLMigration 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.