SUMMARY

• IT professional with 8+ years of experience working in Cyber - security, Insurance and E-commerce, Specialized in Business & Systems Analysis, Quality Assurance, Requirements management, user acceptance testing, Change Management, Reporting, SQL, Data Management, Data Quality, Data Governance, Metadata.
• Worked as a Developer, Business Analyst, Business Systems Analyst and Scrum Master Roles with proven ability in leading cross functional and self - organizing teams with expertise in various phases of Software development life cycle methodologies such as Waterfall, Spiral, Agile framework Scrum, Kanban, Extreme programming and Hybrid Model - Waterfall Agile.
• Strong in documenting nonfunctional requirements using QUEST framework.
• Very strong in authoring Data Governance policies, procedures, templates.
• Supported metadata, data quality rules and metrics processes.
• Helped business in decision making by providing SWOT Analysis, Root cause analysis, Cost- Benefit Analysis and AS-IS To-Be business analysis.
• Proficient in networking with individuals at various levels while organizing, conducting and facilitating requirement elicitation sessions such as survey/questionnaires, interviews, brainstorming, focus group, requirement workshops, document analysis and JAD sessions.
• Used Tableau to create innovative executive dashboards, scorecards and weekly/ monthly reports on the status of key business measurements.
• As a Scrum Master, facilitated and time-boxed the scrum ceremonies such as: Daily Stand-up meeting, Backlog refinement, Sprint planning, Sprint Review, Retrospectives meetings including Grooming sessions.
• Proficient in estimation techniques like Planning Poker, T-shirt sizing, Dot Voting and Relative mass evaluation.
• Experienced in conducting Scrum Training Workshops and User Story Writing workshops to familiarize stakeholders with Scrum process.
• Well versed in writing User Stories and breaking down Epics into user stories satisfying INVEST criteria.
• Worked closely with Product Owner in prioritizing user stories using techniques like Moscow, Kano and Business Value based methods.
• Facilitated discussion, decision making and conflict resolution.
• Knowledge on Agile techniques featuring User Stories, Continuous Integration, Pair Programming.
• Guided the team to remove impediments by finding the right personnel to remove the blocker.
• As a Scrum Master coached my cross functional team on agile principles/Scrum principles and made sure the team is following them. Collaborated with both off shore and on-shore team members.
• Experience in recording and maintaining the artifacts like Product Backlog, Impediments list, sprint burn down charts and sprint burn up charts to track my team’s performance and keeping it visible to the team members and owners.
• Well versed in documenting and reviewing the Business Requirements Document (BRD), Software Requirements Specification (SRS) and Functional Specification Document (FSD).
• High experience in tracing requirements throughout the development process and verifying to Requirement Traceability Matrix (RTM).
• Expertise in Graphic User Interface Design (GUI), wireframes and UI mock-ups using Balsamiq.
• Worked with QA team to design Test Plans and Test cases for User Acceptance Testing (UAT) using HP QC/ HP ALM.
• Ability to write effective SQL queries in SQL Server, Sybase, Oracle and DB2 databases using tools like SQL programmer and mySQL.
• Experience with the ETL on Informatica Power Center.
• Experience Setting up interview sessions with various stakeholders in gathering the requirements.
• Implementing effective change management in the organization using the ADKAR Principles.
• Experience with IT Risk management (Cyber-security) capabilities such as GRC Reporting-Supplier & Buyer, Compliance, Crisis Management & Disaster Recovery management.
• Strong cyber security capabilities to support Risk Management in Insurance and & e-commerce domains with skills like Vulnerability Management using i2 qRadar and Qualys reports, SOC functions using the Splunk and Qualys. Vulnerability Scanning using Symantec reports and Spotfire.
• Knowledge in Attack and Penetration activities using Kali Linux and capabilities like MSEXPLOIT (Penetration testing), HYDRA (Brute force), Pass Hash, Hash Cat, PY scripting to run brute force attacks.

TECHNICAL SKILLS

Operating Systems: Windows XP/10/Kali Linux

Modeling Tools: MS Visio, Mock-Up Screens, Rational Rose

SDLC Methodologies: Waterfall, Waterfall Scrum Hybrid, Scrum, Agile-Scrum, Agile

Business Skills: Process Modeling, Change Management, GAP Analysis, Impact Analysis, SWOTAnalysis, JAD Sessions, Project Scheduling, Project Budgeting

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/ Drill Down, Pivot

Project Management Tools: MS Project, MS SharePoint Server

Risk Management tools: SIEM Qradar, Qualys, Sourcefire, Splunk, Symantec reports, Hydra

Requirement Management: JIRA, Rally, HP ALM, MS Office, Confluence, ClearQuest

