SURAJ KUMAR KINNERA

8+ years of Industry experience as a Sr. Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources and Translating Requirements into Specifications in Banking Industry. Extensive experience in role as Senior Business Analyst with excellent knowledge to the full Software Development Life Cycle (SDLC) methodologies, frame works and processes. Experienced in managing requirements from project inception through release. Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC) Good Knowledge of various financial products like Stocks, Bonds, Mortgage-Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments. Managed dependencies and worked with dependent and interfacing teams to align support and delivery of product to ensure team success including process mapping of Commercial loan (Wholesale, DDA, CRE) life cycle process from case management of commercial relationships, underwriting analysis, credit approval, loan closing documentation, booking, funding and collateral vault to identify gaps and opportunities. Experienced across Microsoft Business Intelligence suite Power BI Service, Power BI Desktop, SQL Server, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). Expertise in the usage of ETL tools including SSIS, DTS for large-scale Data warehouse implementation Projects involving conversion of data from heterogeneous data sources including SQL Server 2000/2005, DB2 and Oracle Over 3 years of experience developing interactive dashboards using Power BI and Over 3 years of experience working with Tableau. Applied hypothesis testing and advanced statistical methods in R (clustering, random forest, regressions) to Deployed SSRS reports using report server and responsible for monitoring and tuning reports. Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Expertise Knowledge in writing DAX Queries and MDX Queries. Design and development of Microsoft Power BI visualization solutions like Dashboards, Standard Reports, Scorecards, Drill down reports, Drill through reports, charts and Ad - hoc Reports. Comprehensive understanding and experience of SDLC and project life cycle methodologies such as Waterfall, Agile/Scrum, Rapid Application Development, (RAD) and Rational Unified Process (RUP). Created templates and documentation aligned to Agile & SAFe principles and processes. Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models. Worked with Demand Deposit Account (DDA) applications; this included coordination across multiple in-house teams, vendor team, and the department for application analysis and design documentation and review. Experienced in multi-tier, database-driven, client-server, Internet, Web, and wireless development. Focus on making systems better through Agile Methodologies, re-architecture, re-factoring, code clean-up, and redesign. Requirement gathering, BRD preparation for various functionalities like DDA, Fund transfer, Customer maintenance, Loan IQ, Loan origination and non-functional requirements for Flex cube. Documented business requirements, functional requirements, use cases, business rules of financial transactions as bill payments, transfers, deposits and security access. Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process. Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau. Expertise in using Tableau Filter, URL and Highlight actions to switch between sheets and navigate to external or internal websites Expert in visualizing the data, reporting and analyzing, creating the dashboards and reports in an intelligible pictorial representing like bars, geographic maps, bubbles, pies, lines etc. Proficient in creating Tableau scorecards, dashboards using advance Tableau functions like Calculated elds, Sets, bins, Groups, Parameters, Actions, Level of Detail (LOD), Adhoc Calculations, etc. Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau. Extensive experience in creating users, groups, sites, row level security and monitoring server activities in Tableau Server. Experienced and Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS 2012. Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Experienced and Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS 2012. Expertise working with SSAS Tabular model to produce reports in excel les using pivot tables. Excellent T-SQL programming skills and experience in the development of SSIS packages using BIDS, complex Stored Procedures, Configuration Files, Tables, Views, Triggers and Functions. Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development. Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users. Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments. Experienced in writing Test Plan and Test Cases and aggressively involved in Regression Testing and Performance Testing using automation tools like Win Runner, LoadRunner, Test Director, Quick Test Pro, Silk Test and Oracle table manipulation using SQL. Involved in Business Requirements walkthrough with the business owners as well as the technical stakeholders. Worked on identifying monitoring gaps or failures during real time transmissions and proactively challenging business units for resolutions and enhancements. Good communication skills in working with business leaders, executive management, business process owners, user communities and IT solution providers. Involved in writing Test Plan and Test Cases and aggressively involved in Regression Testing and Performance Testing using automation tools like Win Runner, Load Runner, Test Director, Quick Test Pro, Silk Test and Oracle table manipulation using SQL.