VENU LINGAMANENI

SUMMARY:

• 12+ years of EDW and Business Intelligence experience in implementing and designing enterprise data warehousing using Informatica, Teradata, Netazza, SQL Server, DB2, Data Allegro as a BI Business Analyst.
• Extensive experience in designing and developing reports, data aggregation, Statistical Analysis, dash boards, trend analysis as a Business Intelligence architect using SQL Server BI, Business Objects, OBIEE, Hyperion, SAS BI, Cognos, Business Objects, Micro Strategy, Tableau for the OLTP and OLAP environments.
• 3+ years of experience with Big Data, Good Data and Cloud Data.
• Extensive experience in the implementation and design of ODS systems, Databases for various applications.
• Practiced in clarifying business requirements, performed As Is - To BE, Gap, feasibility and Solution Analysis.
• Complete SDLC and Project/Product Life cycle experience as Business Systems Analyst, Business intelligence analyst, Functional Analyst, Requirements Analyst, Quality Assurance Analyst, Data Modeler, Usability Specialist and Technical Writer.
• Experience in working with clients such as Trading, Securities, Financial, Healthcare, Insurance, Energy, Retail, Ecommerce and Clinical Domains.
• Experience designing and building expert systems for Product Recommendation & Selection, Problem Diagnostics & Troubleshooting, Customer Service, Accounting, Audit and Web3.0 solutions.
• Ability to understand IIBA and Business Analyst Body of Knowledge (BABOK).
• Ability to research, analyze and translate complex business and technical information to Managers, CIO, Developers and Testers at all verticals & horizontals.
• Experience with Change Management, Identity management, Issue resolution and Risk management Processes.
• Worked closely with development teams as business subject matter expert during Technical Design, Development, Testing, Deployment and maintenance stages of the project.
• Worked with SQL, PL/SQL, Joins, Sequences, Stored Procedures, indexes, views, Teradata, Data ware housing, xml, open standards, schema systems, OPENXML, SOAP, XHTML, tags, elements, attributes etc.
• Experience with MS Project, Budgeting and time tracking tools.
• Experience with Six Sigma, Agile, Scrum, Project Management, and System Development Methodologies utilizing Enterprise Architecture Framework to align systems with business.
• Class Diagrams and ERDs in providing the Solution Designing, Resource Management, Team Building, Project Plan, Budget Management and Cost Avoidance.
• Experienced in working with Client Facing, End User, in house, Near Shore and off shore development teams.
• Experience with Facts, Dimensions, Look Up tables, Slowly Changing Dimensions, Flat Files and Web Services in designing the enterprise data warehouse.
• Deep content knowledge and expertise using Business Process Management (BPM), Knowledge Management (KM), and Business Rules Management (BRMS) technologies.
• Knowledge in Data warehousing 2.0, BI 2.0 applications such as Business Analytics, Dashboards, EPM etc.
• Worked with ERP/CRMs such as Oracle R12 EBS, SAP and Salesforce.com.
• Ability to Define explicit and implicit requirements using UML(Use cases and UML diagrams), Current State Analysis, Process Modeling, Data Modeling, Paper Prototyping, GAP Analysis, UI Prototypes, Frameworks, Report Prototypes, Sitemaps, wireframes, “Day in the life of analysis” and copy decks.
• Facilitated requirements gathering/JAD Sessions in compliance with AGILE and SCRUM methodologies.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Involved in implementation of HIPAA EDI Transactions such as 835,837 etc.
• Facilitated Electronic Data Interchange.
• Performed GAP Analysis for HIPAA 4010 and 5010 transactions.
• Used EDI tools to verify mapping to X12 format.
• Recommend changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards ANSI.
• Designed, Implemented HIPAA EDI transactions in X12 responses and of 837, 835, 277CA and 999 and conducted QA and validation defect testing.
• Conducted data analysis for various version changes of EDI messages on different sub-systems.
• The project is on the conversion of for different transactions such as 837, 277 and 276.
• Provided the required test data for the developers in order to fix the defects.
• Participated in QA team meeting and bug tracking meetings.
• Assisted in writing efficient and effective Test Plans, Test Strategy, System testing, End-to-End Testing and User Acceptance testing.
• Participating in the planning, development, coordination and presentation of specific testing needs as appropriate to the quality assurance needs of the end user.
• Assisted business users in defining UAT test cases and plans; Established and maintained test cases and test data in Quality Center.
• Coordinated with the QA Team for testing activities across multiple systems and managed Conversion test execution.
• Helped in conducting Gap Analysis (GAP), User Acceptance Testing (UAT), and System Integration testing (SIT) and SWOT analysis.
• Developed reports using Crystal Reports and Business Objects, Crystal Brio and Crystal Xcelcious.

