SUMMARY

• 7+ years of experience as a Senior Business Data Analyst/Business System Analyst/IAM Business Analyst.
• Experience working in Waterfall and Agile Methodologies to solve problems and deliver projects in a fast - paced environment.
• Facilitated sprint planning, daily scrum, and sprint demos, retrospective and cross-team coordination.
• Proficiency in using issue tracking and agile management tools such as JIRA, VersionOne and Rally (CA Agile Central) to document user stories, conduct sprint planning, track sprint progress and monitor the team's statistics.
• Author User Stories and maintain Product Backlog, Sprint Backlog.
• Highly experienced in capturing requirements through interviews, workshops, JAD sessions, GAP analysis and existing systems documentation thus formulating the business requirements document.
• Strong writing skills in preparing Business Requirement Documents (BRD), System Requirement Specifications (SRS), Software Requirement Specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and Technical Design Document (TDD).
• Documents requirements using Unified Modeling Language (Use Case and Activity Diagrams) and builds business Process Flow Charts.
• Understanding of directories (AD/LDAP) and group structures, policies etc.
• Experience in design and implementation of SailPoint, OIM, configuring Active Directory, and Shared Folders.
• Experience in Maintaining standard information security policy, procedure, and services.
• Experience in Implementing ITSM, ITOM, ITAM, ITBM using ServiceNow suite of modules.
• Expertise on ServiceNow modules such as Service Catalog, Incident, Change, Vendor Management, Problem, Knowledge, Reporting and more.
• Adept in writing SQL queries for data extraction, manipulation, analysis, and validation, generating user reports and proficient knowledge of Relational Database Management Systems (RDBMS), and Data Warehousing.
• Outstanding Data analysis skills including developing of Source to target database Mapping Document for ETL coding, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Wrote SQL queries for Data Validation and Data Mapping.
• Experience inDataMining,Datamapping and Data modeling and good understanding of the ETL tools like SSIS, and Informatica Power Center.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), Business Objects, Crystal Reports and MS Excel spreadsheets.
• Experience working in different Relational Database Management Systems (RDBMS) like SQL Server, VBA and Teradata.
• Experienced in Functional, Integration, Regression, User Acceptance UAT, System.
• Experienced in writing test plans and test cases.
• Professional in using Requirement Management Tools such as JIRA, HP ALM/Quality Center, TFS, Rally.
• Reviewed test scenarios and test cases for UAT and regression testing to support pre and post implementation of applications and production issues along with QA and other business groups, in addition to maintaining Test Matrix and Requirements Traceability Matrix RTM.
• Prepared use cases, experiments, test contents and false ups.
• Presented screen-mockups and wireframes to showcase workflows of requirements to the stakeholders.
• Capable of setting up great affinity with partners, upper administration, designers and QA group to accomplish business objectives.

TECHNICAL SKILLS

Project Methodologies: Waterfall, Agile

Business Modeling Tools: MS Visio, Signavio, IBM Rose, UML Case Tools

Requirement Management Tools: VersionOne, Jira, Rally, Confluence

Defect Tracking Tools: ALM, Jira, TFS, Rally

Operating Systems: Microsoft Windows, Mac OS., Unix, Linux

Databases/Languages/ETL/BI Tools: MS SQL Server, Teradata, RDBMS, Oracle DBMSSQL, PL/SQL, T-SQLSSIS, Informatica Power Center, SSRS, SAS, Tableau, Power BI, Busines ObjectsOther Tools MS Project, Clarity/Open Workbench, Word, Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Cranston, RI

Senior Business Data Analyst/ IAM Business Analyst

Responsibilities:

• Facilitated AgileScrumceremonies withScrumMasterfor specific technical tracks including: sprint iteration planning, story grooming, daily stand ups, sprint retrospectives and release planning -ScrumProject across all disciplines of the organization.
• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents (BRD) and supporting documents that contain the essential business elements and detailed definitions.
• Provided input into developing and modifying systems to meet client needs and develop business Analyze client's business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Played a pivotal role in facilitating JAD sessions to develop detailed solutions and to verify the application development process.
• Wrote the business requirements in Jira Agile Epics and user stories format and uploaded and assigned the user stories in Jira for both Agile (sprints) methodology.
• Created the list of backlog items and prioritized the product backlog in Jira during the sprint planning meetings.
• Analyzed all applications which send user entitlement feed file to Sailpoint and categorized them on the basis of configuration type as High, medium or low risk applications
• Co-ordinated with ETL team for business transformation process on feed files sent from application end to be received on a standard format to SailPoint.
• Worked on multiple critical work streams including, automated provisioning and deprovisioning, self-service access request (SSAR) via Sailpoint and RBAC.
• Consulted with the Information Security Team to protect company data and use of PII data on the form, in the workflow.
• Performed “AS-IS” and “TO-BE” assessment to understand the underlying gap in the business process.
• Worked on Sail Point reporting capabilities, for example: User Monitoring report, Mover report, Provisional services report and other standard sailpoint reports
• Created scope analysis of Converting Applications which were only UER (User entitlement reviews) in Sailpoint and converted them to Self-service access request.
• Involved in design and implementation of SailPoint, configuring Active Directory, and Shared Folders.
• Involved for Global Active Directory Access on multiple Business Applications. (VPN, SharePoint, VDI, Skype…) Creation of Lotus Notes User accounts in conjunction with Active Directory.
• Responsible for providing access to Remote Desktop users via Active Directory and Lotus Notes.
• Utilized Security Information and Event Management (SIEM), Intrusion Detection & Prevention (IDS / IPS), Data Leakage Prevention (DLP), forensics, sniffers and malware analysis tools.
• Implemented multiple tools including DLP, and QRadar SIEM.
• Coordinating with Business Partners and Information Technology Application Groups to define Business Roles and Technical Roles and assisted in integrating these requirements into IAM solution.
• Configured, analyzed, and maintained IAM tool ensuring high efficiency and effectiveness of the tool.
• Prepared Business Requirement Documentation for Service Desk.
• Reviewed existing IT processes in ServiceNow to identify areas of improvements & enhancements.
• Implemented and configured new ITSM platform ServiceNow.
• Conducted integration analysis and studied critical dependencies on Servicenow modules for delivery of ITAM within the DB environment.
• Worked with stakeholders to document future state processes for Incident Management, Change Management, Knowledge Management, and Service Request Management as part of ITSM management on ServiceNow.
• Provided operational support for end-users and development issues related to the Service Request function on ServiceNow.
• Gathered data requirement from the Anti-Money Laundering (AML) team to use the new Data Warehouse as a repository for their reporting needs and work closely with them about Data requirements for reports like Currency Transaction Reports (CTR) and Suspicious Activity Report (SAR).
• Designed and analyzed Security Administration processes/workflows, recommended ways to improve efficiency and effectiveness and helped implement the solutions.
• Operated regular inspections of systems and network processes for security updates.
• Conducted audit process for initiating security and safety measures and strategies.
• Worked closely with application developers to maintain custom extensions of Identity Access Management environment.
• Defined requirements and analyzed all data feeds to ensure that IAM is receiving accurate and timely data from target systems and other data sources.
• Conducted privacy and security impact and/or risk assessment analysis by supporting and consulting with business and IT partners on recommendations and/or mitigation strategies; manage and report on remediation efforts.
• Created Use Case diagrams, Swimlane diagrams, Scenarios and Use Case narratives using UML methodology and MS Visio.
• Created Technical Design documentation for the data models, data flow control process.
• Managed the strategy and vision of the Enterprise Data Management to support the Data Governance program.
• Involved in all mapping documents from source to target, maintaining field names to comply with internal database administrators, data owners, data governance.
• Used SQL programming and developed Stored Procedures, Triggers, Functions, Packages using SQL.
• Used ETL transformations to copy columns and load data from data sources to the destination databases.
• Performed Data profiling, Data mining, Data cleansing.
• Developed and executed SQL queries against data warehouses to support data mapping and ad-hoc analysis.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Troubleshoot IAM issues related to the tool configuration or the data itself.
• Participated in the discussions of roadmaps and participated in the standards process for Identity Access Management (IAM) solutions.
• Performed UAT testing on all scenarios including acceptance criteria before handling over to the stakeholders for their sign-off.
• Extensively utilized HP ALM to create business requirements and solution requirements and created traceability matrix from HP ALM.
• Was involved in Functional System Testing, Integration Testing, Regression Testing, and User Acceptance Test using the test cases given by the client before releasing the application.
• Created reports using SQL and MS Excel Pivot Tables and Vlookups.
• Facilitated communications between customers, SME's and Technical staff.

Confidential, Mt Laurel, NJ

Business Data Analyst

Responsibilities:

• Analyzed client’s business requirements and processes through document analysis, interviews, workshops and workflow analysis.
• Organized JAD sessions with business managers, application owners and developers. Designed the strategies to overcome potential obstinacy which could result from limited scope of the applications involved and its impact on the intertwined business processes workflows.
• Led agile business requirements gathering sessions with stakeholders and users.
• Used JIRA for updating epics, user stories, and acceptance criteria. As well as track the projects updates.
• Participated Sprint Planning, Story Refinement, Sprint Demo, Sprint Review, Sprint Retro.
• Created the Business Requirements Document (BRD), Functional Specifications document (FSD) and Use Case Specifications.
• Conducted GAP analysis for process improvement between the As-Is and the To-Be risk assessment processes.
• Participated in identifying opportunities and parameters forBusiness process improvements.
• Work with the project teams on implementing the defined business Roles within the Identity Access Management.
• Analysis on Decommissioning existing business roles from legacy systems like ITSM/ TIRA and onboarding them to SailPoint.
• Set up meetings with different technical teams such as SailPoint team, Provisioning services team to understand and document the current state process in the bank.
• Configured, analyzed, and maintained IAM tool ensuring high efficiency and effectiveness of the tool.
• Gathered requirements for ServiceNow Identity Access Management business requirements from key business and technology stakeholders.
• Elicited high level IAM Business Requirements from key business and technology stakeholders.
• Worked with the IAM team to develop IAM Roadmap and Release Plan by identifying gaps between the current and future state and identifying initiatives for proposed future state solutions not available in current systems.
• Service Catalog and Request Workflow Design and Configuration.
• Identify and document detailed current major IAM Service Gaps (Gap Analysis) or deficiencies for processes, products and tools.
• Worked with SME’s to develop Maturity Model for improving IAM maturity over time.
• Worked with the SME’s and key stakeholders to assess current and target state maturity for each IAM capability in the Framework.
• Created the assigning the actual SafeNet Remote Access Program and Permissions in Active Directory.
• Responsible for Active Directory Global Access Management.
• Responsible for assigning Users in Global Active Directory to requested SharePoint Sites.
• Provided Business and IT management with guidance on IT risk management matters, particularly on application and infrastructure security.
• Researched, developed, implemented, tested and reviewed an organization's information security to protect information and prevent unauthorized access.
• Provided security administration and knowledge of existing processes and procedures to support project work being completed by senior members of Information Security or IT. These projects could include adding new security technologies, upgrades and enhancements, or sun-setting of existing security technologies and processes.
• Created processes and procedures based on ITIL.
• Created deployment plans to implement ITIL tools, services, software and .
• Made sure correct field are captured during record creation.
• Worked with CI Data Owners and other stakeholders to ensure the quality of the CMDB data is maintained and all CIs are up-to-date.
• Worked on SAM assessment for implementation of SAM pro.
• Worked on designing/enhancing various modules of ServiceNow: Service Catalog, Incident, Problem, Change, Knowledge Articles, Asset, User Administration, CMDB, CI, and reporting utilizing ITIL process.
• Implemented new applications and modules on the ServiceNow platform.
• Process included all the way from procurement all the way to disposal of assets.
• Setting up SLA/SLO/OLA to measure service level and operational commitment.
• Run continual service improvement programs to improve service availability.
• Researched ITSM tools and services that makes a company run more effectively and efficiently.
• Provided analysis, documentation and reports in support of the IT Operations Management (ITOM) along with Problem Management.
• Worked on ITBM- Application Portfolio Management (APM).
• Worked on Hardware Asset management to implement process flow to manage assets in the system.
• Involved in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing and ETL testing.
• Based on business requirement, developed the Complex SQL queries with Joins, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Performeddata analysisanddata profilingusing complexSQL and PL/SQLon Oracle.
• Used SQL tools to run SQL queries and validate the data loaded into the target tables.
• Wrote complex queries involved multiple tables using T-SQL stored procedures and user defined functions.
• Maintained Requirement Traceability Matrix and Test Matrix.
• Created test cases and performed Integrated and System Testing using ALM.
• Responsible for final user-acceptance testing (UAT) and usability testing, planned the UAT testing, test plans, test cases and worked with the business users for UAT test execution in developing the documentation.
• Performed Functional testing, Regression testing, Integration testing and System testing.
• Reported bugs to the developers by using ALM/Quality Center.
• Worked with MS Office especially MS Excel to deploy report.

Confidential, Pasadena, CA

IAM Business Analyst/Business System Analyst

Responsibilities:

