VISWANADH “VIS” KANURI DALLAS, TX

ac24bc@r.postjobfree.com PH: 912-***-****(C)

PROFESSIONAL SUMMARY:

Results driven, client focused professional with Ten plus years of experience in business and data analysis with progressive experience in analysis, design, reporting, implementation, testing and maintenance of applications.

Seasoned professional, with outstanding project planning, execution, monitoring and resource planning skills with the ability to support multiple simultaneous projects in a matrix organizational structure.

Working knowledge of Market Risk, Credit Risk, Finance (Auto, Mortgage), Healthcare, Telecom projects.

Hands on expertise with database marketing, risk and credit criteria, segmentation and targeting, MDM (Meta Data Management), loan servicing methodologies, data governance, identity management, active directory and web analytics.

Strong expertise in SAS, SQL, SSIS, Excel, VBA, PL/SQL, AS/400. Proficiency with complex joins and sub-queries; Experience working with very large datasets Working knowledge of Business Objects, Crystal, Bloomberg, Cognos, DataStage and Abinitio.

Worked with Teradata, Vertica, Oracle, SQL Server, Netezza and DB2

Expertise in MS Visio, MS Project and automated tools like Rational Clear Case, Rational Clear Quest, Rational Robot, Rational Rose, Requisite Pro and Data Modeling experience using Erwin.

Worked on Data Mapping projects (Source-to-Target mapping) for system requirements and recommending data model changes. Hands on experience with Project and Product Management activities.

Facilitation of joint application development (JAD) sessions, written correspondence, reports, implementation requirements, project status reports, oral presentations and formal walkthrough’s.

Extensive knowledge of Object Oriented Analysis and Design using Rational Unified Process (RUP) and UML Methodologies.

Strong work experience on Agile methodologies using VersionOne, Rally and Jira, waterfall methodologies

Software Development Life Cycle (SDLC) experience including analysis, design and review of business and software requirement specifications.

Hands on with coordinating and collaborating with multiple teams, providing trouble shooting support and prioritizing and tracking enhancements. Managing team members in US and offshore

Extensive experience in gathering Business and System requirements, documenting detailed business processes, creating traceability matrix(RTM), identifying risks and impact analysis.

Expertise in Process Re-design

Thorough knowledge of Quality Assurance, User Acceptance Testing and writing Operational specifications.

Excellent analytical and problem solving skills, with effective communication and leadership skills.

EDUCATION

08/2004 - 12/2005: Master of Science, Mathematics and Computer Science – Georgia Southern University, Statesboro, GA. GPA 3.7/4.0;

09/2000 - 06/2004: Bachelor of Science, Computer Science and Information Technology - Jawaharlal Nehru Technological University, Hyderabad, India. GPA 3.3/4.0;

Research: Image compression model using wavelets.

TECHNICAL PAPERS

Qualitative Properties of General First Order Matrix Difference Systems (Published in

the International Journal of Non-Linear studies).

Solution of Kronecker product initial value problems associated with first order difference system via tensor based hardness of the shortest vector problem (Published in Science Direct – Applied Mathematics).

Multi-homing based solution to provide integrated (loss and delay) service differentiation in a multi-layered wireless sensor networks (Published in Globe Com 2004 Journal).

PROFESSIONAL EXPERIENCE

E-Commerce Data Analyst/Product Owner, AT&T/TEK Systems

Richardson, TX 06/16 – Present

Working for the Premier (Premier Online Care and Premier Online Bill) team as a reporting analyst and product owner.

Managing all Premier reporting using Adobe Analytics, Business Objects and SQL

Generate daily, weekly and monthly reports against Oracle, Teradata, Vertica and Netezza databases depending on the requirement

Worked as the lead product owner from the business side on the Adobe Analytics migration project from Web Trends by identifying all critical and non-critical URLs and mapping the Event codes, Flow codes, Friendly Page names and other key attributes.

Worked with Adobe development team on the Adobe data layer migration project to ensure the Premier Care pages are on the same production data layer as the other cross functional teams

Worked on creating a monthly Premier Login Report that provides how many unique customers are using Premier for performing digital transactions online like updating a device, changing rate plans and/or features, transfer of billing responsibility etc., by Role, FAN and BAN.

Provide insights based on the login report to see a trend of how many users are using the online services month over month and year over year.