Environment: SQL, PL/SQL, ETL, Business Objects, Crystal Reports, EDI.

Confidential

Business Analyst

Responsibilities:

• Worked with Medicare, Medicaid, Duals, Hospice, LTSS, Vision, Dental, Pharmacy and behavioral health benefits.
• Duals insurance plan product design, benefit planning and eligibility rules design.
• Developed solutions for Managed Care in association with state, federal and autonomous apex institutions such as CMS.
• Experience in conducting JAD Sessions, Collecting requirements related to 834, 837, 835, 276, 277, 834, 820, 270, 271 Transactions
• Implemented Healthcare Enterprise Core Administration Platform using Facets and Electronic Health Record & Practice Management applications using NextGen platform.
• Also involved in migrations and customizations of Facets & NextGen systems.
• Actively involved in designing the Enterprise data ware house.
• Designed and Developed Self Service and hosted Business Intelligence reports using SQL Server BI. (SSIS, SSRS, SSAS)
• Provided usability documents, Software Design Documents (High Level/Low Level), Technical Specification Documents etc.
• Experience in working with financial data such as General Ledger, Balance Sheets, International Accounting, Account Receivables and Payables etc.

Environment: SQL Server, PL/SQL, Crystal Reports, EPIC Reports.

Confidential

Business Analyst

Responsibilities:

• Implemented large scale healthcare claims processing systems such as Medicare/Medicaid developed with HIPAA standards.
• Analyzed business requirements, suggested most effective database solutions to fulfill those requirements, setting up access methods for data (view, APIs etc), management of data, creation and maintenance of / test data scripts. Performed code reviews.
• Medicare/Medicaid plan design, Plan coordination and Benefit management
• Creation of data models(ER Diagrams) for online and data warehousing applications (ODS) and work with DBAs to physical data structures.
• As part of Enterprise architecture team, creation of enterprise wide database design standards, processes, database solutions, creation and maintenance of enterprises data models and process models. Creation of data management strategy, Enterprise architecture governance strategy, creating business process models. Maintaining HIPAA Protocols and maintenance and communication standards and protocols.
• Data modeling experience in Architecture, design, OLAP, DSS and reporting. Infrastructure set up, Analysis, Conceptualization, Design and Development, Mentoring, Discoverer, Star Schema, Snow Flake schema, Slowing Changing Dimensions Type1, Type2, Facts, Dimension tables, Bill Inman and Ralph Kimball approaches, Data marts etc.
• Upgrading 4010 documents to 5010, and familiarity with HIPPA/EDI Standards EDI Health Care Eligibility/Benefit Inquiry documents such as 270, 271, 276, 277, 278, 835, 834, 820, 997
• Implemented end to end enterprise wide data ware house system for Document Management System and also instrumental in designing and developing reports using SAS BI platform.
• Created multiple ETL jobs using Data Marts, Data Mining, performance tuning, Batch Processes and reporting using SQL Server, SSIS, SSRS and Cognos etc.

Environment: SQL, PL/SQL, ETL, Informatica, Cognos.

Confidential

Systems Analyst

Responsibilities:

• Gathered, Documented, Analyzed, Participated, Managed, Validated complex Business requirements & Functional specifications in migrating data from existing SAP ECC 5.5 system to the newly implementing Oracle R12 ERP system.
• Worked extensively with SAP Data Services, SAP BW and SAP Business Objects.
• Conducted JAD sessions to design and implement Advance Metering Infrastructure and Automated Meter Reading solutions.
• Familiarity with Smart Meter & Smart Grid systems of General Electric, ABB, Schneider Electric and Siemens.
• Gathered and validated requirements from Joint Application Development (JAD) sessions with Business Units to ensure Legal and Audit Compliance.
• Created User Interface Prototypes, Business Use Cases, System Interface Documents, Business process design, process flow diagrams, Information Mapping Diagrams, Functional Specification Documents (FSD), Software Requirement Specification Documents (SRS), Software Design Documents (SDD), Input Process Output (IPO), Context (Business and Design), Vision, Traceability matrix, Use case diagrams, Activity diagrams using Rational Unified Process(RUP) artifacts with Agile team SDLC.
• Created Business Intelligence applications using OBIEE platform and also participated in EDW implementation.

