Project Management
Resume:
Sowjanya
ac0lzc@r.postjobfree.com
Summary:
Highly accomplished Senior Business Analyst with 8+ years of expertise in business intelligence, analyzing business requirements and transforming them into technical solutions and verifiable track record of managing complex projects and exceeding expectations. An innovative business professional with ability to develop creative solutions for complex problems.
Experience in systems testing, systems operations and systems analysis in the Healthcare, Insurance, Telecom etc. environments.
Data visualization skills and experience using visualization tools ex: QlikView& BO. Analyses and comparisons of data in preparation for Dashboards and Reports (List reports, Cross-tab reports, Drill through reports, Master-Detail Reports and Cascading Reports). Conducted Analytical modeling and prepared relevant dashboards to show the equations and preparing recommendations for management.
Creating and maintaining project migration schedule with project documentation requirements.
Worked with a client relationship focus to ensure full awareness of client business workflow, strategy, issues, requirement, and tools.
Very good working experience on Facets Claims Processing system.
In-depth knowledge of creating BRD, FRD, SRS, SOP, use cases, wireframes, activity diagrams, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
Proficient in business process modeling, documentation, and testing using Quality Center, Rational Suite, MS Office Suite, MS Visio, MS SharePoint etc. in combination with UML 2.0 diagramming techniques.
Proficient with data analysis and processing functions such as pivot tables, statistical analysis, multivariate analysis, data mining, graphs, charts that are used in excel and spreadsheet applications.
Excellent skills in writing stored procedures, SQL queries, functions, triggers, views and schemas in SQL.
Technically savvy operations manager with the ability to capture, collate, and analyze data to provide
Recommendations and insights to senior management in support of strategic and tactical business decisions.
Familiarity with programming languages like XML Web Services (SOAP, WSDL, and UDDI) and Service Oriented Architecture (SOA) with MS Visual Studio development platform (WCF).
Good understanding of UI/UX with design specifics using Adobe Photoshop, HTML & CSS.
Knowledge of various Software Development Life Cycle (SDLC) methodologies like Waterfall Model, Agile (SCRUM, User stories, Sprints)with an in depth knowledge of RUP’s Iterative Software Development Life Cycle process i.e. Inception, Elaboration, Construction and Transition.
Strong experience on understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL architecture.
Expertise in business requirement elicitation/gathering using techniques like interviewing, questionnaires, brainstorming, and focus groups; conducting JAD sessions, project meetings, customer interviews and coordinating various technical and managerial teams or stakeholders at all levels.
Knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment) with EDI.
Having great leadership qualities for handling small/large team with strong analytical and problem solving skills, multi-tasking abilities.
Education:
Bachelors in Instrumentation Engineering, India
Technical Skills
Software Tools: Microsoft Office Suite (Word, Excel, PowerPoint, Access), MS Project, Adobe Photoshop, Adobe Dreamweaver, AEM
Database: TOAD, MS Access, Oracle 9i
Tools: UML, Share Point, HP Quality Centre, Rational Suite, MS Visio, iRise, JIRA
Project Methodologies: SDLC, Agile/Scrum, Waterfall, Rational Unified Process (RUP)
BI Tools : QlikView, Business Objects
Version Control Tools: MS Visual Source Safe (VSS), Team Foundation Server (TFS)
Languages: HTML, CSS
Professional Experience:
Humana Health Care OH/US Dec 15 – Till Date
Sr. Business Analyst
Responsibilities:
Analyze and develop policies and procedures to help increase efficiency and quality
Define, gather and create business requirements documents (BRD), Functional Specifications Documents (FSD) and Use Case Specifications
Identified, researched, defined and documented user problems and automated/manual business processes.
Executed SQL queries on relational databases to create daily reports
Conducting meetings with Subject Matter Experts (SME's) to understand the workflow of the business and their application processes
Assisted the Project Manager in developing, tracking and managing the project triple constraint; schedule, cost, resources and scope using MS Project
Analysis of all the projects of past related to the functionality and come to one conclusion and then write the business scenarios for testing team
Providing part time support to testing team to implement business logic into system at the time of testing & execution
Used Electronic Medical Record (EMR) to extract useful information regarding patients for claim submission to the insurance company.
Analyzing of system requirements and Use cases involved in the product development for writing of Test cases
Supporting the design team for designing the best UI/UX for the web portal.
Performing GAP analysis to derive requirements for existing systems enhancements.
Designed and developed Use Cases and Use Case Scenarios using the UML methodologies
Synthesized User Interface and Business Process Requirements and translated it into the Business Requirement Document (BRD), to be use as input to the functional design specifications
Worked with development team to develop SOA architecture using Windows Communication Foundation.
Work with upper management of medical management department to identify and brainstorm solutions for bottlenecks and errors of ongoing reports.
Conduct elicitation meetings gather/refine specifications and design reports that would satisfy business needs.
Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
Worked on XML/XSLT for dashboard development.
Upgrade and QA reports in order to make sure they accommodate various new health care plans and data.
Manage the development of multiple reports in order to consolidate information that would assist upper management of various departments in making enterprise decisions via Tableau.
Creating of verifying Tableau reports by writing complex SQL statements with joins, aggregate functions, and filters &search criteria to verify the integrity and correctness of the report outputs.
Worked in the agile methodology-using Scrum, which has its primary focus on the management part of the software development in small iterations of four weeks’ sprint. Created user stories for all the release, sprint planning, daily stand-ups, grooming & planning sessions with team.
Involved in advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
Involved in generating reports from excel database for Tableau Dashboard.
Designed and developed Qlikview visualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
USAA San Antonio, TX Dec14 – Nov15
Business Analyst
Responsibilities:
Responsible for gathering and analyzing Business and system functional requirements and for understanding and translating these needs into Business Requirement Specification (BRS), System Requirement Specification (SRS) documents, Conceptual design document (CDD), Client requirements document (CRD), and Functional specification document (FSD)
Involved in creating Business Flow Diagrams, Dataflow diagrams, UML Activity diagrams, Sequence diagrams, and USE cases diagrams using MS VISIO.
Developed and executed test use cases for the prototype application. Documented results of the tests and communicated same to the development team.
Conducted risk analysis, while writing BRD, SRS, and test strategies. Determined risk impacts, developed risk mitigation strategy and created risk action plans.
Interacted and arranged meetings with Business and in network/out network service providers to gather business requirements for the current process of getting prior Authorization.
Gathered Business Requirements from the Subject Matter Experts (SMEs), liaison between the business team and the IT community and documented the requirements in the BRD & Functional Requirement Document (FRD).
Worked in Agile Development environment with daily stand up meetings, writing user stories, planning sprints, burning points, reviewing, grooming, many more.
Utilized data flow diagrams, use case diagrams and process flow diagrams to represent information provided by the Business Owners.
Supported systems administration team in using BO software for BI planning, testing and implementation functions.
Facilitated JAD Sessions with the SMEs, stakeholders and other management teams in the finalization of the business requirements documentation.
Gained understanding of the firm working system including registration, scheduling, investment banking, risk policy and claim processing.
Wrote complex SQL queries to enhance the performance of the reports.
Coordinated between test team, development and business team in clarifying the functionality issue and requirement specification.
Assisted in quality testing process to validate that the program meets the requirements.
Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements with the support from SME's
Was in regular contact with Business partners on the status of issues, action plans and timeframe for resolution throughout the development cycle.
Manage & coordinate project activities with business users, development, QA and validation teams to ensure that business requirements are accomplished within stipulated project timelines.
Involved in project budgeting, auditing, project resource planning, project scheduling, risk analysis and management
Effectively managed project risks by creating and managing a Risk Register which identifies, prioritizes and measures risk, risk drivers and expected loss
Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
Centurylink – Hyd/India Mar 11 –Nov13
Sr. Business Analyst
Responsibilities:
Collaborating between Clients, Development Team, Digital Marketing Team (SEO), QA Team. Managing clients and resolve their problems.
Worked in Agile development environment.
Understanding client requirements and getting the best result oriented strategy.
Assisting clients to choose the best solutions and results.
Preparing very detailed reports, UML diagrams, process flow diagrams, etc. using Apple Keynote and other software’s.
Reviewing all the documents of Team Leaders.
Train and motivate team leads to maintain the accuracy and get the maximum turn around to the clients.
Reviewing and preparing rough quotes for the new/old clients to ease the work of Business Development team.
Maintaining client satisfaction so client retention ratio is sustained.
Got great achievements in many clients with higher conversion rates or increased leads.
Implementing detailed Google analytics or tags with the help of Google tag manager. Implementing dashboards, views, funnels, goals, events, many more.
Maintaining websites in AEM with maintaining content, social media marketing and paid campaigns.
Made many process documents streamlining the team of 13 with 5 team leads.
Interviewing and recruiting best resources for the company.
Resource management and motivation.
Verizon– CHN/India Mar08- Feb 11
Sr. Business Analyst
Responsibilities:
Provide consultation to businesses to build up their on-line promoting efforts.
Leverage the potential of the web to create businesses more competitive within the on-line world, get a lot of customers and increase multiplied financial success.
Collaborated closely with the UI design and development team to ensure viability of new features to ensure proper functionalities of the complete system.
Provide advanced digital marketing solutions to suit the requirements of companies from multiple industries; services provided embody however not restricted to web site design, search engine optimization (SEO), Paid Search marketing (PPC), Social Media, Mobile marketing/Applications and Email Marketing.
Effective social media and mobile device presence
Manage multiple business functions including client communication/management, operations, project management, etc.
Effectively handling project communication, documentation, training, and requirements management
Deliver excellent customer service and maintain meaningful relationships with clients’ campaigns and regularly communicate performance results.
Involved in designing and developing Data Models and Data Marts that support the Business Intelligence
Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
Extensively use Microsoft Project or similar tools such as Open Workbench to document project plans.
Performed extensive requirement analysis including data analysis and Gap analysis.
Analyzed business requirements and segregated them into high level and low level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
Successfully conducted sessions, which helped synchronize the different stakeholders on them objectives and helped the developers to have a clear-cut picture of the project.
Have been working on exploring different software systems and databases in order to design a possible solution and identifying vital data points/elements.
Created UML models and visual artifacts like DFD, flowchart, and process flow diagrams.
Participated in the logical and physical design sessions and developed design documents.
Used MS Visio for process modeling, process mapping and business process flow diagrams.
Designed and implemented basic SQL queries for QA testing and report / data validation.
Worked with quality control teams to develop test plan and test cases.
Prepared functional requirements/technical documents, led the change request management and prioritized requirements.
Developed use cases/user stories and acceptance criteria and led the sprint planning and retrospective Meetings.
Mapped the regulatory environment in geographies such as the U.S, Europe, Australia with the challenges faced by various players in the insurance domain and assessed its impact.
Lead a team of 5-7 interns and developed successful campaigns.
Contact this candidate