Testing Tools: HPQC, Selenium

Reporting/BI Tools: Tableau Desktop, IBM Cognos, Tibco, SAP Logon, Spotfire

ETL Tools: Informatica

Methodology Tools: JIRA, HP ALM, RALLY

Databases: MsSQL, Oracle, MS Access

Finance Tools: Thompson Reuters, Experian, Bloomberg B-Pipe, MorningStar

Languages: HTML, XML, SQL.

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis, MN

Sr. Business Systems Analyst/ Scrum Master

Responsibilities:

• Documented underwriting processes and analyzed procedures to see that they would meet regulations from the Department of Insurance
• Assessed the impact of current business processes on users and stakeholders.
• Conducted interviews with key business users to collect information on business processes and user requirements.
• Collected the Business requirements and Functional requirements in the BRD and FRD.
• Utilized my SQL skills to perform queries to analyze issues during QA
• Assisted in documenting the release notes.
• Created interactive dashboards to visualize the reports and identify critical issues that needed attention.
• Utilized tableau dashboards to create Premium forecasting dashboards, claimant correlation, Fraud Analysis and SLA dashboards to help assurers expedite their risk analysis.
• Assisted the developers to create unit tests, test cases to ensure 100% test coverage of the code.
• Facilitated and time-boxed Scrum ceremonies like Sprint Planning, Daily Scrum, Sprint Review and Retrospective meetings.
• Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming meetings.
• Reviewed Sprint Burn down and Release Burn Down Charts to maintain team’s velocity.
• Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which features met the definition of Done, DoD using the acceptance criteria.
• Helped resolved team and organizational level impediments.
• At the end of each sprint conducted Sprint Retrospective meetings such as Sad Mad Glad techniques so each stakeholder can freely express their opinions and suggest improvement measures.
• Helped the Product Owner to Prioritize the Product Backlog items using MOSCOW technique for developing Sprint tasks by taking suggestions from team.
• Used JIRA for drafting user stories, allotting tasks, backlog management, issue tracking, user story maps and generating reports.
• Maintained the Task Board that was referred to during the daily stand-ups that helped the team track the stories To Do, Work in Progress, Done and Accepted.

Environment: SQL SharePoint, AWS EC2, AWS Red Shift, AWS DynamoDB, AWS Kinesis -Fire Hose, Selenium, Rally, IBM i2 qRadar, i2 SNA, IBM i2 Analyze, Jenkins, Tableau.

Confidential - Columbus, OH

IT Risk Management Specialist (Cyber Security)

Responsibilities:

• Conducted data leak prevention (DLP), ensuring company sensitive and critical information did not leave the network.
• Monitored IT defense perimeter and scanning infrastructure, taking or recommending appropriate action per set procedures when.
• Reported incidents to appropriate Tier 2 or Tier 3 teams to determine any increased risk to the company and/or its clients.
• Processed intelligence reports through analysis of intelligence reports and briefings from various sources and documented indicators of compromise (IOCs) in company database.
• Responsible for handling the Intelligence and Email Operations for the SOC while maintaining proficiency of adversary tactics, techniques, and procedures (TTPs) through analysis of email headers, malware analysis and open source intelligence.
• Familiar with multiple information security tools such as; SIEM Qradar, Intrusion Detections and Preventions Systems (Sourcefire), Malware Analysis (Hydra Threat Analyzer, VirusTotal), email analysis in Rshield and Sureview, intelligence analysis (CRITs), proxy searches (Putty).
• Produce and maintain project documents (timelines, requirements, project documentation) ensuring they are complete, current, and stored appropriately
• Supported the issue resolution in the existing cyber data acquisition process.
• Interacted with diverse technical and non-technical groups, spanning multiple functional areas -Cyber Analytics, Incident Responders, Communications Teams, Security Engineering, Security Operations, Infrastructure Stakeholders, Business Management, etc.)
• Effectively communicated relevant project information to management team, business leads and stakeholders across the organization including detailed technical and operational level communications as well as project status, risks, issues, decisions.
• Effectively communicated and work with technology partners

Environment: Kali Linux- msexploit, Hydra, Password hash, Hash Cat, IDQ, Splunk, tableau, qRadar, Qualys Reporting, Symantec, Rshield, Virtual Total, Source Fire, CRITs, Putty, Sureview.

Confidential - Estero, FL

Sr. Business Analyst

Responsibilities:

• Utilized my communication skills to conduct JAD sessions, Interviews, Brain Storming and other elicitation techniques to collect requirements for the project
• Documented the requirements using the BRD and the SRS
• Created project plans in accordance with project management framework standards and procedures.
• Identified ongoing issues and gaps within project plans, in order to eliminate implementation issues.
• Acted as a liaison between the SME’s and the stakeholders to assess the Risk, process reviews and policy reviews to elicit the requirements precisely
• Assisted in creating the UML diagrams and interactive mock ups for development team to understand the requirements in an orderly manner
• Assisted the development team to perform UAT testing and updated status in the SharePoint.
• Consistently tracked the project status and reported it to all the stake holders involved.
• Enhanced business data visualization for the weekly Directors' presentations
• Interpret custom data into easily understandable reports for clients
• Revised business performance metrics in collaboration with IT, which increased transparency on sales key factors
• Responsible for leading testing efforts, ensuring that issues are identified, tracked, reported on and resolved in a timely manner

Environment: Waterfall, Balsamiq, SharePoint, SQL Server, MS Office Suite, JIRA, Rally, HP QC, Tableau.

Confidential - Brenham, TX

Business Systems Analyst

Responsibilities:

• Project followed Agile methodology for Guidewire Claim Center Integration in different sprints.
• Facilitating daily Scrum meetings, Sprint review meetings and Sprint retrospective meetings, assisting Scrum Master in developing during Sprint Meetings.
• Managed RTM to ensure test cases are traceable to requirement specifications.
• Gathering business requirements, converting them into functional requirements and authored the same in making User Stories for New Claim Module.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
• Translated business user concepts and ideas into comprehensive business requirements and design documents.
• Created project plans in accordance with project management framework standards and procedures.
• Identified ongoing issues and gaps within project plans, in order to eliminate implementation issues.
• Created and maintained User Stories by interviewing the SMEs, Claim Specialists, Claim Adjusters, Field Investigators etc. to capture the process flow from First Notice of Loss (FNOL) to Claim-case closure, to communicate the requirements to development and testing teams.
• Worked closely with the business users, Stakeholders and SME's to identify, document and analyze the business process that was currently being followed to improve the time efficiency of the processes.
• Reviewed and assisted the design team in coming up with UI Screen Mockups and Wireframes for the proposed new UI prototype.
• Performed Risk Analysis on implementing the AI for SNA and Fraud Analytics

Environment: Agile methodology, Microsoft Suite, SQL, HP ALM, SAP Power designer, Oracle DB

Confidential

Informatica Powercenter Developer / Informatica Data quality

Responsibilities:

• Responsible for gathering requirement of the project by directly interacting with client and made analysis accordingly.
• Helped in building the New ETL Design.
• Defined various facts and Dimensions in the data mart including Fact Less Facts, Aggregate and Summary facts.
• Extracting, Scrubbing and Transforming data from Main Frame Files, Oracle, SQL Server, DB2, Teradata and then loading into Oracle database using Informatica, SSIS
• Worked on optimizing the ETL procedures in Informatica.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Implementing logical and physical data modeling with STAR and SNOWFLAKE techniques using Erwin in Data warehouse as well as in Data Mart.
• Used Type 1 and Type 2 mappings to update Slowly Changing Dimension Tables.
• Involved in the performance tuning process by identifying and optimizing source, target and mapping and session bottlenecks.
• Configured incremental aggregator transformation functions to improve the performance of data loading.
• Worked Database level tuning, SQL Query tuning for the Data warehouse and OLTP Databases.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Informatica Data Quality (IDQ 8.6.1) is used here for data quality measurement.
• Used Active batch scheduling tool for scheduling jobs.

Environment: Informatica Power Center, IDQ, SSIS, SSRS, Team Foundation Server, Teradata, Share Point, Oracle, TOAD, Erwin 7.0, Unix, SQL Server, Autosys, Windows.

Confidential

Junior ETL Developer

Responsibilities:

• Obtained business requirements from business users and stakeholders using JAD sessions, brain storming sessions, focus groups and personal interviews
• Established financial forecasts for the given project by using already made scope of the system.
• Developed use case model using MS Visio. Created a development plan for the overall project and prototypes.
• Gathered and documented requirements for creating bureau reports and bureau reporting mart (ISO, Mass Auto, DMV)
• Performed in depth data analysis identifying data issues in legacy system and worked with business to develop resolutions to those issues.
• Created business requirements document and functional requirements document after gathering both functional and non-functional requirements as well as user stories.
• Actively involved in data warehouse and mart design sessions for both Logical and Physical design
• Communicated logic for the parsing of data to ETL team.
• Created data mapping documents for the movement of data from production databases to the warehouse and from the warehouse to the policy and claims marts.
• Defined logic for Extraction, Transformation and Loading of data into Warehouse and Marts.
• Worked closely with offshore development team.

Environment: MS SQL Server 2005, Cognos, Rational ClearQuest, Microsoft SharePoint, MS Visio, RTM, Erwin, MS Word/Power Point.