Environment: SQL, PL/SQL, OBIEE.

Confidential

Business Analyst

Responsibilities:

• Implemented enterprise wide data warehouse using time series, geography dimensions.
• Developed various OLAP cubes using Hyperion software.
• Designed various trending and analysis charts
• Dedicated to Business Analysis, Quality Assurance practices such as agile process, daily scrum, iteration review and planning meetings.
• Worked extensively with SAP Business Objects and Oracle ERP, OBIEE and Hyperion.
• Developed Preliminary project plan, Project work Breakdown Structure (WBS), project timelines, project analysis, impact analysis and risk Analysis on project plans, methodologies, resources and participate actively in their implementation.

Environment: SQL, PL/SQL, Hyperion, OBIEE.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Produced High level Design and Low Level Design of solutions detailing exact functional and technical requirements against respective needs detailing exact Configuration / Database changes required to address various business functionalities and changes.
• Customized eCommunications, eChannel and eSales application for Order Management and Service Management application to in corporate unique business rules of online business and interactions with backend systems.
• EAI, Web Services, MQ and MS SQL scripts were used to communicate with other systems for order progression and processing.
• Created a detailedproject planwith well-defined tasks, milestones, signoffs & specifications.
• Identified risks and defined appropriate mitigation strategies.
• Monitored weekly status to track the Target Vs Achieved performance.
• Developed end user reports (performance, financial human resource) using Business Objects platform.
• Created reports using OBIEE and MicroStrategy

Environment: SQL, PL/SQL, ETL, OBIEE, Micro Strategy

Confidential, Manhattan, NY

Business Analyst

Responsibilities:

• Project to test and validate the brokerage system components affected by changes of requiring to support valid short transactions and short positions on Confidential Type 2 margin accounts
• All the components including Accel trading platform, Fidessa OMS, Wash Manager, Intact agent, BPSA SOD and Real time agent, Portfolio Manager (for rebate processing and interest calculation), RBC Prime blotter processor, RBC Prime trade entry GUI, Prime transaction and validation manager, Anvil Rebate system, Axiom RiskMonitor system, Utopia Collateral & Margining system, Prime report manager, Advent P&L manager, PB Direct, are validated and tested affected by consolidating short transactions in ADP type 2 accounts, BNYM Workbench
• Wrote use cases for unit testing of trades flow for BPSA (ADP through Intact), Trade Entry screenand SODbatch
• Prepared project plans, work breakdown structure, schedule, cost and other project related documents including requirement traceability matrix.
• Conducted JAD sessions with treasury product and ACH SMEs, vendors, users, PMO and other stakeholders and monitoring for open requirements and pending issues.
• Restructured business workflows to enhance applications’ capability to meet business needs.
• Created dash boards and drill down reports using Micro Strategy Business Intelligence platform.
• Oversaw offshore shared technology resources for release and implementation activities.

Environment: SQL, PL/SQL, ETL, Micro Strategy

IBM, Poughkeepsie, NY

Business Analyst

Responsibilities:

• Developed and maintained Point of Sale terminal applications, user interfaces according to end client specifications.
• Worked with Systems Analysts who in turn certify all new applications and equipment.
• Provided 4th-Level technical support for product troubleshooting.
• Facilitated JAD session with external clients and internal development teams, in order to develop artifacts to support the development and implementation of Enterprise Architecture, Business Transformation and systems development.
• Used Business Applications Oriented Modeling (BAOM) approach to define artifacts, which include UML Use Cases and UML Diagrams (Use Case, State, Activity), Business Process Models, Data Models(Class Diagrams), Data Dictionaries, Report Prototypes, Functional Requirements, Non- Functional Requirements, Gap Analysis, UI Wireframes, UI Specifications, Site Maps, “day in the life of “ analysis, and Copy Decks.
• Reservation application analysis and development, Release Management, enhancements, Troubleshooting, testing, configuration, implementation, Joint Application Development (JAD), Walkthroughs and Review meetings with Project Manager, QA Engineers and Development team.
• Created business intelligence reports using Crystal Reports, SQL Server 2000, Cognos and Actuate Reports etc.

Environment: SQL, PL/SQL, Actuate Reports, Crystal Reports.