SUMMARY

• A multi - skilled IT professional with 8+ years’ progressive experience as a Database Developer, Business Systems Analyst, Data Analyst and Scrum Master.
• Proven ability to work with cross-functional teams in a wide spectrum of Banking, Information Technology and Investment Management domains.
• Hands on experience with Waterfall, Agile Scrum and Hybrid of Waterfall and Agile methodologies.
• Expert communicator, able to resolve conflicts and negotiate win-win outcomes. Deep understanding of logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
• Proven ability to lead team by example consistently hitting targets, implementing and improving best practices, providing leadership, guidance and training less experienced team members effectively to accomplish strategic goals and objectives.
• Experience in partnering with a diverse team located in multiple locations and time zones
• Conducted and documented Impact, SWOT, Cost benefit analysis, Root cause, Feasibility study, Risk and Data analysis.
• Extensive experience in working directly with the project’s business process to determine “as is” and “to be” process flows (GAP Analysis)
• Experience in creating technical roadmaps to develop and implement a complex technology system replacement in a phased approach.
• Maintained good quality of commitment with Business Users and Stakeholders while facilitating elicitation techniques such as JAD sessions, Brainstorming, Requirement workshops, Document Analysis and during reverse engineering.
• Took the ownership of maintaining and verifying use cases, test cases in Requirement Traceability Matrix (RTM).
• Extensive years of experience in Business process re-engineering, Business process improvements, Historical Dataset Analysis and creating Business Requirements documents (BRD), Technical Specification Documents (TSD), System Requirements Specifications (SRS), Use-Case Specification Documents, Test case and Deployment Documents
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams, and ER Diagrams.
• Extensive years of experience in creating wireframes, mockups, user interfaces using Balsamiq, Moqups and other UI design tools.
• Well versed with Data Analysis and Data Mining Methodologies which includes Logistic Regression, Decision Trees, Support Vector Machines, Classification etc.
• Extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
• Experience working in Three-Tier architecture, Ajax, Web Services (SOAP, REST), Client-Side Validation, and Server-Side Validation. Possess good knowledge on validation scripting like JavaScript, JQuery and Angular JS.
• Extensively involved in Hypothesis Testing, Smoke Testing, Functionality Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
• Proficient with and breaking-down of epics into User Stories (INVEST/3C) and handling the Requirements Churn.
• Very active in conducting innovative and fun based team building activities.

TECHNICAL SKILLS

Banking Domain: Risk Management, Credit Risk Management, CCAR/DFAST

Investment Management: Equities, Fixed Income, Derivatives, ETFs, Asset Allocation Funds, Money Market Funds and Bond Funds.

Methodologies: Waterfall, Scrum, Agile-Waterfall Hybrid

Languages: SQL, PLSQL, Java, J2EE, JSP, HTML5, CSS3, SASS, JavaScript, XML

Databases: Oracle 10g/11g/R12/12c, MySQL, SQL Server, PHPMyAdmin

Frameworks: Bootstrap, AngularJS, JavaScript, jQuery, Spring MVC, D3.js

Operating Systems: Windows XP/7/8/10, UNIX/Linux

QA Test Tools: HP Quality Center 9.0/ HP ALM 11.0, HP QTP, HP Loadrunner, HP UFT, Bugzilla

BI Tools: SAS DI Studio, SAS Web Report Studio, SAS BI Dashboard, SAS Visual Analytics, SAS Enterprise Miner, Tableau, Cognos

Version Control: PVCS, GitHub, TFS

Data Modelling Tools: ERwin, SAP PowerDesigner, Microsoft Visio

Project Management Tools: Rally, JIRA, HP/Kintana PPM

Tools:, Text Editors, IDEs Toad, NetBeans, Moqups, balsamiq, Microsoft Azure ML Studio Notepad++, Eclipse, Microsoft Azure ML Studio

PROFESSIONAL EXPERIENCE

Business Systems Analyst/Data Analyst

Confidential, Chandler, AZ

Environment: Agile-Waterfall Hybrid methodology, Oracle 12c, SQL Server 2012, SAS DI Studio, SAS Enterprise Miner, SAS Web Report Studio, SAS Visual Analytics, HTML5, CSS3, JavaScript, Rally, Microsoft Office Suite 2013, GitHub, HP UFT, HP QTP, MS SharePoint 2013, SAP PowerDesigner 16.5

Responsibilities:

• Elicited demands from the stakeholders and analyzed them for consistency, completeness and flexibility.
• Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
• Communicated effectively across company contacts and clients, internal team about the project requirements, schedules and launches.
• Developed ad-hoc reports and monthly Key Performance Indicator (KPI) monitoring reports in multiple formats such as HTML, PDF, or RTF for customer analysis and reporting with different dimensions including product, area, distribution channel, states, and branch.
• Analyzed portfolio trends for risks and opportunities relative to credit, collateral, and operational efficiencies.
• Reviewed for the Risk DataMart (RDM) data dictionary for completeness and accuracy.
• Involved in extracting, analyzing, and interpreting data using SQL and applied statistical techniques.
• Hands on experience in using SQL and SAS to extract data, merge, concatenate, clean, and prepared large datasets from multiple data sources.
• Developedrequest for proposals (RFPs) and proofing the content of such RFPs.
• Identified trends in complex datasets, reviewed data reports and key data elements to identify coding issues.
• Well versed with Data Mining Methodologies which includes Logistic Regression, Decision Trees, Support Vector Machines, Classification etc.
• Used Data Mining techniques as part of data preparation to remove outliers, maintain consistent, valid and relevant data, data transformation, data sampling.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Developed, maintained, scheduled & monitored ETL jobs.
• Extensive experience in working directly with the project’s business process to determine “as is” and “to be” process flows (GAP Analysis)
• Experience in creating technical roadmaps to develop and implement a complex technology system replacement in a phased approach.
• Used SAS web report studio to create different types of reports such as summary detail, drill up/ down, with features such as report linking, different sections, filters, prompts and conditional highlighting etc. Made sure the web reports are appropriate in accordance with CCAR’s standards with high level transparency.
• Worked extensively on process re-engineering, automation, reverse engineering and overall streamlining of reports resulting in efficiency and conversion to self-service mode
• Mentored junior resources, trained in SQL, SAS etc. Lead process efficiency initiatives to help increase the productivity of the business.
• Provided requisite information in support of independent and internal audit activities.
• Used Rally for issue tracking, user story management and requirement traceability.
• Assisted with Hypothesis Testing, User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place.

Business Systems Analyst/Scrum Master

Confidential, Monterey Park, CA

Environment: Scrum methodology, Oracle 10g, Oracle 12c, Toad, Oracle Golden Gate, R12 Oracle e-business Suite, Oracle Data Integrator, CA Erwin 9.2, Tableau 8.3, Microsoft Office Suite 2013, JIRA, HP ALM

Responsibilities:

• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions, performing document analysis and looking at knowledge repository.
• Understood problem definition through one-one meetings with Data architect, Enterprise architect, Solution advisors.
• Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Developedrequest for proposals (RFPs) and proofing the content of such RFPs.
• Assessed business priorities, and advised business units by performing Risk Analysis.
• Incorporated Scrum Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective.
• Helped in estimation and prioritization of the user stories using Relative Mass Evaluation and MOSCOW Techniques.
• As Scrum master tracked team velocity and Sprint progress using Sprint Burn Down Chart and Product Burn Down Chart, conducted time boxed daily scrum meeting. Supported the scrum development team by resolving impediments.
• Used CA ERwin for Process modeling, Process mapping, Data Mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO-BE system concepts and also prepared the System Process Maps.
• Created Data Mapping template and assisted in creating Data modeling.
• Developed Conceptual and Logical Data Models. Created Data Dictionary for the data models.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Handled Requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the Triple Constraints and discussing them in Daily Scrum
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Created PLSQL packages to develop batch jobs in order to process the data, concatenate the data.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
• Established Incident Reporting and Change Control procedures.
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Business Systems Analyst/Scrum Master

Confidential, Madison, WI

Environment: SCRUM Methodology, Balsamiq, MS Office, MS Visio, Star UML, HP Loadrunner, HTML, JavaScript, CSS, XML, C#, Web Services, SOA, XML, ASP.NET 4.5.1, IIS, MS SQL Server 2012, Visual Studio 2013, TFS, SharePoint 2010

Responsibilities:

• Helped the Product Owner to prioritize the Product Backlog Items (PBI’s) for developing Sprint Tasks by taking suggestions from the cross-functional development team.
• Used prioritizing techniques like MoSCoW, KANO Model for prioritizing the user stories in the product backlog at Backlog Refinement Meeting.
• Created and maintained Sprint Burn-down Chart and Product Burn-Down Chart to keep the track of the team’s progress and the team’s Velocity for better estimation of the sprint life cycle.
• Extensive experience in writing user stories by breaking down EPICS into smaller User Stories using INVEST principle with the help of product owner and cross functional team.
• Used user story splitting patterns such as Workflow Steps, Simple/Complex and Defer Performance.
• Estimated user stories by using Estimation Techniques like Planning Poker and T-shirt sizing.
• Designed, developed and delivered responsive design pages using HTML5, SASS/CSS, jQuery, ATG and Bootstrap frameworks, along with their testing and release
• Provided rich UI/UX and client side validations using jQuery
• Planned the UAT Testing, Test Plans, and Test Cases and worked with the business users for UAT test execution.
• Supported the Product Owner and Business Users while performing User Acceptance Testing to make sure that all the requirements are developed correctly.
• Assisted in developing Test Plans, manual and automatic Test Scripts using Load Runner for Regression Testing, Performance Testing and Stress Testing.
• Executed SQL queries to extract application data to perform application validations.
• Performed Risk Management in the project by maintaining a risk register to identify and mitigate risks in the project development process.

