Resume

Sign in

Data Sql Server

Location:
Little Rock, Arkansas, 72207, United States
Posted:
February 15, 2018

Contact this candidate

Resume:

SUMMARY

IT Professional with *+ years of hands-on experience within the financial services and banking industry in the domains such as Risk Management, trading, Portfolio management, anti-money laundering, order management system and Retail Banking.

Served as a Business Analyst, Business Systems Analyst and Scrum Master roles; and proven ability leading cross-functional and self-organizing teams in various business settings.

Extensive experience in Software Development Life Cycle (SDLC) from inception to disposition with different methodologies such as Waterfall, Agile methodologies like Scrum, Waterfall-Scrum (hybrid).

Well versed in authoring Business Requirements Document (BRD), Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case, Business case and Data mapping document.

Proficient in balancing business and functional requirements to be in line with operations and technical feasibility and translate requirements into system concepts.

Extremely skilled as Scrum Master in facilitating scrum process and events to improve team’s performance and handling team dynamics. Proficient in writing User Stories and managing Requirements Churn in Scrum efficient in performing, prioritizing tasks effectively leveraging analyzing techniques like Planning poker, MoSCoW, T-shirt sizing.

Expertise in eliciting & gathering Business requirements, Business Process Re-engineering (BPR), Business Process Modelling (BPM) and Data Analysis.

Experience in gathering SMART requirements and translating them into functional specifications.

Expertise in tracing requirements throughout the development process and verifying their adherence to Requirement Traceability Matrix (RTM).

Expertise in Release Management, Scope Management, Steady-state transition and ITIL/ITSM best practices (Incident Management, Problem Management, Change Management) and industry standards.

Experienced with extensive client interactions and converting business functionalities to Service Oriented Architecture (SOA) models across IT environment. Also worked in Three-tier architecture, Web Services (SOAP, WSDL), Client-side and Server-side validations. Proficient in XML technologies like XML, DTD, XSL, XSLT, SOAP, and WSDL.

Experience in applying business analysis tools like GAP Analysis, SWOT, PESTEL, Impact Analysis, Root-case identification, Cost-Benefit analysis, Feasibility study, Risk Analysis.

Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA/ HP QC and collaborated with system users to conduct UAT.

Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau and IBM Cognos for decision making.

Proficient in extracting/generating reports using SQL Server/SSRS/Google Analytics; can construct complex queries for data extraction and formulate meaningful insights and conclusion from the same.

Worthy understanding of concepts like Data warehousing, data mapping, data mining, ETL processes, data modelling.

Experience in managing projects using exceptionally strong organizational, analytical, leadership, problem solving, decision making and Project Management skills.

Highly collaborative team player with extensive customer relationship skills, also possess excellent facilitation and mentoring skills and ability to prioritize tasks according to business needs.

ACCREDITATIONS

Education

Master in Business Administration (Finance & Marketing)-JNTU– Hyderabad, India.

Certifications

Certified Scrum Master

TECHNICAL SKILL SET

Project Management Tools/Methodology

Object Oriented Analysis and Design. (OOAD) using Unified Modeling Language (UML), MS-Project, MS SharePoint, BPMN, Rally, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, Smartsheet.

Requirement Management

MS Office, JIRA, VersionOne, RALLY, Confluence, HP ALM 11.5, Team Foundation Server (TFS ) and Rational Rose

Reporting Tools

SSRS, Tableau, Informatica, MS office Suite,

Databases

MS-Access, MySQL, SQL Server 2005/2008/2012, Oracle 9i/10g,IBM DB2

Office Tools

MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

Analytics Tools

MS Excel, MS Access, Google Analytics, Tableau, Oracle Business Analytics, Hyperion

Testing Tools

HP Service Center, HP QC, HP ALM 11.5 and Bugzillla

ETL Tools

Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI)

Languages

HTML, XML, Visual Basic 6.0, C#. NET, C, PL/SQL, T-SQL, ASP, Java, ASP.NET, ADO.NET,SQL, CICS, Visual Studio 2015

Scripting and Markup

HTML, HTML5, DTD, XML Schema.