Working with the Ecommerce Associate Director and Director to improve the customer base for Premier online care site usage.

Working with other product owners to identify Adobe requirements and make sure the changes for the project are incorporated for Adobe reporting

Worked on modifying the Upgrade Eligibility report that authorized end users can request by removing existing CTN input limits, adding FAN level request and improve the turn-around time from 48 hours to less than 24 hours

Provide monthly financial report updates to the director on budget spent for the Premier Wireless customer reporting project

Also created other critical reports that keep track of order gateway status, automation status etc.

Worked as business analyst/product owner on few projects including FirstNet, ADDP - BYO MDM (ATT Device Deployment Profile - Bring your own Mobile Data Management)

Created joint requirements document, user stories, vision documents and walk them through with concerned audience and get all questions/concerns addressed ahead of time.

Worked with UX information architects to create wireframes that depict what the changes are being made to the existing pages and how the future state will look like post production

Conducting need and gap analysis and provide technical expertise in identifying, evaluating and developing systems and procedures that are cost effective and meet user requirements.

Manage daily scrum meetings including stand-ups, sprint and release planning sessions, retrospectives, demos, and other project meetings (planning and issue resolution) as required.

Business Analyst/Data Mapper, Frontier Telecom

Richardson, TX 07/15 – 06/16

Worked for Frontier Telecommunications as a Data Mapper in the Customer Care, Accounts & Billing (CC&B) team.

Responsible for modeling and mapping data fields from the source systems (Verizon) to the target’s (Frontier) existing systems

Working with the legacy teams and the business in helping define and develop business rules, value maps, source to target data mapping documents

Worked on various shifts during the mock data transmissions and validated sources that I am responsible for, as well as making sure other mappers are validating their source systems and report the status to a command center.

Actively worked with external vendors, EDI and Globys to test the paper and online statement customers to ensure the right customers are set the way they are currently receiving the bills from VZ, post conversion.

Worked with internal and external vendor teams to manage requirements and wrote the minutes of the meeting and publishing the minutes to the conversion team for visibility. Updated and got approvals on the requirements based on the meetings.

Worked on the accounts mapping spec for CABS (CARRIER ACCESS BILLING SYSTEM) EAST to map the data from this system to Frontier’s DPI system.

Worked on the Equal Access spec (for all sources) to identify on the DPI billing system (after conversion) what customers will be able to/forced to choose between the local and long distance carriers based on specific functionalities.

Maintain traceability matrix across the project life-cycle, created source to target maps, tracking requirements status, data profiling, managing changes to requirements and versions of requirement

Assisting ETL (Informatica and RPG) teams with development activities.

Created and maintained multiple value maps that contain default values approved by the business which should be applied during DPI conversion and merge.

Created the BRT (Business Requirements Document) for Equal Access customers which includes the description of the document, customer impact, business process flow, criteria and assumptions, the source and target fields, etc. Used a SharePoint repository to store all documents and keep them up-to date for audit tracking purposes.

Worked extensively on AS/400 green screen to support DPI Billing System.

Worked on HP ALM and Remedy to work on defects and resolved them based on Severity/Priority.

Got approvals from the business managers, Technical Architect, Development Leads, Program Lead and project managers

Also worked on the critical and high priority defects for the major VZ source systems (CBSS and VI5).

Identify what is missing from the source systems and work with the business to default those values based on some conditions.

Analyze the defects and close the defects with in the target date, working with the System Testing and UAT teams to understand and resolve critical defects.

Sr. Business Analyst, AT&T/Amdocs Inc

Richardson, TX 02/14 – 06/15

Managing requirements and development efforts for data migration from legacy systems (Teradata, SQL Server) to newer data systems in Vertica (Big Data) and Teradata. Data involves customer information, price plans, billing information, porting history, UVerse, Mobility, Wireless home phones and data from other acquisition sources.

Managing scope, requirements and development efforts for the new Tax and Revenue regulation reports that display journalized tax data, overall revenue, customer contracts, Equipment data Identifying and removing/preventing impediments. Improving transparency on team progress through velocity reporting, burn down charts, and sprint progress

Conducting need and gap analysis and provides technical expertise in identifying, evaluating and developing systems and procedures that are cost effective and meet user requirements.

