PROFESSIONAL SUMMARY

• Over 12.5 years(7 years leading teams) of result oriented work demonstrating key skills in diversified roles as a Senior Business Analyst, Quality Analyst Lead, Technical Analyst(Data/Systems Analyst) across large Fortune organizations.
• 6.5 years of lead BA & QA experience on Business Intelligence solutions, Data Warehousing, ETL (informatica and ab - initio) Reporting (Qlikview, Tableau, Cognos, BO) projects and Client/Server applications.
• Expertise on domains including Property & Causality (P&C), Life, Bank, Mutual Funds (MF), Health, Client, Customer Care Network (CCN), State Farm Payment Plan (SFPP), Electronic Claim Services (ECS), Bank Credit Card, LMS, Agency Analytics.
• Worked on all SDLC phases including Analysis, Requirement Gathering, Design, Development, Testing, and Implementation using Agile-SCRUM and Waterfall Model.
• Expertise in AGILE Methodologies, AGILE Manifesto and Scrum processes by dividing the application into iterations and facilitated user stories workshop, story Point discussions to analyze the level of effort on project specifications.
• Expertise in requirements elicitation, requirements analysis, requirements specification, requirements validation. Works with business units, internal stakeholders and system units.
• Very efficient in developing business requirements) and functional requirements. Very efficient in using process flows, screen mock-ups, gap analysis.
• Experience working and leading business process analysis with senior level management. Lead and facilitate requirements gathering sessions with business for application delivery.
• Expertise in source-target and meta data documents
• Strong experience with Business Process Modeling and Notation(BPMN). Heavily engaged creating workflows using BPMN
• Skilled at validating the business processes and defining solutions requirement.
• Expertise in Data Modeling, Data Analysis, Data Profiling, Logical and Physical Modeling.
• Proficient in GAP Analysis, Requirement Analysis, Business Modeling, Data Migration, Data profiling, and Dimensional Modeling.
• Conducted Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
• Led initiatives to identify technology requirements and work with vendors to build solution or platform recommendations.
• Applied JIRA and Rally tools to deliver value with more iterations and greater velocity. Handling project management activities for model execution work streams that run in parallel to ongoing system development activities.
• Validating the business processes and define solutions requirement. Defining customer Service processes, metrics and reporting requirements
• Facilitated workshops extensively for requirements analysis, key role in management training sessions.
• Strong technical writing skills in creating knowledge management documents and other artifacts.
• Expertise in different types of testing on like GUI, Integration, Functional, Regression, System testing, UAT.
• Knowledgeable in Web-based and large Client-Server/Multi-tier applications (using SOAP UI & REST).
• Excellent customer facing skills and able to handle multiple competing priorities in a fast-paced environment with strict deadlines.
• Skilled in working across organizational boundaries, proven experience in dealing with ambiguity, and organizational agility. Ability to look beyond reported problem to identify potential impacts.
• Motivated problem solver with strong analytical skills & capable and knowledgeable team member with excellent written and Verbal communication skill

TECHNICAL SKILLS

DOMAINS: Auto, Health, Life, Bank, Mutual Funds, Client, Claims, ECS, Big Data Analytics, Analytics Dashboards, Sales Force, Hadoop, Infrastructure, Associate Register

BUSINESS ANALYST/MODELING/PM TOOLS: MS Project, Microsoft Office Applications -Visio, Excel, Word, Access Database, MS SharePoint 2010/2013, Office 365, UML, Rational Rose, RequisitePro, Cisco Spark, WebEx, Jira, Rally, Skype for Business.

TESTING TOOLS: Test Link, Trac, Selenium, Quality Center/Application Lifecycle Management (ALM), JIRA, SOAPUI, REST, Rational Lifecycle Tool, Rational RequisitePro, Rational Test Manager, HP Quality Center, Rational ClearCase, HP ALM, Rational Clear Quest, Rational Functional Tester, Rational Manual Tester, IBM Optim, Toad, HP Service Manager, Control M 10.1, 11.0; Selenium, QTP, LoadRunner