Monitoring Tools

Microsoft Network Monitor, Wireshark, HP Sitecope

Domain

Finance, Banking, Portfolio Management, Risk Management, Anti-Money Laundering, Trading Services

PROFESSIONAL EXPERIENCE

Client: Wells Fargo, Charlotte, NC

Role: Sr. Business Systems Analyst/Scrum master Feb 2016- Present

Description: The scope of the project is to consolidate and manage the sale and purchase of the fixed income securities from various market venues by efficiently implementing master data management in the order management system by efficiently involving data migration and data mapping processes.

Responsibilities:

Interacted with stakeholders, Systems Architect, UI/Content Management Team, Developers, SME and diverse group of personnel and facilitated JAD sessions to understand the business process, gather Business Requirements and identify changes for the applications and implemented in Waterfall-Agile methodology.

Worked closely with IT and data migration team to prepare and execute the the data migration plan

Identified the fields for data mapping and validated the cleansed data.

Worked with the UI team to create Wireframes to be presented to the Business unit.

Conducted GAP Analysis to understand limitations of the existing system and contributed to functional design of future system, modelled the AS-IS and TO-BE business workflow.

Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.

Prepared Software Requirement Specifications (SRS), Functional Specification Document (FSD), converted functional and non-functional requirements into user stories for Agile-Scrum development framework.

Prepared graphical depictions of Use Cases, Use Case Diagrams, State, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, creation of technical design (UI screen) using Microsoft Visio.

As a Scrum Master, facilitated scrum events including Daily Stand-up meeting, Backlog refinement, Sprint planning, Sprint review and Sprint retrospection meetings.

Written User Stories and managed Agile Lifecycle in Team Foundation Server (TFS) and JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress. Assisted in managing the Product Backlog, Sprint Backlog, Sprint Burn down and Release burn down charts,

Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting.

Removed internal and external impediments that hinder team’s productivity. Worked with the team in the grooming and prioritization of product backlog using technique such as planning poker.

Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.

Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.

Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems.

Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.

Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Managed other BAs and sent their status to Project Manager/Business owners on a weekly and monthly basis using MS Project. Worked on project planning, scheduling and status reporting.

Instructed and modeled core agile principles of collaboration, prioritization, team accountability and visibility. Ensured consistent application of scrum methodologies across the team.

Environment: Hybrid Waterfall-Scrum Methodology, EDM, Informatica MDM, Tableau, API’s/Web Services, JIRA 6.3.3, Visio, SOAP, SOA, SharePoint, XML, XSD Schema, Eclipse 3.1, MS Office, HP ALM, Mock-up screens.

Client: CitiFinancial Group, TX

Role: Business Systems Analyst/Scrum master Aug 2014 – Jan 2016

Description: The scope of the system is to provide an improved Anti Money Laundering system and methodology for a financial institution that provides dynamic, contextually driven compliance action analyses, guidance and recommendations considering the risk dimensions of the financial transaction.

Responsibilities:

Conducted GAP Analysis to understand limitations of the existing system and contributed to functional design of future system; assisted in modeling the AS-IS and TO-BE business workflow.

Worked with business and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.

Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.

Analyzed Legal & Compliance Systems (LCS) to define new compliance rules for the proposed system.

Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively used MS Visio for UML.

Used various estimation tools, planning poker, MoSCoW, T-shirt sizing.

Highly proficient in facilitating product owner to prioritize user stories in Product Back Log.

Encouraged and implemented process improvements techniques and ensured that there was room for change. Introduced a checklist during story time to ask the right questions while reviewing each story.

Constructed Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off.

Was in regular contact with Business partners on the status of issues, action plans and timeframe for conflict resolution throughout the development cycle.

Designed and reviewed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and White box testing with the help of QA teams.

Helped Testers expedite the defect resolution by following up on the defects raised in Quality

Generated key statistics e.g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.

Used IBM Cognos to generate internal reports to study and analyze the current business performance.

Environment: Agile/ Scrum Methodology, HP ALM, SharePoint, Ms Office, VersionOne, Oracle 10g, Java, HTML, CSS and JavaScripts, SQL, Web Services, MS SQL Server, Eclipse 3.1, CICS, CVS, Hibernate.