Manage daily scrum meetings including stand-ups, sprint and release planning sessions, retrospectives, demos, and other project meetings (planning and issue resolution) as required.

Coordination of overall deployment activities of middleware applications and backend database updates for Mobility, U-Verse Subscriber Contract projects.

Developed SQL queries to analyze data while comparing source files to Teradata landing zone records.

Working with leadership team to maintain the backlog and update status using Rally and JIRA

Documenting the Service Level Agreement for fixing various source data issues, which involved interfacing with Sr. Directors, Delivery Managers, Technical Architects and business partners while gathering business data and analyzing the results to improve the quality of Service Management reporting.

Gather Business requirements and create functional specifications document (FSD) and Non-functional specification documents (NFSD) for ongoing projects.

Translate the requirements into Business (Functional) and System (Technical) requirements and review with the customer to get their approval. Writing complex SQL queries to analyze and understand data.

Sr Agile Business Analyst, NationStar Mortgage,

Lewisville, TX 07/13 – 02/14

Working with the internal business users of NationStar Mortgage to develop a new automated tool for audit tracking and monitoring purpose

Working with leadership team to maintain the backlog and update team status using VersionOne agile process management tool.

Meet with other internal business analysts on a regular basis for facilitating JAD sessions, gather status reports, resolve pending issues and ensure deadlines are met as proposed

Identifying and removing/preventing impediments. Improving transparency on team progress through velocity reporting, burn down charts, and sprint progress

Manage all of the data ingestions for various sources including Bank of America, Kinects FCU, Fannie Mae, ARS, Wells Fargo and many more.

Worked on an identity management project to build a new internal repository/tool that approves different access levels based on the role and department.

Drafting the Request for Proposal and Statement of Work for having an offshore team on board for design work.

Provide weekly/monthly reporting to Sr. management on SOW (Statement of Work) spent

Conduct need and gap analysis and provides technical expertise in identifying, evaluating and developing systems and procedures that are cost effective and meet user requirements.

Assist with prioritization and resolution of defects/bugs. Proactive reporting of risks, blockers, and team progress.

Coached cross functional teams in effective use of the adoption of agile principles and practices

Wrote Unix Korn shell scripts to automate the upload process for some standard source files. Some of the scripts include renaming multiple files in multiple folders using pattern matching later used for ingestions, updating a string text within the files with specific extensions

Worked on ingesting data for all existing and new accounts into the reconciliation tool.

Analyze and resolve any issues like file load issues, incomplete data etc., that occur during the ingestion process and performing data quality checks on completed loads.

Using Kofax Administration tool to specify input samples for splitting huge invoices.

Using Kofax Batch Manager to schedule batch jobs related to server recognition, PDF generator and exporting the converted files for ingesting data into the database.

Create reports from SAS and SSAS for audit and data analysis use.

Manage project deliverables, milestones, and required tasks, adhering to business-critical timelines

Run queries against various databases including SQL Server, Oracle

Using functionalities of the Rendition Engine in IBM FileNet P8 to transform data into various formats for storage

Using DataCap tool to process invoices from vendors and converting the files for data ingestion

Sr. DW Business Systems Analyst/Product Owner, Capital One Auto Finance

Plano TX 03/13 – 07/13

Worked for the Capital One Auto Loans Business Intelligence team as a Product Owner cum Sr. Business Systems Analyst for the Auto Finance Data warehouse team.

Worked with the internal business users to gather business requirements that require data warehousing and operational data store related work.

Worked with the Auto Data warehouse and Operational Reporting Environment teams to develop presentation layers, data requirements, data mapping and data modeling

Involved in the full life cycle development of the data warehousing project including design, development, testing and Production support.

Created, documented and maintained logical and physical database models in compliance with enterprise standards and created corporate metadata definitions for enterprise data stores within a metadata repository.