DATABASES: Teradata, Oracle, Hive, IBM DB2, Technical Platform Database (TP) postgres tables, Optim, TOAD, MS Access, SQL, PL/SQL

OPERATING SYSTEMS & TOOLS: Windows, UNIX/AIX, Linux (Putty & SSH Client)

ETL & REPORTING TOOLS: Informatica, Ab Initio, Qlikview, Qliksense, Business Objects, Tableau, Cognos, SAS

OTHERS: IBM Doors, Lotus Notes, Primavera, Guidewire insurance suite (Policy Center, Billing Center. Claim Center), Clear Case, Ultraedit

PROFESSIONAL EXPERIENCE

Confidential, Riverwoods

Agile Coach/Scrum Master

Responsibilities:

• Works with product owner, business Users and application team during requirements gathering.
• Perform detailed functional and technical analysis of requirements and client’s existing applications.
• Validating code for new modules and enhancements; System customizations and enhancements.
• Prepare system testing & UAT test plan documents and perform testing of developed modules
• Validate shell scripts for batch process and scheduling batch jobs.
• Data profiling, data modeling and data analysis.
• Prepare source to target, meta data, physical and logical model document
• Validating metadata graphs from legacy source system to target database fields and involved in testing Ab Initio DMLs.
• Optimizing SQL queries, developing workflow logic for all the applications.
• Prepare detailed design documents and architecture for new modules and enhancements.
• Extensively worked on ETL tool Ab Initio and Hadoop (scoop, Hive)
• Analyze impacts and risks for the application before enhancements and planning a soft launch process for smooth transition.
• Perform code review, test cases, code coverage and results.
• Work with client to improve performance of the system and deploying applications in their environment.
• Deploy the application in production and installing tools across environments like development, quality and production.
• Validating Ab Initio parallel and serial flow batch graphs, conditional components, other components like Transform, Read and Write Multiple files, Partition graphs.

Tools: Windows OS, Microsoft Office, Oracle 9i/10g, Ab Initio GDE 3.2, Co Operating System 3.2, EME 3.2, Maestro, Express It, SQL, Unix shell script, Teradata, Hadoop (HDFS, HBASE, Hive)

Confidential, Bloomington

Responsibilities:

• Interview, investigate, and elicit requirements from a variety of stakeholders, including technical, operations, and business process owners and Subject Matter Experts.Define and document business processes and projects.
• Facilitating discussions, decision making while guiding the teams and organization to remove impediments by identifyingthe rightpersonnel-leading by example.
• Documents and analyzes requirements from a business perspective; defines current and future operational scenarios (processes, models, use cases, plans and solutions) and works with client and the IT Architects to ensure proper translation of business requirements to IT solution requirements.
• Supports business unit(s) in a functional capacity in all phases of the Project Life Cycle, including post-production support and ongoing maintenance.
• Created Product Backlog, Sprint Backlog and managed User story dependencies.
• Participated in requirement analysis by gathering both functional and non-functional requirements via user interviews and JAD sessions with the process owners, stakeholders and document analysis
• Developed Process (DFD) and Data (ER) models for the as-is and to-be systems
• Review User Business requirements, identify gaps and establish peer reviews
• Extensively used agile methodology’s best practices during the SDLC. As a sprint team member participating in Epic/Story workshops, estimations, building automation backlogs, planning, stand ups etc.
• Works with stakeholders from all business units and related third parties to define and document business processes and software requirements for technology initiatives, including online products, content management systems.
• Creates detailed documentation of functional, system (non-functional), user and reporting requirements: use cases, logical models, process flow diagrams, data mapping and flow diagrams.
• Analyzed, elicited business requirements and ETL Mappings from Source to target tables for enhancements on different applications (LOBs) by conducting meetings, interviews, prototyping and Brainstorming sessions with stakeholders, SME, developers and product owners.
• Worked with DBA in setting up the test environment, loading with data from multiple sources.
• Involved in full life cycle testing including GUI, integration, UAT, Regression test on new builds of the application