Client: WellCare, Tampa, FL

Role: Sr. Business System Analyst Apr 2013 - Jan 2014

Description: The scope of the system is to perfrom data migration from from legacy financial systems to a comprehensive ERP system which is integrated across various state departments. The project scope was to do a data migration from legacy system.

Responsibilities:

Involved in Business process re-engineering design including requirement refinement through Business process re-engineering sessions and conference room pilots to produce functional and design documents.

Involved throughout the System Development Life Cycle (SDLC) of Waterfall methodology.

Worked with legal team staff to explain how to cleanse their data

Worked closely with IT and data migration team to prepare data mapping and execute the migration process, validated cleansed data, and create tickets for IT to fix bugs or enhance the migration tool

Understand conversion issues as well as practical issues faced in the implementation of a new case management system

Identify, research and resolve conversion issues

Compare data with original source system and validate data accuracy

Identified and analyzed business needs using techniques such as JAD, Document Analysis, Interface Analysis, Requirements Workshops and Interviews with SMEs and stakeholders.

Prepared Software Requirement Specifications (SRS) and Functional Specification Document (FSD)

Created Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams and Class Diagrams.

Performed data analysis using SQL queries and MS Excel Pivot Tables to understand current complaint metrics and provided the information to the business users during the JAD sessions as inputs.

Assisted in Data modelling, Data Mapping, Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.

Constructed Requirements Traceability Matrix to determine the source of the requirement, ensured all requirements are met and locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off.

Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.

Generated reports using SQL scripts to analyze the existing production data and plan for data migration.

Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data modelling, Data Validation and Data Integrity testing.

Coordinated with development team to define the batch flow for data validation process.

Involved in Functional Testing, Integration Testing and User Acceptance Testing (UAT) with the QA team.

Environment: Waterfall model, MS Project, HP Quality Centre, XML, MS office Tools (Word, Excel, PowerPoint, SharePoint and Visio), SQL Loader, Oracle 10g, Oracle Hyperion, Oracle’s Business Intelligence, Oracle Governance Risk and Compliance, Hyperion, PeopleSoft, SQL

Client: Walgreen Corporate Office, Deer field IL

Role: Business Systems Analyst July 2012- Mar 2013

Description: The scope of the portfolio mangement system is to support portfolio managers in their strategic decisions, considering the dynamic and complex nature of the market and risk attributes by utilizing the wide variety of tools that covers a wide variety of functions to get the most recent data

Responsibilities:

Reviewed business requirement documents and mapping documents to analyse, understand the requirements, mapping logics to create and establish project and implementation plans.

Facilitated JAD sessions with SMEs’, Product owner, and Development managers to understand the business process, had extensive meetings with both RBS and Santander to gather requirements.

Analytically evaluate information obtained from multiple sources (source files, data warehouse etc) reconcile conflicts, classifying the information in logical categories for identifying data gaps.

Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule.

Performed complex SQL queries to validate back end transactions and ETL process

Interacted with various cross functional teams on building business use cases, understanding the process flow and sequence activity.

Understood the business process and decision models, involved in compiling the Vision Document and composing detailed Use Case Specification Documents.

Created a master repository of business terms to associate and bring all businesses functions together for target system.

Created Data mapping documents via conducting though ETL analysis of data, to determine/ensure data quality and integrity.

Assisted in Data modelling, Data Mapping, Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.

Worked on a Metadata Repository project which is vertically dealing with all businesses units in the organization

Constructed and maintained Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system.

Performed reporting on customer data from data warehouse in MSBI

Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.

Environment: Scrum, Wireframes, MS Office (MS Word, MS Excel, MS PowerPoint), SharePoint, MS Visio, UML, VersionOne, MSBI (SSIS, SSRS, SSAS), Web Services, SOA, SOAP, HP ALM, JAVA, JavaScript, XML, HTML.

Client: Bank of the West, San Francisco, CA.

Role: Business Analyst Dec 2011- Jun 2012