• Worked with the SME’s to develop Identity and Access Management (IAM) Program Framework.
• Responsible to elicit high level IAM Business Requirements from key business and technology stakeholders.
• Responsible to create Business Requirements Document (BRD).
• Created user stories, bugs, Task in Jira.
• Used JIRA for handling change requests (creating a ticket to sending for implementation). Used Confluence to document meeting minutes.
• Created Requirements Traceability Matrix (RTM) in MS Excel.
• Responsible for mapping requirements to IAM capabilities, SOX controls and PCI controls.
• Held interviews and workshops with key business and technology stakeholders to assess current state IAM tools
• Responsible for current IAM tools to Framework mapping.
• Identify and document detailed current major IAM Service Gaps (Gap Analysis) or deficiencies for processes, products and tools.
• Worked with SME’s to develop Maturity Model for improving IAM maturity over time.
• Worked with the SME’s and key stakeholders to assess current and target state maturity for each IAM capability in the Framework.
• Worked with SME’s to prepare knowledge transfer document for Trusted Third Party Assessment.
• Identified IAM functional areas in scope and involve in Trusted Third Party market analysis for IAM.
• Worked with the SME’s to define the future state of an IAM solution to adequately prepare for the build, test and implementation stages.
• Responsible to develop IAM term glossary.
• Worked with the IAM team to develop IAM Roadmap and Release Plan by identifying gaps between the current and future state and identifying initiatives for proposed future state solutions not available in current systems.
• Liaised with the audit, project management and business analyst teams to integrate Information Security Governance into the planning, development and execution of policy standards.
• Maintained the ETL environments by monitoring their performance to ensure functionality, integrity and security of the environments and compliance with BTS information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within BTS for resolution.
• Gathered requirements for ServiceNow Identity Access Management business requirements from key business and technology stakeholders.
• Worked on designing/enhancing various modules of ServiceNow: Service Catalog, Incident, Problem, Change, Knowledge Articles, Asset, User Administration, CMDB, CI, and reporting utilizing ITIL process.
• Implemented new applications and modules on the ServiceNow platform.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Responsible for writing Business Use Cases, Business Rules, logical analysis and change management of requirements.
• Worked with business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the golden records to the target MDM database.
• Developed documentation of complex business logic for internal business users by analyzing SQL queries and reporting solutions.
• Performed Data Analysis, Data profiling and Data validation by writing SQL queries.
• Performed Data Analysis, Data profiling and Data validation by writing SQL queries.
• Analyzed the business requirements and designed Conceptual and Logical Data models.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Generated Complx PL/SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, MS Excel and UNIX
• Prepared RTM (Requirement Traceability Matrix) and made sure that the no requirement is left untested.
• Designed the test plan and worked with the QA team to implement and monitor the entire QA process.
• Wrote test cases in ALM/Quality Center, derived from the Design documents and generated a Requirement Traceability Matrix (RTM) for testing purposes.
• Actively participated in the UAT transition, retested UAT defects and updated comments in ALM/Quality Center.

Confidential, Pittsburgh, PA

Business System Analyst

Responsibilities:

• Conducted project kick off meeting with team members to explain roles, responsibilities, deliverables, timelines, assignments and status reporting as well as setting expectations from various teams.
• Performed Requirement Gathering, Analysis & Management by actively discussing and exploring customer requirements and prepared theBusinessCase Document using MS Word.
• Conducted JAD sessions, GtheredBusinessrequirements and documented them.
• Utilized JIRA to manage the project's user stories, Rally to manage the Project Task.
• Prepared artifacts such as BRDs, FRDs, Use Cases & UML diagrams using MS Visio.
• Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model using Visio, to depict process flows and PowerPoint presentations.
• Prepared the future state as well as current state screen shots presentation slides in PowerPoint, AS IS/TO BE document prepared.
• Created user stories for business requirement and technical responses and upload them in JIRA of each project.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile, especially from the project management, requirements and architecture perspectives.
• Worked with the project teams on implementing the definedbusinessRoles within Access & Identity Management (AIM) solution.
• Executed and tracked security process related activities including User ID management.
• Managed operations within theIAMenvironment at the client, including application patching and upgrades and management.
• Worked the Compliance, related to KYC and AML procedures for understanding the current reporting requirements and documenting them.
• Worked on ETL transition for AML and risk and client management.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Performed Data Analysis, Data profiling and Data validation by writing SQL queries.
• Worked on business intelligence standardization and procedures used for development of various SSRS/Power BI dashboards.
• Designed, developed and maintained custom reports using SQL programming, SQL Server Reporting Services (SSRS), Power BI and other analytic/ programming tools as needed to support reporting and analytic needs.
• Wrote complex SQL queries to perform the backend testing against Oracle database.
• Set up and coordinated pre-Production and post-Production User Acceptance Testing with business users. Used Quality Centre for writing UAT test cases.
• Managed, updated and manipulated report with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Participated in User Acceptance Testing and bug-related reengineering efforts.
• Worked with keybusinessleaders, stakeholder and project teams to integrate their applications intoIAMsolution.