Phani K Balagam

• Managed large-scale projects and introduced new systems, tools, and processes to achieve challenging objectives.
• Lead the development of our data science roadmap as well as building out foundational models to support the creation of a more efficient go-to-market strategy
• Guided team through the stages of problem-solving processes like defining objectives, gathering data, analyzing results and drawing conclusions.
• Lead the development of data specifications and processes for a multi-modal Knowledge Graph by integrating information from internal and external data and knowledge bases for analytical and AI/ML model consumption
• Work with different data producers and owners to implement framework and processes effectively
• Collaborate closely with product and engineering teams to design and implement data management strategies ensuring the quality, organization, and accessibility of the data
• Shared best practices regarding efficient time management and prioritization of tasks within high-pressure work environments.
• Increased customer satisfaction with timely project deliveries and seamless communication.
• Conducted performance evaluations, compensations and hiring to maintain appropriate staffing requirements.
• Established a supportive mentor-mentee relationship, instilling trust and fostering self-confidence in team's data science abilities.

• Manage Data Science development team and resources to develop Advanced Analytics build on top of Research data Lake.
• Improved overall business performance with the implementation of predictive analytics solutions.
• Championed a culture of innovation by encouraging experimentation with new approaches to problem-solving using data-driven insights.
• Leveraged machine learning techniques for enhanced pattern recognition and trend analysis capabilities.
• Implemented randomized sampling techniques for optimized surveys.
• Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
• Hands on Analytics development of Preclinical Manufacturing and Process development(PMPD) Analytics showing insights
• Transformed raw data into meaningful visualizations for easy interpretation by non-technical stakeholders.
• Standard development life cycle; DevOps practices with Confluence, JIRA, and GitHub, AWS Redshift,Python, SQL

• Managed end-to-end data science projects, from problem definition to solution deployment, ensuring timely delivery and high-quality results.
• Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
• Evaluated new technologies and methodologies, staying up-to-date on industry trends and best practices.
• Mentored junior team members, fostering a culture of continuous learning and development within the organization.
• Compiled data highlighting key metrics to report information, determine trends and identify methods for Operational Excellence
• Strategized forward-looking insights Roadmap to offer predictive intelligence for business decision-making.
• Identified tools, technologies and skillset for analytical team building process and create positive environment
• Lead Business insights for Lab operations management and help build Quality,Downtime, Cycletime, Space usage, Demand Forecasting, Analytics in Tibco Spotfire
• Lead Lab Equipment utilization reports in spotfire and help business with insights to better planning and service of the assets in the labs
• Delivered inventory management reports with consumable usage, Supplier performance, Stock management, Drug Development reports

Leadership:

• Lead the business requirements gathering efforts and documented the data for functional and business requirements to ensure the scope is captured correctly
• Expert in Business Analytics coaching, motivating and supervising of the analytical team
• Lead and Expanded analytical team potential to take on additional work with the existing team by influencing automation of existing work streams and documenting instructions, code and the process

Hands-on Data Architect:

• Implemented Enterprise data architecture with data models supporting Finance,Sales, Service Manufacturing.
• Design a data lake solution in AWS cloud, that best fits the enterprise wide data analytics, data science and machine learning and Spotfire BI dashboards and reporting
• Developed spotfire quality, efficiency and timeline reports on top of Clinical data management systems. Effectively build Sequential analysis reports in spotfire where there is an incremental data and helped with good clinical practice(GCP) to be within GxP guidelines
• Build Patient cohort analytics in spotfire and implemented row level security based on user login
• Build cycle time spotfire reports to estimate clinical trial performance in every plant and provide insights into resources workload and help the trial process from drug development to marketing
• Developed presentation ready reports for blinded and un blinded tests. Worked closely with pharmacovigilance team and developed processes reports in spotfire and supported in drug safety
• Substantial contribution in creating various visual rich financial performance Spotfire dashboards like Profit and Loss, Gross Margin and Revenue, Revenue and Expense, Revenue and Profitability, Costs breakdown, Actual vs Budgeting, Expense Management, Balance Sheet, sales and orders, sales and profit, Sales Pipeline, Customer profitability, and open orders
• Automated entire financial monthly, Quarterly and yearly review reports for the corporate finance team
• Involved directly in creating various marketing Spotfire dashboards as Sales funnel, Lead to conversion, Campaign ROI out of Salesforce data, Email Campaign Analytics, Break-Even Analytics, Cost per Lead, Cost per customer, Digital marketing, Cost per click, cost per conversion, Click through rate, Conversion rate
• Developed Spotfire HR reporting like headcount Summary, New hire count, active employees and separates, Bad hire count by age and gender, compliance, and Training
• Customize and enhance Spotfire functionality using Document properties, script action control, Iron Python, HTML, and JS