Confidential

Lead Business Analyst

Responsibilities:

• Expertise in analysing & validating Business Requirements, Functional Requirements, Non-Functional Requirements, Technical Requirements, Data Requirements documents for delivery.
• Prepare use cases and technical specifications for application changes, reports, and other custom coding projects. Assisted in creating test plans and performing testing to ensure reports and enhancements meet desired workflows.
• Created Use cases diagram, Activity diagram, and other flow charts to define the business process.
• Review User Business requirements, identify gaps and establish peer reviews.
• Developed UML Use Cases for the application using Rational Rose and prepared the detailed Work flow diagram based on the proposed enhancement for the system
• Completed Business Modeling process, complete UML artifacts related to Business Modeling and Requirements, including MS Visio and Rational Rose
• Work proactively across the organization to identify data sources, data users, and data processes
• Builds working relationships with application vendors. Coordinates status meetings and produces progress reports.
• Extensively interacted with both user group and development team in coming up with structured charts, Class and sequence diagrams
• Performed Data Analysis and developed Data Mapping documents. Analysed requirements for data migration.
• Involved in End-to-End system testing predominantly UAT and coordinated with members of business and systems.

Confidential

Scrum Master

Responsibilities:

• Created Complex use case scenarios, which requires Finance/Bank domain knowledge.
• Extensively used agile methodology’s best practices during the SDLC. As a sprint team member participating in Epic/Story workshops, estimations, building automation backlogs, planning, stand ups.
• Create Business Process Model and Notation (BPMN) compliant diagrams for all “As-Is” and “To-Be” process maps.
• Prepared test data for all types of testing and key participation in UAT.
• Worked successfully eliciting and documenting data terms, definitions, and standards.
• Mitigated the poor understanding of effective delivery processes and brought together individualsfrom various functional silos to create a cross-functional team, significantly reducing communication delays.
• Identified, researched, investigated, analysed, defined and documented business processes for Equities, Fixed Income, Bonds, and Derivatives
• Created workflows for entire process using BPMN.
• Worked on Claim processing module which involved Receipt and Verification of Claim Forms, Claims Enquiry and Response, Adjudication, Claim Payment/Advice.
• Defined the reconciliation process - process bank statements and perform reconciliation accounting transactions and generate appropriate reports
• Analyzed, elicited functional and technical requirements on ETL Mappings from Source to target tables for enhancements on different applications (LOBs) by conducting meetings, interviews, prototyping and Brainstorming sessions with stakeholders, SME, developers and product owners.
• Capture and document both functional and non-functional requirements, process models and business rules from multiple sources.
• Manage change controls, adhere to customer level SLA's and maintain solution requirements.
• Worked with Business Intelligence SME, for solutions on all data needs.
• Created Business Process Model and Notation (BPMN) compliant diagrams for all “As-Is” and “To-Be” process maps.
• Define, develop, and manage artifacts (such as workflows, use cases, user stories, busness rules, etc.) for the team to consume during product development and Project Delivery. Support/manage any system/application upgrades.
• Analyzed & validated business requirements & ETL Mappings from Source to target tables for enhancements on different applications (LOBs) by conducting meetings, interviews, prototyping and Brainstorming sessions with stakeholders, SME, developers and product owners.
• Extensively used agile methodology’s best practices during the SDLC. Worked in a tightly integrated product suite in a fast-paced, highly collaborative, Agile /Scrum development environment.
• Major Job responsibilities as a test lead includes creation of Test Strategy, Test Plan, SUT, Test Cases, Test Logs, Test Results, Test Coverage Matrix, Evidence of Test (EOT), Test Summary Report; setting up test environment including data capture; executing and validating Test Cases; routing Validation Approval Package (VAP).
• Pairing up with developers/product owners to understand complex test cases. Tested Full load & Incremental load as a part of End-End testing & UAT testing.
• Compared data in FDW1.0 with data in FDW2.0 (before and after changes) for different applications. Wrote complex SQL Queries to check/validate data.
• Validated various reports using Cognos, Tableau, Business Objects, Qlikview reports and dashboards based on business requirements.
• Defects were tracked, reviewed and analyzed using TRAC- Defect management tool and reported daily to the project team.

