Pavan Kumar Pullagujjula
Business Analyst
Hyderabad
Summary
To make use of technical, behavioral skills to achieve goals of the organization that focuses on customer satisfaction and customer experience, with excellent problem solving and analytical skills and with exceptional ability to learn and master new technologies quickly and efficiently.
Over Seven years of Professional experience in, Pharma, IT and Insurance with expertise in Business Requirement gathering, Data Analysis and design of OLTP & OLAP systems and proficient in transforming them to technical requirements. Familiarity and experience in the work environment which involves Business analysis, Production/Support, Subject Matter Expert, Database Administrator and Database developer. Over two years of experience on Caliber LIMS with expertise on Technical Application support, training, GMP Documentation, Auditing and multiple client’s support.
Overview
11
11
years of professional experience
9
9
years of post-secondary education
Work History
Sr. Product Specialist
Caliber Technologies
Hyderabad
1 2020 - Current
- Leading and managing LIMS software with requirements gap analysis, training, design, system configuration, development, validation & Go live in compliance with industry standards and best practices
- Handled multiple leading Clients (Zydus, Amneal, Ajanta, MSN Labs etc.) in Pharmacy industry
- Awarded as 2021 Core Value Champion under Compassionate Leadership category
- Primary contact for all Projects carried out through Implementation Partner, Shimadzu (Asia Pacific) Pte Ltd
- Involved in Auditing all Core and Support Functions of QMS
- Performed on-line and on-site training to various clients
- End-to-end implementation of latest LIMS versions at client sites including Instrument Interface (Port Based, File Based & CDS)
- Updated/ Created Functional Requirement Specifications and User Requirement Specifications documents
- Actively involved in supporting Finance and Revenue Management SME's from strategic project planning and support
- Delivered Project Implementation and Release plans in line with schedule
- Provided Hardware and Software technical support to Quality Control Unit
- Work in conjunction with end-users
- Responding to incidents within target SLAs and performing failure analysis, troubleshooting, identifying, isolating, and triaging problem
- Developing and Suggesting workarounds for known errors/problems
- Understanding and following SOPs and maintaining documentation of activities as per GMP requirements
- Understanding of laboratory processes and methods
- Actively involved in managing upgrade and migration to latest LIMS versions
- Worked closely with marketing team in getting milestone signoffs from the clients
- Performed configurations including subroutines, master data, stability, parsing scripts, products, and environmental monitoring within GMP environments
- Performed Build Validations and Instrument Interface Validation
- Regularly review, unit test, and validate application deliverables including master data, subroutines, upgrades, and new functionality
- Organized various workshops with the Team for bringing out the efficiency of performance
- Performed issue response and management through ticketing systems, adhering to the established processes
- Developing and Suggesting workarounds for recurring errors/issues.
Data Modeler/ Analyst
Fannie Mae
Virginia
02.2015 - 12.2017
- Used ER Studio 9.5 to create Logical and Physical Data Models of the Customer ODS using best practices to ensure high data quality near to third normal form
- Prioritized requirements to be developed according to Agile methodology
- Interacted with JAVA developers for making them understand ODS and XSD’s.
- Involved in requirement gathering along with the business analyst group
- Gathered various requirement matrices from the business analysts
- Engaged in the entire System study, Analysis and Design
- Participated in Joint Application Development (JAD) sessions
- Designed for the various reporting requirements
- Actively participated in data mapping activities for the Data Warehouse
- Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to Loan products
- Handled performance requirements for databases in OLTP and OLAP models
- Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
- Developed best practices for standard naming conventions and coding practices to ensure consistency of data models
- Created Source to Target Mapping document with all the transformation rules
- Produced Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer
- Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
- Performed Data Analysis to make sure that data is loading correctly into ODS
- Implemented Referential Integrity using Primary key and Foreign key relationships
- Maintained metadata in ER Studio model and provided Data Dictionary to the team.
Data Modeler
The Hartford Insurance
Hartford
01.2014 - 12.2014
- Responsible for complete Data Design, ETL mappings, Data Analysis and data technical specifications
- Had working sessions with Business to understand and gather requirements
- Optimized and updated logical and physical data models to support future needs
- Provided means of system integration by understanding source and target data and built detailed data mapping documents
- Created XSD’s (XML Schema Design) using XML Spy to support web services which are used in ODS integration layer
- Writing complex SQL queries and PL/SQL procedures to extract data from various source tables
- Created XSD’s in ACORD Schema compliance
- Maintained high-level data architecture documentation, which illustrates source and destination of data to and /or from approved data sources including Xpath mappings
- Developed best practices for standard naming conventions and coding practices to ensure consistency of data models
- Performed data analysis and profiling using TOAD for Data Analyst & TOAD for Oracle
- Evaluated data models and physical databases for variances and discrepancies
- Performed Data Analysis to make sure that data is loading correctly into ODS
- Helped Project Management in defining timelines for project delivery and provided status update on regular basis
- Assisted with project and problem analysis throughout construction, testing and implementation phases.
Education
M.S. in Electronics & Computer Science Engineering -
Southern Illinois University Carbondale, USA
Carbondale, Il 01.2013 - 12.2013
Bachelor of Technology in Electronics & Communication Engineering -
Lendi Institute of Engineering & Technology, JNTU Kakinada, India.
Visakhapatnam 10.2008 - 05.2012
Intermediate - Intermediate
Santha Junior College
Visakhapatnam 03.2006 - 05.2008
Schooling -
Vijaya Sri High School
Visakhapatnam 01.2004 - 05.2006
Skills
Sales Enablement Support
Product Roadmapping
Technical Product Knowledge
Product Lifecycle Management
Vendor Relationship Management
Stakeholder Management
Agile methodologies proficiency
Business Analysis
Outstanding interpersonal skills
Database Management
Product Training
Customer Service
Teamwork and Collaboration
Microsoft Office
Problem-Solving
Time Management
Problem-solving abilities
Team Leadership
Effective Communication
Websites
Technicalareasskillset
- Caliber LIMS- 3.2.0, 3.2.1, 3.3.0, 3.6.1.E & 3.8.1E
- Databases – Microsoft SQL Server 2000/2005/2008, Teradata, Oracle 12c/11i/10g/9i, DB2 and MS Access.
- Programming Languages – C, JAVA, and XML.
- Operating Systems – Microsoft Windows 7/XP/Vista/NT/2000 and UNIX.
- QA Tools – Quality Center and Test Director.
- Data Modeling Tools: ER Studio Data Architect 9.5, ERwin 7.1/7.2/8.2, Oracle Designer and Trillium.
- OLAP Tools – Oracle Business Intelligence, Microsoft Analysis Services, Business Objects, and Crystal Reports 9/10.
Disclaimer
I do hereby declare that, the above information is correct to the best of my knowledge and belief.
Timeline
Data Modeler/ Analyst
Fannie Mae
02.2015 - 12.2017
Data Modeler
The Hartford Insurance
01.2014 - 12.2014
M.S. in Electronics & Computer Science Engineering -
Southern Illinois University Carbondale, USA
01.2013 - 12.2013
Bachelor of Technology in Electronics & Communication Engineering -
Lendi Institute of Engineering & Technology, JNTU Kakinada, India.
10.2008 - 05.2012
Intermediate - Intermediate
Santha Junior College
03.2006 - 05.2008
Schooling -
Vijaya Sri High School
01.2004 - 05.2006
Sr. Product Specialist
Caliber Technologies
1 2020 - Current
Similar Profiles
Akilandeshwari KambhampatiAkilandeshwari Kambhampati
Sr SQA Engineer Level I at Caliber TechnologiesSr SQA Engineer Level I at Caliber Technologies
Gumpina SatyadeepGumpina Satyadeep
SQA Engineer at Caliber TechnologiesSQA Engineer at Caliber Technologies
V V GOPALA REDDY DRV V GOPALA REDDY DR
Manager at Caliber Technologies Private LimitedManager at Caliber Technologies Private Limited