Data Science:

• Involved directly in creating predictive analytics to identify customer purchase patterns using machine learning and Data Science approaches
• Identified customer purchase patterns and created a customer segmentation model, to identify high risk to potential customers for Targeting and Retargeting
• Built a recommendation engine to identify products to cross-sell a customer by applying Machine Learning and Data Science techniques to the customer purchase history and helped the business in improving sales
• Implemented marketing strategies which resulted in 12% growth of customer base

Manage Data Platform:

• Managed and optimized overall Enterprise Data platform, which comprises of ETL, Data Warehousing, Data lake, EMR Hadoop, AWS Redshift and Spotfire BI reporting
• Deployed EMR Hadoop, BIG DATA environment and build Data Lake product for Enhanced data storage and Business Analytics
• Deployed Data Science Platform comprises of Tibco Statistica, TERR, R for Enterprise Data Science Rollouts
• Supported Data Governance and Integration activities by rolling out Tibco Master Data Management(MDM)
• Performed Tibco Spotfire integration with Informatica data virtualization
• Integrate Spotfire with enterprise applications like SAP HANA, SAP BW, AWS Redshift, Oracle, SQL Server, and SharePoint, etc
• Perform admin activities for Spotfire server upgrades, applying hotfixes, manage access provisioning to business users, library migration
• Skills: Tibco Spotfire, AWS Redshift, AWS EMR Hadoop, AWS S3, Oracle, Big Data,Data lake SAP BW, Data Warehousing, Windows, JavaScript, Python, R, HTML, SQL, MS Excel

• Conducted interviews with key business users to collect information on business processes and user requirements
• Performed Data Mining to Collect, Cleanse and provide Digital Marketing analytics from structured and unstructured data for business-critical initiatives
• Performed Linear regression and Data mining techniques to predict the product demand by using statistical equations
• Created visually rich and impactful dashboards in Tibco Spotfire for data reporting. As a result, the business was able to identify the overage software license costs and saved 18% of the operating expenses
• Designed and built Ad tech reports with operational metrics like click-through rate(CTR) and conversion rate (CR) to monitor web campaigns
• Designed and developed product placement reports on for Web Analytics. As a result, helped to identify the products to show on the e-commerce website to improve revenue
• Designed and developed demand forecasting models with time-series and regression model, by analyzing 15 million records of historical data
• Developed a Spotfire dashboard to provide insights into revenue generated, costs incurred, future licensing potential and ROI analyses across different Business units and drivable to product lines