Confidential

Senior-Technical Analyst

Responsibilities:

• Elicited requirements and translated into detailed functional requirements.
• Successful in generating and implementing ideas for improvement (e.g. integrity checks, maintenance processes, metadata, services)
• Analyzed Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Derivatives, Trade Life Cycle, OTC Derivatives, Portfolio Management, Wealth Management and Sales and Marketing
• Creates documentation of business processes, and provide input to future state training procedures, and standard operating procedures
• Creates detailed documentation of functional, system (non-functional), user and reporting requirements: use cases, logical models, process flow diagrams, data mapping and flow diagrams.
• Interacted with front office traders, prime services operations and investment m teams to understand requirements.
• Familiarized with the business processes and operations of the front office, middle office and back office of Hedge Funds & analyzed the strategies of this multi-currency, multiple securities fund.
• Responsible for planning and facilitating the participation of resources and stakeholders in implementing, maintaining and improving systems in support of business needs.
• Ensured that the reconciliation of the funds positions/securities to outside sources were correct.
• Analyzing Data Processing implementing Data Mart applications mainly transformation processes using ETL tool and understanding of ETL workflows and ETL mappings and also monitoring the Production Environment
• Identified and thoroughly analyzed defects, issues, risks, and action items.

Confidential, Chicago

Senior ETL test Analyst

Responsibilities:

• Developed test cases based on business requirements, functional, technical specifications, and development standards. Test cases included test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Extensively used agile methodology’s best practices during the SDLC. Conducted every day scrum meetings with project team to improve the efficiency and productivity of each sprint.
• Implemented accounting strings to identify ETL and other high priority jobs.
• Validated application load jobs to use recoverable load (ingest, import) commands instead of the load command.
• Test lead- providing end-to- end test deliverables.
• Developed SQL queries for Source to Target Mapping & Back-end testing/Database testing .
• Ensured Error logs and audit tables are generated and populated properly.
• Validated tableau, Cognos & Qlikview reports based on Functional Requirements.

Environment: RUP, Rational Requisite Pro, Rational XDE, Rational Rose, Rational ClearQuest, Base Clear case, Java, Oracle, DB2, MS Project, MS office suite

Confidential, Rhode land, NJ

Sr. Technical Analyst

Responsibilities:

• Understanding the Requirements\FDs\EDs\Test Scenarios. Involved in Script Reviews.
• Test Environment preparation (Perform Environment Smoke Test with new Builds)
• Test Case Preparation & Peer Review. Update the scripts with the enhancement documents. Developing test scripts using TSL.
• Reporting the Defects using the Quality Centre, follow-up on the defect status for closure. Documenting the Defects using Quality Centre.
• Represented all of the functional and non-functional requirements in the requirements traceability matrix (RTM) using Requisite Pro.
• Assessed the flaws in the existing as-is accounting system and made clear recommendations of Business process improvements and BPR, incorporated them in the future to-be system design.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Organized triage and cross functional meetings to discuss the priorities of defects logged and delivery time.
• Actively involved in the UML based Class, Communication and activity Diagrams for certain modules of the application in collaboration with Design Team.

Environment: RUP, Rational Requisite Pro, Rational XDE, Rational Rose, Rational ClearQuest, Base Clear case, Java, Oracle, DB2, MS Project, MS office suite.