Developed mapping spreadsheets for development (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetrics, and corporate meta-data definitions.

Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.

Used DataStage for extraction, transformation and loading (ETL) in the data warehouse. Extraction and loading through DataStage and transformation by scripting BTEQ.

Re-write complex queries from SQL-Server and Oracle to Teradata and performance tuning enhancement tasks and helped meet SLP

Performed extensive data modelling using Erwin to help create the lineage between the OLTP and Data Warehouse data models; Managed business requirements in VersionOne

Weekly/Bi-Weekly sessions with other BSA’s on for facilitating story grooming sessions, gathering status reports, resolve roadblocks and discuss lessons learned

Create Epics and vertical user stories, data mapping documents for new requirements and working towards completion before the sprints end.

Working with the Architecture team to resolve any issues and get sign off to go ahead with new data warehouse projects

Set up peer reviews to discuss on going projects and getting input on completed related projects.

Generate reports from SAS, Tableau, Business Objects (desktop and mobile reports), MircoStrategy or Crystal reports depending on the customer requirement.

Talked to bankruptcy business users to understand the documents sent to and from the bankruptcy courts and defining the process to translate and store them into data warehouse for reporting

Conduct Feasibility Analysis and Risk Analysis, while writing the business requirements document and walk through the success criteria with the business users to help them understand the risks associated.

Business Analyst, BlueCross BlueShield of TX,

Richardson, TX 05/12 – 03/13

Worked for the Health Care Services Corporation (Blue Cross Blue Shield of TX) as a Sr Business Analyst/Scrum Master in the Business Intelligence Data Warehouse team.

Worked as a proactive liaison among stakeholders to elicit, analyze, communicate and validate requirements for changes to business processes, policies for existing and new sources.

Worked on projects using Scrum and Kanban methodologies.

Created Epics and helped the team to create smaller user stories for all new requirements and working towards completion before the sprints end.

Provided analysis and efforts on a rating engine which is based on .NET and Java technologies in an SDLC environment for calculating new premiums based on actuarial algorithms.

Define and document business, user and system requirements using appropriate documentation techniques to describe statements of the goals and objectives of the internal stakeholders.

Made sure the user stories are good, comply with acceptance criteria, have sufficient business value and selling points

Guide the development teams to break down large and complex user stories

Maintain traceability matrix across the project life-cycle, created Source to Target maps, tracking requirements status, data profiling, managing changes to requirements and versions of requirement specifications, and tracing individual requirements to other project phases and work products.

Created source to target data mappings against Teradata and DB2 for all new vendors including Onlife, Healthways, HSSI and Evive.

Creating code set files and metadata for the vendor reference files to easily identify the pre-existing codes and reuse them across different vendors.

Created data flow diagrams in MS visio and the RACI chart for a new Healthcare pricing project.

Gather data from Global Information Systems to develop pricing models for health care reforms.

Working with leadership team to maintain the backlog and update team status using JIRA

Performed data profiling on the source data to visualize the table structures, joins and identify any data quality issues that can be eliminated when loading the data.

Provided estimates for project management and change management activities through analysis of requirements effort, resources, and technology.

Using Quality Center to manage defects and work with all teams to ensure resolution prior to UAT.

Teradata Business Systems Analyst, Capital One Home Loans

Plano, TX 02/10 – 04/12

Worked for the Capital One Home Loans BI team as a Sr. BA and managed 3 Junior Business Analysts.

Took charge in initiating the agile conversion with the ING integration and developed user stories, success criteria and rapid release cycle. Managed the daily stand-ups

Produced project status reports, profitability and cost management dashboards, managed the team and resolved day-to-day issues with emphasis on SDLC.

Worked with internal teams to gather requirements for creating reports in SAS, Business Object, Crystal reports or Cognos depending on the complexity of the report(s).

Gathered business and technical requirements for mobile reporting projects to enable business users to view the reports on mobile (Ipad and other android) devices.

Created and maintained logical and physical db models in compliance with enterprise standards and created corporate metadata definitions for enterprise data stores within a metadata repository.

Worked with the data architecture and IT governance teams to get approvals regarding the access restrictions for various departments (Mortgage, Auto, Bank and Card) to segregate and identify who can access what information. Worked on creating a portal for active directory using identity management for requesting access to Enterprise Data Warehouse.

Developed mapping spreadsheets for development team with source to target data mappings including physical naming standards, datatypes, volumetrics, and corporate meta-data definitions.

Ensure scheduled ETL jobs are not delayed (SLAs are not violated) and fix them in case of failures.

Worked on TD performance enhancement projects by identifying the potential set of columns based on the data demographics, collecting stats and changing the SQL to use Primary and Secondary indexes in queries and TD load scripts.

Initiated use case analysis, which provided the framework for potential use case deliverables and their inter-relationships, to assist in maximizing software reuse.

Performed data profiling on the source data to visualize the table structures, joins and identify any data quality issues that can be eliminated when loading the data.

Used Omniture sitecatalyst and SAS for understanding web conversion techniques and replicated the same concept in Business Objects.

Prepared RACI charts and traceability matrices for managing requirements.

Working with the data architect team to discuss and resolve any issues and get the go-ahead to make changes to the existing system

Developed BTEQ, FastExport and MultiLoad Teradata utility scripts to export and import data from different legacy source systems (Oracle, SQL Server, DB2) to Teradata target tables.

Working with the ODS team to develop data requirements, data mapping and data modeling and assisted the business users to define and refine the scope of the project.

Conduct feasibility analysis and risk analysis, while writing the business requirements document and walk through the success criteria with the business users to help them understand the risks associated.

Coordinated development and testing efforts with developers, quality assurance (QA) team. Specified business requirements to development team as code changes were required.

Work with the business users to develop the User Acceptance Test (UAT) case documents.

Market Risk Business and Data Analyst, Citigroup

New York, NY 01/09 – 02/10

Worked with cross functional teams including Risk Managers, Traders, Front Office Business Managers, Technology, Financial Control and other groups internally to gather data including issuer risk (JTD).

Performed daily data checks to ensure data quality and data integrity.

Produced daily and weekly market risk reports that monitor issuer risk (MTM) against single issuer market risk limits.

Automated the process to run the daily data integrity checks using MS Access and MS Excel and scheduling the report using the system scheduler to compare previous business day’s data to the current day’s.

Collaborated with Risk Management and technology teams to create a new repository using PL/SQL that integrates market risk and credit risk into a single report. This enables Risk Managers to look at the combined risk for a single issuer.

Worked with IT and Risk Management teams to change the current reporting process to enable Risk Managers to view a 10 day hierarchical data and the average exposure for any new issuer having risk over the market limit.

Provide information to Risk Managers, senior management and the business for audit, stress testing and ad-hoc related queries.

Verify and fix the indicative data (Security Ratings, Product type and Parent company names) using Bloomberg.

Raise, investigate and follow-up on issues related to data quality and limit excesses.

Performed gap analysis and prepared reports to identify applications and business processes that fell short of PCI standards

Established on-going processes to ensure that all new applications and procedures meet PCI standards.

Wrote Unix Korn shell scripts to automate upload process for some standard source files. Some of the scripts include renaming multiple files in multiple folders using pattern matching later used for ingestions, updating a string text within the files with specific extensions.

Analyze and resolve any issues like file load issues, incomplete data etc., that occur during the ingestion process and performing data quality checks on completed loads.

Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams.

Database Marketing Analyst, Citi Cards

Long Island City, NY 02/06 – 11/08

Worked as a consultant for the Balance Consolidation team under the Database Marketing group.

Supported cross functional teams with program planning and feasibility.

Continuously audit campaign and targeting process for quality and adherence to marketing specifications.

Managed and improved the forecasts of the department’s 24 million dollar budget.

Actively engaged with DM and offshore teams for developing a segmentation model which is expected to bring in about 100 Million Dollars in revenue for Citi Cards.

Worked with Accounts Receivables team to make sure code is setup to match the marketing offer posting process.

Ran reports using SAS and SQL to aid in program planning and to answer questions from marketing, risk and other cross functional groups. Used complex joins to pull out the critical card member information for extensive analysis.

Used Acxiom Encompass tool for web customer conversion and Mobile reporting.

Managed forecast data, track and process invoices using SAS, SQL and Excel, perform ad-hoc analysis using SAS datasets and SQL reports and make recommendations to Marketing, Risk and A/R teams.

Successfully completed the criteria simplification process to enhance the process flow and efficiency of the campaigns to minimize run time and complexity. Developed data flow/Sequence diagrams using MS Visio. Documented application design specs and business process. Also, developed solutions design, deployment strategies and support

Prepared workflow diagrams analyzed AS IS (Current state) and TO BE (Future state) scenarios, designed new process flows and documented the business process and various business scenarios.

Presenting high level data to senior management using MS PowerPoint.

Mentored and managed 4 data analysts in NY, TX and India.

Contact this candidate