Business Analyst/Scrum Master

Confidential, Owings Mills, MD

Environment: Scrum - waterfall Hybrid, MS office Suite, MS Visio, Star UML, AJAX, JAVA EE 6, Oracle 10g, JIRA, Informatica v9x, Cognos, Eclipse, Hibernate, Spring, HTML, CSS, JavaScript, Web Services, SOAP, XML, HP ALM

Responsibilities:

• Decomposed the scope from the BRD into user stories by conducting a story writing session with the Product owner and then the acceptance criteria for the PSPI (Potentially Shippable Product Increment)
• Designed and implemented Portfolio Supervisory System, including trend analysis, forecasting returns and interfaces for risk management and financial analysts implementing the Agile methodology.
• Developed good knowledge of Equities, Fixed Income, Stock Funds, Target Date Funds, Asset Allocation Funds, Money Market Funds and Bond Funds.
• Understanding of Software Localization and incorporated the localization polices for enhancing existing system.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing and logged down defects.
• Assisted in Designing data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support.
• Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
• Planned and organized team engagement activities to encourage self-organization among the team.
• Proven record of Team Management and Leadership skills.

Business Systems Analyst

Confidential

Environment: Waterfall, MS SCOM, SCSM, MS Office 2007, SQL Server 2005, MS Visio, MS Project, SharePoint 2007, HP QC

Responsibilities:

• Ensured healthy rhythm of business is in place by conducting regular Delivery reviews with the customer, along with the Program & Delivery Managers.
• Understand and coordinate client’s needs / enhancements, customization of the product accordingly and consult with technical team and other teams involved in projects to provide solutions in adherence to delivery schedules.
• Research and document data requirements, data collection and administration policy, data access rules and security
• Operated database management systems to analyze data and perform data mining analysis.
• Keep the team abreast of company’s goals and client’s expectations or changes. Identified reporting associate training needs and advised on training sessions.
• Onsite-Offshore team coordination, task allocation, status updates
• Reviewed Project plans, Project cases, Major Project triage
• Assisted Project Manager in creating Risk management plan creation - identification, monitoring, mitigation
• Made sure there is Continuous Process Improvement, Defect Prevention and Quality Control
• Maintained the Quality as per Microsoft’s Standard Process Compliance.
• Conducted project lessons learnt, meetings and used results to continuously improve project development processes
• Ensured project goals are met in post-production. Managed change management and relations with key stakeholders.
• Took ownership of UAT, Go-Lives and support transition end-end. Follow escalation mechanism as per the SLA

Business Systems Analyst

Confidential

Environment: Waterfall, MS Office 2007, Track IT, Informatica Power Center, Kintana PPM, Dollar Universe, Teradata, PVCS, Oracle 9i, HP QC, Cisco Webex

Responsibilities:

• Understanding existing business model and customer requirements through KBA’s, Project artifacts, JAD sessions.
• Understanding the Business elements which need to be measured.
• Listing out all the corresponding Data elements that are associated with the each of these Business elements.
• Converting the Business requirements into Business Rules and Data Rules.
• Assisted the team in designing the Informatica mappings to generate the DQR SQLs dynamically, which can be executed on the corresponding Data Sources.
• Generating the Data measures as per the Business requirements and communicating the same to the Business in case the same exceeds the Thresholds. Scheduling the sessions for loading the data at regular intervals.
• Contributed to Peer reviewing the deliverables by the team members.
• And also to play an active role in preparing Test Plans and actively participating in testing.

Oracle Apps Technical Consultant

Confidential

Environment: Waterfall, Toad, Oracle 9i, Oracle e-business Suite, BPEL, PVCS, HP QC, Kintana PPM, Notepad++, Webex

Responsibilities:

• Reviewed business requirement documents and prepared table dependency, package dependency details as part of Technical Specification Document.
• Attended daily walk through sessions during requirements gathering, created minutes of meeting (MOM) and shared across the team.
• Possess hands on experience with all the phases of Software Development Life cycle.
• Developed packages, procedures, functions, triggers in PLSQL as part of Oracle PIM module under MDM platform.
• Involved in a team of 5 members responsible for code enhancements, code optimization and bug-fixing of the existing code, which helped in achieving 100% test case results during the code performance test.
• Prepared test scenarios for Unit Testing, to run the automated test scripts in HP QTP and generated reports.
• Hands on knowledge on black box and white box testing. Good knowledge on SQA methodologies and techniques.
• Conducted necessary smoke, regression, end to end and UAT on the application after deployment.