• Key responsibilities include; Understanding the business requirements and checking the data requirements for reporting
• Involved in JAD sessions with the Data Modeler to come up with the effective Data Model for Reporting as per the Client Standards
• Performed Quantitative analysis in developing a production plan by assessing the costs, timing, and location
• A discounted cash flow model has been developed for the accounting team for better estimation of the investment.
• Working with the ETL Team, and provided the source XML information
• Created Custom Information links by using Complex SQL queries
• Worked on Transformations of data like pivot, Calculate and Replace, Exclude column features while loading data into Tibco Spotfire
• Developed Visualizations like Bar Chart, Pie Chart, Cross table, Table, Map Chart, Scatter Plot, TreeMap, Box Plot and saved the Analysis file in the library
• Enhanced the visualizations by using Custom Expression, Colors, Formatting Features of Spotfire
• Experience in Installing and Configuring Tibco Spotfire Server and Spotfire Web Player Server
• Configured LDAP Authentication to the Spotfire application
• Experienced in Migrating the code from one environment to another environment by using the Import-export features of Library Administration
• Skills: BusinessObjects, Tibco Spotfire3.3.1.32/4.0.2, Oracle 11g R2, Linux 2.6.18, Oracle 11g R2, Tibco I-Process 11.1 (BPM)

• Worked closely with Business Users, involved in discussing and gathering the analytic requirements from different user groups.
• Created complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed and implemented custom business intelligence solutions Dashboards/Reports using the BI Applications Analytics platform.
• Configured charts, pivot table views, gauge views and filters in user interface.
• Managed security privileges for each subject area and dashboards.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Used Informatica for data extraction, mapping and conversion using Informatica Power Center.
• Created mappings using different Transformations like Source Qualifier, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store the data in target table.
• Performed installation and configuration of OBIEE 10.1.3.4.2/11.1.1.5, Informatica 8.6.1 and DAC 10.1.3.4.1.

Environment: Oracle Applications 11i/R12, BI Apps 7.9.6, OBIEE 10.1.3.4.2/11.1.1.5, SQL, SQL PLUS, TOAD, Informatica Power Center 8.6.1, DAC 10.1.3.4.1, Java, Linux, Windows 2000/XP

• Some of the activities/responsibilities include:
• Duties involve defining project scope, detailed planning, tracking, change control tracking, and change control & risk management
• Prepare BIAPPS configuration files for PeopleSoft
• Developed a better project plan by estimating resource availability through quantitative approaches.
• Extensively used the Power Center client tools Designer, Workflow Manager, and Workflow Monitor
• Worked with different environment and sources to build a data warehouse
• Involved in analyzing the business process and finding out the Business requirements
• Designing the source to target mappings that contain the Business rules and data cleansing during the extract, transform and load process
• Configured common areas and dimensions, Financial Analytics functional area
• To Configure Data warehouse Administration Console DAC, Monitor and Schedule ETL routines of Full and Incremental ETL loads on the Oracle Business Analytics Warehouse
• Validate ETL errors due to data gaps in the source system or customizations in the source system
• Environment: OBI APPS 7.9.6.2, DAC 10.1.3.4.1, Informatica Power Center8.6.1, PeopleSoft 8.9, Linux 2.6.18, Oracle 10.2.0.3.0

• Project: BDW End state Loan Application-Applicant, Involved in metadata documents and document rules around ETL error checks and validation
• Involved in analyzing the business process and finding out the Business requirements
• Owned updating metadata for subject areas once in production and updated in a centralized repository
• Participated in meetings with Product Owner to ensure Design meets business needs ensures proper data access
• Interview source and business SMEs to understand how the data is created/captured

• Extensively used the Power Center client tools Designer, Workflow Manager, and Workflow Monitor for Data Integration
• Involved in analyzing the business process and finding out the Business requirements
• Designing the source to target mappings that contain the Business rules and data cleansing during the extract, transform and load process
• Extensively worked on various complex Mappings by using various Active & Passive transformation like Filter, Sorter, Joiner, Aggregator, Router, Lookup, Sequence Generator, Rank, source qualifier, expression, Mapplet Input, and Mapplet Output transformations

• Involved in the Design, Development, Testing phases of the Data warehouse and in Software Development Life Cycle (SDLC)
• Analysis, Requirements gathering, function/technical specification, development, deploying and testing
• Extensively used Transformations like Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy etc
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information