Description: The scope of this project was to enhance existing internal Credit Risk Management system to enable organization to make best risk enabled decision by expanding system capacity to incorporate real-time data to have precise risk analysis and governance in the process.

Responsibilities:

Identified and analyzed business needs using techniques such as JAD, Document Analysis, Interface Analysis, Requirements Workshops and Interviews with SMEs and stakeholders.

Prepared Software Requirement Specifications (SRS) and Functional Specification Document (FSD)

Created Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams and Class Diagrams.

Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.

Used various modeling techniques like data modeling, data flow diagrams, and UML diagrams for designing and developing the application.

Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.

Worked with business and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.

Developed complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.

Wrote SQL queries to retrieve the data and for data manipulation and integration, created complex SQL queries, such as joins, pivot tables, cubes and sub queries.

Developed and optimizing SQL queries using SQL Server profiler, indexed views and indexes

Created Extraction, Transformation and load(ETL) packages to manage the data integrity, and data manipulation

Generated key statistics e.g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.

Performed Change Management by handling change requests and performing change impact analysis on business and technical side, and getting the approval from the Change Control Board (CCB), to make the appropriate changes.

Created project plans, work breakdown structures (WBS) and identified & managed risks using MS Project.

Designed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and White box testing with the help of QA teams.

Environment: Waterfall Methodology, HP Quality Center, Informatica, SharePoint, IBM Cognos, ETL, Java/J2EE, JSP, Apache TOMCAT, Web Services, MySQL, Eclipse, Unix, WebLogic Application Server, Spring, Hibernate.

Client: Phore Technologies, India

Role: Business Analyst May 2010- Nov 2011

Description: Enhancements and Maintenance of New Account Opening application. Central Database (CDB) is the backend for Smith Barney (SB) account opening system. As a result of the Joint Venture between Centurion Bank & HDFC Bank, the above 2 systems needs to be integrated to create one standard source for the new account opening process and The scope of the system is to implement a risk controlled investment strategy that matches the specific investors and traders by running a set of compatibility algorithms that compares the trading tendancies of the investor and the trader, thereby allowing the investor to choose and implement a risk management strategy.

Responsibilities:

Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.

Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents.

Prepared Functional Specification Documentation (FSD) and communicated the same to the stakeholders.

Analyze Risks, documented Risk Logs and created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE” system

Developed complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.

Wrote SQL queries to retrieve the data and for data manipulation and integration, created complex SQL queries, such as joins, pivot tables, cubes and sub queries.

Developed and optimizing SQL queries using SQL Server profiler, indexed views and indexes.

Assisted in Data modelling, Data Mapping, Data Mining, Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.

Working closely with users for datamining and provide critical data for banks day to day and monthly use

Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.

Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.

Worked with business and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.

Generated key statistics e.g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.

Managed SQL Server environments, by configuring a facet in one instance of SQL Server, copy the state of the facet to a file, and then import that file into another instance of SQL Server as a policy.

Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.

Designed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and White box testing with the help of QA teams.

Encouraged and implemented process improvements techniques and ensure that there was room for change. Introduced a checklist during story time to ask the right questions while reviewing each story.

Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively used Rational Rose and MS Visio for UML.

Constructed Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off.

Preparing End of schedule report and carrying out minutes of meeting with the team. (Both offshore and onsite).

Involved in application enhancement in terms of Improved security, Error logging, Exception Handling and Code Reuse.

Designed and developed Use Cases, Activity Diagrams, Business case, and Sequence Diagrams, using UML and Visio according to business rules.

Proficient in System Test Plans, Integrated Test Plans (ITP), Extensive experience in User Acceptance Testing (UAT).

Environment: Waterfall Methodology, XHTML, CSS & JavaScript, HP Quality Center, Java/J2EE, JSP, Apache TOMCAT, Web Services, MySQL, Eclipse, Unix, WebLogic Application Server, Spring, Hibernate, .NET 3.0, ASP.NET, Ms Office, Visual Studio 2005/2008, LINQ, HTML, CSS, SQL Server 2005/2008, C#. Net, Team Foundation Server (TFS), Ajax Control Toolkit, Visual Source Safe.



Contact this candidate