Keerthi Bojjireddy
Mobile: 847-***-****
E-mail: adikpx@r.postjobfree.com
Data Analyst with 7+ years of experience in IT Business and Data Analysis, Project Coordination and Testing. Possess diverse Relational Database Management experience, experienced in Data Warehousing in high-volume environments and Data Warehouse Platform. Expertise in development, testing, deployment and support of BI Reporting tools (Tableau and Qlik view).
Professional Summary
Proficient in documentation of Data Requirements, as well as organizing interviews, user meetings, workshops, JAD Sessions and requirement elicitation sessions.
Experience in Business and Technical writing and includes creating Business process flow, Business process Modeling, activity diagrams, sequence diagrams and develop Use Cases
Experienced in Object Oriented Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case development using UML methodology
Worked on data warehousing, migration and MDM projects from inception to implementation and
delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management and executives, business sponsors and IT department
Experience in the Requirements mapping from program level to the project level in Application Life Cycle Management (ALM).
Well versed and experienced with development methodologies with a strong hold in Agile methodology, Waterfall model of SDLC with exposure to full project life cycle
Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
In depth and thorough knowledge of design with RDBMS -OLTP, dimensional modeling using data modeling tool ERWIN. Involved in analysis and design of Stored Procedures, Triggers, Views and other related database objects with solid experience in Oracle and MS-SQL Server.
Involvement in writing complex SQL queries DDL and DML and test scripts for data validation, backend testing, data profiling and data analysis.
Supported logical data modelling efforts, schema diagrams and have creating data mapping documents.
Expertise in testing phases through all the levels from developing test plans through test execution.
Supported the QA team in system testing and participated in user acceptance testing.
Experience working with off-shore teams, to delegate tasks and to ensure the assigned tasks are completed within the project timeline.
Ability for effective multi-tasking, prioritizing tasks, managing complex issues and exhibiting impressive organizational skills.
SKILL SET SUMMARY
Modeling Languages
MS Visio, Snagit9
Languages
SQL, PLSQL, Shell scripting
Operating Systems
Windows Vista, XP,7,8,Unix
Databases
MS SQL Server (2005, 2010,2012), Oracle 8i, 9i, 10g,11g
Microsoft Tools
MS Excel, MS Outlook, MS Project, MS Visio
Project Management Tools
Clear Quest, TFS, SharePoint, Quality Center, DOORS, Clear Case, Clear View
BI Tools
Tableau 8.1, Qlik view
ETL Tools
Informatica,SSIS, Datastage
PROFESSIONAL EXPERIENCE
Wells Fargo Mar 2018-Til Now
Business System Analyst San Leandro, CA
Wells Fargo Technology sets IT strategy, enhances the design, development, and operations of our systems, optimizes and enables continuous banking access through in-store, online, ATM, and other channels to Wells Fargo’s more than 70 million global customers. ATM Banking operates one of the most extensive banking franchises in the country, serving customers through approximately 6,000 branches and 13,000 ATMs in 39 states.
Responsibilities:
As a Business Analyst I Consult with technical partners, business partners, and project teams to establish appropriate implementation strategy, methods and plans for strategic initiatives that impact multiple or organization-wide systems, workflows or products with high risk.
Provides support for highly complex technical issues and initiatives related to large-scale applications, systems, databases and provide a work around for complex problems and focuses on bringing issues to resolution, escalating as necessary to meet timelines.
provides support for highly complex technical issues and initiatives related to large-scale applications, systems, databases and/or other technical products and services
Analyzes performance trends and recommends process improvements; assesses changes for risk to production systems and assures quality, security and compliance requirements are met for supported areas; updates, creates and tests the business continuation plan.
Release Implementation schedule planning for Teller, Banker, and ATM Systems - Includes Pilot, Rollout, and fixes and opens, monitors and closes Change Requests, Work Orders, Work Requests and Problem tickets in Pac2000.
Defining Pilot/Soft-Launch locations and detailed deployment across the states
Configuration management, coordination, and schedule planning for new functionality
Post Implementation follow up for Teller, Banker, and ATM Systems to track/facilitate any Post install incidents through resolution.
Generating repots using Tableau and Cognos
Tools: PAC 2000, Tableau, Cognos, AMP, Oracle DB
Genentech,CA Aug 2015- Dec 2017
Senior Business Data Analyst
As a drug manufacturer, Roche / Genentech are required to disclose any reportable spend/transfer of value (TOV) to reportable recipients such as Physicians and Teaching Hospitals to state and federal regulators. Roche / Genentech Commercial Compliance Operations (CCO) and Legal Organizations interpret federal/state regulations and relevant guidelines into data aggregation and reporting methodology document, which serves as a basis for certification process and relevant federal and state reporting.
Responsibilities:
Analyzed and gathered the requirements for MCCO Stewardship and aggregate spend team by supporting the Customer, Channel, and Contract Performance Insights (C3PI) Platform.
Gathered the AGGS Spend Sunshine Tool Disputes/Held requirement from business users & client technical team for data analysis.
Demonstrated the model changes and project related specs/docs to the stakeholders including quality adherence team.
Conduct requirement, design walkthroughs, demos and functionality feedback sessions with all stakeholders.
Partnered with the data acquisition team (FOIM) to measure, track accuracy, and open data inquiries of any third-party master data sources (such as IMS/ Health Care Organization Services or other purchased sources)..
Developing data quality metrics and work cross-functionally to get alignment on metric definitions and developing consistent methodology for generating metrics.
Supported in all phases of C3PI Solution deliverables.
Perform data analysis of Oracle and Excel sources during analysis phase of the project.
Assist with the data migration process by analyzing and correcting various data integrity issues and ensuring uniformity across all data fields
Enabling decision making through secure, real-time collaboration. Write complex SQL queries against Oracle data sources to test accuracy of ETL operations developed in Informatica.
Extensively used Excel for data reconciliation reports
Develop, implement and manage data strategies that optimize data quality to improve standardization and business information value derived from enterprise data.
Participate in brainstorming sessions for conceptual and logical data modeling.
Develop and maintained Technical Specifications Documentation for the Technical team.
Develop and reviewed Test Plans and Test scripts and organized UAT sessions for the business users.
Environment/Tools: Oracle DB, Toad, MS Excel, HP Quality Center, Remedy, Informatica, UML, MS Visio, Doors
United Health Care, TX Dec 2014- June 2015
Data Analyst
UnitedHealth Group IT (UHG IT) is a comprehensive, large-scale information technology services organization. UHG IT functions as the engine driving billions of transactions from millions of customers.
Responsibilities:
●Extensively used SQL to perform data analysis and data validation.
●Worked with Business users to build data sets to fulfill their Ad-Hoc data analysis needs.
●Worked on the agile model, to deliver the products.
●Analyzing on the enhancement requests and defects to determine solutions which do not impact product features.
●Providing information by analyzing and translating information to IT teams and management.
●Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the databases by Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.
●Experience with Data Extraction, Transformation and Loading (ETL), query enhancement and managing data relationship with IT teams.
●Worked on test plans and User Acceptance Test(UAT) procedures.
●Extensively used Excel, and Access in managing data reconciliation reports
Environment/Tools: Oracle DB, Toad, HP Quality Center, Remedy,SSIS, UML, MS Visio, Doors, PeopleSoft CRM,Excel
Health Care Service Corporation, TX Feb 2012-Nov 2013
Data Analyst
Project: To upgrade existing system to Epic Healthcare system in order to enhance the efficiency of business reporting. The data was organized in much better way in new system so that cost of processing and maintenance reduced as well as less efforts were needed to monitor the data flow.
Responsibilities:
●Analyst using multiple data source systems for transition, acquisition, and integration into information repositories; impact analysis of systems and process changes.
●Deliver data mining and reporting as a support function for audits.
●Coordinate the integration of external data into repositories and reporting systems.
make recommendations on specifications for computer programs, databases, systems and reports.
●Provide complex ad hoc reports on complex data requests using SAS, SQL and MS Excel.
●Support the use of mechanisms to ensure reporting systems balance to data repositories and source systems.
●Manage the quality improvement initiative, resulting in the design, implementation, administration, and support of quality review monitoring processes.
●Develop processes and metrics to track revenue for revenue maximization, budgeting, and bid refinement and vendor evaluation.
Environment: Oracle DB, TOAD, IBM Datastage, MDM Clear Case, Clear Quest, SDLC, MS Project/Office/Visio, Excel.
EDUCATIONAL QUALIFICATIONS
Bachelor of Engineering, Karnataka India - 2006